From a8774da1f381de6156d7d4206ef921547b0655b9 Mon Sep 17 00:00:00 2001 From: Dan Langille Date: Sat, 3 Jan 2004 22:33:24 +0000 Subject: [PATCH] Remove "not null" and "default current_timestamp" from media.{firstwritten|lastwritten|labeldate} git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@987 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/make_postgresql_tables.in | 9 +++------ 1 file changed, 3 insertions(+), 6 deletions(-) diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index 7232c05cee..71a3720bc0 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -110,12 +110,9 @@ create table media default 0, poolid integer not null, mediatype text not null, - firstwritten timestamp without time zone not null - default current_timestamp, - lastwritten timestamp without time zone not null - default current_timestamp, - labeldate timestamp without time zone not null - default current_timestamp, + firstwritten timestamp without time zone, + lastwritten timestamp without time zone, + labeldate timestamp without time zone, voljobs integer not null default 0, volfiles integer not null -- 2.39.5