1 files changed, 12 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/history_text.sql b/upgrades/dbpatches/1.4/postgresql/patch/history_text.sql
new file mode 100644
index 00000000..501e5090
--- /dev/null
+++ b/upgrades/dbpatches/1.4/postgresql/patch/history_text.sql
@@ -0,0 +1,12 @@
+CREATE TABLE history_text_tmp (
+	id		bigint DEFAULT '0'	NOT NULL,
+	itemid		bigint DEFAULT '0'	NOT NULL,
+	clock		integer		DEFAULT '0'	NOT NULL,
+	value		text		DEFAULT ''	NOT NULL,
+	PRIMARY KEY (id)
+);
+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 to history_text;