diff options
| author |   Stanislav Ochotnicky <sochotnicky@gmail.com> | 2009-07-08 21:10:55 +0200 |
|---|---|---|
| committer | Stanislav Ochotnicky <sochotnicky@gmail.com> | 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 ); |