加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
platform.sql 19.61 KB
一键复制 编辑 原始数据 按行查看 历史
PickJ 提交于 2019-03-20 10:54 . 角色接口+sql文件更新
/*
Navicat MySQL Data Transfer
Source Server : 本地数据库
Source Server Version : 50721
Source Host : localhost:3306
Source Database : platform
Target Server Type : MYSQL
Target Server Version : 50721
File Encoding : 65001
Date: 2019-03-20 10:53:32
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for car_info
-- ----------------------------
DROP TABLE IF EXISTS `car_info`;
CREATE TABLE `car_info` (
`plate_num` varchar(255) NOT NULL,
`car_desc` varchar(255) DEFAULT NULL,
`car_pic` varchar(255) DEFAULT NULL,
`car_size` int(11) DEFAULT NULL,
PRIMARY KEY (`plate_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of car_info
-- ----------------------------
INSERT INTO `car_info` VALUES ('SS', '111', 'ss', '21');
INSERT INTO `car_info` VALUES ('string', 'string', 'string', '0');
-- ----------------------------
-- Table structure for car_place
-- ----------------------------
DROP TABLE IF EXISTS `car_place`;
CREATE TABLE `car_place` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`car_place_code` varchar(255) DEFAULT NULL,
`car_place_status` int(11) DEFAULT NULL,
`car_place_type` int(11) DEFAULT NULL,
`parking_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of car_place
-- ----------------------------
-- ----------------------------
-- Table structure for coder
-- ----------------------------
DROP TABLE IF EXISTS `coder`;
CREATE TABLE `coder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`code_desc` varchar(255) DEFAULT NULL,
`code_key` varchar(255) DEFAULT NULL,
`code_value` varchar(255) DEFAULT NULL,
`key_desc` varchar(255) DEFAULT NULL,
`value_desc` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of coder
-- ----------------------------
-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`parking_id` int(11) DEFAULT NULL,
`replay` varchar(255) DEFAULT NULL,
`score` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of comment
-- ----------------------------
-- ----------------------------
-- Table structure for parking
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`car_place_num` int(11) DEFAULT NULL,
`discount` int(11) DEFAULT NULL,
`has_cheap` int(11) DEFAULT NULL,
`is_business` int(11) DEFAULT NULL,
`latitude` double DEFAULT NULL,
`location` varchar(255) DEFAULT NULL,
`longitude` double DEFAULT NULL,
`max_time` int(11) DEFAULT NULL,
`parking_name` varchar(255) NOT NULL,
`parking_phone` int(11) DEFAULT NULL,
`parking_sort_code` varchar(255) DEFAULT NULL,
`parking_status_code` int(11) DEFAULT NULL,
`pic_ids` varchar(255) DEFAULT NULL,
`reservation_time` double DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of parking
-- ----------------------------
-- ----------------------------
-- Table structure for parking_order
-- ----------------------------
DROP TABLE IF EXISTS `parking_order`;
CREATE TABLE `parking_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`actual_pay` double DEFAULT NULL,
`car_place_id` int(11) DEFAULT NULL,
`comment_id` int(11) DEFAULT NULL,
`end_time` datetime DEFAULT NULL,
`order_status` int(11) DEFAULT NULL,
`parking_id` int(11) DEFAULT NULL,
`pay_status` int(11) DEFAULT NULL,
`plate_num` varchar(255) DEFAULT NULL,
`rule_code` varchar(255) DEFAULT NULL,
`start_time` datetime DEFAULT NULL,
`total_pay` double DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of parking_order
-- ----------------------------
-- ----------------------------
-- Table structure for parking_record
-- ----------------------------
DROP TABLE IF EXISTS `parking_record`;
CREATE TABLE `parking_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`car_place_id` int(11) DEFAULT NULL,
`end_time` datetime DEFAULT NULL,
`parking_id` int(11) DEFAULT NULL,
`plate_num` varchar(255) DEFAULT NULL,
`start_time` datetime DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`user_type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of parking_record
-- ----------------------------
-- ----------------------------
-- Table structure for pay_rule
-- ----------------------------
DROP TABLE IF EXISTS `pay_rule`;
CREATE TABLE `pay_rule` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`code_desc` varchar(255) DEFAULT NULL,
`code_key` varchar(255) DEFAULT NULL,
`code_value` varchar(255) DEFAULT NULL,
`key_desc` varchar(255) DEFAULT NULL,
`parking_id` int(11) DEFAULT NULL,
`value_desc` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of pay_rule
-- ----------------------------
-- ----------------------------
-- Table structure for resource
-- ----------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`type` int(11) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`permission` varchar(255) DEFAULT NULL,
`sort` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of resource
-- ----------------------------
INSERT INTO `resource` VALUES ('1', '主页', '0', '0', '/home', null, '1');
INSERT INTO `resource` VALUES ('2', '停车场管理', '0', '0', '/parking', null, '2');
INSERT INTO `resource` VALUES ('3', '车库列表', '2', '0', '/parking/list', null, '3');
INSERT INTO `resource` VALUES ('4', '车库详情', '2', '0', '/parking/detail', null, '4');
INSERT INTO `resource` VALUES ('5', '订单管理', '0', '0', '/order', null, '5');
INSERT INTO `resource` VALUES ('6', '实时订单', '5', '0', '/order/now', null, '6');
INSERT INTO `resource` VALUES ('7', '历史订单', '5', '0', '/order/history', null, '7');
INSERT INTO `resource` VALUES ('8', '车库记录表', '0', '0', '/record', null, '8');
INSERT INTO `resource` VALUES ('9', '留言管理', '0', '0', '/message', null, '9');
INSERT INTO `resource` VALUES ('10', '最新留言', '9', '0', '/message/now', null, '10');
INSERT INTO `resource` VALUES ('11', '历史留言', '9', '0', '/message/history', null, '11');
INSERT INTO `resource` VALUES ('12', '个人信息', '0', '0', '/userInfo', null, '12');
INSERT INTO `resource` VALUES ('13', '我的车辆', '12', '0', '/userInfo/car', null, '13');
INSERT INTO `resource` VALUES ('14', '系统管理', '0', '0', '/system', null, '14');
INSERT INTO `resource` VALUES ('15', '用户管理', '14', '0', '/system/user', null, '15');
INSERT INTO `resource` VALUES ('16', '角色管理', '14', '0', '/system/role', null, '16');
INSERT INTO `resource` VALUES ('17', '权限管理', '14', '0', '/system/permission', null, '17');
INSERT INTO `resource` VALUES ('18', '文件管理', '14', '0', '/system/file', null, '18');
INSERT INTO `resource` VALUES ('19', '码表管理', '14', '0', '/system/code', null, '19');
INSERT INTO `resource` VALUES ('20', '添加用户', '15', '1', '/api/user/add', 'user:add', '20');
INSERT INTO `resource` VALUES ('21', '修改资源', '17', '1', null, 'resource:update', '21');
INSERT INTO `resource` VALUES ('22', '增加资源', '17', '1', null, 'resource:add', '22');
INSERT INTO `resource` VALUES ('23', '删除资源', '17', '1', null, 'resource:delete', '23');
INSERT INTO `resource` VALUES ('24', '修改用户', '15', '1', null, 'user:update', '2');
INSERT INTO `resource` VALUES ('25', '删除用户', '15', '1', null, 'user:delete', '1');
INSERT INTO `resource` VALUES ('28', '新增角色', '16', '1', null, 'role:add', null);
INSERT INTO `resource` VALUES ('27', '我的信息', '12', '0', '/userInfo/mine', null, '0');
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`role_name` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '2019-03-02 20:51:28', '2019-03-02 20:51:28', '管理员', 'admin');
INSERT INTO `role` VALUES ('2', '2019-03-13 20:23:14', '2019-03-13 20:23:17', '测试员', 'test');
INSERT INTO `role` VALUES ('10', '2019-03-19 17:01:24', '2019-03-19 17:01:24', '普通用户', 'user');
-- ----------------------------
-- Table structure for role_resource_bind
-- ----------------------------
DROP TABLE IF EXISTS `role_resource_bind`;
CREATE TABLE `role_resource_bind` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`resource_id` int(11) DEFAULT NULL,
`role_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of role_resource_bind
-- ----------------------------
INSERT INTO `role_resource_bind` VALUES ('44', '20', '1');
INSERT INTO `role_resource_bind` VALUES ('24', '2', '1');
INSERT INTO `role_resource_bind` VALUES ('26', '3', '1');
INSERT INTO `role_resource_bind` VALUES ('28', '4', '1');
INSERT INTO `role_resource_bind` VALUES ('49', '25', '2');
INSERT INTO `role_resource_bind` VALUES ('6', '6', '1');
INSERT INTO `role_resource_bind` VALUES ('7', '7', '1');
INSERT INTO `role_resource_bind` VALUES ('43', '24', '2');
INSERT INTO `role_resource_bind` VALUES ('9', '9', '1');
INSERT INTO `role_resource_bind` VALUES ('10', '10', '1');
INSERT INTO `role_resource_bind` VALUES ('11', '11', '1');
INSERT INTO `role_resource_bind` VALUES ('12', '12', '1');
INSERT INTO `role_resource_bind` VALUES ('13', '13', '1');
INSERT INTO `role_resource_bind` VALUES ('32', '14', '1');
INSERT INTO `role_resource_bind` VALUES ('34', '15', '1');
INSERT INTO `role_resource_bind` VALUES ('52', '16', '1');
INSERT INTO `role_resource_bind` VALUES ('17', '17', '1');
INSERT INTO `role_resource_bind` VALUES ('36', '18', '1');
INSERT INTO `role_resource_bind` VALUES ('19', '19', '1');
INSERT INTO `role_resource_bind` VALUES ('25', '2', '2');
INSERT INTO `role_resource_bind` VALUES ('21', '21', '1');
INSERT INTO `role_resource_bind` VALUES ('27', '3', '2');
INSERT INTO `role_resource_bind` VALUES ('29', '4', '2');
INSERT INTO `role_resource_bind` VALUES ('42', '8', '1');
INSERT INTO `role_resource_bind` VALUES ('33', '14', '2');
INSERT INTO `role_resource_bind` VALUES ('35', '15', '2');
INSERT INTO `role_resource_bind` VALUES ('37', '18', '2');
INSERT INTO `role_resource_bind` VALUES ('38', '22', '1');
INSERT INTO `role_resource_bind` VALUES ('39', '23', '1');
INSERT INTO `role_resource_bind` VALUES ('40', '5', '1');
INSERT INTO `role_resource_bind` VALUES ('45', '24', '1');
INSERT INTO `role_resource_bind` VALUES ('50', '1', '1');
INSERT INTO `role_resource_bind` VALUES ('51', '1', '2');
INSERT INTO `role_resource_bind` VALUES ('53', '16', '2');
INSERT INTO `role_resource_bind` VALUES ('54', '26', '1');
INSERT INTO `role_resource_bind` VALUES ('55', '27', '1');
INSERT INTO `role_resource_bind` VALUES ('56', '28', '1');
-- ----------------------------
-- Table structure for upload_file
-- ----------------------------
DROP TABLE IF EXISTS `upload_file`;
CREATE TABLE `upload_file` (
`file_id` varchar(255) NOT NULL,
`file_path` varchar(255) DEFAULT NULL,
`original_file_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of upload_file
-- ----------------------------
INSERT INTO `upload_file` VALUES ('201903181917166', 'http://pno0766j2.bkt.clouddn.com/201903181917166', 'timg (2).jpg');
INSERT INTO `upload_file` VALUES ('201903181916155', 'http://pno0766j2.bkt.clouddn.com/201903181916155', 'a7f140a4df6d40b4bced0852584dd414!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181915384', 'http://pno0766j2.bkt.clouddn.com/201903181915384', 'f124941fbf12408b9b32c0facce7594b!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181915500', 'http://pno0766j2.bkt.clouddn.com/201903181915500', 'timg (1).jpg');
INSERT INTO `upload_file` VALUES ('201903181916003', 'http://pno0766j2.bkt.clouddn.com/201903181916003', 'u=2399164908,2374783155&fm=26&gp=0.jpg');
INSERT INTO `upload_file` VALUES ('201903181916079', 'http://pno0766j2.bkt.clouddn.com/201903181916079', '6a095ce095ed41708bdc0de843247f0b!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181907346', 'http://pno0766j2.bkt.clouddn.com/201903181907346', 'timg.jpg');
INSERT INTO `upload_file` VALUES ('201903181907250', 'http://pno0766j2.bkt.clouddn.com/201903181907250', 'f124941fbf12408b9b32c0facce7594b!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181907124', 'http://pno0766j2.bkt.clouddn.com/201903181907124', 'f95af7b475a04567abf5455ab1f45fad!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181907023', 'http://pno0766j2.bkt.clouddn.com/201903181907023', 'bd78e6f5977041f08d9fffa51b99d09f!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181906544', 'http://pno0766j2.bkt.clouddn.com/201903181906544', 'timg (1).jpg');
INSERT INTO `upload_file` VALUES ('201903181906448', 'http://pno0766j2.bkt.clouddn.com/201903181906448', '90b216b1bb834501b9ebc3897c7087aa!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181906267', 'http://pno0766j2.bkt.clouddn.com/201903181906267', '05d85f468c034ed9b419b370c5bf6a1e!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181902075', 'http://pno0766j2.bkt.clouddn.com/201903181902075', '404.png');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`account` varchar(20) NOT NULL,
`balance` double DEFAULT NULL,
`credit` int(11) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`phone` int(11) DEFAULT NULL,
`photo` varchar(255) DEFAULT NULL,
`role_id` int(11) DEFAULT NULL,
`sex` varchar(255) DEFAULT NULL,
`user_name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('2', '2019-03-13 20:12:09', '2019-03-13 20:12:13', 'admin', '10', '0', '9edef2c5ae0ccfe27768637bb12f874c', '123', '201903181917166', '1', '男', '彭哥');
INSERT INTO `user` VALUES ('5', null, null, 'test1', '10', '0', 'e8344c3c348e0e55fcd9c817e50af842', '122222', '201903181906267', '2', '女', '测试员1');
INSERT INTO `user` VALUES ('6', null, null, 'test2', '10', '0', '868bba54cacb57c4dc8f9e54d5188e7a', '122222', '201903181906448', '2', '女', '测试员2');
INSERT INTO `user` VALUES ('7', null, null, 'test3', '10', '2', '8587fe8b13283285e3d3cbcd7d83df3c', '12222255', '201903181906544', '2', '男', '测试员3');
INSERT INTO `user` VALUES ('8', null, null, 'test4', '10', '0', 'fa864a14fa6a3e08663671a8af1f06fd', '88888', '201903181907023', '2', '男', '测试员4');
INSERT INTO `user` VALUES ('9', null, null, 'test5', '10', '0', 'd6fbdf02bd8c25f626e90cf4b558f068', '122222', '201903181907124', '2', '男', '测试员5');
INSERT INTO `user` VALUES ('10', null, null, 'test6', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181907250', '2', '男', '测试员6');
INSERT INTO `user` VALUES ('11', null, null, 'test7', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181907346', '2', '男', '测试员7');
INSERT INTO `user` VALUES ('12', null, null, 'test8', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181915500', '2', '男', '测试员8');
INSERT INTO `user` VALUES ('13', null, null, 'test9', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181916003', '2', '男', '测试员9');
INSERT INTO `user` VALUES ('14', null, null, 'test10', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181916079', '2', '男', '测试员10');
INSERT INTO `user` VALUES ('15', null, null, 'test11', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181916155', '2', '男', '测试员11');
INSERT INTO `user` VALUES ('16', null, null, 'test12', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员12');
INSERT INTO `user` VALUES ('17', null, null, 'test13', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员13');
INSERT INTO `user` VALUES ('18', null, null, 'test14', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员14');
INSERT INTO `user` VALUES ('19', null, null, 'test15', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员15');
INSERT INTO `user` VALUES ('20', null, null, 'test16', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员16');
INSERT INTO `user` VALUES ('21', null, null, 'test17', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员17');
INSERT INTO `user` VALUES ('22', null, null, 'test18', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员18');
INSERT INTO `user` VALUES ('23', null, null, 'test19', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员19');
INSERT INTO `user` VALUES ('24', null, null, 'test20', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员20');
INSERT INTO `user` VALUES ('25', null, null, 'test21', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', null, '2', '男', '测试员21');
INSERT INTO `user` VALUES ('26', null, null, 'custom1', '0', '10', 'e7650cebe1247f653364b3313dbac850', '1314520', 'string', '2', '女', '访客1');
INSERT INTO `user` VALUES ('27', null, null, 'custom2', '0', '10', 'c6f3031f58290c579575cf7ac0b572e6', '1314520', 'string', '2', '女', '访客1');
INSERT INTO `user` VALUES ('28', null, null, 'custom3', '0', '0', '11abdbcee7e33734fc0e64900af18b77', '133', 'string', '2', '男', '访客3');
-- ----------------------------
-- Table structure for user_plate_bind
-- ----------------------------
DROP TABLE IF EXISTS `user_plate_bind`;
CREATE TABLE `user_plate_bind` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_datetime` datetime DEFAULT NULL,
`update_datetime` datetime DEFAULT NULL,
`plate_num` varchar(255) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user_plate_bind
-- ----------------------------
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化