diff options
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 ); |