xxsZ6399

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jun 25, 2018 at 10:28 AM
7-- Server version: 5.6.21
8-- PHP Version: 5.6.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `bankdata`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `data_penyedia`
27--
28
29CREATE TABLE IF NOT EXISTS `data_penyedia` (
30`id` int(11) NOT NULL,
31  `nama` varchar(60) NOT NULL,
32  `alamat` text NOT NULL,
33  `lat` varchar(50) NOT NULL,
34  `lng` varchar(50) NOT NULL,
35  `no_telp` varchar(15) NOT NULL,
36  `email` varchar(100) NOT NULL,
37  `pengurus` varchar(150) NOT NULL,
38  `foto` varchar(255) NOT NULL
39) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
40
41--
42-- Dumping data for table `data_penyedia`
43--
44
45INSERT INTO `data_penyedia` (`id`, `nama`, `alamat`, `lat`, `lng`, `no_telp`, `email`, `pengurus`, `foto`) VALUES
46(3, 'Bardi', 'Klangon Argosari Sedayu', '', '', '08900000', 'am@mail.com', 'sss', ''),
47(6, 'Adnan', 'Imogiri', '', '', '089999999', 'adnan@mail.com', 'aaaa', ''),
48(7, 'Bambang', 'aaa', '', '', 'aaa', 'aaa', 'aaaa', '');
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `login`
54--
55
56CREATE TABLE IF NOT EXISTS `login` (
57  `username` varchar(40) NOT NULL,
58  `password` varchar(40) NOT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60
61--
62-- Dumping data for table `login`
63--
64
65INSERT INTO `login` (`username`, `password`) VALUES
66('admin', 'adminulpbantul');
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `peralatan`
72--
73
74CREATE TABLE IF NOT EXISTS `peralatan` (
75`no` int(11) NOT NULL,
76  `id` int(11) NOT NULL,
77  `jenis` varchar(75) NOT NULL,
78  `kapasitas` int(11) NOT NULL,
79  `jumlah` int(11) NOT NULL,
80  `merk` varchar(50) NOT NULL,
81  `kondisi` varchar(100) NOT NULL,
82  `posisi` varchar(255) NOT NULL,
83  `ket` varchar(255) NOT NULL
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `personel`
90--
91
92CREATE TABLE IF NOT EXISTS `personel` (
93`id_personel` int(11) NOT NULL,
94  `id` int(11) NOT NULL,
95  `nama` varchar(75) NOT NULL,
96  `tempat_lahir` varchar(40) NOT NULL,
97  `tgl_lahir` date NOT NULL,
98  `j_kel` enum('Laki-laki','Perempuan') NOT NULL,
99  `status_peg` varchar(45) NOT NULL,
100  `status_aktif` enum('Aktif','Tidak Aktif') NOT NULL,
101  `ket` varchar(255) NOT NULL
102) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
103
104-- --------------------------------------------------------
105
106--
107-- Table structure for table `riwayat`
108--
109
110CREATE TABLE IF NOT EXISTS `riwayat` (
111`no` int(11) NOT NULL,
112  `id` int(11) NOT NULL,
113  `tanggal` date NOT NULL,
114  `nama_instansi` varchar(150) NOT NULL,
115  `jml_nominal` int(11) NOT NULL
116) ENGINE=InnoDB DEFAULT CHARSET=latin1;
117
118--
119-- Indexes for dumped tables
120--
121
122--
123-- Indexes for table `data_penyedia`
124--
125ALTER TABLE `data_penyedia`
126 ADD PRIMARY KEY (`id`);
127
128--
129-- Indexes for table `login`
130--
131ALTER TABLE `login`
132 ADD PRIMARY KEY (`username`);
133
134--
135-- Indexes for table `peralatan`
136--
137ALTER TABLE `peralatan`
138 ADD PRIMARY KEY (`no`), ADD KEY `id` (`id`);
139
140--
141-- Indexes for table `personel`
142--
143ALTER TABLE `personel`
144 ADD PRIMARY KEY (`id_personel`), ADD KEY `id` (`id`);
145
146--
147-- Indexes for table `riwayat`
148--
149ALTER TABLE `riwayat`
150 ADD PRIMARY KEY (`no`), ADD KEY `id` (`id`);
151
152--
153-- AUTO_INCREMENT for dumped tables
154--
155
156--
157-- AUTO_INCREMENT for table `data_penyedia`
158--
159ALTER TABLE `data_penyedia`
160MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
161--
162-- AUTO_INCREMENT for table `peralatan`
163--
164ALTER TABLE `peralatan`
165MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;
166--
167-- AUTO_INCREMENT for table `personel`
168--
169ALTER TABLE `personel`
170MODIFY `id_personel` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
171--
172-- AUTO_INCREMENT for table `riwayat`
173--
174ALTER TABLE `riwayat`
175MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;
176--
177-- Constraints for dumped tables
178--
179
180--
181-- Constraints for table `peralatan`
182--
183ALTER TABLE `peralatan`
184ADD CONSTRAINT `peralatan_ibfk_1` FOREIGN KEY (`id`) REFERENCES `data_penyedia` (`id`);
185
186--
187-- Constraints for table `personel`
188--
189ALTER TABLE `personel`
190ADD CONSTRAINT `personel_ibfk_1` FOREIGN KEY (`id`) REFERENCES `data_penyedia` (`id`);
191
192--
193-- Constraints for table `riwayat`
194--
195ALTER TABLE `riwayat`
196ADD CONSTRAINT `riwayat_ibfk_1` FOREIGN KEY (`id`) REFERENCES `data_penyedia` (`id`);
197
198/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
199/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
200/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;