From 56d71a7f601a1dafbceaae9e0873f2c560a222ea Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Sat, 8 Aug 2015 04:54:11 +0100
Subject: Set proper not nulls

---
 gentoobrowse/datasources/schema.sql | 14 +++++++-------
 1 file 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: 
-- 
cgit v1.2.3