From 305622fbc95a50fdb83cb9a4dda8c27f61710ede Mon Sep 17 00:00:00 2001 From: umherirrender Date: Mon, 27 Jan 2014 20:38:59 +0100 Subject: [PATCH] Correct sequence name for fresh Postgres installation Spotted by gebhkla on bug 60083 Bug: 60083 Change-Id: I34283c2539f4ce9d1b85756b3e1c16d255000ed5 --- maintenance/postgres/tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 3940ba2a6c..93e931c918 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -229,9 +229,9 @@ CREATE TABLE categorylinks ( CREATE UNIQUE INDEX cl_from ON categorylinks (cl_from, cl_to); CREATE INDEX cl_sortkey ON categorylinks (cl_to, cl_sortkey, cl_from); -CREATE SEQUENCE externallinks_id_seq; +CREATE SEQUENCE externallinks_el_id_seq; CREATE TABLE externallinks ( - el_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('externallinks_id_seq'), + el_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('externallinks_el_id_seq'), el_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, el_to TEXT NOT NULL, el_index TEXT NOT NULL -- 2.20.1