mysql.sql

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

CREATE DATABASE message;

GRANT ALL ON message.* TO message@localhost IDENTIFIED BY "message";

USE message;

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

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