source: trunk/sql/aggiornamento-2.0_2012-04-22.sql@ 177

Last change on this file since 177 was 155, checked in by luciano, 12 years ago
  • Property svn:executable set to *
File size: 3.3 KB
Line 
1DROP TABLE IF EXISTS `soraldo_ele_fasce`;
2CREATE TABLE IF NOT EXISTS `soraldo_ele_fasce` (
3`id_fascia` int(2) NOT NULL,
4`abitanti` int(11) NOT NULL,
5`data_inizio` date NOT NULL,
6`data_fine` date NOT NULL,
7`seggi` int(4) NOT NULL,
8KEY `id_fascia` (`id_fascia`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1;
10
11--
12-- Dump dei dati per la tabella `soraldo_ele_fasce`
13--
14
15INSERT INTO `soraldo_ele_fasce` (`id_fascia`, `abitanti`, `data_inizio`, `data_fine`, `seggi`) VALUES
16(1, 3000, '2000-01-01', '2010-12-31', 12),
17(2, 10000, '2000-01-01', '2010-12-31', 16),
18(3, 15000, '2000-01-01', '2010-12-31', 20),
19(4, 30000, '2000-01-01', '2010-12-31', 20),
20(5, 100000, '2000-01-01', '2010-12-31', 30),
21(6, 250000, '2000-01-01', '2010-12-31', 40),
22(7, 500000, '2000-01-01', '2010-12-31', 46),
23(8, 1000000, '2000-01-01', '2010-12-31', 50),
24(9, 100000000, '2000-01-01', '2010-12-31', 60),
25(4, 30000, '2011-01-01', '2011-09-14', 16),
26(1, 3000, '2011-01-01', '2011-09-14', 9),
27(2, 10000, '2011-01-01', '2011-09-14', 12),
28(3, 15000, '2011-01-01', '2011-09-14', 16),
29(5, 100000, '2011-01-01', '2011-09-14', 24),
30(6, 250000, '2011-01-01', '2011-09-14', 32),
31(7, 500000, '2011-01-01', '2011-09-14', 36),
32(8, 1000000, '2011-01-01', '2011-09-14', 40),
33(9, 100000000, '2011-01-01', '2011-09-14', 48),
34(1, 1000, '2011-09-15', '0000-00-00', 6),
35(2, 3000, '2011-09-15', '0000-00-00', 6),
36(3, 5000, '2011-09-15', '0000-00-00', 7),
37(4, 10000, '2011-09-15', '0000-00-00', 10),
38(5, 15000, '2011-09-15', '0000-00-00', 16),
39(6, 30000, '2011-09-15', '0000-00-00', 16),
40(7, 100000, '2011-09-15', '0000-00-00', 24),
41(8, 250000, '2011-09-15', '0000-00-00', 32),
42(9, 500000, '2011-09-15', '0000-00-00', 36),
43(10, 1000000, '2011-09-15', '0000-00-00', 40),
44(11, 100000000, '2011-09-15', '0000-00-00', 48);
45
46
47DROP TABLE `soraldo_ele_conf`;
48
49CREATE TABLE IF NOT EXISTS `soraldo_ele_conf` (
50 `id_conf` int(11) NOT NULL auto_increment,
51 `descrizione` varchar(50) NOT NULL,
52 `limite` int(2) NOT NULL,
53 `consin` enum('0','1') NOT NULL default '1',
54 `infpremio` int(3) NOT NULL,
55 `supsbarramento` int(3) NOT NULL,
56 `suppremio` int(3) NOT NULL,
57 `listinfsbar` int(3) NOT NULL default '1',
58 `listinfconta` enum('0','1') NOT NULL default '1',
59 `listsupconta` enum('0','1') NOT NULL default '1',
60 `supminpremio` int(3) NOT NULL,
61 `infminpremio` int(3) NOT NULL,
62 `infdisgiunto` enum('0','1') NOT NULL default '0',
63 `supdisgiunto` enum('0','1') NOT NULL default '0',
64 PRIMARY KEY (`id_conf`)
65) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
66
67--
68-- Dump dei dati per la tabella `soraldo_ele_conf`
69--
70
71INSERT INTO `soraldo_ele_conf` (`id_conf`, `descrizione`, `limite`, `consin`, `infpremio`, `supsbarramento`, `suppremio`, `listinfsbar`, `listinfconta`, `listsupconta`, `supminpremio`, `infminpremio`, `infdisgiunto`, `supdisgiunto`) VALUES
72(1, 'Legge Italiana 267/2000', 3, '1', 67, 3, 60, 3, '1', '1', 40, 40, '0', '0'),
73(2, 'Regione Sicilia precedente al 2008', 2, '0', 67, 3, 60, 3, '1', '1', 40, 40, '0', '0'),
74(3, 'Regione Sicilia Legge n. 22 del 16/12/2008', 2, '0', 67, 5, 60, 3, '1', '0', 40, 40, '0', '0'),
75(4, 'Regione Sicilia Legge n.6/2011', 5, '1', 67, 5, 60, 5, '1', '1', 40, 40, '1', '1');
76
77ALTER TABLE `soraldo_ele_sezioni` ADD `solo_lista` INT( 7 ) NOT NULL DEFAULT '0';
Note: See TracBrowser for help on using the repository browser.