INSERT INTO `proc` (`db`, `name`, `type`, `specific_name`, `language`, `sql_data_access`, `is_deterministic`, `security_type`, `param_list`, `returns`, `body`, `definer`, `created`, `modified`, `sql_mode`, `comment`, `character_set_client`, `collation_connection`, `db_collation`, `body_utf8`) VALUES
('testdb', 'spCopyTest', 'PROCEDURE', 'spCopyTest', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5465737449646020494e542c20494e2060505f4261746361586d6c60204c4f4e4754455854, '', 0x[encoded data, 8058 characters], 'testdb@webserver1', '2023-06-01 13:11:09', '2023-06-01 13:11:09', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x[encoded data, 8058 characters]),
('testdb', 'spCreateAdmin', 'PROCEDURE', 'spCreateAdmin', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f436f6465602056415243484152283130292c20494e2060505f5573657249646020494e54, '', 0x424547494e0d0a202020204445434c4152452054656163686572496420494e542044454641554c5420303b0d0a202020204445434c4152452054656163686572436f64652056415243484152283130292044454641554c542027273b0d0a202020204445434c415245204973537570657241646d696e20494e542044454641554c5420303b0d0a202020200d0a202020204946204558495354532853454c454354202a2046524f4d207461646d696e20574845524520557365724964203d20505f55736572496429205448454e0d0a202020202020202053454c4543542069642041532041646d696e49642c20636f64652041532041646d696e436f64652046524f4d207461646d696e20574845524520557365724964203d20505f5573657249643b0d0a20202020454c53450d0a20202020202020204946202853454c45435420434f554e54282a292046524f4d20747573657229203d2031205448454e0d0a202020202020202020202020494e5345525420494e544f2074746561636865722028436f64652c205573657249642c20437265617465644461746554696d652c20557064617465644461746554696d652c20496e737469747574654964290d0a20202020202020202020202056414c5545532028505f436f64652c20505f5573657249642c204e4f5728292c204e4f5728292c2030293b0d0a20202020202020202020202053455420546561636865724964203d204c4153545f494e534552545f494428293b0d0a2020202020202020202020205345542054656163686572436f6465203d20505f436f64653b0d0a202020202020202020202020534554204973537570657241646d696e203d20313b0d0a2020202020202020454e442049463b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f207461646d696e2028436f64652c205573657249642c204973537570657241646d696e2c20496e7374697475746549642c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a202020202020202056414c5545532028505f436f64652c20505f5573657249642c204973537570657241646d696e2c20302c204e4f5728292c204e4f572829293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f494428292041532041646d696e49642c20505f436f64652041532041646d696e436f64652c205465616368657249642c2054656163686572436f64653b0d0a20202020454e442049463b0d0a202020200d0a2020202053454c45435420353b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:11:53', '2023-06-01 13:11:53', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c4152452054656163686572496420494e542044454641554c5420303b0d0a202020204445434c4152452054656163686572436f64652056415243484152283130292044454641554c542027273b0d0a202020204445434c415245204973537570657241646d696e20494e542044454641554c5420303b0d0a202020200d0a202020204946204558495354532853454c454354202a2046524f4d207461646d696e20574845524520557365724964203d20505f55736572496429205448454e0d0a202020202020202053454c4543542069642041532041646d696e49642c20636f64652041532041646d696e436f64652046524f4d207461646d696e20574845524520557365724964203d20505f5573657249643b0d0a20202020454c53450d0a20202020202020204946202853454c45435420434f554e54282a292046524f4d20747573657229203d2031205448454e0d0a202020202020202020202020494e5345525420494e544f2074746561636865722028436f64652c205573657249642c20437265617465644461746554696d652c20557064617465644461746554696d652c20496e737469747574654964290d0a20202020202020202020202056414c5545532028505f436f64652c20505f5573657249642c204e4f5728292c204e4f5728292c2030293b0d0a20202020202020202020202053455420546561636865724964203d204c4153545f494e534552545f494428293b0d0a2020202020202020202020205345542054656163686572436f6465203d20505f436f64653b0d0a202020202020202020202020534554204973537570657241646d696e203d20313b0d0a2020202020202020454e442049463b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f207461646d696e2028436f64652c205573657249642c204973537570657241646d696e2c20496e7374697475746549642c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a202020202020202056414c5545532028505f436f64652c20505f5573657249642c204973537570657241646d696e2c20302c204e4f5728292c204e4f572829293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f494428292041532041646d696e49642c20505f436f64652041532041646d696e436f64652c205465616368657249642c2054656163686572436f64653b0d0a20202020454e442049463b0d0a202020200d0a2020202053454c45435420353b0d0a454e44),
('testdb', 'spCreateBatch', 'PROCEDURE', 'spCreateBatch', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5465616368657249646020494e54283131292c20494e2060505f53747564656e74496460205641524348415228313030292c20494e2060505f496e7374697475746549646020494e54283131292c20494e2060505f436f6465602056415243484152283230292c20494e2060505f5469746c6560205641524348415228313030292c20494e2060505f426174636844617465602044415445, '', 0x424547494e0d0a202020204445434c41524520505f4261746368496420494e542044454641554c5420303b0d0a202020204445434c41524520505f56616c756573205641524348415228353030292044454641554c542027273b0d0a202020204445434c41524520505f496e73657274205641524348415228353030292044454641554c542027273b0d0a202020204445434c41524520505f55736572496420494e542044454641554c5420303b0d0a202020200d0a202020204946204e4f54204558495354532853454c45435420312046524f4d207474656163686572205748455245204964203d20505f54656163686572496429205448454e0d0a202020202020202053454c454354202d313b0d0a20202020454c53454946204558495354532853454c45435420312046524f4d2074626174636820574845524520546561636865724964203d20505f54656163686572496420414e44205469746c65203d20505f5469746c6529205448454e0d0a202020202020202053454c454354202d323b0d0a20202020454c53454946204e4f54204558495354532853454c45435420312046524f4d2074696e73746974757465205748455245204964203d20505f496e73746974757465496429205448454e0d0a202020202020202053454c454354202d333b0d0a20202020454c53450d0a2020202020202020424547494e0d0a2020202020202020202020205354415254205452414e53414354494f4e3b0d0a2020202020202020202020200d0a202020202020202020202020494e5345525420494e544f2074626174636820285465616368657249642c20436f64652c205469746c652c204261746368446174652c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a20202020202020202020202056414c5545532028505f5465616368657249642c20505f436f64652c20505f5469746c652c20505f4261746368446174652c204e4f5728292c204e4f572829293b0d0a2020202020202020202020200d0a20202020202020202020202053455420505f42617463684964203d204c4153545f494e534552545f494428293b0d0a20202020202020202020202053455420505f557365724964203d202853454c454354205573657249642046524f4d207474656163686572205748455245204964203d20505f546561636865724964293b0d0a2020202020202020202020200d0a202020202020202020202020494e5345525420494e544f20746368617467726f75706d617374657220285469746c652c20437265617465645573657249642c20437265617465644461746554696d652c2042617463684964290d0a20202020202020202020202056414c5545532028505f5469746c652c20505f5573657249642c204e4f5728292c20505f42617463684964293b0d0a2020202020202020202020200d0a2020202020202020202020204946204e4f5420505f53747564656e744964203d20273027205448454e0d0a2020202020202020202020202020202053455420505f56616c756573203d205245504c41434528505f53747564656e7449642c20272c272c20434f4e43415428272c272c20505f426174636849642c20222c222c2031312c2022292c282229293b0d0a2020202020202020202020202020202053455420505f56616c756573203d20434f4e434154282728272c20505f56616c7565732c20272c272c20505f426174636849642c20222c222c2031312c20222922293b0d0a202020202020202020202020202020205345542040496e73657274203d20434f4e4341542827494e5345525420494e544f207461737369676e6261746368202853747564656e7449642c20426174636849642c205374617475734964292056414c554553272c20505f56616c756573293b0d0a20202020202020202020202020202020505245504152452073746d742046524f4d2040496e736572743b0d0a20202020202020202020202020202020455845435554452073746d743b0d0a2020202020202020202020202020202053454c45435420505f426174636849643b0d0a202020202020202020202020454c53450d0a2020202020202020202020202020202053454c45435420505f426174636849643b0d0a202020202020202020202020454e442049463b0d0a2020202020202020202020200d0a202020202020202020202020434f4d4d49543b0d0a2020202020202020454e443b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:12:41', '2023-06-01 13:12:41', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520505f4261746368496420494e542044454641554c5420303b0d0a202020204445434c41524520505f56616c756573205641524348415228353030292044454641554c542027273b0d0a202020204445434c41524520505f496e73657274205641524348415228353030292044454641554c542027273b0d0a202020204445434c41524520505f55736572496420494e542044454641554c5420303b0d0a202020200d0a202020204946204e4f54204558495354532853454c45435420312046524f4d207474656163686572205748455245204964203d20505f54656163686572496429205448454e0d0a202020202020202053454c454354202d313b0d0a20202020454c53454946204558495354532853454c45435420312046524f4d2074626174636820574845524520546561636865724964203d20505f54656163686572496420414e44205469746c65203d20505f5469746c6529205448454e0d0a202020202020202053454c454354202d323b0d0a20202020454c53454946204e4f54204558495354532853454c45435420312046524f4d2074696e73746974757465205748455245204964203d20505f496e73746974757465496429205448454e0d0a202020202020202053454c454354202d333b0d0a20202020454c53450d0a2020202020202020424547494e0d0a2020202020202020202020205354415254205452414e53414354494f4e3b0d0a2020202020202020202020200d0a202020202020202020202020494e5345525420494e544f2074626174636820285465616368657249642c20436f64652c205469746c652c204261746368446174652c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a20202020202020202020202056414c5545532028505f5465616368657249642c20505f436f64652c20505f5469746c652c20505f4261746368446174652c204e4f5728292c204e4f572829293b0d0a2020202020202020202020200d0a20202020202020202020202053455420505f42617463684964203d204c4153545f494e534552545f494428293b0d0a20202020202020202020202053455420505f557365724964203d202853454c454354205573657249642046524f4d207474656163686572205748455245204964203d20505f546561636865724964293b0d0a2020202020202020202020200d0a202020202020202020202020494e5345525420494e544f20746368617467726f75706d617374657220285469746c652c20437265617465645573657249642c20437265617465644461746554696d652c2042617463684964290d0a20202020202020202020202056414c5545532028505f5469746c652c20505f5573657249642c204e4f5728292c20505f42617463684964293b0d0a2020202020202020202020200d0a2020202020202020202020204946204e4f5420505f53747564656e744964203d20273027205448454e0d0a2020202020202020202020202020202053455420505f56616c756573203d205245504c41434528505f53747564656e7449642c20272c272c20434f4e43415428272c272c20505f426174636849642c20222c222c2031312c2022292c282229293b0d0a2020202020202020202020202020202053455420505f56616c756573203d20434f4e434154282728272c20505f56616c7565732c20272c272c20505f426174636849642c20222c222c2031312c20222922293b0d0a202020202020202020202020202020205345542040496e73657274203d20434f4e4341542827494e5345525420494e544f207461737369676e6261746368202853747564656e7449642c20426174636849642c205374617475734964292056414c554553272c20505f56616c756573293b0d0a20202020202020202020202020202020505245504152452073746d742046524f4d2040496e736572743b0d0a20202020202020202020202020202020455845435554452073746d743b0d0a2020202020202020202020202020202053454c45435420505f426174636849643b0d0a202020202020202020202020454c53450d0a2020202020202020202020202020202053454c45435420505f426174636849643b0d0a202020202020202020202020454e442049463b0d0a2020202020202020202020200d0a202020202020202020202020434f4d4d49543b0d0a2020202020202020454e443b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spCreateChatList', 'PROCEDURE', 'spCreateChatList', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f46726f6d5573657249646020494e542c20494e2060505f46726f6d526f6c655479706549646020494e542c20494e2060505f546f5573657249646020494e542c20494e2060505f546f526f6c655479706549646020494e542c20494e2060505f47726f757049646020494e542c20494e2060505f4368617444657461696c6020564152434841522831303030292c20494e2060505f426174636849646020494e542c20494e2060505f436f6e74656e74506174686020564152434841522835303029, '', 0x424547494e0d0a202020204445434c4152452043686174496420494e542044454641554c5420303b0d0a202020200d0a202020204946204558495354532853454c45435420312046524f4d20746368617467726f75706d61737465722057484552452042617463684964203d20505f42617463684964204f5220505f47726f75704964203d203029205448454e0d0a2020202020202020494620505f436f6e74656e7450617468204953204e554c4c205448454e0d0a202020202020202020202020424547494e0d0a20202020202020202020202020202020494e5345525420494e544f20746368617420284368617447726f757049642c20546f526f6c655479706549642c20546f5573657249642c2046726f6d526f6c655479706549642c2046726f6d5573657249642c204368617444657461696c2c20437265617465645573657249642c20437265617465644461746554696d65290a0a2020202020202020202020202020202056414c5545532028505f47726f757049642c20505f546f526f6c655479706549642c20505f546f5573657249642c20505f46726f6d526f6c655479706549642c20505f46726f6d5573657249642c20505f4368617444657461696c2c202853454c4543542049464e554c4c28437265617465645573657249642c2030292046524f4d20746368617467726f75706d6173746572205748455245204964203d20505f47726f75704964292c204e4f572829293b0d0a2020202020202020202020202020202053454c454354204c4153545f494e534552545f494428293b0d0a202020202020202020202020454e443b0d0a2020202020202020454c53450d0a202020202020202020202020424547494e0d0a20202020202020202020202020202020494e5345525420494e544f20746368617420284368617447726f757049642c20546f526f6c655479706549642c20546f5573657249642c2046726f6d526f6c655479706549642c2046726f6d5573657249642c20437265617465645573657249642c20437265617465644461746554696d65290d0a2020202020202020202020202020202056414c5545532028505f47726f757049642c20505f546f526f6c655479706549642c20505f546f5573657249642c20505f46726f6d526f6c655479706549642c20505f46726f6d5573657249642c202853454c4543542049464e554c4c28437265617465645573657249642c2030292046524f4d20746368617467726f75706d6173746572205748455245204964203d20505f47726f75704964292c204e4f572829293b0d0a202020202020202020202020202020200d0a2020202020202020202020202020202053455420436861744964203d204c4153545f494e534552545f494428293b0d0a202020202020202020202020202020200d0a202020202020202020202020202020205550444154452074636861740d0a2020202020202020202020202020202053455420436f6e74656e7450617468203d20434f4e43415428505f436f6e74656e74506174682c20275c5c272c204368617449642c20275c5c272c20505f4368617444657461696c290d0a202020202020202020202020202020205748455245204964203d204368617449643b0d0a202020202020202020202020202020200d0a2020202020202020202020202020202053454c454354204368617449643b0d0a202020202020202020202020454e443b0d0a2020202020202020454e442049463b0d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:13:46', '2023-06-01 13:13:46', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c4152452043686174496420494e542044454641554c5420303b0d0a202020200d0a202020204946204558495354532853454c45435420312046524f4d20746368617467726f75706d61737465722057484552452042617463684964203d20505f42617463684964204f5220505f47726f75704964203d203029205448454e0d0a2020202020202020494620505f436f6e74656e7450617468204953204e554c4c205448454e0d0a202020202020202020202020424547494e0d0a20202020202020202020202020202020494e5345525420494e544f20746368617420284368617447726f757049642c20546f526f6c655479706549642c20546f5573657249642c2046726f6d526f6c655479706549642c2046726f6d5573657249642c204368617444657461696c2c20437265617465645573657249642c20437265617465644461746554696d65290a0a2020202020202020202020202020202056414c5545532028505f47726f757049642c20505f546f526f6c655479706549642c20505f546f5573657249642c20505f46726f6d526f6c655479706549642c20505f46726f6d5573657249642c20505f4368617444657461696c2c202853454c4543542049464e554c4c28437265617465645573657249642c2030292046524f4d20746368617467726f75706d6173746572205748455245204964203d20505f47726f75704964292c204e4f572829293b0d0a2020202020202020202020202020202053454c454354204c4153545f494e534552545f494428293b0d0a202020202020202020202020454e443b0d0a2020202020202020454c53450d0a202020202020202020202020424547494e0d0a20202020202020202020202020202020494e5345525420494e544f20746368617420284368617447726f757049642c20546f526f6c655479706549642c20546f5573657249642c2046726f6d526f6c655479706549642c2046726f6d5573657249642c20437265617465645573657249642c20437265617465644461746554696d65290d0a2020202020202020202020202020202056414c5545532028505f47726f757049642c20505f546f526f6c655479706549642c20505f546f5573657249642c20505f46726f6d526f6c655479706549642c20505f46726f6d5573657249642c202853454c4543542049464e554c4c28437265617465645573657249642c2030292046524f4d20746368617467726f75706d6173746572205748455245204964203d20505f47726f75704964292c204e4f572829293b0d0a202020202020202020202020202020200d0a2020202020202020202020202020202053455420436861744964203d204c4153545f494e534552545f494428293b0d0a202020202020202020202020202020200d0a202020202020202020202020202020205550444154452074636861740d0a2020202020202020202020202020202053455420436f6e74656e7450617468203d20434f4e43415428505f436f6e74656e74506174682c20275c272c204368617449642c20275c272c20505f4368617444657461696c290d0a202020202020202020202020202020205748455245204964203d204368617449643b0d0a202020202020202020202020202020200d0a2020202020202020202020202020202053454c454354204368617449643b0d0a202020202020202020202020454e443b0d0a2020202020202020454e442049463b0d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spCreateComment', 'PROCEDURE', 'spCreateComment', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f526566666572656e6365436f6d6d656e7449646020494e542c20494e2060505f5573657249646020494e542c20494e2060505f526f6c655479706549646020494e542c20494e2060505f41737369676e436f6e74656e7449646020494e542c20494e2060505f436f6d6d656e744d657373616765602056415243484152283130303029, '', 0x424547494e0d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a20202020494e5345525420494e544f207473747564796d6174657269616c636f6d6d656e7420285265666572656e6365436f6d6d656e7449642c205573657249642c20526f6c655479706549642c2041737369676e436f6e74656e7449642c20436f6d6d656e7444657461696c2c20437265617465644461746554696d65290d0a2020202056414c5545532028505f526566666572656e6365436f6d6d656e7449642c20505f5573657249642c20505f526f6c655479706549642c20505f41737369676e436f6e74656e7449642c20505f436f6d6d656e744d6573736167652c204e4f572829293b0d0a202020200d0a2020202053454c454354204c4153545f494e534552545f494428293b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:14:19', '2023-06-01 13:14:19', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a20202020494e5345525420494e544f207473747564796d6174657269616c636f6d6d656e7420285265666572656e6365436f6d6d656e7449642c205573657249642c20526f6c655479706549642c2041737369676e436f6e74656e7449642c20436f6d6d656e7444657461696c2c20437265617465644461746554696d65290d0a2020202056414c5545532028505f526566666572656e6365436f6d6d656e7449642c20505f5573657249642c20505f526f6c655479706549642c20505f41737369676e436f6e74656e7449642c20505f436f6d6d656e744d6573736167652c204e4f572829293b0d0a202020200d0a2020202053454c454354204c4153545f494e534552545f494428293b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44),
('testdb', 'spCreateHomeWork', 'PROCEDURE', 'spCreateHomeWork', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f53747564656e7449647360204c4f4e47544558542c20494e2060505f5465616368657249646020494e542c20494e2060505f426174636849646020494e542c20494e2060505f53746174757349646020494e542c20494e2060505f5469746c65602056415243484152283230292c20494e2060505f4e6f746573602056415243484152283435292c20494e2060505f5375626d697373696f6e4461746554696d6560204441544554494d452c20494e2060505f497353656e644e6f74696669636174696f6e486f6d65776f726b4e6f745375626d697460204249542c20494e2060505f497353656e64534d53486f6d65776f726b4e6f745375626d69746020424954, '', 0x424547494e0d0a202020204445434c41524520505f486f6d65576f726b496420494e542044454641554c5420303b0d0a202020204445434c41524520505f56616c756573205641524348415228353030292044454641554c542027273b0d0a202020204445434c41524520505f496e73657274205641524348415228353030292044454641554c542027273b0d0a202020200d0a20202020494620455849535453202853454c45435420312046524f4d207473747564656e742c2074746561636865722c20746261746368205748455245207462617463682e4964203d20505f4261746368496420414e442074746561636865722e4964203d20505f54656163686572496420414e442046494e445f494e5f534554287473747564656e742e49642c20505f53747564656e744964732929205448454e0d0a20202020202020200d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f2074686f6d65776f726b202853747564656e7449642c205465616368657249642c20426174636849642c205469746c652c204e6f74652c20486f6d65576f726b4461746554696d652c20437265617465644461746554696d652c20557064617465644461746554696d652c20497353656e644e6f74696669636174696f6e486f6d65776f726b4e6f745375626d69742c20497353656e64534d53486f6d65776f726b4e6f745375626d6974290d0a202020202020202056414c5545532028505f53747564656e744964732c20505f5465616368657249642c20505f426174636849642c20505f5469746c652c20505f4e6f7465732c20505f5375626d697373696f6e4461746554696d652c204e4f5728292c204e4f5728292c20505f497353656e644e6f74696669636174696f6e486f6d65776f726b4e6f745375626d69742c20505f497353656e64534d53486f6d65776f726b4e6f745375626d6974293b0d0a20202020202020200d0a202020202020202053455420505f486f6d65576f726b4964203d204c4153545f494e534552545f494428293b0d0a202020202020202053455420505f56616c756573203d205245504c41434528505f53747564656e744964732c20272c272c20434f4e43415428272c272c20505f486f6d65576f726b49642c20272c272c20505f53746174757349642c2027292c282729293b0d0a202020202020202053455420505f56616c756573203d20434f4e434154282728272c20505f56616c7565732c20272c272c20505f486f6d65576f726b49642c20272c272c20505f53746174757349642c20272927293b0d0a20202020202020205345542040496e73657274203d20434f4e4341542827494e5345525420494e544f2074686f6d65576f726b41737369676e2853747564656e7449642c20486f6d65776f726b49642c205374617475734964292056414c554553272c20505f56616c756573293b0d0a2020202020202020505245504152452073746d742046524f4d2040496e736572743b0d0a2020202020202020455845435554452073746d743b0d0a20202020202020200d0a202020202020202053454c45435420505f486f6d65576f726b49643b0d0a2020202020202020434f4d4d49543b0d0a20202020202020200d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:15:04', '2023-06-01 13:15:04', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520505f486f6d65576f726b496420494e542044454641554c5420303b0d0a202020204445434c41524520505f56616c756573205641524348415228353030292044454641554c542027273b0d0a202020204445434c41524520505f496e73657274205641524348415228353030292044454641554c542027273b0d0a202020200d0a20202020494620455849535453202853454c45435420312046524f4d207473747564656e742c2074746561636865722c20746261746368205748455245207462617463682e4964203d20505f4261746368496420414e442074746561636865722e4964203d20505f54656163686572496420414e442046494e445f494e5f534554287473747564656e742e49642c20505f53747564656e744964732929205448454e0d0a20202020202020200d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f2074686f6d65776f726b202853747564656e7449642c205465616368657249642c20426174636849642c205469746c652c204e6f74652c20486f6d65576f726b4461746554696d652c20437265617465644461746554696d652c20557064617465644461746554696d652c20497353656e644e6f74696669636174696f6e486f6d65776f726b4e6f745375626d69742c20497353656e64534d53486f6d65776f726b4e6f745375626d6974290d0a202020202020202056414c5545532028505f53747564656e744964732c20505f5465616368657249642c20505f426174636849642c20505f5469746c652c20505f4e6f7465732c20505f5375626d697373696f6e4461746554696d652c204e4f5728292c204e4f5728292c20505f497353656e644e6f74696669636174696f6e486f6d65776f726b4e6f745375626d69742c20505f497353656e64534d53486f6d65776f726b4e6f745375626d6974293b0d0a20202020202020200d0a202020202020202053455420505f486f6d65576f726b4964203d204c4153545f494e534552545f494428293b0d0a202020202020202053455420505f56616c756573203d205245504c41434528505f53747564656e744964732c20272c272c20434f4e43415428272c272c20505f486f6d65576f726b49642c20272c272c20505f53746174757349642c2027292c282729293b0d0a202020202020202053455420505f56616c756573203d20434f4e434154282728272c20505f56616c7565732c20272c272c20505f486f6d65576f726b49642c20272c272c20505f53746174757349642c20272927293b0d0a20202020202020205345542040496e73657274203d20434f4e4341542827494e5345525420494e544f2074686f6d65576f726b41737369676e2853747564656e7449642c20486f6d65776f726b49642c205374617475734964292056414c554553272c20505f56616c756573293b0d0a2020202020202020505245504152452073746d742046524f4d2040496e736572743b0d0a2020202020202020455845435554452073746d743b0d0a20202020202020200d0a202020202020202053454c45435420505f486f6d65576f726b49643b0d0a2020202020202020434f4d4d49543b0d0a20202020202020200d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a454e44);
INSERT INTO `proc` (`db`, `name`, `type`, `specific_name`, `language`, `sql_data_access`, `is_deterministic`, `security_type`, `param_list`, `returns`, `body`, `definer`, `created`, `modified`, `sql_mode`, `comment`, `character_set_client`, `collation_connection`, `db_collation`, `body_utf8`) VALUES
('testdb', 'spCreateInstitute', 'PROCEDURE', 'spCreateInstitute', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5573657249646020494e542c20494e2060505f557365724e616d6560205641524348415228313030292c20494e2060505f436f6465602056415243484152283230292c20494e2060505f5469746c6560205641524348415228313030292c20494e2060505f526f6c655479706549646020494e54, '', 0x[encoded data, 5844 characters], 'testdb@webserver1', '2023-06-01 13:16:03', '2023-06-01 13:16:03', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x[encoded data, 5844 characters]),
('testdb', 'spCreateNoticeBoard', 'PROCEDURE', 'spCreateNoticeBoard', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f426174636849646020494e542c20494e2060505f52656d61726b6020564152434841522835303029, '', 0x424547494e0d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200a0a20202020494620455849535453202853454c45435420312046524f4d20746261746368205748455245204964203d20505f4261746368496429205448454e0d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f20746e6f74696365626f6172642028426174636849642c2052656d61726b2c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a202020202020202056414c5545532028505f426174636849642c20505f52656d61726b2c204e4f5728292c204e4f572829293b0d0a20202020202020200d0a202020202020202053454c45435420434f4e434154285465616368657249642c20275c5c272c204c4153545f494e534552545f49442829290d0a202020202020202046524f4d207462617463680d0a20202020202020205748455245204964203d20505f426174636849643b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a202020202020202053454c454354202d323b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:16:44', '2023-06-01 13:16:44', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200a0a20202020494620455849535453202853454c45435420312046524f4d20746261746368205748455245204964203d20505f4261746368496429205448454e0d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f20746e6f74696365626f6172642028426174636849642c2052656d61726b2c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a202020202020202056414c5545532028505f426174636849642c20505f52656d61726b2c204e4f5728292c204e4f572829293b0d0a20202020202020200d0a202020202020202053454c45435420434f4e434154285465616368657249642c20275c272c204c4153545f494e534552545f49442829290d0a202020202020202046524f4d207462617463680d0a20202020202020205748455245204964203d20505f426174636849643b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a202020202020202053454c454354202d323b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spCreateNotification', 'PROCEDURE', 'spCreateNotification', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5465616368657249646020494e542c20494e2060505f42617463684964602056415243484152283435292c20494e2060505f5469746c65602056415243484152283435292c20494e2060505f4e6f74696669636174696f6e546578746020564152434841522831303030292c20494e2060505f4e6f74696669636174696f6e4461746560204441544554494d45, '', 0x424547494e0d0a202020204445434c41524520505f4e6f74696669636174696f6e496420494e542044454641554c5420303b0d0a202020200d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a20202020494e5345525420494e544f20746e6f74696669636174696f6e20285465616368657249642c20426174636849642c205469746c652c204e6f74696669636174696f6e546578742c204e6f74696669636174696f6e446174652c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a2020202056414c5545532028505f5465616368657249642c20505f426174636849642c20505f5469746c652c20505f4e6f74696669636174696f6e546578742c20505f4e6f74696669636174696f6e446174652c204e4f5728292c204e4f572829293b0d0a202020200d0a2020202053455420505f4e6f74696669636174696f6e4964203d204c4153545f494e534552545f494428293b0d0a202020200d0a2020202053454c45435420505f4e6f74696669636174696f6e49643b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:17:17', '2023-06-01 13:17:17', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520505f4e6f74696669636174696f6e496420494e542044454641554c5420303b0d0a202020200d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a20202020494e5345525420494e544f20746e6f74696669636174696f6e20285465616368657249642c20426174636849642c205469746c652c204e6f74696669636174696f6e546578742c204e6f74696669636174696f6e446174652c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a2020202056414c5545532028505f5465616368657249642c20505f426174636849642c20505f5469746c652c20505f4e6f74696669636174696f6e546578742c20505f4e6f74696669636174696f6e446174652c204e4f5728292c204e4f572829293b0d0a202020200d0a2020202053455420505f4e6f74696669636174696f6e4964203d204c4153545f494e534552545f494428293b0d0a202020200d0a2020202053454c45435420505f4e6f74696669636174696f6e49643b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44),
('testdb', 'spCreatePaymentTransaction', 'PROCEDURE', 'spCreatePaymentTransaction', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f46656549646020494e542c20494e2060505f53747564656e7449646020494e542c20494e2060505f5061796d656e74416d6f756e746020494e542c20494e2060505f5472616e73616374696f6e53746174757349646020494e542c20494e2060505f5061796d656e7452656d61726b60205641524348415228353030292c20494e2060505f4f535479706549646020534d414c4c494e542c20494e2060505f446174654f66466565436f6c6c656374696f6e602044415445, '', 0x424547494e0d0a202020204946204558495354532853454c45435420312046524f4d20746665657365747570205748455245204964203d20505f466565496420414e442053747564656e744964203d20505f53747564656e744964290d0a202020205448454e200d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f20747061796d656e747472616e73616374696f6e2028466565536574757049642c2053747564656e7449642c20506179416d6f756e742c205061794461746554696d652c205061796d656e7452656d61726b2c205472616e73616374696f6e53746174757349642c20446174654f66466565436f6c6c656374696f6e290d0a202020202020202056414c5545532028505f46656549642c20505f53747564656e7449642c20505f5061796d656e74416d6f756e742c204e4f5728292c20505f5061796d656e7452656d61726b2c20505f5472616e73616374696f6e53746174757349642c20505f446174654f66466565436f6c6c656374696f6e293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f4944282920415320526573756c743b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a202020202020202053454c454354202d3120415320526573756c743b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:17:46', '2023-06-01 13:17:46', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204946204558495354532853454c45435420312046524f4d20746665657365747570205748455245204964203d20505f466565496420414e442053747564656e744964203d20505f53747564656e744964290d0a202020205448454e200d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a2020202020202020494e5345525420494e544f20747061796d656e747472616e73616374696f6e2028466565536574757049642c2053747564656e7449642c20506179416d6f756e742c205061794461746554696d652c205061796d656e7452656d61726b2c205472616e73616374696f6e53746174757349642c20446174654f66466565436f6c6c656374696f6e290d0a202020202020202056414c5545532028505f46656549642c20505f53747564656e7449642c20505f5061796d656e74416d6f756e742c204e4f5728292c20505f5061796d656e7452656d61726b2c20505f5472616e73616374696f6e53746174757349642c20505f446174654f66466565436f6c6c656374696f6e293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f4944282920415320526573756c743b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a202020202020202053454c454354202d3120415320526573756c743b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spCreateStudent', 'PROCEDURE', 'spCreateStudent', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f436f6465602056415243484152283130292c20494e2060505f5573657249646020494e54, '', 0x424547494e0d0a202020204946204558495354532853454c454354202a2046524f4d207473747564656e7420574845524520557365724964203d20505f557365724964290d0a202020205448454e0d0a2020202020202020424547494e0d0a20202020202020202020202053454c45435420505f5573657249643b0d0a2020202020202020454e443b0d0a20202020454c53450d0a2020202020202020494e5345525420494e544f207473747564656e742028436f64652c205573657249642c20496e7374697475746549642c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a202020202020202056414c5545532028505f436f64652c20505f5573657249642c20302c204e4f5728292c204e4f572829293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f494428293b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:18:25', '2023-06-01 13:18:25', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204946204558495354532853454c454354202a2046524f4d207473747564656e7420574845524520557365724964203d20505f557365724964290d0a202020205448454e0d0a2020202020202020424547494e0d0a20202020202020202020202053454c45435420505f5573657249643b0d0a2020202020202020454e443b0d0a20202020454c53450d0a2020202020202020494e5345525420494e544f207473747564656e742028436f64652c205573657249642c20496e7374697475746549642c20437265617465644461746554696d652c20557064617465644461746554696d65290d0a202020202020202056414c5545532028505f436f64652c20505f5573657249642c20302c204e4f5728292c204e4f572829293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f494428293b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spCreateSubmitHomeWork', 'PROCEDURE', 'spCreateSubmitHomeWork', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f486f6d65576f726b49646020494e542c20494e2060505f53747564656e7449646020494e54, '', 0x424547494e0d0a202020204946204558495354532853454c45435420312046524f4d2074686f6d65776f726b205748455245204964203d20505f486f6d65576f726b496420414e442046494e445f494e5f53455428505f53747564656e7449642c2053747564656e74496429203e2030290d0a202020205448454e0d0a20202020202020204946204e4f54204558495354532853454c45435420312046524f4d2074686f6d65776f726b7375626d6974746564616e7377657220574845524520486f6d65776f726b4964203d20505f486f6d65576f726b496420414e442053747564656e744964203d20505f53747564656e744964290d0a20202020202020205448454e0d0a2020202020202020202020205354415254205452414e53414354494f4e3b0d0a2020202020202020202020200d0a202020202020202020202020494e5345525420494e544f2074686f6d65776f726b7375626d6974746564616e737765722028486f6d65576f726b49642c2053747564656e744964290d0a20202020202020202020202056414c5545532028505f486f6d65576f726b49642c20505f53747564656e744964293b0d0a2020202020202020202020200d0a20202020202020202020202053454c45435420313b0d0a202020202020202020202020434f4d4d49543b0d0a2020202020202020454c53450d0a20202020202020202020202053454c45435420313b0d0a2020202020202020454e442049463b0d0a20202020454c53450d0a20202020202020204946204e4f54204558495354532853454c45435420312046524f4d2074686f6d65776f726b205748455245204964203d20505f486f6d65576f726b496420414e442046494e445f494e5f53455428505f53747564656e7449642c2053747564656e74496429203e2030290d0a20202020202020205448454e0d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d313b0d0a2020202020202020454e442049463b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:18:54', '2023-06-01 13:18:54', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204946204558495354532853454c45435420312046524f4d2074686f6d65776f726b205748455245204964203d20505f486f6d65576f726b496420414e442046494e445f494e5f53455428505f53747564656e7449642c2053747564656e74496429203e2030290d0a202020205448454e0d0a20202020202020204946204e4f54204558495354532853454c45435420312046524f4d2074686f6d65776f726b7375626d6974746564616e7377657220574845524520486f6d65776f726b4964203d20505f486f6d65576f726b496420414e442053747564656e744964203d20505f53747564656e744964290d0a20202020202020205448454e0d0a2020202020202020202020205354415254205452414e53414354494f4e3b0d0a2020202020202020202020200d0a202020202020202020202020494e5345525420494e544f2074686f6d65776f726b7375626d6974746564616e737765722028486f6d65576f726b49642c2053747564656e744964290d0a20202020202020202020202056414c5545532028505f486f6d65576f726b49642c20505f53747564656e744964293b0d0a2020202020202020202020200d0a20202020202020202020202053454c45435420313b0d0a202020202020202020202020434f4d4d49543b0d0a2020202020202020454c53450d0a20202020202020202020202053454c45435420313b0d0a2020202020202020454e442049463b0d0a20202020454c53450d0a20202020202020204946204e4f54204558495354532853454c45435420312046524f4d2074686f6d65776f726b205748455245204964203d20505f486f6d65576f726b496420414e442046494e445f494e5f53455428505f53747564656e7449642c2053747564656e74496429203e2030290d0a20202020202020205448454e0d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d313b0d0a2020202020202020454e442049463b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spCreateTeacher', 'PROCEDURE', 'spCreateTeacher', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f436f6465602056415243484152283130292c20494e2060505f5573657249646020494e54, '', 0x424547494e0d0a202020204946204558495354532853454c454354202a2046524f4d20747465616368657220574845524520557365724964203d20505f557365724964290d0a202020205448454e0d0a202020202020202053454c45435420505f5573657249643b0a0a20202020454c53450d0a2020202020202020494e5345525420494e544f20747465616368657228436f64652c205573657249642c20437265617465644461746554696d652c20557064617465644461746554696d652c20496e737469747574654964290d0a202020202020202056414c5545532028505f436f64652c20505f5573657249642c204e4f5728292c204e4f5728292c2030293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f494428293b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:19:24', '2023-06-01 13:19:24', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204946204558495354532853454c454354202a2046524f4d20747465616368657220574845524520557365724964203d20505f557365724964290d0a202020205448454e0d0a202020202020202053454c45435420505f5573657249643b0a0a20202020454c53450d0a2020202020202020494e5345525420494e544f20747465616368657228436f64652c205573657249642c20437265617465644461746554696d652c20557064617465644461746554696d652c20496e737469747574654964290d0a202020202020202056414c5545532028505f436f64652c20505f5573657249642c204e4f5728292c204e4f5728292c2030293b0d0a20202020202020200d0a202020202020202053454c454354204c4153545f494e534552545f494428293b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spDeleteAssignTeacherContent', 'PROCEDURE', 'spDeleteAssignTeacherContent', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f436f6e74656e7449646020494e54, '', 0x424547494e0d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a2020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020205748455245204964203d20505f436f6e74656e7449643b0d0a202020200d0a2020202053454c45435420313b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:21:02', '2023-06-01 13:21:02', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a2020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020205748455245204964203d20505f436f6e74656e7449643b0d0a202020200d0a2020202053454c45435420313b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44),
('testdb', 'spDeleteBatch', 'PROCEDURE', 'spDeleteBatch', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f426174636849646020494e54, '', 0x424547494e0d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a2020202044454c4554452046524f4d20746368617467726f75706d61737465720d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207465746573740d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207466656573657475700d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d2074686f6d65776f726b0d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746e6f74696365626f6172640d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746f6e6c696e656c6563747572650d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746f6e6c696e656c6563747572656d656574696e676163636f756e740d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746f6e6c696e656c6563747572656d656574696e6773657474696e67730d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207474696d657461626c650d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202055504441544520746e6f74696669636174696f6e0d0a202020205345542042617463684964203d205245504c414345285245504c414345285245504c41434528426174636849642c20434f4e43415428505f426174636849642c20272c27292c202727292c20434f4e43415428272c272c20505f42617463684964292c202727292c20505f426174636849642c202727290d0a2020202057484552452046494e445f494e5f53455428505f426174636849642c2042617463684964293b0d0a202020200d0a2020202044454c4554452046524f4d207461737369676e62617463680d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746e6f74696669636174696f6e2057484552452042617463684964203d2027273b0d0a202020200d0a2020202044454c4554452046524f4d207462617463680d0a202020205748455245204964203d20505f426174636849643b0d0a202020200d0a20202020434f4d4d49543b0d0a202020200d0a2020202053454c45435420313b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:21:02', '2023-06-01 13:21:02', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a2020202044454c4554452046524f4d20746368617467726f75706d61737465720d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207465746573740d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207466656573657475700d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d2074686f6d65776f726b0d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746e6f74696365626f6172640d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746f6e6c696e656c6563747572650d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746f6e6c696e656c6563747572656d656574696e676163636f756e740d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746f6e6c696e656c6563747572656d656574696e6773657474696e67730d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d207474696d657461626c650d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202055504441544520746e6f74696669636174696f6e0d0a202020205345542042617463684964203d205245504c414345285245504c414345285245504c41434528426174636849642c20434f4e43415428505f426174636849642c20272c27292c202727292c20434f4e43415428272c272c20505f42617463684964292c202727292c20505f426174636849642c202727290d0a2020202057484552452046494e445f494e5f53455428505f426174636849642c2042617463684964293b0d0a202020200d0a2020202044454c4554452046524f4d207461737369676e62617463680d0a2020202057484552452042617463684964203d20505f426174636849643b0d0a202020200d0a2020202044454c4554452046524f4d20746e6f74696669636174696f6e2057484552452042617463684964203d2027273b0d0a202020200d0a2020202044454c4554452046524f4d207462617463680d0a202020205748455245204964203d20505f426174636849643b0d0a202020200d0a20202020434f4d4d49543b0d0a202020200d0a2020202053454c45435420313b0d0a454e44),
('testdb', 'spDeleteComment', 'PROCEDURE', 'spDeleteComment', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5573657249646020494e542c20494e2060505f436f6d6d656e7449646020494e54, '', 0x424547494e0d0a202020204946204558495354532853454c45435420312046524f4d207473747564796d6174657269616c636f6d6d656e74205748455245204964203d20505f436f6d6d656e74496420414e4420557365724964203d20505f557365724964290d0a202020205448454e0d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207473747564796d6174657269616c636f6d6d656e740d0a20202020202020205748455245204964203d20505f436f6d6d656e744964204f52205265666572656e6365436f6d6d656e744964203d20505f436f6d6d656e7449643b0d0a20202020202020200d0a202020202020202053454c45435420313b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:21:42', '2023-06-01 13:21:42', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204946204558495354532853454c45435420312046524f4d207473747564796d6174657269616c636f6d6d656e74205748455245204964203d20505f436f6d6d656e74496420414e4420557365724964203d20505f557365724964290d0a202020205448454e0d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207473747564796d6174657269616c636f6d6d656e740d0a20202020202020205748455245204964203d20505f436f6d6d656e744964204f52205265666572656e6365436f6d6d656e744964203d20505f436f6d6d656e7449643b0d0a20202020202020200d0a202020202020202053454c45435420313b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spDeleteContentPath', 'PROCEDURE', 'spDeleteContentPath', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f436f6e74656e7449646020494e54, '', 0x424547494e0d0a202020204445434c41524520505f54656163686572436f6e74656e74496420494e543b0d0a202020200d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a2020202020202020524f4c4c4241434b3b0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200d0a202020204946204558495354532853454c45435420312046524f4d207474656163686572436f6e74656e74205748455245204964203d20505f436f6e74656e74496420414e4420436f6e74656e744c696e6b204953204e554c4c290d0a202020205448454e0d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572436f6e74656e740d0a20202020202020205748455245204964203d20505f436f6e74656e7449643b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020202020202057484552452054656163686572436f6e74656e744964203d20505f436f6e74656e7449643b0d0a20202020202020200d0a202020202020202053454c45435420313b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a202020202020202053455420505f54656163686572436f6e74656e744964203d202853454c454354202a2046524f4d207474656163686572636f6e74656e74205748455245205245474558505f4c494b4528436f6e74656e74506174682c20434f4e43415428225e436f6e74656e742e41737369676e436f6e74656e742e5b612d7a412d5a302d395d2a222c20505f436f6e74656e7449642c202224222929293b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572436f6e74656e740d0a20202020202020205748455245204964203d20505f436f6e74656e744964204f5220496420494e202853454c45435420505f54656163686572436f6e74656e744964293b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020202020202057484552452054656163686572436f6e74656e74496420494e202853454c45435420505f54656163686572436f6e74656e744964293b0d0a20202020202020200d0a202020202020202053454c45435420313b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:21:42', '2023-06-01 13:21:42', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520505f54656163686572436f6e74656e74496420494e543b0d0a202020200d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a2020202020202020524f4c4c4241434b3b0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200d0a202020204946204558495354532853454c45435420312046524f4d207474656163686572436f6e74656e74205748455245204964203d20505f436f6e74656e74496420414e4420436f6e74656e744c696e6b204953204e554c4c290d0a202020205448454e0d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572436f6e74656e740d0a20202020202020205748455245204964203d20505f436f6e74656e7449643b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020202020202057484552452054656163686572436f6e74656e744964203d20505f436f6e74656e7449643b0d0a20202020202020200d0a202020202020202053454c45435420313b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454c53450d0a20202020202020205354415254205452414e53414354494f4e3b0d0a20202020202020200d0a202020202020202053455420505f54656163686572436f6e74656e744964203d202853454c454354202a2046524f4d207474656163686572636f6e74656e74205748455245205245474558505f4c494b4528436f6e74656e74506174682c20434f4e43415428225e436f6e74656e742e41737369676e436f6e74656e742e5b612d7a412d5a302d395d2a222c20505f436f6e74656e7449642c202224222929293b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572436f6e74656e740d0a20202020202020205748455245204964203d20505f436f6e74656e744964204f5220496420494e202853454c45435420505f54656163686572436f6e74656e744964293b0d0a20202020202020200d0a202020202020202044454c4554452046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020202020202057484552452054656163686572436f6e74656e74496420494e202853454c45435420505f54656163686572436f6e74656e744964293b0d0a20202020202020200d0a202020202020202053454c45435420313b0d0a20202020202020200d0a2020202020202020434f4d4d49543b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spDeleteDoubtSession', 'PROCEDURE', 'spDeleteDoubtSession', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f54696d655461626c6549646020494e54, '', 0x424547494e0d0a2020202044454c4554452046524f4d207474696d657461626c650d0a202020205748455245204964203d20505f54696d655461626c6549643b0d0a202020200d0a20202020434f4d4d49543b0d0a202020200d0a2020202053454c45435420313b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:22:23', '2023-06-01 13:22:23', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a2020202044454c4554452046524f4d207474696d657461626c650d0a202020205748455245204964203d20505f54696d655461626c6549643b0d0a202020200d0a20202020434f4d4d49543b0d0a202020200d0a2020202053454c45435420313b0d0a454e44),
('testdb', 'spDeleteETestQuestions', 'PROCEDURE', 'spDeleteETestQuestions', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5175657374696f6e49646020494e54, '', 0x424547494e0d0a202020204445434c415245205175657374696f6e50617468205641524348415228353030292044454641554c542027273b0d0a202020200d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a202020204946204e4f54204558495354532853454c45435420312046524f4d207465746573747175657374696f6e73205748455245204964203d20505f5175657374696f6e496420414e442049735375626d6974746564203d2031290d0a202020205448454e0d0a2020202020202020534554205175657374696f6e50617468203d202853454c4543542046696c65706174682046524f4d207465746573747175657374696f6e73205748455245204964203d20505f5175657374696f6e4964293b0d0a20202020202020200d0a202020202020202044454c4554452074716f2046524f4d207465746573747175657374696f6e6f7074696f6e732074716f2057484552452074716f2e5175657374696f6e4964203d20505f5175657374696f6e49643b0d0a202020202020202044454c455445207474712046524f4d207465746573747175657374696f6e7320747471205748455245207474712e4964203d20505f5175657374696f6e49643b0d0a20202020202020200d0a202020202020202053454c454354205175657374696f6e506174683b0d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:22:23', '2023-06-01 13:22:23', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c415245205175657374696f6e50617468205641524348415228353030292044454641554c542027273b0d0a202020200d0a202020205354415254205452414e53414354494f4e3b0d0a202020200d0a202020204946204e4f54204558495354532853454c45435420312046524f4d207465746573747175657374696f6e73205748455245204964203d20505f5175657374696f6e496420414e442049735375626d6974746564203d2031290d0a202020205448454e0d0a2020202020202020534554205175657374696f6e50617468203d202853454c4543542046696c65706174682046524f4d207465746573747175657374696f6e73205748455245204964203d20505f5175657374696f6e4964293b0d0a20202020202020200d0a202020202020202044454c4554452074716f2046524f4d207465746573747175657374696f6e6f7074696f6e732074716f2057484552452074716f2e5175657374696f6e4964203d20505f5175657374696f6e49643b0d0a202020202020202044454c455445207474712046524f4d207465746573747175657374696f6e7320747471205748455245207474712e4964203d20505f5175657374696f6e49643b0d0a20202020202020200d0a202020202020202053454c454354205175657374696f6e506174683b0d0a20202020454c53450d0a202020202020202053454c454354202d313b0d0a20202020454e442049463b0d0a202020200d0a20202020434f4d4d49543b0d0a454e44),
('testdb', 'spDeleteHomeWork', 'PROCEDURE', 'spDeleteHomeWork', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f486f6d65776f726b49646020494e54, '', 0x424547494e0d0a2020202044454c4554452046524f4d2074686f6d65776f726b205748455245204964203d20505f486f6d65776f726b49643b0d0a2020202044454c4554452046524f4d2074686f6d65776f726b61737369676e20574845524520486f6d65576f726b4964203d20505f486f6d65776f726b49643b0d0a202020200d0a2020202053454c45435420313b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:22:23', '2023-06-01 13:22:23', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a2020202044454c4554452046524f4d2074686f6d65776f726b205748455245204964203d20505f486f6d65776f726b49643b0d0a2020202044454c4554452046524f4d2074686f6d65776f726b61737369676e20574845524520486f6d65576f726b4964203d20505f486f6d65776f726b49643b0d0a202020200d0a2020202053454c45435420313b0d0a454e44);
INSERT INTO `proc` (`db`, `name`, `type`, `specific_name`, `language`, `sql_data_access`, `is_deterministic`, `security_type`, `param_list`, `returns`, `body`, `definer`, `created`, `modified`, `sql_mode`, `comment`, `character_set_client`, `collation_connection`, `db_collation`, `body_utf8`) VALUES
('testdb', 'spDeleteInstitute', 'PROCEDURE', 'spDeleteInstitute', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f496e7374697475746549646020494e54, '', 0x[encoded data, 7004 characters], 'testdb@webserver1', '2023-06-01 13:24:08', '2023-06-01 13:24:08', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x[encoded data, 7004 characters]),
('testdb', 'spDeleteNoticeBoard', 'PROCEDURE', 'spDeleteNoticeBoard', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f4e6f7469636549646020494e54, '', 0x424547494e0d0a094445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a09424547494e0d0a090953454c454354202d313b0d0a09454e443b0d0a090d0a094946204e4f5420455849535453202853454c45435420312046524f4d20746e6f74696365626f617264205748455245206964203d20505f4e6f74696365496429205448454e0d0a090953454c454354202d323b0d0a09454c53450d0a09095354415254205452414e53414354494f4e3b0d0a09090944454c4554452046524f4d20746e6f74696365626f6172640d0a0909095748455245204964203d20505f4e6f7469636549643b0d0a09090953454c45435420313b0d0a0909434f4d4d49543b0d0a09454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:25:02', '2023-06-01 13:25:02', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a094445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a09424547494e0d0a090953454c454354202d313b0d0a09454e443b0d0a090d0a094946204e4f5420455849535453202853454c45435420312046524f4d20746e6f74696365626f617264205748455245206964203d20505f4e6f74696365496429205448454e0d0a090953454c454354202d323b0d0a09454c53450d0a09095354415254205452414e53414354494f4e3b0d0a09090944454c4554452046524f4d20746e6f74696365626f6172640d0a0909095748455245204964203d20505f4e6f7469636549643b0d0a09090953454c45435420313b0d0a0909434f4d4d49543b0d0a09454e442049463b0d0a454e44),
('testdb', 'spDeleteNotification', 'PROCEDURE', 'spDeleteNotification', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f4e6f74696669636174696f6e49646020494e54, '', 0x424547494e0d0a0944454c4554452046524f4d20746e6f74696669636174696f6e0d0a095748455245204964203d20505f4e6f74696669636174696f6e49643b0d0a0953454c45435420313b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:25:02', '2023-06-01 13:25:02', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a0944454c4554452046524f4d20746e6f74696669636174696f6e0d0a095748455245204964203d20505f4e6f74696669636174696f6e49643b0d0a0953454c45435420313b0d0a454e44),
('testdb', 'spDeleteOnlinelecture', 'PROCEDURE', 'spDeleteOnlinelecture', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f4c65637475726549646020494e54, '', 0x424547494e0d0a09494620455849535453202853454c45435420312046524f4d20746f6e6c696e656c656374757265205748455245204964203d20505f4c656374757265496429205448454e0d0a090944454c4554452046524f4d20746f6e6c696e656c6563747572650d0a09095748455245204964203d20505f4c65637475726549643b0d0a09454c53450d0a090953454c454354202d313b0d0a09454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:25:43', '2023-06-01 13:25:43', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a09494620455849535453202853454c45435420312046524f4d20746f6e6c696e656c656374757265205748455245204964203d20505f4c656374757265496429205448454e0d0a090944454c4554452046524f4d20746f6e6c696e656c6563747572650d0a09095748455245204964203d20505f4c65637475726549643b0d0a09454c53450d0a090953454c454354202d313b0d0a09454e442049463b0d0a454e44),
('testdb', 'spDeleteOnlineMeetingAccount', 'PROCEDURE', 'spDeleteOnlineMeetingAccount', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f4163636f756e7449646020494e54, '', 0x424547494e0d0a09494620455849535453202853454c45435420312046524f4d20746f6e6c696e656c6563747572656d656574696e676163636f756e74205748455245206964203d20505f4163636f756e74496429205448454e0d0a090944454c45544520746d612c20746c730d0a090946524f4d20746f6e6c696e656c6563747572656d656574696e676163636f756e7420746d610d0a09094c454654204a4f494e20746f6e6c696e656c6563747572656d656574696e6773657474696e677320746c73204f4e20746d612e42617463684964203d20746c732e426174636849640d0a0909574845524520746d612e4964203d20505f4163636f756e7449643b0d0a0909434f4d4d49543b0d0a090953454c45435420313b0d0a09454c53450d0a090953454c454354202d313b0d0a09454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:25:43', '2023-06-01 13:25:43', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a09494620455849535453202853454c45435420312046524f4d20746f6e6c696e656c6563747572656d656574696e676163636f756e74205748455245206964203d20505f4163636f756e74496429205448454e0d0a090944454c45544520746d612c20746c730d0a090946524f4d20746f6e6c696e656c6563747572656d656574696e676163636f756e7420746d610d0a09094c454654204a4f494e20746f6e6c696e656c6563747572656d656574696e6773657474696e677320746c73204f4e20746d612e42617463684964203d20746c732e426174636849640d0a0909574845524520746d612e4964203d20505f4163636f756e7449643b0d0a0909434f4d4d49543b0d0a090953454c45435420313b0d0a09454c53450d0a090953454c454354202d313b0d0a09454e442049463b0d0a454e44),
('testdb', 'spDeleteStudent', 'PROCEDURE', 'spDeleteStudent', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f53747564656e7449646020494e542c20494e2060505f426174636849646020494e542c20494e2060505f496e7374697475746549646020494e54, '', 0x424547494e0d0a0949462028505f42617463684964203d203029205448454e0d0a0909494620455849535453202853454c45435420312046524f4d207473747564656e742c207462617463682c2074696e73746974757465205748455245207473747564656e742e4964203d20505f53747564656e74496420414e442074696e737469747574652e4964203d20505f496e73746974757465496429205448454e0d0a0909095354415254205452414e53414354494f4e3b0d0a09090944454c4554452046524f4d207473747564656e740d0a0909095748455245207473747564656e742e4964203d20505f53747564656e7449643b0d0a09090943414c4c207370556e61737369676e426174636828505f426174636849642c20505f53747564656e744964293b0d0a09090953454c45435420313b0d0a090909434f4d4d49543b0d0a0909454c53450d0a09090953454c454354202d323b0d0a0909454e442049463b0d0a09454c53450d0a0909494620455849535453202853454c45435420312046524f4d207473747564656e742c207462617463682c2074696e73746974757465205748455245207473747564656e742e4964203d20505f53747564656e74496420414e44207462617463682e4964203d20505f4261746368496420414e442074696e737469747574652e4964203d20505f496e73746974757465496429205448454e0d0a09090943414c4c207370556e61737369676e426174636828505f426174636849642c20505f53747564656e744964293b0d0a0909454c53450d0a09090953454c454354202d323b0d0a0909454e442049463b0d0a09454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:25:43', '2023-06-01 13:25:43', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a0949462028505f42617463684964203d203029205448454e0d0a0909494620455849535453202853454c45435420312046524f4d207473747564656e742c207462617463682c2074696e73746974757465205748455245207473747564656e742e4964203d20505f53747564656e74496420414e442074696e737469747574652e4964203d20505f496e73746974757465496429205448454e0d0a0909095354415254205452414e53414354494f4e3b0d0a09090944454c4554452046524f4d207473747564656e740d0a0909095748455245207473747564656e742e4964203d20505f53747564656e7449643b0d0a09090943414c4c207370556e61737369676e426174636828505f426174636849642c20505f53747564656e744964293b0d0a09090953454c45435420313b0d0a090909434f4d4d49543b0d0a0909454c53450d0a09090953454c454354202d323b0d0a0909454e442049463b0d0a09454c53450d0a0909494620455849535453202853454c45435420312046524f4d207473747564656e742c207462617463682c2074696e73746974757465205748455245207473747564656e742e4964203d20505f53747564656e74496420414e44207462617463682e4964203d20505f4261746368496420414e442074696e737469747574652e4964203d20505f496e73746974757465496429205448454e0d0a09090943414c4c207370556e61737369676e426174636828505f426174636849642c20505f53747564656e744964293b0d0a0909454c53450d0a09090953454c454354202d323b0d0a0909454e442049463b0d0a09454e442049463b0d0a454e44),
('testdb', 'spDeleteSubCategory', 'PROCEDURE', 'spDeleteSubCategory', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f53756263617465676f727949646020494e54, '', 0x424547494e0d0a094445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a09424547494e0d0a090953454c45435420222d31223b0d0a09454e443b0d0a0d0a094946204e4f5420455849535453202853454c45435420312046524f4d207453756243617465676f72794d6173746572205748455245206964203d20505f53756263617465676f7279496429205448454e0d0a0909424547494e0d0a09090953454c454354202d333b0d0a0909454e443b0d0a09454c53450d0a0909424547494e0d0a0909095354415254205452414e53414354494f4e3b0d0a09090944454c4554452046524f4d207453756243617465676f72794d6173746572205748455245206964203d20505f53756263617465676f727949643b0d0a090909434f4d4d49543b0d0a09090953454c45435420313b0d0a0909454e443b0d0a09454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:27:48', '2023-06-01 13:27:48', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a094445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a09424547494e0d0a090953454c45435420222d31223b0d0a09454e443b0d0a0d0a094946204e4f5420455849535453202853454c45435420312046524f4d207453756243617465676f72794d6173746572205748455245206964203d20505f53756263617465676f7279496429205448454e0d0a0909424547494e0d0a09090953454c454354202d333b0d0a0909454e443b0d0a09454c53450d0a0909424547494e0d0a0909095354415254205452414e53414354494f4e3b0d0a09090944454c4554452046524f4d207453756243617465676f72794d6173746572205748455245206964203d20505f53756263617465676f727949643b0d0a090909434f4d4d49543b0d0a09090953454c45435420313b0d0a0909454e443b0d0a09454e442049463b0d0a454e44),
('testdb', 'spDeleteSubmitHomeWork', 'PROCEDURE', 'spDeleteSubmitHomeWork', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f486f6d65576f726b49646020494e542c20494e2060505f53747564656e7449646020494e54, '', 0x424547494e0d0a0944454c4554452046524f4d2074686f6d65776f726b7375626d6974746564616e7377657220574845524520486f6d65576f726b4964203d20505f486f6d65576f726b496420414e442053747564656e744964203d20505f53747564656e7449643b0d0a0953454c45435420313b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:27:48', '2023-06-01 13:27:48', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a0944454c4554452046524f4d2074686f6d65776f726b7375626d6974746564616e7377657220574845524520486f6d65576f726b4964203d20505f486f6d65576f726b496420414e442053747564656e744964203d20505f53747564656e7449643b0d0a0953454c45435420313b0d0a454e44),
('testdb', 'spDeleteTeacherContent', 'PROCEDURE', 'spDeleteTeacherContent', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5465616368657249646020494e542c20494e2060505f436f6e74656e7449646020494e542c20494e2060505f466f6c6465725061746860205641524348415228353030292c20494e2060505f436f6e74656e745479706549646020494e542c20494e2060505f41737369676e436f6e74656e746020494e54, '', 0x[encoded data, 6162 characters], 'testdb@webserver1', '2023-06-01 13:27:48', '2023-06-01 13:27:48', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x[encoded data, 6150 characters]),
('testdb', 'spDeleteTest', 'PROCEDURE', 'spDeleteTest', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x60505f5465737449646020494e54, '', 0x424547494e0d0a094445434c415245205175657374696f6e436f756e7420494e542044454641554c5420303b0d0a094445434c415245204f7074696f6e436f756e7420494e542044454641554c5420303b0d0a0d0a0949462045584953545320280d0a09090953454c45435420310d0a09090946524f4d2074657465737420540d0a090909574845524520434153450d0a09090909095748454e2049464e554c4c28542e457870697279446174652c2027313930302d30312d30312729203d2027313930302d30312d303127205448454e202828542e537461727454696d65202b20494e54455256414c20542e4475726174696f6e204d494e555445203c2054494d455f464f524d41542843555254494d4528292c20222554222920414e4420542e537461727444617465203d2043555244415445282929204f522028542e537461727444617465203c2043555244415445282929290d0a0909090909454c5345202828542e45787069727954696d65203c2054494d455f464f524d41542843555254494d4528292c20222554222920414e4420542e45787069727944617465203d2043555244415445282929204f522028542e45787069727944617465203c2043555244415445282929290d0a09090909454e440d0a09090909414e4420542e49735375626d6974746564203d20310d0a09090909414e4420542e6964203d20505f5465737449640d0a09090929205448454e0d0a090953454c454354202d3120415320526573756c743b0d0a09454c53450d0a0909424547494e0d0a0909095354415254205452414e53414354494f4e3b0d0a090909534554205175657374696f6e436f756e74203d202853454c45435420434f554e54284964292046524f4d207465746573747175657374696f6e7320574845524520546573744964203d20505f5465737449642047524f555020425920546573744964293b0d0a090909494620285175657374696f6e436f756e74203e3d203029205448454e0d0a09090909424547494e0d0a09090909094352454154452054454d504f52415259205441424c45205175657374696f6e49645461626c652053454c4543542049642c2046696c65506174682046524f4d207465746573747175657374696f6e7320574845524520546573744964203d20505f5465737449643b0d0a09090909094352454154452054454d504f52415259205441424c45204f7074696f6e49645461626c652053454c4543542074746f2e49642c2074746f2e46696c65506174682046524f4d207465746573747175657374696f6e6f7074696f6e732074746f20494e4e4552204a4f494e207465746573747175657374696f6e7320747471204f4e207474712e4964203d2074746f2e5175657374696f6e496420574845524520546573744964203d20505f5465737449643b0d0a090909090944454c4554452074716f2046524f4d207465746573747175657374696f6e6f7074696f6e732074716f20494e4e4552204a4f494e205175657374696f6e49645461626c6520514944204f4e205149442e4964203d2074716f2e5175657374696f6e49643b0d0a090909090944454c455445207474712046524f4d207465746573747175657374696f6e732074747120494e4e4552204a4f494e205175657374696f6e49645461626c6520514944204f4e205149442e4964203d207474712e4964205748455245207474712e546573744964203d20505f5465737449643b0d0a090909090944454c455445207470712046524f4d2074706172617175657374696f6e732074707120494e4e4552204a4f494e20746574657374207465204f4e2074652e6964203d207470712e5465737449642057484552452074652e6964203d20505f5465737449643b0d0a090909090944454c455445207465746573742046524f4d20746574657374205748455245204964203d20505f5465737449643b0d0a090909090953454c454354203120415320526573756c743b0d0a090909090953454c454354202a2046524f4d205175657374696f6e49645461626c652057484552452049464e554c4c2846696c65506174682c2027272920213d2027273b0d0a090909090953454c454354202a2046524f4d204f7074696f6e49645461626c652057484552452049464e554c4c2846696c65506174682c2027272920213d2027273b0d0a09090909454e443b0d0a090909454e442049463b0d0a09090944454c455445207465746573742046524f4d20746574657374205748455245204964203d20505f5465737449643b0d0a09090953454c454354203120415320526573756c743b0d0a090909434f4d4d49543b0d0a0d0a09090944524f502054454d504f52415259205441424c4520494620455849535453205175657374696f6e49645461626c653b0d0a09090944524f502054454d504f52415259205441424c4520494620455849535453204f7074696f6e49645461626c653b0d0a0909454e443b0d0a09454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:27:48', '2023-06-01 13:27:48', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a094445434c415245205175657374696f6e436f756e7420494e542044454641554c5420303b0d0a094445434c415245204f7074696f6e436f756e7420494e542044454641554c5420303b0d0a0d0a0949462045584953545320280d0a09090953454c45435420310d0a09090946524f4d2074657465737420540d0a090909574845524520434153450d0a09090909095748454e2049464e554c4c28542e457870697279446174652c2027313930302d30312d30312729203d2027313930302d30312d303127205448454e202828542e537461727454696d65202b20494e54455256414c20542e4475726174696f6e204d494e555445203c2054494d455f464f524d41542843555254494d4528292c20222554222920414e4420542e537461727444617465203d2043555244415445282929204f522028542e537461727444617465203c2043555244415445282929290d0a0909090909454c5345202828542e45787069727954696d65203c2054494d455f464f524d41542843555254494d4528292c20222554222920414e4420542e45787069727944617465203d2043555244415445282929204f522028542e45787069727944617465203c2043555244415445282929290d0a09090909454e440d0a09090909414e4420542e49735375626d6974746564203d20310d0a09090909414e4420542e6964203d20505f5465737449640d0a09090929205448454e0d0a090953454c454354202d3120415320526573756c743b0d0a09454c53450d0a0909424547494e0d0a0909095354415254205452414e53414354494f4e3b0d0a090909534554205175657374696f6e436f756e74203d202853454c45435420434f554e54284964292046524f4d207465746573747175657374696f6e7320574845524520546573744964203d20505f5465737449642047524f555020425920546573744964293b0d0a090909494620285175657374696f6e436f756e74203e3d203029205448454e0d0a09090909424547494e0d0a09090909094352454154452054454d504f52415259205441424c45205175657374696f6e49645461626c652053454c4543542049642c2046696c65506174682046524f4d207465746573747175657374696f6e7320574845524520546573744964203d20505f5465737449643b0d0a09090909094352454154452054454d504f52415259205441424c45204f7074696f6e49645461626c652053454c4543542074746f2e49642c2074746f2e46696c65506174682046524f4d207465746573747175657374696f6e6f7074696f6e732074746f20494e4e4552204a4f494e207465746573747175657374696f6e7320747471204f4e207474712e4964203d2074746f2e5175657374696f6e496420574845524520546573744964203d20505f5465737449643b0d0a090909090944454c4554452074716f2046524f4d207465746573747175657374696f6e6f7074696f6e732074716f20494e4e4552204a4f494e205175657374696f6e49645461626c6520514944204f4e205149442e4964203d2074716f2e5175657374696f6e49643b0d0a090909090944454c455445207474712046524f4d207465746573747175657374696f6e732074747120494e4e4552204a4f494e205175657374696f6e49645461626c6520514944204f4e205149442e4964203d207474712e4964205748455245207474712e546573744964203d20505f5465737449643b0d0a090909090944454c455445207470712046524f4d2074706172617175657374696f6e732074707120494e4e4552204a4f494e20746574657374207465204f4e2074652e6964203d207470712e5465737449642057484552452074652e6964203d20505f5465737449643b0d0a090909090944454c455445207465746573742046524f4d20746574657374205748455245204964203d20505f5465737449643b0d0a090909090953454c454354203120415320526573756c743b0d0a090909090953454c454354202a2046524f4d205175657374696f6e49645461626c652057484552452049464e554c4c2846696c65506174682c2027272920213d2027273b0d0a090909090953454c454354202a2046524f4d204f7074696f6e49645461626c652057484552452049464e554c4c2846696c65506174682c2027272920213d2027273b0d0a09090909454e443b0d0a090909454e442049463b0d0a09090944454c455445207465746573742046524f4d20746574657374205748455245204964203d20505f5465737449643b0d0a09090953454c454354203120415320526573756c743b0d0a090909434f4d4d49543b0d0a0d0a09090944524f502054454d504f52415259205441424c4520494620455849535453205175657374696f6e49645461626c653b0d0a09090944524f502054454d504f52415259205441424c4520494620455849535453204f7074696f6e49645461626c653b0d0a0909454e443b0d0a09454e442049463b0d0a454e44),
('testdb', 'spDeleteUser', 'PROCEDURE', 'spDeleteUser', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5573657249646020494e54, '', 0x424547494e0d0a202020204445434c41524520726f6c65696420494e543b0d0a202020200d0a2020202053455420726f6c656964203d202853454c45435420726f6c657479706569642046524f4d207475736572205748455245206964203d20505f557365724964293b0d0a202020205354415254205452414e53414354494f4e3b0d0a2020202020202020494620726f6c656964203d2031205448454e0d0a20202020202020202020202044454c4554452074757365722c207473747564656e742c207461737369676e62617463680d0a20202020202020202020202046524f4d2074757365720d0a2020202020202020202020204c454654204a4f494e207473747564656e74204f4e2074757365722e6964203d207473747564656e742e5573657269640d0a2020202020202020202020204c454654204a4f494e207461737369676e6261746368204f4e207473747564656e742e6964203d207461737369676e62617463682e73747564656e7469640d0a20202020202020202020202057484552452074757365722e6964203d20505f5573657249643b0d0a2020202020202020454c5345494620726f6c656964203d2032205448454e0d0a20202020202020202020202044454c4554452074757365722c2074696e737469747574652c2074746561636865722c207462617463680d0a20202020202020202020202046524f4d2074757365720d0a2020202020202020202020204c454654204a4f494e207474656163686572204f4e2074757365722e6964203d2074746561636865722e5573657269640d0a2020202020202020202020204c454654204a4f494e2074696e73746974757465204f4e2074696e737469747574652e6964203d2074746561636865722e496e7374697475746549640d0a2020202020202020202020204c454654204a4f494e20746261746368204f4e2074746561636865722e6964203d207462617463682e5465616368657249640d0a20202020202020202020202057484552452074757365722e6964203d20505f5573657249643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020434f4d4d49543b0d0a2020202053454c454354202231223b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:31:30', '2023-06-01 13:31:30', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520726f6c65696420494e543b0d0a202020200d0a2020202053455420726f6c656964203d202853454c45435420726f6c657479706569642046524f4d207475736572205748455245206964203d20505f557365724964293b0d0a202020205354415254205452414e53414354494f4e3b0d0a2020202020202020494620726f6c656964203d2031205448454e0d0a20202020202020202020202044454c4554452074757365722c207473747564656e742c207461737369676e62617463680d0a20202020202020202020202046524f4d2074757365720d0a2020202020202020202020204c454654204a4f494e207473747564656e74204f4e2074757365722e6964203d207473747564656e742e5573657269640d0a2020202020202020202020204c454654204a4f494e207461737369676e6261746368204f4e207473747564656e742e6964203d207461737369676e62617463682e73747564656e7469640d0a20202020202020202020202057484552452074757365722e6964203d20505f5573657249643b0d0a2020202020202020454c5345494620726f6c656964203d2032205448454e0d0a20202020202020202020202044454c4554452074757365722c2074696e737469747574652c2074746561636865722c207462617463680d0a20202020202020202020202046524f4d2074757365720d0a2020202020202020202020204c454654204a4f494e207474656163686572204f4e2074757365722e6964203d2074746561636865722e5573657269640d0a2020202020202020202020204c454654204a4f494e2074696e73746974757465204f4e2074696e737469747574652e6964203d2074746561636865722e496e7374697475746549640d0a2020202020202020202020204c454654204a4f494e20746261746368204f4e2074746561636865722e6964203d207462617463682e5465616368657249640d0a20202020202020202020202057484552452074757365722e6964203d20505f5573657249643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020434f4d4d49543b0d0a2020202053454c454354202231223b0d0a454e44);
INSERT INTO `proc` (`db`, `name`, `type`, `specific_name`, `language`, `sql_data_access`, `is_deterministic`, `security_type`, `param_list`, `returns`, `body`, `definer`, `created`, `modified`, `sql_mode`, `comment`, `character_set_client`, `collation_connection`, `db_collation`, `body_utf8`) VALUES
('testdb', 'spGetAssignBatch', 'PROCEDURE', 'spGetAssignBatch', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f426174636849646020494e54, '', 0x424547494e0d0a2020202053454c4543540d0a20202020202020207473747564656e742e69642041532053747564656e7449642c0d0a202020202020202049464e554c4c2874757365722e4e616d652c2027272920415320557365724e616d650d0a2020202046524f4d0d0a20202020202020207461737369676e62617463680d0a20202020494e4e4552204a4f494e207473747564656e74204f4e207473747564656e742e6964203d207461737369676e62617463682e73747564656e7469640d0a20202020494e4e4552204a4f494e207475736572204f4e2074757365722e6964203d207473747564656e742e5573657249640d0a2020202057484552450d0a20202020202020207461737369676e62617463682e42617463684964203d20505f4261746368496420414e440d0a20202020202020207461737369676e62617463682e5374617475734964203d2031313b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:31:30', '2023-06-01 13:31:30', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a2020202053454c4543540d0a20202020202020207473747564656e742e69642041532053747564656e7449642c0d0a202020202020202049464e554c4c2874757365722e4e616d652c2027272920415320557365724e616d650d0a2020202046524f4d0d0a20202020202020207461737369676e62617463680d0a20202020494e4e4552204a4f494e207473747564656e74204f4e207473747564656e742e6964203d207461737369676e62617463682e73747564656e7469640d0a20202020494e4e4552204a4f494e207475736572204f4e2074757365722e6964203d207473747564656e742e5573657249640d0a2020202057484552450d0a20202020202020207461737369676e62617463682e42617463684964203d20505f4261746368496420414e440d0a20202020202020207461737369676e62617463682e5374617475734964203d2031313b0d0a454e44),
('testdb', 'spGetAssignLinkList', 'PROCEDURE', 'spGetAssignLinkList', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f426174636849646020494e542c20494e2060505f5465616368657249646020494e542c20494e2060505f466f6c6465724e616d656020564152434841522835303029, '', 0x424547494e0d0a094445434c41524520505f436f6e74656e7450617468205641524348415228353030293b0d0a0949462028505f466f6c6465726e616d65204953204e554c4c29205448454e0d0a090953455420505f436f6e74656e7450617468203d202853454c45435420636f6e74656e74706174682046524f4d207474656163686572636f6e74656e7420574845524520696420494e202853454c4543542044495354494e43542874656163686572636f6e74656e744964292046524f4d207474656163686572636f6e74656e7461737369676e2057484552452042617463686964203d20505f4261746368496429293b0d0a09454c53450d0a090953455420505f436f6e74656e7450617468203d202853454c454354205245504c41434528434f4e43415428636f6e74656e74706174682c20275c5c272c20505f466f6c6465724e616d652c20272527292c20275c5c272c20275f27292046524f4d207474656163686572636f6e74656e7420574845524520696420494e202853454c4543542044495354494e43542874656163686572636f6e74656e744964292046524f4d207474656163686572636f6e74656e7461737369676e2057484552452042617463686964203d20505f4261746368496429293b0a0a09454e442049463b0d0a0953454c4543540d0a090949642c0d0a0909436f6e74656e744c696e6b20415320506174682c0d0a0909436f6e74656e745469746c65204153205469746c652c0d0a0909437265617465644461746574696d652041532043726561746554696d650d0a0946524f4d0d0a09097474656163686572636f6e74656e740d0a0957484552450d0a090928436f6e74656e747061746820494e202853454c45435420505f436f6e74656e745061746829204f5220436f6e74656e7470617468204c494b45202853454c45435420505f436f6e74656e745061746829290d0a0909414e4420636f6e74656e746c696e6b204953204e4f54204e554c4c0d0a0909414e4420546561636865724964203d20505f5465616368657249643b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:33:32', '2023-06-01 13:33:32', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a094445434c41524520505f436f6e74656e7450617468205641524348415228353030293b0d0a0949462028505f466f6c6465726e616d65204953204e554c4c29205448454e0d0a090953455420505f436f6e74656e7450617468203d202853454c45435420636f6e74656e74706174682046524f4d207474656163686572636f6e74656e7420574845524520696420494e202853454c4543542044495354494e43542874656163686572636f6e74656e744964292046524f4d207474656163686572636f6e74656e7461737369676e2057484552452042617463686964203d20505f4261746368496429293b0d0a09454c53450d0a090953455420505f436f6e74656e7450617468203d202853454c454354205245504c41434528434f4e43415428636f6e74656e74706174682c20275c272c20505f466f6c6465724e616d652c20272527292c20275c272c20275f27292046524f4d207474656163686572636f6e74656e7420574845524520696420494e202853454c4543542044495354494e43542874656163686572636f6e74656e744964292046524f4d207474656163686572636f6e74656e7461737369676e2057484552452042617463686964203d20505f4261746368496429293b0a0a09454e442049463b0d0a0953454c4543540d0a090949642c0d0a0909436f6e74656e744c696e6b20415320506174682c0d0a0909436f6e74656e745469746c65204153205469746c652c0d0a0909437265617465644461746574696d652041532043726561746554696d650d0a0946524f4d0d0a09097474656163686572636f6e74656e740d0a0957484552450d0a090928436f6e74656e747061746820494e202853454c45435420505f436f6e74656e745061746829204f5220436f6e74656e7470617468204c494b45202853454c45435420505f436f6e74656e745061746829290d0a0909414e4420636f6e74656e746c696e6b204953204e4f54204e554c4c0d0a0909414e4420546561636865724964203d20505f5465616368657249643b0d0a454e44),
('testdb', 'spGetBankDetails', 'PROCEDURE', 'spGetBankDetails', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5465616368657249646020494e542c20494e2060505f4163636f756e7449646020494e54, '', 0x424547494e0d0a0953454c4543540d0a09094964204153204163636f756e7449642c0d0a09095465616368657249642c0d0a09094163636f756e74486f6c6465724e616d652c0d0a09094163636f756e744e756d6265722c0d0a090949465343436f64652c0d0a0909456d61696c49640d0a0946524f4d0d0a09097462616e6b6163636f756e7464657461696c0d0a0957484552450d0a090928546561636865724964203d20505f546561636865724964204f5220505f546561636865724964203d2030290d0a0909414e4420284964203d20505f4163636f756e744964204f5220505f4163636f756e744964203d2030293b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:33:32', '2023-06-01 13:33:32', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a0953454c4543540d0a09094964204153204163636f756e7449642c0d0a09095465616368657249642c0d0a09094163636f756e74486f6c6465724e616d652c0d0a09094163636f756e744e756d6265722c0d0a090949465343436f64652c0d0a0909456d61696c49640d0a0946524f4d0d0a09097462616e6b6163636f756e7464657461696c0d0a0957484552450d0a090928546561636865724964203d20505f546561636865724964204f5220505f546561636865724964203d2030290d0a0909414e4420284964203d20505f4163636f756e744964204f5220505f4163636f756e744964203d2030293b0d0a454e44),
('testdb', 'spGetBatch', 'PROCEDURE', 'spGetBatch', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f426174636849646020494e54283131292c20494e2060505f496e74697475746549646020494e54283131292c20494e2060505f5465616368657249646020494e54283131292c20494e2060505f53747564656e7449646020494e542c20494e2060505f49734f7264657242796020494e54, '', 0x424547494e0d0a09494620505f53747564656e744964203d2030205448454e0a0a090953454c4543540d0a0909097462617463682e496420415320426174636849642c0d0a0909097462617463682e636f6465204153204261746368436f64652c0d0a0909097462617463682e7469746c65204153205469746c652c0d0a0909097462617463682e426174636844617465204153204261746368446174652c0d0a0909097462617463682e437265617465644461746554696d652c0d0a090909280d0a0909090953454c45435420434f554e542842617463684964290d0a0909090946524f4d207461737369676e62617463680d0a090909095748455245205374617475734964203d20313120414e442042617463684964203d207462617463682e49640d0a09090929204153204a6f696e656453747564656e74436f756e742c0d0a090909280d0a0909090953454c45435420434f554e542842617463684964290d0a0909090946524f4d207461737369676e62617463680d0a090909095748455245205374617475734964203d20313220414e442042617463684964203d207462617463682e49640d0a09090929204153204e6f744a6f696e656453747564656e74436f756e740d0a090946524f4d0d0a0909097462617463680d0a0909094c454654204a4f494e207474656163686572204f4e2074746561636865722e4964203d207462617463682e5465616368657249640d0a0909094c454654204a4f494e207461737369676e6261746368204f4e207461737369676e62617463682e42617463684964203d207462617463682e49640d0a090957484552450d0a090909287462617463682e546561636865724964203d20505f546561636865724964290d0a090909414e44202874746561636865722e496e737469747574654964203d20505f496e7469747574654964290d0a090909414e4420287462617463682e4964203d20505f42617463684964204f5220505f42617463684964203d2030290d0a090947524f5550204259207462617463682e49640d0a09094f524445522042590d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2030205448454e207462617463682e69640d0a090909095748454e20505f49734f726465724279203d2031205448454e207462617463682e7469746c650d0a090909454e44204153432c0d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2032205448454e207462617463682e437265617465644461746554696d650d0a090909454e4420444553433b0d0a09454c53450d0a090953454c4543540d0a0909097462617463682e496420415320426174636849642c0d0a0909097462617463682e636f6465204153204261746368436f64652c0d0a0909097462617463682e7469746c65204153205469746c652c0d0a0909097462617463682e426174636864617465204153204261746368646174652c0d0a0909097462617463682e437265617465644461746554696d652c0d0a090909280d0a0909090953454c45435420434f554e542842617463684964290d0a0909090946524f4d207461737369676e62617463680d0a090909095748455245205374617475734964203d20313120414e442042617463684964203d207462617463682e49640d0a09090929204153204a6f696e656453747564656e74436f756e740d0a090946524f4d0d0a0909097462617463680d0a0909094c454654204a4f494e207461737369676e6261746368204f4e207461737369676e62617463682e42617463684964203d207462617463682e49640d0a0909094c454654204a4f494e207473747564656e74204f4e207473747564656e742e4964203d207461737369676e62617463682e53747564656e7449640d0a090957484552450d0a090909287461737369676e62617463682e53747564656e744964203d20505f53747564656e744964290d0a090909414e4420287473747564656e742e496e737469747574654964203d20505f496e7469747574654964290d0a090909414e4420287462617463682e4964203d20505f42617463684964204f5220505f42617463684964203d2030290d0a090909414e44207461737369676e62617463682e5374617475734964203d2031310d0a090947524f5550204259207462617463682e49640d0a09094f524445522042590d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2030205448454e207462617463682e69640d0a090909095748454e20505f49734f726465724279203d2031205448454e207462617463682e7469746c650d0a090909454e44204153432c0d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2032205448454e207462617463682e437265617465644461746554696d650d0a090909454e4420444553433b0d0a09454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:35:19', '2023-06-01 13:35:19', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a09494620505f53747564656e744964203d2030205448454e0a0a090953454c4543540d0a0909097462617463682e496420415320426174636849642c0d0a0909097462617463682e636f6465204153204261746368436f64652c0d0a0909097462617463682e7469746c65204153205469746c652c0d0a0909097462617463682e426174636844617465204153204261746368446174652c0d0a0909097462617463682e437265617465644461746554696d652c0d0a090909280d0a0909090953454c45435420434f554e542842617463684964290d0a0909090946524f4d207461737369676e62617463680d0a090909095748455245205374617475734964203d20313120414e442042617463684964203d207462617463682e49640d0a09090929204153204a6f696e656453747564656e74436f756e742c0d0a090909280d0a0909090953454c45435420434f554e542842617463684964290d0a0909090946524f4d207461737369676e62617463680d0a090909095748455245205374617475734964203d20313220414e442042617463684964203d207462617463682e49640d0a09090929204153204e6f744a6f696e656453747564656e74436f756e740d0a090946524f4d0d0a0909097462617463680d0a0909094c454654204a4f494e207474656163686572204f4e2074746561636865722e4964203d207462617463682e5465616368657249640d0a0909094c454654204a4f494e207461737369676e6261746368204f4e207461737369676e62617463682e42617463684964203d207462617463682e49640d0a090957484552450d0a090909287462617463682e546561636865724964203d20505f546561636865724964290d0a090909414e44202874746561636865722e496e737469747574654964203d20505f496e7469747574654964290d0a090909414e4420287462617463682e4964203d20505f42617463684964204f5220505f42617463684964203d2030290d0a090947524f5550204259207462617463682e49640d0a09094f524445522042590d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2030205448454e207462617463682e69640d0a090909095748454e20505f49734f726465724279203d2031205448454e207462617463682e7469746c650d0a090909454e44204153432c0d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2032205448454e207462617463682e437265617465644461746554696d650d0a090909454e4420444553433b0d0a09454c53450d0a090953454c4543540d0a0909097462617463682e496420415320426174636849642c0d0a0909097462617463682e636f6465204153204261746368436f64652c0d0a0909097462617463682e7469746c65204153205469746c652c0d0a0909097462617463682e426174636864617465204153204261746368646174652c0d0a0909097462617463682e437265617465644461746554696d652c0d0a090909280d0a0909090953454c45435420434f554e542842617463684964290d0a0909090946524f4d207461737369676e62617463680d0a090909095748455245205374617475734964203d20313120414e442042617463684964203d207462617463682e49640d0a09090929204153204a6f696e656453747564656e74436f756e740d0a090946524f4d0d0a0909097462617463680d0a0909094c454654204a4f494e207461737369676e6261746368204f4e207461737369676e62617463682e42617463684964203d207462617463682e49640d0a0909094c454654204a4f494e207473747564656e74204f4e207473747564656e742e4964203d207461737369676e62617463682e53747564656e7449640d0a090957484552450d0a090909287461737369676e62617463682e53747564656e744964203d20505f53747564656e744964290d0a090909414e4420287473747564656e742e496e737469747574654964203d20505f496e7469747574654964290d0a090909414e4420287462617463682e4964203d20505f42617463684964204f5220505f42617463684964203d2030290d0a090909414e44207461737369676e62617463682e5374617475734964203d2031310d0a090947524f5550204259207462617463682e49640d0a09094f524445522042590d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2030205448454e207462617463682e69640d0a090909095748454e20505f49734f726465724279203d2031205448454e207462617463682e7469746c650d0a090909454e44204153432c0d0a090909434153450d0a090909095748454e20505f49734f726465724279203d2032205448454e207462617463682e437265617465644461746554696d650d0a090909454e4420444553433b0d0a09454e442049463b0d0a454e44),
('testdb', 'spGetBatchRequest', 'PROCEDURE', 'spGetBatchRequest', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f496e7374697475746549646020494e542c20494e2060505f426174636849646020494e542c20494e2060505f5465616368657249646020494e54, '', 0x424547494e0d0a0953454c4543540d0a09097473747564656e742e49642041532053747564656e7449642c0d0a090949464e554c4c2874757365722e4e616d652c2027272920415320557365724e616d652c0d0a09097462617463682e496420415320426174636849642c0d0a09097462617463682e5469746c652041532042617463684e616d652c0d0a0909747374617475736d61737465722e49642041532053746174757349642c0d0a0909747374617475736d61737465722e5469746c65204153205374617475735469746c650d0a0946524f4d0d0a09097473747564656e740d0a0909494e4e4552204a4f494e207461737369676e6261746368204f4e207461737369676e62617463682e53747564656e744964203d207473747564656e742e49640d0a0909494e4e4552204a4f494e20746261746368204f4e207462617463682e4964203d207461737369676e62617463682e426174636849640d0a0909494e4e4552204a4f494e20747374617475736d6173746572204f4e20747374617475736d61737465722e4964203d207461737369676e62617463682e53746174757349640d0a0909494e4e4552204a4f494e207474656163686572204f4e2074746561636865722e4964203d207462617463682e5465616368657249640a0a0909494e4e4552204a4f494e207475736572204f4e2074757365722e4964203d207473747564656e742e5573657249640d0a0957484552450d0a090974746561636865722e4964203d20505f5465616368657249640d0a0909414e44207462617463682e4964203d20505f426174636849640d0a0909414e442074746561636865722e496e737469747574654964203d20505f496e7374697475746549640d0a0909414e44207461737369676e62617463682e5374617475734964203d2031323b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:37:08', '2023-06-01 13:37:08', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a0953454c4543540d0a09097473747564656e742e49642041532053747564656e7449642c0d0a090949464e554c4c2874757365722e4e616d652c2027272920415320557365724e616d652c0d0a09097462617463682e496420415320426174636849642c0d0a09097462617463682e5469746c652041532042617463684e616d652c0d0a0909747374617475736d61737465722e49642041532053746174757349642c0d0a0909747374617475736d61737465722e5469746c65204153205374617475735469746c650d0a0946524f4d0d0a09097473747564656e740d0a0909494e4e4552204a4f494e207461737369676e6261746368204f4e207461737369676e62617463682e53747564656e744964203d207473747564656e742e49640d0a0909494e4e4552204a4f494e20746261746368204f4e207462617463682e4964203d207461737369676e62617463682e426174636849640d0a0909494e4e4552204a4f494e20747374617475736d6173746572204f4e20747374617475736d61737465722e4964203d207461737369676e62617463682e53746174757349640d0a0909494e4e4552204a4f494e207474656163686572204f4e2074746561636865722e4964203d207462617463682e5465616368657249640a0a0909494e4e4552204a4f494e207475736572204f4e2074757365722e4964203d207473747564656e742e5573657249640d0a0957484552450d0a090974746561636865722e4964203d20505f5465616368657249640d0a0909414e44207462617463682e4964203d20505f426174636849640d0a0909414e442074746561636865722e496e737469747574654964203d20505f496e7374697475746549640d0a0909414e44207461737369676e62617463682e5374617475734964203d2031323b0d0a454e44),
('testdb', 'spGetCategory', 'PROCEDURE', 'spGetCategory', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', '', '', 0x424547494e0d0a0953454c454354202a2046524f4d207463617465676f72794d61737465723b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:38:16', '2023-06-01 13:38:16', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a0953454c454354202a2046524f4d207463617465676f72794d61737465723b0d0a454e44),
('testdb', 'spGetChapter', 'PROCEDURE', 'spGetChapter', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5375626a65637449646020494e54, '', 0x424547494e0d0a094445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a090953454c454354202d313b0d0a20202020202020200d0a0953454c454354200d0a09094964204153204368617074657249642c0d0a09095469746c6520415320436861707465724e616d652c0d0a0909436f64652041532043686170746572436f64650d0a0946524f4d200d0a090974636861707465726d61737465720d0a0957484552450d0a0909285375626a6563744964203d20505f5375626a6563744964204f5220505f5375626a6563744964203d2030293b0d0a454e44, 'testdb@webserver1', '2023-06-01 13:38:16', '2023-06-01 13:38:16', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a094445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a090953454c454354202d313b0d0a20202020202020200d0a0953454c454354200d0a09094964204153204368617074657249642c0d0a09095469746c6520415320436861707465724e616d652c0d0a0909436f64652041532043686170746572436f64650d0a0946524f4d200d0a090974636861707465726d61737465720d0a0957484552450d0a0909285375626a6563744964203d20505f5375626a6563744964204f5220505f5375626a6563744964203d2030293b0d0a454e44),
('testdb', 'spGetChat', 'PROCEDURE', 'spGetChat', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f526f6c655479706549646020494e542c20494e2060505f5573657249646020494e542c20494e2060505f536f7572636549646020494e54, '', 0x[encoded data, 9400 characters], 'testdb@webserver1', '2023-06-01 13:41:45', '2023-06-01 13:41:45', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x[encoded data, 9400 characters]),
('testdb', 'spGetChatGroupList', 'PROCEDURE', 'spGetChatGroupList', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f526f6c655479706549646020494e542c20494e2060505f496e7374697475746549646020494e54, '', 0x424547494e0d0a20202020494620455849535453202853454c45435420312046524f4d2074696e737469747574652057484552452074696e737469747574652e4964203d20505f496e73746974757465496429205448454e0d0a202020202020202053454c454354200d0a202020202020202020202020746368617467726f75706d61737465722e4964204153204368617447726f757049642c0d0a202020202020202020202020746368617467726f75706d61737465722e5469746c65204153204368617447726f75704e616d652c0d0a20202020202020202020202049464e554c4c2874636861742e437265617465644461746554696d652c20272729204153204c6173744d65737361676554696d652c0d0a2020202020202020202020204946284368617444657461696c204953204e554c4c2c0d0a20202020202020202020202020202020494628535452434d5028535542535452494e475f494e44455828436f6e74656e74506174682c20272e272c202d31292c20276a706727204f522027706e6727204f5220276a70656727292c2027496d616765272c200d0a20202020202020202020202020202020494628535452434d5028535542535452494e475f494e44455828436f6e74656e74506174682c20272e272c202d31292c20274d503427292c2027566964656f272c0d0a20202020202020202020202020202020494628535452434d5028535542535452494e475f494e44455828436f6e74656e74506174682c20272e272c202d31292c20274d503327292c2027417564696f272c2027446f63756d656e74272929292c204368617444657461696c29204153204d657373616765547970650d0a202020202020202046524f4d200d0a202020202020202020202020746368617467726f75706d6173746572200d0a20202020202020204c454654204a4f494e207463686174204f4e2074636861742e4368617447726f75704964203d20746368617467726f75706d61737465722e49640d0a20202020202020204c454654204a4f494e20746261746368204f4e20746368617467726f75706d61737465722e42617463684964203d207462617463682e49640d0a20202020202020204c454654204a4f494e207474656163686572204f4e2074746561636865722e4964203d207462617463682e5465616368657249640d0a20202020202020205748455245200d0a20202020202020202020202074746561636865722e496e737469747574654964203d20505f496e7374697475746549640d0a202020202020202020202020414e4420746368617467726f75706d61737465722e437265617465644461746554696d65203c3d204e4f5728290d0a202020202020202020202020414e44202874636861742e437265617465644461746554696d65203d202853454c454354204d41582874636861742e437265617465644461746554696d65292046524f4d207463686174205748455245204368617447726f75704964203d20746368617467726f75706d61737465722e6964290d0a202020202020202020202020202020204f522049464e554c4c2874636861742e437265617465644461746554696d652c20272729203d202727293b0d0a20202020454c53450d0a202020202020202053454c454354202d31204153204368617447726f757049643b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 14:01:36', '2023-06-01 14:01:36', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a20202020494620455849535453202853454c45435420312046524f4d2074696e737469747574652057484552452074696e737469747574652e4964203d20505f496e73746974757465496429205448454e0d0a202020202020202053454c454354200d0a202020202020202020202020746368617467726f75706d61737465722e4964204153204368617447726f757049642c0d0a202020202020202020202020746368617467726f75706d61737465722e5469746c65204153204368617447726f75704e616d652c0d0a20202020202020202020202049464e554c4c2874636861742e437265617465644461746554696d652c20272729204153204c6173744d65737361676554696d652c0d0a2020202020202020202020204946284368617444657461696c204953204e554c4c2c0d0a20202020202020202020202020202020494628535452434d5028535542535452494e475f494e44455828436f6e74656e74506174682c20272e272c202d31292c20276a706727204f522027706e6727204f5220276a70656727292c2027496d616765272c200d0a20202020202020202020202020202020494628535452434d5028535542535452494e475f494e44455828436f6e74656e74506174682c20272e272c202d31292c20274d503427292c2027566964656f272c0d0a20202020202020202020202020202020494628535452434d5028535542535452494e475f494e44455828436f6e74656e74506174682c20272e272c202d31292c20274d503327292c2027417564696f272c2027446f63756d656e74272929292c204368617444657461696c29204153204d657373616765547970650d0a202020202020202046524f4d200d0a202020202020202020202020746368617467726f75706d6173746572200d0a20202020202020204c454654204a4f494e207463686174204f4e2074636861742e4368617447726f75704964203d20746368617467726f75706d61737465722e49640d0a20202020202020204c454654204a4f494e20746261746368204f4e20746368617467726f75706d61737465722e42617463684964203d207462617463682e49640d0a20202020202020204c454654204a4f494e207474656163686572204f4e2074746561636865722e4964203d207462617463682e5465616368657249640d0a20202020202020205748455245200d0a20202020202020202020202074746561636865722e496e737469747574654964203d20505f496e7374697475746549640d0a202020202020202020202020414e4420746368617467726f75706d61737465722e437265617465644461746554696d65203c3d204e4f5728290d0a202020202020202020202020414e44202874636861742e437265617465644461746554696d65203d202853454c454354204d41582874636861742e437265617465644461746554696d65292046524f4d207463686174205748455245204368617447726f75704964203d20746368617467726f75706d61737465722e6964290d0a202020202020202020202020202020204f522049464e554c4c2874636861742e437265617465644461746554696d652c20272729203d202727293b0d0a20202020454c53450d0a202020202020202053454c454354202d31204153204368617447726f757049643b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spGetCode', 'PROCEDURE', 'spGetCode', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f5461626c654e616d6560205641524348415228343029, '', 0x424547494e0d0a2020202053455420406765744944203d20434f4e434154282753454c45435420636f64652046524f4d20272c20505f5461626c654e616d65293b0d0a20202020505245504152452073746d742046524f4d204067657449443b0d0a20202020455845435554452073746d743b0d0a202020204445414c4c4f4341544520505245504152452073746d743b0d0a454e44, 'testdb@webserver1', '2023-06-01 14:02:05', '2023-06-01 14:02:05', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a2020202053455420406765744944203d20434f4e434154282753454c45435420636f64652046524f4d20272c20505f5461626c654e616d65293b0d0a20202020505245504152452073746d742046524f4d204067657449443b0d0a20202020455845435554452073746d743b0d0a202020204445414c4c4f4341544520505245504152452073746d743b0d0a454e44),
('testdb', 'spGetComment', 'PROCEDURE', 'spGetComment', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x494e2060505f41737369676e436f6e74656e7449646020494e542c20494e2060505f436f6d6d656e7449646020494e54, '', 0x424547494e0d0a2020202053454c454354200d0a20202020202020205573657249642c200d0a20202020202020207473747564796d6174657269616c636f6d6d656e742e496420415320436f6d6d656e7449642c200d0a202020202020202074757365722e6e616d6520415320557365724e616d652c0d0a20202020202020202853454c45435420434f554e542831292046524f4d207473747564796d6174657269616c636f6d6d656e742074732057484552452074732e5265666572656e6365436f6d6d656e744964203d207473747564796d6174657269616c636f6d6d656e742e696429204153204e756d6265726f66436f6d6d656e742c0d0a2020202020202020436f6d6d656e7444657461696c20415320436f6d6d656e744d6573736167652c0d0a20202020202020207473747564796d6174657269616c636f6d6d656e742e437265617465644461746554696d650d0a2020202046524f4d200d0a20202020202020207473747564796d6174657269616c636f6d6d656e740d0a202020204c454654204a4f494e200d0a20202020202020207475736572204f4e20557365724964203d2074757365722e49640d0a202020205748455245200d0a2020202020202020287473747564796d6174657269616c636f6d6d656e742e4964203d20505f436f6d6d656e744964204f52205265666572656e6365436f6d6d656e744964203d20505f436f6d6d656e74496429200d0a20202020202020204f522028505f436f6d6d656e744964203d203020414e44205265666572656e6365436f6d6d656e744964203d2030290d0a2020202020202020414e442041737369676e436f6e74656e744964203d20505f41737369676e436f6e74656e7449640d0a2020202047524f5550204259200d0a20202020202020207473747564796d6174657269616c636f6d6d656e742e49643b0d0a454e44, 'testdb@webserver1', '2023-06-01 14:02:51', '2023-06-01 14:02:51', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a2020202053454c454354200d0a20202020202020205573657249642c200d0a20202020202020207473747564796d6174657269616c636f6d6d656e742e496420415320436f6d6d656e7449642c200d0a202020202020202074757365722e6e616d6520415320557365724e616d652c0d0a20202020202020202853454c45435420434f554e542831292046524f4d207473747564796d6174657269616c636f6d6d656e742074732057484552452074732e5265666572656e6365436f6d6d656e744964203d207473747564796d6174657269616c636f6d6d656e742e696429204153204e756d6265726f66436f6d6d656e742c0d0a2020202020202020436f6d6d656e7444657461696c20415320436f6d6d656e744d6573736167652c0d0a20202020202020207473747564796d6174657269616c636f6d6d656e742e437265617465644461746554696d650d0a2020202046524f4d200d0a20202020202020207473747564796d6174657269616c636f6d6d656e740d0a202020204c454654204a4f494e200d0a20202020202020207475736572204f4e20557365724964203d2074757365722e49640d0a202020205748455245200d0a2020202020202020287473747564796d6174657269616c636f6d6d656e742e4964203d20505f436f6d6d656e744964204f52205265666572656e6365436f6d6d656e744964203d20505f436f6d6d656e74496429200d0a20202020202020204f522028505f436f6d6d656e744964203d203020414e44205265666572656e6365436f6d6d656e744964203d2030290d0a2020202020202020414e442041737369676e436f6e74656e744964203d20505f41737369676e436f6e74656e7449640d0a2020202047524f5550204259200d0a20202020202020207473747564796d6174657269616c636f6d6d656e742e49643b0d0a454e44),
('testdb', 'spGetconfigurationmaster', 'PROCEDURE', 'spGetconfigurationmaster', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', '', '', 0x424547494e0d0a2020202053454c4543540d0a202020202020202049642c0d0a20202020202020205469746c652c0d0a20202020202020204974656d4b65792c0d0a20202020202020204974656d56616c75650d0a2020202046524f4d0d0a202020202020202074636f6e66696775726174696f6e6d61737465723b0d0a454e44, 'testdb@webserver1', '2023-06-01 14:02:51', '2023-06-01 14:02:51', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a2020202053454c4543540d0a202020202020202049642c0d0a20202020202020205469746c652c0d0a20202020202020204974656d4b65792c0d0a20202020202020204974656d56616c75650d0a2020202046524f4d0d0a202020202020202074636f6e66696775726174696f6e6d61737465723b0d0a454e44);
INSERT INTO `proc` (`db`, `name`, `type`, `specific_name`, `language`, `sql_data_access`, `is_deterministic`, `security_type`, `param_list`, `returns`, `body`, `definer`, `created`, `modified`, `sql_mode`, `comment`, `character_set_client`, `collation_connection`, `db_collation`, `body_utf8`) VALUES
('testdb', 'spGetContentList', 'PROCEDURE', 'spGetContentList', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x0d0a20202020494e2060505f5465616368657249646020494e542c200d0a20202020494e2060505f41737369676e436f6e74656e746020494e542c200d0a20202020494e2060505f466f6c6465724e616d6560205641524348415228353030292c200d0a20202020494e2060505f49734f7264657242796020494e542c200d0a20202020494e2060505f436f6e74656e745479706549646020494e540d0a, '', 0x[encoded data, 5414 characters], 'testdb@webserver1', '2023-06-01 14:06:00', '2023-06-01 14:06:00', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x[encoded data, 5410 characters]),
('testdb', 'spGetContentTitle', 'PROCEDURE', 'spGetContentTitle', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x0d0a20202020494e2060505f436f6e74656e7449646020494e542c0d0a20202020494e2060505f436f6e74656e745061746860205641524348415228353030290d0a, '', 0x424547494e0d0a20202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e74205748455245206964203d20505f436f6e74656e74496420414e4420436f6e74656e746c696e6b204953204e554c4c29205448454e0d0a202020202020202053454c45435420434f4e43415428436f6e74656e74506174682c20275c5c272c20436f6e74656e745469746c652920415320436f6e74656e74506174680d0a202020202020202046524f4d207474656163686572636f6e74656e740d0a20202020202020205748455245206964203d20505f436f6e74656e7449643b0d0a20202020454c53450d0a20202020202020205354415254205452414e53414354494f4e3b0d0a2020202020202020494e5345525420494e544f207474656163686572636f6e74656e742028436f6e74656e74506174682c20436f6e74656e745469746c652c20436f6e74656e744c696e6b2c205465616368657249642c20437265617465644461746554696d65290d0a202020202020202053454c45435420505f436f6e74656e74506174682c20436f6e74656e745469746c652c20436f6e74656e744c696e6b2c205465616368657249642c20437265617465644461746554696d650d0a202020202020202046524f4d207474656163686572636f6e74656e740d0a20202020202020205748455245206964203d20505f436f6e74656e7449643b0d0a202020202020202053454c45435420436f6e74656e745061746820415320436f6e74656e74506174682c20696420415320436f6e74656e7449642046524f4d207474656163686572636f6e74656e74205748455245206964203d204c4153545f494e534552545f494428293b0d0a2020202020202020434f4d4d49543b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 14:12:34', '2023-06-01 14:12:34', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a20202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e74205748455245206964203d20505f436f6e74656e74496420414e4420436f6e74656e746c696e6b204953204e554c4c29205448454e0d0a202020202020202053454c45435420434f4e43415428436f6e74656e74506174682c20275c272c20436f6e74656e745469746c652920415320436f6e74656e74506174680d0a202020202020202046524f4d207474656163686572636f6e74656e740d0a20202020202020205748455245206964203d20505f436f6e74656e7449643b0d0a20202020454c53450d0a20202020202020205354415254205452414e53414354494f4e3b0d0a2020202020202020494e5345525420494e544f207474656163686572636f6e74656e742028436f6e74656e74506174682c20436f6e74656e745469746c652c20436f6e74656e744c696e6b2c205465616368657249642c20437265617465644461746554696d65290d0a202020202020202053454c45435420505f436f6e74656e74506174682c20436f6e74656e745469746c652c20436f6e74656e744c696e6b2c205465616368657249642c20437265617465644461746554696d650d0a202020202020202046524f4d207474656163686572636f6e74656e740d0a20202020202020205748455245206964203d20505f436f6e74656e7449643b0d0a202020202020202053454c45435420436f6e74656e745061746820415320436f6e74656e74506174682c20696420415320436f6e74656e7449642046524f4d207474656163686572636f6e74656e74205748455245206964203d204c4153545f494e534552545f494428293b0d0a2020202020202020434f4d4d49543b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spGetContentPath', 'PROCEDURE', 'spGetContentPath', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x0d0a20202020494e2060505f436f6e74656e7449646020494e542c200d0a20202020494e2060505f41737369676e436f6e74656e746020494e540d0a, '', 0x424547494e0d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a2020202020202020524f4c4c4241434b3b0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200d0a20202020494620505f41737369676e436f6e74656e74203d2030205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e74205748455245204964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e43415428436f6e74656e74506174682c20275c5c272c2069642c20275c5c272c20436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e740d0a2020202020202020202020205748455245206964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454c5345494620505f41737369676e436f6e74656e74203d2031205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e7461737369676e205748455245204964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e434154287474656163686572636f6e74656e7461737369676e2e436f6e74656e74506174682c20275c5c272c207474656163686572636f6e74656e7461737369676e2e69642c20275c5c272c207474656163686572636f6e74656e7461737369676e2e436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e740d0a202020202020202020202020494e4e4552204a4f494e207474656163686572636f6e74656e7461737369676e204f4e207474656163686572636f6e74656e7461737369676e2e54656163686572436f6e74656e744964203d207474656163686572636f6e74656e742e69640d0a2020202020202020202020205748455245207474656163686572636f6e74656e7461737369676e2e6964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454c5345494620505f41737369676e436f6e74656e74203d2032205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e7461737369676e2057484552452054656163686572436f6e74656e744964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e43415428436f6e74656e74506174682c20275c5c272c2069642c20275c5c272c20436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e7461737369676e0d0a20202020202020202020202057484552452054656163686572436f6e74656e744964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454c5345494620505f41737369676e436f6e74656e74203d2033205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e7461737369676e20494e4e4552204a4f494e207474656163686572636f6e74656e74204f4e207474656163686572636f6e74656e742e4964203d207474656163686572636f6e74656e7461737369676e2e54656163686572436f6e74656e744964205748455245207474656163686572636f6e74656e7461737369676e2e4964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e434154287474656163686572636f6e74656e742e436f6e74656e74506174682c20275c5c272c207474656163686572636f6e74656e742e69642c20275c5c272c207474656163686572636f6e74656e742e436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020202020202020202020494e4e4552204a4f494e207474656163686572636f6e74656e74204f4e207474656163686572636f6e74656e742e4964203d207474656163686572636f6e74656e7461737369676e2e54656163686572436f6e74656e7449640d0a2020202020202020202020205748455245207474656163686572636f6e74656e7461737369676e2e4964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454e442049463b0d0a454e44, 'testdb@webserver1', '2023-06-01 14:12:19', '2023-06-01 14:12:19', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a202020204445434c41524520457869742048414e444c455220464f522053514c455843455054494f4e0d0a20202020424547494e0d0a2020202020202020524f4c4c4241434b3b0d0a202020202020202053454c454354202d313b0d0a20202020454e443b0d0a202020200d0a20202020494620505f41737369676e436f6e74656e74203d2030205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e74205748455245204964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e43415428436f6e74656e74506174682c20275c272c2069642c20275c272c20436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e740d0a2020202020202020202020205748455245206964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454c5345494620505f41737369676e436f6e74656e74203d2031205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e7461737369676e205748455245204964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e434154287474656163686572636f6e74656e7461737369676e2e436f6e74656e74506174682c20275c272c207474656163686572636f6e74656e7461737369676e2e69642c20275c272c207474656163686572636f6e74656e7461737369676e2e436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e740d0a202020202020202020202020494e4e4552204a4f494e207474656163686572636f6e74656e7461737369676e204f4e207474656163686572636f6e74656e7461737369676e2e54656163686572436f6e74656e744964203d207474656163686572636f6e74656e742e69640d0a2020202020202020202020205748455245207474656163686572636f6e74656e7461737369676e2e6964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454c5345494620505f41737369676e436f6e74656e74203d2032205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e7461737369676e2057484552452054656163686572436f6e74656e744964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e43415428436f6e74656e74506174682c20275c272c2069642c20275c272c20436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e7461737369676e0d0a20202020202020202020202057484552452054656163686572436f6e74656e744964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454c5345494620505f41737369676e436f6e74656e74203d2033205448454e0d0a2020202020202020494620455849535453202853454c45435420312046524f4d207474656163686572636f6e74656e7461737369676e20494e4e4552204a4f494e207474656163686572636f6e74656e74204f4e207474656163686572636f6e74656e742e4964203d207474656163686572636f6e74656e7461737369676e2e54656163686572436f6e74656e744964205748455245207474656163686572636f6e74656e7461737369676e2e4964203d20505f436f6e74656e74496429205448454e0d0a20202020202020202020202053454c45435420434f4e434154287474656163686572636f6e74656e742e436f6e74656e74506174682c20275c272c207474656163686572636f6e74656e742e69642c20275c272c207474656163686572636f6e74656e742e436f6e74656e745469746c652920415320436f6e74656e74506174680d0a20202020202020202020202046524f4d207474656163686572636f6e74656e7461737369676e0d0a202020202020202020202020494e4e4552204a4f494e207474656163686572636f6e74656e74204f4e207474656163686572636f6e74656e742e4964203d207474656163686572636f6e74656e7461737369676e2e54656163686572436f6e74656e7449640d0a2020202020202020202020205748455245207474656163686572636f6e74656e7461737369676e2e4964203d20505f436f6e74656e7449643b0d0a2020202020202020454c53450d0a20202020202020202020202053454c454354202d323b0d0a2020202020202020454e442049463b0d0a20202020454e442049463b0d0a454e44),
('testdb', 'spGetDoubtSession', 'PROCEDURE', 'spGetDoubtSession', 'SQL', 'CONTAINS_SQL', 'NO', 'DEFINER', 0x0d0a20202020494e2060505f54696d655461626c654964602056415243484152283435290d0a, '', 0x424547494e0d0a2020202053454c4543540d0a202020202020202049642041532054696d655461626c6549642c0d0a202020202020202043415354287474696d657461626c652e46726f6d54696d652041532043484152292041532046726f6d54696d652c0d0a202020202020202043415354287474696d657461626c652e546f54696d6520415320434841522920415320546f54696d652c0d0a202020202020202043415354287474696d657461626c652e46726f6d446174652041532043484152292041532046726f6d446174652c0d0a20202020202020205469746c652c0d0a20202020202020205375626a6563742c0d0a2020202020202020497353657373696f6e2c0d0a2020202020202020416e6f756e63656d656e744d6573736167652c0d0a202020202020202042617463684964200d0a2020202046524f4d0d0a20202020202020207474696d657461626c650d0a2020202057484552450d0a20202020202020202846494e445f494e5f5345542849642c20505f54696d655461626c65496429204f522049464e554c4c28505f54696d655461626c6549642c20272729203d202727204f5220505f54696d655461626c654964203d2022302229200d0a2020202020202020414e4420497353657373696f6e203d20313b0d0a20202020202020202d2d202846494e445f494e5f5345542854696d655461626c6549642c20505f54696d655461626c65496429293b0d0a454e44, 'testdb@webserver1', '2023-06-01 14:13:15', '2023-06-01 14:13:15', 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', '', 'utf8mb4', 'utf8mb4_unicode_ci', 'latin1_swedish_ci', 0x424547494e0d0a2020202053454c4543540d0a202020202020202049642041532054696d655461626c6549642c0d0a202020202020202043415354287474696d657461626c652e46726f6d54696d652041532043484152292041532046726f6d54696d652c0d0a202020202020202043415354287474696d657461626c652e546f54696d6520415320434841522920415320546f54696d652c0d0a202020202020202043415354287474696d657461626c652e46726f6d446174652041532043484152292041532046726f6d446174652c0d0a20202020202020205469746c652c0d0a20202020202020205375626a6563742c0d0a2020202020202020497353657373696f6e2c0d0a2020202020202020416e6f756e63656d656e744d6573736167652c0d0a202020202020202042617463684964200d0a2020202046524f4d0d0a20202020202020207474696d657461626c650d0a2020202057484552450d0a20202020202020202846494e445f494e5f5345542849642c20505f54696d655461626c65496429204f522049464e554c4c28505f54696d655461626c6549642c20272729203d202727204f5220505f54696d655461626c654964203d2022302229200d0a2020202020202020414e4420497353657373696f6e203d20313b0d0a20202020202020202d2d202846494e445f494e5f5345542854696d655461626c6549642c20505f54696d655461626c65496429293b0d0a454e44);

-- --------------------------------------------------------

--
-- Table structure for table `procs_priv`
--

CREATE TABLE IF NOT EXISTS `procs_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';

-- --------------------------------------------------------

--
-- Table structure for table `proxies_priv`
--

CREATE TABLE IF NOT EXISTS `proxies_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` (`Host`, `User`, `Proxied_host`, `Proxied_user`, `With_grant`, `Grantor`, `Timestamp`) VALUES
('localhost', 'root', '', '', 1, '', '2015-03-25 16:52:14');

-- --------------------------------------------------------

--
-- Table structure for table `servers`
--

CREATE TABLE IF NOT EXISTS `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(64) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

-- --------------------------------------------------------

--
-- Table structure for table `slave_master_info`
--

CREATE TABLE IF NOT EXISTS `slave_master_info` (
  `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
  `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',
  `Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The host name of the master.',
  `User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
  `User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
  `Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
  `Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
  `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
  `Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
  `Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
  `Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
  `Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
  `Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
  `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
  `Heartbeat` float NOT NULL,
  `Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
  `Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
  `Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
  `Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
  `Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
  `Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
  `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';

-- --------------------------------------------------------

--
-- Table structure for table `slave_relay_log_info`
--

CREATE TABLE IF NOT EXISTS `slave_relay_log_info` (
  `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',
  `Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
  `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',
  `Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
  `Number_of_workers` int(10) unsigned NOT NULL,
  `Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';

-- --------------------------------------------------------

--
-- Table structure for table `slave_worker_info`
--

CREATE TABLE IF NOT EXISTS `slave_worker_info` (
  `Id` int(10) unsigned NOT NULL,
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Relay_log_pos` bigint(20) unsigned NOT NULL,
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Master_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,
  `Checkpoint_seqno` int(10) unsigned NOT NULL,
  `Checkpoint_group_size` int(10) unsigned NOT NULL,
  `Checkpoint_group_bitmap` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';

-- --------------------------------------------------------

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host` mediumtext NOT NULL,
  `query_time` time NOT NULL,
  `lock_time` time NOT NULL,
  `rows_sent` int(11) NOT NULL,
  `rows_examined` int(11) NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int(11) NOT NULL,
  `insert_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `sql_text` mediumtext NOT NULL,
  `thread_id` bigint(21) unsigned NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';

-- --------------------------------------------------------

--
-- Table structure for table `tables_priv`
--

CREATE TABLE IF NOT EXISTS `tables_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--

INSERT INTO `tables_priv` (`Host`, `Db`, `User`, `Table_name`, `Grantor`, `Timestamp`, `Table_priv`, `Column_priv`) VALUES
('webserver1', 'mysql', 'pma', 'user', 'root@172.16.60.48', '0000-00-00 00:00:00', '', 'Select'),
('webserver1', 'mysql', 'pma', 'db', 'root@172.16.60.48', '0000-00-00 00:00:00', 'Select', '');

-- --------------------------------------------------------

--
-- Table structure for table `time_zone`
--

CREATE TABLE IF NOT EXISTS `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones';

-- --------------------------------------------------------

--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE IF NOT EXISTS `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL,
  `Correction` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones';

-- --------------------------------------------------------

--
-- Table structure for table `time_zone_name`
--

CREATE TABLE IF NOT EXISTS `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names';

-- --------------------------------------------------------

--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE IF NOT EXISTS `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions';

-- --------------------------------------------------------

--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE IF NOT EXISTS `time_zone_transition_type` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  `Offset` int(11) NOT NULL DEFAULT '0',
  `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types';

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
  `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
  `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8_bin DEFAULT 'mysql_native_password',
  `authentication_string` text COLLATE utf8_bin,
  `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`) VALUES
('localhost', 'root', '*34ED0CCF9C15466553D66EE4D2D30D3E2EA964E3', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('127.0.0.1', 'root', '*34ED0CCF9C15466553D66EE4D2D30D3E2EA964E3', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('::1', 'root', '*34ED0CCF9C15466553D66EE4D2D30D3E2EA964E3', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'root', '*34ED0CCF9C15466553D66EE4D2D30D3E2EA964E3', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'blogschooluser', '*4F32B0D8D9043E4173190F8BB550A0D5551802EE', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'pma', '*03E2854B1BC2353C7FED1F780C55F7845322DC57', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'testuser', '*559745BE38F18EAD74E73C24181C4CAD91C8DD35', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'blogschoololduse', '*7EBFCD8B959DA2D6024FB06BFD3AD4EEF28D5A24', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'sapphiresoftuser', '*AE01074B370091258B9BB73B2B2C120BBF98FDE5', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'occucarebloguser', '*B1ADE45FB0BD1D0A9719044C9645D6C9BE9AEA2A', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'applecore_user', '*3072F25F9F3F7F0694B6007678D743463794D49B', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'scooter_user', '*38AE72BE9696488636F0C2F863F603FD769CB813', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'sa', '*3DFA6166A89EB743E0371048386203B7FFD9728D', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'vedant_school', '*A844D199DB0FD887C1B349253993DE4A62A33AF4', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'sa', '*3DFA6166A89EB743E0371048386203B7FFD9728D', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'datingapp_u', '*823A42E8E4861F9298446A8D5935C6211770A077', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'fooddailyapp_u', '*908A1D8BADC52E0B255EE880C099EDB846713A03', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'vida_lms_dev', '*2C123E443089B60AD87BFD7BD45B82A2EF949DB8', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'mysqlbackup', '*097E5D80EEDF4E11E7778EFE62403EFFC1AC7949', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'sapphiresoftnewu', '*EAC2AA05AE51EE33C8B23969585CC7B08511ED5F', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'bugtrackeruser', '*F54CDE1C3F16CDF9529090ADD9719D6E43C9B22F', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'bugtrackeruser', '*F54CDE1C3F16CDF9529090ADD9719D6E43C9B22F', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'foodtrail', '*CE226009FE5CCF5416599549181A481FBEB42136', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'auditorpassuser', '*A6DDA2096EA2C45EEB0CCB4DDC90A5A833E524BE', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'sapphireblognew', '*43CCB32B5DE73CD73DBCEB8C364291762FEEC869', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'amittestblog', '*356B2491889B6AC1F68140CD3078B75F5969DAA6', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('%', 'blognew', '*952028539828324FEBA961B7642C8AB94A0F97DD', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N'),
('webserver1', 'testdb', '*DD231BF891786DDBDB54F9107D170DC1798A8826', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '', 'N');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `columns_priv`
--
ALTER TABLE `columns_priv`
  ADD PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`);

--
-- Indexes for table `db`
--
ALTER TABLE `db`
  ADD PRIMARY KEY (`Host`,`Db`,`User`),
  ADD KEY `User` (`User`);

--
-- Indexes for table `event`
--
ALTER TABLE `event`
  ADD PRIMARY KEY (`db`,`name`);

--
-- Indexes for table `func`
--
ALTER TABLE `func`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `help_category`
--
ALTER TABLE `help_category`
  ADD PRIMARY KEY (`help_category_id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `help_keyword`
--
ALTER TABLE `help_keyword`
  ADD PRIMARY KEY (`help_keyword_id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `help_relation`
--
ALTER TABLE `help_relation`
  ADD PRIMARY KEY (`help_keyword_id`,`help_topic_id`);

--
-- Indexes for table `help_topic`
--
ALTER TABLE `help_topic`
  ADD PRIMARY KEY (`help_topic_id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `innodb_index_stats`
--
ALTER TABLE `innodb_index_stats`
  ADD PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`);

--
-- Indexes for table `innodb_table_stats`
--
ALTER TABLE `innodb_table_stats`
  ADD PRIMARY KEY (`database_name`,`table_name`);

--
-- Indexes for table `ndb_binlog_index`
--
ALTER TABLE `ndb_binlog_index`
  ADD PRIMARY KEY (`epoch`,`orig_server_id`,`orig_epoch`);

--
-- Indexes for table `plugin`
--
ALTER TABLE `plugin`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `proc`
--
ALTER TABLE `proc`
  ADD PRIMARY KEY (`db`,`name`,`type`);

--
-- Indexes for table `procs_priv`
--
ALTER TABLE `procs_priv`
  ADD PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  ADD KEY `Grantor` (`Grantor`);

--
-- Indexes for table `proxies_priv`
--
ALTER TABLE `proxies_priv`
  ADD PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  ADD KEY `Grantor` (`Grantor`);

--
-- Indexes for table `servers`
--
ALTER TABLE `servers`
  ADD PRIMARY KEY (`Server_name`);

--
-- Indexes for table `slave_master_info`
--
ALTER TABLE `slave_master_info`
  ADD PRIMARY KEY (`Host`,`Port`);

--
-- Indexes for table `slave_relay_log_info`
--
ALTER TABLE `slave_relay_log_info`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `slave_worker_info`
--
ALTER TABLE `slave_worker_info`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `tables_priv`
--
ALTER TABLE `tables_priv`
  ADD PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  ADD KEY `Grantor` (`Grantor`);

--
-- Indexes for table `time_zone`
--
ALTER TABLE `time_zone`
  ADD PRIMARY KEY (`Time_zone_id`);

--
-- Indexes for table `time_zone_leap_second`
--
ALTER TABLE `time_zone_leap_second`
  ADD PRIMARY KEY (`Transition_time`);

--
-- Indexes for table `time_zone_name`
--
ALTER TABLE `time_zone_name`
  ADD PRIMARY KEY (`Name`);

--
-- Indexes for table `time_zone_transition`
--
ALTER TABLE `time_zone_transition`
  ADD PRIMARY KEY (`Time_zone_id`,`Transition_time`);

--
-- Indexes for table `time_zone_transition_type`
--
ALTER TABLE `time_zone_transition_type`
  ADD PRIMARY KEY (`Time_zone_id`,`Transition_type_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`Host`,`User`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `time_zone`
--
ALTER TABLE `time_zone`
  MODIFY `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
