mysql的建表语句转换成kingbase820 CREATE TABLE t_iam_dept_txl ID varchar32 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 主键UUID SERIAL_NUMBER int11 NULL DEFAULT NULL COMMENT 主键UUID DEPT_CODE

CREATE TABLE t_iam_dept_txl ( "ID" varchar(32) COLLATE "pg_catalog"."default" NOT NULL, "SERIAL_NUMBER" integer DEFAULT NULL, "DEPT_CODE" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying, "DEPT_NAME" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying, "PARENT_ID" varchar(32) COLLATE "pg_catalog"."default" DEFAULT '0'::character varying, "PARENT_NAME" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying, "CORP_ID" varchar(32) COLLATE "pg_catalog"."default" DEFAULT NULL, "CORP_NAME" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying, "LEVEL_CODE" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying, "LEVEL" integer DEFAULT 0, "IS_CORP" integer DEFAULT 0, "HAS_CHILD" integer DEFAULT 1, "STATUS" smallint DEFAULT 1, "IS_DELETE" integer DEFAULT 0, "ORGMANAGERID" varchar(32) COLLATE "pg_catalog"."default" DEFAULT NULL, "SHOW_NUMBER" varchar(64) COLLATE "pg_catalog"."default" DEFAULT '10'::character varying, "CREATE_TIME" bigint DEFAULT NULL, "UPDATE_TIME" bigint DEFAULT NULL, "UNI_CODE" varchar(64) COLLATE "pg_catalog"."default" DEFAULT ''::character varying, "TMP1" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP2" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP3" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP4" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP5" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP6" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP7" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP8" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP9" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP10" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, "TMP11" bytea, "TMP12" bytea, "TMP13" bytea, "TMP14" bytea, "TMP15" bytea, "TMP16" text COLLATE "pg_catalog"."default", "TMP17" text COLLATE "pg_catalog"."default", "TMP18" text COLLATE "pg_catalog"."default", "TMP19" text COLLATE "pg_catalog"."default", "TMP20" text COLLATE "pg_catalog"."default", "BO_ID" varchar(32) COLLATE "pg_catalog"."default" DEFAULT 'v0'::character varying, "BO_UNICODE" varchar(32) COLLATE "pg_catalog"."default" DEFAULT NULL, "DS_DEPT_ID" varchar(32) COLLATE "pg_catalog"."default" DEFAULT NULL, "IS_SHOW" smallint DEFAULT NULL, "DEPT_FULL_NAME" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL, PRIMARY KEY ("ID"), INDEX "SERIAL_NUMBER" ("SERIAL_NUMBER") ); COMMENT ON TABLE t_iam_dept_txl IS '部门表'