Added database constraint on job.friendly_name not null
authorJean-Michel Nirgal Vourgère <jmv@nirgal.com>
Thu, 11 Nov 2010 16:09:53 +0000 (16:09 +0000)
committerJean-Michel Nirgal Vourgère <jmv@nirgal.com>
Thu, 11 Nov 2010 16:09:53 +0000 (16:09 +0000)
structure.sql

index 3a7d03c507f5dfdb5d659278833c606500fe74b3..01218e6e6f75b12897f79f0e4639d2eee6555186 100644 (file)
@@ -116,7 +116,7 @@ CREATE TABLE job (
     pid integer,
     result integer,
     archive_time timestamp without time zone,
-    friendly_filename character varying(255)
+    friendly_filename character varying(255) NOT NULL
 );