pgsql/x-dragon-expense.sql

diff --git a/pgsql/x-dragon-expense.sql b/pgsql/x-dragon-expense.sql
deleted file mode 100644 (file)
index 559cc56..0000000
--- a/pgsql/x-dragon-expense.sql
+++ /dev/null
@@ -1,131 +0,0 @@
-
-CREATE SEQUENCE expense_id_seq
-  INCREMENT 1
-  MINVALUE 1
-  MAXVALUE 2147483647
-  START 1
-  CACHE 1;
-ALTER TABLE expense_id_seq
-  OWNER TO admin;
-GRANT ALL ON TABLE expense_id_seq TO admin;
-GRANT ALL ON TABLE expense_id_seq TO xtrole;
-
-
-CREATE SEQUENCE expitem_id_seq
-  INCREMENT 1
-  MINVALUE 1
-  MAXVALUE 2147483647
-  START 1
-  CACHE 1;
-ALTER TABLE expitem_id_seq
-  OWNER TO admin;
-GRANT ALL ON TABLE expitem_id_seq TO admin;
-GRANT ALL ON TABLE expitem_id_seq TO xtrole;
-
-
-
-CREATE TABLE expense
-(
-    expense_id INTEGER NOT NULL DEFAULT nextval(('expense_id_seq'::text)::regclass),
-    
-    
-    expense_accnt_id INTEGER DEFAULT NULL,
-    expense_emp_id INTEGER NOT NULL,
-    
-    expense_number TEXT NOT NULL,
-    
-    expense_trandate date DEFAULT NULL,
-    expense_created date DEFAULT NULL,
-    expense_modified  date DEFAULT NULL,
-    expense_duedate date DEFAULT NULL,
-    
-    expense_memo  TEXT,
-    expense_comments  TEXT,
-    expense_status TEXT,
-    
-    expense_advance decimal(12,3) DEFAULT '0.000',
-    expense_amount decimal(12,3) DEFAULT '0.000',
-    
-    expense_tax decimal(12,3) DEFAULT '0.000',
-    expense_total decimal(12,3) DEFAULT '0.000',
-    expense_posted boolean default false,
-     
-    CONSTRAINT expense_accnt_id_fkey FOREIGN KEY (expense_accnt_id)
-        REFERENCES accnt (accnt_id)  MATCH SIMPLE,
-    CONSTRAINT expense_emp_id_fkey FOREIGN KEY (expense_emp_id)
-        REFERENCES emp (emp_id),
-    CONSTRAINT expense_id_pkey PRIMARY KEY (expense_id)
-)
-WITH (
-  OIDS=FALSE
-);
-
-ALTER TABLE expense
-  OWNER TO admin;
-  
-GRANT ALL ON TABLE expense TO admin;
-GRANT ALL ON TABLE expense TO xtrole;
-COMMENT ON TABLE expense
-  IS 'Expense Reports';
- 
- CREATE INDEX expense_number_ix  ON expense USING btree  (expense_number);
- CREATE INDEX expense_date_ix  ON expense USING btree  (expense_trandate,expense_created, expense_modified, expense_duedate );
-
-
- 
- 
-CREATE TABLE expitem
-(
-  expitem_id INTEGER NOT NULL DEFAULT nextval(('expitem_id_seq'::text)::regclass),
-  
-  expitem_expense_id INTEGER NOT NULL,
-  expitem_curr_id INTEGER NOT NULL,
-  expitem_expcat_id INTEGER NOT NULL,
-
-  
-  expitem_row INTEGER NOT NULL,
-  
-  
-  expitem_amount decimal(12,3) DEFAULT '0.000',
-  expitem_amount_fc decimal(12,3) DEFAULT '0.000',
-  expitem_tax decimal(12,3) DEFAULT '0.000',
-  expitem_total decimal(12,3) DEFAULT '0.000',
-  --grossAmt decimal(12,3) DEFAULT '0.000',
-  -- expense cat?
-  
-  expitem_date date DEFAULT NULL,
-  --exchangeRate decimal(12,5) DEFAULT NULL,
-  
-  
-  expitem_is_billable INTEGER DEFAULT 0,
-  
-  expitem_memo text DEFAULT '',
-  
-  
-  -- tax code ???  
-  --receipt int(4) DEFAULT '0',
-    CONSTRAINT expitem_expense_id_fkey FOREIGN KEY (expitem_expense_id)
-        REFERENCES expense (expense_id),
-    
-    CONSTRAINT expitem_curr_id_fkey FOREIGN KEY (expitem_curr_id)
-        REFERENCES curr_symbol (curr_id),
-    
-    CONSTRAINT expitem_expcat_id_fkey FOREIGN KEY (expitem_expcat_id)
-        REFERENCES expcat (expcat_id),
-    
-    -- unique row / expid....
-        
-    CONSTRAINT expitem_id_pkey PRIMARY KEY (expitem_id)
-)
-WITH (
-  OIDS=FALSE
-);
-
-ALTER TABLE expitem
-  OWNER TO admin;
-  
-GRANT ALL ON TABLE expitem TO admin;
-GRANT ALL ON TABLE expitem TO xtrole;
-COMMENT ON TABLE expitem
-  IS 'Expense Report Items';
-