-- phpMyAdmin SQL Dump
-- version 2.8.0-rc1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 03, 2006 at 11:50 PM
-- Server version: 4.1.1
-- PHP Version: 4.3.0
-- 
-- Database: `a_kb_20_release`
-- 

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

-- 
-- Table structure for table `s_data_to_user_rule`
-- 

CREATE TABLE IF NOT EXISTS `s_data_to_user_rule` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_data_to_user_rule`
-- 

INSERT INTO `s_data_to_user_rule` (`id`, `title`) VALUES (1, 'kb_category_to_admin'),
(2, 'kb_category_to_admin_role'),
(3, 'kb_category_to_member'),
(4, 'kb_category_to_member_role'),
(5, 'file_category_to_admin'),
(6, 'file_category_to_admin_role'),
(7, 'file_category_to_member'),
(8, 'file_category_to_member_role'),
(9, 'kb_entry_to_admin'),
(10, 'kb_entry_to_admin_role'),
(11, 'kb_entry_to_member'),
(12, 'kb_entry_to_member_role'),
(13, 'file_entry_to_admin'),
(14, 'file_entry_to_admin_role'),
(15, 'file_entry_to_member'),
(16, 'file_entry_to_member_role');

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

-- 
-- Table structure for table `s_data_to_user_value`
-- 

CREATE TABLE IF NOT EXISTS `s_data_to_user_value` (
  `rule_id` int(11) NOT NULL default '0',
  `data_value` int(11) NOT NULL default '0',
  `user_value` int(11) NOT NULL default '0',
  KEY `rule_id` (`rule_id`),
  KEY `data_value` (`data_value`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_data_to_user_value`
-- 


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

-- 
-- Table structure for table `s_feedback`
-- 

