[platal.git] / upgrade / 1.1.3 / 05_authgroupex.sql

ALTER TABLE group_auth
ADD COLUMN group_id SMALLINT(5) UNSIGNED NULL DEFAULT NULL;
ALTER TABLE group_auth
ADD INDEX (group_id);
ALTER TABLE group_auth
ADD FOREIGN KEY (group_id) REFERENCES groups (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE group_auth
ADD COLUMN flags SET('allow_xnet', 'group_only') DEFAULT '';

UPDATE group_auth SET flags = 'allow_xnet' WHERE name = 'Polytechnique.net';
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';