-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 27, 2015 at 10:24 AM
-- Server version: 5.6.27-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `product_ciblogdb`
--

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

--
-- Table structure for table `assets`
--

CREATE TABLE IF NOT EXISTS `identitas` (
 `id_identitas` int(5) NOT NULL AUTO_INCREMENT,
  `nama_website` varchar(100) CHARACTER SET latin1 NOT NULL,
  `email` varchar(100) CHARACTER SET latin1 NOT NULL,
  `url` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `nama_fb` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `no_telp` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `meta_deskripsi` text CHARACTER SET latin1 NOT NULL,
  `meta_keyword` varchar(250) CHARACTER SET latin1 NOT NULL,
  `favicon` varchar(50) CHARACTER SET latin1 NOT NULL,
  `maps` text CHARACTER SET latin1 NOT NULL,
  `biaya_koma` int(10) DEFAULT NULL,
  `nama_satker` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `kode_badan_hukum` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `tanggal_pendirian` date DEFAULT NULL,
  `biaya_pos` int(10) DEFAULT NULL,
  `mulai_kuliah` date DEFAULT NULL,
  `ujian_semester` date DEFAULT NULL,
  `visi_misi` text COLLATE latin1_general_ci,
  `tujuan` text COLLATE latin1_general_ci,
  `sambutan` text COLLATE latin1_general_ci,
  `logo` varchar(75) COLLATE latin1_general_ci DEFAULT NULL,
  `alamat` varchar(125) COLLATE latin1_general_ci DEFAULT NULL,
  `nama_pimpinan` varchar(125) COLLATE latin1_general_ci DEFAULT NULL,
  `nama_app` varchar(200) COLLATE latin1_general_ci DEFAULT NULL,
  `nomor_rekening` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `nama_bank` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `pemilik_rekening` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `nama_kasir` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `nip_kasir` varchar(23) COLLATE latin1_general_ci DEFAULT NULL,
  `nama_kota` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`id_identitas`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

insert  into `identitas`(`id_identitas`,`nama_website`,`email`,`url`,`nama_fb`,`no_telp`,`meta_deskripsi`,`meta_keyword`,`favicon`,`maps`,`biaya_koma`,`nama_satker`,`kode_badan_hukum`,`tanggal_pendirian`,`biaya_pos`,`mulai_kuliah`,`ujian_semester`,`visi_misi`,`tujuan`,`sambutan`,`logo`,`alamat`,`nama_pimpinan`,`nama_app`,`nomor_rekening`,`nama_bank`,`pemilik_rekening`,`nama_kasir`,`nip_kasir`,`nama_kota`) values (1,'Aplikasi Panjar XXXXXXX','pa.palu@yahoo.co.id','http://pa-palu.go.id','','(0451) 421156','palu,perkara,sidang,gugatan,permohonan','Unismuh Palu','favicon.png','',0,'XXXXXXXX','24535','2018-12-04',55000,'2017-12-14','2019-01-29','<h3 style=\"text-align:center\"><strong>Visi</strong></h3>\r\n\r\n<p>Terwujudnya lembaga pendidikan tinggi agama islam terkemuka di Indonesia yang mampu mengembangkan dan mengintegrasikan aspek keislaman, keilmuan, kemanusiaan, dan keindonesiaan.</p>\r\n\r\n<h3 style=\"text-align:center\"><strong>Misi</strong></h3>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ol>\r\n	<li>Menyelenggarakan Tri Darma Perguruan Tinggi yang Islami dan berkualitas;</li>\r\n	<li>Mewujudkan insan akademis yang cerdas dan berakhlak mulia;</li>\r\n	<li>Menumbuhkambangkan etos ilmu, etos kerja dan etos pengabdian yang tinggi, serta berpartisipasi aktif dalam memberdayakan segenap potensi masyarakat.</li>\r\n</ol>\r\n','<p><strong>Tujuan</strong></p>\r\n\r\n<ol>\r\n	<li>saasdasd</li>\r\n	<li>dasdasd</li>\r\n</ol>\r\n','<p>Assalamualaikumwrwb.</p>\r\n\r\n<p>Silahkan Klik Tombol &quot;<strong>Mulai HITUNG Panjar</strong>&quot; untuk memulai menghitung Panjar Biaya Perkara ANDA.</p>\r\n\r\n<ol>\r\n	<li>Selanjutnya, Pilih Jenis Perkara Anda,</li>\r\n	<li>Ketik Nama Anda / Lawan</li>\r\n	<li>Pilih Kategori (Penggugat atau Tergugat)</li>\r\n	<li>Ketik Awalan Kelurahan Anda Tinggal, selanjutnya sistim akan mencari Nama Kelurahan sesuai huruf yang diketik,kemudian pilih, maka otomatis akan nampak nama kelurahan dan kecamatan ANda</li>\r\n	<li>selanjutnya Klik Tombol Simpan,</li>\r\n	<li>Ulangi Nomor 2 - 5 Untuk Pihak selanjutnya.</li>\r\n	<li>Jika Ingin Cetak hasilnya,silahkan Klik Tombol Cetak.</li>\r\n</ol>\r\n\r\n<p>Salam Super, Semoga Anda merasa senang, Kami Pun Senang...</p>\r\n','logo_512.png','Jl. WR Supratman No. 10, Kota Palu\r\n','Komar\'s','Aplikasi Panjar Mahkamah Sya\'iyah Banda Aceh','0060-01-001841-30-6','BRI ','Pengadilan Agama Palu','Akriyadi, S.H','198010122006041008','Sabang');

CREATE TABLE IF NOT EXISTS `user` (
  `id_user` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `cookie` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


insert  into `user`(`id_user`,`username`,`password`,`cookie`) values (1,'admin','81dc9bdb52d04dc20036dbd8313ed055','6lYufkEAQ3LCGpqz6sSb5rpnfDtgaozCnNxv7cx08H9RQeu9akLIrmAXhheBWMjP'),(2,'komar','81dc9bdb52d04dc20036dbd8313ed055','');

CREATE TABLE IF NOT EXISTS `transaksi` (
   `id_pihak` int(3) NOT NULL AUTO_INCREMENT,
  `jenis_perkara` varchar(75) DEFAULT NULL,
  `pihak` varchar(50) DEFAULT NULL,
  `detail` varchar(150) DEFAULT NULL,
  `total_biaya` int(15) DEFAULT NULL,
  `keterangan` int(3) DEFAULT NULL,
  PRIMARY KEY (`id_pihak`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `temp_pos` (
 `id` int(7) NOT NULL AUTO_INCREMENT,
  `id_kewenangan` int(2) DEFAULT NULL,
  `id_kel` int(2) DEFAULT NULL,
  `nama_pihak` varchar(100) DEFAULT NULL,
  `pemohon_termohon` varchar(30) DEFAULT NULL,
  `jumlah_panggilan` int(1) DEFAULT NULL,
  `biaya` int(12) DEFAULT NULL,
  `jumlah_panggilan_x_biaya` int(15) DEFAULT NULL,
  `kode_panjar` varchar(100) DEFAULT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `temp_panjar` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `id_kewenangan` int(2) DEFAULT NULL,
  `id_kel` int(2) DEFAULT NULL,
  `nama_pihak` varchar(100) DEFAULT NULL,
  `pemohon_termohon` varchar(30) DEFAULT NULL,
  `jumlah_panggilan` int(1) DEFAULT NULL,
  `biaya` int(12) DEFAULT NULL,
  `jumlah_panggilan_x_biaya` int(15) DEFAULT NULL,
  `kode_panjar` varchar(100) DEFAULT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `tb_pengguna` (
   `user_id` int(7) NOT NULL,
  `username` varchar(50) CHARACTER SET latin1 NOT NULL,
  `password` varchar(255) CHARACTER SET latin1 NOT NULL,
  `nama_lengkap` varchar(75) CHARACTER SET latin1 DEFAULT NULL,
  `pengguna_id` varchar(20) CHARACTER SET latin1 NOT NULL,
  `level` enum('1','2','3','4','5','6','7','8') CHARACTER SET latin1 NOT NULL COMMENT '1=admin , 2= Petugas Absen ,3= Petugas Administrasi ,4=Petugas Akademik, 5 = Petugas Keuangan, 6 = Dosen, 7 = Mahasiswa',
  `keterangan` varchar(5) CHARACTER SET latin1 NOT NULL,
  `last_login` datetime NOT NULL,
  `foto` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `blokir` enum('Y','N') CHARACTER SET latin1 DEFAULT NULL,
  `id_session` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `tanggal_perubahan` datetime DEFAULT NULL,
  `username_input` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `username_perubahan` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

insert  into `tb_pengguna`(`user_id`,`username`,`password`,`nama_lengkap`,`pengguna_id`,`level`,`keterangan`,`last_login`,`foto`,`blokir`,`id_session`,`tanggal_input`,`tanggal_perubahan`,`username_input`,`username_perubahan`) values (1,'admin','3e39b3844837bdefc8017fbcb386ea302af877fb17baa09d0a1bd34b67bbf2b34fba314bbcab450f5f3f73771b7aea956ba3320defda029723f4fdff7dfa007b','Super Admin','1','1','','0000-00-00 00:00:00',NULL,'N','9a362a91b4de4a313bed73647479200c','2017-07-23 23:23:29','2017-07-24 17:12:07','admin','admin'),(2,'kasir','3e39b3844837bdefc8017fbcb386ea302af877fb17baa09d0a1bd34b67bbf2b34fba314bbcab450f5f3f73771b7aea956ba3320defda029723f4fdff7dfa007b','Kasir','12124','2','','0000-00-00 00:00:00',NULL,'N','202cb962ac59075b964b07152d234b70','2018-08-01 15:02:27',NULL,'admin',NULL);


CREATE TABLE IF NOT EXISTS `tb_kelurahan_komdanas` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `satker_name` tinytext,
  `satker_code` varchar(10) DEFAULT NULL,
  `prop` varchar(10) DEFAULT NULL,
  `prop_name` varchar(100) DEFAULT NULL,
  `kabkota` varchar(100) DEFAULT NULL,
  `kec` varchar(100) DEFAULT NULL,
  `kel` varchar(100) DEFAULT NULL,
  `nomor_radius` int(3) DEFAULT NULL,
  `nilai` int(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `tb_kasir` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `nomor_perkara` varchar(25) DEFAULT NULL,
  `pihak_text` varchar(100) DEFAULT NULL,
  `tanggal_sidang` date DEFAULT NULL,
  `jurusita` varchar(100) DEFAULT NULL,
  `nama_kelurahan` varchar(100) DEFAULT NULL,
  `radius` int(10) DEFAULT NULL,
  `biaya_js` int(10) DEFAULT NULL,
  `biaya_kas` int(10) DEFAULT NULL,
  `tabayun` enum('Y','N') DEFAULT NULL,
  `biaya_tabayun` int(10) DEFAULT NULL,
  `tanggal_transaksi` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `tb_group_users` (
 `group_id` int(3) NOT NULL AUTO_INCREMENT,
  `nama_level` varchar(50) DEFAULT NULL,
  `level` int(1) DEFAULT NULL,
  `keterangan` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

insert  into `tb_group_users`(`group_id`,`nama_level`,`level`,`keterangan`) values (2,'Kasir / Bendahara',2,NULL),(6,'Administrator',1,NULL);


CREATE TABLE IF NOT EXISTS `sys_audittrail` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key: (by system)',
  `datetime` datetime NOT NULL COMMENT 'Waktu Aktifitas: (by system)',
  `ipaddress` varchar(15) NOT NULL DEFAULT '' COMMENT 'Alamat IP: (by system)',
  `username` varchar(30) NOT NULL DEFAULT '' COMMENT 'Username: (by system)',
  `tablename` varchar(250) NOT NULL DEFAULT '' COMMENT 'Nama Tabel: (by system)',
  `formname` varchar(250) DEFAULT '' COMMENT 'Nama Form Aplikasi: (by system)',
  `action` varchar(250) NOT NULL DEFAULT '' COMMENT 'Aktifitas: (by system)',
  `title` varchar(250) NOT NULL DEFAULT '' COMMENT 'Keterangan Aktifitas: (by system)',
  `description` longtext COMMENT 'Informasi detil Aktifitas: (by system)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `satker` (
 `id_satker` int(11) NOT NULL AUTO_INCREMENT,
  `kode` int(6) unsigned zerofill NOT NULL,
  `eselon` int(2) unsigned zerofill NOT NULL,
  `nama` varchar(256) COLLATE latin1_general_ci NOT NULL,
  `jalan` varchar(256) COLLATE latin1_general_ci NOT NULL,
  `kabkota` varchar(256) COLLATE latin1_general_ci NOT NULL,
  `prop` varchar(256) COLLATE latin1_general_ci NOT NULL,
  `kodepos` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
  `tlp` varchar(16) COLLATE latin1_general_ci DEFAULT NULL,
  `fax` varchar(16) COLLATE latin1_general_ci DEFAULT NULL,
  `web` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `mail` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `bank` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `rekening` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `rekening_an` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `tahun` varchar(25) COLLATE latin1_general_ci NOT NULL,
  `kasir` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `kasir_nip` varchar(18) COLLATE latin1_general_ci DEFAULT NULL,
  `kode_p` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
  `logo` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`id_satker`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

insert  into `satker`(`id_satker`,`kode`,`eselon`,`nama`,`jalan`,`kabkota`,`prop`,`kodepos`,`tlp`,`fax`,`web`,`mail`,`bank`,`rekening`,`rekening_an`,`tahun`,`kasir`,`kasir_nip`,`kode_p`,`logo`) values (1,307271,04,'Pengadilan Agama Kodya Palu','Jalan WR.Supratman No. 10 Palu','Palu','Sulawesi Tengah','94111','0451-421156','0451-458125','http://pa-palu.net','pa.palu@yahoo.co.id','Bank BRI','0399780029','Pengadilan Agama Palu','2017','pa.palu','197807112014082002','PA.PAL','logo_pn.png');

CREATE TABLE IF NOT EXISTS `radius` (
  `id_radius` int(11) NOT NULL AUTO_INCREMENT,
  `kategori_radius` varchar(10) NOT NULL,
  `nilai_radius` int(9) NOT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(50) DEFAULT NULL,
  `tanggal_perubahan` datetime DEFAULT NULL,
  `username_perubahan` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_radius`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
insert  into `radius`(`id_radius`,`kategori_radius`,`nilai_radius`,`tanggal_input`,`username_input`,`tanggal_perubahan`,`username_perubahan`) values (1,'I ',80000,NULL,NULL,NULL,NULL),(2,'II',90000,NULL,NULL,NULL,NULL),(3,'III',100000,NULL,NULL,NULL,NULL);

CREATE TABLE IF NOT EXISTS `komponen_biaya_satker` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama_komponen` varchar(150) NOT NULL,
  `jumlah` int(12) NOT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(100) DEFAULT NULL,
  `tanggal_perubahan` datetime DEFAULT NULL,
  `username_perubahan` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE INDEX id_index ON komponen_biaya_satker(`id`);
insert  into `komponen_biaya_satker`(`id`,`nama_komponen`,`jumlah`,`tanggal_input`,`username_input`) values (1,'Biaya Pendaftaran / PNBP',30000,NULL,NULL),(2,'Biaya Pemberkasan / ATK',50000,NULL,NULL),(3,'Materai',6000,NULL,NULL),(4,'Redaksi',5000,NULL,NULL);

CREATE TABLE IF NOT EXISTS `kewenangan_satker` (
   `id_kewenangan` int(2) NOT NULL AUTO_INCREMENT,
  `kode` int(3) DEFAULT NULL,
  `nama_kewenangan` varchar(255) DEFAULT NULL,
  `panggilan_p` int(1) DEFAULT NULL,
  `panggilan_t` int(1) DEFAULT NULL,
  `sebutan_p` varchar(50) DEFAULT NULL,
  `sebutan_t` varchar(50) DEFAULT NULL,
  `keterangan` varchar(250) DEFAULT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(50) DEFAULT NULL,
  `tanggal_perubahan` datetime DEFAULT NULL,
  `username_perubahan` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_kewenangan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE INDEX id_kewenangan_index ON kewenangan_satker(`id_kewenangan`);
insert  into `kewenangan_satker`(`id_kewenangan`,`kode`,`nama_kewenangan`,`panggilan_p`,`panggilan_t`,`sebutan_p`,`sebutan_t`,`keterangan`,`tanggal_input`,`username_input`,`tanggal_perubahan`,`username_perubahan`) values (1,10,'Pembatalan Perkawinan',2,3,'Penggugat','Tergugat',NULL,NULL,NULL,NULL,NULL),(2,20,'Izin Poligami',3,4,'Pemohon','Termohon',NULL,NULL,NULL,NULL,NULL),(3,30,'Kelalaian Atas Kewajiban Suami / Istri',2,2,'Pemohon','Pemohon',NULL,NULL,NULL,NULL,NULL),(4,40,'Cerai Talak',3,4,'pemohon','Termohon',NULL,NULL,NULL,'2018-04-03 08:38:08','komar'),(9,60,'Cerai Gugat',3,4,'Penggugat','Tergugat',NULL,NULL,NULL,NULL,NULL),(10,80,'Harta Bersama',3,4,'Penggugat','Tergugat',NULL,NULL,NULL,NULL,NULL),(11,100,'Penguasaan Anak',3,3,'PE','Te',NULL,NULL,NULL,NULL,NULL),(12,120,'Nafkah Anak Oleh Ibu karena Ayah tidak mampu',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(13,140,'Hak - hak bekas istri/kewajiban bekas Suami',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(14,160,'Pengesahan Anak',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(15,180,'Pencabutan Kekuasaan Orang Tua',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(16,200,'Pencabutan Kekuasaan Wali',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(17,220,'Penunjukan orang lain sebagai Wali oleh Pengadilan',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(18,240,'Ganti Rugi terhadap Wali',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(19,260,'Asal Usul Anak',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(20,280,'Perkawinan Campuran',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(21,300,'Pengesahan Perkawinan/Istbat Nikah',2,2,'pemohon','PEMOHON II',NULL,NULL,NULL,'2018-04-02 09:28:56','komar'),(22,320,'Dispensasi Kawin',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(23,340,'Wali Adhol',3,3,'pemohon','Termohon',NULL,NULL,NULL,'2018-04-02 09:34:14','komar'),(24,360,'Kewarisan',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(25,380,'Hibah',3,3,'PEt','TE',NULL,NULL,NULL,NULL,NULL),(26,400,'Wakaf',3,4,'pemohon','TERMOHON',NULL,NULL,NULL,'2018-04-02 08:10:48','komar'),(27,420,'Ekonomi Syariah',3,3,'PE','TE',NULL,NULL,NULL,NULL,NULL),(28,440,'P3HP/Penetapan Ahli Waris',3,2,'pemohon','TErmohon',NULL,NULL,NULL,'2018-03-30 16:53:20','komar');

CREATE TABLE IF NOT EXISTS `permintaan_biaya` (
  `id_permintaan` int(5) NOT NULL AUTO_INCREMENT,
  `pengguna_id` int(30) NOT NULL,
  `nomor_perkara` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `nama_pihak` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `sebagai` enum('1','2','3','4') CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `tanggal_sidang` date DEFAULT NULL,
  `rupiah` int(11) DEFAULT NULL,
  `biaya_jurusita` int(11) DEFAULT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `konfigurasi` (
  `id_konfigurasi` int(11) NOT NULL AUTO_INCREMENT,
  `nama_konfigurasi` varchar(40) NOT NULL,
  `type_konfigurasi` enum('Text','File','Uang') NOT NULL,
  `nilai_konfigurasi` text NOT NULL,
  PRIMARY KEY (`id_konfigurasi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

insert  into `konfigurasi`(`id_konfigurasi`,`nama_konfigurasi`,`type_konfigurasi`,`nilai_konfigurasi`) values (1,'Pengaturan Judul Website','Text','Aplikasi Kalkulator Panjar Biaya Perkara Tingkat Pertama Pengadilan Agama Palu'),(2,'Meta Deskripsi','Text','Aplikasi Kalkulator Panjar Biaya Perkara Tingkat Pertama Pengadilan Agama Palu'),(3,'Meta Keyword','Text','kalkulator panjar perkara, hitung panjar perkara, pengadilan agama Palu'),(4,'Footer','Text','Pengadilan Agama Palu'),(5,'Nama Pengadilan','Text','Pengadilan Agama Palu'),(6,'Nama Kabupaten','Text','Kota Palu'),(7,'Biaya Pendaftaran','Uang','30000'),(8,'Redaksi','Uang','5000'),(9,'Materai','Uang','6000'),(10,'Biaya Proses','Uang','50000'),(12,'Gambar Header','File','header2.png'),(13,'Favicon Website','File','logo.png'),(14,'nama_bank','Text','BRI Cabang Palu, Nomor Rekening : 128-1234566-98-49659 An. Pengadilan Agama Palu - Sulawesi Tengah');



CREATE TABLE IF NOT EXISTS `kelurahan` (
   `id_kel` int(11) NOT NULL AUTO_INCREMENT,
  `id_kec` int(11) NOT NULL,
  `nama_kel` varchar(150) NOT NULL,
  `id_radius` int(11) NOT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(50) DEFAULT NULL,
  `tanggal_perubahan` datetime DEFAULT NULL,
  `username_perubahan` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_kel`),
  KEY `id_radius` (`id_radius`),
  KEY `id_kec` (`id_kec`),
  CONSTRAINT `kelurahan_ibfk_1` FOREIGN KEY (`id_kec`) REFERENCES `kecamatan` (`id_kec`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `kelurahan_ibfk_2` FOREIGN KEY (`id_radius`) REFERENCES `radius` (`id_radius`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `kecamatan` (
  `id_kec` int(11) NOT NULL AUTO_INCREMENT,
  `nama_kec` varchar(150) NOT NULL,
  `tanggal_input` datetime DEFAULT NULL,
  `username_input` varchar(50) DEFAULT NULL,
  `tanggal_perubahan` datetime DEFAULT NULL,
  `username_perubahan` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_kec`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!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 */;
