install/includes/install.sql
-- *** STRUCTURE: `tbl_authors` ***
DROP TABLE IF EXISTS `tbl_authors`;
CREATE TABLE `tbl_authors` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`password` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`first_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_seen` datetime DEFAULT '1000-01-01 00:00:00',
`user_type` enum('author','manager','developer') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'author',
`primary` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`default_area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auth_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`language` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`(191)),
KEY `auth_token` (`auth_token`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci NOT NULL DEFAULT '',
`namespace` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`creation` int(14) NOT NULL DEFAULT '0',
`expiry` int(14) unsigned DEFAULT NULL,
`data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `hash` (`hash`),
KEY `expiry` (`expiry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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,
`modification_author_id` int(11) unsigned NOT NULL DEFAULT 1,
`creation_date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`creation_date_gmt` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`modification_date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`modification_date_gmt` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
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`),
KEY `modification_date` (`modification_date`),
KEY `modification_date_gmt` (`modification_date_gmt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- *** STRUCTURE: `tbl_extensions` ***
DROP TABLE IF EXISTS `tbl_extensions`;
CREATE TABLE `tbl_extensions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`status` enum('enabled','disabled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enabled',
`version` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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) unsigned NOT NULL,
`page` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`delegate` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`callback` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`order` int(11) signed NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `extension_id` (`extension_id`),
KEY `page` (`page`),
KEY `delegate` (`delegate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci NOT NULL,
`element_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`parent_section` int(11) unsigned NOT NULL DEFAULT '0',
`required` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
`sortorder` int(11) signed NOT NULL DEFAULT '1',
`location` enum('main','sidebar') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'main',
`show_column` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`id`),
KEY `index` (`element_name`,`type`,`parent_section`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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_multiple_selection` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`default_to_current_user` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL,
`author_types` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci NOT NULL DEFAULT 'on',
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`calendar` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`time` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`sort_options` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`static_options` text COLLATE utf8mb4_unicode_ci,
`dynamic_options` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pre_populate_source` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`),
KEY `pre_populate_source` (`pre_populate_source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci DEFAULT NULL,
`size` int(3) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci NOT NULL,
`validator` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- *** STRUCTURE: `tbl_forgotpass` ***
DROP TABLE IF EXISTS `tbl_forgotpass`;
CREATE TABLE `tbl_forgotpass` (
`author_id` int(11) unsigned NOT NULL DEFAULT '0',
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`expiry` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`author_id`),
KEY `token` (`token`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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) unsigned DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`handle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`params` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`data_sources` text COLLATE utf8mb4_unicode_ci,
`events` text COLLATE utf8mb4_unicode_ci,
`sortorder` int(11) signed NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `page_id` (`page_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 utf8mb4_unicode_ci NOT NULL DEFAULT '',
`handle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`sortorder` int(11) signed NOT NULL DEFAULT '0',
`hidden` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`filter` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
`navigation_group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Content',
`author_id` int(11) unsigned NOT NULL DEFAULT 1,
`modification_author_id` int(11) unsigned NOT NULL DEFAULT 1,
`creation_date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`creation_date_gmt` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`modification_date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`modification_date_gmt` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `handle` (`handle`(191)),
KEY `creation_date` (`creation_date`),
KEY `creation_date_gmt` (`creation_date_gmt`),
KEY `modification_date` (`modification_date`),
KEY `modification_date_gmt` (`modification_date_gmt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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,
`hide_association` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`interface` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`editor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `parent_section_id` (`parent_section_id`,`child_section_id`,`child_section_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- *** STRUCTURE: `tbl_sessions` ***
DROP TABLE IF EXISTS `tbl_sessions`;
CREATE TABLE `tbl_sessions` (
`session` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`session_expires` int(10) unsigned NOT NULL DEFAULT '0',
`session_data` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`session`),
KEY `session_expires` (`session_expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;