PageRenderTime 43ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/tests/resources/sql/mysql/contentbox.sql

https://github.com/Ortus-Solutions/ContentBox
SQL | 468 lines | 397 code | 71 blank | 0 comment | 0 complexity | 28dca88e61aa1b6be6c146ce68048c6f MD5 | raw file
  1. # ************************************************************
  2. # Sequel Ace SQL dump
  3. # Version 20025
  4. #
  5. # https://sequel-ace.com/
  6. # https://github.com/Sequel-Ace/Sequel-Ace
  7. #
  8. # Host: 127.0.0.1 (MySQL 5.7.22)
  9. # Database: contentbox
  10. # Generation Time: 2022-02-18 20:12:42 +0000
  11. # ************************************************************
  12. USE `contentbox`;
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. SET NAMES utf8mb4;
  17. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  18. /*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  19. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  20. # Dump of table cb_author
  21. # ------------------------------------------------------------
  22. DROP TABLE IF EXISTS `cb_author`;
  23. CREATE TABLE `cb_author` (
  24. `firstName` varchar(100) NOT NULL,
  25. `lastName` varchar(100) NOT NULL,
  26. `email` varchar(255) NOT NULL,
  27. `username` varchar(100) NOT NULL,
  28. `password` varchar(100) NOT NULL,
  29. `isActive` bit(1) NOT NULL DEFAULT b'1',
  30. `lastLogin` datetime DEFAULT NULL,
  31. `createdDate` datetime NOT NULL,
  32. `biography` longtext,
  33. `preferences` longtext,
  34. `modifiedDate` datetime NOT NULL,
  35. `isDeleted` bit(1) NOT NULL DEFAULT b'0',
  36. `isPasswordReset` bit(1) NOT NULL DEFAULT b'0',
  37. `is2FactorAuth` bit(1) NOT NULL DEFAULT b'0',
  38. `authorID` char(36) CHARACTER SET utf8 NOT NULL,
  39. `FK_roleID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  40. PRIMARY KEY (`authorID`),
  41. UNIQUE KEY `username` (`username`),
  42. UNIQUE KEY `id` (`authorID`),
  43. UNIQUE KEY `authorID` (`authorID`),
  44. KEY `idx_active` (`isActive`),
  45. KEY `idx_email` (`email`),
  46. KEY `idx_login` (`username`,`password`,`isActive`),
  47. KEY `idx_activeAuthor` (`isActive`),
  48. KEY `idx_deleted` (`isDeleted`),
  49. KEY `idx_passwordReset` (`isPasswordReset`),
  50. KEY `idx_2factorauth` (`is2FactorAuth`),
  51. KEY `fk_cb_author_FK_roleID` (`FK_roleID`),
  52. CONSTRAINT `fk_cb_author_FK_roleID` FOREIGN KEY (`FK_roleID`) REFERENCES `cb_role` (`roleID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  53. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  54. LOCK TABLES `cb_author` WRITE;
  55. /*!40000 ALTER TABLE `cb_author` DISABLE KEYS */;
  56. INSERT INTO `cb_author` (`firstName`, `lastName`, `email`, `username`, `password`, `isActive`, `lastLogin`, `createdDate`, `biography`, `preferences`, `modifiedDate`, `isDeleted`, `isPasswordReset`, `is2FactorAuth`, `authorID`, `FK_roleID`)
  57. VALUES
  58. ('Luis','Majano','lmajano@gmail.com','lmajano','$2a$12$KU4n4ZQf3cd/ULCuvc8PIO9VrQKi7eKbcEuQaILTJ/sdcjXvT31YK',b'1','2021-02-18 17:54:10','2013-07-11 11:06:39','','{\"sidemenuCollapse\":\"yes\",\"linkedin\":\"\",\"sidebarState\":\"yes\",\"markup\":\"HTML\",\"website\":\"\",\"editor\":\"ckeditor\",\"twitter\":\"http://twitter.com/lmajano\",\"facebook\":\"http://facebook.com/lmajano\"}','2021-02-18 17:54:10',b'0',b'0',b'0','77abddba-a444-11eb-ab6f-0290cc502ae3','77c2c62e-a444-11eb-ab6f-0290cc502ae3'),
  59. ('Lui','Majano','lmajano@ortussolutions.com','luismajano','$2a$12$KU4n4ZQf3cd/ULCuvc8PIO9VrQKi7eKbcEuQaILTJ/sdcjXvT31YK',b'1','2015-07-29 14:38:46','2013-07-11 11:07:23','','{\"GOOGLE\":\"\",\"EDITOR\":\"ckeditor\",\"TWITTER\":\"http:\\/\\/twitter.com\\/lmajano\",\"FACEBOOK\":\"http:\\/\\/facebook.com\\/lmajano\"}','2017-06-21 18:29:30',b'0',b'0',b'0','77abdf9a-a444-11eb-ab6f-0290cc502ae3','77c2c62e-a444-11eb-ab6f-0290cc502ae3'),
  60. ('Tester','Majano','lmajano@testing.com','testermajano','$2a$12$FE058d9bj7Sv6tPmvZMaleC2x8.b.tRqVei5p/5XqPytSNpF5eCym',b'1','2017-07-06 12:13:14','2013-07-11 11:07:23','','{\"sidemenuCollapse\":\"no\",\"google\":\"\",\"sidebarState\":\"true\",\"markup\":\"HTML\",\"editor\":\"ckeditor\",\"twitter\":\"http://twitter.com/lmajano\",\"facebook\":\"http://facebook.com/lmajano\"}','2017-07-18 15:22:13',b'0',b'1',b'1','77abe0a8-a444-11eb-ab6f-0290cc502ae3','77c2c476-a444-11eb-ab6f-0290cc502ae3'),
  61. ('Joe','Joe','joejoe@joe.com','joejoe','$2a$12$.FrcqDLb3DNIK2TqJo0aQuwB3WSxAW0KmJUKKPaAQV7VoYwihDM1.',b'1','2017-07-06 11:38:28','2017-07-06 11:30:59','','{\"linkedin\":\"\",\"markup\":\"HTML\",\"website\":\"\",\"editor\":\"ckeditor\",\"twitter\":\"\",\"facebook\":\"\"}','2017-07-06 11:54:11',b'0',b'1',b'1','77abe166-a444-11eb-ab6f-0290cc502ae3','77c2c62e-a444-11eb-ab6f-0290cc502ae3'),
  62. ('Jorge','Morelos','joremorelos@morelos.com','joremorelos@morelos.com','$2a$12$IBAYihdRG.Hj8fh/fztmi.MvFRn2lPxk4Thw1mnmbVzjoLnNCgzOe',b'0',NULL,'2017-07-06 12:07:02','','{\"linkedin\":\"\",\"markup\":\"HTML\",\"website\":\"\",\"editor\":\"ckeditor\",\"twitter\":\"\",\"facebook\":\"\"}','2017-07-19 17:01:18',b'0',b'1',b'0','77abe206-a444-11eb-ab6f-0290cc502ae3','77c2c62e-a444-11eb-ab6f-0290cc502ae3');
  63. /*!40000 ALTER TABLE `cb_author` ENABLE KEYS */;
  64. UNLOCK TABLES;
  65. # Dump of table cb_authorPermissionGroups
  66. # ------------------------------------------------------------
  67. DROP TABLE IF EXISTS `cb_authorPermissionGroups`;
  68. CREATE TABLE `cb_authorPermissionGroups` (
  69. `FK_permissionGroupID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  70. `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  71. KEY `fk_cb_authorPermissionGroups_FK_permissionGroupID` (`FK_permissionGroupID`),
  72. KEY `fk_cb_authorPermissionGroups_FK_authorID` (`FK_authorID`),
  73. CONSTRAINT `fk_cb_authorPermissionGroups_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  74. CONSTRAINT `fk_cb_authorPermissionGroups_FK_permissionGroupID` FOREIGN KEY (`FK_permissionGroupID`) REFERENCES `cb_permissionGroup` (`permissionGroupID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  75. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  76. LOCK TABLES `cb_authorPermissionGroups` WRITE;
  77. /*!40000 ALTER TABLE `cb_authorPermissionGroups` DISABLE KEYS */;
  78. INSERT INTO `cb_authorPermissionGroups` (`FK_permissionGroupID`, `FK_authorID`)
  79. VALUES
  80. ('7850efee-a444-11eb-ab6f-0290cc502ae3','77abe166-a444-11eb-ab6f-0290cc502ae3'),
  81. ('7850efee-a444-11eb-ab6f-0290cc502ae3','77abe206-a444-11eb-ab6f-0290cc502ae3'),
  82. ('7850f138-a444-11eb-ab6f-0290cc502ae3','77abe206-a444-11eb-ab6f-0290cc502ae3');
  83. /*!40000 ALTER TABLE `cb_authorPermissionGroups` ENABLE KEYS */;
  84. UNLOCK TABLES;
  85. # Dump of table cb_authorPermissions
  86. # ------------------------------------------------------------
  87. DROP TABLE IF EXISTS `cb_authorPermissions`;
  88. CREATE TABLE `cb_authorPermissions` (
  89. `FK_permissionID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  90. `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  91. KEY `fk_cb_authorPermissions_FK_permissionID` (`FK_permissionID`),
  92. KEY `fk_cb_authorPermissions_FK_authorID` (`FK_authorID`),
  93. CONSTRAINT `fk_cb_authorPermissions_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  94. CONSTRAINT `fk_cb_authorPermissions_FK_permissionID` FOREIGN KEY (`FK_permissionID`) REFERENCES `cb_permission` (`permissionID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  95. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  96. LOCK TABLES `cb_authorPermissions` WRITE;
  97. /*!40000 ALTER TABLE `cb_authorPermissions` DISABLE KEYS */;
  98. INSERT INTO `cb_authorPermissions` (`FK_permissionID`, `FK_authorID`)
  99. VALUES
  100. ('785d8182-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
  101. ('785d8574-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
  102. ('785d8420-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
  103. ('785d83b2-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
  104. ('785d8344-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
  105. ('785d84fc-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3');
  106. /*!40000 ALTER TABLE `cb_authorPermissions` ENABLE KEYS */;
  107. UNLOCK TABLES;
  108. # Dump of table cb_category
  109. # ------------------------------------------------------------
  110. DROP TABLE IF EXISTS `cb_category`;
  111. CREATE TABLE `cb_category` (
  112. `category` varchar(200) NOT NULL,
  113. `slug` varchar(200) NOT NULL,
  114. `createdDate` datetime NOT NULL,
  115. `modifiedDate` datetime NOT NULL,
  116. `isDeleted` bit(1) NOT NULL DEFAULT b'0',
  117. `categoryID` char(36) CHARACTER SET utf8 NOT NULL,
  118. `FK_siteID` varchar(36) NOT NULL DEFAULT '',
  119. `isPublic` bit(1) NOT NULL,
  120. PRIMARY KEY (`categoryID`),
  121. UNIQUE KEY `id` (`categoryID`),
  122. UNIQUE KEY `categoryID` (`categoryID`),
  123. KEY `idx_slug` (`slug`),
  124. KEY `idx_categorySlug` (`slug`),
  125. KEY `idx_deleted` (`isDeleted`),
  126. KEY `idx_categoryName` (`category`),
  127. KEY `FK_siteID` (`FK_siteID`),
  128. KEY `idx_isPublic` (`isPublic`),
  129. CONSTRAINT `cb_category_ibfk_1` FOREIGN KEY (`FK_siteID`) REFERENCES `cb_site` (`siteID`) ON DELETE CASCADE ON UPDATE CASCADE
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  131. LOCK TABLES `cb_category` WRITE;
  132. /*!40000 ALTER TABLE `cb_category` DISABLE KEYS */;
  133. INSERT INTO `cb_category` (`category`, `slug`, `createdDate`, `modifiedDate`, `isDeleted`, `categoryID`, `FK_siteID`, `isPublic`)
  134. VALUES
  135. ('General','general','2016-05-03 16:23:25','2016-05-03 16:23:25',b'0','16B64400-E17B-477C-B0A0C59764CB85F8','1c81d376-a481-11eb-ab6f-0290cc502ae3',b'0'),
  136. ('ColdFusion','coldfusion','2016-05-03 16:23:25','2016-05-03 16:23:25',b'0','786a9660-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3',b'1'),
  137. ('ContentBox','contentbox','2016-05-03 16:23:25','2016-05-03 16:23:25',b'0','786a97f0-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3',b'1'),
  138. ('coldbox','coldbox','2016-05-03 16:23:25','2016-05-03 16:23:25',b'0','786a98cc-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3',b'1'),
  139. ('News','news','2016-05-03 16:23:25','2016-05-03 16:23:25',b'0','A657752D-79AC-42CB-B7A9572AB7B329A1','1c81d376-a481-11eb-ab6f-0290cc502ae3',b'0');
  140. /*!40000 ALTER TABLE `cb_category` ENABLE KEYS */;
  141. UNLOCK TABLES;
  142. # Dump of table cb_comment
  143. # ------------------------------------------------------------
  144. DROP TABLE IF EXISTS `cb_comment`;
  145. CREATE TABLE `cb_comment` (
  146. `content` longtext NOT NULL,
  147. `author` varchar(100) NOT NULL,
  148. `authorIP` varchar(100) NOT NULL,
  149. `authorEmail` varchar(255) NOT NULL,
  150. `authorURL` varchar(255) DEFAULT NULL,
  151. `createdDate` datetime NOT NULL,
  152. `isApproved` bit(1) NOT NULL DEFAULT b'0',
  153. `modifiedDate` datetime NOT NULL,
  154. `isDeleted` bit(1) NOT NULL DEFAULT b'0',
  155. `commentID` char(36) CHARACTER SET utf8 NOT NULL,
  156. `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  157. PRIMARY KEY (`commentID`),
  158. UNIQUE KEY `id` (`commentID`),
  159. UNIQUE KEY `commentID` (`commentID`),
  160. KEY `idx_approved` (`isApproved`),
  161. KEY `idx_createdDate` (`createdDate`),
  162. KEY `idx_commentCreatedDate` (`createdDate`),
  163. KEY `idx_deleted` (`isDeleted`),
  164. KEY `fk_cb_comment_FK_contentID` (`FK_contentID`),
  165. CONSTRAINT `fk_cb_comment_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  166. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  167. LOCK TABLES `cb_comment` WRITE;
  168. /*!40000 ALTER TABLE `cb_comment` DISABLE KEYS */;
  169. INSERT INTO `cb_comment` (`content`, `author`, `authorIP`, `authorEmail`, `authorURL`, `createdDate`, `isApproved`, `modifiedDate`, `isDeleted`, `commentID`, `FK_contentID`)
  170. VALUES
  171. ('Test','Luis','','lmajano@gmail.com','','2015-08-04 16:17:43',b'0','2021-02-18 17:58:20',b'0','77d99fac-a444-11eb-ab6f-0290cc502ae3','779cd234-a444-11eb-ab6f-0290cc502ae3'),
  172. ('test','Luis Majano','127.0.0.1','lmajano@gmail.com','','2016-05-11 16:12:33',b'1','2016-05-11 16:12:33',b'0','77d9a15a-a444-11eb-ab6f-0290cc502ae3','779cd18a-a444-11eb-ab6f-0290cc502ae3'),
  173. ('test','Luis Majano','127.0.0.1','lmajano@ortussolutions.com','','2016-05-12 12:34:17',b'1','2016-05-12 12:34:17',b'0','77d9a240-a444-11eb-ab6f-0290cc502ae3','779cd18a-a444-11eb-ab6f-0290cc502ae3'),
  174. ('My awesome comment','Luis Majano','127.0.0.1','lmajano@gmail.com','','2016-11-28 15:35:51',b'1','2016-11-28 15:35:51',b'0','77d9a2cc-a444-11eb-ab6f-0290cc502ae3','779cd234-a444-11eb-ab6f-0290cc502ae3'),
  175. ('Another test comment','Luis Majano','127.0.0.1','lmajano@gmail.com','','2021-05-05 15:15:06',b'1','2021-05-05 15:15:06',b'0','ff808081793cf2c801793e2b749b002a','779cd234-a444-11eb-ab6f-0290cc502ae3'),
  176. ('My comment is meant to test your limits','Joe Hacker','127.0.0.1','joe@hacker.com','','2021-05-05 15:15:29',b'0','2021-05-05 15:15:42',b'0','ff808081793cf2c801793e2bcd53002b','779cd234-a444-11eb-ab6f-0290cc502ae3');
  177. /*!40000 ALTER TABLE `cb_comment` ENABLE KEYS */;
  178. UNLOCK TABLES;
  179. # Dump of table cb_commentSubscriptions
  180. # ------------------------------------------------------------
  181. DROP TABLE IF EXISTS `cb_commentSubscriptions`;
  182. CREATE TABLE `cb_commentSubscriptions` (
  183. `subscriptionID` char(36) CHARACTER SET utf8 NOT NULL,
  184. `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  185. PRIMARY KEY (`subscriptionID`),
  186. KEY `fk_cb_commentSubscriptions_FK_contentID` (`FK_contentID`),
  187. CONSTRAINT `fk_cb_commentSubscriptions_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  188. CONSTRAINT `fk_cb_commentSubscriptions_subscriptionID` FOREIGN KEY (`subscriptionID`) REFERENCES `cb_subscriptions` (`subscriptionID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  189. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  190. LOCK TABLES `cb_commentSubscriptions` WRITE;
  191. /*!40000 ALTER TABLE `cb_commentSubscriptions` DISABLE KEYS */;
  192. INSERT INTO `cb_commentSubscriptions` (`subscriptionID`, `FK_contentID`)
  193. VALUES
  194. ('77e37aae-a444-11eb-ab6f-0290cc502ae3','779cd18a-a444-11eb-ab6f-0290cc502ae3'),
  195. ('77e37b80-a444-11eb-ab6f-0290cc502ae3','779cd18a-a444-11eb-ab6f-0290cc502ae3'),
  196. ('77e3796e-a444-11eb-ab6f-0290cc502ae3','779cd234-a444-11eb-ab6f-0290cc502ae3');
  197. /*!40000 ALTER TABLE `cb_commentSubscriptions` ENABLE KEYS */;
  198. UNLOCK TABLES;
  199. # Dump of table cb_content
  200. # ------------------------------------------------------------
  201. DROP TABLE IF EXISTS `cb_content`;
  202. CREATE TABLE `cb_content` (
  203. `contentType` varchar(255) NOT NULL,
  204. `title` varchar(500) NOT NULL,
  205. `slug` varchar(500) NOT NULL,
  206. `createdDate` datetime NOT NULL,
  207. `publishedDate` datetime DEFAULT NULL,
  208. `expireDate` datetime DEFAULT NULL,
  209. `isPublished` bit(1) NOT NULL DEFAULT b'1',
  210. `allowComments` bit(1) NOT NULL DEFAULT b'1',
  211. `passwordProtection` varchar(100) DEFAULT NULL,
  212. `HTMLKeywords` varchar(160) DEFAULT NULL,
  213. `HTMLDescription` varchar(160) DEFAULT NULL,
  214. `cache` bit(1) NOT NULL DEFAULT b'1',
  215. `cacheTimeout` int(11) DEFAULT '0',
  216. `cacheLastAccessTimeout` int(11) DEFAULT '0',
  217. `markup` varchar(100) NOT NULL DEFAULT 'HTML',
  218. `showInSearch` bit(1) NOT NULL DEFAULT b'1',
  219. `featuredImage` varchar(500) DEFAULT NULL,
  220. `featuredImageURL` varchar(500) DEFAULT NULL,
  221. `modifiedDate` datetime NOT NULL,
  222. `isDeleted` bit(1) NOT NULL DEFAULT b'0',
  223. `HTMLTitle` varchar(255) DEFAULT NULL,
  224. `contentID` char(36) CHARACTER SET utf8 NOT NULL,
  225. `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  226. `FK_parentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  227. `FK_siteID` varchar(36) DEFAULT NULL,
  228. PRIMARY KEY (`contentID`),
  229. UNIQUE KEY `id` (`contentID`),
  230. UNIQUE KEY `contentID` (`contentID`),
  231. KEY `idx_slug` (`slug`),
  232. KEY `idx_discriminator` (`contentType`),
  233. KEY `idx_cachetimeout` (`cacheTimeout`),
  234. KEY `idx_cache` (`cache`),
  235. KEY `idx_publishedSlug` (`slug`,`isPublished`),
  236. KEY `idx_published` (`contentType`,`isPublished`,`passwordProtection`),
  237. KEY `idx_publishedDate` (`publishedDate`),
  238. KEY `idx_cachelastaccesstimeout` (`cacheLastAccessTimeout`),
  239. KEY `idx_createdDate` (`createdDate`),
  240. KEY `idx_expireDate` (`expireDate`),
  241. KEY `idx_search` (`title`,`isPublished`),
  242. KEY `idx_showInSearch` (`showInSearch`),
  243. KEY `idx_deleted` (`isDeleted`),
  244. KEY `fk_cb_content_FK_authorID` (`FK_authorID`),
  245. KEY `fk_cb_content_FK_parentID` (`FK_parentID`),
  246. KEY `FK_siteID` (`FK_siteID`),
  247. CONSTRAINT `cb_content_ibfk_1` FOREIGN KEY (`FK_siteID`) REFERENCES `cb_site` (`siteID`) ON DELETE CASCADE ON UPDATE CASCADE,
  248. CONSTRAINT `fk_cb_content_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  249. CONSTRAINT `fk_cb_content_FK_parentID` FOREIGN KEY (`FK_parentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  250. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  251. LOCK TABLES `cb_content` WRITE;
  252. /*!40000 ALTER TABLE `cb_content` DISABLE KEYS */;
  253. INSERT INTO `cb_content` (`contentType`, `title`, `slug`, `createdDate`, `publishedDate`, `expireDate`, `isPublished`, `allowComments`, `passwordProtection`, `HTMLKeywords`, `HTMLDescription`, `cache`, `cacheTimeout`, `cacheLastAccessTimeout`, `markup`, `showInSearch`, `featuredImage`, `featuredImageURL`, `modifiedDate`, `isDeleted`, `HTMLTitle`, `contentID`, `FK_authorID`, `FK_parentID`, `FK_siteID`)
  254. VALUES
  255. ('Entry','An awesome blog entry','an-awesome-blog-entry','2013-07-12 09:53:01','2013-07-20 16:05:46',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc2bc-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  256. ('Entry','Another Test','another-test','2013-07-12 09:53:31','2013-07-20 16:39:53',NULL,b'0',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc4e2-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  257. ('Entry','ContentBox Modular CMS at the South Florida CFUG','contentbox-modular-cms-at-the-south-florida-cfug','2012-09-13 15:55:12','2013-07-20 16:39:39',NULL,b'1',b'1','','','',b'1',0,0,'html',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc5e6-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  258. ('Entry','Test with an excerpt','test-with-an-excerpt','2013-07-15 17:56:10','2013-07-20 16:39:39',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc6b8-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  259. ('Entry','Updating an ORM entity','updating-an-orm-entity','2013-07-19 18:45:08','2013-07-20 16:39:39',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc76c-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  260. ('Entry','Copy of Updating an ORM entity','copy-of-updating-an-orm-entity','2013-07-20 16:10:43','2013-07-20 16:39:39',NULL,b'1',b'1','','','',b'1',0,0,'html',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc820-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  261. ('Entry','Copy of Another Test','copy-of-another-test','2013-07-20 16:12:16','2013-07-20 16:39:39',NULL,b'1',b'1','','','',b'1',0,0,'html',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc906-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  262. ('Entry','Copy of Copy of Another Test','copy-of-copy-of-another-test','2013-07-20 16:12:23','2013-07-20 16:12:00',NULL,b'0',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cc9ba-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  263. ('Entry','Couchbase Infrastructure','couchbase-infrastructure','2013-07-26 16:53:43','2013-07-26 16:53:00',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cca64-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  264. ('Entry','Couchbase Details','couchbase-details','2013-07-26 16:55:00','2013-10-11 10:31:00',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1','','','2021-02-19 10:54:25',b'0','','779ccb0e-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  265. ('ContentStore','First Content Store','first-content-store','2013-08-12 11:59:12','2013-08-12 12:02:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779ccbb8-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  266. ('ContentStore','My News','my-awesome-news','2013-08-14 18:14:43','2013-08-14 18:14:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779ccc62-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  267. ('ContentStore','blog-sidebar-top','blog-sidebar-top','2013-08-22 20:42:37','2013-08-22 20:42:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779ccd02-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  268. ('ContentStore','footer','foot','2013-08-22 20:43:59','2013-08-22 20:43:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2021-05-05 15:18:36',b'0',NULL,'779ccdac-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  269. ('ContentStore','support options','support-options-baby','2013-08-22 20:45:19','2013-08-22 20:45:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cce56-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  270. ('ContentStore','FireFox Test','firefox-test','2013-08-29 08:29:36','2013-08-29 08:29:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779ccef6-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  271. ('Entry','Couchbase Conference','couchbase-conference','2013-09-13 16:54:52','2013-09-13 16:54:00',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779ccfa0-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  272. ('Entry','Disk Queues','disk-queues','2013-09-13 16:55:05','2013-09-13 16:54:00',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cd040-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  273. ('Entry','This is just awesome','this-is-just-awesome','2013-10-15 16:48:56','2013-10-15 16:48:00',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cd0ea-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  274. ('Entry','Closures cannot be declared outside of cfscript','closures-cannot-be-declared-outside-of-cfscript','2013-11-11 11:53:03','2013-11-11 11:52:00',NULL,b'1',b'1','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cd18a-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  275. ('Entry','Disk Queues ','disk-queues-77caf','2014-01-31 14:41:16','2014-01-31 14:41:00',NULL,b'1',b'1','','these are nice keywords','Disk Queues are amazing and they rock SEO',b'1',0,0,'HTML',b'1','','','2021-05-05 15:17:18',b'0','Disk Queues are amazing','779cd234-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  276. ('Page','support','support','2013-07-20 15:38:47','2013-07-20 15:38:00',NULL,b'1',b'0','','','',b'1',0,0,'html',b'1','','','2016-08-05 14:42:30',b'0',NULL,'779cd2de-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  277. ('ContentStore','Small Footer','foot/small-footer','2014-09-26 16:00:44','2014-09-26 16:00:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-05-03 16:23:25',b'0',NULL,'779cd388-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779ccdac-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  278. ('Page','No Layout Test','no-layout-test','2015-03-29 10:13:59','2015-03-29 10:13:00',NULL,b'1',b'0','test','','',b'1',0,0,'HTML',b'1','','','2016-08-05 14:42:30',b'0',NULL,'779cd432-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  279. ('Page','No Sidebar','email-test','2015-09-16 10:33:56','2015-09-16 10:33:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1',NULL,NULL,'2016-08-05 14:42:30',b'0',NULL,'779cd4dc-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  280. ('ContentStore','Lucee 4.5.2.018','lucee-452018','2016-01-14 11:44:58','2016-01-14 11:42:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-03 16:23:25',b'0',NULL,'779cd57c-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  281. ('ContentStore','Another test','another-test-a161b','2016-01-14 11:45:35','2016-01-14 11:45:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-05 15:56:12',b'0',NULL,'779cd61c-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  282. ('Page','parent page','parent-page','2016-04-12 09:26:56','2016-04-12 09:26:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-03 16:23:25',b'0',NULL,'779cd6c6-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  283. ('Page','child 1','parent-page/child-1','2016-04-12 09:27:06','2016-04-12 09:27:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-03 16:23:25',b'0',NULL,'779cd766-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cd6c6-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  284. ('Page','node','node','2016-04-12 13:18:51','2016-04-12 13:18:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-08-05 14:42:30',b'0',NULL,'779cd806-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  285. ('Page','child1','node/child1','2016-04-12 13:19:04','2016-04-12 13:18:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-03 16:23:25',b'0',NULL,'779cd8b0-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cd806-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  286. ('Page','child2','node/child2','2016-04-12 13:19:10','2016-04-12 13:19:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-03 16:23:25',b'0',NULL,'779cd950-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cd806-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  287. ('Page','Test Markdown','test-markdown','2016-05-05 11:12:23','2016-05-05 11:11:00','2016-05-01 00:00:00',b'0',b'0','','','',b'1',0,0,'Markdown',b'0','','','2016-08-05 14:42:24',b'0',NULL,'779cd9fa-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  288. ('Page','products','products','2016-05-18 11:35:32','2017-06-13 17:08:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2017-06-13 17:08:36',b'0','','779cdaa4-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  289. ('Page','coldbox','products/coldbox','2016-05-18 11:35:32','2013-07-11 11:23:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cdb4e-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdaa4-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  290. ('Page','mini','products/coldbox/mini','2016-05-18 11:35:32','2015-09-22 10:53:23',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cdbee-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdb4e-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  291. ('Page','services','products/coldbox/services','2016-05-18 11:35:32','2015-09-22 10:53:23',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cdc8e-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdb4e-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  292. ('Page','servers','products/coldbox/services/servers','2016-05-18 11:35:32','2013-07-20 10:40:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cdd38-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdc8e-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  293. ('Page','More Servers','products/coldbox/services/more-servers','2016-05-18 11:35:32','2013-07-20 10:40:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cddd8-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdc8e-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  294. ('Page','support','products/coldbox/services/support','2016-05-18 11:35:32','2013-07-20 10:40:00',NULL,b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cde82-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdc8e-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  295. ('Page','coldbox-new','products/coldbox-new','2016-05-18 11:35:32','2016-04-11 11:32:00',NULL,b'1',b'0','','','',b'1',0,0,'html',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cdf22-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdaa4-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  296. ('Page','mini','products/coldbox-new/mini','2016-05-18 11:35:32','2013-08-22 10:23:03',NULL,b'0',b'0','','','',b'1',0,0,'html',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779cdfc2-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdf22-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  297. ('Page','services','products/coldbox-new/services','2016-05-18 11:35:32','2013-08-22 10:23:03',NULL,b'0',b'0','','','',b'1',0,0,'html',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779ce06c-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cdf22-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  298. ('Page','servers','products/coldbox-new/services/servers','2016-05-18 11:35:32','2013-08-22 10:23:03',NULL,b'0',b'0','','','',b'1',0,0,'html',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779ce10c-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779ce06c-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  299. ('Page','More Servers','products/coldbox-new/services/more-servers','2016-05-18 11:35:32','2013-08-22 10:23:04',NULL,b'0',b'0','','','',b'1',0,0,'html',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779ce1ac-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779ce06c-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  300. ('Page','support','products/coldbox-new/services/support','2016-05-18 11:35:32','2013-08-22 10:23:04',NULL,b'0',b'0','','','',b'1',0,0,'html',b'1','','','2016-05-18 11:35:32',b'0',NULL,'779ce256-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779ce06c-a444-11eb-ab6f-0290cc502ae3','1c81d376-a481-11eb-ab6f-0290cc502ae3'),
  301. ('ContentStore','My Expired Content Store','my-expired-content-store','2018-03-20 09:48:13','2018-03-20 09:47:00','2018-02-01 00:00:00',b'1',b'0','','','',b'1',0,0,'HTML',b'1','','','2018-03-20 09:48:13',b'0','','779ce300-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3',NULL,'1c81d376-a481-11eb-ab6f-0290cc502ae3');
  302. /*!40000 ALTER TABLE `cb_content` ENABLE KEYS */;
  303. UNLOCK TABLES;
  304. # Dump of table cb_contentCategories
  305. # ------------------------------------------------------------
  306. DROP TABLE IF EXISTS `cb_contentCategories`;
  307. CREATE TABLE `cb_contentCategories` (
  308. `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  309. `FK_categoryID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  310. KEY `fk_cb_contentCategories_FK_contentID` (`FK_contentID`),
  311. KEY `fk_cb_contentCategories_FK_categoryID` (`FK_categoryID`),
  312. CONSTRAINT `fk_cb_contentCategories_FK_categoryID` FOREIGN KEY (`FK_categoryID`) REFERENCES `cb_category` (`categoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  313. CONSTRAINT `fk_cb_contentCategories_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  314. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  315. LOCK TABLES `cb_contentCategories` WRITE;
  316. /*!40000 ALTER TABLE `cb_contentCategories` DISABLE KEYS */;
  317. INSERT INTO `cb_contentCategories` (`FK_contentID`, `FK_categoryID`)
  318. VALUES
  319. ('779ccc62-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
  320. ('779ccc62-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
  321. ('779cc4e2-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
  322. ('779cc4e2-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
  323. ('779cc906-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
  324. ('779cc906-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
  325. ('779cc9ba-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
  326. ('779cc9ba-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
  327. ('779cd2de-a444-11eb-ab6f-0290cc502ae3','786a98cc-a444-11eb-ab6f-0290cc502ae3'),
  328. ('779cd234-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
  329. ('779cd234-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
  330. ('779ccdac-a444-11eb-ab6f-0290cc502ae3','786a98cc-a444-11eb-ab6f-0290cc502ae3');
  331. /*!40000 ALTER TABLE `cb_contentCategories` ENABLE KEYS */;
  332. UNLOCK TABLES;
  333. # Dump of table cb_contentStore
  334. # ------------------------------------------------------------
  335. DROP TABLE IF EXISTS `cb_contentStore`;
  336. CREATE TABLE `cb_contentStore` (
  337. `description` longtext,
  338. `order` int(11) DEFAULT '0',
  339. `contentID` char(36) CHARACTER SET utf8 NOT NULL,
  340. PRIMARY KEY (`contentID`),
  341. CONSTRAINT `fk_cb_contentStore_contentID` FOREIGN KEY (`contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  342. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  343. LOCK TABLES `cb_contentStore` WRITE;
  344. /*!40000 ALTER TABLE `cb_contentStore` DISABLE KEYS */;
  345. INSERT INTO `cb_contentStore` (`description`, `order`, `contentID`)
  346. VALUES
  347. ('My very first content',0,'779ccbb8-a444-11eb-ab6f-0290cc502ae3'),
  348. ('Most greatest news',0,'779ccc62-a444-11eb-ab6f-0290cc502ae3'),
  349. ('',0,'779ccd02-a444-11eb-ab6f-0290cc502ae3'),
  350. ('This is a reusable footer',0,'779ccdac-a444-11eb-ab6f-0290cc502ae3'),
  351. ('support options',0,'779cce56-a444-11eb-ab6f-0290cc502ae3'),
  352. ('Test',0,'779ccef6-a444-11eb-ab6f-0290cc502ae3'),
  353. ('A small footer',0,'779cd388-a444-11eb-ab6f-0290cc502ae3'),
  354. ('test',0,'779cd57c-a444-11eb-ab6f-0290cc502ae3'),
  355. ('asdf',0,'779cd61c-a444-11eb-ab6f-0290cc502ae3'),
  356. ('',0,'779ce300-a444-11eb-ab6f-0290cc502ae3');
  357. /*!40000 ALTER TABLE `cb_contentStore` ENABLE KEYS */;
  358. UNLOCK TABLES;
  359. # Dump of table cb_contentVersion
  360. # ------------------------------------------------------------
  361. DROP TABLE IF EXISTS `cb_contentVersion`;
  362. CREATE TABLE `cb_contentVersion` (
  363. `content` longtext NOT NULL,
  364. `changelog` longtext,
  365. `version` int(11) NOT NULL,
  366. `createdDate` datetime NOT NULL,
  367. `isActive` bit(1) NOT NULL DEFAULT b'1',
  368. `modifiedDate` datetime NOT NULL,
  369. `isDeleted` bit(1) NOT NULL DEFAULT b'0',
  370. `contentVersionID` char(36) CHARACTER SET utf8 NOT NULL,
  371. `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  372. `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
  373. PRIMARY KEY (`contentVersionID`),
  374. UNIQUE KEY `id` (`contentVersionID`),
  375. UNIQUE KEY `contentVersionID` (`contentVersionID`),
  376. KEY `idx_active` (`isActive`),
  377. KEY `idx_version` (`version`),
  378. KEY `idx_createdDate` (`createdDate`),
  379. KEY `idx_versionCreatedDate` (`createdDate`),
  380. KEY `idx_activeContentVersion` (`isActive`),
  381. KEY `idx_deleted` (`isDeleted`),
  382. KEY `fk_cb_contentVersion_FK_authorID` (`FK_authorID`),
  383. KEY `fk_cb_contentVersion_FK_contentID` (`FK_contentID`),
  384. CONSTRAINT `fk_cb_contentVersion_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  385. CONSTRAINT `fk_cb_contentVersion_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  386. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  387. LOCK TABLES `cb_contentVersion` WRITE;
  388. /*!40000 ALTER TABLE `cb_contentVersion` DISABLE KEYS */;
  389. INSERT INTO `cb_contentVersion` (`content`, `changelog`, `version`, `createdDate`, `isActive`, `modifiedDate`, `isDeleted`, `contentVersionID`, `FK_authorID`, `FK_contentID`)
  390. VALUES
  391. ('<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>&nbsp;</p>\r\n','Test',1,'2013-07-12 09:53:01',b'1','2016-05-03 16:23:25',b'0','78076356-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cc2bc-a444-11eb-ab6f-0290cc502ae3'),
  392. ('<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>&nbsp;</p>\r\n','',1,'2013-07-12 09:53:31',b'0','2016-05-03 16:23:25',b'0','780764fa-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cc4e2-a444-11eb-ab6f-0290cc502ae3'),
  393. ('<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>&nbsp;</p>\r\n','',2,'2013-07-12 09:53:40',b'1','2016-05-03 16:23:25',b'0','780765c2-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cc4e2-a444-11eb-ab6f-0290cc502ae3'),
  394. ('I am glad to go back to my adoptive home, Miami next week and present at the South Florida CFUG on <a href=\"http://gocontentbox.org\">ContentBox Modular CMS</a> September 20th, 2012.  We will be showcasing our next ContentBox version 1.0.7 and have some great goodies for everybody.  <a href=\"http://www.gocontentbox.org/blog/south-florida-cfug-presentation\">You can read all about the event here</a>.  Hope to see you there!','Imported content',1,'2013-04-07 10:45:28',b'1','2016-05-03 16:23:25',b'0','7807666c-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cc5e6-a444-11eb-ab6f-0290cc502ae3'),
  395. ('<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>&nbsp;</p>\r\n','',1,'2013-07-15 17:56:10',b'1','2016-05-03 16:23:25',b'0','780766ee-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cc6b8-a444-11eb-ab6f-0290cc502ae3'),
  396. ('<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>&nbsp;</p>\r\n','quick save',1,'2013-07-19 18:45:08',b'0','2016-05-03 16:23:25',b'0','78076766-a444-11eb-ab6f-0290cc502ae3','77abddba-a444-11eb-ab6f-0290cc502ae3','779cc76c-a444-11eb-ab6f-0290cc502ae3'),
  397. ('<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia