--
--Create Database
--
create database if not exists new_db character set = 'gb2312' collate = 'gb2312_chinese_ci';
--
--Create Table
--
use new_db;
drop table if exists Customer;
create table Customer
(
CustomerID smallint unsigned not null primary key auto_increment,
Name varchar(20) not null,
Gender ENUM('M', 'F') not null,
Address varchar(25) not null default ' ',
Telephone smallint unsigned not null default '0'
)engine = InnoDB default charset = gb2312 default collate = gb2312_chinese_ci;
use new_db;
drop table if exists TestingInfo;
create table TestingInfo
(
TestingID smallint unsigned primary key not null auto_increment,
CustomerID smallint unsigned not null ,
City varchar(20) not null default ' ',
CurDate date not null default 0,
CheckIn ENUM('T', 'N') not null,
Groups ENUM('A', 'B', 'C') not null,
foreign key (CustomerID) references Customer(CustomerID)
)engine = InnoDB default charset = gb2312 default collate = gb2312_chinese_ci;
--
--Creata user
--
use new_db;
grant select, insert, update, delete on new_db.* to m1@'%', m2@'%', m3@'%';