-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 02, 2021 at 10:48 AM
-- Server version: 5.7.23-23
-- PHP Version: 7.3.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Dumping data for table `setting_menus`
--

INSERT INTO `setting_menus` (`id`, `software_id`, `name`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Organization', 1, '2020-10-20 00:16:23', '2020-10-20 00:16:23', NULL),
(2, 1, 'Users & Roles', 1, '2020-10-20 00:16:23', '2020-10-20 00:16:23', NULL),
(3, 1, 'Preferences', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(4, 1, 'Taxes', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(5, 1, 'BANK', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(6, 1, 'Warehouse', 0, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(7, 1, 'Country', 0, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(8, 1, 'Region', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(9, 1, 'Branch/Depot', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(10, 1, 'Van Master', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(11, 1, 'Route', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(12, 1, 'Customer Category', 0, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(13, 1, 'Credit Limits', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(14, 1, 'Outlet Product Code', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(15, 1, 'Item Group', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(16, 1, 'UOM', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(17, 2, 'Organization', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(18, 2, 'Users & Roles', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(19, 2, 'Preferences', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(20, 2, 'Taxes', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(21, 2, 'BANK', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(22, 2, 'Warehouse', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(23, 2, 'Country', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(24, 2, 'Region', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(25, 2, 'Branch/Depot', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(26, 2, 'Van Master', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(27, 2, 'Route', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(28, 2, 'Customer Category', 0, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(29, 2, 'Credit Limits', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(30, 2, 'Outlet Product Code', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(31, 2, 'Item Group', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(32, 2, 'UOM', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(33, 3, 'Organization', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(34, 3, 'Users & Roles', 1, '2020-10-20 00:16:24', '2020-10-20 00:16:24', NULL),
(35, 3, 'Preferences', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(36, 3, 'Taxes', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(37, 3, 'BANK', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(38, 3, 'Warehouse', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(39, 3, 'Country', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(40, 3, 'Region', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(41, 3, 'Branch/Depot', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(42, 3, 'Van Master', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(43, 3, 'Route', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(44, 3, 'Customer Category', 0, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(45, 3, 'Credit Limits', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(46, 3, 'Outlet Product Code', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(47, 3, 'Item Group', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(48, 3, 'UOM', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(49, 4, 'Organization', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(50, 4, 'Users & Roles', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(51, 4, 'Preferences', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(52, 4, 'Taxes', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(53, 4, 'BANK', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(54, 4, 'Warehouse', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(55, 4, 'Country', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(56, 4, 'Region', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(57, 4, 'Branch/Depot', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(58, 4, 'Van Master', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(59, 4, 'Route', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(60, 4, 'Customer Category', 0, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(61, 4, 'Credit Limits', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(62, 4, 'Outlet Product Code', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(63, 4, 'Item Group', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(64, 4, 'UOM', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(65, 5, 'Organization', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(66, 5, 'Users & Roles', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(67, 5, 'Preferences', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(68, 5, 'Taxes', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(69, 5, 'BANK', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(70, 5, 'Warehouse', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(71, 5, 'Country', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(72, 5, 'Region', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(73, 5, 'Branch/Depot', 1, '2020-10-20 00:16:25', '2020-10-20 00:16:25', NULL),
(74, 5, 'Van Master', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(75, 5, 'Route', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(76, 5, 'Customer Category', 0, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(77, 5, 'Credit Limits', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(78, 5, 'Outlet Product Code', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(79, 5, 'Item Group', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(80, 5, 'UOM', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(81, 6, 'Organization', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(82, 6, 'Users & Roles', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(83, 6, 'Preferences', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(84, 6, 'Taxes', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(85, 6, 'BANK', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(86, 6, 'Warehouse', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(87, 6, 'Country', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(88, 6, 'Region', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(89, 6, 'Branch/Depot', 1, '2020-10-20 00:16:26', '2020-10-20 00:16:26', NULL),
(90, 6, 'Van Master', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(91, 6, 'Route', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(92, 6, 'Customer Category', 0, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(93, 6, 'Credit Limits', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(94, 6, 'Outlet Product Code', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(95, 6, 'Item Group', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(96, 6, 'UOM', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(97, 7, 'Organization', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(98, 7, 'Users & Roles', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(99, 7, 'Preferences', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(100, 7, 'Taxes', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(101, 7, 'BANK', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(102, 7, 'Warehouse', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(103, 7, 'Country', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(104, 7, 'Region', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(105, 7, 'Branch/Depot', 1, '2020-10-20 00:16:27', '2020-10-20 00:16:27', NULL),
(106, 7, 'Van Master', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(107, 7, 'Route', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(108, 7, 'Customer Category', 0, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(109, 7, 'Credit Limits', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(110, 7, 'Outlet Product Code', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(111, 7, 'Item Group', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(112, 7, 'UOM', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(113, 8, 'Organization', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(114, 8, 'Users & Roles', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(115, 8, 'Preferences', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(116, 8, 'Taxes', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(117, 8, 'BANK', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(118, 8, 'Warehouse', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(119, 8, 'Country', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(120, 8, 'Region', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(121, 8, 'Branch/Depot', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(122, 8, 'Van Master', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(123, 8, 'Route', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(124, 8, 'Customer Category', 0, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(125, 8, 'Credit Limits', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(126, 8, 'Outlet Product Code', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(127, 8, 'Item Group', 1, '2020-10-20 00:16:28', '2020-10-20 00:16:28', NULL),
(128, 8, 'UOM', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(129, 9, 'Organization', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(130, 9, 'Users & Roles', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(131, 9, 'Preferences', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(132, 9, 'Taxes', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(133, 9, 'BANK', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(134, 9, 'Warehouse', 0, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(135, 9, 'Country', 0, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(136, 9, 'Region', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(137, 9, 'Branch/Depot', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(138, 9, 'Van Master', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(139, 9, 'Route', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(140, 9, 'Customer Category', 0, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(141, 9, 'Credit Limits', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(142, 9, 'Outlet Product Code', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(143, 9, 'Item Group', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(144, 9, 'UOM', 1, '2020-10-20 00:16:29', '2020-10-20 00:16:29', NULL),
(145, 1, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(146, 2, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(147, 3, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(148, 4, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(149, 5, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(150, 6, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(151, 7, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(152, 8, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(153, 9, 'Currency', 1, '2020-11-05 23:15:43', '2020-11-05 23:15:43', NULL),
(163, 1, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(164, 2, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(165, 3, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(166, 4, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(167, 5, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(168, 6, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(169, 7, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(170, 8, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL),
(171, 9, 'Merchandiser Replacement', 1, '2021-01-28 13:06:19', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `setting_menus`
--
ALTER TABLE `setting_menus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `setting_menus_software_id_foreign` (`software_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `setting_menus`
--
ALTER TABLE `setting_menus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=172;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `setting_menus`
--
ALTER TABLE `setting_menus`
  ADD CONSTRAINT `setting_menus_software_id_foreign` FOREIGN KEY (`software_id`) REFERENCES `softwares` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
