| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -9,20 +9,20 @@ |
| 10 | 10 | BEGIN; |
| 11 | 11 | SET client_min_messages = 'ERROR'; |
| 12 | 12 | |
| 13 | | -DROP SEQUENCE IF EXISTS user_user_id_seq; |
| 14 | | -DROP SEQUENCE IF EXISTS page_page_id_seq; |
| 15 | | -DROP SEQUENCE IF EXISTS revision_rev_id_seq; |
| 16 | | -DROP SEQUENCE IF EXISTS page_restrictions_id_seq; |
| 17 | | -DROP SEQUENCE IF EXISTS ipblocks_ipb_id_seq; |
| 18 | | -DROP SEQUENCE IF EXISTS recentchanges_rc_id_seq; |
| 19 | | -DROP SEQUENCE IF EXISTS logging_log_id_seq; |
| 20 | | -DROP SEQUENCE IF EXISTS trackbacks_tb_id_seq; |
| 21 | | -DROP SEQUENCE IF EXISTS job_job_id_seq; |
| 22 | | -DROP SEQUENCE IF EXISTS category_cat_id_seq; |
| 23 | | -DROP FUNCTION IF EXISTS page_deleted(); |
| 24 | | -DROP FUNCTION IF EXISTS ts2_page_title(); |
| 25 | | -DROP FUNCTION IF EXISTS ts2_page_text(); |
| 26 | | -DROP FUNCTION IF EXISTS add_interwiki(TEXT,INT,SMALLINT); |
| | 13 | +DROP SEQUENCE IF EXISTS user_user_id_seq CASCADE; |
| | 14 | +DROP SEQUENCE IF EXISTS page_page_id_seq CASCADE; |
| | 15 | +DROP SEQUENCE IF EXISTS revision_rev_id_seq CASCADE; |
| | 16 | +DROP SEQUENCE IF EXISTS page_restrictions_id_seq CASCADE; |
| | 17 | +DROP SEQUENCE IF EXISTS ipblocks_ipb_id_seq CASCADE; |
| | 18 | +DROP SEQUENCE IF EXISTS recentchanges_rc_id_seq CASCADE; |
| | 19 | +DROP SEQUENCE IF EXISTS logging_log_id_seq CASCADE; |
| | 20 | +DROP SEQUENCE IF EXISTS trackbacks_tb_id_seq CASCADE; |
| | 21 | +DROP SEQUENCE IF EXISTS job_job_id_seq CASCADE; |
| | 22 | +DROP SEQUENCE IF EXISTS category_cat_id_seq CASCADE; |
| | 23 | +DROP FUNCTION IF EXISTS page_deleted() CASCADE; |
| | 24 | +DROP FUNCTION IF EXISTS ts2_page_title() CASCADE; |
| | 25 | +DROP FUNCTION IF EXISTS ts2_page_text() CASCADE; |
| | 26 | +DROP FUNCTION IF EXISTS add_interwiki(TEXT,INT,SMALLINT) CASCADE; |
| 27 | 27 | |
| 28 | 28 | CREATE SEQUENCE user_user_id_seq MINVALUE 0 START WITH 0; |
| 29 | 29 | CREATE TABLE mwuser ( -- replace reserved word 'user' |