From 02fdde13e138029abb1c8b2e969a64cd7a9cb4b1 Mon Sep 17 00:00:00 2001
From: Stanislav Ochotnicky <sochotnicky@gmail.com>
Date: Wed, 8 Jul 2009 21:10:55 +0200
Subject: Fix errors in ddl

 * useflag table had wrong type for id (no autoincrement)
 * name of packageproperties_seq_id was corrected
---
 doc/ddl.sql | 20 ++++++++++++++++----
 1 file changed, 16 insertions(+), 4 deletions(-)

(limited to 'doc')

diff --git a/doc/ddl.sql b/doc/ddl.sql
index a9cc00f..5ca409c 100644
--- a/doc/ddl.sql
+++ b/doc/ddl.sql
@@ -159,10 +159,10 @@ CREATE TABLE packagecategory (
 
 
 --
--- Name: packageproperties_seq_id; Type: SEQUENCE; Schema: public; Owner: postgres
+-- Name: packageproperties_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
 --
 
-CREATE SEQUENCE packageproperties_seq_id
+CREATE SEQUENCE packageproperties_id_seq
     START WITH 1
     INCREMENT BY 1
     NO MAXVALUE
@@ -175,7 +175,7 @@ CREATE SEQUENCE packageproperties_seq_id
 --
 
 CREATE TABLE packageproperties (
-    id integer DEFAULT nextval('packageproperties_seq_id'::regclass) NOT NULL,
+    id integer DEFAULT nextval('packageproperties_id_seq'::regclass) NOT NULL,
     packageversion_id integer NOT NULL,
     profile_id integer NOT NULL,
     tinderbox_id integer
@@ -282,12 +282,24 @@ CREATE TABLE tinderbox (
 );
 
 
+--
+-- Name: useflag_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE useflag_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+
 --
 -- Name: useflag; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
 --
 
 CREATE TABLE useflag (
-    id integer NOT NULL,
+    id integer DEFAULT nextval('useflag_id_seq'::regclass) NOT NULL,
     name character varying(255) NOT NULL
 );
 
-- 
cgit v1.2.3-65-gdbad