· 8 years ago · Mar 04, 2018, 03:30 AM
1CREATE TABLE `pzreport1_data` (
2 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `chis` int(11) DEFAULT NULL,
4 `ucha` int(11) DEFAULT NULL,
5 `prof` int(11) DEFAULT NULL,
6 `pere` int(11) DEFAULT NULL,
7 `povy` int(11) DEFAULT NULL,
8 `sred` int(11) DEFAULT NULL,
9 `chi1` int(11) DEFAULT NULL,
10 `vtom` int(11) DEFAULT NULL,
11 `chi2` int(11) DEFAULT NULL,
12 `naim` int(11) DEFAULT NULL,
13 `pova` int(11) DEFAULT NULL,
14 `akimat` varchar(2) NOT NULL,
15 UNIQUE KEY `id` (`id`)
16) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
17/*!40101 SET character_set_client = @saved_cs_client */;
18
19--
20-- Dumping data for table `pzreport1_data`
21--
22
23LOCK TABLES `pzreport1_data` WRITE;
24/*!40000 ALTER TABLE `pzreport1_data` DISABLE KEYS */;
25INSERT INTO `pzreport1_data` VALUES (1,1500,0,0,0,0,41,0,170,0,0,0,'a'),(2,2133,24,0,0,24,24,0,4,0,0,0,'b'),(3,4512,1666,1175,300,191,43,1494,356,36,36,0,'c'),(4,1066,38,0,0,38,61,15,51,1,1,0,'d'),(5,1567,0,299,1268,0,40,0,919,305,305,0,'e'),(6,3091,1783,0,1783,0,40,711,0,0,0,0,'f'),(7,2567,89,0,57,32,40,3,2,1,1,0,'g'),(8,1362,698,0,657,41,47,14,29,0,0,0,'h'),(9,904,0,700,172,32,40,0,0,0,0,0,'i'),(10,1644,0,0,0,0,0,0,0,205,205,0,'j'),(11,1166,0,0,0,0,44,0,573,28,28,0,'k'),(12,3593,0,0,0,0,40,0,369,0,0,0,'l'),(13,1062,131,0,131,0,26,65,44,61,61,0,'m'),(14,3073,70,0,30,40,146,9,893,0,0,0,'n'),(15,697,2,0,0,2,40,0,520,2794,2794,0,'o'),(16,8475,1092,492,600,0,38,1090,0,62,62,0,'p');
26/*!40000 ALTER TABLE `pzreport1_data` ENABLE KEYS */;
27UNLOCK TABLES;
28
29--
30-- Table structure for table `pzreport2_data`
31--
32
33DROP TABLE IF EXISTS `pzreport2_data`;
34/*!40101 SET @saved_cs_client = @@character_set_client */;
35/*!40101 SET character_set_client = utf8 */;
36CREATE TABLE `pzreport2_data` (
37 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
38 `akimat` varchar(2) NOT NULL,
39 `chis` int(11) NOT NULL,
40 `kgpm` int(11) NOT NULL,
41 `kgpo` int(11) NOT NULL,
42 `kouc` int(11) NOT NULL,
43 `izse` int(11) NOT NULL,
44 `kore` int(11) NOT NULL,
45 `izza` int(11) NOT NULL,
46 UNIQUE KEY `id` (`id`)
47) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Dumping data for table `pzreport2_data`
52--
53
54LOCK TABLES `pzreport2_data` WRITE;
55/*!40000 ALTER TABLE `pzreport2_data` DISABLE KEYS */;
56INSERT INTO `pzreport2_data` VALUES (1,'a',0,0,0,0,0,0,0),(2,'b',0,0,0,0,0,0,0),(3,'c',0,0,0,0,0,0,0),(4,'d',0,0,150,0,0,0,0),(5,'e',0,0,0,0,0,0,0),(6,'f',0,0,0,0,0,0,0),(7,'g',0,0,0,0,0,0,0),(8,'h',0,0,0,0,0,0,0),(9,'i',0,0,0,0,0,0,0),(10,'j',0,0,0,0,0,0,0),(11,'k',0,0,0,0,0,0,0),(12,'l',0,0,0,0,0,0,0),(13,'m',0,0,0,0,0,0,0),(14,'n',1,0,344,0,0,370,0),(15,'o',0,0,0,0,0,0,0),(16,'p',0,0,0,0,0,0,0);
57/*!40000 ALTER TABLE `pzreport2_data` ENABLE KEYS */;
58UNLOCK TABLES;