· 9 years ago · Dec 18, 2016, 10:12 AM
1--
2-- Table structure for table `myTable`
3--
4
5DROP TABLE IF EXISTS `myTable`;
6/*!40101 SET @saved_cs_client = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `myTable` (
9 `id` varchar(36) NOT NULL,
10 `name` varchar(64) NOT NULL,
11 `desc` text,
12 `q` text NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15/*!40101 SET character_set_client = @saved_cs_client */;
16
17--
18-- Dumping data for table `myTable`
19--
20
21LOCK TABLES `myTable` WRITE;
22/*!40000 ALTER TABLE `myTable` DISABLE KEYS */;
23/*!40000 ALTER TABLE `myTable` ENABLE KEYS */;
24UNLOCK TABLES;