summaryrefslogtreecommitdiff
path: root/sql/legacy/Pg-upgrade-1.8.0-1.8.4.sql
blob: 57b24f1f35df649e874814b693810032f1727cd1 (plain)
  1. --
  2. alter table chart add column gifi_accno text;
  3. --
  4. create table gifi (accno text, description text);
  5. create unique index gifi_accno_key on gifi (accno);
  6. --
  7. create table mtemp (parts_id int, name text);
  8. insert into mtemp select parts_id, name from makemodel;
  9. drop table makemodel;
  10. alter table mtemp rename to makemodel;
  11. --
  12. alter table defaults add column closedto date;
  13. alter table defaults add column revtrans bool;
  14. --
  15. alter table ap add column notes text;
  16. --
  17. alter table customer add column businessnumber text;
  18. alter table vendor add column businessnumber text;
  19. --
  20. update defaults set version = '1.8.4', revtrans = 'f';
  21. --