Changeset 199 for trunk/install/sql/eleonline.sql

Timestamp:

Apr 23, 2014, 12:08:28 AM (10 years ago)

Author:

roby

Message:

• aggiornamento consiglieri per comuni fino a 10.000 abitanti
• inserita cancellazione voti di gruppi e liste (a caduta comprende le preferenze) per sezione

File:

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

trunk/install/sql/eleonline.sql

@@ -325 +325 @@
 (5, 'Legge Italiana 267/2000 con riduzione 2011', 3, '1', 67, 3, 60, 3, '1', '1', 40, 40, '0', '0', '0', '0', '0', 7),
 (6, 'Legge Italiana 267/2000 con riduzione 2012', 3, '1', 67, 3, 60, 3, '1', '1', 40, 40, '0', '0', '0', '0', '0', 7);
+(7, 'Legge Italiana 267/2000 con modifiche 2014', 3, '1', 67, 3, 60, 3, '1', '1', 40, 40, '0', '0', '0', '0', '0', 6);
 UNLOCK TABLES;
 /*!40000 ALTER TABLE `soraldo_ele_conf` ENABLE KEYS */;
@@ -434 +435 @@
 (8, 1000000, 50, 1),
 (9, 100000000, 60, 1),
-(1, 3000, 9, 5),
-(2, 5000, 9, 5),
-(3, 10000, 12, 5),
-(4, 15000, 16, 5),
-(5, 30000, 16, 5),
-(6, 100000, 24, 5),
-(7, 250000, 32, 5),
-(8, 500000, 36, 5),
-(9, 1000000, 40, 5),
-(10, 100000000, 48, 5),
-(1, 3000, 6, 6),
-(2, 5000, 7, 6),
-(3, 10000, 10, 6),
-(4, 15000, 16, 6),
-(5, 30000, 16, 6),
-(6, 100000, 24, 6),
-(7, 250000, 32, 6),
-(8, 500000, 36, 6),
-(9, 1000000, 40, 6),
-(10, 100000000, 48, 6),
 (1, 3000, 12, 2),
 (2, 10000, 16, 2),
@@ -482 +463 @@
 (8, 500000, 36, 4),
 (9, 1000000, 40, 4),
-(10, 100000000, 48, 4);
+(10, 100000000, 48, 4),
+(1, 3000, 9, 5),
+(2, 5000, 9, 5),
+(3, 10000, 12, 5),
+(4, 15000, 16, 5),
+(5, 30000, 16, 5),
+(6, 100000, 24, 5),
+(7, 250000, 32, 5),
+(8, 500000, 36, 5),
+(9, 1000000, 40, 5),
+(10, 100000000, 48, 5),
+(1, 3000, 6, 6),
+(2, 5000, 7, 6),
+(3, 10000, 10, 6),
+(4, 15000, 16, 6),
+(5, 30000, 16, 6),
+(6, 100000, 24, 6),
+(7, 250000, 32, 6),
+(8, 500000, 36, 6),
+(9, 1000000, 40, 6),
+(10, 100000000, 48, 6),
+(1, 3000, 10, 7),
+(2, 10000, 12, 7),
+(3, 15000, 16, 7),
+(4, 30000, 16, 7),
+(5, 100000, 24, 7),
+(6, 250000, 32, 7),
+(7, 500000, 36, 7),
+(8, 1000000, 40, 7),
+(9, 100000000, 48, 7);
 /*!40000 ALTER TABLE `soraldo_ele_fasce` ENABLE KEYS */;
 UNLOCK TABLES;