Changeset 318 for trunk/install/sql

Timestamp:

Jun 2, 2019, 10:04:20 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/install/sql/eleonline.sql (modified) (3 diffs)

trunk/install/sql/eleonline.sql

@@ -449 +449 @@
   `num_gruppo` int(2) UNSIGNED NOT NULL DEFAULT '0',
   `id_circ` int(11) NOT NULL DEFAULT '0',
-  `num_circ` int(2) UNSIGNED NOT NULL,
+  `num_circ` int(2) UNSIGNED NOT NULL DEFAULT '0',
   `descrizione` text,
   `simbolo` text,
@@ -544 +544 @@
   `id_cons_gen` int(11) NOT NULL DEFAULT '0',
   `orario` time NOT NULL DEFAULT '00:00:00',
-  `data` date NOT NULL DEFAULT '0000-00-00'
+  `data` date NOT NULL DEFAULT '1970-01-01'
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
@@ -718 +718 @@
   `id_parz` int(11) NOT NULL,
   `orario` time NOT NULL DEFAULT '00:00:00',
-  `data` date NOT NULL DEFAULT '0000-00-00',
+  `data` date NOT NULL DEFAULT '1970-01-01',
   `voti_uomini` int(7) NOT NULL DEFAULT '0',
   `voti_donne` int(7) NOT NULL DEFAULT '0',