Revision 1822
Added by Dietmar almost 12 years ago
| websitebaker.sql | ||
|---|---|---|
| 1 |
-- phpMyAdmin SQL Dump |
|
| 2 |
-- Date of creation: 2012-11-17 12:37am |
|
| 3 |
-- Server Version: 5.1.41 |
|
| 4 |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
| 5 |
-- -------------------------------------------------------- |
|
| 6 |
-- Database structure for WebsiteBaker core |
|
| 1 | 7 |
-- |
| 2 |
-- Tabellenstruktur für Tabelle '{TABLE_PREFIX}addons'
|
|
| 8 |
-- Replacements: {TABLE_PREFIX}, {TABLE_ENGINE}, {TABLE_COLLATION}
|
|
| 3 | 9 |
-- |
| 4 |
|
|
| 5 |
DROP TABLE IF EXISTS {TABLE_PREFIX}addons;
|
|
| 6 |
CREATE TABLE IF NOT EXISTS {TABLE_PREFIX}addons (
|
|
| 7 |
addon_id int(11) NOT NULL AUTO_INCREMENT, |
|
| 8 |
`type` varchar(255) NOT NULL DEFAULT '', |
|
| 9 |
`directory` varchar(255) NOT NULL DEFAULT '', |
|
| 10 |
`name` varchar(255) NOT NULL DEFAULT '', |
|
| 11 |
description text NOT NULL, |
|
| 12 |
`function` varchar(255) NOT NULL DEFAULT '', |
|
| 13 |
version varchar(255) NOT NULL DEFAULT '', |
|
| 14 |
platform varchar(255) NOT NULL DEFAULT '', |
|
| 15 |
author varchar(255) NOT NULL DEFAULT '', |
|
| 16 |
license varchar(255) NOT NULL DEFAULT '', |
|
| 10 |
-- -------------------------------------------------------- |
|
| 11 |
-- |
|
| 12 |
-- Structure of table '{TABLE_PREFIX}addons'
|
|
| 13 |
-- |
|
| 14 |
DROP TABLE IF EXISTS `{TABLE_PREFIX}addons`;
|
|
| 15 |
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}addons` (
|
|
| 16 |
`addon_id` int(11) NOT NULL AUTO_INCREMENT, |
|
| 17 |
`type` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 18 |
`directory` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 19 |
`name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 20 |
`description` text{TABLE_COLLATION} NOT NULL,
|
|
| 21 |
`function` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 22 |
`version` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 23 |
`platform` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 24 |
`author` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 25 |
`license` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 17 | 26 |
PRIMARY KEY (addon_id) |
| 18 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 19 |
|
|
| 27 |
){TABLE_ENGINE};
|
|
| 20 | 28 |
-- |
| 21 |
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}groups`
|
|
| 29 |
-- Structure of table '{TABLE_PREFIX}groups'
|
|
| 22 | 30 |
-- |
| 23 |
|
|
| 24 | 31 |
DROP TABLE IF EXISTS `{TABLE_PREFIX}groups`;
|
| 25 | 32 |
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}groups` (
|
| 26 | 33 |
`group_id` int(11) NOT NULL AUTO_INCREMENT, |
| 27 |
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 28 |
`system_permissions` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 29 |
`module_permissions` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 30 |
`template_permissions` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 34 |
`name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 35 |
`system_permissions` text{TABLE_COLLATION} NOT NULL,
|
|
| 36 |
`module_permissions` text{TABLE_COLLATION} NOT NULL,
|
|
| 37 |
`template_permissions` text{TABLE_COLLATION} NOT NULL,
|
|
| 31 | 38 |
PRIMARY KEY (`group_id`) |
| 32 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 33 |
|
|
| 39 |
){TABLE_ENGINE};
|
|
| 34 | 40 |
-- |
| 35 |
-- Daten für Tabelle `{TABLE_PREFIX}groups`
|
|
| 41 |
-- Structure of table '{TABLE_PREFIX}pages'
|
|
| 36 | 42 |
-- |
| 37 |
|
|
| 38 |
INSERT INTO `{TABLE_PREFIX}groups` VALUES(1, 'Administrators', 'access,addons,admintools,admintools_view,groups,groups_add,groups_delete,groups_modify,groups_view,languages,languages_install,languages_uninstall,languages_view,media,media_create,media_delete,media_rename,media_upload,media_view,modules,modules_advanced,modules_install,modules_uninstall,modules_view,pages,pages_add,pages_add_l0,pages_delete,pages_intro,pages_modify,pages_settings,pages_view,preferences,preferences_view,settings,settings_advanced,settings_basic,settings_view,templates,templates_install,templates_uninstall,templates_view,users,users_add,users_delete,users_modify,users_view', '', '');
|
|
| 39 |
|
|
| 40 |
-- -------------------------------------------------------- |
|
| 41 |
|
|
| 42 |
-- |
|
| 43 |
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}pages`
|
|
| 44 |
-- |
|
| 45 |
|
|
| 46 | 43 |
DROP TABLE IF EXISTS `{TABLE_PREFIX}pages`;
|
| 47 | 44 |
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}pages` (
|
| 48 | 45 |
`page_id` int(11) NOT NULL AUTO_INCREMENT, |
| 49 | 46 |
`parent` int(11) NOT NULL DEFAULT '0', |
| 50 | 47 |
`root_parent` int(11) NOT NULL DEFAULT '0', |
| 51 | 48 |
`level` int(11) NOT NULL DEFAULT '0', |
| 52 |
`link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
| 53 |
`target` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 54 |
`page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 55 |
`page_icon` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 56 |
`menu_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 57 |
`menu_icon_0` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 58 |
`menu_icon_1` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 59 |
`tooltip` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 60 |
`description` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 61 |
`keywords` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 62 |
`page_trail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
| 63 |
`template` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 64 |
`visibility` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 49 |
`link` varchar(255){TABLE_COLLATION} NOT NULL,
|
|
| 50 |
`target` varchar(7){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 51 |
`page_title` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 52 |
`page_icon` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 53 |
`menu_title` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 54 |
`menu_icon_0` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 55 |
`menu_icon_1` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 56 |
`tooltip` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 57 |
`description` text{TABLE_COLLATION} NOT NULL,
|
|
| 58 |
`keywords` text{TABLE_COLLATION} NOT NULL,
|
|
| 59 |
`page_trail` varchar(255){TABLE_COLLATION} NOT NULL,
|
|
| 60 |
`template` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 61 |
`visibility` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 65 | 62 |
`position` int(11) NOT NULL DEFAULT '0', |
| 66 | 63 |
`menu` int(11) NOT NULL DEFAULT '1', |
| 67 |
`language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 64 |
`language` varchar(5){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 68 | 65 |
`page_code` int(11) NOT NULL DEFAULT '0', |
| 69 | 66 |
`searching` int(11) NOT NULL DEFAULT '0', |
| 70 |
`admin_groups` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
|
|
| 71 |
`admin_users` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
|
|
| 72 |
`viewing_groups` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
|
|
| 73 |
`viewing_users` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
|
|
| 67 |
`admin_groups` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '1',
|
|
| 68 |
`admin_users` varchar(512){TABLE_COLLATION} NOT NULL,
|
|
| 69 |
`viewing_groups` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '1',
|
|
| 70 |
`viewing_users` varchar(512){TABLE_COLLATION} NOT NULL,
|
|
| 74 | 71 |
`modified_when` int(11) NOT NULL DEFAULT '0', |
| 75 | 72 |
`modified_by` int(11) NOT NULL DEFAULT '0', |
| 76 |
`custom01` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 77 |
`custom02` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 73 |
`custom01` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 74 |
`custom02` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 78 | 75 |
PRIMARY KEY (`page_id`) |
| 79 | 76 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 80 |
|
|
| 81 |
-- -------------------------------------------------------- |
|
| 82 |
|
|
| 83 | 77 |
-- |
| 84 |
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}sections`
|
|
| 78 |
-- Structure of table '{TABLE_PREFIX}sections'
|
|
| 85 | 79 |
-- |
| 86 |
|
|
| 87 | 80 |
DROP TABLE IF EXISTS `{TABLE_PREFIX}sections`;
|
| 88 | 81 |
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}sections` (
|
| 89 | 82 |
`section_id` int(11) NOT NULL AUTO_INCREMENT, |
| 90 | 83 |
`page_id` int(11) NOT NULL DEFAULT '0', |
| 91 | 84 |
`position` int(11) NOT NULL DEFAULT '0', |
| 92 |
`module` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 93 |
`block` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 94 |
`publ_start` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
|
|
| 95 |
`publ_end` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
|
|
| 85 |
`module` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 86 |
`block` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 87 |
`publ_start` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '0',
|
|
| 88 |
`publ_end` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '0',
|
|
| 96 | 89 |
PRIMARY KEY (`section_id`) |
| 97 | 90 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 98 |
|
|
| 99 |
-- -------------------------------------------------------- |
|
| 100 |
|
|
| 101 | 91 |
-- |
| 102 |
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}users`
|
|
| 92 |
-- Structure of table '{TABLE_PREFIX}users'
|
|
| 103 | 93 |
-- |
| 104 |
|
|
| 105 | 94 |
DROP TABLE IF EXISTS `{TABLE_PREFIX}users`;
|
| 106 | 95 |
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}users` (
|
| 107 | 96 |
`user_id` int(11) NOT NULL AUTO_INCREMENT, |
| 108 | 97 |
`group_id` int(11) NOT NULL DEFAULT '0', |
| 109 |
`groups_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
|
|
| 98 |
`groups_id` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '0',
|
|
| 110 | 99 |
`active` int(11) NOT NULL DEFAULT '0', |
| 111 |
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 112 |
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 113 |
`confirm_code` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 100 |
`username` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 101 |
`password` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 102 |
`confirm_code` varchar(32){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 114 | 103 |
`confirm_timeout` int(11) NOT NULL DEFAULT '0', |
| 115 |
`remember_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 104 |
`remember_key` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 116 | 105 |
`last_reset` int(11) NOT NULL DEFAULT '0', |
| 117 |
`display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 118 |
`email` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 106 |
`display_name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 107 |
`email` text{TABLE_COLLATION} NOT NULL,
|
|
| 119 | 108 |
`timezone` int(11) NOT NULL DEFAULT '0', |
| 120 |
`date_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 121 |
`time_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 122 |
`language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EN',
|
|
| 123 |
`home_folder` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 109 |
`date_format` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 110 |
`time_format` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 111 |
`language` varchar(5){TABLE_COLLATION} NOT NULL DEFAULT 'EN',
|
|
| 112 |
`home_folder` text{TABLE_COLLATION} NOT NULL,
|
|
| 124 | 113 |
`login_when` int(11) NOT NULL DEFAULT '0', |
| 125 |
`login_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 114 |
`login_ip` varchar(15){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 126 | 115 |
PRIMARY KEY (`user_id`) |
| 127 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 128 |
|
|
| 116 |
){TABLE_ENGINE};
|
|
| 129 | 117 |
-- |
| 130 |
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}settings`
|
|
| 118 |
-- Structure of table '{TABLE_PREFIX}settings'
|
|
| 131 | 119 |
-- |
| 132 |
|
|
| 133 | 120 |
DROP TABLE IF EXISTS `{TABLE_PREFIX}settings`;
|
| 134 | 121 |
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}settings` (
|
| 135 | 122 |
`setting_id` int(11) NOT NULL AUTO_INCREMENT, |
| 136 |
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
| 137 |
`value` text COLLATE utf8_unicode_ci NOT NULL,
|
|
| 123 |
`name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 124 |
`value` text{TABLE_COLLATION} NOT NULL,
|
|
| 138 | 125 |
PRIMARY KEY (`setting_id`) |
| 139 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 140 |
|
|
| 126 |
){TABLE_ENGINE};
|
|
| 127 |
-- |
|
| 128 |
-- Structure of table `{TABLE_PREFIX}search`
|
|
| 129 |
-- |
|
| 130 |
DROP TABLE IF EXISTS `{TABLE_PREFIX}search`;
|
|
| 131 |
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}search` (
|
|
| 132 |
`search_id` int(11) NOT NULL AUTO_INCREMENT, |
|
| 133 |
`name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',
|
|
| 134 |
`value` text{TABLE_COLLATION} NOT NULL,
|
|
| 135 |
`extra` text{TABLE_COLLATION} NOT NULL,
|
|
| 136 |
PRIMARY KEY (`search_id`) |
|
| 137 |
){TABLE_ENGINE};
|
|
| 138 |
-- EndOfFile |
|
Also available in: Unified diff
! update redirct to upgrade-script in /admin/start(index.php