大佬们帮忙看看啊,我这个建表语句有问题吗,为什么一直14行附近出现错误,无效的数据类型
create table CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG
(
id bigint(19)
constraint T_DATA_TRANS_RULE_CONFIG_pk
primary key,
parent_id bigint(19),
rule_name varchar(50),
rule_description VARCHAR(512),
fetch_type varchar(200),
status varchar(10),
description1 text,
custom_flag TINYINT(3),
rule_type TINYINT(3)
);
comment on table CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG is ‘数据分发信息表’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.parent_id is ‘父类id’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.rule_name is ‘规则名称’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.rule_description is ‘规则说明’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.fetch_type is ‘提取类型’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.status is ‘状态(0停用,1启用,2注销)’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.description1 is ‘描述1’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.custom_flag is ‘是否自定义菜单,1为是,0为否’;
comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.rule_type is ‘1-正则规则, 2-关键词规则’;
create table CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG
(
id bigint
constraint T_DATA_TRANS_RULE_CONFIG_pk
primary key,
parent_id bigint,
rule_name varchar(50),
rule_description VARCHAR(512),
fetch_type varchar(200),
status varchar(10),
description1 text,
custom_flag TINYINT,
rule_type TINYINT
);
bigint和TINYINT后面不要加精度