kivitendo/sql/Pg-upgrade/Pg-upgrade-2.2.0.15-2.2.0.16.sql @ fdb14a85
| 54e4131e | Moritz Bunkus | CREATE TABLE "adr" (
|
||
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
||||
"adr_description" text,
|
||||
"adr_code" text NOT NULL
|
||||
);
|
||||
ALTER TABLE parts add column adr_id integer;
|
||||
| 2071984a | Holger Lindemann | alter table shipto add column shipto_id integer;
|
||
alter table shipto alter column shipto_id set default nextval('id'::text);
|
||||
update shipto set shipto_id=nextval('id'::text);
|
||||
| 54e4131e | Moritz Bunkus | |||
alter table oe add column shipto_id integer;
|
||||
| 2071984a | Holger Lindemann | alter table ar add column shipto_id integer;
|