建表

---

CREATE TABLE msdb.UserInfo(
id INT AUTO_INCREMENT,
username VARCHAR(64) NOT NULL,
password VARCHAR(64),
KEY(id),
PRIMARY KEY (username)
) CHARSET=gbk COLLATE=gbk_bin;

CREATE TABLE msdb.company(
cmc VARCHAR(128) CHARSET gbk COLLATE gbk_bin NOT NULL,
cjc VARCHAR(32),
sfcx TINYINT,
SHOW_CODE VARCHAR(128) CHARSET gbk COLLATE gbk_bin,
PAR_OBJ_ID VARCHAR(64),
PRIMARY KEY (cmc)
) CHARSET=gbk COLLATE=gbk_bin;