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) 
);