Changeset 139 for trunk/install

Timestamp:

May 6, 2012, 8:53:42 PM (13 years ago)

Author:

roby

Message:

Modifiche per gestione Legge regione Sicilia 2011

File:

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

trunk/install/sql/eleonline.sql

@@ -301 +301 @@
   `supminpremio` int(3) NOT NULL,
   `infminpremio` int(3) NOT NULL,
+  `infdisgiunto` enum('0','1') NOT NULL DEFAULT '0',
+  `supdisgiunto` enum('0','1') NOT NULL DEFAULT '0',
   PRIMARY KEY  (`id_conf`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
@@ -311 +313 @@
 /*!40000 ALTER TABLE `soraldo_ele_conf` DISABLE KEYS */;
 LOCK TABLES `soraldo_ele_conf` WRITE;
-INSERT INTO `soraldo_ele_conf` VALUES (1,'Legge Italiana 267/2000',3,'1',67,3,60,3,'1','1',40,40),(2,'Regione Sicilia precedente al 2008',2,'0',67,3,60,3,'1','1',40,40),(3,'Regione Sicilia Legge n. 22 del 16/12/2008',2,'0',67,5,60,3,'1','0',40,40);
+INSERT INTO `soraldo_ele_conf` VALUES 
+(1, 'Legge Italiana 267/2000', 3, '1', 67, 3, 60, 3, '1', '1', 40, 40, '0', '0'),
+(2, 'Regione Sicilia precedente al 2008', 2, '0', 67, 3, 60, 3, '1', '1', 40, 40, '0', '0'),
+(3, 'Regione Sicilia Legge n. 22 del 16/12/2008', 2, '0', 67, 5, 60, 3, '1', '0', 40, 40, '0', '0'),
+(4, 'Regione Sicilia Legge n.6/2011', 5, '1', 67, 5, 60, 5, '1', '1', 40, 40, '1', '1');
 UNLOCK TABLES;
 /*!40000 ALTER TABLE `soraldo_ele_conf` ENABLE KEYS */;
@@ -409 +415 @@
 LOCK TABLES `soraldo_ele_fasce` WRITE;
 /*!40000 ALTER TABLE `soraldo_ele_fasce` DISABLE KEYS */;
-INSERT INTO `soraldo_ele_fasce` VALUES (1,3000,'2000-01-01','2010-12-31',12),(2,10000,'2000-01-01','2010-12-31',16),(3,15000,'2000-01-01','2010-12-31',20),(4,30000,'2000-01-01','2010-12-31',20),(5,100000,'2000-01-01','2010-12-31',30),(6,250000,'2000-01-01','2010-12-31',40),(7,500000,'2000-01-01','2010-12-31',46),(8,1000000,'2000-01-01','2010-12-31',50),(9,100000000,'2000-01-01','2010-12-31',60),(4,30000,'2011-01-01','0000-00-00',16),(1,3000,'2011-01-01','0000-00-00',9),(2,10000,'2011-01-01','0000-00-00',12),(3,15000,'2011-01-01','0000-00-00',16),(5,100000,'2011-01-01','0000-00-00',24),(6,250000,'2011-01-01','0000-00-00',32),(7,500000,'2011-01-01','0000-00-00',36),(8,1000000,'2011-01-01','0000-00-00',40),(9,100000000,'2011-01-01','0000-00-00',48);
+INSERT INTO `soraldo_ele_fasce` VALUES 
+(1, 3000, '2000-01-01', '2010-12-31', 12),
+(2, 10000, '2000-01-01', '2010-12-31', 16),
+(3, 15000, '2000-01-01', '2010-12-31', 20),
+(4, 30000, '2000-01-01', '2010-12-31', 20),
+(5, 100000, '2000-01-01', '2010-12-31', 30),
+(6, 250000, '2000-01-01', '2010-12-31', 40),
+(7, 500000, '2000-01-01', '2010-12-31', 46),
+(8, 1000000, '2000-01-01', '2010-12-31', 50),
+(9, 100000000, '2000-01-01', '2010-12-31', 60),
+(4, 30000, '2011-01-01', '2011-09-14', 16),
+(1, 3000, '2011-01-01', '2011-09-14', 9),
+(2, 10000, '2011-01-01', '2011-09-14', 12),
+(3, 15000, '2011-01-01', '2011-09-14', 16),
+(5, 100000, '2011-01-01', '2011-09-14', 24),
+(6, 250000, '2011-01-01', '2011-09-14', 32),
+(7, 500000, '2011-01-01', '2011-09-14', 36),
+(8, 1000000, '2011-01-01', '2011-09-14', 40),
+(9, 100000000, '2011-01-01', '2011-09-14', 48),
+(1, 1000, '2011-09-15', '0000-00-00', 6),
+(2, 3000, '2011-09-15', '0000-00-00', 6),
+(3, 5000, '2011-09-15', '0000-00-00', 7),
+(4, 10000, '2011-09-15', '0000-00-00', 10),
+(5, 15000, '2011-09-15', '0000-00-00', 16),
+(6, 30000, '2011-09-15', '0000-00-00', 16),
+(7, 100000, '2011-09-15', '0000-00-00', 24),
+(8, 250000, '2011-09-15', '0000-00-00', 32),
+(9, 500000, '2011-09-15', '0000-00-00', 36),
+(10, 1000000, '2011-09-15', '0000-00-00', 40),
+(11, 100000000, '2011-09-15', '0000-00-00', 48);
 /*!40000 ALTER TABLE `soraldo_ele_fasce` ENABLE KEYS */;
 UNLOCK TABLES;
@@ -741 +776 @@
   `contestati_lista` int(7) NOT NULL default '0',
   `voti_nulli_lista` int(7) NOT NULL default '0',
+  `bianchi_lista` int(7) NOT NULL DEFAULT '0',
+  `nulli_lista` int(7) NOT NULL DEFAULT '0',
   UNIQUE KEY `id_sezi` (`id_sez`),
   KEY `id_cons` (`id_cons`),