怎样写MySQL的脚本

Question

DROP TABLE TBCRTYPE;
CREATE TABLE TBCRTYPE (
PRJID          INT          NOT NULL,
DOCTYPEID      INT          NOT NULL,
FILETYPEID     INT          NOT NULL,
TYPEID         INT          NOT NULL,
TYPEFLAG       VARCHAR(1)   NOT NULL,
TYPENAME       VARCHAR(200) NOT NULL,
LOCKKBN        VARCHAR(1),
LOCKUSERID     VARCHAR(20),
LOCKTIME       VARCHAR(19),
WIDEUSE1       VARCHAR(200),
WIDEUSE2       VARCHAR(200),
WIDEUSE3       VARCHAR(200),
WIDEUSE4       VARCHAR(200),
CREATETIME     VARCHAR(19),
CREATWTID      VARCHAR(50),
CREATEUSER     VARCHAR(20),
CREATESYSTEM   VARCHAR(20),
LASTWTID       VARCHAR(50),
LASTSYSTEM     VARCHAR(20),
LASTTIME       VARCHAR(19),
LASTUSER       VARCHAR(20),
PRIMARY KEY(PRJID, DOCTYPEID, FILETYPEID, TYPEID, TYPEFLAG)
)TYPE=InnoDB;
commit;