uav
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for agv_group
-- ----------------------------
DROP TABLE IF EXISTS `agv_group`;
CREATE TABLE `agv_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(128) DEFAULT NULL COMMENT '群名',
`user_id` int(11) DEFAULT NULL COMMENT '创建的作者',
`introduce` varchar(128) DEFAULT NULL COMMENT '群的介绍',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户的群组';
-- ----------------------------
-- Table structure for agv_static
-- ----------------------------
DROP TABLE IF EXISTS `agv_static`;
CREATE TABLE `agv_static` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`scene_id` varchar(128) DEFAULT NULL COMMENT '场景的id',
`lab_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`agv_counts` int(11) DEFAULT NULL COMMENT 'agv的总数',
`order_finished` int(11) DEFAULT NULL COMMENT '订单完成的总数',
`agv_distance` double DEFAULT NULL COMMENT 'agv总的距离',
`agv_time` double DEFAULT NULL COMMENT 'agv总的运行时间',
`order_time` double DEFAULT NULL COMMENT '订单总的运行时间',
`avarage_rate` double DEFAULT NULL COMMENT 'agv平均利用率',
`avarage_order_time` double DEFAULT NULL COMMENT '订单平均完成时间',
`created` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='仿真的统计结果';
-- ----------------------------
-- Table structure for agv_user
-- ----------------------------
DROP TABLE IF EXISTS `agv_user`;
CREATE TABLE `agv_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(64) DEFAULT NULL COMMENT '用户的登录名',
`password` varchar(64) DEFAULT NULL COMMENT '用户的密码',
`realname` varchar(64) DEFAULT NULL COMMENT '用户的真是名字',
`type` int(11) DEFAULT NULL COMMENT '1表示学生，2表示教师',
`salt` varchar(64) DEFAULT NULL COMMENT '密码盐',
`status` int(11) DEFAULT NULL COMMENT '1:完成注册',
`headimage` varchar(128) DEFAULT NULL COMMENT '用户头像',
`email` char(64) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Table structure for group_user
-- ----------------------------
DROP TABLE IF EXISTS `group_user`;
CREATE TABLE `group_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`status` char(10) DEFAULT NULL COMMENT '1:提交审核，2：审核中，3审核成功',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COMMENT='用户群内的用户';
-- ----------------------------
-- Table structure for ilab_token
-- ----------------------------
DROP TABLE IF EXISTS `ilab_token`;
CREATE TABLE `ilab_token` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`un` varchar(64) DEFAULT NULL,
`access_token` varchar(128) DEFAULT NULL,
`reportId` int(11) DEFAULT NULL,
`start_time` mediumtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(64) DEFAULT NULL COMMENT '权限的描述',
`permission` varchar(64) DEFAULT NULL COMMENT '权限',
`url` varchar(64) DEFAULT NULL COMMENT '权限访问的url',
`parent_id` int(11) DEFAULT NULL COMMENT '父亲权限',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='权限表';
-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` varchar(64) DEFAULT NULL COMMENT '创建时间',
`product_name` varchar(64) DEFAULT NULL COMMENT '产品的名称',
`num` varchar(64) DEFAULT NULL,
`price` int(11) DEFAULT NULL COMMENT '产品的价格',
`sceneId` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3889 DEFAULT CHARSET=utf8 COMMENT='商品';
-- ----------------------------
-- Table structure for reprot_static
-- ----------------------------
DROP TABLE IF EXISTS `reprot_static`;
CREATE TABLE `reprot_static` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`object_id` varchar(128) DEFAULT NULL COMMENT '目标的id',
`object_content` varchar(128) DEFAULT NULL COMMENT 'type为1表示车的名字 ，type为2是表示订单的id',
`object_time` double DEFAULT NULL COMMENT '运行时间',
`scene_id` varchar(128) DEFAULT NULL COMMENT '场景的id',
`user_id` int(11) DEFAULT NULL COMMENT '用户的id',
`object_type` int(11) DEFAULT NULL COMMENT '1:car 2:order',
`object_name` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COMMENT='报告中的agv和order详细信息';
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(64) DEFAULT NULL COMMENT '角色的名字',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色';
-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_id` int(11) DEFAULT NULL,
`permission_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='角色权限表';
-- ----------------------------
-- Table structure for shelves
-- ----------------------------
DROP TABLE IF EXISTS `shelves`;
CREATE TABLE `shelves` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shelves_name` varchar(64) DEFAULT NULL COMMENT '货架的名字',
`created` varchar(64) DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='货架';
-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`scene_id` varchar(128) DEFAULT NULL COMMENT '场景的id',
`content` varchar(255) DEFAULT NULL COMMENT '作业的内容',
`created` varchar(64) DEFAULT NULL COMMENT '作业的创建时间',
`deadline` bigint(20) DEFAULT NULL COMMENT '作业的截至日期',
`user_id` int(11) DEFAULT NULL COMMENT '作者的id',
`group_id` int(11) DEFAULT NULL COMMENT '所对应的群组',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='作业';
-- ----------------------------
-- Table structure for task_report
-- ----------------------------
DROP TABLE IF EXISTS `task_report`;
CREATE TABLE `task_report` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` text COMMENT '报告的内容',
`user_id` int(11) DEFAULT NULL COMMENT '用户的id',
`created` varchar(64) DEFAULT NULL COMMENT '提交的时间',
`status` int(11) DEFAULT NULL COMMENT '1表示创建，2表示提交，3表示批改完成',
`task_id` int(11) DEFAULT NULL COMMENT '任务的id',
`score` int(11) DEFAULT NULL COMMENT '教师批改的分数',
`remark` varchar(128) DEFAULT NULL COMMENT '教师的评语',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='学生作业的提交报告';
-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`roler_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户juese';
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for agv_user
-- ----------------------------
DROP TABLE IF EXISTS `agv_user`;
CREATE TABLE `agv_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(64) DEFAULT NULL COMMENT '用户的登录名',
`password` varchar(64) DEFAULT NULL COMMENT '用户的密码',
`realname` varchar(64) DEFAULT NULL COMMENT '用户的真是名字',
`type` int(11) DEFAULT NULL COMMENT '1表示学生，2表示教师',
`salt` varchar(64) DEFAULT NULL COMMENT '密码盐',
`status` int(11) DEFAULT NULL COMMENT '1:完成注册',
`headimage` varchar(128) DEFAULT NULL COMMENT '用户头像',
`email` char(64) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Records of agv_user
-- ----------------------------
INSERT INTO `agv_user` VALUES ('2', 'jinma', '1f5b93481fd2e56dc1660b2a53153e2e', '金马', '1', '11111', '0', null, '1771084007@qq.com');
INSERT INTO `agv_user` VALUES ('3', 'test01', '1f5b93481fd2e56dc1660b2a53153e2e', null, '1', '11111', '0', null, null);
INSERT INTO `agv_user` VALUES ('5', 'teacher', '4064d7330ea8e5df352d6db45e6c271a', 'teacher01', '2', '11111', '0', null, '1771084007@qq.com');
INSERT INTO `agv_user` VALUES ('9', 'teacher001', '88f23c6b6af2be4a1e34d9181e603dc1', null, '2', '882553', '0', null, null);
INSERT INTO `agv_user` VALUES ('116', 'student', '0963e2693521d5a517ffc75d791e5b34', '学生', '1', '11111', '0', null, '1771084007@qq.com');
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(64) DEFAULT NULL COMMENT '权限的描述',
`permission` varchar(64) DEFAULT NULL COMMENT '权限',
`url` varchar(64) DEFAULT NULL COMMENT '权限访问的url',
`parent_id` int(11) DEFAULT NULL COMMENT '父亲权限',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='权限表';
-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES ('1', '批量导入用户', 'addBulkUser', '/user/addBulkUser', '0');
INSERT INTO `permission` VALUES ('2', '添加群组', 'addGroup', '/user/addGroup', '0');
INSERT INTO `permission` VALUES ('3', '更新群组', 'updateGroup', '/user/updateGroup', '0');
INSERT INTO `permission` VALUES ('4', '删除群组', 'delGroup', '/user/delGroup', '0');
INSERT INTO `permission` VALUES ('5', '添加任务', 'addTask', '/task/addTask', '0');
INSERT INTO `permission` VALUES ('6', '修改任务', 'updateTask', '/task/updateTask', '0');
INSERT INTO `permission` VALUES ('7', '删除任务', 'delTask', '/task/delTask', '0');
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(64) DEFAULT NULL COMMENT '角色的名字',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色';
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '管理员');
INSERT INTO `role` VALUES ('2', '学生');
-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_id` int(11) DEFAULT NULL,
`permission_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='角色权限表';
-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES ('1', '1', '1');
INSERT INTO `role_permission` VALUES ('2', '1', '2');
INSERT INTO `role_permission` VALUES ('3', '1', '3');
INSERT INTO `role_permission` VALUES ('4', '1', '4');
INSERT INTO `role_permission` VALUES ('5', '1', '5');
INSERT INTO `role_permission` VALUES ('6', '1', '6');
INSERT INTO `role_permission` VALUES ('7', '1', '7');
浙公网安备 33010602011771号