From e0367e26800632ba06aa0f7314946173ba580928 Mon Sep 17 00:00:00 2001
From: linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sun, 20 May 2007 19:23:13 +0000
Subject: fixed really dumb use of sequences into serial

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1224 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 15 +++------------
 1 file 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,
-- 
cgit v1.2.3