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: