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 group_strict BOOL DEFAULT FALSE COMMENT 'Whether to only accept member of the groups';