Commit | Line | Data |
---|---|---|
b8de879d RB |
1 | ALTER TABLE group_auth |
2 | ADD COLUMN group_id SMALLINT(5) UNSIGNED NULL DEFAULT NULL; | |
3 | ALTER TABLE group_auth | |
4 | ADD INDEX (group_id); | |
5 | ALTER TABLE group_auth | |
6 | ADD FOREIGN KEY (group_id) REFERENCES groups (id) ON UPDATE CASCADE ON DELETE CASCADE; | |
7 | ||
8 | ALTER TABLE group_auth | |
bd83728a RB |
9 | ADD COLUMN flags SET('allow_xnet', 'group_only') DEFAULT ''; |
10 | ||
11 | UPDATE group_auth SET flags = 'allow_xnet' WHERE name = 'Polytechnique.net'; |