jAzhMGT5

1-- MySQL dump 10.16  Distrib 10.1.19-MariaDB, for Win32 (AMD64)
2--
3-- Host: api.metamug.com    Database: api.metamug.com
4-- ------------------------------------------------------
5-- Server version	5.6.33-0ubuntu0.14.04.1-log
6--
7-- Table structure for table `movie`
8--
9
10DROP TABLE IF EXISTS `movie`;
11/*!40101 SET @saved_cs_client     = @@character_set_client */;
12/*!40101 SET character_set_client = utf8 */;
13CREATE TABLE `movie` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `name` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
16  `rating` decimal(2,1) NOT NULL,
17  `releaseDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
18  PRIMARY KEY (`id`),
19  KEY `name` (`name`(191))
20) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
21/*!40101 SET character_set_client = @saved_cs_client */;
22
23--
24-- Dumping data for table `movie`
25--
26
27LOCK TABLES `movie` WRITE;
28/*!40000 ALTER TABLE `movie` DISABLE KEYS */;
29INSERT INTO `movie` VALUES (1,'Reader',3.1,'2017-01-27 15:34:22'),(2,'The Dark Knight',5.0,'2017-01-27 15:34:22'),(3,'The Happening',4.0,'2017-01-27 15:34:22'),(4,'hi there;',5.5,'2016-01-05 00:00:00');
30/*!40000 ALTER TABLE `movie` ENABLE KEYS */;
31UNLOCK TABLES;
32
33
34-- Dump completed on 2017-02-03  3:26:46