replace job extension by a friendly filename.
[ais.git] / structure.sql
index edcead7da24f5933736a4f603d03a5de4bb8dcb3..3a7d03c507f5dfdb5d659278833c606500fe74b3 100644 (file)
@@ -113,10 +113,10 @@ CREATE TABLE job (
     start_time timestamp without time zone,
     finish_time timestamp without time zone,
     command text NOT NULL,
-    extension character varying(8) NOT NULL,
     pid integer,
     result integer,
-    archive_time timestamp without time zone
+    archive_time timestamp without time zone,
+    friendly_filename character varying(255)
 );