Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- 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: `dbcoba`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `ci_sessions`
- --
- CREATE TABLE `daerah` (
- `iddaerah` int(11) NOT NULL,
- `namadaerah` varchar(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `daerah`
- --
- INSERT INTO `daerah` (`iddaerah`, `namadaerah`) VALUES
- (1, 'Kabupaten Agam'),
- (2, 'Kota Bukittinggi'),
- (3, 'Kabupaten Dharmasraya'),
- (4, 'Kabupaten Kepulauan Mentawai'),
- (5, 'Kabupaten Lima Puluh Kota'),
- (6, 'Kota Padang'),
- (7, 'Kota Padang Panjang'),
- (8, 'PADANG PARIAMAN KAB'),
- (9, 'PARIAMAN KOTA'),
- (10, 'PASAMAN BARAT KAB'),
- (11, 'PASAMAN KAB'),
- (12, 'PAYAKUMBUH KOTA'),
- (13, 'PESISIR SELATAN KAB'),
- (14, 'PROV. SUMATERA BARAT'),
- (15, 'SAWAHLUNTO KOTA'),
- (16, 'SIJUNJUNG KAB'),
- (17, 'SOLOK KAB'),
- (18, 'SOLOK KOTA'),
- (19, 'SOLOK SELATAN KAB'),
- (20, 'TANAH DATAR KAB');
- -- --------------------------------------------------------
- --
- -- Table structure for table `infrastruktur`
- --
- CREATE TABLE `infrastruktur` (
- `idinfrastruktur` int(11) NOT NULL,
- `namainfrastruktur` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `infrastruktur`
- --
- INSERT INTO `infrastruktur` (`idinfrastruktur`, `namainfrastruktur`) VALUES
- (9, 'Jalan'),
- (10, 'Irigasi'),
- (11, 'Drainase'),
- (12, 'Lainnya'),
- (13, 'Bangunan'),
- (14, 'Jembatan');
- -- --------------------------------------------------------
- --
- -- Table structure for table `input`
- --
- CREATE TABLE `input` (
- `idinput` int(11) NOT NULL,
- `daerah_i` int(11) NOT NULL,
- `pekerjaan_i` int(11) NOT NULL,
- `jasa_i` int(11) NOT NULL,
- `infrastruktur_i` int(11) NOT NULL,
- `tahun` varchar(10) NOT NULL,
- `jmltahli` varchar(10) NOT NULL,
- `jmltterampil` varchar(10) NOT NULL,
- `nilai` varchar(30) NOT NULL,
- `operator` varchar(30) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `input`
- --
- INSERT INTO `input` (`idinput`, `daerah_i`, `pekerjaan_i`, `jasa_i`, `infrastruktur_i`, `tahun`, `jmltahli`, `jmltterampil`, `nilai`, `operator`) VALUES
- (28, 6, 3, 14, 9, '2013', '0', '0', '370000000', 'anton joni saputra'),
- (29, 6, 3, 14, 10, '2013', '0', '0', '317000000', 'anton joni saputra'),
- (30, 6, 3, 14, 11, '2013', '0', '0', '450000000', 'anton joni saputra'),
- (31, 6, 3, 14, 13, '2014', '0', '0', '323000000', 'anton joni saputra'),
- (32, 6, 3, 14, 9, '2014', '0', '0', '550000000', 'anton joni saputra'),
- (33, 6, 3, 14, 11, '2014', '0', '0', '450000000', 'anton joni saputra'),
- (34, 6, 3, 14, 13, '2015', '0', '0', '655500000', 'anton joni saputra'),
- (35, 6, 3, 14, 14, '2015', '0', '0', '127500000', 'anton joni saputra'),
- (36, 6, 3, 14, 9, '2015', '0', '0', '467500000', 'anton joni saputra'),
- (37, 6, 3, 14, 10, '2015', '0', '0', '226163950', 'anton joni saputra'),
- (38, 6, 3, 14, 11, '2015', '0', '0', '471000000', 'anton joni saputra'),
- (39, 6, 3, 14, 12, '2015', '0', '0', ' 4191200000 ', 'anton joni saputra'),
- (40, 6, 3, 14, 13, '2016', '0', '0', ' 145340000 ', 'anton joni saputra'),
- (41, 6, 3, 14, 14, '2016', '0', '0', ' 239488750 ', 'anton joni saputra'),
- (42, 6, 2, 10, 13, '2015', '0', '0', '55000000', 'anton joni saputra');
- -- --------------------------------------------------------
- --
- -- Table structure for table `jasa`
- --
- CREATE TABLE `jasa` (
- `idjasa` int(11) NOT NULL,
- `jenispekerjaan` int(11) NOT NULL,
- `jenisjasapekerjaan` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `jasa`
- --
- INSERT INTO `jasa` (`idjasa`, `jenispekerjaan`, `jenisjasapekerjaan`) VALUES
- (10, 2, 'Pembangunan'),
- (11, 2, 'Peningkatan'),
- (12, 2, 'Pemeliharaan'),
- (13, 3, 'Pengawasan'),
- (14, 3, 'Perencanaan'),
- (15, 3, 'Study / kajian'),
- (16, 4, 'Pengadaan');
- -- --------------------------------------------------------
- --
- -- Table structure for table `pekerjaan`
- --
- CREATE TABLE `pekerjaan` (
- `idjenispekerjaan` int(11) NOT NULL,
- `jenis_pekerjaan` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `pekerjaan`
- --
- INSERT INTO `pekerjaan` (`idjenispekerjaan`, `jenis_pekerjaan`) VALUES
- (2, 'Kontruksi'),
- (3, ' Konsultan'),
- (4, 'Barang dan Jasa');
- -- --------------------------------------------------------
- --
- -- Table structure for table `user`
- --
- CREATE TABLE `user` (
- `id` int(2) NOT NULL,
- `username` varchar(30) NOT NULL,
- `password` text NOT NULL,
- `nama` text NOT NULL,
- `level` varchar(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `user`
- --
- INSERT INTO `user` (`id`, `username`, `password`, `nama`, `level`) VALUES
- (1, 'admin', '1a1d7066fdc41001b876363c2f8daba891c3ab42b449500aadd363cbb917de95c57d96ede9461c41810dc192bdf232f463dc0e20b6ca5768aef244fb4f1ae892', 'anton joni saputra', 'admin'),
- (6, 'male', '374144bdd07a201e995e9a4ed236a4c63297a501172267ee3f785112832429faef4e8a257f5e7fc8ad9ab0df6fef83cdb423d2d77d1007ca3a9cfabcd313eae9', 'agus', 'operator'),
- (7, 'bogil', '6e842fb9c7bb330f748231bb4798866e7325070964a54ee8d34a64046f270b046fb8f1bd22aee9c427aded5304ef29cf6cabc1af3a9bc642641325b0611209a7', 'antonx', 'operator');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `daerah`
- --
- ALTER TABLE `daerah`
- ADD PRIMARY KEY (`iddaerah`);
- --
- -- Indexes for table `infrastruktur`
- --
- ALTER TABLE `infrastruktur`
- ADD PRIMARY KEY (`idinfrastruktur`);
- --
- -- Indexes for table `input`
- --
- ALTER TABLE `input`
- ADD PRIMARY KEY (`idinput`);
- --
- -- Indexes for table `jasa`
- --
- ALTER TABLE `jasa`
- ADD PRIMARY KEY (`idjasa`);
- --
- -- Indexes for table `pekerjaan`
- --
- ALTER TABLE `pekerjaan`
- ADD PRIMARY KEY (`idjenispekerjaan`);
- --
- -- Indexes for table `user`
- --
- ALTER TABLE `user`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `daerah`
- --
- ALTER TABLE `daerah`
- MODIFY `iddaerah` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
- --
- -- AUTO_INCREMENT for table `infrastruktur`
- --
- ALTER TABLE `infrastruktur`
- MODIFY `idinfrastruktur` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
- --
- -- AUTO_INCREMENT for table `input`
- --
- ALTER TABLE `input`
- MODIFY `idinput` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
- --
- -- AUTO_INCREMENT for table `jasa`
- --
- ALTER TABLE `jasa`
- MODIFY `idjasa` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
- --
- -- AUTO_INCREMENT for table `pekerjaan`
- --
- ALTER TABLE `pekerjaan`
- MODIFY `idjenispekerjaan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `user`
- --
- ALTER TABLE `user`
- MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
- COMMIT;
Add Comment
Please, Sign In to add comment