PageRenderTime 172ms CodeModel.GetById 19ms RepoModel.GetById 1ms 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. 

  2. # Sequel Ace SQL dump
    3. 

  3. # Version 20025
    4. 

  4. #
    5. 

  5. # https://sequel-ace.com/
    6. 

  6. # https://github.com/Sequel-Ace/Sequel-Ace
    7. 

  7. #
    8. 

  8. # Host: 127.0.0.1 (MySQL 5.7.22)
    9. 

  9. # Database: contentbox
    10. 

  10. # Generation Time: 2022-02-18 20:12:42 +0000
    11. 

  11. # ************************************************************
    12. 

  12. 

  13. USE `contentbox`;
    14. 

  14. 

  15. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    16. 

  16. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    17. 

  17. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    18. 

  18. SET NAMES utf8mb4;
    19. 

  19. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    20. 

  20. /*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    21. 

  21. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    22. 

  22. 

  23. 

  24. # Dump of table cb_author
    25. 

  25. # ------------------------------------------------------------
    26. 

  26. 

  27. DROP TABLE IF EXISTS `cb_author`;
    28. 

  28. 

  29. CREATE TABLE `cb_author` (
    30. 

  30.   `firstName` varchar(100) NOT NULL,
    31. 

  31.   `lastName` varchar(100) NOT NULL,
    32. 

  32.   `email` varchar(255) NOT NULL,
    33. 

  33.   `username` varchar(100) NOT NULL,
    34. 

  34.   `password` varchar(100) NOT NULL,
    35. 

  35.   `isActive` bit(1) NOT NULL DEFAULT b'1',
    36. 

  36.   `lastLogin` datetime DEFAULT NULL,
    37. 

  37.   `createdDate` datetime NOT NULL,
    38. 

  38.   `biography` longtext,
    39. 

  39.   `preferences` longtext,
    40. 

  40.   `modifiedDate` datetime NOT NULL,
    41. 

  41.   `isDeleted` bit(1) NOT NULL DEFAULT b'0',
    42. 

  42.   `isPasswordReset` bit(1) NOT NULL DEFAULT b'0',
    43. 

  43.   `is2FactorAuth` bit(1) NOT NULL DEFAULT b'0',
    44. 

  44.   `authorID` char(36) CHARACTER SET utf8 NOT NULL,
    45. 

  45.   `FK_roleID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    46. 

  46.   PRIMARY KEY (`authorID`),
    47. 

  47.   UNIQUE KEY `username` (`username`),
    48. 

  48.   UNIQUE KEY `id` (`authorID`),
    49. 

  49.   UNIQUE KEY `authorID` (`authorID`),
    50. 

  50.   KEY `idx_active` (`isActive`),
    51. 

  51.   KEY `idx_email` (`email`),
    52. 

  52.   KEY `idx_login` (`username`,`password`,`isActive`),
    53. 

  53.   KEY `idx_activeAuthor` (`isActive`),
    54. 

  54.   KEY `idx_deleted` (`isDeleted`),
    55. 

  55.   KEY `idx_passwordReset` (`isPasswordReset`),
    56. 

  56.   KEY `idx_2factorauth` (`is2FactorAuth`),
    57. 

  57.   KEY `fk_cb_author_FK_roleID` (`FK_roleID`),
    58. 

  58.   CONSTRAINT `fk_cb_author_FK_roleID` FOREIGN KEY (`FK_roleID`) REFERENCES `cb_role` (`roleID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    59. 

  59. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    60. 

  60. 

  61. LOCK TABLES `cb_author` WRITE;
    62. 

  62. /*!40000 ALTER TABLE `cb_author` DISABLE KEYS */;
    63. 

  63. 

  64. INSERT INTO `cb_author` (`firstName`, `lastName`, `email`, `username`, `password`, `isActive`, `lastLogin`, `createdDate`, `biography`, `preferences`, `modifiedDate`, `isDeleted`, `isPasswordReset`, `is2FactorAuth`, `authorID`, `FK_roleID`)
    65. 

  65. VALUES
    66. 

  66. 	('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'),
    67. 

  67. 	('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'),
    68. 

  68. 	('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'),
    69. 

  69. 	('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'),
    70. 

  70. 	('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');
    71. 

  71. 

  72. /*!40000 ALTER TABLE `cb_author` ENABLE KEYS */;
    73. 

  73. UNLOCK TABLES;
    74. 

  74. 

  75. 

  76. # Dump of table cb_authorPermissionGroups
    77. 

  77. # ------------------------------------------------------------
    78. 

  78. 

  79. DROP TABLE IF EXISTS `cb_authorPermissionGroups`;
    80. 

  80. 

  81. CREATE TABLE `cb_authorPermissionGroups` (
    82. 

  82.   `FK_permissionGroupID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    83. 

  83.   `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    84. 

  84.   KEY `fk_cb_authorPermissionGroups_FK_permissionGroupID` (`FK_permissionGroupID`),
    85. 

  85.   KEY `fk_cb_authorPermissionGroups_FK_authorID` (`FK_authorID`),
    86. 

  86.   CONSTRAINT `fk_cb_authorPermissionGroups_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    87. 

  87.   CONSTRAINT `fk_cb_authorPermissionGroups_FK_permissionGroupID` FOREIGN KEY (`FK_permissionGroupID`) REFERENCES `cb_permissionGroup` (`permissionGroupID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    88. 

  88. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    89. 

  89. 

  90. LOCK TABLES `cb_authorPermissionGroups` WRITE;
    91. 

  91. /*!40000 ALTER TABLE `cb_authorPermissionGroups` DISABLE KEYS */;
    92. 

  92. 

  93. INSERT INTO `cb_authorPermissionGroups` (`FK_permissionGroupID`, `FK_authorID`)
    94. 

  94. VALUES
    95. 

  95. 	('7850efee-a444-11eb-ab6f-0290cc502ae3','77abe166-a444-11eb-ab6f-0290cc502ae3'),
    96. 

  96. 	('7850efee-a444-11eb-ab6f-0290cc502ae3','77abe206-a444-11eb-ab6f-0290cc502ae3'),
    97. 

  97. 	('7850f138-a444-11eb-ab6f-0290cc502ae3','77abe206-a444-11eb-ab6f-0290cc502ae3');
    98. 

  98. 

  99. /*!40000 ALTER TABLE `cb_authorPermissionGroups` ENABLE KEYS */;
    100. 

  100. UNLOCK TABLES;
    101. 

  101. 

  102. 

  103. # Dump of table cb_authorPermissions
    104. 

  104. # ------------------------------------------------------------
    105. 

  105. 

  106. DROP TABLE IF EXISTS `cb_authorPermissions`;
    107. 

  107. 

  108. CREATE TABLE `cb_authorPermissions` (
    109. 

  109.   `FK_permissionID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    110. 

  110.   `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    111. 

  111.   KEY `fk_cb_authorPermissions_FK_permissionID` (`FK_permissionID`),
    112. 

  112.   KEY `fk_cb_authorPermissions_FK_authorID` (`FK_authorID`),
    113. 

  113.   CONSTRAINT `fk_cb_authorPermissions_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    114. 

  114.   CONSTRAINT `fk_cb_authorPermissions_FK_permissionID` FOREIGN KEY (`FK_permissionID`) REFERENCES `cb_permission` (`permissionID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    115. 

  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    116. 

  116. 

  117. LOCK TABLES `cb_authorPermissions` WRITE;
    118. 

  118. /*!40000 ALTER TABLE `cb_authorPermissions` DISABLE KEYS */;
    119. 

  119. 

  120. INSERT INTO `cb_authorPermissions` (`FK_permissionID`, `FK_authorID`)
    121. 

  121. VALUES
    122. 

  122. 	('785d8182-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
    123. 

  123. 	('785d8574-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
    124. 

  124. 	('785d8420-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
    125. 

  125. 	('785d83b2-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
    126. 

  126. 	('785d8344-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3'),
    127. 

  127. 	('785d84fc-a444-11eb-ab6f-0290cc502ae3','77abe0a8-a444-11eb-ab6f-0290cc502ae3');
    128. 

  128. 

  129. /*!40000 ALTER TABLE `cb_authorPermissions` ENABLE KEYS */;
    130. 

  130. UNLOCK TABLES;
    131. 

  131. 

  132. 

  133. # Dump of table cb_category
    134. 

  134. # ------------------------------------------------------------
    135. 

  135. 

  136. DROP TABLE IF EXISTS `cb_category`;
    137. 

  137. 

  138. CREATE TABLE `cb_category` (
    139. 

  139.   `category` varchar(200) NOT NULL,
    140. 

  140.   `slug` varchar(200) NOT NULL,
    141. 

  141.   `createdDate` datetime NOT NULL,
    142. 

  142.   `modifiedDate` datetime NOT NULL,
    143. 

  143.   `isDeleted` bit(1) NOT NULL DEFAULT b'0',
    144. 

  144.   `categoryID` char(36) CHARACTER SET utf8 NOT NULL,
    145. 

  145.   `FK_siteID` varchar(36) NOT NULL DEFAULT '',
    146. 

  146.   `isPublic` bit(1) NOT NULL,
    147. 

  147.   PRIMARY KEY (`categoryID`),
    148. 

  148.   UNIQUE KEY `id` (`categoryID`),
    149. 

  149.   UNIQUE KEY `categoryID` (`categoryID`),
    150. 

  150.   KEY `idx_slug` (`slug`),
    151. 

  151.   KEY `idx_categorySlug` (`slug`),
    152. 

  152.   KEY `idx_deleted` (`isDeleted`),
    153. 

  153.   KEY `idx_categoryName` (`category`),
    154. 

  154.   KEY `FK_siteID` (`FK_siteID`),
    155. 

  155.   KEY `idx_isPublic` (`isPublic`),
    156. 

  156.   CONSTRAINT `cb_category_ibfk_1` FOREIGN KEY (`FK_siteID`) REFERENCES `cb_site` (`siteID`) ON DELETE CASCADE ON UPDATE CASCADE
    157. 

  157. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    158. 

  158. 

  159. LOCK TABLES `cb_category` WRITE;
    160. 

  160. /*!40000 ALTER TABLE `cb_category` DISABLE KEYS */;
    161. 

  161. 

  162. INSERT INTO `cb_category` (`category`, `slug`, `createdDate`, `modifiedDate`, `isDeleted`, `categoryID`, `FK_siteID`, `isPublic`)
    163. 

  163. VALUES
    164. 

  164. 	('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'),
    165. 

  165. 	('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'),
    166. 

  166. 	('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'),
    167. 

  167. 	('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'),
    168. 

  168. 	('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');
    169. 

  169. 

  170. /*!40000 ALTER TABLE `cb_category` ENABLE KEYS */;
    171. 

  171. UNLOCK TABLES;
    172. 

  172. 

  173. 

  174. # Dump of table cb_comment
    175. 

  175. # ------------------------------------------------------------
    176. 

  176. 

  177. DROP TABLE IF EXISTS `cb_comment`;
    178. 

  178. 

  179. CREATE TABLE `cb_comment` (
    180. 

  180.   `content` longtext NOT NULL,
    181. 

  181.   `author` varchar(100) NOT NULL,
    182. 

  182.   `authorIP` varchar(100) NOT NULL,
    183. 

  183.   `authorEmail` varchar(255) NOT NULL,
    184. 

  184.   `authorURL` varchar(255) DEFAULT NULL,
    185. 

  185.   `createdDate` datetime NOT NULL,
    186. 

  186.   `isApproved` bit(1) NOT NULL DEFAULT b'0',
    187. 

  187.   `modifiedDate` datetime NOT NULL,
    188. 

  188.   `isDeleted` bit(1) NOT NULL DEFAULT b'0',
    189. 

  189.   `commentID` char(36) CHARACTER SET utf8 NOT NULL,
    190. 

  190.   `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    191. 

  191.   PRIMARY KEY (`commentID`),
    192. 

  192.   UNIQUE KEY `id` (`commentID`),
    193. 

  193.   UNIQUE KEY `commentID` (`commentID`),
    194. 

  194.   KEY `idx_approved` (`isApproved`),
    195. 

  195.   KEY `idx_createdDate` (`createdDate`),
    196. 

  196.   KEY `idx_commentCreatedDate` (`createdDate`),
    197. 

  197.   KEY `idx_deleted` (`isDeleted`),
    198. 

  198.   KEY `fk_cb_comment_FK_contentID` (`FK_contentID`),
    199. 

  199.   CONSTRAINT `fk_cb_comment_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    200. 

  200. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    201. 

  201. 

  202. LOCK TABLES `cb_comment` WRITE;
    203. 

  203. /*!40000 ALTER TABLE `cb_comment` DISABLE KEYS */;
    204. 

  204. 

  205. INSERT INTO `cb_comment` (`content`, `author`, `authorIP`, `authorEmail`, `authorURL`, `createdDate`, `isApproved`, `modifiedDate`, `isDeleted`, `commentID`, `FK_contentID`)
    206. 

  206. VALUES
    207. 

  207. 	('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'),
    208. 

  208. 	('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'),
    209. 

  209. 	('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'),
    210. 

  210. 	('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'),
    211. 

  211. 	('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'),
    212. 

  212. 	('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');
    213. 

  213. 

  214. /*!40000 ALTER TABLE `cb_comment` ENABLE KEYS */;
    215. 

  215. UNLOCK TABLES;
    216. 

  216. 

  217. 

  218. # Dump of table cb_commentSubscriptions
    219. 

  219. # ------------------------------------------------------------
    220. 

  220. 

  221. DROP TABLE IF EXISTS `cb_commentSubscriptions`;
    222. 

  222. 

  223. CREATE TABLE `cb_commentSubscriptions` (
    224. 

  224.   `subscriptionID` char(36) CHARACTER SET utf8 NOT NULL,
    225. 

  225.   `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    226. 

  226.   PRIMARY KEY (`subscriptionID`),
    227. 

  227.   KEY `fk_cb_commentSubscriptions_FK_contentID` (`FK_contentID`),
    228. 

  228.   CONSTRAINT `fk_cb_commentSubscriptions_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    229. 

  229.   CONSTRAINT `fk_cb_commentSubscriptions_subscriptionID` FOREIGN KEY (`subscriptionID`) REFERENCES `cb_subscriptions` (`subscriptionID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    230. 

  230. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    231. 

  231. 

  232. LOCK TABLES `cb_commentSubscriptions` WRITE;
    233. 

  233. /*!40000 ALTER TABLE `cb_commentSubscriptions` DISABLE KEYS */;
    234. 

  234. 

  235. INSERT INTO `cb_commentSubscriptions` (`subscriptionID`, `FK_contentID`)
    236. 

  236. VALUES
    237. 

  237. 	('77e37aae-a444-11eb-ab6f-0290cc502ae3','779cd18a-a444-11eb-ab6f-0290cc502ae3'),
    238. 

  238. 	('77e37b80-a444-11eb-ab6f-0290cc502ae3','779cd18a-a444-11eb-ab6f-0290cc502ae3'),
    239. 

  239. 	('77e3796e-a444-11eb-ab6f-0290cc502ae3','779cd234-a444-11eb-ab6f-0290cc502ae3');
    240. 

  240. 

  241. /*!40000 ALTER TABLE `cb_commentSubscriptions` ENABLE KEYS */;
    242. 

  242. UNLOCK TABLES;
    243. 

  243. 

  244. 

  245. # Dump of table cb_content
    246. 

  246. # ------------------------------------------------------------
    247. 

  247. 

  248. DROP TABLE IF EXISTS `cb_content`;
    249. 

  249. 

  250. CREATE TABLE `cb_content` (
    251. 

  251.   `contentType` varchar(255) NOT NULL,
    252. 

  252.   `title` varchar(500) NOT NULL,
    253. 

  253.   `slug` varchar(500) NOT NULL,
    254. 

  254.   `createdDate` datetime NOT NULL,
    255. 

  255.   `publishedDate` datetime DEFAULT NULL,
    256. 

  256.   `expireDate` datetime DEFAULT NULL,
    257. 

  257.   `isPublished` bit(1) NOT NULL DEFAULT b'1',
    258. 

  258.   `allowComments` bit(1) NOT NULL DEFAULT b'1',
    259. 

  259.   `passwordProtection` varchar(100) DEFAULT NULL,
    260. 

  260.   `HTMLKeywords` varchar(160) DEFAULT NULL,
    261. 

  261.   `HTMLDescription` varchar(160) DEFAULT NULL,
    262. 

  262.   `cache` bit(1) NOT NULL DEFAULT b'1',
    263. 

  263.   `cacheTimeout` int(11) DEFAULT '0',
    264. 

  264.   `cacheLastAccessTimeout` int(11) DEFAULT '0',
    265. 

  265.   `markup` varchar(100) NOT NULL DEFAULT 'HTML',
    266. 

  266.   `showInSearch` bit(1) NOT NULL DEFAULT b'1',
    267. 

  267.   `featuredImage` varchar(500) DEFAULT NULL,
    268. 

  268.   `featuredImageURL` varchar(500) DEFAULT NULL,
    269. 

  269.   `modifiedDate` datetime NOT NULL,
    270. 

  270.   `isDeleted` bit(1) NOT NULL DEFAULT b'0',
    271. 

  271.   `HTMLTitle` varchar(255) DEFAULT NULL,
    272. 

  272.   `contentID` char(36) CHARACTER SET utf8 NOT NULL,
    273. 

  273.   `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    274. 

  274.   `FK_parentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    275. 

  275.   `FK_siteID` varchar(36) DEFAULT NULL,
    276. 

  276.   PRIMARY KEY (`contentID`),
    277. 

  277.   UNIQUE KEY `id` (`contentID`),
    278. 

  278.   UNIQUE KEY `contentID` (`contentID`),
    279. 

  279.   KEY `idx_slug` (`slug`),
    280. 

  280.   KEY `idx_discriminator` (`contentType`),
    281. 

  281.   KEY `idx_cachetimeout` (`cacheTimeout`),
    282. 

  282.   KEY `idx_cache` (`cache`),
    283. 

  283.   KEY `idx_publishedSlug` (`slug`,`isPublished`),
    284. 

  284.   KEY `idx_published` (`contentType`,`isPublished`,`passwordProtection`),
    285. 

  285.   KEY `idx_publishedDate` (`publishedDate`),
    286. 

  286.   KEY `idx_cachelastaccesstimeout` (`cacheLastAccessTimeout`),
    287. 

  287.   KEY `idx_createdDate` (`createdDate`),
    288. 

  288.   KEY `idx_expireDate` (`expireDate`),
    289. 

  289.   KEY `idx_search` (`title`,`isPublished`),
    290. 

  290.   KEY `idx_showInSearch` (`showInSearch`),
    291. 

  291.   KEY `idx_deleted` (`isDeleted`),
    292. 

  292.   KEY `fk_cb_content_FK_authorID` (`FK_authorID`),
    293. 

  293.   KEY `fk_cb_content_FK_parentID` (`FK_parentID`),
    294. 

  294.   KEY `FK_siteID` (`FK_siteID`),
    295. 

  295.   CONSTRAINT `cb_content_ibfk_1` FOREIGN KEY (`FK_siteID`) REFERENCES `cb_site` (`siteID`) ON DELETE CASCADE ON UPDATE CASCADE,
    296. 

  296.   CONSTRAINT `fk_cb_content_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    297. 

  297.   CONSTRAINT `fk_cb_content_FK_parentID` FOREIGN KEY (`FK_parentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    298. 

  298. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    299. 

  299. 

  300. LOCK TABLES `cb_content` WRITE;
    301. 

  301. /*!40000 ALTER TABLE `cb_content` DISABLE KEYS */;
    302. 

  302. 

  303. 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`)
    304. 

  304. VALUES
    305. 

  305. 	('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'),
    306. 

  306. 	('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'),
    307. 

  307. 	('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'),
    308. 

  308. 	('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'),
    309. 

  309. 	('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'),
    310. 

  310. 	('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'),
    311. 

  311. 	('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'),
    312. 

  312. 	('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'),
    313. 

  313. 	('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'),
    314. 

  314. 	('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'),
    315. 

  315. 	('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'),
    316. 

  316. 	('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'),
    317. 

  317. 	('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'),
    318. 

  318. 	('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'),
    319. 

  319. 	('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'),
    320. 

  320. 	('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'),
    321. 

  321. 	('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'),
    322. 

  322. 	('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'),
    323. 

  323. 	('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'),
    324. 

  324. 	('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'),
    325. 

  325. 	('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'),
    326. 

  326. 	('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'),
    327. 

  327. 	('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'),
    328. 

  328. 	('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'),
    329. 

  329. 	('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'),
    330. 

  330. 	('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'),
    331. 

  331. 	('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'),
    332. 

  332. 	('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'),
    333. 

  333. 	('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'),
    334. 

  334. 	('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'),
    335. 

  335. 	('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'),
    336. 

  336. 	('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'),
    337. 

  337. 	('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'),
    338. 

  338. 	('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'),
    339. 

  339. 	('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'),
    340. 

  340. 	('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'),
    341. 

  341. 	('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'),
    342. 

  342. 	('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'),
    343. 

  343. 	('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'),
    344. 

  344. 	('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'),
    345. 

  345. 	('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'),
    346. 

  346. 	('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'),
    347. 

  347. 	('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'),
    348. 

  348. 	('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'),
    349. 

  349. 	('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'),
    350. 

  350. 	('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'),
    351. 

  351. 	('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');
    352. 

  352. 

  353. /*!40000 ALTER TABLE `cb_content` ENABLE KEYS */;
    354. 

  354. UNLOCK TABLES;
    355. 

  355. 

  356. 

  357. # Dump of table cb_contentCategories
    358. 

  358. # ------------------------------------------------------------
    359. 

  359. 

  360. DROP TABLE IF EXISTS `cb_contentCategories`;
    361. 

  361. 

  362. CREATE TABLE `cb_contentCategories` (
    363. 

  363.   `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    364. 

  364.   `FK_categoryID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    365. 

  365.   KEY `fk_cb_contentCategories_FK_contentID` (`FK_contentID`),
    366. 

  366.   KEY `fk_cb_contentCategories_FK_categoryID` (`FK_categoryID`),
    367. 

  367.   CONSTRAINT `fk_cb_contentCategories_FK_categoryID` FOREIGN KEY (`FK_categoryID`) REFERENCES `cb_category` (`categoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    368. 

  368.   CONSTRAINT `fk_cb_contentCategories_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    369. 

  369. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    370. 

  370. 

  371. LOCK TABLES `cb_contentCategories` WRITE;
    372. 

  372. /*!40000 ALTER TABLE `cb_contentCategories` DISABLE KEYS */;
    373. 

  373. 

  374. INSERT INTO `cb_contentCategories` (`FK_contentID`, `FK_categoryID`)
    375. 

  375. VALUES
    376. 

  376. 	('779ccc62-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
    377. 

  377. 	('779ccc62-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
    378. 

  378. 	('779cc4e2-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
    379. 

  379. 	('779cc4e2-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
    380. 

  380. 	('779cc906-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
    381. 

  381. 	('779cc906-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
    382. 

  382. 	('779cc9ba-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
    383. 

  383. 	('779cc9ba-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
    384. 

  384. 	('779cd2de-a444-11eb-ab6f-0290cc502ae3','786a98cc-a444-11eb-ab6f-0290cc502ae3'),
    385. 

  385. 	('779cd234-a444-11eb-ab6f-0290cc502ae3','786a97f0-a444-11eb-ab6f-0290cc502ae3'),
    386. 

  386. 	('779cd234-a444-11eb-ab6f-0290cc502ae3','786a9660-a444-11eb-ab6f-0290cc502ae3'),
    387. 

  387. 	('779ccdac-a444-11eb-ab6f-0290cc502ae3','786a98cc-a444-11eb-ab6f-0290cc502ae3');
    388. 

  388. 

  389. /*!40000 ALTER TABLE `cb_contentCategories` ENABLE KEYS */;
    390. 

  390. UNLOCK TABLES;
    391. 

  391. 

  392. 

  393. # Dump of table cb_contentStore
    394. 

  394. # ------------------------------------------------------------
    395. 

  395. 

  396. DROP TABLE IF EXISTS `cb_contentStore`;
    397. 

  397. 

  398. CREATE TABLE `cb_contentStore` (
    399. 

  399.   `description` longtext,
    400. 

  400.   `order` int(11) DEFAULT '0',
    401. 

  401.   `contentID` char(36) CHARACTER SET utf8 NOT NULL,
    402. 

  402.   PRIMARY KEY (`contentID`),
    403. 

  403.   CONSTRAINT `fk_cb_contentStore_contentID` FOREIGN KEY (`contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    404. 

  404. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    405. 

  405. 

  406. LOCK TABLES `cb_contentStore` WRITE;
    407. 

  407. /*!40000 ALTER TABLE `cb_contentStore` DISABLE KEYS */;
    408. 

  408. 

  409. INSERT INTO `cb_contentStore` (`description`, `order`, `contentID`)
    410. 

  410. VALUES
    411. 

  411. 	('My very first content',0,'779ccbb8-a444-11eb-ab6f-0290cc502ae3'),
    412. 

  412. 	('Most greatest news',0,'779ccc62-a444-11eb-ab6f-0290cc502ae3'),
    413. 

  413. 	('',0,'779ccd02-a444-11eb-ab6f-0290cc502ae3'),
    414. 

  414. 	('This is a reusable footer',0,'779ccdac-a444-11eb-ab6f-0290cc502ae3'),
    415. 

  415. 	('support options',0,'779cce56-a444-11eb-ab6f-0290cc502ae3'),
    416. 

  416. 	('Test',0,'779ccef6-a444-11eb-ab6f-0290cc502ae3'),
    417. 

  417. 	('A small footer',0,'779cd388-a444-11eb-ab6f-0290cc502ae3'),
    418. 

  418. 	('test',0,'779cd57c-a444-11eb-ab6f-0290cc502ae3'),
    419. 

  419. 	('asdf',0,'779cd61c-a444-11eb-ab6f-0290cc502ae3'),
    420. 

  420. 	('',0,'779ce300-a444-11eb-ab6f-0290cc502ae3');
    421. 

  421. 

  422. /*!40000 ALTER TABLE `cb_contentStore` ENABLE KEYS */;
    423. 

  423. UNLOCK TABLES;
    424. 

  424. 

  425. 

  426. # Dump of table cb_contentVersion
    427. 

  427. # ------------------------------------------------------------
    428. 

  428. 

  429. DROP TABLE IF EXISTS `cb_contentVersion`;
    430. 

  430. 

  431. CREATE TABLE `cb_contentVersion` (
    432. 

  432.   `content` longtext NOT NULL,
    433. 

  433.   `changelog` longtext,
    434. 

  434.   `version` int(11) NOT NULL,
    435. 

  435.   `createdDate` datetime NOT NULL,
    436. 

  436.   `isActive` bit(1) NOT NULL DEFAULT b'1',
    437. 

  437.   `modifiedDate` datetime NOT NULL,
    438. 

  438.   `isDeleted` bit(1) NOT NULL DEFAULT b'0',
    439. 

  439.   `contentVersionID` char(36) CHARACTER SET utf8 NOT NULL,
    440. 

  440.   `FK_authorID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    441. 

  441.   `FK_contentID` char(36) CHARACTER SET utf8 DEFAULT NULL,
    442. 

  442.   PRIMARY KEY (`contentVersionID`),
    443. 

  443.   UNIQUE KEY `id` (`contentVersionID`),
    444. 

  444.   UNIQUE KEY `contentVersionID` (`contentVersionID`),
    445. 

  445.   KEY `idx_active` (`isActive`),
    446. 

  446.   KEY `idx_version` (`version`),
    447. 

  447.   KEY `idx_createdDate` (`createdDate`),
    448. 

  448.   KEY `idx_versionCreatedDate` (`createdDate`),
    449. 

  449.   KEY `idx_activeContentVersion` (`isActive`),
    450. 

  450.   KEY `idx_deleted` (`isDeleted`),
    451. 

  451.   KEY `fk_cb_contentVersion_FK_authorID` (`FK_authorID`),
    452. 

  452.   KEY `fk_cb_contentVersion_FK_contentID` (`FK_contentID`),
    453. 

  453.   CONSTRAINT `fk_cb_contentVersion_FK_authorID` FOREIGN KEY (`FK_authorID`) REFERENCES `cb_author` (`authorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    454. 

  454.   CONSTRAINT `fk_cb_contentVersion_FK_contentID` FOREIGN KEY (`FK_contentID`) REFERENCES `cb_content` (`contentID`) ON DELETE NO ACTION ON UPDATE NO ACTION
    455. 

  455. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    456. 

  456. 

  457. LOCK TABLES `cb_contentVersion` WRITE;
    458. 

  458. /*!40000 ALTER TABLE `cb_contentVersion` DISABLE KEYS */;
    459. 

  459. 

  460. INSERT INTO `cb_contentVersion` (`content`, `changelog`, `version`, `createdDate`, `isActive`, `modifiedDate`, `isDeleted`, `contentVersionID`, `FK_authorID`, `FK_contentID`)
    461. 

  461. VALUES
    462. 

  462. 	('<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'),
    463. 

  463. 	('<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'),
    464. 

  464. 	('<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'),
    465. 

  465. 	('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'),
    466. 

  466. 	('<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'),
    467. 

  467. 	('<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'),
    468. 

  468. 	('<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 
    469.