From 13e7d428b192698586f2ddb2dc274df03c10cf46 Mon Sep 17 00:00:00 2001 From: "Mark A. Hershberger" Date: Sat, 5 Feb 2011 22:20:09 +0000 Subject: [PATCH] followup r13884 add CASCADE so that if the tables are created a second time, errors aren't given. --- maintenance/postgres/tables.sql | 28 ++++++++++++++-------------- 1 file changed, 14 insertions(+), 14 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 5edb030562..f1e7e93365 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -9,20 +9,20 @@ BEGIN; SET client_min_messages = 'ERROR'; -DROP SEQUENCE IF EXISTS user_user_id_seq; -DROP SEQUENCE IF EXISTS page_page_id_seq; -DROP SEQUENCE IF EXISTS revision_rev_id_seq; -DROP SEQUENCE IF EXISTS page_restrictions_id_seq; -DROP SEQUENCE IF EXISTS ipblocks_ipb_id_seq; -DROP SEQUENCE IF EXISTS recentchanges_rc_id_seq; -DROP SEQUENCE IF EXISTS logging_log_id_seq; -DROP SEQUENCE IF EXISTS trackbacks_tb_id_seq; -DROP SEQUENCE IF EXISTS job_job_id_seq; -DROP SEQUENCE IF EXISTS category_cat_id_seq; -DROP FUNCTION IF EXISTS page_deleted(); -DROP FUNCTION IF EXISTS ts2_page_title(); -DROP FUNCTION IF EXISTS ts2_page_text(); -DROP FUNCTION IF EXISTS add_interwiki(TEXT,INT,SMALLINT); +DROP SEQUENCE IF EXISTS user_user_id_seq CASCADE; +DROP SEQUENCE IF EXISTS page_page_id_seq CASCADE; +DROP SEQUENCE IF EXISTS revision_rev_id_seq CASCADE; +DROP SEQUENCE IF EXISTS page_restrictions_id_seq CASCADE; +DROP SEQUENCE IF EXISTS ipblocks_ipb_id_seq CASCADE; +DROP SEQUENCE IF EXISTS recentchanges_rc_id_seq CASCADE; +DROP SEQUENCE IF EXISTS logging_log_id_seq CASCADE; +DROP SEQUENCE IF EXISTS trackbacks_tb_id_seq CASCADE; +DROP SEQUENCE IF EXISTS job_job_id_seq CASCADE; +DROP SEQUENCE IF EXISTS category_cat_id_seq CASCADE; +DROP FUNCTION IF EXISTS page_deleted() CASCADE; +DROP FUNCTION IF EXISTS ts2_page_title() CASCADE; +DROP FUNCTION IF EXISTS ts2_page_text() CASCADE; +DROP FUNCTION IF EXISTS add_interwiki(TEXT,INT,SMALLINT) CASCADE; CREATE SEQUENCE user_user_id_seq MINVALUE 0 START WITH 0; CREATE TABLE mwuser ( -- replace reserved word 'user' -- 2.20.1