forked from rickadviser/RickMorrisonService
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhotelPricing.sql
69 lines (59 loc) · 10.9 KB
/
hotelPricing.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
-- -- 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 DATABASE IF EXISTS pricing;
-- CREATE DATABASE pricing;
-- USE pricing;
-- 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 (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