CREATE TABLE IF NOT EXISTS `s_feedback` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned default NULL,
  `admin_id` int(10) unsigned NOT NULL default '0',
  `category_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_answered` datetime NOT NULL default '0000-00-00 00:00:00',
  `answered` tinyint(1) NOT NULL default '0',
  `placed` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `NewIndex` (`user_id`),
  KEY `admin_id` (`admin_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_feedback`
-- 


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

-- 
-- Table structure for table `s_file_category`
-- 

CREATE TABLE IF NOT EXISTS `s_file_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL default '0',
  `num_entry` smallint(5) unsigned NOT NULL default '0',
  `private` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_file_category`
-- 


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

-- 
-- Table structure for table `s_file_entry`
-- 

CREATE TABLE IF NOT EXISTS `s_file_entry` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `author_id` int(10) unsigned NOT NULL default '0',
  `updater_id` int(10) unsigned NOT NULL default '0',
  `directory` varchar(255) NOT NULL default '',
  `sub_directory` varchar(255) NOT NULL default '',
  `filename` varchar(255) NOT NULL default '',
  `filesize` int(10) unsigned NOT NULL default '0',
  `filetype` varchar(50) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `description_full` text NOT NULL,
  `comment` text NOT NULL,
  `date_updated` timestamp NOT NULL,
  `date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `downloads` int(10) unsigned NOT NULL default '0',
  `filetext` text NOT NULL,
  `sort_order` smallint(5) unsigned NOT NULL default '1',
  `private` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `author_id` (`author_id`),
  KEY `filename` (`filename`(4)),
  KEY `updater_id` (`updater_id`),
  FULLTEXT KEY `title` (`title`,`description`,`filetext`)
) ENGINE=MyISAM COMMENT='images per item';

-- 
-- Dumping data for table `s_file_entry`
-- 


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

-- 
-- Table structure for table `s_file_entry_to_category`
-- 

CREATE TABLE IF NOT EXISTS `s_file_entry_to_category` (
  `entry_id` int(10) unsigned NOT NULL default '0',
  `category_id` int(10) unsigned NOT NULL default '0',
  `is_main` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`entry_id`,`category_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_file_entry_to_category`
-- 


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

-- 
-- Table structure for table `s_kb_attachment_to_entry`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_attachment_to_entry` (
  `entry_id` int(10) unsigned NOT NULL default '0',
  `attachment_id` int(10) unsigned NOT NULL default '0',
  `attachment_type` tinyint(1) NOT NULL default '0',
  KEY `entry_id` (`entry_id`),
  KEY `attachment_id` (`attachment_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_attachment_to_entry`
-- 


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

-- 
-- Table structure for table `s_kb_category`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL default '0',
  `num_entry` smallint(5) unsigned NOT NULL default '0',
  `commentable` tinyint(1) NOT NULL default '1',
  `ratingable` tinyint(1) NOT NULL default '1',
  `private` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_category`
-- 


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

-- 
-- Table structure for table `s_kb_comment`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_comment` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `entry_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned default NULL,
  `name` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `comment` text NOT NULL,
  `date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `entry_id` (`entry_id`),
  KEY `NewIndex` (`user_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_comment`
-- 


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

-- 
-- Table structure for table `s_kb_entry`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_entry` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `author_id` int(10) unsigned NOT NULL default '0',
  `updater_id` int(10) unsigned NOT NULL default '0',
  `title` text NOT NULL,
  `body` mediumtext NOT NULL,
  `url_title` varchar(255) NOT NULL default '',
  `meta_keywords` text NOT NULL,
  `meta_description` text NOT NULL,
  `date_updated` timestamp NOT NULL,
  `date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(10) unsigned NOT NULL default '0',
  `sort_order` smallint(5) unsigned NOT NULL default '1',
  `private` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `updater_id` (`updater_id`),
  KEY `author_id` (`author_id`),
  KEY `url_title` (`url_title`(10)),
  FULLTEXT KEY `title_only` (`title`),
  FULLTEXT KEY `title` (`title`,`body`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_entry`
-- 


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

-- 
-- Table structure for table `s_kb_entry_to_category`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_entry_to_category` (
  `entry_id` int(10) unsigned NOT NULL default '0',
  `category_id` int(10) unsigned NOT NULL default '0',
  `is_main` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`entry_id`,`category_id`),
  KEY `entry_id` (`entry_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_entry_to_category`
-- 


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

-- 
-- Table structure for table `s_kb_glossary`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_glossary` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `phrase` varchar(100) NOT NULL default '',
  `definition` text NOT NULL,
  `display_once` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_glossary`
-- 


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

-- 
-- Table structure for table `s_kb_rating`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_rating` (
  `entry_id` int(10) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rate` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_rating`
-- 


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

-- 
-- Table structure for table `s_kb_related_to_entry`
-- 

CREATE TABLE IF NOT EXISTS `s_kb_related_to_entry` (
  `entry_id` int(10) unsigned NOT NULL default '0',
  `related_entry_id` int(10) unsigned NOT NULL default '0',
  `related_type` tinyint(1) NOT NULL default '0',
  KEY `entry_id` (`entry_id`),
  KEY `attachment_id` (`related_entry_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_kb_related_to_entry`
-- 


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

-- 
-- Table structure for table `s_letter_template`
-- 

CREATE TABLE IF NOT EXISTS `s_letter_template` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `letter_key` varchar(20) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `from_email` varchar(255) NOT NULL default '',
  `from_name` varchar(255) NOT NULL default '',
  `to_email` varchar(255) NOT NULL default '',
  `to_name` varchar(255) NOT NULL default '',
  `to_cc_email` varchar(255) NOT NULL default '',
  `to_cc_name` varchar(255) NOT NULL default '',
  `to_bcc_email` varchar(255) NOT NULL default '',
  `to_bcc_name` varchar(255) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `body` text,
  `skip_field` varchar(255) NOT NULL default '',
  `is_html` tinyint(1) NOT NULL default '0',
  `in_out` tinyint(4) NOT NULL default '1',
  `predifined` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_letter_template`
-- 

INSERT INTO `s_letter_template` (`id`, `letter_key`, `title`, `description`, `from_email`, `from_name`, `to_email`, `to_name`, `to_cc_email`, `to_cc_name`, `to_bcc_email`, `to_bcc_name`, `subject`, `body`, `skip_field`, `is_html`, `in_out`, `predifined`, `active`) VALUES (1, 'send_to_friend', '', '', '', '', '', '', '', '', '', '', '', NULL, 'to,from', 0, 2, 1, 1),
(2, 'answer_to_user', '', '', '[support_email]', '[support_name]', '[email]', '[first_name] [last_name]', '', '', '', '', '', NULL, '', 0, 1, 1, 1),
(3, 'contact', '', '', '', '', '[support_email]', '[support_name]', '', '', '', '', '', NULL, 'from', 0, 1, 1, 1),
(4, 'confirm_registration', '', '', '', '', '', '', '', '', '', '', '', NULL, 'to,from', 0, 2, 1, 1),
(5, 'generated_password', '', '', '', '', '', '', '', '', '', '', '', NULL, 'to,from', 0, 2, 1, 1);

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

-- 
-- Table structure for table `s_member`
-- 

CREATE TABLE IF NOT EXISTS `s_member` (
  `id` smallint(6) NOT NULL auto_increment,
  `role_id` tinyint(3) NOT NULL default '0',
  `username` varchar(30) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `first_name` varchar(50) NOT NULL default '',
  `middle_name` varchar(50) NOT NULL default '',
  `last_name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `phone` varchar(20) NOT NULL default '',
  `member_comment` text NOT NULL,
  `admin_comment` text NOT NULL,
  `date_registered` date NOT NULL default '0000-00-00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`username`),
  KEY `pass` (`password`(2)),
  KEY `role_id` (`role_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_member`
-- 


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

-- 
-- Table structure for table `s_priv`
-- 

CREATE TABLE IF NOT EXISTS `s_priv` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `priv_name_id` smallint(6) NOT NULL default '0',
  `grantor` int(11) NOT NULL default '0',
  `timestamp` timestamp NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `user` (`user_id`),
  KEY `name_priv_id` (`priv_name_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_priv`
-- 

INSERT INTO `s_priv` (`id`, `user_id`, `priv_name_id`, `grantor`, `timestamp`) VALUES (1, 1, 1, 1, '2006-09-21 01:03:00'),
(2, 2, 2, 0, '2006-03-25 11:05:00'),
(3, 3, 3, 0, '2006-02-13 21:52:08'),
(4, 4, 4, 0, '2006-05-31 19:58:55'),
(5, 5, 5, 1, '2006-10-05 21:36:46');

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

-- 
-- Table structure for table `s_priv_module`
-- 

CREATE TABLE IF NOT EXISTS `s_priv_module` (
  `id` smallint(6) NOT NULL default '0',
  `parent_id` smallint(6) NOT NULL default '0',
  `parent_setting_id` tinyint(1) NOT NULL default '0',
  `module_name` varchar(30) NOT NULL default '0',
  `menu_name` varchar(50) NOT NULL default '',
  `use_in_sub_menu` enum('NO','YES_DEFAULT','YES_NOT_DEFAULT') default NULL,
  `as_sub_menu` tinyint(1) NOT NULL default '0',
  `by_default` varchar(30) NOT NULL default '',
  `own_priv` tinyint(1) NOT NULL default '0',
  `check_priv` tinyint(1) NOT NULL default '1',
  `active` tinyint(1) NOT NULL default '1',
  `sort_order` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_priv_module`
-- 

INSERT INTO `s_priv_module` (`id`, `parent_id`, `parent_setting_id`, `module_name`, `menu_name`, `use_in_sub_menu`, `as_sub_menu`, `by_default`, `own_priv`, `check_priv`, `active`, `sort_order`) VALUES (0, 0, 0, 'all', '', 'NO', 0, '', 0, 1, 1, 0),
(1, 0, 0, 'user', 'Administrators', 'NO', 0, 'user', 0, 1, 1, 20),
(3, 0, 0, 'setting', 'Settings', 'NO', 0, 'kb_setting', 0, 1, 1, 21),
(5, 0, 0, 'member', 'Members', 'NO', 0, 'member', 0, 1, 1, 3),
(100, 0, 3, 'knowledgebase', 'KnowledgeBase', 'YES_DEFAULT', 0, 'kb_entry', 1, 1, 1, 1),
(2, 1, 0, 'privilege', 'Pivilege', 'NO', 1, '', 0, 1, 0, 1),
(101, 100, 0, 'kb_entry', 'Questions', 'NO', 0, '', 0, 1, 1, 1),
(102, 100, 0, 'kb_category', 'Categories', 'NO', 0, '', 0, 1, 1, 15),
(104, 100, 0, 'kb_comment', 'Comments', 'NO', 0, '', 0, 1, 1, 3),
(105, 100, 0, 'kb_glossary', 'Glossary', 'NO', 0, '', 0, 1, 1, 4),
(131, 3, 3, 'sys_setting', 'System', 'NO', 0, '', 0, 1, 0, 0),
(10, 1, 0, 'user', 'Administrators', 'NO', 0, '', 0, 1, 1, 0),
(8, 0, 0, 'feedback', 'Feedback', 'NO', 0, 'feedback', 0, 1, 1, 2),
(130, 3, 0, 'kb_setting', 'KnowledgeBase', 'NO', 0, '', 0, 1, 1, 1),
(108, 100, 0, 'kb_attachment', 'Attachments', 'NO', 0, '', 0, 1, 0, 20),
(200, 0, 3, 'file', 'Files', 'NO', 0, 'file_entry', 0, 1, 1, 2),
(202, 200, 0, 'file_category', 'Categories', 'NO', 0, '', 0, 1, 1, 2),
(109, 100, 0, 'kb_client', 'Client View', 'NO', 0, '', 0, 0, 1, 23),
(132, 3, 0, 'letter_template', 'Letter Template', 'NO', 0, '', 0, 1, 1, 12),
(133, 3, 0, 'file_setting', 'Files', 'NO', 0, '', 0, 1, 1, 5),
(50, 5, 0, 'member', 'Members', 'NO', 0, '', 0, 1, 1, 0),
(51, 5, 0, 'member_role', 'Roles', 'NO', 0, '', 0, 1, 1, 2),
(11, 1, 0, 'user_role', 'Roles', 'NO', 0, '', 0, 1, 0, 2),
(300, 0, 0, 'ticket', 'Tickets', 'NO', 0, '', 0, 1, 0, 0),
(201, 200, 0, 'file_entry', 'Files', 'NO', 0, '', 0, 1, 1, 1),
(134, 3, 0, 'email_setting', 'Email', 'NO', 0, '', 0, 1, 1, 11),
(6, 0, 0, 'sys', 'Sys', 'NO', 0, 'php_info', 0, 1, 0, 30),
(61, 6, 0, 'php_info', 'PHP info', 'NO', 0, 'php_info', 0, 1, 1, 1),
(62, 6, 0, 'db_info', 'DB info', 'NO', 0, 'db_info', 0, 1, 1, 2),
(9, 0, 0, 'account', 'My Account', 'NO', 0, 'account', 0, 0, 1, 100),
(135, 3, 0, 'cron', 'Sheduled Tasks', 'NO', 0, '', 0, 1, 0, 15),
(91, 9, 0, 'account', 'My Account', 'NO', 0, '', 0, 0, 1, 1),
(80, 8, 0, 'feedback', 'Feedback', 'NO', 0, '', 0, 1, 1, 0),
(203, 200, 0, 'file_bulk', 'Bulk', 'NO', 0, '', 0, 1, 1, 3);

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

-- 
-- Table structure for table `s_priv_name`
-- 

CREATE TABLE IF NOT EXISTS `s_priv_name` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `active` tinyint(1) NOT NULL default '1',
  `statusable` enum('yes','no') NOT NULL default 'yes',
  `info_editable` enum('yes','no') NOT NULL default 'yes',
  `priv_editable` enum('yes','no') NOT NULL default 'yes',
  `deleteable` enum('yes','no') NOT NULL default 'yes',
  `sort_order` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_priv_name`
-- 

INSERT INTO `s_priv_name` (`id`, `name`, `description`, `active`, `statusable`, `info_editable`, `priv_editable`, `deleteable`, `sort_order`) VALUES (1, 'Admin', 'User has all privileges.', 1, 'no', 'yes', 'yes', 'no', 1),
(2, 'KnowledgeBase Moderator', 'User has all privileges for knowledgebase.', 1, 'yes', 'yes', 'yes', 'yes', 2),
(3, 'KnowledgeBase Editor', 'User has privileges for Knowledgebase\r\n(Edit, Delete - Questions, Comments, Site Visitors questions)', 1, 'yes', 'yes', 'yes', 'yes', 3),
(4, 'Knowledgebase Author', '', 1, 'yes', 'yes', 'yes', 'yes', 4),
(5, 'Knowledgebase Author (not trusted)', '', 1, 'yes', 'yes', 'yes', 'yes', 5);

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

-- 
-- Table structure for table `s_priv_rule`
-- 

CREATE TABLE IF NOT EXISTS `s_priv_rule` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `priv_name_id` smallint(6) NOT NULL default '0',
  `priv_module_id` smallint(6) NOT NULL default '0',
  `what_priv` set('select','self_select','insert','update','self_update','status','self_status','delete','self_delete') NOT NULL default '',
  `apply_to_child` tinyint(1) unsigned NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `Table_priv` (`priv_module_id`),
  KEY `name_priv_id` (`priv_name_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_priv_rule`
-- 

INSERT INTO `s_priv_rule` (`id`, `priv_name_id`, `priv_module_id`, `what_priv`, `apply_to_child`, `active`) VALUES (1, 1, 0, 'select,insert,update,status,delete', 0, 1),
(2, 2, 100, 'select,insert,update,status,delete', 1, 1),
(3, 2, 1, 'select', 0, 1),
(4, 3, 1, 'select', 0, 1),
(5, 3, 101, 'select,insert,update,status,delete', 0, 1),
(6, 3, 104, 'select,insert,update,status,delete', 0, 1),
(7, 3, 107, 'select,insert,update,status,delete', 0, 1),
(11, 2, 200, 'select,insert,update,status,delete', 1, 1),
(9, 3, 108, 'select,insert,update,status,delete', 0, 1),
(10, 2, 5, 'select,insert,update,status,delete', 0, 1),
(12, 3, 5, 'select', 0, 1),
(13, 3, 201, 'select,insert,update,status,delete', 0, 1),
(14, 4, 1, 'select,self_update', 0, 0),
(15, 4, 101, 'self_select,insert,self_update,self_status,self_delete', 0, 1),
(16, 4, 201, 'self_select,insert,self_update,self_status,self_delete', 0, 1),
(17, 5, 1, 'self_select,self_update', 0, 0),
(18, 5, 101, 'self_select,insert,self_update,self_delete', 0, 1),
(19, 5, 201, 'self_select,insert,self_update,self_delete', 0, 1),
(20, 2, 8, 'select,insert,update,status,delete', 1, 1),
(21, 3, 8, 'select,insert,update,status,delete', 1, 1);

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

-- 
-- Table structure for table `s_role`
-- 

CREATE TABLE IF NOT EXISTS `s_role` (
  `id` tinyint(4) NOT NULL auto_increment,
  `role_key` varchar(10) NOT NULL default '',
  `title` varchar(50) NOT NULL default '',
  `description` text NOT NULL,
  `active` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_role`
-- 


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

-- 
-- Table structure for table `s_setting`
-- 

CREATE TABLE IF NOT EXISTS `s_setting` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `module_id` int(10) unsigned NOT NULL default '0',
  `group_id` tinyint(3) unsigned NOT NULL default '0',
  `input_id` tinyint(3) unsigned NOT NULL default '0',
  `options` varchar(100) NOT NULL default '',
  `setting_key` varchar(255) NOT NULL default '',
  `messure` varchar(10) NOT NULL default '',
  `range` varchar(255) NOT NULL default '',
  `default_value` varchar(255) NOT NULL default '',
  `sort_order` float NOT NULL default '0',
  `required` tinyint(1) NOT NULL default '0',
  `skip_default` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_setting`
-- 

INSERT INTO `s_setting` (`id`, `module_id`, `group_id`, `input_id`, `options`, `setting_key`, `messure`, `range`, `default_value`, `sort_order`, `required`, `skip_default`, `active`) VALUES (1, 100, 4, 1, '', 'allow_comments', '', '0,1,2', '1', 12, 0, 0, 1),
(2, 100, 4, 4, '', 'allow_rating', '', '', '1', 14, 0, 0, 1),
(3, 100, 4, 1, '', 'allow_post_entry', '', '0,1,2', '1', 11, 0, 0, 0),
(4, 100, 3, 1, '', 'num_most_viewed_entries', '', '0,3,5,10,15', '5', 8, 0, 0, 1),
(5, 100, 3, 1, '', 'num_recently_posted_entries', '', '0,3,5,10,15', '5', 7, 0, 0, 1),
(6, 100, 3, 1, '', 'num_entries_per_page', '', '10,15,20', '10', 6, 0, 0, 1),
(7, 100, 8, 1, 'onchange="populateSelect(myOptions[this.value]);"', 'view_format', '', 'default', 'default', 2, 0, 0, 1),
(8, 100, 6, 4, '', 'show_hits', '', '', '1', 2, 0, 0, 1),
(9, 100, 4, 1, '', 'comment_policy', '', '1,2,3', '1', 13, 0, 0, 1),
(10, 100, 1, 2, 'size="50"', 'site_title', '', '', 'Your Company / Knowledgebase', 2, 0, 1, 1),
(11, 100, 1, 2, 'size="50"', 'support_email', '', '', 'your@email.com', 10, 0, 1, 0),
(12, 100, 3, 4, '', 'show_glossary_link', '', '', '1', 16, 0, 0, 1),
(13, 100, 8, 2, 'size="50"', 'page_to_load', '', '', 'Default', 1, 0, 0, 1),
(14, 100, 3, 1, '', 'category_sort_order', '', 'name,sort_order', 'sort_order', 10, 0, 0, 1),
(15, 100, 6, 4, '', 'show_send_link', '', '', '1', 1, 0, 0, 1),
(16, 100, 3, 1, '', 'show_num_entries', '', '0,1', '1', 10.1, 0, 0, 1),
(17, 100, 3, 4, '', 'show_title_nav', '', '', '1', 19, 0, 0, 1),
(104, 100, 3, 1, '', 'entry_sort_order', '', 'name,sort_order,added_desc,added_asc,updated_desc,updated_asc,hits_desc,hits_asc', 'sort_order', 1, 0, 0, 1),
(19, 100, 1, 2, 'size="50"', 'nav_title', '', '', 'Knowledgebase', 4, 0, 0, 1),
(20, 200, 1, 2, 'size="50"', 'file_dir', '', '', '[document_root_parent]/kb_file/', 10, 0, 0, 1),
(21, 200, 1, 4, '', 'file_extract', '', '', '1', 15, 0, 0, 1),
(22, 200, 1, 2, 'size="50"', 'file_denied_extensions', '', 'php,php3,php5,phtml,asp,aspx,ascx,jsp,cfm,cfc,pl,bat,exe,dll,reg,cgi', 'php,php3,php5,phtml,asp,aspx,ascx,jsp,cfm,cfc,pl,bat,exe,dll,reg,cgi', 13, 0, 0, 1),
(23, 200, 1, 2, '', 'file_max_filesize', '', '', '2048', 11, 0, 0, 1),
(24, 200, 1, 1, '', 'file_store', '', 'dir,db', 'dir', 0, 0, 0, 0),
(25, 200, 1, 2, 'size="50"', 'file_allowed_extensions', '', '', '', 12, 0, 0, 1),
(26, 200, 1, 1, '', 'file_rename_policy', '', 'date_Ymd-His,date_Ymd,date_Y,suffics_3', 'date_Ymd-His', 10, 0, 0, 0),
(27, 200, 3, 1, '', 'num_most_viewed_entries', '', '0,3,5,10,15', '5', 3, 0, 0, 1),
(28, 200, 3, 1, '', 'num_recently_posted_entries', '', '0,3,5,10,15', '5', 2, 0, 0, 1),
(29, 200, 3, 1, '', 'num_entries_per_page', '', '10,15,20', '10', 1, 0, 0, 1),
(30, 200, 3, 1, '', 'category_sort_order', '', 'name,sort_order', 'sort_order', 4, 0, 0, 1),
(31, 200, 3, 1, '', 'show_num_entries', '', '0,1', '1', 5, 0, 0, 1),
(34, 100, 3, 4, '', 'show_file_link', '', '', '1', 18, 0, 0, 1),
(33, 100, 2, 4, '', 'kb_register_access', '', '', '0', 3.1, 0, 0, 1),
(35, 100, 2, 1, '', 'private_policy', '', '1,2', '2', 3.7, 0, 0, 1),
(36, 200, 2, 1, '', 'private_policy', '', '1,2', '2', 0, 0, 0, 1),
(49, 134, 2, 2, 'size="50"', 'smtp_port', '', '', '25', 7, 0, 0, 1),
(38, 100, 2, 4, '', 'register_policy', '', '', '1', 3.2, 0, 0, 1),
(39, 100, 2, 2, 'size="10"', 'auth_expired', '', '', '60', 3.6, 0, 0, 1),
(40, 134, 2, 1, '', 'mailer', '', 'mail,smtp,sendmail', 'mail', 3, 1, 0, 1),
(41, 134, 1, 2, 'size="50"', 'from_email', '', '', '', 2, 1, 1, 1),
(42, 134, 1, 2, 'size="50"', 'from_name', '', '', 'Support Team', 3, 0, 0, 1),
(43, 134, 2, 2, 'size="50"', 'sendmail_path', '', '', '/usr/sbin/sendmail', 4, 0, 0, 1),
(44, 134, 2, 4, '', 'smtp_auth', '', '', '0', 5, 0, 0, 1),
(45, 134, 2, 2, 'size="50"', 'smtp_user', '', '', '', 8, 0, 0, 1),
(46, 134, 2, 2, 'size="50"', 'smtp_pass', '', '', '', 9, 0, 0, 1),
(47, 134, 2, 2, 'size="50"', 'smtp_host', '', '', '', 6, 0, 0, 1),
(50, 100, 5, 2, 'size="10"', 'preview_article_limit', '', '', '150', 1, 0, 0, 1),
(51, 100, 5, 4, '', 'preview_show_comments', '', '', '1', 4, 0, 0, 1),
(52, 100, 5, 4, '', 'preview_show_rating', '', '', '0', 3, 0, 0, 1),
(53, 100, 5, 4, '', 'preview_show_hits', '', '', '0', 5, 0, 0, 1),
(54, 100, 5, 4, '', 'preview_show_date', '', '', '1', 2, 0, 0, 1),
(55, 100, 6, 4, '', 'show_author', '', '', '1', 3, 0, 0, 1),
(56, 134, 1, 2, 'size="50"', 'from_mailer', '', '', 'KB Mailer', 1, 0, 0, 1),
(57, 100, 2, 4, '', 'register_confirmation', '', '', '1', 3.3, 0, 0, 0),
(58, 100, 3, 1, '', 'num_entries_category', '', '0,3,5,10,15,20,all', 'all', 8.1, 0, 0, 1),
(59, 100, 7, 2, 'size="50"', 'rss_title', '', '', 'Knowledgebase RSS', 2, 0, 1, 1),
(60, 100, 7, 3, 'rows="2" style="width: 100%"', 'rss_description', '', '', '', 3, 0, 1, 1),
(61, 100, 7, 1, '', 'rss_generate', '', 'none,one,top', 'one', 1, 0, 0, 1),
(62, 100, 1, 3, 'rows="2" style="width: 100%"', 'site_keywords', '', '', '', 5, 0, 1, 0),
(63, 100, 1, 3, 'rows="2" style="width: 100%"', 'site_description', '', '', '', 6, 0, 1, 0),
(64, 100, 3, 1, '', 'num_category_cols', '', '0,1,2,3,4,5', '3', 10.2, 0, 0, 1),
(65, 200, 3, 2, 'size="10"', 'num_category_cols', '', '', '3', 6, 0, 0, 1),
(66, 100, 2, 4, '', 'register_approval', '', '', '0', 3.5, 0, 0, 0),
(101, 100, 1, 2, 'size="50"', 'header_title', '', '', 'Knowledgebase', 3, 0, 1, 1),
(102, 100, 4, 1, '', 'allow_contact', '', '0,1,2', '1', 11.1, 0, 0, 1),
(103, 100, 8, 1, '', 'view_template', '', '1', 'default', 3, 0, 0, 1);

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

-- 
-- Table structure for table `s_setting_input`
-- 

CREATE TABLE IF NOT EXISTS `s_setting_input` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `input` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_setting_input`
-- 

INSERT INTO `s_setting_input` (`id`, `input`) VALUES (1, 'select'),
(2, 'text'),
(3, 'textarea'),
(4, 'checkbox'),
(5, 'password');

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

-- 
-- Table structure for table `s_setting_to_value`
-- 

CREATE TABLE IF NOT EXISTS `s_setting_to_value` (
  `setting_id` int(10) unsigned NOT NULL default '0',
  `setting_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`setting_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_setting_to_value`
-- 


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

-- 
-- Table structure for table `s_user`
-- 

CREATE TABLE IF NOT EXISTS `s_user` (
  `id` smallint(6) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `first_name` varchar(50) NOT NULL default '',
  `middle_name` varchar(50) NOT NULL default '',
  `last_name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `phone` varchar(20) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  `editable` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`username`),
  KEY `pass` (`password`(2))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `s_user`
-- 

INSERT INTO `s_user` (`id`, `username`, `password`, `first_name`, `middle_name`, `last_name`, `email`, `phone`, `active`, `editable`) VALUES (1, 'admin', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Admin', '', 'Admin', 'eleontev@gmail.com', '', 1, 1),
(2, 'moderator', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Moderator', '', 'Moderator', 'moderator@site.com', '111-111 ahsdajshkdah', 1, 1),
(3, 'editor', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Editor', '', 'Editor', 'editor@site.com', '', 1, 1),
(4, 'author1', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Author1', '', 'Author1', 'author1@site.com', '', 1, 1),
(5, 'author2', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Author2', '', 'Author2', 'author2@site.com', '', 1, 1);