DevTestersmk

no_such_table_paste

Jan 22nd, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. DROP TABLE IF EXISTS `AAAA`;
  2. /*!40101 SET @saved_cs_client = @@character_set_client */;
  3. /*!40101 SET character_set_client = utf8 */;
  4. CREATE 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`) 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.  
  37. LOCK TABLES `AAAA` WRITE;
  38. /*!40000 ALTER TABLE `AAAA` DISABLE KEYS */;
  39. /*!40000 ALTER TABLE `AAAA` ENABLE KEYS */;
  40. UNLOCK TABLES;
Add Comment
Please, Sign In to add comment