upgrade/1.1.3/05_authgroupex.sql

   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
   9 ADD COLUMN flags SET('allow_xnet', 'group_only') DEFAULT '';
  10
  11 UPDATE group_auth SET flags = 'allow_xnet' WHERE name = 'Polytechnique.net';