· 6 years ago · Apr 02, 2019, 04:40 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Apr 02, 2019 at 06:35
7-- Server version: 5.6.20
8-- PHP Version: 5.5.15
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: `inventory`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `barang`
27--
28
29CREATE TABLE IF NOT EXISTS `barang` (
30`id` int(11) NOT NULL,
31 `kode_barang` varchar(5) NOT NULL,
32 `name` varchar(255) NOT NULL,
33 `harga` int(11) NOT NULL,
34 `stock_masuk` int(11) DEFAULT NULL,
35 `stock_keluar` int(11) DEFAULT NULL,
36 `category_id` int(11) NOT NULL,
37 `merk_id` int(11) NOT NULL,
38 `satuan_id` int(11) NOT NULL,
39 `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
40 `update_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
41) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;
42
43--
44-- Dumping data for table `barang`
45--
46
47INSERT INTO `barang` (`id`, `kode_barang`, `name`, `harga`, `stock_masuk`, `stock_keluar`, `category_id`, `merk_id`, `satuan_id`, `created_at`, `update_at`) VALUES
48(20, '112', 'Club rasa coklat', 15000, 10, NULL, 7, 5, 6, '2019-03-30 02:40:42', '2019-03-30 02:40:42'),
49(21, 'QS500', 'Teh Aqua rasa Strawberry', 5000, 25, 10, 7, 4, 5, '2019-03-30 03:47:10', '2019-03-30 03:47:10'),
50(22, 'a333', 'gatau', 50000, 10, 5, 9, 8, 7, '2019-04-02 02:50:40', '2019-04-02 02:50:40');
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `barang_keluar`
56--
57
58CREATE TABLE IF NOT EXISTS `barang_keluar` (
59`id` int(11) NOT NULL,
60 `barang_id` int(11) NOT NULL,
61 `jumlah` int(11) NOT NULL,
62 `status` char(1) DEFAULT NULL,
63 `keterangan` varchar(255) DEFAULT NULL,
64 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
65 `update_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
66) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;
67
68--
69-- Dumping data for table `barang_keluar`
70--
71
72INSERT INTO `barang_keluar` (`id`, `barang_id`, `jumlah`, `status`, `keterangan`, `created_at`, `update_at`) VALUES
73(16, 20, 1, NULL, 'botol kecil', '2019-03-28 00:00:00', '2019-03-30 00:00:00'),
74(17, 20, 1, NULL, 'botol kecil', '2019-03-28 00:00:00', '2019-03-30 00:00:00'),
75(18, 20, 10, NULL, 'botol besar', '2019-03-30 00:00:00', '2019-03-30 09:40:41'),
76(19, 21, 3, NULL, 'tes', '2019-03-30 00:00:00', '2019-03-30 10:42:46'),
77(20, 21, 3, NULL, 'tes', '2019-03-30 00:00:00', '2019-03-30 10:45:53'),
78(21, 21, 5, NULL, 'tes', '2019-03-30 00:00:00', '2019-03-30 10:47:10'),
79(22, 22, 5, NULL, 'gatau', '2019-04-02 00:00:00', '2019-04-02 09:50:40');
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `barang_masuk`
85--
86
87CREATE TABLE IF NOT EXISTS `barang_masuk` (
88`id` int(11) NOT NULL,
89 `barang_id` int(11) NOT NULL,
90 `jumlah` int(11) NOT NULL,
91 `status` char(1) DEFAULT NULL,
92 `supplier` varchar(255) NOT NULL,
93 `update_at` datetime NOT NULL,
94 `created_at` datetime NOT NULL,
95 `keterangan` varchar(255) DEFAULT NULL
96) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=84 ;
97
98--
99-- Dumping data for table `barang_masuk`
100--
101
102INSERT INTO `barang_masuk` (`id`, `barang_id`, `jumlah`, `status`, `supplier`, `update_at`, `created_at`, `keterangan`) VALUES
103(63, 19, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
104(64, 19, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
105(65, 19, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
106(66, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
107(67, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
108(68, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
109(69, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
110(70, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
111(71, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
112(72, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
113(73, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
114(74, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
115(75, 18, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
116(76, 17, 20, NULL, 'xfrends', '0000-00-00 00:00:00', '2019-03-28 00:00:00', 'botol kecil'),
117(77, 20, 20, NULL, 'xfrends', '2019-03-30 00:00:00', '2019-03-28 00:00:00', 'botol besar'),
118(78, 20, 10, NULL, 'test', '2019-03-30 00:00:00', '2019-03-30 00:00:00', 'test jeterangan'),
119(79, 20, 10, NULL, 'tes', '0000-00-00 00:00:00', '2019-03-30 00:00:00', 'botol besar'),
120(80, 21, 2, NULL, 'tes', '0000-00-00 00:00:00', '2019-03-30 00:00:00', 'tes'),
121(81, 21, 10, NULL, 'tes', '0000-00-00 00:00:00', '2019-03-30 00:00:00', 'tes'),
122(82, 21, 10, NULL, 'ucok', '0000-00-00 00:00:00', '2019-03-30 00:00:00', 'tes'),
123(83, 22, 10, NULL, 'gatau juga', '0000-00-00 00:00:00', '2019-04-02 00:00:00', 'gatau');
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `barang_reject`
129--
130
131CREATE TABLE IF NOT EXISTS `barang_reject` (
132`id` int(11) NOT NULL,
133 `kode_barang` int(11) NOT NULL,
134 `name` varchar(255) NOT NULL,
135 `supplier` varchar(255) NOT NULL,
136 `jumlah` int(11) NOT NULL,
137 `keterangan` int(11) NOT NULL,
138 `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
139 `update_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
140) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
141
142-- --------------------------------------------------------
143
144--
145-- Table structure for table `category`
146--
147
148CREATE TABLE IF NOT EXISTS `category` (
149`id` int(6) NOT NULL,
150 `name` varchar(255) NOT NULL,
151 `keterangan` tinytext,
152 `created_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
153 `updated_at` timestamp NULL DEFAULT NULL
154) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
155
156--
157-- Dumping data for table `category`
158--
159
160INSERT INTO `category` (`id`, `name`, `keterangan`, `created_at`, `updated_at`) VALUES
161(7, 'Minuman', 'Simpan di tempat kering dan hindari suhu panas', '2019-03-27 17:00:00', NULL),
162(9, 'Makanan', 'Hindari sinar matahari', '2019-03-30 02:45:21', '2019-03-29 17:00:00');
163
164-- --------------------------------------------------------
165
166--
167-- Table structure for table `merk`
168--
169
170CREATE TABLE IF NOT EXISTS `merk` (
171`id` int(11) NOT NULL,
172 `nama` varchar(255) NOT NULL,
173 `keterangan` varchar(255) NOT NULL,
174 `created_at` timestamp NULL DEFAULT NULL,
175 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
176) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
177
178--
179-- Dumping data for table `merk`
180--
181
182INSERT INTO `merk` (`id`, `nama`, `keterangan`, `created_at`, `updated_at`) VALUES
183(4, 'Aqua', 'Minuman air mineral', '2019-03-27 17:00:00', '2019-03-28 04:13:30'),
184(6, 'Vit', 'Minuman air mineral', '2019-03-27 17:00:00', '2019-03-28 04:15:12'),
185(7, 'Total', 'Minuman air mineral', '2019-03-27 17:00:00', '2019-03-28 04:15:18'),
186(8, 'Chitato', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:16:19'),
187(9, 'Mister Potato', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:16:46'),
188(10, 'Lays', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:17:04'),
189(11, 'Leo', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:17:09'),
190(12, 'Piatos', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:17:15'),
191(13, 'Qtela', 'Snack singkong', '2019-03-27 17:00:00', '2019-03-28 04:17:49'),
192(14, 'Kusuka', 'Snack Singkong', '2019-03-27 17:00:00', '2019-03-28 04:18:04'),
193(15, 'Chuba', 'Snack Singkong', '2019-03-27 17:00:00', '2019-03-28 04:18:11');
194
195-- --------------------------------------------------------
196
197--
198-- Table structure for table `satuan`
199--
200
201CREATE TABLE IF NOT EXISTS `satuan` (
202`id` int(11) NOT NULL,
203 `nama` varchar(255) NOT NULL,
204 `keterangan` varchar(255) NOT NULL,
205 `created_at` timestamp NULL DEFAULT NULL,
206 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
207) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
208
209--
210-- Dumping data for table `satuan`
211--
212
213INSERT INTO `satuan` (`id`, `nama`, `keterangan`, `created_at`, `updated_at`) VALUES
214(5, '500 ml', 'botol kecil', '2019-03-27 17:00:00', '2019-03-28 04:19:52'),
215(6, '2 Liter', 'botol besar', '2019-03-27 17:00:00', '2019-03-28 04:20:08'),
216(7, '300 gr', 'bungkus kecil', '2019-03-27 17:00:00', '2019-03-28 04:20:16'),
217(8, '1 kg', 'bungkus besar', '2019-03-27 17:00:00', '2019-03-28 04:20:46'),
218(9, '700 gr', 'bungkus sedang', '2019-03-27 17:00:00', '2019-03-28 04:20:54');
219
220-- --------------------------------------------------------
221
222--
223-- Table structure for table `users`
224--
225
226CREATE TABLE IF NOT EXISTS `users` (
227`id` int(11) NOT NULL,
228 `email` varchar(255) NOT NULL,
229 `password` varchar(255) NOT NULL
230) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
231
232--
233-- Dumping data for table `users`
234--
235
236INSERT INTO `users` (`id`, `email`, `password`) VALUES
237(1, 'admin@gmail.com', '21232f297a57a5a743894a0e4a801fc3');
238
239--
240-- Indexes for dumped tables
241--
242
243--
244-- Indexes for table `barang`
245--
246ALTER TABLE `barang`
247 ADD PRIMARY KEY (`id`);
248
249--
250-- Indexes for table `barang_keluar`
251--
252ALTER TABLE `barang_keluar`
253 ADD PRIMARY KEY (`id`);
254
255--
256-- Indexes for table `barang_masuk`
257--
258ALTER TABLE `barang_masuk`
259 ADD PRIMARY KEY (`id`);
260
261--
262-- Indexes for table `barang_reject`
263--
264ALTER TABLE `barang_reject`
265 ADD PRIMARY KEY (`id`);
266
267--
268-- Indexes for table `category`
269--
270ALTER TABLE `category`
271 ADD PRIMARY KEY (`id`);
272
273--
274-- Indexes for table `merk`
275--
276ALTER TABLE `merk`
277 ADD PRIMARY KEY (`id`);
278
279--
280-- Indexes for table `satuan`
281--
282ALTER TABLE `satuan`
283 ADD PRIMARY KEY (`id`);
284
285--
286-- Indexes for table `users`
287--
288ALTER TABLE `users`
289 ADD PRIMARY KEY (`id`);
290
291--
292-- AUTO_INCREMENT for dumped tables
293--
294
295--
296-- AUTO_INCREMENT for table `barang`
297--
298ALTER TABLE `barang`
299MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
300--
301-- AUTO_INCREMENT for table `barang_keluar`
302--
303ALTER TABLE `barang_keluar`
304MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
305--
306-- AUTO_INCREMENT for table `barang_masuk`
307--
308ALTER TABLE `barang_masuk`
309MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=84;
310--
311-- AUTO_INCREMENT for table `barang_reject`
312--
313ALTER TABLE `barang_reject`
314MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
315--
316-- AUTO_INCREMENT for table `category`
317--
318ALTER TABLE `category`
319MODIFY `id` int(6) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
320--
321-- AUTO_INCREMENT for table `merk`
322--
323ALTER TABLE `merk`
324MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
325--
326-- AUTO_INCREMENT for table `satuan`
327--
328ALTER TABLE `satuan`
329MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
330--
331-- AUTO_INCREMENT for table `users`
332--
333ALTER TABLE `users`
334MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
335/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
336/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
337/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;