diff options
| author | alecpl <alec@alec.pl> | 2010-04-15 07:54:44 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2010-04-15 07:54:44 +0000 |
| commit | 8a79f224c28a10fc2edc5a1ab1ebc608058bda34 (patch) | |
| tree | dafbb22c1a892977d09d81af68a0cfbd74db3aad | |
| parent | 2491c6240cad60e68916a79c7a0689bedc2cefd9 (diff) | |
- Fix: postgres doens't support AFTER clause
| -rw-r--r-- | SQL/postgres.update.sql | 2 |
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 |