summaryrefslogtreecommitdiff
path: root/sql/legacy/Pg-upgrade-2.4.2-2.4.3.sql
blob: a3c21f3383afe572870cc212c435a788ddd873f0 (plain)
  1. --
  2. alter table defaults rename invnumber to sinumber;
  3. alter table defaults add vinumber text;
  4. alter table defaults add employeenumber text;
  5. alter table defaults add partnumber text;
  6. alter table defaults add customernumber text;
  7. alter table defaults add vendornumber text;
  8. --
  9. alter table employee add employeenumber varchar(32);
  10. --
  11. alter table customer add startdate date;
  12. alter table customer add enddate date;
  13. --
  14. alter table vendor add startdate date;
  15. alter table vendor add enddate date;
  16. --
  17. update defaults set version = '2.4.3';