-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 28, 2023 at 03:01 AM
-- Server version: 10.4.20-MariaDB
-- PHP Version: 7.3.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `biro_adm_pembangunan`
--

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

--
-- Table structure for table `file`
--

CREATE TABLE `file` (
  `id_file` int(11) NOT NULL,
  `nama_kegiatan` text NOT NULL,
  `instansi_pelaksana` text NOT NULL,
  `tgl_pelaksanaan` varchar(55) NOT NULL,
  `waktu_pelaksanaan` varchar(35) NOT NULL,
  `dilaksanakan_di` text NOT NULL,
  `tipe_kegiatan` text NOT NULL,
  `link_file` text NOT NULL,
  `publikasikan` varchar(5) NOT NULL,
  `created_at` varchar(55) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `file`
--

INSERT INTO `file` (`id_file`, `nama_kegiatan`, `instansi_pelaksana`, `tgl_pelaksanaan`, `waktu_pelaksanaan`, `dilaksanakan_di`, `tipe_kegiatan`, `link_file`, `publikasikan`, `created_at`) VALUES
(1, 'Rapat Pimpinan', 'RUMAH SAKIT UMUM DAERAH MOHAMMAD NATSIR', '2023-08-16', '12:00', 'Aula Kantor Gubernur', '', '$data = [\r\n		\'nama_kegiatan\' =>$this->input->post(\'nama\'),\r\n        \'instansi_pelaksana\' =>$this->input->post(\'opd\'),\r\n        \'tgl_pelaksanaan\' =>$this->input->post(\'tgl\'),\r\n        \'waktu_pelaksanaan\' =>$this->input->post(\'jam\'),\r\n        \'dilaksanakan_di\' =>$this->input->post(\'lokasi\'),\r\n        \'link_file\' =>$this->input->post(\'link\'),\r\n        \'publikasikan\' =>$this->input->post(\'publish\'),\r\n        \'created_at\' =>timestamp(),\r\n		];', 'Ya', '2023-08-21 10:07:35'),
(3, 'Rapat Pimpinan', 'RUMAH SAKIT JIWA PROF. HB. SAANIN', '2023-08-05', '12:00', 'di', '', 'https://drive.google.com/drive/folders/1UUwdZ-EUkGOPWDes3v3l3eIwJNCYuwND?usp=sharing', 'Tidak', '2023-08-21 09:50:10'),
(4, 'vfsavfadsvfasfsafacsfasfcasfc', 'RUMAH SAKIT UMUM DAERAH PARIAMAN', '2023-08-22', '12:00', 'Disana', '', '$this->input->post(\'link\')', 'Ya', '2023-08-21 10:01:56'),
(5, 'Rapat Pimpinan', 'RUMAH SAKIT JIWA PROF. HB. SAANIN', '2023-08-05', '12:00', 'di', '', 'https://drive.google.com/drive/folders/1UUwdZ-EUkGOPWDes3v3l3eIwJNCYuwND?usp=sharing', 'Tidak', '2023-08-21 10:01:26'),
(6, 'Rapat Pimpinan bulanan', 'RUMAH SAKIT JIWA PROF. HB. SAANIN', '2023-08-05', '12:00', 'di', '', 'https://drive.google.com/drive/folders/1UUwdZ-EUkGOPWDes3v3l3eIwJNCYuwND?usp=sharing', 'Tidak', '2023-08-21 10:01:38');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `file`
--
ALTER TABLE `file`
  ADD PRIMARY KEY (`id_file`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `file`
--
ALTER TABLE `file`
  MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
