2 CREATE SEQUENCE id start 10000;
5 CREATE SEQUENCE invoiceid;
6 SELECT nextval ('invoiceid');
8 CREATE SEQUENCE orderitemsid MAXVALUE 100000 CYCLE;
9 SELECT nextval ('orderitemsid');
11 CREATE TABLE makemodel (
18 id int DEFAULT nextval ( 'id' ),
21 transdate date DEFAULT current_date,
24 department_id int default 0
28 id int DEFAULT nextval ( 'id' ),
31 charttype char(1) DEFAULT 'A',
42 CREATE TABLE defaults (
43 inventory_accno_id int,
51 weightunit varchar(5),
56 revtrans bool DEFAULT 'f',
60 audittrail bool default 'f',
67 INSERT INTO defaults (version) VALUES ('2.4.3');
69 CREATE TABLE acc_trans (
73 transdate date DEFAULT current_date,
75 cleared bool DEFAULT 'f',
76 fx_transaction bool DEFAULT 'f',
81 CREATE TABLE invoice (
82 id int DEFAULT nextval ( 'invoiceid' ),
91 assemblyitem bool DEFAULT 'f',
98 CREATE TABLE customer (
99 id int default nextval('id'),
101 address1 varchar(32),
102 address2 varchar(32),
113 taxincluded bool default 'f',
114 creditlimit float default 0,
115 terms int2 default 0,
116 customernumber varchar(32),
120 taxnumber varchar(32),
125 language_code varchar(6),
134 id int DEFAULT nextval ( 'id' ),
141 priceupdate date DEFAULT current_date,
143 onhand float4 DEFAULT 0,
145 makemodel bool DEFAULT 'f',
146 assembly bool DEFAULT 'f',
147 alternate bool DEFAULT 'f',
149 inventory_accno_id int,
151 expense_accno_id int,
153 obsolete bool DEFAULT 'f',
154 bom bool DEFAULT 'f',
161 CREATE TABLE assembly (
170 id int DEFAULT nextval ( 'id' ),
172 transdate date DEFAULT current_date,
180 invoice bool DEFAULT 'f',
182 terms int2 DEFAULT 0,
190 department_id int default 0,
192 language_code varchar(6)
196 id int DEFAULT nextval ( 'id' ),
198 transdate date DEFAULT current_date,
200 taxincluded bool DEFAULT 'f',
206 invoice bool DEFAULT 'f',
214 department_id int default 0,
216 language_code varchar(6)
219 CREATE TABLE partstax (
230 CREATE TABLE customertax (
235 CREATE TABLE vendortax (
241 id int default nextval('id'),
243 transdate date default current_date,
254 closed bool default 'f',
255 quotation bool default 'f',
258 department_id int default 0,
260 language_code varchar(6)
263 CREATE TABLE orderitems (
275 id int default nextval('orderitemsid')
278 CREATE TABLE exchangerate (
285 create table employee (
286 id int default nextval('id'),
289 address1 varchar(32),
290 address2 varchar(32),
295 workphone varchar(20),
296 homephone varchar(20),
297 startdate date default current_date,
301 sales bool default 'f',
307 employeenumber varchar(32)
310 create table shipto (
312 shiptoname varchar(64),
313 shiptoaddress1 varchar(32),
314 shiptoaddress2 varchar(32),
315 shiptocity varchar(32),
316 shiptostate varchar(32),
317 shiptozipcode varchar(10),
318 shiptocountry varchar(32),
319 shiptocontact varchar(64),
320 shiptophone varchar(20),
321 shiptofax varchar(20),
325 CREATE TABLE vendor (
326 id int default nextval('id'),
328 address1 varchar(32),
329 address2 varchar(32),
339 terms int2 default 0,
340 taxincluded bool default 'f',
341 vendornumber varchar(32),
344 gifi_accno varchar(30),
346 taxnumber varchar(32),
349 creditlimit float default 0,
353 language_code varchar(6),
360 CREATE TABLE project (
361 id int default nextval('id'),
366 CREATE TABLE partsgroup (
367 id int default nextval('id'),
371 CREATE TABLE status (
374 printed bool default 'f',
375 emailed bool default 'f',
380 CREATE TABLE department (
381 id int default nextval('id'),
383 role char(1) default 'P'
386 -- department transaction table
387 CREATE TABLE dpt_trans (
393 CREATE TABLE business (
394 id int default nextval('id'),
406 CREATE TABLE warehouse (
407 id int default nextval('id'),
411 CREATE TABLE inventory (
421 CREATE TABLE yearend (
426 CREATE TABLE partsvendor (
435 CREATE TABLE pricegroup (
436 id int default nextval('id'),
440 CREATE TABLE partscustomer (
451 CREATE TABLE language (
456 CREATE TABLE audittrail (
462 transdate timestamp default current_timestamp,
466 CREATE TABLE translation (
468 language_code varchar(6),