SF.net SVN: ledger-smb: [1224] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1224
          http://svn.sourceforge.net/ledger-smb/?rev=1224&view=rev
Author:   linuxpoet
Date:     2007-05-20 12:23:13 -0700 (Sun, 20 May 2007)

Log Message:
-----------
fixed really dumb use of sequences into serial

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-05-20 04:41:26 UTC (rev 1223)
+++ trunk/sql/Pg-database.sql	2007-05-20 19:23:13 UTC (rev 1224)
@@ -3,15 +3,6 @@
 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 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 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 jcitems (
-  id int default nextval('jcitemsid') PRIMARY KEY,
+  id int serial PRIMARY KEY,
   project_id int,
   parts_id int,
   description text,


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.