Inicio Explorar Ayuda
Registro Iniciar sesión
seeseele
/
xmg_backend
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Árbol: 2464278753
Ramas Etiquetas
xmg_backend
/
sql
/
vrproject.sql

vrproject.sql 157 KB
Histórico Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : localhost
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80033
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : vrproject
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80033
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 01/07/2023 02:01:13
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for gen_table
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `gen_table`;
    24. 

  24. CREATE TABLE `gen_table`  (
    25. 

  25.   `table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    26. 

  26.   `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '表名称',
    27. 

  27.   `table_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '表描述',
    28. 

  28.   `sub_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联子表的表名',
    29. 

  29.   `sub_table_fk_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '子表关联的外键名',
    30. 

  30.   `class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '实体类名称',
    31. 

  31.   `tpl_category` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
    32. 

  32.   `package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生成包路径',
    33. 

  33.   `module_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生成模块名',
    34. 

  34.   `business_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生成业务名',
    35. 

  35.   `function_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生成功能名',
    36. 

  36.   `function_author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生成功能作者',
    37. 

  37.   `gen_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
    38. 

  38.   `gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
    39. 

  39.   `options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '其它生成选项',
    40. 

  40.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    41. 

  41.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    42. 

  42.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    43. 

  43.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    44. 

  44.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    45. 

  45.   PRIMARY KEY (`table_id`) USING BTREE
    46. 

  46. ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代码生成业务表' ROW_FORMAT = DYNAMIC;
    47. 

  47. 

  48. -- ----------------------------
    49. 

  49. -- Records of gen_table
    50. 

  50. -- ----------------------------
    51. 

  51. INSERT INTO `gen_table` VALUES (18, 'vr_data_type', '数据类型', NULL, NULL, 'DataType', 'crud', 'com.ruoyi.project.VRdemo', 'VRdemo', 'datatype', '数据类型', 'ruoyi', '0', '/', '{\"parentMenuId\":\"\"}', 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10', NULL);
    52. 

  52. INSERT INTO `gen_table` VALUES (19, 'vr_app', '应用表', NULL, NULL, 'App', 'crud', 'com.ruoyi.project.VRdemo', 'VRdemo', 'app', '应用', 'ruoyi', '0', '/', '{\"parentMenuId\":\"\"}', 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17', NULL);
    53. 

  53. INSERT INTO `gen_table` VALUES (20, 'vr_data_source', '数据源', NULL, NULL, 'DataSource', 'crud', 'com.ruoyi.project.VRdemo', 'VRdemo', 'datasource', '数据源管理', 'ruoyi', '0', '/', '{\"parentMenuId\":\"\"}', 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37', NULL);
    54. 

  54. INSERT INTO `gen_table` VALUES (21, 'vr_image_data', '图片数据', NULL, NULL, 'ImageData', 'crud', 'com.ruoyi.project.VRdemo', 'data', 'data', 'data', 'ruoyi', '0', '/', '{\"parentMenuId\":\"\"}', 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55', NULL);
    55. 

  55. INSERT INTO `gen_table` VALUES (22, 'vr_video_data', '视频的数据', NULL, NULL, 'VideoData', 'crud', 'com.ruoyi.project.VRdemo', 'videoData', 'videoDemo', 'videoData', 'ruoyi', '0', '/', '{\"parentMenuId\":\"\"}', 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08', NULL);
    56. 

  56. INSERT INTO `gen_table` VALUES (23, 'vr_company_app', '公司应用表', NULL, NULL, 'CompanyApp', 'crud', 'com.ruoyi.project.VRdemo', 'companyapp', 'companyapp', 'companyapp', 'ruoyi', '0', '/', '{\"parentMenuId\":\"\"}', 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16', NULL);
    57. 

  57. 

  58. -- ----------------------------
    59. 

  59. -- Table structure for gen_table_column
    60. 

  60. -- ----------------------------
    61. 

  61. DROP TABLE IF EXISTS `gen_table_column`;
    62. 

  62. CREATE TABLE `gen_table_column`  (
    63. 

  63.   `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    64. 

  64.   `table_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '归属表编号',
    65. 

  65.   `column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '列名称',
    66. 

  66.   `column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '列描述',
    67. 

  67.   `column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '列类型',
    68. 

  68.   `java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
    69. 

  69.   `java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
    70. 

  70.   `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
    71. 

  71.   `is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
    72. 

  72.   `is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
    73. 

  73.   `is_insert` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）',
    74. 

  74.   `is_edit` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）',
    75. 

  75.   `is_list` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）',
    76. 

  76.   `is_query` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）',
    77. 

  77.   `query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
    78. 

  78.   `html_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
    79. 

  79.   `dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
    80. 

  80.   `sort` int NULL DEFAULT NULL COMMENT '排序',
    81. 

  81.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    82. 

  82.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    83. 

  83.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    84. 

  84.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    85. 

  85.   PRIMARY KEY (`column_id`) USING BTREE
    86. 

  86. ) ENGINE = InnoDB AUTO_INCREMENT = 256 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = DYNAMIC;
    87. 

  87. 

  88. -- ----------------------------
    89. 

  89. -- Records of gen_table_column
    90. 

  90. -- ----------------------------
    91. 

  91. INSERT INTO `gen_table_column` VALUES (187, '18', 'data_type_id', 'ID', 'int', 'Long', 'dataTypeId', '1', '1', NULL, '0', NULL, '1', NULL, 'EQ', 'input', '', 1, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    92. 

  92. INSERT INTO `gen_table_column` VALUES (188, '18', 'title', '名称', 'varchar(20)', 'String', 'title', '0', '0', '1', '1', '1', '1', '1', 'LIKE', 'input', '', 2, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    93. 

  93. INSERT INTO `gen_table_column` VALUES (189, '18', 'description', '描述', 'varchar(255)', 'String', 'description', '0', '0', NULL, '1', '1', '1', '0', 'EQ', 'input', '', 3, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    94. 

  94. INSERT INTO `gen_table_column` VALUES (190, '18', 'component', '组件', 'varchar(20)', 'String', 'component', '0', '0', '1', '1', '1', '1', '0', 'EQ', 'input', '', 4, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    95. 

  95. INSERT INTO `gen_table_column` VALUES (191, '18', 'spotType', 'spot类型', 'tinyint(1)', 'Integer', 'spotType', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'select', '', 5, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    96. 

  96. INSERT INTO `gen_table_column` VALUES (192, '18', 'parameters', '参数', 'text', 'String', 'parameters', '0', '0', '1', '1', '1', '0', '0', 'EQ', 'textarea', '', 6, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    97. 

  97. INSERT INTO `gen_table_column` VALUES (193, '18', 'status', '状态', 'tinyint(1)', 'Integer', 'status', '0', '0', '1', '0', '1', '1', '1', 'EQ', 'radio', '', 7, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    98. 

  98. INSERT INTO `gen_table_column` VALUES (194, '18', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '0', NULL, NULL, NULL, 'EQ', 'input', '', 8, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    99. 

  99. INSERT INTO `gen_table_column` VALUES (195, '18', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '0', NULL, '1', NULL, 'EQ', 'datetime', '', 9, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    100. 

  100. INSERT INTO `gen_table_column` VALUES (196, '18', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '0', '0', NULL, NULL, 'EQ', 'input', '', 10, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    101. 

  101. INSERT INTO `gen_table_column` VALUES (197, '18', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '0', '0', '1', NULL, 'EQ', 'datetime', '', 11, 'admin', '2023-05-20 16:58:01', '', '2023-05-20 17:02:10');
    102. 

  102. INSERT INTO `gen_table_column` VALUES (198, '19', 'app_id', 'ID', 'int', 'Long', 'appId', '1', '1', NULL, '0', NULL, '1', '1', 'EQ', 'input', '', 1, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    103. 

  103. INSERT INTO `gen_table_column` VALUES (199, '19', 'title', '标题', 'varchar(50)', 'String', 'title', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    104. 

  104. INSERT INTO `gen_table_column` VALUES (200, '19', 'price', '价格', 'decimal(15,2)', 'BigDecimal', 'price', '0', '0', '1', '1', '1', '1', '0', 'EQ', 'input', '', 3, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    105. 

  105. INSERT INTO `gen_table_column` VALUES (201, '19', 'path', '存储路径', 'varchar(100)', 'String', 'path', '0', '0', '1', '1', '1', '0', '0', 'EQ', 'input', '', 4, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    106. 

  106. INSERT INTO `gen_table_column` VALUES (202, '19', 'spots', '预设展示点', 'text', 'String', 'spots', '0', '0', '1', '1', '1', '0', '0', 'EQ', 'textarea', '', 5, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    107. 

  107. INSERT INTO `gen_table_column` VALUES (203, '19', 'status', '状态', 'tinyint(1)', 'Integer', 'status', '0', '0', '1', '0', '1', '1', '1', 'EQ', 'radio', '', 6, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    108. 

  108. INSERT INTO `gen_table_column` VALUES (204, '19', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '0', NULL, NULL, NULL, 'EQ', 'input', '', 7, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    109. 

  109. INSERT INTO `gen_table_column` VALUES (205, '19', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '0', NULL, '1', NULL, 'EQ', 'datetime', '', 8, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    110. 

  110. INSERT INTO `gen_table_column` VALUES (206, '19', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '0', '0', NULL, NULL, 'EQ', 'input', '', 9, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    111. 

  111. INSERT INTO `gen_table_column` VALUES (207, '19', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '0', '0', '1', NULL, 'EQ', 'datetime', '', 10, 'admin', '2023-05-20 19:25:50', '', '2023-05-20 19:32:17');
    112. 

  112. INSERT INTO `gen_table_column` VALUES (208, '20', 'data_source_id', '自增id', 'int', 'Long', 'dataSourceId', '1', '1', NULL, '0', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    113. 

  113. INSERT INTO `gen_table_column` VALUES (209, '20', 'company_id', '所属企业ID', 'int', 'Long', 'companyId', '0', '0', '0', '0', '0', '0', '0', 'EQ', 'input', '', 2, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    114. 

  114. INSERT INTO `gen_table_column` VALUES (210, '20', 'company_app_id', '所属应用ID', 'int', 'Long', 'companyAppId', '0', '0', '0', '0', '0', '0', '0', 'EQ', 'input', '', 3, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    115. 

  115. INSERT INTO `gen_table_column` VALUES (211, '20', 'data_type_id', '数据类型ID', 'int', 'Long', 'dataTypeId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', 'data_type', 4, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    116. 

  116. INSERT INTO `gen_table_column` VALUES (212, '20', 'extend_id', '扩展ID', 'int', 'Long', 'extendId', '0', '0', '0', '0', '0', '0', '0', 'EQ', 'input', '', 5, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    117. 

  117. INSERT INTO `gen_table_column` VALUES (213, '20', 'spot', '展示点', 'varchar(20)', 'String', 'spot', '0', '0', '1', '1', '1', '1', '1', 'LIKE', 'input', '', 6, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    118. 

  118. INSERT INTO `gen_table_column` VALUES (214, '20', 'storage_id', '存储ID', 'int', 'Long', 'storageId', '0', '0', '0', '0', '0', '0', '0', 'EQ', 'input', '', 7, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    119. 

  119. INSERT INTO `gen_table_column` VALUES (215, '20', 'title', '数据源标题', 'varchar(50)', 'String', 'title', '0', '0', '1', '1', '1', '1', '1', 'LIKE', 'input', '', 8, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    120. 

  120. INSERT INTO `gen_table_column` VALUES (216, '20', 'setting', '数据源设置信息', 'text', 'String', 'setting', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'textarea', '', 9, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    121. 

  121. INSERT INTO `gen_table_column` VALUES (217, '20', 'status', '数据源状态(0表示未审核，1表示审核通过，-1表示审核不通过) 默认值为0', 'tinyint(1)', 'Integer', 'status', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', '', 10, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    122. 

  122. INSERT INTO `gen_table_column` VALUES (218, '20', 'view_counts', '浏览量 默认值为0', 'int', 'Long', 'viewCounts', '0', '0', NULL, '0', '0', '0', '0', 'EQ', 'input', '', 11, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    123. 

  123. INSERT INTO `gen_table_column` VALUES (219, '20', 'click_rate', '点击量 默认值为0', 'float', 'Long', 'clickRate', '0', '0', NULL, '0', '0', '0', '0', 'EQ', 'input', '', 12, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    124. 

  124. INSERT INTO `gen_table_column` VALUES (220, '20', 'cache', '数据源缓存信息', 'text', 'String', 'cache', '0', '0', '0', '0', '0', '0', '0', 'EQ', 'textarea', '', 13, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    125. 

  125. INSERT INTO `gen_table_column` VALUES (221, '20', 'cache_time', '数据源缓存时间', 'datetime', 'Date', 'cacheTime', '0', '0', '0', '0', '0', '0', '0', 'EQ', 'datetime', '', 14, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    126. 

  126. INSERT INTO `gen_table_column` VALUES (222, '20', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '0', NULL, NULL, NULL, 'EQ', 'input', '', 15, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    127. 

  127. INSERT INTO `gen_table_column` VALUES (223, '20', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '0', NULL, NULL, NULL, 'EQ', 'datetime', '', 16, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    128. 

  128. INSERT INTO `gen_table_column` VALUES (224, '20', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '0', '0', NULL, NULL, 'EQ', 'input', '', 17, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    129. 

  129. INSERT INTO `gen_table_column` VALUES (225, '20', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '0', '0', NULL, NULL, 'EQ', 'datetime', '', 18, 'admin', '2023-05-26 14:07:23', '', '2023-06-06 14:18:37');
    130. 

  130. INSERT INTO `gen_table_column` VALUES (226, '21', 'image_data_id', '自增id', 'int', 'Long', 'imageDataId', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    131. 

  131. INSERT INTO `gen_table_column` VALUES (227, '21', 'company_id', '企业ID', 'int', 'Long', 'companyId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    132. 

  132. INSERT INTO `gen_table_column` VALUES (228, '21', 'data_source_id', '数据源ID', 'int', 'Long', 'dataSourceId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    133. 

  133. INSERT INTO `gen_table_column` VALUES (229, '21', 'storage_id', '存储ID', 'int', 'Long', 'storageId', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    134. 

  134. INSERT INTO `gen_table_column` VALUES (230, '21', 'size', '图片大小', 'int', 'Long', 'size', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 5, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    135. 

  135. INSERT INTO `gen_table_column` VALUES (231, '21', 'path', '图片存储路径', 'varchar(100)', 'String', 'path', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 6, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    136. 

  136. INSERT INTO `gen_table_column` VALUES (232, '21', 'url', '关联链接', 'varchar(255)', 'String', 'url', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    137. 

  137. INSERT INTO `gen_table_column` VALUES (233, '21', 'create_time', '图片上传时间', 'datetime', 'Date', 'createTime', '0', '0', '1', '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 8, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    138. 

  138. INSERT INTO `gen_table_column` VALUES (234, '21', 'update_time', '图片更新时间', 'datetime', 'Date', 'updateTime', '0', '0', '1', '1', '1', NULL, NULL, 'EQ', 'datetime', '', 9, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:07:55');
    139. 

  139. INSERT INTO `gen_table_column` VALUES (235, '22', 'video_data_id', '自增id', 'int', 'Long', 'videoDataId', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    140. 

  140. INSERT INTO `gen_table_column` VALUES (236, '22', 'company_id', '所属企业ID', 'int', 'Long', 'companyId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    141. 

  141. INSERT INTO `gen_table_column` VALUES (237, '22', 'data_source_id', '数据源ID', 'int', 'Long', 'dataSourceId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    142. 

  142. INSERT INTO `gen_table_column` VALUES (238, '22', 'storage_id', '存储ID', 'int', 'Long', 'storageId', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    143. 

  143. INSERT INTO `gen_table_column` VALUES (239, '22', 'size', '视频文件大小', 'int', 'Long', 'size', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 5, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    144. 

  144. INSERT INTO `gen_table_column` VALUES (240, '22', 'path', '视频文件存储路径', 'varchar(100)', 'String', 'path', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 6, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    145. 

  145. INSERT INTO `gen_table_column` VALUES (241, '22', 'url', '视频访问URL', 'varchar(255)', 'String', 'url', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    146. 

  146. INSERT INTO `gen_table_column` VALUES (242, '22', 'cover', '视频封面图URL', 'varchar(100)', 'String', 'cover', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 8, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    147. 

  147. INSERT INTO `gen_table_column` VALUES (243, '22', 'type', '视频文件类型(0 mp4 1 avi 2 wmv 3 mov 4 flv)', 'tinyint(1)', 'Integer', 'type', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'select', '', 9, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    148. 

  148. INSERT INTO `gen_table_column` VALUES (244, '22', 'create_time', '视频上传时间', 'datetime', 'Date', 'createTime', '0', '0', '1', '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 10, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    149. 

  149. INSERT INTO `gen_table_column` VALUES (245, '22', 'update_time', '视频更新时间', 'datetime', 'Date', 'updateTime', '0', '0', '1', '1', '1', NULL, NULL, 'EQ', 'datetime', '', 11, 'admin', '2023-05-29 16:05:16', '', '2023-05-29 16:09:08');
    150. 

  150. INSERT INTO `gen_table_column` VALUES (246, '23', 'company_app_id', '自增id', 'int', 'Long', 'companyAppId', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    151. 

  151. INSERT INTO `gen_table_column` VALUES (247, '23', 'company_id', '所属企业ID', 'int', 'Long', 'companyId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    152. 

  152. INSERT INTO `gen_table_column` VALUES (248, '23', 'app_id', '应用模板ID', 'int', 'Long', 'appId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    153. 

  153. INSERT INTO `gen_table_column` VALUES (249, '23', 'name', '应用名称', 'varchar(100)', 'String', 'name', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 4, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    154. 

  154. INSERT INTO `gen_table_column` VALUES (250, '23', 'logo', '应用图标', 'varchar(100)', 'String', 'logo', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 5, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    155. 

  155. INSERT INTO `gen_table_column` VALUES (251, '23', 'cover', '应用封面图', 'varchar(100)', 'String', 'cover', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 6, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    156. 

  156. INSERT INTO `gen_table_column` VALUES (252, '23', 'setting', '应用设置信息', 'text', 'String', 'setting', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'textarea', '', 7, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    157. 

  157. INSERT INTO `gen_table_column` VALUES (253, '23', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 8, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    158. 

  158. INSERT INTO `gen_table_column` VALUES (254, '23', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 9, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    159. 

  159. INSERT INTO `gen_table_column` VALUES (255, '23', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 10, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    160. 

  160. INSERT INTO `gen_table_column` VALUES (256, '23', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', '', 11, 'admin', '2023-06-01 17:04:47', '', '2023-06-01 17:07:16');
    161. 

  161. 

  162. -- ----------------------------
    163. 

  163. -- Table structure for qrtz_blob_triggers
    164. 

  164. -- ----------------------------
    165. 

  165. DROP TABLE IF EXISTS `qrtz_blob_triggers`;
    166. 

  166. CREATE TABLE `qrtz_blob_triggers`  (
    167. 

  167.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    168. 

  168.   `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
    169. 

  169.   `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
    170. 

  170.   `blob_data` blob NULL COMMENT '存放持久化Trigger对象',
    171. 

  171.   PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
    172. 

  172.   CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
    173. 

  173. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Blob类型的触发器表' ROW_FORMAT = DYNAMIC;
    174. 

  174. 

  175. -- ----------------------------
    176. 

  176. -- Records of qrtz_blob_triggers
    177. 

  177. -- ----------------------------
    178. 

  178. 

  179. -- ----------------------------
    180. 

  180. -- Table structure for qrtz_calendars
    181. 

  181. -- ----------------------------
    182. 

  182. DROP TABLE IF EXISTS `qrtz_calendars`;
    183. 

  183. CREATE TABLE `qrtz_calendars`  (
    184. 

  184.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    185. 

  185.   `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '日历名称',
    186. 

  186.   `calendar` blob NOT NULL COMMENT '存放持久化calendar对象',
    187. 

  187.   PRIMARY KEY (`sched_name`, `calendar_name`) USING BTREE
    188. 

  188. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '日历信息表' ROW_FORMAT = DYNAMIC;
    189. 

  189. 

  190. -- ----------------------------
    191. 

  191. -- Records of qrtz_calendars
    192. 

  192. -- ----------------------------
    193. 

  193. 

  194. -- ----------------------------
    195. 

  195. -- Table structure for qrtz_cron_triggers
    196. 

  196. -- ----------------------------
    197. 

  197. DROP TABLE IF EXISTS `qrtz_cron_triggers`;
    198. 

  198. CREATE TABLE `qrtz_cron_triggers`  (
    199. 

  199.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    200. 

  200.   `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
    201. 

  201.   `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
    202. 

  202.   `cron_expression` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'cron表达式',
    203. 

  203.   `time_zone_id` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '时区',
    204. 

  204.   PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
    205. 

  205.   CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
    206. 

  206. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Cron类型的触发器表' ROW_FORMAT = DYNAMIC;
    207. 

  207. 

  208. -- ----------------------------
    209. 

  209. -- Records of qrtz_cron_triggers
    210. 

  210. -- ----------------------------
    211. 

  211. 

  212. -- ----------------------------
    213. 

  213. -- Table structure for qrtz_fired_triggers
    214. 

  214. -- ----------------------------
    215. 

  215. DROP TABLE IF EXISTS `qrtz_fired_triggers`;
    216. 

  216. CREATE TABLE `qrtz_fired_triggers`  (
    217. 

  217.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    218. 

  218.   `entry_id` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度器实例id',
    219. 

  219.   `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
    220. 

  220.   `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
    221. 

  221.   `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度器实例名',
    222. 

  222.   `fired_time` bigint NOT NULL COMMENT '触发的时间',
    223. 

  223.   `sched_time` bigint NOT NULL COMMENT '定时器制定的时间',
    224. 

  224.   `priority` int NOT NULL COMMENT '优先级',
    225. 

  225.   `state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '状态',
    226. 

  226.   `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务名称',
    227. 

  227.   `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务组名',
    228. 

  228.   `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否并发',
    229. 

  229.   `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否接受恢复执行',
    230. 

  230.   PRIMARY KEY (`sched_name`, `entry_id`) USING BTREE
    231. 

  231. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '已触发的触发器表' ROW_FORMAT = DYNAMIC;
    232. 

  232. 

  233. -- ----------------------------
    234. 

  234. -- Records of qrtz_fired_triggers
    235. 

  235. -- ----------------------------
    236. 

  236. 

  237. -- ----------------------------
    238. 

  238. -- Table structure for qrtz_job_details
    239. 

  239. -- ----------------------------
    240. 

  240. DROP TABLE IF EXISTS `qrtz_job_details`;
    241. 

  241. CREATE TABLE `qrtz_job_details`  (
    242. 

  242.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    243. 

  243.   `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名称',
    244. 

  244.   `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务组名',
    245. 

  245.   `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '相关介绍',
    246. 

  246.   `job_class_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行任务类名称',
    247. 

  247.   `is_durable` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '是否持久化',
    248. 

  248.   `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '是否并发',
    249. 

  249.   `is_update_data` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '是否更新数据',
    250. 

  250.   `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '是否接受恢复执行',
    251. 

  251.   `job_data` blob NULL COMMENT '存放持久化job对象',
    252. 

  252.   PRIMARY KEY (`sched_name`, `job_name`, `job_group`) USING BTREE
    253. 

  253. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '任务详细信息表' ROW_FORMAT = DYNAMIC;
    254. 

  254. 

  255. -- ----------------------------
    256. 

  256. -- Records of qrtz_job_details
    257. 

  257. -- ----------------------------
    258. 

  258. 

  259. -- ----------------------------
    260. 

  260. -- Table structure for qrtz_locks
    261. 

  261. -- ----------------------------
    262. 

  262. DROP TABLE IF EXISTS `qrtz_locks`;
    263. 

  263. CREATE TABLE `qrtz_locks`  (
    264. 

  264.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    265. 

  265.   `lock_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '悲观锁名称',
    266. 

  266.   PRIMARY KEY (`sched_name`, `lock_name`) USING BTREE
    267. 

  267. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '存储的悲观锁信息表' ROW_FORMAT = DYNAMIC;
    268. 

  268. 

  269. -- ----------------------------
    270. 

  270. -- Records of qrtz_locks
    271. 

  271. -- ----------------------------
    272. 

  272. 

  273. -- ----------------------------
    274. 

  274. -- Table structure for qrtz_paused_trigger_grps
    275. 

  275. -- ----------------------------
    276. 

  276. DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
    277. 

  277. CREATE TABLE `qrtz_paused_trigger_grps`  (
    278. 

  278.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    279. 

  279.   `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
    280. 

  280.   PRIMARY KEY (`sched_name`, `trigger_group`) USING BTREE
    281. 

  281. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '暂停的触发器表' ROW_FORMAT = DYNAMIC;
    282. 

  282. 

  283. -- ----------------------------
    284. 

  284. -- Records of qrtz_paused_trigger_grps
    285. 

  285. -- ----------------------------
    286. 

  286. 

  287. -- ----------------------------
    288. 

  288. -- Table structure for qrtz_scheduler_state
    289. 

  289. -- ----------------------------
    290. 

  290. DROP TABLE IF EXISTS `qrtz_scheduler_state`;
    291. 

  291. CREATE TABLE `qrtz_scheduler_state`  (
    292. 

  292.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    293. 

  293.   `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '实例名称',
    294. 

  294.   `last_checkin_time` bigint NOT NULL COMMENT '上次检查时间',
    295. 

  295.   `checkin_interval` bigint NOT NULL COMMENT '检查间隔时间',
    296. 

  296.   PRIMARY KEY (`sched_name`, `instance_name`) USING BTREE
    297. 

  297. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '调度器状态表' ROW_FORMAT = DYNAMIC;
    298. 

  298. 

  299. -- ----------------------------
    300. 

  300. -- Records of qrtz_scheduler_state
    301. 

  301. -- ----------------------------
    302. 

  302. 

  303. -- ----------------------------
    304. 

  304. -- Table structure for qrtz_simple_triggers
    305. 

  305. -- ----------------------------
    306. 

  306. DROP TABLE IF EXISTS `qrtz_simple_triggers`;
    307. 

  307. CREATE TABLE `qrtz_simple_triggers`  (
    308. 

  308.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    309. 

  309.   `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
    310. 

  310.   `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
    311. 

  311.   `repeat_count` bigint NOT NULL COMMENT '重复的次数统计',
    312. 

  312.   `repeat_interval` bigint NOT NULL COMMENT '重复的间隔时间',
    313. 

  313.   `times_triggered` bigint NOT NULL COMMENT '已经触发的次数',
    314. 

  314.   PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
    315. 

  315.   CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
    316. 

  316. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '简单触发器的信息表' ROW_FORMAT = DYNAMIC;
    317. 

  317. 

  318. -- ----------------------------
    319. 

  319. -- Records of qrtz_simple_triggers
    320. 

  320. -- ----------------------------
    321. 

  321. 

  322. -- ----------------------------
    323. 

  323. -- Table structure for qrtz_simprop_triggers
    324. 

  324. -- ----------------------------
    325. 

  325. DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
    326. 

  326. CREATE TABLE `qrtz_simprop_triggers`  (
    327. 

  327.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    328. 

  328.   `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
    329. 

  329.   `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
    330. 

  330.   `str_prop_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第一个参数',
    331. 

  331.   `str_prop_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第二个参数',
    332. 

  332.   `str_prop_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第三个参数',
    333. 

  333.   `int_prop_1` int NULL DEFAULT NULL COMMENT 'int类型的trigger的第一个参数',
    334. 

  334.   `int_prop_2` int NULL DEFAULT NULL COMMENT 'int类型的trigger的第二个参数',
    335. 

  335.   `long_prop_1` bigint NULL DEFAULT NULL COMMENT 'long类型的trigger的第一个参数',
    336. 

  336.   `long_prop_2` bigint NULL DEFAULT NULL COMMENT 'long类型的trigger的第二个参数',
    337. 

  337.   `dec_prop_1` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数',
    338. 

  338.   `dec_prop_2` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数',
    339. 

  339.   `bool_prop_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数',
    340. 

  340.   `bool_prop_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数',
    341. 

  341.   PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
    342. 

  342.   CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
    343. 

  343. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '同步机制的行锁表' ROW_FORMAT = DYNAMIC;
    344. 

  344. 

  345. -- ----------------------------
    346. 

  346. -- Records of qrtz_simprop_triggers
    347. 

  347. -- ----------------------------
    348. 

  348. 

  349. -- ----------------------------
    350. 

  350. -- Table structure for qrtz_triggers
    351. 

  351. -- ----------------------------
    352. 

  352. DROP TABLE IF EXISTS `qrtz_triggers`;
    353. 

  353. CREATE TABLE `qrtz_triggers`  (
    354. 

  354.   `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调度名称',
    355. 

  355.   `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '触发器的名字',
    356. 

  356.   `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '触发器所属组的名字',
    357. 

  357.   `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_job_details表job_name的外键',
    358. 

  358.   `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'qrtz_job_details表job_group的外键',
    359. 

  359.   `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '相关介绍',
    360. 

  360.   `next_fire_time` bigint NULL DEFAULT NULL COMMENT '上一次触发时间（毫秒）',
    361. 

  361.   `prev_fire_time` bigint NULL DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）',
    362. 

  362.   `priority` int NULL DEFAULT NULL COMMENT '优先级',
    363. 

  363.   `trigger_state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '触发器状态',
    364. 

  364.   `trigger_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '触发器的类型',
    365. 

  365.   `start_time` bigint NOT NULL COMMENT '开始时间',
    366. 

  366.   `end_time` bigint NULL DEFAULT NULL COMMENT '结束时间',
    367. 

  367.   `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '日程表名称',
    368. 

  368.   `misfire_instr` smallint NULL DEFAULT NULL COMMENT '补偿执行的策略',
    369. 

  369.   `job_data` blob NULL COMMENT '存放持久化job对象',
    370. 

  370.   PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
    371. 

  371.   INDEX `sched_name`(`sched_name` ASC, `job_name` ASC, `job_group` ASC) USING BTREE,
    372. 

  372.   CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
    373. 

  373. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '触发器详细信息表' ROW_FORMAT = DYNAMIC;
    374. 

  374. 

  375. -- ----------------------------
    376. 

  376. -- Records of qrtz_triggers
    377. 

  377. -- ----------------------------
    378. 

  378. 

  379. -- ----------------------------
    380. 

  380. -- Table structure for sys_config
    381. 

  381. -- ----------------------------
    382. 

  382. DROP TABLE IF EXISTS `sys_config`;
    383. 

  383. CREATE TABLE `sys_config`  (
    384. 

  384.   `config_id` int NOT NULL AUTO_INCREMENT COMMENT '参数主键',
    385. 

  385.   `config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '参数名称',
    386. 

  386.   `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '参数键名',
    387. 

  387.   `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '参数键值',
    388. 

  388.   `config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
    389. 

  389.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    390. 

  390.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    391. 

  391.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    392. 

  392.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    393. 

  393.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    394. 

  394.   PRIMARY KEY (`config_id`) USING BTREE
    395. 

  395. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数配置表' ROW_FORMAT = DYNAMIC;
    396. 

  396. 

  397. -- ----------------------------
    398. 

  398. -- Records of sys_config
    399. 

  399. -- ----------------------------
    400. 

  400. INSERT INTO `sys_config` VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2023-04-28 11:55:31', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    401. 

  401. INSERT INTO `sys_config` VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2023-04-28 11:55:31', '', NULL, '初始化密码 123456');
    402. 

  402. INSERT INTO `sys_config` VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2023-04-28 11:55:31', '', NULL, '深色主题theme-dark，浅色主题theme-light');
    403. 

  403. INSERT INTO `sys_config` VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', '2023-04-28 11:55:31', '', NULL, '是否开启验证码功能（true开启，false关闭）');
    404. 

  404. INSERT INTO `sys_config` VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2023-04-28 11:55:31', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
    405. 

  405. 

  406. -- ----------------------------
    407. 

  407. -- Table structure for sys_dept
    408. 

  408. -- ----------------------------
    409. 

  409. DROP TABLE IF EXISTS `sys_dept`;
    410. 

  410. CREATE TABLE `sys_dept`  (
    411. 

  411.   `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id',
    412. 

  412.   `parent_id` bigint NULL DEFAULT 0 COMMENT '父部门id',
    413. 

  413.   `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '祖级列表',
    414. 

  414.   `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '部门名称',
    415. 

  415.   `order_num` int NULL DEFAULT 0 COMMENT '显示顺序',
    416. 

  416.   `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人',
    417. 

  417.   `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话',
    418. 

  418.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
    419. 

  419.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    420. 

  420.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    421. 

  421.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    422. 

  422.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    423. 

  423.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    424. 

  424.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    425. 

  425.   PRIMARY KEY (`dept_id`) USING BTREE
    426. 

  426. ) ENGINE = InnoDB AUTO_INCREMENT = 202 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '部门表' ROW_FORMAT = DYNAMIC;
    427. 

  427. 

  428. -- ----------------------------
    429. 

  429. -- Records of sys_dept
    430. 

  430. -- ----------------------------
    431. 

  431. INSERT INTO `sys_dept` VALUES (100, 0, '0', 'VRO', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', 'admin', '2023-05-08 20:34:06');
    432. 

  432. INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '继续教育学院', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', 'admin', '2023-06-27 23:56:38');
    433. 

  433. INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '元宇宙学院', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', 'admin', '2023-06-27 23:56:49');
    434. 

  434. INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', '', NULL);
    435. 

  435. INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', '', NULL);
    436. 

  436. INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', '', NULL);
    437. 

  437. INSERT INTO `sys_dept` VALUES (106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', '', NULL);
    438. 

  438. INSERT INTO `sys_dept` VALUES (107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-04-28 11:55:31', '', NULL);
    439. 

  439. INSERT INTO `sys_dept` VALUES (108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', '2023-04-28 11:55:31', '', NULL);
    440. 

  440. INSERT INTO `sys_dept` VALUES (109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', '2023-04-28 11:55:31', '', NULL);
    441. 

  441. INSERT INTO `sys_dept` VALUES (200, 102, '0,100,102', '管理部门', 1, NULL, NULL, NULL, '0', '0', 'admin', '2023-05-08 20:39:46', '', NULL);
    442. 

  442. INSERT INTO `sys_dept` VALUES (201, 100, '0,100', '测试总公司2', 3, NULL, NULL, NULL, '0', '0', 'admin', '2023-05-08 20:48:57', '', NULL);
    443. 

  443. 

  444. -- ----------------------------
    445. 

  445. -- Table structure for sys_dict_data
    446. 

  446. -- ----------------------------
    447. 

  447. DROP TABLE IF EXISTS `sys_dict_data`;
    448. 

  448. CREATE TABLE `sys_dict_data`  (
    449. 

  449.   `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
    450. 

  450.   `dict_sort` int NULL DEFAULT 0 COMMENT '字典排序',
    451. 

  451.   `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典标签',
    452. 

  452.   `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典键值',
    453. 

  453.   `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
    454. 

  454.   `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
    455. 

  455.   `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '表格回显样式',
    456. 

  456.   `is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
    457. 

  457.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
    458. 

  458.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    459. 

  459.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    460. 

  460.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    461. 

  461.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    462. 

  462.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    463. 

  463.   PRIMARY KEY (`dict_code`) USING BTREE
    464. 

  464. ) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典数据表' ROW_FORMAT = DYNAMIC;
    465. 

  465. 

  466. -- ----------------------------
    467. 

  467. -- Records of sys_dict_data
    468. 

  468. -- ----------------------------
    469. 

  469. INSERT INTO `sys_dict_data` VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '性别男');
    470. 

  470. INSERT INTO `sys_dict_data` VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '性别女');
    471. 

  471. INSERT INTO `sys_dict_data` VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '性别未知');
    472. 

  472. INSERT INTO `sys_dict_data` VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '显示菜单');
    473. 

  473. INSERT INTO `sys_dict_data` VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '隐藏菜单');
    474. 

  474. INSERT INTO `sys_dict_data` VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '正常状态');
    475. 

  475. INSERT INTO `sys_dict_data` VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '停用状态');
    476. 

  476. INSERT INTO `sys_dict_data` VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '正常状态');
    477. 

  477. INSERT INTO `sys_dict_data` VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '停用状态');
    478. 

  478. INSERT INTO `sys_dict_data` VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '默认分组');
    479. 

  479. INSERT INTO `sys_dict_data` VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '系统分组');
    480. 

  480. INSERT INTO `sys_dict_data` VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '系统默认是');
    481. 

  481. INSERT INTO `sys_dict_data` VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '系统默认否');
    482. 

  482. INSERT INTO `sys_dict_data` VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '通知');
    483. 

  483. INSERT INTO `sys_dict_data` VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '公告');
    484. 

  484. INSERT INTO `sys_dict_data` VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '正常状态');
    485. 

  485. INSERT INTO `sys_dict_data` VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '关闭状态');
    486. 

  486. INSERT INTO `sys_dict_data` VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '其他操作');
    487. 

  487. INSERT INTO `sys_dict_data` VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '新增操作');
    488. 

  488. INSERT INTO `sys_dict_data` VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '修改操作');
    489. 

  489. INSERT INTO `sys_dict_data` VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '删除操作');
    490. 

  490. INSERT INTO `sys_dict_data` VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '授权操作');
    491. 

  491. INSERT INTO `sys_dict_data` VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '导出操作');
    492. 

  492. INSERT INTO `sys_dict_data` VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '导入操作');
    493. 

  493. INSERT INTO `sys_dict_data` VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '强退操作');
    494. 

  494. INSERT INTO `sys_dict_data` VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '生成操作');
    495. 

  495. INSERT INTO `sys_dict_data` VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '清空操作');
    496. 

  496. INSERT INTO `sys_dict_data` VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '正常状态');
    497. 

  497. INSERT INTO `sys_dict_data` VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '停用状态');
    498. 

  498. INSERT INTO `sys_dict_data` VALUES (100, 1, '图片', '3', 'data_type', NULL, 'default', 'N', '0', 'admin', '2023-05-29 14:17:38', '', NULL, NULL);
    499. 

  499. INSERT INTO `sys_dict_data` VALUES (101, 2, '视频', '4', 'data_type', NULL, 'default', 'N', '0', 'admin', '2023-05-29 14:29:29', '', NULL, NULL);
    500. 

  500. INSERT INTO `sys_dict_data` VALUES (102, 3, '场景', '2', 'data_type', NULL, 'default', 'N', '0', 'admin', '2023-05-29 14:37:28', '', NULL, NULL);
    501. 

  501. INSERT INTO `sys_dict_data` VALUES (103, 4, '模型', '1', 'data_type', NULL, 'default', 'N', '0', 'admin', '2023-05-29 14:37:41', '', NULL, NULL);
    502. 

  502. 

  503. -- ----------------------------
    504. 

  504. -- Table structure for sys_dict_type
    505. 

  505. -- ----------------------------
    506. 

  506. DROP TABLE IF EXISTS `sys_dict_type`;
    507. 

  507. CREATE TABLE `sys_dict_type`  (
    508. 

  508.   `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
    509. 

  509.   `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典名称',
    510. 

  510.   `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
    511. 

  511.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
    512. 

  512.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    513. 

  513.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    514. 

  514.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    515. 

  515.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    516. 

  516.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    517. 

  517.   PRIMARY KEY (`dict_id`) USING BTREE,
    518. 

  518.   UNIQUE INDEX `dict_type`(`dict_type` ASC) USING BTREE
    519. 

  519. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典类型表' ROW_FORMAT = DYNAMIC;
    520. 

  520. 

  521. -- ----------------------------
    522. 

  522. -- Records of sys_dict_type
    523. 

  523. -- ----------------------------
    524. 

  524. INSERT INTO `sys_dict_type` VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '用户性别列表');
    525. 

  525. INSERT INTO `sys_dict_type` VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '菜单状态列表');
    526. 

  526. INSERT INTO `sys_dict_type` VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '系统开关列表');
    527. 

  527. INSERT INTO `sys_dict_type` VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '任务状态列表');
    528. 

  528. INSERT INTO `sys_dict_type` VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '任务分组列表');
    529. 

  529. INSERT INTO `sys_dict_type` VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '系统是否列表');
    530. 

  530. INSERT INTO `sys_dict_type` VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '通知类型列表');
    531. 

  531. INSERT INTO `sys_dict_type` VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '通知状态列表');
    532. 

  532. INSERT INTO `sys_dict_type` VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '操作类型列表');
    533. 

  533. INSERT INTO `sys_dict_type` VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '登录状态列表');
    534. 

  534. INSERT INTO `sys_dict_type` VALUES (100, '数据类型', 'data_type', '0', 'admin', '2023-05-29 14:16:55', '', NULL, NULL);
    535. 

  535. 

  536. -- ----------------------------
    537. 

  537. -- Table structure for sys_job
    538. 

  538. -- ----------------------------
    539. 

  539. DROP TABLE IF EXISTS `sys_job`;
    540. 

  540. CREATE TABLE `sys_job`  (
    541. 

  541.   `job_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务ID',
    542. 

  542.   `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '任务名称',
    543. 

  543.   `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
    544. 

  544.   `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调用目标字符串',
    545. 

  545.   `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT 'cron执行表达式',
    546. 

  546.   `misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
    547. 

  547.   `concurrent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
    548. 

  548.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '状态（0正常 1暂停）',
    549. 

  549.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    550. 

  550.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    551. 

  551.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    552. 

  552.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    553. 

  553.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注信息',
    554. 

  554.   PRIMARY KEY (`job_id`, `job_name`, `job_group`) USING BTREE
    555. 

  555. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '定时任务调度表' ROW_FORMAT = DYNAMIC;
    556. 

  556. 

  557. -- ----------------------------
    558. 

  558. -- Records of sys_job
    559. 

  559. -- ----------------------------
    560. 

  560. INSERT INTO `sys_job` VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    561. 

  561. INSERT INTO `sys_job` VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    562. 

  562. INSERT INTO `sys_job` VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    563. 

  563. 

  564. -- ----------------------------
    565. 

  565. -- Table structure for sys_job_log
    566. 

  566. -- ----------------------------
    567. 

  567. DROP TABLE IF EXISTS `sys_job_log`;
    568. 

  568. CREATE TABLE `sys_job_log`  (
    569. 

  569.   `job_log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
    570. 

  570.   `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名称',
    571. 

  571.   `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务组名',
    572. 

  572.   `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调用目标字符串',
    573. 

  573.   `job_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '日志信息',
    574. 

  574.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
    575. 

  575.   `exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '异常信息',
    576. 

  576.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    577. 

  577.   PRIMARY KEY (`job_log_id`) USING BTREE
    578. 

  578. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = DYNAMIC;
    579. 

  579. 

  580. -- ----------------------------
    581. 

  581. -- Records of sys_job_log
    582. 

  582. -- ----------------------------
    583. 

  583. 

  584. -- ----------------------------
    585. 

  585. -- Table structure for sys_logininfor
    586. 

  586. -- ----------------------------
    587. 

  587. DROP TABLE IF EXISTS `sys_logininfor`;
    588. 

  588. CREATE TABLE `sys_logininfor`  (
    589. 

  589.   `info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
    590. 

  590.   `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '用户账号',
    591. 

  591.   `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '登录IP地址',
    592. 

  592.   `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '登录地点',
    593. 

  593.   `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '浏览器类型',
    594. 

  594.   `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '操作系统',
    595. 

  595.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
    596. 

  596.   `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '提示消息',
    597. 

  597.   `login_time` datetime NULL DEFAULT NULL COMMENT '访问时间',
    598. 

  598.   PRIMARY KEY (`info_id`) USING BTREE
    599. 

  599. ) ENGINE = InnoDB AUTO_INCREMENT = 303 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统访问记录' ROW_FORMAT = DYNAMIC;
    600. 

  600. 

  601. -- ----------------------------
    602. 

  602. -- Records of sys_logininfor
    603. 

  603. -- ----------------------------
    604. 

  604. INSERT INTO `sys_logininfor` VALUES (100, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-04-28 12:23:00');
    605. 

  605. INSERT INTO `sys_logininfor` VALUES (101, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-04-28 12:23:55');
    606. 

  606. INSERT INTO `sys_logininfor` VALUES (102, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-04-28 12:26:08');
    607. 

  607. INSERT INTO `sys_logininfor` VALUES (103, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-04-28 17:52:46');
    608. 

  608. INSERT INTO `sys_logininfor` VALUES (104, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-04-28 21:09:42');
    609. 

  609. INSERT INTO `sys_logininfor` VALUES (105, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-04-29 18:46:45');
    610. 

  610. INSERT INTO `sys_logininfor` VALUES (106, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-04-29 20:26:35');
    611. 

  611. INSERT INTO `sys_logininfor` VALUES (107, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-04 18:54:27');
    612. 

  612. INSERT INTO `sys_logininfor` VALUES (108, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-04 22:17:08');
    613. 

  613. INSERT INTO `sys_logininfor` VALUES (109, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:15:48');
    614. 

  614. INSERT INTO `sys_logininfor` VALUES (110, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:31:00');
    615. 

  615. INSERT INTO `sys_logininfor` VALUES (111, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '用户不存在/密码错误', '2023-05-06 20:31:14');
    616. 

  616. INSERT INTO `sys_logininfor` VALUES (112, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '密码输入错误1次', '2023-05-06 20:31:14');
    617. 

  617. INSERT INTO `sys_logininfor` VALUES (113, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '用户不存在/密码错误', '2023-05-06 20:31:22');
    618. 

  618. INSERT INTO `sys_logininfor` VALUES (114, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '密码输入错误2次', '2023-05-06 20:31:22');
    619. 

  619. INSERT INTO `sys_logininfor` VALUES (115, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '验证码已失效', '2023-05-06 20:33:57');
    620. 

  620. INSERT INTO `sys_logininfor` VALUES (116, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '验证码错误', '2023-05-06 20:34:00');
    621. 

  621. INSERT INTO `sys_logininfor` VALUES (117, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:34:03');
    622. 

  622. INSERT INTO `sys_logininfor` VALUES (118, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:34:12');
    623. 

  623. INSERT INTO `sys_logininfor` VALUES (119, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:34:18');
    624. 

  624. INSERT INTO `sys_logininfor` VALUES (120, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:34:32');
    625. 

  625. INSERT INTO `sys_logininfor` VALUES (121, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:34:39');
    626. 

  626. INSERT INTO `sys_logininfor` VALUES (122, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:38:49');
    627. 

  627. INSERT INTO `sys_logininfor` VALUES (123, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:39:17');
    628. 

  628. INSERT INTO `sys_logininfor` VALUES (124, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:39:27');
    629. 

  629. INSERT INTO `sys_logininfor` VALUES (125, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:39:33');
    630. 

  630. INSERT INTO `sys_logininfor` VALUES (126, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:42:15');
    631. 

  631. INSERT INTO `sys_logininfor` VALUES (127, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:42:22');
    632. 

  632. INSERT INTO `sys_logininfor` VALUES (128, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:46:14');
    633. 

  633. INSERT INTO `sys_logininfor` VALUES (129, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:46:23');
    634. 

  634. INSERT INTO `sys_logininfor` VALUES (130, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-06 20:48:25');
    635. 

  635. INSERT INTO `sys_logininfor` VALUES (131, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-06 20:48:33');
    636. 

  636. INSERT INTO `sys_logininfor` VALUES (132, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 13:24:21');
    637. 

  637. INSERT INTO `sys_logininfor` VALUES (133, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 13:24:38');
    638. 

  638. INSERT INTO `sys_logininfor` VALUES (134, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 13:24:45');
    639. 

  639. INSERT INTO `sys_logininfor` VALUES (135, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 13:28:38');
    640. 

  640. INSERT INTO `sys_logininfor` VALUES (136, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 13:28:46');
    641. 

  641. INSERT INTO `sys_logininfor` VALUES (137, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 13:31:36');
    642. 

  642. INSERT INTO `sys_logininfor` VALUES (138, 'admind', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '登录用户：admind 不存在', '2023-05-07 13:31:42');
    643. 

  643. INSERT INTO `sys_logininfor` VALUES (139, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '密码输入错误1次', '2023-05-07 13:31:47');
    644. 

  644. INSERT INTO `sys_logininfor` VALUES (140, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '用户不存在/密码错误', '2023-05-07 13:31:47');
    645. 

  645. INSERT INTO `sys_logininfor` VALUES (141, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '验证码错误', '2023-05-07 13:31:51');
    646. 

  646. INSERT INTO `sys_logininfor` VALUES (142, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 13:31:53');
    647. 

  647. INSERT INTO `sys_logininfor` VALUES (143, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 13:33:21');
    648. 

  648. INSERT INTO `sys_logininfor` VALUES (144, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 13:33:27');
    649. 

  649. INSERT INTO `sys_logininfor` VALUES (145, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 13:39:35');
    650. 

  650. INSERT INTO `sys_logininfor` VALUES (146, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 13:39:47');
    651. 

  651. INSERT INTO `sys_logininfor` VALUES (147, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 18:37:41');
    652. 

  652. INSERT INTO `sys_logininfor` VALUES (148, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 18:42:58');
    653. 

  653. INSERT INTO `sys_logininfor` VALUES (149, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 18:43:05');
    654. 

  654. INSERT INTO `sys_logininfor` VALUES (150, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 18:44:57');
    655. 

  655. INSERT INTO `sys_logininfor` VALUES (151, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 18:45:02');
    656. 

  656. INSERT INTO `sys_logininfor` VALUES (152, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 18:48:54');
    657. 

  657. INSERT INTO `sys_logininfor` VALUES (153, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 18:49:01');
    658. 

  658. INSERT INTO `sys_logininfor` VALUES (154, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 18:57:52');
    659. 

  659. INSERT INTO `sys_logininfor` VALUES (155, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 18:57:56');
    660. 

  660. INSERT INTO `sys_logininfor` VALUES (156, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 19:01:23');
    661. 

  661. INSERT INTO `sys_logininfor` VALUES (157, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 19:01:31');
    662. 

  662. INSERT INTO `sys_logininfor` VALUES (158, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 19:36:33');
    663. 

  663. INSERT INTO `sys_logininfor` VALUES (159, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 20:24:26');
    664. 

  664. INSERT INTO `sys_logininfor` VALUES (160, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 20:24:59');
    665. 

  665. INSERT INTO `sys_logininfor` VALUES (161, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 20:25:07');
    666. 

  666. INSERT INTO `sys_logininfor` VALUES (162, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 20:26:12');
    667. 

  667. INSERT INTO `sys_logininfor` VALUES (163, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 20:26:23');
    668. 

  668. INSERT INTO `sys_logininfor` VALUES (164, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-07 20:39:28');
    669. 

  669. INSERT INTO `sys_logininfor` VALUES (165, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '用户不存在/密码错误', '2023-05-07 20:39:35');
    670. 

  670. INSERT INTO `sys_logininfor` VALUES (166, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '密码输入错误1次', '2023-05-07 20:39:35');
    671. 

  671. INSERT INTO `sys_logininfor` VALUES (167, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-07 20:39:40');
    672. 

  672. INSERT INTO `sys_logininfor` VALUES (168, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 18:56:32');
    673. 

  673. INSERT INTO `sys_logininfor` VALUES (169, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:30:58');
    674. 

  674. INSERT INTO `sys_logininfor` VALUES (170, 'ry', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:31:02');
    675. 

  675. INSERT INTO `sys_logininfor` VALUES (171, 'ry', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:31:44');
    676. 

  676. INSERT INTO `sys_logininfor` VALUES (172, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '用户不存在/密码错误', '2023-05-08 20:31:54');
    677. 

  677. INSERT INTO `sys_logininfor` VALUES (173, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '密码输入错误1次', '2023-05-08 20:31:54');
    678. 

  678. INSERT INTO `sys_logininfor` VALUES (174, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:32:09');
    679. 

  679. INSERT INTO `sys_logininfor` VALUES (175, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:34:40');
    680. 

  680. INSERT INTO `sys_logininfor` VALUES (176, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:34:45');
    681. 

  681. INSERT INTO `sys_logininfor` VALUES (177, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:34:50');
    682. 

  682. INSERT INTO `sys_logininfor` VALUES (178, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:34:57');
    683. 

  683. INSERT INTO `sys_logininfor` VALUES (179, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:35:19');
    684. 

  684. INSERT INTO `sys_logininfor` VALUES (180, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:35:27');
    685. 

  685. INSERT INTO `sys_logininfor` VALUES (181, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:35:54');
    686. 

  686. INSERT INTO `sys_logininfor` VALUES (182, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:36:01');
    687. 

  687. INSERT INTO `sys_logininfor` VALUES (183, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:40:08');
    688. 

  688. INSERT INTO `sys_logininfor` VALUES (184, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:40:14');
    689. 

  689. INSERT INTO `sys_logininfor` VALUES (185, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:40:29');
    690. 

  690. INSERT INTO `sys_logininfor` VALUES (186, 'ry', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:40:34');
    691. 

  691. INSERT INTO `sys_logininfor` VALUES (187, 'ry', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:41:46');
    692. 

  692. INSERT INTO `sys_logininfor` VALUES (188, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:41:57');
    693. 

  693. INSERT INTO `sys_logininfor` VALUES (189, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:42:37');
    694. 

  694. INSERT INTO `sys_logininfor` VALUES (190, 'ry', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:42:44');
    695. 

  695. INSERT INTO `sys_logininfor` VALUES (191, 'ry', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:42:59');
    696. 

  696. INSERT INTO `sys_logininfor` VALUES (192, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:43:04');
    697. 

  697. INSERT INTO `sys_logininfor` VALUES (193, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:43:35');
    698. 

  698. INSERT INTO `sys_logininfor` VALUES (194, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:43:40');
    699. 

  699. INSERT INTO `sys_logininfor` VALUES (195, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:44:04');
    700. 

  700. INSERT INTO `sys_logininfor` VALUES (196, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:44:10');
    701. 

  701. INSERT INTO `sys_logininfor` VALUES (197, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:46:12');
    702. 

  702. INSERT INTO `sys_logininfor` VALUES (198, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '1', '验证码错误', '2023-05-08 20:46:19');
    703. 

  703. INSERT INTO `sys_logininfor` VALUES (199, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:46:22');
    704. 

  704. INSERT INTO `sys_logininfor` VALUES (200, 'company', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:48:15');
    705. 

  705. INSERT INTO `sys_logininfor` VALUES (201, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:48:21');
    706. 

  706. INSERT INTO `sys_logininfor` VALUES (202, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:49:23');
    707. 

  707. INSERT INTO `sys_logininfor` VALUES (203, 'company3', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:49:29');
    708. 

  708. INSERT INTO `sys_logininfor` VALUES (204, 'company3', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '退出成功', '2023-05-08 20:55:11');
    709. 

  709. INSERT INTO `sys_logininfor` VALUES (205, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-08 20:55:22');
    710. 

  710. INSERT INTO `sys_logininfor` VALUES (206, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-11 19:03:07');
    711. 

  711. INSERT INTO `sys_logininfor` VALUES (207, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-14 21:13:34');
    712. 

  712. INSERT INTO `sys_logininfor` VALUES (208, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-20 15:56:37');
    713. 

  713. INSERT INTO `sys_logininfor` VALUES (209, 'admin', '127.0.0.1', '内网IP', 'Firefox 9', 'Windows 10', '0', '登录成功', '2023-05-20 17:56:44');
    714. 

  714. INSERT INTO `sys_logininfor` VALUES (210, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-26 00:34:09');
    715. 

  715. INSERT INTO `sys_logininfor` VALUES (211, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-26 01:06:46');
    716. 

  716. INSERT INTO `sys_logininfor` VALUES (212, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码已失效', '2023-05-26 13:58:45');
    717. 

  717. INSERT INTO `sys_logininfor` VALUES (213, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-26 13:58:48');
    718. 

  718. INSERT INTO `sys_logininfor` VALUES (214, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-26 17:32:26');
    719. 

  719. INSERT INTO `sys_logininfor` VALUES (215, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码已失效', '2023-05-26 22:52:20');
    720. 

  720. INSERT INTO `sys_logininfor` VALUES (216, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-26 22:52:23');
    721. 

  721. INSERT INTO `sys_logininfor` VALUES (217, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '退出成功', '2023-05-26 23:58:25');
    722. 

  722. INSERT INTO `sys_logininfor` VALUES (218, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-26 23:58:33');
    723. 

  723. INSERT INTO `sys_logininfor` VALUES (219, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-28 16:35:23');
    724. 

  724. INSERT INTO `sys_logininfor` VALUES (220, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-29 14:05:37');
    725. 

  725. INSERT INTO `sys_logininfor` VALUES (221, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-29 14:07:23');
    726. 

  726. INSERT INTO `sys_logininfor` VALUES (222, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-29 16:04:56');
    727. 

  727. INSERT INTO `sys_logininfor` VALUES (223, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-05-30 13:40:34');
    728. 

  728. INSERT INTO `sys_logininfor` VALUES (224, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-30 13:40:37');
    729. 

  729. INSERT INTO `sys_logininfor` VALUES (225, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码已失效', '2023-05-30 15:02:59');
    730. 

  730. INSERT INTO `sys_logininfor` VALUES (226, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-30 15:03:04');
    731. 

  731. INSERT INTO `sys_logininfor` VALUES (227, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-31 15:42:47');
    732. 

  732. INSERT INTO `sys_logininfor` VALUES (228, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '退出成功', '2023-05-31 15:51:25');
    733. 

  733. INSERT INTO `sys_logininfor` VALUES (229, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-05-31 15:51:29');
    734. 

  734. INSERT INTO `sys_logininfor` VALUES (230, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-01 14:05:08');
    735. 

  735. INSERT INTO `sys_logininfor` VALUES (231, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-01 15:09:52');
    736. 

  736. INSERT INTO `sys_logininfor` VALUES (232, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-06-01 16:55:36');
    737. 

  737. INSERT INTO `sys_logininfor` VALUES (233, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-06-01 16:55:43');
    738. 

  738. INSERT INTO `sys_logininfor` VALUES (234, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-01 16:55:52');
    739. 

  739. INSERT INTO `sys_logininfor` VALUES (235, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-01 23:43:11');
    740. 

  740. INSERT INTO `sys_logininfor` VALUES (236, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-02 21:24:40');
    741. 

  741. INSERT INTO `sys_logininfor` VALUES (237, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-06-02 21:55:56');
    742. 

  742. INSERT INTO `sys_logininfor` VALUES (238, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-06-02 21:55:58');
    743. 

  743. INSERT INTO `sys_logininfor` VALUES (239, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-02 21:56:01');
    744. 

  744. INSERT INTO `sys_logininfor` VALUES (240, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-02 22:55:52');
    745. 

  745. INSERT INTO `sys_logininfor` VALUES (241, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-03 13:26:36');
    746. 

  746. INSERT INTO `sys_logininfor` VALUES (242, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-03 18:57:08');
    747. 

  747. INSERT INTO `sys_logininfor` VALUES (243, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-03 21:19:02');
    748. 

  748. INSERT INTO `sys_logininfor` VALUES (244, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-05 14:04:55');
    749. 

  749. INSERT INTO `sys_logininfor` VALUES (245, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-05 14:37:27');
    750. 

  750. INSERT INTO `sys_logininfor` VALUES (246, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-05 16:48:30');
    751. 

  751. INSERT INTO `sys_logininfor` VALUES (247, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-05 17:23:43');
    752. 

  752. INSERT INTO `sys_logininfor` VALUES (248, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-06-05 17:59:57');
    753. 

  753. INSERT INTO `sys_logininfor` VALUES (249, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-05 18:00:01');
    754. 

  754. INSERT INTO `sys_logininfor` VALUES (250, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-06 14:06:10');
    755. 

  755. INSERT INTO `sys_logininfor` VALUES (251, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-06-06 14:29:19');
    756. 

  756. INSERT INTO `sys_logininfor` VALUES (252, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-06 14:29:22');
    757. 

  757. INSERT INTO `sys_logininfor` VALUES (253, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码已失效', '2023-06-06 15:19:07');
    758. 

  758. INSERT INTO `sys_logininfor` VALUES (254, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-06 15:19:10');
    759. 

  759. INSERT INTO `sys_logininfor` VALUES (255, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-06 17:58:51');
    760. 

  760. INSERT INTO `sys_logininfor` VALUES (256, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-06 22:46:43');
    761. 

  761. INSERT INTO `sys_logininfor` VALUES (257, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-07 13:09:52');
    762. 

  762. INSERT INTO `sys_logininfor` VALUES (258, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-08 14:13:41');
    763. 

  763. INSERT INTO `sys_logininfor` VALUES (259, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '1', '验证码错误', '2023-06-08 18:03:52');
    764. 

  764. INSERT INTO `sys_logininfor` VALUES (260, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-08 18:03:54');
    765. 

  765. INSERT INTO `sys_logininfor` VALUES (261, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '退出成功', '2023-06-08 18:28:49');
    766. 

  766. INSERT INTO `sys_logininfor` VALUES (262, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-08 18:28:53');
    767. 

  767. INSERT INTO `sys_logininfor` VALUES (263, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '退出成功', '2023-06-08 18:29:40');
    768. 

  768. INSERT INTO `sys_logininfor` VALUES (264, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-08 18:29:43');
    769. 

  769. INSERT INTO `sys_logininfor` VALUES (265, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '退出成功', '2023-06-08 19:12:58');
    770. 

  770. INSERT INTO `sys_logininfor` VALUES (266, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-08 19:13:03');
    771. 

  771. INSERT INTO `sys_logininfor` VALUES (267, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-09 13:25:05');
    772. 

  772. INSERT INTO `sys_logininfor` VALUES (268, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-09 14:01:15');
    773. 

  773. INSERT INTO `sys_logininfor` VALUES (269, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-09 14:02:35');
    774. 

  774. INSERT INTO `sys_logininfor` VALUES (270, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-09 14:09:35');
    775. 

  775. INSERT INTO `sys_logininfor` VALUES (271, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-09 14:17:01');
    776. 

  776. INSERT INTO `sys_logininfor` VALUES (272, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-09 14:25:56');
    777. 

  777. INSERT INTO `sys_logininfor` VALUES (273, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-09 14:28:39');
    778. 

  778. INSERT INTO `sys_logininfor` VALUES (274, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-06-27 22:12:02');
    779. 

  779. INSERT INTO `sys_logininfor` VALUES (275, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:15:08');
    780. 

  780. INSERT INTO `sys_logininfor` VALUES (276, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:15:14');
    781. 

  781. INSERT INTO `sys_logininfor` VALUES (277, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:27:39');
    782. 

  782. INSERT INTO `sys_logininfor` VALUES (278, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:27:45');
    783. 

  783. INSERT INTO `sys_logininfor` VALUES (279, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:42:05');
    784. 

  784. INSERT INTO `sys_logininfor` VALUES (280, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:42:12');
    785. 

  785. INSERT INTO `sys_logininfor` VALUES (281, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:51:00');
    786. 

  786. INSERT INTO `sys_logininfor` VALUES (282, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:51:21');
    787. 

  787. INSERT INTO `sys_logininfor` VALUES (283, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:51:25');
    788. 

  788. INSERT INTO `sys_logininfor` VALUES (284, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:51:37');
    789. 

  789. INSERT INTO `sys_logininfor` VALUES (285, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:52:01');
    790. 

  790. INSERT INTO `sys_logininfor` VALUES (286, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:52:07');
    791. 

  791. INSERT INTO `sys_logininfor` VALUES (287, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:52:47');
    792. 

  792. INSERT INTO `sys_logininfor` VALUES (288, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:52:54');
    793. 

  793. INSERT INTO `sys_logininfor` VALUES (289, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:55:47');
    794. 

  794. INSERT INTO `sys_logininfor` VALUES (290, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:55:59');
    795. 

  795. INSERT INTO `sys_logininfor` VALUES (291, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-27 23:59:50');
    796. 

  796. INSERT INTO `sys_logininfor` VALUES (292, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-27 23:59:58');
    797. 

  797. INSERT INTO `sys_logininfor` VALUES (293, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-28 00:00:12');
    798. 

  798. INSERT INTO `sys_logininfor` VALUES (294, 'company3', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-28 00:00:16');
    799. 

  799. INSERT INTO `sys_logininfor` VALUES (295, 'company3', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-28 00:00:32');
    800. 

  800. INSERT INTO `sys_logininfor` VALUES (296, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-28 00:00:54');
    801. 

  801. INSERT INTO `sys_logininfor` VALUES (297, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-28 00:29:10');
    802. 

  802. INSERT INTO `sys_logininfor` VALUES (298, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-28 00:29:25');
    803. 

  803. INSERT INTO `sys_logininfor` VALUES (299, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-28 00:43:20');
    804. 

  804. INSERT INTO `sys_logininfor` VALUES (300, 'company', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '退出成功', '2023-06-28 00:43:25');
    805. 

  805. INSERT INTO `sys_logininfor` VALUES (301, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-06-28 00:43:33');
    806. 

  806. INSERT INTO `sys_logininfor` VALUES (302, 'admin', '127.0.0.1', '内网IP', 'Firefox 11', 'Windows 10', '0', '登录成功', '2023-07-01 00:31:34');
    807. 

  807. 

  808. -- ----------------------------
    809. 

  809. -- Table structure for sys_menu
    810. 

  810. -- ----------------------------
    811. 

  811. DROP TABLE IF EXISTS `sys_menu`;
    812. 

  812. CREATE TABLE `sys_menu`  (
    813. 

  813.   `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    814. 

  814.   `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单名称',
    815. 

  815.   `parent_id` bigint NULL DEFAULT 0 COMMENT '父菜单ID',
    816. 

  816.   `order_num` int NULL DEFAULT 0 COMMENT '显示顺序',
    817. 

  817.   `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '路由地址',
    818. 

  818.   `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组件路径',
    819. 

  819.   `query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由参数',
    820. 

  820.   `is_frame` int NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）',
    821. 

  821.   `is_cache` int NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
    822. 

  822.   `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    823. 

  823.   `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
    824. 

  824.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
    825. 

  825.   `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识',
    826. 

  826.   `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '#' COMMENT '菜单图标',
    827. 

  827.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    828. 

  828.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    829. 

  829.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    830. 

  830.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    831. 

  831.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注',
    832. 

  832.   PRIMARY KEY (`menu_id`) USING BTREE
    833. 

  833. ) ENGINE = InnoDB AUTO_INCREMENT = 2045 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '菜单权限表' ROW_FORMAT = DYNAMIC;
    834. 

  834. 

  835. -- ----------------------------
    836. 

  836. -- Records of sys_menu
    837. 

  837. -- ----------------------------
    838. 

  838. INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 1, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2023-04-28 11:55:31', '', NULL, '系统管理目录');
    839. 

  839. INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 2, 'monitor', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2023-04-28 11:55:31', '', NULL, '系统监控目录');
    840. 

  840. INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 3, 'tool', NULL, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2023-04-28 11:55:31', '', NULL, '系统工具目录');
    841. 

  841. INSERT INTO `sys_menu` VALUES (4, '若依官网', 0, 4, 'http://ruoyi.vip', NULL, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', '2023-04-28 11:55:31', '', NULL, '若依官网地址');
    842. 

  842. INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 1, 'usera', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2023-04-28 11:55:31', 'admin', '2023-04-28 13:16:24', '用户管理菜单');
    843. 

  843. INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2023-04-28 11:55:31', '', NULL, '角色管理菜单');
    844. 

  844. INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2023-04-28 11:55:31', '', NULL, '菜单管理菜单');
    845. 

  845. INSERT INTO `sys_menu` VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2023-04-28 11:55:31', '', NULL, '部门管理菜单');
    846. 

  846. INSERT INTO `sys_menu` VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2023-04-28 11:55:31', '', NULL, '岗位管理菜单');
    847. 

  847. INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2023-04-28 11:55:31', '', NULL, '字典管理菜单');
    848. 

  848. INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2023-04-28 11:55:31', '', NULL, '参数设置菜单');
    849. 

  849. INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2023-04-28 11:55:31', '', NULL, '通知公告菜单');
    850. 

  850. INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2023-04-28 11:55:31', '', NULL, '日志管理菜单');
    851. 

  851. INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2023-04-28 11:55:31', '', NULL, '在线用户菜单');
    852. 

  852. INSERT INTO `sys_menu` VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2023-04-28 11:55:31', '', NULL, '定时任务菜单');
    853. 

  853. INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2023-04-28 11:55:31', '', NULL, '数据监控菜单');
    854. 

  854. INSERT INTO `sys_menu` VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2023-04-28 11:55:31', '', NULL, '服务监控菜单');
    855. 

  855. INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2023-04-28 11:55:31', '', NULL, '缓存监控菜单');
    856. 

  856. INSERT INTO `sys_menu` VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', '2023-04-28 11:55:31', '', NULL, '缓存列表菜单');
    857. 

  857. INSERT INTO `sys_menu` VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2023-04-28 11:55:31', '', NULL, '表单构建菜单');
    858. 

  858. INSERT INTO `sys_menu` VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2023-04-28 11:55:31', '', NULL, '代码生成菜单');
    859. 

  859. INSERT INTO `sys_menu` VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2023-04-28 11:55:31', '', NULL, '系统接口菜单');
    860. 

  860. INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2023-04-28 11:55:31', '', NULL, '操作日志菜单');
    861. 

  861. INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2023-04-28 11:55:31', '', NULL, '登录日志菜单');
    862. 

  862. INSERT INTO `sys_menu` VALUES (1000, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    863. 

  863. INSERT INTO `sys_menu` VALUES (1001, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    864. 

  864. INSERT INTO `sys_menu` VALUES (1002, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    865. 

  865. INSERT INTO `sys_menu` VALUES (1003, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    866. 

  866. INSERT INTO `sys_menu` VALUES (1004, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    867. 

  867. INSERT INTO `sys_menu` VALUES (1005, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    868. 

  868. INSERT INTO `sys_menu` VALUES (1006, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    869. 

  869. INSERT INTO `sys_menu` VALUES (1007, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    870. 

  870. INSERT INTO `sys_menu` VALUES (1008, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    871. 

  871. INSERT INTO `sys_menu` VALUES (1009, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    872. 

  872. INSERT INTO `sys_menu` VALUES (1010, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    873. 

  873. INSERT INTO `sys_menu` VALUES (1011, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    874. 

  874. INSERT INTO `sys_menu` VALUES (1012, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    875. 

  875. INSERT INTO `sys_menu` VALUES (1013, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    876. 

  876. INSERT INTO `sys_menu` VALUES (1014, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    877. 

  877. INSERT INTO `sys_menu` VALUES (1015, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    878. 

  878. INSERT INTO `sys_menu` VALUES (1016, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    879. 

  879. INSERT INTO `sys_menu` VALUES (1017, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    880. 

  880. INSERT INTO `sys_menu` VALUES (1018, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    881. 

  881. INSERT INTO `sys_menu` VALUES (1019, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    882. 

  882. INSERT INTO `sys_menu` VALUES (1020, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    883. 

  883. INSERT INTO `sys_menu` VALUES (1021, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    884. 

  884. INSERT INTO `sys_menu` VALUES (1022, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    885. 

  885. INSERT INTO `sys_menu` VALUES (1023, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    886. 

  886. INSERT INTO `sys_menu` VALUES (1024, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    887. 

  887. INSERT INTO `sys_menu` VALUES (1025, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    888. 

  888. INSERT INTO `sys_menu` VALUES (1026, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    889. 

  889. INSERT INTO `sys_menu` VALUES (1027, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    890. 

  890. INSERT INTO `sys_menu` VALUES (1028, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    891. 

  891. INSERT INTO `sys_menu` VALUES (1029, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    892. 

  892. INSERT INTO `sys_menu` VALUES (1030, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    893. 

  893. INSERT INTO `sys_menu` VALUES (1031, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    894. 

  894. INSERT INTO `sys_menu` VALUES (1032, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    895. 

  895. INSERT INTO `sys_menu` VALUES (1033, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    896. 

  896. INSERT INTO `sys_menu` VALUES (1034, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    897. 

  897. INSERT INTO `sys_menu` VALUES (1035, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    898. 

  898. INSERT INTO `sys_menu` VALUES (1036, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    899. 

  899. INSERT INTO `sys_menu` VALUES (1037, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    900. 

  900. INSERT INTO `sys_menu` VALUES (1038, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    901. 

  901. INSERT INTO `sys_menu` VALUES (1039, '操作查询', 500, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    902. 

  902. INSERT INTO `sys_menu` VALUES (1040, '操作删除', 500, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    903. 

  903. INSERT INTO `sys_menu` VALUES (1041, '日志导出', 500, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    904. 

  904. INSERT INTO `sys_menu` VALUES (1042, '登录查询', 501, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    905. 

  905. INSERT INTO `sys_menu` VALUES (1043, '登录删除', 501, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    906. 

  906. INSERT INTO `sys_menu` VALUES (1044, '日志导出', 501, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    907. 

  907. INSERT INTO `sys_menu` VALUES (1045, '账户解锁', 501, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    908. 

  908. INSERT INTO `sys_menu` VALUES (1046, '在线查询', 109, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    909. 

  909. INSERT INTO `sys_menu` VALUES (1047, '批量强退', 109, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    910. 

  910. INSERT INTO `sys_menu` VALUES (1048, '单条强退', 109, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    911. 

  911. INSERT INTO `sys_menu` VALUES (1049, '任务查询', 110, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    912. 

  912. INSERT INTO `sys_menu` VALUES (1050, '任务新增', 110, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    913. 

  913. INSERT INTO `sys_menu` VALUES (1051, '任务修改', 110, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    914. 

  914. INSERT INTO `sys_menu` VALUES (1052, '任务删除', 110, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    915. 

  915. INSERT INTO `sys_menu` VALUES (1053, '状态修改', 110, 5, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    916. 

  916. INSERT INTO `sys_menu` VALUES (1054, '任务导出', 110, 6, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    917. 

  917. INSERT INTO `sys_menu` VALUES (1055, '生成查询', 116, 1, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    918. 

  918. INSERT INTO `sys_menu` VALUES (1056, '生成修改', 116, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    919. 

  919. INSERT INTO `sys_menu` VALUES (1057, '生成删除', 116, 3, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    920. 

  920. INSERT INTO `sys_menu` VALUES (1058, '导入代码', 116, 4, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    921. 

  921. INSERT INTO `sys_menu` VALUES (1059, '预览代码', 116, 5, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    922. 

  922. INSERT INTO `sys_menu` VALUES (1060, '生成代码', 116, 6, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    923. 

  923. INSERT INTO `sys_menu` VALUES (2030, 'VR-ONE', 0, 0, 'VRdemo', NULL, NULL, 1, 0, 'M', '0', '0', '', 'dict', 'admin', '2023-04-28 13:17:41', 'admin', '2023-05-20 16:12:16', '');
    924. 

  924. INSERT INTO `sys_menu` VALUES (2031, '应用管理', 2030, 1, 'app', 'VRdemo/app/index', NULL, 1, 0, 'C', '0', '0', 'VRdemo:app:list', 'peoples', 'admin', '2023-04-28 13:18:42', 'admin', '2023-05-06 20:48:21', '');
    925. 

  925. INSERT INTO `sys_menu` VALUES (2032, '数据类型管理', 2030, 2, 'dataType', 'VRdemo/dataType/index', NULL, 1, 0, 'C', '0', '0', 'VRdemo:datatype:list', 'dict', 'admin', '2023-04-28 21:18:11', 'admin', '2023-05-20 16:12:41', '');
    926. 

  926. INSERT INTO `sys_menu` VALUES (2034, '应用查询', 2031, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:app:query', '#', 'admin', '2023-05-07 13:27:02', '', NULL, '');
    927. 

  927. INSERT INTO `sys_menu` VALUES (2035, '应用添加', 2031, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:app:add', '#', 'admin', '2023-05-07 13:27:26', '', NULL, '');
    928. 

  928. INSERT INTO `sys_menu` VALUES (2036, '应用修改', 2031, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:app:edit', '#', 'admin', '2023-05-07 13:27:45', 'admin', '2023-05-07 13:33:05', '');
    929. 

  929. INSERT INTO `sys_menu` VALUES (2037, '应用删除', 2031, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:app:remove', '#', 'admin', '2023-05-07 13:28:22', '', NULL, '');
    930. 

  930. INSERT INTO `sys_menu` VALUES (2038, '类型查询', 2032, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:datatype:query', '#', 'admin', '2023-05-07 19:00:00', 'admin', '2023-05-07 19:00:23', '');
    931. 

  931. INSERT INTO `sys_menu` VALUES (2039, '类型添加', 2032, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:datatype:add', '#', 'admin', '2023-05-07 19:00:36', '', NULL, '');
    932. 

  932. INSERT INTO `sys_menu` VALUES (2040, '类型修改', 2032, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:datatype:edit', '#', 'admin', '2023-05-07 19:00:53', '', NULL, '');
    933. 

  933. INSERT INTO `sys_menu` VALUES (2041, '类型删除', 2032, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'VRdemo:datatype:remove', '#', 'admin', '2023-05-07 19:01:07', '', NULL, '');
    934. 

  934. INSERT INTO `sys_menu` VALUES (2042, '数据源管理', 2030, 3, 'dataSource', 'VRdemo/dataSource/index', NULL, 1, 0, 'C', '0', '0', 'VRdemo:dataSource:list', 'rate', 'admin', '2023-05-26 01:10:19', '', NULL, '');
    935. 

  935. INSERT INTO `sys_menu` VALUES (2043, '展厅管理', 2030, 4, 'selectApp', 'VRdemo/selectApp/index', NULL, 1, 0, 'C', '0', '0', 'VRdemo:selectApp:list', 'checkbox', 'admin', '2023-06-08 16:18:53', 'admin', '2023-06-08 16:21:01', '');
    936. 

  936. INSERT INTO `sys_menu` VALUES (2044, '企业管理', 2030, 5, 'company', 'VRdemo/company/index', NULL, 1, 0, 'C', '0', '0', '', '#', 'admin', '2023-06-27 23:23:32', 'admin', '2023-06-27 23:23:46', '');
    937. 

  937. 

  938. -- ----------------------------
    939. 

  939. -- Table structure for sys_notice
    940. 

  940. -- ----------------------------
    941. 

  941. DROP TABLE IF EXISTS `sys_notice`;
    942. 

  942. CREATE TABLE `sys_notice`  (
    943. 

  943.   `notice_id` int NOT NULL AUTO_INCREMENT COMMENT '公告ID',
    944. 

  944.   `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告标题',
    945. 

  945.   `notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
    946. 

  946.   `notice_content` longblob NULL COMMENT '公告内容',
    947. 

  947.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
    948. 

  948.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    949. 

  949.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    950. 

  950.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    951. 

  951.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    952. 

  952.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    953. 

  953.   PRIMARY KEY (`notice_id`) USING BTREE
    954. 

  954. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '通知公告表' ROW_FORMAT = DYNAMIC;
    955. 

  955. 

  956. -- ----------------------------
    957. 

  957. -- Records of sys_notice
    958. 

  958. -- ----------------------------
    959. 

  959. INSERT INTO `sys_notice` VALUES (1, '温馨提醒：2018-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2023-04-28 11:55:31', '', NULL, '管理员');
    960. 

  960. INSERT INTO `sys_notice` VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2023-04-28 11:55:31', '', NULL, '管理员');
    961. 

  961. 

  962. -- ----------------------------
    963. 

  963. -- Table structure for sys_oper_log
    964. 

  964. -- ----------------------------
    965. 

  965. DROP TABLE IF EXISTS `sys_oper_log`;
    966. 

  966. CREATE TABLE `sys_oper_log`  (
    967. 

  967.   `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键',
    968. 

  968.   `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '模块标题',
    969. 

  969.   `business_type` int NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
    970. 

  970.   `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '方法名称',
    971. 

  971.   `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '请求方式',
    972. 

  972.   `operator_type` int NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
    973. 

  973.   `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '操作人员',
    974. 

  974.   `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '部门名称',
    975. 

  975.   `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '请求URL',
    976. 

  976.   `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '主机地址',
    977. 

  977.   `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '操作地点',
    978. 

  978.   `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '请求参数',
    979. 

  979.   `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '返回参数',
    980. 

  980.   `status` int NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
    981. 

  981.   `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '错误消息',
    982. 

  982.   `oper_time` datetime NULL DEFAULT NULL COMMENT '操作时间',
    983. 

  983.   PRIMARY KEY (`oper_id`) USING BTREE
    984. 

  984. ) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '操作日志记录' ROW_FORMAT = DYNAMIC;
    985. 

  985. 

  986. -- ----------------------------
    987. 

  987. -- Records of sys_oper_log
    988. 

  988. -- ----------------------------
    989. 

  989. INSERT INTO `sys_oper_log` VALUES (100, '代码生成', 6, 'com.ruoyi.project.tool.gen.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"datatype\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2023-04-28 20:18:34');
    990. 

  990. INSERT INTO `sys_oper_log` VALUES (101, '代码生成', 6, 'com.ruoyi.project.tool.gen.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"app\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2023-04-28 20:18:48');
    991. 

  991. INSERT INTO `sys_oper_log` VALUES (102, '代码生成', 8, 'com.ruoyi.project.tool.gen.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"apptemplate,datatype,app\"}', NULL, 0, NULL, '2023-04-28 20:26:27');
    992. 

  992. INSERT INTO `sys_oper_log` VALUES (103, '代码生成', 6, 'com.ruoyi.project.tool.gen.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"company\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2023-04-28 21:10:13');
    993. 

  993. INSERT INTO `sys_oper_log` VALUES (104, '代码生成', 2, 'com.ruoyi.project.tool.gen.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"company\",\"className\":\"Company\",\"columns\":[{\"capJavaField\":\"CompanyId\",\"columnComment\":\"自增ID\",\"columnId\":31,\"columnName\":\"company_id\",\"columnType\":\"int\",\"createBy\":\"admin\",\"createTime\":\"2023-04-28 21:10:13\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"1\",\"isQuery\":\"1\",\"javaField\":\"companyId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":true,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"CompanyIdtitle\",\"columnComment\":\"企业名称\",\"columnId\":32,\"columnName\":\"company_idtitle\",\"columnType\":\"varchar(100)\",\"createBy\":\"admin\",\"createTime\":\"2023-04-28 21:10:13\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"companyIdtitle\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":true,\"sort\":2,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Money\",\"columnComment\":\"企业余额 默认\\r\\n为 0.00\",\"columnId\":33,\"columnName\":\"money\",\"columnType\":\"decimal(15,2)\",\"createBy\":\"admin\",\"createTime\":\"2023-04-28 21:10:13\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"money\",\"javaType\":\"BigDecimal\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"BETWEEN\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Totalmoney\",\"columnComment\":\"企业总金额 默认\\r\\n为 0.00\",\"columnId\":34,\"columnName\":\"totalMoney\",\"columnType\":\"decimal(15,2)\",\"createBy\":\"admin\",\"createTime\":\"2023-04-28 21:10:13\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2023-04-28 21:13:24');
    994. 

  994. INSERT INTO `sys_oper_log` VALUES (105, '代码生成', 8, 'com.ruoyi.project.tool.gen.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"company\"}', NULL, 0, NULL, '2023-04-28 21:13:27');
    995. 

  995. INSERT INTO `sys_oper_log` VALUES (106, '代码生成', 8, 'com.ruoyi.project.tool.gen.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"company\"}', NULL, 0, NULL, '2023-04-28 21:13:34');
    996. 

  996. INSERT INTO `sys_oper_log` VALUES (107, '菜单管理', 1, 'com.ruoyi.project.system.controller.SysMenuController.add()', 'POST', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"VRdemo/company/index\",\"createBy\":\"admin\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"企业管理\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":2030,\"path\":\"company\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2023-04-28 21:18:11');
    997. 

  997. INSERT INTO `sys_oper_log` VALUES (108, '企业', 1, 'com.ruoyi.project.VRdemo.controller.CompanyController.add()', 'POST', 1, 'admin', NULL, '/VRdemo/company', '127.0.0.1', '内网IP', '{\"companyIdtitle\":\"1\",\"createTime\":\"2023-04-28 21:26:25.465\",\"email\":\"1\",\"money\":1,\"params\":{},\"phone\":\"1\",\"totalmoney\":1,\"username\":\"1\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLException: Field \'status\' doesn\'t have a default value\r\n### The error may exist in file [C:\\Users\\1\\Desktop\\VRproject\\RuoYi-Vue-fast-master\\target\\classes\\mybatis\\VRdemo\\CompanyMapper.xml]\r\n### The error may involve com.ruoyi.project.VRdemo.mapper.CompanyMapper.insertCompany-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into company          ( company_idtitle,             money,             totalMoney,             username,             password,             phone,             email,                                       create_time )           values ( ?,             ?,             ?,             ?,             ?,             ?,             ?,                                       ? )\r\n### Cause: java.sql.SQLException: Field \'status\' doesn\'t have a default value\n; Field \'status\' doesn\'t have a default value; nested exception is java.sql.SQLException: Field \'status\' doesn\'t have a default value', '2023-04-28 21:26:25');
    998. 

  998. INSERT INTO `sys_oper_log` VALUES (109, '企业', 1, 'com.ruoyi.project.VRdemo.controller.CompanyController.add()', 'POST', 1, 'admin', NULL, '/VRdemo/company', '127.0.0.1', '内网IP', '{\"companyIdtitle\":\"1\",\"createTime\":\"2023-04-28 21:35:06.176\",\"email\":\"1\",\"money\":1,\"params\":{},\"phone\":\"1\",\"totalmoney\":1,\"username\":\"1\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLException: Field \'status\' doesn\'t have a default value\r\n### The error may exist in file [C:\\Users\\1\\Desktop\\VRproject\\RuoYi-Vue-fast-master\\target\\classes\\mybatis\\VRdemo\\CompanyMapper.xml]\r\n### The error may involve com.ruoyi.project.VRdemo.mapper.CompanyMapper.insertCompany-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into company          ( company_idtitle,             money,             totalMoney,             username,             password,             phone,             email,                                       create_time )           values ( ?,             ?,             ?,             ?,             ?,             ?,             ?,                                       ? )\r\n### Cause: java.sql.SQLException: Field \'status\' doesn\'t have a default value\n; Field \'status\' doesn\'t have a default value; nested exception is java.sql.SQLException: Field \'status\' doesn\'t have a default value', '2023-04-28 21:35:06');
    999. 

  999. INSERT INTO `sys_oper_log` VALUES (110, '企业', 1, 'com.ruoyi.project.VRdemo.controller.CompanyController.add()', 'POST', 1, 'admin', NULL, '/VRdemo/company', '127.0.0.1', '内网IP', '{\"companyIdtitle\":\"1\",\"createTime\":\"2023-04-28 21:36:00.07\",\"email\":\"1\",\"money\":1,\"params\":{},\"phone\":\"1\",\"totalmoney\":1,\"username\":\"1\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLException: Field \'status\' doesn\'t have a default value\r\n### The error may exist in file [C:\\Users\\1\\Desktop\\VRproject\\RuoYi-Vue-fast-master\\target\\classes\\mybatis\\VRdemo\\CompanyMapper.xml]\r\n### The error may involve com.ruoyi.project.VRdemo.mapper.CompanyMapper.insertCompany-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into company          ( company_idtitle,             money,             totalMoney,             username,             password,             phone,             email,                                       create_time )           values ( ?,             ?,             ?,             ?,             ?,             ?,             ?,                                       ? )\r\n### Cause: java.sql.SQLException: Field \'status\' doesn\'t have a default value\n; Field \'status\' doesn\'t have a default value; nested exception is java.sql.SQLException: Field \'status\' doesn\'t have a default value', '2023-04-28 21:36:00');
    1000. 

  1000. INSERT INTO `sys_oper_log` VALUES (111, '企业', 1, 'com.ruoyi.project.VRdemo.controller.CompanyController.add()', 'POST', 1, 'admin', NULL, '/VRdemo/company', '127.0.0.1', '内网IP', '{\"companyId\":1,\"companyIdtitle\":\"1\",\"createTime\":\"2023-04-28 21:37:06.321\",\"email\":\"1\",\"money\":1,\"params\":{},\"phone\":\"1\",\"totalmoney\":1,\"username\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2023-04-28 21:37:06');
    1001. 

  1001. 

  1002. -- ----------------------------
    1003. 

  1003. -- Table structure for sys_post
    1004. 

  1004. -- ----------------------------
    1005. 

  1005. DROP TABLE IF EXISTS `sys_post`;
    1006. 

  1006. CREATE TABLE `sys_post`  (
    1007. 

  1007.   `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
    1008. 

  1008.   `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '岗位编码',
    1009. 

  1009.   `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '岗位名称',
    1010. 

  1010.   `post_sort` int NOT NULL COMMENT '显示顺序',
    1011. 

  1011.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '状态（0正常 1停用）',
    1012. 

  1012.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1013. 

  1013.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1014. 

  1014.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1015. 

  1015.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1016. 

  1016.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    1017. 

  1017.   PRIMARY KEY (`post_id`) USING BTREE
    1018. 

  1018. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '岗位信息表' ROW_FORMAT = DYNAMIC;
    1019. 

  1019. 

  1020. -- ----------------------------
    1021. 

  1021. -- Records of sys_post
    1022. 

  1022. -- ----------------------------
    1023. 

  1023. INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    1024. 

  1024. INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    1025. 

  1025. INSERT INTO `sys_post` VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    1026. 

  1026. INSERT INTO `sys_post` VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2023-04-28 11:55:31', '', NULL, '');
    1027. 

  1027. 

  1028. -- ----------------------------
    1029. 

  1029. -- Table structure for sys_role
    1030. 

  1030. -- ----------------------------
    1031. 

  1031. DROP TABLE IF EXISTS `sys_role`;
    1032. 

  1032. CREATE TABLE `sys_role`  (
    1033. 

  1033.   `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    1034. 

  1034.   `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名称',
    1035. 

  1035.   `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色权限字符串',
    1036. 

  1036.   `role_sort` int NOT NULL COMMENT '显示顺序',
    1037. 

  1037.   `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
    1038. 

  1038.   `menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示',
    1039. 

  1039.   `dept_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '部门树选择项是否关联显示',
    1040. 

  1040.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
    1041. 

  1041.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    1042. 

  1042.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1043. 

  1043.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1044. 

  1044.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1045. 

  1045.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1046. 

  1046.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    1047. 

  1047.   PRIMARY KEY (`role_id`) USING BTREE
    1048. 

  1048. ) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色信息表' ROW_FORMAT = DYNAMIC;
    1049. 

  1049. 

  1050. -- ----------------------------
    1051. 

  1051. -- Records of sys_role
    1052. 

  1052. -- ----------------------------
    1053. 

  1053. INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '超级管理员');
    1054. 

  1054. INSERT INTO `sys_role` VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2023-04-28 11:55:31', '', NULL, '普通角色');
    1055. 

  1055. INSERT INTO `sys_role` VALUES (100, '企业', 'company', 3, '4', 1, 1, '0', '0', 'admin', '2023-05-06 20:29:16', 'admin', '2023-06-27 23:51:59', NULL);
    1056. 

  1056. 

  1057. -- ----------------------------
    1058. 

  1058. -- Table structure for sys_role_dept
    1059. 

  1059. -- ----------------------------
    1060. 

  1060. DROP TABLE IF EXISTS `sys_role_dept`;
    1061. 

  1061. CREATE TABLE `sys_role_dept`  (
    1062. 

  1062.   `role_id` bigint NOT NULL COMMENT '角色ID',
    1063. 

  1063.   `dept_id` bigint NOT NULL COMMENT '部门ID',
    1064. 

  1064.   PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
    1065. 

  1065. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色和部门关联表' ROW_FORMAT = DYNAMIC;
    1066. 

  1066. 

  1067. -- ----------------------------
    1068. 

  1068. -- Records of sys_role_dept
    1069. 

  1069. -- ----------------------------
    1070. 

  1070. INSERT INTO `sys_role_dept` VALUES (2, 100);
    1071. 

  1071. INSERT INTO `sys_role_dept` VALUES (2, 101);
    1072. 

  1072. INSERT INTO `sys_role_dept` VALUES (2, 105);
    1073. 

  1073. 

  1074. -- ----------------------------
    1075. 

  1075. -- Table structure for sys_role_menu
    1076. 

  1076. -- ----------------------------
    1077. 

  1077. DROP TABLE IF EXISTS `sys_role_menu`;
    1078. 

  1078. CREATE TABLE `sys_role_menu`  (
    1079. 

  1079.   `role_id` bigint NOT NULL COMMENT '角色ID',
    1080. 

  1080.   `menu_id` bigint NOT NULL COMMENT '菜单ID',
    1081. 

  1081.   PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
    1082. 

  1082. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = DYNAMIC;
    1083. 

  1083. 

  1084. -- ----------------------------
    1085. 

  1085. -- Records of sys_role_menu
    1086. 

  1086. -- ----------------------------
    1087. 

  1087. INSERT INTO `sys_role_menu` VALUES (2, 1);
    1088. 

  1088. INSERT INTO `sys_role_menu` VALUES (2, 2);
    1089. 

  1089. INSERT INTO `sys_role_menu` VALUES (2, 3);
    1090. 

  1090. INSERT INTO `sys_role_menu` VALUES (2, 4);
    1091. 

  1091. INSERT INTO `sys_role_menu` VALUES (2, 100);
    1092. 

  1092. INSERT INTO `sys_role_menu` VALUES (2, 101);
    1093. 

  1093. INSERT INTO `sys_role_menu` VALUES (2, 102);
    1094. 

  1094. INSERT INTO `sys_role_menu` VALUES (2, 103);
    1095. 

  1095. INSERT INTO `sys_role_menu` VALUES (2, 104);
    1096. 

  1096. INSERT INTO `sys_role_menu` VALUES (2, 105);
    1097. 

  1097. INSERT INTO `sys_role_menu` VALUES (2, 106);
    1098. 

  1098. INSERT INTO `sys_role_menu` VALUES (2, 107);
    1099. 

  1099. INSERT INTO `sys_role_menu` VALUES (2, 108);
    1100. 

  1100. INSERT INTO `sys_role_menu` VALUES (2, 109);
    1101. 

  1101. INSERT INTO `sys_role_menu` VALUES (2, 110);
    1102. 

  1102. INSERT INTO `sys_role_menu` VALUES (2, 111);
    1103. 

  1103. INSERT INTO `sys_role_menu` VALUES (2, 112);
    1104. 

  1104. INSERT INTO `sys_role_menu` VALUES (2, 113);
    1105. 

  1105. INSERT INTO `sys_role_menu` VALUES (2, 114);
    1106. 

  1106. INSERT INTO `sys_role_menu` VALUES (2, 115);
    1107. 

  1107. INSERT INTO `sys_role_menu` VALUES (2, 116);
    1108. 

  1108. INSERT INTO `sys_role_menu` VALUES (2, 117);
    1109. 

  1109. INSERT INTO `sys_role_menu` VALUES (2, 500);
    1110. 

  1110. INSERT INTO `sys_role_menu` VALUES (2, 501);
    1111. 

  1111. INSERT INTO `sys_role_menu` VALUES (2, 1000);
    1112. 

  1112. INSERT INTO `sys_role_menu` VALUES (2, 1001);
    1113. 

  1113. INSERT INTO `sys_role_menu` VALUES (2, 1002);
    1114. 

  1114. INSERT INTO `sys_role_menu` VALUES (2, 1003);
    1115. 

  1115. INSERT INTO `sys_role_menu` VALUES (2, 1004);
    1116. 

  1116. INSERT INTO `sys_role_menu` VALUES (2, 1005);
    1117. 

  1117. INSERT INTO `sys_role_menu` VALUES (2, 1006);
    1118. 

  1118. INSERT INTO `sys_role_menu` VALUES (2, 1007);
    1119. 

  1119. INSERT INTO `sys_role_menu` VALUES (2, 1008);
    1120. 

  1120. INSERT INTO `sys_role_menu` VALUES (2, 1009);
    1121. 

  1121. INSERT INTO `sys_role_menu` VALUES (2, 1010);
    1122. 

  1122. INSERT INTO `sys_role_menu` VALUES (2, 1011);
    1123. 

  1123. INSERT INTO `sys_role_menu` VALUES (2, 1012);
    1124. 

  1124. INSERT INTO `sys_role_menu` VALUES (2, 1013);
    1125. 

  1125. INSERT INTO `sys_role_menu` VALUES (2, 1014);
    1126. 

  1126. INSERT INTO `sys_role_menu` VALUES (2, 1015);
    1127. 

  1127. INSERT INTO `sys_role_menu` VALUES (2, 1016);
    1128. 

  1128. INSERT INTO `sys_role_menu` VALUES (2, 1017);
    1129. 

  1129. INSERT INTO `sys_role_menu` VALUES (2, 1018);
    1130. 

  1130. INSERT INTO `sys_role_menu` VALUES (2, 1019);
    1131. 

  1131. INSERT INTO `sys_role_menu` VALUES (2, 1020);
    1132. 

  1132. INSERT INTO `sys_role_menu` VALUES (2, 1021);
    1133. 

  1133. INSERT INTO `sys_role_menu` VALUES (2, 1022);
    1134. 

  1134. INSERT INTO `sys_role_menu` VALUES (2, 1023);
    1135. 

  1135. INSERT INTO `sys_role_menu` VALUES (2, 1024);
    1136. 

  1136. INSERT INTO `sys_role_menu` VALUES (2, 1025);
    1137. 

  1137. INSERT INTO `sys_role_menu` VALUES (2, 1026);
    1138. 

  1138. INSERT INTO `sys_role_menu` VALUES (2, 1027);
    1139. 

  1139. INSERT INTO `sys_role_menu` VALUES (2, 1028);
    1140. 

  1140. INSERT INTO `sys_role_menu` VALUES (2, 1029);
    1141. 

  1141. INSERT INTO `sys_role_menu` VALUES (2, 1030);
    1142. 

  1142. INSERT INTO `sys_role_menu` VALUES (2, 1031);
    1143. 

  1143. INSERT INTO `sys_role_menu` VALUES (2, 1032);
    1144. 

  1144. INSERT INTO `sys_role_menu` VALUES (2, 1033);
    1145. 

  1145. INSERT INTO `sys_role_menu` VALUES (2, 1034);
    1146. 

  1146. INSERT INTO `sys_role_menu` VALUES (2, 1035);
    1147. 

  1147. INSERT INTO `sys_role_menu` VALUES (2, 1036);
    1148. 

  1148. INSERT INTO `sys_role_menu` VALUES (2, 1037);
    1149. 

  1149. INSERT INTO `sys_role_menu` VALUES (2, 1038);
    1150. 

  1150. INSERT INTO `sys_role_menu` VALUES (2, 1039);
    1151. 

  1151. INSERT INTO `sys_role_menu` VALUES (2, 1040);
    1152. 

  1152. INSERT INTO `sys_role_menu` VALUES (2, 1041);
    1153. 

  1153. INSERT INTO `sys_role_menu` VALUES (2, 1042);
    1154. 

  1154. INSERT INTO `sys_role_menu` VALUES (2, 1043);
    1155. 

  1155. INSERT INTO `sys_role_menu` VALUES (2, 1044);
    1156. 

  1156. INSERT INTO `sys_role_menu` VALUES (2, 1045);
    1157. 

  1157. INSERT INTO `sys_role_menu` VALUES (2, 1046);
    1158. 

  1158. INSERT INTO `sys_role_menu` VALUES (2, 1047);
    1159. 

  1159. INSERT INTO `sys_role_menu` VALUES (2, 1048);
    1160. 

  1160. INSERT INTO `sys_role_menu` VALUES (2, 1049);
    1161. 

  1161. INSERT INTO `sys_role_menu` VALUES (2, 1050);
    1162. 

  1162. INSERT INTO `sys_role_menu` VALUES (2, 1051);
    1163. 

  1163. INSERT INTO `sys_role_menu` VALUES (2, 1052);
    1164. 

  1164. INSERT INTO `sys_role_menu` VALUES (2, 1053);
    1165. 

  1165. INSERT INTO `sys_role_menu` VALUES (2, 1054);
    1166. 

  1166. INSERT INTO `sys_role_menu` VALUES (2, 1055);
    1167. 

  1167. INSERT INTO `sys_role_menu` VALUES (2, 1056);
    1168. 

  1168. INSERT INTO `sys_role_menu` VALUES (2, 1057);
    1169. 

  1169. INSERT INTO `sys_role_menu` VALUES (2, 1058);
    1170. 

  1170. INSERT INTO `sys_role_menu` VALUES (2, 1059);
    1171. 

  1171. INSERT INTO `sys_role_menu` VALUES (2, 1060);
    1172. 

  1172. INSERT INTO `sys_role_menu` VALUES (100, 1);
    1173. 

  1173. INSERT INTO `sys_role_menu` VALUES (100, 100);
    1174. 

  1174. INSERT INTO `sys_role_menu` VALUES (100, 101);
    1175. 

  1175. INSERT INTO `sys_role_menu` VALUES (100, 102);
    1176. 

  1176. INSERT INTO `sys_role_menu` VALUES (100, 103);
    1177. 

  1177. INSERT INTO `sys_role_menu` VALUES (100, 1000);
    1178. 

  1178. INSERT INTO `sys_role_menu` VALUES (100, 1001);
    1179. 

  1179. INSERT INTO `sys_role_menu` VALUES (100, 1002);
    1180. 

  1180. INSERT INTO `sys_role_menu` VALUES (100, 1003);
    1181. 

  1181. INSERT INTO `sys_role_menu` VALUES (100, 1004);
    1182. 

  1182. INSERT INTO `sys_role_menu` VALUES (100, 1005);
    1183. 

  1183. INSERT INTO `sys_role_menu` VALUES (100, 1006);
    1184. 

  1184. INSERT INTO `sys_role_menu` VALUES (100, 1007);
    1185. 

  1185. INSERT INTO `sys_role_menu` VALUES (100, 1008);
    1186. 

  1186. INSERT INTO `sys_role_menu` VALUES (100, 1009);
    1187. 

  1187. INSERT INTO `sys_role_menu` VALUES (100, 1010);
    1188. 

  1188. INSERT INTO `sys_role_menu` VALUES (100, 1011);
    1189. 

  1189. INSERT INTO `sys_role_menu` VALUES (100, 1012);
    1190. 

  1190. INSERT INTO `sys_role_menu` VALUES (100, 1013);
    1191. 

  1191. INSERT INTO `sys_role_menu` VALUES (100, 1014);
    1192. 

  1192. INSERT INTO `sys_role_menu` VALUES (100, 1015);
    1193. 

  1193. INSERT INTO `sys_role_menu` VALUES (100, 1016);
    1194. 

  1194. INSERT INTO `sys_role_menu` VALUES (100, 1017);
    1195. 

  1195. INSERT INTO `sys_role_menu` VALUES (100, 1018);
    1196. 

  1196. INSERT INTO `sys_role_menu` VALUES (100, 1019);
    1197. 

  1197. INSERT INTO `sys_role_menu` VALUES (100, 2030);
    1198. 

  1198. INSERT INTO `sys_role_menu` VALUES (100, 2032);
    1199. 

  1199. INSERT INTO `sys_role_menu` VALUES (100, 2038);
    1200. 

  1200. INSERT INTO `sys_role_menu` VALUES (100, 2039);
    1201. 

  1201. INSERT INTO `sys_role_menu` VALUES (100, 2040);
    1202. 

  1202. INSERT INTO `sys_role_menu` VALUES (100, 2041);
    1203. 

  1203. INSERT INTO `sys_role_menu` VALUES (100, 2042);
    1204. 

  1204. INSERT INTO `sys_role_menu` VALUES (100, 2043);
    1205. 

  1205. 

  1206. -- ----------------------------
    1207. 

  1207. -- Table structure for sys_user
    1208. 

  1208. -- ----------------------------
    1209. 

  1209. DROP TABLE IF EXISTS `sys_user`;
    1210. 

  1210. CREATE TABLE `sys_user`  (
    1211. 

  1211.   `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    1212. 

  1212.   `dept_id` bigint NULL DEFAULT NULL COMMENT '部门ID',
    1213. 

  1213.   `company_id` int NULL DEFAULT NULL COMMENT '企业ID',
    1214. 

  1214.   `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户账号',
    1215. 

  1215.   `nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户昵称',
    1216. 

  1216.   `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户）',
    1217. 

  1217.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '用户邮箱',
    1218. 

  1218.   `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '手机号码',
    1219. 

  1219.   `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
    1220. 

  1220.   `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '头像地址',
    1221. 

  1221.   `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '密码',
    1222. 

  1222.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
    1223. 

  1223.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    1224. 

  1224.   `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '最后登录IP',
    1225. 

  1225.   `login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间',
    1226. 

  1226.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1227. 

  1227.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1228. 

  1228.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1229. 

  1229.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1230. 

  1230.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    1231. 

  1231.   PRIMARY KEY (`user_id`) USING BTREE
    1232. 

  1232. ) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;
    1233. 

  1233. 

  1234. -- ----------------------------
    1235. 

  1235. -- Records of sys_user
    1236. 

  1236. -- ----------------------------
    1237. 

  1237. INSERT INTO `sys_user` VALUES (1, 103, NULL, 'admin', '若依', '00', 'ry@163.com', '15888888888', '1', '/profile/avatar/2023/07/01/blob_20230701011048A006.png', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2023-07-01 00:31:34', 'admin', '2023-04-28 11:55:31', '', '2023-07-01 00:31:34', '管理员');
    1238. 

  1238. INSERT INTO `sys_user` VALUES (2, 105, NULL, 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$IBARLRwNzOk9cYKnsfpcCeNLslzrrwQF9R3c13eXC5EhS94mDh9C.', '0', '0', '127.0.0.1', '2023-05-08 20:42:45', 'admin', '2023-04-28 11:55:31', 'admin', '2023-05-08 20:43:28', '测试员');
    1239. 

  1239. INSERT INTO `sys_user` VALUES (100, 101, NULL, 'company', '企业测试1', '00', '', '', '0', '/profile/avatar/2023/05/07/blob_20230507183808A001.png', '$2a$10$eAGx6tkpKngRXQeC9a0m6ebD5.gRuEJNC6XN8xK9IlElRgbKUzgse', '0', '0', '127.0.0.1', '2023-06-28 00:43:20', 'admin', '2023-05-06 20:29:51', 'admin', '2023-06-28 00:43:20', NULL);
    1240. 

  1240. INSERT INTO `sys_user` VALUES (101, 200, NULL, 'company2', '企业测试账号2', '00', '', '', '0', '', '$2a$10$B5Pex5GFNPXC7XUgDxGFCe.6kloLceTSZxeLlTi4IzyDjNmvjHFjG', '0', '0', '', NULL, 'company', '2023-05-08 20:46:51', '', NULL, NULL);
    1241. 

  1241. INSERT INTO `sys_user` VALUES (102, 102, NULL, 'company3', 'company3', '00', '', '', '0', '', '$2a$10$6eAQ2JVve6G0NGjkS13X3u7afPAXBx.lhhxZ6Yp2mwNbj4GqL1OmC', '0', '0', '127.0.0.1', '2023-06-28 00:00:17', 'admin', '2023-05-08 20:49:17', 'admin', '2023-06-28 00:00:16', NULL);
    1242. 

  1242. 

  1243. -- ----------------------------
    1244. 

  1244. -- Table structure for sys_user_post
    1245. 

  1245. -- ----------------------------
    1246. 

  1246. DROP TABLE IF EXISTS `sys_user_post`;
    1247. 

  1247. CREATE TABLE `sys_user_post`  (
    1248. 

  1248.   `user_id` bigint NOT NULL COMMENT '用户ID',
    1249. 

  1249.   `post_id` bigint NOT NULL COMMENT '岗位ID',
    1250. 

  1250.   PRIMARY KEY (`user_id`, `post_id`) USING BTREE
    1251. 

  1251. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = DYNAMIC;
    1252. 

  1252. 

  1253. -- ----------------------------
    1254. 

  1254. -- Records of sys_user_post
    1255. 

  1255. -- ----------------------------
    1256. 

  1256. INSERT INTO `sys_user_post` VALUES (1, 1);
    1257. 

  1257. 

  1258. -- ----------------------------
    1259. 

  1259. -- Table structure for sys_user_role
    1260. 

  1260. -- ----------------------------
    1261. 

  1261. DROP TABLE IF EXISTS `sys_user_role`;
    1262. 

  1262. CREATE TABLE `sys_user_role`  (
    1263. 

  1263.   `user_id` bigint NOT NULL COMMENT '用户ID',
    1264. 

  1264.   `role_id` bigint NOT NULL COMMENT '角色ID',
    1265. 

  1265.   PRIMARY KEY (`user_id`, `role_id`) USING BTREE
    1266. 

  1266. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户和角色关联表' ROW_FORMAT = DYNAMIC;
    1267. 

  1267. 

  1268. -- ----------------------------
    1269. 

  1269. -- Records of sys_user_role
    1270. 

  1270. -- ----------------------------
    1271. 

  1271. INSERT INTO `sys_user_role` VALUES (1, 1);
    1272. 

  1272. INSERT INTO `sys_user_role` VALUES (2, 2);
    1273. 

  1273. INSERT INTO `sys_user_role` VALUES (100, 100);
    1274. 

  1274. INSERT INTO `sys_user_role` VALUES (101, 100);
    1275. 

  1275. INSERT INTO `sys_user_role` VALUES (102, 100);
    1276. 

  1276. 

  1277. -- ----------------------------
    1278. 

  1278. -- Table structure for vr_app
    1279. 

  1279. -- ----------------------------
    1280. 

  1280. DROP TABLE IF EXISTS `vr_app`;
    1281. 

  1281. CREATE TABLE `vr_app`  (
    1282. 

  1282.   `app_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1283. 

  1283.   `title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '模板标题',
    1284. 

  1284.   `price` decimal(15, 2) NOT NULL COMMENT '模板价格',
    1285. 

  1285.   `path` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '模板存储路径',
    1286. 

  1286.   `spots` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '预设展示点（Json数据）',
    1287. 

  1287.   `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '模板状态（0 未审核\r\n，1 已通\r\n过，-1 已删除\r）默认为0',
    1288. 

  1288.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1289. 

  1289.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1290. 

  1290.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1291. 

  1291.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1292. 

  1292.   PRIMARY KEY (`app_id`) USING BTREE
    1293. 

  1293. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;
    1294. 

  1294. 

  1295. -- ----------------------------
    1296. 

  1296. -- Records of vr_app
    1297. 

  1297. -- ----------------------------
    1298. 

  1298. INSERT INTO `vr_app` VALUES (1, '1', 1.00, '/profile/upload/2023/04/29/123_20230429190439A002.doc', '[{\r\n	\"spots\": [{\r\n			\"name\": \"s1\",\r\n			\"dataTypeId\": \"3\"\r\n		},\r\n		{\r\n			\"name\": \"s2\",\r\n			\"dataTypeId\": \"4\"\r\n		}\r\n	]\r\n}]', 1, '', NULL, '', '2023-05-20 20:28:16');
    1299. 

  1299. INSERT INTO `vr_app` VALUES (2, '1', 1.00, '/profile/upload/2023/04/29/123_20230429190633A003.doc', '[{\r\n	\"spots\": [{\r\n			\"name\": \"ss1\",\r\n			\"dataTypeId\": \"3\"\r\n		},\r\n		{\r\n			\"name\": \"ss2\",\r\n			\"dataTypeId\": \"4\"\r\n		}\r\n	]\r\n}]', 0, '', '2023-04-29 19:06:35', '', '2023-04-29 19:06:38');
    1300. 

  1300. INSERT INTO `vr_app` VALUES (3, '1', 1.00, '/profile/upload/2023/05/04/123_20230504193602A002.doc', '123', 0, '', '2023-05-04 19:36:04', '', NULL);
    1301. 

  1301. INSERT INTO `vr_app` VALUES (5, '123', 12311.00, '/profile/upload/2023/05/20/123_20230520195532A002.doc', '123', 0, '', '2023-05-20 19:55:35', '', '2023-05-20 19:56:18');
    1302. 

  1302. 

  1303. -- ----------------------------
    1304. 

  1304. -- Table structure for vr_app_deploy
    1305. 

  1305. -- ----------------------------
    1306. 

  1306. DROP TABLE IF EXISTS `vr_app_deploy`;
    1307. 

  1307. CREATE TABLE `vr_app_deploy`  (
    1308. 

  1308.   `app_deploy_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1309. 

  1309.   `company_app_id` int NOT NULL COMMENT '所属企业应用id',
    1310. 

  1310.   `company_id` int NOT NULL COMMENT '所属企业id',
    1311. 

  1311.   `type` tinyint NOT NULL DEFAULT 1 COMMENT '部署类型（1系统默认页面部署 2网页部署 3微信小程序）',
    1312. 

  1312.   `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0未部署 1已部署）',
    1313. 

  1313.   `setting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '配置文件',
    1314. 

  1314.   PRIMARY KEY (`app_deploy_id`) USING BTREE
    1315. 

  1315. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
    1316. 

  1316. 

  1317. -- ----------------------------
    1318. 

  1318. -- Records of vr_app_deploy
    1319. 

  1319. -- ----------------------------
    1320. 

  1320. 

  1321. -- ----------------------------
    1322. 

  1322. -- Table structure for vr_badge
    1323. 

  1323. -- ----------------------------
    1324. 

  1324. DROP TABLE IF EXISTS `vr_badge`;
    1325. 

  1325. CREATE TABLE `vr_badge`  (
    1326. 

  1326.   `badge_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1327. 

  1327.   `company_id` int NOT NULL COMMENT '所属企业id',
    1328. 

  1328.   `company_app_id` int NOT NULL COMMENT '所属应用id',
    1329. 

  1329.   `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '徽章名称',
    1330. 

  1330.   `level` int NOT NULL COMMENT '徽章等级',
    1331. 

  1331.   `storage_id` int NOT NULL COMMENT '存储id',
    1332. 

  1332.   `size` int NOT NULL COMMENT '存储大小',
    1333. 

  1333.   `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '存储路径',
    1334. 

  1334.   `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '徽章描述',
    1335. 

  1335.   `create_time` datetime NOT NULL COMMENT '创建时间',
    1336. 

  1336.   `update_time` datetime NOT NULL COMMENT '更新时间',
    1337. 

  1337.   PRIMARY KEY (`badge_id`) USING BTREE
    1338. 

  1338. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
    1339. 

  1339. 

  1340. -- ----------------------------
    1341. 

  1341. -- Records of vr_badge
    1342. 

  1342. -- ----------------------------
    1343. 

  1343. 

  1344. -- ----------------------------
    1345. 

  1345. -- Table structure for vr_company
    1346. 

  1346. -- ----------------------------
    1347. 

  1347. DROP TABLE IF EXISTS `vr_company`;
    1348. 

  1348. CREATE TABLE `vr_company`  (
    1349. 

  1349.   `company_id` int NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    1350. 

  1350.   `title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '企业名称',
    1351. 

  1351.   `money` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '企业余额 默认\r\n为 0.00',
    1352. 

  1352.   `total_money` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '企业总金额 默认\r\n为 0.00',
    1353. 

  1353.   `phone` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '企业联系电话',
    1354. 

  1354.   `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业联系邮箱',
    1355. 

  1355.   `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '企业状态，0 未审核\r\n通过，1 已审核通\r\n过，-1 已注销',
    1356. 

  1356.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1357. 

  1357.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1358. 

  1358.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1359. 

  1359.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1360. 

  1360.   PRIMARY KEY (`company_id`) USING BTREE
    1361. 

  1361. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;
    1362. 

  1362. 

  1363. -- ----------------------------
    1364. 

  1364. -- Records of vr_company
    1365. 

  1365. -- ----------------------------
    1366. 

  1366. INSERT INTO `vr_company` VALUES (1, 'xxx公司', 1.00, 1.00, '1', '1', 0, '', '2023-04-28 21:37:06', '', NULL);
    1367. 

  1367. INSERT INTO `vr_company` VALUES (2, '1', 0.00, 0.00, '11111111111', NULL, 0, '', '2023-06-27 23:24:09', '', NULL);
    1368. 

  1368. 

  1369. -- ----------------------------
    1370. 

  1370. -- Table structure for vr_company_app
    1371. 

  1371. -- ----------------------------
    1372. 

  1372. DROP TABLE IF EXISTS `vr_company_app`;
    1373. 

  1373. CREATE TABLE `vr_company_app`  (
    1374. 

  1374.   `company_app_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1375. 

  1375.   `company_id` int NOT NULL COMMENT '所属企业ID',
    1376. 

  1376.   `app_id` int NOT NULL COMMENT '应用模板ID',
    1377. 

  1377.   `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '应用名称',
    1378. 

  1378.   `logo` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '应用图标',
    1379. 

  1379.   `cover` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '应用封面图',
    1380. 

  1380.   `setting` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '应用设置信息',
    1381. 

  1381.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1382. 

  1382.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1383. 

  1383.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1384. 

  1384.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1385. 

  1385.   `dept_id` bigint NULL DEFAULT NULL,
    1386. 

  1386.   PRIMARY KEY (`company_app_id`) USING BTREE,
    1387. 

  1387.   INDEX `cid`(`company_id` ASC) USING BTREE
    1388. 

  1388. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;
    1389. 

  1389. 

  1390. -- ----------------------------
    1391. 

  1391. -- Records of vr_company_app
    1392. 

  1392. -- ----------------------------
    1393. 

  1393. INSERT INTO `vr_company_app` VALUES (1, 1, 1, 'xxxx公司', NULL, NULL, NULL, '', NULL, '', NULL, 102);
    1394. 

  1394. INSERT INTO `vr_company_app` VALUES (2, 2, 2, '22222公司', NULL, NULL, NULL, '', NULL, '', NULL, 101);
    1395. 

  1395. INSERT INTO `vr_company_app` VALUES (5, 1, 3, 'xxxx公司', NULL, NULL, NULL, '', NULL, '', NULL, 102);
    1396. 

  1396. 

  1397. -- ----------------------------
    1398. 

  1398. -- Table structure for vr_data_source
    1399. 

  1399. -- ----------------------------
    1400. 

  1400. DROP TABLE IF EXISTS `vr_data_source`;
    1401. 

  1401. CREATE TABLE `vr_data_source`  (
    1402. 

  1402.   `data_source_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1403. 

  1403.   `company_id` int NULL DEFAULT NULL COMMENT '所属企业ID',
    1404. 

  1404.   `company_app_id` int NULL DEFAULT NULL COMMENT '所属应用ID',
    1405. 

  1405.   `data_type_id` int NULL DEFAULT NULL COMMENT '数据类型ID',
    1406. 

  1406.   `extend_id` int NULL DEFAULT 0 COMMENT '扩展ID',
    1407. 

  1407.   `spot` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '对应展示点名称',
    1408. 

  1408.   `storage_id` int NULL DEFAULT 0 COMMENT '存储ID',
    1409. 

  1409.   `title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '数据源标题',
    1410. 

  1410.   `setting` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '数据源设置信息',
    1411. 

  1411.   `status` tinyint(1) NULL DEFAULT 0 COMMENT '数据源状态(0表示未审核，1表示审核通过，-1表示审核不通过) 默认值为0',
    1412. 

  1412.   `view_counts` int NULL DEFAULT 0 COMMENT '浏览量 默认值为0',
    1413. 

  1413.   `click_rate` float NULL DEFAULT 0 COMMENT '点击量 默认值为0',
    1414. 

  1414.   `cache` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '数据源缓存信息',
    1415. 

  1415.   `cache_time` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '数据源缓存时间',
    1416. 

  1416.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1417. 

  1417.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1418. 

  1418.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1419. 

  1419.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1420. 

  1420.   PRIMARY KEY (`data_source_id`) USING BTREE
    1421. 

  1421. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;
    1422. 

  1422. 

  1423. -- ----------------------------
    1424. 

  1424. -- Records of vr_data_source
    1425. 

  1425. -- ----------------------------
    1426. 

  1426. 

  1427. -- ----------------------------
    1428. 

  1428. -- Table structure for vr_data_type
    1429. 

  1429. -- ----------------------------
    1430. 

  1430. DROP TABLE IF EXISTS `vr_data_type`;
    1431. 

  1431. CREATE TABLE `vr_data_type`  (
    1432. 

  1432.   `data_type_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1433. 

  1433.   `title` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据类型名称',
    1434. 

  1434.   `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '数据类型描述 默认为空',
    1435. 

  1435.   `component` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据类型组件',
    1436. 

  1436.   `spotType` tinyint(1) NOT NULL COMMENT 'spot类型',
    1437. 

  1437.   `parameters` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据类型参数',
    1438. 

  1438.   `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '数据类型状态1 启用，\r\n0 禁用，默认 0',
    1439. 

  1439.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    1440. 

  1440.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1441. 

  1441.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    1442. 

  1442.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1443. 

  1443.   PRIMARY KEY (`data_type_id`) USING BTREE
    1444. 

  1444. ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;
    1445. 

  1445. 

  1446. -- ----------------------------
    1447. 

  1447. -- Records of vr_data_type
    1448. 

  1448. -- ----------------------------
    1449. 

  1449. INSERT INTO `vr_data_type` VALUES (1, '模型', '123', 'Model', 1, '123', 0, '', NULL, '', '2023-05-20 19:20:00');
    1450. 

  1450. INSERT INTO `vr_data_type` VALUES (2, '场景', NULL, 'Scene', 2, 'null', 0, '', NULL, '', '2023-05-20 20:26:39');
    1451. 

  1451. INSERT INTO `vr_data_type` VALUES (3, '图片', NULL, 'Image', 4, 'null', 1, '', NULL, '', NULL);
    1452. 

  1452. INSERT INTO `vr_data_type` VALUES (4, '视频', NULL, 'Video', 4, 'null', 1, '', NULL, '', NULL);
    1453. 

  1453. INSERT INTO `vr_data_type` VALUES (5, '相册', NULL, 'Album', 4, 'null', 1, '', NULL, '', NULL);
    1454. 

  1454. INSERT INTO `vr_data_type` VALUES (6, '全景图片', NULL, 'PanoramaImage\n', 2, 'null', 0, '', NULL, '', NULL);
    1455. 

  1455. INSERT INTO `vr_data_type` VALUES (7, '全景视频', NULL, 'PanoramaVideo\n', 2, 'null', 0, '', NULL, '', NULL);
    1456. 

  1456. INSERT INTO `vr_data_type` VALUES (8, '电子书', NULL, 'Book', 4, 'null', 0, '', NULL, '', NULL);
    1457. 

  1457. INSERT INTO `vr_data_type` VALUES (9, '用户组列表', NULL, 'UserGroup', 4, 'null', 0, '', NULL, '', NULL);
    1458. 

  1458. INSERT INTO `vr_data_type` VALUES (10, '用户列表', NULL, 'UserList\n', 4, 'null', 0, '', NULL, '', NULL);
    1459. 

  1459. INSERT INTO `vr_data_type` VALUES (11, '用户详情', NULL, 'UserInfo', 4, 'null', 0, '', NULL, '', NULL);
    1460. 

  1460. INSERT INTO `vr_data_type` VALUES (12, '用户查询', NULL, 'UserSearch\n', 4, 'null', 0, '', NULL, '', NULL);
    1461. 

  1461. 

  1462. -- ----------------------------
    1463. 

  1463. -- Table structure for vr_image_data
    1464. 

  1464. -- ----------------------------
    1465. 

  1465. DROP TABLE IF EXISTS `vr_image_data`;
    1466. 

  1466. CREATE TABLE `vr_image_data`  (
    1467. 

  1467.   `image_data_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1468. 

  1468.   `company_id` int NULL DEFAULT NULL COMMENT '企业ID',
    1469. 

  1469.   `data_source_id` int NULL DEFAULT NULL COMMENT '数据源ID',
    1470. 

  1470.   `storage_id` int NULL DEFAULT 0 COMMENT '存储ID',
    1471. 

  1471.   `size` int NULL DEFAULT NULL COMMENT '图片大小',
    1472. 

  1472.   `path` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片存储路径',
    1473. 

  1473.   `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '关联链接',
    1474. 

  1474.   `create_time` datetime NULL DEFAULT NULL COMMENT '图片上传时间',
    1475. 

  1475.   `update_time` datetime NULL DEFAULT NULL COMMENT '图片更新时间',
    1476. 

  1476.   PRIMARY KEY (`image_data_id`) USING BTREE
    1477. 

  1477. ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;
    1478. 

  1478. 

  1479. -- ----------------------------
    1480. 

  1480. -- Records of vr_image_data
    1481. 

  1481. -- ----------------------------
    1482. 

  1482. INSERT INTO `vr_image_data` VALUES (24, 1, 12, 0, NULL, '/profile/imageDataPath/2023/07/01/123_20230701012853A011.jpg', NULL, '2023-07-01 01:23:34', NULL);
    1483. 

  1483. 

  1484. -- ----------------------------
    1485. 

  1485. -- Table structure for vr_user
    1486. 

  1486. -- ----------------------------
    1487. 

  1487. DROP TABLE IF EXISTS `vr_user`;
    1488. 

  1488. CREATE TABLE `vr_user`  (
    1489. 

  1489.   `user_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1490. 

  1490.   `company_id` int NOT NULL COMMENT '所属企业id',
    1491. 

  1491.   `company_app_id` int NOT NULL COMMENT '所属应用id',
    1492. 

  1492.   `user_group_id` int NOT NULL COMMENT '用户组id',
    1493. 

  1493.   `open_id` int NULL DEFAULT NULL COMMENT '第三方开放平台Id',
    1494. 

  1494.   `id_number` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学号',
    1495. 

  1495.   `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户真实姓名',
    1496. 

  1496.   `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号码',
    1497. 

  1497.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱地址',
    1498. 

  1498.   `reference_id` int NULL DEFAULT NULL COMMENT '推荐者id',
    1499. 

  1499.   `level` int NOT NULL DEFAULT 1 COMMENT '用户等级',
    1500. 

  1500.   `score` int NOT NULL DEFAULT 0 COMMENT '用户积分',
    1501. 

  1501.   `storage_id` int NULL DEFAULT NULL COMMENT '存储id',
    1502. 

  1502.   `size` int NULL DEFAULT NULL COMMENT '头像图片大小',
    1503. 

  1503.   `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像图片存储路径',
    1504. 

  1504.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1505. 

  1505.   PRIMARY KEY (`user_id`) USING BTREE
    1506. 

  1506. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
    1507. 

  1507. 

  1508. -- ----------------------------
    1509. 

  1509. -- Records of vr_user
    1510. 

  1510. -- ----------------------------
    1511. 

  1511. 

  1512. -- ----------------------------
    1513. 

  1513. -- Table structure for vr_user_badge
    1514. 

  1514. -- ----------------------------
    1515. 

  1515. DROP TABLE IF EXISTS `vr_user_badge`;
    1516. 

  1516. CREATE TABLE `vr_user_badge`  (
    1517. 

  1517.   `user_badge` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1518. 

  1518.   `company_id` int NOT NULL COMMENT '所属企业id',
    1519. 

  1519.   `company_app_id` int NOT NULL COMMENT '所属应用id',
    1520. 

  1520.   `user_id` int NOT NULL COMMENT '所属用户id',
    1521. 

  1521.   `badge_id` int NOT NULL COMMENT '徽章id',
    1522. 

  1522.   `status` tinyint NOT NULL DEFAULT 0 COMMENT '领取状态（0未领取 1已领取）',
    1523. 

  1523.   `createTime` datetime NOT NULL COMMENT '创建时间',
    1524. 

  1524.   PRIMARY KEY (`user_badge`) USING BTREE
    1525. 

  1525. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
    1526. 

  1526. 

  1527. -- ----------------------------
    1528. 

  1528. -- Records of vr_user_badge
    1529. 

  1529. -- ----------------------------
    1530. 

  1530. 

  1531. -- ----------------------------
    1532. 

  1532. -- Table structure for vr_user_group
    1533. 

  1533. -- ----------------------------
    1534. 

  1534. DROP TABLE IF EXISTS `vr_user_group`;
    1535. 

  1535. CREATE TABLE `vr_user_group`  (
    1536. 

  1536.   `user_group_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1537. 

  1537.   `company_id` int NOT NULL COMMENT '所属企业id',
    1538. 

  1538.   `company_app_id` int NOT NULL COMMENT '所属应用id',
    1539. 

  1539.   `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户组名',
    1540. 

  1540.   `storage_id` int NOT NULL COMMENT '存储id',
    1541. 

  1541.   `size` int NOT NULL COMMENT '存储文件大小',
    1542. 

  1542.   `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '存储文件路径',
    1543. 

  1543.   `level` int NOT NULL DEFAULT 1 COMMENT '等级',
    1544. 

  1544.   `score` int NOT NULL DEFAULT 0 COMMENT '积分',
    1545. 

  1545.   `sort` tinyint NOT NULL DEFAULT 0 COMMENT '排序方式（0uid 1等级 2积分 默认0）',
    1546. 

  1546.   PRIMARY KEY (`user_group_id`) USING BTREE
    1547. 

  1547. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
    1548. 

  1548. 

  1549. -- ----------------------------
    1550. 

  1550. -- Records of vr_user_group
    1551. 

  1551. -- ----------------------------
    1552. 

  1552. 

  1553. -- ----------------------------
    1554. 

  1554. -- Table structure for vr_user_message
    1555. 

  1555. -- ----------------------------
    1556. 

  1556. DROP TABLE IF EXISTS `vr_user_message`;
    1557. 

  1557. CREATE TABLE `vr_user_message`  (
    1558. 

  1558.   `user_message_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1559. 

  1559.   `company_id` int NOT NULL COMMENT '所属企业id',
    1560. 

  1560.   `company_app_id` int NOT NULL COMMENT '所属应用id',
    1561. 

  1561.   `user_id` int NOT NULL COMMENT '用户id',
    1562. 

  1562.   `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标题',
    1563. 

  1563.   `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '留言内容',
    1564. 

  1564.   `reply` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '回帖内容',
    1565. 

  1565.   `status` tinyint NOT NULL COMMENT '状态（-1已经删除 0未审核 1已审核）',
    1566. 

  1566.   `create_time` datetime NOT NULL COMMENT '创建时间',
    1567. 

  1567.   `reply_time` datetime NOT NULL COMMENT '回帖时间',
    1568. 

  1568.   PRIMARY KEY (`user_message_id`) USING BTREE
    1569. 

  1569. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
    1570. 

  1570. 

  1571. -- ----------------------------
    1572. 

  1572. -- Records of vr_user_message
    1573. 

  1573. -- ----------------------------
    1574. 

  1574. 

  1575. -- ----------------------------
    1576. 

  1576. -- Table structure for vr_video_data
    1577. 

  1577. -- ----------------------------
    1578. 

  1578. DROP TABLE IF EXISTS `vr_video_data`;
    1579. 

  1579. CREATE TABLE `vr_video_data`  (
    1580. 

  1580.   `video_data_id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
    1581. 

  1581.   `company_id` int NULL DEFAULT NULL COMMENT '所属企业ID',
    1582. 

  1582.   `data_source_id` int NULL DEFAULT NULL COMMENT '数据源ID',
    1583. 

  1583.   `storage_id` int NULL DEFAULT 0 COMMENT '存储ID',
    1584. 

  1584.   `size` int NULL DEFAULT NULL COMMENT '视频文件大小',
    1585. 

  1585.   `path` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '视频文件存储路径',
    1586. 

  1586.   `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '视频访问URL',
    1587. 

  1587.   `cover` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '视频封面图URL',
    1588. 

  1588.   `type` tinyint(1) NULL DEFAULT NULL COMMENT '视频文件类型(0 mp4 1 avi 2 wmv 3 mov 4 flv)',
    1589. 

  1589.   `create_time` datetime NULL DEFAULT NULL COMMENT '视频上传时间',
    1590. 

  1590.   `update_time` datetime NULL DEFAULT NULL COMMENT '视频更新时间',
    1591. 

  1591.   PRIMARY KEY (`video_data_id`) USING BTREE
    1592. 

  1592. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;
    1593. 

  1593. 

  1594. -- ----------------------------
    1595. 

  1595. -- Records of vr_video_data
    1596. 

  1596. -- ----------------------------
    1597. 

  1597. 

  1598. SET FOREIGN_KEY_CHECKS = 1;
    1599.