CREATE TABLE i2bill_sys_attachment ( `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `size` int(0) NOT NULL, `ext` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `create_time` datetime(0) NOT NULL, `del_flag` int(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;