Revision: 49889
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 1, 2011 17:21 by mantosz
Initial Code
-- *** STRUCTURE: `tbl_authors` *** DROP TABLE IF EXISTS `tbl_authors`; CREATE TABLE `tbl_authors` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `first_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `last_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `last_seen` datetime DEFAULT '0000-00-00 00:00:00', `user_type` enum('author','developer') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'author', `primary` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', `default_section` int(11) NOT NULL, `auth_token_active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', `language` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_cache` *** DROP TABLE IF EXISTS `tbl_cache`; CREATE TABLE `tbl_cache` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `creation` int(14) NOT NULL DEFAULT '0', `expiry` int(14) unsigned DEFAULT NULL, `data` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `creation` (`creation`), KEY `hash` (`hash`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_entries` *** DROP TABLE IF EXISTS `tbl_entries`; CREATE TABLE `tbl_entries` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `section_id` int(11) unsigned NOT NULL, `author_id` int(11) unsigned NOT NULL, `creation_date` datetime NOT NULL, `creation_date_gmt` datetime NOT NULL, PRIMARY KEY (`id`), KEY `section_id` (`section_id`), KEY `author_id` (`author_id`), KEY `creation_date` (`creation_date`), KEY `creation_date_gmt` (`creation_date_gmt`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_extensions` *** DROP TABLE IF EXISTS `tbl_extensions`; CREATE TABLE `tbl_extensions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `status` enum('enabled','disabled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enabled', `version` varchar(20) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_extensions_delegates` *** DROP TABLE IF EXISTS `tbl_extensions_delegates`; CREATE TABLE `tbl_extensions_delegates` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `extension_id` int(11) NOT NULL, `page` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `delegate` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `callback` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `extension_id` (`extension_id`), KEY `page` (`page`), KEY `delegate` (`delegate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields` *** DROP TABLE IF EXISTS `tbl_fields`; CREATE TABLE `tbl_fields` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `element_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `parent_section` int(11) NOT NULL DEFAULT '0', `required` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', `sortorder` int(11) NOT NULL DEFAULT '1', `location` enum('main','sidebar') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'main', `show_column` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', PRIMARY KEY (`id`), KEY `index` (`element_name`,`type`,`parent_section`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_author` *** DROP TABLE IF EXISTS `tbl_fields_author`; CREATE TABLE `tbl_fields_author` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `allow_author_change` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL, `allow_multiple_selection` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', `default_to_current_user` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_checkbox` *** DROP TABLE IF EXISTS `tbl_fields_checkbox`; CREATE TABLE `tbl_fields_checkbox` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `default_state` enum('on','off') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on', `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_date` *** DROP TABLE IF EXISTS `tbl_fields_date`; CREATE TABLE `tbl_fields_date` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `pre_populate` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', `calendar` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', PRIMARY KEY (`id`), KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_input` *** DROP TABLE IF EXISTS `tbl_fields_input`; CREATE TABLE `tbl_fields_input` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `validator` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_select` *** DROP TABLE IF EXISTS `tbl_fields_select`; CREATE TABLE `tbl_fields_select` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `allow_multiple_selection` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', `static_options` text COLLATE utf8_unicode_ci, `dynamic_options` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_taglist` *** DROP TABLE IF EXISTS `tbl_fields_taglist`; CREATE TABLE `tbl_fields_taglist` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `validator` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `pre_populate_source` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `field_id` (`field_id`), KEY `pre_populate_source` (`pre_populate_source`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_textarea` *** DROP TABLE IF EXISTS `tbl_fields_textarea`; CREATE TABLE `tbl_fields_textarea` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `formatter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `size` int(3) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_fields_upload` *** DROP TABLE IF EXISTS `tbl_fields_upload`; CREATE TABLE `tbl_fields_upload` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(11) unsigned NOT NULL, `destination` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `validator` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_forgotpass` *** DROP TABLE IF EXISTS `tbl_forgotpass`; CREATE TABLE `tbl_forgotpass` ( `author_id` int(11) NOT NULL DEFAULT '0', `token` varchar(6) COLLATE utf8_unicode_ci NOT NULL, `expiry` varchar(25) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`author_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_pages` *** DROP TABLE IF EXISTS `tbl_pages`; CREATE TABLE `tbl_pages` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `parent` int(11) DEFAULT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `params` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `data_sources` text COLLATE utf8_unicode_ci, `events` text COLLATE utf8_unicode_ci, `sortorder` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `parent` (`parent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_pages_types` *** DROP TABLE IF EXISTS `tbl_pages_types`; CREATE TABLE `tbl_pages_types` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `page_id` int(11) unsigned NOT NULL, `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `page_id` (`page_id`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_sections` *** DROP TABLE IF EXISTS `tbl_sections`; CREATE TABLE `tbl_sections` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `sortorder` int(11) NOT NULL DEFAULT '0', `entry_order` varchar(7) COLLATE utf8_unicode_ci DEFAULT NULL, `entry_order_direction` enum('asc','desc') COLLATE utf8_unicode_ci DEFAULT 'asc', `hidden` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', `navigation_group` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Content', PRIMARY KEY (`id`), UNIQUE KEY `handle` (`handle`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- *** STRUCTURE: `tbl_sections_association` *** DROP TABLE IF EXISTS `tbl_sections_association`; CREATE TABLE `tbl_sections_association` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `parent_section_id` int(11) unsigned NOT NULL, `parent_section_field_id` int(11) unsigned DEFAULT NULL, `child_section_id` int(11) unsigned NOT NULL, `child_section_field_id` int(11) unsigned NOT NULL, `cascading_deletion` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', PRIMARY KEY (`id`), KEY `parent_section_id` (`parent_section_id`,`child_section_id`,`child_section_field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Initial URL
Initial Description
Initial Title
Symphony Install.sql Error Fix
Initial Tags
Initial Language
Symfony