diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/acknowledges.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/acknowledges.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/acknowledges.sql b/upgrades/dbpatches/1.3/postgresql/patch/acknowledges.sql deleted file mode 100644 index 7846291f..00000000 --- a/upgrades/dbpatches/1.3/postgresql/patch/acknowledges.sql +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE acknowledges_tmp ( - acknowledgeid bigint DEFAULT '0' NOT NULL, - userid bigint DEFAULT '0' NOT NULL, - eventid bigint DEFAULT '0' NOT NULL, - clock integer DEFAULT '0' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (acknowledgeid) -); -CREATE INDEX acknowledges_1 on acknowledges_tmp (userid); -CREATE INDEX acknowledges_2 on acknowledges_tmp (eventid); -CREATE INDEX acknowledges_3 on acknowledges_tmp (clock); - -insert into acknowledges_tmp select * from acknowledges; -drop table acknowledges; -alter table acknowledges_tmp rename to acknowledges; |