CREATE TABLE `ugm_files` ( `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '檔案流水號', `col_name` varchar(255) NOT NULL DEFAULT '' COMMENT '欄位名稱', `col_sn` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '欄位編號', `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `kind` enum('img','file') NOT NULL DEFAULT 'img' COMMENT '檔案種類', `file_name` varchar(255) NOT NULL DEFAULT '' COMMENT '檔案名稱', `file_type` varchar(255) NOT NULL DEFAULT '' COMMENT '檔案類型', `file_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '檔案大小', `description` text NOT NULL COMMENT '檔案說明', `counter` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '下載人次', `sub_dir` varchar(255) NOT NULL DEFAULT '' COMMENT '檔案子路徑', PRIMARY KEY (`sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ```