· 4 years ago · Aug 11, 2021, 06:22 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 11 Agu 2021 pada 08.13
7-- Versi Server: 5.6.26
8-- PHP Version: 5.6.12
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 utf8mb4 */;
18
19--
20-- Database: `pro_antrian`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `tb_antrian`
27--
28
29CREATE TABLE IF NOT EXISTS `tb_antrian` (
30 `id_antrian` int(11) NOT NULL,
31 `no_loket` int(11) NOT NULL,
32 `no_antrian` int(11) NOT NULL,
33 `tgl` date NOT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data untuk tabel `tb_antrian`
38--
39
40INSERT INTO `tb_antrian` (`id_antrian`, `no_loket`, `no_antrian`, `tgl`) VALUES
41(1, 1, 4, '2020-08-05'),
42(2, 1, 27, '2019-08-19');
43
44-- --------------------------------------------------------
45
46--
47-- Struktur dari tabel `tb_loket`
48--
49
50CREATE TABLE IF NOT EXISTS `tb_loket` (
51 `id_loket` int(11) NOT NULL,
52 `no_loket` varchar(10) NOT NULL,
53 `nama_loket` varchar(255) NOT NULL,
54 `aktif` int(11) NOT NULL
55) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
56
57--
58-- Dumping data untuk tabel `tb_loket`
59--
60
61INSERT INTO `tb_loket` (`id_loket`, `no_loket`, `nama_loket`, `aktif`) VALUES
62(1, '1', 'pembuatan', 1),
63(2, '2', 'perpanjangan', 1);
64
65-- --------------------------------------------------------
66
67--
68-- Struktur dari tabel `tb_media`
69--
70
71CREATE TABLE IF NOT EXISTS `tb_media` (
72 `id_media` int(11) NOT NULL,
73 `nama` varchar(255) NOT NULL,
74 `file` varchar(255) NOT NULL,
75 `tgl_upload` date NOT NULL
76) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
77
78--
79-- Dumping data untuk tabel `tb_media`
80--
81
82INSERT INTO `tb_media` (`id_media`, `nama`, `file`, `tgl_upload`) VALUES
83(1, 'My Video', 'video.mp4', '2019-07-03');
84
85-- --------------------------------------------------------
86
87--
88-- Struktur dari tabel `tb_pengguna`
89--
90
91CREATE TABLE IF NOT EXISTS `tb_pengguna` (
92 `id_user` int(11) NOT NULL,
93 `nama` varchar(50) NOT NULL,
94 `username` varchar(50) NOT NULL,
95 `password` varchar(100) NOT NULL,
96 `level` varchar(20) NOT NULL
97) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
98
99--
100-- Dumping data untuk tabel `tb_pengguna`
101--
102
103INSERT INTO `tb_pengguna` (`id_user`, `nama`, `username`, `password`, `level`) VALUES
104(11, 'admin', 'admin', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', 'admin'),
105(12, 'admin', 'admin', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', 'admin'),
106(13, 'admin', 'admin', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', 'admin');
107
108-- --------------------------------------------------------
109
110--
111-- Struktur dari tabel `tb_temp`
112--
113
114CREATE TABLE IF NOT EXISTS `tb_temp` (
115 `id_temp` int(11) NOT NULL,
116 `no_loket` int(11) NOT NULL,
117 `no_antrian` int(11) NOT NULL,
118 `tgl` date NOT NULL
119) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
120
121--
122-- Dumping data untuk tabel `tb_temp`
123--
124
125INSERT INTO `tb_temp` (`id_temp`, `no_loket`, `no_antrian`, `tgl`) VALUES
126(1, 1, 1, '2021-05-06'),
127(2, 2, 16, '2020-05-18');
128
129-- --------------------------------------------------------
130
131--
132-- Struktur dari tabel `tb_text`
133--
134
135CREATE TABLE IF NOT EXISTS `tb_text` (
136 `id_text` int(11) NOT NULL,
137 `isi_text` varchar(255) NOT NULL
138) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
139
140--
141-- Dumping data untuk tabel `tb_text`
142--
143
144INSERT INTO `tb_text` (`id_text`, `isi_text`) VALUES
145(1, 'Sudah terlalu asik sendiri..... |'),
146(2, 'Sudah terlalu asik dengan duniaku sendiri.... |'),
147(3, 'karna tak ada yang menemani... rasanya.... |');
148
149--
150-- Indexes for dumped tables
151--
152
153--
154-- Indexes for table `tb_antrian`
155--
156ALTER TABLE `tb_antrian`
157 ADD PRIMARY KEY (`id_antrian`);
158
159--
160-- Indexes for table `tb_loket`
161--
162ALTER TABLE `tb_loket`
163 ADD PRIMARY KEY (`id_loket`);
164
165--
166-- Indexes for table `tb_media`
167--
168ALTER TABLE `tb_media`
169 ADD PRIMARY KEY (`id_media`);
170
171--
172-- Indexes for table `tb_pengguna`
173--
174ALTER TABLE `tb_pengguna`
175 ADD PRIMARY KEY (`id_user`);
176
177--
178-- Indexes for table `tb_temp`
179--
180ALTER TABLE `tb_temp`
181 ADD PRIMARY KEY (`id_temp`);
182
183--
184-- Indexes for table `tb_text`
185--
186ALTER TABLE `tb_text`
187 ADD PRIMARY KEY (`id_text`);
188
189--
190-- AUTO_INCREMENT for dumped tables
191--
192
193--
194-- AUTO_INCREMENT for table `tb_antrian`
195--
196ALTER TABLE `tb_antrian`
197 MODIFY `id_antrian` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
198--
199-- AUTO_INCREMENT for table `tb_loket`
200--
201ALTER TABLE `tb_loket`
202 MODIFY `id_loket` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
203--
204-- AUTO_INCREMENT for table `tb_media`
205--
206ALTER TABLE `tb_media`
207 MODIFY `id_media` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
208--
209-- AUTO_INCREMENT for table `tb_pengguna`
210--
211ALTER TABLE `tb_pengguna`
212 MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
213--
214-- AUTO_INCREMENT for table `tb_temp`
215--
216ALTER TABLE `tb_temp`
217 MODIFY `id_temp` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
218--
219-- AUTO_INCREMENT for table `tb_text`
220--
221ALTER TABLE `tb_text`
222 MODIFY `id_text` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
223/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
224/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
225/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
226