-- For ORACLE Sqlplus

-- Creation des Tables --

CREATE TABLE USERS(
	UID 		NUMBER(4),
	PSEUDO		VARCHAR(15),
	PASSWORD	VARCHAR(10)
);

CREATE TABLE MESSAGES (
	ID		NUMBER(5),
	PSEUDO		VARCHAR(15),
	MESSAGE		VARCHAR(40),
	PRIMARY KEY(ID)
	-- FOREIGN KEY(PSEUDO) REFERENCES USERS
);