-- 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', '');

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

--
-- Table structure for table `user_admin`
--

CREATE TABLE IF NOT EXISTS `user_admin` (
  `admin_id` int(254) NOT NULL AUTO_INCREMENT,
  `username` varchar(254) NOT NULL,
  `password` varchar(254) NOT NULL,
  `pass` varchar(254) NOT NULL,
  `nama_lengkap` varchar(254) NOT NULL,
  `jenis_kelamin` varchar(50) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` varchar(254) NOT NULL,
  `no_telp` varchar(60) NOT NULL,
  `mail` varchar(254) NOT NULL,
  `foto_admin` text NOT NULL,
  `latitude` float(10,6) NOT NULL,
  `longitude` float(10,6) NOT NULL,
  `login` int(1) NOT NULL,
  `status` int(1) NOT NULL,
  `kode` varchar(254) NOT NULL,
  `ip_online` varchar(254) NOT NULL,
  `last_time` datetime NOT NULL,
  `lockscreen` int(1) NOT NULL,
  `admin` int(1) NOT NULL,
  `imei_device` text NOT NULL,
  `operator_phone` varchar(254) NOT NULL,
  `ponseltype` varchar(254) NOT NULL,
  `versi_os` varchar(254) NOT NULL,
  `serialphone` varchar(254) NOT NULL,
  `token_user` varchar(254) NOT NULL,
  `token_login` text NOT NULL,
  `hapus` int(1) NOT NULL,
  PRIMARY KEY (`admin_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `user_admin`
--

INSERT INTO `user_admin` (`admin_id`, `username`, `password`, `pass`, `nama_lengkap`, `jenis_kelamin`, `tanggal_lahir`, `alamat`, `no_telp`, `mail`, `foto_admin`, `latitude`, `longitude`, `login`, `status`, `kode`, `ip_online`, `last_time`, `lockscreen`, `admin`, `imei_device`, `operator_phone`, `ponseltype`, `versi_os`, `serialphone`, `token_user`, `token_login`, `hapus`) VALUES
(1, '001', 'ea13836c3629aa4ed9d1fac9005f7176', 'sempak123456', 'PROGRAMMER', 'LAKI - LAKI', '2022-07-21', 'jl. setapak', '081', '', '../foto_admin/20220721_172949_1_PROGRAMMER.png', 0.000000, 0.000000, 1, 0, 'makmur_jaya', '36.73.245.200', '2022-12-20 12:28:54', 0, 1, '', '', '', '', '', '', 'ev1zs3okex1blopxq6j8fjd9bobsmvk1ql0jpo44m5g8u55lcpts862kvdci8wjziki89mcvrt3li96bi04766r2k4ks13sjoasxw5toixax6h95hdcok3q48ax9eps2zl0wqulpsvmidw4u9gjukaiskw2zlv2lg3i7x3wpzjocft7paqku0jnlfqk1lnm1q49o86d7p2j5vqv5gf0hio3denfzb1116apeh3l665c2v78cm8ulxxzclecwgeimoo16rncisp0ow81jhv5fs4rei3aih8l6wncoapm3ensbvtvdp0si4jwnn7m5g8ccvp16eoatc358w0lm0d45x0tl7frno30js2q7r01336b07wm7ard8r6uzmlmaonuhqkohlpkpwwq3tcb33ocvv6uirhsg5nxv7mctcxi8t8cmlnqpc2l89gq1xji36gze2b7f9qn2i0pknf90iu8sait8iccosb3unaaw0izziojl3tmmnueit87bkj0cu47heheffdfd1iz5slsfg6e9fllz5mczqkh52vlh90vbzvgrh87ifm7u7tudg7d6ructqibzi7bi2rpk0xigjqbrj640dh75bjz2ha2ghdek54461nnkdicx5gxix4o9onc6iemfs10x6447rrs5q42wlzfi33ssq4iojl4bm49t9d115u6wz8sk873cbv41z2qjovub0349h5bnzhjiqciijlauhfwhin06juhjiltgr43qmnpdz8cjuneb2btkztrio82nuv3m06dnt20tacc40rg229n23ekrnmeiih4joh6ik7bvko0kggnjqaltp5kcszvbh0v6i1o290xuoxf4e2n4d9x2fif8iajzbe5tguvqutkjrzo62bafl8h0rx898r9j6fcna8d42inuxb0znbf8kx8buhl28vlfbi2l6fp9dd3bp3bdeqmiovaicwklr60253ocjdlxro8hsku7bg6zbhhod2949a7edvqw', 0),
(2, 'administrator', '', '', '', '', '0000-00-00', '', '', '', '', 0.000000, 0.000000, 0, 0, 'makmur_jaya', '180.254.41.93', '2020-01-29 20:37:14', 0, 0, '', '', '', '', '', '', '', 0),
(3, 'super', '', '', '', '', '0000-00-00', '', '', '', '', 0.000000, 0.000000, 0, 0, 'makmur_jaya', '0', '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', '', 0),
(4, 'superadmin', '', '', '', '', '0000-00-00', '', '', '', '', 0.000000, 0.000000, 0, 0, 'makmur_jaya', '0', '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', '', 0),
(5, 'superuser', '', '', '', '', '0000-00-00', '', '', '', '', 0.000000, 0.000000, 0, 0, 'makmur_jaya', '', '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', '', 0),
(6, '007', '72209edab3ae9cb08c8f1c356038bcc0', 'printilku', 'VIRADY', 'LAKI - LAKI', '0000-00-00', 'JL. BIBIS KARAH', '81', '', '../foto_admin/2017-09-15_123.png', -7.318022, 112.727875, 1, 0, 'makmur_jaya', '36.85.31.6', '2022-10-23 14:31:11', 0, 1, '867815039255230', 'TELKOMSEL', 'OPPO-CPH1723', 'Nougat v7.1, API Level: 25', 'YPQSWSHAFEF6JVQ4', 'e3ui59k2UMY:APA91bHaeBKDYrd2Vvt9arUe6niheoYPO6IP3DxjJxj2qXJP27VE1dvelDNVVHXl-nryGrOxN6kOLmBNgr2zY8g1xzgyAzjG08hq9HEGzp2gddcGpVmcjwMLiKPTKkjjEIal3oVmuYjH', '433hpxphmmfqv2ho96upogivtbutmv0qz48p1i6olmfhox6i30nrgmnaih4kd4bd9k2bi803ugljdrhhs489qvjodn9rsk4146dnedr9tcs73aovfx46snv6b4x3p15u8iinw9wpmpxq0lmfiqlbegiqlftbhi6phocdi93ki0aimwe4nzg2gis1emdvkjl17xf56iq5i144xi9lipoiog032dinxkp4i4apm0u51z9zhjlz99xxqi0sbzf9k5d29orwpl1rlar2uc23mz0ci14a1kjlpxozlfva1w1m7so15q5rq53p78z9tivjfji1iebzbdmi6bkc2p3tv7i3fhc807sfqahposp06bjdn3ppttip01sgi5pidhi3sfth8ihfu0ti4i7xcqndrgtaljti0r2t7vagerv9sorw7zukphxhxrrjakhbck4jff0u7w4zlwwsvqdl8a261upcf7nrrsb77b1e76et2amx1zj99mfbg5nvcan33iaaacpii3bkexifw2o6o4h5940mfnpimztwcjfunqf1nxhkz6qoa8tkdu6shwb4v418og2b6hcufuef053adwvqq2j8iuduze2ou4z1mcw16bg6gkhugdl7f4gdzu7z89n3dm5zz115chct1uni78qmd6zd17c9g0dumiumkvrwd4qeidx5mnszurcvzp5fpjac14im0qjdu9ssmpi9dq98il4hb9w0t6cvbbhb10ow9gow6m5kdesv0wcb69czgpur0b22crim8nieaozn2ri3oufu4rukhobi0ekd6jze6htg6s39jmc8hr2ljw50lhimv3z2migtga9n2dwm08uh0x2ku8kfp32l71nu04nhex4ha03a8is9vvtp3e5ti7fq92k977ql4u2fv6q45id0d7qglwa44pudsenzmdlr8o63vw70fl1ssr9eojis9c52rt1d7n5fcbj78r7oc8g50qjoa2hjfnl6gnknbp3n1mva', 0),
(8, 'operator', 'e10adc3949ba59abbe56e057f20f883e', '123456', 'OPERATOR PARKIR', 'LAKI - LAKI', '0000-00-00', 'Jl. Setapak', '81', '', '', -7.121618, 112.419960, 1, 0, 'makmur_jaya', '36.81.161.89', '2022-12-02 10:11:25', 0, 2, '', '', '', '', '', '', 'li3biam9cz2i7752tw3mi7ohbm5eot1ac4laf8kr7mpftvinslaqti84kdi97jjko5u3dfuk1k0vfij73tiws71dljmt36drb8vonp9o99kps3xvxvsp3u2oeohhuu9625uqu4f4dzt53q10muppose3gvlbqvht0cjvgzzuit02k237xtxmlbp27adx5vr58b0pa0k9tkbdnfkk8h6ttvv069ib5pgd1h3bhnla8xovc9gkrndkj9kpij0o8h2az5lgs7r14gxgpd1g0f1kom9759verxoq2a7vhiwmet3474k8jls771edbar37ft9q157z2uewxi313clo5tw689ii1mpggz7h5eh78v36d78gjt5pn2wvceed04uh31i9gfgoakvor35bxa0kcwgpbu2ciwt2xsbd7s2icx631bfimgizdiootq1rnvtkn5iux0d9ijdzvtxh9ghmf5b8wdzj8t4vz2qw3362nj2jd01mgi9vol4ki446x82wbttfxzhkjj3wj5j0nswbe0wc40j29likeszcrhwb007j6qktjg5xg1al2tnbemwtew66d3hd3ox9fh3zi8xea7zd1npg9l9ohfuvjb8n06xgo0fm9d1kl1xmom2i8cmqsglbsuis0v8ovob52cpndm919bzhnl7f2squmonmjwbflmkni9acvjd4udmiztx1lnw8ckvvg7a1tups3z4zji4dvqwvktw6htetd9ougzvatk3xk8x3q2hmsdid7ejo8xhm76go5bzzw2whaul1w2opg62nlmbtjtfrzvg47f34h0msv7traihqojea5q3pjjhjfxnncrsusemnmgfwzwnng1xls1bbltu0qio3agi2vkqh15e121oi3m4vof6981azki2uf0xalnsnt6ov7ddb0h6oxdx6f85z78tm8rxufpi8v643kiek0l8xi64de9clh68qx5lcv3lrapuu89e8un6tta68jju1p2sn7d0', 0);

