|
--
alter table customer rename column businessnumber to customernumber;
create index customer_customernumber_key on customer (customernumber);
alter table vendor rename column businessnumber to vendornumber;
create index vendor_vendornumber_key on vendor (vendornumber);
--
CREATE TABLE employee (
id int DEFAULT nextval ('id'),
login text,
name varchar(35),
addr1 varchar(35),
addr2 varchar(35),
addr3 varchar(35),
addr4 varchar(35),
workphone varchar(20),
homephone varchar(20),
startdate date default current_date,
enddate date,
notes text
);
--
create index employee_id_key on employee (id</ |
