-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 16-01-2019 a las 17:50:48
-- Versión del servidor: 10.2.19-MariaDB-cll-lve
-- Versión de PHP: 7.2.7
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 */;
--
-- Base de datos: `nwsktjeg_ultraventas`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `barcodes`
--
CREATE TABLE `barcodes` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`width` double(8,2) DEFAULT NULL,
`height` double(8,2) DEFAULT NULL,
`paper_width` double(8,2) DEFAULT NULL,
`paper_height` double(8,2) DEFAULT NULL,
`top_margin` double(8,2) DEFAULT NULL,
`left_margin` double(8,2) DEFAULT NULL,
`row_distance` double(8,2) DEFAULT NULL,
`col_distance` double(8,2) DEFAULT NULL,
`stickers_in_one_row` int(11) DEFAULT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`is_continuous` tinyint(1) NOT NULL DEFAULT 0,
`stickers_in_one_sheet` int(11) DEFAULT NULL,
`business_id` int(10) UNSIGNED DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `barcodes`
--
INSERT INTO `barcodes` (`id`, `name`, `description`, `width`, `height`, `paper_width`, `paper_height`, `top_margin`, `left_margin`, `row_distance`, `col_distance`, `stickers_in_one_row`, `is_default`, `is_continuous`, `stickers_in_one_sheet`, `business_id`, `created_at`, `updated_at`) VALUES
(1, '20 Labels per Sheet - (8.5\" x 11\")', 'Sheet Size: 8.5\" x 11\"\\r\\nLabel Size: 4\" x 1\"\\r\\nLabels per sheet: 20', 3.75, 1.00, 8.50, 11.00, 0.50, 0.50, 0.00, 0.16, 2, 0, 0, 20, NULL, '2017-12-18 11:13:44', '2017-12-18 11:13:44'),
(2, '30 Labels per sheet - (8.5\" x 11\")', 'Sheet Size: 8.5\" x 11\"\\r\\nLabel Size: 2.625\" x 1\"\\r\\nLabels per sheet: 30', 2.62, 1.00, 8.50, 11.00, 0.50, 0.22, 0.00, 0.14, 3, 0, 0, 30, NULL, '2017-12-18 11:04:39', '2017-12-18 11:10:40'),
(3, '32 Labels per sheet - (8.5\" x 11\")', 'Sheet Size: 8.5\" x 11\"\\r\\nLabel Size: 2\" x 1.25\"\\r\\nLabels per sheet: 32', 2.00, 1.25, 8.50, 11.00, 0.50, 0.25, 0.00, 0.00, 4, 0, 0, 32, NULL, '2017-12-18 10:55:40', '2017-12-18 10:55:40'),
(4, '40 Labels per sheet - (8.5\" x 11\")', 'Sheet Size: 8.5\" x 11\"\\r\\nLabel Size: 2\" x 1\"\\r\\nLabels per sheet: 40', 2.00, 1.00, 8.50, 11.00, 0.50, 0.25, 0.00, 0.00, 4, 0, 0, 40, NULL, '2017-12-18 10:58:40', '2017-12-18 10:58:40'),
(5, '50 Labels per Sheet - (8.5\" x 11\")', 'Sheet Size: 8.5\" x 11\"\\r\\nLabel Size: 1.5\" x 1\"\\r\\nLabels per sheet: 50', 1.50, 1.00, 8.50, 11.00, 0.50, 0.50, 0.00, 0.00, 5, 0, 0, 50, NULL, '2017-12-18 10:51:10', '2017-12-18 10:51:10'),
(6, 'Continuous Rolls - 31.75mm x 25.4mm', 'Label Size: 31.75mm x 25.4mm\\r\\nGap: 3.18mm', 1.25, 1.00, 1.25, 0.00, 0.12, 0.00, 0.12, 0.00, 1, 0, 1, NULL, NULL, '2017-12-18 10:51:10', '2017-12-18 10:51:10');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `bookings`
--
CREATE TABLE `bookings` (
`id` int(10) UNSIGNED NOT NULL,
`contact_id` int(10) UNSIGNED NOT NULL,
`waiter_id` int(10) UNSIGNED DEFAULT NULL,
`table_id` int(10) UNSIGNED DEFAULT NULL,
`correspondent_id` int(11) DEFAULT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`location_id` int(10) UNSIGNED NOT NULL,
`booking_start` datetime NOT NULL,
`booking_end` datetime NOT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`booking_status` enum('booked','completed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL,
`booking_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `brands`
--
CREATE TABLE `brands` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `brands`
--
INSERT INTO `brands` (`id`, `business_id`, `name`, `description`, `created_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 2, 'hp', 'hp computadoras', 2, NULL, '2019-01-16 21:51:30', '2019-01-16 21:51:30'),
(2, 2, 'ANIPSA', 'PINTURAS', 2, NULL, '2019-01-16 21:51:45', '2019-01-16 21:51:45'),
(3, 2, 'TOSHIBA', 'TOSHIBA', 2, NULL, '2019-01-16 21:56:44', '2019-01-16 21:56:44'),
(4, 2, 'ASUS', 'ASUS', 2, NULL, '2019-01-16 21:56:50', '2019-01-16 21:56:50'),
(5, 2, 'COCACO0LA', 'COCACOLA', 2, NULL, '2019-01-16 21:57:32', '2019-01-16 21:57:32');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `business`
--
CREATE TABLE `business` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
`currency_id` int(10) UNSIGNED NOT NULL,
`start_date` date DEFAULT NULL,
`tax_number_1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tax_label_1` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tax_number_2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tax_label_2` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`default_sales_tax` int(10) UNSIGNED DEFAULT NULL,
`default_profit_percent` double(5,2) NOT NULL DEFAULT 0.00,
`owner_id` int(10) UNSIGNED NOT NULL,
`time_zone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Asia/Kolkata',
`fy_start_month` tinyint(4) NOT NULL DEFAULT 1,
`accounting_method` enum('fifo','lifo','avco') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fifo',
`default_sales_discount` decimal(20,2) DEFAULT NULL,
`sell_price_tax` enum('includes','excludes') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'includes',
`logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sku_prefix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`enable_product_expiry` tinyint(1) NOT NULL DEFAULT 0,
`expiry_type` enum('add_expiry','add_manufacturing') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'add_expiry',
`on_product_expiry` enum('keep_selling','stop_selling','auto_delete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'keep_selling',
`stop_selling_before` int(11) NOT NULL COMMENT 'Stop selling expied item n days before expiry',
`enable_tooltip` tinyint(1) NOT NULL DEFAULT 1,
`purchase_in_diff_currency` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Allow purchase to be in different currency then the business currency',
`purchase_currency_id` int(10) UNSIGNED DEFAULT NULL,
`p_exchange_rate` decimal(20,3) NOT NULL DEFAULT 1.000,
`transaction_edit_days` int(10) UNSIGNED NOT NULL DEFAULT 30,
`stock_expiry_alert_days` int(10) UNSIGNED NOT NULL DEFAULT 30,
`keyboard_shortcuts` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pos_settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`enable_brand` tinyint(1) NOT NULL DEFAULT 1,
`enable_category` tinyint(1) NOT NULL DEFAULT 1,
`enable_sub_category` tinyint(1) NOT NULL DEFAULT 1,
`enable_price_tax` tinyint(1) NOT NULL DEFAULT 1,
`enable_purchase_status` tinyint(1) DEFAULT 1,
`enable_lot_number` tinyint(1) NOT NULL DEFAULT 0,
`default_unit` int(11) DEFAULT NULL,
`enable_racks` tinyint(1) NOT NULL DEFAULT 0,
`enable_row` tinyint(1) NOT NULL DEFAULT 0,
`enable_position` tinyint(1) NOT NULL DEFAULT 0,
`enable_editing_product_from_purchase` tinyint(1) NOT NULL DEFAULT 1,
`sales_cmsn_agnt` enum('logged_in_user','user','cmsn_agnt') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`item_addition_method` tinyint(1) NOT NULL DEFAULT 1,
`enable_inline_tax` tinyint(1) NOT NULL DEFAULT 1,
`currency_symbol_placement` enum('before','after') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'before',
`enabled_modules` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_format` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'm/d/Y',
`time_format` enum('12','24') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '24',
`ref_no_prefixes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`theme_color` char(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`email_settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sms_settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `business`
--
INSERT INTO `business` (`id`, `name`, `currency_id`, `start_date`, `tax_number_1`, `tax_label_1`, `tax_number_2`, `tax_label_2`, `default_sales_tax`, `default_profit_percent`, `owner_id`, `time_zone`, `fy_start_month`, `accounting_method`, `default_sales_discount`, `sell_price_tax`, `logo`, `sku_prefix`, `enable_product_expiry`, `expiry_type`, `on_product_expiry`, `stop_selling_before`, `enable_tooltip`, `purchase_in_diff_currency`, `purchase_currency_id`, `p_exchange_rate`, `transaction_edit_days`, `stock_expiry_alert_days`, `keyboard_shortcuts`, `pos_settings`, `enable_brand`, `enable_category`, `enable_sub_category`, `enable_price_tax`, `enable_purchase_status`, `enable_lot_number`, `default_unit`, `enable_racks`, `enable_row`, `enable_position`, `enable_editing_product_from_purchase`, `sales_cmsn_agnt`, `item_addition_method`, `enable_inline_tax`, `currency_symbol_placement`, `enabled_modules`, `date_format`, `time_format`, `ref_no_prefixes`, `theme_color`, `created_by`, `email_settings`, `sms_settings`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'test', 3, '2019-01-16', NULL, NULL, NULL, NULL, NULL, 25.00, 1, 'Asia/Kolkata', 1, 'fifo', NULL, 'includes', NULL, NULL, 0, 'add_expiry', 'keep_selling', 0, 1, 0, NULL, '1.000', 30, 30, '{\"pos\":{\"express_checkout\":\"shift+e\",\"pay_n_ckeckout\":\"shift+p\",\"draft\":\"shift+d\",\"cancel\":\"shift+c\",\"edit_discount\":\"shift+i\",\"edit_order_tax\":\"shift+t\",\"add_payment_row\":\"shift+r\",\"finalize_payment\":\"shift+f\",\"recent_product_quantity\":\"f2\",\"add_new_product\":\"f4\"}}', NULL, 1, 1, 1, 1, 1, 0, NULL, 0, 0, 0, 1, NULL, 1, 0, 'before', NULL, 'm/d/Y', '24', '{\"purchase\":\"PO\",\"stock_transfer\":\"ST\",\"stock_adjustment\":\"SA\",\"sell_return\":\"CN\",\"expense\":\"EP\",\"contacts\":\"CO\",\"purchase_payment\":\"PP\",\"sell_payment\":\"SP\",\"business_location\":\"BL\"}', NULL, NULL, NULL, NULL, 1, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 'tusolutionweb', 4, '2019-01-16', NULL, NULL, NULL, NULL, NULL, 25.00, 2, 'America/Lima', 1, 'fifo', NULL, 'includes', '1547635306_coca personal.jpg', NULL, 0, 'add_expiry', 'keep_selling', 0, 1, 0, NULL, '1.000', 30, 30, '{\"pos\":{\"express_checkout\":\"shift+e\",\"pay_n_ckeckout\":\"shift+p\",\"draft\":\"shift+d\",\"cancel\":\"shift+c\",\"edit_discount\":\"shift+i\",\"edit_order_tax\":\"shift+t\",\"add_payment_row\":\"shift+r\",\"finalize_payment\":\"shift+f\",\"recent_product_quantity\":\"f2\",\"add_new_product\":\"f4\"}}', NULL, 1, 1, 1, 1, 1, 0, NULL, 0, 0, 0, 1, NULL, 1, 0, 'before', NULL, 'm/d/Y', '24', '{\"purchase\":\"PO\",\"stock_transfer\":\"ST\",\"stock_adjustment\":\"SA\",\"sell_return\":\"CN\",\"expense\":\"EP\",\"contacts\":\"CO\",\"purchase_payment\":\"PP\",\"sell_payment\":\"SP\",\"business_location\":\"BL\"}', NULL, NULL, NULL, NULL, 1, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `business_locations`
--
CREATE TABLE `business_locations` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`location_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
`landmark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`state` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`zip_code` char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
`invoice_scheme_id` int(10) UNSIGNED NOT NULL,
`invoice_layout_id` int(10) UNSIGNED NOT NULL,
`print_receipt_on_invoice` tinyint(1) DEFAULT 1,
`receipt_printer_type` enum('browser','printer') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'browser',
`printer_id` int(11) DEFAULT NULL,
`mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`alternate_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_field1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_field2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_field3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_field4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `business_locations`
--
INSERT INTO `business_locations` (`id`, `business_id`, `location_id`, `name`, `landmark`, `country`, `state`, `city`, `zip_code`, `invoice_scheme_id`, `invoice_layout_id`, `print_receipt_on_invoice`, `receipt_printer_type`, `printer_id`, `mobile`, `alternate_number`, `email`, `website`, `custom_field1`, `custom_field2`, `custom_field3`, `custom_field4`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'BL0001', 'test', 't', 't', 't', 't', 't', 1, 1, 1, 'browser', NULL, 't', 't', '', '', NULL, NULL, NULL, NULL, NULL, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 2, 'BL0001', 'tusolutionweb', 'av san marin', 'Argentina', 'buenos aires', 'buenos aires', '+53435', 2, 2, 1, 'browser', NULL, '344565', '934233445', '', 'http://comprayventacodigofuente.com/ultraventas/public/', NULL, NULL, NULL, NULL, NULL, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `cash_registers`
--
CREATE TABLE `cash_registers` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED DEFAULT NULL,
`status` enum('close','open') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
`closed_at` datetime DEFAULT NULL,
`closing_amount` decimal(20,2) NOT NULL DEFAULT 0.00,
`total_card_slips` int(11) NOT NULL DEFAULT 0,
`total_cheques` int(11) NOT NULL DEFAULT 0,
`closing_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `cash_registers`
--
INSERT INTO `cash_registers` (`id`, `business_id`, `user_id`, `status`, `closed_at`, `closing_amount`, `total_card_slips`, `total_cheques`, `closing_note`, `created_at`, `updated_at`) VALUES
(1, 2, 2, 'close', '2019-01-16 17:07:42', '1000.00', 0, 0, NULL, '2019-01-16 22:03:41', '2019-01-16 22:07:42'),
(2, 2, 2, 'open', NULL, '0.00', 0, 0, NULL, '2019-01-16 22:10:17', '2019-01-16 22:10:17');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `cash_register_transactions`
--
CREATE TABLE `cash_register_transactions` (
`id` int(10) UNSIGNED NOT NULL,
`cash_register_id` int(10) UNSIGNED NOT NULL,
`amount` decimal(20,2) NOT NULL DEFAULT 0.00,
`pay_method` enum('cash','card','cheque','bank_transfer','custom_pay_1','custom_pay_2','custom_pay_3','other') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type` enum('debit','credit') COLLATE utf8mb4_unicode_ci NOT NULL,
`transaction_type` enum('initial','sell','transfer','refund') COLLATE utf8mb4_unicode_ci NOT NULL,
`transaction_id` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `cash_register_transactions`
--
INSERT INTO `cash_register_transactions` (`id`, `cash_register_id`, `amount`, `pay_method`, `type`, `transaction_type`, `transaction_id`, `created_at`, `updated_at`) VALUES
(1, 1, '1000.00', 'cash', 'credit', 'initial', NULL, '2019-01-16 22:03:41', '2019-01-16 22:03:41'),
(2, 2, '5000.00', 'cash', 'credit', 'initial', NULL, '2019-01-16 22:10:17', '2019-01-16 22:10:17');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `categories`
--
CREATE TABLE `categories` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`short_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`parent_id` int(11) NOT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `categories`
--
INSERT INTO `categories` (`id`, `name`, `business_id`, `short_code`, `parent_id`, `created_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Ferreteria', 2, NULL, 0, 2, NULL, '2019-01-16 21:40:11', '2019-01-16 21:40:11'),
(2, 'Computadoras', 2, NULL, 0, 2, NULL, '2019-01-16 21:40:21', '2019-01-16 21:40:21');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `contacts`
--
CREATE TABLE `contacts` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`type` enum('supplier','customer','both') COLLATE utf8mb4_unicode_ci NOT NULL,
`supplier_business_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tax_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`landmark` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`landline` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`alternate_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pay_term_number` int(11) DEFAULT NULL,
`pay_term_type` enum('days','months') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`credit_limit` decimal(20,2) DEFAULT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`customer_group_id` int(11) DEFAULT NULL,
`custom_field1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_field2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_field3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_field4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `contacts`
--
INSERT INTO `contacts` (`id`, `business_id`, `type`, `supplier_business_name`, `name`, `email`, `contact_id`, `tax_number`, `city`, `state`, `country`, `landmark`, `mobile`, `landline`, `alternate_number`, `pay_term_number`, `pay_term_type`, `credit_limit`, `created_by`, `is_default`, `customer_group_id`, `custom_field1`, `custom_field2`, `custom_field3`, `custom_field4`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'customer', NULL, 'Walk-In Customer', NULL, 'CO0001', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 2, 'customer', NULL, 'Walk-In Customer', NULL, 'CO0001', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `currencies`
--
CREATE TABLE `currencies` (
`id` int(10) UNSIGNED NOT NULL,
`country` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`currency` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
`symbol` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
`thousand_separator` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`decimal_separator` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `currencies`
--
INSERT INTO `currencies` (`id`, `country`, `currency`, `code`, `symbol`, `thousand_separator`, `decimal_separator`, `created_at`, `updated_at`) VALUES
(1, 'Albania', 'Leke', 'ALL', 'Lek', ',', '.', NULL, NULL),
(2, 'America', 'Dollars', 'USD', '$', ',', '.', NULL, NULL),
(3, 'Afghanistan', 'Afghanis', 'AF', '؋', ',', '.', NULL, NULL),
(4, 'Argentina', 'Pesos', 'ARS', '$', ',', '.', NULL, NULL),
(5, 'Aruba', 'Guilders', 'AWG', 'ƒ', ',', '.', NULL, NULL),
(6, 'Australia', 'Dollars', 'AUD', '$', ',', '.', NULL, NULL),
(7, 'Azerbaijan', 'New Manats', 'AZ', 'ман', ',', '.', NULL, NULL),
(8, 'Bahamas', 'Dollars', 'BSD', '$', ',', '.', NULL, NULL),
(9, 'Barbados', 'Dollars', 'BBD', '$', ',', '.', NULL, NULL),
(10, 'Belarus', 'Rubles', 'BYR', 'p.', ',', '.', NULL, NULL),
(11, 'Belgium', 'Euro', 'EUR', '€', ',', '.', NULL, NULL),
(12, 'Beliz', 'Dollars', 'BZD', 'BZ$', ',', '.', NULL, NULL),
(13, 'Bermuda', 'Dollars', 'BMD', '$', ',', '.', NULL, NULL),
(14, 'Bolivia', 'Bolivianos', 'BOB', '$b', ',', '.', NULL, NULL),
(15, 'Bosnia and Herzegovina', 'Convertible Marka', 'BAM', 'KM', ',', '.', NULL, NULL),
(16, 'Botswana', 'Pula\'s', 'BWP', 'P', ',', '.', NULL, NULL),
(17, 'Bulgaria', 'Leva', 'BG', 'лв', ',', '.', NULL, NULL),
(18, 'Brazil', 'Reais', 'BRL', 'R$', ',', '.', NULL, NULL),
(19, 'Britain [United Kingdom]', 'Pounds', 'GBP', '£', ',', '.', NULL, NULL),
(20, 'Brunei Darussalam', 'Dollars', 'BND', '$', ',', '.', NULL, NULL),
(21, 'Cambodia', 'Riels', 'KHR', '៛', ',', '.', NULL, NULL),
(22, 'Canada', 'Dollars', 'CAD', '$', ',', '.', NULL, NULL),
(23, 'Cayman Islands', 'Dollars', 'KYD', '$', ',', '.', NULL, NULL),
(24, 'Chile', 'Pesos', 'CLP', '$', ',', '.', NULL, NULL),
(25, 'China', 'Yuan Renminbi', 'CNY', '¥', ',', '.', NULL, NULL),
(26, 'Colombia', 'Pesos', 'COP', '$', ',', '.', NULL, NULL),
(27, 'Costa Rica', 'Colón', 'CRC', '₡', ',', '.', NULL, NULL),
(28, 'Croatia', 'Kuna', 'HRK', 'kn', ',', '.', NULL, NULL),
(29, 'Cuba', 'Pesos', 'CUP', '₱', ',', '.', NULL, NULL),
(30, 'Cyprus', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(31, 'Czech Republic', 'Koruny', 'CZK', 'Kč', ',', '.', NULL, NULL),
(32, 'Denmark', 'Kroner', 'DKK', 'kr', ',', '.', NULL, NULL),
(33, 'Dominican Republic', 'Pesos', 'DOP ', 'RD$', ',', '.', NULL, NULL),
(34, 'East Caribbean', 'Dollars', 'XCD', '$', ',', '.', NULL, NULL),
(35, 'Egypt', 'Pounds', 'EGP', '£', ',', '.', NULL, NULL),
(36, 'El Salvador', 'Colones', 'SVC', '$', ',', '.', NULL, NULL),
(37, 'England [United Kingdom]', 'Pounds', 'GBP', '£', ',', '.', NULL, NULL),
(38, 'Euro', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(39, 'Falkland Islands', 'Pounds', 'FKP', '£', ',', '.', NULL, NULL),
(40, 'Fiji', 'Dollars', 'FJD', '$', ',', '.', NULL, NULL),
(41, 'France', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(42, 'Ghana', 'Cedis', 'GHC', '¢', ',', '.', NULL, NULL),
(43, 'Gibraltar', 'Pounds', 'GIP', '£', ',', '.', NULL, NULL),
(44, 'Greece', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(45, 'Guatemala', 'Quetzales', 'GTQ', 'Q', ',', '.', NULL, NULL),
(46, 'Guernsey', 'Pounds', 'GGP', '£', ',', '.', NULL, NULL),
(47, 'Guyana', 'Dollars', 'GYD', '$', ',', '.', NULL, NULL),
(48, 'Holland [Netherlands]', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(49, 'Honduras', 'Lempiras', 'HNL', 'L', ',', '.', NULL, NULL),
(50, 'Hong Kong', 'Dollars', 'HKD', '$', ',', '.', NULL, NULL),
(51, 'Hungary', 'Forint', 'HUF', 'Ft', ',', '.', NULL, NULL),
(52, 'Iceland', 'Kronur', 'ISK', 'kr', ',', '.', NULL, NULL),
(53, 'India', 'Rupees', 'INR', '₹', ',', '.', NULL, NULL),
(54, 'Indonesia', 'Rupiahs', 'IDR', 'Rp', ',', '.', NULL, NULL),
(55, 'Iran', 'Rials', 'IRR', '﷼', ',', '.', NULL, NULL),
(56, 'Ireland', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(57, 'Isle of Man', 'Pounds', 'IMP', '£', ',', '.', NULL, NULL),
(58, 'Israel', 'New Shekels', 'ILS', '₪', ',', '.', NULL, NULL),
(59, 'Italy', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(60, 'Jamaica', 'Dollars', 'JMD', 'J$', ',', '.', NULL, NULL),
(61, 'Japan', 'Yen', 'JPY', '¥', ',', '.', NULL, NULL),
(62, 'Jersey', 'Pounds', 'JEP', '£', ',', '.', NULL, NULL),
(63, 'Kazakhstan', 'Tenge', 'KZT', 'лв', ',', '.', NULL, NULL),
(64, 'Korea [North]', 'Won', 'KPW', '₩', ',', '.', NULL, NULL),
(65, 'Korea [South]', 'Won', 'KRW', '₩', ',', '.', NULL, NULL),
(66, 'Kyrgyzstan', 'Soms', 'KGS', 'лв', ',', '.', NULL, NULL),
(67, 'Laos', 'Kips', 'LAK', '₭', ',', '.', NULL, NULL),
(68, 'Latvia', 'Lati', 'LVL', 'Ls', ',', '.', NULL, NULL),
(69, 'Lebanon', 'Pounds', 'LBP', '£', ',', '.', NULL, NULL),
(70, 'Liberia', 'Dollars', 'LRD', '$', ',', '.', NULL, NULL),
(71, 'Liechtenstein', 'Switzerland Francs', 'CHF', 'CHF', ',', '.', NULL, NULL),
(72, 'Lithuania', 'Litai', 'LTL', 'Lt', ',', '.', NULL, NULL),
(73, 'Luxembourg', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(74, 'Macedonia', 'Denars', 'MKD', 'ден', ',', '.', NULL, NULL),
(75, 'Malaysia', 'Ringgits', 'MYR', 'RM', ',', '.', NULL, NULL),
(76, 'Malta', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(77, 'Mauritius', 'Rupees', 'MUR', '₨', ',', '.', NULL, NULL),
(78, 'Mexico', 'Pesos', 'MX', '$', ',', '.', NULL, NULL),
(79, 'Mongolia', 'Tugriks', 'MNT', '₮', ',', '.', NULL, NULL),
(80, 'Mozambique', 'Meticais', 'MZ', 'MT', ',', '.', NULL, NULL),
(81, 'Namibia', 'Dollars', 'NAD', '$', ',', '.', NULL, NULL),
(82, 'Nepal', 'Rupees', 'NPR', '₨', ',', '.', NULL, NULL),
(83, 'Netherlands Antilles', 'Guilders', 'ANG', 'ƒ', ',', '.', NULL, NULL),
(84, 'Netherlands', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(85, 'New Zealand', 'Dollars', 'NZD', '$', ',', '.', NULL, NULL),
(86, 'Nicaragua', 'Cordobas', 'NIO', 'C$', ',', '.', NULL, NULL),
(87, 'Nigeria', 'Nairas', 'NG', '₦', ',', '.', NULL, NULL),
(88, 'North Korea', 'Won', 'KPW', '₩', ',', '.', NULL, NULL),
(89, 'Norway', 'Krone', 'NOK', 'kr', ',', '.', NULL, NULL),
(90, 'Oman', 'Rials', 'OMR', '﷼', ',', '.', NULL, NULL),
(91, 'Pakistan', 'Rupees', 'PKR', '₨', ',', '.', NULL, NULL),
(92, 'Panama', 'Balboa', 'PAB', 'B/.', ',', '.', NULL, NULL),
(93, 'Paraguay', 'Guarani', 'PYG', 'Gs', ',', '.', NULL, NULL),
(94, 'Peru', 'Nuevos Soles', 'PE', 'S/.', ',', '.', NULL, NULL),
(95, 'Philippines', 'Pesos', 'PHP', 'Php', ',', '.', NULL, NULL),
(96, 'Poland', 'Zlotych', 'PL', 'zł', ',', '.', NULL, NULL),
(97, 'Qatar', 'Rials', 'QAR', '﷼', ',', '.', NULL, NULL),
(98, 'Romania', 'New Lei', 'RO', 'lei', ',', '.', NULL, NULL),
(99, 'Russia', 'Rubles', 'RUB', 'руб', ',', '.', NULL, NULL),
(100, 'Saint Helena', 'Pounds', 'SHP', '£', ',', '.', NULL, NULL),
(101, 'Saudi Arabia', 'Riyals', 'SAR', '﷼', ',', '.', NULL, NULL),
(102, 'Serbia', 'Dinars', 'RSD', 'Дин.', ',', '.', NULL, NULL),
(103, 'Seychelles', 'Rupees', 'SCR', '₨', ',', '.', NULL, NULL),
(104, 'Singapore', 'Dollars', 'SGD', '$', ',', '.', NULL, NULL),
(105, 'Slovenia', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(106, 'Solomon Islands', 'Dollars', 'SBD', '$', ',', '.', NULL, NULL),
(107, 'Somalia', 'Shillings', 'SOS', 'S', ',', '.', NULL, NULL),
(108, 'South Africa', 'Rand', 'ZAR', 'R', ',', '.', NULL, NULL),
(109, 'South Korea', 'Won', 'KRW', '₩', ',', '.', NULL, NULL),
(110, 'Spain', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(111, 'Sri Lanka', 'Rupees', 'LKR', '₨', ',', '.', NULL, NULL),
(112, 'Sweden', 'Kronor', 'SEK', 'kr', ',', '.', NULL, NULL),
(113, 'Switzerland', 'Francs', 'CHF', 'CHF', ',', '.', NULL, NULL),
(114, 'Suriname', 'Dollars', 'SRD', '$', ',', '.', NULL, NULL),
(115, 'Syria', 'Pounds', 'SYP', '£', ',', '.', NULL, NULL),
(116, 'Taiwan', 'New Dollars', 'TWD', 'NT$', ',', '.', NULL, NULL),
(117, 'Thailand', 'Baht', 'THB', '฿', ',', '.', NULL, NULL),
(118, 'Trinidad and Tobago', 'Dollars', 'TTD', 'TT$', ',', '.', NULL, NULL),
(119, 'Turkey', 'Lira', 'TRY', 'TL', ',', '.', NULL, NULL),
(120, 'Turkey', 'Liras', 'TRL', '£', ',', '.', NULL, NULL),
(121, 'Tuvalu', 'Dollars', 'TVD', '$', ',', '.', NULL, NULL),
(122, 'Ukraine', 'Hryvnia', 'UAH', '₴', ',', '.', NULL, NULL),
(123, 'United Kingdom', 'Pounds', 'GBP', '£', ',', '.', NULL, NULL),
(124, 'United States of America', 'Dollars', 'USD', '$', ',', '.', NULL, NULL),
(125, 'Uruguay', 'Pesos', 'UYU', '$U', ',', '.', NULL, NULL),
(126, 'Uzbekistan', 'Sums', 'UZS', 'лв', ',', '.', NULL, NULL),
(127, 'Vatican City', 'Euro', 'EUR', '€', '.', ',', NULL, NULL),
(128, 'Venezuela', 'Bolivares Fuertes', 'VEF', 'Bs', ',', '.', NULL, NULL),
(129, 'Vietnam', 'Dong', 'VND', '₫', ',', '.', NULL, NULL),
(130, 'Yemen', 'Rials', 'YER', '﷼', ',', '.', NULL, NULL),
(131, 'Zimbabwe', 'Zimbabwe Dollars', 'ZWD', 'Z$', ',', '.', NULL, NULL),
(132, 'Iraq', 'Iraqi dinar', 'IQD', 'د.ع', ',', '.', NULL, NULL),
(133, 'Kenya', 'Kenyan shilling', 'KES', 'KSh', ',', '.', NULL, NULL),
(134, 'Bangladesh', 'Taka', 'BDT', '৳', ',', '.', NULL, NULL),
(135, 'Algerie', 'Algerian dinar', 'DZD', 'د.ج', ' ', '.', NULL, NULL),
(136, 'United Arab Emirates', 'United Arab Emirates dirham', 'AED', 'د.إ', ',', '.', NULL, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `customer_groups`
--
CREATE TABLE `customer_groups` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`amount` double(5,2) NOT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `expense_categories`
--
CREATE TABLE `expense_categories` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `group_sub_taxes`
--
CREATE TABLE `group_sub_taxes` (
`group_tax_id` int(10) UNSIGNED NOT NULL,
`tax_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `invoice_layouts`
--
CREATE TABLE `invoice_layouts` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`header_text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`invoice_no_prefix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`quotation_no_prefix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`invoice_heading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sub_heading_line1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sub_heading_line2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sub_heading_line3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sub_heading_line4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sub_heading_line5` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`invoice_heading_not_paid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`invoice_heading_paid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`quotation_heading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sub_total_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`discount_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tax_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`total_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`total_due_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`paid_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`show_client_id` tinyint(1) NOT NULL DEFAULT 0,
`client_id_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`client_tax_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`show_time` tinyint(1) NOT NULL DEFAULT 1,
`show_brand` tinyint(1) NOT NULL DEFAULT 0,
`show_sku` tinyint(1) NOT NULL DEFAULT 1,
`show_cat_code` tinyint(1) NOT NULL DEFAULT 1,
`show_expiry` tinyint(1) NOT NULL DEFAULT 0,
`show_lot` tinyint(1) NOT NULL DEFAULT 0,
`show_sale_description` tinyint(1) NOT NULL DEFAULT 0,
`sales_person_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`show_sales_person` tinyint(1) NOT NULL DEFAULT 0,
`table_product_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`table_qty_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`table_unit_price_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`table_subtotal_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cat_code_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`show_logo` tinyint(1) NOT NULL DEFAULT 0,
`show_business_name` tinyint(1) NOT NULL DEFAULT 0,
`show_location_name` tinyint(1) NOT NULL DEFAULT 1,
`show_landmark` tinyint(1) NOT NULL DEFAULT 1,
`show_city` tinyint(1) NOT NULL DEFAULT 1,
`show_state` tinyint(1) NOT NULL DEFAULT 1,
`show_zip_code` tinyint(1) NOT NULL DEFAULT 1,
`show_country` tinyint(1) NOT NULL DEFAULT 1,
`show_mobile_number` tinyint(1) NOT NULL DEFAULT 1,
`show_alternate_number` tinyint(1) NOT NULL DEFAULT 0,
`show_email` tinyint(1) NOT NULL DEFAULT 0,
`show_tax_1` tinyint(1) NOT NULL DEFAULT 1,
`show_tax_2` tinyint(1) NOT NULL DEFAULT 0,
`show_barcode` tinyint(1) NOT NULL DEFAULT 0,
`show_payments` tinyint(1) NOT NULL DEFAULT 0,
`show_customer` tinyint(1) NOT NULL DEFAULT 0,
`customer_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`highlight_color` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`footer_text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module_info` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`business_id` int(10) UNSIGNED NOT NULL,
`design` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT 'classic',
`cn_heading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'cn = credit note',
`cn_no_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cn_amount_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`table_tax_headings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `invoice_layouts`
--
INSERT INTO `invoice_layouts` (`id`, `name`, `header_text`, `invoice_no_prefix`, `quotation_no_prefix`, `invoice_heading`, `sub_heading_line1`, `sub_heading_line2`, `sub_heading_line3`, `sub_heading_line4`, `sub_heading_line5`, `invoice_heading_not_paid`, `invoice_heading_paid`, `quotation_heading`, `sub_total_label`, `discount_label`, `tax_label`, `total_label`, `total_due_label`, `paid_label`, `show_client_id`, `client_id_label`, `client_tax_label`, `date_label`, `show_time`, `show_brand`, `show_sku`, `show_cat_code`, `show_expiry`, `show_lot`, `show_sale_description`, `sales_person_label`, `show_sales_person`, `table_product_label`, `table_qty_label`, `table_unit_price_label`, `table_subtotal_label`, `cat_code_label`, `logo`, `show_logo`, `show_business_name`, `show_location_name`, `show_landmark`, `show_city`, `show_state`, `show_zip_code`, `show_country`, `show_mobile_number`, `show_alternate_number`, `show_email`, `show_tax_1`, `show_tax_2`, `show_barcode`, `show_payments`, `show_customer`, `customer_label`, `highlight_color`, `footer_text`, `module_info`, `is_default`, `business_id`, `design`, `cn_heading`, `cn_no_label`, `cn_amount_label`, `table_tax_headings`, `created_at`, `updated_at`) VALUES
(1, 'Default', NULL, 'Invoice No.', NULL, 'Invoice', NULL, NULL, NULL, NULL, NULL, '', '', NULL, 'Subtotal', 'Discount', 'Tax', 'Total', 'Total Due', 'Total Paid', 0, NULL, NULL, 'Date', 1, 0, 1, 1, 0, 0, 0, NULL, 0, 'Product', 'Quantity', 'Unit Price', 'Subtotal', NULL, NULL, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 1, 1, 'Customer', '#000000', '', NULL, 1, 1, 'classic', NULL, NULL, NULL, NULL, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 'Default', NULL, 'Invoice No.', NULL, 'Invoice', NULL, NULL, NULL, NULL, NULL, '', '', NULL, 'Subtotal', 'Discount', 'Tax', 'Total', 'Total Due', 'Total Paid', 0, NULL, NULL, 'Date', 1, 0, 1, 1, 0, 0, 0, NULL, 0, 'Product', 'Quantity', 'Unit Price', 'Subtotal', NULL, NULL, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 1, 1, 'Customer', '#000000', '', NULL, 1, 2, 'classic', NULL, NULL, NULL, NULL, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `invoice_schemes`
--
CREATE TABLE `invoice_schemes` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`scheme_type` enum('blank','year') COLLATE utf8mb4_unicode_ci NOT NULL,
`prefix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`start_number` int(11) DEFAULT NULL,
`invoice_count` int(11) NOT NULL DEFAULT 0,
`total_digits` int(11) DEFAULT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `invoice_schemes`
--
INSERT INTO `invoice_schemes` (`id`, `business_id`, `name`, `scheme_type`, `prefix`, `start_number`, `invoice_count`, `total_digits`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 1, 'Default', 'blank', '', 1, 0, 4, 1, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 2, 'Default', 'blank', '', 1, 0, 4, 1, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `migrations`
--
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL,
`migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `migrations`
--
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2017_07_05_071953_create_currencies_table', 1),
(4, '2017_07_05_073658_create_business_table', 1),
(5, '2017_07_22_075923_add_business_id_users_table', 1),
(6, '2017_07_23_113209_create_brands_table', 1),
(7, '2017_07_26_083429_create_permission_tables', 1),
(8, '2017_07_26_110000_create_tax_rates_table', 1),
(9, '2017_07_26_122313_create_units_table', 1),
(10, '2017_07_27_075706_create_contacts_table', 1),
(11, '2017_08_04_071038_create_categories_table', 1),
(12, '2017_08_08_115903_create_products_table', 1),
(13, '2017_08_09_061616_create_variation_templates_table', 1),
(14, '2017_08_09_061638_create_variation_value_templates_table', 1),
(15, '2017_08_10_061146_create_product_variations_table', 1),
(16, '2017_08_10_061216_create_variations_table', 1),
(17, '2017_08_19_054827_create_transactions_table', 1),
(18, '2017_08_31_073533_create_purchase_lines_table', 1),
(19, '2017_10_15_064638_create_transaction_payments_table', 1),
(20, '2017_10_31_065621_add_default_sales_tax_to_business_table', 1),
(21, '2017_11_20_051930_create_table_group_sub_taxes', 1),
(22, '2017_11_20_063603_create_transaction_sell_lines', 1),
(23, '2017_11_21_064540_create_barcodes_table', 1),
(24, '2017_11_23_181237_create_invoice_schemes_table', 1),
(25, '2017_12_25_122822_create_business_locations_table', 1),
(26, '2017_12_25_160253_add_location_id_to_transactions_table', 1),
(27, '2017_12_25_163227_create_variation_location_details_table', 1),
(28, '2018_01_04_115627_create_sessions_table', 1),
(29, '2018_01_05_112817_create_invoice_layouts_table', 1),
(30, '2018_01_06_112303_add_invoice_scheme_id_and_invoice_layout_id_to_business_locations', 1),
(31, '2018_01_08_104124_create_expense_categories_table', 1),
(32, '2018_01_08_123327_modify_transactions_table_for_expenses', 1),
(33, '2018_01_09_111005_modify_payment_status_in_transactions_table', 1),
(34, '2018_01_09_111109_add_paid_on_column_to_transaction_payments_table', 1),
(35, '2018_01_25_172439_add_printer_related_fields_to_business_locations_table', 1),
(36, '2018_01_27_184322_create_printers_table', 1),
(37, '2018_01_30_181442_create_cash_registers_table', 1),
(38, '2018_01_31_125836_create_cash_register_transactions_table', 1),
(39, '2018_02_07_173326_modify_business_table', 1),
(40, '2018_02_08_105425_add_enable_product_expiry_column_to_business_table', 1),
(41, '2018_02_08_111027_add_expiry_period_and_expiry_period_type_columns_to_products_table', 1),
(42, '2018_02_08_131118_add_mfg_date_and_exp_date_purchase_lines_table', 1),
(43, '2018_02_08_155348_add_exchange_rate_to_transactions_table', 1),
(44, '2018_02_09_124945_modify_transaction_payments_table_for_contact_payments', 1),
(45, '2018_02_12_113640_create_transaction_sell_lines_purchase_lines_table', 1),
(46, '2018_02_12_114605_add_quantity_sold_in_purchase_lines_table', 1),
(47, '2018_02_13_183323_alter_decimal_fields_size', 1),
(48, '2018_02_14_161928_add_transaction_edit_days_to_business_table', 1),
(49, '2018_02_15_161032_add_document_column_to_transactions_table', 1),
(50, '2018_02_17_124709_add_more_options_to_invoice_layouts', 1),
(51, '2018_02_19_111517_add_keyboard_shortcut_column_to_business_table', 1),
(52, '2018_02_19_121537_stock_adjustment_move_to_transaction_table', 1),
(53, '2018_02_20_165505_add_is_direct_sale_column_to_transactions_table', 1),
(54, '2018_02_21_105329_create_system_table', 1),
(55, '2018_02_23_100549_version_1_2', 1),
(56, '2018_02_23_125648_add_enable_editing_sp_from_purchase_column_to_business_table', 1),
(57, '2018_02_26_103612_add_sales_commission_agent_column_to_business_table', 1),
(58, '2018_02_26_130519_modify_users_table_for_sales_cmmsn_agnt', 1),
(59, '2018_02_26_134500_add_commission_agent_to_transactions_table', 1),
(60, '2018_02_27_121422_add_item_addition_method_to_business_table', 1),
(61, '2018_02_27_170232_modify_transactions_table_for_stock_transfer', 1),
(62, '2018_03_05_153510_add_enable_inline_tax_column_to_business_table', 1),
(63, '2018_03_06_210206_modify_product_barcode_types', 1),
(64, '2018_03_13_181541_add_expiry_type_to_business_table', 1),
(65, '2018_03_16_113446_product_expiry_setting_for_business', 1),
(66, '2018_03_19_113601_add_business_settings_options', 1),
(67, '2018_03_26_125334_add_pos_settings_to_business_table', 1),
(68, '2018_03_26_165350_create_customer_groups_table', 1),
(69, '2018_03_27_122720_customer_group_related_changes_in_tables', 1),
(70, '2018_03_29_110138_change_tax_field_to_nullable_in_business_table', 1),
(71, '2018_03_29_115502_add_changes_for_sr_number_in_products_and_sale_lines_table', 1),
(72, '2018_03_29_134340_add_inline_discount_fields_in_purchase_lines', 1),
(73, '2018_03_31_140921_update_transactions_table_exchange_rate', 1),
(74, '2018_04_03_103037_add_contact_id_to_contacts_table', 1),
(75, '2018_04_03_122709_add_changes_to_invoice_layouts_table', 1),
(76, '2018_04_09_135320_change_exchage_rate_size_in_business_table', 1),
(77, '2018_04_17_123122_add_lot_number_to_business', 1),
(78, '2018_04_17_160845_add_product_racks_table', 1),
(79, '2018_04_20_182015_create_res_tables_table', 1),
(80, '2018_04_24_105246_restaurant_fields_in_transaction_table', 1),
(81, '2018_04_24_114149_add_enabled_modules_business_table', 1),
(82, '2018_04_24_133704_add_modules_fields_in_invoice_layout_table', 1),
(83, '2018_04_27_132653_quotation_related_change', 1),
(84, '2018_05_02_104439_add_date_format_and_time_format_to_business', 1),
(85, '2018_05_02_111939_add_sell_return_to_transaction_payments', 1),
(86, '2018_05_14_114027_add_rows_positions_for_products', 1),
(87, '2018_05_14_125223_add_weight_to_products_table', 1),
(88, '2018_05_14_164754_add_opening_stock_permission', 1),
(89, '2018_05_15_134729_add_design_to_invoice_layouts', 1),
(90, '2018_05_16_183307_add_tax_fields_invoice_layout', 1),
(91, '2018_05_18_191956_add_sell_return_to_transaction_table', 1),
(92, '2018_05_21_131349_add_custom_fileds_to_contacts_table', 1),
(93, '2018_05_21_131607_invoice_layout_fields_for_sell_return', 1),
(94, '2018_05_21_131949_add_custom_fileds_and_website_to_business_locations_table', 1),
(95, '2018_05_22_123527_create_reference_counts_table', 1),
(96, '2018_05_22_154540_add_ref_no_prefixes_column_to_business_table', 1),
(97, '2018_05_24_132620_add_ref_no_column_to_transaction_payments_table', 1),
(98, '2018_05_24_161026_add_location_id_column_to_business_location_table', 1),
(99, '2018_05_25_180603_create_modifiers_related_table', 1),
(100, '2018_05_29_121714_add_purchase_line_id_to_stock_adjustment_line_table', 1),
(101, '2018_05_31_114645_add_res_order_status_column_to_transactions_table', 1),
(102, '2018_06_05_103530_rename_purchase_line_id_in_stock_adjustment_lines_table', 1),
(103, '2018_06_05_111905_modify_products_table_for_modifiers', 1),
(104, '2018_06_06_110524_add_parent_sell_line_id_column_to_transaction_sell_lines_table', 1),
(105, '2018_06_07_152443_add_is_service_staff_to_roles_table', 1),
(106, '2018_06_07_182258_add_image_field_to_products_table', 1),
(107, '2018_06_13_133705_create_bookings_table', 1),
(108, '2018_06_15_173636_add_email_column_to_contacts_table', 1),
(109, '2018_06_27_182835_add_superadmin_related_fields_business', 1),
(110, '2018_07_10_101913_add_custom_fields_to_products_table', 1),
(111, '2018_07_17_103434_add_sales_person_name_label_to_invoice_layouts_table', 1),
(112, '2018_07_17_120612_change_all_quantity_field_type_to_decimal', 1),
(113, '2018_07_17_163920_add_theme_skin_color_column_to_business_table', 1),
(114, '2018_07_24_160319_add_lot_no_line_id_to_transaction_sell_lines_table', 1),
(115, '2018_07_25_110004_add_show_expiry_and_show_lot_colums_to_invoice_layouts_table', 1),
(116, '2018_07_25_172004_add_discount_columns_to_transaction_sell_lines_table', 1),
(117, '2018_07_26_124720_change_design_column_type_in_invoice_layouts_table', 1),
(118, '2018_07_26_170424_add_unit_price_before_discount_column_to_transaction_sell_line_table', 1),
(119, '2018_07_28_103614_add_credit_limit_column_to_contacts_table', 1),
(120, '2018_08_08_110755_add_new_payment_methods_to_transaction_payments_table', 1),
(121, '2018_08_08_122225_modify_cash_register_transactions_table_for_new_payment_methods', 1),
(122, '2018_08_14_104036_add_opening_balance_type_to_transactions_table', 1),
(123, '2018_09_06_114438_create_selling_price_groups_table', 1),
(124, '2018_09_06_154057_create_variation_group_prices_table', 1),
(125, '2018_09_07_102413_add_permission_to_access_default_selling_price', 1),
(126, '2018_09_07_134858_add_selling_price_group_id_to_transactions_table', 1),
(127, '2018_09_10_112448_update_product_type_to_single_if_null_in_products_table', 1),
(128, '2018_09_10_173656_add_account_id_column_to_transaction_payments_table', 1),
(129, '2018_09_19_123914_create_notification_templates_table', 1),
(130, '2018_09_22_110504_add_sms_and_email_settings_columns_to_business_table', 1),
(131, '2018_09_24_134942_add_lot_no_line_id_to_stock_adjustment_lines_table', 1),
(132, '2018_09_27_111609_modify_transactions_table_for_purchase_return', 1),
(133, '2018_09_27_131154_add_quantity_returned_column_to_purchase_lines_table', 1),
(134, '2018_10_02_131401_add_return_quantity_column_to_transaction_sell_lines_table', 1),
(135, '2018_10_03_104918_add_qty_returned_column_to_transaction_sell_lines_purchase_lines_table', 1),
(136, '2018_10_03_185947_add_default_notification_templates_to_database', 1),
(137, '2018_10_09_153105_add_business_id_to_transaction_payments_table', 1),
(138, '2018_10_16_135229_create_permission_for_sells_and_purchase', 1),
(139, '2018_10_22_114441_add_columns_for_variable_product_modifications', 1),
(140, '2018_10_22_134428_modify_variable_product_data', 1),
(141, '2018_10_30_181558_add_table_tax_headings_to_invoice_layout', 1),
(142, '2018_10_31_122619_add_pay_terms_field_transactions_table', 1),
(143, '2018_10_31_161328_add_new_permissions_for_pos_screen', 1),
(144, '2018_10_31_174752_add_access_selected_contacts_only_to_users_table', 1),
(145, '2018_10_31_175627_add_user_contact_access', 1),
(146, '2018_10_31_180559_add_auto_send_sms_column_to_notification_templates_table', 1),
(147, '2018_11_02_171949_change_card_type_column_to_varchar_in_transaction_payments_table', 1),
(148, '2018_11_08_105621_add_role_permissions', 1),
(149, '2018_11_26_114135_add_is_suspend_column_to_transactions_table', 1),
(150, '2018_11_29_115918_add_primary_key_in_system_table', 1),
(151, '2018_12_03_185546_add_product_description_column_to_products_table', 1),
(152, '2018_12_06_114937_modify_system_table_and_users_table', 1),
(153, '2019_01_08_112015_add_document_column_to_transaction_payments_table', 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `model_has_permissions`
--
CREATE TABLE `model_has_permissions` (
`permission_id` int(10) UNSIGNED NOT NULL,
`model_id` int(10) UNSIGNED NOT NULL,
`model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `model_has_roles`
--
CREATE TABLE `model_has_roles` (
`role_id` int(10) UNSIGNED NOT NULL,
`model_id` int(10) UNSIGNED NOT NULL,
`model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `model_has_roles`
--
INSERT INTO `model_has_roles` (`role_id`, `model_id`, `model_type`) VALUES
(1, 1, 'App\\User'),
(3, 2, 'App\\User');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `notification_templates`
--
CREATE TABLE `notification_templates` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(11) NOT NULL,
`template_for` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_body` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sms_body` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auto_send` tinyint(1) NOT NULL DEFAULT 0,
`auto_send_sms` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `notification_templates`
--
INSERT INTO `notification_templates` (`id`, `business_id`, `template_for`, `email_body`, `sms_body`, `subject`, `auto_send`, `auto_send_sms`, `created_at`, `updated_at`) VALUES
(1, 1, 'new_sale', 'Dear {contact_name},
\n\n Your invoice number is {invoice_number}
\n Total amount: {total_amount}
\n Paid amount: {paid_amount}
\n\n Thank you for shopping with us.
\n\n {business_logo}
\n\n
', 'Dear {contact_name}, Thank you for shopping with us. {business_name}', 'Thank you from {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 1, 'payment_received', 'Dear {contact_name},
\n\n We have received a payment of {paid_amount}
\n\n {business_logo}
', 'Dear {contact_name}, We have received a payment of {paid_amount}. {business_name}', 'Payment Received, from {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(3, 1, 'payment_reminder', 'Dear {contact_name},
\n\n This is to remind you that you have pending payment of {due_amount}. Kindly pay it as soon as possible.
\n\n {business_logo}
', 'Dear {contact_name}, You have pending payment of {due_amount}. Kindly pay it as soon as possible. {business_name}', 'Payment Reminder, from {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(4, 1, 'new_booking', 'Dear {contact_name},
\n\n Your booking is confirmed
\n\n Date: {start_time} to {end_time}
\n\n Table: {table}
\n\n Location: {location}
\n\n {business_logo}
', 'Dear {contact_name}, Your booking is confirmed. Date: {start_time} to {end_time}, Table: {table}, Location: {location}', 'Booking Confirmed - {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(5, 1, 'new_order', 'Dear {contact_name},
\n\n We have a new order with reference number {invoice_number}. Kindly process the products as soon as possible.
\n\n {business_name}
\n {business_logo}
', 'Dear {contact_name}, We have a new order with reference number {invoice_number}. Kindly process the products as soon as possible. {business_name}', 'New Order, from {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(6, 1, 'payment_paid', 'Dear {contact_name},
\n\n We have paid amount {paid_amount} again invoice number {invoice_number}.
\n Kindly note it down.
\n\n {business_name}
\n {business_logo}
', 'We have paid amount {paid_amount} again invoice number {invoice_number}.\n Kindly note it down. {business_name}', 'Payment Paid, from {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(7, 1, 'items_received', 'Dear {contact_name},
\n\n We have received all items from invoice reference number {invoice_number}. Thank you for processing it.
\n\n {business_name}
\n {business_logo}
', 'We have received all items from invoice reference number {invoice_number}. Thank you for processing it. {business_name}', 'Items received, from {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(8, 1, 'items_pending', 'Dear {contact_name},
\n This is to remind you that we have not yet received some items from invoice reference number {invoice_number}. Please process it as soon as possible.
\n\n {business_name}
\n {business_logo}
', 'This is to remind you that we have not yet received some items from invoice reference number {invoice_number} . Please process it as soon as possible.{business_name}', 'Items Pending, from {business_name}', 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(9, 2, 'new_sale', 'Dear {contact_name},
\n\n Your invoice number is {invoice_number}
\n Total amount: {total_amount}
\n Paid amount: {paid_amount}
\n\n Thank you for shopping with us.
\n\n {business_logo}
\n\n
', 'Dear {contact_name}, Thank you for shopping with us. {business_name}', 'Thank you from {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(10, 2, 'payment_received', 'Dear {contact_name},
\n\n We have received a payment of {paid_amount}
\n\n {business_logo}
', 'Dear {contact_name}, We have received a payment of {paid_amount}. {business_name}', 'Payment Received, from {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(11, 2, 'payment_reminder', 'Dear {contact_name},
\n\n This is to remind you that you have pending payment of {due_amount}. Kindly pay it as soon as possible.
\n\n {business_logo}
', 'Dear {contact_name}, You have pending payment of {due_amount}. Kindly pay it as soon as possible. {business_name}', 'Payment Reminder, from {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(12, 2, 'new_booking', 'Dear {contact_name},
\n\n Your booking is confirmed
\n\n Date: {start_time} to {end_time}
\n\n Table: {table}
\n\n Location: {location}
\n\n {business_logo}
', 'Dear {contact_name}, Your booking is confirmed. Date: {start_time} to {end_time}, Table: {table}, Location: {location}', 'Booking Confirmed - {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(13, 2, 'new_order', 'Dear {contact_name},
\n\n We have a new order with reference number {invoice_number}. Kindly process the products as soon as possible.
\n\n {business_name}
\n {business_logo}
', 'Dear {contact_name}, We have a new order with reference number {invoice_number}. Kindly process the products as soon as possible. {business_name}', 'New Order, from {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(14, 2, 'payment_paid', 'Dear {contact_name},
\n\n We have paid amount {paid_amount} again invoice number {invoice_number}.
\n Kindly note it down.
\n\n {business_name}
\n {business_logo}
', 'We have paid amount {paid_amount} again invoice number {invoice_number}.\n Kindly note it down. {business_name}', 'Payment Paid, from {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(15, 2, 'items_received', 'Dear {contact_name},
\n\n We have received all items from invoice reference number {invoice_number}. Thank you for processing it.
\n\n {business_name}
\n {business_logo}
', 'We have received all items from invoice reference number {invoice_number}. Thank you for processing it. {business_name}', 'Items received, from {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(16, 2, 'items_pending', 'Dear {contact_name},
\n This is to remind you that we have not yet received some items from invoice reference number {invoice_number}. Please process it as soon as possible.
\n\n {business_name}
\n {business_logo}
', 'This is to remind you that we have not yet received some items from invoice reference number {invoice_number} . Please process it as soon as possible.{business_name}', 'Items Pending, from {business_name}', 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `permissions`
--
CREATE TABLE `permissions` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `permissions`
--
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'profit_loss_report.view', 'web', '2019-01-16 20:39:53', NULL),
(2, 'direct_sell.access', 'web', '2019-01-16 20:39:53', NULL),
(3, 'product.opening_stock', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(4, 'crud_all_bookings', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(5, 'crud_own_bookings', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(6, 'access_default_selling_price', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(7, 'purchase.payments', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(8, 'sell.payments', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(9, 'edit_product_price_from_sale_screen', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(10, 'edit_product_discount_from_sale_screen', 'web', '2019-01-16 20:39:53', '2019-01-16 20:39:53'),
(11, 'roles.view', 'web', '2019-01-16 20:39:54', '2019-01-16 20:39:54'),
(12, 'roles.create', 'web', '2019-01-16 20:39:54', '2019-01-16 20:39:54'),
(13, 'roles.update', 'web', '2019-01-16 20:39:54', '2019-01-16 20:39:54'),
(14, 'roles.delete', 'web', '2019-01-16 20:39:54', '2019-01-16 20:39:54'),
(15, 'user.view', 'web', '2019-01-16 20:39:54', NULL),
(16, 'user.create', 'web', '2019-01-16 20:39:54', NULL),
(17, 'user.update', 'web', '2019-01-16 20:39:54', NULL),
(18, 'user.delete', 'web', '2019-01-16 20:39:54', NULL),
(19, 'supplier.view', 'web', '2019-01-16 20:39:54', NULL),
(20, 'supplier.create', 'web', '2019-01-16 20:39:54', NULL),
(21, 'supplier.update', 'web', '2019-01-16 20:39:54', NULL),
(22, 'supplier.delete', 'web', '2019-01-16 20:39:54', NULL),
(23, 'customer.view', 'web', '2019-01-16 20:39:54', NULL),
(24, 'customer.create', 'web', '2019-01-16 20:39:54', NULL),
(25, 'customer.update', 'web', '2019-01-16 20:39:54', NULL),
(26, 'customer.delete', 'web', '2019-01-16 20:39:54', NULL),
(27, 'product.view', 'web', '2019-01-16 20:39:54', NULL),
(28, 'product.create', 'web', '2019-01-16 20:39:54', NULL),
(29, 'product.update', 'web', '2019-01-16 20:39:54', NULL),
(30, 'product.delete', 'web', '2019-01-16 20:39:54', NULL),
(31, 'purchase.view', 'web', '2019-01-16 20:39:54', NULL),
(32, 'purchase.create', 'web', '2019-01-16 20:39:54', NULL),
(33, 'purchase.update', 'web', '2019-01-16 20:39:54', NULL),
(34, 'purchase.delete', 'web', '2019-01-16 20:39:54', NULL),
(35, 'sell.view', 'web', '2019-01-16 20:39:54', NULL),
(36, 'sell.create', 'web', '2019-01-16 20:39:54', NULL),
(37, 'sell.update', 'web', '2019-01-16 20:39:54', NULL),
(38, 'sell.delete', 'web', '2019-01-16 20:39:54', NULL),
(39, 'purchase_n_sell_report.view', 'web', '2019-01-16 20:39:54', NULL),
(40, 'contacts_report.view', 'web', '2019-01-16 20:39:54', NULL),
(41, 'stock_report.view', 'web', '2019-01-16 20:39:54', NULL),
(42, 'tax_report.view', 'web', '2019-01-16 20:39:54', NULL),
(43, 'trending_product_report.view', 'web', '2019-01-16 20:39:54', NULL),
(44, 'register_report.view', 'web', '2019-01-16 20:39:54', NULL),
(45, 'sales_representative.view', 'web', '2019-01-16 20:39:54', NULL),
(46, 'expense_report.view', 'web', '2019-01-16 20:39:54', NULL),
(47, 'business_settings.access', 'web', '2019-01-16 20:39:54', NULL),
(48, 'barcode_settings.access', 'web', '2019-01-16 20:39:54', NULL),
(49, 'invoice_settings.access', 'web', '2019-01-16 20:39:54', NULL),
(50, 'brand.view', 'web', '2019-01-16 20:39:54', NULL),
(51, 'brand.create', 'web', '2019-01-16 20:39:54', NULL),
(52, 'brand.update', 'web', '2019-01-16 20:39:54', NULL),
(53, 'brand.delete', 'web', '2019-01-16 20:39:54', NULL),
(54, 'tax_rate.view', 'web', '2019-01-16 20:39:54', NULL),
(55, 'tax_rate.create', 'web', '2019-01-16 20:39:54', NULL),
(56, 'tax_rate.update', 'web', '2019-01-16 20:39:54', NULL),
(57, 'tax_rate.delete', 'web', '2019-01-16 20:39:54', NULL),
(58, 'unit.view', 'web', '2019-01-16 20:39:54', NULL),
(59, 'unit.create', 'web', '2019-01-16 20:39:54', NULL),
(60, 'unit.update', 'web', '2019-01-16 20:39:54', NULL),
(61, 'unit.delete', 'web', '2019-01-16 20:39:54', NULL),
(62, 'category.view', 'web', '2019-01-16 20:39:54', NULL),
(63, 'category.create', 'web', '2019-01-16 20:39:54', NULL),
(64, 'category.update', 'web', '2019-01-16 20:39:54', NULL),
(65, 'category.delete', 'web', '2019-01-16 20:39:54', NULL),
(66, 'expense.access', 'web', '2019-01-16 20:39:54', NULL),
(67, 'access_all_locations', 'web', '2019-01-16 20:39:54', NULL),
(68, 'dashboard.data', 'web', '2019-01-16 20:39:54', NULL),
(69, 'location.1', 'web', '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(70, 'location.2', 'web', '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(71, 'selling_price_group.1', 'web', '2019-01-16 22:08:23', '2019-01-16 22:08:23');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `printers`
--
CREATE TABLE `printers` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection_type` enum('network','windows','linux') COLLATE utf8mb4_unicode_ci NOT NULL,
`capability_profile` enum('default','simple','SP2000','TEP-200M','P822D') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
`char_per_line` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`port` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `products`
--
CREATE TABLE `products` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`type` enum('single','variable','modifier') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`unit_id` int(11) UNSIGNED DEFAULT NULL,
`brand_id` int(10) UNSIGNED DEFAULT NULL,
`category_id` int(10) UNSIGNED DEFAULT NULL,
`sub_category_id` int(10) UNSIGNED DEFAULT NULL,
`tax` int(10) UNSIGNED DEFAULT NULL,
`tax_type` enum('inclusive','exclusive') COLLATE utf8mb4_unicode_ci NOT NULL,
`enable_stock` tinyint(1) NOT NULL DEFAULT 0,
`alert_quantity` int(11) NOT NULL,
`sku` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`barcode_type` enum('C39','C128','EAN13','EAN8','UPCA','UPCE') COLLATE utf8mb4_unicode_ci DEFAULT 'C128',
`expiry_period` decimal(4,2) DEFAULT NULL,
`expiry_period_type` enum('days','months') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`enable_sr_no` tinyint(1) NOT NULL DEFAULT 0,
`weight` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_custom_field1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_custom_field2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_custom_field3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_custom_field4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `products`
--
INSERT INTO `products` (`id`, `name`, `business_id`, `type`, `unit_id`, `brand_id`, `category_id`, `sub_category_id`, `tax`, `tax_type`, `enable_stock`, `alert_quantity`, `sku`, `barcode_type`, `expiry_period`, `expiry_period_type`, `enable_sr_no`, `weight`, `product_custom_field1`, `product_custom_field2`, `product_custom_field3`, `product_custom_field4`, `image`, `product_description`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Asus core i5', 2, 'single', 2, 1, 2, NULL, NULL, 'exclusive', 1, 5, '0001', 'C128', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '1547675724_core i5 hp.jpg', '15. PULGADAS 4 GB DE RAM
\r\n\r\nDD 1TB
', 2, '2019-01-16 21:55:24', '2019-01-16 21:55:24'),
(2, 'asus core i7', 2, 'single', 2, 4, 2, NULL, NULL, 'exclusive', 1, 5, '0002', 'C128', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '1547675956_asus core i7.jpg', 'asus core i7
\r\n\r\n2TB HDD
\r\n\r\n2 GB VIDEO DEDICADO
\r\n\r\nRAM 8GB
', 2, '2019-01-16 21:59:16', '2019-01-16 21:59:16'),
(3, 'DSICO DURO TOSHIBA', 2, 'single', 2, 3, 2, NULL, NULL, 'inclusive', 1, 5, '0003', 'C128', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '1547676049_dsico duro externo toshiba.jpg', 'DISCO DURO USB 3.0
\r\n\r\nCAPACIDAD 1000GB
', 2, '2019-01-16 22:00:49', '2019-01-16 22:00:49');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `product_racks`
--
CREATE TABLE `product_racks` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`location_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`rack` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`row` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `product_variations`
--
CREATE TABLE `product_variations` (
`id` int(10) UNSIGNED NOT NULL,
`variation_template_id` int(11) DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`is_dummy` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `product_variations`
--
INSERT INTO `product_variations` (`id`, `variation_template_id`, `name`, `product_id`, `is_dummy`, `created_at`, `updated_at`) VALUES
(1, NULL, 'DUMMY', 1, 1, '2019-01-16 21:55:24', '2019-01-16 21:55:24'),
(2, NULL, 'DUMMY', 2, 1, '2019-01-16 21:59:16', '2019-01-16 21:59:16'),
(3, NULL, 'DUMMY', 3, 1, '2019-01-16 22:00:49', '2019-01-16 22:00:49');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `purchase_lines`
--
CREATE TABLE `purchase_lines` (
`id` int(10) UNSIGNED NOT NULL,
`transaction_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`variation_id` int(10) UNSIGNED NOT NULL,
`quantity` decimal(20,4) NOT NULL,
`pp_without_discount` decimal(20,2) NOT NULL DEFAULT 0.00 COMMENT 'Purchase price before inline discounts',
`discount_percent` decimal(5,2) NOT NULL DEFAULT 0.00 COMMENT 'Inline discount percentage',
`purchase_price` decimal(20,2) DEFAULT NULL,
`purchase_price_inc_tax` decimal(20,2) NOT NULL DEFAULT 0.00,
`item_tax` decimal(20,2) DEFAULT NULL,
`tax_id` int(10) UNSIGNED DEFAULT NULL,
`quantity_sold` decimal(20,4) DEFAULT 0.0000,
`quantity_adjusted` decimal(20,4) DEFAULT 0.0000,
`quantity_returned` decimal(20,4) NOT NULL DEFAULT 0.0000,
`mfg_date` date DEFAULT NULL,
`exp_date` date DEFAULT NULL,
`lot_number` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `purchase_lines`
--
INSERT INTO `purchase_lines` (`id`, `transaction_id`, `product_id`, `variation_id`, `quantity`, `pp_without_discount`, `discount_percent`, `purchase_price`, `purchase_price_inc_tax`, `item_tax`, `tax_id`, `quantity_sold`, `quantity_adjusted`, `quantity_returned`, `mfg_date`, `exp_date`, `lot_number`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, '50.0000', '18.00', '0.00', '18.00', '18.00', '0.00', NULL, '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, '2019-01-16 21:55:46', '2019-01-16 21:55:46'),
(2, 2, 2, 2, '40.0000', '3555.00', '0.00', '3555.00', '3555.00', '0.00', NULL, '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, '2019-01-16 21:59:24', '2019-01-16 22:13:00'),
(3, 3, 3, 3, '30.0000', '100.00', '0.00', '100.00', '100.00', '0.00', NULL, '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, '2019-01-16 22:01:29', '2019-01-16 22:01:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `reference_counts`
--
CREATE TABLE `reference_counts` (
`id` int(10) UNSIGNED NOT NULL,
`ref_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`ref_count` int(11) NOT NULL,
`business_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `reference_counts`
--
INSERT INTO `reference_counts` (`id`, `ref_type`, `ref_count`, `business_id`, `created_at`, `updated_at`) VALUES
(1, 'contacts', 1, 1, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 'business_location', 1, 1, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(3, 'contacts', 1, 2, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(4, 'business_location', 1, 2, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `res_product_modifier_sets`
--
CREATE TABLE `res_product_modifier_sets` (
`modifier_set_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL COMMENT 'Table use to store the modifier sets applicable for a product'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `res_tables`
--
CREATE TABLE `res_tables` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`location_id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `roles`
--
CREATE TABLE `roles` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`is_service_staff` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `roles`
--
INSERT INTO `roles` (`id`, `name`, `guard_name`, `business_id`, `is_default`, `is_service_staff`, `created_at`, `updated_at`) VALUES
(1, 'Admin#1', 'web', 1, 1, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 'Cashier#1', 'web', 1, 0, 0, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(3, 'Admin#2', 'web', 2, 1, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47'),
(4, 'Cashier#2', 'web', 2, 0, 0, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `role_has_permissions`
--
CREATE TABLE `role_has_permissions` (
`permission_id` int(10) UNSIGNED NOT NULL,
`role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `role_has_permissions`
--
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(35, 2),
(35, 4),
(36, 2),
(36, 4),
(37, 2),
(37, 4),
(38, 2),
(38, 4),
(67, 2),
(67, 4);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `selling_price_groups`
--
CREATE TABLE `selling_price_groups` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `selling_price_groups`
--
INSERT INTO `selling_price_groups` (`id`, `name`, `description`, `business_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'FERRE', 'FERTERIA EN GENERAL', 2, NULL, '2019-01-16 22:08:23', '2019-01-16 22:08:23');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `sessions`
--
CREATE TABLE `sessions` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int(10) UNSIGNED DEFAULT NULL,
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
`last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `stock_adjustments_temp`
--
CREATE TABLE `stock_adjustments_temp` (
`id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `stock_adjustment_lines`
--
CREATE TABLE `stock_adjustment_lines` (
`id` int(10) UNSIGNED NOT NULL,
`transaction_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`variation_id` int(10) UNSIGNED NOT NULL,
`quantity` decimal(20,4) NOT NULL,
`unit_price` decimal(20,2) DEFAULT NULL COMMENT 'Last purchase unit price',
`removed_purchase_line` int(11) DEFAULT NULL,
`lot_no_line_id` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `system`
--
CREATE TABLE `system` (
`id` int(10) UNSIGNED NOT NULL,
`key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `system`
--
INSERT INTO `system` (`id`, `key`, `value`) VALUES
(1, 'db_version', '2.11.4'),
(2, 'default_business_active_status', '1');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `tax_rates`
--
CREATE TABLE `tax_rates` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`amount` double(8,2) NOT NULL,
`is_tax_group` tinyint(1) NOT NULL DEFAULT 0,
`created_by` int(10) UNSIGNED NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `tax_rates`
--
INSERT INTO `tax_rates` (`id`, `business_id`, `name`, `amount`, `is_tax_group`, `created_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 2, 'ifv', 18.00, 0, 2, NULL, '2019-01-16 22:37:44', '2019-01-16 22:37:44');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `transactions`
--
CREATE TABLE `transactions` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`location_id` int(10) UNSIGNED NOT NULL,
`res_table_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'fields to restaurant module',
`res_waiter_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'fields to restaurant module',
`res_order_status` enum('received','cooked','served') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type` enum('purchase','sell','expense','stock_adjustment','sell_transfer','purchase_transfer','opening_stock','sell_return','opening_balance','purchase_return') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` enum('received','pending','ordered','draft','final') COLLATE utf8mb4_unicode_ci NOT NULL,
`is_quotation` tinyint(1) NOT NULL DEFAULT 0,
`payment_status` enum('paid','due','partial') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`adjustment_type` enum('normal','abnormal') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact_id` int(11) UNSIGNED DEFAULT NULL,
`customer_group_id` int(11) DEFAULT NULL COMMENT 'used to add customer group while selling',
`invoice_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`transaction_date` datetime NOT NULL,
`total_before_tax` decimal(20,2) NOT NULL DEFAULT 0.00,
`tax_id` int(10) UNSIGNED DEFAULT NULL,
`tax_amount` decimal(20,2) NOT NULL DEFAULT 0.00,
`discount_type` enum('fixed','percentage') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`discount_amount` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`shipping_details` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`shipping_charges` decimal(20,2) NOT NULL DEFAULT 0.00,
`additional_notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`staff_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`final_total` decimal(20,2) NOT NULL DEFAULT 0.00,
`expense_category_id` int(10) UNSIGNED DEFAULT NULL,
`expense_for` int(10) UNSIGNED DEFAULT NULL,
`commission_agent` int(11) DEFAULT NULL,
`document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_direct_sale` tinyint(1) NOT NULL DEFAULT 0,
`is_suspend` tinyint(1) NOT NULL DEFAULT 0,
`exchange_rate` decimal(20,3) NOT NULL DEFAULT 1.000,
`total_amount_recovered` decimal(20,2) DEFAULT NULL COMMENT 'Used for stock adjustment.',
`transfer_parent_id` int(11) DEFAULT NULL,
`return_parent_id` int(11) DEFAULT NULL,
`opening_stock_product_id` int(11) DEFAULT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`pay_term_number` int(11) DEFAULT NULL,
`pay_term_type` enum('days','months') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`selling_price_group_id` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `transactions`
--
INSERT INTO `transactions` (`id`, `business_id`, `location_id`, `res_table_id`, `res_waiter_id`, `res_order_status`, `type`, `status`, `is_quotation`, `payment_status`, `adjustment_type`, `contact_id`, `customer_group_id`, `invoice_no`, `ref_no`, `transaction_date`, `total_before_tax`, `tax_id`, `tax_amount`, `discount_type`, `discount_amount`, `shipping_details`, `shipping_charges`, `additional_notes`, `staff_note`, `final_total`, `expense_category_id`, `expense_for`, `commission_agent`, `document`, `is_direct_sale`, `is_suspend`, `exchange_rate`, `total_amount_recovered`, `transfer_parent_id`, `return_parent_id`, `opening_stock_product_id`, `created_by`, `pay_term_number`, `pay_term_type`, `selling_price_group_id`, `created_at`, `updated_at`) VALUES
(1, 2, 2, NULL, NULL, NULL, 'opening_stock', 'received', 0, 'paid', NULL, NULL, NULL, NULL, NULL, '2019-01-01 16:55:46', '900.00', NULL, '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, '900.00', NULL, NULL, NULL, NULL, 0, 0, '1.000', NULL, NULL, NULL, 1, 2, NULL, NULL, NULL, '2019-01-16 21:55:46', '2019-01-16 21:55:46'),
(2, 2, 2, NULL, NULL, NULL, 'opening_stock', 'received', 0, 'paid', NULL, NULL, NULL, NULL, NULL, '2019-01-01 16:59:24', '142200.00', NULL, '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, '142200.00', NULL, NULL, NULL, NULL, 0, 0, '1.000', NULL, NULL, NULL, 2, 2, NULL, NULL, NULL, '2019-01-16 21:59:24', '2019-01-16 22:13:00'),
(3, 2, 2, NULL, NULL, NULL, 'opening_stock', 'received', 0, 'paid', NULL, NULL, NULL, NULL, NULL, '2019-01-01 17:01:29', '3000.00', NULL, '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, '3000.00', NULL, NULL, NULL, NULL, 0, 0, '1.000', NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, '2019-01-16 22:01:29', '2019-01-16 22:01:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `transaction_payments`
--
CREATE TABLE `transaction_payments` (
`id` int(10) UNSIGNED NOT NULL,
`transaction_id` int(11) UNSIGNED DEFAULT NULL,
`business_id` int(11) DEFAULT NULL,
`is_return` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Used during sales to return the change',
`amount` decimal(20,2) NOT NULL DEFAULT 0.00,
`method` enum('cash','card','cheque','bank_transfer','custom_pay_1','custom_pay_2','custom_pay_3','other') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`transaction_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_transaction_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_holder_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_month` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_security` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cheque_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bank_account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`paid_on` datetime DEFAULT NULL,
`created_by` int(11) NOT NULL,
`payment_for` int(11) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`payment_ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`account_id` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `transaction_sell_lines`
--
CREATE TABLE `transaction_sell_lines` (
`id` int(10) UNSIGNED NOT NULL,
`transaction_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`variation_id` int(10) UNSIGNED NOT NULL,
`quantity` decimal(20,4) NOT NULL,
`quantity_returned` decimal(20,4) NOT NULL DEFAULT 0.0000,
`unit_price_before_discount` decimal(20,2) NOT NULL DEFAULT 0.00,
`unit_price` decimal(20,2) DEFAULT NULL,
`line_discount_type` enum('fixed','percentage') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`line_discount_amount` decimal(20,2) NOT NULL DEFAULT 0.00,
`unit_price_inc_tax` decimal(20,2) DEFAULT NULL,
`item_tax` decimal(20,2) DEFAULT NULL,
`tax_id` int(10) UNSIGNED DEFAULT NULL,
`lot_no_line_id` int(11) DEFAULT NULL,
`sell_line_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`parent_sell_line_id` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `transaction_sell_lines_purchase_lines`
--
CREATE TABLE `transaction_sell_lines_purchase_lines` (
`id` int(10) UNSIGNED NOT NULL,
`sell_line_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'id from transaction_sell_lines',
`stock_adjustment_line_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'id from stock_adjustment_lines',
`purchase_line_id` int(10) UNSIGNED NOT NULL COMMENT 'id from purchase_lines',
`quantity` decimal(20,4) NOT NULL,
`qty_returned` decimal(20,4) NOT NULL DEFAULT 0.0000,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `units`
--
CREATE TABLE `units` (
`id` int(10) UNSIGNED NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`actual_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`short_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`allow_decimal` tinyint(1) NOT NULL,
`created_by` int(10) UNSIGNED NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `units`
--
INSERT INTO `units` (`id`, `business_id`, `actual_name`, `short_name`, `allow_decimal`, `created_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Pieces', 'Pc(s)', 0, 1, NULL, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 2, 'Pieces', 'Pc(s)', 0, 2, NULL, '2019-01-16 21:11:47', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `users`
--
CREATE TABLE `users` (
`id` int(10) UNSIGNED NOT NULL,
`surname` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`language` char(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
`contact_no` char(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`business_id` int(10) UNSIGNED DEFAULT NULL,
`status` enum('active','inactive','terminated') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
`is_cmmsn_agnt` tinyint(1) NOT NULL DEFAULT 0,
`cmmsn_percent` decimal(4,2) NOT NULL DEFAULT 0.00,
`selected_contacts` tinyint(1) NOT NULL DEFAULT 0,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `users`
--
INSERT INTO `users` (`id`, `surname`, `first_name`, `last_name`, `username`, `email`, `password`, `language`, `contact_no`, `address`, `remember_token`, `business_id`, `status`, `is_cmmsn_agnt`, `cmmsn_percent`, `selected_contacts`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 't', 't', 't', 'test', 'test@test.com', '$2y$10$rdiVXRuIlq4ti5GBVZBFs.nxzPQWOT3MdyNzBELEY1hpFAn2bbFVO', 'en', NULL, NULL, NULL, 1, 'active', 0, '0.00', 0, NULL, '2019-01-16 21:02:50', '2019-01-16 21:02:50'),
(2, 'Sr', 'tusolutionweb', 'tutos', 'tusolutionweb', 'tusolutionweb@gmail.com', '$2y$10$sgGzSDBE3OVy48BbN0kCKuPUvfi0sdjwGHzAOVQdXZYpn5RVVj7kO', 'es', NULL, NULL, 'OoZtNJc1jHR6Zyx11XNt7cD8fnyfRntnmgVJqY45s6bUfYi92feQGmc7uEO0', 2, 'active', 0, '0.00', 0, NULL, '2019-01-16 21:11:46', '2019-01-16 21:11:47');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `user_contact_access`
--
CREATE TABLE `user_contact_access` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `variations`
--
CREATE TABLE `variations` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`sub_sku` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_variation_id` int(10) UNSIGNED NOT NULL,
`variation_value_id` int(11) DEFAULT NULL,
`default_purchase_price` decimal(20,2) DEFAULT NULL,
`dpp_inc_tax` decimal(20,2) NOT NULL DEFAULT 0.00,
`profit_percent` decimal(20,2) NOT NULL DEFAULT 0.00,
`default_sell_price` decimal(20,2) DEFAULT NULL,
`sell_price_inc_tax` decimal(20,2) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `variations`
--
INSERT INTO `variations` (`id`, `name`, `product_id`, `sub_sku`, `product_variation_id`, `variation_value_id`, `default_purchase_price`, `dpp_inc_tax`, `profit_percent`, `default_sell_price`, `sell_price_inc_tax`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'DUMMY', 1, '0001', 1, NULL, '2000.00', '2000.00', '18.00', '2360.00', '2360.00', '2019-01-16 21:55:24', '2019-01-16 22:41:56', NULL),
(2, 'DUMMY', 2, '0002', 2, NULL, '3700.00', '3700.00', '25.00', '4625.00', '4625.00', '2019-01-16 21:59:16', '2019-01-16 22:40:13', NULL),
(3, 'DUMMY', 3, '0003', 3, NULL, '100.00', '100.00', '18.00', '118.00', '118.00', '2019-01-16 22:00:49', '2019-01-16 22:42:11', NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `variation_group_prices`
--
CREATE TABLE `variation_group_prices` (
`id` int(10) UNSIGNED NOT NULL,
`variation_id` int(10) UNSIGNED NOT NULL,
`price_group_id` int(10) UNSIGNED NOT NULL,
`price_inc_tax` decimal(20,2) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `variation_group_prices`
--
INSERT INTO `variation_group_prices` (`id`, `variation_id`, `price_group_id`, `price_inc_tax`, `created_at`, `updated_at`) VALUES
(1, 3, 1, '100.00', '2019-01-16 22:09:22', '2019-01-16 22:09:22'),
(2, 2, 1, '3700.00', '2019-01-16 22:09:40', '2019-01-16 22:09:40'),
(3, 1, 1, '2000.00', '2019-01-16 22:10:04', '2019-01-16 22:39:30');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `variation_location_details`
--
CREATE TABLE `variation_location_details` (
`id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`product_variation_id` int(10) UNSIGNED NOT NULL COMMENT 'id from product_variations table',
`variation_id` int(10) UNSIGNED NOT NULL,
`location_id` int(10) UNSIGNED NOT NULL,
`qty_available` decimal(20,4) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Volcado de datos para la tabla `variation_location_details`
--
INSERT INTO `variation_location_details` (`id`, `product_id`, `product_variation_id`, `variation_id`, `location_id`, `qty_available`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 2, '50.0000', '2019-01-16 21:55:46', '2019-01-16 21:55:46'),
(2, 2, 2, 2, 2, '40.0000', '2019-01-16 21:59:24', '2019-01-16 21:59:24'),
(3, 3, 3, 3, 2, '30.0000', '2019-01-16 22:01:29', '2019-01-16 22:01:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `variation_templates`
--
CREATE TABLE `variation_templates` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`business_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `variation_value_templates`
--
CREATE TABLE `variation_value_templates` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`variation_template_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Índices para tablas volcadas
--
--
-- Indices de la tabla `barcodes`
--
ALTER TABLE `barcodes`
ADD PRIMARY KEY (`id`),
ADD KEY `barcodes_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `bookings`
--
ALTER TABLE `bookings`
ADD PRIMARY KEY (`id`),
ADD KEY `bookings_contact_id_foreign` (`contact_id`),
ADD KEY `bookings_business_id_foreign` (`business_id`),
ADD KEY `bookings_created_by_foreign` (`created_by`);
--
-- Indices de la tabla `brands`
--
ALTER TABLE `brands`
ADD PRIMARY KEY (`id`),
ADD KEY `brands_business_id_foreign` (`business_id`),
ADD KEY `brands_created_by_foreign` (`created_by`);
--
-- Indices de la tabla `business`
--
ALTER TABLE `business`
ADD PRIMARY KEY (`id`),
ADD KEY `business_owner_id_foreign` (`owner_id`),
ADD KEY `business_currency_id_foreign` (`currency_id`),
ADD KEY `business_default_sales_tax_foreign` (`default_sales_tax`);
--
-- Indices de la tabla `business_locations`
--
ALTER TABLE `business_locations`
ADD PRIMARY KEY (`id`),
ADD KEY `business_locations_business_id_index` (`business_id`),
ADD KEY `business_locations_invoice_scheme_id_foreign` (`invoice_scheme_id`),
ADD KEY `business_locations_invoice_layout_id_foreign` (`invoice_layout_id`);
--
-- Indices de la tabla `cash_registers`
--
ALTER TABLE `cash_registers`
ADD PRIMARY KEY (`id`),
ADD KEY `cash_registers_business_id_foreign` (`business_id`),
ADD KEY `cash_registers_user_id_foreign` (`user_id`);
--
-- Indices de la tabla `cash_register_transactions`
--
ALTER TABLE `cash_register_transactions`
ADD PRIMARY KEY (`id`),
ADD KEY `cash_register_transactions_cash_register_id_foreign` (`cash_register_id`);
--
-- Indices de la tabla `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`id`),
ADD KEY `categories_business_id_foreign` (`business_id`),
ADD KEY `categories_created_by_foreign` (`created_by`);
--
-- Indices de la tabla `contacts`
--
ALTER TABLE `contacts`
ADD PRIMARY KEY (`id`),
ADD KEY `contacts_business_id_foreign` (`business_id`),
ADD KEY `contacts_created_by_foreign` (`created_by`);
--
-- Indices de la tabla `currencies`
--
ALTER TABLE `currencies`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `customer_groups`
--
ALTER TABLE `customer_groups`
ADD PRIMARY KEY (`id`),
ADD KEY `customer_groups_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `expense_categories`
--
ALTER TABLE `expense_categories`
ADD PRIMARY KEY (`id`),
ADD KEY `expense_categories_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `group_sub_taxes`
--
ALTER TABLE `group_sub_taxes`
ADD KEY `group_sub_taxes_group_tax_id_foreign` (`group_tax_id`),
ADD KEY `group_sub_taxes_tax_id_foreign` (`tax_id`);
--
-- Indices de la tabla `invoice_layouts`
--
ALTER TABLE `invoice_layouts`
ADD PRIMARY KEY (`id`),
ADD KEY `invoice_layouts_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `invoice_schemes`
--
ALTER TABLE `invoice_schemes`
ADD PRIMARY KEY (`id`),
ADD KEY `invoice_schemes_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);
--
-- Indices de la tabla `model_has_roles`
--
ALTER TABLE `model_has_roles`
ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);
--
-- Indices de la tabla `notification_templates`
--
ALTER TABLE `notification_templates`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);
--
-- Indices de la tabla `permissions`
--
ALTER TABLE `permissions`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `printers`
--
ALTER TABLE `printers`
ADD PRIMARY KEY (`id`),
ADD KEY `printers_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`),
ADD KEY `products_brand_id_foreign` (`brand_id`),
ADD KEY `products_category_id_foreign` (`category_id`),
ADD KEY `products_sub_category_id_foreign` (`sub_category_id`),
ADD KEY `products_tax_foreign` (`tax`),
ADD KEY `products_name_index` (`name`),
ADD KEY `products_business_id_index` (`business_id`),
ADD KEY `products_unit_id_index` (`unit_id`),
ADD KEY `products_created_by_index` (`created_by`);
--
-- Indices de la tabla `product_racks`
--
ALTER TABLE `product_racks`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `product_variations`
--
ALTER TABLE `product_variations`
ADD PRIMARY KEY (`id`),
ADD KEY `product_variations_name_index` (`name`),
ADD KEY `product_variations_product_id_index` (`product_id`);
--
-- Indices de la tabla `purchase_lines`
--
ALTER TABLE `purchase_lines`
ADD PRIMARY KEY (`id`),
ADD KEY `purchase_lines_transaction_id_foreign` (`transaction_id`),
ADD KEY `purchase_lines_product_id_foreign` (`product_id`),
ADD KEY `purchase_lines_variation_id_foreign` (`variation_id`),
ADD KEY `purchase_lines_tax_id_foreign` (`tax_id`);
--
-- Indices de la tabla `reference_counts`
--
ALTER TABLE `reference_counts`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `res_product_modifier_sets`
--
ALTER TABLE `res_product_modifier_sets`
ADD KEY `res_product_modifier_sets_modifier_set_id_foreign` (`modifier_set_id`);
--
-- Indices de la tabla `res_tables`
--
ALTER TABLE `res_tables`
ADD PRIMARY KEY (`id`),
ADD KEY `res_tables_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`),
ADD KEY `roles_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
ADD PRIMARY KEY (`permission_id`,`role_id`),
ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);
--
-- Indices de la tabla `selling_price_groups`
--
ALTER TABLE `selling_price_groups`
ADD PRIMARY KEY (`id`),
ADD KEY `selling_price_groups_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `sessions`
--
ALTER TABLE `sessions`
ADD UNIQUE KEY `sessions_id_unique` (`id`);
--
-- Indices de la tabla `stock_adjustment_lines`
--
ALTER TABLE `stock_adjustment_lines`
ADD PRIMARY KEY (`id`),
ADD KEY `stock_adjustment_lines_product_id_foreign` (`product_id`),
ADD KEY `stock_adjustment_lines_variation_id_foreign` (`variation_id`),
ADD KEY `stock_adjustment_lines_transaction_id_index` (`transaction_id`);
--
-- Indices de la tabla `system`
--
ALTER TABLE `system`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `tax_rates`
--
ALTER TABLE `tax_rates`
ADD PRIMARY KEY (`id`),
ADD KEY `tax_rates_business_id_foreign` (`business_id`),
ADD KEY `tax_rates_created_by_foreign` (`created_by`);
--
-- Indices de la tabla `transactions`
--
ALTER TABLE `transactions`
ADD PRIMARY KEY (`id`),
ADD KEY `transactions_tax_id_foreign` (`tax_id`),
ADD KEY `transactions_business_id_index` (`business_id`),
ADD KEY `transactions_type_index` (`type`),
ADD KEY `transactions_contact_id_index` (`contact_id`),
ADD KEY `transactions_transaction_date_index` (`transaction_date`),
ADD KEY `transactions_created_by_index` (`created_by`),
ADD KEY `transactions_location_id_index` (`location_id`),
ADD KEY `transactions_expense_for_foreign` (`expense_for`),
ADD KEY `transactions_expense_category_id_index` (`expense_category_id`);
--
-- Indices de la tabla `transaction_payments`
--
ALTER TABLE `transaction_payments`
ADD PRIMARY KEY (`id`),
ADD KEY `transaction_payments_transaction_id_foreign` (`transaction_id`),
ADD KEY `transaction_payments_created_by_index` (`created_by`);
--
-- Indices de la tabla `transaction_sell_lines`
--
ALTER TABLE `transaction_sell_lines`
ADD PRIMARY KEY (`id`),
ADD KEY `transaction_sell_lines_transaction_id_foreign` (`transaction_id`),
ADD KEY `transaction_sell_lines_product_id_foreign` (`product_id`),
ADD KEY `transaction_sell_lines_variation_id_foreign` (`variation_id`),
ADD KEY `transaction_sell_lines_tax_id_foreign` (`tax_id`);
--
-- Indices de la tabla `transaction_sell_lines_purchase_lines`
--
ALTER TABLE `transaction_sell_lines_purchase_lines`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `units`
--
ALTER TABLE `units`
ADD PRIMARY KEY (`id`),
ADD KEY `units_business_id_foreign` (`business_id`),
ADD KEY `units_created_by_foreign` (`created_by`);
--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_username_unique` (`username`),
ADD KEY `users_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `user_contact_access`
--
ALTER TABLE `user_contact_access`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `variations`
--
ALTER TABLE `variations`
ADD PRIMARY KEY (`id`),
ADD KEY `variations_product_id_foreign` (`product_id`),
ADD KEY `variations_product_variation_id_foreign` (`product_variation_id`),
ADD KEY `variations_name_index` (`name`),
ADD KEY `variations_sub_sku_index` (`sub_sku`);
--
-- Indices de la tabla `variation_group_prices`
--
ALTER TABLE `variation_group_prices`
ADD PRIMARY KEY (`id`),
ADD KEY `variation_group_prices_variation_id_foreign` (`variation_id`),
ADD KEY `variation_group_prices_price_group_id_foreign` (`price_group_id`);
--
-- Indices de la tabla `variation_location_details`
--
ALTER TABLE `variation_location_details`
ADD PRIMARY KEY (`id`),
ADD KEY `variation_location_details_location_id_foreign` (`location_id`),
ADD KEY `variation_location_details_product_id_index` (`product_id`),
ADD KEY `variation_location_details_product_variation_id_index` (`product_variation_id`),
ADD KEY `variation_location_details_variation_id_index` (`variation_id`);
--
-- Indices de la tabla `variation_templates`
--
ALTER TABLE `variation_templates`
ADD PRIMARY KEY (`id`),
ADD KEY `variation_templates_business_id_foreign` (`business_id`);
--
-- Indices de la tabla `variation_value_templates`
--
ALTER TABLE `variation_value_templates`
ADD PRIMARY KEY (`id`),
ADD KEY `variation_value_templates_name_index` (`name`),
ADD KEY `variation_value_templates_variation_template_id_index` (`variation_template_id`);
--
-- AUTO_INCREMENT de las tablas volcadas
--
--
-- AUTO_INCREMENT de la tabla `barcodes`
--
ALTER TABLE `barcodes`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT de la tabla `bookings`
--
ALTER TABLE `bookings`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `brands`
--
ALTER TABLE `brands`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT de la tabla `business`
--
ALTER TABLE `business`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `business_locations`
--
ALTER TABLE `business_locations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `cash_registers`
--
ALTER TABLE `cash_registers`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `cash_register_transactions`
--
ALTER TABLE `cash_register_transactions`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `categories`
--
ALTER TABLE `categories`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `contacts`
--
ALTER TABLE `contacts`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `currencies`
--
ALTER TABLE `currencies`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137;
--
-- AUTO_INCREMENT de la tabla `customer_groups`
--
ALTER TABLE `customer_groups`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `expense_categories`
--
ALTER TABLE `expense_categories`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `invoice_layouts`
--
ALTER TABLE `invoice_layouts`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `invoice_schemes`
--
ALTER TABLE `invoice_schemes`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154;
--
-- AUTO_INCREMENT de la tabla `notification_templates`
--
ALTER TABLE `notification_templates`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT de la tabla `permissions`
--
ALTER TABLE `permissions`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;
--
-- AUTO_INCREMENT de la tabla `printers`
--
ALTER TABLE `printers`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `products`
--
ALTER TABLE `products`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `product_racks`
--
ALTER TABLE `product_racks`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `product_variations`
--
ALTER TABLE `product_variations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `purchase_lines`
--
ALTER TABLE `purchase_lines`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `reference_counts`
--
ALTER TABLE `reference_counts`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT de la tabla `res_tables`
--
ALTER TABLE `res_tables`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `roles`
--
ALTER TABLE `roles`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT de la tabla `selling_price_groups`
--
ALTER TABLE `selling_price_groups`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `stock_adjustment_lines`
--
ALTER TABLE `stock_adjustment_lines`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `system`
--
ALTER TABLE `system`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `tax_rates`
--
ALTER TABLE `tax_rates`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `transactions`
--
ALTER TABLE `transactions`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `transaction_payments`
--
ALTER TABLE `transaction_payments`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `transaction_sell_lines`
--
ALTER TABLE `transaction_sell_lines`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `transaction_sell_lines_purchase_lines`
--
ALTER TABLE `transaction_sell_lines_purchase_lines`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `units`
--
ALTER TABLE `units`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `user_contact_access`
--
ALTER TABLE `user_contact_access`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `variations`
--
ALTER TABLE `variations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `variation_group_prices`
--
ALTER TABLE `variation_group_prices`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `variation_location_details`
--
ALTER TABLE `variation_location_details`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `variation_templates`
--
ALTER TABLE `variation_templates`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `variation_value_templates`
--
ALTER TABLE `variation_value_templates`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Restricciones para tablas volcadas
--
--
-- Filtros para la tabla `barcodes`
--
ALTER TABLE `barcodes`
ADD CONSTRAINT `barcodes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `bookings`
--
ALTER TABLE `bookings`
ADD CONSTRAINT `bookings_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `bookings_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `bookings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `brands`
--
ALTER TABLE `brands`
ADD CONSTRAINT `brands_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `brands_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `business`
--
ALTER TABLE `business`
ADD CONSTRAINT `business_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
ADD CONSTRAINT `business_default_sales_tax_foreign` FOREIGN KEY (`default_sales_tax`) REFERENCES `tax_rates` (`id`),
ADD CONSTRAINT `business_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `business_locations`
--
ALTER TABLE `business_locations`
ADD CONSTRAINT `business_locations_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `business_locations_invoice_layout_id_foreign` FOREIGN KEY (`invoice_layout_id`) REFERENCES `invoice_layouts` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `business_locations_invoice_scheme_id_foreign` FOREIGN KEY (`invoice_scheme_id`) REFERENCES `invoice_schemes` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `cash_registers`
--
ALTER TABLE `cash_registers`
ADD CONSTRAINT `cash_registers_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `cash_registers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `cash_register_transactions`
--
ALTER TABLE `cash_register_transactions`
ADD CONSTRAINT `cash_register_transactions_cash_register_id_foreign` FOREIGN KEY (`cash_register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `categories`
--
ALTER TABLE `categories`
ADD CONSTRAINT `categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `contacts`
--
ALTER TABLE `contacts`
ADD CONSTRAINT `contacts_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `contacts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `customer_groups`
--
ALTER TABLE `customer_groups`
ADD CONSTRAINT `customer_groups_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `expense_categories`
--
ALTER TABLE `expense_categories`
ADD CONSTRAINT `expense_categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `group_sub_taxes`
--
ALTER TABLE `group_sub_taxes`
ADD CONSTRAINT `group_sub_taxes_group_tax_id_foreign` FOREIGN KEY (`group_tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `group_sub_taxes_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `invoice_layouts`
--
ALTER TABLE `invoice_layouts`
ADD CONSTRAINT `invoice_layouts_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `invoice_schemes`
--
ALTER TABLE `invoice_schemes`
ADD CONSTRAINT `invoice_schemes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `model_has_roles`
--
ALTER TABLE `model_has_roles`
ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `printers`
--
ALTER TABLE `printers`
ADD CONSTRAINT `printers_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `products`
--
ALTER TABLE `products`
ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `products_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `products_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `products_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `products_tax_foreign` FOREIGN KEY (`tax`) REFERENCES `tax_rates` (`id`),
ADD CONSTRAINT `products_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `product_variations`
--
ALTER TABLE `product_variations`
ADD CONSTRAINT `product_variations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `purchase_lines`
--
ALTER TABLE `purchase_lines`
ADD CONSTRAINT `purchase_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `purchase_lines_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `purchase_lines_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `purchase_lines_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `res_product_modifier_sets`
--
ALTER TABLE `res_product_modifier_sets`
ADD CONSTRAINT `res_product_modifier_sets_modifier_set_id_foreign` FOREIGN KEY (`modifier_set_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `res_tables`
--
ALTER TABLE `res_tables`
ADD CONSTRAINT `res_tables_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `roles`
--
ALTER TABLE `roles`
ADD CONSTRAINT `roles_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `selling_price_groups`
--
ALTER TABLE `selling_price_groups`
ADD CONSTRAINT `selling_price_groups_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `stock_adjustment_lines`
--
ALTER TABLE `stock_adjustment_lines`
ADD CONSTRAINT `stock_adjustment_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `stock_adjustment_lines_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `stock_adjustment_lines_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `tax_rates`
--
ALTER TABLE `tax_rates`
ADD CONSTRAINT `tax_rates_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `tax_rates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `transactions`
--
ALTER TABLE `transactions`
ADD CONSTRAINT `transactions_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transactions_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transactions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transactions_expense_category_id_foreign` FOREIGN KEY (`expense_category_id`) REFERENCES `expense_categories` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transactions_expense_for_foreign` FOREIGN KEY (`expense_for`) REFERENCES `users` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transactions_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `business_locations` (`id`),
ADD CONSTRAINT `transactions_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `transaction_payments`
--
ALTER TABLE `transaction_payments`
ADD CONSTRAINT `transaction_payments_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `transaction_sell_lines`
--
ALTER TABLE `transaction_sell_lines`
ADD CONSTRAINT `transaction_sell_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transaction_sell_lines_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transaction_sell_lines_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transaction_sell_lines_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `units`
--
ALTER TABLE `units`
ADD CONSTRAINT `units_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `units_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `users`
--
ALTER TABLE `users`
ADD CONSTRAINT `users_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `variations`
--
ALTER TABLE `variations`
ADD CONSTRAINT `variations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `variations_product_variation_id_foreign` FOREIGN KEY (`product_variation_id`) REFERENCES `product_variations` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `variation_group_prices`
--
ALTER TABLE `variation_group_prices`
ADD CONSTRAINT `variation_group_prices_price_group_id_foreign` FOREIGN KEY (`price_group_id`) REFERENCES `selling_price_groups` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `variation_group_prices_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `variation_location_details`
--
ALTER TABLE `variation_location_details`
ADD CONSTRAINT `variation_location_details_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `business_locations` (`id`),
ADD CONSTRAINT `variation_location_details_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`);
--
-- Filtros para la tabla `variation_templates`
--
ALTER TABLE `variation_templates`
ADD CONSTRAINT `variation_templates_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `variation_value_templates`
--
ALTER TABLE `variation_value_templates`
ADD CONSTRAINT `variation_value_templates_variation_template_id_foreign` FOREIGN KEY (`variation_template_id`) REFERENCES `variation_templates` (`id`) ON DELETE CASCADE;
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 */;