diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/history_text.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/history_text.sql | 12 |
1 files changed, 0 insertions, 12 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_text.sql b/upgrades/dbpatches/1.3/mysql/patch/history_text.sql deleted file mode 100644 index f67efcae..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/history_text.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE TABLE history_text_tmp ( - id bigint unsigned DEFAULT '0' NOT NULL, - itemid bigint unsigned DEFAULT '0' NOT NULL, - clock integer DEFAULT '0' NOT NULL, - value text DEFAULT '' NOT NULL, - PRIMARY KEY (id) -) ENGINE=InnoDB; -CREATE INDEX history_text_1 on history_text_tmp (itemid,clock); - -insert into history_text_tmp select * from history_text; -drop table history_text; -alter table history_text_tmp rename history_text; |