Пробую написать плагин вопросов. Делаю по аналогии с топиками. В БД создаю две таблицы для вопросов:
CREATE TABLE IF NOT EXISTS `prefix_question` (
`question_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`question_title` varchar(200) NOT NULL,
`question_tags` varchar(250) NOT NULL COMMENT 'tags separated by a comma',
`question_date_add` datetime NOT NULL,
`question_date_edit` datetime DEFAULT NULL,
`question_user_ip` varchar(20) NOT NULL,
`question_publish_index` tinyint(1) NOT NULL DEFAULT '0',
`question_count_read` int(11) unsigned NOT NULL DEFAULT '0',
`question_cut_text` varchar(100) DEFAULT NULL,
`question_text_hash` varchar(32) NOT NULL,
PRIMARY KEY (`question_id`),
KEY `user_id` (`user_id`),
KEY `question_date_add` (`question_date_add`),
KEY `question_text_hash` (`question_text_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `prefix_question_content` (
`question_id` int(11) unsigned NOT NULL,
`question_text` longtext NOT NULL,
`question_text_short` text NOT NULL,
`question_text_source` longtext NOT NULL,
`question_extra` text NOT NULL,
PRIMARY KEY (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Читать дальше →