-- --------------------------------------------------------
|
-- tables for the FAQ module
|
|
CREATE TABLE `help_faq_sections` (
|
`hfs_id` int(11) NOT NULL AUTO_INCREMENT,
|
`hfs_name` varchar(255) DEFAULT NULL,
|
`hfs_order` int(11) DEFAULT '0',
|
`sys_userid` int(11) DEFAULT NULL,
|
`sys_groupid` int(11) DEFAULT NULL,
|
`sys_perm_user` varchar(5) DEFAULT NULL,
|
`sys_perm_group` varchar(5) DEFAULT NULL,
|
`sys_perm_other` varchar(5) DEFAULT NULL,
|
PRIMARY KEY (`hfs_id`)
|
) ENGINE=MyISAM AUTO_INCREMENT=1;
|
|
INSERT INTO `help_faq_sections` VALUES (1,'General',0,NULL,NULL,NULL,NULL,NULL);
|
|
CREATE TABLE `help_faq` (
|
`hf_id` int(11) NOT NULL AUTO_INCREMENT,
|
`hf_section` int(11) DEFAULT NULL,
|
`hf_order` int(11) DEFAULT '0',
|
`hf_question` text,
|
`hf_answer` text,
|
`sys_userid` int(11) DEFAULT NULL,
|
`sys_groupid` int(11) DEFAULT NULL,
|
`sys_perm_user` varchar(5) DEFAULT NULL,
|
`sys_perm_group` varchar(5) DEFAULT NULL,
|
`sys_perm_other` varchar(5) DEFAULT NULL,
|
PRIMARY KEY (`hf_id`)
|
) ENGINE=MyISAM AUTO_INCREMENT=1;
|
|
INSERT INTO `help_faq` VALUES (1,1,0,'I\'d like to know ...','Yes, of course.',1,1,'riud','riud','r');
|
