# HG changeset patch
# User Daniele Nicolodi <daniele@grinta.net>
# Date 1318347882 -7200
# Node ID 4f7fa0617726fd84a4bcc82d437f1eb8217312b9
# Parent  ee8373e00a3ed934080b5bf59a881c9c611ed273
Fix declaration of 'toffset' field in 'tsdata' table for new databases.

diff -r ee8373e00a3e -r 4f7fa0617726 src/ltpdarepo/sql/database.sql
--- a/src/ltpdarepo/sql/database.sql	Tue Oct 11 17:23:28 2011 +0200
+++ b/src/ltpdarepo/sql/database.sql	Tue Oct 11 17:44:42 2011 +0200
@@ -86,7 +86,7 @@
   `fs` double DEFAULT NULL,
   `nsecs` double DEFAULT NULL,
   `t0` datetime DEFAULT NULL,
-  `toffset` bigint DEFAULT NULL,
+  `toffset` bigint NOT NULL DEFAULT 0,
   PRIMARY KEY `obj_id` (`obj_id`),
   FOREIGN KEY (`obj_id`) REFERENCES `objs` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB;