create database news;
来源:互联网 发布:阿里云股票接口 编辑:程序博客网 时间:2024/06/06 01:27
create database news;
use news;
create table manager(
uname varchar(20) primary key,
upass varchar(20) not null
);
create table users(
uid int(8) primary key auto_increment,
uname varchar(20) not null unique,
upass varchar(20) not null,
sex char(2) default '男',
score int(8) default 0,
constraint ck_sex check(sex in('男','女'))
);
create table newsType(
tid int(8) primary key auto_increment,
title varchar(100) not null,
discription varchar(200)
);
create table newsInfo(
nid int(8) primary key auto_increment,
title varchar(100) not null,
content varchar(1000),
picPath varchar(100),
creator varchar(20),
cdate datetime ,
mdate datetime,
constraint fk_creator foreign key(creator) references manager(uname)
);
create table comments(
cid int(8) primary key auto_increment,
title varchar(50) not null,
content varchar(500) ,
creator int(8),
cdate datetime,
constraint fk_comments foreign key(creator) references users(uid)
);
use news;
create table manager(
uname varchar(20) primary key,
upass varchar(20) not null
);
create table users(
uid int(8) primary key auto_increment,
uname varchar(20) not null unique,
upass varchar(20) not null,
sex char(2) default '男',
score int(8) default 0,
constraint ck_sex check(sex in('男','女'))
);
create table newsType(
tid int(8) primary key auto_increment,
title varchar(100) not null,
discription varchar(200)
);
create table newsInfo(
nid int(8) primary key auto_increment,
title varchar(100) not null,
content varchar(1000),
picPath varchar(100),
creator varchar(20),
cdate datetime ,
mdate datetime,
constraint fk_creator foreign key(creator) references manager(uname)
);
create table comments(
cid int(8) primary key auto_increment,
title varchar(50) not null,
content varchar(500) ,
creator int(8),
cdate datetime,
constraint fk_comments foreign key(creator) references users(uid)
);
- create database news;
- create database
- create database
- create database
- Create database
- create database
- Create RSS channels from HTML news sites
- Create Mobile Database Apps
- oracle create database
- mysql create database utf8
- CREATE DATABASE LINK
- Oracle Create Database Syntax
- CREATE DATABASE 的步骤
- mysql的create database
- Create database manual
- Oracle Create Database
- create database link
- MANUALLY CREATE DATABASE
- 获取客户端访问的真实IP和区域
- 堆和栈的区别
- JavaScript显示系统时间
- 如何使用AppCAD计算传输线的特性阻抗
- myeclipse6.5重新安装maven2 (Maven+MyEclipse6.5)
- create database news;
- IE6下Png透明最佳解决方案(推荐) Unit PNG Fix
- 装双系统的电脑上实现linux与windows之间的文件共享
- grails 附初值
- 首遇ORA-00600: internal error code, arguments: [evapth : unexpected evaluation], [], [], [], [], [], [
- HttpWatch工具简介及使用技巧
- 派生和继承
- 如何减小NK大小&&WinCE的快速启动
- marquee属性 marquee参数