ddl.sql

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

CREATE DATABASE library;

GRANT ALL ON library.* to library@localhost IDENTIFIED BY "library";

USE library;

create table CATEGORY (
	id varchar(32) primary key,
	name varchar(32) not null,
	description varchar(255)
);

create unique index ui_category_name on category( name );

create table PRODUCT (
	id varchar(32) primary key,
	name varchar(32) not null,
	description varchar(255),
	category_id varchar(32) references category(id)
);
	
create table user_info (
	username varchar(32) primary key,
	password varchar(32)
);

insert into user_info values( 'test', 'test' );