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.