summaryrefslogtreecommitdiff
path: root/sql/Pg-upgrade-2.3.5-2.3.6.sql
blob: 3eac490fd4af9370d7ba445249bc158dfccddb05 (plain)
  1. --
  2. create table pricegroup (id int default nextval('id'), pricegroup text);
  3. create index pricegroup_pricegroup_key on pricegroup (pricegroup);
  4. create index pricegroup_id_key on pricegroup (id);
  5. --
  6. create table partscustomer (parts_id int, customer_id int, pricegroup_id int, pricebreak float4, sellprice float, validfrom date, validto date);
  7. --
  8. create table language (code varchar(6), description text);
  9. alter table customer add language_code varchar(6);
  10. alter table customer add pricegroup_id int;
  11. --
  12. alter table vendor add language_code varchar(6);
  13. alter table vendor add pricegroup_id int;
  14. --
  15. update defaults set version = '2.3.6';