diff options
| -rw-r--r-- | gentoobrowse/datasources/schema.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql index 36877a4..4eec710 100644 --- a/gentoobrowse/datasources/schema.sql +++ b/gentoobrowse/datasources/schema.sql @@ -316,7 +316,7 @@ CREATE TABLE ebuilds ( license text, firstseen timestamp without time zone NOT NULL, moddate timestamp without time zone NOT NULL, - repoid integer + repoid integer NOT NULL ); ALTER TABLE ebuilds OWNER TO gentoo; -- Name: TABLE ebuilds; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -329,16 +329,16 @@ CREATE TABLE files ( firstseen timestamp without time zone DEFAULT now() NOT NULL, cachedat timestamp without time zone, filetypeid integer NOT NULL, - repoid integer DEFAULT 1 NOT NULL, - filesize integer, - pathparts text[] + repoid integer NOT NULL, + filesize integer NOT NULL, + pathparts text[] NOT NULL ); ALTER TABLE files OWNER TO gentoo; -- Name: filetypes; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: CREATE TABLE filetypes ( filetypeid integer NOT NULL, description text NOT NULL, - spec filterspec[] + spec filterspec[] NOT NULL ); ALTER TABLE filetypes OWNER TO gentoo; -- Name: TABLE filetypes; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -346,7 +346,7 @@ COMMENT ON TABLE filetypes IS 'What kind of file is this?... metadata, changelog -- Name: license; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: CREATE TABLE license ( name text NOT NULL, - legalbumph text + legalbumph text NOT NULL ); ALTER TABLE license OWNER TO gentoo; -- Name: masksets; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -476,7 +476,7 @@ ALTER SEQUENCE use_groups_usegroupid_seq OWNED BY use_groups.usegroupid; CREATE TABLE use_local ( packageid integer NOT NULL, use text NOT NULL, - description text + description text NOT NULL ); ALTER TABLE use_local OWNER TO gentoo; -- Name: user_ebuild_emails; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: |