create.sql

来自「一个jsp的扫雷英雄榜源代码」· SQL 代码 · 共 25 行

CREATE DATABASE ch02;
USE ch02;

# -----------------------------------------------------------------------
# player_info
# -----------------------------------------------------------------------
DROP TABLE IF EXISTS player_info;

CREATE TABLE player_info (
username   VARCHAR(20)  NOT NULL,
password   VARCHAR(20)  NOT NULL,
realname   VARCHAR(20)  NOT NULL,
PRIMARY KEY (username) );

# -----------------------------------------------------------------------
# player_record
# -----------------------------------------------------------------------
DROP TABLE IF EXISTS player_record;

CREATE TABLE player_record (
username VARCHAR(20)  NOT NULL,
grade    CHAR(1)      NOT NULL,
use_time int,
PRIMARY KEY ( username,grade ) );