summaryrefslogtreecommitdiff
path: root/sql/Pg-upgrade-2.6.2-2.6.3.sql
blob: 2abfe62735a391529e1ff6197c7b0507901fb621 (plain)
  1. --
  2. delete from status where formname = 'receipt';
  3. delete from status where formname = 'check';
  4. create table statu (trans_id int, formname text, printed bool default 'f', emailed bool default 'f', spoolfile text);
  5. insert into statu select trans_id, formname, printed, emailed, spoolfile from status;
  6. drop table status;
  7. alter table statu rename to status;
  8. create index status_trans_id_key on status (trans_id);
  9. --
  10. update defaults set version = '2.6.3';