From 0cbfb7a5849d68a9b16c361f092848982fac04e7 Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Fri, 27 Nov 2009 17:01:31 +0000 Subject: Gave dbhistlog timestamp more precision. --- did-model.lua | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/did-model.lua b/did-model.lua index 444eb4f..0e39d7a 100644 --- a/did-model.lua +++ b/did-model.lua @@ -22,7 +22,7 @@ local con local database_creation_script = { "CREATE AGGREGATE array_accum(anyelement) (SFUNC = array_append, STYPE = anyarray, INITCOND = '{}')", - "CREATE TABLE dbhistlog (logdatetime timestamp(0) without time zone NOT NULL, msgtext text, userid text)", + "CREATE TABLE dbhistlog (logdatetime timestamp(3) without time zone NOT NULL, msgtext text, userid text)", "CREATE TABLE definition (did character varying(40) NOT NULL, identification character varying(7), department character varying(40), description character varying(255))", "CREATE TABLE pubdid (did character varying(40), extension character varying(40), starttime time without time zone, endtime time without time zone, stale boolean)", "CREATE TABLE rule (did character varying(40) NOT NULL, extension character varying(40) NOT NULL, starttime time without time zone, endtime time without time zone, startdate date, enddate date, dayofweek bit(7))", -- cgit v1.2.3