source: trunk/sql/aggiornamento-2.0_2011-04-16.sql@ 307

Last change on this file since 307 was 155, checked in by luciano, 12 years ago
  • Property svn:executable set to *
File size: 3.4 KB
Line 
1--
2-- MySQL dump 10.10
3--
4-- Host: localhost Database: eleonline2
5-- ------------------------------------------------------
6-- Server version 5.0.19-standard
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8 */;
12/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13/*!40103 SET TIME_ZONE='+00:00' */;
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18
19
20-- MySQL dump 10.11
21--
22-- Host: localhost Database: elefonte
23-- ------------------------------------------------------
24-- Server version 5.0.51a-3ubuntu5.4
25
26/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
27/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
28/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
29/*!40101 SET NAMES utf8 */;
30/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
31/*!40103 SET TIME_ZONE='+00:00' */;
32/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
33/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
34/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
35/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
36
37--
38-- Table structure for table `soraldo_ele_fasce`
39--
40
41DROP TABLE IF EXISTS `soraldo_ele_fasce`;
42SET @saved_cs_client = @@character_set_client;
43SET character_set_client = utf8;
44CREATE TABLE `soraldo_ele_fasce` (
45 `id_fascia` int(2) NOT NULL,
46 `abitanti` int(11) NOT NULL,
47 `data_inizio` date NOT NULL,
48 `data_fine` date NOT NULL,
49 `seggi` int(4) NOT NULL,
50 KEY `id_fascia` (`id_fascia`)
51) ENGINE=MyISAM DEFAULT CHARSET=latin1;
52SET character_set_client = @saved_cs_client;
53
54--
55-- Dumping data for table `soraldo_ele_fasce`
56--
57
58LOCK TABLES `soraldo_ele_fasce` WRITE;
59/*!40000 ALTER TABLE `soraldo_ele_fasce` DISABLE KEYS */;
60INSERT INTO `soraldo_ele_fasce` VALUES (1,3000,'2000-01-01','2010-12-31',12),(2,10000,'2000-01-01','2010-12-31',16),(3,15000,'2000-01-01','2010-12-31',20),(4,30000,'2000-01-01','2010-12-31',20),(5,100000,'2000-01-01','2010-12-31',30),(6,250000,'2000-01-01','2010-12-31',40),(7,500000,'2000-01-01','2010-12-31',46),(8,1000000,'2000-01-01','2010-12-31',50),(9,100000000,'2000-01-01','2010-12-31',60),(4,30000,'2011-01-01','0000-00-00',16),(1,3000,'2011-01-01','0000-00-00',9),(2,10000,'2011-01-01','0000-00-00',12),(3,15000,'2011-01-01','0000-00-00',16),(5,100000,'2011-01-01','0000-00-00',24),(6,250000,'2011-01-01','0000-00-00',32),(7,500000,'2011-01-01','0000-00-00',36),(8,1000000,'2011-01-01','0000-00-00',40),(9,100000000,'2011-01-01','0000-00-00',48);
61/*!40000 ALTER TABLE `soraldo_ele_fasce` ENABLE KEYS */;
62UNLOCK TABLES;
63/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
64
65/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
66/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
67/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
68/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
69/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
70/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
71/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
72
73-- Dump completed on 2011-04-16 9:33:30
Note: See TracBrowser for help on using the repository browser.