| 1 | DROP TABLE IF EXISTS `soraldo_ele_fasce`;
|
|---|
| 2 | CREATE 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,
|
|---|
| 8 | KEY `id_fascia` (`id_fascia`)
|
|---|
| 9 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|---|
| 10 |
|
|---|
| 11 | --
|
|---|
| 12 | -- Dump dei dati per la tabella `soraldo_ele_fasce`
|
|---|
| 13 | --
|
|---|
| 14 |
|
|---|
| 15 | INSERT 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 |
|
|---|
| 47 | DROP TABLE `soraldo_ele_conf`;
|
|---|
| 48 |
|
|---|
| 49 | CREATE 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 |
|
|---|
| 71 | INSERT 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 |
|
|---|
| 77 | ALTER TABLE `soraldo_ele_sezioni` ADD `solo_lista` INT( 7 ) NOT NULL DEFAULT '0';
|
|---|
