用户表: 表名:user
CREATE TABLE user (
username varchar(20) NOT NULL,
password varchar(20) NOT NULL,
access int DEFAULT '0', --默认值为0——>游客, 1——>普通用户, 2———>VIP, 3——>管理员root
PRIMARY KEY (username)
);
--按权限列出所有用户 select username,access from user order by access asc
--审核通过 update user set access='1' where username=''
--删除用户 delete from user where username=''
--会员注册 update user set access='2' where username=''
站内公告: 表名:message
CREATE TABLE message(
ID int PRIMARY KEY AUTO_INCREMENT, --公告编号:ID(主键)
Title varchar(50) not null primary key, --公告内容:Title
pDate timestamp NOT NULL DEFAULT NOW(),