|
Last change
on this file since 199 was 199, checked in by roby, 10 years ago |
- aggiornamento consiglieri per comuni fino a 10.000 abitanti
- inserita cancellazione voti di gruppi e liste (a caduta comprende le preferenze) per sezione
|
|
File size:
2.5 KB
|
| Line | |
|---|
| 1 | -- phpMyAdmin SQL Dump
|
|---|
| 2 | -- version 4.1.6
|
|---|
| 3 | -- http://www.phpmyadmin.net
|
|---|
| 4 | --
|
|---|
| 5 | -- Host: 127.0.0.1
|
|---|
| 6 | -- Generation Time: Apr 22, 2014 alle 23:11
|
|---|
| 7 | -- Versione del server: 5.6.16
|
|---|
| 8 | -- PHP Version: 5.5.9
|
|---|
| 9 |
|
|---|
| 10 | SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|---|
| 11 | SET time_zone = "+00:00";
|
|---|
| 12 |
|
|---|
| 13 |
|
|---|
| 14 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|---|
| 15 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|---|
| 16 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|---|
| 17 | /*!40101 SET NAMES utf8 */;
|
|---|
| 18 |
|
|---|
| 19 | --
|
|---|
| 20 | -- Database: `eleonline`
|
|---|
| 21 | --
|
|---|
| 22 |
|
|---|
| 23 | -- --------------------------------------------------------
|
|---|
| 24 |
|
|---|
| 25 | --
|
|---|
| 26 | -- Struttura della tabella `soraldo_ele_fasce`
|
|---|
| 27 | --
|
|---|
| 28 |
|
|---|
| 29 | CREATE TABLE IF NOT EXISTS `soraldo_ele_fasce` (
|
|---|
| 30 | `id_fascia` int(2) NOT NULL,
|
|---|
| 31 | `abitanti` int(11) NOT NULL,
|
|---|
| 32 | `seggi` int(4) NOT NULL,
|
|---|
| 33 | `id_conf` int(11) DEFAULT '1',
|
|---|
| 34 | KEY `id_fascia` (`id_fascia`)
|
|---|
| 35 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|---|
| 36 |
|
|---|
| 37 | --
|
|---|
| 38 | -- Dump dei dati per la tabella `soraldo_ele_fasce`
|
|---|
| 39 | --
|
|---|
| 40 |
|
|---|
| 41 | INSERT INTO `soraldo_ele_fasce` (`id_fascia`, `abitanti`, `seggi`, `id_conf`) VALUES
|
|---|
| 42 | (1, 3000, 12, 1),
|
|---|
| 43 | (2, 10000, 16, 1),
|
|---|
| 44 | (3, 15000, 20, 1),
|
|---|
| 45 | (4, 30000, 20, 1),
|
|---|
| 46 | (5, 100000, 30, 1),
|
|---|
| 47 | (6, 250000, 40, 1),
|
|---|
| 48 | (7, 500000, 46, 1),
|
|---|
| 49 | (8, 1000000, 50, 1),
|
|---|
| 50 | (9, 100000000, 60, 1),
|
|---|
| 51 | (1, 3000, 12, 2),
|
|---|
| 52 | (2, 10000, 16, 2),
|
|---|
| 53 | (3, 15000, 20, 2),
|
|---|
| 54 | (4, 30000, 20, 2),
|
|---|
| 55 | (5, 100000, 30, 2),
|
|---|
| 56 | (6, 250000, 40, 2),
|
|---|
| 57 | (7, 500000, 46, 2),
|
|---|
| 58 | (8, 1000000, 50, 2),
|
|---|
| 59 | (9, 100000000, 60, 2),
|
|---|
| 60 | (1, 3000, 9, 3),
|
|---|
| 61 | (2, 5000, 9, 3),
|
|---|
| 62 | (4, 15000, 16, 3),
|
|---|
| 63 | (3, 10000, 12, 3),
|
|---|
| 64 | (5, 30000, 16, 3),
|
|---|
| 65 | (6, 100000, 24, 3),
|
|---|
| 66 | (7, 250000, 32, 3),
|
|---|
| 67 | (8, 500000, 36, 3),
|
|---|
| 68 | (9, 1000000, 40, 3),
|
|---|
| 69 | (10, 100000000, 48, 3),
|
|---|
| 70 | (1, 3000, 6, 4),
|
|---|
| 71 | (2, 5000, 7, 4),
|
|---|
| 72 | (3, 10000, 12, 4),
|
|---|
| 73 | (4, 15000, 16, 4),
|
|---|
| 74 | (5, 30000, 16, 4),
|
|---|
| 75 | (6, 100000, 24, 4),
|
|---|
| 76 | (7, 250000, 32, 4),
|
|---|
| 77 | (8, 500000, 36, 4),
|
|---|
| 78 | (9, 1000000, 40, 4),
|
|---|
| 79 | (10, 100000000, 48, 4),
|
|---|
| 80 | (1, 3000, 9, 5),
|
|---|
| 81 | (2, 5000, 9, 5),
|
|---|
| 82 | (3, 10000, 12, 5),
|
|---|
| 83 | (4, 15000, 16, 5),
|
|---|
| 84 | (5, 30000, 16, 5),
|
|---|
| 85 | (6, 100000, 24, 5),
|
|---|
| 86 | (7, 250000, 32, 5),
|
|---|
| 87 | (8, 500000, 36, 5),
|
|---|
| 88 | (9, 1000000, 40, 5),
|
|---|
| 89 | (10, 100000000, 48, 5),
|
|---|
| 90 | (1, 3000, 6, 6),
|
|---|
| 91 | (2, 5000, 7, 6),
|
|---|
| 92 | (3, 10000, 10, 6),
|
|---|
| 93 | (4, 15000, 16, 6),
|
|---|
| 94 | (5, 30000, 16, 6),
|
|---|
| 95 | (6, 100000, 24, 6),
|
|---|
| 96 | (7, 250000, 32, 6),
|
|---|
| 97 | (8, 500000, 36, 6),
|
|---|
| 98 | (9, 1000000, 40, 6),
|
|---|
| 99 | (10, 100000000, 48, 6),
|
|---|
| 100 | (1, 3000, 10, 7),
|
|---|
| 101 | (2, 10000, 12, 7),
|
|---|
| 102 | (3, 15000, 16, 7),
|
|---|
| 103 | (4, 30000, 16, 7),
|
|---|
| 104 | (5, 100000, 24, 7),
|
|---|
| 105 | (6, 250000, 32, 7),
|
|---|
| 106 | (7, 500000, 36, 7),
|
|---|
| 107 | (8, 1000000, 40, 7),
|
|---|
| 108 | (9, 100000000, 48, 7);
|
|---|
| 109 |
|
|---|
| 110 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|---|
| 111 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|---|
| 112 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
