WAREAMS/base_sql/bucket_sql/xuankuang_ddl_20230904.sql

CREATE TABLE if not exists `car_info` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `carNo` int(11) DEFAULT NULL COMMENT '车编号',
    `warehouse_id` int(11) DEFAULT NULL COMMENT '仓库编号',
    `state` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '状态',
    `active_flag` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Y' COMMENT '是否启用',
    `userdefine1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `userdefine2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `userdefine3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `userdefine4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `userdefine5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `battery` int(11) DEFAULT NULL COMMENT '电池',
    `x` int(11) DEFAULT NULL COMMENT 'x轴',
    `y` int(11) DEFAULT NULL COMMENT 'y轴',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;