· 6 years ago · Sep 18, 2019, 12:02 PM
1-- phpMyAdmin SQL Dump
2-- version 4.9.0.1
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Waktu pembuatan: 18 Sep 2019 pada 13.57
7-- Versi server: 10.4.6-MariaDB
8-- Versi PHP: 7.3.9
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `1920_xiirpl_1_3_abutoyibazis`
23--
24
25DELIMITER $$
26--
27-- Prosedur
28--
29CREATE DEFINER=`root`@`localhost` PROCEDURE `insertDetailOrder` (IN `_id` INT, IN `_id_menu` INT, IN `_id_order` CHAR(8), IN `_jumlah` INT, IN `_harga` INT, IN `_status_detail_order` ENUM('Selesai','On Process')) NO SQL
30BEGIN
31INSERT INTO detail_orders VALUES (_id, _id_menu, _id_order, _jumlah, _harga, _status_detail_order);
32END$$
33
34CREATE DEFINER=`root`@`localhost` PROCEDURE `insertDetailTransaction` (IN `_id` INT, IN `_id_transaksi` INT, IN `_id_menu` INT, IN `_jumlah` INT, IN `_sub_total` INT) NO SQL
35BEGIN
36INSERT INTO detail_transactions VALUES (_id, _id_transaksi, _id_menu, _jumlah, _sub_total);
37END$$
38
39CREATE DEFINER=`root`@`localhost` PROCEDURE `insertOrder` (IN `_id` CHAR(8), IN `_id_user` INT, IN `_nama_pelanggan` VARCHAR(100), IN `_no_meja` ENUM('01','02','03'), IN `_alamat` VARCHAR(191), IN `_waktu_order` VARCHAR(30), IN `_keterangan` TEXT, IN `_status_order` ENUM('Sudah Dibayar','Belum Dibayar')) NO SQL
40BEGIN
41INSERT INTO orders VALUES (_id, _id_user, _nama_pelanggan, _no_meja, _alamat, _waktu_order, _keterangan, _status_order );
42END$$
43
44CREATE DEFINER=`root`@`localhost` PROCEDURE `insertTransaction` (IN `_id` INT, IN `_id_user` INT, IN `_id_order` CHAR(8), IN `_total_bayar` INT, IN `_uang_dibayar` INT, IN `_total_kembali` INT) NO SQL
45BEGIN
46INSERT INTO transactions VALUES (_id, _id_user, _id_order, _total_bayar, _uang_dibayar, _total_kembali);
47END$$
48
49DELIMITER ;
50
51-- --------------------------------------------------------
52
53--
54-- Struktur dari tabel `categories`
55--
56
57CREATE TABLE `categories` (
58 `id` int(10) UNSIGNED NOT NULL,
59 `nama_kategori` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL
60) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
61
62--
63-- Dumping data untuk tabel `categories`
64--
65
66INSERT INTO `categories` (`id`, `nama_kategori`) VALUES
67(1, 'Pizza'),
68(2, 'Pasta'),
69(3, 'Chicken'),
70(4, 'Dessert'),
71(5, 'Drink');
72
73-- --------------------------------------------------------
74
75--
76-- Struktur dari tabel `detail_orders`
77--
78
79CREATE TABLE `detail_orders` (
80 `id` bigint(20) UNSIGNED NOT NULL,
81 `id_menu` int(10) UNSIGNED NOT NULL,
82 `id_order` char(8) COLLATE utf8mb4_unicode_ci NOT NULL,
83 `jumlah` int(11) NOT NULL,
84 `harga` int(11) NOT NULL,
85 `status_detail_order` enum('Selesai','On Process') COLLATE utf8mb4_unicode_ci NOT NULL,
86 `created_at` timestamp NULL DEFAULT NULL,
87 `updated_at` timestamp NULL DEFAULT NULL
88) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
89
90--
91-- Dumping data untuk tabel `detail_orders`
92--
93
94INSERT INTO `detail_orders` (`id`, `id_menu`, `id_order`, `jumlah`, `harga`, `status_detail_order`, `created_at`, `updated_at`) VALUES
95(1, 12, 'wtw527n3', 1, 150000, 'On Process', NULL, NULL),
96(2, 13, 'wtw527n3', 1, 19000, 'On Process', NULL, NULL),
97(3, 18, 'wtw527n3', 1, 10000, 'On Process', NULL, NULL),
98(4, 17, 'wtw527n3', 1, 38000, 'On Process', NULL, NULL),
99(5, 12, 'HOGNOAV7', 1, 150000, 'On Process', NULL, NULL),
100(6, 16, 'HOGNOAV7', 1, 156900, 'On Process', NULL, NULL),
101(7, 13, 'HOGNOAV7', 1, 19000, 'On Process', NULL, NULL);
102
103-- --------------------------------------------------------
104
105--
106-- Struktur dari tabel `detail_transactions`
107--
108
109CREATE TABLE `detail_transactions` (
110 `id` bigint(20) UNSIGNED NOT NULL,
111 `id_transaksi` bigint(20) UNSIGNED NOT NULL,
112 `id_menu` int(10) UNSIGNED NOT NULL,
113 `jumlah` int(11) NOT NULL,
114 `sub_total` int(11) NOT NULL
115) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
116
117--
118-- Dumping data untuk tabel `detail_transactions`
119--
120
121INSERT INTO `detail_transactions` (`id`, `id_transaksi`, `id_menu`, `jumlah`, `sub_total`) VALUES
122(5, 20, 12, 1, 150000),
123(6, 20, 13, 1, 19000),
124(7, 20, 18, 1, 10000),
125(8, 20, 17, 1, 38000);
126
127-- --------------------------------------------------------
128
129--
130-- Struktur dari tabel `discounts`
131--
132
133CREATE TABLE `discounts` (
134 `id` int(10) UNSIGNED NOT NULL,
135 `kode` char(8) COLLATE utf8mb4_unicode_ci NOT NULL,
136 `diskon` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
137 `status` enum('valid','invalid') COLLATE utf8mb4_unicode_ci NOT NULL,
138 `created_at` timestamp NULL DEFAULT NULL,
139 `updated_at` timestamp NULL DEFAULT NULL
140) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
141
142-- --------------------------------------------------------
143
144--
145-- Struktur dari tabel `levels`
146--
147
148CREATE TABLE `levels` (
149 `id` int(10) UNSIGNED NOT NULL,
150 `nama_level` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
151 `email_level` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
152 `created_at` timestamp NULL DEFAULT NULL,
153 `updated_at` timestamp NULL DEFAULT NULL
154) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
155
156--
157-- Dumping data untuk tabel `levels`
158--
159
160INSERT INTO `levels` (`id`, `nama_level`, `email_level`, `created_at`, `updated_at`) VALUES
161(1, 'Administrator', 'admin@resto.co.id', '2019-08-30 04:28:34', '2019-08-30 04:28:34'),
162(2, 'Waiter', 'waiter@resto.co.id', '2019-08-30 19:40:20', '2019-08-30 19:40:20'),
163(3, 'Kasir', 'kasir@resto.co.id', '2019-08-30 19:40:20', '2019-08-30 19:40:20'),
164(4, 'Owner', 'owner@resto.co.id', '2019-08-30 19:40:20', '2019-08-30 19:40:20'),
165(5, 'Pelanggan', '', '2019-08-30 19:40:20', '2019-08-30 19:40:20');
166
167-- --------------------------------------------------------
168
169--
170-- Struktur dari tabel `menus`
171--
172
173CREATE TABLE `menus` (
174 `id` int(10) UNSIGNED NOT NULL,
175 `id_kategori` int(10) UNSIGNED NOT NULL,
176 `nama_menu` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
177 `harga` int(11) NOT NULL,
178 `status_menu` enum('Tersedia','Tidak Tersedia') COLLATE utf8mb4_unicode_ci NOT NULL,
179 `deskripsi` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
180 `gambar` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
181 `created_at` timestamp NULL DEFAULT NULL,
182 `updated_at` timestamp NULL DEFAULT NULL,
183 `deleted_at` timestamp NULL DEFAULT NULL
184) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
185
186--
187-- Dumping data untuk tabel `menus`
188--
189
190INSERT INTO `menus` (`id`, `id_kategori`, `nama_menu`, `harga`, `status_menu`, `deskripsi`, `gambar`, `created_at`, `updated_at`, `deleted_at`) VALUES
191(1, 2, 'Spagheti Beef', 79000, 'Tersedia', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Beatae quia ad quos odio ducimus magni atque tenetur', 'pizza-buah.png', '2019-09-01 02:47:31', '2019-09-12 16:58:00', NULL),
192(2, 3, 'Chicken Dinner', 150000, 'Tersedia', 'lorem ipsum dolor sit amet', 'pizza-buah.png', '2019-09-02 04:01:12', '2019-09-09 21:50:18', NULL),
193(12, 1, 'Splitza Classic', 150000, 'Tersedia', 'Call to undefined function SoftDeletes()', 'pizza-buah.png', '2019-09-02 17:19:26', '2019-09-09 21:35:26', NULL),
194(13, 5, 'Pudding Choco', 19000, 'Tersedia', 'Call to undefined function SoftDeletes()', 'pizza-buah.png', '2019-09-02 17:21:44', '2019-09-02 17:21:44', NULL),
195(16, 3, 'Chicken Spice', 156900, 'Tersedia', '\'sweetalert::alert\'->->', 'pizza-buah.png', '2019-09-02 17:57:05', '2019-09-02 23:30:15', NULL),
196(17, 4, 'Sandwich Bread', 38000, 'Tersedia', '->setConnection(Check::connection());', 'pizza-buah.png', '2019-09-08 20:03:03', '2019-09-08 20:12:38', NULL),
197(18, 1, 'Pizza Matang', 10000, 'Tersedia', 'protected $dates = [\'deleted_at\'];', 'pizza-buah.png', '2019-09-08 20:19:43', '2019-09-18 01:02:15', NULL);
198
199-- --------------------------------------------------------
200
201--
202-- Struktur dari tabel `migrations`
203--
204
205CREATE TABLE `migrations` (
206 `id` int(10) UNSIGNED NOT NULL,
207 `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
208 `batch` int(11) NOT NULL
209) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
210
211--
212-- Dumping data untuk tabel `migrations`
213--
214
215INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
216(1, '2014_10_12_000000_create_users_table', 1),
217(2, '2014_10_12_100000_create_password_resets_table', 1),
218(3, '2019_08_26_141515_create_menus_table', 1),
219(4, '2019_08_26_143231_create_categories_table', 1),
220(5, '2019_08_26_144130_create_levels_table', 1),
221(6, '2019_08_27_112605_create_transactions_table', 1),
222(7, '2019_08_27_114105_create_orders_table', 1),
223(8, '2019_08_27_120433_create_discounts_table', 1),
224(9, '2019_08_27_123807_create_detail_orders_table', 1),
225(10, '2019_08_27_132151_create_detail_transactions_table', 1),
226(11, '2019_08_27_235303_add_foreign_to_users_table', 1),
227(12, '2019_08_28_113254_add_foreign_to_menus_table', 1),
228(13, '2019_08_28_113738_add_foreign_to_transactions_table', 1),
229(14, '2019_08_28_114053_add_foreign_to_orders_table', 1),
230(15, '2019_08_28_114541_add_foreign_to_detail_orders_table', 1),
231(16, '2019_08_28_115620_add_foreign_to_detail_transactions_table', 1),
232(17, '2019_08_30_223554_add_status_order_to_orders', 1),
233(18, '2019_08_30_235915_add_email_level_to_levels', 1),
234(19, '2019_09_03_070438_create_soft_delete_menu', 1),
235(20, '2019_09_10_102223_create_social_accounts_table', 1),
236(21, '2019_09_15_200832_add_soft_delete_order', 1),
237(22, '2019_09_17_075820_add_timestamp_to_detail_order', 1),
238(23, '2019_09_17_092027_add_total_bayar_orders', 1);
239
240-- --------------------------------------------------------
241
242--
243-- Struktur dari tabel `orders`
244--
245
246CREATE TABLE `orders` (
247 `id` char(8) COLLATE utf8mb4_unicode_ci NOT NULL,
248 `id_user` bigint(20) UNSIGNED NOT NULL,
249 `nama_pelanggan` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
250 `no_meja` enum('01','02','03') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
251 `alamat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
252 `waktu_order` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
253 `keterangan` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
254 `status_order` enum('Sudah Dibayar','Belum Dibayar') COLLATE utf8mb4_unicode_ci NOT NULL,
255 `total_pembayaran` int(11) NOT NULL,
256 `created_at` timestamp NULL DEFAULT NULL,
257 `updated_at` timestamp NULL DEFAULT NULL,
258 `deleted_at` timestamp NULL DEFAULT NULL
259) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
260
261--
262-- Dumping data untuk tabel `orders`
263--
264
265INSERT INTO `orders` (`id`, `id_user`, `nama_pelanggan`, `no_meja`, `alamat`, `waktu_order`, `keterangan`, `status_order`, `total_pembayaran`, `created_at`, `updated_at`, `deleted_at`) VALUES
266('HOGNOAV7', 6, 'Dot Blade', '02', NULL, '18:32:30 WIB', 'Semua Bungkus, Bawa Pulang', 'Belum Dibayar', 325900, '2019-09-18 11:32:30', '2019-09-18 11:32:30', NULL),
267('wtw527n3', 6, 'Rudi Hartono', '02', NULL, '22:48:46 WIB', 'Semua Gratis Untuk Raja', 'Sudah Dibayar', 217000, '2019-09-17 15:48:46', '2019-09-18 06:03:54', NULL);
268
269-- --------------------------------------------------------
270
271--
272-- Struktur dari tabel `password_resets`
273--
274
275CREATE TABLE `password_resets` (
276 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
277 `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
278 `created_at` timestamp NULL DEFAULT NULL
279) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
280
281-- --------------------------------------------------------
282
283--
284-- Struktur dari tabel `social_accounts`
285--
286
287CREATE TABLE `social_accounts` (
288 `id` bigint(20) UNSIGNED NOT NULL,
289 `id_user` bigint(20) NOT NULL,
290 `provider_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
291 `provider_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
292 `created_at` timestamp NULL DEFAULT NULL,
293 `updated_at` timestamp NULL DEFAULT NULL
294) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
295
296-- --------------------------------------------------------
297
298--
299-- Struktur dari tabel `transactions`
300--
301
302CREATE TABLE `transactions` (
303 `id` bigint(20) UNSIGNED NOT NULL,
304 `id_user` bigint(20) UNSIGNED NOT NULL,
305 `id_order` char(8) COLLATE utf8mb4_unicode_ci NOT NULL,
306 `total_bayar` int(11) NOT NULL,
307 `uang_dibayar` int(11) DEFAULT NULL,
308 `total_kembali` int(11) DEFAULT NULL,
309 `created_at` timestamp NULL DEFAULT NULL,
310 `updated_at` timestamp NULL DEFAULT NULL
311) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
312
313--
314-- Dumping data untuk tabel `transactions`
315--
316
317INSERT INTO `transactions` (`id`, `id_user`, `id_order`, `total_bayar`, `uang_dibayar`, `total_kembali`, `created_at`, `updated_at`) VALUES
318(20, 6, 'wtw527n3', 217000, 300000, 83000, '2019-09-18 06:03:52', '2019-09-18 06:03:52');
319
320-- --------------------------------------------------------
321
322--
323-- Struktur dari tabel `users`
324--
325
326CREATE TABLE `users` (
327 `id` bigint(20) UNSIGNED NOT NULL,
328 `id_level` int(10) UNSIGNED NOT NULL,
329 `nickname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
330 `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
331 `email` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
332 `email_verified_at` timestamp NULL DEFAULT NULL,
333 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
334 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
335 `created_at` timestamp NULL DEFAULT NULL,
336 `updated_at` timestamp NULL DEFAULT NULL
337) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
338
339--
340-- Dumping data untuk tabel `users`
341--
342
343INSERT INTO `users` (`id`, `id_level`, `nickname`, `username`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
344(6, 1, NULL, 'admin', 'admin@resto.co.id', NULL, '$2y$10$AUcBiR0K49GUzanI2pPEA.zfN.uRP0R/kIw.9CSxJHOjmXdMqqCEG', 'shzvjuCCx06moGuTmHwPi8tfPVn7dRw9g2HfMS5bEjTBSE2w5SmgF2xgctTi', '2019-09-17 14:08:39', '2019-09-17 14:08:39'),
345(7, 3, NULL, 'kasir', 'kasir@resto.co.id', NULL, '$2y$10$ovD5T4G0gWKUN.IOTFHW0eUfXcsuXmo3g/MREzb8uzCHcZ.TP3hue', NULL, '2019-09-17 15:36:44', '2019-09-17 15:36:44');
346
347-- --------------------------------------------------------
348
349--
350-- Stand-in struktur untuk tampilan `vMenu`
351-- (Lihat di bawah untuk tampilan aktual)
352--
353CREATE TABLE `vMenu` (
354`id` int(10) unsigned
355,`id_kategori` int(10) unsigned
356,`nama_menu` varchar(100)
357,`harga` int(11)
358,`status_menu` enum('Tersedia','Tidak Tersedia')
359,`deskripsi` text
360,`gambar` varchar(100)
361,`deleted_at` timestamp
362);
363
364-- --------------------------------------------------------
365
366--
367-- Stand-in struktur untuk tampilan `vOrderKasir`
368-- (Lihat di bawah untuk tampilan aktual)
369--
370CREATE TABLE `vOrderKasir` (
371`id` char(8)
372,`id_user` bigint(20) unsigned
373,`nama_pelanggan` varchar(100)
374,`no_meja` enum('01','02','03')
375,`alamat` varchar(191)
376,`waktu_order` varchar(30)
377,`keterangan` text
378,`status_order` enum('Sudah Dibayar','Belum Dibayar')
379,`total_pembayaran` int(11)
380,`created_at` timestamp
381,`updated_at` timestamp
382,`deleted_at` timestamp
383);
384
385-- --------------------------------------------------------
386
387--
388-- Stand-in struktur untuk tampilan `vOrderWaiter`
389-- (Lihat di bawah untuk tampilan aktual)
390--
391CREATE TABLE `vOrderWaiter` (
392`id` char(8)
393,`id_user` bigint(20) unsigned
394,`nama_pelanggan` varchar(100)
395,`no_meja` enum('01','02','03')
396,`alamat` varchar(191)
397,`waktu_order` varchar(30)
398,`keterangan` text
399,`status_order` enum('Sudah Dibayar','Belum Dibayar')
400,`total_pembayaran` int(11)
401,`created_at` timestamp
402,`updated_at` timestamp
403,`deleted_at` timestamp
404);
405
406-- --------------------------------------------------------
407
408--
409-- Stand-in struktur untuk tampilan `vUser`
410-- (Lihat di bawah untuk tampilan aktual)
411--
412CREATE TABLE `vUser` (
413`id` bigint(20) unsigned
414,`nickname` varchar(100)
415,`username` varchar(20)
416,`email` varchar(20)
417,`nama_level` varchar(20)
418);
419
420-- --------------------------------------------------------
421
422--
423-- Struktur untuk view `vMenu`
424--
425DROP TABLE IF EXISTS `vMenu`;
426
427CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vMenu` AS select `menus`.`id` AS `id`,`menus`.`id_kategori` AS `id_kategori`,`menus`.`nama_menu` AS `nama_menu`,`menus`.`harga` AS `harga`,`menus`.`status_menu` AS `status_menu`,`menus`.`deskripsi` AS `deskripsi`,`menus`.`gambar` AS `gambar`,`menus`.`deleted_at` AS `deleted_at` from (`menus` join `categories` on(`menus`.`id_kategori` = `categories`.`id`)) ;
428
429-- --------------------------------------------------------
430
431--
432-- Struktur untuk view `vOrderKasir`
433--
434DROP TABLE IF EXISTS `vOrderKasir`;
435
436CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vOrderKasir` AS select `orders`.`id` AS `id`,`orders`.`id_user` AS `id_user`,`orders`.`nama_pelanggan` AS `nama_pelanggan`,`orders`.`no_meja` AS `no_meja`,`orders`.`alamat` AS `alamat`,`orders`.`waktu_order` AS `waktu_order`,`orders`.`keterangan` AS `keterangan`,`orders`.`status_order` AS `status_order`,`orders`.`total_pembayaran` AS `total_pembayaran`,`orders`.`created_at` AS `created_at`,`orders`.`updated_at` AS `updated_at`,`orders`.`deleted_at` AS `deleted_at` from `orders` ;
437
438-- --------------------------------------------------------
439
440--
441-- Struktur untuk view `vOrderWaiter`
442--
443DROP TABLE IF EXISTS `vOrderWaiter`;
444
445CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vOrderWaiter` AS select `orders`.`id` AS `id`,`orders`.`id_user` AS `id_user`,`orders`.`nama_pelanggan` AS `nama_pelanggan`,`orders`.`no_meja` AS `no_meja`,`orders`.`alamat` AS `alamat`,`orders`.`waktu_order` AS `waktu_order`,`orders`.`keterangan` AS `keterangan`,`orders`.`status_order` AS `status_order`,`orders`.`total_pembayaran` AS `total_pembayaran`,`orders`.`created_at` AS `created_at`,`orders`.`updated_at` AS `updated_at`,`orders`.`deleted_at` AS `deleted_at` from `orders` ;
446
447-- --------------------------------------------------------
448
449--
450-- Struktur untuk view `vUser`
451--
452DROP TABLE IF EXISTS `vUser`;
453
454CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vUser` AS select `users`.`id` AS `id`,`users`.`nickname` AS `nickname`,`users`.`username` AS `username`,`users`.`email` AS `email`,`levels`.`nama_level` AS `nama_level` from (`users` join `levels` on(`users`.`id_level` = `levels`.`id`)) ;
455
456--
457-- Indexes for dumped tables
458--
459
460--
461-- Indeks untuk tabel `categories`
462--
463ALTER TABLE `categories`
464 ADD PRIMARY KEY (`id`);
465
466--
467-- Indeks untuk tabel `detail_orders`
468--
469ALTER TABLE `detail_orders`
470 ADD PRIMARY KEY (`id`),
471 ADD KEY `detail_orders_id_order_foreign` (`id_order`),
472 ADD KEY `detail_orders_id_menu_foreign` (`id_menu`);
473
474--
475-- Indeks untuk tabel `detail_transactions`
476--
477ALTER TABLE `detail_transactions`
478 ADD PRIMARY KEY (`id`),
479 ADD KEY `detail_transactions_id_transaksi_foreign` (`id_transaksi`);
480
481--
482-- Indeks untuk tabel `discounts`
483--
484ALTER TABLE `discounts`
485 ADD PRIMARY KEY (`id`);
486
487--
488-- Indeks untuk tabel `levels`
489--
490ALTER TABLE `levels`
491 ADD PRIMARY KEY (`id`);
492
493--
494-- Indeks untuk tabel `menus`
495--
496ALTER TABLE `menus`
497 ADD PRIMARY KEY (`id`),
498 ADD KEY `menus_id_kategori_foreign` (`id_kategori`);
499
500--
501-- Indeks untuk tabel `migrations`
502--
503ALTER TABLE `migrations`
504 ADD PRIMARY KEY (`id`);
505
506--
507-- Indeks untuk tabel `orders`
508--
509ALTER TABLE `orders`
510 ADD PRIMARY KEY (`id`),
511 ADD KEY `orders_id_user_foreign` (`id_user`);
512
513--
514-- Indeks untuk tabel `password_resets`
515--
516ALTER TABLE `password_resets`
517 ADD KEY `password_resets_email_index` (`email`);
518
519--
520-- Indeks untuk tabel `social_accounts`
521--
522ALTER TABLE `social_accounts`
523 ADD PRIMARY KEY (`id`),
524 ADD UNIQUE KEY `social_accounts_provider_id_unique` (`provider_id`);
525
526--
527-- Indeks untuk tabel `transactions`
528--
529ALTER TABLE `transactions`
530 ADD PRIMARY KEY (`id`),
531 ADD KEY `transactions_id_user_foreign` (`id_user`),
532 ADD KEY `transactions_id_order_foreign` (`id_order`);
533
534--
535-- Indeks untuk tabel `users`
536--
537ALTER TABLE `users`
538 ADD PRIMARY KEY (`id`),
539 ADD UNIQUE KEY `users_email_unique` (`email`),
540 ADD KEY `users_id_level_foreign` (`id_level`);
541
542--
543-- AUTO_INCREMENT untuk tabel yang dibuang
544--
545
546--
547-- AUTO_INCREMENT untuk tabel `categories`
548--
549ALTER TABLE `categories`
550 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
551
552--
553-- AUTO_INCREMENT untuk tabel `detail_orders`
554--
555ALTER TABLE `detail_orders`
556 MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
557
558--
559-- AUTO_INCREMENT untuk tabel `detail_transactions`
560--
561ALTER TABLE `detail_transactions`
562 MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
563
564--
565-- AUTO_INCREMENT untuk tabel `discounts`
566--
567ALTER TABLE `discounts`
568 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
569
570--
571-- AUTO_INCREMENT untuk tabel `levels`
572--
573ALTER TABLE `levels`
574 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
575
576--
577-- AUTO_INCREMENT untuk tabel `menus`
578--
579ALTER TABLE `menus`
580 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
581
582--
583-- AUTO_INCREMENT untuk tabel `migrations`
584--
585ALTER TABLE `migrations`
586 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
587
588--
589-- AUTO_INCREMENT untuk tabel `social_accounts`
590--
591ALTER TABLE `social_accounts`
592 MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
593
594--
595-- AUTO_INCREMENT untuk tabel `transactions`
596--
597ALTER TABLE `transactions`
598 MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
599
600--
601-- AUTO_INCREMENT untuk tabel `users`
602--
603ALTER TABLE `users`
604 MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
605
606--
607-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
608--
609
610--
611-- Ketidakleluasaan untuk tabel `detail_orders`
612--
613ALTER TABLE `detail_orders`
614 ADD CONSTRAINT `detail_orders_id_menu_foreign` FOREIGN KEY (`id_menu`) REFERENCES `menus` (`id`) ON UPDATE CASCADE,
615 ADD CONSTRAINT `detail_orders_id_order_foreign` FOREIGN KEY (`id_order`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
616
617--
618-- Ketidakleluasaan untuk tabel `detail_transactions`
619--
620ALTER TABLE `detail_transactions`
621 ADD CONSTRAINT `detail_transactions_id_transaksi_foreign` FOREIGN KEY (`id_transaksi`) REFERENCES `transactions` (`id`);
622
623--
624-- Ketidakleluasaan untuk tabel `menus`
625--
626ALTER TABLE `menus`
627 ADD CONSTRAINT `menus_id_kategori_foreign` FOREIGN KEY (`id_kategori`) REFERENCES `categories` (`id`) ON UPDATE CASCADE;
628
629--
630-- Ketidakleluasaan untuk tabel `orders`
631--
632ALTER TABLE `orders`
633 ADD CONSTRAINT `orders_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
634
635--
636-- Ketidakleluasaan untuk tabel `transactions`
637--
638ALTER TABLE `transactions`
639 ADD CONSTRAINT `transactions_id_order_foreign` FOREIGN KEY (`id_order`) REFERENCES `orders` (`id`),
640 ADD CONSTRAINT `transactions_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON UPDATE CASCADE;
641
642--
643-- Ketidakleluasaan untuk tabel `users`
644--
645ALTER TABLE `users`
646 ADD CONSTRAINT `users_id_level_foreign` FOREIGN KEY (`id_level`) REFERENCES `levels` (`id`) ON UPDATE CASCADE;
647COMMIT;
648
649/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
650/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
651/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;