/*
 Navicat Premium Data Transfer

 Source Server         : Localhost
 Source Server Type    : MySQL
 Source Server Version : 100427
 Source Host           : localhost:3306
 Source Schema         : teladan

 Target Server Type    : MySQL
 Target Server Version : 100427
 File Encoding         : 65001

 Date: 06/05/2024 17:33:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for berita
-- ----------------------------
DROP TABLE IF EXISTS `berita`;
CREATE TABLE `berita`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `judul_berita` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `isi_berita` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `detail_isi_berita` blob NULL,
  `tanggal` date NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of berita
-- ----------------------------
INSERT INTO `berita` VALUES (2, 'PELATIHAN PRECEPTORSHIP', 'Bahwa dalam rangka meningkatkan kemampuan pembimbing klinik (Clinincal Instruktur) Politeknik Kesehatan Kemenkes Medan diperlukan pelatihan preceptorship untuk memberikan bekal dan sebagai syarat untuk menjadi pembimbing klinik bagi pembimbing klinik sehingga memiliki kesiapan arah dalam proses pembelajaran klinik dalam memberikan bimbingan kepada mahasiswa agar mencapai kompetensi yang berstandar.\r\nLembaga Pelatihan Dan Pengembangan Kompetensi Poltekkes Medan Teladan, telah melaksanakan Pelatihan Preceptorship bagi Pembimbing Klinik di lingkungan Poltekkes Medan bekerjasama dengan Lembaga Competency Learning Center Mitra Husada pada tanggal 11-13 Januari 2024 dengan metode Blended Learning (daring dan luring) untuk satu Angkatan peserta.\r\n', 'preception.jpeg', '2024-04-25 13:33:40', '2024-05-06 11:50:24', NULL, 'Admin', 0x3C70207374796C653D226D617267696E2D72696768743A203070783B206D617267696E2D626F74746F6D3A20323470783B206D617267696E2D6C6566743A203070783B2070616464696E673A203070783B20666F6E742D76617269616E742D6E756D657269633A20696E68657269743B20666F6E742D76617269616E742D656173742D617369616E3A20696E68657269743B20666F6E742D737472657463683A20696E68657269743B206C696E652D6865696768743A20696E68657269743B20766572746963616C2D616C69676E3A20626173656C696E653B206F75746C696E653A203070783B202D7765626B69742D7461702D686967686C696768742D636F6C6F723A207267626128302C20302C20302C2030293B20626F726465723A203070783B20746578742D72656E646572696E673A206F7074696D697A656C65676962696C6974793B223E3C666F6E7420636F6C6F723D22233834383939342220666163653D224F70656E2053616E732C2073616E732D7365726966223E3C7370616E207374796C653D22666F6E742D73697A653A20313370783B223E42616877612064616C616D2072616E676B61206D656E696E676B61746B616E206B656D616D7075616E2070656D62696D62696E67206B6C696E696B2028436C696E696E63616C20496E737472756B7475722920506F6C6974656B6E696B204B657365686174616E204B656D656E6B6573204D6564616E2064697065726C756B616E2070656C61746968616E20707265636570746F727368697020756E74756B206D656D626572696B616E2062656B616C2064616E20736562616761692073796172617420756E74756B206D656E6A6164692070656D62696D62696E67206B6C696E696B20626167692070656D62696D62696E67206B6C696E696B20736568696E676761206D656D696C696B69206B6573696170616E20617261682064616C616D2070726F7365732070656D62656C616A6172616E206B6C696E696B2064616C616D206D656D626572696B616E2062696D62696E67616E206B6570616461206D61686173697377612061676172206D656E6361706169206B6F6D706574656E73692079616E67206265727374616E6461722E3C2F7370616E3E3C2F666F6E743E3C2F703E3C70207374796C653D226D617267696E2D72696768743A203070783B206D617267696E2D626F74746F6D3A20323470783B206D617267696E2D6C6566743A203070783B2070616464696E673A203070783B20666F6E742D76617269616E742D6E756D657269633A20696E68657269743B20666F6E742D76617269616E742D656173742D617369616E3A20696E68657269743B20666F6E742D737472657463683A20696E68657269743B206C696E652D6865696768743A20696E68657269743B20766572746963616C2D616C69676E3A20626173656C696E653B206F75746C696E653A203070783B202D7765626B69742D7461702D686967686C696768742D636F6C6F723A207267626128302C20302C20302C2030293B20626F726465723A203070783B20746578742D72656E646572696E673A206F7074696D697A656C65676962696C6974793B223E3C666F6E7420636F6C6F723D22233834383939342220666163653D224F70656E2053616E732C2073616E732D7365726966223E3C7370616E207374796C653D22666F6E742D73697A653A20313370783B223E4C656D626167612050656C61746968616E2044616E2050656E67656D62616E67616E204B6F6D706574656E736920506F6C74656B6B6573204D6564616E2054656C6164616E2C2074656C6168206D656C616B73616E616B616E2050656C61746968616E20507265636570746F727368697020626167692050656D62696D62696E67204B6C696E696B206469206C696E676B756E67616E20506F6C74656B6B6573204D6564616E2062656B65726A6173616D612064656E67616E204C656D6261676120436F6D706574656E6379204C6561726E696E672043656E746572204D697472612048757361646120706164612074616E6767616C2031312D3133204A616E7561726920323032342064656E67616E206D65746F646520426C656E646564204C6561726E696E672028646172696E672064616E206C7572696E672920756E74756B207361747520416E676B6174616E20706573657274612E3C2F7370616E3E3C2F666F6E743E3C2F703E, '2024-04-08');
INSERT INTO `berita` VALUES (40, 'PENGARAHAN PERSIAPAN PELATIHAN PENGEMBANGAN MEDIA PRESENTASI', 'Politeknik Kesehatan Medan sebagai Perguruan Tinggi Vokasi di Lingkungan Kementerian Kesehatan, bersiap untuk mewujudkan Lembaga Pelatihan Dan Pengembangan Kompetensi Poltekkes Medan Teladan yang terakreditasi Unggul.\r\nDalam memenuhi rangkaian persyaratan terakreditasinya Lembaga tersebut, Lembaga Pelatihan Dan Pengembangan Kompetensi Poltekkes Medan Teladan akan melaksanakan Pelatihan Pengembangan Media Presentasi bagi Dosen Poltekkes Medan bekerjasama dengan Balai Pelatihan Kesehatan Batam pada tanggal 18-21 Maret 2024 secara daring/full online untuk 2 angkatan peserta. Sebelum dimulainya pelatihan, dilakukan pengarahan persiapan pelatihan secara teknis sehingga diharapkan pelatihan akan berjalan sukses dan bermanfaat bagi seluruh peserta. \r\n', 'pengembangan.jpg', '2024-04-23 14:47:39', '2024-05-06 11:50:15', NULL, 'Admin', 0x3C70207374796C653D226D617267696E2D72696768743A203070783B206D617267696E2D626F74746F6D3A20323470783B206D617267696E2D6C6566743A203070783B2070616464696E673A203070783B20666F6E742D76617269616E742D6E756D657269633A20696E68657269743B20666F6E742D76617269616E742D656173742D617369616E3A20696E68657269743B20666F6E742D737472657463683A20696E68657269743B206C696E652D6865696768743A20696E68657269743B20766572746963616C2D616C69676E3A20626173656C696E653B206F75746C696E653A203070783B202D7765626B69742D7461702D686967686C696768742D636F6C6F723A207267626128302C20302C20302C2030293B20626F726465723A203070783B20746578742D72656E646572696E673A206F7074696D697A656C65676962696C6974793B223E3C666F6E7420636F6C6F723D22233834383939342220666163653D224F70656E2053616E732C2073616E732D7365726966223E3C7370616E207374796C653D22666F6E742D73697A653A20313370783B223E506F6C6974656B6E696B204B657365686174616E204D6564616E20736562616761692050657267757275616E2054696E67676920566F6B617369206469204C696E676B756E67616E204B656D656E74657269616E204B657365686174616E2C206265727369617020756E74756B206D6577756A75646B616E204C656D626167612050656C61746968616E2044616E2050656E67656D62616E67616E204B6F6D706574656E736920506F6C74656B6B6573204D6564616E2054656C6164616E2079616E6720746572616B726564697461736920556E6767756C2E3C2F7370616E3E3C2F666F6E743E3C2F703E3C70207374796C653D226D617267696E2D72696768743A203070783B206D617267696E2D626F74746F6D3A20323470783B206D617267696E2D6C6566743A203070783B2070616464696E673A203070783B20666F6E742D76617269616E742D6E756D657269633A20696E68657269743B20666F6E742D76617269616E742D656173742D617369616E3A20696E68657269743B20666F6E742D737472657463683A20696E68657269743B206C696E652D6865696768743A20696E68657269743B20766572746963616C2D616C69676E3A20626173656C696E653B206F75746C696E653A203070783B202D7765626B69742D7461702D686967686C696768742D636F6C6F723A207267626128302C20302C20302C2030293B20626F726465723A203070783B20746578742D72656E646572696E673A206F7074696D697A656C65676962696C6974793B223E3C666F6E7420636F6C6F723D22233834383939342220666163653D224F70656E2053616E732C2073616E732D7365726966223E3C7370616E207374796C653D22666F6E742D73697A653A20313370783B223E44616C616D206D656D656E7568692072616E676B6169616E20706572737961726174616E20746572616B72656469746173696E7961204C656D626167612074657273656275742C204C656D626167612050656C61746968616E2044616E2050656E67656D62616E67616E204B6F6D706574656E736920506F6C74656B6B6573204D6564616E2054656C6164616E20616B616E206D656C616B73616E616B616E2050656C61746968616E2050656E67656D62616E67616E204D656469612050726573656E74617369206261676920446F73656E20506F6C74656B6B6573204D6564616E2062656B65726A6173616D612064656E67616E2042616C61692050656C61746968616E204B657365686174616E20426174616D20706164612074616E6767616C2031382D3231204D6172657420323032342073656361726120646172696E672F66756C6C206F6E6C696E6520756E74756B203220616E676B6174616E20706573657274612E20536562656C756D2064696D756C61696E79612070656C61746968616E2C2064696C616B756B616E2070656E6761726168616E2070657273696170616E2070656C61746968616E207365636172612074656B6E697320736568696E67676120646968617261706B616E2070656C61746968616E20616B616E206265726A616C616E2073756B7365732064616E206265726D616E6661617420626167692073656C7572756820706573657274612E3C2F7370616E3E3C2F666F6E743E3C2F703E, '2024-04-16');
INSERT INTO `berita` VALUES (41, 'PUBLIC SPEAKING', 'Public speaking atau Berbicara di depan umum merupakan salah satu cara paling efektif untuk berkomunikasi dengan orang banyak. Kemampuan untuk menyampaikan ide dan pesan secara jelas dan persuasif adalah keterampilan yang sangat berharga dalam berbagai aspek kehidupan, baik itu dalam pekerjaan, pendidikan, maupun kehidupan sosial. Dapat mengembangkan hubungan dengan berbagai orang dari latar belakang yang berbeda. Ini bisa menjadi kesempatan untuk berbagi ide, menemukan mentor, atau menjalin kemitraan yang berpotensi menguntungkan baik secara profesional maupun pribadi. Orang yang pandai berbicara di depan umum memiliki kemampuan untuk mempengaruhi dan meyakinkan orang lain. Kemampuan ini penting dalam berbagai konteks, mulai dari memimpin rapat, menjual ide, hingga mempengaruhi keputusan strategis.', 'public_speaking.jpeg', '2024-05-06 11:35:30', '2024-05-06 12:16:39', NULL, 'Admin', 0x3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B0D0A6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E536F7369616C697361736920696E692074656C61680D0A64696C616B756B616E207061646120526162752074616E6767616C203133204D6172657420323032342C2079616E672064696C616B756B616E2073656361726120646172696E672064616E2064690D0A686164697269206F6C6568203820706573657274612E3C6F3A703E3C2F6F3A703E3C2F7370616E3E3C2F703E3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B0D0A6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E266E6273703B3C2F7370616E3E3C2F703E3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B0D0A6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E50656E74696E676E7961203C7370616E207374796C653D22636F6C6F723A207267622831332C2031332C203133293B206261636B67726F756E642D696D6167653A20696E697469616C3B206261636B67726F756E642D706F736974696F6E3A20696E697469616C3B206261636B67726F756E642D73697A653A20696E697469616C3B206261636B67726F756E642D7265706561743A20696E697469616C3B206261636B67726F756E642D6174746163686D656E743A20696E697469616C3B206261636B67726F756E642D6F726967696E3A20696E697469616C3B206261636B67726F756E642D636C69703A20696E697469616C3B223E7075626C696320737065616B696E673C2F7370616E3E3C6F3A703E3C2F6F3A703E3C2F7370616E3E3C2F703E3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A7573746966793B746578742D696E64656E743A2E3235696E223E3C7370616E207374796C653D22666F6E742D73697A653A20313270743B206C696E652D6865696768743A20313037253B20666F6E742D66616D696C793A202671756F743B54696D6573204E657720526F6D616E2671756F743B2C2073657269663B20636F6C6F723A207267622831332C2031332C203133293B206261636B67726F756E642D696D6167653A20696E697469616C3B206261636B67726F756E642D706F736974696F6E3A20696E697469616C3B206261636B67726F756E642D73697A653A20696E697469616C3B206261636B67726F756E642D7265706561743A20696E697469616C3B206261636B67726F756E642D6174746163686D656E743A20696E697469616C3B206261636B67726F756E642D6F726967696E3A20696E697469616C3B206261636B67726F756E642D636C69703A20696E697469616C3B223E5075626C696320737065616B696E672061746175203C2F7370616E3E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E4265726269636172610D0A646920646570616E20756D756D206D65727570616B616E2073616C6168207361747520636172612070616C696E67206566656B74696620756E74756B206265726B6F6D756E696B6173690D0A64656E67616E206F72616E672062616E79616B2E204B656D616D7075616E20756E74756B206D656E79616D7061696B616E206964652064616E20706573616E20736563617261206A656C61730D0A64616E20706572737561736966206164616C6168206B65746572616D70696C616E2079616E672073616E6761742062657268617267612064616C616D20626572626167616920617370656B0D0A6B656869647570616E2C206261696B206974752064616C616D2070656B65726A61616E2C2070656E646964696B616E2C206D617570756E206B656869647570616E20736F7369616C2E2044617061740D0A6D656E67656D62616E676B616E20687562756E67616E2064656E67616E206265726261676169206F72616E672064617269206C617461722062656C616B616E672079616E6720626572626564612E0D0A496E692062697361206D656E6A616469206B6573656D706174616E20756E74756B2062657262616769206964652C206D656E656D756B616E206D656E746F722C2061746175206D656E6A616C696E0D0A6B656D69747261616E2079616E6720626572706F74656E7369206D656E67756E74756E676B616E206261696B207365636172612070726F666573696F6E616C206D617570756E20707269626164692E0D0A4F72616E672079616E672070616E6461692062657262696361726120646920646570616E20756D756D206D656D696C696B69206B656D616D7075616E20756E74756B206D656D70656E6761727568690D0A64616E206D6579616B696E6B616E206F72616E67206C61696E2E204B656D616D7075616E20696E692070656E74696E672064616C616D206265726261676169206B6F6E74656B732C206D756C61690D0A64617269206D656D696D70696E2072617061742C206D656E6A75616C206964652C2068696E676761206D656D70656E676172756869206B657075747573616E207374726174656769732E3C6F3A703E3C2F6F3A703E3C2F7370616E3E3C2F703E3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A7573746966793B746578742D696E64656E743A2E3235696E223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E4265726269636172610D0A6469646570616E20756D756D206A756761206461706174206D656E67656D62616E676B616E20646972692073656361726120707269626164692064656E67616E2050726F7365730D0A70657273696170616E2064616E2070656E616D70696C616E20646920646570616E2061756469656E73206461706174206D656D62616E7475206D656E696E676B61746B616E0D0A6B6570657263617961616E20646972692C206D656E676174617369206B6574616B7574616E2C2064616E206D656E6761736168206B65746572616D70696C616E206B6F6D756E696B6173692E204B656D616D7075616E0D0A62657262696361726120646920646570616E20756D756D206461706174206D656D62756B612070696E74752062616769206B656D616A75616E206B61726965722079616E670D0A7369676E6966696B616E2E2042616E79616B2070656B65726A61616E2064616E20706F73697369206D656D62757475686B616E206B656D616D7075616E206B6F6D756E696B6173692079616E670D0A6B7561742C2064616E206B656D616D7075616E20756E74756B2062657262696361726120646920646570616E20756D756D206461706174206D656E6A616469206B65756E6767756C616E0D0A6B6F6D706574697469662079616E67206D656D626564616B616E2064656E67616E2079616E67206C61696E2E204F72616E672079616E672061686C692064616C616D206265726269636172612064690D0A646570616E20756D756D20736572696E676B616C69206469686F726D6174692064616E206469616B756920736562616761692070656D696D70696E2070616E64616E67616E2064616C616D0D0A626964616E67206D6572656B612E204B656D616D7075616E20756E74756B2062657262696361726120736563617261207065727375617369662064616E206D6579616B696E6B616E20626973610D0A6D656D62616E7475206D656D62616E67756E2072657075746173692079616E67206B7561742E2042657262696361726120646920646570616E20756D756D206A756761206D65727570616B616E0D0A6361726120756E74756B206D656E6761746173692074616E74616E67616E2064616E206D656E67656D62616E676B616E20646972692E20536574696170206B6573656D706174616E0D0A626572626963617261206D656D626572696B616E2070656C616A6172616E2062657268617267612C206261696B2064617269206B6573756B736573616E206D617570756E206B65676167616C616E2C0D0A79616E67206461706174206D656D62616E74752074756D6275682064616E206265726B656D62616E6720736562616761692073656F72616E6720696E6469766964752E203C7370616E20636C6173733D2273656C65637461626C652D74657874223E44656E67616E2064656D696B69616E2C206B656D616D7075616E2062657262696361726120646920646570616E20756D756D2062756B616E0D0A68616E7961206D65727570616B616E206B65746572616D70696C616E2079616E672070656E74696E672064616C616D206B6F6E74656B732070726F666573696F6E616C2C207465746170690D0A6A7567612070656E74696E6720756E74756B2070656E67656D62616E67616E20707269626164692C2070656E676172756820736F7369616C2C2064616E206B6573756B736573616E207365636172610D0A6B6573656C75727568616E2064616C616D206B656869647570616E2E3C6F3A703E3C2F6F3A703E3C2F7370616E3E3C2F7370616E3E3C2F703E3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E20636C6173733D2273656C65637461626C652D74657874223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E266E6273703B3C2F7370616E3E3C2F7370616E3E3C2F703E3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E20636C6173733D2273656C65637461626C652D74657874223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E556E74756B0D0A6461706174206C65626968206C616E6A7574206D656D70656C616A617269203C2F7370616E3E3C2F7370616E3E3C7370616E207374796C653D22666F6E742D73697A653A20313270743B206C696E652D6865696768743A20313037253B20666F6E742D66616D696C793A202671756F743B54696D6573204E657720526F6D616E2671756F743B2C2073657269663B20636F6C6F723A207267622831332C2031332C203133293B206261636B67726F756E642D696D6167653A20696E697469616C3B206261636B67726F756E642D706F736974696F6E3A20696E697469616C3B206261636B67726F756E642D73697A653A20696E697469616C3B206261636B67726F756E642D7265706561743A20696E697469616C3B206261636B67726F756E642D6174746163686D656E743A20696E697469616C3B206261636B67726F756E642D6F726967696E3A20696E697469616C3B206261636B67726F756E642D636C69703A20696E697469616C3B223E7075626C696320737065616B696E67203C2F7370616E3E3C7370616E20636C6173733D2273656C65637461626C652D74657874223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E64617061740D0A6469203C6120687265663D2268747470733A2F2F64726976652E676F6F676C652E636F6D2F64726976652F666F6C646572732F31554A687647794D765678514E46567230515358323263505A6946486830557A5122207461726765743D225F626C616E6B223E6B6C696B20646973696E693C2F613E2E3C6F3A703E3C2F6F3A703E3C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D226D617267696E2D72696768743A203070783B206D617267696E2D626F74746F6D3A20323470783B206D617267696E2D6C6566743A203070783B2070616464696E673A203070783B20666F6E742D76617269616E742D6E756D657269633A20696E68657269743B20666F6E742D76617269616E742D656173742D617369616E3A20696E68657269743B20666F6E742D737472657463683A20696E68657269743B206C696E652D6865696768743A20696E68657269743B20766572746963616C2D616C69676E3A20626173656C696E653B206F75746C696E653A203070783B202D7765626B69742D7461702D686967686C696768742D636F6C6F723A207267626128302C20302C20302C2030293B20626F726465723A203070783B20746578742D72656E646572696E673A206F7074696D697A656C65676962696C6974793B223E0D0A0D0A0D0A0D0A0D0A0D0A0D0A0D0A0D0A0D0A0D0A0D0A0D0A0D0A3C2F703E3C7020636C6173733D224D736F4E6F726D616C22207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E20636C6173733D2273656C65637461626C652D74657874223E3C7370616E207374796C653D22666F6E742D73697A653A31322E3070743B6C696E652D6865696768743A313037253B666F6E742D66616D696C793A2671756F743B54696D6573204E657720526F6D616E2671756F743B2C7365726966223E416E64610D0A6A756761206461706174206D656E6765726A616B616E203C6120687265663D2268747470733A2F2F646F63732E676F6F676C652E636F6D2F666F726D732F642F652F3146414970514C5366586642424D6F546B48336654424F5461724167414E3169705757795133434A6D376D775F773074775343765F5748772F76696577666F726D3F7573703D73665F6C696E6B22207461726765743D225F626C616E6B223E6B75697320646973696E693C2F613E2E3C6F3A703E3C2F6F3A703E3C2F7370616E3E3C2F7370616E3E3C2F703E, '2024-04-19');

-- ----------------------------
-- Table structure for cache
-- ----------------------------
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache`  (
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cache_locks
-- ----------------------------
DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks`  (
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for galeri_fasilitas
-- ----------------------------
DROP TABLE IF EXISTS `galeri_fasilitas`;
CREATE TABLE `galeri_fasilitas`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `judul_galeri` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of galeri_fasilitas
-- ----------------------------
INSERT INTO `galeri_fasilitas` VALUES (1, 'LAB OSC KEBIDANAN', 'kebidanan1.jpeg', '2024-04-24 12:19:25', '2024-04-25 10:16:46', NULL);
INSERT INTO `galeri_fasilitas` VALUES (2, 'LAB OSC KEBIDANAN', 'kebidanan2.jpeg', '2024-04-24 12:19:25', '2024-04-25 10:17:48', NULL);
INSERT INTO `galeri_fasilitas` VALUES (3, 'LAB BAHASA', 'lab1.jpeg', '2024-04-24 12:21:15', '2024-04-25 10:16:12', NULL);
INSERT INTO `galeri_fasilitas` VALUES (4, 'LAB BAHASA', 'lab2.jpeg', '2024-04-24 12:21:15', '2024-04-25 10:18:31', NULL);
INSERT INTO `galeri_fasilitas` VALUES (5, 'LAB TERPADU', 'terpadu1.jpeg', '2024-04-24 14:06:20', '2024-04-25 10:20:24', NULL);
INSERT INTO `galeri_fasilitas` VALUES (6, 'LAB TERPADU', 'terpadu2.jpeg', '2024-04-24 14:06:20', '2024-04-25 10:20:34', NULL);
INSERT INTO `galeri_fasilitas` VALUES (7, 'RUANG CBT', 'cbt1.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (8, 'RUANG CBT', 'cbt2.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (9, 'RUANG KELAS', 'kelas1.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (11, 'AUDITORIUM', 'autor1.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (12, 'AUDITORIUM', 'autor2.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (13, 'PERPUSTAKAAN', 'perpus1.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (14, 'PERPUSTAKAAN', 'perpus2.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (15, 'RUANG DIREKTUR', 'dir1.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (16, 'RUANG DIREKTUR', 'dir2.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (17, 'LAPANGAN BADMINTON', 'badmin1.jpeg', '2024-04-25 10:43:26', '2024-04-25 10:43:26', NULL);
INSERT INTO `galeri_fasilitas` VALUES (18, 'LAPANGAN BADMINTON', 'badmin3.jpeg', '2024-04-25 10:43:26', '2024-04-25 11:50:38', NULL);

-- ----------------------------
-- Table structure for galeri_kegiatan
-- ----------------------------
DROP TABLE IF EXISTS `galeri_kegiatan`;
CREATE TABLE `galeri_kegiatan`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `judul_kegiatan` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of galeri_kegiatan
-- ----------------------------
INSERT INTO `galeri_kegiatan` VALUES (41, 'PELATIHAN PRECEPTORSHIP', 'kegiatan1.jpeg', '2024-04-25 13:57:49', '2024-04-25 13:57:49', NULL);
INSERT INTO `galeri_kegiatan` VALUES (42, 'PELATIHAN PRECEPTORSHIP', 'kegiatan2.jpeg', '2024-04-25 13:57:49', '2024-04-25 13:57:49', NULL);
INSERT INTO `galeri_kegiatan` VALUES (43, 'PELATIHAN PRECEPTORSHIP', 'kegiatan3.jpeg', '2024-04-25 13:57:49', '2024-04-25 13:57:49', NULL);
INSERT INTO `galeri_kegiatan` VALUES (44, 'PELATIHAN PRECEPTORSHIP', 'kegiatan4.jpeg', '2024-04-25 13:57:49', '2024-04-25 13:57:49', NULL);
INSERT INTO `galeri_kegiatan` VALUES (45, 'PELATIHAN PRECEPTORSHIP', 'kegiatan5.jpeg', '2024-04-25 13:57:49', '2024-04-25 13:57:49', NULL);
INSERT INTO `galeri_kegiatan` VALUES (46, 'PENGARAHAN PERSIAPAN PELATIHAN PENGEMBANGAN MEDIA PRESENTASI', 'kegiatan6.jpeg', '2024-04-25 13:57:49', '2024-04-25 13:57:49', NULL);
INSERT INTO `galeri_kegiatan` VALUES (47, 'PENGARAHAN PERSIAPAN PELATIHAN PENGEMBANGAN MEDIA PRESENTASI', 'kegiatan7.jpeg', '2024-04-25 13:57:49', '2024-04-25 13:57:49', NULL);

-- ----------------------------
-- Table structure for isi_dokumen
-- ----------------------------
DROP TABLE IF EXISTS `isi_dokumen`;
CREATE TABLE `isi_dokumen`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jenis_id` int(11) NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `keterangan` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `file_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  `jenis_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of isi_dokumen
-- ----------------------------
INSERT INTO `isi_dokumen` VALUES (1, 1, 'reinsta.pdf', 'RENSTRA', 'pdf', '2024-04-29 09:46:24', '2024-05-04 17:07:26', NULL, '1');
INSERT INTO `isi_dokumen` VALUES (2, 2, 'rkt.pdf', 'RKT', 'pdf', '2024-04-29 09:46:24', '2024-05-04 17:07:27', NULL, '1');
INSERT INTO `isi_dokumen` VALUES (3, 3, 'laporan pelatihan.pdf', 'LAPORAN PENELITIAN', 'pdf', '2024-04-29 09:46:24', '2024-05-04 17:07:27', NULL, '1');
INSERT INTO `isi_dokumen` VALUES (4, 4, 'hasil surve.pdf', 'HASIL SURVEY', 'pdf', '2024-04-29 09:46:24', '2024-05-04 17:07:28', NULL, '1');
INSERT INTO `isi_dokumen` VALUES (5, 2, 'rkt1.pdf', 'RKT', 'pdf', '2024-04-29 09:46:24', '2024-05-04 17:07:29', '2024-05-04 11:15:57', '1');
INSERT INTO `isi_dokumen` VALUES (41, 41, 'https://drive.google.com/drive/folders/1BEwOrQHfCC_mQSRspkbQmFYsPELNy18g?usp=sharing', 'Materi Materi Sosialisasi Polkesmed', '', '2024-03-01 17:06:37', '2024-05-04 17:33:04', NULL, '2');
INSERT INTO `isi_dokumen` VALUES (43, 41, 'https://forms.gle/1DDDxq6rdmBQQFAC7', 'Post Test Public Speaking', '', '2024-03-13 17:06:37', '2024-05-04 17:33:04', NULL, '2');

-- ----------------------------
-- Table structure for jadwal
-- ----------------------------
DROP TABLE IF EXISTS `jadwal`;
CREATE TABLE `jadwal`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isi_jadwal` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `tanggal_awal` date NULL DEFAULT NULL,
  `tanggal_akhir` date NULL DEFAULT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jadwal
-- ----------------------------
INSERT INTO `jadwal` VALUES (1, 'Media presentasi', '2024-03-18', '2024-03-21', '2024-04-23 16:49:46', '2024-04-26 08:13:49', NULL);
INSERT INTO `jadwal` VALUES (2, 'Preceptorship', '2024-01-11', '2024-01-13', '2024-04-26 08:20:02', '2024-04-26 08:20:02', NULL);
INSERT INTO `jadwal` VALUES (40, 'Pelatihan Public Speaking Bagi SDM Kesehatan', '2024-06-03', '2024-06-07', '2024-05-04 15:36:04', '2024-05-04 15:38:04', NULL);
INSERT INTO `jadwal` VALUES (41, 'Pelatihan Basic Trauma Cardiac Life Support (BTCLS)', '2024-08-05', '2024-08-13', '2024-05-04 15:36:26', '2024-05-04 15:42:48', NULL);
INSERT INTO `jadwal` VALUES (42, 'Pelatihan Keselamatan dan Kesehatan Kerja di Fasilitas Pelayanan Kesehatan (K3)', '2024-07-01', '2024-07-09', '2024-05-04 15:37:08', '2024-05-04 15:43:24', NULL);
INSERT INTO `jadwal` VALUES (43, 'Pelatihan Pengelolaan Limbah Fasyankes', '2024-09-02', '2024-09-06', '2024-05-04 15:37:22', '2024-05-04 15:43:45', NULL);

-- ----------------------------
-- Table structure for jenis_dokumen
-- ----------------------------
DROP TABLE IF EXISTS `jenis_dokumen`;
CREATE TABLE `jenis_dokumen`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama_dokumen` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jenis_dokumen
-- ----------------------------
INSERT INTO `jenis_dokumen` VALUES (1, 'RENSTRA', '2024-04-28 08:17:43', '2024-04-28 08:17:43', NULL);
INSERT INTO `jenis_dokumen` VALUES (2, 'RKT', '2024-04-28 08:17:43', '2024-04-28 08:17:43', NULL);
INSERT INTO `jenis_dokumen` VALUES (3, 'LAPORAN PELATIHAN', '2024-04-28 08:17:43', '2024-05-04 11:17:37', '2024-05-04 11:17:35');
INSERT INTO `jenis_dokumen` VALUES (4, 'HASIL SURVEY ', '2024-04-28 08:17:43', '2024-05-04 11:17:39', '2024-05-04 11:17:35');
INSERT INTO `jenis_dokumen` VALUES (41, 'MATERI SOSIALISASI TELADAN', '2024-05-04 17:06:30', '2024-05-04 17:06:30', NULL);

-- ----------------------------
-- Table structure for jenis_fasilitas
-- ----------------------------
DROP TABLE IF EXISTS `jenis_fasilitas`;
CREATE TABLE `jenis_fasilitas`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama_fasilitas` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
  `updated_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `deleted_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jenis_fasilitas
-- ----------------------------
INSERT INTO `jenis_fasilitas` VALUES (1, 'LAB BAHASA', '2024-04-25 09:59:25', '2024-04-25 10:13:44', NULL);
INSERT INTO `jenis_fasilitas` VALUES (2, 'LAB TERPADU', '2024-04-25 09:59:25', '2024-04-25 10:13:36', NULL);
INSERT INTO `jenis_fasilitas` VALUES (3, 'LAB OSC KEBIDANAN', '2024-04-25 10:01:22', '2024-04-25 10:01:22', NULL);
INSERT INTO `jenis_fasilitas` VALUES (4, 'RUANG CBT', '2024-04-25 10:01:22', '2024-04-25 10:01:22', NULL);
INSERT INTO `jenis_fasilitas` VALUES (5, 'RUANG KELAS', '2024-04-25 10:02:50', '2024-04-25 10:03:00', NULL);
INSERT INTO `jenis_fasilitas` VALUES (6, 'AUDITORIUM', '2024-04-25 10:02:50', '2024-04-25 10:03:05', NULL);
INSERT INTO `jenis_fasilitas` VALUES (7, 'PERPUSTAKAAN', '2024-04-25 10:04:05', '2024-04-25 10:04:05', NULL);
INSERT INTO `jenis_fasilitas` VALUES (8, 'RUANG DIREKTUR', '2024-04-25 10:04:05', '2024-04-25 10:04:05', NULL);
INSERT INTO `jenis_fasilitas` VALUES (9, 'LAPANGAN BADMINTON', '2024-04-25 10:04:51', '2024-04-25 10:04:51', NULL);
INSERT INTO `jenis_fasilitas` VALUES (10, 'RUANG DISKUSI', '2024-04-25 10:04:51', '2024-04-25 10:04:51', NULL);

-- ----------------------------
-- Table structure for job_batches
-- ----------------------------
DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE `job_batches`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `cancelled_at` int(11) NULL DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for jobs
-- ----------------------------
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED NULL DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `jobs_queue_index`(`queue`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '0001_01_01_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (2, '0001_01_01_000001_create_cache_table', 1);
INSERT INTO `migrations` VALUES (3, '0001_01_01_000002_create_jobs_table', 1);

-- ----------------------------
-- Table structure for password_reset_tokens
-- ----------------------------
DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens`  (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`email`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sessions
-- ----------------------------
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sessions_user_id_index`(`user_id`) USING BTREE,
  INDEX `sessions_last_activity_index`(`last_activity`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sessions
-- ----------------------------
INSERT INTO `sessions` VALUES ('3LhVOLxgHUCO605DEFZYpiEEbneA1NflCLQubTOl', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoia1QyWXkyTkY2QmtsMndjZzlneGVXVFM2bDJjNUhibVVPTHIzTGpuayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3QvZGlrbGF0L3B1YmxpYy9mb2xkZXIvMSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1714438375);
INSERT INTO `sessions` VALUES ('4bxIzDT5R6kkq2vddED5UCgnnOW0NJXpsOAxqFAv', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU2NIOWx4ejVuenBXRTJpWUJhQVR1bjlUYWZwdk5RbndrWnpHZWpWSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3QvdGVsYWRhbi9wdWJsaWMvZm9sZGVyLzEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1714971643);
INSERT INTO `sessions` VALUES ('5NO5fkHNi1rtsCnIvVW9j7YxqcBz8IqU7XbzGa00', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY0w2dXhzUzF0b2dvQmxUcjB0YlVYT1NETmFnODJZc29xMDFoOFVKbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9sb2NhbGhvc3QvdGVsYWRhbi9wdWJsaWMvZm9sZGVyLzQxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1714818517);
INSERT INTO `sessions` VALUES ('GlCyvAaeYEQXzI4qlr7AD4F3BjC56djC9K9EUQCp', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoic1k0dVNMS29XTkp4bVNJRzdRQTBYaWNKMldzZWIyWGx5eEVONWpzSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3QvZGlrbGF0L3B1YmxpYy9mb2xkZXIvMyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1714374449);
INSERT INTO `sessions` VALUES ('jTpBx0KAi9c2Djo09qU0zjEvmfcgou8LWJKTVwz5', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoic1pQMjg3NkM5QkZQNE1VSUZmRnlBbnZKdk5OMlFRa2dCQ01VZGx2NSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly9sb2NhbGhvc3QvdGVsYWRhbi9wdWJsaWMvYmVyaXRhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1714878267);
INSERT INTO `sessions` VALUES ('liZma4rNIntjGvNxDScungABoLrV8cfqTLb6dKKX', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibUZEMmhVRzlqYlNsUWZZeXJuRm1YeHp5NkdUSzFSUWxLTmxYZmQzZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9sb2NhbGhvc3QvdGVsYWRhbi9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1714698515);
INSERT INTO `sessions` VALUES ('pRTgNca5frPDlceorLnTE6RNup1B6hUvqlpP7mha', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoialp5QTFwREU0OVFkTmljS2VGQ3JjRWhvSnZRd2ZVdzBVbXBQNm4zTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9sb2NhbGhvc3QvdGVsYWRhbi9wdWJsaWMvZmFzaWxpdGFzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1714801558);
INSERT INTO `sessions` VALUES ('RH9RMniNOvyWBMqOXEnEPZaCM6jRepWYkQ4wYpk6', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSUhGWHB4ZGNBajJmUkR3RWk4ZlgxWG52Wmd5ajYzVUVkWG1UQVVjTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9sb2NhbGhvc3QvdGVsYWRhbi9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1714713568);
INSERT INTO `sessions` VALUES ('zWnvglx7ltEaxJJN073OArCc8kOklIo0UBwaDsQQ', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZmxia3l4YmhYY0JDbVlTVEp3YThzV21reHpJZDN0ekRQa09XQ2ZobiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3QvZGlrbGF0L3B1YmxpYy9mb2xkZXIvMSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1714382391);

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp(0) NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
