summaryrefslogtreecommitdiff
path: root/maintenance/oracle/patch_seq_names_pre1.16.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/oracle/patch_seq_names_pre1.16.sql')
-rw-r--r--maintenance/oracle/patch_seq_names_pre1.16.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/oracle/patch_seq_names_pre1.16.sql b/maintenance/oracle/patch_seq_names_pre1.16.sql
new file mode 100644
index 00000000..5346b141
--- /dev/null
+++ b/maintenance/oracle/patch_seq_names_pre1.16.sql
@@ -0,0 +1,8 @@
+-- script for renameing sequence names to conform with <table>_<field>_seq format
+RENAME rev_rev_id_val TO revision_rev_id_seq;
+RENAME text_old_id_val TO text_old_id_seq;
+RENAME category_id_seq TO category_cat_id_seq;
+RENAME ipblocks_ipb_id_val TO ipblocks_ipb_id_seq;
+RENAME rc_rc_id_seq TO recentchanges_rc_id_seq;
+RENAME log_log_id_seq TO logging_log_id_seq;
+RENAME pr_id_val TO page_restrictions_pr_id_seq; \ No newline at end of file