-洗肠子
1
根据需求分析的结果规划出的实体有:管理员实体、单条新闻实体、新闻版块实 体、新闻评论实体
管理员表
(admin)
Sql
:
DROP DATABASE IF EXISTS `webnews`;
CREATE DATABASE `webnews`
USE ` webnews `;
CREATE TABLE admin (
adminID
int(4) NOT NULL auto_increment,
adminType int(4) not null,
adminName char(30) not null,
loginName char(30) not null,
loginPwd char(30) not null,
PRIMARY KEY
(adminID)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
INSERT INTO admin (
adminID
,adminType,adminName,loginName,loginPwd) VALUES (1,1,'
系统管理员
','admin1','admin1');
INSERT INTO admin (
adminID
,adminType,a dminName,loginName,loginPwd) VALUES (2,2,'
新闻管理员
','admin2','admin2');
INSERT INTO admin (
adminID
,adminType,a dminName,loginName,loginPwd) VALUES (3,3,'
会员管理员
','admin3','admin3');
INSERT INTO admin (
adminID
,adminType,a dminName,LoginName,LoginPwd) VALUES (4,4,'
评论管理员
','admin4','admin4');
会员表(
Member
)
字段名
memberID
loginPwd
类型
int
varchar
长度
4
50
50
是否为空
Not null
Not null
Not null
注释
登录名
登录密码
默认值
无
无
主键,
会员
ID
无
loginName
varchar
realName
varchar
varchar
50
100
Not null
Not null
真实姓名
无
会员
无
CREATE TABLE member (
memberID
int(4) NOT NULL auto_increment,
loginName char(50) not null,
loginPwd char(50) not null,
realName char(50) not null,
email varchar(100) not null,
PRIMARY KEY
(memberID)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
INSERT INTO member (
member ID
,loginName,loginPwd,realName,email) VALUES (1, 'member1','member1','
会员
1
号
','me mber1@');
INSERT INTO member (
memberID
,loginName,loginPwd,realName,email) VALUES (2, 'me mber2','member2','
会员
2
号
','member2@' );
INSERT INTO member (
memberID
,loginN ame,loginPwd,realName,email) VALUES (3, 'member3', 'member3','
会员
3
号
','member3@');
INSERT INTO member (
memberID
,loginName ,loginPwd,realName,email) VALUES (4, 'member4','me mber4','
会员
4
号
','member4@');
INSERT INTO member (
memberID
,loginName ,loginPwd,realName,email) VALUES (5, 'member5','me mber5','
会员
5
号
','member5@');
INSERT INTO member (
memberID
,loginName ,loginPwd,realName,email) VALUES (6, 'member6','me mber6','
会员
6
号
','member6@');
INSERT INTO member (
memberID
,loginName ,loginPwd,realName,email) VALUES (7, 'member7','me mber7','
会员
7
号
','member7@');
INSERT INTO member (
memberID
,loginName ,loginPwd,realName,email) VALUES (8, 'member8','me mber8','
会员
8
号
','member8@');
INSERT INTO member (
memberID
,loginName ,loginPwd,realName,email) VALUES (9, 'member9','me mber9','
会员
9
号
','member9@');
INSERT INTO member (
memberID
,loginName ,loginPwd,realName,email) VALUES (10,
'member1 0','member10','
会员
10
号
','member10@') ;
新闻评论表(
Comments
)
字段名
CommentID
reviewer
Title
Content
newsID
类
型
int
int
Text
int
长
度
是否为空
注
释
4
4
16
4
否
是
否
否
是
主键
评论标识
外键
评论者姓名(会员
ID
)
评论标题
评论内容
评论时间
外键
所属新闻
ID
默认值
(无)
(无)
(无)
(无)
Now
()
(无)
varchar
100
否
CommentDate
Datetime
8
CREATE TABLE comments (
commentID
int(4) NOT NULL auto_increment,
reviewer
int(4) ,
news
int(4),
title varchar(100) not NULL,
content text not null,
commentDate datetime not null,
PRIMARY KEY
(commentID),
foreign key (reviewer) references member(memberID) on delete cascade,
foreign key (news) references news(newsID) on delete cascade
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
INSERT INTO comments (
commentID
,
reviewer
,
news
, title,content, commentDate) VALUES (1, 1,1, '
真假?
',
'
火箭就是垃圾
', now());
INSERT INTO comments (
commentID
,
reviewer
,
news
, title,content, commentDate) VALUES (2, 2,1, '
强大的
队伍正常表现
', '
期待火箭会越来越好
', now());
INSERT INTO comments (
commentID
,
reviewer
,
news
, title,content, commentDate) VALUES (3, 1,3, '
真假?
',
'
饭岛爱死了,太可惜了。多好的一人啊!
', now());
INSERT INTO comments (
commentID
,
reviewer
,
news
, title,content, commentDate) VALUES (4, 1,2, '
读书?
',
'
读书到死
', now());
-洗肠子
-洗肠子
-洗肠子
-洗肠子
-洗肠子
-洗肠子
-洗肠子
-洗肠子
本文更新与2021-02-01 21:40,由作者提供,不代表本网站立场,转载请注明出处:http://www.xapfxb.com/yuer/441009.html
-
上一篇:老年人便秘能喝羊奶粉吗
下一篇:胃的形态结构与功能