mysql.sql

来自「Spring +Web 的完整 MyEclipse 项目源码,使用者可以作为入门」· SQL 代码 · 共 37 行

drop database if exists hiexample;
create database hiexample;
grant all privileges on olat.* to test@"%" identified by "test";
grant all privileges on olat.* to test@localhost identified by "test";
use hiexample;

CREATE TABLE IF NOT EXISTS USER_TABLE (
   id bigint NOT NULL, 
   username varchar(80) not null,  
PRIMARY KEY (id)) 
TYPE=INNODB 
MIN_ROWS=0 
MAX_ROWS=1000 
PACK_KEYS=DEFAULT 
ROW_FORMAT=DEFAULT ;

CREATE TABLE IF NOT EXISTS ITEM_TABLE (
   id bigint  NOT NULL, 
   itemName varchar(80) null,  
PRIMARY KEY (id)) 
TYPE=INNODB 
MIN_ROWS=0 
MAX_ROWS=1000 
PACK_KEYS=DEFAULT 
ROW_FORMAT=DEFAULT ;

CREATE TABLE IF NOT EXISTS BID_TABLE (
   id bigint  NOT NULL, 
    bidAmount decimal(10,2) null, 
    item_id bigint  NOT NULL, 
    user_id bigint  NOT NULL,  
PRIMARY KEY (id)) 
TYPE=INNODB 
MIN_ROWS=0 
MAX_ROWS=1000 
PACK_KEYS=DEFAULT 
ROW_FORMAT=DEFAULT ;