summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/mysql/patch/profiles.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/profiles.sql')
-rw-r--r--upgrades/dbpatches/1.3/mysql/patch/profiles.sql27
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;