schema.sql

来自「是jsp开发与应用详解的全部源代码」· SQL 代码 · 共 15 行

CREATE DATABASE hibdemo DEFAULT CHARSET utf8;
USE hibdemo;
create table sys_user (
    id bigint not null auto_increment,
    email varchar(255) not null unique,
    name varchar(255) not null,
    password varchar(255) not null,
    screen_name varchar(255),
    status smallint,
    address varchar(255),
    primary key (id)
);
-- data for test
insert into sys_user (email,name,password,screen_name,status,address) values('[e-mail]','neo','first','neo',1,'zion');
insert into sys_user (email,name,password,screen_name,status,address) values('[e-mail]','trinitty','neo','trinitty',1,'zion');