diff options
author | 2009-07-08 21:10:55 +0200 | |
---|---|---|
committer | 2009-07-08 21:16:09 +0200 | |
commit | 02fdde13e138029abb1c8b2e969a64cd7a9cb4b1 (patch) | |
tree | 29720b8fb71c5fd320f0f9a08ea30a27e4a87125 /doc | |
parent | Added basic functions of DbIface interface (diff) | |
download | collagen-02fdde13e138029abb1c8b2e969a64cd7a9cb4b1.tar.gz collagen-02fdde13e138029abb1c8b2e969a64cd7a9cb4b1.tar.bz2 collagen-02fdde13e138029abb1c8b2e969a64cd7a9cb4b1.zip |
Fix errors in ddl
* useflag table had wrong type for id (no autoincrement)
* name of packageproperties_seq_id was corrected
Diffstat (limited to 'doc')
-rw-r--r-- | doc/ddl.sql | 20 |
1 files changed, 16 insertions, 4 deletions
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 @@ -283,11 +283,23 @@ 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 ); |