· 6 years ago · Apr 02, 2019, 04:44 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:37
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 `category`
129--
130
131CREATE TABLE IF NOT EXISTS `category` (
132`id` int(6) NOT NULL,
133 `name` varchar(255) NOT NULL,
134 `keterangan` tinytext,
135 `created_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
136 `updated_at` timestamp NULL DEFAULT NULL
137) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
138
139--
140-- Dumping data for table `category`
141--
142
143INSERT INTO `category` (`id`, `name`, `keterangan`, `created_at`, `updated_at`) VALUES
144(7, 'Minuman', 'Simpan di tempat kering dan hindari suhu panas', '2019-03-27 17:00:00', NULL),
145(9, 'Makanan', 'Hindari sinar matahari', '2019-03-30 02:45:21', '2019-03-29 17:00:00');
146
147-- --------------------------------------------------------
148
149--
150-- Table structure for table `merk`
151--
152
153CREATE TABLE IF NOT EXISTS `merk` (
154`id` int(11) NOT NULL,
155 `nama` varchar(255) NOT NULL,
156 `keterangan` varchar(255) NOT NULL,
157 `created_at` timestamp NULL DEFAULT NULL,
158 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
159) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
160
161--
162-- Dumping data for table `merk`
163--
164
165INSERT INTO `merk` (`id`, `nama`, `keterangan`, `created_at`, `updated_at`) VALUES
166(4, 'Aqua', 'Minuman air mineral', '2019-03-27 17:00:00', '2019-03-28 04:13:30'),
167(6, 'Vit', 'Minuman air mineral', '2019-03-27 17:00:00', '2019-03-28 04:15:12'),
168(7, 'Total', 'Minuman air mineral', '2019-03-27 17:00:00', '2019-03-28 04:15:18'),
169(8, 'Chitato', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:16:19'),
170(9, 'Mister Potato', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:16:46'),
171(10, 'Lays', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:17:04'),
172(11, 'Leo', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:17:09'),
173(12, 'Piatos', 'Snack Kentang', '2019-03-27 17:00:00', '2019-03-28 04:17:15'),
174(13, 'Qtela', 'Snack singkong', '2019-03-27 17:00:00', '2019-03-28 04:17:49'),
175(14, 'Kusuka', 'Snack Singkong', '2019-03-27 17:00:00', '2019-03-28 04:18:04'),
176(15, 'Chuba', 'Snack Singkong', '2019-03-27 17:00:00', '2019-03-28 04:18:11');
177
178-- --------------------------------------------------------
179
180--
181-- Table structure for table `satuan`
182--
183
184CREATE TABLE IF NOT EXISTS `satuan` (
185`id` int(11) NOT NULL,
186 `nama` varchar(255) NOT NULL,
187 `keterangan` varchar(255) NOT NULL,
188 `created_at` timestamp NULL DEFAULT NULL,
189 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
190) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
191
192--
193-- Dumping data for table `satuan`
194--
195
196INSERT INTO `satuan` (`id`, `nama`, `keterangan`, `created_at`, `updated_at`) VALUES
197(5, '500 ml', 'botol kecil', '2019-03-27 17:00:00', '2019-03-28 04:19:52'),
198(6, '2 Liter', 'botol besar', '2019-03-27 17:00:00', '2019-03-28 04:20:08'),
199(7, '300 gr', 'bungkus kecil', '2019-03-27 17:00:00', '2019-03-28 04:20:16'),
200(8, '1 kg', 'bungkus besar', '2019-03-27 17:00:00', '2019-03-28 04:20:46'),
201(9, '700 gr', 'bungkus sedang', '2019-03-27 17:00:00', '2019-03-28 04:20:54');
202
203-- --------------------------------------------------------
204
205--
206-- Table structure for table `users`
207--
208
209CREATE TABLE IF NOT EXISTS `users` (
210`id` int(11) NOT NULL,
211 `email` varchar(255) NOT NULL,
212 `password` varchar(255) NOT NULL
213) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
214
215--
216-- Dumping data for table `users`
217--
218
219INSERT INTO `users` (`id`, `email`, `password`) VALUES
220(1, 'admin@gmail.com', '21232f297a57a5a743894a0e4a801fc3');
221
222--
223-- Indexes for dumped tables
224--
225
226--
227-- Indexes for table `barang`
228--
229ALTER TABLE `barang`
230 ADD PRIMARY KEY (`id`);
231
232--
233-- Indexes for table `barang_keluar`
234--
235ALTER TABLE `barang_keluar`
236 ADD PRIMARY KEY (`id`);
237
238--
239-- Indexes for table `barang_masuk`
240--
241ALTER TABLE `barang_masuk`
242 ADD PRIMARY KEY (`id`);
243
244--
245-- Indexes for table `category`
246--
247ALTER TABLE `category`
248 ADD PRIMARY KEY (`id`);
249
250--
251-- Indexes for table `merk`
252--
253ALTER TABLE `merk`
254 ADD PRIMARY KEY (`id`);
255
256--
257-- Indexes for table `satuan`
258--
259ALTER TABLE `satuan`
260 ADD PRIMARY KEY (`id`);
261
262--
263-- Indexes for table `users`
264--
265ALTER TABLE `users`
266 ADD PRIMARY KEY (`id`);
267
268--
269-- AUTO_INCREMENT for dumped tables
270--
271
272--
273-- AUTO_INCREMENT for table `barang`
274--
275ALTER TABLE `barang`
276MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
277--
278-- AUTO_INCREMENT for table `barang_keluar`
279--
280ALTER TABLE `barang_keluar`
281MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
282--
283-- AUTO_INCREMENT for table `barang_masuk`
284--
285ALTER TABLE `barang_masuk`
286MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=84;
287--
288-- AUTO_INCREMENT for table `category`
289--
290ALTER TABLE `category`
291MODIFY `id` int(6) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
292--
293-- AUTO_INCREMENT for table `merk`
294--
295ALTER TABLE `merk`
296MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
297--
298-- AUTO_INCREMENT for table `satuan`
299--
300ALTER TABLE `satuan`
301MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
302--
303-- AUTO_INCREMENT for table `users`
304--
305ALTER TABLE `users`
306MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
307/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
308/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
309/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;