Index: branches/2.8.x/CHANGELOG =================================================================== --- branches/2.8.x/CHANGELOG (revision 1819) +++ branches/2.8.x/CHANGELOG (revision 1820) @@ -13,6 +13,10 @@ +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 16 Nov-2012 Build 1819 Dietmar Woellbrink (Luisehahne) # bugfix media, Undefined index /admin/media/upload.php on line 108 - removed obselete resize_img.php Index: branches/2.8.x/wb/admin/interface/version.php =================================================================== --- branches/2.8.x/wb/admin/interface/version.php (revision 1819) +++ branches/2.8.x/wb/admin/interface/version.php (revision 1820) @@ -51,5 +51,5 @@ // check if defined to avoid errors during installation (redirect to admin panel fails if PHP error/warnings are enabled) if(!defined('VERSION')) define('VERSION', '2.8.3'); -if(!defined('REVISION')) define('REVISION', '1819'); +if(!defined('REVISION')) define('REVISION', '1820'); if(!defined('SP')) define('SP', ''); Index: branches/2.8.x/wb/install/sql/websitebaker.sql =================================================================== --- branches/2.8.x/wb/install/sql/websitebaker.sql (nonexistent) +++ branches/2.8.x/wb/install/sql/websitebaker.sql (revision 1820) @@ -0,0 +1,140 @@ +-- +-- 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; + Property changes on: branches/2.8.x/wb/install/sql/websitebaker.sql ___________________________________________________________________ Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Date Author Id Revision HeadURL \ No newline at end of property Index: branches/2.8.x/wb/install/sql/wb_search.sql =================================================================== --- branches/2.8.x/wb/install/sql/wb_search.sql (nonexistent) +++ branches/2.8.x/wb/install/sql/wb_search.sql (revision 1820) @@ -0,0 +1,33 @@ + +-- +-- 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', '

[TEXT_SEARCH]

\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n
\r\n
', ''); +INSERT INTO `{TABLE_PREFIX}search` VALUES(2, 'footer', '', ''); +INSERT INTO `{TABLE_PREFIX}search` VALUES(3, 'results_header', '

[TEXT_RESULTS_FOR] "[SEARCH_STRING]":

\r\n
', ''); +INSERT INTO `{TABLE_PREFIX}search` VALUES(4, 'results_loop', '

[TITLE]

\r\n
[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] [TEXT_ON] [DATE]
\r\n

[DESCRIPTION].. [EXCERPT]

', ''); +INSERT INTO `{TABLE_PREFIX}search` VALUES(5, 'results_footer', '
', ''); +INSERT INTO `{TABLE_PREFIX}search` VALUES(6, 'no_results', '

[TEXT_NO_RESULTS]

', ''); +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', '', ''); Property changes on: branches/2.8.x/wb/install/sql/wb_search.sql ___________________________________________________________________ Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Date Author Id Revision HeadURL \ No newline at end of property