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);
6 create table partscustomer (parts_id int, customer_id int, pricegroup_id int, pricebreak float4, sellprice float, validfrom date, validto date);
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;
12 alter table vendor add language_code varchar(6);
13 alter table vendor add pricegroup_id int;
15 update defaults set version = '2.3.6';