

CREATE TABLE `tbl_agenda` (
  `ageId` varchar(10) NOT NULL,
  `ageJudul` varchar(200) NOT NULL,
  `ageTgl1` datetime NOT NULL,
  `ageTgl2` datetime NOT NULL,
  `ageIsi` text NOT NULL,
  `ageStatus` int(11) NOT NULL,
  `ageLink` varchar(10) NOT NULL,
  PRIMARY KEY (`ageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_agenda VALUES("AGE-000001","Bimtek Penyusunan Rencana Aksi POKJA PUG Kabupaten Sarmi","2021-07-31 09:59:00","2021-07-31 15:00:00","Sosialisasi Partisipasi Masyarakat Dalam Hak - Hak Anak (PUHA) dI Hotel Horison Kabupaten Sarmi.Sosialisasi Partisipasi Masyarakat Dalam Hak - Hak Anak (PUHA) dI Hotel Horison Kabupaten Sarmi.Sosialisasi Partisipasi Masyarakat Dalam Hak - Hak Anak (PUHA) dI Hotel Horison Kabupaten Sarmi.Sosialisasi Partisipasi Masyarakat Dalam Hak - Hak Anak (PUHA) dI Hotel Horison Kabupaten Sarmi.","1","PUB-000001");



CREATE TABLE `tbl_anggota` (
  `angId` varchar(10) NOT NULL,
  `angNama` varchar(100) NOT NULL,
  `angJabatan` int(11) NOT NULL,
  `angFoto` varchar(200) NOT NULL,
  PRIMARY KEY (`angId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_anggota VALUES("ANG-000001","Eti Nari","1","31072021172049users.jpg");
INSERT INTO tbl_anggota VALUES("ANG-000002","Sarce Abuere","5","31072021172606users.jpg");
INSERT INTO tbl_anggota VALUES("ANG-000003","Isabella K. Samoa","7","31072021172639users.jpg");



CREATE TABLE `tbl_backup` (
  `bacId` varchar(10) NOT NULL,
  `bacUsrId` varchar(10) NOT NULL,
  `bacFile` varchar(100) NOT NULL,
  `bacTime` datetime NOT NULL,
  PRIMARY KEY (`bacId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_backup VALUES("BAC-000001","USE-000001","sjksjksd.sql","2021-08-01 11:10:19");



CREATE TABLE `tbl_history` (
  `hisId` varchar(15) NOT NULL,
  `hisUsrId` varchar(10) NOT NULL,
  `hisAksi` varchar(100) NOT NULL,
  `hisAksId` varchar(10) NOT NULL,
  `hisTime` datetime NOT NULL,
  PRIMARY KEY (`hisId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_history VALUES("HIS-00000000001","USE-000001","Login","USE-000001","2021-07-31 03:43:43");
INSERT INTO tbl_history VALUES("HIS-00000000002","USE-000001","Tambah data Admin","USE-000002","2021-07-31 03:46:39");
INSERT INTO tbl_history VALUES("HIS-00000000003","USE-000001","Edit data Admin","0","2021-07-31 03:47:46");
INSERT INTO tbl_history VALUES("HIS-00000000004","USE-000001","Edit data Admin","USE-000002","2021-07-31 03:48:12");
INSERT INTO tbl_history VALUES("HIS-00000000005","USE-000001","Edit data Admin","USE-000001","2021-07-31 03:48:23");
INSERT INTO tbl_history VALUES("HIS-00000000006","USE-000001","Hapus data Admin","USE-000002","2021-07-31 03:49:31");
INSERT INTO tbl_history VALUES("HIS-00000000007","USE-000001","Logout","USE-000001","2021-07-31 03:50:37");
INSERT INTO tbl_history VALUES("HIS-00000000008","USE-000001","Login","USE-000001","2021-07-31 03:50:49");
INSERT INTO tbl_history VALUES("HIS-00000000009","USE-000001","Tambah data Ketua","KET-000001","2021-07-31 04:14:01");
INSERT INTO tbl_history VALUES("HIS-00000000010","USE-000001","Edit data Ketua","KET-000001","2021-07-31 04:32:48");
INSERT INTO tbl_history VALUES("HIS-00000000011","USE-000001","Hapus data Ketua","KET-000001","2021-07-31 04:34:32");
INSERT INTO tbl_history VALUES("HIS-00000000012","USE-000001","Tambah data Ketua","KET-000001","2021-07-31 05:03:48");
INSERT INTO tbl_history VALUES("HIS-00000000013","USE-000001","Login","USE-000001","2021-07-31 05:09:04");
INSERT INTO tbl_history VALUES("HIS-00000000014","USE-000001","Edit data Ketua","KET-000001","2021-07-31 05:09:33");
INSERT INTO tbl_history VALUES("HIS-00000000015","USE-000001","Tambah data Ketua","KET-000002","2021-07-31 05:10:18");
INSERT INTO tbl_history VALUES("HIS-00000000016","USE-000001","Tambah data Ketua","KET-000003","2021-07-31 05:11:02");
INSERT INTO tbl_history VALUES("HIS-00000000017","USE-000001","Tambah data Pengurus","ANG-000001","2021-07-31 05:20:49");
INSERT INTO tbl_history VALUES("HIS-00000000018","USE-000001","Edit data Pengurus","ANG-000001","2021-07-31 05:25:40");
INSERT INTO tbl_history VALUES("HIS-00000000019","USE-000001","Tambah data Pengurus","ANG-000002","2021-07-31 05:26:06");
INSERT INTO tbl_history VALUES("HIS-00000000020","USE-000001","Tambah data Pengurus","ANG-000003","2021-07-31 05:26:39");
INSERT INTO tbl_history VALUES("HIS-00000000021","USE-000001","Tambah data Pengurus","ANG-000004","2021-07-31 05:33:45");
INSERT INTO tbl_history VALUES("HIS-00000000022","USE-000001","Hapus data Pengurus","ANG-000004","2021-07-31 05:34:56");
INSERT INTO tbl_history VALUES("HIS-00000000023","USE-000001","Tambah data Agenda","AGE-000001","2021-07-31 06:36:58");
INSERT INTO tbl_history VALUES("HIS-00000000024","USE-000001","Login","USE-000001","2021-07-31 08:59:05");
INSERT INTO tbl_history VALUES("HIS-00000000025","USE-000001","Edit data Agenda","0","2021-07-31 09:29:23");
INSERT INTO tbl_history VALUES("HIS-00000000026","USE-000001","Hapus data Agenda","AGE-000001","2021-07-31 09:37:58");
INSERT INTO tbl_history VALUES("HIS-00000000027","USE-000001","Tambah data Agenda","AGE-000001","2021-07-31 09:41:10");
INSERT INTO tbl_history VALUES("HIS-00000000028","USE-000001","Edit data Agenda","AGE-000001","2021-07-31 09:47:56");
INSERT INTO tbl_history VALUES("HIS-00000000029","USE-000001","Edit data Agenda","AGE-000001","2021-07-31 09:52:34");
INSERT INTO tbl_history VALUES("HIS-00000000030","USE-000001","Edit data Agenda","AGE-000001","2021-07-31 10:02:59");
INSERT INTO tbl_history VALUES("HIS-00000000031","USE-000001","Edit data Agenda","AGE-000001","2021-07-31 10:04:09");
INSERT INTO tbl_history VALUES("HIS-00000000032","USE-000001","Edit data Agenda","AGE-000001","2021-07-31 10:04:20");
INSERT INTO tbl_history VALUES("HIS-00000000033","USE-000001","Tambah data Publik","PUB-000001","2021-07-31 10:35:02");
INSERT INTO tbl_history VALUES("HIS-00000000034","USE-000001","Tambah data Publik","PUB-000002","2021-07-31 10:42:25");
INSERT INTO tbl_history VALUES("HIS-00000000035","USE-000001","Login","USE-000001","2021-07-31 11:19:19");
INSERT INTO tbl_history VALUES("HIS-00000000036","USE-000001","Tambah data Publik","PUB-000003","2021-07-31 11:46:48");
INSERT INTO tbl_history VALUES("HIS-00000000037","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:21:50");
INSERT INTO tbl_history VALUES("HIS-00000000038","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:29:42");
INSERT INTO tbl_history VALUES("HIS-00000000039","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:36:30");
INSERT INTO tbl_history VALUES("HIS-00000000040","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:41:43");
INSERT INTO tbl_history VALUES("HIS-00000000041","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:42:43");
INSERT INTO tbl_history VALUES("HIS-00000000042","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:43:07");
INSERT INTO tbl_history VALUES("HIS-00000000043","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:45:12");
INSERT INTO tbl_history VALUES("HIS-00000000044","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:46:01");
INSERT INTO tbl_history VALUES("HIS-00000000045","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:47:58");
INSERT INTO tbl_history VALUES("HIS-00000000046","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:50:21");
INSERT INTO tbl_history VALUES("HIS-00000000047","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:50:44");
INSERT INTO tbl_history VALUES("HIS-00000000048","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:51:04");
INSERT INTO tbl_history VALUES("HIS-00000000049","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:51:40");
INSERT INTO tbl_history VALUES("HIS-00000000050","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:53:11");
INSERT INTO tbl_history VALUES("HIS-00000000051","USE-000001","Edit data Publik","PUB-000002","2021-08-01 12:53:25");
INSERT INTO tbl_history VALUES("HIS-00000000052","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:54:29");
INSERT INTO tbl_history VALUES("HIS-00000000053","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:54:59");
INSERT INTO tbl_history VALUES("HIS-00000000054","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:55:38");
INSERT INTO tbl_history VALUES("HIS-00000000055","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:56:08");
INSERT INTO tbl_history VALUES("HIS-00000000056","USE-000001","Edit data Publik","PUB-000003","2021-08-01 12:56:43");
INSERT INTO tbl_history VALUES("HIS-00000000057","USE-000001","Hapus data Publik","PUB-000002","2021-08-01 01:10:03");
INSERT INTO tbl_history VALUES("HIS-00000000058","USE-000001","Hapus data Publik","PUB-000003","2021-08-01 01:10:19");
INSERT INTO tbl_history VALUES("HIS-00000000059","USE-000001","Edit data Publik","PUB-000001","2021-08-01 01:10:40");
INSERT INTO tbl_history VALUES("HIS-00000000060","USE-000001","Hapus data Publik","PUB-000001","2021-08-01 01:11:00");
INSERT INTO tbl_history VALUES("HIS-00000000061","USE-000001","Tambah data Publik","PUB-000002","2021-08-01 01:18:31");
INSERT INTO tbl_history VALUES("HIS-00000000062","USE-000001","Edit data Agenda","AGE-000001","2021-08-01 01:20:48");
INSERT INTO tbl_history VALUES("HIS-00000000063","USE-000001","Logout","USE-000001","2021-08-01 01:48:18");
INSERT INTO tbl_history VALUES("HIS-00000000064","USE-000001","Login","USE-000001","2021-08-01 10:57:15");
INSERT INTO tbl_history VALUES("HIS-00000000065","USE-000001","Logout","USE-000001","2021-08-01 12:01:31");
INSERT INTO tbl_history VALUES("HIS-00000000066","USE-000001","Login","USE-000001","2021-08-01 12:01:36");
INSERT INTO tbl_history VALUES("HIS-00000000067","USE-000001","Logout","USE-000001","2021-08-01 12:02:13");
INSERT INTO tbl_history VALUES("HIS-00000000068","USE-000001","Login","USE-000001","2021-08-01 12:02:34");
INSERT INTO tbl_history VALUES("HIS-00000000069","USE-000001","Edit data Pesan","PES-000001","2021-08-01 12:26:27");
INSERT INTO tbl_history VALUES("HIS-00000000070","USE-000001","Edit data Pesan","PES-000001","2021-08-01 12:28:39");
INSERT INTO tbl_history VALUES("HIS-00000000071","USE-000001","Edit data Pesan","PES-000001","2021-08-01 12:28:47");
INSERT INTO tbl_history VALUES("HIS-00000000072","USE-000001","Edit data Pesan","PES-000001","2021-08-01 12:28:53");
INSERT INTO tbl_history VALUES("HIS-00000000073","USE-000001","Hapus data Pesan","PES-000001","2021-08-01 12:30:14");
INSERT INTO tbl_history VALUES("HIS-00000000074","USE-000001","Edit data Pesan","PES-000002","2021-08-01 12:57:16");



CREATE TABLE `tbl_kegiatan` (
  `kegId` varchar(15) NOT NULL,
  `kegPubId` varchar(10) NOT NULL,
  `kegFoto` varchar(200) NOT NULL,
  PRIMARY KEY (`kegId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;




CREATE TABLE `tbl_ketua` (
  `ketId` varchar(10) NOT NULL,
  `ketNama` varchar(100) NOT NULL,
  `ketJabatan` int(11) NOT NULL,
  `ketBakti1` int(11) NOT NULL,
  `ketBakti2` int(11) NOT NULL,
  `ketFoto` varchar(200) NOT NULL,
  PRIMARY KEY (`ketId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_ketua VALUES("KET-000001","Amelia Fonataba","1","2019","2024","31072021170933users.jpg");
INSERT INTO tbl_ketua VALUES("KET-000002","Rantina Bakai","2","2019","2024","31072021171018users.jpg");
INSERT INTO tbl_ketua VALUES("KET-000003","Agustina Moar","3","2019","2024","31072021171102users.jpg");



CREATE TABLE `tbl_pesan` (
  `pesId` varchar(10) NOT NULL,
  `pesNama` varchar(70) NOT NULL,
  `pesTelp` varchar(15) NOT NULL,
  `pesJudul` varchar(200) NOT NULL,
  `pesPesan` text NOT NULL,
  `pesTime` datetime NOT NULL,
  `pesStatus` int(11) NOT NULL,
  PRIMARY KEY (`pesId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_pesan VALUES("PES-000001","Endang","081342627621","Kebersihan","Kebersihan sangat penting demi meningkatkan pola hidup sehat. ","2021-08-01 10:32:40","2");
INSERT INTO tbl_pesan VALUES("PES-000002","asds","sad","sad","sad","2021-08-01 12:56:50","2");



CREATE TABLE `tbl_publik` (
  `pubId` varchar(10) NOT NULL,
  `pubStatus` int(11) NOT NULL,
  `pubJudul` text NOT NULL,
  `pubTime` datetime NOT NULL,
  `pubSampul` varchar(200) NOT NULL,
  `pubIsi` text NOT NULL,
  PRIMARY KEY (`pubId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_publik VALUES("PUB-000001","1","kegiatahgsjahd jhsdg1","2021-07-31 23:20:00","01082021011706image6.jpg","<p><em><strong>wer</strong></em><strong>erewrwerwerwerewrewr</strong>erewrewrewrew</p>
");
INSERT INTO tbl_publik VALUES("PUB-000002","1","c malesuada libero vehicula ut. Integer sodales, urna eget interdum eleifend,","2021-07-31 23:20:00","01082021011831image1.jpg","<p><span style="font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;">Nunc tincidunt, elit non cursus euismod, lacus augue ornare metus, egestas imperdiet nulla nisl quis mauris. Suspendisse a pharetra urna. Morbi dui lectus, pharetra nec elementum eget, vulputate ut nisi. Aliquam accumsan, nulla sed feugiat vehicula, lacus justo semper libero, quis porttitor turpis odio sit amet ligula. Duis dapibus fermentum orci, nec malesuada libero vehicula ut. Integer sodales, urna eget interdum eleifend, nulla nibh laoreet nisl, quis dignissim mauris dolor eget mi. Donec at mauris enim. Duis nisi tellus, adipiscing a convallis quis, tristique vitae risus. Nullam molestie gravida lobortis. Proin ut nibh quis felis auctor ornare. Cras ultricies, nibh at mollis faucibus, justo eros porttitor mi, quis auctor lectus arcu sit amet nunc. Vivamus gravida vehicula arcu, vitae vulputate augue lacinia faucibus.</span><br style="box-sizing: border-box; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" />
<br style="box-sizing: border-box; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" />
<span style="font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;">Nunc tincidunt, elit non cursus euismod, lacus augue ornare metus, egestas imperdiet nulla nisl quis mauris. Suspendisse a pharetra urna. Morbi dui lectus, pharetra nec elementum eget, vulputate ut nisi. Aliquam accumsan, nulla sed feugiat vehicula, lacus justo semper libero, quis porttitor turpis odio sit amet ligula. Duis dapibus fermentum orci, nec malesuada libero vehicula ut. Integer sodales, urna eget interdum eleifend, nulla nibh laoreet nisl, quis dignissim mauris dolor eget mi. Donec at mauris enim. Duis nisi tellus, adipiscing a convallis quis, tristique vitae risus. Nullam molestie gravida lobortis. Proin ut nibh quis felis auctor ornare. Cras ultricies, nibh at mollis faucibus, justo eros porttitor mi, quis auctor lectus arcu sit amet nunc. Vivamus gravida vehicula arcu, vitae vulputate augue lacinia faucibus.</span></p>
");



CREATE TABLE `tbl_user` (
  `usrId` varchar(10) NOT NULL,
  `usrNama` varchar(150) NOT NULL,
  `usrHp` varchar(13) NOT NULL,
  `usrUname` varchar(25) NOT NULL,
  `usrPwd` varchar(200) NOT NULL,
  `usrFoto` varchar(200) NOT NULL,
  PRIMARY KEY (`usrId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tbl_user VALUES("USE-000001","Endang S. Tahari","081342627621","admin","21232f297a57a5a743894a0e4a801fc3","3107202115260602_File Photo-min.jpg");

