mysql建表语句以及项目建表案例

建表语句以及案例
CREATE TABLE IF NOT EXISTS tra_safefee(
id VARCHAR (32) NOT NULL PRIMARY KEY COMMENT ‘主键id’,
orderid VARCHAR (32) NOT NULL COMMENT ‘订单id’,
isopen INT (2) NOT NULL DEFAULT ‘1’ COMMENT ‘是否开启投保 0-否 1-是’,
safefee DECIMAL(10,2) NOT NULL COMMENT ‘保费’,
ispay INT(2) NOT NULL COMMENT ‘是否已经支付 0-否 1-是’,
isvalid INT (2) COMMENT ‘是否有效 0-无效 1-有效’,
creator VARCHAR (10) COMMENT ‘创建者’,
createtime BIGINT (20) COMMENT ‘创建时间’,
updatetime BIGINT (20) COMMENT ‘版本时间戳’,
remark VARCHAR (200) COMMENT ‘系统备注’
)ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT ‘***服务费’;