Mercurial > hg > ltpdarepo
changeset 117:4f7fa0617726
Fix declaration of 'toffset' field in 'tsdata' table for new databases.
| author | Daniele Nicolodi <daniele@grinta.net> |
|---|---|
| date | Tue, 11 Oct 2011 17:44:42 +0200 |
| parents | ee8373e00a3e |
| children | 2843a5c5e607 |
| files | src/ltpdarepo/sql/database.sql |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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;