Posted By

mantosz on 08/01/11


Tagged

fix installsql


Versions (?)

Symphony Install.sql Error Fix


 / Published in: Symfony
 

  1. -- *** STRUCTURE: `tbl_authors` ***
  2. DROP TABLE IF EXISTS `tbl_authors`;
  3. CREATE TABLE `tbl_authors` (
  4. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  5. `username` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  6. `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  7. `first_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  8. `last_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  9. `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  10. `last_seen` datetime DEFAULT '0000-00-00 00:00:00',
  11. `user_type` enum('author','developer') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'author',
  12. `primary` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  13. `default_section` int(11) NOT NULL,
  14. `auth_token_active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  15. `language` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  16. PRIMARY KEY (`id`),
  17. UNIQUE KEY `username` (`username`)
  18. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  19.  
  20. -- *** STRUCTURE: `tbl_cache` ***
  21. DROP TABLE IF EXISTS `tbl_cache`;
  22. CREATE TABLE `tbl_cache` (
  23. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  24. `hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  25. `creation` int(14) NOT NULL DEFAULT '0',
  26. `expiry` int(14) unsigned DEFAULT NULL,
  27. `data` longtext COLLATE utf8_unicode_ci NOT NULL,
  28. PRIMARY KEY (`id`),
  29. KEY `creation` (`creation`),
  30. KEY `hash` (`hash`)
  31. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  32.  
  33. -- *** STRUCTURE: `tbl_entries` ***
  34. DROP TABLE IF EXISTS `tbl_entries`;
  35. CREATE TABLE `tbl_entries` (
  36. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  37. `section_id` int(11) unsigned NOT NULL,
  38. `author_id` int(11) unsigned NOT NULL,
  39. `creation_date` datetime NOT NULL,
  40. `creation_date_gmt` datetime NOT NULL,
  41. PRIMARY KEY (`id`),
  42. KEY `section_id` (`section_id`),
  43. KEY `author_id` (`author_id`),
  44. KEY `creation_date` (`creation_date`),
  45. KEY `creation_date_gmt` (`creation_date_gmt`)
  46. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  47.  
  48. -- *** STRUCTURE: `tbl_extensions` ***
  49. DROP TABLE IF EXISTS `tbl_extensions`;
  50. CREATE TABLE `tbl_extensions` (
  51. `id` int(11) NOT NULL AUTO_INCREMENT,
  52. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  53. `status` enum('enabled','disabled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enabled',
  54. `version` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  55. PRIMARY KEY (`id`),
  56. KEY `name` (`name`)
  57. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  58.  
  59. -- *** STRUCTURE: `tbl_extensions_delegates` ***
  60. DROP TABLE IF EXISTS `tbl_extensions_delegates`;
  61. CREATE TABLE `tbl_extensions_delegates` (
  62. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  63. `extension_id` int(11) NOT NULL,
  64. `page` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  65. `delegate` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  66. `callback` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  67. PRIMARY KEY (`id`),
  68. KEY `extension_id` (`extension_id`),
  69. KEY `page` (`page`),
  70. KEY `delegate` (`delegate`)
  71. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  72.  
  73. -- *** STRUCTURE: `tbl_fields` ***
  74. DROP TABLE IF EXISTS `tbl_fields`;
  75. CREATE TABLE `tbl_fields` (
  76. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  77. `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  78. `element_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  79. `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  80. `parent_section` int(11) NOT NULL DEFAULT '0',
  81. `required` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  82. `sortorder` int(11) NOT NULL DEFAULT '1',
  83. `location` enum('main','sidebar') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'main',
  84. `show_column` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  85. PRIMARY KEY (`id`),
  86. KEY `index` (`element_name`,`type`,`parent_section`)
  87. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  88.  
  89. -- *** STRUCTURE: `tbl_fields_author` ***
  90. DROP TABLE IF EXISTS `tbl_fields_author`;
  91. CREATE TABLE `tbl_fields_author` (
  92. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  93. `field_id` int(11) unsigned NOT NULL,
  94. `allow_author_change` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
  95. `allow_multiple_selection` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  96. `default_to_current_user` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
  97. PRIMARY KEY (`id`),
  98. UNIQUE KEY `field_id` (`field_id`)
  99. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  100.  
  101. -- *** STRUCTURE: `tbl_fields_checkbox` ***
  102. DROP TABLE IF EXISTS `tbl_fields_checkbox`;
  103. CREATE TABLE `tbl_fields_checkbox` (
  104. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  105. `field_id` int(11) unsigned NOT NULL,
  106. `default_state` enum('on','off') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on',
  107. `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  108. PRIMARY KEY (`id`),
  109. KEY `field_id` (`field_id`)
  110. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  111.  
  112. -- *** STRUCTURE: `tbl_fields_date` ***
  113. DROP TABLE IF EXISTS `tbl_fields_date`;
  114. CREATE TABLE `tbl_fields_date` (
  115. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  116. `field_id` int(11) unsigned NOT NULL,
  117. `pre_populate` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  118. `calendar` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  119. PRIMARY KEY (`id`),
  120. KEY `field_id` (`field_id`)
  121. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  122.  
  123. -- *** STRUCTURE: `tbl_fields_input` ***
  124. DROP TABLE IF EXISTS `tbl_fields_input`;
  125. CREATE TABLE `tbl_fields_input` (
  126. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  127. `field_id` int(11) unsigned NOT NULL,
  128. `validator` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  129. PRIMARY KEY (`id`),
  130. KEY `field_id` (`field_id`)
  131. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  132.  
  133. -- *** STRUCTURE: `tbl_fields_select` ***
  134. DROP TABLE IF EXISTS `tbl_fields_select`;
  135. CREATE TABLE `tbl_fields_select` (
  136. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  137. `field_id` int(11) unsigned NOT NULL,
  138. `allow_multiple_selection` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  139. `static_options` text COLLATE utf8_unicode_ci,
  140. `dynamic_options` int(11) unsigned DEFAULT NULL,
  141. PRIMARY KEY (`id`),
  142. KEY `field_id` (`field_id`)
  143. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  144.  
  145. -- *** STRUCTURE: `tbl_fields_taglist` ***
  146. DROP TABLE IF EXISTS `tbl_fields_taglist`;
  147. CREATE TABLE `tbl_fields_taglist` (
  148. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  149. `field_id` int(11) unsigned NOT NULL,
  150. `validator` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  151. `pre_populate_source` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  152. PRIMARY KEY (`id`),
  153. KEY `field_id` (`field_id`),
  154. KEY `pre_populate_source` (`pre_populate_source`)
  155. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  156.  
  157. -- *** STRUCTURE: `tbl_fields_textarea` ***
  158. DROP TABLE IF EXISTS `tbl_fields_textarea`;
  159. CREATE TABLE `tbl_fields_textarea` (
  160. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  161. `field_id` int(11) unsigned NOT NULL,
  162. `formatter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  163. `size` int(3) unsigned NOT NULL,
  164. PRIMARY KEY (`id`),
  165. KEY `field_id` (`field_id`)
  166. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  167.  
  168. -- *** STRUCTURE: `tbl_fields_upload` ***
  169. DROP TABLE IF EXISTS `tbl_fields_upload`;
  170. CREATE TABLE `tbl_fields_upload` (
  171. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  172. `field_id` int(11) unsigned NOT NULL,
  173. `destination` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  174. `validator` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  175. PRIMARY KEY (`id`),
  176. KEY `field_id` (`field_id`)
  177. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  178.  
  179. -- *** STRUCTURE: `tbl_forgotpass` ***
  180. DROP TABLE IF EXISTS `tbl_forgotpass`;
  181. CREATE TABLE `tbl_forgotpass` (
  182. `author_id` int(11) NOT NULL DEFAULT '0',
  183. `token` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  184. `expiry` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  185. PRIMARY KEY (`author_id`)
  186. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  187.  
  188. -- *** STRUCTURE: `tbl_pages` ***
  189. DROP TABLE IF EXISTS `tbl_pages`;
  190. CREATE TABLE `tbl_pages` (
  191. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  192. `parent` int(11) DEFAULT NULL,
  193. `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  194. `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  195. `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  196. `params` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  197. `data_sources` text COLLATE utf8_unicode_ci,
  198. `events` text COLLATE utf8_unicode_ci,
  199. `sortorder` int(11) NOT NULL DEFAULT '0',
  200. PRIMARY KEY (`id`),
  201. KEY `parent` (`parent`)
  202. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  203.  
  204. -- *** STRUCTURE: `tbl_pages_types` ***
  205. DROP TABLE IF EXISTS `tbl_pages_types`;
  206. CREATE TABLE `tbl_pages_types` (
  207. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  208. `page_id` int(11) unsigned NOT NULL,
  209. `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  210. PRIMARY KEY (`id`),
  211. KEY `page_id` (`page_id`,`type`)
  212. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  213.  
  214. -- *** STRUCTURE: `tbl_sections` ***
  215. DROP TABLE IF EXISTS `tbl_sections`;
  216. CREATE TABLE `tbl_sections` (
  217. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  218. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  219. `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  220. `sortorder` int(11) NOT NULL DEFAULT '0',
  221. `entry_order` varchar(7) COLLATE utf8_unicode_ci DEFAULT NULL,
  222. `entry_order_direction` enum('asc','desc') COLLATE utf8_unicode_ci DEFAULT 'asc',
  223. `hidden` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  224. `navigation_group` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Content',
  225. PRIMARY KEY (`id`),
  226. UNIQUE KEY `handle` (`handle`)
  227. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  228.  
  229. -- *** STRUCTURE: `tbl_sections_association` ***
  230. DROP TABLE IF EXISTS `tbl_sections_association`;
  231. CREATE TABLE `tbl_sections_association` (
  232. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  233. `parent_section_id` int(11) unsigned NOT NULL,
  234. `parent_section_field_id` int(11) unsigned DEFAULT NULL,
  235. `child_section_id` int(11) unsigned NOT NULL,
  236. `child_section_field_id` int(11) unsigned NOT NULL,
  237. `cascading_deletion` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  238. PRIMARY KEY (`id`),
  239. KEY `parent_section_id` (`parent_section_id`,`child_section_id`,`child_section_field_id`)
  240. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Report this snippet  

You need to login to post a comment.