WLCSvv7f

1DROP TABLE IF EXISTS `AAAA`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `AAAA` (
5  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'PK.',
6  `aaaa` bigint(10) NOT NULL COMMENT 'Fk. Some Comment',
7  `bbbb` bigint(10) DEFAULT NULL,
8  `cccc` varchar(20) DEFAULT NULL COMMENT 'Some Comment',
9  `dddd` varchar(400) NOT NULL COMMENT 'Some Comment',
10  `eeee` varchar(400) DEFAULT NULL COMMENT 'Some Comment',
11  `ffff` varchar(255) DEFAULT NULL COMMENT 'Some Comment',
12  `gggg` varchar(255) DEFAULT NULL COMMENT 'Some Comment',
13  `hhhh` varchar(255) DEFAULT NULL COMMENT 'Some Comment',
14  `iiii` varchar(10) NOT NULL COMMENT 'Some Comment',
15  `jjjj` varchar(10) NOT NULL COMMENT 'Some Comment',
16  `kkkk` varchar(10) NOT NULL COMMENT 'Some Comment',
17  `llll` varchar(10) NOT NULL COMMENT 'Some Comment',
18  `mmmm` bigint(20) DEFAULT NULL COMMENT 'Some Comment',
19  `nnnn` bigint(20) DEFAULT NULL COMMENT 'Some Comment',
20  `oooo` bigint(10) DEFAULT NULL COMMENT 'FK. Some Comment',
21  `pppp` varchar(255) DEFAULT NULL COMMENT 'Filter value. Some Comment',
22  `qqqq` varchar(999) DEFAULT NULL COMMENT 'Comment. Some Comment',
23  `rrrr` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created date',
24  `ssss` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modified Date. Some Comment',
25  `tttt` varchar(1) DEFAULT 'A' COMMENT 'Some Comment',
26  PRIMARY KEY (`id`),
27  UNIQUE KEY `aaaa_pk` (`id`) COMMENT 'PK Index',
28  KEY `bbbb_fk` (`bbbb`) USING BTREE COMMENT 'Index for FK, Reference Category',
29  CONSTRAINT `bbbb_fk` FOREIGN KEY (`bbbb`) REFERENCES `category` (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `AAAA`
35--
36
37LOCK TABLES `AAAA` WRITE;
38/*!40000 ALTER TABLE `AAAA` DISABLE KEYS */;
39/*!40000 ALTER TABLE `AAAA` ENABLE KEYS */;
40UNLOCK TABLES;