[TOC] ## 插入或創建·數據表·文件代碼（完整版） ~~~ INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'title', '標題', '', 'text', 'a:2:{s:12:\"defaultvalue\";s:0:\"\";s:10:\"ispassword\";s:1:\"0\";}', '1', '2'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'keywords', '關鍵詞', '', 'text', 'a:2:{s:12:\"defaultvalue\";s:0:\"\";s:10:\"ispassword\";s:1:\"0\";}', '1', '3'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'tags', 'TAGS', '', 'text', 'a:2:{s:12:\"defaultvalue\";s:0:\"\";s:10:\"ispassword\";s:1:\"0\";}', '1', '4'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'description', '摘要', '', 'textarea', 'a:2:{s:6:\"height\";s:3:\"100\";s:12:\"defaultvalue\";s:0:\"\";}', '1', '5'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'thumb', '縮略圖', '', 'image', 'a:1:{s:8:\"allowext\";s:15:\"gif|jpg|png|bmp\";}', '1', '6'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'username', '用戶名', '', 'text', 'a:2:{s:12:\"defaultvalue\";s:0:\"\";s:10:\"ispassword\";s:1:\"0\";}', '1', '7'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'inputtime', '發布時間', '', 'datetime', 'a:1:{s:9:\"fieldtype\";s:8:\"datetime\";}', '1', '8'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'url', 'URL', '', 'text', 'a:2:{s:12:\"defaultvalue\";s:0:\"\";s:10:\"ispassword\";s:1:\"0\";}', '1', '9'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'status', '狀態', '', 'box', 'a:4:{s:7:\"options\";s:27:\"審核通過|1\r\n待審核|0\";s:7:\"boxtype\";s:5:\"radio\";s:9:\"fieldtype\";s:3:\"int\";s:12:\"defaultvalue\";s:1:\"1\";}', '1', '10'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'views', '瀏覽量', '', 'number', 'a:1:{s:12:\"defaultvalue\";s:1:\"0\";}', '1', '11'); -- INSERT INTO `@cmsprefix@models_field` VALUES (null, '@modelid@', 'order', '排序', '', 'number', 'a:1:{s:12:\"defaultvalue\";s:1:\"0\";}', '1', '12'); -- DROP TABLE IF EXISTS `@cmsprefix@@cmstablename@`; -- CREATE TABLE `@cmsprefix@@cmstablename@` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主鍵', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '標題', `keywords` varchar(100) NOT NULL DEFAULT '' COMMENT '關鍵詞', `tags` varchar(255) NOT NULL DEFAULT '' COMMENT 'TAGS', `description` varchar(255) NOT NULL DEFAULT '' COMMENT '摘要', `thumb` varchar(100) NOT NULL DEFAULT '' COMMENT '縮略圖', `username` varchar(20) NOT NULL DEFAULT '' COMMENT '用戶名', `inputtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '發布時間', `url` varchar(100) NOT NULL DEFAULT '' COMMENT 'URL', `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '狀態', `views` int(11) NOT NULL DEFAULT '0' COMMENT '瀏覽量', `order` int(11) NOT NULL DEFAULT '0' COMMENT '排序', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ~~~