参考开源互动百科,做个基于ThinkPHP的wiki系统。
时间:2010-07-18 来源:melec
主表
DROP TABLE IF EXISTS `ts_wiki`; CREATE TABLE `ts_wiki` ( `id` int(11) NOT NULL AUTO_INCREMENT, `infotype` tinyint(1) unsigned DEFAULT '4', `letter` char(1) NOT NULL, `title` varchar(255) NOT NULL, `tag` varchar(255) DEFAULT NULL, `summary` text NOT NULL, `content` longtext NOT NULL, `author` varchar(255) NOT NULL, `authorId` int(11) NOT NULL, `createTime` int(11) NOT NULL, `lastEditTime` int(11) NOT NULL, `lastEditor` varchar(255) NOT NULL, `lastEditorId` int(11) NOT NULL, `words` int(11) DEFAULT NULL, `views` int(10) NOT NULL DEFAULT '0', `edits` int(10) NOT NULL DEFAULT '0', `commentCount` int(10) NOT NULL DEFAULT '0', `votes` int(10) NOT NULL DEFAULT '0', `visible` tinyint(1) NOT NULL DEFAULT '1', `locked` tinyint(1) NOT NULL DEFAULT '0', `recycleId` int(11) NOT NULL DEFAULT '0', `activeHistoryId` int(11) NOT NULL DEFAULT '0', `judge` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
相关阅读 更多 +