| Index: trunk/phase3/maintenance/postgres/archives/patch-update_sequences.sql |
| — | — | @@ -0,0 +1,40 @@ |
| | 2 | +ALTER SEQUENCE rev_rev_id_val RENAME TO revision_rev_id_seq; |
| | 3 | +ALTER TABLE revision ALTER COLUMN rev_id SET DEFAULT NEXTVAL('revision_rev_id_seq'); |
| | 4 | + |
| | 5 | +ALTER SEQUENCE text_old_id_val RENAME TO text_old_id_seq; |
| | 6 | +ALTER TABLE pagecontent ALTER COLUMN old_id SET DEFAULT nextval('text_old_id_seq'); |
| | 7 | + |
| | 8 | +ALTER SEQUENCE category_id_seq RENAME TO category_cat_id_seq; |
| | 9 | +ALTER TABLE category ALTER COLUMN cat_id SET DEFAULT nextval('category_cat_id_seq'); |
| | 10 | + |
| | 11 | +ALTER SEQUENCE ipblocks_ipb_id_val RENAME TO ipblocks_ipb_id_seq; |
| | 12 | +ALTER TABLE ipblocks ALTER COLUMN ipb_id SET DEFAULT nextval('ipblocks_ipb_id_seq'); |
| | 13 | + |
| | 14 | +ALTER SEQUENCE rc_rc_id_seq RENAME TO recentchanges_rc_id_seq; |
| | 15 | +ALTER TABLE recentchanges ALTER COLUMN rc_id SET DEFAULT nextval('recentchanges_rc_id_seq'); |
| | 16 | + |
| | 17 | +ALTER SEQUENCE log_log_id_seq RENAME TO logging_log_id_seq; |
| | 18 | +ALTER TABLE logging ALTER COLUMN log_id SET DEFAULT nextval('logging_log_id_seq'); |
| | 19 | + |
| | 20 | +ALTER SEQUENCE pr_id_val RENAME TO page_restrictions_pr_id_seq; |
| | 21 | +ALTER TABLE page_restrictions ALTER COLUMN pr_id SET DEFAULT nextval('page_restrictions_pr_id_seq'); |
| | 22 | +ALTER SEQUENCE rev_rev_id_val RENAME TO revision_rev_id_seq; |
| | 23 | +ALTER TABLE revision ALTER COLUMN rev_id SET DEFAULT NEXTVAL('revision_rev_id_seq'); |
| | 24 | + |
| | 25 | +ALTER SEQUENCE text_old_id_val RENAME TO text_old_id_seq; |
| | 26 | +ALTER TABLE pagecontent ALTER COLUMN old_id SET DEFAULT nextval('text_old_id_seq'); |
| | 27 | + |
| | 28 | +ALTER SEQUENCE category_id_seq RENAME TO category_cat_id_seq; |
| | 29 | +ALTER TABLE category ALTER COLUMN cat_id SET DEFAULT nextval('category_cat_id_seq'); |
| | 30 | + |
| | 31 | +ALTER SEQUENCE ipblocks_ipb_id_val RENAME TO ipblocks_ipb_id_seq; |
| | 32 | +ALTER TABLE ipblocks ALTER COLUMN ipb_id SET DEFAULT nextval('ipblocks_ipb_id_seq'); |
| | 33 | + |
| | 34 | +ALTER SEQUENCE rc_rc_id_seq RENAME TO recentchanges_rc_id_seq; |
| | 35 | +ALTER TABLE recentchanges ALTER COLUMN rc_id SET DEFAULT nextval('recentchanges_rc_id_seq'); |
| | 36 | + |
| | 37 | +ALTER SEQUENCE log_log_id_seq RENAME TO logging_log_id_seq; |
| | 38 | +ALTER TABLE logging ALTER COLUMN log_id SET DEFAULT nextval('logging_log_id_seq'); |
| | 39 | + |
| | 40 | +ALTER SEQUENCE pr_id_val RENAME TO page_restrictions_pr_id_seq; |
| | 41 | +ALTER TABLE page_restrictions ALTER COLUMN pr_id SET DEFAULT nextval('page_restrictions_pr_id_seq'); |
| Property changes on: trunk/phase3/maintenance/postgres/archives/patch-update_sequences.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 42 | + native |