summaryrefslogtreecommitdiff
path: root/SQL
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2010-04-15 07:54:44 +0000
committeralecpl <alec@alec.pl>2010-04-15 07:54:44 +0000
commit8a79f224c28a10fc2edc5a1ab1ebc608058bda34 (patch)
treedafbb22c1a892977d09d81af68a0cfbd74db3aad /SQL
parent2491c6240cad60e68916a79c7a0689bedc2cefd9 (diff)
- Fix: postgres doens't support AFTER clause
Diffstat (limited to 'SQL')
-rw-r--r--SQL/postgres.update.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql
index dc22b9030..762f5fbc7 100644
--- a/SQL/postgres.update.sql
+++ b/SQL/postgres.update.sql
@@ -49,7 +49,7 @@ CREATE INDEX contacts_user_id_idx ON contacts (user_id, email);
DROP INDEX identities_user_id_idx;
CREATE INDEX identities_user_id_idx ON identities (user_id, del);
-ALTER TABLE identities ADD changed timestamp with time zone DEFAULT now() NOT NULL AFTER user_id;
+ALTER TABLE identities ADD changed timestamp with time zone DEFAULT now() NOT NULL;
CREATE SEQUENCE contactgroups_ids
INCREMENT BY 1