eznews.sql

:::

[1032]PHP入門

9-1 eznews.sql

01CREATE TABLE `eznews` (
02  `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
03  `cate_sn` smallint(5) unsigned NOT NULL,
04  `news_title` varchar(255) NOT NULL,
05  `news_content` longtext NOT NULL,
06  `ip` varchar(255) NOT NULL,
07  `author` varchar(255) NOT NULL,
08  `uid` smallint(5) unsigned NOT NULL,
09  `post_time` datetime NOT NULL,
10  `status` varchar(255) NOT NULL,
11  `counter` mediumint(8) unsigned NOT NULL,
12  PRIMARY KEY (`sn`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;
14 
15 
16CREATE TABLE `eznews_cate` (
17  `cate_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
18  `cate_title` varchar(255) NOT NULL,
19  PRIMARY KEY (`cate_sn`)
20) ENGINE=MyISAM DEFAULT CHARSET=utf8;
21 
22CREATE TABLE `eznews_files` (
23  `file_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
24  `sn` smallint(5) unsigned NOT NULL,
25  `file_name` varchar(255) NOT NULL,
26  `file_size` int(11) NOT NULL,
27  `file_type` varchar(255) NOT NULL,
28  `file_new_name` varchar(255) NOT NULL,
29  PRIMARY KEY (`file_sn`)
30) ENGINE=MyISAM DEFAULT CHARSET=utf8;
31 
32 
33CREATE TABLE `eznews_users` (
34  `uid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
35  `uname` varchar(255) NOT NULL,
36  `passwd` varchar(255) NOT NULL,
37  PRIMARY KEY (`uid`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8;