· 6 years ago · Jun 28, 2019, 04:38 AM
1-- MySQL dump 10.13 Distrib 5.7.26, for Linux (x86_64)
2--
3-- Host: localhost Database: tableaudata
4-- ------------------------------------------------------
5-- Server version 5.6.34-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `HOUSING_99A_LIVE_LISTING_COUNT_SUBCITY`
20--
21
22DROP TABLE IF EXISTS `HOUSING_99A_LIVE_LISTING_COUNT_SUBCITY`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `HOUSING_99A_LIVE_LISTING_COUNT_SUBCITY` (
26 `ID` bigint(20) NOT NULL AUTO_INCREMENT,
27 `99_PARENT_CITY` varchar(15) DEFAULT NULL,
28 `TYPE` enum('SUBCITY','LOCALITY','PARENTCITY') DEFAULT NULL COMMENT 'city and locality data identifer',
29 `99_CITY` varchar(50) DEFAULT NULL,
30 `99_LOCALITY` varchar(50) DEFAULT NULL,
31 `99_CITY_ID` int(11) NOT NULL,
32 `99_LOCALITY_ID` int(11) NOT NULL,
33 `HOUSING_CITY` varchar(50) NOT NULL,
34 `HOUSING_LOCALITY` varchar(100) NOT NULL,
35 `HOUSING_CITY_ID` varchar(50) NOT NULL,
36 `HOUSING_LOCALITY_ID` varchar(50) NOT NULL,
37 `RES_COM` char(1) DEFAULT NULL,
38 `PREFERENCE` char(1) DEFAULT NULL,
39 `CLASS` char(1) DEFAULT NULL,
40 `LISTING_COUNT` int(11) DEFAULT NULL,
41 `99_LISTING_COUNT` int(11) NOT NULL,
42 `CRAWLED_DATE` date DEFAULT NULL,
43 `UKEY` varchar(35) DEFAULT NULL COMMENT 'checksum of 99_CITY_ID, 99_LOCALITY_ID,RES_COM, PREFERENCE,CLASS, CRAWLED_DATE to prevent duplicate records',
44 PRIMARY KEY (`ID`),
45 KEY `99_LISTING_COUNT` (`99_LISTING_COUNT`),
46 KEY `LISTING_COUNT` (`LISTING_COUNT`),
47 KEY `CRAWLED_DATE` (`CRAWLED_DATE`),
48 KEY `99_LOCALITY` (`99_LOCALITY`),
49 KEY `99_LOCALITY_ID` (`99_LOCALITY_ID`),
50 KEY `99_CITY_ID` (`99_CITY_ID`),
51 KEY `HOUSING_LOCALITY` (`HOUSING_LOCALITY`),
52 KEY `RES_COM` (`RES_COM`),
53 KEY `PREFERENCE` (`PREFERENCE`),
54 KEY `CLASS` (`CLASS`),
55 KEY `TYPE` (`TYPE`)
56) ENGINE=MyISAM AUTO_INCREMENT=511132 DEFAULT CHARSET=latin1;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping routines for database 'tableaudata'
61--
62/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
63
64/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
65/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
66/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
67/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
68/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
69/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
70/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
71
72-- Dump completed on 2019-06-28 10:04:51