線上書籍

Home

[1032]PHP入門

CREATE TABLE `eznews` ( `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cate_sn` smallint(5) unsigned NOT NULL, `news_title` varchar(255) NOT NULL, `news_content` longtext NOT NULL, `ip` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, `post_time` datetime NOT NULL, `status` varchar(255) NOT NULL, `counter` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `eznews_cate` ( `cate_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cate_title` varchar(255) NOT NULL, PRIMARY KEY (`cate_sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `eznews_files` ( `file_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `sn` smallint(5) unsigned NOT NULL, `file_name` varchar(255) NOT NULL, `file_size` int(11) NOT NULL, `file_type` varchar(255) NOT NULL, `file_new_name` varchar(255) NOT NULL, PRIMARY KEY (`file_sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;