-- http://www.phpmyadmin.net
--




--
-- Database: `parkir_sidoarjo`
--

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

--
-- Table structure for table `blok_ip`
--

CREATE TABLE IF NOT EXISTS `blok_ip` (
  `id_ip` int(254) NOT NULL AUTO_INCREMENT,
  `tanggal` datetime NOT NULL,
  `ipnya` varchar(254) NOT NULL,
  `lokasi_ip` varchar(254) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `kelamin`
--

CREATE TABLE IF NOT EXISTS `kelamin` (
  `id_kelamin` int(254) NOT NULL AUTO_INCREMENT,
  `jenis_kelamin` varchar(254) NOT NULL,
  PRIMARY KEY (`id_kelamin`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `kelamin`
--

INSERT INTO `kelamin` (`id_kelamin`, `jenis_kelamin`) VALUES
(1, 'LAKI - LAKI'),
(2, 'PEREMPUAN');

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

--
-- Table structure for table `laporan_parkir`
--

CREATE TABLE IF NOT EXISTS `laporan_parkir` (
  `id_laporan` bigint(254) NOT NULL AUTO_INCREMENT,
  `masuk` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `keluar` datetime NOT NULL,
  `jenis_kendaraan` varchar(254) NOT NULL,
  `nopol` varchar(254) NOT NULL,
  `img_masuk` text NOT NULL,
  `img_keluar` text NOT NULL,
  `barcode` varchar(254) NOT NULL,
  `pembayaran` bigint(254) NOT NULL,
  `admin_id` varchar(254) NOT NULL,
  `nama_lengkap` varchar(254) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id_laporan`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `laporan_parkir`
--

INSERT INTO `laporan_parkir` (`id_laporan`, `masuk`, `keluar`, `jenis_kendaraan`, `nopol`, `img_masuk`, `img_keluar`, `barcode`, `pembayaran`, `admin_id`, `nama_lengkap`, `status`) VALUES
(1, '2022-12-20 04:21:31', '2022-12-20 11:42:25', 'MOBIL', 'B6780PK', '../foto_parkir/tes1.png', '', '112233PL', 5000, '1', 'PROGRAMMER', 0);

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

--
-- Table structure for table `maintenance`
--

CREATE TABLE IF NOT EXISTS `maintenance` (
  `id` int(254) NOT NULL AUTO_INCREMENT,
  `tahun` year(4) NOT NULL,
  `bulan` int(254) NOT NULL,
  `hari` int(254) NOT NULL,
  `aktif` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `maintenance`
--

INSERT INTO `maintenance` (`id`, `tahun`, `bulan`, `hari`, `aktif`) VALUES
(1, 2022, 10, 1, 0),
(2, 2022, 10, 1, 0);

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

--
-- Table structure for table `nominal_bayar_parkir`
--

CREATE TABLE IF NOT EXISTS `nominal_bayar_parkir` (
  `id_bayar` bigint(254) NOT NULL AUTO_INCREMENT,
  `jenis_kendaraan` varchar(254) NOT NULL,
  `harga` bigint(254) NOT NULL,
  PRIMARY KEY (`id_bayar`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `nominal_bayar_parkir`
--

INSERT INTO `nominal_bayar_parkir` (`id_bayar`, `jenis_kendaraan`, `harga`) VALUES
(1, 'MOTOR', 2000),
(2, 'MOBIL', 5000);

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

--
-- Table structure for table `notifikasi`
--

CREATE TABLE IF NOT EXISTS `notifikasi` (
  `id_notifikasi` int(254) NOT NULL AUTO_INCREMENT,
  `tanggal_notifikasi` datetime NOT NULL,
  `jenis_laporan` varchar(254) NOT NULL,
  `status_laporan` varchar(254) NOT NULL,
  `id_laporan` varchar(254) NOT NULL,
  `user_id` varchar(254) NOT NULL,
  `admin_id` varchar(254) NOT NULL,
  `judul_notifikasi` varchar(254) NOT NULL,
  `isi_notifikasi` text NOT NULL,
  `read_user` int(1) NOT NULL,
  `hapus_user` int(11) NOT NULL,
  PRIMARY KEY (`id_notifikasi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `office`
--

CREATE TABLE IF NOT EXISTS `office` (
  `id_office` int(254) NOT NULL AUTO_INCREMENT,
  `nama_office` varchar(254) NOT NULL,
  `alamat_office` text NOT NULL,
  `kota_office` varchar(254) NOT NULL,
  `propinsi_office` varchar(254) NOT NULL,
  `telp_office` varchar(40) NOT NULL,
  `sms_office` varchar(40) NOT NULL,
  `fax_office` varchar(40) NOT NULL,
  `mail_office` varchar(254) NOT NULL,
  `logo` text NOT NULL,
  `logo_cetak` text NOT NULL,
  `foto_office` text NOT NULL,
  `latitude` float(10,6) NOT NULL,
  `longitude` float(10,6) NOT NULL,
  `appid` varchar(254) NOT NULL,
  `app_name` varchar(254) NOT NULL,
  `ver` varchar(254) NOT NULL,
  `vb_name` varchar(254) NOT NULL,
  `vb_ver` varchar(254) NOT NULL,
  `web_keyword` text NOT NULL,
  PRIMARY KEY (`id_office`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `office`
--

INSERT INTO `office` (`id_office`, `nama_office`, `alamat_office`, `kota_office`, `propinsi_office`, `telp_office`, `sms_office`, `fax_office`, `mail_office`, `logo`, `logo_cetak`, `foto_office`, `latitude`, `longitude`, `appid`, `app_name`, `ver`, `vb_name`, `vb_ver`, `web_keyword`) VALUES
(1, 'SOFTWARE PARKING SIDOARJO', 'Jl. ', 'SIDOARJO', 'JAWA TIMUR', '031', '0811', '031', 'parkiransps@gmail.com', '../logo/logo.png', '../logo/logo.png', '', -7.281485, 112.714134, '', '', '', 'parkir_sidoarjo', '1.0', '');

