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