diff options
| -rw-r--r-- | sql/Pg-database.sql | 15 |
1 files changed, 3 insertions, 12 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index afc9852c..4809f935 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -3,15 +3,6 @@ begin; CREATE SEQUENCE id start 10000; SELECT nextval ('id'); -- -CREATE SEQUENCE invoiceid; -SELECT nextval ('invoiceid'); --- -CREATE SEQUENCE orderitemsid; -SELECT nextval ('orderitemsid'); --- -CREATE SEQUENCE jcitemsid; -SELECT nextval ('jcitemsid'); --- CREATE TABLE transactions ( id int PRIMARY KEY, @@ -97,7 +88,7 @@ CREATE TABLE acc_trans ( ); -- CREATE TABLE invoice ( - id int DEFAULT nextval ( 'invoiceid' ) PRIMARY KEY, + id int serial PRIMARY KEY, trans_id int, parts_id int, description text, @@ -313,7 +304,7 @@ CREATE TABLE oe ( ); -- CREATE TABLE orderitems ( - id int default nextval('orderitemsid') PRIMARY KEY, + id int serial PRIMARY KEY, trans_id int, parts_id int, description text, @@ -562,7 +553,7 @@ CREATE TABLE recurringprint ( ); -- CREATE TABLE jcitems ( - id int default nextval('jcitemsid') PRIMARY KEY, + id int serial PRIMARY KEY, project_id int, parts_id int, description text, |