Open-ILS/src/sql/Pg/upgrade/0371.schema.serial_supplement-fix.sql

   1 -- If these two fail, they're already renamed (DB built after 0352), so
   2 -- we're good.
   3 ALTER SEQUENCE serial.sup_summary_id_seq RENAME TO supplement_summary_id_seq;
   4 ALTER SEQUENCE serial.bib_summary_id_seq RENAME TO basic_summary_id_seq;
   5
   6 BEGIN;  -- but we still need to consume an upgrade number :-/
   7
   8 INSERT INTO config.upgrade_log (version) VALUES ('0371');   -- senator
   9
  10 COMMIT;