diff options
author | ivan <ivan> | 2007-12-04 21:29:13 +0000 |
---|---|---|
committer | ivan <ivan> | 2007-12-04 21:29:13 +0000 |
commit | 86b1b489a4ed2f9bc0cba6cafeab0d6eca5584dc (patch) | |
tree | 4a7a8893f6ad8bd86cf6c22e00cf19d9c70554f2 /sql-ledger/sql/Pg-tables.sql | |
parent | 948b8acdd4b9b3864342062d0c397a11f57c5700 (diff) |
there's no reason this should still be hanging aroudn the tree
Diffstat (limited to 'sql-ledger/sql/Pg-tables.sql')
-rw-r--r-- | sql-ledger/sql/Pg-tables.sql | 471 |
1 files changed, 0 insertions, 471 deletions
diff --git a/sql-ledger/sql/Pg-tables.sql b/sql-ledger/sql/Pg-tables.sql deleted file mode 100644 index 2b7cb92ad..000000000 --- a/sql-ledger/sql/Pg-tables.sql +++ /dev/null @@ -1,471 +0,0 @@ --- -CREATE SEQUENCE id start 10000; -SELECT nextval ('id'); --- -CREATE SEQUENCE invoiceid; -SELECT nextval ('invoiceid'); --- -CREATE SEQUENCE orderitemsid MAXVALUE 100000 CYCLE; -SELECT nextval ('orderitemsid'); --- -CREATE TABLE makemodel ( - parts_id int, - make text, - model text -); --- -CREATE TABLE gl ( - id int DEFAULT nextval ( 'id' ), - reference text, - description text, - transdate date DEFAULT current_date, - employee_id int, - notes text, - department_id int default 0 -); --- -CREATE TABLE chart ( - id int DEFAULT nextval ( 'id' ), - accno text NOT NULL, - description text, - charttype char(1) DEFAULT 'A', - category char(1), - link text, - gifi_accno text -); --- -CREATE TABLE gifi ( - accno text, - description text -); --- -CREATE TABLE defaults ( - inventory_accno_id int, - income_accno_id int, - expense_accno_id int, - fxgain_accno_id int, - fxloss_accno_id int, - sinumber text, - sonumber text, - yearend varchar(5), - weightunit varchar(5), - businessnumber text, - version varchar(8), - curr text, - closedto date, - revtrans bool DEFAULT 'f', - ponumber text, - sqnumber text, - rfqnumber text, - audittrail bool default 'f', - vinumber text, - employeenumber text, - partnumber text, - customernumber text, - vendornumber text -); -INSERT INTO defaults (version) VALUES ('2.4.3'); --- -CREATE TABLE acc_trans ( - trans_id int, - chart_id int, - amount float, - transdate date DEFAULT current_date, - source text, - cleared bool DEFAULT 'f', - fx_transaction bool DEFAULT 'f', - project_id int, - memo text -); --- -CREATE TABLE invoice ( - id int DEFAULT nextval ( 'invoiceid' ), - trans_id int, - parts_id int, - description text, - qty float4, - allocated float4, - sellprice float, - fxsellprice float, - discount float4, - assemblyitem bool DEFAULT 'f', - unit varchar(5), - project_id int, - deliverydate date, - serialnumber text -); --- -CREATE TABLE customer ( - id int default nextval('id'), - name varchar(64), - address1 varchar(32), - address2 varchar(32), - city varchar(32), - state varchar(32), - zipcode varchar(10), - country varchar(32), - contact varchar(64), - phone varchar(20), - fax varchar(20), - email text, - notes text, - discount float4, - taxincluded bool default 'f', - creditlimit float default 0, - terms int2 default 0, - customernumber varchar(32), - cc text, - bcc text, - business_id int, - taxnumber varchar(32), - sic_code varchar(6), - iban varchar(34), - bic varchar(11), - employee_id int, - language_code varchar(6), - pricegroup_id int, - curr char(3), - startdate date, - enddate date -); --- --- -CREATE TABLE parts ( - id int DEFAULT nextval ( 'id' ), - partnumber text, - description text, - unit varchar(5), - listprice float, - sellprice float, - lastcost float, - priceupdate date DEFAULT current_date, - weight float4, - onhand float4 DEFAULT 0, - notes text, - makemodel bool DEFAULT 'f', - assembly bool DEFAULT 'f', - alternate bool DEFAULT 'f', - rop float4, - inventory_accno_id int, - income_accno_id int, - expense_accno_id int, - bin text, - obsolete bool DEFAULT 'f', - bom bool DEFAULT 'f', - image text, - drawing text, - microfiche text, - partsgroup_id int -); --- -CREATE TABLE assembly ( - id int, - parts_id int, - qty float, - bom bool, - adj bool -); --- -CREATE TABLE ar ( - id int DEFAULT nextval ( 'id' ), - invnumber text, - transdate date DEFAULT current_date, - customer_id int, - taxincluded bool, - amount float, - netamount float, - paid float, - datepaid date, - duedate date, - invoice bool DEFAULT 'f', - shippingpoint text, - terms int2 DEFAULT 0, - notes text, - curr char(3), - ordnumber text, - employee_id int, - till varchar(20), - quonumber text, - intnotes text, - department_id int default 0, - shipvia text, - language_code varchar(6) -); --- -CREATE TABLE ap ( - id int DEFAULT nextval ( 'id' ), - invnumber text, - transdate date DEFAULT current_date, - vendor_id int, - taxincluded bool DEFAULT 'f', - amount float, - netamount float, - paid float, - datepaid date, - duedate date, - invoice bool DEFAULT 'f', - ordnumber text, - curr char(3), - notes text, - employee_id int, - till varchar(20), - quonumber text, - intnotes text, - department_id int default 0, - shipvia text, - language_code varchar(6) -); --- -CREATE TABLE partstax ( - parts_id int, - chart_id int -); --- -CREATE TABLE tax ( - chart_id int, - rate float, - taxnumber text -); --- -CREATE TABLE customertax ( - customer_id int, - chart_id int -); --- -CREATE TABLE vendortax ( - vendor_id int, - chart_id int -); --- -CREATE TABLE oe ( - id int default nextval('id'), - ordnumber text, - transdate date default current_date, - vendor_id int, - customer_id int, - amount float8, - netamount float8, - reqdate date, - taxincluded bool, - shippingpoint text, - notes text, - curr char(3), - employee_id int, - closed bool default 'f', - quotation bool default 'f', - quonumber text, - intnotes text, - department_id int default 0, - shipvia text, - language_code varchar(6) -); --- -CREATE TABLE orderitems ( - trans_id int, - parts_id int, - description text, - qty float4, - sellprice float8, - discount float4, - unit varchar(5), - project_id int, - reqdate date, - ship float4, - serialnumber text, - id int default nextval('orderitemsid') -); --- -CREATE TABLE exchangerate ( - curr char(3), - transdate date, - buy float8, - sell float8 -); --- -create table employee ( - id int default nextval('id'), - login text, - name varchar(64), - address1 varchar(32), - address2 varchar(32), - city varchar(32), - state varchar(32), - zipcode varchar(10), - country varchar(32), - workphone varchar(20), - homephone varchar(20), - startdate date default current_date, - enddate date, - notes text, - role varchar(20), - sales bool default 'f', - email text, - sin varchar(20), - iban varchar(34), - bic varchar(11), - managerid int, - employeenumber varchar(32) -); --- -create table shipto ( - trans_id int, - shiptoname varchar(64), - shiptoaddress1 varchar(32), - shiptoaddress2 varchar(32), - shiptocity varchar(32), - shiptostate varchar(32), - shiptozipcode varchar(10), - shiptocountry varchar(32), - shiptocontact varchar(64), - shiptophone varchar(20), - shiptofax varchar(20), - shiptoemail text -); --- -CREATE TABLE vendor ( - id int default nextval('id'), - name varchar(64), - address1 varchar(32), - address2 varchar(32), - city varchar(32), - state varchar(32), - zipcode varchar(10), - country varchar(32), - contact varchar(64), - phone varchar(20), - fax varchar(20), - email text, - notes text, - terms int2 default 0, - taxincluded bool default 'f', - vendornumber varchar(32), - cc text, - bcc text, - gifi_accno varchar(30), - business_id int, - taxnumber varchar(32), - sic_code varchar(6), - discount float4, - creditlimit float default 0, - iban varchar(34), - bic varchar(11), - employee_id int, - language_code varchar(6), - pricegroup_id int, - curr char(3), - startdate date, - enddate date -); --- -CREATE TABLE project ( - id int default nextval('id'), - projectnumber text, - description text -); --- -CREATE TABLE partsgroup ( - id int default nextval('id'), - partsgroup text -); --- -CREATE TABLE status ( - trans_id int, - formname text, - printed bool default 'f', - emailed bool default 'f', - spoolfile text, - chart_id int -); --- -CREATE TABLE department ( - id int default nextval('id'), - description text, - role char(1) default 'P' -); --- --- department transaction table -CREATE TABLE dpt_trans ( - trans_id int, - department_id int -); --- --- business table -CREATE TABLE business ( - id int default nextval('id'), - description text, - discount float4 -); --- --- SIC -CREATE TABLE sic ( - code varchar(6), - sictype char(1), - description text -); --- -CREATE TABLE warehouse ( - id int default nextval('id'), - description text -); --- -CREATE TABLE inventory ( - warehouse_id int, - parts_id int, - oe_id int, - orderitems_id int, - qty float4, - shippingdate date, - employee_id int -); --- -CREATE TABLE yearend ( - trans_id int, - transdate date -); --- -CREATE TABLE partsvendor ( - vendor_id int, - parts_id int, - partnumber text, - leadtime int2, - lastcost float, - curr char(3) -); --- -CREATE TABLE pricegroup ( - id int default nextval('id'), - pricegroup text -); --- -CREATE TABLE partscustomer ( - parts_id int, - customer_id int, - pricegroup_id int, - pricebreak float4, - sellprice float, - validfrom date, - validto date, - curr char(3) -); --- -CREATE TABLE language ( - code varchar(6), - description text -); --- -CREATE TABLE audittrail ( - trans_id int, - tablename text, - reference text, - formname text, - action text, - transdate timestamp default current_timestamp, - employee_id int -); --- -CREATE TABLE translation ( - trans_id int, - language_code varchar(6), - description text -); --- |