数据库
- 格式：doc
- 大小：35.50 KB
- 文档页数：3
1.管理员
drop table if exists t_admin;
create table t_admin(
id integer not null auto_increment,
username varchar(255) not null unique,
password varchar(255),
primary key(id)
);
/*
你可以在下面编写插入语句，往数据库表插入数据
*/
insert into t_admin (username,password) values('admin','admin');
2文章
drop table if exists t_article;
create table t_article(
id integer not null auto_increment,
title varchar(200),
content longtext,
source varchar(255),
keyword varchar(255),
intro varchar(2000),
type varchar(50),
author varchar(100),
recommend boolean,
headline boolean,
leaveNumber integer default 0,
clickNumber integer default 0,
adminId integer,
topicId integer,
createtime datetime,
updatetime datetime,
deploytime datetime,
primary key(id)
);
drop table if exists t_article_keyword;
create table t_article_keyword(
articleId integer,
keyword varchar(255)
);
3.附件
drop table if exists t_attachment;
create table t_attachment(
id integer not null auto_increment, articleId integer,
name varchar(200),
contentType varchar(100),
uploadTime datetime,
primary key(id)
);
4.频道
/*
创建Channel和Article的一张中间表，用来记录哪篇文章属于哪个频道这些信息
其中：channelId和articleId联合起来不允许重复！
*/
drop table if exists t_channel_article;
create table t_channel_article(
channelId integer,
articleId integer,
unique key channel_article (channelId,articleId)
);
5.频道
drop table if exists t_channel;
create table t_channel(
id integer not null auto_increment,
name varchar(200),
description longtext,
primary key(id)
);
6.留言
-- 创建文章评论留言表
drop table if exists t_comment;
create table t_comment(
id integer not null auto_increment,
name varchar(200),
email varchar(50),
site varchar(200),
articleId integer,
memberId integer,
content longtext,
commentTime datetime,
primary key(id)
);
7.会员
-- 创建网站会员信息表
drop table if exists t_member;
create table t_member(
id integer not null auto_increment, name varchar(200),
email varchar(50),
nickName varchar(50),
password varchar(20),
qq varchar(20),
phone varchar(20),
address varchar(255),
description longtext,
primary key(id)
);
insert into t_member (name,nickname,password) values ('比尔','test','test');
