| Index: trunk/phase3/maintenance/postgres/archives/patch-update_sequences.sql |
| — | — | @@ -1,20 +1,20 @@ |
| 2 | | -ALTER SEQUENCE rev_rev_id_val RENAME TO revision_rev_id_seq; |
| | 2 | +ALTER TABLE revision RENAME rev_rev_id_val TO revision_rev_id_seq; |
| 3 | 3 | ALTER TABLE revision ALTER COLUMN rev_id SET DEFAULT NEXTVAL('revision_rev_id_seq'); |
| 4 | 4 | |
| 5 | | -ALTER SEQUENCE text_old_id_val RENAME TO text_old_id_seq; |
| | 5 | +ALTER TABLE pagecontent RENAME text_old_id_val TO text_old_id_seq; |
| 6 | 6 | ALTER TABLE pagecontent ALTER COLUMN old_id SET DEFAULT nextval('text_old_id_seq'); |
| 7 | 7 | |
| 8 | | -ALTER SEQUENCE category_id_seq RENAME TO category_cat_id_seq; |
| | 8 | +ALTER TABLE category RENAME category_id_seq TO category_cat_id_seq; |
| 9 | 9 | ALTER TABLE category ALTER COLUMN cat_id SET DEFAULT nextval('category_cat_id_seq'); |
| 10 | 10 | |
| 11 | | -ALTER SEQUENCE ipblocks_ipb_id_val RENAME TO ipblocks_ipb_id_seq; |
| | 11 | +ALTER TABLE ipblocks RENAME ipblocks_ipb_id_val TO ipblocks_ipb_id_seq; |
| 12 | 12 | ALTER TABLE ipblocks ALTER COLUMN ipb_id SET DEFAULT nextval('ipblocks_ipb_id_seq'); |
| 13 | 13 | |
| 14 | | -ALTER SEQUENCE rc_rc_id_seq RENAME TO recentchanges_rc_id_seq; |
| | 14 | +ALTER TABLE recentchanges RENAME rc_rc_id_seq TO recentchanges_rc_id_seq; |
| 15 | 15 | ALTER TABLE recentchanges ALTER COLUMN rc_id SET DEFAULT nextval('recentchanges_rc_id_seq'); |
| 16 | 16 | |
| 17 | | -ALTER SEQUENCE log_log_id_seq RENAME TO logging_log_id_seq; |
| | 17 | +ALTER TABLE logging RENAME log_log_id_seq TO logging_log_id_seq; |
| 18 | 18 | ALTER TABLE logging ALTER COLUMN log_id SET DEFAULT nextval('logging_log_id_seq'); |
| 19 | 19 | |
| 20 | | -ALTER SEQUENCE pr_id_val RENAME TO page_restrictions_pr_id_seq; |
| | 20 | +ALTER TABLE page_restrictions RENAME pr_id_val TO page_restrictions_pr_id_seq; |
| 21 | 21 | ALTER TABLE page_restrictions ALTER COLUMN pr_id SET DEFAULT nextval('page_restrictions_pr_id_seq'); |