forked from rickadviser/RickMorrisonService
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathschema.sql
73 lines (62 loc) · 11.2 KB
/
schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
DROP DATABASE IF EXISTS pricing;
CREATE DATABASE pricing;
USE pricing;
-- CREATE TABLE prices (id SERIAL PRIMARY KEY, bookDate DATE, RoomsAvail BOOLEAN,
-- Priceline NUMBER, Booking NUMBER, Hotels NUMBER, OfficialHotelSite NUMBER, Expedia NUMBER,
-- TripAdvisor NUMBER, Orbitz NUMBER, Hotwire NUMBER, Agoda NUMBER, CheapTickets NUMBER);
-- MySQL dump 10.13 Distrib 5.7.25, for osx10.14 (x86_64)
--
-- Host: localhost Database: TripAdvisor_Locations
-- ------------------------------------------------------
-- Server version 5.7.25
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `hotelpricing`
--
DROP TABLE IF EXISTS `hotelpricing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hotelpricing` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bookDate_old` varchar(20) DEFAULT NULL,
`RoomsAvail` text,
`Priceline` int(11) DEFAULT NULL,
`Booking` int(11) DEFAULT NULL,
`Hotels` int(11) DEFAULT NULL,
`OfficialHotelSite` int(11) DEFAULT NULL,
`Expedia` int(11) DEFAULT NULL,
`TripAdvisor` int(11) DEFAULT NULL,
`Orbitz` int(11) DEFAULT NULL,
`Hotwire` int(11) DEFAULT NULL,
`Agoda` int(11) DEFAULT NULL,
`CheapTickets` int(11) DEFAULT NULL,
`bookDate` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `hotelpricing`
--
LOCK TABLES `hotelpricing` WRITE;
/*!40000 ALTER TABLE `hotelpricing` DISABLE KEYS */;
INSERT INTO `hotelpricing` VALUES (0,'3-29-2019','TRUE',163,167,174,146,190,178,183,179,190,183,'2019-03-29 00:00:00'),(1,'4-1-2019','TRUE',163,167,174,146,190,178,183,179,190,183,'2019-04-01 00:00:00'),(2,'4-2-2019','TRUE',163,166,174,146,190,180,182,181,190,182,'2019-04-02 00:00:00'),(3,'4-3-2019','TRUE',167,168,167,146,188,167,188,181,189,188,'2019-04-03 00:00:00'),(4,'4-4-2019','TRUE',170,167,175,146,179,166,184,181,188,184,'2019-04-04 00:00:00'),(5,'4-5-2019','TRUE',171,169,178,148,181,168,179,181,181,187,'2019-04-05 00:00:00'),(6,'4-6-2019','TRUE',168,163,180,148,181,167,181,181,185,183,'2019-04-06 00:00:00'),(7,'4-7-2019','TRUE',164,163,167,160,181,169,181,181,185,183,'2019-04-07 00:00:00'),(8,'4-8-2019','TRUE',166,167,166,160,181,163,181,190,179,182,'2019-04-08 00:00:00'),(9,'4-9-2019','TRUE',166,170,168,158,181,163,181,190,190,188,'2019-04-09 00:00:00'),(10,'4-10-2019','TRUE',171,171,167,149,181,167,181,189,190,184,'2019-04-10 00:00:00'),(11,'4-11-2019','TRUE',180,168,169,152,190,170,181,188,188,179,'2019-04-11 00:00:00'),(12,'4-12-2019','TRUE',180,164,163,155,190,171,190,181,189,187,'2019-04-12 00:00:00'),(13,'4-13-2019','TRUE',167,166,163,152,189,168,190,185,187,183,'2019-04-13 00:00:00'),(14,'4-14-2019','TRUE',175,166,167,163,188,164,189,185,183,183,'2019-04-14 00:00:00'),(15,'4-15-2019','TRUE',174,171,170,162,181,166,188,179,183,182,'2019-04-15 00:00:00'),(16,'4-16-2019','TRUE',174,180,171,158,185,166,181,190,182,188,'2019-04-16 00:00:00'),(17,'4-17-2019','TRUE',167,180,168,155,185,171,185,190,188,184,'2019-04-17 00:00:00'),(18,'4-18-2019','TRUE',175,167,164,160,179,180,185,188,187,179,'2019-04-18 00:00:00'),(19,'4-19-2019','TRUE',178,175,166,159,190,180,179,179,183,181,'2019-04-19 00:00:00'),(20,'4-20-2019','FALSE',180,174,166,149,190,167,190,181,183,189,'2019-04-20 00:00:00'),(21,'4-21-2019','TRUE',167,174,171,148,188,175,190,181,182,188,'2019-04-21 00:00:00'),(22,'4-22-2019','TRUE',166,167,180,149,189,174,188,181,188,181,'2019-04-22 00:00:00'),(23,'4-23-2019','FALSE',171,175,180,146,187,174,189,181,184,185,'2019-04-23 00:00:00'),(24,'4-24-2019','TRUE',168,178,167,146,183,167,187,181,179,185,'2019-04-24 00:00:00'),(25,'4-25-2019','TRUE',164,180,175,148,183,175,183,181,188,179,'2019-04-25 00:00:00'),(26,'4-26-2019','TRUE',166,167,174,148,182,178,183,190,189,190,'2019-04-26 00:00:00'),(27,'4-27-2019','TRUE',166,166,174,160,188,180,182,190,187,190,'2019-04-27 00:00:00'),(28,'4-28-2019','FALSE',171,168,167,160,184,167,188,189,183,188,'2019-04-28 00:00:00'),(29,'4-29-2019','FALSE',180,167,175,158,179,166,184,188,183,189,'2019-04-29 00:00:00'),(30,'4-30-2019','TRUE',180,169,178,149,181,168,179,181,182,187,'2019-04-30 00:00:00'),(31,'5-1-2019','TRUE',167,163,180,152,181,167,181,185,188,183,'2019-05-01 00:00:00'),(32,'5-2-2019','TRUE',175,163,167,155,181,169,181,185,187,183,'2019-05-02 00:00:00'),(33,'5-3-2019','TRUE',174,167,166,152,181,163,181,179,183,182,'2019-05-03 00:00:00'),(34,'5-4-2019','TRUE',174,170,168,163,181,163,181,190,183,188,'2019-05-04 00:00:00'),(35,'5-5-2019','TRUE',167,171,167,162,181,167,181,190,182,184,'2019-05-05 00:00:00'),(36,'5-6-2019','TRUE',175,168,169,158,190,170,181,188,188,187,'2019-05-06 00:00:00'),(37,'5-7-2019','FALSE',178,164,163,155,190,171,190,189,189,183,'2019-05-07 00:00:00'),(38,'5-8-2019','TRUE',180,166,163,160,189,164,190,187,187,183,'2019-05-08 00:00:00'),(39,'5-9-2019','TRUE',167,166,167,159,188,166,189,183,183,182,'2019-05-09 00:00:00'),(40,'5-10-2019','FALSE',166,171,170,149,181,166,188,183,183,188,'2019-05-10 00:00:00'),(41,'5-11-2019','TRUE',168,180,171,148,185,171,181,182,182,183,'2019-05-11 00:00:00'),(42,'5-12-2019','TRUE',167,180,164,149,185,180,185,188,188,183,'2019-05-12 00:00:00'),(43,'5-13-2019','TRUE',169,167,166,146,179,180,185,184,187,182,'2019-05-13 00:00:00'),(44,'5-14-2019','TRUE',163,175,166,158,190,167,179,179,183,188,'2019-05-14 00:00:00'),(45,'5-15-2019','FALSE',163,174,171,155,190,175,190,181,183,184,'2019-05-15 00:00:00'),(46,'5-16-2019','FALSE',167,174,180,160,188,174,190,181,182,179,'2019-05-16 00:00:00'),(47,'5-17-2019','TRUE',170,167,180,159,189,174,188,181,188,187,'2019-05-17 00:00:00'),(48,'5-18-2019','TRUE',171,175,167,149,187,164,189,181,184,183,'2019-05-18 00:00:00'),(49,'5-19-2019','TRUE',168,178,175,148,179,166,187,181,179,183,'2019-05-19 00:00:00'),(50,'5-20-2019','TRUE',164,180,174,149,190,166,183,181,181,182,'2019-05-20 00:00:00'),(51,'5-21-2019','TRUE',166,167,174,146,190,171,183,190,181,188,'2019-05-21 00:00:00'),(52,'5-22-2019','TRUE',166,166,164,146,188,180,182,190,185,184,'2019-05-22 00:00:00'),(53,'5-23-2019','TRUE',171,168,166,148,189,180,188,189,185,179,'2019-05-23 00:00:00'),(54,'5-24-2019','FALSE',180,167,166,148,187,167,184,188,179,183,'2019-05-24 00:00:00'),(55,'5-25-2019','TRUE',180,169,171,160,183,175,179,181,190,183,'2019-05-25 00:00:00'),(56,'5-26-2019','TRUE',167,163,180,160,183,174,181,185,190,182,'2019-05-26 00:00:00'),(57,'5-27-2019','FALSE',175,163,180,158,182,174,181,185,188,188,'2019-05-27 00:00:00'),(58,'5-28-2019','TRUE',174,167,167,149,188,167,181,179,189,184,'2019-05-28 00:00:00'),(59,'5-29-2019','TRUE',174,170,175,152,184,175,181,190,187,179,'2019-05-29 00:00:00'),(60,'5-30-2019','TRUE',167,171,174,155,179,178,181,190,183,187,'2019-05-30 00:00:00'),(61,'5-31-2019','TRUE',175,168,174,152,181,180,181,188,183,183,'2019-05-31 00:00:00'),(62,'6-1-2019','FALSE',178,164,167,163,181,167,190,189,182,183,'2019-06-01 00:00:00'),(63,'6-2-2019','FALSE',166,166,175,162,181,166,190,187,188,182,'2019-06-02 00:00:00'),(64,'6-3-2019','TRUE',168,166,178,158,181,168,189,183,184,188,'2019-06-03 00:00:00'),(65,'6-4-2019','TRUE',167,171,180,160,181,167,188,183,187,184,'2019-06-04 00:00:00'),(66,'6-5-2019','TRUE',169,180,167,160,181,167,181,182,183,179,'2019-06-05 00:00:00'),(67,'6-6-2019','TRUE',163,180,166,158,190,166,185,188,183,184,'2019-06-06 00:00:00'),(68,'6-7-2019','TRUE',163,167,168,149,190,168,185,184,182,179,'2019-06-07 00:00:00'),(69,'6-8-2019','TRUE',167,175,167,152,189,167,179,179,188,187,'2019-06-08 00:00:00'),(70,'6-9-2019','TRUE',170,174,167,155,188,169,190,181,184,183,'2019-06-09 00:00:00'),(71,'6-10-2019','FALSE',171,174,166,160,181,163,190,181,179,183,'2019-06-10 00:00:00'),(72,'6-11-2019','TRUE',168,167,168,158,185,163,188,181,187,182,'2019-06-11 00:00:00'),(73,'6-12-2019','TRUE',164,175,167,155,185,167,189,181,183,188,'2019-06-12 00:00:00'),(74,'6-13-2019','FALSE',166,178,169,160,179,170,187,181,183,184,'2019-06-13 00:00:00'),(75,'6-14-2019','TRUE',166,180,163,159,190,171,183,181,182,179,'2019-06-14 00:00:00'),(76,'6-15-2019','TRUE',177,167,163,149,190,168,183,190,188,181,'2019-06-15 00:00:00'),(77,'6-16-2019','TRUE',171,166,167,148,188,164,182,190,184,189,'2019-06-16 00:00:00'),(78,'6-17-2019','TRUE',168,168,170,149,189,166,188,189,179,188,'2019-06-17 00:00:00'),(79,'6-18-2019','FALSE',164,167,171,146,187,166,184,188,181,181,'2019-06-18 00:00:00'),(80,'6-19-2019','FALSE',166,169,168,146,183,171,179,181,189,185,'2019-06-19 00:00:00'),(81,'6-20-2019','TRUE',166,163,164,148,183,180,181,185,188,185,'2019-06-20 00:00:00'),(82,'6-21-2019','TRUE',171,163,166,148,182,180,181,185,181,179,'2019-06-21 00:00:00'),(83,'6-22-2019','TRUE',180,167,166,160,188,170,181,179,185,190,'2019-06-22 00:00:00'),(84,'6-23-2019','TRUE',180,170,171,160,184,171,181,190,185,190,'2019-06-23 00:00:00'),(85,'6-24-2019','TRUE',167,171,180,158,179,168,181,190,179,188,'2019-06-24 00:00:00'),(86,'6-25-2019','TRUE',175,168,180,149,181,164,181,188,190,189,'2019-06-25 00:00:00'),(87,'6-26-2019','TRUE',174,164,167,152,181,166,190,189,190,187,'2019-06-26 00:00:00'),(88,'6-27-2019','FALSE',174,166,175,155,181,166,190,187,188,183,'2019-06-27 00:00:00'),(89,'6-28-2019','TRUE',167,166,174,152,181,171,189,183,189,183,'2019-06-28 00:00:00'),(90,'6-29-2019','TRUE',175,171,174,163,181,180,188,183,187,182,'2019-06-29 00:00:00'),(91,'6-30-2019','FALSE',178,180,167,162,181,180,181,182,183,188,'2019-06-30 00:00:00'),(92,'7-1-2019','TRUE',180,180,175,158,190,167,185,188,183,184,'2019-07-01 00:00:00'),(93,'7-2-2019','TRUE',167,167,178,159,190,175,185,184,182,187,'2019-07-02 00:00:00'),(94,'7-3-2019','TRUE',166,175,180,152,189,174,179,179,188,183,'2019-07-03 00:00:00'),(95,'7-4-2019','TRUE',168,174,167,151,188,174,190,181,184,183,'2019-07-04 00:00:00'),(96,'7-5-2019','FALSE',167,174,166,147,181,167,190,181,187,182,'2019-07-05 00:00:00'),(97,'7-6-2019','FALSE',169,167,168,148,185,175,188,181,183,183,'2019-07-06 00:00:00'),(98,'7-7-2019','TRUE',163,175,167,149,185,178,189,181,183,183,'2019-07-07 00:00:00'),(99,'7-8-2019','TRUE',163,178,169,160,179,180,187,181,182,182,'2019-07-08 00:00:00'),(100,'7-9-2019','TRUE',167,180,163,160,190,167,183,181,188,188,'2019-07-09 00:00:00');
/*!40000 ALTER TABLE `hotelpricing` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-03-28 14:34:34