user_tbl.sql

来自「一个较简单的论坛——中国精英论坛,是我的一个练习」· SQL 代码 · 共 41 行

drop table zhao_space_tbl;
drop table zhao_talk_tbl;
drop table zhao_user_tbl;

drop sequence zhao_space_sequence;
drop sequence zhao_user_sequence;
drop sequence zhao_talk_sequence;

create sequence zhao_user_sequence;
create table zhao_user_tbl
(
	id number(5) primary key,
	username varchar2(20),
	userpwd varchar2(20),
	city varchar2(30),
	img varchar2(30),
	cent int,
	timestr timestamp default sysdate
);
create sequence zhao_talk_sequence;
create table zhao_talk_tbl(
	id number(5) primary key,
	talkname varchar2(20) not null,
	talkcontent varchar2(100),
	userid number(5) references zhao_user_tbl(id),
	top int,
	count number(5),
	timestr timestamp default sysdate);
	
create sequence zhao_space_sequence;
create table zhao_space_tbl(
	id number(5) primary key,
	userid number(5) references zhao_user_tbl(id),
	talkid number(5) references zhao_talk_tbl(id),
	spacecontent varchar2(100),
	timestr timestamp default sysdate);