SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- Database: `soft_saurus47`
-- --------------------------------------------------------
-- Table structure for table `admin_osa`
CREATE TABLE `admin_osa` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) unsigned NOT NULL DEFAULT '0',
`sorteering` int(11) unsigned NOT NULL DEFAULT '0',
`nimetus` varchar(255) DEFAULT NULL,
`eng_nimetus` varchar(255) DEFAULT NULL,
`fail` varchar(255) DEFAULT NULL,
`moodul_id` int(11) unsigned NOT NULL DEFAULT '0',
`extension` varchar(100) DEFAULT NULL,
`show_in_editor` tinyint(1) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`,`parent_id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=159 ;
-- Dumping data for table `admin_osa`
INSERT INTO `admin_osa` VALUES
(2, 1, 40, '', 'Data', '', 0, NULL, 0),
(5, 1, 20, '', 'System', '', 0, NULL, 0),
(9, 32, 90, '', 'Translations', 'sys_sonad_loetelu.php', 0, NULL, 0),
(15, 69, 30, '', 'Log', 'log.php', 0, NULL, 1),
(17, 32, 80, '', 'System articles', 'sys_alias.php', 0, NULL, 0),
(19, 1, 90, '', 'Properties', '', 0, NULL, 1),
(32, 1, 60, '', 'Languages', '', 0, NULL, 0),
(33, 32, 100, '', 'Languages', 'keeled.php', 0, NULL, 0),
(34, 1, 50, '', 'Presentation', NULL, 0, NULL, 0),
(39, 34, 90, '', 'Custom Style Sheet', 'custom_css.php', 0, NULL, 0),
(42, 5, 70, '', 'Configuration', 'change_config.php', 0, NULL, 0),
(58, 34, 70, '', 'Content templates', 'content_templates.php', 0, NULL, 0),
(59, 34, 80, '', 'Page templates', 'page_templates.php', 0, NULL, 0),
(60, 19, 100, '', 'Site properties', 'change_config.php?group=1', 0, NULL, 1),
(62, 69, 80, '', 'Recycle Bin', 'trash.php', 0, NULL, 1),
(68, 5, 100, '', 'System info', 'sys_info.php', 0, NULL, 0),
(69, 1, 100, '', 'Tools', '', 0, NULL, 1),
(71, 34, 60, '', 'Object templates', 'object_template_map.php', 0, NULL, 0),
(73, 69, 90, '', 'People', 'user_management.php', 0, NULL, 1),
(74, 2, 90, '', 'Profiles', 'profiles.php', 0, NULL, 0),
(75, 2, 80, '', 'Profile data', 'profile_data.php', 0, NULL, 0),
(76, 5, 20, '', 'External tables', 'db_data.php', 0, NULL, 0),
(77, 69, 100, '', 'Files', 'filemanager.php', 0, NULL, 1),
(78, 1, 10, '', 'Help', NULL, 0, NULL, 0),
(81, 78, 10, '', 'About', 'javascript:void(openpopup(''about.php'',''about'',''450'',''300''))', 0, NULL, 0),
(83, 19, 80, '', 'Permissions', 'permissions.php', 0, NULL, 0),
(85, 5, 80, '', 'Error log', 'error_log.php', 0, NULL, 0),
(86, 1, 70, '', 'Extensions', '', 0, NULL, 0),
(87, 86, 110, '', 'Extensions', 'extensions.php', 0, NULL, 0),
(150, 69, 60, '', 'Feedback forms', 'feedbackforms_handler.php', 0, NULL, 1),
(151, 19, 70, '', 'Image manipulation', 'images_config.php', 0, NULL, 0),
(152, 2, 100, '', 'Explorer', 'site_explorer.php', 0, NULL, 0),
(153, 19, 90, '', 'Site Design', 'designs.php', 0, NULL, 0),
(158, 78, 100, NULL, 'Saurus CMS homepage', 'http://www.saurus.info/" target="_blank', 0, NULL, 0);
-- --------------------------------------------------------
-- Table structure for table `allowed_mails`
CREATE TABLE `allowed_mails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mail` varchar(255) DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `cache`
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objekt_id` int(10) unsigned NOT NULL DEFAULT '0',
`aeg` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`checksum` varchar(20) NOT NULL DEFAULT '',
`requests` int(11) unsigned NOT NULL DEFAULT '0',
`user_id` bigint(20) unsigned DEFAULT NULL,
`site_id` int(10) unsigned DEFAULT NULL,
KEY `objekt_id` (`objekt_id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `config`
`nimi` varchar(255) NOT NULL DEFAULT '',
`sisu` varchar(255) DEFAULT NULL,
`on_nahtav` enum('0','1') NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `config`
INSERT INTO `config` VALUES
('active_users', '0:0', 'Visitors count on the site (guests:users)', '0'),
('add_new_user_to_mailinglists', '0', 'Add new users to all mailinglists by default', '1'),
('admin_ip_filter', '0', 'User IP access: 0 - luba k6ik, valja arvatud ... / 1 - keela k6ik, valja arvatud ...', '0'),
('adm_img_path', '/admin/images', 'administraatori osas', '0'),
('adm_path', '/admin', 'admini juur', '0'),
('ad_auth_users', '0', 'Use Active Directory authentication for users (Y/N)', '0'),
('ad_base_dn', 'OU=Company,DC=example,DC=com', 'Base DN of the AD server', '1'),
('ad_create_cms_groups', '0', 'Create group if not found in CMS? (Y/N)', '1'),
('ad_create_cms_users', '0', 'Create user if not found in CMS? (Y/N)', '1'),
('ad_readall_password', '', 'Password of the AD user with read access to the Base DN (fill only if anonymous access is denied)', '1'),
('ad_readall_username', '', 'Username of the AD user with read access to the Base DN (fill only if anonymous access is denied)', '1'),
('ad_server', '', 'Active Directory server address', '1'),
('ad_server_port', '389', 'Active Directory server port', '1'),
('alamartiklid_paises', '0', 'Subarticles alignment', '1'),
('alias_language_format', '0', 'Alias prefix format', '1'),
('alias_trail_format', '0', 'Alias format', '1'),
('allow_autologin_from_ip', '0', 'Automatic login based on user IP-address', '1'),
('allow_change_position', '0', 'Allow to change position for the objects', '1'),
('allow_commenting', '1', 'Allow commenting', '1'),
('allow_forgot_password', '1', 'Allow "Forgot password" feature', '1'),
('artiklite_arv_arhiivis', '20', 'Number of articles on archive page in "News" template', '1'),
('bank_connection_logfile', '', 'The log file for Bank Connection', '0'),
('cache_expired', '0', 'Cache expires (hours). 0 = cache is not used', '1'),
('check_for_captcha', '1', 'Use CAPTCHA verification for comments and forums', '1'),
('comment_max_chars', '120', 'Maximum length of word in the comment. Longer words will cause text wrapping.', '1'),
('company_name', '', 'Company name to display when paying', '0'),
('context_menu_open_event', 'click', 'Context menu open event', '1'),
('custom_img_path', '/px_custom', 'custom piltide jaoks, mis ei kuulu toote komplekti', '0'),
('custom_login_url', '', 'Enter a custom login page URL instead of the standard form like: http://www.example.com', '1'),
('cyr_convert_encoding', '', 'Cyrillic conversation type. Value=(k,i,a,d,m,u) or empty', '1'),
('date_format', 'dd.mm.yyyy', 'System date format', '1'),
('default_comments', '0', 'Adding comments is allowed for objects by default', '1'),
('default_mail', '[[admin_email]]', 'Default "To" e-mail address', '1'),
('default_pass_expire_days', '365', 'Registered users password expiration time (in days)', '1'),
('disable_form_based_login', '0', 'Disable form based login', '1'),
('display_errors_ip', '', 'Display errors only to these IP addresses (semicolon separated)', '1'),
('documents_directory', '/shared/documents', 'Documents directory', '1'),
('documents_in_filesystem', '1', 'If this is 1 and documents_directory has a value, then {init_documents} saves documents to the filesystem', '1'),
('documents_mod_xsendfile', '1', 'If this is 1 and documents_in_filesystem is 1 and documents_directory has a value and mod_xsendfile Apache mod has been installed, then mod_xsendfile will serve the files', '1'),
('dont_cache_objects', '', 'Cache will be skipped for ID''s (coma separated list)', '1'),
('editor_intra_link', '0', 'If "intranet" hyperlinks are allowed in the editor', '0'),
('enable_mailing_list', '1', 'Enable mailing lists', '1'),
('eshop_key', '', 'Key used to sign data in the shoppingcart (Not the same as the bank key!)', '0'),
('ESTCARD_id', '', 'ID in the ESTCARD payment system', '0'),
('ESTCARD_signature', '', 'SIGNATURE path or text for the ESTCARD payment system', '0'),
('ESTCARD_url', 'https://pos.estcard.ee/test-pos/servlet/iPAYServlet', 'URL for connecting to ESTCARD payment system', '0'),
('feedbackform_action', 'form.php', 'Form action', '1'),
('feedbackform_check_for_captcha', '0', 'Use CAPTCHA verification for feedback forms', '1'),
('feedbackform_form_name', 'SCMSForm', 'Form name', '1'),
('feedbackform_method', 'post', 'Form method', '1'),
('file_path', '/public', 'failide asukoht', '0'),
('fm_allow_multiple_upload', '1', 'Allow for multiple file uploading', '1'),
('force_https_for_admin', '0', 'Force HTTPS for admin environment', '1'),
('force_https_for_editing', '0', 'Force HTTPS for editor environment', '1'),
('from_email', '[[admin_email]]', 'Default "From" e-mail address', '1'),
('gallup_ip_check', '2', 'Prevent multiple votes', '1'),
('goto_user_details', '0:1:details.php?user=[user_id]', 'Hidden feature: kui sisselülitatud, siis kommentaari juures ei näidata mitte autori nime ja emaili,<br> vaid kasutajanime ja linki valislehele.', '0'),
('HANZA_account', '', 'ACCOUNT to use for the HANZA.NET payment system', '0'),
('HANZA_signature', '', 'SIGNATURE path or text for the HANZA.NET payment system', '0'),
('HANZA_url', 'https://www.hanza.net/cgi-bin/hanza/pangalink.jsp', 'URL for connecting to the HANZA.NET payment system', '0'),
('HANZA_username', '', 'USERNAME for the HANZA.NET payment system', '0'),
('hostname', '[[domhost]]', 'Website domain e.g "your.site.com" (Caution! Affects whole website!)', '0'),
('id_card_create_cms_users', '0', 'Create user if not found in CMS? (Y/N)', ''),
('id_card_default_cms_group', '0', 'Default group for created users', ''),
('imagemagick_path', '', 'Imagemagick binaries path. Fill only if Imagemagick is used for image \nmanipulation and it is not found in system path', '1'),
('image_mode', 'gd lib', 'Image manipulation is handed by', '1'),
('image_width', '600', 'Maximum size of picture in gallery (in pixels)', '1'),
('img_path', '/px', 'piltide asukoht', '0'),
('IPOS_account', '', 'ACCOUNT to use for the IPOS payment system', '0'),
('IPOS_signature', '', 'SIGNATURE path or text for the IPOS payment system', '0'),
('IPOS_url', 'https://unet.eyp.ee/cgi-bin/ws.sh/u-commerce.w', 'URL for connecting to the IPOS payment system', '0'),
('IPOS_username', '', 'USERNAME for the IPOS payment system', '0'),
('js_path', '/js', 'javascriptide asukoht', '0'),
('kasutaja_voti', 'deprecated', 'reg.kasutaja parooli kodeerimisel kasutatav võti', '0'),
('kasuta_ip_filter', '0', '0 - don''t use; 1 - users only; 2 - admins only; 3 - both admins and users', '0'),
('kommentaaride_lehekulgede_arv', '10', 'Number of comments pages', '1'),
('komment_arv_lehel', '10', 'Number of comments on 1 comments page', '1'),
('KREP_account', '', 'ACCOUNT to use for the KREP payment system', '0'),
('KREP_signature', '', 'SIGNATURE path or text for the KREP payment system', '0'),
('KREP_url', 'https://i-pank.krediidipank.ee/', 'URL for connecting to the KREP payment system', '0'),
('KREP_username', '', 'USERNAME for the KREP payment system', '0'),
('lock_inactive_user_after_x_days', '0', 'Lock inactive user after x days', '1'),
('login_duration_time', '5', 'Time within the login attempts are considered as one (in minutes)', '1'),
('login_locked_time', '20', 'How long user is locked after failed login attempts (in minutes)', '1'),
('mailinglist_sending_option', '0', 'Mailinglist send type', '1'),
('maillist_article_content', '0', 'Article content', '1'),
('maillist_article_title', '0', 'Article title', '1'),
('maillist_footer', '', 'Custom footer (will be added after articles)', '1'),
('maillist_format', '0', 'Mailinglists format', '1'),
('maillist_header', '', 'Custom header (will be added prior articles)', '1'),
('maillist_interval', '1', 'Mailing list interval (in hour)', '1'),
('maillist_reporter_address', '', 'Send reports about mailinglist postings to (e-mail address)', '1'),
('maillist_sender_address', '', 'Sender address', '1'),
('maillist_sending_after_publishing', '0', 'Run mailinglists after each publishing (otherwise run on pageload)', '1'),
('maillist_send_newer_than', '01.09.2004', 'Send articles that are newer than (dd.mm.yyyy)', '1'),
('maillist_subject', '0', 'Mailinglist subject', '1'),
('max_login_attempts', '5', 'Maximum number of login attempts', '1'),
('new_user_password', '', 'Password string for new users (default is empty)', '1'),
('next_10min', '1305282327', 'Time for next 10 minutes interval run', '0'),
('next_counting_active_users', '0', 'Next calculation time for the visitors count', '0'),
('next_day', '1305368127', 'Time for next day run', '0'),
('next_hour', '1305285327', 'Millal järgmine auto_publishing toimub', '0'),
('next_mailinglist', '1305285327', 'Millal järgmine auto_maillist toimub', '0'),
('next_week', '1305886527', 'Time for next week run', '0'),
('NORDEA_account', '', 'ACCOUNT to use for the Nordea Solo payment system', '0'),
('NORDEA_MAC_key', '', 'Nordea MAC signature key', '0'),
('NORDEA_url', 'https://solo3.nordea.fi/cgi-bin/SOLOPM01', 'URL for connecting to the Nordea Solo payment system', '0'),
('NORDEA_username', '', 'USERNAME for the Nordea Solo payment system', '0'),
('notification_about_new_user_enabled', '0', 'Notify administrator about new registered users by e-mail Y/N', '1'),
('only_regusers_comment', '0', 'Only authenticated users may add comments', '1'),
('original_picture_saved', '0', 'Allow original file download in image gallery\r\n', '1'),
('otsingu_tulemuste_arv', '20', 'Number of articles on search result page', '1'),
('payment_secret_key', '', 'Secret key to use for the payment system', '0'),
('php_max_execution_time', '1300', 'Maximum time a script is allowed to run (seconds)', '1'),
('php_memory_limit', '64', 'Maximum amount of memory a script is allowed to allocate (Mbytes)', '1'),
('prog_path', '', 'Path to the ''kontrolli'' and ''signeeri'' programs', '0'),
('protocol', 'http://', 'Protocol of the public website', '1'),
('proxy_server', '', 'Proxy server address', '1'),
('proxy_server_port', '', 'Proxy server port', '1'),
('redirect_to_alias', '1', 'Redirect links containing object ID to object alias', '1'),
('regusers_access_enabled', '0', '1 - enabled / 0 - disabled', '0'),
('replace_links_with_alias', '0', 'Replace local links in content with their respective aliases', '1'),
('SAMPO_account', '', 'ACCOUNT to use for the SAMPO payment system', '0'),
('SAMPO_signature', '', 'SIGNATURE path or text for the SAMPO payment system', '0'),
('SAMPO_url', 'https://www2.sampo.ee/cgi-bin/pizza', 'URL for connecting to the SAMPO payment system', '0'),
('SAMPO_username', '', 'USERNAME for the SAMPO payment system', '0'),
('save_error_log', '1', 'Save PHP and MySQL errors into the database', '1'),
('save_site_log', '1', 'Enable site log', '1'),
('search_result_excerpt_length', '180', 'Search result excerpt length', '0'),
('secure_file_path', '/shared', 'File path for non public files', '0'),
('send_error_notifiations_last_run', '2008-02-24 17:27:46', 'Last time when error notifications were sent', '0'),
('send_error_notifiations_setting', '0', 'Method for error notifications activation', '1'),
('send_error_notifiations_to', '', 'E-mail addresses to send error notifications (comma separated)', '1'),
('send_error_notifiations_to_superusers', '0', 'Send error notifications to all superusers', '1'),
('send_feedback_email', 'feedback@saurus.info', 'E-mail address where bug, feature request and other feedback are sent', '0'),
('site_name', 'Saurus CMS', 'Website name, used on printer-friendly pages', '1'),
('start_date_of_objects_counting', '01.09.2004', '[dd.mm.yyyy ] Start counting from that date', '1'),
('styles_path', '/styles/default', 'Application skin', '1'),
('subject', 'Data from website', 'E-mail "Subject"', '1'),
('thumb_width', '150', 'Maximum size of thumbnail in gallery (in pixels)', '1'),
('time_zone', '', 'GMT time zone the website is located in', '1'),
('toolbar_allowed_on_print_page', '0', 'Standard buttons allowed on the Print Page', '0'),
('transport_vat', '0.18', 'Transport V.A.T. value in percent', '1'),
('trash_expires', '10', 'Number of days content objects are preserved in recycle bin. <br>If "0", objects will be deleted immediately.', '1'),
('unix_userpasswd', '0', 'Use UNIX crypt for user login', '0'),
('UPOS_account', '', 'ACCOUNT to use for the UPOS payment system', '0'),
('UPOS_signature', '', 'SIGNATURE path or text for the UPOS payment system', '0'),
('UPOS_url', 'https://unet.eyp.ee/cgi-bin/ws.sh/u-pos.w', 'URL for connecting to the UPOS payment system', '0'),
('UPOS_username', '', 'USERNAME for the UPOS payment system', '0'),
('users_can_delete_comment', '1', 'Users are allowed to delete their last comment', '1'),
('users_can_register', '0', 'Site visitors are allowed to register', '1'),
('users_require_safe_password', '0', 'Check for password difficulty', '1'),
('user_ip_filter', '0', 'User IP access: 0 - luba k6ik, valja arvatud ... / 1 - keela k6ik, valja arvatud ...', '0'),
('use_aliases', '0', 'Use human friendly URLs', '1'),
('use_ntlm_auth', '0', 'Use NTLM authentication for users? (Y/N)', '1'),
('wwwroot', '[[relativeurl]]', 'Website root URL (if any) e.g "/mysite" (Caution! Affects whole website!)', '0'),
('xml_max_filecount', '100', 'The maximum number of XML import files that are processed at once', '1');
-- --------------------------------------------------------
-- Table structure for table `config_images`
CREATE TABLE `config_images` (
`definition_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`definition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
-- Dumping data for table `config_images`
INSERT INTO `config_images` VALUES
(2, 'Content width', '520'),
(3, 'Half of content width', '260');
-- --------------------------------------------------------
-- Table structure for table `css`
`css_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`is_active` tinyint(1) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
-- Dumping data for table `css`
(1, 'custom_css', '@import url(extensions/saurus4/css/main.css);\r\n@import url(extensions/saurus4/css/content.css);\r\n\r\nbody, td {\r\n font-family: "Lucida Sans Unicode", Verdana, sans-serif;\r\n font-size: 13px;\r\n color: #495B76;\r\n}\r\n\r\na {\r\n color: #85A5EF;\r\n}\r\n\r\nh1 {\r\n margin: 0px;\r\n padding-top: 10px;\r\n font-size: 24px;\r\n font-weight: normal;\r\n}\r\n\r\nh2 {\r\n margin: 0px;\r\n padding-top: 10px;\r\n font-size: 20px;\r\n font-weight: normal;\r\n}\r\n\r\nh3 {\r\n margin: 0px;\r\n padding-top: 10px;\r\n font-size: 16px;\r\n font-weight: normal;\r\n}\r\n\r\np.qoute {\r\n margin: 10px 0px 10px 0px;\r\n padding-left: 15px;\r\n font-style: italic;\r\n border-left: 3px solid #85A5EF;\r\n}\r\n\r\nspan.Date {\r\n font-size: 11px;\r\n color: #85A5EF;\r\n}\r\n', 1),
(2, 'wysiwyg_css', 'h1 {\r\n margin: 0px;\r\n padding-top: 10px;\r\n font-size: 24px !important;\r\n font-weight: normal;\r\n}\r\n\r\nh2 {\r\n margin: 0px;\r\n padding-top: 10px;\r\n font-size: 20px !important;\r\n font-weight: normal;\r\n}\r\n\r\nh3 {\r\n margin: 0px;\r\n padding-top: 10px;\r\n font-size: 16px !important;\r\n font-weight: normal;\r\n} \r\n\r\np.qoute {\r\n margin: 10px 0px 10px 0px;\r\n padding-left: 15px;\r\n font-style: italic;\r\n border-left: 3px solid #85A5EF;\r\n}\r\n\r\npre {\r\n}\r\n\r\nspan.Date {\r\n font-size: 11px;\r\n color: #85A5EF;\r\n}\r\n', 1),
(3, 'wysiwyg_css_general', 'body, td {\r\n padding: 5px 5px 5px 5px;\r\n margin: 0px;\r\n background-color: #ffffff;\r\n font-family: "Lucida Sans Unicode", Verdana, sans-serif;\r\n font-size: 13px;\r\n color: #495B76;\r\n}\r\n\r\na {\r\n color: #85A5EF !important;\r\n}\r\n', 1);
-- --------------------------------------------------------
-- Table structure for table `document_parts`
CREATE TABLE `document_parts` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`objekt_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`content` longblob NOT NULL,
KEY `id_objekt_id` (`objekt_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `error_log`
CREATE TABLE `error_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`time_of_error` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`err_text` text NOT NULL,
`err_type` enum('PHP','SQL','CMS') NOT NULL DEFAULT 'CMS',
`domain` varchar(255) NOT NULL DEFAULT '',
`referrer` varchar(255) NOT NULL DEFAULT '',
`fdat_scope` text NOT NULL,
`ip` varchar(15) NOT NULL DEFAULT '',
`remote_user` varchar(255) NOT NULL DEFAULT '',
KEY `err_type` (`err_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `extensions`
CREATE TABLE `extensions` (
`extension_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`title` varchar(255) DEFAULT NULL,
`path` varchar(255) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`icon_path` varchar(255) DEFAULT NULL,
`version` varchar(15) DEFAULT NULL,
`version_date` date NOT NULL DEFAULT '0000-00-00',
`min_saurus_version` varchar(15) DEFAULT NULL,
`min_saurus_modules` varchar(255) DEFAULT NULL,
`is_official` tinyint(1) unsigned NOT NULL DEFAULT '1',
`is_active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_downloadable` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`extension_id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
-- Dumping data for table `extensions`
INSERT INTO `extensions` VALUES
(1, 'saurus4', 'Saurus 4', 'These templates ship with Saurus CMS 4 installation.', 'extensions/saurus4/', 'Saurus <a href="http://www.saurus.info" target="_blank">www.saurus.info</a>', 'logo.gif', '1.8', '2009-11-19', '4.6.4', '', 1, 0, 1),
(4, 'sample', 'Sample Extension', 'For explaining how stuff works', 'extensions/sample/', 'Saurus <a href="http://www.saurus.info" target="_blank">www.saurus.info</a>', 'logo.gif', '1.0', '2006-05-18', '4.2.0', '', 1, 0, 0);
-- --------------------------------------------------------
-- Table structure for table `ext_country`
CREATE TABLE `ext_country` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`profile_id` int(4) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=235 ;
-- Dumping data for table `ext_country`
INSERT INTO `ext_country` VALUES
(5, 135, 'American Samoa'),
(10, 135, 'Antigua and Barbuda'),
(14, 135, 'Ascension Island'),
(28, 135, 'Bosnia and Herzegovina'),
(30, 135, 'Bouvet Island'),
(32, 135, 'British Indian Ocean Territory'),
(33, 135, 'Brunei Darussalam'),
(35, 135, 'Burkina Faso'),
(41, 135, 'Cayman Islands'),
(42, 135, 'Central African Republic'),
(46, 135, 'Christmas Island'),
(47, 135, 'Cocos (Keeling) Islands'),
(50, 135, 'Croatia/Hrvatska'),
(53, 135, 'Czech Republic'),
(57, 135, 'Dominican Republic'),
(61, 135, 'El Salvador'),
(62, 135, 'Equatorial Guinea'),
(66, 135, 'Falkland Islands (Malvina)'),
(67, 135, 'Faroe Islands'),
(71, 135, 'French Guiana'),
(72, 135, 'French Polynesia'),
(73, 135, 'French Southern Territories'),
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
