diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/users_groups.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/users_groups.sql | 23 |
1 files changed, 0 insertions, 23 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/users_groups.sql b/upgrades/dbpatches/1.3/mysql/patch/users_groups.sql deleted file mode 100644 index 1b45595b..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/users_groups.sql +++ /dev/null @@ -1,23 +0,0 @@ -CREATE TABLE users_groups_tmp ( - id bigint unsigned NOT NULL auto_increment, - usrgrpid bigint unsigned DEFAULT '0' NOT NULL, - userid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -) ENGINE=InnoDB; -CREATE INDEX users_groups_1 on users_groups_tmp (usrgrpid,userid); - -insert into users_groups_tmp select NULL,usrgrpid,userid from users_groups; -drop table users_groups; -alter table users_groups_tmp rename users_groups; - -CREATE TABLE users_groups_tmp ( - id bigint unsigned DEFAULT '0' NOT NULL, - usrgrpid bigint unsigned DEFAULT '0' NOT NULL, - userid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -) ENGINE=InnoDB; -CREATE INDEX users_groups_1 on users_groups_tmp (usrgrpid,userid); - -insert into users_groups_tmp select * from users_groups; -drop table users_groups; -alter table users_groups_tmp rename users_groups; |