Tims-Chat/sql/0021-chat1_room-Temporary.sql

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

5 lines
227 B
MySQL
Raw Permalink Normal View History

2018-08-16 22:30:59 +00:00
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;