# HG changeset patch
# User Daniele Nicolodi <daniele@grinta.net>
# Date 1318346608 -7200
# Node ID ee8373e00a3ed934080b5bf59a881c9c611ed273
# Parent  1996c3a9f0e80019165752501505c2fcc3d7827a
Remove fields comments.

diff -r 1996c3a9f0e8 -r ee8373e00a3e src/ltpdarepo/sql/database.sql
--- a/src/ltpdarepo/sql/database.sql	Tue Oct 11 17:20:15 2011 +0200
+++ b/src/ltpdarepo/sql/database.sql	Tue Oct 11 17:23:28 2011 +0200
@@ -1,6 +1,6 @@
 CREATE TABLE `objs` (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of every object in this database',
-  `xml` longtext COMMENT 'Raw XML representation of the object',
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `xml` longtext,
   `uuid` text CHARACTER SET utf8,
   `hash` text CHARACTER SET utf8,
   PRIMARY KEY (`id`)
@@ -8,7 +8,7 @@
 
 CREATE TABLE `bobjs` (
   `obj_id` int(11) unsigned NOT NULL,
-  `mat` longblob COMMENT 'Binary version of the object',
+  `mat` longblob,
   PRIMARY KEY (`obj_id`),
   FOREIGN KEY (`obj_id`) REFERENCES `objs` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB;
@@ -18,12 +18,12 @@
   `obj_type` enum('ao','collection','filterbank','matrix','mfir','miir','parfrac',
                   'pest','plist','pzmodel','rational','smodel','ssm','timespan') NOT NULL,
   `name` text CHARACTER SET utf8,
-  `created` datetime DEFAULT NULL COMMENT 'Creation time of an object',
+  `created` datetime DEFAULT NULL,
   `version` text CHARACTER SET utf8,
   `ip` text CHARACTER SET utf8,
   `hostname` text CHARACTER SET utf8,
   `os` text CHARACTER SET utf8,
-  `submitted` datetime DEFAULT NULL COMMENT 'Submission time of an object',
+  `submitted` datetime DEFAULT NULL,
   `experiment_title` text CHARACTER SET utf8,
   `experiment_desc` text CHARACTER SET utf8,
   `analysis_desc` text CHARACTER SET utf8,
@@ -32,25 +32,25 @@
   `additional_comments` text CHARACTER SET utf8,
   `keywords` text CHARACTER SET utf8,
   `reference_ids` text CHARACTER SET utf8,
-  `validated` tinyint(4) DEFAULT NULL COMMENT 'Validated',
-  `vdate` datetime DEFAULT NULL COMMENT 'Validation time',
+  `validated` tinyint(4) DEFAULT NULL,
+  `vdate` datetime DEFAULT NULL,
   `author` text CHARACTER SET utf8,
   PRIMARY KEY (`obj_id`),
   FOREIGN KEY (`obj_id`) REFERENCES `objs` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB;
 
 CREATE TABLE `collections` (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of every data set in this table',
-  `nobjs` int(11) DEFAULT NULL COMMENT 'Number of objects in a collection',
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `nobjs` int(11) DEFAULT NULL,
   `obj_ids` text CHARACTER SET utf8,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB;
 
 CREATE TABLE `transactions` (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of every data set in this table',
-  `obj_id` int(11) DEFAULT NULL COMMENT 'ID of the object the transaction belongs to',
-  `user_id` int(11) DEFAULT NULL COMMENT 'ID of the User of the transactions',
-  `transdate` datetime DEFAULT NULL COMMENT 'Date and time of the transaction',
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `obj_id` int(11) DEFAULT NULL,
+  `user_id` int(11) DEFAULT NULL,
+  `transdate` datetime DEFAULT NULL,
   `direction` text CHARACTER SET utf8,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB;
@@ -83,9 +83,9 @@
   `obj_id` int(11) unsigned NOT NULL,
   `xunits` text CHARACTER SET utf8,
   `yunits` text CHARACTER SET utf8,
-  `fs` double DEFAULT NULL COMMENT 'Sample frequency [Hz]',
-  `nsecs` double DEFAULT NULL COMMENT 'Number of nanoseconds',
-  `t0` datetime DEFAULT NULL COMMENT 'Starting time of the time series',
+  `fs` double DEFAULT NULL,
+  `nsecs` double DEFAULT NULL,
+  `t0` datetime DEFAULT NULL,
   `toffset` bigint DEFAULT NULL,
   PRIMARY KEY `obj_id` (`obj_id`),
   FOREIGN KEY (`obj_id`) REFERENCES `objs` (`id`) ON DELETE CASCADE