WB 2.08.x

16 Nov-2012 Build 1820 Dietmar Woellbrink (Luisehahne)

+ added sql folder including  websitebaker.sql, wb_search.sql

! update /install/save.php, will now created the tables with $database->SqlImport() 

! update search layout in settings

if(!defined('REVISION')) define('REVISION', '1820');

--

-- Tabellenstruktur für Tabelle '{TABLE_PREFIX}addons'

--

DROP TABLE IF EXISTS {TABLE_PREFIX}addons;

CREATE TABLE IF NOT EXISTS {TABLE_PREFIX}addons (

  addon_id int(11) NOT NULL AUTO_INCREMENT,

  `type` varchar(255) NOT NULL DEFAULT '',

  `directory` varchar(255) NOT NULL DEFAULT '',

  `name` varchar(255) NOT NULL DEFAULT '',

  description text NOT NULL,

  `function` varchar(255) NOT NULL DEFAULT '',

  version varchar(255) NOT NULL DEFAULT '',

  platform varchar(255) NOT NULL DEFAULT '',

  author varchar(255) NOT NULL DEFAULT '',

  license varchar(255) NOT NULL DEFAULT '',

  PRIMARY KEY (addon_id)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--

-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}groups`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}groups`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}groups` (

  `group_id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `system_permissions` text COLLATE utf8_unicode_ci NOT NULL,

  `module_permissions` text COLLATE utf8_unicode_ci NOT NULL,

  `template_permissions` text COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`group_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--

-- Daten für Tabelle `{TABLE_PREFIX}groups`

--

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', '', '');

-- --------------------------------------------------------

--

-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}pages`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}pages`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}pages` (

  `page_id` int(11) NOT NULL AUTO_INCREMENT,

  `parent` int(11) NOT NULL DEFAULT '0',

  `root_parent` int(11) NOT NULL DEFAULT '0',

  `level` int(11) NOT NULL DEFAULT '0',

  `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

  `target` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `page_icon` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `menu_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `menu_icon_0` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `menu_icon_1` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `tooltip` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `description` text COLLATE utf8_unicode_ci NOT NULL,

  `keywords` text COLLATE utf8_unicode_ci NOT NULL,

  `page_trail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

  `template` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `visibility` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `position` int(11) NOT NULL DEFAULT '0',

  `menu` int(11) NOT NULL DEFAULT '1',

  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `page_code` int(11) NOT NULL DEFAULT '0',

  `searching` int(11) NOT NULL DEFAULT '0',

  `admin_groups` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',

  `admin_users` varchar(512) COLLATE utf8_unicode_ci NOT NULL,

  `viewing_groups` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',

  `viewing_users` varchar(512) COLLATE utf8_unicode_ci NOT NULL,

  `modified_when` int(11) NOT NULL DEFAULT '0',

  `modified_by` int(11) NOT NULL DEFAULT '0',

  `custom01` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `custom02` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  PRIMARY KEY (`page_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--

-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}sections`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}sections`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}sections` (

  `section_id` int(11) NOT NULL AUTO_INCREMENT,

  `page_id` int(11) NOT NULL DEFAULT '0',

  `position` int(11) NOT NULL DEFAULT '0',

  `module` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `block` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `publ_start` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',

  `publ_end` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',

  PRIMARY KEY (`section_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--

-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}users`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}users`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}users` (

  `user_id` int(11) NOT NULL AUTO_INCREMENT,

  `group_id` int(11) NOT NULL DEFAULT '0',

  `groups_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',

  `active` int(11) NOT NULL DEFAULT '0',

  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `confirm_code` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `confirm_timeout` int(11) NOT NULL DEFAULT '0',

  `remember_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `last_reset` int(11) NOT NULL DEFAULT '0',

  `display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `email` text COLLATE utf8_unicode_ci NOT NULL,

  `timezone` int(11) NOT NULL DEFAULT '0',

  `date_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `time_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EN',

  `home_folder` text COLLATE utf8_unicode_ci NOT NULL,

  `login_when` int(11) NOT NULL DEFAULT '0',

  `login_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  PRIMARY KEY (`user_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--

-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}settings`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}settings`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}settings` (

  `setting_id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `value` text COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`setting_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--

-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}search`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}search`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}search` (

  `search_id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) NOT NULL DEFAULT '',

  `value` text NOT NULL,

  `extra` text NOT NULL,

  PRIMARY KEY (`search_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--

-- Daten für Tabelle `{TABLE_PREFIX}search`

--

INSERT INTO `{TABLE_PREFIX}search` VALUES(1, 'header', '<h1>[TEXT_SEARCH]</h1>\r\n<form name="searchpage" action="[WB_URL]/search/index.php" method="get">\r\n<table cellpadding="3" cellspacing="0" border="0" style="width:100%; max-width:500px">\r\n<tr>\r\n<td>\r\n<input type="hidden" name="search_path" value="[SEARCH_PATH]" />\r\n<input type="hidden" name="referrer" value="[REFERRER]" />\r\n<input type="text" name="string" value="[SEARCH_STRING]" style="width: 100%;" />\r\n</td>\r\n<td width="100">\r\n<input type="submit" value="[TEXT_SEARCH]" style="width: 100%;" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan="2">\r\n<input type="radio" name="match" id="match_all" value="all"[ALL_CHECKED] />\r\n<label for="match_all">[TEXT_ALL_WORDS]</label>\r\n<input type="radio" name="match" id="match_any" value="any"[ANY_CHECKED] />\r\n<label for="match_any">[TEXT_ANY_WORDS]</label>\r\n<input type="radio" name="match" id="match_exact" value="exact"[EXACT_CHECKED] />\r\n<label for="match_exact">[TEXT_EXACT_MATCH]</label>\r\n</td>\r\n</tr>\r\n</table>\r\n</form>\r\n<hr />', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(2, 'footer', '', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(3, 'results_header', '<p>[TEXT_RESULTS_FOR] "<strong>[SEARCH_STRING]</strong>":</p>\r\n<div class="searchresults">', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(4, 'results_loop', '<h3 style="margin:10px 0 3px 0;"><a href="[LINK]">[TITLE]</a></h3>\r\n<div style="font-size:0.8em;">[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] [TEXT_ON] [DATE]</div>\r\n<p style="padding: 0 0 5px 0; margin: 2px 0 10px 0; border-bottom: 1px solid #777;">[DESCRIPTION].. [EXCERPT]</p>', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(5, 'results_footer', '</div>', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(6, 'no_results', '<p>[TEXT_NO_RESULTS]</p>', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(7, 'module_order', 'faqbaker,manual,wysiwyg', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(8, 'max_excerpt', '5', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(9, 'time_limit', '0', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(10, 'cfg_enable_old_search', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(11, 'cfg_search_keywords', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(12, 'cfg_search_description', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(13, 'cfg_show_description', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(14, 'cfg_enable_flush', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(15, 'template', '', '');