|
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;
|
|
|
|
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);
|
|
|
|
alter table oe add column shipto_id integer;
|
|
alter table ar add column shipto_id integer;
|