diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/profiles.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/profiles.sql | 27 |
1 files changed, 0 insertions, 27 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/profiles.sql b/upgrades/dbpatches/1.3/mysql/patch/profiles.sql deleted file mode 100644 index ba8e374d..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/profiles.sql +++ /dev/null @@ -1,27 +0,0 @@ -CREATE TABLE profiles_tmp ( - profileid bigint unsigned NOT NULL auto_increment, - userid bigint unsigned DEFAULT '0' NOT NULL, - idx varchar(64) DEFAULT '' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL, - valuetype integer DEFAULT 0 NOT NULL, - PRIMARY KEY (profileid) -) ENGINE=InnoDB; -CREATE UNIQUE INDEX profiles_1 on profiles_tmp (userid,idx); - -insert into profiles_tmp select NULL,userid,idx,value,valuetype from profiles; -drop table profiles; -alter table profiles_tmp rename profiles; - -CREATE TABLE profiles_tmp ( - profileid bigint unsigned DEFAULT '0' NOT NULL, - userid bigint unsigned DEFAULT '0' NOT NULL, - idx varchar(64) DEFAULT '' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL, - valuetype integer DEFAULT 0 NOT NULL, - PRIMARY KEY (profileid) -) ENGINE=InnoDB; -CREATE UNIQUE INDEX profiles_1 on profiles_tmp (userid,idx); - -insert into profiles_tmp select * from profiles; -drop table profiles; -alter table profiles_tmp rename profiles; |