pgsql/invadj.sql

diff --git a/pgsql/invadj.sql b/pgsql/invadj.sql
index 38df318..d9da573 100644 (file)
--- 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...