Springboot大学生活动社团管理系统设计.docx

学生社团管理一.引言1.1 项目来源通过对各大高校实地的调查可知，一般高校的学生社团信息管理主要是依据纸质和手工作业处理，人工的对大量会员的基本资料进行档案式管理，此种处理方式数据量大，管理模式和方法滞后，存放时间不能长久和数据更新速度慢。考虑现存的情况，建立一个系统化的学生社团管理系统是十分必要的。比如由原来的档案式保存会员信息变为将信息存入数据库中进行系统管理；利用海报或者板报宣传社团活动变为直接在网上发布社团活动的时间和地点等；文件式申请社团的创建变为规范格式的网上申请，提交，再由系统管理员审核；此系统还可以方便会员对社团动态进行查看、交流等。1.2 任务目标学生社团管理信息系统是一个操作简单、使用方便的基于B/S模式的系统。它的建立既是为了更加高效、规范地实现对社团动态进行管理，又是为了方便用户及时查看社团信息，保证信息的时效性和高效性。由于要满足用户随时随地查看社团最新动态，达到共享性的目的，故采用B/S模式，这样可达到信息共享、节约成本和提高效率的目的。此学生社团管理信息系统应达到以下目标：（1）系统采界面设计简单大方，操作简单，效率高，安全性能高,同时便于维护和管理；（2）在登录界面，可根据界面中的权限来选择不同用户可以对系统调用不同的功能。（3）通过查询、添加、修改等操作，对社团信息、用户资料、管理等（4）系统采用MYSQ1.数据库，开发语言为JAVA,数据库的存储容量足够大，而且比较稳定，能够较长时间保存数据二.项目规划2.1 硬件设备Windows台式电脑或笔记本内存4G以上2.2 软件环境操作系统：WindowslOJDK版本：1.8数据库:mysql5系列Java开发工具：idea服务器：tomcat8.0三、数据库设计3.1 数据库设计：采用mysql数据库，编码格式为UTF8,满足数据库设计三范式基本要求主要数据库表有：用户表角色表菜单表社团信息表社团成员表、社团活动申请表审批,社团公告信息表,日志表等。截图如下：Est_cactivity_applySjdUbst-messSst_user三st_zx圜sys_config国sys_dept国sys-dict昌sys_log国sys_menu圉sys_ossSsys_role国sys_role_deptHsys_role_menuSsys_usersys_user_role3.2 数据库部分SQ1.DROPTAB1.EIFEXISTS'js.apply'CREATETAB1.E'js.apply'('id'int(ll)NOTNU1.1.AUT0NCREMEN工'name'varchar(255)DEFAU1.TNU1.1.z'zsdw'varchar(255)DEFAU1.TNU1.1.,'type'varchar(255)DEFAU1.TNU1.1.,'principal'varchar(255)DEFAU1.TNU1.1.,'phone'varchar(255)DEFAU1.TNU1.1.z'email'varchar(255)DEFAU1.TNU1.1.z'starJtime'datetimeDEFAU1.TNU1.1.,'ent-time'datetimeDEFAU1.TNU1.1.,'majozhuban'varchar(255)DEFAU1.TNU1.1.,'sponsor'varchar(255)DEFAU1.TNU1.1.,'undertaeker'varchar(255)DEFAU1.TNU1.1.,'apply-time'datetimeDEFAU1.TNU1.1.,'remark'varchar(255)DEFAU1.TNU1.1.,'audit-stu'varchar(255)DEFAU1.TNU1.1.,PRIMARYKEY('id')ENGINE=InnoDBATOJNCREMENT=11DEFAU1.TCHARSET=UtfS;Recordsofjs_applyINSERTINTO'js,apply'VA1.UES(8,'游戏排位赛事'J腾讯事业游戏部'J个人赛'，'李杨勇',13219015380'22',2020-09-2214:56:24,2020-09-2214:56:30广西南交大'，null,null,null为增加两个不同专业同学友谊，丰富大学生活/同意，）；INSERTINTO'js,apply'VA1.UES（9J体育赛事,，西南交通大学统计部,J团队赛，'W,13219015380*54972,'2020-09-2214:56:26','2020-09-2214:56:34,西南交大一null,null,null/为增加两个不同专业同学友谊，丰富大学生活丁未审核，）；INSERTINTO'js,apply'VA1.UES（,1（T,美术竞赛0051R'西南交大二团队赛,Jadmi/,13219015380null,'2020-09-2200:00:00','2020-09-2215:05:57广西南交大null,null,null,'为增加两个不同专业同学友谊，丰富大学生活/未审核'）；-Tablestructureforjs_closingDROPTAB1.EIFEXISTS'js-closing'CREATETAB1.E'js-closing'('id'int(ll)NOTNU1.1.AUTOJNCREMENI；'jt_type'varchar(255)DEFAU1.TNU1.1.,'title'varchar(255)DEFAU1.TNU1.1.,'bid'int(ll)DEFAU1.TNU1.1.,'start-time'datetimeDEFAU1.TNU1.1.,'ranking'varchar(255)DEFAU1.TNU1.1.,'total-money'doubleDEFAU1.TNU1.1.,PRIMARYKEY('id')ENGINE=InnoDBATOJNCREMENT=9DEFAU1.TCHARSET=UtfS;-Recordsofjs_closingINSERTINTO'js-closing'VA1.UES(W,团队赛丁体育赛事002,z,2,z,2020-09-2211:19:22冒优等奖/100O')；INSERTINTO'js,closing'VA1.UES('6','团队赛'，'美术竞赛0056,z'4'2020-09-2215:00:48',null,'0');INSERTINTO'js-closing'VA1.UES(7,'个人赛/美术竞赛0056,4,2020-09-2215:01:13；,奖/4500');INSERTINTO'js-dosing'VA1.UES(8,'个人赛冒团队竞赛0045,5'z'2020-09-2215:02:171,null,'0');-Tablestructureforjs_expenditureDROPTAB1.EIFEXISTS'js-expenditure'CREATETAB1.E'js-expenditure'('id'int(ll)NOTNU1.1.AUTOJNCREMENI；'zhuche'doubleDEFAU1.TNU1.1.,'rate'doubleDEFAU1.TNU1.1.,'train'doubleDEFAU1.TNU1.1.,'guidance'doubleDEFAU1.TNU1.1.z'haocai'doubleDEFAU1.TNU1.1.,'bonus'doubleDEFAU1.TNU1.1.,'other'doubleDEFAU1.TNU1.1.,'total'doubleDEFAU1.TNU1.1.,'name'varchar(255)DEFAU1.TNU1.1.,PRIMARYKEY('id')ENGINE=InnoDBAT0JNCREMENT=3DEFAU1.TCHARSET=UtfS;Recordsofjs_expenditureINSERTINTO'js.expenditure'VA1.UES(,l,z,100,z,100,z,200,200,100,z,300,0,1100位赛事)；INSERTINTO'js-e×penditure'VA1.UES(,2,z,100,100,100,z,100,100,z,100,100,z,700,iX排位赛事,)；Tablestructureforjs_personalDROPTAB1.EIFEXISTS'js-persona;CREATETAB1.E'js-personal'('id'int(ll)NOTNU1.1.AUTOJNCREMENT；'name'varchar(255)DEFAU1.TNU1.1.,'college'varchar(255)DEFAU1.TNU1.1.,'class-name'varchar(255)DEFAU1.TNU1.1.,grade'varchar(255)DEFAU1.TNU1.1.,'major'varchar(255)DEFAU1.TNU1.1.,'email'varchar(255)DEFAU1.TNU1.1.,'phone'varchar(255)DEFAU1.TNU1.1.,'title'varchar(255)DEFAU1.TNU1.1.,PRIMARYKEY('id')ENGINE=InnoDBAT0JNCREMENT=6DEFAU1.TCHARSET=utf8;-Recordsofjs_personalINSERTINTO'js,personaVA1.UES(工,李杨勇广川大,J2012,J6J，计算机，'sdfsdcom',13216565656,test');INSERTINTO'js,personal'VA1.UES(2,'admin'J理工大学'，'2012','2012'J计算及有关','juiu1.13219015380','体育赛事项目002')；INSERTINTO'js-personaVA1.UES(3Jtony/西南交大/2012','0212','计算机'Jhu',125487245742：,美术课程小蛮腰003,)；INSERTINTOJs-personaVA1.UES('4',涂涂'，'西南交大九里提'，'2012','2012','计算机','888INSERTINTO'js-personaVA1.UES(,5,z'1,nulll,Nl,1,阿达人-Tablestructureforjs_teamDROPTAB1.EIFEXISTS'js-team'CREATETAB1.E'js-team'('id'int(ll)NOTNU1.1.AUTOJNCREMENI；'num'int(ll)DEFAU1.TNU1.1.,'title'varchar(255)DEFAU1.TNU1.1.,'bm-time'datetimeDEFAU1.TNU1.1.,PRIMARYKEY('id')ENGINE=InnoDBAT0JNCREMENT=6DEFAU1.TCHARSET=utf8;-Recordsofjs_teamINSERTINTO'js.team'VA1.UES(工'123冒体育项目竞赛1011,2020-09-2117:39:331);INSERTINTO'js-team'VA1.UES('2,4567体育赛事002,z'2020-09-2211:19:171)；INSERTINTO'js,team'VA1.UES(4,'888','美术竞赛0056,2020-09-2215:01:13,)；Insertinto'js-team'values(,5,z,i2i,ii,z'2020-09-2215：O2：17')；-Tablestructureforqrtz_blob_triggersDROPTAB1.EIFEXISTSqrtz_blob_triggers'CREATETAB1.E'qrtz_blob_triggers'('SCHED-NAME'varchar(120)NOTNU1.1.,'TRIGGER-NAME'varchar(200)NOTNU1.1.,'TRIGGER-GROUP'varchar(200)NOTNU1.1.,B1.OB_DATA'blob,PRIMARYKEY('SCHED_NAME'；TRIGGER_NAME'；TRIGGER_GROUP'),KEY'SCHED_NAME'('SCHED_NAME','TRlGGER_NAME；TRIGGER_GROUP'),CONSTRAINT'qrtz_blob_triggers_ibfk_l'FoR曰GNKEY('SCHED_NAME;'TRIGGER-NAME'z'TRIGGER-GROP')REFERENCES'qrtz_triggers'('SCHED-NAME'TRIGGER-NAME'z'TRIGGER-GROP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_blob_triggers-Tablestructureforqrtz_calendarsDROPTAB1.EIFEXISTS'qrtz-calendars'CREATETAB1.E'qrtz-calendars'('SCHED-NAME'varchar(120)NOTNU1.1.,'CA1.ENDAR-NAME'varchar(200)NOTNU1.1.,'CA1.ENDAR'blobNOTNU1.1.,PRIMARYKEY('SCHED_NAME','CA1.ENDAR_NAME')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_caIendarsTablestructureforqrtz_cron_triggersDROPTAB1.EIFEXISTS'qrtz_cron_triggers'CREATETAB1.E'qrtz_cron_triggers'('SCHED-NAME'varchar(120)NOTNU1.1.,'TRIGGER-NAME'varchar(200)NOTNU1.1.,'TRIGGER-GROUP'varchar(200)NOTNU1.1.,'CRON-EXPRESSION'varchar(120)NOTNU1.1.,'TIME_ZONE_ID'varchar(80)DEFAU1.TNU1.1.,PRIMARYKEY('SCHED_NAME'；TRIGGER_NAME'；TRIGGER_GROUP'),CONSTRAINT'qrtz_cron_triggers_ibfk_l'FoR日GNKEY('SCHED_NAME;'TRIGGER-NAME'TRIGGER-GROP')REFERENCES'qrtz_triggers'('SCHED-NAME'TRIGGER-NAME'z'TRIGGER-GROP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_cron_triggersINSERTINTOqrtz_cron_triggers'VA1.UES('RenrenScheduIer','7ASK_1'DEFAU1.T','O0/30*'AsiaShanghai,);-Tablestructureforqrtz_fired_triggersDROPTAB1.EIFEXISTSqrtz_fired_triggers'CREATETAB1.E'qrtz_fired_triggers'('SCHED-NAME'varchar(120)NOTNU1.1.,'ENTRYJD'varchar(95)NOTNU1.1.,'TRIGGER-NAME'varchar(200)NOTNU1.1.,'TRIGGER-GROUP'varchar(2OO)NOTNU1.1.,INS1ANCE-NAME'varchar(200)NOTNU1.1.,FIREDjIME'bigint(13)NOTNU1.1.,'SCHED-TIME'bigint(13)NOTNU1.1.,PRIORITY'int(ll)NOTNU1.1.,'SWE'varchar(16)NOTNU1.1.,'JOB-NAME'varchar(2OO)DEFAU1.TNU1.1.,'JOB-GROUP'varchar(200)DEFAU1.TNU1.1.,'IS-NONCONCRRENT'Varchar(I)DEFAU1.TNU1.1.,REQUESTS_RECOVERY'varchaNl)DEFAU1.TNU1.1.,PRIMARYKEY('SCHED_NAME'；ENTRYJD'),KEY'IDX_QRTZ_FT_TRIG_INST_NAME'('SCHED_NAME'；INSTANCE_NAME')ZKEY'IDX_QRTZ_FT_INST_JOB_REQ_RCVRY'('SCHED_NAME','INSTANCE_NAME','REQUESTS_RECOVERY'),KEYIDX_QRTZ_FT_J_G'('SCHED_NAME','JOB_NAME','JoB_GROUP'),KEYIDX_QRTZ_FT_JG'('SCHED-NAME'JOB-GROP')zKEYIDX_QRTZ_FT_T_G'('SCHED_NAME','TRlGGER_NAME','TRlGGER_GROUP'),KEYIDX_QRTZ_FT_TG'('SCHED_NAME'；TRIGGER_GROUP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_fired_triggers-Tablestructureforqrtzjob_detailsDROPTAB1.EIFEXISTS'qrtzjob-details'CREATETAB1.E'qrtzjob-details'('SCHED-NAME'varchar(120)NOTNU1.1.,'JOB-NAME'varchar(200)NOTNU1.1.,'JOB-GROUP'varchar(200)NOTNU1.1.,DESCRIPTION'varchar(250)DEFAU1.TNU1.1.,'JOB_C1.ASS_NAME'varchar(250)NOTNU1.1.,'IS-DRAB1.E'varchar(l)NOTNU1.1.,'IS-NONCONCRRENT'varchar(l)NOTNU1.1.,'IS_UPDATE_DATA'varchar(l)NOTNU1.1.,REQUESTS_RECOVERY'varchaHl)NOTNU1.1.,'JOB-DATA'blob,PRIMARYKEY('SCHED_NAME','JoB_NAME','JoB_GROUP'),KEY'IDX_QRTZ_REC1.RECoVERY'('SCHED_NAME','REQUESTS_RECOVERY'),KEY'IDX_QRTZ_J_GRP'('SCHED_NAME'；JOB_GROUP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtzjob_detailsINSERTINTO'qrtzjob-details'VA1.UES('RenrenScheduIer','TASK'，'DEFAU1.T；nullz'io.renren.modules.job.utils.ScheduIeJob',0,'0',0'0'z0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000173461A7D807874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000174000672656E72656E74000CE58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000007800);TablestructureforqrtzjocksDROPTAB1.EIFEXISTSqrtzjocks'CREATETAB1.E'qrtzjocks'('SCHED-NAME'varchar(120)NOTNU1.1.,'1.OCK-NAME'varchar(40)NOTNU1.1.,PRIMARYKEY('SCHED_NAME'；1.OCK_NAME')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-RecordsofqrtzjocksINSERTINTO'qrtzjocks'VA1.UES('RenrenScheduIer',SWE.ACCESS,);INSERTINTO'qrtzOCkS'VA1.UES('RenrenScheduIer','TRIGGER-ACCESS,);Tablestructureforqrtz_paused_trigger_grpsDROP-TAB1.EIFEXISTS'qrtz_paused_trigger_grps'CREATETAB1.E'qrtz_paused_trigger_grps'('SCHED-NAME'varchar(120)NOTNU1.1.,'TRIGGER-GROUP'varchar(200)NOTNU1.1.,PRIMARYKEY('SCHED_NAME'；TRIGGER_GROUP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_paused_trigger_grps-Tablestructureforqrtz_scheduIer_stateDROPTAB1.EIFEXISTS'qrtz_scheduler_state'CREATETAB1.E'qrtz_scheduler_state'('SCHED-NAME'varchar(120)NOTNU1.1.,INS1ANCE-NAME'varchar(200)NOTNU1.1.,'1.AST_CHECKIN_TIME'bigint(13)NOTNU1.1.,'Checkinjnterval'bgint(i3)notnull,PRIMARYKEY('SCHED_NAME','INSIANCE_NAME')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_scheduler_stateINSERTINTO'qrtz_scheduler_state'VA1.UES('RenrenScheduIer',AUTOBVT-741.S4381607518324687,z,1607518867075,15000');Tablestructureforqrtz_simple_triggersDROPTAB1.EIFEXISTS'qrtz_simple_triggers'CREATETAB1.E'qrtz_simple_triggers'('SCHED-NAME'varchar(120)NOTNU1.1.,'TRIGGER-NAME'varchar(200)NOTNU1.1.,'TRIGGER-GROUP'varchar(200)NOTNU1.1.,'REPEAT-COUNT'bigint(7)NOTNU1.1.,'Repeatjnterval'bigint(i2)notnull,'TIMESJRIGGERED'bigint(10)NOTNU1.1.,PRIMARYKEY('SCHED_NAME'；TRIGGER_NAME'；TRIGGER_GROUP'),CONSTRAINT'qrtz_simple_triggers_ibfk_l'FOREIGNKEY('SCHED-NAME'TRIGGER-NAME'z'TRIGGER-GROP')REFERENCES'qrtz_triggers'('SCHED_NAME'TRIGGER-NAME'z'TRIGGER-GROP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_simple_triggers-Tablestructureforqrtz_simprop_triggersDROP-TAB1.EIFEXISTS'qrtz_simprop_triggers'CREATETAB1.E'qrtz_simprop_triggers'('SCHED-NAME'varchar(120)NOTNU1.1.,'TRIGGER-NAME'varchar(200)NOTNU1.1.,'TRIGGER-GROUP'varchar(200)NOTNU1.1.,'STR_PROP_1'varchar(512)DEFAU1.TNU1.1.,'STR_PR0P_2'varchar(512)DEFAU1.TNU1.1.,'STR_PR0P_3'varchar(512)DEFAU1.TNU1.1.,'INT_PROP_1'int(ll)DEFAU1.TNU1.1.,'INT_PR0P_2'int(ll)DEFAU1.TNU1.1.,'1.ONG_PROP_1'bigint(20)DEFAU1.TNU1.1.,'1.0NG_PR0P_2'bigint(20)DEFAU1.TNU1.1.,'DEC_PROP_1'decimal(13z4)DEFAU1.TNU1.1.,DEC_PR0P_2'decimal(13z4)DEFAU1.TNU1.1.,BOO1._PROP_1'varchar(l)DEFAU1.TNU1.1.,B001._PR0P_2'varchar(l)DEFAU1.TNU1.1.,PRIMARYKEY('SCHED_NAME','TRlGGER_NAME','TRlGGER_GROUP'),CONSTRAINTqrtz_simprop_triggers_ibfk_l'FOR日GNKEY('SCHED_NAME'TRIGGER-NAME','TRIGGER-GROP')REFERENCES'qrtz_triggers'('SCHED-NAME'TRIGGER-NAME'z'TRIGGER-GROP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;-Recordsofqrtz_simprop_triggers-Tablestructureforqrtz_triggersDROPTAB1.EIFEXISTS'qrtz-triggers'CREATETAB1.E'qrtz-triggers'('SCHED-NAME'varchar(120)NOTNU1.1.,'TRIGGER-NAME'varchar(200)NOTNU1.1.,'TRIGGER-GROUP'varchar(200)NOTNU1.1.,'JOB-NAME'varchar(200)NOTNU1.1.,'JOB-GROUP'varchar(200)NOTNU1.1.,'DESCRIPTION'varchar(25O)DEFAU1.TNU1.1.,NEXT_FIRE_TIME'bigint(13)DEFAU1.TNU1.1.,PREV_FIRE_TIME'bigint(13)DEFAU1.TNU1.1.,PRIORITY'int(ll)DEFAU1.TNU1.1.,'TRIGGER-STATE'varchar(16)NOTNU1.1.,'TRIGGER-TYPE'varchar(8)NOTNU1.1.,'S7ART-TIME'bigint(13)NOTNU1.1.,'END-TIME'bigint(13)DEFAU1.TNU1.1.,'CA1.ENDAR-NAME'varchar(200)DEFAU1.TNU1.1.,'Misfirejnstr'SmalIim(2)defaultnull,'JOB-DATA'blob,PRIMARYKEY('SCHED_NAME'；TRIGGER_NAME'；TRIGGER_GROUP'),KEY'IDX_QRTZ_T_J'('SCHED_NAME','JOB_NAME','JOB_GROUP'),KEY'IDX_QRTZ_TG'('SCHED_NAME；JOB_GROUP'),KEY'IDX_QRTZ_T_C'('SCHED_NAME','CA1.ENDAR_NAME'),KEY'IDX_QRTZ_T_G'('SCHED_NAME'；TRIGGER_GROUP'),KEY'IDX_QRTZ工STArE'('SCHED_NAME','TRIGGER_STATE'),KEY'IDX_QRTZ_T_N_SWE'('SCHED_NAME','TRlGGER_NAME','TRIGGER_GROUP','TRlGGER_STATE'),KEY'IDX_QRTZ工N_G_STATE'('SCHED_NAME','TRIGGER_GROUP','TRlGGER_STATE'),KEY'IDX_QRTZ_T_NEXT_FIRE_TIME'('SCHED_NAME'；NEXT_FIRE_TIME'),KEY'IDX_QRTZ_T_NFT_ST'('SCHED_NAME'；TRIGGER_S7ATE'；NEXT_FIRE_TIME'),KEY'IDX_QRTZ_T_NFT_MISFIRE'('SCHED-NAME'z'MISFIREJNSTR','NEXT-FIRE-TIME'),KEY'IDX_QRTZ_T_NFT_ST_MISFIRE'('SCHED_NAME','MlSFlREJNSTR','NEXT_FIRE_TIME','TRlGGER_STATE'),KEY,IDX_QRTZ_T_NFT_ST_MISFIRE_GRP'('SCHED_NAME','MISFlRENSTR','NEXT_FIREjnME','TRIGGER_GROUP','TRlGGER_S1ATE'),CONSTRAINT'qrtz_triggers_ibfk_l'FoR日GNKEY('SCHED-NAME'JOB-NAME'JOB-GROP')REFERENCES'qrtzjob-details'('SCHED_NAME'Z'JOB-NAME','JOB-GROUP')ENGINE=InnoDBDEFAU1.TCHARSET=utf8;Recordsofqrtz_triggersINSERTINTO'qrtz-triggers'VA1.UES('RenrenScheduIer','TASK-l,z'DEFAU1.T*,'1ASK_1'DEFAU1.T；null,16