Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS `AAAA`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `AAAA` (
- `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'PK.',
- `aaaa` bigint(10) NOT NULL COMMENT 'Fk. Some Comment',
- `bbbb` bigint(10) DEFAULT NULL,
- `cccc` varchar(20) DEFAULT NULL COMMENT 'Some Comment',
- `dddd` varchar(400) NOT NULL COMMENT 'Some Comment',
- `eeee` varchar(400) DEFAULT NULL COMMENT 'Some Comment',
- `ffff` varchar(255) DEFAULT NULL COMMENT 'Some Comment',
- `gggg` varchar(255) DEFAULT NULL COMMENT 'Some Comment',
- `hhhh` varchar(255) DEFAULT NULL COMMENT 'Some Comment',
- `iiii` varchar(10) NOT NULL COMMENT 'Some Comment',
- `jjjj` varchar(10) NOT NULL COMMENT 'Some Comment',
- `kkkk` varchar(10) NOT NULL COMMENT 'Some Comment',
- `llll` varchar(10) NOT NULL COMMENT 'Some Comment',
- `mmmm` bigint(20) DEFAULT NULL COMMENT 'Some Comment',
- `nnnn` bigint(20) DEFAULT NULL COMMENT 'Some Comment',
- `oooo` bigint(10) DEFAULT NULL COMMENT 'FK. Some Comment',
- `pppp` varchar(255) DEFAULT NULL COMMENT 'Filter value. Some Comment',
- `qqqq` varchar(999) DEFAULT NULL COMMENT 'Comment. Some Comment',
- `rrrr` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created date',
- `ssss` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modified Date. Some Comment',
- `tttt` varchar(1) DEFAULT 'A' COMMENT 'Some Comment',
- PRIMARY KEY (`id`),
- UNIQUE KEY `aaaa_pk` (`id`) COMMENT 'PK Index',
- KEY `bbbb_fk` (`bbbb`) COMMENT 'Index for FK, Reference Category',
- CONSTRAINT `bbbb_fk` FOREIGN KEY (`bbbb`) REFERENCES `category` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `AAAA`
- --
- LOCK TABLES `AAAA` WRITE;
- /*!40000 ALTER TABLE `AAAA` DISABLE KEYS */;
- /*!40000 ALTER TABLE `AAAA` ENABLE KEYS */;
- UNLOCK TABLES;
Add Comment
Please, Sign In to add comment