CREATE TABLE account ( id int NOT NULL AUTO_INCREMENT, name varchar(32) NOT NULL, password char(32) NOT NULL, question varchar(64), answer varchar(64), email varchar(64), qq varchar(16), tel varchar(16), address varchar(255), id_type enum('IdCard') DEFAULT 'IdCard', id_card varchar(32), point int DEFAULT '0' NOT NULL, PRIMARY KEY (id, name) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE pay ( trade_no varchar(20) NOT NULL, channel varchar(10), server_id int NOT NULL, account_id int NOT NULL, fee int NOT NULL, status tinyint NOT NULL, create_time datetime NOT NULL, pay_time datetime, PRIMARY KEY (trade_no), INDEX trade_no (trade_no) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE server ( id int NOT NULL AUTO_INCREMENT, name varchar(32) NOT NULL, host char(60) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;