oracle.sql

来自「Hibernate (著译者: 陈天河等)项目开发宝典本书以Hibernate为」· SQL 代码 · 共 25 行

CREATE TABLESPACE message
DATAFILE '/opt/oracle/oradata/surecomp/message01.dbf' size 200M
EXTENT MANAGEMENT local;

CREATE USER message IDENTIFIED BY message
DEFAULT TABLESPACE message;

GRANT connect, resource TO message;

CREATE TABLE userinfo (
	id			VARCHAR2(32) NOT NULL,
	name		VARCHAR2(32) NOT NULL,
	password	VARCHAR2(32) NOT NULL,
	CONSTRAINT userinfo_pk PRIMARY KEY (id),
	CONSTRAINT userinfo_unique_name UNIQUE ( name )
);

CREATE TABLE message (
	id			VARCHAR2(32) NOT NULL,
	title		VARCHAR2(32) NOT NULL,
	content		VARCHAR2(2000),
	user_id		VARCHAR2(32),
	CONSTRAINT message_pk PRIMARY KEY (id),
	CONSTRAINT message_user FOREIGN KEY (user_id) REFERENCES userinfo(id) 
);