From 3a86274adfc409657395eec8d0d9984940e928d2 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 25 Feb 2015 18:09:22 +0800 Subject: [PATCH] pgsql/invadj.sql --- pgsql/invadj.sql | 68 +----------------------------------------------- 1 file changed, 1 insertion(+), 67 deletions(-) diff --git a/pgsql/invadj.sql b/pgsql/invadj.sql index 38df3184..d9da5738 100644 --- a/pgsql/invadj.sql +++ b/pgsql/invadj.sql @@ -1,70 +1,4 @@ --- Sequence: accnt_accnt_id_seq - ---DROP table invadj; - - -CREATE SEQUENCE invadj_id_seq - INCREMENT 1 - MINVALUE 1 - MAXVALUE 2147483647 - START 1 - CACHE 1; -ALTER TABLE invadj_id_seq - OWNER TO admin; -GRANT ALL ON TABLE invadj_id_seq TO admin; -GRANT ALL ON TABLE invadj_id_seq TO xtrole; - - -CREATE TABLE invadj -( - invadj_id integer NOT NULL DEFAULT nextval(('invadj_id_seq'::text)::regclass), - invadj_transdate date, - invadj_location_id integer, - invadj_itemsite_id integer, - invadj_qty_by integer, - invadj_posted boolean, - - CONSTRAINT invadj_pkey PRIMARY KEY (invadj_id ), - CONSTRAINT invadj_location_fkey FOREIGN KEY (invadj_location_id) - REFERENCES location (location_id) - ON UPDATE CASCADE ON DELETE NO ACTION, - - CONSTRAINT invadj_itemsite_fkey FOREIGN KEY (invadj_itemsite_id) - REFERENCES itemsite (itemsite_id) - ON UPDATE CASCADE ON DELETE NO ACTION -) -WITH ( - OIDS=FALSE -); - -ALTER TABLE invadj ADD COLUMN invadj_comments text; -ALTER TABLE invadj ADD COLUMN invadj_voids_id INTEGER NOT NULL DEFAULT 0; -ALTER TABLE invadj ADD COLUMN invadj_invdetail_id INTEGER; -ALTER TABLE invadj ADD COLUMN invadj_voided_by_id INTEGER NOT NULL DEFAULT 0; -ALTER TABLE invadj ADD COLUMN invadj_invadjgrp_id INTEGER DEFAULT NULL; - - -CREATE INDEX invadj_location_id_ix ON invadj USING btree (invadj_location_id); -CREATE INDEX invadj_transdate_ix ON invadj USING btree (invadj_transdate); -CREATE INDEX invadj_itemsite_ix ON invadj USING btree (invadj_itemsite_id); -CREATE INDEX invadj_posted_ix ON invadj USING btree (invadj_posted); - -CREATE INDEX invadj_voided_by_id_ix ON invadj USING btree (invadj_voided_by_id); -CREATE INDEX invadj_invdetail_id_ix ON invadj USING btree (invadj_invdetail_id); -CREATE INDEX invadj_voids_id_ix ON invadj USING btree (invadj_voids_id); - -CREATE INDEX invadj_invadjgrp_id_ix ON invadj USING btree (invadj_invadjgrp_id); - - - -ALTER TABLE invadj - OWNER TO admin; -GRANT ALL ON TABLE invadj TO admin; -GRANT ALL ON TABLE invadj TO xtrole; -COMMENT ON TABLE invadj - IS 'Inventory Adjustment Draft'; - - +-- invadj routines ... -- split into seperate files... -- 2.39.2