/*
Navicat MySQL Data Transfer
Source Server : 47.121.117.123
Source Server Version : 50535
Source Host : 47.121.117.123:3306
Source Database : fr_oqb
Target Server Type : MYSQL
Target Server Version : 50535
File Encoding : 65001
Date: 2024-02-23 11:52:25
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for order_active
-- ----------------------------
DROP TABLE IF EXISTS `order_active`;
CREATE TABLE `order_active` (
`id` varchar(64) NOT NULL,
`no` varchar(128) DEFAULT NULL COMMENT '订单编号',
`totalmoney` decimal(18,5) DEFAULT NULL COMMENT '订单总金额',
`payedmoney` decimal(18,5) DEFAULT NULL COMMENT '已支付金额',
`paymentmethod` int(11) DEFAULT NULL,
`discountmoney` decimal(18,5) DEFAULT NULL COMMENT '折扣金额',
`status` int(11) DEFAULT NULL COMMENT '状态',
`ordertime` datetime DEFAULT NULL COMMENT '下单时间',
`paytime` datetime DEFAULT NULL COMMENT '支付时间',
`sendtime` datetime DEFAULT NULL COMMENT '发货时间',
`receivetime` datetime DEFAULT NULL COMMENT '收货时间',
`commenttime` datetime DEFAULT NULL COMMENT '评价时间',
`completetime` datetime DEFAULT NULL COMMENT '完成时间',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`sendername` varchar(128) DEFAULT NULL COMMENT '发货人名称',
`sendercode` varchar(64) DEFAULT NULL COMMENT '发货人编号',
`sendercontactno` int(64) DEFAULT NULL COMMENT '发货人联系方式',
`targetaddress` varchar(1024) DEFAULT NULL COMMENT '收货地址',
`deliveryaddress` varchar(1024) DEFAULT NULL COMMENT '发货地址',
`optimalcoupon` varchar(1024) DEFAULT NULL COMMENT '优惠券',
`logisticscompany` varchar(64) DEFAULT NULL COMMENT '物流公司',
`logisticsno` varchar(64) DEFAULT NULL COMMENT '物流编号',
`transportmode` varchar(64) DEFAULT NULL COMMENT '运输方式',
`boxcount` int(11) DEFAULT NULL COMMENT '箱数',
`boxweight` decimal(18,5) DEFAULT NULL COMMENT '重量',
`freight` decimal(18,5) DEFAULT NULL COMMENT '运费',
`commentcontent` varchar(1024) DEFAULT NULL COMMENT '评价内容',
`commentlevel` int(11) DEFAULT NULL COMMENT '评价等级',
`receiverid` varchar(64) DEFAULT NULL COMMENT '收货人ID',
`vipuserId` varchar(64) DEFAULT NULL COMMENT '会员ID',
`vipname` varchar(128) DEFAULT NULL COMMENT '会员名称',
`vipphone` varchar(32) DEFAULT NULL COMMENT '会员联系电话',
`vipdiamondtype` int(11) DEFAULT NULL COMMENT '会员等级',
`viptype` int(11) DEFAULT NULL COMMENT '会员类型',
`vippicture` varchar(1024) DEFAULT NULL COMMENT '会员肖像',
`vipcarddiscountrate` decimal(18,5) DEFAULT NULL COMMENT '会员卡折扣率',
`type` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_active
-- ----------------------------
INSERT INTO `order_active` VALUES ('09ecfc99-a97a-4d16-a6cb-8b2b8311f65b', 'A000000006', '0.10000', null, null, null, '0', '2024-02-20 14:12:54', null, null, null, null, null, '0', null, '2024-02-20 14:12:54', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '1');
INSERT INTO `order_active` VALUES ('42836373-b78b-4e4f-b749-88863a6e2e56', 'A000000002', '0.01000', '0.01000', '2', null, '4', '2024-01-31 15:01:39', '2024-01-31 15:02:19', null, null, null, null, '0', null, '2024-01-31 15:01:39', '2024-01-31 15:02:19', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0d9d1d9c-9be8-4dc1-9102-be8b10110c27', null, '15122116943', null, null, 'https://www.wisdomdeliver.com:443/static/picture//ohzrgMbsGBZ6e04adb165d4f310fdd7f838895ae590c-20240125093313.png', null, '0');
INSERT INTO `order_active` VALUES ('5b9acb50-eb53-4588-a53a-68fc7c0ec60f', 'A000000004', '0.10000', '0.10000', '0', null, '4', '2024-01-31 15:06:45', '2024-01-31 15:06:45', null, null, null, null, '0', null, '2024-01-31 15:06:45', '2024-01-31 15:06:45', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0d9d1d9c-9be8-4dc1-9102-be8b10110c27', null, '15122116943', null, null, 'https://www.wisdomdeliver.com:443/static/picture//ohzrgMbsGBZ6e04adb165d4f310fdd7f838895ae590c-20240125093313.png', null, '1');
INSERT INTO `order_active` VALUES ('720b16d8-ae77-401d-90ea-08f76ae08afa', 'A000000001', '0.01000', null, null, null, '0', '2024-01-31 14:46:08', null, null, null, null, null, '0', null, '2024-01-31 14:46:08', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0d9d1d9c-9be8-4dc1-9102-be8b10110c27', null, '15122116943', null, null, 'https://www.wisdomdeliver.com:443/static/picture//ohzrgMbsGBZ6e04adb165d4f310fdd7f838895ae590c-20240125093313.png', null, '0');
INSERT INTO `order_active` VALUES ('7b166ca2-52b2-4e2c-8ee4-cab7cc30fcc4', 'A000000012', '0.10000', null, null, null, '0', '2024-02-20 14:33:36', null, null, null, null, null, '0', null, '2024-02-20 14:33:36', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '1');
INSERT INTO `order_active` VALUES ('93e25d3e-e962-4e36-9679-8b3afe29c94e', 'A000000011', '0.10000', null, null, null, '0', '2024-02-20 14:13:58', null, null, null, null, null, '0', null, '2024-02-20 14:13:58', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '1');
INSERT INTO `order_active` VALUES ('9fee1b0c-abf5-4ca3-b570-0fd889a17e34', 'A000000009', '0.10000', null, null, null, '0', '2024-02-20 14:13:19', null, null, null, null, null, '0', null, '2024-02-20 14:13:19', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '1');
INSERT INTO `order_active` VALUES ('a3eb0ed9-2eef-4083-883e-5e6bcffd4f86', 'A000000010', '0.01000', '0.01000', '2', null, '4', '2024-02-20 14:13:43', '2024-02-20 14:13:49', null, null, null, null, '0', null, '2024-02-20 14:13:43', '2024-02-20 14:13:49', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '0');
INSERT INTO `order_active` VALUES ('a426d99c-ae00-485a-b887-13762ee89670', 'A000000008', '0.10000', null, null, null, '0', '2024-02-20 14:13:16', null, null, null, null, null, '0', null, '2024-02-20 14:13:16', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '1');
INSERT INTO `order_active` VALUES ('b62603c7-4dd4-4a38-be23-fa5717283988', 'A000000013', '0.01000', null, null, null, '0', '2024-02-20 22:04:15', null, null, null, null, null, '0', null, '2024-02-20 22:04:15', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '0');
INSERT INTO `order_active` VALUES ('d0993a0e-ea3a-4913-9417-f4736a03de1e', 'A000000007', '0.10000', null, null, null, '0', '2024-02-20 14:13:12', null, null, null, null, null, '0', null, '2024-02-20 14:13:12', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '1');
INSERT INTO `order_active` VALUES ('d95a1e55-b704-4d22-8741-f60ff29f1ff1', 'A000000005', '0.01000', null, null, null, '0', '2024-02-07 11:29:17', null, null, null, null, null, '0', null, '2024-02-07 11:29:17', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '2', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, '0');
INSERT INTO `order_active` VALUES ('f6eec033-8324-45c1-86d7-2da5492c2ce4', 'A000000003', '0.01000', '0.01000', '2', null, '4', '2024-01-31 15:05:15', '2024-01-31 15:05:32', null, null, null, null, '0', null, '2024-01-31 15:05:15', '2024-01-31 15:05:32', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0d9d1d9c-9be8-4dc1-9102-be8b10110c27', null, '15122116943', null, null, 'https://www.wisdomdeliver.com:443/static/picture//ohzrgMbsGBZ6e04adb165d4f310fdd7f838895ae590c-20240125093313.png', null, '0');
-- ----------------------------
-- Table structure for order_active_product
-- ----------------------------
DROP TABLE IF EXISTS `order_active_product`;
CREATE TABLE `order_active_product` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`productid` varchar(64) DEFAULT NULL COMMENT '产品ID',
`productcode` varchar(64) DEFAULT NULL COMMENT '产品编号',
`productname` varchar(256) DEFAULT NULL COMMENT '产品名称',
`status` int(11) DEFAULT NULL COMMENT '状态',
`color` varchar(32) DEFAULT NULL COMMENT '颜色',
`size` varchar(32) DEFAULT NULL COMMENT '尺码',
`count` int(11) DEFAULT NULL COMMENT '数量',
`image` varchar(256) DEFAULT NULL COMMENT '产品图片',
`price` decimal(18,5) DEFAULT NULL COMMENT '产品原价',
`saleprice` decimal(18,5) DEFAULT NULL COMMENT '售价',
`rejectreason` varchar(1024) DEFAULT NULL COMMENT '拒绝理由',
`rejectcomment` varchar(1024) DEFAULT NULL COMMENT '拒绝注释',
`rejecttime` datetime DEFAULT NULL COMMENT '拒绝时间',
`payer` varchar(256) DEFAULT NULL COMMENT '支付人',
`payedmoney` decimal(18,5) DEFAULT NULL COMMENT '支付金额',
`discount` decimal(18,5) DEFAULT NULL COMMENT '折扣金额',
`payee` varchar(256) DEFAULT NULL COMMENT '收款人',
`orderid` varchar(64) DEFAULT NULL,
`orderno` varchar(128) DEFAULT NULL COMMENT '订单编号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_active_product
-- ----------------------------
INSERT INTO `order_active_product` VALUES ('21b242ff-b486-4af4-b658-6e909c7441d7', '0', null, '2024-02-07 11:29:17', null, 'b1a5ca4e-ecad-420f-8049-c7897e9b09b5', null, '0.1', '0', null, null, null, null, '0.01000', null, null, null, null, null, null, null, null, 'd95a1e55-b704-4d22-8741-f60ff29f1ff1', 'A000000005');
INSERT INTO `order_active_product` VALUES ('26c77d55-bfd5-4b20-951e-f089543f8efe', '0', null, '2024-02-20 14:13:58', null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '0', null, null, null, null, '0.10000', null, null, null, null, null, null, null, null, '93e25d3e-e962-4e36-9679-8b3afe29c94e', 'A000000011');
INSERT INTO `order_active_product` VALUES ('65dcbe62-0012-4f24-9bcd-bd936b73d848', '0', null, '2024-02-20 14:13:19', null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '0', null, null, null, null, '0.10000', null, null, null, null, null, null, null, null, '9fee1b0c-abf5-4ca3-b570-0fd889a17e34', 'A000000009');
INSERT INTO `order_active_product` VALUES ('66236cd6-e046-4dbe-adac-a46939a21f9d', '0', null, '2024-02-20 14:13:43', null, 'b1a5ca4e-ecad-420f-8049-c7897e9b09b5', null, '0.1', '0', null, null, null, null, '0.01000', null, null, null, null, null, null, null, null, 'a3eb0ed9-2eef-4083-883e-5e6bcffd4f86', 'A000000010');
INSERT INTO `order_active_product` VALUES ('673f6950-2118-4ad6-b13a-a8a9f94f3637', '0', null, '2024-01-31 14:46:08', null, 'b1a5ca4e-ecad-420f-8049-c7897e9b09b5', null, '0.1', '0', null, null, null, null, '0.01000', null, null, null, null, null, null, null, null, '720b16d8-ae77-401d-90ea-08f76ae08afa', 'A000000001');
INSERT INTO `order_active_product` VALUES ('74d18ed8-110d-4ccd-bae9-d5a44929ff81', '0', null, '2024-02-20 14:33:36', null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '0', null, null, null, null, '0.10000', null, null, null, null, null, null, null, null, '7b166ca2-52b2-4e2c-8ee4-cab7cc30fcc4', 'A000000012');
INSERT INTO `order_active_product` VALUES ('83ec3f00-369a-4ddb-91a9-ecefbbab499c', '0', null, '2024-02-20 14:13:16', null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '0', null, null, null, null, '0.10000', null, null, null, null, null, null, null, null, 'a426d99c-ae00-485a-b887-13762ee89670', 'A000000008');
INSERT INTO `order_active_product` VALUES ('8abfa515-6c46-4471-8293-b24c421ffa00', '0', null, '2024-02-20 14:12:54', null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '0', null, null, null, null, '0.10000', null, null, null, null, null, null, null, null, '09ecfc99-a97a-4d16-a6cb-8b2b8311f65b', 'A000000006');
INSERT INTO `order_active_product` VALUES ('8da14ffc-cdac-47be-aba5-08047569cc8e', '0', null, '2024-02-20 22:04:15', null, 'b1a5ca4e-ecad-420f-8049-c7897e9b09b5', null, '0.1', '0', null, null, null, null, '0.01000', null, null, null, null, null, null, null, null, 'b62603c7-4dd4-4a38-be23-fa5717283988', 'A000000013');
INSERT INTO `order_active_product` VALUES ('ab12d76d-06c3-458e-aedb-ee77bb3711d2', '0', null, '2024-01-31 15:06:45', null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '0', null, null, null, null, '0.10000', null, null, null, null, null, null, null, null, '5b9acb50-eb53-4588-a53a-68fc7c0ec60f', 'A000000004');
INSERT INTO `order_active_product` VALUES ('af423938-697d-474e-8968-0e6a13e08ecc', '0', null, '2024-02-20 14:13:12', null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '0', null, null, null, null, '0.10000', null, null, null, null, null, null, null, null, 'd0993a0e-ea3a-4913-9417-f4736a03de1e', 'A000000007');
INSERT INTO `order_active_product` VALUES ('c02ef08a-f466-4791-803e-ee5366084e9e', '0', null, '2024-01-31 15:01:39', null, 'b1a5ca4e-ecad-420f-8049-c7897e9b09b5', null, '0.1', '0', null, null, null, null, '0.01000', null, null, null, null, null, null, null, null, '42836373-b78b-4e4f-b749-88863a6e2e56', 'A000000002');
INSERT INTO `order_active_product` VALUES ('edc3e2e7-119f-496f-b2c7-95e52910726a', '0', null, '2024-01-31 15:05:15', null, 'b1a5ca4e-ecad-420f-8049-c7897e9b09b5', null, '0.1', '0', null, null, null, null, '0.01000', null, null, null, null, null, null, null, null, 'f6eec033-8324-45c1-86d7-2da5492c2ce4', 'A000000003');
-- ----------------------------
-- Table structure for order_history
-- ----------------------------
DROP TABLE IF EXISTS `order_history`;
CREATE TABLE `order_history` (
`id` varchar(64) NOT NULL,
`no` varchar(128) DEFAULT NULL COMMENT '订单编号',
`totalmoney` decimal(18,5) DEFAULT NULL COMMENT '订单总金额',
`payedmoney` decimal(18,5) DEFAULT NULL COMMENT '已支付金额',
`paymentmethod` int(11) DEFAULT NULL,
`discountmoney` decimal(18,5) DEFAULT NULL COMMENT '折扣金额',
`status` int(11) DEFAULT NULL COMMENT '状态',
`ordertime` datetime DEFAULT NULL COMMENT '下单时间',
`paytime` datetime DEFAULT NULL COMMENT '支付时间',
`sendtime` datetime DEFAULT NULL COMMENT '发货时间',
`receivetime` datetime DEFAULT NULL COMMENT '收货时间',
`commenttime` datetime DEFAULT NULL COMMENT '评价时间',
`completetime` datetime DEFAULT NULL COMMENT '完成时间',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`sendername` varchar(128) DEFAULT NULL COMMENT '发货人名称',
`sendercode` varchar(64) DEFAULT NULL COMMENT '发货人编号',
`sendercontactno` int(64) DEFAULT NULL COMMENT '发货人联系方式',
`targetaddress` varchar(1024) DEFAULT NULL COMMENT '收货地址',
`deliveryaddress` varchar(1024) DEFAULT NULL COMMENT '发货地址',
`optimalcoupon` varchar(1024) DEFAULT NULL COMMENT '优惠券',
`logisticscompany` varchar(64) DEFAULT NULL COMMENT '物流公司',
`logisticsno` varchar(64) DEFAULT NULL COMMENT '物流编号',
`transportmode` varchar(64) DEFAULT NULL COMMENT '运输方式',
`boxcount` int(11) DEFAULT NULL COMMENT '箱数',
`boxweight` decimal(18,5) DEFAULT NULL COMMENT '重量',
`freight` decimal(18,5) DEFAULT NULL COMMENT '运费',
`commentcontent` varchar(1024) DEFAULT NULL COMMENT '评价内容',
`commentlevel` int(11) DEFAULT NULL COMMENT '评价等级',
`receiverid` varchar(64) DEFAULT NULL COMMENT '收货人ID',
`vipuserId` varchar(64) DEFAULT NULL COMMENT '会员ID',
`vipname` varchar(128) DEFAULT NULL COMMENT '会员名称',
`vipphone` varchar(32) DEFAULT NULL COMMENT '会员联系电话',
`vipdiamondtype` int(11) DEFAULT NULL COMMENT '会员等级',
`viptype` int(11) DEFAULT NULL COMMENT '会员类型',
`vippicture` varchar(1024) DEFAULT NULL COMMENT '会员肖像',
`vipcarddiscountrate` decimal(18,5) DEFAULT NULL COMMENT '会员卡折扣率',
`type` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_history
-- ----------------------------
-- ----------------------------
-- Table structure for order_history_product
-- ----------------------------
DROP TABLE IF EXISTS `order_history_product`;
CREATE TABLE `order_history_product` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`productid` varchar(64) DEFAULT NULL COMMENT '产品ID',
`productcode` varchar(64) DEFAULT NULL COMMENT '产品编号',
`productname` varchar(256) DEFAULT NULL COMMENT '产品名称',
`status` int(11) DEFAULT NULL COMMENT '状态',
`color` varchar(32) DEFAULT NULL COMMENT '颜色',
`size` varchar(32) DEFAULT NULL COMMENT '尺码',
`count` int(11) DEFAULT NULL COMMENT '数量',
`image` varchar(256) DEFAULT NULL COMMENT '产品图片',
`price` decimal(18,5) DEFAULT NULL COMMENT '产品原价',
`saleprice` decimal(18,5) DEFAULT NULL COMMENT '售价',
`rejectreason` varchar(1024) DEFAULT NULL COMMENT '拒绝理由',
`rejectcomment` varchar(1024) DEFAULT NULL COMMENT '拒绝注释',
`rejecttime` datetime DEFAULT NULL COMMENT '拒绝时间',
`payer` varchar(256) DEFAULT NULL COMMENT '支付人',
`payedmoney` decimal(18,5) DEFAULT NULL COMMENT '支付金额',
`discount` decimal(18,5) DEFAULT NULL COMMENT '折扣金额',
`payee` varchar(256) DEFAULT NULL COMMENT '收款人',
`orderno` varchar(128) DEFAULT NULL COMMENT '订单编号',
`orderid` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_history_product
-- ----------------------------
-- ----------------------------
-- Table structure for order_receiver
-- ----------------------------
DROP TABLE IF EXISTS `order_receiver`;
CREATE TABLE `order_receiver` (
`id` varchar(64) NOT NULL,
`userid` varchar(64) DEFAULT NULL,
`code` varchar(128) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`contactno` varchar(64) DEFAULT NULL,
`country` varchar(64) DEFAULT NULL,
`province` varchar(64) DEFAULT NULL,
`city` varchar(64) DEFAULT NULL,
`region` varchar(128) DEFAULT NULL,
`receiveaddress` varchar(512) DEFAULT NULL,
`isoftenused` varchar(64) DEFAULT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_receiver
-- ----------------------------
-- ----------------------------
-- Table structure for organization_class
-- ----------------------------
DROP TABLE IF EXISTS `organization_class`;
CREATE TABLE `organization_class` (
`id` varchar(64) NOT NULL COMMENT 'id',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`outerphone` varchar(32) DEFAULT NULL,
`innerphone` varchar(32) DEFAULT NULL,
`supervisor` varchar(64) DEFAULT NULL,
`supervisorassistant` varchar(64) DEFAULT NULL,
`fax` varchar(64) DEFAULT NULL,
`zipcode` varchar(32) DEFAULT NULL,
`address` varchar(256) DEFAULT NULL,
`parentid` varchar(64) DEFAULT NULL COMMENT 'parent id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`deplevel` int(3) DEFAULT NULL COMMENT 'department level',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`organizationid` varchar(64) DEFAULT NULL,
`organizationname` varchar(256) DEFAULT NULL,
`organizationcode` varchar(256) DEFAULT NULL,
`departmentid` varchar(64) DEFAULT NULL,
`departmentname` varchar(256) DEFAULT NULL,
`departmentcode` varchar(256) DEFAULT NULL,
`majorid` varchar(64) DEFAULT NULL,
`majorname` varchar(256) DEFAULT NULL,
`majorcode` varchar(256) DEFAULT NULL,
`gradeid` varchar(64) DEFAULT NULL,
`gradename` varchar(256) DEFAULT NULL,
`gradecode` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of organization_class
-- ----------------------------
INSERT INTO `organization_class` VALUES ('1403c68e-b376-4c6b-84eb-46d90b74cc39', 'C001', '1', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:41:10', null, null, null, null, null, null, null, null, null, null, '094cef8e-7328-4ca8-8c36-889978bbdcdb', null, null);
INSERT INTO `organization_class` VALUES ('274665f9-3d76-4565-a50e-fe643f46a6a2', 'C005', '5', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:41:25', null, null, null, null, null, null, null, null, null, null, '094cef8e-7328-4ca8-8c36-889978bbdcdb', null, null);
INSERT INTO `organization_class` VALUES ('7662d6de-e6f6-4b00-8054-49dbb2b208aa', 'C004', '4', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:41:21', null, null, null, null, null, null, null, null, null, null, '094cef8e-7328-4ca8-8c36-889978bbdcdb', null, null);
INSERT INTO `organization_class` VALUES ('b5394e1b-7cdc-4757-bc4e-db0d8d13ee00', 'C003', '3', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:41:17', null, null, null, null, null, null, null, null, null, null, '094cef8e-7328-4ca8-8c36-889978bbdcdb', null, null);
INSERT INTO `organization_class` VALUES ('c5656c24-4377-4abb-8cf0-a5f77c06760c', 'C006', '6', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:41:29', null, null, null, null, null, null, null, null, null, null, '094cef8e-7328-4ca8-8c36-889978bbdcdb', null, null);
INSERT INTO `organization_class` VALUES ('daf060e0-b7a8-49b4-abb6-9e3a0173d9d1', 'C002', '2', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:41:14', null, null, null, null, null, null, null, null, null, null, '094cef8e-7328-4ca8-8c36-889978bbdcdb', null, null);
-- ----------------------------
-- Table structure for organization_department
-- ----------------------------
DROP TABLE IF EXISTS `organization_department`;
CREATE TABLE `organization_department` (
`id` varchar(64) NOT NULL COMMENT 'id',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`outerphone` varchar(32) DEFAULT NULL,
`innerphone` varchar(32) DEFAULT NULL,
`supervisor` varchar(64) DEFAULT NULL,
`supervisorassistant` varchar(64) DEFAULT NULL,
`fax` varchar(64) DEFAULT NULL,
`zipcode` varchar(32) DEFAULT NULL,
`address` varchar(256) DEFAULT NULL,
`parentid` varchar(64) DEFAULT NULL COMMENT 'parent id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`deplevel` int(3) DEFAULT NULL COMMENT 'department level',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`organizationid` varchar(64) DEFAULT NULL,
`organizationname` varchar(256) DEFAULT NULL,
`organizationcode` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of organization_department
-- ----------------------------
INSERT INTO `organization_department` VALUES ('6b29043d-d224-48ff-9d17-ab652fd584f5', 'D005', '计算机学院', '', '', '', '', '', '', '', '', '0', null, '0', '', '2024-01-31 09:56:13', null, 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002');
INSERT INTO `organization_department` VALUES ('90b99fb5-d9bf-4e16-928e-e4ab95595b72', 'D004', '商学院', '', '', '', '', '', '', '', '', '0', null, '0', '', '2024-01-31 09:56:04', null, 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002');
INSERT INTO `organization_department` VALUES ('cfb8f51e-7988-4023-8dca-b5b3cd15c7a5', 'D002', '土木工程管理', null, null, null, null, null, null, null, null, '0', null, '0', '测试数据', '2024-01-18 11:29:48', '2024-01-22 16:43:47', 'cd738fee-5cae-4e2a-b057-32e2138f9bdb', '中南大学', 'A0005');
INSERT INTO `organization_department` VALUES ('e27244bc-8240-4b12-bef2-003ded033148', 'D003', '工商管理学院', null, null, null, null, null, null, null, null, '0', null, '0', '测试数据', '2024-01-18 11:30:22', '2024-01-22 16:47:53', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002');
-- ----------------------------
-- Table structure for organization_grade
-- ----------------------------
DROP TABLE IF EXISTS `organization_grade`;
CREATE TABLE `organization_grade` (
`id` varchar(64) NOT NULL COMMENT 'id',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`outerphone` varchar(32) DEFAULT NULL,
`innerphone` varchar(32) DEFAULT NULL,
`supervisor` varchar(64) DEFAULT NULL,
`supervisorassistant` varchar(64) DEFAULT NULL,
`fax` varchar(64) DEFAULT NULL,
`zipcode` varchar(32) DEFAULT NULL,
`address` varchar(256) DEFAULT NULL,
`parentid` varchar(64) DEFAULT NULL COMMENT 'parent id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`deplevel` int(3) DEFAULT NULL COMMENT 'department level',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`organizationid` varchar(64) DEFAULT NULL,
`organizationname` varchar(256) DEFAULT NULL,
`organizationcode` varchar(256) DEFAULT NULL,
`departmentid` varchar(64) DEFAULT NULL,
`departmentname` varchar(256) DEFAULT NULL,
`departmentcode` varchar(256) DEFAULT NULL,
`majorid` varchar(64) DEFAULT NULL,
`majorname` varchar(256) DEFAULT NULL,
`majorcode` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of organization_grade
-- ----------------------------
INSERT INTO `organization_grade` VALUES ('094cef8e-7328-4ca8-8c36-889978bbdcdb', 'G001', '一年级', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:39:53', '2024-01-22 18:28:43', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '9ead598e-4faf-49e1-9863-165c766631ed', '工商管理', 'M003');
INSERT INTO `organization_grade` VALUES ('13d2cbb0-6aaf-41dd-ba44-18650e3268b7', 'G009', '一年级', '', '', '', '', '', '', '', '', '0', null, '0', '', '2024-01-27 15:20:22', null, 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '5b718983-9508-40f4-aeba-22aad1b55e47', '电子信息与科学', 'M007');
INSERT INTO `organization_grade` VALUES ('1e1e0815-0575-465f-be30-4b445cf2dc30', 'G003', '三年级', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:40:07', '2024-01-22 18:28:50', '1df5035a-d251-4d19-9045-59a377c123fc', '哈佛大学', 'B0001', '', '', '', '', '', '');
INSERT INTO `organization_grade` VALUES ('7af84337-44b5-4132-8e62-117b5bdf8014', 'G008', '二年级', '', '', '', '', '', '', '', '', '0', null, '0', '', '2024-01-27 15:20:07', '2024-01-27 15:20:37', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '5b718983-9508-40f4-aeba-22aad1b55e47', '电子信息与科学', 'M007');
INSERT INTO `organization_grade` VALUES ('89252e80-1fab-431d-bc92-c9e7418a36b6', 'G005', '五年级', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:40:25', '2024-01-22 18:27:17', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '1edb42fc-a10b-4f39-a2bc-6c2bcb276547', '土木工程', 'M002');
INSERT INTO `organization_grade` VALUES ('93aeebf0-7e96-4c82-b4c3-fe61e0e741c4', 'G002', '二年级', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:40:01', '2024-01-22 18:29:00', '59299abc-06ca-48f2-b026-4638ced717b4', '清华大学', 'A0002', '', '', '', '', '', '');
INSERT INTO `organization_grade` VALUES ('93bd9f0e-b05c-454d-8dcb-758a35ad804f', 'G006', '六年级', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:40:32', '2024-01-22 18:25:42', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '9ead598e-4faf-49e1-9863-165c766631ed', '工商管理', 'M003');
INSERT INTO `organization_grade` VALUES ('b302d31a-82fe-44d1-bb11-fd9b487d579c', 'G007', '三年级', '', '', '', '', '', '', '', '', '0', null, '0', '', '2024-01-27 15:15:23', '2024-01-27 15:21:36', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '5b718983-9508-40f4-aeba-22aad1b55e47', '电子信息与科学', 'M007');
INSERT INTO `organization_grade` VALUES ('f5160257-9dc3-41e4-818e-5fff2f1dab5f', 'G004', '四年级', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-08 22:40:17', '2024-01-22 18:27:34', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '8e4c4549-760a-44f2-b730-3131f6cc5645', '软件工程', 'M001');
-- ----------------------------
-- Table structure for organization_major
-- ----------------------------
DROP TABLE IF EXISTS `organization_major`;
CREATE TABLE `organization_major` (
`id` varchar(64) NOT NULL COMMENT 'id',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`parentid` varchar(64) DEFAULT NULL COMMENT 'parent id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`organizationid` varchar(64) DEFAULT NULL,
`organizationname` varchar(256) DEFAULT NULL,
`organizationcode` varchar(256) DEFAULT NULL,
`departmentid` varchar(64) DEFAULT NULL,
`departmentname` varchar(256) DEFAULT NULL,
`departmentcode` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of organization_major
-- ----------------------------
INSERT INTO `organization_major` VALUES ('03f1eb77-9638-4c6d-b554-f37b43435945', 'M005', '环境工程', '', '0', '0', '', '2024-01-22 16:44:54', null, 'cd738fee-5cae-4e2a-b057-32e2138f9bdb', '中南大学', 'A0005', 'cfb8f51e-7988-4023-8dca-b5b3cd15c7a5', '土木工程管理', 'D002');
INSERT INTO `organization_major` VALUES ('1edb42fc-a10b-4f39-a2bc-6c2bcb276547', 'M002', '土木工程', null, '0', '0', '', '2024-01-08 22:39:09', '2024-01-22 16:42:17', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003');
INSERT INTO `organization_major` VALUES ('2511b9d5-72ca-4c9a-a3a4-1540acd90b69', 'M004', '电气工程', null, '0', '0', '测试数据', '2024-01-08 22:39:33', '2024-01-22 16:44:03', '1df5035a-d251-4d19-9045-59a377c123fc', '哈佛大学', 'B0001', 'cfb8f51e-7988-4023-8dca-b5b3cd15c7a5', '土木工程管理', 'D002');
INSERT INTO `organization_major` VALUES ('3e2224bb-3e5f-4556-aea1-6f1a5e4239b5', 'M006', 'A', '', '0', '0', '', '2024-01-22 17:52:53', '2024-01-22 17:53:02', '276be9b7-6737-47b0-9d68-caf3e4c3dadd', '复旦大学', 'A0003', '', '', '');
INSERT INTO `organization_major` VALUES ('5b718983-9508-40f4-aeba-22aad1b55e47', 'M007', '电子信息与科学', '', '0', '0', '', '2024-01-27 15:15:07', null, 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003');
INSERT INTO `organization_major` VALUES ('8e4c4549-760a-44f2-b730-3131f6cc5645', 'M001', '软件工程', null, '0', '0', '', '2024-01-08 22:39:01', '2024-01-22 16:42:25', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003');
INSERT INTO `organization_major` VALUES ('9ead598e-4faf-49e1-9863-165c766631ed', 'M003', '工商管理', null, '0', '0', '', '2024-01-08 22:39:19', '2024-01-22 16:42:06', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003');
-- ----------------------------
-- Table structure for organization_master
-- ----------------------------
DROP TABLE IF EXISTS `organization_master`;
CREATE TABLE `organization_master` (
`id` varchar(64) NOT NULL COMMENT 'id',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`outerphone` varchar(32) DEFAULT NULL,
`innerphone` varchar(32) DEFAULT NULL,
`supervisor` varchar(64) DEFAULT NULL,
`supervisorassistant` varchar(64) DEFAULT NULL,
`fax` varchar(64) DEFAULT NULL,
`zipcode` varchar(32) DEFAULT NULL,
`address` varchar(256) DEFAULT NULL,
`parentid` varchar(64) DEFAULT NULL COMMENT 'parent id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`deplevel` int(3) DEFAULT NULL COMMENT 'department level',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of organization_master
-- ----------------------------
INSERT INTO `organization_master` VALUES ('1df5035a-d251-4d19-9045-59a377c123fc', 'B0001', '哈佛大学', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-06 16:13:25', null);
INSERT INTO `organization_master` VALUES ('276be9b7-6737-47b0-9d68-caf3e4c3dadd', 'A0003', '复旦大学', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-06 16:12:05', null);
INSERT INTO `organization_master` VALUES ('59299abc-06ca-48f2-b026-4638ced717b4', 'A0002', '清华大学', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-06 16:11:47', '2024-01-06 16:12:10');
INSERT INTO `organization_master` VALUES ('cd738fee-5cae-4e2a-b057-32e2138f9bdb', 'A0005', '中南大学', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-06 16:13:07', null);
INSERT INTO `organization_master` VALUES ('e704a3f2-c4b6-4a76-b0fe-d7d8f8b031f5', 'A0004', '上海交通大学', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-06 16:12:29', null);
INSERT INTO `organization_master` VALUES ('fd41d4da-042a-41ed-943b-f8917251e227', 'A0001', '北京大学', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-06 16:09:56', null);
INSERT INTO `organization_master` VALUES ('fd53196d-a456-4801-a524-bbed67104056', 'B0002', '麻省理工大学', null, null, null, null, null, null, null, null, '0', null, '0', '', '2024-01-06 16:13:39', null);
-- ----------------------------
-- Table structure for product_attribute_key
-- ----------------------------
DROP TABLE IF EXISTS `product_attribute_key`;
CREATE TABLE `product_attribute_key` (
`id` varchar(64) NOT NULL COMMENT 'id',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(256) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of product_attribute_key
-- ----------------------------
-- ----------------------------
-- Table structure for product_attribute_value
-- ----------------------------
DROP TABLE IF EXISTS `product_attribute_value`;
CREATE TABLE `product_attribute_value` (
`id` varchar(64) NOT NULL COMMENT 'id',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`value` varchar(256) DEFAULT NULL,
`attribute_id` varchar(256) DEFAULT NULL,
`attribute_name` varchar(256) DEFAULT NULL COMMENT 'key',
`productid` varchar(64) DEFAULT NULL,
`productcode` varchar(128) DEFAULT NULL,
`productname` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of product_attribute_value
-- ----------------------------
-- ----------------------------
-- Table structure for product_brand
-- ----------------------------
DROP TABLE IF EXISTS `product_brand`;
CREATE TABLE `product_brand` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(10) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(256) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
`website` varchar(256) DEFAULT NULL,
`logoimage` varchar(256) DEFAULT NULL,
`description` text,
`foundedyear` date DEFAULT NULL,
`countryoforigin` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of product_brand
-- ----------------------------
-- ----------------------------
-- Table structure for product_category
-- ----------------------------
DROP TABLE IF EXISTS `product_category`;
CREATE TABLE `product_category` (
`id` varchar(64) NOT NULL COMMENT 'id',
`parentid` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of product_category
-- ----------------------------
-- ----------------------------
-- Table structure for product_master
-- ----------------------------
DROP TABLE IF EXISTS `product_master`;
CREATE TABLE `product_master` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(10) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(256) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
`formation` varchar(1024) DEFAULT NULL COMMENT '相关信息',
`buyprice` varchar(256) DEFAULT NULL COMMENT '进货价',
`sellprice` varchar(128) DEFAULT NULL COMMENT '卖价',
`provider` varchar(128) DEFAULT NULL COMMENT '供应商',
`discount` varchar(128) DEFAULT NULL COMMENT '优惠价',
`keyword` varchar(128) DEFAULT NULL,
`count` varchar(1027) DEFAULT NULL COMMENT '数量',
`image` varchar(256) DEFAULT NULL COMMENT '图片',
`size` varchar(128) DEFAULT NULL COMMENT '尺码',
`color` varchar(128) DEFAULT NULL COMMENT '颜色',
`specifications` text,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`brandid` varchar(64) DEFAULT NULL,
`brandname` varchar(256) DEFAULT NULL,
`brandcode` varchar(256) DEFAULT NULL,
`model` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of product_master
-- ----------------------------
-- ----------------------------
-- Table structure for product_supplier
-- ----------------------------
DROP TABLE IF EXISTS `product_supplier`;
CREATE TABLE `product_supplier` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(10) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(256) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
`logo` varchar(256) DEFAULT NULL,
`description` text,
`contactor` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL,
`contactortitle` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL,
`telphone` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '负责人',
`cellphone` varchar(128) DEFAULT NULL,
`website` varchar(256) CHARACTER SET utf8mb4 DEFAULT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`tax` varchar(256) DEFAULT NULL,
`companyaddress` varchar(512) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '省市区',
`registrationaddress` varchar(512) DEFAULT NULL,
`businessscope` varchar(1024) DEFAULT NULL,
`bankname` varchar(256) DEFAULT NULL,
`bankaccount` varchar(256) DEFAULT NULL,
`creditrating` varchar(256) DEFAULT NULL,
`registrationcapital` decimal(18,5) DEFAULT NULL,
`establishmentdate` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of product_supplier
-- ----------------------------
-- ----------------------------
-- Table structure for question_category
-- ----------------------------
DROP TABLE IF EXISTS `question_category`;
CREATE TABLE `question_category` (
`id` varchar(64) NOT NULL COMMENT 'id',
`parentid` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_category
-- ----------------------------
INSERT INTO `question_category` VALUES ('133aaba2-5403-4f46-817c-855908070623', null, '多选题', '0', '', '2024-01-06 15:45:43', null, '0');
INSERT INTO `question_category` VALUES ('249cd5ed-4033-435e-ab3d-cff8fc1cab30', null, '判断题', '0', '', '2024-01-06 15:47:01', null, '0');
INSERT INTO `question_category` VALUES ('4a7ae831-8bf0-4210-a324-a6d78939f858', null, '论述题', '0', '', '2024-01-06 15:47:16', null, '0');
INSERT INTO `question_category` VALUES ('5bd96dfb-0e85-4b03-87d9-cfd131b58580', null, '填空题', '0', '', '2024-01-06 15:46:37', null, '0');
INSERT INTO `question_category` VALUES ('808518fa-aa04-4f05-9556-79117197c6a4', null, '单选题', '0', '', '2024-01-06 15:45:16', null, '0');
INSERT INTO `question_category` VALUES ('9fb78cc5-b7f6-415d-8401-034efa8b17ea', null, '简答题', '0', '', '2024-01-06 15:47:08', null, '0');
INSERT INTO `question_category` VALUES ('a5a92cdc-0299-4dbc-9fe1-4a54ba8eda50', null, '案例分析题', '0', '', '2024-01-06 15:47:41', null, '0');
INSERT INTO `question_category` VALUES ('aa71363b-145f-4d2f-b733-ebcabfa30e73', null, '分析题', '0', '', '2024-01-06 15:47:23', null, '0');
INSERT INTO `question_category` VALUES ('b77502b7-67c0-470d-8d2f-966285ac7734', null, '案例选择题', '0', '', '2024-01-06 15:47:32', null, '0');
INSERT INTO `question_category` VALUES ('b79c879b-f1ac-4118-93d8-f2f8a118fa5f', null, '名词解释', '0', '', '2024-01-06 15:46:53', null, '0');
-- ----------------------------
-- Table structure for question_master
-- ----------------------------
DROP TABLE IF EXISTS `question_master`;
CREATE TABLE `question_master` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`paperid` varchar(64) DEFAULT NULL,
`papername` varchar(256) DEFAULT NULL,
`papercode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`stem` text,
`answer` text,
`casebody` text,
`analysis` text,
`level` int(10) DEFAULT NULL,
`score` decimal(18,5) DEFAULT NULL,
`optiona` varchar(256) DEFAULT NULL,
`optionb` varchar(256) DEFAULT NULL,
`optionc` varchar(256) DEFAULT NULL,
`optiond` varchar(256) DEFAULT NULL,
`optione` varchar(256) DEFAULT NULL,
`optionf` varchar(256) DEFAULT NULL,
`optiong` varchar(256) DEFAULT NULL,
`optionh` varchar(256) DEFAULT NULL,
`knowledgepointid` varchar(64) DEFAULT NULL,
`knowledgepointname` varchar(256) DEFAULT NULL,
`knowledgepointcode` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_master
-- ----------------------------
INSERT INTO `question_master` VALUES ('03891fb4-0ec8-4d2c-8822-187879a778bc', '0', '0', '', '2024-02-02 14:31:00', '2024-02-02 16:51:15', 'Q0000006', '单选1', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第一题
A 1
B 2
C 3
D 4
', 'B
', null, 'xxxadwawdawd
', '0', null, '', '', '', '', '', '', '', '', null, null, null);
INSERT INTO `question_master` VALUES ('56e600e5-b44d-49de-9795-14344351ddfb', '0', '0', '', '2024-01-08 22:38:27', '2024-01-26 11:28:17', 'Q0000005', '0555', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '4a7ae831-8bf0-4210-a324-a6d78939f858', '论述题', '
', '
', null, '
', '4', '10.00000', null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master` VALUES ('586159ee-938f-4a08-a16e-1dd569598eb2', '0', '0', '', '2024-02-02 14:31:37', '2024-02-06 18:16:58', 'Q0000007', '单选2', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第二题
A 1
B 2
C 3
D 4
', 'A
', null, 'd4w5a6d4564
', '3', '1.00000', '', '', '', '', '', '', '', '', 'f3c11f2c-a78f-4713-9da4-1597684a092d', '动量', null);
INSERT INTO `question_master` VALUES ('81fe2e08-804b-454d-8143-f270cb2914f4', '0', '0', '', '2024-01-08 22:38:14', '2024-01-26 11:08:09', 'Q0000003', '0333', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', 'C
', null, '
', null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master` VALUES ('88c74aef-f20b-4b09-b356-481a43ceec61', '0', '0', '', '2024-01-08 22:38:05', '2024-01-26 10:43:56', 'Q0000002', '0222', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', '
', null, '
', '0', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master` VALUES ('b5b0ba85-7471-4eb8-aedd-add3856887c7', '0', '0', '', '2024-01-08 22:37:59', '2024-01-22 18:54:37', 'Q0000001', '0111', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '133aaba2-5403-4f46-817c-855908070623', '多选题', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master` VALUES ('fd154665-c484-4842-a487-931063a844b0', '0', '0', '', '2024-01-08 22:38:21', '2024-01-22 18:54:43', 'Q0000004', '0444', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '5bd96dfb-0e85-4b03-87d9-cfd131b58580', '填空题', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for question_master_blank_filling
-- ----------------------------
DROP TABLE IF EXISTS `question_master_blank_filling`;
CREATE TABLE `question_master_blank_filling` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`paperid` varchar(64) DEFAULT NULL,
`papername` varchar(256) DEFAULT NULL,
`papercode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`stem` text,
`answer` text,
`casebody` text,
`analysis` text,
`level` int(10) DEFAULT NULL,
`score` decimal(18,5) DEFAULT NULL,
`optiona` varchar(256) DEFAULT NULL,
`optionb` varchar(256) DEFAULT NULL,
`optionc` varchar(256) DEFAULT NULL,
`optiond` varchar(256) DEFAULT NULL,
`optione` varchar(256) DEFAULT NULL,
`optionf` varchar(256) DEFAULT NULL,
`optiong` varchar(256) DEFAULT NULL,
`optionh` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_master_blank_filling
-- ----------------------------
INSERT INTO `question_master_blank_filling` VALUES ('03891fb4-0ec8-4d2c-8822-187879a778bc', '0', '0', '', '2024-02-02 14:31:00', '2024-02-02 16:51:15', 'Q0000006', '单选1', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第一题
A 1
B 2
C 3
D 4
', 'B
', null, 'xxxadwawdawd
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_blank_filling` VALUES ('56e600e5-b44d-49de-9795-14344351ddfb', '0', '0', '', '2024-01-08 22:38:27', '2024-01-26 11:28:17', 'Q0000005', '0555', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '4a7ae831-8bf0-4210-a324-a6d78939f858', '论述题', '
', '
', null, '
', '4', '10.00000', null, null, null, null, null, null, null, null);
INSERT INTO `question_master_blank_filling` VALUES ('586159ee-938f-4a08-a16e-1dd569598eb2', '0', '0', '', '2024-02-02 14:31:37', '2024-02-02 16:51:03', 'Q0000007', '单选2', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第二题
A 1
B 2
C 3
D 4
', 'A
', null, 'd4w5a6d4564
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_blank_filling` VALUES ('81fe2e08-804b-454d-8143-f270cb2914f4', '0', '0', '', '2024-01-08 22:38:14', '2024-01-26 11:08:09', 'Q0000003', '0333', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', 'C
', null, '
', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_blank_filling` VALUES ('88c74aef-f20b-4b09-b356-481a43ceec61', '0', '0', '', '2024-01-08 22:38:05', '2024-01-26 10:43:56', 'Q0000002', '0222', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', '
', null, '
', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_blank_filling` VALUES ('b5b0ba85-7471-4eb8-aedd-add3856887c7', '0', '0', '', '2024-01-08 22:37:59', '2024-01-22 18:54:37', 'Q0000001', '0111', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '133aaba2-5403-4f46-817c-855908070623', '多选题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_blank_filling` VALUES ('fd154665-c484-4842-a487-931063a844b0', '0', '0', '', '2024-01-08 22:38:21', '2024-01-22 18:54:43', 'Q0000004', '0444', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '5bd96dfb-0e85-4b03-87d9-cfd131b58580', '填空题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for question_master_case_analysis
-- ----------------------------
DROP TABLE IF EXISTS `question_master_case_analysis`;
CREATE TABLE `question_master_case_analysis` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`paperid` varchar(64) DEFAULT NULL,
`papername` varchar(256) DEFAULT NULL,
`papercode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`stem` text,
`answer` text,
`casebody` text,
`analysis` text,
`level` int(10) DEFAULT NULL,
`score` decimal(18,5) DEFAULT NULL,
`optiona` varchar(256) DEFAULT NULL,
`optionb` varchar(256) DEFAULT NULL,
`optionc` varchar(256) DEFAULT NULL,
`optiond` varchar(256) DEFAULT NULL,
`optione` varchar(256) DEFAULT NULL,
`optionf` varchar(256) DEFAULT NULL,
`optiong` varchar(256) DEFAULT NULL,
`optionh` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_master_case_analysis
-- ----------------------------
INSERT INTO `question_master_case_analysis` VALUES ('03891fb4-0ec8-4d2c-8822-187879a778bc', '0', '0', '', '2024-02-02 14:31:00', '2024-02-02 16:51:15', 'Q0000006', '单选1', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第一题
A 1
B 2
C 3
D 4
', 'B
', null, 'xxxadwawdawd
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_case_analysis` VALUES ('56e600e5-b44d-49de-9795-14344351ddfb', '0', '0', '', '2024-01-08 22:38:27', '2024-01-26 11:28:17', 'Q0000005', '0555', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '4a7ae831-8bf0-4210-a324-a6d78939f858', '论述题', '
', '
', null, '
', '4', '10.00000', null, null, null, null, null, null, null, null);
INSERT INTO `question_master_case_analysis` VALUES ('586159ee-938f-4a08-a16e-1dd569598eb2', '0', '0', '', '2024-02-02 14:31:37', '2024-02-02 16:51:03', 'Q0000007', '单选2', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第二题
A 1
B 2
C 3
D 4
', 'A
', null, 'd4w5a6d4564
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_case_analysis` VALUES ('81fe2e08-804b-454d-8143-f270cb2914f4', '0', '0', '', '2024-01-08 22:38:14', '2024-01-26 11:08:09', 'Q0000003', '0333', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', 'C
', null, '
', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_case_analysis` VALUES ('88c74aef-f20b-4b09-b356-481a43ceec61', '0', '0', '', '2024-01-08 22:38:05', '2024-01-26 10:43:56', 'Q0000002', '0222', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', '
', null, '
', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_case_analysis` VALUES ('b5b0ba85-7471-4eb8-aedd-add3856887c7', '0', '0', '', '2024-01-08 22:37:59', '2024-01-22 18:54:37', 'Q0000001', '0111', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '133aaba2-5403-4f46-817c-855908070623', '多选题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_case_analysis` VALUES ('fd154665-c484-4842-a487-931063a844b0', '0', '0', '', '2024-01-08 22:38:21', '2024-01-22 18:54:43', 'Q0000004', '0444', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '5bd96dfb-0e85-4b03-87d9-cfd131b58580', '填空题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for question_master_choice
-- ----------------------------
DROP TABLE IF EXISTS `question_master_choice`;
CREATE TABLE `question_master_choice` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`paperid` varchar(64) DEFAULT NULL,
`papername` varchar(256) DEFAULT NULL,
`papercode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`stem` text,
`answer` text,
`casebody` text,
`analysis` text,
`level` int(10) DEFAULT NULL,
`score` decimal(18,5) DEFAULT NULL,
`optiona` varchar(256) DEFAULT NULL,
`optionb` varchar(256) DEFAULT NULL,
`optionc` varchar(256) DEFAULT NULL,
`optiond` varchar(256) DEFAULT NULL,
`optione` varchar(256) DEFAULT NULL,
`optionf` varchar(256) DEFAULT NULL,
`optiong` varchar(256) DEFAULT NULL,
`optionh` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_master_choice
-- ----------------------------
INSERT INTO `question_master_choice` VALUES ('03891fb4-0ec8-4d2c-8822-187879a778bc', '0', '0', '', '2024-02-02 14:31:00', '2024-02-02 16:51:15', 'Q0000006', '单选1', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第一题
A 1
B 2
C 3
D 4
', 'B
', null, 'xxxadwawdawd
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_choice` VALUES ('56e600e5-b44d-49de-9795-14344351ddfb', '0', '0', '', '2024-01-08 22:38:27', '2024-01-26 11:28:17', 'Q0000005', '0555', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '4a7ae831-8bf0-4210-a324-a6d78939f858', '论述题', '
', '
', null, '
', '4', '10.00000', null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice` VALUES ('586159ee-938f-4a08-a16e-1dd569598eb2', '0', '0', '', '2024-02-02 14:31:37', '2024-02-02 16:51:03', 'Q0000007', '单选2', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第二题
A 1
B 2
C 3
D 4
', 'A
', null, 'd4w5a6d4564
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_choice` VALUES ('81fe2e08-804b-454d-8143-f270cb2914f4', '0', '0', '', '2024-01-08 22:38:14', '2024-01-26 11:08:09', 'Q0000003', '0333', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', 'C
', null, '
', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice` VALUES ('88c74aef-f20b-4b09-b356-481a43ceec61', '0', '0', '', '2024-01-08 22:38:05', '2024-01-26 10:43:56', 'Q0000002', '0222', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', '
', null, '
', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice` VALUES ('b5b0ba85-7471-4eb8-aedd-add3856887c7', '0', '0', '', '2024-01-08 22:37:59', '2024-01-22 18:54:37', 'Q0000001', '0111', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '133aaba2-5403-4f46-817c-855908070623', '多选题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice` VALUES ('fd154665-c484-4842-a487-931063a844b0', '0', '0', '', '2024-01-08 22:38:21', '2024-01-22 18:54:43', 'Q0000004', '0444', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '5bd96dfb-0e85-4b03-87d9-cfd131b58580', '填空题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for question_master_choice_multiple
-- ----------------------------
DROP TABLE IF EXISTS `question_master_choice_multiple`;
CREATE TABLE `question_master_choice_multiple` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`paperid` varchar(64) DEFAULT NULL,
`papername` varchar(256) DEFAULT NULL,
`papercode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`stem` text,
`answer` text,
`casebody` text,
`analysis` text,
`level` int(10) DEFAULT NULL,
`score` decimal(18,5) DEFAULT NULL,
`optiona` varchar(256) DEFAULT NULL,
`optionb` varchar(256) DEFAULT NULL,
`optionc` varchar(256) DEFAULT NULL,
`optiond` varchar(256) DEFAULT NULL,
`optione` varchar(256) DEFAULT NULL,
`optionf` varchar(256) DEFAULT NULL,
`optiong` varchar(256) DEFAULT NULL,
`optionh` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_master_choice_multiple
-- ----------------------------
INSERT INTO `question_master_choice_multiple` VALUES ('03891fb4-0ec8-4d2c-8822-187879a778bc', '0', '0', '', '2024-02-02 14:31:00', '2024-02-02 16:51:15', 'Q0000006', '单选1', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第一题
A 1
B 2
C 3
D 4
', 'B
', null, 'xxxadwawdawd
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_choice_multiple` VALUES ('56e600e5-b44d-49de-9795-14344351ddfb', '0', '0', '', '2024-01-08 22:38:27', '2024-01-26 11:28:17', 'Q0000005', '0555', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '4a7ae831-8bf0-4210-a324-a6d78939f858', '论述题', '
', '
', null, '
', '4', '10.00000', null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice_multiple` VALUES ('586159ee-938f-4a08-a16e-1dd569598eb2', '0', '0', '', '2024-02-02 14:31:37', '2024-02-02 16:51:03', 'Q0000007', '单选2', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第二题
A 1
B 2
C 3
D 4
', 'A
', null, 'd4w5a6d4564
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_choice_multiple` VALUES ('81fe2e08-804b-454d-8143-f270cb2914f4', '0', '0', '', '2024-01-08 22:38:14', '2024-01-26 11:08:09', 'Q0000003', '0333', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', 'C
', null, '
', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice_multiple` VALUES ('88c74aef-f20b-4b09-b356-481a43ceec61', '0', '0', '', '2024-01-08 22:38:05', '2024-01-26 10:43:56', 'Q0000002', '0222', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', '
', null, '
', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice_multiple` VALUES ('b5b0ba85-7471-4eb8-aedd-add3856887c7', '0', '0', '', '2024-01-08 22:37:59', '2024-01-22 18:54:37', 'Q0000001', '0111', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '133aaba2-5403-4f46-817c-855908070623', '多选题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_choice_multiple` VALUES ('fd154665-c484-4842-a487-931063a844b0', '0', '0', '', '2024-01-08 22:38:21', '2024-01-22 18:54:43', 'Q0000004', '0444', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '5bd96dfb-0e85-4b03-87d9-cfd131b58580', '填空题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for question_master_judge
-- ----------------------------
DROP TABLE IF EXISTS `question_master_judge`;
CREATE TABLE `question_master_judge` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`paperid` varchar(64) DEFAULT NULL,
`papername` varchar(256) DEFAULT NULL,
`papercode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`stem` text,
`answer` text,
`casebody` text,
`analysis` text,
`level` int(10) DEFAULT NULL,
`score` decimal(18,5) DEFAULT NULL,
`optiona` varchar(256) DEFAULT NULL,
`optionb` varchar(256) DEFAULT NULL,
`optionc` varchar(256) DEFAULT NULL,
`optiond` varchar(256) DEFAULT NULL,
`optione` varchar(256) DEFAULT NULL,
`optionf` varchar(256) DEFAULT NULL,
`optiong` varchar(256) DEFAULT NULL,
`optionh` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_master_judge
-- ----------------------------
INSERT INTO `question_master_judge` VALUES ('03891fb4-0ec8-4d2c-8822-187879a778bc', '0', '0', '', '2024-02-02 14:31:00', '2024-02-02 16:51:15', 'Q0000006', '单选1', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第一题
A 1
B 2
C 3
D 4
', 'B
', null, 'xxxadwawdawd
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_judge` VALUES ('56e600e5-b44d-49de-9795-14344351ddfb', '0', '0', '', '2024-01-08 22:38:27', '2024-01-26 11:28:17', 'Q0000005', '0555', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '4a7ae831-8bf0-4210-a324-a6d78939f858', '论述题', '
', '
', null, '
', '4', '10.00000', null, null, null, null, null, null, null, null);
INSERT INTO `question_master_judge` VALUES ('586159ee-938f-4a08-a16e-1dd569598eb2', '0', '0', '', '2024-02-02 14:31:37', '2024-02-02 16:51:03', 'Q0000007', '单选2', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第二题
A 1
B 2
C 3
D 4
', 'A
', null, 'd4w5a6d4564
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_judge` VALUES ('81fe2e08-804b-454d-8143-f270cb2914f4', '0', '0', '', '2024-01-08 22:38:14', '2024-01-26 11:08:09', 'Q0000003', '0333', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', 'C
', null, '
', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_judge` VALUES ('88c74aef-f20b-4b09-b356-481a43ceec61', '0', '0', '', '2024-01-08 22:38:05', '2024-01-26 10:43:56', 'Q0000002', '0222', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', '
', null, '
', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_judge` VALUES ('b5b0ba85-7471-4eb8-aedd-add3856887c7', '0', '0', '', '2024-01-08 22:37:59', '2024-01-22 18:54:37', 'Q0000001', '0111', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '133aaba2-5403-4f46-817c-855908070623', '多选题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_judge` VALUES ('fd154665-c484-4842-a487-931063a844b0', '0', '0', '', '2024-01-08 22:38:21', '2024-01-22 18:54:43', 'Q0000004', '0444', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '5bd96dfb-0e85-4b03-87d9-cfd131b58580', '填空题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for question_master_translate
-- ----------------------------
DROP TABLE IF EXISTS `question_master_translate`;
CREATE TABLE `question_master_translate` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`paperid` varchar(64) DEFAULT NULL,
`papername` varchar(256) DEFAULT NULL,
`papercode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`stem` text,
`answer` text,
`casebody` text,
`analysis` text,
`level` int(10) DEFAULT NULL,
`score` decimal(18,5) DEFAULT NULL,
`optiona` varchar(256) DEFAULT NULL,
`optionb` varchar(256) DEFAULT NULL,
`optionc` varchar(256) DEFAULT NULL,
`optiond` varchar(256) DEFAULT NULL,
`optione` varchar(256) DEFAULT NULL,
`optionf` varchar(256) DEFAULT NULL,
`optiong` varchar(256) DEFAULT NULL,
`optionh` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_master_translate
-- ----------------------------
INSERT INTO `question_master_translate` VALUES ('03891fb4-0ec8-4d2c-8822-187879a778bc', '0', '0', '', '2024-02-02 14:31:00', '2024-02-02 16:51:15', 'Q0000006', '单选1', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第一题
A 1
B 2
C 3
D 4
', 'B
', null, 'xxxadwawdawd
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_translate` VALUES ('56e600e5-b44d-49de-9795-14344351ddfb', '0', '0', '', '2024-01-08 22:38:27', '2024-01-26 11:28:17', 'Q0000005', '0555', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '4a7ae831-8bf0-4210-a324-a6d78939f858', '论述题', '
', '
', null, '
', '4', '10.00000', null, null, null, null, null, null, null, null);
INSERT INTO `question_master_translate` VALUES ('586159ee-938f-4a08-a16e-1dd569598eb2', '0', '0', '', '2024-02-02 14:31:37', '2024-02-02 16:51:03', 'Q0000007', '单选2', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '808518fa-aa04-4f05-9556-79117197c6a4', '单选题', '1+1=？第二题
A 1
B 2
C 3
D 4
', 'A
', null, 'd4w5a6d4564
', '0', null, '', '', '', '', '', '', '', '');
INSERT INTO `question_master_translate` VALUES ('81fe2e08-804b-454d-8143-f270cb2914f4', '0', '0', '', '2024-01-08 22:38:14', '2024-01-26 11:08:09', 'Q0000003', '0333', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', 'C
', null, '
', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_translate` VALUES ('88c74aef-f20b-4b09-b356-481a43ceec61', '0', '0', '', '2024-01-08 22:38:05', '2024-01-26 10:43:56', 'Q0000002', '0222', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '9fb78cc5-b7f6-415d-8401-034efa8b17ea', '简答题', '
', '
', null, '
', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_translate` VALUES ('b5b0ba85-7471-4eb8-aedd-add3856887c7', '0', '0', '', '2024-01-08 22:37:59', '2024-01-22 18:54:37', 'Q0000001', '0111', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '133aaba2-5403-4f46-817c-855908070623', '多选题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `question_master_translate` VALUES ('fd154665-c484-4842-a487-931063a844b0', '0', '0', '', '2024-01-08 22:38:21', '2024-01-22 18:54:43', 'Q0000004', '0444', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', '99cb7d08-314b-49d3-92f1-14e87ddd8af8', null, null, '5bd96dfb-0e85-4b03-87d9-cfd131b58580', '填空题', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for question_paper
-- ----------------------------
DROP TABLE IF EXISTS `question_paper`;
CREATE TABLE `question_paper` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
`categoryid` varchar(64) DEFAULT NULL,
`categoryname` varchar(256) DEFAULT NULL,
`price` decimal(18,5) DEFAULT NULL,
`type` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_paper
-- ----------------------------
INSERT INTO `question_paper` VALUES ('3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', '0', '0', '', '2024-01-18 09:42:41', '2024-01-26 11:07:57', 'P0000003', '实训答辩', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '5d922a9a-132d-4df4-94b6-e977533fa88f', '专项练习', '0.10000', '2');
INSERT INTO `question_paper` VALUES ('99cb7d08-314b-49d3-92f1-14e87ddd8af8', '0', '0', '', '2024-01-08 22:42:17', '2024-01-22 19:28:32', 'P0000002', '期末复习', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '5d922a9a-132d-4df4-94b6-e977533fa88f', '专项练习', '0.00000', '1');
INSERT INTO `question_paper` VALUES ('afa74a91-92ca-48b4-9a21-bd8bb57a75fc', '0', '0', '', '2024-01-08 22:32:18', '2024-01-22 19:29:31', 'P0000001', '2024 期中考试', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001', 'ffd099a0-2ff1-487d-8a72-f30f1b60d303', '2024年度考试', '0.00000', '0');
INSERT INTO `question_paper` VALUES ('b17b5358-0632-463c-ac12-eb94cdee130d', '0', '0', '', '2024-01-31 15:16:25', null, 'P0000004', 'aaa', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003', '5d922a9a-132d-4df4-94b6-e977533fa88f', '专项练习', '0.00000', '0');
INSERT INTO `question_paper` VALUES ('d6a17cd6-d89a-4592-ab8d-d68c45084a5c', '0', '0', '', '2024-02-02 17:30:50', null, 'P0000005', '发的地方', 'a727fc6f-b706-416a-ab61-a0854c049c0f', '高等数学二', 'S0000005', 'ad9da6a5-682b-4e81-b1e1-9163fa0f6cce', '能力测验', '0.00000', '0');
-- ----------------------------
-- Table structure for question_paper_category
-- ----------------------------
DROP TABLE IF EXISTS `question_paper_category`;
CREATE TABLE `question_paper_category` (
`id` varchar(64) NOT NULL COMMENT 'id',
`parentid` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_paper_category
-- ----------------------------
INSERT INTO `question_paper_category` VALUES ('33b0354e-6c94-4643-b977-5d6f82b84e14', 'ffd099a0-2ff1-487d-8a72-f30f1b60d303', '期中考试', '0', '', '2024-01-06 16:14:34', '2024-01-06 16:15:05', '0');
INSERT INTO `question_paper_category` VALUES ('5d922a9a-132d-4df4-94b6-e977533fa88f', null, '专项练习', '0', '', '2024-01-06 16:15:42', null, '0');
INSERT INTO `question_paper_category` VALUES ('74b5bfdb-10d4-488b-98a4-9b41e4238742', 'ffd099a0-2ff1-487d-8a72-f30f1b60d303', '期末考试', '0', '', '2024-01-06 16:14:43', '2024-01-06 16:15:10', '0');
INSERT INTO `question_paper_category` VALUES ('ad9da6a5-682b-4e81-b1e1-9163fa0f6cce', null, '能力测验', '0', '', '2024-01-06 16:15:28', null, '0');
INSERT INTO `question_paper_category` VALUES ('ffd099a0-2ff1-487d-8a72-f30f1b60d303', null, '2024年度考试', '0', '', '2024-01-06 16:14:59', null, '0');
-- ----------------------------
-- Table structure for question_subject
-- ----------------------------
DROP TABLE IF EXISTS `question_subject`;
CREATE TABLE `question_subject` (
`id` varchar(64) NOT NULL COMMENT 'id',
`status` int(1) DEFAULT NULL COMMENT 'enabled',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`gradeid` varchar(64) DEFAULT NULL,
`gradename` varchar(256) DEFAULT NULL,
`gradecode` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_subject
-- ----------------------------
INSERT INTO `question_subject` VALUES ('5c69046c-9f0c-4356-877e-6f2afed2c45e', '0', '0', '', '2024-01-06 16:08:53', null, '10003', '物理', null, null, null);
INSERT INTO `question_subject` VALUES ('9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '0', '0', '', '2024-01-06 16:08:32', null, '10002', '英语', null, null, null);
INSERT INTO `question_subject` VALUES ('a727fc6f-b706-416a-ab61-a0854c049c0f', '0', '0', '', '2024-01-30 16:05:19', null, 'S0000005', '高等数学二', null, null, null);
INSERT INTO `question_subject` VALUES ('b9b21d1f-aafd-41a3-84bc-87d7c9f28c75', '0', '0', '', '2024-01-30 16:05:12', null, 'S0000004', '高等数学一', null, null, null);
INSERT INTO `question_subject` VALUES ('f998cc25-32c6-44aa-8869-7545b8347e4d', '0', '0', '', '2024-01-06 15:48:11', '2024-01-06 16:01:49', '10001', '数学', null, null, null);
-- ----------------------------
-- Table structure for question_subject_grade_relation
-- ----------------------------
DROP TABLE IF EXISTS `question_subject_grade_relation`;
CREATE TABLE `question_subject_grade_relation` (
`id` varchar(64) NOT NULL,
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`status` int(11) DEFAULT NULL,
`actionby` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`gradeid` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`gradename` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`gradecode` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`subjectid` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
`subjectname` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`subjectcode` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of question_subject_grade_relation
-- ----------------------------
INSERT INTO `question_subject_grade_relation` VALUES ('25ddf0a6-d672-48fe-8068-cc16e4383ae0', '2024-02-05 15:04:39', null, null, null, '0', '13d2cbb0-6aaf-41dd-ba44-18650e3268b7', 'G009', '一年级', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001');
INSERT INTO `question_subject_grade_relation` VALUES ('27cf029f-1039-48a9-b7d7-ae0c2c9bdce6', '2024-02-08 11:10:51', null, null, null, '0', '094cef8e-7328-4ca8-8c36-889978bbdcdb', 'G001', '一年级', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002');
INSERT INTO `question_subject_grade_relation` VALUES ('2b7b7284-9fed-4b98-bcc7-29368dbb991b', '2024-02-05 15:04:29', null, null, null, '0', '13d2cbb0-6aaf-41dd-ba44-18650e3268b7', 'G009', '一年级', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002');
INSERT INTO `question_subject_grade_relation` VALUES ('318eac06-f74e-429c-945b-2d9ce99593ff', '2024-02-08 11:10:35', null, null, null, '0', '93bd9f0e-b05c-454d-8dcb-758a35ad804f', 'G006', '六年级', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_grade_relation` VALUES ('3a78de10-efbf-4172-ba41-a5d22a648d80', '2024-02-05 15:05:38', null, null, null, '0', '13d2cbb0-6aaf-41dd-ba44-18650e3268b7', 'G009', '一年级', 'a727fc6f-b706-416a-ab61-a0854c049c0f', '高等数学二', 'S0000005');
INSERT INTO `question_subject_grade_relation` VALUES ('49060c42-c2f9-4638-a3e1-2359257536fb', '2024-02-08 11:10:51', null, null, null, '0', '094cef8e-7328-4ca8-8c36-889978bbdcdb', 'G001', '一年级', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_grade_relation` VALUES ('4bc73cb2-7cfa-4c1b-8fc0-0e7c71e61a56', '2024-02-08 11:10:35', null, null, null, '0', '93bd9f0e-b05c-454d-8dcb-758a35ad804f', 'G006', '六年级', '9983c5b9-1ad1-408d-b8e1-4d1c9b46f9fd', '英语', '10002');
INSERT INTO `question_subject_grade_relation` VALUES ('523dfb7c-9be7-4bef-a4ce-336bd8c4804c', '2024-02-08 11:10:51', null, null, null, '0', '094cef8e-7328-4ca8-8c36-889978bbdcdb', 'G001', '一年级', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001');
INSERT INTO `question_subject_grade_relation` VALUES ('59dd7a9d-d72f-410e-95d5-819340bdfc8c', '2024-02-08 11:10:35', null, null, null, '0', '93bd9f0e-b05c-454d-8dcb-758a35ad804f', 'G006', '六年级', 'f998cc25-32c6-44aa-8869-7545b8347e4d', '数学', '10001');
INSERT INTO `question_subject_grade_relation` VALUES ('5f0fbc51-8f0d-4664-afe3-3845033ff097', '2024-02-08 11:10:35', null, null, null, '0', '93bd9f0e-b05c-454d-8dcb-758a35ad804f', 'G006', '六年级', 'a727fc6f-b706-416a-ab61-a0854c049c0f', '高等数学二', 'S0000005');
INSERT INTO `question_subject_grade_relation` VALUES ('c359236d-2fcb-46cd-987d-39dc6f49706d', '2024-02-05 15:04:29', null, null, null, '0', '13d2cbb0-6aaf-41dd-ba44-18650e3268b7', 'G009', '一年级', 'b9b21d1f-aafd-41a3-84bc-87d7c9f28c75', '高等数学一', 'S0000004');
INSERT INTO `question_subject_grade_relation` VALUES ('cb04ad2c-b4ae-4046-b754-ad89a01c0f49', '2024-02-08 11:10:35', null, null, null, '0', '93bd9f0e-b05c-454d-8dcb-758a35ad804f', 'G006', '六年级', 'b9b21d1f-aafd-41a3-84bc-87d7c9f28c75', '高等数学一', 'S0000004');
INSERT INTO `question_subject_grade_relation` VALUES ('ee6de222-de5d-45b4-a705-e5aa3abc219f', '2024-02-05 15:04:29', null, null, null, '0', '13d2cbb0-6aaf-41dd-ba44-18650e3268b7', 'G009', '一年级', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
-- ----------------------------
-- Table structure for question_subject_knowledge_point
-- ----------------------------
DROP TABLE IF EXISTS `question_subject_knowledge_point`;
CREATE TABLE `question_subject_knowledge_point` (
`id` varchar(64) NOT NULL COMMENT 'id',
`parentid` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'key',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`status` int(11) DEFAULT NULL,
`subjectid` varchar(64) DEFAULT NULL,
`subjectname` varchar(256) DEFAULT NULL,
`subjectcode` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of question_subject_knowledge_point
-- ----------------------------
INSERT INTO `question_subject_knowledge_point` VALUES ('012064ca-855f-4eff-9baf-e97e29388201', 'fe9589be-e23f-43d4-914d-1bb6face3765', '2 固体、液体和气体', '0', '', '2024-01-26 16:48:50', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('068bb84a-1b40-4d4d-9dda-4b82d0a70b40', '956bb085-6aca-442d-a584-63098d7eb238', '机械能', '0', '', '2024-01-26 16:42:57', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('350d9a11-de87-4fb6-955c-534a1a15194d', '956bb085-6aca-442d-a584-63098d7eb238', '曲线运动、万有引力', '0', '', '2024-01-26 16:38:44', '2024-01-26 16:38:56', '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('38811053-0481-4910-a427-846e0befe186', '956bb085-6aca-442d-a584-63098d7eb238', '机械波', '0', '', '2024-01-26 16:43:17', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('8d8262cd-e382-4c30-ab66-7d8d221c8c63', '956bb085-6aca-442d-a584-63098d7eb238', '相互作用、力与机械', '0', '', '2024-01-26 16:30:29', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('956bb085-6aca-442d-a584-63098d7eb238', null, '第一章 力学', '0', '', '2024-01-26 15:57:24', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('b5acfe90-3b41-42c2-a7ab-98f7a77f5b95', '956bb085-6aca-442d-a584-63098d7eb238', '牛顿运动定律', '0', '', '2024-01-26 16:30:37', '2024-01-26 16:38:21', '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('ce7961be-073d-42ae-89ef-9c18d6e32ce9', '956bb085-6aca-442d-a584-63098d7eb238', '机械振动', '0', '', '2024-01-26 16:43:05', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('d2c08b0a-c02b-4163-9647-a95913a3e795', 'fe9589be-e23f-43d4-914d-1bb6face3765', '1 分子热运动和热机', '0', '', '2024-01-26 16:48:44', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('f2197bdb-b7be-4b59-b6e1-039c7d60127b', '956bb085-6aca-442d-a584-63098d7eb238', '运动的描述', '0', '', '2024-01-26 16:17:29', '2024-01-26 16:27:42', '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('f3c11f2c-a78f-4713-9da4-1597684a092d', '956bb085-6aca-442d-a584-63098d7eb238', '动量', '0', '', '2024-01-26 16:39:05', '2024-01-26 16:40:13', '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
INSERT INTO `question_subject_knowledge_point` VALUES ('fe9589be-e23f-43d4-914d-1bb6face3765', '', '第二章 热学', '0', '', '2024-01-26 16:47:44', null, '0', '5c69046c-9f0c-4356-877e-6f2afed2c45e', '物理', '10003');
-- ----------------------------
-- Table structure for shopping_cart
-- ----------------------------
DROP TABLE IF EXISTS `shopping_cart`;
CREATE TABLE `shopping_cart` (
`id` varchar(64) NOT NULL COMMENT '购物车ID',
`code` varchar(64) DEFAULT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`vipuserId` varchar(64) DEFAULT NULL COMMENT '会员ID',
`vipname` varchar(128) DEFAULT NULL COMMENT '会员名称',
`vipphone` varchar(32) DEFAULT NULL COMMENT '会员联系电话',
`vipdiamondtype` int(11) DEFAULT NULL COMMENT '会员等级',
`viptype` int(11) DEFAULT NULL COMMENT '会员类型',
`vippicture` varchar(1024) DEFAULT NULL COMMENT '会员肖像',
`vipcarddiscountrate` decimal(18,5) DEFAULT NULL COMMENT '会员卡折扣率',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_cart
-- ----------------------------
INSERT INTO `shopping_cart` VALUES ('b942adf2-53d1-4fcc-b1e6-10345e7f6489', 'C0000001', '0', null, '2024-01-08 21:28:00', '2024-01-08 21:28:48', 'b23ee1ba-3b67-11eb-8afe-00163e033152', null, null, null, null, null, null);
-- ----------------------------
-- Table structure for shopping_cart_product
-- ----------------------------
DROP TABLE IF EXISTS `shopping_cart_product`;
CREATE TABLE `shopping_cart_product` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`productid` varchar(64) DEFAULT NULL COMMENT '产品ID',
`productcode` varchar(64) DEFAULT NULL COMMENT '产品编号',
`productname` varchar(256) DEFAULT NULL COMMENT '产品名称',
`status` int(11) DEFAULT NULL COMMENT '状态',
`color` varchar(32) DEFAULT NULL COMMENT '颜色',
`size` varchar(32) DEFAULT NULL COMMENT '尺码',
`count` int(11) DEFAULT NULL COMMENT '数量',
`image` varchar(256) DEFAULT NULL COMMENT '产品图片',
`price` decimal(18,5) DEFAULT NULL COMMENT '产品原价',
`saleprice` decimal(18,5) DEFAULT NULL COMMENT '售价',
`cartid` varchar(64) DEFAULT NULL,
`cartcode` varchar(128) DEFAULT NULL COMMENT '订单编号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_cart_product
-- ----------------------------
-- ----------------------------
-- Table structure for system_audittrail
-- ----------------------------
DROP TABLE IF EXISTS `system_audittrail`;
CREATE TABLE `system_audittrail` (
`id` varchar(64) NOT NULL COMMENT 'id',
`message` varchar(1024) DEFAULT NULL,
`actionby` varchar(256) DEFAULT NULL COMMENT 'action by some user',
`actiontype` varchar(256) DEFAULT NULL COMMENT 'action type: create, update, delete, query',
`actionip` varchar(256) DEFAULT NULL COMMENT 'action computer ip',
`actiontime` datetime DEFAULT NULL COMMENT 'action time',
`module` varchar(256) DEFAULT NULL COMMENT 'module',
`beforetarget` varchar(1024) DEFAULT NULL COMMENT 'before target',
`aftertarget` varchar(1024) DEFAULT NULL COMMENT 'after target',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of system_audittrail
-- ----------------------------
INSERT INTO `system_audittrail` VALUES ('02cc6e21-d349-4138-8b5f-02bed4b0bf48', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 19:26:34', 'Security', null, null, '0', null, '2024-02-18 19:26:34', null);
INSERT INTO `system_audittrail` VALUES ('03a37e73-a67c-4610-a344-bc9432e71f43', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 16:55:42', 'Security', null, null, '0', null, '2024-01-27 16:55:42', null);
INSERT INTO `system_audittrail` VALUES ('0404c953-8ba3-4920-88b8-3049d415e63d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 10:51:28', 'Security', null, null, '0', null, '2024-01-26 10:51:28', null);
INSERT INTO `system_audittrail` VALUES ('06418cc6-2907-443f-b728-f1c315613326', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:09:10', 'Security', null, null, '0', null, '2024-02-02 13:09:10', null);
INSERT INTO `system_audittrail` VALUES ('0a31b543-f9ef-435b-90e7-4f27f59b0e34', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 15:08:03', 'Security', null, null, '0', null, '2024-02-02 15:08:03', null);
INSERT INTO `system_audittrail` VALUES ('0a550b23-cdd5-4859-9e0a-1c376b768faf', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-18 08:44:38', 'Security', null, null, '0', null, '2024-02-18 08:44:38', null);
INSERT INTO `system_audittrail` VALUES ('0a55ad08-1b80-4e4a-9015-0799e8f05c11', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 15:42:50', 'Security', null, null, '0', null, '2024-01-06 15:42:50', null);
INSERT INTO `system_audittrail` VALUES ('0ac5f047-739e-4649-b730-e6e31336bdba', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 16:26:53', 'Security', null, null, '0', null, '2024-02-02 16:26:53', null);
INSERT INTO `system_audittrail` VALUES ('0b6a6559-ac16-4e26-ac2f-2cfe0ec06dd3', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-23 08:09:13', 'Security', null, null, '0', null, '2024-01-23 08:09:13', null);
INSERT INTO `system_audittrail` VALUES ('0bb36d68-40bb-4134-9102-d1a6f20ed84c', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 15:53:35', 'Security', null, null, '0', null, '2024-01-30 15:53:35', null);
INSERT INTO `system_audittrail` VALUES ('0f80b677-1cc2-4cf5-986e-2209977dd662', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 12:56:31', 'Security', null, null, '0', null, '2024-02-02 12:56:31', null);
INSERT INTO `system_audittrail` VALUES ('10f5bfa0-4968-451b-b4b7-bf7d1daf8934', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-08 22:29:15', 'Security', null, null, '0', null, '2024-01-08 22:29:15', null);
INSERT INTO `system_audittrail` VALUES ('127a7e0e-8965-4dfb-9db1-6983b3d53ca0', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-31 11:23:17', 'Security', null, null, '0', null, '2024-01-31 11:23:17', null);
INSERT INTO `system_audittrail` VALUES ('12b844e4-d421-4d8c-a07e-a50640acf605', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-08 16:31:28', 'Security', null, null, '0', null, '2024-02-08 16:31:28', null);
INSERT INTO `system_audittrail` VALUES ('15ed47a6-bf67-4c9c-a4d0-6ec87d71fef4', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 17:58:36', 'Security', null, null, '0', null, '2024-02-06 17:58:36', null);
INSERT INTO `system_audittrail` VALUES ('15f20c93-01b9-4bef-9856-0576b2623f68', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 14:35:15', 'Security', null, null, '0', null, '2024-02-05 14:35:15', null);
INSERT INTO `system_audittrail` VALUES ('16688c54-8620-4694-ad3d-8437020a97fd', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-19 08:17:44', 'Security', null, null, '0', null, '2024-02-19 08:17:44', null);
INSERT INTO `system_audittrail` VALUES ('171cfe55-6eaf-4a77-9fb0-be37169fafc0', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 14:47:34', 'Security', null, null, '0', null, '2024-01-27 14:47:34', null);
INSERT INTO `system_audittrail` VALUES ('178bd431-5bbe-4406-a759-66f27ee7a58b', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-18 18:16:18', 'Security', null, null, '0', null, '2024-02-18 18:16:18', null);
INSERT INTO `system_audittrail` VALUES ('17957fb8-4ee6-4e13-b9dd-a7e0d6813e9e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 09:49:51', 'Security', null, null, '0', null, '2024-02-02 09:49:51', null);
INSERT INTO `system_audittrail` VALUES ('1803b537-f245-4e3d-80a2-4e7604256523', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-19 15:05:25', 'Security', null, null, '0', null, '2024-02-19 15:05:25', null);
INSERT INTO `system_audittrail` VALUES ('18a35d04-aad8-45ab-a459-521939f916b8', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 14:01:05', 'Security', null, null, '0', null, '2024-02-01 14:01:05', null);
INSERT INTO `system_audittrail` VALUES ('19279f6a-15a8-4270-9483-04cf9bcac2e0', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 09:37:19', 'Security', null, null, '0', null, '2024-02-02 09:37:19', null);
INSERT INTO `system_audittrail` VALUES ('1af09a0c-5aa7-4d9e-88ad-a32ed6495a8b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 14:46:28', 'Security', null, null, '0', null, '2024-02-06 14:46:28', null);
INSERT INTO `system_audittrail` VALUES ('1b06081c-7100-46c3-8ba4-c0281cb5d68f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 16:36:58', 'Security', null, null, '0', null, '2024-02-02 16:36:58', null);
INSERT INTO `system_audittrail` VALUES ('1b8de07a-c287-4f8c-b319-cc21e6a4955e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:01:58', 'Security', null, null, '0', null, '2024-02-02 13:01:58', null);
INSERT INTO `system_audittrail` VALUES ('1bd608ef-aa3c-47b3-97e3-1ae93d87f063', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 09:25:50', 'Security', null, null, '0', null, '2024-02-05 09:25:50', null);
INSERT INTO `system_audittrail` VALUES ('1c3d66a9-b2b3-4fb6-8141-16488ab72e7b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 10:53:03', 'Security', null, null, '0', null, '2024-02-02 10:53:03', null);
INSERT INTO `system_audittrail` VALUES ('1de5a0b3-aff5-4775-9c2e-3454240b3bc9', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-06 17:47:49', 'Security', null, null, '0', null, '2024-02-06 17:47:49', null);
INSERT INTO `system_audittrail` VALUES ('1e0b0a2a-baf0-43e2-8356-aee01057f67b', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-20 10:15:41', 'Security', null, null, '0', null, '2024-02-20 10:15:41', null);
INSERT INTO `system_audittrail` VALUES ('1e419f75-3a7e-47d1-941d-c46c4740aa22', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 17:28:28', 'Security', null, null, '0', null, '2024-02-06 17:28:28', null);
INSERT INTO `system_audittrail` VALUES ('1e533a8e-03f5-4ba9-85fa-ad810f0159ab', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:32:42', 'Security', null, null, '0', null, '2024-02-18 18:32:42', null);
INSERT INTO `system_audittrail` VALUES ('1eb43d11-e103-4066-ab94-9f210f06cd9d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 22:43:51', 'Security', null, null, '0', null, '2024-01-06 22:43:51', null);
INSERT INTO `system_audittrail` VALUES ('1f2207a1-f3b4-4f36-bd14-682f889042a5', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-08 10:31:28', 'Security', null, null, '0', null, '2024-02-08 10:31:28', null);
INSERT INTO `system_audittrail` VALUES ('1f654a91-42e9-48dc-a53f-6488f81f48e9', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-10 10:23:33', 'Security', null, null, '0', null, '2024-02-10 10:23:33', null);
INSERT INTO `system_audittrail` VALUES ('204ba1d6-35d5-44ac-b33e-089f6b4641f1', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-18 18:37:08', 'Security', null, null, '0', null, '2024-02-18 18:37:08', null);
INSERT INTO `system_audittrail` VALUES ('214f0e1b-a420-4654-91ce-249a16cddde9', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 08:19:11', 'Security', null, null, '0', null, '2024-02-04 08:19:11', null);
INSERT INTO `system_audittrail` VALUES ('2171328f-4936-44e3-bba6-be269842eb23', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-08 16:29:02', 'Security', null, null, '0', null, '2024-02-08 16:29:02', null);
INSERT INTO `system_audittrail` VALUES ('22d85af6-347b-4463-b788-794f60d71733', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 09:57:00', 'Security', null, null, '0', null, '2024-02-05 09:57:00', null);
INSERT INTO `system_audittrail` VALUES ('2364994b-2de6-4064-a66e-0acb2ae24333', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:28:02', 'Security', null, null, '0', null, '2024-02-02 14:28:02', null);
INSERT INTO `system_audittrail` VALUES ('23e5a5c2-7f1c-4536-a363-97196ee83a15', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-23 10:51:32', 'Security', null, null, '0', null, '2024-02-23 10:51:32', null);
INSERT INTO `system_audittrail` VALUES ('24d514de-9e8d-42d3-a18a-3c551662db2b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 18:01:40', 'Security', null, null, '0', null, '2024-02-06 18:01:40', null);
INSERT INTO `system_audittrail` VALUES ('254f6cc3-1e83-454f-b364-ef19e23744b1', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:29:26', 'Security', null, null, '0', null, '2024-02-02 13:29:26', null);
INSERT INTO `system_audittrail` VALUES ('26c8e2ef-2b75-41c0-9ee8-017275289bf6', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 10:18:03', 'Security', null, null, '0', null, '2024-02-01 10:18:03', null);
INSERT INTO `system_audittrail` VALUES ('28bffbfc-9fdc-4463-9071-1f17c134e39b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 09:48:32', 'Security', null, null, '0', null, '2024-02-02 09:48:32', null);
INSERT INTO `system_audittrail` VALUES ('29c24116-e077-4f3c-8042-3043a1d2b1e8', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 08:33:47', 'Security', null, null, '0', null, '2024-02-04 08:33:47', null);
INSERT INTO `system_audittrail` VALUES ('2a8653e8-195f-477a-a8f4-2f057f976bad', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:28:21', 'Security', null, null, '0', null, '2024-02-02 14:28:21', null);
INSERT INTO `system_audittrail` VALUES ('2b6944d0-4ff1-41ed-adc4-6309cb316868', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 10:40:46', 'Security', null, null, '0', null, '2024-02-01 10:40:46', null);
INSERT INTO `system_audittrail` VALUES ('2c68000f-26e1-47ad-801c-e7ad3ee59856', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-04 22:41:29', 'Security', null, null, '0', null, '2024-01-04 22:41:29', null);
INSERT INTO `system_audittrail` VALUES ('2dea6541-4797-45d8-8fd9-e7778f761aaa', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 17:49:35', 'Security', null, null, '0', null, '2024-02-06 17:49:35', null);
INSERT INTO `system_audittrail` VALUES ('2f44df81-b143-4390-86b7-74853ee85e08', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-25 09:26:05', 'Security', null, null, '0', null, '2024-01-25 09:26:05', null);
INSERT INTO `system_audittrail` VALUES ('3207c59d-62b2-4456-9684-602732125a5e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 17:31:22', 'Security', null, null, '0', null, '2024-02-18 17:31:22', null);
INSERT INTO `system_audittrail` VALUES ('322cce0f-b359-4047-8fdc-15abf1b76cc7', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-31 11:19:21', 'Security', null, null, '0', null, '2024-01-31 11:19:21', null);
INSERT INTO `system_audittrail` VALUES ('32b840ee-b149-489d-8632-baaaaeb5db91', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 22:52:46', 'Security', null, null, '0', null, '2024-01-06 22:52:46', null);
INSERT INTO `system_audittrail` VALUES ('33e0d995-d6c8-4d00-978f-4870839ad8ff', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 19:26:14', 'Security', null, null, '0', null, '2024-02-18 19:26:14', null);
INSERT INTO `system_audittrail` VALUES ('34157b78-6331-41e4-b6cc-6936d52f9df5', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-18 18:19:14', 'Security', null, null, '0', null, '2024-02-18 18:19:14', null);
INSERT INTO `system_audittrail` VALUES ('359dd3ac-3d42-4bb4-b4e3-1a4cf765860f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 16:19:58', 'Security', null, null, '0', null, '2024-01-27 16:19:58', null);
INSERT INTO `system_audittrail` VALUES ('3786a34b-2d20-4574-97ee-d7d7ddff4bb7', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 14:23:22', 'Security', null, null, '0', null, '2024-01-27 14:23:22', null);
INSERT INTO `system_audittrail` VALUES ('37ebb557-9f59-4d8d-8408-6c0b7286e02d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 15:14:31', 'Security', null, null, '0', null, '2024-01-27 15:14:31', null);
INSERT INTO `system_audittrail` VALUES ('38863f80-1496-4c1f-b6b9-d2b71c765753', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:50:32', 'Security', null, null, '0', null, '2024-01-06 20:50:32', null);
INSERT INTO `system_audittrail` VALUES ('38f72d6c-075f-48eb-9302-30e8fe8b923e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 10:27:16', 'Security', null, null, '0', null, '2024-02-02 10:27:16', null);
INSERT INTO `system_audittrail` VALUES ('395615bc-a4bd-4d9d-9d2b-fdad1cfa04df', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-19 16:17:22', 'Security', null, null, '0', null, '2024-02-19 16:17:22', null);
INSERT INTO `system_audittrail` VALUES ('39980429-58d6-48e6-aace-bc8e5ec5644a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:05:19', 'Security', null, null, '0', null, '2024-02-02 14:05:19', null);
INSERT INTO `system_audittrail` VALUES ('3a3ccbd8-a2ad-4c4a-b8bf-c0a1ada6e586', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 10:13:42', 'Security', null, null, '0', null, '2024-01-26 10:13:42', null);
INSERT INTO `system_audittrail` VALUES ('3a5d86e6-16c8-4a0b-8440-8ccdc9f307bc', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:24:51', 'Security', null, null, '0', null, '2024-02-02 14:24:51', null);
INSERT INTO `system_audittrail` VALUES ('3d901156-b688-44c0-bacf-3047c26429e6', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-14 14:41:56', 'Security', null, null, '0', null, '2024-01-14 14:41:56', null);
INSERT INTO `system_audittrail` VALUES ('3eea0ae4-51dc-4fb8-8159-79f54220b698', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:51:04', 'Security', null, null, '0', null, '2024-01-06 20:51:04', null);
INSERT INTO `system_audittrail` VALUES ('3f04ad5d-85a0-4eab-bf08-451caca0d87d', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:12:31', 'Security', null, null, '0', null, '2024-02-18 18:12:31', null);
INSERT INTO `system_audittrail` VALUES ('40c82613-1bb1-40f3-a57a-9c63b7f24fc8', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-17 16:41:12', 'Security', null, null, '0', null, '2024-01-17 16:41:12', null);
INSERT INTO `system_audittrail` VALUES ('42d8d7bc-106f-4738-a1bd-8d77826ddf39', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 18:04:58', 'Security', null, null, '0', null, '2024-02-06 18:04:58', null);
INSERT INTO `system_audittrail` VALUES ('430ee356-5b5b-4f8c-86de-b65e6097dd3b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-04 18:55:56', 'Security', null, null, '0', null, '2024-01-04 18:55:56', null);
INSERT INTO `system_audittrail` VALUES ('431b1355-e591-49dd-b58c-bddda42de8df', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-29 08:49:26', 'Security', null, null, '0', null, '2024-01-29 08:49:26', null);
INSERT INTO `system_audittrail` VALUES ('4404e5fd-ff91-4102-bbbf-4a03270ebddd', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-31 09:34:03', 'Security', null, null, '0', null, '2024-01-31 09:34:03', null);
INSERT INTO `system_audittrail` VALUES ('44e33417-b02a-4eb9-9ca2-1b433966fde0', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 13:55:05', 'Security', null, null, '0', null, '2024-02-01 13:55:05', null);
INSERT INTO `system_audittrail` VALUES ('4540f76d-b823-4322-be9b-bfcad932c4bc', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-25 11:25:00', 'Security', null, null, '0', null, '2024-01-25 11:25:00', null);
INSERT INTO `system_audittrail` VALUES ('454e4b95-0f98-4a2b-b99d-2bdb938b55cc', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-07 09:11:18', 'Security', null, null, '0', null, '2024-02-07 09:11:18', null);
INSERT INTO `system_audittrail` VALUES ('46021649-b640-43ed-a650-c31306455b90', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 15:07:17', 'Security', null, null, '0', null, '2024-01-27 15:07:17', null);
INSERT INTO `system_audittrail` VALUES ('46372030-5ea7-40a3-b19b-a9db3347ea3a', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 09:14:23', 'Security', null, null, '0', null, '2024-02-04 09:14:23', null);
INSERT INTO `system_audittrail` VALUES ('4675e666-9a05-4342-807a-a12ebf5fa450', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 12:05:27', 'Security', null, null, '0', null, '2024-02-01 12:05:27', null);
INSERT INTO `system_audittrail` VALUES ('46c79a3e-81cd-4f52-a4d0-738fb9c24904', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 17:48:32', 'Security', null, null, '0', null, '2024-02-06 17:48:32', null);
INSERT INTO `system_audittrail` VALUES ('46d78c67-15ab-4bf2-af38-a93b519a3c77', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 09:23:59', 'Security', null, null, '0', null, '2024-02-01 09:23:59', null);
INSERT INTO `system_audittrail` VALUES ('46f39f5f-4b3e-44b7-9c72-d5e3c362a9c3', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 22:50:02', 'Security', null, null, '0', null, '2024-01-06 22:50:02', null);
INSERT INTO `system_audittrail` VALUES ('47333c31-31ab-4424-8378-6b59ae287831', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:23:13', 'Security', null, null, '0', null, '2024-02-02 14:23:13', null);
INSERT INTO `system_audittrail` VALUES ('47947a46-1b3e-4682-8874-0521fbdf97de', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 08:53:41', 'Security', null, null, '0', null, '2024-02-04 08:53:41', null);
INSERT INTO `system_audittrail` VALUES ('481cca55-54d3-4808-9325-457a94b6445c', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 18:00:50', 'Security', null, null, '0', null, '2024-02-06 18:00:50', null);
INSERT INTO `system_audittrail` VALUES ('48a49a94-02a1-44ae-b70e-8647e137ea52', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-12 21:40:21', 'Security', null, null, '0', null, '2024-02-12 21:40:21', null);
INSERT INTO `system_audittrail` VALUES ('496928e7-12ab-40c7-9802-033b06b88292', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-20 10:11:53', 'Security', null, null, '0', null, '2024-02-20 10:11:53', null);
INSERT INTO `system_audittrail` VALUES ('4a354e47-2cd9-4be4-9317-2473b46839ee', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 12:04:44', 'Security', null, null, '0', null, '2024-02-01 12:04:44', null);
INSERT INTO `system_audittrail` VALUES ('4a9f45a3-1e44-4861-993d-6cd05fac7ce5', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-20 08:33:43', 'Security', null, null, '0', null, '2024-02-20 08:33:43', null);
INSERT INTO `system_audittrail` VALUES ('4ab583d1-6150-4345-aed9-6288939ad73e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 10:21:24', 'Security', null, null, '0', null, '2024-02-02 10:21:24', null);
INSERT INTO `system_audittrail` VALUES ('4ab989b8-b31d-496c-877a-53724be61f55', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-23 10:36:24', 'Security', null, null, '0', null, '2024-02-23 10:36:24', null);
INSERT INTO `system_audittrail` VALUES ('4afee9cd-3f2a-4364-908a-bbd44fe4bfae', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:15:57', 'Security', null, null, '0', null, '2024-02-02 13:15:57', null);
INSERT INTO `system_audittrail` VALUES ('4e84f4ec-c985-4580-bbbc-fd76731ba0b2', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 23:04:26', 'Security', null, null, '0', null, '2024-02-06 23:04:26', null);
INSERT INTO `system_audittrail` VALUES ('4eb76907-166c-48eb-bd1b-0f3a8f26e5a3', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:39:10', 'Security', null, null, '0', null, '2024-01-06 20:39:10', null);
INSERT INTO `system_audittrail` VALUES ('4fb423d0-4c3a-42fc-8b84-1c91609d4592', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 09:11:56', 'Security', null, null, '0', null, '2024-01-30 09:11:56', null);
INSERT INTO `system_audittrail` VALUES ('50e4e04a-8f89-4e9d-acfd-542908ec1e09', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 17:47:56', 'Security', null, null, '0', null, '2024-02-06 17:47:56', null);
INSERT INTO `system_audittrail` VALUES ('515c1da2-d0e1-4431-8f06-1fcbf26ff3f7', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 16:20:43', 'Security', null, null, '0', null, '2024-02-02 16:20:43', null);
INSERT INTO `system_audittrail` VALUES ('52b00757-c95c-43cf-9455-310aa5dd1dda', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-06 17:47:49', 'Security', null, null, '0', null, '2024-02-06 17:47:49', null);
INSERT INTO `system_audittrail` VALUES ('52b755e7-6ced-440b-8739-7f0d1afb5f11', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 15:11:52', 'Security', null, null, '0', null, '2024-02-05 15:11:52', null);
INSERT INTO `system_audittrail` VALUES ('5401b93e-2a24-433a-bdbb-d37ede51f1ed', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 17:59:11', 'Security', null, null, '0', null, '2024-02-06 17:59:11', null);
INSERT INTO `system_audittrail` VALUES ('541d34d8-e1c1-46b2-a916-412de479eafe', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 11:42:03', 'Security', null, null, '0', null, '2024-01-30 11:42:03', null);
INSERT INTO `system_audittrail` VALUES ('5495b3c5-6a44-48a6-be02-f0a98d051683', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-31 15:13:26', 'Security', null, null, '0', null, '2024-01-31 15:13:26', null);
INSERT INTO `system_audittrail` VALUES ('57391e72-c8da-41c0-b809-0a25c325d699', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 15:46:42', 'Security', null, null, '0', null, '2024-01-30 15:46:42', null);
INSERT INTO `system_audittrail` VALUES ('58c9dc64-afe9-45bf-ab46-54f7ada27ba1', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-23 23:27:23', 'Security', null, null, '0', null, '2024-01-23 23:27:23', null);
INSERT INTO `system_audittrail` VALUES ('58dda817-7f61-4fab-980d-38bdc0e22f69', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-07 11:18:49', 'Security', null, null, '0', null, '2024-02-07 11:18:49', null);
INSERT INTO `system_audittrail` VALUES ('5a6ae7a2-4b0e-4a66-b53d-6a3dd36018e9', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-18 10:33:02', 'Security', null, null, '0', null, '2024-01-18 10:33:02', null);
INSERT INTO `system_audittrail` VALUES ('5c660ca4-60ff-4574-99b5-a8f1e5f38e2a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 15:22:14', 'Security', null, null, '0', null, '2024-01-27 15:22:14', null);
INSERT INTO `system_audittrail` VALUES ('5de61180-995d-464c-99fd-6c51da2d8cbe', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 23:06:20', 'Security', null, null, '0', null, '2024-02-06 23:06:20', null);
INSERT INTO `system_audittrail` VALUES ('5f179b3f-5d1e-49c5-8b2c-53b0343410d1', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-23 12:12:47', 'Security', null, null, '0', null, '2024-01-23 12:12:47', null);
INSERT INTO `system_audittrail` VALUES ('6021797f-e5b2-462a-a494-c9a9254a06f3', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-18 18:10:20', 'Security', null, null, '0', null, '2024-02-18 18:10:20', null);
INSERT INTO `system_audittrail` VALUES ('618caf2a-dbe8-4e40-9130-3298419dc53a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-04 11:52:54', 'Security', null, null, '0', null, '2024-01-04 11:52:54', null);
INSERT INTO `system_audittrail` VALUES ('619b3d30-5810-4f61-8b3e-91e2c4f0d4b7', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-31 09:52:00', 'Security', null, null, '0', null, '2024-01-31 09:52:00', null);
INSERT INTO `system_audittrail` VALUES ('62a724c8-219d-42cb-9434-bc9537e451b9', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 09:50:33', 'Security', null, null, '0', null, '2024-02-02 09:50:33', null);
INSERT INTO `system_audittrail` VALUES ('637257d6-1d3d-4eb2-8688-c001d0d5c54f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:13:16', 'Security', null, null, '0', null, '2024-02-18 18:13:16', null);
INSERT INTO `system_audittrail` VALUES ('63f4ce5f-3297-4031-9df1-955b14473950', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-20 14:37:29', 'Security', null, null, '0', null, '2024-02-20 14:37:29', null);
INSERT INTO `system_audittrail` VALUES ('64292873-97d3-4826-a380-4df36a6b78af', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-07 11:18:06', 'Security', null, null, '0', null, '2024-02-07 11:18:06', null);
INSERT INTO `system_audittrail` VALUES ('65dce1d5-6321-4be5-8b06-6069ec3ffef7', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 12:42:57', 'Security', null, null, '0', null, '2024-02-02 12:42:57', null);
INSERT INTO `system_audittrail` VALUES ('66a3f4e8-568e-439b-9b2b-75945ccce1f0', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 17:49:09', 'Security', null, null, '0', null, '2024-02-06 17:49:09', null);
INSERT INTO `system_audittrail` VALUES ('6836dde6-7e0b-47b9-bc34-fe3966aadb59', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-10 10:41:06', 'Security', null, null, '0', null, '2024-02-10 10:41:06', null);
INSERT INTO `system_audittrail` VALUES ('6902b023-2149-4f2a-9290-3af4443c584c', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-29 14:24:28', 'Security', null, null, '0', null, '2024-01-29 14:24:28', null);
INSERT INTO `system_audittrail` VALUES ('69707bb8-775b-4cfb-9b82-a0a3a272c625', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 10:34:42', 'Security', null, null, '0', null, '2024-02-01 10:34:42', null);
INSERT INTO `system_audittrail` VALUES ('69a5eb1d-3efe-4bee-bbe8-3429a70ae020', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 10:53:22', 'Security', null, null, '0', null, '2024-01-30 10:53:22', null);
INSERT INTO `system_audittrail` VALUES ('6b50d9cb-71ff-4b79-ae4b-feb45cb76d93', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 15:51:13', 'Security', null, null, '0', null, '2024-01-30 15:51:13', null);
INSERT INTO `system_audittrail` VALUES ('6b95c677-a592-4a7b-b025-9e7e68ed4bb9', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-18 18:08:33', 'Security', null, null, '0', null, '2024-02-18 18:08:33', null);
INSERT INTO `system_audittrail` VALUES ('6c23c218-75cf-4be4-9035-8811fa4e6c4d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 11:10:49', 'Security', null, null, '0', null, '2024-02-01 11:10:49', null);
INSERT INTO `system_audittrail` VALUES ('6c44cc46-e928-4e38-8fec-9bc91aff1bc4', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-23 14:39:52', 'Security', null, null, '0', null, '2024-01-23 14:39:52', null);
INSERT INTO `system_audittrail` VALUES ('6ce76872-f6fe-4590-8fa0-0d7489dc4fae', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 09:22:47', 'Security', null, null, '0', null, '2024-02-04 09:22:47', null);
INSERT INTO `system_audittrail` VALUES ('6d7f104a-6e3f-42df-bcea-570d80d721ec', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-23 10:33:09', 'Security', null, null, '0', null, '2024-02-23 10:33:09', null);
INSERT INTO `system_audittrail` VALUES ('6e24fec4-c049-413d-ba5c-2c5a248a6933', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-06 23:04:41', 'Security', null, null, '0', null, '2024-02-06 23:04:41', null);
INSERT INTO `system_audittrail` VALUES ('6e2e0494-41e0-4bae-bda0-a7be58d66825', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-04 11:29:15', 'Security', null, null, '0', null, '2024-01-04 11:29:15', null);
INSERT INTO `system_audittrail` VALUES ('6e399975-a5d1-4d17-a8a8-936dc0605a0f', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 09:08:30', 'Security', null, null, '0', null, '2024-02-06 09:08:30', null);
INSERT INTO `system_audittrail` VALUES ('6eba8758-b935-48c9-8917-6cf61eed4a9e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 11:29:51', 'Security', null, null, '0', null, '2024-02-01 11:29:51', null);
INSERT INTO `system_audittrail` VALUES ('6f192ae5-9851-4782-b142-fd72f5ae662e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 15:07:03', 'Security', null, null, '0', null, '2024-02-05 15:07:03', null);
INSERT INTO `system_audittrail` VALUES ('6f6e87fb-d6e3-4071-9092-96b0034393cf', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 09:52:49', 'Security', null, null, '0', null, '2024-02-02 09:52:49', null);
INSERT INTO `system_audittrail` VALUES ('6f85a3a4-cdd1-4d33-85d7-ee91a5bdb6a5', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 09:41:48', 'Security', null, null, '0', null, '2024-01-26 09:41:48', null);
INSERT INTO `system_audittrail` VALUES ('70e9d343-8d25-4d7e-b2e7-ad00699e02bc', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-29 14:02:04', 'Security', null, null, '0', null, '2024-01-29 14:02:04', null);
INSERT INTO `system_audittrail` VALUES ('71627000-8df4-4b5d-9781-bf3bf950bdb3', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-08 16:25:46', 'Security', null, null, '0', null, '2024-02-08 16:25:46', null);
INSERT INTO `system_audittrail` VALUES ('722bb5d6-4469-4134-bd5d-cfcabac506b9', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 15:50:30', 'Security', null, null, '0', null, '2024-01-30 15:50:30', null);
INSERT INTO `system_audittrail` VALUES ('72fbb6a3-ef36-4633-b3a6-a29a22e7dab0', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 17:35:27', 'Security', null, null, '0', null, '2024-02-02 17:35:27', null);
INSERT INTO `system_audittrail` VALUES ('734a7273-55db-44ee-9365-20db910d135a', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-21 10:20:40', 'Security', null, null, '0', null, '2024-02-21 10:20:40', null);
INSERT INTO `system_audittrail` VALUES ('74cc7e1d-4ee1-4bc6-acd6-bdd61553e84e', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 14:44:01', 'Security', null, null, '0', null, '2024-02-05 14:44:01', null);
INSERT INTO `system_audittrail` VALUES ('764e4c4c-6421-45d7-bec9-944aa8ba3eee', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-08 16:13:09', 'Security', null, null, '0', null, '2024-01-08 16:13:09', null);
INSERT INTO `system_audittrail` VALUES ('77284293-a298-4227-a067-f15683bfbc9b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 15:37:02', 'Security', null, null, '0', null, '2024-02-02 15:37:02', null);
INSERT INTO `system_audittrail` VALUES ('77816b1b-4da8-44a0-8b79-6c650e513971', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 15:49:10', 'Security', null, null, '0', null, '2024-01-30 15:49:10', null);
INSERT INTO `system_audittrail` VALUES ('7839b3c4-0c95-48c5-8ed4-3d6eca7fed90', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 15:05:41', 'Security', null, null, '0', null, '2024-02-01 15:05:41', null);
INSERT INTO `system_audittrail` VALUES ('78742dfe-a145-4d55-a7b8-f43ede00c414', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:57:47', 'Security', null, null, '0', null, '2024-01-06 20:57:47', null);
INSERT INTO `system_audittrail` VALUES ('79f134f2-7c1f-4509-a5dd-5d2784f9bb5d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 17:29:18', 'Security', null, null, '0', null, '2024-02-01 17:29:18', null);
INSERT INTO `system_audittrail` VALUES ('7ac44998-714c-4320-b045-b24b2898bbfe', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 23:04:33', 'Security', null, null, '0', null, '2024-02-06 23:04:33', null);
INSERT INTO `system_audittrail` VALUES ('7ac85f0f-bea7-4318-abe3-921d8c97cdf8', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:18:08', 'Security', null, null, '0', null, '2024-02-02 13:18:08', null);
INSERT INTO `system_audittrail` VALUES ('7ad82961-8821-4025-8e8e-d3e49a00862a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 14:05:39', 'Security', null, null, '0', null, '2024-02-01 14:05:39', null);
INSERT INTO `system_audittrail` VALUES ('7ade5457-094e-4d04-b916-0b176762fd08', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:51:41', 'Security', null, null, '0', null, '2024-02-02 13:51:41', null);
INSERT INTO `system_audittrail` VALUES ('7b178c01-18a8-4cbe-9505-1a8872e193ee', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 12:35:49', 'Security', null, null, '0', null, '2024-02-02 12:35:49', null);
INSERT INTO `system_audittrail` VALUES ('7baa99c1-29e9-4d1a-adda-907e36281ab2', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 16:53:22', 'Security', null, null, '0', null, '2024-01-27 16:53:22', null);
INSERT INTO `system_audittrail` VALUES ('7d14ffcc-f7f8-4ceb-a94f-d822d2f83203', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:54:44', 'Security', null, null, '0', null, '2024-01-06 20:54:44', null);
INSERT INTO `system_audittrail` VALUES ('7e609b5f-4ec7-4bf2-8a7e-ca62faa5a740', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-19 08:58:34', 'Security', null, null, '0', null, '2024-02-19 08:58:34', null);
INSERT INTO `system_audittrail` VALUES ('80762968-a028-4918-a8dc-02c7ddd945d0', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-20 20:28:16', 'Security', null, null, '0', null, '2024-02-20 20:28:16', null);
INSERT INTO `system_audittrail` VALUES ('80d188bd-a170-45ed-8dad-ed3303311c75', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-20 14:37:54', 'Security', null, null, '0', null, '2024-02-20 14:37:54', null);
INSERT INTO `system_audittrail` VALUES ('80d76817-51f9-4d6a-a1b1-33ee91ae98a1', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-07 11:02:40', 'Security', null, null, '0', null, '2024-02-07 11:02:40', null);
INSERT INTO `system_audittrail` VALUES ('80db3714-9e2c-489a-a5bf-91bf1bb2b0ef', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 10:45:12', 'Security', null, null, '0', null, '2024-02-01 10:45:12', null);
INSERT INTO `system_audittrail` VALUES ('81069735-6e48-40f2-b7b6-b8cd19bfdad3', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-04 11:52:34', 'Security', null, null, '0', null, '2024-01-04 11:52:34', null);
INSERT INTO `system_audittrail` VALUES ('8229ac63-089c-4366-b31f-cd4579163134', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:10:08', 'Security', null, null, '0', null, '2024-02-02 14:10:08', null);
INSERT INTO `system_audittrail` VALUES ('82382485-f936-4030-ad9c-48adb537d427', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 14:03:53', 'Security', null, null, '0', null, '2024-02-01 14:03:53', null);
INSERT INTO `system_audittrail` VALUES ('834e6e15-3fac-4b77-861f-e741a86fdd89', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-23 08:13:09', 'Security', null, null, '0', null, '2024-01-23 08:13:09', null);
INSERT INTO `system_audittrail` VALUES ('83db2aae-d576-4797-a974-5f9b1184b07b', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-23 10:36:17', 'Security', null, null, '0', null, '2024-02-23 10:36:17', null);
INSERT INTO `system_audittrail` VALUES ('83f01e66-2639-4c68-b5a0-29314bf3ff7b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 18:07:41', 'Security', null, null, '0', null, '2024-02-06 18:07:41', null);
INSERT INTO `system_audittrail` VALUES ('84ebe8ab-9a85-482b-8323-eeacc8ce9e1f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 17:06:37', 'Security', null, null, '0', null, '2024-02-01 17:06:37', null);
INSERT INTO `system_audittrail` VALUES ('85f4a655-eb7b-428a-bb44-c410025bc22f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 15:34:04', 'Security', null, null, '0', null, '2024-01-27 15:34:04', null);
INSERT INTO `system_audittrail` VALUES ('8634c28f-cd6e-4194-9adb-07b67f83290e', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-20 20:30:20', 'Security', null, null, '0', null, '2024-02-20 20:30:20', null);
INSERT INTO `system_audittrail` VALUES ('86f60446-7fce-48a6-9c70-a8918d7c1975', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-22 10:50:06', 'Security', null, null, '0', null, '2024-02-22 10:50:06', null);
INSERT INTO `system_audittrail` VALUES ('87edae2b-f3c0-4d42-89c0-a44eef87fb7a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 10:38:29', 'Security', null, null, '0', null, '2024-01-26 10:38:29', null);
INSERT INTO `system_audittrail` VALUES ('892098c5-bd5c-4a26-97b2-6bdd356774d7', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 15:30:00', 'Security', null, null, '0', null, '2024-01-06 15:30:00', null);
INSERT INTO `system_audittrail` VALUES ('8a41c566-7527-4091-9694-dff8e4a0a6ff', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-23 10:14:31', 'Security', null, null, '0', null, '2024-02-23 10:14:31', null);
INSERT INTO `system_audittrail` VALUES ('8a554be9-7981-4a53-b78b-d3a1a623b76d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 08:44:54', 'Security', null, null, '0', null, '2024-02-01 08:44:54', null);
INSERT INTO `system_audittrail` VALUES ('8acc7e62-a375-4482-973c-b2325669559c', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 17:28:50', 'Security', null, null, '0', null, '2024-02-06 17:28:50', null);
INSERT INTO `system_audittrail` VALUES ('8cc9607c-66e5-45bf-995b-2a1d03a73f15', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 16:32:16', 'Security', null, null, '0', null, '2024-01-27 16:32:16', null);
INSERT INTO `system_audittrail` VALUES ('8e09e993-051a-4faf-a7a6-70a65bd0ba66', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 10:52:54', 'Security', null, null, '0', null, '2024-01-30 10:52:54', null);
INSERT INTO `system_audittrail` VALUES ('8e3bbf6a-efc5-4def-a11e-7bb59adecb8b', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-07 12:15:31', 'Security', null, null, '0', null, '2024-02-07 12:15:31', null);
INSERT INTO `system_audittrail` VALUES ('900801ea-9256-4f09-97dd-8d1fd20b73c5', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:58:20', 'Security', null, null, '0', null, '2024-01-06 20:58:20', null);
INSERT INTO `system_audittrail` VALUES ('9051df5e-6bcd-4c36-ab95-3d9c2fb0d454', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-24 15:15:04', 'Security', null, null, '0', null, '2024-01-24 15:15:04', null);
INSERT INTO `system_audittrail` VALUES ('91365c7a-2c78-4086-a932-5fbe7fa4be9f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 11:08:45', 'Security', null, null, '0', null, '2024-02-01 11:08:45', null);
INSERT INTO `system_audittrail` VALUES ('96000a88-7314-4fab-b228-b4d91e9eab8e', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-24 11:13:01', 'Security', null, null, '0', null, '2024-01-24 11:13:01', null);
INSERT INTO `system_audittrail` VALUES ('974f62ee-0bab-40a3-9a2e-62d1daa50f6d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 09:36:36', 'Security', null, null, '0', null, '2024-02-02 09:36:36', null);
INSERT INTO `system_audittrail` VALUES ('9abfbcd1-7e05-4b64-b20c-ada17d8af013', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-04 11:28:46', 'Security', null, null, '0', null, '2024-01-04 11:28:46', null);
INSERT INTO `system_audittrail` VALUES ('9acfbf7f-de68-4bb4-8d93-9947ec770b26', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-18 09:31:14', 'Security', null, null, '0', null, '2024-01-18 09:31:14', null);
INSERT INTO `system_audittrail` VALUES ('9b0b11da-6802-496c-b915-4e4f63d8a1e0', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:43:03', 'Security', null, null, '0', null, '2024-02-02 13:43:03', null);
INSERT INTO `system_audittrail` VALUES ('9bd851d6-780e-4fec-92e0-5b91776eff47', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 10:15:45', 'Security', null, null, '0', null, '2024-01-26 10:15:45', null);
INSERT INTO `system_audittrail` VALUES ('9c30c2b3-2dc4-47e3-a462-0b836ead38b3', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 13:51:47', 'Security', null, null, '0', null, '2024-01-27 13:51:47', null);
INSERT INTO `system_audittrail` VALUES ('9c7a1417-435a-46c1-905b-c73024a3366f', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 15:17:54', 'Security', null, null, '0', null, '2024-01-06 15:17:54', null);
INSERT INTO `system_audittrail` VALUES ('9d7433e1-f58a-47f7-8eb6-0c88e460e956', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 12:49:53', 'Security', null, null, '0', null, '2024-02-02 12:49:53', null);
INSERT INTO `system_audittrail` VALUES ('9f9326ed-c7ad-4a6b-8dbc-3cc58b76df5b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-14 14:41:37', 'Security', null, null, '0', null, '2024-01-14 14:41:37', null);
INSERT INTO `system_audittrail` VALUES ('a05ebc5b-aa50-4a90-997b-2c55b80503e5', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 13:53:01', 'Security', null, null, '0', null, '2024-01-27 13:53:01', null);
INSERT INTO `system_audittrail` VALUES ('a1e017cb-06c3-445f-a4d2-49e022f3a9be', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 19:36:06', 'Security', null, null, '0', null, '2024-01-06 19:36:06', null);
INSERT INTO `system_audittrail` VALUES ('a23b32de-ed1f-4a7c-81b4-d6f6c8aff3bc', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 18:36:47', 'Security', null, null, '0', null, '2024-02-06 18:36:47', null);
INSERT INTO `system_audittrail` VALUES ('a2758e57-8e8e-4447-956b-634405f72577', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:59:33', 'Security', null, null, '0', null, '2024-01-06 20:59:33', null);
INSERT INTO `system_audittrail` VALUES ('a427a68f-ee49-4dcb-904b-da772c540b6a', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 10:10:37', 'Security', null, null, '0', null, '2024-02-05 10:10:37', null);
INSERT INTO `system_audittrail` VALUES ('a445d8ea-e017-4f56-b97d-6350e112391a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-22 16:17:36', 'Security', null, null, '0', null, '2024-01-22 16:17:36', null);
INSERT INTO `system_audittrail` VALUES ('a6b96de5-f40b-4bd3-bbb3-85e19634b073', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:17:01', 'Security', null, null, '0', null, '2024-02-02 13:17:01', null);
INSERT INTO `system_audittrail` VALUES ('a6d90e0c-7886-4080-85dc-8cfb430a8d08', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 14:38:18', 'Security', null, null, '0', null, '2024-01-26 14:38:18', null);
INSERT INTO `system_audittrail` VALUES ('a6fbc68a-e0a4-4fa5-b865-3e0b085f8cd5', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 17:36:14', 'Security', null, null, '0', null, '2024-02-05 17:36:14', null);
INSERT INTO `system_audittrail` VALUES ('a70912ac-1939-4db8-9f9a-3ec6580219a7', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-05 14:32:07', 'Security', null, null, '0', null, '2024-02-05 14:32:07', null);
INSERT INTO `system_audittrail` VALUES ('a7b602e1-5124-4e5f-8638-7577b647ca00', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 08:53:49', 'Security', null, null, '0', null, '2024-02-04 08:53:49', null);
INSERT INTO `system_audittrail` VALUES ('a875a475-cba3-4991-b848-8693bb8b9660', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-20 13:57:53', 'Security', null, null, '0', null, '2024-02-20 13:57:53', null);
INSERT INTO `system_audittrail` VALUES ('a96763da-b341-48af-9d62-9b356e37721c', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-20 17:32:37', 'Security', null, null, '0', null, '2024-02-20 17:32:37', null);
INSERT INTO `system_audittrail` VALUES ('aaca4c8a-0fe0-4f92-b2e8-a83d06924b02', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-06 17:47:49', 'Security', null, null, '0', null, '2024-02-06 17:47:49', null);
INSERT INTO `system_audittrail` VALUES ('ac7ce9b6-96a9-4025-bd8b-6e69f6ddd897', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 10:00:42', 'Security', null, null, '0', null, '2024-02-02 10:00:42', null);
INSERT INTO `system_audittrail` VALUES ('ad7805ef-c107-422a-ac45-50e5d46a5712', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:13:21', 'Security', null, null, '0', null, '2024-02-18 18:13:21', null);
INSERT INTO `system_audittrail` VALUES ('ae9a75e2-49ab-4dcd-acca-1f8d5a8037b8', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-24 09:06:42', 'Security', null, null, '0', null, '2024-01-24 09:06:42', null);
INSERT INTO `system_audittrail` VALUES ('b1e2e5ae-2045-4eb7-b7aa-4e14029620fd', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-18 18:32:02', 'Security', null, null, '0', null, '2024-02-18 18:32:02', null);
INSERT INTO `system_audittrail` VALUES ('b1f32e93-3b5a-4433-87e8-34addc8b12a8', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-18 18:12:50', 'Security', null, null, '0', null, '2024-02-18 18:12:50', null);
INSERT INTO `system_audittrail` VALUES ('b21241a3-01b8-4402-b3a1-2add86a80a62', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:27:49', 'Security', null, null, '0', null, '2024-02-02 14:27:49', null);
INSERT INTO `system_audittrail` VALUES ('b21f14cc-965b-40eb-af5b-f9835918180b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 10:19:27', 'Security', null, null, '0', null, '2024-02-02 10:19:27', null);
INSERT INTO `system_audittrail` VALUES ('b2fbbd84-8f92-49e6-aa3c-3973b04aaecd', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:33:41', 'Security', null, null, '0', null, '2024-01-06 20:33:41', null);
INSERT INTO `system_audittrail` VALUES ('b318c089-9217-476d-bf39-0095fd646494', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-18 10:39:56', 'Security', null, null, '0', null, '2024-01-18 10:39:56', null);
INSERT INTO `system_audittrail` VALUES ('b33f16b3-5bce-4f74-81e8-86e9a17a4dce', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-20 13:55:43', 'Security', null, null, '0', null, '2024-02-20 13:55:43', null);
INSERT INTO `system_audittrail` VALUES ('b4912da1-b362-4a92-92b6-b582bed276be', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:18:02', 'Security', null, null, '0', null, '2024-02-18 18:18:02', null);
INSERT INTO `system_audittrail` VALUES ('b5c629b6-12a8-41fc-8911-011e451418db', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-06 17:59:38', 'Security', null, null, '0', null, '2024-02-06 17:59:38', null);
INSERT INTO `system_audittrail` VALUES ('b5c797ef-a813-4ea7-b2c2-264a3ad81847', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 15:11:13', 'Security', null, null, '0', null, '2024-02-01 15:11:13', null);
INSERT INTO `system_audittrail` VALUES ('b64604c0-b799-4fc0-b8c2-ac80d32e0d03', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 13:57:04', 'Security', null, null, '0', null, '2024-02-01 13:57:04', null);
INSERT INTO `system_audittrail` VALUES ('b7248467-c1b4-4265-890c-cc71f4473590', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:42:31', 'Security', null, null, '0', null, '2024-02-02 13:42:31', null);
INSERT INTO `system_audittrail` VALUES ('b7e91c03-dfff-42d1-8848-95379f735a56', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-08 16:26:20', 'Security', null, null, '0', null, '2024-02-08 16:26:20', null);
INSERT INTO `system_audittrail` VALUES ('ba8f9204-c00b-4e74-8a90-2773da2029f1', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-24 15:24:55', 'Security', null, null, '0', null, '2024-01-24 15:24:55', null);
INSERT INTO `system_audittrail` VALUES ('bc8a79cb-71b4-4e5c-858d-cca61264de0a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 15:07:33', 'Security', null, null, '0', null, '2024-02-01 15:07:33', null);
INSERT INTO `system_audittrail` VALUES ('bccd0426-d8b8-493c-8e7d-a9685743f23a', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 14:13:07', 'Security', null, null, '0', null, '2024-02-02 14:13:07', null);
INSERT INTO `system_audittrail` VALUES ('bd6ab6dd-e866-48c5-a2d8-f64c319150d5', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 13:57:16', 'Security', null, null, '0', null, '2024-02-02 13:57:16', null);
INSERT INTO `system_audittrail` VALUES ('be1a2223-3884-4535-8019-3dbc9e8adc36', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 15:34:30', 'Security', null, null, '0', null, '2024-01-27 15:34:30', null);
INSERT INTO `system_audittrail` VALUES ('be9c2a1b-7ad2-44a5-b11e-25b4ed4c310d', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:23:59', 'Security', null, null, '0', null, '2024-01-06 20:23:59', null);
INSERT INTO `system_audittrail` VALUES ('bffea401-3302-4223-b9b8-78afd8dd01fc', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-23 10:34:48', 'Security', null, null, '0', null, '2024-02-23 10:34:48', null);
INSERT INTO `system_audittrail` VALUES ('c223601d-e214-42b5-98b2-343cbe1d1624', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-08 10:30:43', 'Security', null, null, '0', null, '2024-02-08 10:30:43', null);
INSERT INTO `system_audittrail` VALUES ('c33345e2-6a93-4642-9238-ef1279efdf32', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 18:07:37', 'Security', null, null, '0', null, '2024-02-06 18:07:37', null);
INSERT INTO `system_audittrail` VALUES ('c4b2bff5-c959-40c6-a5cc-94d94a7de8e2', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:31:46', 'Security', null, null, '0', null, '2024-02-18 18:31:46', null);
INSERT INTO `system_audittrail` VALUES ('c5f8afa4-e408-4cbf-99cf-901a87df8556', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 14:13:08', 'Security', null, null, '0', null, '2024-02-01 14:13:08', null);
INSERT INTO `system_audittrail` VALUES ('c69e53bf-2f58-4a02-8431-9794595bc980', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:10:12', 'Security', null, null, '0', null, '2024-02-18 18:10:12', null);
INSERT INTO `system_audittrail` VALUES ('c75b1599-6bb1-4711-b23f-6f1191a45ebd', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 19:35:14', 'Security', null, null, '0', null, '2024-01-06 19:35:14', null);
INSERT INTO `system_audittrail` VALUES ('c81c411c-6d69-40fa-b006-c8fef6e8b017', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 12:59:26', 'Security', null, null, '0', null, '2024-02-02 12:59:26', null);
INSERT INTO `system_audittrail` VALUES ('c8419662-17bf-4546-96e7-348e7ede4eb7', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 10:27:22', 'Security', null, null, '0', null, '2024-02-02 10:27:22', null);
INSERT INTO `system_audittrail` VALUES ('ca710732-5bfb-4ebf-93bc-f9a5e16411cd', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 10:43:58', 'Security', null, null, '0', null, '2024-02-01 10:43:58', null);
INSERT INTO `system_audittrail` VALUES ('cabdbebd-294c-40f3-9e10-e4f42e7b412a', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 09:22:05', 'Security', null, null, '0', null, '2024-02-04 09:22:05', null);
INSERT INTO `system_audittrail` VALUES ('cb634711-5d75-4ecf-80cc-751c17b0878c', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 16:57:04', 'Security', null, null, '0', null, '2024-02-01 16:57:04', null);
INSERT INTO `system_audittrail` VALUES ('d030a171-6a71-407f-a7c4-281febcb8098', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-18 18:14:30', 'Security', null, null, '0', null, '2024-02-18 18:14:30', null);
INSERT INTO `system_audittrail` VALUES ('d22d870f-4b80-4b71-a060-3643cd2ba127', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-23 10:24:46', 'Security', null, null, '0', null, '2024-02-23 10:24:46', null);
INSERT INTO `system_audittrail` VALUES ('d2ee28f5-d390-48f9-88b5-1752bf2fa716', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 16:50:48', 'Security', null, null, '0', null, '2024-02-01 16:50:48', null);
INSERT INTO `system_audittrail` VALUES ('d3c502a4-a95f-449b-af54-2bec3df0f2c4', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-19 15:58:31', 'Security', null, null, '0', null, '2024-02-19 15:58:31', null);
INSERT INTO `system_audittrail` VALUES ('d5c0d14a-a50f-401c-ab8d-b7f1c5b5c28d', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 16:46:53', 'Security', null, null, '0', null, '2024-02-01 16:46:53', null);
INSERT INTO `system_audittrail` VALUES ('d61b0f2c-c685-4931-b397-3c3525d015ed', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 12:52:44', 'Security', null, null, '0', null, '2024-02-02 12:52:44', null);
INSERT INTO `system_audittrail` VALUES ('d8702633-8ed0-4e91-a06f-58b3d6fe56f6', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 15:01:19', 'Security', null, null, '0', null, '2024-02-02 15:01:19', null);
INSERT INTO `system_audittrail` VALUES ('d8b624b8-b1b7-47a3-bab3-a7627538ce9b', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 14:28:34', 'Security', null, null, '0', null, '2024-01-26 14:28:34', null);
INSERT INTO `system_audittrail` VALUES ('d8fbc717-d1b2-440a-a65e-be5f2aba96f4', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 20:40:55', 'Security', null, null, '0', null, '2024-01-06 20:40:55', null);
INSERT INTO `system_audittrail` VALUES ('da4db173-10a6-42fc-8bc0-473aa035412c', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 10:27:34', 'Security', null, null, '0', null, '2024-02-02 10:27:34', null);
INSERT INTO `system_audittrail` VALUES ('dcc3ce25-b556-4c88-9403-45c01f575278', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-10 10:41:46', 'Security', null, null, '0', null, '2024-02-10 10:41:46', null);
INSERT INTO `system_audittrail` VALUES ('dcd6bcc9-f69c-4649-9a4c-804b9870c2ce', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 11:29:39', 'Security', null, null, '0', null, '2024-02-01 11:29:39', null);
INSERT INTO `system_audittrail` VALUES ('dd4bd448-d73e-4f98-94dc-09942e9b8553', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-21 11:51:13', 'Security', null, null, '0', null, '2024-02-21 11:51:13', null);
INSERT INTO `system_audittrail` VALUES ('e11fb819-22b3-41a4-8391-a5b20ca92871', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-23 12:13:11', 'Security', null, null, '0', null, '2024-01-23 12:13:11', null);
INSERT INTO `system_audittrail` VALUES ('e1b0b3ff-51d6-495e-ad4e-66e4c5fd0975', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-26 10:16:39', 'Security', null, null, '0', null, '2024-01-26 10:16:39', null);
INSERT INTO `system_audittrail` VALUES ('e226a52a-ec33-4128-9050-f560895c08de', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-06 19:35:49', 'Security', null, null, '0', null, '2024-01-06 19:35:49', null);
INSERT INTO `system_audittrail` VALUES ('e53915ad-3d4b-436e-b673-971a925bc08c', 'Login', 'root', 'LOGIN', '127.0.0.1', '2024-02-18 18:14:04', 'Security', null, null, '0', null, '2024-02-18 18:14:04', null);
INSERT INTO `system_audittrail` VALUES ('e5ece7c4-ae63-47b1-bed5-1c25d1d60ccb', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 12:21:14', 'Security', null, null, '0', null, '2024-02-01 12:21:14', null);
INSERT INTO `system_audittrail` VALUES ('e63e631c-cb27-4307-b8a1-0563c0ab900b', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-07 09:57:44', 'Security', null, null, '0', null, '2024-02-07 09:57:44', null);
INSERT INTO `system_audittrail` VALUES ('e643ed63-4284-4b14-b9b3-97069f976584', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 15:08:08', 'Security', null, null, '0', null, '2024-02-01 15:08:08', null);
INSERT INTO `system_audittrail` VALUES ('e6a37a3b-2d4b-429a-a912-97823e0c3bab', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 16:17:24', 'Security', null, null, '0', null, '2024-01-27 16:17:24', null);
INSERT INTO `system_audittrail` VALUES ('e95465ae-b3ea-4b52-b44b-9ccf27961e52', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-08 10:29:52', 'Security', null, null, '0', null, '2024-02-08 10:29:52', null);
INSERT INTO `system_audittrail` VALUES ('ea32cd3f-fd68-401e-abfe-638c56e965b3', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 14:43:17', 'Security', null, null, '0', null, '2024-02-01 14:43:17', null);
INSERT INTO `system_audittrail` VALUES ('ec9f7047-31af-4147-a7d6-a0297be4b150', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-08 11:10:04', 'Security', null, null, '0', null, '2024-02-08 11:10:04', null);
INSERT INTO `system_audittrail` VALUES ('efffc13d-1b42-4152-954d-46a9b1f4403f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-04 08:19:48', 'Security', null, null, '0', null, '2024-02-04 08:19:48', null);
INSERT INTO `system_audittrail` VALUES ('f22a3ea1-8ef2-4a91-9c2e-f09c5495b506', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-04 11:31:41', 'Security', null, null, '0', null, '2024-01-04 11:31:41', null);
INSERT INTO `system_audittrail` VALUES ('f2d2dfc7-bd67-4d1a-a5fc-e79cc319aedd', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 18:19:40', 'Security', null, null, '0', null, '2024-02-06 18:19:40', null);
INSERT INTO `system_audittrail` VALUES ('f35dc69a-451d-4895-87e0-797ef58bb744', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 18:02:41', 'Security', null, null, '0', null, '2024-02-06 18:02:41', null);
INSERT INTO `system_audittrail` VALUES ('f3b8e0d3-dc18-452c-9f1b-71d6a3a90916', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 14:46:20', 'Security', null, null, '0', null, '2024-02-06 14:46:20', null);
INSERT INTO `system_audittrail` VALUES ('f68b23c0-6a2b-4514-b74b-cf2a0fed2d07', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-25 10:17:06', 'Security', null, null, '0', null, '2024-01-25 10:17:06', null);
INSERT INTO `system_audittrail` VALUES ('f78cb856-e890-4b44-ad56-80554f5ca018', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-29 08:38:58', 'Security', null, null, '0', null, '2024-01-29 08:38:58', null);
INSERT INTO `system_audittrail` VALUES ('f8476bde-a159-4a9a-b61c-3837c411b7fc', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-07 12:15:29', 'Security', null, null, '0', null, '2024-02-07 12:15:29', null);
INSERT INTO `system_audittrail` VALUES ('f892c894-d66c-4507-8f04-3e2d5143a0c6', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-01 09:18:06', 'Security', null, null, '0', null, '2024-02-01 09:18:06', null);
INSERT INTO `system_audittrail` VALUES ('f8cabf61-db52-4403-8dee-f8013d1e20a2', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-13 11:06:24', 'Security', null, null, '0', null, '2024-01-13 11:06:24', null);
INSERT INTO `system_audittrail` VALUES ('f8ed4fec-0311-4e4a-b506-e480f1f85a71', 'Login', '2023003', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-06 09:07:08', 'Security', null, null, '0', null, '2024-02-06 09:07:08', null);
INSERT INTO `system_audittrail` VALUES ('f96067bc-32fb-4ece-b1d2-50f07064ea9a', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-07 11:18:07', 'Security', null, null, '0', null, '2024-02-07 11:18:07', null);
INSERT INTO `system_audittrail` VALUES ('fa17b1c7-229c-4f00-85b1-ab3f435db849', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 16:55:56', 'Security', null, null, '0', null, '2024-01-27 16:55:56', null);
INSERT INTO `system_audittrail` VALUES ('fb20d7b9-4e61-4db5-8403-81b5eb42bef3', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-27 15:45:20', 'Security', null, null, '0', null, '2024-01-27 15:45:20', null);
INSERT INTO `system_audittrail` VALUES ('fbaf05aa-b065-4c96-a21e-90b79f31029a', 'Login', '2023003', 'LOGIN', '127.0.0.1', '2024-02-08 10:32:37', 'Security', null, null, '0', null, '2024-02-08 10:32:37', null);
INSERT INTO `system_audittrail` VALUES ('fc0dc8a1-18da-40bd-b9bf-c97b9866f415', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 10:53:00', 'Security', null, null, '0', null, '2024-01-30 10:53:00', null);
INSERT INTO `system_audittrail` VALUES ('fc9b2671-f3e3-456e-a6d4-bc5e387403a4', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-29 08:40:57', 'Security', null, null, '0', null, '2024-01-29 08:40:57', null);
INSERT INTO `system_audittrail` VALUES ('fcb829ac-7bde-4567-8427-5fc23b54215f', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-02-02 09:51:10', 'Security', null, null, '0', null, '2024-02-02 09:51:10', null);
INSERT INTO `system_audittrail` VALUES ('fce845c2-cef0-4439-9b77-f2b2d76ed8fb', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-30 16:10:35', 'Security', null, null, '0', null, '2024-01-30 16:10:35', null);
INSERT INTO `system_audittrail` VALUES ('fea8db78-6cd1-4990-8290-da1dcda13b25', 'Login', 'root', 'LOGIN', '0:0:0:0:0:0:0:1', '2024-01-31 16:08:46', 'Security', null, null, '0', null, '2024-01-31 16:08:46', null);
-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config` (
`id` varchar(64) NOT NULL COMMENT 'id',
`ckey` varchar(256) DEFAULT NULL COMMENT 'key',
`cvalue` varchar(256) DEFAULT NULL COMMENT 'value',
`clevel` varchar(256) DEFAULT NULL COMMENT 'level',
`category` varchar(256) DEFAULT NULL COMMENT 'category',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of system_config
-- ----------------------------
INSERT INTO `system_config` VALUES ('2e60c1ea-0644-4713-a527-0dd261e5c67e', 'zh_cn', '中文（简体）', '0', 'language', '0', '', '2023-03-13 12:28:09', '2023-03-14 15:58:07');
INSERT INTO `system_config` VALUES ('76cb2112-f5f7-459f-8fde-4e515e9b87d3', 'en_us', 'English (United States)', '0', 'language', '0', '', '2023-03-13 12:27:43', '2023-03-14 15:58:10');
-- ----------------------------
-- Table structure for system_mail_send_log
-- ----------------------------
DROP TABLE IF EXISTS `system_mail_send_log`;
CREATE TABLE `system_mail_send_log` (
`id` varchar(64) NOT NULL,
`uid` varchar(64) DEFAULT NULL,
`status` int(11) DEFAULT '0' COMMENT '0: pending，1: successful，2: failed',
`routeKey` varchar(255) DEFAULT NULL,
`exchange` varchar(255) DEFAULT NULL,
`count` int(11) DEFAULT '0' COMMENT 'retry count',
`tryTime` datetime DEFAULT NULL COMMENT 'first retry time',
`createTime` datetime DEFAULT NULL,
`updateTime` datetime DEFAULT NULL,
`username` varchar(128) DEFAULT NULL,
`account` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of system_mail_send_log
-- ----------------------------
-- ----------------------------
-- Table structure for system_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_menu`;
CREATE TABLE `system_menu` (
`id` varchar(64) NOT NULL COMMENT 'id',
`code` varchar(64) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL COMMENT 'name',
`url` varchar(256) DEFAULT NULL COMMENT 'link uri',
`path` varchar(256) DEFAULT NULL,
`component` varchar(256) DEFAULT NULL,
`type` int(2) DEFAULT NULL COMMENT 'undefined = 0, page = 1, menu = 2, button = 3',
`icon` varchar(256) DEFAULT NULL COMMENT 'icon of node',
`parentid` varchar(64) DEFAULT NULL COMMENT 'parent id',
`keepalive` tinyint(1) DEFAULT NULL COMMENT 'keep alive',
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`level` int(10) DEFAULT NULL,
`languagekey` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of system_menu
-- ----------------------------
INSERT INTO `system_menu` VALUES ('05edffb5-6f23-4624-9032-270e16d53d43', 'Tue Jan 30 10:45:06 CST 2024', '历史订单', '/admin/order/HistoryOrder', '/admin/order/HistoryOrder', 'HistoryOrder', '2', 'order-history', '0d1a6c2d-34c7-4c10-ab8f-84fbba5db4bb', null, null, '', '2024-01-30 10:45:06', null, '1', 'HistoryOrder');
INSERT INTO `system_menu` VALUES ('0d1a6c2d-34c7-4c10-ab8f-84fbba5db4bb', 'Tue Jan 30 10:43:18 CST 2024', '订单管理', '/admin/order', '/admin/order', 'LayoutAdmin', '2', 'order', null, null, null, '', '2024-01-30 10:43:18', null, '5', 'Order');
INSERT INTO `system_menu` VALUES ('14f8dc1b-1e05-46c6-a898-378a7001fd69', 'Sat Jan 06 15:23:43 CST 2024', '题型管理', '/admin/question/QuestionCategory', '/admin/question/QuestionCategory', 'QuestionCategory', '2', 'question-category', '98aa2937-2d0e-4438-a6cc-9c8bb7080175', null, null, '', '2024-01-06 15:23:43', '2024-01-18 10:39:42', '1', 'QuestionCategory');
INSERT INTO `system_menu` VALUES ('1a4e9f28-e32e-4781-be70-7235f19fccbc', 'Sat Jan 06 22:48:20 CST 2024', '历史优惠券', '/admin/vip/VIPCouponHistory', '/admin/vip/VIPCouponHistory', 'VIPCouponHistory', '2', 'coupon-history', 'dcd3a28d-df75-40fb-ba78-57dae14f6a0d', null, null, '', '2024-01-06 22:48:20', '2024-01-06 22:48:34', '1', 'VIPCouponHistory');
INSERT INTO `system_menu` VALUES ('22be1ccc-8294-41ff-8e79-5443450558f6', 'Sat Jan 06 15:26:15 CST 2024', '试卷管理', '/admin/question/QuestionPaper', '/admin/question/QuestionPaper', 'QuestionPaper', '2', 'question-paper', '98aa2937-2d0e-4438-a6cc-9c8bb7080175', null, null, '', '2024-01-06 15:26:15', null, '4', 'QuestionPaper');
INSERT INTO `system_menu` VALUES ('26f60c39-e0a0-4490-9565-ecdd73d27679', 'Fri Feb 23 10:19:35 CST 2024', '产品列表', '/admin/product/ProductMaster', '/admin/product/ProductMaster', 'ProductMaster', '2', 'product-master', '83bab001-0055-44a3-a83b-3ef121c235a0', null, null, '', '2024-02-23 10:19:35', '2024-02-23 10:19:50', '1', 'ProductMaster');
INSERT INTO `system_menu` VALUES ('369931da-a696-47c8-bd68-b2e16b577f99', 'Tue Jan 30 10:44:13 CST 2024', '活动订单', '/admin/order/ActiveOrder', '/admin/order/ActiveOrder', 'ActiveOrder', '2', 'order-active', '0d1a6c2d-34c7-4c10-ab8f-84fbba5db4bb', null, null, '', '2024-01-30 10:44:13', null, '2', 'ActiveOrder');
INSERT INTO `system_menu` VALUES ('3dd86f16-9d2e-4fd7-a5ae-19bd338857f7', 'MailSendLog', '邮件日志', '/admin/system/MailSendLog', '/admin/system/MailSendLog', 'MailSendLog', '2', 'email', 'b67fd674-3ac9-11eb-8afe-00163e033152', null, null, null, '2023-04-26 08:51:57', '2023-11-20 10:15:01', '6', 'MailSendLog');
INSERT INTO `system_menu` VALUES ('512c4b10-f763-4f91-95aa-1e4cf61f8d03', 'Fri Feb 23 10:20:51 CST 2024', '品牌管理', '/admin/product/ProductBrand', '/admin/product/ProductBrand', 'ProductBrand', '2', 'product-brand', '83bab001-0055-44a3-a83b-3ef121c235a0', null, null, '', '2024-02-23 10:20:51', null, '2', 'ProductBrand');
INSERT INTO `system_menu` VALUES ('56972411-c9eb-4e6f-8942-b619a1955c28', 'Sat Jan 06 15:27:10 CST 2024', '试卷类别', '/admin/question/QuestionPaperCategory', '/admin/question/QuestionPaperCategory', 'QuestionPaperCategory', '2', 'question-paper-category', '98aa2937-2d0e-4438-a6cc-9c8bb7080175', null, null, '', '2024-01-06 15:27:10', '2024-01-18 10:39:33', '3', 'QuestionPaperCategory');
INSERT INTO `system_menu` VALUES ('5a5a2d38-4673-4975-899a-c89911b3f73e', 'Fri Feb 23 10:22:25 CST 2024', '产品类别', '/admin/product/ProductCategory', '/admin/product/ProductCategory', 'ProductCategory', '2', 'product-category', '83bab001-0055-44a3-a83b-3ef121c235a0', null, null, '', '2024-02-23 10:22:25', null, '3', 'ProductCategory');
INSERT INTO `system_menu` VALUES ('73d6d881-3acf-11eb-8afe-00163e033152', 'MenuList', '菜单管理', '/admin/system/Menu', '/admin/system/Menu', 'Menu', '2', 'menu', 'b67fd674-3ac9-11eb-8afe-00163e033152', '1', '0', null, '2020-12-30 10:32:09', '2022-12-28 15:32:58', '1', 'MenuList');
INSERT INTO `system_menu` VALUES ('839236b7-2781-4e18-836a-cb977a947afa', 'Thu Jan 04 22:53:16 CST 2024', '院系管理', '/admin/organization/OrganizationDepartment', '/admin/organization/OrganizationDepartment', 'OrganizationDepartment', '2', 'organization-department', 'b2ded452-945c-4e0e-a43b-be5bfae2a24c', null, null, '', '2024-01-04 22:53:16', '2024-01-18 10:38:44', '4', 'OrganizationDepartment');
INSERT INTO `system_menu` VALUES ('83bab001-0055-44a3-a83b-3ef121c235a0', 'Fri Feb 23 10:18:17 CST 2024', '产品管理', '/admin/product', '/admin/product', 'LayoutAdmin', '2', 'product', null, null, null, '', '2024-02-23 10:18:17', '2024-02-23 10:18:45', '6', 'Product');
INSERT INTO `system_menu` VALUES ('933826d4-8bfb-4053-8502-b0c7a428b3b3', 'Sat Jan 06 22:47:28 CST 2024', '优惠券列表', '/admin/vip/VIPCouponActive', '/admin/vip/VIPCouponActive', 'VIPCouponActive', '2', 'coupon-active', 'dcd3a28d-df75-40fb-ba78-57dae14f6a0d', null, null, '', '2024-01-06 22:47:28', null, '2', 'VIPCouponActive');
INSERT INTO `system_menu` VALUES ('98aa2937-2d0e-4438-a6cc-9c8bb7080175', 'Sat Jan 06 15:20:50 CST 2024', '试题管理', '/admin/question', '/admin/question', 'LayoutAdmin', '2', 'question', null, null, null, '', '2024-01-06 15:20:50', '2024-01-29 13:59:44', '4', 'Question');
INSERT INTO `system_menu` VALUES ('98aefb60-e1de-43d7-94f6-54baaa38961e', 'Mon Jan 29 14:00:43 CST 2024', '会员充值活动', '/admin/vip/VIPDepositActivity', '/admin/vip/VIPDepositActivity', 'VIPDepositActivity', '2', 'deposit-activity', 'dcd3a28d-df75-40fb-ba78-57dae14f6a0d', null, null, '', '2024-01-29 14:00:43', '2024-01-29 14:24:02', '5', 'VIPDepositActivity');
INSERT INTO `system_menu` VALUES ('9b09c4c5-4c5b-4cfd-9d54-9d528ae378e5', 'Fri Feb 23 10:21:33 CST 2024', '供应商管理', '/admin/product/ProductSupplier', '/admin/product/ProductSupplier', 'ProductSupplier', '2', 'product-supplier', '83bab001-0055-44a3-a83b-3ef121c235a0', null, null, '', '2024-02-23 10:21:33', null, '3', 'ProductSupplier');
INSERT INTO `system_menu` VALUES ('a0d6cd97-33d3-4907-ad1d-3c088e5a0563', 'Sat Jan 06 15:41:56 CST 2024', '会员列表', '/admin/vip/VIPMaster', '/admin/vip/VIPMaster', 'VIPMaster', '2', 'vip-master', 'dcd3a28d-df75-40fb-ba78-57dae14f6a0d', null, null, '', '2024-01-06 15:41:56', '2024-01-06 22:48:41', '3', 'VIPMaster');
INSERT INTO `system_menu` VALUES ('a5e4dad9-69da-4b01-8da5-e05cc48de8ac', 'Config', '配置管理', '/admin/system/Config', '/admin/system/Config', 'Config', '2', 'configuration', 'b67fd674-3ac9-11eb-8afe-00163e033152', null, null, null, '2023-03-13 10:40:34', '2024-01-06 20:58:14', '4', 'Config');
INSERT INTO `system_menu` VALUES ('b2ded452-945c-4e0e-a43b-be5bfae2a24c', 'Thu Jan 04 22:42:57 CST 2024', '组织结构', '/admin/organization', '/admin/organization', 'LayoutAdmin', '2', 'organization', null, null, null, '', '2024-01-04 22:42:57', '2024-01-04 22:54:08', '2', 'Organization');
INSERT INTO `system_menu` VALUES ('b667fc7f-3ac9-11eb-8afe-00163e033152', 'AuditTrail', '审计追踪', '/admin/system/AuditTrail', '/admin/system/AuditTrail', 'AuditTrail', '0', 'audittrail', 'b67fd674-3ac9-11eb-8afe-00163e033152', '0', '0', null, '2022-08-08 14:07:00', '2022-12-28 15:31:54', '3', 'AuditTrail');
INSERT INTO `system_menu` VALUES ('b678a830-3ac9-11eb-8afe-00163e033152', 'Log', '日志', '/admin/system/Log', '/admin/system/Log', 'Log', '2', 'systemlog', 'b67fd674-3ac9-11eb-8afe-00163e033152', '0', '0', null, '2020-12-30 10:32:09', '2022-12-28 15:31:46', '2', 'Log');
INSERT INTO `system_menu` VALUES ('b67fd674-3ac9-11eb-8afe-00163e033152', 'SystemSettings', '系统设置', '/admin/system', '/admin/system', 'LayoutAdmin', '2', 'settings', null, '0', '0', null, '2020-12-30 10:32:09', '2024-01-06 20:57:36', '1', 'SystemSettings');
INSERT INTO `system_menu` VALUES ('b9c13a9e-858b-4326-85c8-0cb6136c4519', 'Sat Jan 06 15:22:52 CST 2024', '试题库', '/admin/question/QuestionMaster', '/admin/question/QuestionMaster', 'QuestionMaster', '2', 'question-master', '98aa2937-2d0e-4438-a6cc-9c8bb7080175', null, null, '', '2024-01-06 15:22:52', '2024-01-18 10:39:46', '2', 'QuestionMaster');
INSERT INTO `system_menu` VALUES ('d27cb44b-c1be-40b8-836e-11cc912dc8ab', 'Notification', '系统通知', '/admin/system/Notification', '/admin/system/Notification', 'Notification', '2', 'notification', 'b67fd674-3ac9-11eb-8afe-00163e033152', null, null, null, '2023-03-18 22:59:57', '2023-11-20 10:15:03', '5', 'Notification');
INSERT INTO `system_menu` VALUES ('dcd3a28d-df75-40fb-ba78-57dae14f6a0d', 'Sat Jan 06 15:41:06 CST 2024', '会员管理', '/admin/vip', '/admin/vip', 'LayoutAdmin', '2', 'vip', null, null, null, '', '2024-01-06 15:41:06', '2024-01-29 13:59:37', '3', 'VIP');
INSERT INTO `system_menu` VALUES ('e6e98c21-f37a-4dc2-89ec-85266fb5251b', 'Sat Jan 06 15:19:45 CST 2024', '专业管理', '/admin/organization/OrganizationMajor', '/admin/organization/OrganizationMajor', 'OrganizationMajor', '2', 'organization-major', 'b2ded452-945c-4e0e-a43b-be5bfae2a24c', null, null, '', '2024-01-06 15:19:45', null, '3', 'OrganizationMajor');
INSERT INTO `system_menu` VALUES ('edf03e6c-81e1-48c5-a6a2-a77bfd5dfe9e', 'Thu Jan 04 22:51:33 CST 2024', '学校管理', '/admin/organization/OrganizationMaster', '/admin/organization/OrganizationMaster', 'OrganizationMaster', '2', 'organization-master', 'b2ded452-945c-4e0e-a43b-be5bfae2a24c', null, null, '', '2024-01-04 22:51:33', '2024-01-18 10:38:36', '5', 'OrganizationMaster');
INSERT INTO `system_menu` VALUES ('fdb522fa-feec-4024-83ce-34cee78c13bb', 'Sat Jan 06 15:25:07 CST 2024', '科目管理', '/admin/question/QuestionSubject', '/admin/question/QuestionSubject', 'QuestionSubject', '2', 'question-subject', '98aa2937-2d0e-4438-a6cc-9c8bb7080175', null, null, '', '2024-01-06 15:25:07', '2024-01-18 10:38:59', '5', 'QuestionSubject');
-- ----------------------------
-- Table structure for system_notification
-- ----------------------------
DROP TABLE IF EXISTS `system_notification`;
CREATE TABLE `system_notification` (
`id` varchar(64) NOT NULL COMMENT 'id',
`title` varchar(256) DEFAULT NULL COMMENT 'key',
`context` text COMMENT 'value',
`department` varchar(256) DEFAULT NULL COMMENT 'level',
`category` varchar(256) DEFAULT NULL COMMENT 'category',
`nlevel` int(11) DEFAULT NULL,
`keywords` varchar(256) DEFAULT NULL,
`actionby` varchar(126) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`publisher` varchar(128) DEFAULT NULL,
`publishdatetime` datetime DEFAULT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of system_notification
-- ----------------------------
INSERT INTO `system_notification` VALUES ('a805a0c8-1aa1-47ca-9455-086fdf32211b', '系统内部调整通知', 'sfdafdsa
', 'IT', 'Adjust', '1', 'Internal Adjust', '', '1', '', null, '0', '', '2023-12-15 16:46:37', '2023-12-21 10:34:50');
-- ----------------------------
-- Table structure for vip_coupon_active
-- ----------------------------
DROP TABLE IF EXISTS `vip_coupon_active`;
CREATE TABLE `vip_coupon_active` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`status` int(11) DEFAULT NULL COMMENT '状态',
`type` int(11) DEFAULT NULL COMMENT '优惠券类型',
`activityname` varchar(256) DEFAULT NULL COMMENT '活动名称',
`code` varchar(64) DEFAULT NULL COMMENT '优惠券号',
`distributioncondition` varchar(255) DEFAULT NULL COMMENT '领取条件',
`amount` decimal(18,5) DEFAULT NULL COMMENT '面值',
`discount` decimal(18,5) DEFAULT NULL,
`discountrate` decimal(18,5) DEFAULT NULL COMMENT '折扣率',
`validdatefrom` datetime DEFAULT NULL COMMENT '有效期开始时间',
`validdateto` datetime DEFAULT NULL COMMENT '有效期结束时间',
`issuingtime` datetime DEFAULT NULL COMMENT '发放时间',
`usagetime` datetime DEFAULT NULL COMMENT '使用时间',
`orderno` varchar(256) DEFAULT NULL COMMENT '使用订单号',
`masterid` varchar(64) DEFAULT NULL,
`mastercode` varchar(64) DEFAULT NULL,
`mastername` varchar(128) DEFAULT NULL COMMENT '姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vip_coupon_active
-- ----------------------------
INSERT INTO `vip_coupon_active` VALUES ('83f72f40-3ecd-427c-82ef-8a81635faaa0', null, '', '2024-01-29 15:31:02', '2024-01-29 15:48:07', '0', '2', '春节代金券', 'M0000001', '', '100.00000', '10.00000', '0.20000', '2024-01-29 08:00:00', '2024-01-31 08:00:00', null, null, null, null, null, null);
INSERT INTO `vip_coupon_active` VALUES ('8f54c3b7-9ab5-479c-866a-3a8bef3f909a', null, '', '2024-02-02 16:22:04', null, '0', '0', '春节狂欢节', 'M0000002', '', null, '1.00000', null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for vip_coupon_history
-- ----------------------------
DROP TABLE IF EXISTS `vip_coupon_history`;
CREATE TABLE `vip_coupon_history` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`status` int(11) DEFAULT NULL COMMENT '状态',
`type` int(11) DEFAULT NULL COMMENT '优惠券类型',
`activityname` varchar(256) DEFAULT NULL COMMENT '活动名称',
`code` varchar(64) DEFAULT NULL COMMENT '优惠券号',
`distributioncondition` varchar(255) DEFAULT NULL COMMENT '领取条件',
`amount` decimal(18,5) DEFAULT NULL COMMENT '面值',
`discount` decimal(18,5) DEFAULT NULL,
`discountrate` decimal(18,5) DEFAULT NULL COMMENT '折扣率',
`validdatefrom` datetime DEFAULT NULL COMMENT '有效期开始时间',
`validdateto` datetime DEFAULT NULL COMMENT '有效期结束时间',
`issuingtime` datetime DEFAULT NULL COMMENT '发放时间',
`usagetime` datetime DEFAULT NULL COMMENT '使用时间',
`orderno` varchar(256) DEFAULT NULL COMMENT '使用订单号',
`masterid` varchar(64) DEFAULT NULL,
`mastercode` varchar(64) DEFAULT NULL,
`mastername` varchar(128) DEFAULT NULL COMMENT '姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vip_coupon_history
-- ----------------------------
INSERT INTO `vip_coupon_history` VALUES ('bed69e9d-f14e-4583-8ded-69ec34226e62', '0', '', '2022-11-15 15:11:38', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `vip_coupon_history` VALUES ('cdae7880-7708-4d10-aedf-dddcd06eefd8', '0', null, '2022-11-16 15:21:56', '2022-11-16 15:40:49', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `vip_coupon_history` VALUES ('fc155403-3bf5-4de5-9a20-99b9a3211d6d', '0', null, '2022-12-06 14:31:02', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for vip_deposit_activity
-- ----------------------------
DROP TABLE IF EXISTS `vip_deposit_activity`;
CREATE TABLE `vip_deposit_activity` (
`id` varchar(64) NOT NULL,
`status` int(11) DEFAULT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(256) DEFAULT NULL,
`name` varchar(256) DEFAULT NULL,
`description` varchar(1024) DEFAULT NULL,
`amount` decimal(18,5) DEFAULT NULL,
`discount` decimal(18,5) DEFAULT NULL,
`present` decimal(18,5) DEFAULT NULL,
`discountrate` decimal(18,5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vip_deposit_activity
-- ----------------------------
INSERT INTO `vip_deposit_activity` VALUES ('7323a345-7796-4800-b80b-c7b4ca87f10a', '0', '0', null, '2024-01-29 11:55:03', '2024-01-29 14:30:40', 'V0000001', '50', '充50送10', '50.00000', '0.00000', '0.00000', '0.75000');
INSERT INTO `vip_deposit_activity` VALUES ('b1a5ca4e-ecad-420f-8049-c7897e9b09b5', '0', '0', null, '2024-01-29 11:56:09', '2024-02-21 10:21:37', 'V0000002', '0.1', '', '0.10000', '0.00000', '0.00000', '0.10000');
INSERT INTO `vip_deposit_activity` VALUES ('d632c76b-b547-4556-bce0-7276100a905c', '0', '0', null, '2024-01-29 11:56:57', '2024-01-29 14:29:32', 'V0000003', '100', '充100送高级VIP', '100.00000', '0.00000', '0.00000', '0.85000');
-- ----------------------------
-- Table structure for vip_master
-- ----------------------------
DROP TABLE IF EXISTS `vip_master`;
CREATE TABLE `vip_master` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`code` varchar(64) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL COMMENT '姓名',
`diamondtype` int(11) DEFAULT NULL COMMENT '会员等级',
`type` int(11) DEFAULT NULL COMMENT '类型',
`discountrate` decimal(18,5) DEFAULT NULL COMMENT '折扣',
`idcard` varchar(64) DEFAULT NULL COMMENT '身份证号',
`gender` tinyint(1) DEFAULT NULL COMMENT '性别',
`birthday` datetime DEFAULT NULL COMMENT '出生日期',
`openid` varchar(64) DEFAULT NULL,
`nickname` varchar(128) DEFAULT NULL,
`language` varchar(64) DEFAULT NULL,
`city` varchar(128) DEFAULT NULL,
`province` varchar(128) DEFAULT NULL,
`country` varchar(128) DEFAULT NULL,
`avatarurl` varchar(1024) DEFAULT NULL,
`cellphone` varchar(64) DEFAULT NULL,
`token` varchar(1024) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vip_master
-- ----------------------------
INSERT INTO `vip_master` VALUES ('0d9d1d9c-9be8-4dc1-9102-be8b10110c27', '0', null, '2024-01-24 10:09:07', '2024-02-19 09:44:34', 'V0000001', '你瞅啥！', '3', null, null, null, '1', null, 'oTpYX5CAjqlHAd40oY_NHn5M5VYQ', '你瞅啥！', null, null, null, null, 'https://www.wisdomdeliver.com:443/static/picture//873b803f-d485-4324-89c1-1e78781ee6d1-20240219094423.jpg', '15122116943', null, null);
INSERT INTO `vip_master` VALUES ('5a25fcac-9204-4dad-80da-afe71e0c711c', '0', '', '2024-02-06 15:48:02', '2024-02-19 09:46:14', 'V0000003', 'A', '1', null, '0.80000', null, '0', '2024-02-19 00:00:00', null, '花花', null, '天津', '天津', '中国', 'https://www.wisdomdeliver.com:443/static/picture//0c9b7ee6-49fc-4d3a-8f19-c8f49ed5f04e-20240219093757.jpg', '18222062609', null, null);
INSERT INTO `vip_master` VALUES ('7c1c595c-4946-4eb3-b34e-f896f2a94d0b', '0', null, '2024-01-24 09:58:43', '2024-02-06 15:28:16', 'V0000002', null, '2', null, null, null, null, null, 'oTpYX5D2LTRnAEH300ZqPep6_eso', '微信用户', null, null, null, null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, null, null);
-- ----------------------------
-- Table structure for vip_master_organization
-- ----------------------------
DROP TABLE IF EXISTS `vip_master_organization`;
CREATE TABLE `vip_master_organization` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`masterid` varchar(64) DEFAULT NULL,
`mastercode` varchar(64) DEFAULT NULL,
`mastername` varchar(128) DEFAULT NULL COMMENT '姓名',
`organizationid` varchar(64) DEFAULT NULL,
`organizationname` varchar(256) DEFAULT NULL,
`organizationcode` varchar(256) DEFAULT NULL,
`departmentid` varchar(64) DEFAULT NULL,
`departmentname` varchar(256) DEFAULT NULL,
`departmentcode` varchar(256) DEFAULT NULL,
`majorid` varchar(64) DEFAULT NULL,
`majorname` varchar(256) DEFAULT NULL,
`majorcode` varchar(256) DEFAULT NULL,
`gradeid` varchar(64) DEFAULT NULL,
`gradename` varchar(256) DEFAULT NULL,
`gradecode` varchar(256) DEFAULT NULL,
`classid` varchar(64) DEFAULT NULL,
`classname` varchar(256) DEFAULT NULL,
`classcode` varchar(256) DEFAULT NULL,
`updatecount` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vip_master_organization
-- ----------------------------
INSERT INTO `vip_master_organization` VALUES ('31bf9add-6d9e-4ad2-995d-3e7a252136c3', '0', null, '2024-01-21 23:36:56', '2024-02-20 14:07:10', '0d9d1d9c-9be8-4dc1-9102-be8b10110c27', null, '你瞅啥！', 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '5b718983-9508-40f4-aeba-22aad1b55e47', '电子信息与科学', 'M007', null, null, null, null, null, null, '12');
INSERT INTO `vip_master_organization` VALUES ('5df9f2d6-d6db-4155-8517-b8af4d55d3b7', '0', null, '2024-01-25 11:27:41', '2024-02-07 11:32:56', '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, 'fd53196d-a456-4801-a524-bbed67104056', '麻省理工大学', 'B0002', 'e27244bc-8240-4b12-bef2-003ded033148', '工商管理学院', 'D003', '5b718983-9508-40f4-aeba-22aad1b55e47', '电子信息与科学', 'M007', null, null, null, null, null, null, '2');
-- ----------------------------
-- Table structure for vip_master_paper_relation
-- ----------------------------
DROP TABLE IF EXISTS `vip_master_paper_relation`;
CREATE TABLE `vip_master_paper_relation` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`masterid` varchar(64) DEFAULT NULL,
`mastercode` varchar(64) DEFAULT NULL,
`mastername` varchar(128) DEFAULT NULL COMMENT '姓名',
`paperid` varchar(64) DEFAULT NULL,
`papercode` varchar(64) DEFAULT NULL,
`papername` varchar(128) DEFAULT NULL COMMENT '姓名',
`buyedtime` datetime DEFAULT NULL,
`amount` decimal(18,5) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vip_master_paper_relation
-- ----------------------------
INSERT INTO `vip_master_paper_relation` VALUES ('1f9eb506-dc3c-41e2-a9c2-226a6b2bbf1d', '0', null, '2024-01-31 15:06:45', '2024-01-31 15:07:00', '0d9d1d9c-9be8-4dc1-9102-be8b10110c27', null, null, '3a4cfd45-9303-4ed6-97cd-a50a7ce967c4', null, '实训答辩', '2024-01-31 15:06:45', '0.10000', '2');
-- ----------------------------
-- Table structure for vip_master_wallet
-- ----------------------------
DROP TABLE IF EXISTS `vip_master_wallet`;
CREATE TABLE `vip_master_wallet` (
`id` varchar(64) NOT NULL,
`isdeleted` tinyint(1) DEFAULT NULL COMMENT 'isdeleted or not',
`remark` varchar(1024) DEFAULT NULL COMMENT 'remark',
`createtime` datetime DEFAULT NULL COMMENT 'create time',
`updatetime` datetime DEFAULT NULL COMMENT 'latest update time',
`masterid` varchar(64) DEFAULT NULL,
`mastercode` varchar(64) DEFAULT NULL,
`mastername` varchar(128) DEFAULT NULL COMMENT '姓名',
`balance` decimal(18,5) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of vip_master_wallet
-- ----------------------------
INSERT INTO `vip_master_wallet` VALUES ('1b7f1c0f-1d5e-42f6-98a0-55cbada15ed6', '0', null, '2024-01-29 11:40:59', '2024-02-20 14:13:49', '7c1c595c-4946-4eb3-b34e-f896f2a94d0b', null, null, '160.02000', null);
INSERT INTO `vip_master_wallet` VALUES ('78283ade-53c7-4150-babc-a92e1a7ec3bb', '0', null, '2024-01-29 17:15:28', '2024-01-31 15:06:45', '0d9d1d9c-9be8-4dc1-9102-be8b10110c27', null, null, '48.95000', null);