[1992] in Moira Commits
/svn/moira r4131 - in trunk/moira: db server
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Fri Aug 16 14:34:39 2013
Date: Fri, 16 Aug 2013 14:34:32 -0400
From: Garry Zacheiss <zacheiss@MIT.EDU>
Message-Id: <201308161834.r7GIYW3B008101@drugstore.mit.edu>
To: moira-commits@MIT.EDU
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: zacheiss
Date: 2013-08-16 14:34:32 -0400 (Fri, 16 Aug 2013)
New Revision: 4131
Modified:
trunk/moira/db/schema.sql
trunk/moira/server/increment.pc
Log:
use TIMESTAMP, not DATE.
Modified: trunk/moira/db/schema.sql
===================================================================
--- trunk/moira/db/schema.sql 2013-08-14 13:59:27 UTC (rev 4130)
+++ trunk/moira/db/schema.sql 2013-08-16 18:34:32 UTC (rev 4131)
@@ -506,7 +506,7 @@
afterc INTEGER DEFAULT 0 NOT NULL,
before VARCHAR(4000) DEFAULT CHR(0) NOT NULL,
after VARCHAR(4000) DEFAULT CHR(0) NOT NULL,
- timestamp DATE DEFAULT SYSDATE NOT NULL,
+ timestamp TIMESTAMP DEFAULT SYSTIMESTAMP NOT NULL,
incremental_id INTEGER DEFAULT 0 NOT NULL
);
Modified: trunk/moira/server/increment.pc
===================================================================
--- trunk/moira/server/increment.pc 2013-08-14 13:59:27 UTC (rev 4130)
+++ trunk/moira/server/increment.pc 2013-08-16 18:34:32 UTC (rev 4131)
@@ -629,7 +629,7 @@
EXEC SQL INSERT INTO incremental_queue
(incremental_id, table_name, service, beforec, afterc, before, after, timestamp)
VALUES (incremental_seq.nextval, :iu->table, :iu->service, :iu->beforec, :iu->afterc,
- NVL(:before_encoded, CHR(0)), NVL(:after_encoded, CHR(0)), SYSDATE);
+ NVL(:before_encoded, CHR(0)), NVL(:after_encoded, CHR(0)), SYSTIMESTAMP);
EXEC SQL COMMIT WORK;
if (before_flattened)
