[Summary view] [Print] [Text view]

   1  -- 
   2  -- Database: `a_knowledgebase_1_2`
   3  -- 
   4  
   5  -- --------------------------------------------------------
   6  
   7  -- 
   8  -- Table structure for table `s_kb_entry`
   9  -- 
  10  
  11  CREATE TABLE `s_kb_entry` (
  12    `id` int(10) unsigned NOT NULL auto_increment,
  13    `author_id` int(10) unsigned NOT NULL default '0',
  14    `updater_id` int(10) unsigned NOT NULL default '0',
  15    `title` text NOT NULL,
  16    `body` text NOT NULL,
  17    `date_updated` timestamp NOT NULL,
  18    `date_posted` date NOT NULL default '0000-00-00',
  19    `hits` int(10) unsigned NOT NULL default '0',
  20    `active` tinyint(1) NOT NULL default '1',
  21    PRIMARY KEY  (`id`),
  22    KEY `updater_id` (`updater_id`),
  23    KEY `author_id` (`author_id`),
  24    FULLTEXT KEY `title` (`title`,`body`)
  25  ) TYPE=MyISAM ;
  26  
  27      
  28  
  29  -- --------------------------------------------------------
  30  
  31  -- 
  32  -- Table structure for table `s_kb_attachment_to_entry`
  33  -- 
  34  
  35  CREATE TABLE `s_kb_attachment_to_entry` (
  36    `entry_id` int(10) unsigned NOT NULL default '0',
  37    `attachment_id` int(10) unsigned NOT NULL default '0',
  38    PRIMARY KEY  (`entry_id`,`attachment_id`)
  39  ) TYPE=MyISAM;
  40  
  41  -- 
  42  -- Dumping data for table `s_kb_attachment_to_entry`
  43  -- 
  44  
  45  
  46  -- --------------------------------------------------------
  47  
  48  -- 
  49  -- Table structure for table `s_kb_category`
  50  -- 
  51  
  52  CREATE TABLE `s_kb_category` (
  53    `id` int(10) unsigned NOT NULL auto_increment,
  54    `parent_id` int(10) unsigned NOT NULL default '0',
  55    `name` varchar(100) NOT NULL default '',
  56    `description` text NOT NULL,
  57    `sort_order` tinyint(3) unsigned NOT NULL default '0',
  58    `commentable` tinyint(1) NOT NULL default '1',
  59    `ratingable` tinyint(1) NOT NULL default '1',
  60    `private` tinyint(1) NOT NULL default '0',
  61    `active` tinyint(1) NOT NULL default '1',
  62    PRIMARY KEY  (`id`),
  63    KEY `parent_id` (`parent_id`)
  64  ) TYPE=MyISAM ;
  65  
  66  
  67  -- --------------------------------------------------------
  68  
  69  -- 
  70  -- Table structure for table `s_kb_comment`
  71  -- 
  72  
  73  CREATE TABLE `s_kb_comment` (
  74    `id` int(10) unsigned NOT NULL auto_increment,
  75    `entry_id` int(10) unsigned NOT NULL default '0',
  76    `user_id` int(10) unsigned default NULL,
  77    `name` varchar(50) NOT NULL default '',
  78    `email` varchar(50) NOT NULL default '',
  79    `comment` text NOT NULL,
  80    `date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
  81    `active` tinyint(1) NOT NULL default '1',
  82    PRIMARY KEY  (`id`),
  83    KEY `entry_id` (`entry_id`),
  84    KEY `NewIndex` (`user_id`)
  85  ) TYPE=MyISAM ;
  86  
  87  
  88  
  89  -- 
  90  -- Table structure for table `s_kb_entry_to_category`
  91  -- 
  92  
  93  CREATE TABLE `s_kb_entry_to_category` (
  94    `entry_id` int(10) unsigned NOT NULL default '0',
  95    `category_id` int(10) unsigned NOT NULL default '0',
  96    PRIMARY KEY  (`entry_id`,`category_id`)
  97  ) TYPE=MyISAM;
  98  
  99  
 100  -- 
 101  -- Table structure for table `s_kb_glossary`
 102  -- 
 103  
 104  CREATE TABLE `s_kb_glossary` (
 105    `id` int(10) unsigned NOT NULL auto_increment,
 106    `phrase` varchar(100) NOT NULL default '',
 107    `definition` text NOT NULL,
 108    `display_once` tinyint(1) NOT NULL default '0',
 109    PRIMARY KEY  (`id`)
 110  ) TYPE=MyISAM ;
 111  
 112  
 113  
 114  -- 
 115  -- Table structure for table `s_kb_rating`
 116  -- 
 117  
 118  CREATE TABLE `s_kb_rating` (
 119    `entry_id` int(10) unsigned NOT NULL default '0',
 120    `votes` int(10) unsigned NOT NULL default '0',
 121    `rate` bigint(20) unsigned NOT NULL default '0',
 122    PRIMARY KEY  (`entry_id`)
 123  ) TYPE=MyISAM;
 124  
 125  
 126  -- 
 127  -- Table structure for table `s_member`
 128  -- 
 129  
 130  CREATE TABLE `s_member` (
 131    `id` smallint(6) NOT NULL auto_increment,
 132    `username` varchar(16) NOT NULL default '',
 133    `password` varchar(32) NOT NULL default '',
 134    `first_name` varchar(50) NOT NULL default '',
 135    `middle_name` varchar(50) NOT NULL default '',
 136    `last_name` varchar(100) NOT NULL default '',
 137    `email` varchar(100) NOT NULL default '',
 138    `phone` varchar(20) NOT NULL default '',
 139    `date_registered` date NOT NULL default '0000-00-00',
 140    `active` tinyint(1) NOT NULL default '1',
 141    PRIMARY KEY  (`id`),
 142    UNIQUE KEY `login` (`username`),
 143    KEY `pass` (`password`(2))
 144  ) TYPE=MyISAM ;
 145  
 146  
 147  -- 
 148  -- Table structure for table `s_priv`
 149  -- 
 150  
 151  CREATE TABLE `s_priv` (
 152    `id` int(10) unsigned NOT NULL auto_increment,
 153    `user_id` int(10) unsigned NOT NULL default '0',
 154    `priv_name_id` smallint(6) NOT NULL default '0',
 155    `grantor` int(11) NOT NULL default '0',
 156    `timestamp` timestamp NOT NULL,
 157    PRIMARY KEY  (`id`),
 158    KEY `user` (`user_id`),
 159    KEY `name_priv_id` (`priv_name_id`)
 160  ) TYPE=MyISAM AUTO_INCREMENT=87 ;
 161  
 162  -- 
 163  -- Dumping data for table `s_priv`
 164  -- 
 165  
 166  INSERT INTO `s_priv` VALUES (2, 2, 2, 0, '2005-10-12 00:02:00');
 167  INSERT INTO `s_priv` VALUES (1, 1, 1, 0, '2005-11-13 13:01:00');
 168  INSERT INTO `s_priv` VALUES (3, 3, 3, 0, '2006-02-13 21:52:08');
 169  
 170  -- --------------------------------------------------------
 171  
 172  -- 
 173  -- Table structure for table `s_priv_module`
 174  -- 
 175  
 176  CREATE TABLE `s_priv_module` (
 177    `id` smallint(6) NOT NULL default '0',
 178    `parent_id` smallint(6) NOT NULL default '0',
 179    `parent_setting_id` tinyint(1) NOT NULL default '0',
 180    `module_name` varchar(30) NOT NULL default '0',
 181    `menu_name` varchar(50) NOT NULL default '',
 182    `use_in_sub_menu` enum('NO','YES_DEFAULT','YES_NOT_DEFAULT') default NULL,
 183    `as_sub_menu` tinyint(1) NOT NULL default '0',
 184    `by_default` varchar(30) NOT NULL default '',
 185    `own_priv` tinyint(1) NOT NULL default '0',
 186    `check_priv` tinyint(1) NOT NULL default '0',
 187    `active` tinyint(1) NOT NULL default '0',
 188    `sort_order` smallint(5) unsigned NOT NULL default '0',
 189    PRIMARY KEY  (`id`)
 190  ) TYPE=MyISAM;
 191  
 192  -- 
 193  -- Dumping data for table `s_priv_module`
 194  -- 
 195  
 196  INSERT INTO `s_priv_module` VALUES (0, 0, 0, 'all', '', 'NO', 0, '', 0, 1, 1, 0);
 197  INSERT INTO `s_priv_module` VALUES (1, 0, 0, 'user', 'Administrators', 'NO', 0, 'user', 0, 1, 1, 20);
 198  INSERT INTO `s_priv_module` VALUES (3, 0, 0, 'setting', 'Settings', 'NO', 0, 'kb_setting', 0, 1, 1, 21);
 199  INSERT INTO `s_priv_module` VALUES (5, 0, 0, 'member', 'Members', 'YES_DEFAULT', 0, '', 0, 1, 1, 2);
 200  INSERT INTO `s_priv_module` VALUES (100, 0, 3, 'knowledgebase', 'KnowledgeBase', 'YES_DEFAULT', 0, '', 1, 1, 1, 1);
 201  INSERT INTO `s_priv_module` VALUES (2, 1, 0, 'privilege', 'Pivilege', 'NO', 1, '', 0, 1, 0, 1);
 202  INSERT INTO `s_priv_module` VALUES (101, 100, 0, 'kb_entry', 'Questions', 'NO', 0, '', 0, 1, 1, 1);
 203  INSERT INTO `s_priv_module` VALUES (102, 100, 0, 'kb_category', 'Categories', 'NO', 0, '', 0, 1, 1, 15);
 204  INSERT INTO `s_priv_module` VALUES (104, 100, 0, 'kb_comment', 'Comments', 'NO', 0, '', 0, 1, 1, 3);
 205  INSERT INTO `s_priv_module` VALUES (105, 100, 0, 'kb_glossary', 'Glossary', 'NO', 0, '', 0, 1, 1, 4);
 206  INSERT INTO `s_priv_module` VALUES (30, 3, 3, 'sys_setting', 'System', 'NO', 0, '', 0, 1, 0, 0);
 207  INSERT INTO `s_priv_module` VALUES (4, 1, 0, 'user', 'Administrators', 'NO', 0, '', 0, 1, 1, 0);
 208  INSERT INTO `s_priv_module` VALUES (107, 100, 0, 'kb_user_entry', 'User Questions', 'NO', 0, '', 0, 1, 0, 11);
 209  INSERT INTO `s_priv_module` VALUES (130, 3, 0, 'kb_setting', 'KnowledgeBase', 'NO', 0, '', 0, 1, 1, 0);
 210  
 211  -- --------------------------------------------------------
 212  
 213  -- 
 214  -- Table structure for table `s_priv_name`
 215  -- 
 216  
 217  CREATE TABLE `s_priv_name` (
 218    `id` smallint(5) unsigned NOT NULL auto_increment,
 219    `name` varchar(100) NOT NULL default '',
 220    `description` text NOT NULL,
 221    `active` tinyint(1) NOT NULL default '1',
 222    `statusable` enum('yes','no') NOT NULL default 'yes',
 223    `info_editable` enum('yes','no') NOT NULL default 'yes',
 224    `priv_editable` enum('yes','no') NOT NULL default 'yes',
 225    `deleteable` enum('yes','no') NOT NULL default 'yes',
 226    `sort_order` smallint(5) unsigned NOT NULL default '0',
 227    PRIMARY KEY  (`id`)
 228  ) TYPE=MyISAM AUTO_INCREMENT=4 ;
 229  
 230  -- 
 231  -- Dumping data for table `s_priv_name`
 232  -- 
 233  
 234  INSERT INTO `s_priv_name` VALUES (1, 'Admin', 'User has all privileges.', 1, 'no', 'yes', 'yes', 'no', 1);
 235  INSERT INTO `s_priv_name` VALUES (2, 'KnowledgeBase Moderator', 'User has all privileges for knowledgebase.', 1, 'yes', 'yes', 'yes', 'yes', 2);
 236  INSERT INTO `s_priv_name` VALUES (3, 'KnowledgeBase Editor', 'User has privileges for Knowledgebase\r\n(Edit, Delete - Questions, Comments, Site Visitors questions)', 1, 'yes', 'yes', 'yes', 'yes', 3);
 237  
 238  -- --------------------------------------------------------
 239  
 240  -- 
 241  -- Table structure for table `s_priv_rule`
 242  -- 
 243  
 244  CREATE TABLE `s_priv_rule` (
 245    `id` int(10) unsigned NOT NULL auto_increment,
 246    `priv_name_id` smallint(6) NOT NULL default '0',
 247    `priv_module_id` smallint(6) NOT NULL default '0',
 248    `what_priv` set('select','self_select','insert','update','self_update','status','self_status','delete','self_delete') NOT NULL default '',
 249    `apply_to_child` tinyint(1) unsigned NOT NULL default '0',
 250    PRIMARY KEY  (`id`),
 251    KEY `Table_priv` (`priv_module_id`),
 252    KEY `name_priv_id` (`priv_name_id`)
 253  ) TYPE=MyISAM AUTO_INCREMENT=11 ;
 254  
 255  -- 
 256  -- Dumping data for table `s_priv_rule`
 257  -- 
 258  
 259  INSERT INTO `s_priv_rule` VALUES (1, 1, 0, 'select,insert,update,status,delete', 0);
 260  INSERT INTO `s_priv_rule` VALUES (2, 2, 100, 'select,insert,update,status,delete', 1);
 261  INSERT INTO `s_priv_rule` VALUES (3, 2, 4, 'self_select,self_update', 0);
 262  INSERT INTO `s_priv_rule` VALUES (4, 3, 4, 'self_select,self_update', 0);
 263  INSERT INTO `s_priv_rule` VALUES (5, 3, 101, 'select,insert,update,status,delete', 0);
 264  INSERT INTO `s_priv_rule` VALUES (6, 3, 104, 'select,insert,update,status,delete', 0);
 265  INSERT INTO `s_priv_rule` VALUES (7, 3, 107, 'select,insert,update,status,delete', 0);
 266  INSERT INTO `s_priv_rule` VALUES (8, 2, 130, 'select,update', 0);
 267  INSERT INTO `s_priv_rule` VALUES (9, 3, 108, 'select,insert,update,status,delete', 0);
 268  INSERT INTO `s_priv_rule` VALUES (10, 2, 5, 'select,insert,update,status,delete', 0);
 269  
 270  
 271  -- --------------------------------------------------------
 272  
 273  -- 
 274  -- Table structure for table `s_setting`
 275  -- 
 276  
 277  DROP TABLE IF EXISTS `s_setting`;
 278  CREATE TABLE `s_setting` (
 279    `id` int(10) unsigned NOT NULL auto_increment,
 280    `module_id` int(10) unsigned NOT NULL default '0',
 281    `input_id` int(10) unsigned NOT NULL default '0',
 282    `options` varchar(100) NOT NULL default '',
 283    `setting_key` varchar(255) NOT NULL default '',
 284    `messure` varchar(10) NOT NULL default '',
 285    `range` varchar(255) NOT NULL default '',
 286    `default_value` varchar(255) NOT NULL default '',
 287    `sort_order` float NOT NULL default '0',
 288    `active` tinyint(1) NOT NULL default '1',
 289    PRIMARY KEY  (`id`)
 290  ) TYPE=MyISAM AUTO_INCREMENT=20 ;
 291  
 292  -- 
 293  -- Dumping data for table `s_setting`
 294  -- 
 295  
 296  INSERT INTO `s_setting` VALUES (1, 100, 1, '', 'allow_comments', '', '0,1,2', '1', 12, 1);
 297  INSERT INTO `s_setting` VALUES (2, 100, 4, '', 'allow_rating', '', '', '1', 14, 1);
 298  INSERT INTO `s_setting` VALUES (3, 100, 1, '', 'allow_post_entry', '', '0,1,2', '0', 11, 0);
 299  INSERT INTO `s_setting` VALUES (4, 100, 1, '', 'num_most_viewed_entries', '', '5,10,15', '5', 8, 1);
 300  INSERT INTO `s_setting` VALUES (5, 100, 1, '', 'num_recently_posted_entries', '', '5,10,15', '5', 7, 1);
 301  INSERT INTO `s_setting` VALUES (6, 100, 1, '', 'num_entries_per_page', '', '10,15,20', '10', 6, 1);
 302  INSERT INTO `s_setting` VALUES (7, 100, 1, '', 'view_format', '', 'default, faq_1', 'default', 4, 1);
 303  INSERT INTO `s_setting` VALUES (8, 100, 4, '', 'show_hits', '', '', '1', 15, 1);
 304  INSERT INTO `s_setting` VALUES (9, 100, 4, '', 'comment_status', '', '', '1', 13, 1);
 305  INSERT INTO `s_setting` VALUES (10, 100, 2, 'size="50"', 'site_title', '', '', 'Your Company / Knowledgebase', 1, 1);
 306  INSERT INTO `s_setting` VALUES (11, 100, 2, 'size="50"', 'support_email', '', '', 'your@email.com', 2, 1);
 307  INSERT INTO `s_setting` VALUES (12, 100, 4, '', 'show_glossary_link', '', '', '1', 16, 1);
 308  INSERT INTO `s_setting` VALUES (13, 100, 2, 'size="50"', 'page_to_load', '', '', 'Default', 3, 1);
 309  INSERT INTO `s_setting` VALUES (14, 100, 1, '', 'category_sort_order', '', 'name,sort_order', 'sort_order', 10, 1);
 310  INSERT INTO `s_setting` VALUES (15, 100, 4, '', 'show_send_link', '', '', '1', 17, 1);
 311  INSERT INTO `s_setting` VALUES (16, 100, 1, '', 'show_num_entries', '', '0,1,2', '1', 19, 1);
 312  INSERT INTO `s_setting` VALUES (17, 100, 4, '', 'show_title_nav', '', '', '1', 18, 1);
 313  INSERT INTO `s_setting` VALUES (18, 100, 1, '', 'home_page_format', '', '1,2,3,4', '1', 5, 1);
 314  INSERT INTO `s_setting` VALUES (19, 100, 2, 'size="50"', 'nav_title', '', '', 'Knowledgebase', 1.2, 1);
 315  
 316  -- --------------------------------------------------------
 317  
 318  -- 
 319  -- Table structure for table `s_setting_input`
 320  -- 
 321  
 322  CREATE TABLE `s_setting_input` (
 323    `id` int(10) unsigned NOT NULL auto_increment,
 324    `input` varchar(20) NOT NULL default '',
 325    PRIMARY KEY  (`id`)
 326  ) TYPE=MyISAM AUTO_INCREMENT=6 ;
 327  
 328  -- 
 329  -- Dumping data for table `s_setting_input`
 330  -- 
 331  
 332  INSERT INTO `s_setting_input` VALUES (1, 'select');
 333  INSERT INTO `s_setting_input` VALUES (2, 'text');
 334  INSERT INTO `s_setting_input` VALUES (3, 'textarea');
 335  INSERT INTO `s_setting_input` VALUES (4, 'checkbox');
 336  INSERT INTO `s_setting_input` VALUES (5, 'password');
 337  
 338  -- --------------------------------------------------------
 339  
 340  -- 
 341  -- Table structure for table `s_setting_to_value`
 342  -- 
 343  
 344  CREATE TABLE `s_setting_to_value` (
 345    `setting_id` int(10) unsigned NOT NULL default '0',
 346    `setting_value` varchar(255) NOT NULL default '',
 347    PRIMARY KEY  (`setting_id`)
 348  ) TYPE=MyISAM;
 349  
 350  
 351  
 352  -- 
 353  -- Table structure for table `s_user`
 354  -- 
 355  
 356  CREATE TABLE `s_user` (
 357    `id` smallint(6) NOT NULL auto_increment,
 358    `username` varchar(16) NOT NULL default '',
 359    `password` varchar(32) NOT NULL default '',
 360    `first_name` varchar(50) NOT NULL default '',
 361    `middle_name` varchar(50) NOT NULL default '',
 362    `last_name` varchar(100) NOT NULL default '',
 363    `email` varchar(100) NOT NULL default '',
 364    `phone` varchar(20) NOT NULL default '',
 365    `active` tinyint(1) NOT NULL default '0',
 366    `editable` tinyint(1) NOT NULL default '0',
 367    PRIMARY KEY  (`id`),
 368    UNIQUE KEY `login` (`username`),
 369    KEY `pass` (`password`(2))
 370  ) TYPE=MyISAM AUTO_INCREMENT=5 ;
 371  
 372  -- 
 373  -- Dumping data for table `s_user`
 374  -- 
 375  
 376  INSERT INTO `s_user` VALUES (1, 'admin', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Admin', '', 'Admin', 'admin@site.com', '', 1, 1);
 377  INSERT INTO `s_user` VALUES (2, 'moderator', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Moderator', '', 'Moderator', 'moderator@site.com', '111-111', 1, 1);
 378  INSERT INTO `s_user` VALUES (3, 'editor', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Editor', '', 'Editor', 'editor@site.com', '', 1, 1);