From 8a65e853dfe77ec2e91e6b12b75e9bfcf8fd4957 Mon Sep 17 00:00:00 2001 From: APTX Date: Thu, 4 Apr 2013 14:01:16 +0200 Subject: [PATCH] Make id columns not null. Add a lid column for future use --- localmylist/share/schema/schema.sql | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/localmylist/share/schema/schema.sql b/localmylist/share/schema/schema.sql index a61233a..f95f8a1 100644 --- a/localmylist/share/schema/schema.sql +++ b/localmylist/share/schema/schema.sql @@ -45,7 +45,7 @@ CREATE INDEX language_idx ON anime_title USING hash (language); CREATE TABLE episode ( eid integer NOT NULL, - aid integer, + aid integer NOT NULL, entry_added timestamp without time zone NOT NULL DEFAULT now(), anidb_update timestamp without time zone, entry_update timestamp without time zone, @@ -77,9 +77,10 @@ CREATE TABLE episode_type CREATE TABLE file ( fid integer NOT NULL, - eid integer, - aid integer, - gid integer, + eid integer NOT NULL, + aid integer NOT NULL, + gid integer NOT NULL, + lid integer NOT NULL DEFAULT 0, entry_added timestamp without time zone NOT NULL DEFAULT now(), anidb_update timestamp without time zone, entry_update timestamp without time zone, -- 2.52.0