1
0
mirror of https://github.com/wbbaddons/Tims-Chat.git synced 2024-11-19 17:00:08 +00:00
Tims-Chat/sql/0021-chat1_room-Temporary.sql
2018-08-17 00:30:59 +02:00

5 lines
227 B
SQL

ALTER TABLE chat1_room ADD isTemporary TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE chat1_room ADD ownerID INT(10) DEFAULT NULL;
ALTER TABLE chat1_room ADD FOREIGN KEY (ownerID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;