[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,
`uid` smallint(5) unsigned 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;
CREATE TABLE `eznews_users` (
`uid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`uname` varchar(255) NOT NULL,
`passwd` varchar(255) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;