create_tables_110100.sql

来自「一个用java+jsp实现的论坛和聊天室」· SQL 代码 · 共 60 行

-- create_tables.sql

------------------------------------------------------

-- drop all objects:

drop sequence customer_seq;
drop sequence disc_article_seq;
drop sequence disc_article_thread_seq;

drop table disc_article;
drop table customer;

------------------------------------------------------

CREATE TABLE CUSTOMER
(
ID NUMBER(10, 0) CONSTRAINT PK_CUSTOMER PRIMARY KEY,
acct_name varchar2(32) not null unique,
pwd_enc raw(16) not null
)
TABLESPACE USERS 
STORAGE(INITIAL 16384
	NEXT	16384
	MINEXTENTS 1
	MAXEXTENTS 500
	PCTINCREASE 0)
/

create sequence customer_seq;

------------------------------------------------------

CREATE TABLE DISC_ARTICLE
(
id number(10, 0) constraint pk_disc_article primary key,
date_post date,
content varchar2(1024),
subject varchar2(32),
from_ip varchar2(32),
customer_id number,
disc_type_id number,
thread_id number,
constraint fk_disc_article foreign key
  (customer_id) references customer (id) on delete cascade
)
TABLESPACE USERS 
STORAGE(INITIAL 16384
	NEXT	16384
	MINEXTENTS 1
	MAXEXTENTS 500
	PCTINCREASE 0)
/

create sequence disc_article_seq;
create sequence disc_article_thread_seq;

------------------------------------------------------