summaryrefslogtreecommitdiff
path: root/sql/legacy/Pg-upgrade-2.3.1-2.3.3.sql
blob: 9ee09915a09a131743010d8d19f9d9e9db1cff48 (plain)
  1. --
  2. create table partsvendor (vendor_id int, parts_id int, partnumber text, leadtime int2, lastcost float, curr char(3));
  3. create index partsvendor_vendor_id_key on partsvendor (vendor_id);
  4. create index partsvendor_parts_id_key on partsvendor (parts_id);
  5. --
  6. alter table assembly add column adj bool;
  7. update assembly set adj = 't';
  8. --
  9. update defaults set version = '2.3.3';