Tims-Chat/sql/0016-chat1_command_trigger-...

4 lines
219 B
SQL

ALTER TABLE chat1_command_trigger DROP PRIMARY KEY;
ALTER TABLE chat1_command_trigger ADD COLUMN triggerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE chat1_command_trigger ADD UNIQUE KEY (commandTrigger);