TEXT 38
Db.xml Guest on 30th June 2020 04:40:34 PM
  1. This XML file does not appear to have any style information associated with it. The document tree is shown below.
  2. <schema xmlns="http://www.concrete5.org/doctrine-xml/0.5" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.concrete5.org/doctrine-xml/0.5 http://concrete5.github.io/doctrine-xml/doctrine-xml-0.5.xsd">
  3. <table name="PageTypes">
  4. <field name="ptID" type="integer" size="10">
  5. <unsigned/>
  6. <autoincrement/>
  7. <key/>
  8. </field>
  9. <field name="ptName" type="string" size="255">
  10. <notnull/>
  11. </field>
  12. <field name="ptHandle" type="string" size="128">
  13. <notnull/>
  14. </field>
  15. <field name="ptPublishTargetTypeID" type="integer" size="10">
  16. <unsigned/>
  17. </field>
  18. <field name="ptDefaultPageTemplateID" type="integer" size="10">
  19. <unsigned/>
  20. </field>
  21. <field name="ptAllowedPageTemplates" type="string" size="1">
  22. <default value="A"/>
  23. </field>
  24. <field name="ptIsInternal" type="boolean">
  25. <default value="0"/>
  26. <notnull/>
  27. </field>
  28. <field name="ptIsFrequentlyAdded" type="boolean">
  29. <default value="1"/>
  30. <notnull/>
  31. </field>
  32. <field name="ptDisplayOrder" type="integer" size="10">
  33. <unsigned/>
  34. </field>
  35. <field name="ptLaunchInComposer" type="boolean">
  36. <default value="0"/>
  37. <notnull/>
  38. </field>
  39. <field name="pkgID" type="integer" size="10">
  40. <unsigned/>
  41. <default value="0"/>
  42. <notnull/>
  43. </field>
  44. <field name="ptPublishTargetObject" type="text"/>
  45. <field name="siteTypeID" type="integer" size="10">
  46. <unsigned/>
  47. <default value="0"/>
  48. </field>
  49. <index name="ptHandle">
  50. <unique/>
  51. <col>ptHandle</col>
  52. </index>
  53. <index name="siteTypeID">
  54. <col>siteTypeID</col>
  55. </index>
  56. <index name="pkgID">
  57. <col>pkgID</col>
  58. <col>ptID</col>
  59. </index>
  60. </table>
  61. <table name="PageTypePageTemplates">
  62. <field name="ptID" type="integer" size="10">
  63. <unsigned/>
  64. <key/>
  65. <default value="0"/>
  66. </field>
  67. <field name="pTemplateID" type="integer" size="10">
  68. <unsigned/>
  69. <key/>
  70. <default value="0"/>
  71. </field>
  72. <index name="pTemplateID">
  73. <col>pTemplateID</col>
  74. </index>
  75. </table>
  76. <table name="PageTypeComposerOutputBlocks">
  77. <field name="ptComposerOutputBlockID" type="integer" size="10">
  78. <unsigned/>
  79. <autoincrement/>
  80. <key/>
  81. </field>
  82. <field name="cID" type="integer" size="10">
  83. <unsigned/>
  84. <default value="0"/>
  85. <notnull/>
  86. </field>
  87. <field name="cvID" type="integer" size="10">
  88. <unsigned/>
  89. <default value="0"/>
  90. <notnull/>
  91. </field>
  92. <field name="arHandle" type="string" size="255"/>
  93. <field name="cbDisplayOrder" type="integer" size="10">
  94. <unsigned/>
  95. <default value="0"/>
  96. </field>
  97. <field name="ptComposerFormLayoutSetControlID" type="integer" size="10">
  98. <unsigned/>
  99. <default value="0"/>
  100. <notnull/>
  101. </field>
  102. <field name="bID" type="integer" size="10">
  103. <unsigned/>
  104. <default value="0"/>
  105. </field>
  106. <index name="cID">
  107. <col>cID</col>
  108. </index>
  109. <index name="bID">
  110. <col>bID</col>
  111. <col>cID</col>
  112. </index>
  113. <index name="ptComposerFormLayoutSetControlID">
  114. <col>ptComposerFormLayoutSetControlID</col>
  115. </index>
  116. </table>
  117. <table name="PageTypePublishTargetTypes">
  118. <field name="ptPublishTargetTypeID" type="integer" size="10">
  119. <unsigned/>
  120. <autoincrement/>
  121. <key/>
  122. </field>
  123. <field name="ptPublishTargetTypeHandle" type="string" size="255"/>
  124. <field name="ptPublishTargetTypeName" type="string" size="255"/>
  125. <field name="pkgID" type="integer" size="10">
  126. <unsigned/>
  127. <default value="0"/>
  128. <notnull/>
  129. </field>
  130. <index name="ptPublishTargetTypeHandle">
  131. <col>ptPublishTargetTypeHandle</col>
  132. </index>
  133. <index name="pkgID">
  134. <col>pkgID</col>
  135. </index>
  136. </table>
  137. <table name="PageTypeComposerControlTypes">
  138. <field name="ptComposerControlTypeID" type="integer" size="10">
  139. <unsigned/>
  140. <autoincrement/>
  141. <key/>
  142. </field>
  143. <field name="ptComposerControlTypeHandle" type="string" size="255"/>
  144. <field name="ptComposerControlTypeName" type="string" size="255"/>
  145. <field name="pkgID" type="integer" size="10">
  146. <unsigned/>
  147. <default value="0"/>
  148. <notnull/>
  149. </field>
  150. <index name="pkgID">
  151. <col>pkgID</col>
  152. </index>
  153. <index name="ptComposerControlTypeHandle">
  154. <unique/>
  155. <col>ptComposerControlTypeHandle</col>
  156. </index>
  157. </table>
  158. <table name="PageTypeComposerFormLayoutSets">
  159. <field name="ptComposerFormLayoutSetID" type="integer" size="10">
  160. <unsigned/>
  161. <autoincrement/>
  162. <key/>
  163. </field>
  164. <field name="ptID" type="integer" size="10">
  165. <unsigned/>
  166. <default value="0"/>
  167. </field>
  168. <field name="ptComposerFormLayoutSetName" type="string" size="255"/>
  169. <field name="ptComposerFormLayoutSetDescription" type="text" size="65535"/>
  170. <field name="ptComposerFormLayoutSetDisplayOrder" type="integer" size="10">
  171. <unsigned/>
  172. <default value="0"/>
  173. </field>
  174. <index name="ptID">
  175. <col>ptID</col>
  176. </index>
  177. </table>
  178. <table name="PageTypeComposerFormLayoutSetControls">
  179. <field name="ptComposerFormLayoutSetControlID" type="integer" size="10">
  180. <unsigned/>
  181. <autoincrement/>
  182. <key/>
  183. </field>
  184. <field name="ptComposerFormLayoutSetID" type="integer" size="10">
  185. <unsigned/>
  186. <default value="0"/>
  187. </field>
  188. <field name="ptComposerControlTypeID" type="integer" size="10">
  189. <unsigned/>
  190. <default value="0"/>
  191. </field>
  192. <field name="ptComposerControlObject" type="text"/>
  193. <field name="ptComposerFormLayoutSetControlDisplayOrder" type="integer" size="10">
  194. <unsigned/>
  195. <default value="0"/>
  196. </field>
  197. <field name="ptComposerFormLayoutSetControlCustomLabel" type="string" size="255"/>
  198. <field name="ptComposerFormLayoutSetControlCustomTemplate" type="string" size="255"/>
  199. <field name="ptComposerFormLayoutSetControlDescription" type="string" size="255"/>
  200. <field name="ptComposerFormLayoutSetControlRequired" type="integer" size="10">
  201. <default value="0"/>
  202. </field>
  203. <index name="ptComposerControlTypeID">
  204. <col>ptComposerControlTypeID</col>
  205. </index>
  206. </table>
  207. <table name="MultilingualTranslations">
  208. <field name="mtID" type="integer" size="11">
  209. <unsigned/>
  210. <autoincrement/>
  211. <key/>
  212. </field>
  213. <field name="mtSectionID" type="integer" size="11">
  214. <unsigned/>
  215. <default value="0"/>
  216. <notnull/>
  217. </field>
  218. <field name="msgid" type="text" size="65535">
  219. <notnull/>
  220. </field>
  221. <field name="msgidPlural" type="text" size="65535"/>
  222. <field name="msgstr" type="text" size="65535"/>
  223. <field name="msgstrPlurals" type="text" size="65535"/>
  224. <field name="context" type="text" size="65535"/>
  225. <field name="comments" type="text" size="65535"/>
  226. <field name="reference" type="text" size="65535"/>
  227. <field name="flags" type="text" size="65535"/>
  228. <field name="updated" type="datetime"/>
  229. </table>
  230. <table name="PageTypePageTemplateDefaultPages">
  231. <field name="pTemplateID" type="integer" size="10">
  232. <unsigned/>
  233. <key/>
  234. <default value="0"/>
  235. </field>
  236. <field name="ptID" type="integer" size="10">
  237. <unsigned/>
  238. <key/>
  239. <default value="0"/>
  240. </field>
  241. <field name="cID" type="integer" size="10">
  242. <unsigned/>
  243. <default value="0"/>
  244. </field>
  245. <index name="ptID">
  246. <col>ptID</col>
  247. </index>
  248. <index name="cID">
  249. <col>cID</col>
  250. </index>
  251. </table>
  252. <table name="PageTypeComposerOutputControls">
  253. <field name="ptComposerOutputControlID" type="integer" size="10">
  254. <unsigned/>
  255. <autoincrement/>
  256. <key/>
  257. </field>
  258. <field name="pTemplateID" type="integer" size="10">
  259. <unsigned/>
  260. <default value="0"/>
  261. </field>
  262. <field name="ptID" type="integer" size="10">
  263. <unsigned/>
  264. <default value="0"/>
  265. </field>
  266. <field name="ptComposerFormLayoutSetControlID" type="integer" size="10">
  267. <unsigned/>
  268. <default value="0"/>
  269. </field>
  270. <index name="pTemplateID">
  271. <col>pTemplateID</col>
  272. <col>ptComposerFormLayoutSetControlID</col>
  273. </index>
  274. <index name="ptID">
  275. <col>ptID</col>
  276. </index>
  277. <index name="ptComposerFormLayoutSetControlID">
  278. <col>ptComposerFormLayoutSetControlID</col>
  279. </index>
  280. </table>
  281. <table name="PageTypePermissionAssignments">
  282. <field name="ptID" type="integer" size="10">
  283. <unsigned/>
  284. <key/>
  285. <default value="0"/>
  286. </field>
  287. <field name="pkID" type="integer" size="10">
  288. <unsigned/>
  289. <key/>
  290. <default value="0"/>
  291. </field>
  292. <field name="paID" type="integer" size="10">
  293. <unsigned/>
  294. <key/>
  295. <default value="0"/>
  296. </field>
  297. <index name="pkID">
  298. <col>pkID</col>
  299. </index>
  300. <index name="ptID">
  301. <col>ptID</col>
  302. </index>
  303. </table>
  304. <table name="Features">
  305. <field name="feID" type="integer" size="10">
  306. <unsigned/>
  307. <autoincrement/>
  308. <key/>
  309. </field>
  310. <field name="feHandle" type="string" size="255">
  311. <notnull/>
  312. </field>
  313. <field name="feScore" type="integer" size="10">
  314. <default value="1"/>
  315. <notnull/>
  316. </field>
  317. <field name="feHasCustomClass" type="boolean">
  318. <default value="0"/>
  319. <notnull/>
  320. </field>
  321. <field name="pkgID" type="integer" size="10">
  322. <unsigned/>
  323. </field>
  324. <index name="feHandle">
  325. <unique/>
  326. <col>feHandle</col>
  327. </index>
  328. <index name="pkgID">
  329. <col>pkgID</col>
  330. <col>feID</col>
  331. </index>
  332. </table>
  333. <table name="FeatureCategories">
  334. <field name="fcID" type="integer" size="10">
  335. <unsigned/>
  336. <autoincrement/>
  337. <key/>
  338. </field>
  339. <field name="fcHandle" type="string" size="255">
  340. <notnull/>
  341. </field>
  342. <field name="pkgID" type="integer" size="10">
  343. <unsigned/>
  344. </field>
  345. <index name="fcHandle">
  346. <unique/>
  347. <col>fcHandle</col>
  348. </index>
  349. <index name="pkgID">
  350. <col>pkgID</col>
  351. <col>fcID</col>
  352. </index>
  353. </table>
  354. <table name="FeatureAssignments">
  355. <field name="faID" type="integer" size="10">
  356. <unsigned/>
  357. <autoincrement/>
  358. <key/>
  359. </field>
  360. <field name="feID" type="integer" size="10">
  361. <unsigned/>
  362. </field>
  363. <field name="fcID" type="integer" size="10">
  364. <unsigned/>
  365. </field>
  366. <field name="fdObject" type="text"/>
  367. <index name="feID">
  368. <col>feID</col>
  369. </index>
  370. <index name="fcID">
  371. <col>fcID</col>
  372. </index>
  373. </table>
  374. <table name="BannedWords">
  375. <field name="bwID" type="integer" size="10">
  376. <unsigned/>
  377. <autoincrement/>
  378. <key/>
  379. </field>
  380. <field name="bannedWord" type="text">
  381. <notnull/>
  382. </field>
  383. </table>
  384. <table name="Gatherings">
  385. <field name="gaID" type="integer" size="10">
  386. <unsigned/>
  387. <autoincrement/>
  388. <key/>
  389. </field>
  390. <field name="gaDateCreated" type="datetime">
  391. <notnull/>
  392. </field>
  393. <field name="gaDateLastUpdated" type="datetime">
  394. <notnull/>
  395. </field>
  396. <index name="gaDateLastUpdated">
  397. <col>gaDateLastUpdated</col>
  398. </index>
  399. </table>
  400. <table name="GatheringItemSelectedTemplates">
  401. <field name="gaiID" type="integer" size="10">
  402. <unsigned/>
  403. <key/>
  404. <default value="0"/>
  405. <notnull/>
  406. </field>
  407. <field name="gatID" type="integer" size="10">
  408. <unsigned/>
  409. <key/>
  410. <default value="0"/>
  411. <notnull/>
  412. </field>
  413. <field name="gatTypeID" type="integer" size="10">
  414. <unsigned/>
  415. <default value="0"/>
  416. </field>
  417. <index name="gatUniqueKey">
  418. <unique/>
  419. <col>gaiID</col>
  420. <col>gatTypeID</col>
  421. </index>
  422. <index name="gatTypeID">
  423. <col>gatTypeID</col>
  424. </index>
  425. <index name="gatID">
  426. <col>gatID</col>
  427. </index>
  428. </table>
  429. <table name="GatheringItems">
  430. <field name="gaiID" type="integer" size="10">
  431. <unsigned/>
  432. <autoincrement/>
  433. <key/>
  434. </field>
  435. <field name="gaID" type="integer" size="10">
  436. <unsigned/>
  437. </field>
  438. <field name="gasID" type="integer" size="10">
  439. <unsigned/>
  440. </field>
  441. <field name="gaiDateTimeCreated" type="datetime">
  442. <notnull/>
  443. </field>
  444. <field name="gaiPublicDateTime" type="datetime">
  445. <notnull/>
  446. </field>
  447. <field name="gaiTitle" type="text" size="65535"/>
  448. <field name="gaiSlotWidth" type="integer" size="10">
  449. <unsigned/>
  450. <default value="1"/>
  451. </field>
  452. <field name="gaiSlotHeight" type="integer" size="10">
  453. <unsigned/>
  454. <default value="1"/>
  455. </field>
  456. <field name="gaiKey" type="string" size="255">
  457. <notnull/>
  458. </field>
  459. <field name="gaiBatchDisplayOrder" type="integer" size="10">
  460. <unsigned/>
  461. <default value="0"/>
  462. <notnull/>
  463. </field>
  464. <field name="gaiBatchTimestamp" type="integer" size="10">
  465. <unsigned/>
  466. <default value="0"/>
  467. <notnull/>
  468. </field>
  469. <field name="gaiIsDeleted" type="boolean">
  470. <default value="0"/>
  471. </field>
  472. <index name="gaiUniqueKey">
  473. <unique/>
  474. <col>gaiKey</col>
  475. <col>gasID</col>
  476. <col>gaID</col>
  477. </index>
  478. <index name="gaID">
  479. <col>gaID</col>
  480. <col>gaiBatchTimestamp</col>
  481. </index>
  482. <index name="gasID">
  483. <col>gasID</col>
  484. </index>
  485. </table>
  486. <table name="GatheringPermissionAssignments">
  487. <field name="gaID" type="integer" size="10">
  488. <unsigned/>
  489. <key/>
  490. <default value="0"/>
  491. </field>
  492. <field name="pkID" type="integer" size="10">
  493. <unsigned/>
  494. <key/>
  495. <default value="0"/>
  496. </field>
  497. <field name="paID" type="integer" size="10">
  498. <unsigned/>
  499. <key/>
  500. <default value="0"/>
  501. </field>
  502. <index name="pkID">
  503. <col>pkID</col>
  504. </index>
  505. <index name="paID">
  506. <col>paID</col>
  507. </index>
  508. </table>
  509. <table name="GatheringItemFeatureAssignments">
  510. <field name="gafaID" type="integer" size="10">
  511. <unsigned/>
  512. <autoincrement/>
  513. <key/>
  514. </field>
  515. <field name="gaiID" type="integer" size="10">
  516. <unsigned/>
  517. </field>
  518. <field name="faID" type="integer" size="10">
  519. <unsigned/>
  520. </field>
  521. <index name="gaiID">
  522. <col>gaiID</col>
  523. <col>faID</col>
  524. </index>
  525. <index name="faID">
  526. <col>faID</col>
  527. </index>
  528. </table>
  529. <table name="GatheringItemTemplateTypes">
  530. <field name="gatTypeID" type="integer" size="10">
  531. <unsigned/>
  532. <autoincrement/>
  533. <key/>
  534. </field>
  535. <field name="gatTypeHandle" type="string" size="64">
  536. <notnull/>
  537. </field>
  538. <field name="pkgID" type="integer" size="10">
  539. <unsigned/>
  540. <default value="0"/>
  541. <notnull/>
  542. </field>
  543. <index name="gatTypeHandle">
  544. <unique/>
  545. <col>gatTypeHandle</col>
  546. </index>
  547. <index name="pkgID">
  548. <col>pkgID</col>
  549. </index>
  550. </table>
  551. <table name="GatheringItemTemplates">
  552. <field name="gatID" type="integer" size="10">
  553. <unsigned/>
  554. <autoincrement/>
  555. <key/>
  556. </field>
  557. <field name="gatHandle" type="string" size="255">
  558. <notnull/>
  559. </field>
  560. <field name="gatName" type="text" size="65535"/>
  561. <field name="gatHasCustomClass" type="boolean">
  562. <default value="0"/>
  563. <notnull/>
  564. </field>
  565. <field name="gatFixedSlotWidth" type="integer" size="10">
  566. <unsigned/>
  567. <default value="0"/>
  568. </field>
  569. <field name="gatFixedSlotHeight" type="integer" size="10">
  570. <unsigned/>
  571. <default value="0"/>
  572. </field>
  573. <field name="gatForceDefault" type="integer" size="10">
  574. <unsigned/>
  575. <default value="0"/>
  576. </field>
  577. <field name="pkgID" type="integer" size="10">
  578. <unsigned/>
  579. </field>
  580. <field name="gatTypeID" type="integer" size="10">
  581. <unsigned/>
  582. <default value="0"/>
  583. </field>
  584. <index name="gatHandle">
  585. <unique/>
  586. <col>gatHandle</col>
  587. <col>gatTypeID</col>
  588. </index>
  589. <index name="gatTypeID">
  590. <col>gatTypeID</col>
  591. </index>
  592. <index name="pkgID">
  593. <col>pkgID</col>
  594. </index>
  595. </table>
  596. <table name="GatheringItemTemplateFeatures">
  597. <field name="gfeID" type="integer" size="10">
  598. <unsigned/>
  599. <autoincrement/>
  600. <key/>
  601. </field>
  602. <field name="gatID" type="integer" size="10">
  603. <unsigned/>
  604. </field>
  605. <field name="feID" type="integer" size="10">
  606. <unsigned/>
  607. </field>
  608. <index name="gatID">
  609. <col>gatID</col>
  610. </index>
  611. <index name="feID">
  612. <col>feID</col>
  613. <col>gatID</col>
  614. </index>
  615. </table>
  616. <table name="GatheringDataSources">
  617. <field name="gasID" type="integer" size="10">
  618. <unsigned/>
  619. <autoincrement/>
  620. <key/>
  621. </field>
  622. <field name="gasName" type="string" size="255"/>
  623. <field name="gasHandle" type="string" size="255">
  624. <notnull/>
  625. </field>
  626. <field name="pkgID" type="integer" size="10">
  627. <unsigned/>
  628. <default value="0"/>
  629. <notnull/>
  630. </field>
  631. <field name="gasDisplayOrder" type="integer" size="10">
  632. <unsigned/>
  633. <default value="0"/>
  634. <notnull/>
  635. </field>
  636. <index name="gasHandle">
  637. <unique/>
  638. <col>gasHandle</col>
  639. </index>
  640. <index name="pkgID">
  641. <col>pkgID</col>
  642. </index>
  643. </table>
  644. <table name="GatheringConfiguredDataSources">
  645. <field name="gcsID" type="integer" size="10">
  646. <unsigned/>
  647. <autoincrement/>
  648. <key/>
  649. </field>
  650. <field name="gaID" type="integer" size="10">
  651. <unsigned/>
  652. </field>
  653. <field name="gasID" type="integer" size="10">
  654. <unsigned/>
  655. </field>
  656. <field name="gcdObject" type="text"/>
  657. <index name="gaID">
  658. <col>gaID</col>
  659. </index>
  660. <index name="gasID">
  661. <col>gasID</col>
  662. </index>
  663. </table>
  664. <table name="Conversations">
  665. <field name="cnvID" type="integer" size="10">
  666. <unsigned/>
  667. <autoincrement/>
  668. <key/>
  669. </field>
  670. <field name="cID" type="integer" size="10">
  671. <unsigned/>
  672. <default value="0"/>
  673. </field>
  674. <field name="cnvDateCreated" type="datetime">
  675. <notnull/>
  676. </field>
  677. <field name="cnvDateLastMessage" type="datetime"/>
  678. <field name="cnvParentMessageID" type="integer" size="10">
  679. <unsigned/>
  680. <default value="0"/>
  681. </field>
  682. <field name="cnvAttachmentsEnabled" type="boolean">
  683. <default value="1"/>
  684. <notnull/>
  685. </field>
  686. <field name="cnvMessagesTotal" type="integer" size="10">
  687. <unsigned/>
  688. <default value="0"/>
  689. </field>
  690. <field name="cnvOverrideGlobalPermissions" type="boolean">
  691. <default value="0"/>
  692. </field>
  693. <field name="cnvAttachmentOverridesEnabled" type="boolean">
  694. <default value="0"/>
  695. <notnull/>
  696. </field>
  697. <field name="cnvMaxFilesGuest" type="integer">
  698. <default value="0"/>
  699. </field>
  700. <field name="cnvMaxFilesRegistered" type="integer">
  701. <default value="0"/>
  702. </field>
  703. <field name="cnvMaxFileSizeGuest" type="integer">
  704. <default value="0"/>
  705. </field>
  706. <field name="cnvMaxFileSizeRegistered" type="integer">
  707. <default value="0"/>
  708. </field>
  709. <field name="cnvFileExtensions" type="text" size="65535"/>
  710. <field name="cnvNotificationOverridesEnabled" type="boolean">
  711. <default value="0"/>
  712. <notnull/>
  713. </field>
  714. <field name="cnvEnableSubscription" type="boolean">
  715. <default value="0"/>
  716. </field>
  717. <index name="cID">
  718. <col>cID</col>
  719. </index>
  720. <index name="cnvParentMessageID">
  721. <col>cnvParentMessageID</col>
  722. </index>
  723. </table>
  724. <table name="ConversationFeatureDetailAssignments">
  725. <field name="faID" type="integer" size="10">
  726. <unsigned/>
  727. <key/>
  728. <default value="0"/>
  729. </field>
  730. <field name="cnvID" type="integer" size="10">
  731. <unsigned/>
  732. <default value="0"/>
  733. <notnull/>
  734. </field>
  735. <index name="cnvID">
  736. <col>cnvID</col>
  737. </index>
  738. </table>
  739. <table name="ConversationDiscussions">
  740. <field name="cnvDiscussionID" type="integer" size="10">
  741. <unsigned/>
  742. <autoincrement/>
  743. <key/>
  744. </field>
  745. <field name="cnvDiscussionDateCreated" type="datetime">
  746. <notnull/>
  747. </field>
  748. <field name="cID" type="integer" size="10">
  749. <unsigned/>
  750. </field>
  751. <index name="cID">
  752. <col>cID</col>
  753. </index>
  754. </table>
  755. <table name="gaPage">
  756. <field name="gaiID" type="integer" size="10">
  757. <unsigned/>
  758. <key/>
  759. </field>
  760. <field name="cID" type="integer" size="10">
  761. <unsigned/>
  762. </field>
  763. <index name="cID">
  764. <col>cID</col>
  765. </index>
  766. </table>
  767. <table name="ConversationMessages">
  768. <field name="cnvMessageID" type="integer" size="10">
  769. <unsigned/>
  770. <autoincrement/>
  771. <key/>
  772. </field>
  773. <field name="cnvID" type="integer" size="10">
  774. <unsigned/>
  775. <default value="0"/>
  776. <notnull/>
  777. </field>
  778. <field name="cnvMessageReview" type="integer" size="1">
  779. <unsigned/>
  780. <default value="0"/>
  781. <notnull/>
  782. </field>
  783. <field name="uID" type="integer" size="10">
  784. <unsigned/>
  785. <default value="0"/>
  786. <notnull/>
  787. </field>
  788. <field name="cnvEditorID" type="integer" size="10">
  789. <unsigned/>
  790. <default value="0"/>
  791. <notnull/>
  792. </field>
  793. <field name="cnvMessageAuthorName" type="string" size="255"/>
  794. <field name="cnvMessageAuthorEmail" type="string" size="255"/>
  795. <field name="cnvMessageAuthorWebsite" type="string" size="255"/>
  796. <field name="cnvMessageSubmitIP" type="blob" size="32"/>
  797. <field name="cnvMessageSubmitUserAgent" type="text"/>
  798. <field name="cnvMessageLevel" type="integer" size="10">
  799. <unsigned/>
  800. <default value="0"/>
  801. <notnull/>
  802. </field>
  803. <field name="cnvMessageParentID" type="integer" size="10">
  804. <unsigned/>
  805. <default value="0"/>
  806. <notnull/>
  807. </field>
  808. <field name="cnvMessageDateCreated" type="datetime"/>
  809. <field name="cnvMessageSubject" type="text" size="65535"/>
  810. <field name="cnvMessageBody" type="text" size="65535"/>
  811. <field name="cnvIsMessageDeleted" type="boolean">
  812. <default value="0"/>
  813. <notnull/>
  814. </field>
  815. <field name="cnvIsMessageApproved" type="boolean">
  816. <default value="0"/>
  817. <notnull/>
  818. </field>
  819. <field name="cnvMessageTotalRatingScore" type="bigint">
  820. <default value="0"/>
  821. </field>
  822. <index name="cnvID">
  823. <col>cnvID</col>
  824. </index>
  825. <index name="cnvMessageParentID">
  826. <col>cnvMessageParentID</col>
  827. </index>
  828. <index name="uID">
  829. <col>uID</col>
  830. </index>
  831. </table>
  832. <table name="ConversationFlaggedMessages">
  833. <field name="cnvMessageID" type="integer" size="10">
  834. <unsigned/>
  835. <key/>
  836. </field>
  837. <field name="cnvMessageFlagTypeID" type="integer" size="10"/>
  838. <index name="cnvMessageFlagTypeID">
  839. <col>cnvMessageFlagTypeID</col>
  840. </index>
  841. </table>
  842. <table name="ConversationFlaggedMessageTypes">
  843. <field name="cnvMessageFlagTypeID" type="integer" size="10">
  844. <unsigned/>
  845. <autoincrement/>
  846. <key/>
  847. </field>
  848. <field name="cnvMessageFlagTypeHandle" type="string" size="64"/>
  849. <index name="cnvMessageFlagTypeHandle">
  850. <unique/>
  851. <col>cnvMessageFlagTypeHandle</col>
  852. </index>
  853. </table>
  854. <table name="ConversationEditors">
  855. <field name="cnvEditorID" type="integer" size="11">
  856. <unsigned/>
  857. <autoincrement/>
  858. <key/>
  859. </field>
  860. <field name="cnvEditorHandle" type="string" size="64"/>
  861. <field name="cnvEditorName" type="string" size="255"/>
  862. <field name="cnvEditorIsActive" type="boolean">
  863. <default value="0"/>
  864. <notnull/>
  865. </field>
  866. <field name="pkgID" type="integer" size="10">
  867. <unsigned/>
  868. <default value="0"/>
  869. <notnull/>
  870. </field>
  871. <index name="pkgID">
  872. <col>pkgID</col>
  873. <col>cnvEditorHandle</col>
  874. </index>
  875. </table>
  876. <table name="ConversationMessageAttachments">
  877. <field name="cnvMessageAttachmentID" type="integer" size="11">
  878. <unsigned/>
  879. <autoincrement/>
  880. <key/>
  881. </field>
  882. <field name="cnvMessageID" type="integer" size="11"/>
  883. <field name="fID" type="integer" size="11"/>
  884. <index name="cnvMessageID">
  885. <col>cnvMessageID</col>
  886. </index>
  887. <index name="fID">
  888. <col>fID</col>
  889. </index>
  890. </table>
  891. <table name="ConversationMessageRatings">
  892. <field name="cnvMessageRatingID" type="integer" size="10">
  893. <unsigned/>
  894. <autoincrement/>
  895. <key/>
  896. </field>
  897. <field name="cnvMessageID" type="integer" size="10">
  898. <unsigned/>
  899. </field>
  900. <field name="cnvRatingTypeID" type="integer" size="10">
  901. <unsigned/>
  902. <default value="0"/>
  903. <notnull/>
  904. </field>
  905. <field name="cnvMessageRatingIP" type="blob" size="32"/>
  906. <field name="timestamp" type="datetime"/>
  907. <field name="uID" type="integer" size="10">
  908. <unsigned/>
  909. <default value="0"/>
  910. <notnull/>
  911. </field>
  912. <index name="cnvMessageID">
  913. <col>cnvMessageID</col>
  914. <col>cnvRatingTypeID</col>
  915. </index>
  916. <index name="cnvRatingTypeID">
  917. <col>cnvRatingTypeID</col>
  918. </index>
  919. <index name="uID">
  920. <col>uID</col>
  921. </index>
  922. </table>
  923. <table name="ConversationRatingTypes">
  924. <field name="cnvRatingTypeID" type="integer" size="10">
  925. <unsigned/>
  926. <autoincrement/>
  927. <key/>
  928. </field>
  929. <field name="cnvRatingTypeHandle" type="string" size="255"/>
  930. <field name="cnvRatingTypeName" type="string" size="10"/>
  931. <field name="cnvRatingTypeCommunityPoints" type="integer" size="10"/>
  932. <field name="pkgID" type="integer" size="10">
  933. <unsigned/>
  934. <default value="0"/>
  935. <notnull/>
  936. </field>
  937. <index name="cnvRatingTypeHandle">
  938. <unique/>
  939. <col>cnvRatingTypeHandle</col>
  940. </index>
  941. <index name="pkgID">
  942. <col>pkgID</col>
  943. <col>cnvRatingTypeHandle</col>
  944. </index>
  945. </table>
  946. <table name="PermissionAssignments">
  947. <field name="paID" type="integer" size="10">
  948. <unsigned/>
  949. <key/>
  950. <default value="0"/>
  951. </field>
  952. <field name="pkID" type="integer" size="10">
  953. <unsigned/>
  954. <key/>
  955. <default value="0"/>
  956. <notnull/>
  957. </field>
  958. <index name="pkID">
  959. <col>pkID</col>
  960. </index>
  961. </table>
  962. <table name="PermissionAccess">
  963. <field name="paID" type="integer" size="10">
  964. <unsigned/>
  965. <autoincrement/>
  966. <key/>
  967. </field>
  968. <field name="paIsInUse" type="boolean">
  969. <default value="0"/>
  970. <notnull/>
  971. </field>
  972. </table>
  973. <table name="PermissionAccessList">
  974. <field name="paID" type="integer" size="10">
  975. <unsigned/>
  976. <key/>
  977. <default value="0"/>
  978. </field>
  979. <field name="peID" type="integer" size="10">
  980. <unsigned/>
  981. <key/>
  982. <default value="0"/>
  983. <notnull/>
  984. </field>
  985. <field name="pdID" type="integer" size="10">
  986. <unsigned/>
  987. <default value="0"/>
  988. <notnull/>
  989. </field>
  990. <field name="accessType" type="smallint">
  991. <default value="0"/>
  992. <notnull/>
  993. </field>
  994. <index name="accessType">
  995. <col>accessType</col>
  996. </index>
  997. <index name="peID">
  998. <col>peID</col>
  999. </index>
  1000. <index name="peID_accessType">
  1001. <col>peID</col>
  1002. <col>accessType</col>
  1003. </index>
  1004. <index name="pdID">
  1005. <col>pdID</col>
  1006. </index>
  1007. <index name="permissionAccessDuration">
  1008. <col>paID</col>
  1009. <col>pdID</col>
  1010. </index>
  1011. </table>
  1012. <table name="BlockTypePermissionBlockTypeAccessList">
  1013. <field name="paID" type="integer" size="10">
  1014. <unsigned/>
  1015. <key/>
  1016. <default value="0"/>
  1017. </field>
  1018. <field name="peID" type="integer" size="10">
  1019. <unsigned/>
  1020. <key/>
  1021. <default value="0"/>
  1022. </field>
  1023. <field name="permission" type="string" size="1">
  1024. <default value="1"/>
  1025. <notnull/>
  1026. </field>
  1027. <index name="peID">
  1028. <col>peID</col>
  1029. </index>
  1030. </table>
  1031. <table name="BlockTypePermissionBlockTypeAccessListCustom">
  1032. <field name="paID" type="integer" size="10">
  1033. <unsigned/>
  1034. <key/>
  1035. <default value="0"/>
  1036. </field>
  1037. <field name="peID" type="integer" size="10">
  1038. <unsigned/>
  1039. <key/>
  1040. <default value="0"/>
  1041. </field>
  1042. <field name="btID" type="integer" size="10">
  1043. <unsigned/>
  1044. <key/>
  1045. <default value="0"/>
  1046. </field>
  1047. <index name="peID">
  1048. <col>peID</col>
  1049. </index>
  1050. <index name="btID">
  1051. <col>btID</col>
  1052. </index>
  1053. </table>
  1054. <table name="AreaPermissionBlockTypeAccessList">
  1055. <field name="paID" type="integer" size="10">
  1056. <unsigned/>
  1057. <key/>
  1058. <default value="0"/>
  1059. </field>
  1060. <field name="peID" type="integer" size="10">
  1061. <unsigned/>
  1062. <key/>
  1063. <default value="0"/>
  1064. </field>
  1065. <field name="permission" type="string" size="1">
  1066. <default value="1"/>
  1067. <notnull/>
  1068. </field>
  1069. <index name="peID">
  1070. <col>peID</col>
  1071. </index>
  1072. </table>
  1073. <table name="AreaPermissionBlockTypeAccessListCustom">
  1074. <field name="paID" type="integer" size="10">
  1075. <unsigned/>
  1076. <key/>
  1077. <default value="0"/>
  1078. </field>
  1079. <field name="peID" type="integer" size="10">
  1080. <unsigned/>
  1081. <key/>
  1082. <default value="0"/>
  1083. </field>
  1084. <field name="btID" type="integer" size="10">
  1085. <unsigned/>
  1086. <key/>
  1087. <default value="0"/>
  1088. </field>
  1089. <index name="peID">
  1090. <col>peID</col>
  1091. </index>
  1092. <index name="btID">
  1093. <col>btID</col>
  1094. </index>
  1095. </table>
  1096. <table name="AreaPermissionAssignments">
  1097. <field name="cID" type="integer" size="10">
  1098. <unsigned/>
  1099. <key/>
  1100. <default value="0"/>
  1101. </field>
  1102. <field name="arHandle" type="string" size="255">
  1103. <key/>
  1104. </field>
  1105. <field name="pkID" type="integer" size="10">
  1106. <unsigned/>
  1107. <key/>
  1108. <default value="0"/>
  1109. </field>
  1110. <field name="paID" type="integer" size="10">
  1111. <unsigned/>
  1112. <key/>
  1113. <default value="0"/>
  1114. </field>
  1115. <index name="paID">
  1116. <col>paID</col>
  1117. </index>
  1118. <index name="pkID">
  1119. <col>pkID</col>
  1120. </index>
  1121. </table>
  1122. <table name="BlockPermissionAssignments">
  1123. <field name="cID" type="integer" size="10">
  1124. <unsigned/>
  1125. <key/>
  1126. <default value="0"/>
  1127. </field>
  1128. <field name="cvID" type="integer" size="10">
  1129. <unsigned/>
  1130. <key/>
  1131. <default value="0"/>
  1132. </field>
  1133. <field name="bID" type="integer" size="10">
  1134. <unsigned/>
  1135. <key/>
  1136. <default value="0"/>
  1137. </field>
  1138. <field name="pkID" type="integer" size="10">
  1139. <unsigned/>
  1140. <key/>
  1141. <default value="0"/>
  1142. </field>
  1143. <field name="paID" type="integer" size="10">
  1144. <unsigned/>
  1145. <key/>
  1146. <default value="0"/>
  1147. </field>
  1148. <index name="bID">
  1149. <col>bID</col>
  1150. </index>
  1151. <index name="pkID">
  1152. <col>pkID</col>
  1153. </index>
  1154. <index name="paID">
  1155. <col>paID</col>
  1156. </index>
  1157. </table>
  1158. <table name="Areas">
  1159. <field name="arID" type="integer" size="10">
  1160. <unsigned/>
  1161. <autoincrement/>
  1162. <key/>
  1163. </field>
  1164. <field name="cID" type="integer" size="10">
  1165. <unsigned/>
  1166. <default value="0"/>
  1167. <notnull/>
  1168. </field>
  1169. <field name="arHandle" type="string" size="255">
  1170. <notnull/>
  1171. </field>
  1172. <field name="arOverrideCollectionPermissions" type="boolean">
  1173. <default value="0"/>
  1174. <notnull/>
  1175. </field>
  1176. <field name="arInheritPermissionsFromAreaOnCID" type="integer" size="10">
  1177. <unsigned/>
  1178. <default value="0"/>
  1179. <notnull/>
  1180. </field>
  1181. <field name="arIsGlobal" type="boolean">
  1182. <default value="0"/>
  1183. <notnull/>
  1184. </field>
  1185. <field name="arParentID" type="integer" size="10">
  1186. <unsigned/>
  1187. <default value="0"/>
  1188. <notnull/>
  1189. </field>
  1190. <index name="arIsGlobal">
  1191. <col>arIsGlobal</col>
  1192. </index>
  1193. <index name="cID">
  1194. <col>cID</col>
  1195. </index>
  1196. <index name="arHandle">
  1197. <col>arHandle</col>
  1198. </index>
  1199. <index name="arParentID">
  1200. <col>arParentID</col>
  1201. </index>
  1202. </table>
  1203. <table name="AreaLayouts">
  1204. <field name="arLayoutID" type="integer">
  1205. <unsigned/>
  1206. <autoincrement/>
  1207. <key/>
  1208. </field>
  1209. <field name="arLayoutSpacing" type="integer">
  1210. <unsigned/>
  1211. <default value="0"/>
  1212. <notnull/>
  1213. </field>
  1214. <field name="arLayoutIsCustom" type="boolean">
  1215. <default value="0"/>
  1216. <notnull/>
  1217. </field>
  1218. <field name="arLayoutIsPreset" type="boolean">
  1219. <default value="0"/>
  1220. <notnull/>
  1221. </field>
  1222. <field name="arLayoutMaxColumns" type="integer">
  1223. <unsigned/>
  1224. <default value="0"/>
  1225. <notnull/>
  1226. </field>
  1227. <field name="arLayoutUsesThemeGridFramework" type="boolean">
  1228. <default value="0"/>
  1229. <notnull/>
  1230. </field>
  1231. </table>
  1232. <table name="AreaLayoutsUsingPresets">
  1233. <field name="arLayoutID" type="integer">
  1234. <unsigned/>
  1235. <key/>
  1236. </field>
  1237. <field name="preset" type="string">
  1238. <default value=""/>
  1239. <notnull/>
  1240. </field>
  1241. </table>
  1242. <table name="AreaLayoutPresets">
  1243. <field name="arLayoutPresetID" type="integer">
  1244. <unsigned/>
  1245. <autoincrement/>
  1246. <key/>
  1247. </field>
  1248. <field name="arLayoutID" type="integer">
  1249. <unsigned/>
  1250. <default value="0"/>
  1251. <notnull/>
  1252. </field>
  1253. <field name="arLayoutPresetName" type="string" size="255"/>
  1254. <index name="arLayoutID">
  1255. <col>arLayoutID</col>
  1256. </index>
  1257. <index name="arLayoutPresetName">
  1258. <col>arLayoutPresetName</col>
  1259. </index>
  1260. </table>
  1261. <table name="AreaLayoutColumns">
  1262. <field name="arLayoutColumnID" type="integer">
  1263. <unsigned/>
  1264. <autoincrement/>
  1265. <key/>
  1266. </field>
  1267. <field name="arLayoutID" type="integer">
  1268. <unsigned/>
  1269. <default value="0"/>
  1270. <notnull/>
  1271. </field>
  1272. <field name="arLayoutColumnIndex" type="integer">
  1273. <unsigned/>
  1274. <default value="0"/>
  1275. <notnull/>
  1276. </field>
  1277. <field name="arID" type="integer">
  1278. <unsigned/>
  1279. <default value="0"/>
  1280. <notnull/>
  1281. </field>
  1282. <field name="arLayoutColumnDisplayID" type="integer">
  1283. <default value="0"/>
  1284. </field>
  1285. <index name="arLayoutID">
  1286. <col>arLayoutID</col>
  1287. <col>arLayoutColumnIndex</col>
  1288. </index>
  1289. <index name="arID">
  1290. <col>arID</col>
  1291. </index>
  1292. <index name="arLayoutColumnDisplayID">
  1293. <col>arLayoutColumnDisplayID</col>
  1294. </index>
  1295. </table>
  1296. <table name="AreaLayoutCustomColumns">
  1297. <field name="arLayoutColumnID" type="integer">
  1298. <unsigned/>
  1299. <autoincrement/>
  1300. <key/>
  1301. </field>
  1302. <field name="arLayoutColumnWidth" type="string" size="64">
  1303. <notnull/>
  1304. </field>
  1305. </table>
  1306. <table name="AreaLayoutThemeGridColumns">
  1307. <field name="arLayoutColumnID" type="integer">
  1308. <unsigned/>
  1309. <autoincrement/>
  1310. <key/>
  1311. </field>
  1312. <field name="arLayoutColumnSpan" type="integer">
  1313. <unsigned/>
  1314. <default value="0"/>
  1315. </field>
  1316. <field name="arLayoutColumnOffset" type="integer">
  1317. <unsigned/>
  1318. <default value="0"/>
  1319. </field>
  1320. </table>
  1321. <table name="AuthenticationTypes">
  1322. <field name="authTypeID" type="integer" size="10">
  1323. <unsigned/>
  1324. <autoincrement/>
  1325. <key/>
  1326. </field>
  1327. <field name="authTypeHandle" type="string" size="255">
  1328. <notnull/>
  1329. </field>
  1330. <field name="authTypeName" type="string" size="255">
  1331. <notnull/>
  1332. </field>
  1333. <field name="authTypeIsEnabled" type="boolean">
  1334. <notnull/>
  1335. </field>
  1336. <field name="authTypeDisplayOrder" type="integer" size="10">
  1337. <unsigned/>
  1338. </field>
  1339. <field name="pkgID" type="integer" size="10">
  1340. <unsigned/>
  1341. </field>
  1342. <index name="authTypeHandle">
  1343. <unique/>
  1344. <col>authTypeHandle</col>
  1345. </index>
  1346. <index name="pkgID">
  1347. <col>pkgID</col>
  1348. </index>
  1349. </table>
  1350. <table name="BlockTypeSetBlockTypes">
  1351. <field name="btID" type="integer" size="10">
  1352. <unsigned/>
  1353. <key/>
  1354. <default value="0"/>
  1355. </field>
  1356. <field name="btsID" type="integer" size="10">
  1357. <unsigned/>
  1358. <key/>
  1359. <default value="0"/>
  1360. </field>
  1361. <field name="displayOrder" type="integer" size="10">
  1362. <unsigned/>
  1363. <default value="0"/>
  1364. <notnull/>
  1365. </field>
  1366. <index name="btsID">
  1367. <col>btsID</col>
  1368. <col>displayOrder</col>
  1369. </index>
  1370. </table>
  1371. <table name="BlockTypeSets">
  1372. <field name="btsID" type="integer" size="10">
  1373. <unsigned/>
  1374. <autoincrement/>
  1375. <key/>
  1376. </field>
  1377. <field name="btsName" type="string" size="255"/>
  1378. <field name="btsHandle" type="string" size="255">
  1379. <notnull/>
  1380. </field>
  1381. <field name="pkgID" type="integer" size="10">
  1382. <unsigned/>
  1383. <default value="0"/>
  1384. <notnull/>
  1385. </field>
  1386. <field name="btsDisplayOrder" type="integer" size="10">
  1387. <unsigned/>
  1388. <default value="0"/>
  1389. <notnull/>
  1390. </field>
  1391. <index name="btsHandle">
  1392. <unique/>
  1393. <col>btsHandle</col>
  1394. </index>
  1395. <index name="btsDisplayOrder">
  1396. <col>btsDisplayOrder</col>
  1397. </index>
  1398. <index name="pkgID">
  1399. <col>pkgID</col>
  1400. </index>
  1401. </table>
  1402. <table name="Blocks">
  1403. <field name="bID" type="integer" size="10">
  1404. <unsigned/>
  1405. <autoincrement/>
  1406. <key/>
  1407. </field>
  1408. <field name="bName" type="string" size="60"/>
  1409. <field name="bDateAdded" type="datetime">
  1410. <default value="1000-01-01 00:00:00"/>
  1411. <notnull/>
  1412. </field>
  1413. <field name="bDateModified" type="datetime">
  1414. <default value="1000-01-01 00:00:00"/>
  1415. <notnull/>
  1416. </field>
  1417. <field name="bFilename" type="string" size="255"/>
  1418. <field name="bIsActive" type="string" size="1">
  1419. <default value="1"/>
  1420. <notnull/>
  1421. </field>
  1422. <field name="btID" type="integer" size="10">
  1423. <unsigned/>
  1424. <default value="0"/>
  1425. <notnull/>
  1426. </field>
  1427. <field name="uID" type="integer" size="10">
  1428. <unsigned/>
  1429. </field>
  1430. <field name="btCachedBlockRecord" type="text"/>
  1431. <index name="btID">
  1432. <col>btID</col>
  1433. </index>
  1434. <index name="uID">
  1435. <col>uID</col>
  1436. </index>
  1437. </table>
  1438. <table name="CollectionVersionBlocksOutputCache">
  1439. <field name="cID" type="integer" size="10">
  1440. <unsigned/>
  1441. <key/>
  1442. <default value="0"/>
  1443. </field>
  1444. <field name="cvID" type="integer" size="10">
  1445. <unsigned/>
  1446. <key/>
  1447. <default value="1"/>
  1448. </field>
  1449. <field name="bID" type="integer" size="10">
  1450. <unsigned/>
  1451. <key/>
  1452. <default value="0"/>
  1453. </field>
  1454. <field name="arHandle" type="string" size="255">
  1455. <key/>
  1456. </field>
  1457. <field name="btCachedBlockOutput" type="text"/>
  1458. <field name="btCachedBlockOutputExpires" type="integer" size="10">
  1459. <unsigned/>
  1460. <default value="0"/>
  1461. <notnull/>
  1462. </field>
  1463. <index name="bID">
  1464. <col>bID</col>
  1465. <col>cID</col>
  1466. <col>cvID</col>
  1467. <col>arHandle</col>
  1468. </index>
  1469. </table>
  1470. <table name="CollectionVersionBlocksCacheSettings">
  1471. <field name="cID" type="integer" size="10">
  1472. <unsigned/>
  1473. <key/>
  1474. <default value="0"/>
  1475. </field>
  1476. <field name="cvID" type="integer" size="10">
  1477. <unsigned/>
  1478. <key/>
  1479. <default value="1"/>
  1480. </field>
  1481. <field name="bID" type="integer" size="10">
  1482. <unsigned/>
  1483. <key/>
  1484. <default value="0"/>
  1485. </field>
  1486. <field name="arHandle" type="string" size="255">
  1487. <key/>
  1488. </field>
  1489. <field name="btCacheBlockOutput" type="boolean">
  1490. <default value="0"/>
  1491. <notnull/>
  1492. </field>
  1493. <field name="btCacheBlockOutputOnPost" type="boolean">
  1494. <default value="0"/>
  1495. <notnull/>
  1496. </field>
  1497. <field name="btCacheBlockOutputForRegisteredUsers" type="boolean">
  1498. <default value="0"/>
  1499. <notnull/>
  1500. </field>
  1501. <field name="btCacheBlockOutputLifetime" type="integer" size="10">
  1502. <unsigned/>
  1503. <default value="0"/>
  1504. <notnull/>
  1505. </field>
  1506. <index name="bID">
  1507. <col>bID</col>
  1508. <col>cID</col>
  1509. <col>cvID</col>
  1510. <col>arHandle</col>
  1511. </index>
  1512. </table>
  1513. <table name="CollectionVersionFeatureAssignments">
  1514. <field name="cID" type="integer" size="10">
  1515. <unsigned/>
  1516. <key/>
  1517. <default value="0"/>
  1518. </field>
  1519. <field name="cvID" type="integer" size="10">
  1520. <unsigned/>
  1521. <key/>
  1522. <default value="1"/>
  1523. </field>
  1524. <field name="faID" type="integer" size="10">
  1525. <unsigned/>
  1526. <key/>
  1527. <default value="0"/>
  1528. </field>
  1529. <index name="faID">
  1530. <col>faID</col>
  1531. </index>
  1532. </table>
  1533. <table name="CollectionVersionThemeCustomStyles">
  1534. <field name="cID" type="integer" size="10">
  1535. <unsigned/>
  1536. <key/>
  1537. <default value="0"/>
  1538. </field>
  1539. <field name="cvID" type="integer" size="10">
  1540. <unsigned/>
  1541. <key/>
  1542. <default value="1"/>
  1543. </field>
  1544. <field name="pThemeID" type="integer" size="10">
  1545. <unsigned/>
  1546. <key/>
  1547. <default value="0"/>
  1548. </field>
  1549. <field name="scvlID" type="integer" size="10">
  1550. <unsigned/>
  1551. <default value="0"/>
  1552. </field>
  1553. <field name="preset" type="string" size="255"/>
  1554. <field name="sccRecordID" type="integer" size="10">
  1555. <unsigned/>
  1556. <default value="0"/>
  1557. </field>
  1558. <index name="pThemeID">
  1559. <col>pThemeID</col>
  1560. </index>
  1561. <index name="scvlID">
  1562. <col>scvlID</col>
  1563. </index>
  1564. <index name="sccRecordID">
  1565. <col>sccRecordID</col>
  1566. </index>
  1567. </table>
  1568. <table name="BlockFeatureAssignments">
  1569. <field name="cID" type="integer" size="10">
  1570. <unsigned/>
  1571. <key/>
  1572. <default value="0"/>
  1573. </field>
  1574. <field name="cvID" type="integer" size="10">
  1575. <unsigned/>
  1576. <key/>
  1577. <default value="0"/>
  1578. </field>
  1579. <field name="bID" type="integer" size="10">
  1580. <unsigned/>
  1581. <key/>
  1582. <default value="0"/>
  1583. </field>
  1584. <field name="faID" type="integer" size="10">
  1585. <unsigned/>
  1586. <key/>
  1587. <default value="0"/>
  1588. </field>
  1589. <index name="faID">
  1590. <col>faID</col>
  1591. <col>cID</col>
  1592. <col>cvID</col>
  1593. </index>
  1594. <index name="bID">
  1595. <col>bID</col>
  1596. </index>
  1597. </table>
  1598. <table name="CollectionVersionRelatedEdits">
  1599. <field name="cID" type="integer" size="10">
  1600. <unsigned/>
  1601. <key/>
  1602. <default value="0"/>
  1603. </field>
  1604. <field name="cvID" type="integer" size="10">
  1605. <unsigned/>
  1606. <key/>
  1607. <default value="0"/>
  1608. </field>
  1609. <field name="cRelationID" type="integer" size="10">
  1610. <unsigned/>
  1611. <key/>
  1612. <default value="0"/>
  1613. </field>
  1614. <field name="cvRelationID" type="integer" size="10">
  1615. <unsigned/>
  1616. <key/>
  1617. <default value="0"/>
  1618. </field>
  1619. </table>
  1620. <table name="CollectionVersionBlocks">
  1621. <field name="cID" type="integer" size="10">
  1622. <unsigned/>
  1623. <key/>
  1624. <default value="0"/>
  1625. </field>
  1626. <field name="cvID" type="integer" size="10">
  1627. <unsigned/>
  1628. <key/>
  1629. <default value="1"/>
  1630. </field>
  1631. <field name="bID" type="integer" size="10">
  1632. <unsigned/>
  1633. <key/>
  1634. <default value="0"/>
  1635. </field>
  1636. <field name="arHandle" type="string" size="255">
  1637. <key/>
  1638. </field>
  1639. <field name="cbRelationID" type="integer" size="10">
  1640. <unsigned/>
  1641. <default value="0"/>
  1642. </field>
  1643. <field name="cbDisplayOrder" type="integer" size="10">
  1644. <unsigned/>
  1645. <default value="0"/>
  1646. <notnull/>
  1647. </field>
  1648. <field name="isOriginal" type="boolean">
  1649. <default value="0"/>
  1650. <notnull/>
  1651. </field>
  1652. <field name="cbOverrideAreaPermissions" type="boolean">
  1653. <default value="0"/>
  1654. <notnull/>
  1655. </field>
  1656. <field name="cbIncludeAll" type="boolean">
  1657. <default value="0"/>
  1658. <notnull/>
  1659. </field>
  1660. <field name="cbOverrideBlockTypeCacheSettings" type="boolean">
  1661. <default value="0"/>
  1662. <notnull/>
  1663. </field>
  1664. <field name="cbOverrideBlockTypeContainerSettings" type="boolean">
  1665. <default value="0"/>
  1666. <notnull/>
  1667. </field>
  1668. <field name="cbEnableBlockContainer" type="boolean">
  1669. <default value="0"/>
  1670. <notnull/>
  1671. </field>
  1672. <index name="bID">
  1673. <col>bID</col>
  1674. <col>cID</col>
  1675. </index>
  1676. <index name="cbRelationID">
  1677. <col>cbRelationID</col>
  1678. </index>
  1679. </table>
  1680. <table name="CollectionVersionBlockStyles">
  1681. <field name="cID" type="integer" size="10">
  1682. <unsigned/>
  1683. <key/>
  1684. <default value="0"/>
  1685. </field>
  1686. <field name="cvID" type="integer" size="10">
  1687. <unsigned/>
  1688. <key/>
  1689. <default value="0"/>
  1690. </field>
  1691. <field name="bID" type="integer" size="10">
  1692. <unsigned/>
  1693. <key/>
  1694. <default value="0"/>
  1695. </field>
  1696. <field name="arHandle" type="string" size="255">
  1697. <key/>
  1698. </field>
  1699. <field name="issID" type="integer" size="10">
  1700. <unsigned/>
  1701. <default value="0"/>
  1702. <notnull/>
  1703. </field>
  1704. <index name="bID">
  1705. <col>bID</col>
  1706. <col>issID</col>
  1707. </index>
  1708. <index name="issID">
  1709. <col>issID</col>
  1710. </index>
  1711. </table>
  1712. <table name="CollectionVersionAreaStyles">
  1713. <field name="cID" type="integer" size="10">
  1714. <unsigned/>
  1715. <key/>
  1716. <default value="0"/>
  1717. </field>
  1718. <field name="cvID" type="integer" size="10">
  1719. <unsigned/>
  1720. <key/>
  1721. <default value="0"/>
  1722. </field>
  1723. <field name="arHandle" type="string" size="255">
  1724. <key/>
  1725. </field>
  1726. <field name="issID" type="integer" size="10">
  1727. <unsigned/>
  1728. <default value="0"/>
  1729. <notnull/>
  1730. </field>
  1731. <index name="issID">
  1732. <col>issID</col>
  1733. </index>
  1734. </table>
  1735. <table name="CollectionVersions">
  1736. <field name="cID" type="integer" size="10">
  1737. <unsigned/>
  1738. <key/>
  1739. <default value="0"/>
  1740. </field>
  1741. <field name="cvID" type="integer" size="10">
  1742. <unsigned/>
  1743. <key/>
  1744. <default value="1"/>
  1745. </field>
  1746. <field name="cvName" type="text" size="65535"/>
  1747. <field name="cvHandle" type="string" size="255"/>
  1748. <field name="cvDescription" type="text" size="65535"/>
  1749. <field name="cvDatePublic" type="datetime"/>
  1750. <field name="cvDateCreated" type="datetime">
  1751. <default value="1000-01-01 00:00:00"/>
  1752. <notnull/>
  1753. </field>
  1754. <field name="cvComments" type="string" size="255"/>
  1755. <field name="cvIsApproved" type="boolean">
  1756. <default value="0"/>
  1757. <notnull/>
  1758. </field>
  1759. <field name="cvIsNew" type="boolean">
  1760. <default value="0"/>
  1761. <notnull/>
  1762. </field>
  1763. <field name="cvAuthorUID" type="integer" size="10">
  1764. <unsigned/>
  1765. </field>
  1766. <field name="cvApproverUID" type="integer" size="10">
  1767. <unsigned/>
  1768. </field>
  1769. <field name="pThemeID" type="integer" size="10">
  1770. <unsigned/>
  1771. <default value="0"/>
  1772. <notnull/>
  1773. </field>
  1774. <field name="pTemplateID" type="integer" size="10">
  1775. <unsigned/>
  1776. <default value="0"/>
  1777. <notnull/>
  1778. </field>
  1779. <field name="cvActivateDatetime" type="datetime"/>
  1780. <field name="cvPublishDate" type="datetime"/>
  1781. <index name="cvIsApproved">
  1782. <col>cvIsApproved</col>
  1783. </index>
  1784. <index name="cvAuthorUID">
  1785. <col>cvAuthorUID</col>
  1786. </index>
  1787. <index name="cvApproverUID">
  1788. <col>cvApproverUID</col>
  1789. </index>
  1790. <index name="pThemeID">
  1791. <col>pThemeID</col>
  1792. </index>
  1793. <index name="pTemplateID">
  1794. <col>pTemplateID</col>
  1795. </index>
  1796. </table>
  1797. <table name="Collections">
  1798. <field name="cID" type="integer" size="10">
  1799. <unsigned/>
  1800. <autoincrement/>
  1801. <key/>
  1802. </field>
  1803. <field name="cDateAdded" type="datetime">
  1804. <default value="1000-01-01 00:00:00"/>
  1805. <notnull/>
  1806. </field>
  1807. <field name="cDateModified" type="datetime">
  1808. <default value="1000-01-01 00:00:00"/>
  1809. <notnull/>
  1810. </field>
  1811. <field name="cHandle" type="string" size="255"/>
  1812. <index name="cIDDateModified">
  1813. <col>cID</col>
  1814. <col>cDateModified</col>
  1815. </index>
  1816. <index name="cDateModified">
  1817. <col>cDateModified</col>
  1818. </index>
  1819. <index name="cDateAdded">
  1820. <col>cDateAdded</col>
  1821. </index>
  1822. </table>
  1823. <table name="Config">
  1824. <field name="configNamespace" type="string" size="255">
  1825. <key/>
  1826. <default value=""/>
  1827. <notnull/>
  1828. </field>
  1829. <field name="configGroup" type="string" size="255">
  1830. <key/>
  1831. </field>
  1832. <field name="configItem" type="string" size="255">
  1833. <key/>
  1834. </field>
  1835. <field name="configValue" type="text"/>
  1836. <index name="configGroup">
  1837. <col>configGroup</col>
  1838. </index>
  1839. </table>
  1840. <table name="ConfigStore">
  1841. <field name="cfKey" type="string" size="64">
  1842. <key/>
  1843. </field>
  1844. <field name="timestamp" type="timestamp">
  1845. <deftimestamp/>
  1846. <notnull/>
  1847. </field>
  1848. <field name="cfValue" type="text"/>
  1849. <field name="uID" type="integer" size="10">
  1850. <unsigned/>
  1851. <key/>
  1852. <default value="0"/>
  1853. </field>
  1854. <field name="pkgID" type="integer" size="10">
  1855. <unsigned/>
  1856. <default value="0"/>
  1857. <notnull/>
  1858. </field>
  1859. <index name="uID">
  1860. <col>uID</col>
  1861. <col>cfKey</col>
  1862. </index>
  1863. <index name="pkgID">
  1864. <col>pkgID</col>
  1865. <col>cfKey</col>
  1866. </index>
  1867. </table>
  1868. <table name="DownloadStatistics">
  1869. <field name="dsID" type="integer" size="10">
  1870. <unsigned/>
  1871. <autoincrement/>
  1872. <key/>
  1873. </field>
  1874. <field name="fID" type="integer" size="10">
  1875. <unsigned/>
  1876. <notnull/>
  1877. </field>
  1878. <field name="fvID" type="integer" size="10">
  1879. <unsigned/>
  1880. <notnull/>
  1881. </field>
  1882. <field name="uID" type="integer" size="10">
  1883. <unsigned/>
  1884. <notnull/>
  1885. </field>
  1886. <field name="rcID" type="integer" size="10">
  1887. <unsigned/>
  1888. <notnull/>
  1889. </field>
  1890. <field name="timestamp" type="timestamp">
  1891. <deftimestamp/>
  1892. <notnull/>
  1893. </field>
  1894. <index name="fID">
  1895. <col>fID</col>
  1896. <col>timestamp</col>
  1897. </index>
  1898. <index name="fvID">
  1899. <col>fID</col>
  1900. <col>fvID</col>
  1901. </index>
  1902. <index name="uID">
  1903. <col>uID</col>
  1904. </index>
  1905. <index name="rcID">
  1906. <col>rcID</col>
  1907. </index>
  1908. <index name="timestamp">
  1909. <col>timestamp</col>
  1910. </index>
  1911. </table>
  1912. <table name="FilePermissionFileTypes">
  1913. <field name="fsID" type="integer" size="10">
  1914. <unsigned/>
  1915. <key/>
  1916. <default value="0"/>
  1917. </field>
  1918. <field name="gID" type="integer" size="10">
  1919. <unsigned/>
  1920. <key/>
  1921. <default value="0"/>
  1922. </field>
  1923. <field name="uID" type="integer" size="10">
  1924. <unsigned/>
  1925. <key/>
  1926. <default value="0"/>
  1927. </field>
  1928. <field name="extension" type="string" size="32">
  1929. <key/>
  1930. </field>
  1931. <index name="gID">
  1932. <col>gID</col>
  1933. </index>
  1934. <index name="uID">
  1935. <col>uID</col>
  1936. </index>
  1937. </table>
  1938. <table name="StyleCustomizerInlineStylePresets">
  1939. <field name="pssPresetID" type="integer" size="10">
  1940. <unsigned/>
  1941. <autoincrement/>
  1942. <key/>
  1943. </field>
  1944. <field name="pssPresetName" type="string" size="255">
  1945. <notnull/>
  1946. </field>
  1947. <field name="issID" type="integer" size="10">
  1948. <unsigned/>
  1949. <default value="0"/>
  1950. <notnull/>
  1951. </field>
  1952. <index name="issID">
  1953. <col>issID</col>
  1954. </index>
  1955. </table>
  1956. <table name="StyleCustomizerValueLists">
  1957. <field name="scvlID" type="integer" size="10">
  1958. <unsigned/>
  1959. <autoincrement/>
  1960. <key/>
  1961. </field>
  1962. </table>
  1963. <table name="StyleCustomizerValues">
  1964. <field name="scvID" type="integer" size="10">
  1965. <unsigned/>
  1966. <autoincrement/>
  1967. <key/>
  1968. </field>
  1969. <field name="scvlID" type="integer" size="10">
  1970. <unsigned/>
  1971. </field>
  1972. <field name="value" type="text" size="65535"/>
  1973. <index name="scvlID">
  1974. <col>scvlID</col>
  1975. </index>
  1976. </table>
  1977. <table name="PermissionKeys">
  1978. <field name="pkID" type="integer" size="10">
  1979. <unsigned/>
  1980. <autoincrement/>
  1981. <key/>
  1982. </field>
  1983. <field name="pkHandle" type="string" size="255">
  1984. <notnull/>
  1985. </field>
  1986. <field name="pkName" type="string" size="255">
  1987. <notnull/>
  1988. </field>
  1989. <field name="pkCanTriggerWorkflow" type="boolean">
  1990. <default value="0"/>
  1991. <notnull/>
  1992. </field>
  1993. <field name="pkHasCustomClass" type="boolean">
  1994. <default value="0"/>
  1995. <notnull/>
  1996. </field>
  1997. <field name="pkDescription" type="string" size="255"/>
  1998. <field name="pkCategoryID" type="integer" size="10">
  1999. <unsigned/>
  2000. </field>
  2001. <field name="pkgID" type="integer" size="10">
  2002. <unsigned/>
  2003. </field>
  2004. <index name="akHandle">
  2005. <unique/>
  2006. <col>pkHandle</col>
  2007. </index>
  2008. <index name="pkCategoryID">
  2009. <col>pkCategoryID</col>
  2010. </index>
  2011. <index name="pkgID">
  2012. <col>pkgID</col>
  2013. </index>
  2014. </table>
  2015. <table name="PermissionKeyCategories">
  2016. <field name="pkCategoryID" type="integer" size="10">
  2017. <unsigned/>
  2018. <autoincrement/>
  2019. <key/>
  2020. </field>
  2021. <field name="pkCategoryHandle" type="string" size="255">
  2022. <notnull/>
  2023. </field>
  2024. <field name="pkgID" type="integer" size="10">
  2025. <unsigned/>
  2026. </field>
  2027. <index name="pkCategoryHandle">
  2028. <unique/>
  2029. <col>pkCategoryHandle</col>
  2030. </index>
  2031. <index name="pkgID">
  2032. <col>pkgID</col>
  2033. </index>
  2034. </table>
  2035. <table name="PermissionAccessEntityTypes">
  2036. <field name="petID" type="integer" size="10">
  2037. <unsigned/>
  2038. <autoincrement/>
  2039. <key/>
  2040. </field>
  2041. <field name="petHandle" type="string" size="255">
  2042. <notnull/>
  2043. </field>
  2044. <field name="petName" type="string" size="255">
  2045. <notnull/>
  2046. </field>
  2047. <field name="pkgID" type="integer" size="10">
  2048. <unsigned/>
  2049. </field>
  2050. <index name="petHandle">
  2051. <unique/>
  2052. <col>petHandle</col>
  2053. </index>
  2054. <index name="pkgID">
  2055. <col>pkgID</col>
  2056. </index>
  2057. </table>
  2058. <table name="PermissionAccessEntityTypeCategories">
  2059. <field name="petID" type="integer" size="10">
  2060. <unsigned/>
  2061. <key/>
  2062. <default value="0"/>
  2063. </field>
  2064. <field name="pkCategoryID" type="integer" size="10">
  2065. <unsigned/>
  2066. <key/>
  2067. <default value="0"/>
  2068. </field>
  2069. <index name="pkCategoryID">
  2070. <col>pkCategoryID</col>
  2071. </index>
  2072. </table>
  2073. <table name="PermissionAccessEntities">
  2074. <field name="peID" type="integer" size="10">
  2075. <unsigned/>
  2076. <autoincrement/>
  2077. <key/>
  2078. </field>
  2079. <field name="petID" type="integer" size="10">
  2080. <unsigned/>
  2081. </field>
  2082. <index name="petID">
  2083. <col>petID</col>
  2084. </index>
  2085. </table>
  2086. <table name="PermissionAccessEntityUsers">
  2087. <field name="peID" type="integer" size="10">
  2088. <unsigned/>
  2089. <key/>
  2090. <default value="0"/>
  2091. </field>
  2092. <field name="uID" type="integer" size="10">
  2093. <unsigned/>
  2094. <key/>
  2095. <default value="0"/>
  2096. </field>
  2097. <index name="uID">
  2098. <col>uID</col>
  2099. </index>
  2100. </table>
  2101. <table name="PermissionAccessEntityGroupSets">
  2102. <field name="peID" type="integer" size="10">
  2103. <unsigned/>
  2104. <key/>
  2105. <default value="0"/>
  2106. </field>
  2107. <field name="gsID" type="integer" size="10">
  2108. <unsigned/>
  2109. <key/>
  2110. <default value="0"/>
  2111. </field>
  2112. <index name="gsID">
  2113. <col>gsID</col>
  2114. </index>
  2115. </table>
  2116. <table name="PermissionAccessEntityGroups">
  2117. <field name="pegID" type="integer" size="10">
  2118. <unsigned/>
  2119. <autoincrement/>
  2120. <key/>
  2121. </field>
  2122. <field name="peID" type="integer" size="10">
  2123. <unsigned/>
  2124. <default value="0"/>
  2125. <notnull/>
  2126. </field>
  2127. <field name="gID" type="integer" size="10">
  2128. <unsigned/>
  2129. <default value="0"/>
  2130. <notnull/>
  2131. </field>
  2132. <index name="peID">
  2133. <col>peID</col>
  2134. </index>
  2135. <index name="gID">
  2136. <col>gID</col>
  2137. </index>
  2138. </table>
  2139. <table name="PermissionDurationObjects">
  2140. <field name="pdID" type="integer" size="10">
  2141. <unsigned/>
  2142. <autoincrement/>
  2143. <key/>
  2144. </field>
  2145. <field name="pdObject" type="text" size="65535">
  2146. <notnull/>
  2147. </field>
  2148. </table>
  2149. <table name="PagePermissionPageTypeAccessList">
  2150. <field name="paID" type="integer" size="10">
  2151. <unsigned/>
  2152. <key/>
  2153. <default value="0"/>
  2154. </field>
  2155. <field name="peID" type="integer" size="10">
  2156. <unsigned/>
  2157. <key/>
  2158. <default value="0"/>
  2159. </field>
  2160. <field name="permission" type="string" size="1">
  2161. <default value="1"/>
  2162. <notnull/>
  2163. </field>
  2164. <field name="externalLink" type="boolean">
  2165. <default value="0"/>
  2166. <notnull/>
  2167. </field>
  2168. <index name="peID">
  2169. <col>peID</col>
  2170. </index>
  2171. </table>
  2172. <table name="PagePermissionPageTypeAccessListCustom">
  2173. <field name="paID" type="integer" size="10">
  2174. <unsigned/>
  2175. <key/>
  2176. <default value="0"/>
  2177. </field>
  2178. <field name="peID" type="integer" size="10">
  2179. <unsigned/>
  2180. <key/>
  2181. <default value="0"/>
  2182. </field>
  2183. <field name="ptID" type="integer" size="10">
  2184. <unsigned/>
  2185. <key/>
  2186. <default value="0"/>
  2187. </field>
  2188. <index name="peID">
  2189. <col>peID</col>
  2190. </index>
  2191. <index name="ptID">
  2192. <col>ptID</col>
  2193. </index>
  2194. </table>
  2195. <table name="PagePermissionThemeAccessList">
  2196. <field name="paID" type="integer" size="10">
  2197. <unsigned/>
  2198. <key/>
  2199. <default value="0"/>
  2200. </field>
  2201. <field name="peID" type="integer" size="10">
  2202. <unsigned/>
  2203. <key/>
  2204. <default value="0"/>
  2205. </field>
  2206. <field name="permission" type="string" size="1">
  2207. <default value="1"/>
  2208. <notnull/>
  2209. </field>
  2210. <index name="peID">
  2211. <col>peID</col>
  2212. </index>
  2213. </table>
  2214. <table name="PagePermissionThemeAccessListCustom">
  2215. <field name="paID" type="integer" size="10">
  2216. <unsigned/>
  2217. <key/>
  2218. <default value="0"/>
  2219. </field>
  2220. <field name="peID" type="integer" size="10">
  2221. <unsigned/>
  2222. <key/>
  2223. <default value="0"/>
  2224. </field>
  2225. <field name="pThemeID" type="integer" size="10">
  2226. <unsigned/>
  2227. <key/>
  2228. <default value="0"/>
  2229. </field>
  2230. <index name="peID">
  2231. <col>peID</col>
  2232. </index>
  2233. <index name="pThemeID">
  2234. <col>pThemeID</col>
  2235. </index>
  2236. </table>
  2237. <table name="NotificationPermissionSubscriptionList">
  2238. <field name="paID" type="integer" size="10">
  2239. <unsigned/>
  2240. <key/>
  2241. <default value="0"/>
  2242. </field>
  2243. <field name="peID" type="integer" size="10">
  2244. <unsigned/>
  2245. <key/>
  2246. <default value="0"/>
  2247. </field>
  2248. <field name="permission" type="string" size="1">
  2249. <default value="1"/>
  2250. <notnull/>
  2251. </field>
  2252. <index name="peID">
  2253. <col>peID</col>
  2254. </index>
  2255. </table>
  2256. <table name="NotificationPermissionSubscriptionListCustom">
  2257. <field name="paID" type="integer" size="10">
  2258. <unsigned/>
  2259. <key/>
  2260. <default value="0"/>
  2261. </field>
  2262. <field name="peID" type="integer" size="10">
  2263. <unsigned/>
  2264. <key/>
  2265. <default value="0"/>
  2266. </field>
  2267. <field name="nSubscriptionIdentifier" type="string">
  2268. <key/>
  2269. </field>
  2270. <index name="peID">
  2271. <col>peID</col>
  2272. </index>
  2273. <index name="nSubscriptionIdentifier">
  2274. <col>nSubscriptionIdentifier</col>
  2275. </index>
  2276. </table>
  2277. <table name="PagePermissionPropertyAccessList">
  2278. <field name="paID" type="integer" size="10">
  2279. <unsigned/>
  2280. <key/>
  2281. <default value="0"/>
  2282. </field>
  2283. <field name="peID" type="integer" size="10">
  2284. <unsigned/>
  2285. <key/>
  2286. <default value="0"/>
  2287. </field>
  2288. <field name="name" type="boolean">
  2289. <default value="0"/>
  2290. </field>
  2291. <field name="publicDateTime" type="boolean">
  2292. <default value="0"/>
  2293. </field>
  2294. <field name="uID" type="boolean">
  2295. <default value="0"/>
  2296. </field>
  2297. <field name="description" type="boolean">
  2298. <default value="0"/>
  2299. </field>
  2300. <field name="paths" type="boolean">
  2301. <default value="0"/>
  2302. </field>
  2303. <field name="attributePermission" type="string" size="1">
  2304. <default value="1"/>
  2305. <notnull/>
  2306. </field>
  2307. <index name="peID">
  2308. <col>peID</col>
  2309. </index>
  2310. <index name="uID">
  2311. <col>uID</col>
  2312. </index>
  2313. </table>
  2314. <table name="PagePermissionPropertyAttributeAccessListCustom">
  2315. <field name="paID" type="integer" size="10">
  2316. <unsigned/>
  2317. <key/>
  2318. <default value="0"/>
  2319. </field>
  2320. <field name="peID" type="integer" size="10">
  2321. <unsigned/>
  2322. <key/>
  2323. <default value="0"/>
  2324. </field>
  2325. <field name="akID" type="integer" size="10">
  2326. <unsigned/>
  2327. <key/>
  2328. <default value="0"/>
  2329. </field>
  2330. <index name="peID">
  2331. <col>peID</col>
  2332. </index>
  2333. <index name="akID">
  2334. <col>akID</col>
  2335. </index>
  2336. </table>
  2337. <table name="UserPermissionEditPropertyAccessList">
  2338. <field name="paID" type="integer" size="10">
  2339. <unsigned/>
  2340. <key/>
  2341. <default value="0"/>
  2342. </field>
  2343. <field name="peID" type="integer" size="10">
  2344. <unsigned/>
  2345. <key/>
  2346. <default value="0"/>
  2347. </field>
  2348. <field name="uName" type="boolean">
  2349. <default value="0"/>
  2350. </field>
  2351. <field name="uEmail" type="boolean">
  2352. <default value="0"/>
  2353. </field>
  2354. <field name="uPassword" type="boolean">
  2355. <default value="0"/>
  2356. </field>
  2357. <field name="uAvatar" type="boolean">
  2358. <default value="0"/>
  2359. </field>
  2360. <field name="uTimezone" type="boolean">
  2361. <default value="0"/>
  2362. </field>
  2363. <field name="uDefaultLanguage" type="boolean">
  2364. <default value="0"/>
  2365. </field>
  2366. <field name="attributePermission" type="string" size="1">
  2367. <default value="1"/>
  2368. <notnull/>
  2369. </field>
  2370. </table>
  2371. <table name="UserPermissionEditPropertyAttributeAccessListCustom">
  2372. <field name="paID" type="integer" size="10">
  2373. <unsigned/>
  2374. <key/>
  2375. <default value="0"/>
  2376. </field>
  2377. <field name="peID" type="integer" size="10">
  2378. <unsigned/>
  2379. <key/>
  2380. <default value="0"/>
  2381. </field>
  2382. <field name="akID" type="integer" size="10">
  2383. <unsigned/>
  2384. <key/>
  2385. <default value="0"/>
  2386. </field>
  2387. <index name="peID">
  2388. <col>peID</col>
  2389. </index>
  2390. <index name="akID">
  2391. <col>akID</col>
  2392. </index>
  2393. </table>
  2394. <table name="UserPermissionViewAttributeAccessList">
  2395. <field name="paID" type="integer" size="10">
  2396. <unsigned/>
  2397. <key/>
  2398. <default value="0"/>
  2399. </field>
  2400. <field name="peID" type="integer" size="10">
  2401. <unsigned/>
  2402. <key/>
  2403. <default value="0"/>
  2404. </field>
  2405. <field name="permission" type="string" size="1">
  2406. <default value="1"/>
  2407. <notnull/>
  2408. </field>
  2409. <index name="peID">
  2410. <col>peID</col>
  2411. </index>
  2412. </table>
  2413. <table name="UserPermissionViewAttributeAccessListCustom">
  2414. <field name="paID" type="integer" size="10">
  2415. <unsigned/>
  2416. <key/>
  2417. <default value="0"/>
  2418. </field>
  2419. <field name="peID" type="integer" size="10">
  2420. <unsigned/>
  2421. <key/>
  2422. <default value="0"/>
  2423. </field>
  2424. <field name="akID" type="integer" size="10">
  2425. <unsigned/>
  2426. <key/>
  2427. <default value="0"/>
  2428. </field>
  2429. <index name="peID">
  2430. <col>peID</col>
  2431. </index>
  2432. <index name="akID">
  2433. <col>akID</col>
  2434. </index>
  2435. </table>
  2436. <table name="PagePermissionAssignments">
  2437. <field name="cID" type="integer" size="10">
  2438. <unsigned/>
  2439. <key/>
  2440. <default value="0"/>
  2441. </field>
  2442. <field name="pkID" type="integer" size="10">
  2443. <unsigned/>
  2444. <key/>
  2445. <default value="0"/>
  2446. </field>
  2447. <field name="paID" type="integer" size="10">
  2448. <unsigned/>
  2449. <key/>
  2450. <default value="0"/>
  2451. </field>
  2452. <index name="paID">
  2453. <col>paID</col>
  2454. <col>pkID</col>
  2455. </index>
  2456. <index name="pkID">
  2457. <col>pkID</col>
  2458. </index>
  2459. </table>
  2460. <table name="ConversationPermissionAssignments">
  2461. <field name="cnvID" type="integer" size="10">
  2462. <unsigned/>
  2463. <key/>
  2464. <default value="0"/>
  2465. </field>
  2466. <field name="pkID" type="integer" size="10">
  2467. <unsigned/>
  2468. <key/>
  2469. <default value="0"/>
  2470. </field>
  2471. <field name="paID" type="integer" size="10">
  2472. <unsigned/>
  2473. <key/>
  2474. <default value="0"/>
  2475. </field>
  2476. <index name="paID">
  2477. <col>paID</col>
  2478. </index>
  2479. <index name="pkID">
  2480. <col>pkID</col>
  2481. </index>
  2482. </table>
  2483. <table name="ConversationPermissionAddMessageAccessList">
  2484. <field name="paID" type="integer" size="10">
  2485. <unsigned/>
  2486. <key/>
  2487. <default value="0"/>
  2488. </field>
  2489. <field name="peID" type="integer" size="10">
  2490. <unsigned/>
  2491. <key/>
  2492. <default value="0"/>
  2493. </field>
  2494. <field name="permission" type="string" size="1">
  2495. <default value="A"/>
  2496. <notnull/>
  2497. </field>
  2498. <index name="peID">
  2499. <col>peID</col>
  2500. </index>
  2501. </table>
  2502. <table name="ConversationSubscriptions">
  2503. <field name="cnvID" type="integer" size="10">
  2504. <unsigned/>
  2505. <key/>
  2506. <default value="0"/>
  2507. </field>
  2508. <field name="uID" type="integer" size="10">
  2509. <unsigned/>
  2510. <key/>
  2511. <default value="0"/>
  2512. </field>
  2513. <field name="type" type="string" size="1">
  2514. <default value="S"/>
  2515. </field>
  2516. <index name="cnvID">
  2517. <col>cnvID</col>
  2518. </index>
  2519. <index name="uID">
  2520. <col>uID</col>
  2521. </index>
  2522. </table>
  2523. <table name="FilePermissionFileTypeAccessList">
  2524. <field name="paID" type="integer" size="10">
  2525. <unsigned/>
  2526. <key/>
  2527. <default value="0"/>
  2528. </field>
  2529. <field name="peID" type="integer" size="10">
  2530. <unsigned/>
  2531. <key/>
  2532. <default value="0"/>
  2533. </field>
  2534. <field name="permission" type="string" size="1">
  2535. <default value="1"/>
  2536. <notnull/>
  2537. </field>
  2538. <index name="peID">
  2539. <col>peID</col>
  2540. </index>
  2541. </table>
  2542. <table name="FilePermissionFileTypeAccessListCustom">
  2543. <field name="paID" type="integer" size="10">
  2544. <unsigned/>
  2545. <key/>
  2546. <default value="0"/>
  2547. </field>
  2548. <field name="peID" type="integer" size="10">
  2549. <unsigned/>
  2550. <key/>
  2551. <default value="0"/>
  2552. </field>
  2553. <field name="extension" type="string" size="64">
  2554. <key/>
  2555. <notnull/>
  2556. </field>
  2557. <index name="peID">
  2558. <col>peID</col>
  2559. </index>
  2560. </table>
  2561. <table name="FileVersionLog">
  2562. <field name="fvlID" type="integer" size="10">
  2563. <unsigned/>
  2564. <autoincrement/>
  2565. <key/>
  2566. </field>
  2567. <field name="fID" type="integer" size="10">
  2568. <unsigned/>
  2569. <default value="0"/>
  2570. <notnull/>
  2571. </field>
  2572. <field name="fvID" type="integer" size="10">
  2573. <unsigned/>
  2574. <default value="0"/>
  2575. <notnull/>
  2576. </field>
  2577. <field name="fvUpdateTypeID" type="smallint">
  2578. <unsigned/>
  2579. <default value="0"/>
  2580. <notnull/>
  2581. </field>
  2582. <field name="fvUpdateTypeAttributeID" type="integer" size="10">
  2583. <unsigned/>
  2584. <default value="0"/>
  2585. <notnull/>
  2586. </field>
  2587. <index name="fvID">
  2588. <col>fID</col>
  2589. <col>fvID</col>
  2590. <col>fvlID</col>
  2591. </index>
  2592. </table>
  2593. <table name="GroupSetGroups">
  2594. <field name="gID" type="integer" size="10">
  2595. <unsigned/>
  2596. <key/>
  2597. <default value="0"/>
  2598. </field>
  2599. <field name="gsID" type="integer" size="10">
  2600. <unsigned/>
  2601. <key/>
  2602. <default value="0"/>
  2603. </field>
  2604. <index name="gsID">
  2605. <col>gsID</col>
  2606. </index>
  2607. </table>
  2608. <table name="GroupSets">
  2609. <field name="gsID" type="integer" size="10">
  2610. <unsigned/>
  2611. <autoincrement/>
  2612. <key/>
  2613. </field>
  2614. <field name="gsName" type="string" size="255"/>
  2615. <field name="pkgID" type="integer" size="10">
  2616. <unsigned/>
  2617. <default value="0"/>
  2618. <notnull/>
  2619. </field>
  2620. <index name="gsName">
  2621. <col>gsName</col>
  2622. </index>
  2623. <index name="pkgID">
  2624. <col>pkgID</col>
  2625. <col>gsID</col>
  2626. </index>
  2627. </table>
  2628. <table name="Groups">
  2629. <field name="gID" type="integer" size="10">
  2630. <unsigned/>
  2631. <autoincrement/>
  2632. <key/>
  2633. </field>
  2634. <field name="gName" type="string" size="128">
  2635. <notnull/>
  2636. </field>
  2637. <field name="gDescription" type="string" size="255">
  2638. <notnull/>
  2639. </field>
  2640. <field name="gUserExpirationIsEnabled" type="boolean">
  2641. <default value="0"/>
  2642. <notnull/>
  2643. </field>
  2644. <field name="gUserExpirationMethod" type="string" size="12"/>
  2645. <field name="gUserExpirationSetDateTime" type="datetime"/>
  2646. <field name="gUserExpirationInterval" type="integer" size="10">
  2647. <unsigned/>
  2648. <default value="0"/>
  2649. <notnull/>
  2650. </field>
  2651. <field name="gUserExpirationAction" type="string" size="20"/>
  2652. <field name="gIsBadge" type="boolean">
  2653. <default value="0"/>
  2654. <notnull/>
  2655. </field>
  2656. <field name="gBadgeFID" type="integer" size="10">
  2657. <unsigned/>
  2658. <default value="0"/>
  2659. <notnull/>
  2660. </field>
  2661. <field name="gBadgeDescription" type="string" size="255"/>
  2662. <field name="gBadgeCommunityPointValue" type="integer" size="11">
  2663. <default value="0"/>
  2664. <notnull/>
  2665. </field>
  2666. <field name="gIsAutomated" type="boolean">
  2667. <default value="0"/>
  2668. <notnull/>
  2669. </field>
  2670. <field name="gCheckAutomationOnRegister" type="boolean">
  2671. <default value="0"/>
  2672. <notnull/>
  2673. </field>
  2674. <field name="gCheckAutomationOnLogin" type="boolean">
  2675. <default value="0"/>
  2676. <notnull/>
  2677. </field>
  2678. <field name="gCheckAutomationOnJobRun" type="boolean">
  2679. <default value="0"/>
  2680. <notnull/>
  2681. </field>
  2682. <field name="gPath" type="text" size="65535"/>
  2683. <field name="pkgID" type="integer" size="10">
  2684. <unsigned/>
  2685. <default value="0"/>
  2686. <notnull/>
  2687. </field>
  2688. <index name="gName">
  2689. <col>gName</col>
  2690. </index>
  2691. <index name="gBadgeFID">
  2692. <col>gBadgeFID</col>
  2693. </index>
  2694. <index name="pkgID">
  2695. <col>pkgID</col>
  2696. </index>
  2697. </table>
  2698. <table name="Jobs">
  2699. <field name="jID" type="integer" size="10">
  2700. <unsigned/>
  2701. <autoincrement/>
  2702. <key/>
  2703. </field>
  2704. <field name="jName" type="string" size="100">
  2705. <notnull/>
  2706. </field>
  2707. <field name="jDescription" type="string" size="255">
  2708. <notnull/>
  2709. </field>
  2710. <field name="jDateInstalled" type="datetime"/>
  2711. <field name="jDateLastRun" type="datetime"/>
  2712. <field name="pkgID" type="integer" size="10">
  2713. <unsigned/>
  2714. <default value="0"/>
  2715. <notnull/>
  2716. </field>
  2717. <field name="jLastStatusText" type="text"/>
  2718. <field name="jLastStatusCode" type="smallint" size="4">
  2719. <default value="0"/>
  2720. <notnull/>
  2721. </field>
  2722. <field name="jStatus" type="string" size="14">
  2723. <default value="ENABLED"/>
  2724. <notnull/>
  2725. </field>
  2726. <field name="jHandle" type="string" size="255">
  2727. <notnull/>
  2728. </field>
  2729. <field name="jNotUninstallable" type="smallint" size="4">
  2730. <default value="0"/>
  2731. <notnull/>
  2732. </field>
  2733. <field name="isScheduled" type="smallint" size="1">
  2734. <default value="0"/>
  2735. <notnull/>
  2736. </field>
  2737. <field name="scheduledInterval" type="string" size="255">
  2738. <default value="days"/>
  2739. <notnull/>
  2740. </field>
  2741. <field name="scheduledValue" type="integer" size="10">
  2742. <default value="0"/>
  2743. <notnull/>
  2744. </field>
  2745. <index name="jHandle">
  2746. <unique/>
  2747. <col>jHandle</col>
  2748. </index>
  2749. <index name="pkgID">
  2750. <col>pkgID</col>
  2751. </index>
  2752. <index name="isScheduled">
  2753. <col>isScheduled</col>
  2754. <col>jDateLastRun</col>
  2755. <col>jID</col>
  2756. </index>
  2757. <index name="jDateLastRun">
  2758. <col>jDateLastRun</col>
  2759. <col>jID</col>
  2760. </index>
  2761. </table>
  2762. <table name="JobsLog">
  2763. <field name="jlID" type="integer" size="10">
  2764. <unsigned/>
  2765. <autoincrement/>
  2766. <key/>
  2767. </field>
  2768. <field name="jID" type="integer" size="10">
  2769. <unsigned/>
  2770. <notnull/>
  2771. </field>
  2772. <field name="jlMessage" type="text">
  2773. <notnull/>
  2774. </field>
  2775. <field name="jlTimestamp" type="timestamp">
  2776. <deftimestamp/>
  2777. <notnull/>
  2778. </field>
  2779. <field name="jlError" type="integer" size="10">
  2780. <default value="0"/>
  2781. <notnull/>
  2782. </field>
  2783. <index name="jID">
  2784. <col>jID</col>
  2785. </index>
  2786. </table>
  2787. <table name="JobSetJobs">
  2788. <field name="jsID" type="integer" size="10">
  2789. <unsigned/>
  2790. <key/>
  2791. <default value="0"/>
  2792. </field>
  2793. <field name="jID" type="integer" size="10">
  2794. <unsigned/>
  2795. <key/>
  2796. <default value="0"/>
  2797. </field>
  2798. <field name="jRunOrder" type="integer" size="10">
  2799. <unsigned/>
  2800. <default value="0"/>
  2801. <notnull/>
  2802. </field>
  2803. <index name="jID">
  2804. <col>jID</col>
  2805. </index>
  2806. </table>
  2807. <table name="JobSets">
  2808. <field name="jsID" type="integer" size="10">
  2809. <unsigned/>
  2810. <autoincrement/>
  2811. <key/>
  2812. </field>
  2813. <field name="jsName" type="string" size="128">
  2814. <notnull/>
  2815. </field>
  2816. <field name="pkgID" type="integer" size="10">
  2817. <unsigned/>
  2818. <default value="0"/>
  2819. <notnull/>
  2820. </field>
  2821. <field name="jDateLastRun" type="datetime"/>
  2822. <field name="isScheduled" type="smallint" size="1">
  2823. <default value="0"/>
  2824. <notnull/>
  2825. </field>
  2826. <field name="scheduledInterval" type="string" size="255">
  2827. <default value="days"/>
  2828. <notnull/>
  2829. </field>
  2830. <field name="scheduledValue" type="integer" size="10">
  2831. <default value="0"/>
  2832. <notnull/>
  2833. </field>
  2834. <index name="pkgID">
  2835. <col>pkgID</col>
  2836. </index>
  2837. <index name="jsName">
  2838. <col>jsName</col>
  2839. </index>
  2840. </table>
  2841. <table name="UserPointHistory">
  2842. <field name="upID" type="integer" size="11">
  2843. <autoincrement/>
  2844. <key/>
  2845. </field>
  2846. <field name="upuID" type="integer" size="11">
  2847. <default value="0"/>
  2848. <notnull/>
  2849. </field>
  2850. <field name="upaID" type="integer" size="11">
  2851. <default value="0"/>
  2852. </field>
  2853. <field name="upPoints" type="integer" size="11">
  2854. <default value="0"/>
  2855. </field>
  2856. <field name="object" type="text"/>
  2857. <field name="timestamp" type="timestamp">
  2858. <deftimestamp/>
  2859. <notnull/>
  2860. </field>
  2861. <index name="upuID">
  2862. <col>upuID</col>
  2863. </index>
  2864. <index name="upaID">
  2865. <col>upaID</col>
  2866. </index>
  2867. </table>
  2868. <table name="UserPointActions">
  2869. <field name="upaID" type="integer" size="11">
  2870. <autoincrement/>
  2871. <key/>
  2872. </field>
  2873. <field name="upaHandle" type="string" size="255"/>
  2874. <field name="upaName" type="string" size="255"/>
  2875. <field name="upaDefaultPoints" type="integer" size="11">
  2876. <default value="0"/>
  2877. <notnull/>
  2878. </field>
  2879. <field name="pkgID" type="integer" size="10">
  2880. <unsigned/>
  2881. <default value="0"/>
  2882. <notnull/>
  2883. </field>
  2884. <field name="upaHasCustomClass" type="boolean">
  2885. <default value="0"/>
  2886. <notnull/>
  2887. </field>
  2888. <field name="upaIsActive" type="boolean">
  2889. <default value="1"/>
  2890. <notnull/>
  2891. </field>
  2892. <field name="gBadgeID" type="integer" size="11">
  2893. <default value="0"/>
  2894. <notnull/>
  2895. </field>
  2896. <index name="upaHandle">
  2897. <unique/>
  2898. <col>upaHandle</col>
  2899. </index>
  2900. <index name="pkgID">
  2901. <col>pkgID</col>
  2902. </index>
  2903. <index name="gBBadgeID">
  2904. <col>gBadgeID</col>
  2905. </index>
  2906. </table>
  2907. <table name="SystemAntispamLibraries">
  2908. <field name="saslHandle" type="string" size="64">
  2909. <key/>
  2910. </field>
  2911. <field name="saslName" type="string" size="255"/>
  2912. <field name="saslIsActive" type="boolean">
  2913. <default value="0"/>
  2914. <notnull/>
  2915. </field>
  2916. <field name="pkgID" type="integer" size="10">
  2917. <unsigned/>
  2918. <default value="0"/>
  2919. <notnull/>
  2920. </field>
  2921. <index name="pkgID">
  2922. <col>pkgID</col>
  2923. </index>
  2924. </table>
  2925. <table name="SystemCaptchaLibraries">
  2926. <field name="sclHandle" type="string" size="64">
  2927. <key/>
  2928. </field>
  2929. <field name="sclName" type="string" size="255"/>
  2930. <field name="sclIsActive" type="boolean">
  2931. <default value="0"/>
  2932. <notnull/>
  2933. </field>
  2934. <field name="pkgID" type="integer" size="10">
  2935. <unsigned/>
  2936. <default value="0"/>
  2937. <notnull/>
  2938. </field>
  2939. <index name="pkgID">
  2940. <col>pkgID</col>
  2941. </index>
  2942. </table>
  2943. <table name="SystemDatabaseQueryLog">
  2944. <field name="ID" type="integer" size="10">
  2945. <unsigned/>
  2946. <autoincrement/>
  2947. <key/>
  2948. </field>
  2949. <field name="query" type="text" size="65535"/>
  2950. <field name="params" type="text" size="65535"/>
  2951. <field name="executionMS" type="string" size="255"/>
  2952. </table>
  2953. <table name="SystemContentEditorSnippets">
  2954. <field name="scsHandle" type="string" size="64">
  2955. <key/>
  2956. </field>
  2957. <field name="scsName" type="string" size="255"/>
  2958. <field name="scsIsActive" type="boolean">
  2959. <default value="0"/>
  2960. <notnull/>
  2961. </field>
  2962. <field name="pkgID" type="integer" size="10">
  2963. <unsigned/>
  2964. <default value="0"/>
  2965. <notnull/>
  2966. </field>
  2967. <index name="pkgID">
  2968. <col>pkgID</col>
  2969. </index>
  2970. </table>
  2971. <table name="PageSearchIndex">
  2972. <field name="cID" type="integer" size="10">
  2973. <unsigned/>
  2974. <key/>
  2975. <default value="0"/>
  2976. </field>
  2977. <field name="content" type="text"/>
  2978. <field name="cName" type="string" size="255"/>
  2979. <field name="cDescription" type="text" size="65535"/>
  2980. <field name="cPath" type="text" size="65535"/>
  2981. <field name="cDatePublic" type="datetime"/>
  2982. <field name="cDateLastIndexed" type="datetime"/>
  2983. <field name="cDateLastSitemapped" type="datetime"/>
  2984. <field name="cRequiresReindex" type="boolean">
  2985. <default value="0"/>
  2986. </field>
  2987. <index name="cName">
  2988. <fulltext/>
  2989. <col>cName</col>
  2990. </index>
  2991. <index name="cDescription">
  2992. <fulltext/>
  2993. <col>cDescription</col>
  2994. </index>
  2995. <index name="content">
  2996. <fulltext/>
  2997. <col>content</col>
  2998. </index>
  2999. <index name="content2">
  3000. <fulltext/>
  3001. <col>cName</col>
  3002. <col>cDescription</col>
  3003. <col>content</col>
  3004. </index>
  3005. <index name="cDateLastIndexed">
  3006. <col>cDateLastIndexed</col>
  3007. </index>
  3008. <index name="cDateLastSitemapped">
  3009. <col>cDateLastSitemapped</col>
  3010. </index>
  3011. <index name="cRequiresReindex">
  3012. <col>cRequiresReindex</col>
  3013. </index>
  3014. <opt for="MySQL" engine="MYISAM"/>
  3015. </table>
  3016. <table name="PageThemes">
  3017. <field name="pThemeID" type="integer" size="10">
  3018. <unsigned/>
  3019. <autoincrement/>
  3020. <key/>
  3021. </field>
  3022. <field name="pThemeHandle" type="string" size="64">
  3023. <notnull/>
  3024. </field>
  3025. <field name="pThemeName" type="string" size="255"/>
  3026. <field name="pThemeDescription" type="text" size="65535"/>
  3027. <field name="pkgID" type="integer" size="10">
  3028. <unsigned/>
  3029. <default value="0"/>
  3030. <notnull/>
  3031. </field>
  3032. <field name="pThemeHasCustomClass" type="boolean">
  3033. <default value="0"/>
  3034. <notnull/>
  3035. </field>
  3036. <index name="ptHandle">
  3037. <unique/>
  3038. <col>pThemeHandle</col>
  3039. </index>
  3040. <index name="pkgID">
  3041. <col>pkgID</col>
  3042. </index>
  3043. </table>
  3044. <table name="PageThemeCustomStyles">
  3045. <field name="pThemeID" type="integer" size="10">
  3046. <unsigned/>
  3047. <key/>
  3048. <default value="0"/>
  3049. </field>
  3050. <field name="scvlID" type="integer" size="10">
  3051. <unsigned/>
  3052. <default value="0"/>
  3053. </field>
  3054. <field name="preset" type="string" size="255"/>
  3055. <field name="sccRecordID" type="integer" size="10">
  3056. <unsigned/>
  3057. <default value="0"/>
  3058. </field>
  3059. <index name="scvlID">
  3060. <col>scvlID</col>
  3061. </index>
  3062. <index name="sccRecordID">
  3063. <col>sccRecordID</col>
  3064. </index>
  3065. </table>
  3066. <table name="Pages">
  3067. <field name="cID" type="integer" size="10">
  3068. <unsigned/>
  3069. <key/>
  3070. <default value="0"/>
  3071. </field>
  3072. <field name="siteTreeID" type="integer" size="10">
  3073. <unsigned/>
  3074. <default value="0"/>
  3075. </field>
  3076. <field name="ptID" type="integer" size="10">
  3077. <unsigned/>
  3078. <key/>
  3079. <default value="0"/>
  3080. </field>
  3081. <field name="cIsTemplate" type="boolean">
  3082. <default value="0"/>
  3083. <notnull/>
  3084. </field>
  3085. <field name="uID" type="integer" size="10">
  3086. <unsigned/>
  3087. </field>
  3088. <field name="cIsCheckedOut" type="boolean">
  3089. <default value="0"/>
  3090. <notnull/>
  3091. </field>
  3092. <field name="cCheckedOutUID" type="integer" size="10">
  3093. <unsigned/>
  3094. </field>
  3095. <field name="cCheckedOutDatetime" type="datetime"/>
  3096. <field name="cCheckedOutDatetimeLastEdit" type="datetime"/>
  3097. <field name="cOverrideTemplatePermissions" type="boolean">
  3098. <default value="1"/>
  3099. <notnull/>
  3100. </field>
  3101. <field name="cInheritPermissionsFromCID" type="integer" size="10">
  3102. <unsigned/>
  3103. <default value="0"/>
  3104. <notnull/>
  3105. </field>
  3106. <field name="cInheritPermissionsFrom" type="string" size="8">
  3107. <default value="PARENT"/>
  3108. <notnull/>
  3109. </field>
  3110. <field name="cFilename" type="string" size="255"/>
  3111. <field name="cPointerID" type="integer" size="10">
  3112. <unsigned/>
  3113. <default value="0"/>
  3114. <notnull/>
  3115. </field>
  3116. <field name="cPointerExternalLink" type="text"/>
  3117. <field name="cPointerExternalLinkNewWindow" type="boolean">
  3118. <default value="0"/>
  3119. <notnull/>
  3120. </field>
  3121. <field name="cIsActive" type="boolean">
  3122. <default value="1"/>
  3123. <notnull/>
  3124. </field>
  3125. <field name="cChildren" type="integer" size="10">
  3126. <unsigned/>
  3127. <default value="0"/>
  3128. <notnull/>
  3129. </field>
  3130. <field name="cDisplayOrder" type="integer" size="10">
  3131. <unsigned/>
  3132. <default value="0"/>
  3133. <notnull/>
  3134. </field>
  3135. <field name="cParentID" type="integer" size="10">
  3136. <unsigned/>
  3137. <default value="0"/>
  3138. <notnull/>
  3139. </field>
  3140. <field name="pkgID" type="integer" size="10">
  3141. <unsigned/>
  3142. <default value="0"/>
  3143. <notnull/>
  3144. </field>
  3145. <field name="cDraftTargetParentPageID" type="integer" size="10">
  3146. <unsigned/>
  3147. <default value="0"/>
  3148. <notnull/>
  3149. </field>
  3150. <field name="cCacheFullPageContent" type="smallint">
  3151. <default value="-1"/>
  3152. <notnull/>
  3153. </field>
  3154. <field name="cCacheFullPageContentOverrideLifetime" type="string" size="32">
  3155. <default value="0"/>
  3156. <notnull/>
  3157. </field>
  3158. <field name="cCacheFullPageContentLifetimeCustom" type="integer" size="10">
  3159. <unsigned/>
  3160. <default value="0"/>
  3161. <notnull/>
  3162. </field>
  3163. <field name="cIsSystemPage" type="boolean">
  3164. <default value="0"/>
  3165. <notnull/>
  3166. </field>
  3167. <index name="cParentID">
  3168. <col>cParentID</col>
  3169. </index>
  3170. <index name="siteTreeID">
  3171. <col>siteTreeID</col>
  3172. </index>
  3173. <index name="cIsActive">
  3174. <col>cID</col>
  3175. <col>cIsActive</col>
  3176. </index>
  3177. <index name="cCheckedOutUID">
  3178. <col>cCheckedOutUID</col>
  3179. </index>
  3180. <index name="uID">
  3181. <col>uID</col>
  3182. <col>cPointerID</col>
  3183. </index>
  3184. <index name="cPointerID">
  3185. <col>cPointerID</col>
  3186. <col>cDisplayOrder</col>
  3187. </index>
  3188. <index name="cIsTemplate">
  3189. <col>cID</col>
  3190. <col>cIsTemplate</col>
  3191. </index>
  3192. <index name="cIsSystemPage">
  3193. <col>cID</col>
  3194. <col>cIsSystemPage</col>
  3195. </index>
  3196. <index name="pkgID">
  3197. <col>pkgID</col>
  3198. </index>
  3199. <index name="cParentMaxDisplay">
  3200. <col>cParentID</col>
  3201. <col>cDisplayOrder</col>
  3202. </index>
  3203. </table>
  3204. <table name="PileContents">
  3205. <field name="pcID" type="integer" size="10">
  3206. <unsigned/>
  3207. <autoincrement/>
  3208. <key/>
  3209. </field>
  3210. <field name="pID" type="integer" size="10">
  3211. <unsigned/>
  3212. <default value="0"/>
  3213. <notnull/>
  3214. </field>
  3215. <field name="itemID" type="integer" size="10">
  3216. <unsigned/>
  3217. <default value="0"/>
  3218. <notnull/>
  3219. </field>
  3220. <field name="itemType" type="string" size="64">
  3221. <notnull/>
  3222. </field>
  3223. <field name="quantity" type="integer" size="10">
  3224. <unsigned/>
  3225. <default value="1"/>
  3226. <notnull/>
  3227. </field>
  3228. <field name="timestamp" type="timestamp">
  3229. <deftimestamp/>
  3230. <notnull/>
  3231. </field>
  3232. <field name="displayOrder" type="integer" size="10">
  3233. <unsigned/>
  3234. <default value="0"/>
  3235. <notnull/>
  3236. </field>
  3237. <index name="pID">
  3238. <col>pID</col>
  3239. <col>displayOrder</col>
  3240. </index>
  3241. <index name="itemID">
  3242. <col>itemID</col>
  3243. </index>
  3244. <index name="itemType">
  3245. <col>itemType</col>
  3246. <col>itemID</col>
  3247. <col>pID</col>
  3248. </index>
  3249. </table>
  3250. <table name="Piles">
  3251. <field name="pID" type="integer" size="10">
  3252. <unsigned/>
  3253. <autoincrement/>
  3254. <key/>
  3255. </field>
  3256. <field name="uID" type="integer" size="10">
  3257. <unsigned/>
  3258. </field>
  3259. <field name="isDefault" type="boolean">
  3260. <default value="0"/>
  3261. <notnull/>
  3262. </field>
  3263. <field name="timestamp" type="timestamp">
  3264. <deftimestamp/>
  3265. <notnull/>
  3266. </field>
  3267. <field name="name" type="string" size="255"/>
  3268. <field name="state" type="string" size="64">
  3269. <notnull/>
  3270. </field>
  3271. <index name="uID">
  3272. <col>uID</col>
  3273. <col>name</col>
  3274. </index>
  3275. </table>
  3276. <table name="UserPrivateMessages">
  3277. <field name="msgID" type="integer" size="10">
  3278. <unsigned/>
  3279. <autoincrement/>
  3280. <key/>
  3281. </field>
  3282. <field name="uAuthorID" type="integer" size="10">
  3283. <unsigned/>
  3284. <default value="0"/>
  3285. <notnull/>
  3286. </field>
  3287. <field name="msgDateCreated" type="datetime">
  3288. <notnull/>
  3289. </field>
  3290. <field name="msgSubject" type="string" size="255">
  3291. <notnull/>
  3292. </field>
  3293. <field name="msgBody" type="text" size="65535"/>
  3294. <field name="uToID" type="integer" size="10">
  3295. <unsigned/>
  3296. <default value="0"/>
  3297. <notnull/>
  3298. </field>
  3299. <index name="uAuthorID">
  3300. <col>uAuthorID</col>
  3301. <col>msgDateCreated</col>
  3302. </index>
  3303. </table>
  3304. <table name="UserPrivateMessagesTo">
  3305. <field name="msgID" type="integer" size="10">
  3306. <unsigned/>
  3307. <key/>
  3308. <default value="0"/>
  3309. </field>
  3310. <field name="uID" type="integer" size="10">
  3311. <unsigned/>
  3312. <key/>
  3313. <default value="0"/>
  3314. </field>
  3315. <field name="uAuthorID" type="integer" size="10">
  3316. <unsigned/>
  3317. <key/>
  3318. <default value="0"/>
  3319. </field>
  3320. <field name="msgMailboxID" type="integer" size="11">
  3321. <key/>
  3322. <notnull/>
  3323. </field>
  3324. <field name="msgIsNew" type="boolean">
  3325. <default value="0"/>
  3326. <notnull/>
  3327. </field>
  3328. <field name="msgIsUnread" type="boolean">
  3329. <default value="0"/>
  3330. <notnull/>
  3331. </field>
  3332. <field name="msgIsReplied" type="boolean">
  3333. <default value="0"/>
  3334. <notnull/>
  3335. </field>
  3336. <index name="uID">
  3337. <col>uID</col>
  3338. </index>
  3339. <index name="uAuthorID">
  3340. <col>uAuthorID</col>
  3341. </index>
  3342. <index name="msgFolderID">
  3343. <col>msgMailboxID</col>
  3344. </index>
  3345. <index name="msgIsNew">
  3346. <col>msgIsNew</col>
  3347. </index>
  3348. </table>
  3349. <table name="LoginControlIpRanges" comment="IP ranges used to control login attempts">
  3350. <field name="lcirID" type="integer" comment="Record identifier">
  3351. <unsigned/>
  3352. <autoincrement/>
  3353. <key/>
  3354. </field>
  3355. <field name="lcirIpFrom" type="string" size="40" comment="Start of the range">
  3356. <notnull/>
  3357. </field>
  3358. <field name="lcirIpTo" type="string" size="40" comment="End of the range">
  3359. <notnull/>
  3360. </field>
  3361. <field name="lcirType" type="smallint" comment="Type of the record">
  3362. <unsigned/>
  3363. <notnull/>
  3364. </field>
  3365. <field name="lcirExpires" type="datetime" comment="Record end-of-life timestamp"> </field>
  3366. <index name="IX_LoginControlIpRanges_Search">
  3367. <col>lcirIpFrom</col>
  3368. <col>lcirIpTo</col>
  3369. <col>lcirExpires</col>
  3370. </index>
  3371. </table>
  3372. <table name="UserGroups">
  3373. <field name="uID" type="integer" size="10">
  3374. <unsigned/>
  3375. <key/>
  3376. <default value="0"/>
  3377. </field>
  3378. <field name="gID" type="integer" size="10">
  3379. <unsigned/>
  3380. <key/>
  3381. <default value="0"/>
  3382. </field>
  3383. <field name="ugEntered" type="datetime">
  3384. <default value="1000-01-01 00:00:00"/>
  3385. <notnull/>
  3386. </field>
  3387. <index name="uID">
  3388. <col>uID</col>
  3389. </index>
  3390. <index name="gID">
  3391. <col>gID</col>
  3392. </index>
  3393. </table>
  3394. <table name="UserValidationHashes">
  3395. <field name="uvhID" type="integer" size="10">
  3396. <unsigned/>
  3397. <autoincrement/>
  3398. <key/>
  3399. </field>
  3400. <field name="uID" type="integer" size="10">
  3401. <unsigned/>
  3402. </field>
  3403. <field name="uHash" type="string" size="64">
  3404. <notnull/>
  3405. </field>
  3406. <field name="type" type="smallint">
  3407. <unsigned/>
  3408. <default value="0"/>
  3409. <notnull/>
  3410. </field>
  3411. <field name="uDateGenerated" type="integer" size="10">
  3412. <unsigned/>
  3413. <default value="0"/>
  3414. <notnull/>
  3415. </field>
  3416. <field name="uDateRedeemed" type="integer" size="10">
  3417. <unsigned/>
  3418. <default value="0"/>
  3419. <notnull/>
  3420. </field>
  3421. <index name="uID">
  3422. <col>uID</col>
  3423. <col>type</col>
  3424. </index>
  3425. <index name="uHash">
  3426. <col>uHash</col>
  3427. <col>type</col>
  3428. </index>
  3429. <index name="uDateGenerated">
  3430. <col>uDateGenerated</col>
  3431. <col>type</col>
  3432. </index>
  3433. </table>
  3434. <table name="Logs">
  3435. <field name="logID" type="integer" size="10">
  3436. <unsigned/>
  3437. <autoincrement/>
  3438. <key/>
  3439. </field>
  3440. <field name="channel" type="string" size="255"/>
  3441. <field name="time" type="integer" size="10">
  3442. <unsigned/>
  3443. <notnull/>
  3444. </field>
  3445. <field name="message" type="text"/>
  3446. <field name="uID" type="integer" size="10">
  3447. <unsigned/>
  3448. </field>
  3449. <field name="level" type="integer" size="10">
  3450. <notnull/>
  3451. </field>
  3452. <index name="channel">
  3453. <col>channel</col>
  3454. </index>
  3455. <index name="uID">
  3456. <col>uID</col>
  3457. </index>
  3458. </table>
  3459. <table name="MailImporters">
  3460. <field name="miID" type="integer" size="10">
  3461. <unsigned/>
  3462. <autoincrement/>
  3463. <key/>
  3464. </field>
  3465. <field name="miHandle" type="string" size="64">
  3466. <notnull/>
  3467. </field>
  3468. <field name="miServer" type="string" size="255"/>
  3469. <field name="miUsername" type="string" size="255"/>
  3470. <field name="miPassword" type="string" size="255"/>
  3471. <field name="miEncryption" type="string" size="32"/>
  3472. <field name="miIsEnabled" type="boolean">
  3473. <default value="0"/>
  3474. <notnull/>
  3475. </field>
  3476. <field name="miEmail" type="string" size="255"/>
  3477. <field name="miPort" type="integer" size="10">
  3478. <unsigned/>
  3479. <default value="0"/>
  3480. <notnull/>
  3481. </field>
  3482. <field name="pkgID" type="integer" size="10">
  3483. <unsigned/>
  3484. </field>
  3485. <field name="miConnectionMethod" type="string" size="8">
  3486. <default value="POP"/>
  3487. </field>
  3488. <index name="miHandle">
  3489. <unique/>
  3490. <col>miHandle</col>
  3491. </index>
  3492. <index name="pkgID">
  3493. <col>pkgID</col>
  3494. <col>miID</col>
  3495. </index>
  3496. </table>
  3497. <table name="MailValidationHashes">
  3498. <field name="mvhID" type="integer" size="10">
  3499. <unsigned/>
  3500. <autoincrement/>
  3501. <key/>
  3502. </field>
  3503. <field name="miID" type="integer" size="10">
  3504. <unsigned/>
  3505. <default value="0"/>
  3506. <notnull/>
  3507. </field>
  3508. <field name="email" type="string" size="254">
  3509. <notnull/>
  3510. </field>
  3511. <field name="mHash" type="string" size="128">
  3512. <notnull/>
  3513. </field>
  3514. <field name="mDateGenerated" type="integer" size="10">
  3515. <unsigned/>
  3516. <default value="0"/>
  3517. <notnull/>
  3518. </field>
  3519. <field name="mDateRedeemed" type="integer" size="10">
  3520. <unsigned/>
  3521. <default value="0"/>
  3522. <notnull/>
  3523. </field>
  3524. <field name="data" type="text" size="65535"/>
  3525. <index name="miID">
  3526. <col>miID</col>
  3527. </index>
  3528. <index name="mHash">
  3529. <unique/>
  3530. <col>mHash</col>
  3531. </index>
  3532. </table>
  3533. <table name="FailedLoginAttempts" comment="Records failed login attempts">
  3534. <field name="lcirID" type="integer" comment="Record identifier">
  3535. <unsigned/>
  3536. <autoincrement/>
  3537. <key/>
  3538. </field>
  3539. <field name="flaIp" type="string" size="40" comment="IP address of the failed login attempt">
  3540. <notnull/>
  3541. </field>
  3542. <field name="flaTimestamp" type="timestamp" comment="Timestamp of the failed login attempt">
  3543. <notnull/>
  3544. </field>
  3545. </table>
  3546. <table name="FilePermissionAssignments">
  3547. <field name="fID" type="integer" size="10">
  3548. <unsigned/>
  3549. <key/>
  3550. <default value="0"/>
  3551. </field>
  3552. <field name="pkID" type="integer" size="10">
  3553. <unsigned/>
  3554. <key/>
  3555. <default value="0"/>
  3556. </field>
  3557. <field name="paID" type="integer" size="10">
  3558. <unsigned/>
  3559. <key/>
  3560. <default value="0"/>
  3561. </field>
  3562. <index name="pkID">
  3563. <col>pkID</col>
  3564. </index>
  3565. <index name="paID">
  3566. <col>paID</col>
  3567. </index>
  3568. </table>
  3569. <table name="FileSets">
  3570. <field name="fsID" type="integer" size="10">
  3571. <unsigned/>
  3572. <autoincrement/>
  3573. <key/>
  3574. </field>
  3575. <field name="fsName" type="string" size="64">
  3576. <notnull/>
  3577. </field>
  3578. <field name="uID" type="integer" size="10">
  3579. <unsigned/>
  3580. <default value="0"/>
  3581. <notnull/>
  3582. </field>
  3583. <field name="fsType" type="smallint">
  3584. <notnull/>
  3585. </field>
  3586. <field name="fsOverrideGlobalPermissions" type="smallint"/>
  3587. <index name="uID">
  3588. <col>uID</col>
  3589. <col>fsType</col>
  3590. <col>fsName</col>
  3591. </index>
  3592. <index name="fsName">
  3593. <col>fsName</col>
  3594. </index>
  3595. <index name="fsType">
  3596. <col>fsType</col>
  3597. </index>
  3598. </table>
  3599. <table name="FileSetSavedSearches">
  3600. <field name="fsID" type="integer" size="10">
  3601. <unsigned/>
  3602. <key/>
  3603. <default value="0"/>
  3604. </field>
  3605. <field name="fsSearchRequest" type="text" size="65535"/>
  3606. <field name="fsResultColumns" type="text" size="65535"/>
  3607. </table>
  3608. <table name="FileSetFiles">
  3609. <field name="fsfID" type="integer" size="10">
  3610. <unsigned/>
  3611. <autoincrement/>
  3612. <key/>
  3613. </field>
  3614. <field name="fID" type="integer" size="10">
  3615. <unsigned/>
  3616. <notnull/>
  3617. </field>
  3618. <field name="fsID" type="integer" size="10">
  3619. <unsigned/>
  3620. <notnull/>
  3621. </field>
  3622. <field name="timestamp" type="timestamp">
  3623. <deftimestamp/>
  3624. <notnull/>
  3625. </field>
  3626. <field name="fsDisplayOrder" type="integer" size="10">
  3627. <unsigned/>
  3628. <notnull/>
  3629. </field>
  3630. <index name="fID">
  3631. <col>fID</col>
  3632. </index>
  3633. <index name="fsID">
  3634. <col>fsID</col>
  3635. </index>
  3636. </table>
  3637. <table name="Stacks">
  3638. <field name="stID" type="integer" size="10">
  3639. <unsigned/>
  3640. <autoincrement/>
  3641. <key/>
  3642. </field>
  3643. <field name="stName" type="string" size="255">
  3644. <notnull/>
  3645. </field>
  3646. <field name="stType" type="integer" size="10">
  3647. <unsigned/>
  3648. <default value="0"/>
  3649. <notnull/>
  3650. </field>
  3651. <field name="cID" type="integer" size="10">
  3652. <unsigned/>
  3653. <default value="0"/>
  3654. <notnull/>
  3655. </field>
  3656. <field name="stMultilingualSection" type="integer" size="10">
  3657. <unsigned/>
  3658. <default value="0"/>
  3659. <notnull/>
  3660. </field>
  3661. <index name="stType">
  3662. <col>stType</col>
  3663. </index>
  3664. <index name="stName">
  3665. <col>stName</col>
  3666. </index>
  3667. <index name="cID">
  3668. <col>cID</col>
  3669. </index>
  3670. </table>
  3671. <table name="WorkflowProgressCategories">
  3672. <field name="wpCategoryID" type="integer" size="10">
  3673. <unsigned/>
  3674. <autoincrement/>
  3675. <key/>
  3676. </field>
  3677. <field name="wpCategoryHandle" type="string" size="255">
  3678. <notnull/>
  3679. </field>
  3680. <field name="pkgID" type="integer" size="10">
  3681. <unsigned/>
  3682. </field>
  3683. <index name="wpCategoryHandle">
  3684. <unique/>
  3685. <col>wpCategoryHandle</col>
  3686. </index>
  3687. <index name="pkgID">
  3688. <col>pkgID</col>
  3689. </index>
  3690. </table>
  3691. <table name="WorkflowProgressHistory">
  3692. <field name="wphID" type="integer" size="10">
  3693. <unsigned/>
  3694. <autoincrement/>
  3695. <key/>
  3696. </field>
  3697. <field name="wpID" type="integer" size="10">
  3698. <unsigned/>
  3699. <default value="0"/>
  3700. <notnull/>
  3701. </field>
  3702. <field name="timestamp" type="timestamp">
  3703. <deftimestamp/>
  3704. <notnull/>
  3705. </field>
  3706. <field name="object" type="text" size="65535"/>
  3707. <index name="wpID">
  3708. <col>wpID</col>
  3709. <col>timestamp</col>
  3710. </index>
  3711. </table>
  3712. <table name="WorkflowProgress">
  3713. <field name="wpID" type="integer" size="10">
  3714. <unsigned/>
  3715. <autoincrement/>
  3716. <key/>
  3717. </field>
  3718. <field name="wpCategoryID" type="integer" size="10">
  3719. <unsigned/>
  3720. </field>
  3721. <field name="wfID" type="integer" size="10">
  3722. <unsigned/>
  3723. <default value="0"/>
  3724. <notnull/>
  3725. </field>
  3726. <field name="wpApproved" type="boolean">
  3727. <default value="0"/>
  3728. <notnull/>
  3729. </field>
  3730. <field name="wpDateAdded" type="datetime"/>
  3731. <field name="wpDateLastAction" type="datetime"/>
  3732. <field name="wpCurrentStatus" type="integer" size="10">
  3733. <default value="0"/>
  3734. <notnull/>
  3735. </field>
  3736. <field name="wrID" type="integer" size="10">
  3737. <default value="0"/>
  3738. <notnull/>
  3739. </field>
  3740. <field name="wpIsCompleted" type="boolean">
  3741. <default value="0"/>
  3742. <notnull/>
  3743. </field>
  3744. <index name="wpCategoryID">
  3745. <col>wpCategoryID</col>
  3746. </index>
  3747. <index name="wfID">
  3748. <col>wfID</col>
  3749. </index>
  3750. <index name="wrID">
  3751. <col>wrID</col>
  3752. <col>wpID</col>
  3753. <col>wpIsCompleted</col>
  3754. </index>
  3755. </table>
  3756. <table name="WorkflowTypes">
  3757. <field name="wftID" type="integer" size="10">
  3758. <unsigned/>
  3759. <autoincrement/>
  3760. <key/>
  3761. </field>
  3762. <field name="wftHandle" type="string" size="64">
  3763. <notnull/>
  3764. </field>
  3765. <field name="wftName" type="string" size="128">
  3766. <notnull/>
  3767. </field>
  3768. <field name="pkgID" type="integer" size="10">
  3769. <unsigned/>
  3770. <default value="0"/>
  3771. <notnull/>
  3772. </field>
  3773. <index name="wftHandle">
  3774. <unique/>
  3775. <col>wftHandle</col>
  3776. </index>
  3777. <index name="pkgID">
  3778. <col>pkgID</col>
  3779. </index>
  3780. </table>
  3781. <table name="Workflows">
  3782. <field name="wfID" type="integer" size="10">
  3783. <unsigned/>
  3784. <autoincrement/>
  3785. <key/>
  3786. </field>
  3787. <field name="wfName" type="string" size="255"/>
  3788. <field name="wftID" type="integer" size="10">
  3789. <unsigned/>
  3790. <default value="0"/>
  3791. <notnull/>
  3792. </field>
  3793. <field name="pkgID" type="integer" size="10">
  3794. <unsigned/>
  3795. <default value="0"/>
  3796. <notnull/>
  3797. </field>
  3798. <index name="wfName">
  3799. <unique/>
  3800. <col>wfName</col>
  3801. </index>
  3802. <index name="wftID">
  3803. <col>wftID</col>
  3804. <col>wfID</col>
  3805. </index>
  3806. <index name="pkgID">
  3807. <col>pkgID</col>
  3808. </index>
  3809. </table>
  3810. <table name="PermissionAccessWorkflows">
  3811. <field name="paID" type="integer" size="10">
  3812. <unsigned/>
  3813. <key/>
  3814. <default value="0"/>
  3815. </field>
  3816. <field name="wfID" type="integer" size="10">
  3817. <unsigned/>
  3818. <key/>
  3819. <default value="0"/>
  3820. </field>
  3821. <index name="wfID">
  3822. <col>wfID</col>
  3823. </index>
  3824. </table>
  3825. <table name="BasicWorkflowProgressData">
  3826. <field name="wpID" type="integer" size="10">
  3827. <unsigned/>
  3828. <key/>
  3829. <default value="0"/>
  3830. </field>
  3831. <field name="uIDStarted" type="integer" size="10">
  3832. <unsigned/>
  3833. <default value="0"/>
  3834. <notnull/>
  3835. </field>
  3836. <field name="uIDCompleted" type="integer" size="10">
  3837. <unsigned/>
  3838. <default value="0"/>
  3839. <notnull/>
  3840. </field>
  3841. <field name="wpDateCompleted" type="datetime"/>
  3842. <index name="uIDStarted">
  3843. <col>uIDStarted</col>
  3844. </index>
  3845. <index name="uIDCompleted">
  3846. <col>uIDCompleted</col>
  3847. </index>
  3848. </table>
  3849. <table name="BasicWorkflowPermissionAssignments">
  3850. <field name="wfID" type="integer" size="10">
  3851. <unsigned/>
  3852. <key/>
  3853. <default value="0"/>
  3854. </field>
  3855. <field name="pkID" type="integer" size="10">
  3856. <unsigned/>
  3857. <key/>
  3858. <default value="0"/>
  3859. </field>
  3860. <field name="paID" type="integer" size="10">
  3861. <unsigned/>
  3862. <key/>
  3863. <default value="0"/>
  3864. </field>
  3865. <index name="pkID">
  3866. <col>pkID</col>
  3867. </index>
  3868. <index name="paID">
  3869. <col>paID</col>
  3870. </index>
  3871. </table>
  3872. <table name="WorkflowRequestObjects">
  3873. <field name="wrID" type="integer" size="10">
  3874. <unsigned/>
  3875. <autoincrement/>
  3876. <key/>
  3877. </field>
  3878. <field name="wrObject" type="text" size="65535"/>
  3879. </table>
  3880. <table name="PageWorkflowProgress">
  3881. <field name="cID" type="integer" size="10">
  3882. <unsigned/>
  3883. <key/>
  3884. <default value="0"/>
  3885. </field>
  3886. <field name="wpID" type="integer" size="10">
  3887. <unsigned/>
  3888. <key/>
  3889. <default value="0"/>
  3890. </field>
  3891. <index name="wpID">
  3892. <col>wpID</col>
  3893. </index>
  3894. </table>
  3895. <table name="UserWorkflowProgress">
  3896. <field name="uID" type="integer" size="10">
  3897. <unsigned/>
  3898. <key/>
  3899. <default value="0"/>
  3900. </field>
  3901. <field name="wpID" type="integer" size="10">
  3902. <unsigned/>
  3903. <key/>
  3904. <default value="0"/>
  3905. </field>
  3906. </table>
  3907. <table name="Queues">
  3908. <field name="queue_id" type="integer" size="10">
  3909. <unsigned/>
  3910. <autoincrement/>
  3911. <key/>
  3912. </field>
  3913. <field name="queue_name" type="string" size="100">
  3914. <notnull/>
  3915. </field>
  3916. <field name="timeout" type="integer" size="5">
  3917. <unsigned/>
  3918. <default value="30"/>
  3919. <notnull/>
  3920. </field>
  3921. <index name="queue_name">
  3922. <col>queue_name</col>
  3923. </index>
  3924. <opt for="MySQL" engine="INNODB"/>
  3925. </table>
  3926. <table name="QueueMessages">
  3927. <field name="message_id" type="integer" size="20">
  3928. <unsigned/>
  3929. <autoincrement/>
  3930. <key/>
  3931. </field>
  3932. <field name="queue_id" type="integer" size="10">
  3933. <unsigned/>
  3934. <notnull/>
  3935. </field>
  3936. <field name="handle" type="string" size="32"/>
  3937. <field name="body" type="text">
  3938. <notnull/>
  3939. </field>
  3940. <field name="md5" type="string" size="32">
  3941. <notnull/>
  3942. </field>
  3943. <field name="timeout" type="decimal" size="14"> </field>
  3944. <field name="created" type="integer" size="10">
  3945. <unsigned/>
  3946. <notnull/>
  3947. </field>
  3948. <index name="message_handle">
  3949. <unique/>
  3950. <col>handle</col>
  3951. </index>
  3952. <index name="message_queueid">
  3953. <col>queue_id</col>
  3954. </index>
  3955. <opt for="MySQL" engine="INNODB"/>
  3956. <references table="Queues" onupdate="cascade" ondelete="cascade">
  3957. <column local="queue_id" foreign="queue_id"/>
  3958. </references>
  3959. </table>
  3960. <table name="QueuePageDuplicationRelations">
  3961. <field name="queue_name" type="string" size="255">
  3962. <notnull/>
  3963. </field>
  3964. <field name="cID" type="integer" size="10">
  3965. <unsigned/>
  3966. <key/>
  3967. <default value="0"/>
  3968. </field>
  3969. <field name="originalCID" type="integer" size="10">
  3970. <unsigned/>
  3971. <key/>
  3972. <default value="0"/>
  3973. </field>
  3974. <index name="originalCID">
  3975. <col>originalCID</col>
  3976. <col>queue_name</col>
  3977. </index>
  3978. <opt for="MySQL" engine="INNODB"/>
  3979. </table>
  3980. <table name="Trees">
  3981. <field name="treeID" type="integer" size="11">
  3982. <unsigned/>
  3983. <autoincrement/>
  3984. <key/>
  3985. </field>
  3986. <field name="treeTypeID" type="integer" size="11">
  3987. <unsigned/>
  3988. <default value="0"/>
  3989. </field>
  3990. <field name="treeDateAdded" type="datetime"/>
  3991. <field name="rootTreeNodeID" type="integer" size="10">
  3992. <unsigned/>
  3993. <default value="0"/>
  3994. </field>
  3995. <index name="treeTypeID">
  3996. <col>treeTypeID</col>
  3997. </index>
  3998. </table>
  3999. <table name="TreeTypes">
  4000. <field name="treeTypeID" type="integer" size="11">
  4001. <unsigned/>
  4002. <autoincrement/>
  4003. <key/>
  4004. </field>
  4005. <field name="treeTypeHandle" type="string" size="255">
  4006. <default value=""/>
  4007. </field>
  4008. <field name="pkgID" type="integer" size="11">
  4009. <unsigned/>
  4010. <default value="0"/>
  4011. </field>
  4012. <index name="treeTypeHandle">
  4013. <unique/>
  4014. <col>treeTypeHandle</col>
  4015. </index>
  4016. <index name="pkgID">
  4017. <col>pkgID</col>
  4018. </index>
  4019. </table>
  4020. <table name="TreeNodeTypes">
  4021. <field name="treeNodeTypeID" type="integer" size="11">
  4022. <unsigned/>
  4023. <autoincrement/>
  4024. <key/>
  4025. </field>
  4026. <field name="treeNodeTypeHandle" type="string" size="255">
  4027. <default value=""/>
  4028. </field>
  4029. <field name="pkgID" type="integer" size="11">
  4030. <unsigned/>
  4031. <default value="0"/>
  4032. </field>
  4033. <index name="treeNodeTypeHandle">
  4034. <unique/>
  4035. <col>treeNodeTypeHandle</col>
  4036. </index>
  4037. <index name="pkgID">
  4038. <col>pkgID</col>
  4039. </index>
  4040. </table>
  4041. <table name="TreeNodes">
  4042. <field name="treeNodeID" type="integer" size="11">
  4043. <unsigned/>
  4044. <autoincrement/>
  4045. <key/>
  4046. </field>
  4047. <field name="treeNodeTypeID" type="integer" size="11">
  4048. <unsigned/>
  4049. <default value="0"/>
  4050. </field>
  4051. <field name="treeID" type="integer" size="11">
  4052. <unsigned/>
  4053. <default value="0"/>
  4054. </field>
  4055. <field name="treeNodeParentID" type="integer" size="10">
  4056. <unsigned/>
  4057. <default value="0"/>
  4058. </field>
  4059. <field name="treeNodeDisplayOrder" type="integer" size="10">
  4060. <unsigned/>
  4061. <default value="0"/>
  4062. </field>
  4063. <field name="treeNodeName" type="string" size="255">
  4064. <default value=""/>
  4065. </field>
  4066. <field name="dateModified" type="datetime"> </field>
  4067. <field name="dateCreated" type="datetime"> </field>
  4068. <field name="treeNodeOverridePermissions" type="boolean">
  4069. <default value="0"/>
  4070. </field>
  4071. <field name="inheritPermissionsFromTreeNodeID" type="integer">
  4072. <unsigned/>
  4073. <default value="0"/>
  4074. </field>
  4075. <index name="treeNodeParentID">
  4076. <col>treeNodeParentID</col>
  4077. </index>
  4078. <index name="treeNodeTypeID">
  4079. <col>treeNodeTypeID</col>
  4080. </index>
  4081. <index name="treeID">
  4082. <col>treeID</col>
  4083. </index>
  4084. <index name="inheritPermissionsFromTreeNodeID">
  4085. <col>inheritPermissionsFromTreeNodeID</col>
  4086. <col>treeNodeID</col>
  4087. </index>
  4088. </table>
  4089. <table name="TreeNodePermissionAssignments">
  4090. <field name="treeNodeID" type="integer" size="10">
  4091. <unsigned/>
  4092. <key/>
  4093. <default value="0"/>
  4094. </field>
  4095. <field name="pkID" type="integer" size="10">
  4096. <unsigned/>
  4097. <key/>
  4098. <default value="0"/>
  4099. </field>
  4100. <field name="paID" type="integer" size="10">
  4101. <unsigned/>
  4102. <key/>
  4103. <default value="0"/>
  4104. </field>
  4105. <index name="pkID">
  4106. <col>pkID</col>
  4107. </index>
  4108. <index name="paID">
  4109. <col>paID</col>
  4110. </index>
  4111. </table>
  4112. <table name="TreeGroupNodes">
  4113. <field name="treeNodeID" type="integer" size="11">
  4114. <unsigned/>
  4115. <autoincrement/>
  4116. <key/>
  4117. </field>
  4118. <field name="gID" type="integer" size="11">
  4119. <unsigned/>
  4120. <default value="0"/>
  4121. </field>
  4122. <index name="gID">
  4123. <col>gID</col>
  4124. </index>
  4125. </table>
  4126. <table name="TreeFileNodes">
  4127. <field name="treeNodeID" type="integer" size="11">
  4128. <unsigned/>
  4129. <autoincrement/>
  4130. <key/>
  4131. </field>
  4132. <field name="fID" type="integer" size="11">
  4133. <unsigned/>
  4134. <default value="0"/>
  4135. </field>
  4136. <index name="fID">
  4137. <col>fID</col>
  4138. </index>
  4139. </table>
  4140. <table name="TreeSearchQueryNodes">
  4141. <field name="treeNodeID" type="integer" size="11">
  4142. <unsigned/>
  4143. <autoincrement/>
  4144. <key/>
  4145. </field>
  4146. <field name="savedSearchID" type="string"> </field>
  4147. <index name="savedSearchID">
  4148. <col>savedSearchID</col>
  4149. </index>
  4150. </table>
  4151. <table name="TopicTrees">
  4152. <field name="treeID" type="integer" size="11">
  4153. <unsigned/>
  4154. <key/>
  4155. <default value="0"/>
  4156. </field>
  4157. <field name="topicTreeName" type="string" size="255">
  4158. <default value=""/>
  4159. </field>
  4160. </table>
  4161. <table name="Sessions">
  4162. <field name="sessionID" type="string" size="255">
  4163. <key/>
  4164. <notnull/>
  4165. </field>
  4166. <field name="sessionValue" type="text" size="65535">
  4167. <notnull/>
  4168. </field>
  4169. <field name="sessionTime" type="integer" size="11">
  4170. <unsigned/>
  4171. <notnull/>
  4172. </field>
  4173. <field name="sessionLifeTime" type="integer" size="11">
  4174. <unsigned/>
  4175. <notnull/>
  4176. </field>
  4177. </table>
  4178. <table name="FileImageThumbnailPaths">
  4179. <field name="fileID" type="integer">
  4180. <unsigned/>
  4181. <notnull/>
  4182. </field>
  4183. <field name="fileVersionID" type="integer">
  4184. <unsigned/>
  4185. <notnull/>
  4186. </field>
  4187. <field name="thumbnailTypeHandle" type="string" size="255">
  4188. <notnull/>
  4189. </field>
  4190. <field name="storageLocationID" type="integer">
  4191. <unsigned/>
  4192. <notnull/>
  4193. </field>
  4194. <field name="path" type="text">
  4195. <notnull/>
  4196. </field>
  4197. <field name="isBuilt" type="boolean">
  4198. <notnull/>
  4199. </field>
  4200. <field name="lockID" type="string" size="255"/>
  4201. <field name="lockExpires" type="datetime"/>
  4202. <index name="thumbnailPathID">
  4203. <unique/>
  4204. <col>fileID</col>
  4205. <col>fileVersionID</col>
  4206. <col>thumbnailTypeHandle</col>
  4207. <col>storageLocationID</col>
  4208. </index>
  4209. </table>
  4210. </schema>

Paste is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.