create user rui
identified by rui
default tablespace facelook;grant connect,resource to rui;--用户表
create table fluser(
userid varchar2(20) primary key,
username varchar2(40),
password varchar2(20),
email varchar2(100),
version number(10),
status number(6)
);create table album(
id number(10) primary key,
name varchar2(60),
userid varchar2(20) references fluser(userid), --外键
limit number(6) --相册权限
);create table photo(
photoid number(10) primary key,
createtime date, --创建时间
name varchar2(30), --相片名称
contenttype varchar2(30), --相片类型
albumid number(10) references album(id), --相册实体类外键
content varchar(256), --相片
thumbnail varchar(256), --缩略图
photoorder number(6) --相册内顺序
);create table flcomment(
commentid number(10) primary key,
photoid number(10) references photo(photoid), --外键
parentid number(10),
createtime date,
userid varchar2(20) references fluser(userid), --外键
flcomment varchar2(200),
commentorder number(6)
);create table (
id number(10) primary key,
photoid number(10) references photo(photoid), --外键
name varchar2(20), --标记名称
leftL number(6),
leftT number(6),
rightL number(6),
rightT number(6),
order number(6) --显示顺序
);create table activity(
id number(10) primary key,
userid varchar2(20) references fluser(userid), --外键
time date,
type number(6),
photoid number(10) references photo(photoid),
commentid number(10) references flcomment(commentid), --外键
id number(10) references (id) --外键
);create sequence user_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence album_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence photo_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence comment_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence _seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence activity_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence order_seq
start with 1
increment by 1
nomaxvalue
cache 10;oracle
identified by rui
default tablespace facelook;grant connect,resource to rui;--用户表
create table fluser(
userid varchar2(20) primary key,
username varchar2(40),
password varchar2(20),
email varchar2(100),
version number(10),
status number(6)
);create table album(
id number(10) primary key,
name varchar2(60),
userid varchar2(20) references fluser(userid), --外键
limit number(6) --相册权限
);create table photo(
photoid number(10) primary key,
createtime date, --创建时间
name varchar2(30), --相片名称
contenttype varchar2(30), --相片类型
albumid number(10) references album(id), --相册实体类外键
content varchar(256), --相片
thumbnail varchar(256), --缩略图
photoorder number(6) --相册内顺序
);create table flcomment(
commentid number(10) primary key,
photoid number(10) references photo(photoid), --外键
parentid number(10),
createtime date,
userid varchar2(20) references fluser(userid), --外键
flcomment varchar2(200),
commentorder number(6)
);create table (
id number(10) primary key,
photoid number(10) references photo(photoid), --外键
name varchar2(20), --标记名称
leftL number(6),
leftT number(6),
rightL number(6),
rightT number(6),
order number(6) --显示顺序
);create table activity(
id number(10) primary key,
userid varchar2(20) references fluser(userid), --外键
time date,
type number(6),
photoid number(10) references photo(photoid),
commentid number(10) references flcomment(commentid), --外键
id number(10) references (id) --外键
);create sequence user_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence album_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence photo_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence comment_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence _seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence activity_seq
start with 1
increment by 1
nomaxvalue
cache 10;create sequence order_seq
start with 1
increment by 1
nomaxvalue
cache 10;oracle
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货