CREATE TABLE `ps_stock` (
  `id_stock` int(11) UNSIGNED NOT NULL,
  `id_warehouse` int(11) UNSIGNED NOT NULL,
  `id_product` int(11) UNSIGNED NOT NULL,
  `id_product_attribute` int(11) UNSIGNED NOT NULL,
  `reference` varchar(64) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `isbn` varchar(32) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `physical_quantity` int(11) UNSIGNED NOT NULL,
  `usable_quantity` int(11) UNSIGNED NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_stock_available`
--

CREATE TABLE `ps_stock_available` (
  `id_stock_available` int(11) UNSIGNED NOT NULL,
  `id_product` int(11) UNSIGNED NOT NULL,
  `id_product_attribute` int(11) UNSIGNED NOT NULL,
  `id_shop` int(11) UNSIGNED NOT NULL,
  `id_shop_group` int(11) UNSIGNED NOT NULL,
  `quantity` int(10) NOT NULL DEFAULT '0',
  `physical_quantity` int(11) NOT NULL DEFAULT '0',
  `reserved_quantity` int(11) NOT NULL DEFAULT '0',
  `depends_on_stock` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `out_of_stock` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `location` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_stock_available`
--

INSERT INTO `ps_stock_available` (`id_stock_available`, `id_product`, `id_product_attribute`, `id_shop`, `id_shop_group`, `quantity`, `physical_quantity`, `reserved_quantity`, `depends_on_stock`, `out_of_stock`, `location`) VALUES
(1, 1, 0, 1, 0, -33, -10, 23, 0, 0, ''),
(2, 2, 0, 1, 0, -50, -5, 45, 0, 0, ''),
(3, 3, 0, 1, 0, -95, -12, 83, 0, 0, ''),
(4, 4, 0, 1, 0, -10, -4, 6, 0, 0, ''),
(5, 5, 0, 1, 0, -17, -4, 13, 0, 0, ''),
(6, 6, 0, 1, 0, -15, -4, 11, 0, 0, ''),
(7, 7, 0, 1, 0, -7, -2, 5, 0, 0, ''),
(8, 8, 0, 1, 0, -102, -16, 86, 0, 0, ''),
(9, 9, 0, 1, 0, -99, -23, 76, 0, 0, ''),
(10, 10, 0, 1, 0, -31, -7, 24, 0, 0, ''),
(11, 11, 0, 1, 0, -134, -22, 112, 0, 0, ''),
(12, 12, 0, 1, 0, -81, -12, 69, 0, 1, ''),
(13, 13, 0, 1, 0, -93, -22, 71, 0, 0, ''),
(14, 14, 0, 1, 0, -32, -4, 28, 0, 0, ''),
(15, 15, 0, 1, 0, -118, -16, 102, 0, 0, ''),
(16, 16, 0, 1, 0, -23, -9, 14, 0, 0, ''),
(17, 17, 0, 1, 0, -5, -2, 3, 0, 0, ''),
(18, 18, 0, 1, 0, -20, -6, 14, 0, 0, ''),
(19, 19, 0, 1, 0, -46, -10, 36, 0, 0, ''),
(20, 20, 0, 1, 0, -58, -8, 50, 0, 0, ''),
(21, 21, 0, 1, 0, -8, -6, 2, 0, 0, ''),
(22, 22, 0, 1, 0, -9, 0, 9, 0, 0, ''),
(23, 23, 0, 1, 0, -49, -6, 43, 0, 0, ''),
(24, 24, 0, 1, 0, -61, -8, 53, 0, 1, ''),
(25, 25, 0, 1, 0, -48, -9, 39, 0, 0, ''),
(26, 26, 0, 1, 0, -35, -2, 33, 0, 0, ''),
(27, 27, 0, 1, 0, -10, -4, 6, 0, 0, ''),
(28, 28, 0, 1, 0, -15, -5, 10, 0, 0, ''),
(29, 29, 0, 1, 0, -11, -1, 10, 0, 0, ''),
(30, 30, 0, 1, 0, -91, -15, 76, 0, 0, ''),
(31, 31, 0, 1, 0, -12, -5, 7, 0, 0, ''),
(32, 32, 0, 1, 0, -16, -1, 15, 0, 0, ''),
(33, 33, 0, 1, 0, -16, -1, 15, 0, 0, ''),
(34, 34, 0, 1, 0, -17, -1, 16, 0, 0, ''),
(35, 35, 0, 1, 0, -21, 0, 21, 0, 0, ''),
(36, 36, 0, 1, 0, -18, -3, 15, 0, 0, ''),
(37, 37, 0, 1, 0, -57, -5, 52, 0, 0, ''),
(38, 38, 0, 1, 0, -39, -4, 35, 0, 0, ''),
(39, 39, 0, 1, 0, -25, -1, 24, 0, 0, ''),
(40, 40, 0, 1, 0, -8, -1, 7, 0, 0, ''),
(41, 41, 0, 1, 0, -6, -2, 4, 0, 1, ''),
(42, 42, 0, 1, 0, -5, -3, 2, 0, 0, ''),
(43, 43, 0, 1, 0, -54, -7, 47, 0, 0, ''),
(44, 44, 0, 1, 0, -26, 0, 26, 0, 0, ''),
(45, 45, 0, 1, 0, -33, -6, 27, 0, 0, ''),
(46, 46, 0, 1, 0, -19, -3, 16, 0, 0, ''),
(47, 47, 0, 1, 0, -13, -6, 7, 0, 0, ''),
(48, 48, 0, 1, 0, -12, -3, 9, 0, 0, ''),
(49, 49, 0, 1, 0, -12, -3, 9, 0, 0, ''),
(50, 50, 0, 1, 0, -2, -1, 1, 0, 0, ''),
(51, 51, 0, 1, 0, -8, -1, 7, 0, 0, ''),
(52, 52, 0, 1, 0, -3, -1, 2, 0, 0, ''),
(53, 53, 0, 1, 0, -1, 0, 1, 0, 0, ''),
(54, 54, 0, 1, 0, -72, -10, 62, 0, 0, ''),
(55, 55, 0, 1, 0, -47, -4, 43, 0, 0, ''),
(56, 56, 0, 1, 0, -13, -1, 12, 0, 0, ''),
(57, 57, 0, 1, 0, -25, -5, 20, 0, 0, ''),
(58, 58, 0, 1, 0, -9, 0, 9, 0, 0, ''),
(59, 59, 0, 1, 0, 0, 0, 0, 0, 1, ''),
(60, 60, 0, 1, 0, 0, 0, 0, 0, 1, ''),
(61, 61, 0, 1, 0, 0, 0, 0, 0, 1, ''),
(62, 62, 0, 1, 0, 0, 0, 0, 0, 1, ''),
(63, 63, 0, 1, 0, 0, 0, 0, 0, 1, ''),
(64, 64, 0, 1, 0, -21, 0, 21, 0, 0, ''),
(66, 66, 0, 1, 0, -13, 0, 13, 0, 0, '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_stock_mvt`
--

CREATE TABLE `ps_stock_mvt` (
  `id_stock_mvt` bigint(20) NOT NULL,
  `id_stock` int(11) NOT NULL,
  `id_order` int(11) DEFAULT NULL,
  `id_supply_order` int(11) DEFAULT NULL,
  `id_stock_mvt_reason` int(11) NOT NULL,
  `id_employee` int(11) NOT NULL,
  `employee_lastname` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `employee_firstname` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `physical_quantity` int(11) NOT NULL,
  `date_add` datetime NOT NULL,
  `sign` smallint(6) NOT NULL DEFAULT '1',
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `last_wa` decimal(20,6) DEFAULT '0.000000',
  `current_wa` decimal(20,6) DEFAULT '0.000000',
  `referer` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Extraindo dados da tabela `ps_stock_mvt`
--

INSERT INTO `ps_stock_mvt` (`id_stock_mvt`, `id_stock`, `id_order`, `id_supply_order`, `id_stock_mvt_reason`, `id_employee`, `employee_lastname`, `employee_firstname`, `physical_quantity`, `date_add`, `sign`, `price_te`, `last_wa`, `current_wa`, `referer`) VALUES
(1, 48, 161, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:10', -1, 0.000000, 0.000000, 0.000000, NULL),
(2, 3, 161, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:10', -1, 0.000000, 0.000000, 0.000000, NULL),
(3, 26, 160, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(4, 32, 159, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(5, 38, 159, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(6, 11, 158, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(7, 14, 157, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(8, 20, 156, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(9, 38, 156, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(10, 9, 155, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(11, 12, 155, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(12, 46, 154, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(13, 20, 153, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(14, 12, 152, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(15, 8, 151, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(16, 14, 151, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(17, 15, 151, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(18, 18, 151, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(19, 28, 151, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(20, 10, 150, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(21, 37, 149, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(22, 36, 149, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(23, 15, 148, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(24, 30, 147, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(25, 45, 146, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(26, 13, 146, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(27, 45, 145, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(28, 24, 144, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(29, 9, 144, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(30, 9, 143, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(31, 13, 143, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(32, 11, 142, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(33, 45, 141, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(34, 47, 140, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(35, 57, 140, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(36, 55, 140, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(37, 17, 140, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(38, 30, 139, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(39, 40, 138, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(40, 3, 137, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(41, 2, 137, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(42, 20, 137, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(43, 24, 137, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(44, 37, 137, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(45, 38, 137, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(46, 47, 136, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(47, 12, 135, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(48, 15, 134, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(49, 49, 133, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(50, 54, 133, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(51, 9, 132, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(52, 30, 132, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(53, 45, 131, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(54, 43, 131, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(55, 13, 130, NULL, 3, 1, 'Dsd', 'Admin', 3, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(56, 19, 129, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(57, 28, 129, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(58, 37, 128, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(59, 38, 128, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(60, 8, 127, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(61, 13, 127, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(62, 18, 126, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(63, 11, 125, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(64, 15, 125, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(65, 4, 124, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(66, 3, 124, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(67, 11, 124, NULL, 3, 1, 'Dsd', 'Admin', 5, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(68, 10, 123, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(69, 9, 123, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(70, 2, 122, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(71, 12, 122, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(72, 16, 121, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(73, 9, 121, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(74, 19, 120, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(75, 25, 120, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(76, 4, 120, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(77, 1, 119, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(78, 27, 119, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(79, 31, 119, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(80, 9, 118, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(81, 15, 117, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(82, 6, 117, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(83, 5, 117, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(84, 16, 116, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(85, 23, 115, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(86, 25, 115, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(87, 9, 115, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(88, 31, 115, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(89, 1, 114, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(90, 15, 114, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(91, 19, 114, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(92, 25, 114, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(93, 54, 113, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(94, 55, 113, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(95, 15, 112, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(96, 21, 112, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(97, 24, 112, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(98, 8, 111, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(99, 23, 111, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(100, 31, 111, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(101, 8, 110, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(102, 23, 110, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(103, 13, 110, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(104, 39, 109, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(105, 3, 109, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(106, 8, 108, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(107, 10, 108, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(108, 47, 107, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(109, 19, 107, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(110, 54, 106, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(111, 43, 105, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(112, 13, 104, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(113, 36, 104, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(114, 54, 103, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(115, 55, 103, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(116, 56, 103, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(117, 57, 103, NULL, 3, 1, 'Dsd', 'Admin', 3, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(118, 11, 102, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(119, 19, 102, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(120, 9, 101, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(121, 42, 101, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:11', -1, 0.000000, 0.000000, 0.000000, NULL),
(122, 15, 100, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(123, 25, 99, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(124, 20, 98, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(125, 26, 98, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(126, 3, 98, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(127, 13, 97, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(128, 11, 96, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(129, 15, 95, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(130, 15, 94, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(131, 9, 94, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(132, 8, 93, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(133, 1, 93, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(134, 9, 92, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(135, 9, 91, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(136, 8, 90, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(137, 10, 90, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(138, 46, 89, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(139, 24, 88, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(140, 20, 88, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(141, 24, 87, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(142, 24, 86, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(143, 13, 85, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(144, 15, 84, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(145, 19, 83, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(146, 23, 83, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(147, 9, 82, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(148, 12, 81, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(149, 43, 81, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(150, 41, 80, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(151, 5, 80, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(152, 28, 79, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(153, 13, 78, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(154, 9, 78, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(155, 8, 77, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(156, 13, 77, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(157, 30, 76, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(158, 11, 75, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(159, 8, 75, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(160, 15, 75, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(161, 18, 75, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(162, 21, 75, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(163, 27, 75, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(164, 12, 75, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(165, 8, 74, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(166, 3, 74, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(167, 12, 74, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(168, 48, 73, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(169, 54, 73, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(170, 16, 73, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(171, 14, 73, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(172, 43, 73, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(173, 20, 72, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(174, 42, 72, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(175, 30, 72, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(176, 25, 71, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(177, 8, 71, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(178, 13, 70, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(179, 9, 70, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(180, 11, 69, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(181, 13, 68, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(182, 9, 68, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(183, 11, 67, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(184, 29, 67, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(185, 30, 66, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(186, 12, 65, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(187, 8, 64, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(188, 15, 63, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(189, 19, 63, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(190, 46, 62, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(191, 30, 62, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(192, 3, 61, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(193, 7, 61, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(194, 5, 61, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(195, 24, 60, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(196, 28, 60, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(197, 25, 60, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(198, 19, 60, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(199, 3, 59, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(200, 8, 59, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(201, 16, 59, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(202, 23, 59, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(203, 21, 58, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(204, 20, 58, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(205, 25, 57, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(206, 11, 57, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(207, 11, 56, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(208, 19, 56, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(209, 27, 56, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(210, 13, 55, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(211, 8, 55, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(212, 13, 54, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(213, 11, 53, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(214, 18, 53, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(215, 13, 52, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(216, 6, 51, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(217, 12, 50, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(218, 11, 50, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(219, 21, 50, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(220, 23, 50, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(221, 28, 49, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(222, 33, 49, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(223, 14, 48, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:12', -1, 0.000000, 0.000000, 0.000000, NULL),
(224, 1, 47, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(225, 5, 47, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(226, 20, 47, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(227, 34, 46, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(228, 37, 46, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(229, 36, 46, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(230, 30, 45, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(231, 31, 44, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(232, 30, 43, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(233, 10, 42, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(234, 30, 41, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(235, 9, 41, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(236, 10, 41, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(237, 30, 40, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(238, 7, 40, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(239, 25, 40, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(240, 16, 39, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(241, 16, 38, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(242, 37, 37, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(243, 42, 37, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(244, 9, 37, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(245, 49, 36, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(246, 54, 36, NULL, 3, 1, 'Dsd', 'Admin', 2, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(247, 30, 35, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(248, 41, 35, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(249, 45, 34, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(250, 16, 33, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(251, 11, 32, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(252, 9, 32, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(253, 11, 31, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(254, 9, 31, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(255, 1, 30, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(256, 25, 30, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(257, 19, 30, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(258, 3, 30, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(259, 30, 30, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(260, 11, 30, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(261, 13, 29, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(262, 3, 28, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(263, 4, 28, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(264, 2, 28, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(265, 18, 28, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(266, 9, 27, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(267, 1, 26, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(268, 47, 26, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(269, 43, 26, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(270, 12, 25, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(271, 51, 24, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(272, 52, 24, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(273, 50, 24, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(274, 1, 23, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(275, 3, 23, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(276, 54, 22, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(277, 55, 22, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(278, 57, 22, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(279, 13, 17, NULL, 3, 1, 'Dsd', 'Admin', 3, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(280, 6, 15, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(281, 47, 14, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(282, 1, 13, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL),
(283, 2, 12, NULL, 3, 1, 'Dsd', 'Admin', 1, '2022-05-19 11:03:13', -1, 0.000000, 0.000000, 0.000000, NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_stock_mvt_reason`
--

CREATE TABLE `ps_stock_mvt_reason` (
  `id_stock_mvt_reason` int(11) UNSIGNED NOT NULL,
  `sign` tinyint(1) NOT NULL DEFAULT '1',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_stock_mvt_reason`
--

INSERT INTO `ps_stock_mvt_reason` (`id_stock_mvt_reason`, `sign`, `date_add`, `date_upd`, `deleted`) VALUES
(1, 1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(2, -1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(3, -1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(4, -1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(5, 1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(6, -1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(7, 1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(8, 1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(9, 1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(10, 1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(11, 1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0),
(12, -1, '2020-11-16 21:58:01', '2020-11-16 21:58:01', 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_stock_mvt_reason_lang`
--

CREATE TABLE `ps_stock_mvt_reason_lang` (
  `id_stock_mvt_reason` int(11) UNSIGNED NOT NULL,
  `id_lang` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_stock_mvt_reason_lang`
--

INSERT INTO `ps_stock_mvt_reason_lang` (`id_stock_mvt_reason`, `id_lang`, `name`) VALUES
(1, 1, 'Aumentar'),
(2, 1, 'Diminuir'),
(3, 1, 'Encomenda de Cliente'),
(4, 1, 'Regulation following an inventory of stock'),
(5, 1, 'Regulation following an inventory of stock'),
(6, 1, 'Transferir para outro armazém'),
(7, 1, 'Transferir de outro armazém'),
(8, 1, 'Pedido de fornecimento'),
(9, 1, 'Encomenda de Cliente'),
(10, 1, 'Devolução do produto'),
(11, 1, 'Employee Edition'),
(12, 1, 'Employee Edition');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_store`
--

CREATE TABLE `ps_store` (
  `id_store` int(10) UNSIGNED NOT NULL,
  `id_country` int(10) UNSIGNED NOT NULL,
  `id_state` int(10) UNSIGNED DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `postcode` varchar(12) NOT NULL,
  `latitude` decimal(13,8) DEFAULT NULL,
  `longitude` decimal(13,8) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `fax` varchar(16) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_store`
--

INSERT INTO `ps_store` (`id_store`, `id_country`, `id_state`, `city`, `postcode`, `latitude`, `longitude`, `phone`, `fax`, `email`, `active`, `date_add`, `date_upd`) VALUES
(1, 15, 0, 'Vila Nova de Gaia', '4430-299', 25.76500500, -80.24379700, '', '', 'dsdportugal@sapo.pt', 1, '2020-11-16 21:58:35', '2022-12-19 12:31:37');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_store_lang`
--

CREATE TABLE `ps_store_lang` (
  `id_store` int(11) UNSIGNED NOT NULL,
  `id_lang` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `hours` text,
  `note` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_store_lang`
--

INSERT INTO `ps_store_lang` (`id_store`, `id_lang`, `name`, `address1`, `address2`, `hours`, `note`) VALUES
(1, 1, 'DSD de Luxe Portugal, Lda.', 'Rua Alexandre Herculano, 174', 'Oliveira do Douro', '[[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"]]', '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_store_shop`
--

CREATE TABLE `ps_store_shop` (
  `id_store` int(11) UNSIGNED NOT NULL,
  `id_shop` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_store_shop`
--

INSERT INTO `ps_store_shop` (`id_store`, `id_shop`) VALUES
(1, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supplier`
--

CREATE TABLE `ps_supplier` (
  `id_supplier` int(10) UNSIGNED NOT NULL,
  `name` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_supplier`
--

INSERT INTO `ps_supplier` (`id_supplier`, `name`, `date_add`, `date_upd`, `active`) VALUES
(1, 'DSD de LUXE', '2020-11-16 23:41:53', '2020-11-16 23:41:53', 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supplier_lang`
--

CREATE TABLE `ps_supplier_lang` (
  `id_supplier` int(10) UNSIGNED NOT NULL,
  `id_lang` int(10) UNSIGNED NOT NULL,
  `description` text,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(512) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_supplier_lang`
--

INSERT INTO `ps_supplier_lang` (`id_supplier`, `id_lang`, `description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES
(1, 1, '', '', '', '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supplier_shop`
--

CREATE TABLE `ps_supplier_shop` (
  `id_supplier` int(11) UNSIGNED NOT NULL,
  `id_shop` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_supplier_shop`
--

INSERT INTO `ps_supplier_shop` (`id_supplier`, `id_shop`) VALUES
(1, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supply_order`
--

CREATE TABLE `ps_supply_order` (
  `id_supply_order` int(11) UNSIGNED NOT NULL,
  `id_supplier` int(11) UNSIGNED NOT NULL,
  `supplier_name` varchar(64) NOT NULL,
  `id_lang` int(11) UNSIGNED NOT NULL,
  `id_warehouse` int(11) UNSIGNED NOT NULL,
  `id_supply_order_state` int(11) UNSIGNED NOT NULL,
  `id_currency` int(11) UNSIGNED NOT NULL,
  `id_ref_currency` int(11) UNSIGNED NOT NULL,
  `reference` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `date_delivery_expected` datetime DEFAULT NULL,
  `total_te` decimal(20,6) DEFAULT '0.000000',
  `total_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `total_tax` decimal(20,6) DEFAULT '0.000000',
  `total_ti` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `is_template` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supply_order_detail`
--

CREATE TABLE `ps_supply_order_detail` (
  `id_supply_order_detail` int(11) UNSIGNED NOT NULL,
  `id_supply_order` int(11) UNSIGNED NOT NULL,
  `id_currency` int(11) UNSIGNED NOT NULL,
  `id_product` int(11) UNSIGNED NOT NULL,
  `id_product_attribute` int(11) UNSIGNED NOT NULL,
  `reference` varchar(64) NOT NULL,
  `supplier_reference` varchar(64) NOT NULL,
  `name` varchar(128) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `isbn` varchar(32) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `exchange_rate` decimal(20,6) DEFAULT '0.000000',
  `unit_price_te` decimal(20,6) DEFAULT '0.000000',
  `quantity_expected` int(11) UNSIGNED NOT NULL,
  `quantity_received` int(11) UNSIGNED NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `price_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `tax_rate` decimal(20,6) DEFAULT '0.000000',
  `tax_value` decimal(20,6) DEFAULT '0.000000',
  `price_ti` decimal(20,6) DEFAULT '0.000000',
  `tax_value_with_order_discount` decimal(20,6) DEFAULT '0.000000',
  `price_with_order_discount_te` decimal(20,6) DEFAULT '0.000000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supply_order_history`
--

CREATE TABLE `ps_supply_order_history` (
  `id_supply_order_history` int(11) UNSIGNED NOT NULL,
  `id_supply_order` int(11) UNSIGNED NOT NULL,
  `id_employee` int(11) UNSIGNED NOT NULL,
  `employee_lastname` varchar(255) DEFAULT '',
  `employee_firstname` varchar(255) DEFAULT '',
  `id_state` int(11) UNSIGNED NOT NULL,
  `date_add` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supply_order_receipt_history`
--

CREATE TABLE `ps_supply_order_receipt_history` (
  `id_supply_order_receipt_history` int(11) UNSIGNED NOT NULL,
  `id_supply_order_detail` int(11) UNSIGNED NOT NULL,
  `id_employee` int(11) UNSIGNED NOT NULL,
  `employee_lastname` varchar(255) DEFAULT '',
  `employee_firstname` varchar(255) DEFAULT '',
  `id_supply_order_state` int(11) UNSIGNED NOT NULL,
  `quantity` int(11) UNSIGNED NOT NULL,
  `date_add` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supply_order_state`
--

CREATE TABLE `ps_supply_order_state` (
  `id_supply_order_state` int(11) UNSIGNED NOT NULL,
  `delivery_note` tinyint(1) NOT NULL DEFAULT '0',
  `editable` tinyint(1) NOT NULL DEFAULT '0',
  `receipt_state` tinyint(1) NOT NULL DEFAULT '0',
  `pending_receipt` tinyint(1) NOT NULL DEFAULT '0',
  `enclosed` tinyint(1) NOT NULL DEFAULT '0',
  `color` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_supply_order_state`
--

INSERT INTO `ps_supply_order_state` (`id_supply_order_state`, `delivery_note`, `editable`, `receipt_state`, `pending_receipt`, `enclosed`, `color`) VALUES
(1, 0, 1, 0, 0, 0, '#faab00'),
(2, 1, 0, 0, 0, 0, '#273cff'),
(3, 0, 0, 0, 1, 0, '#ff37f5'),
(4, 0, 0, 1, 1, 0, '#ff3e33'),
(5, 0, 0, 1, 0, 1, '#00d60c'),
(6, 0, 0, 0, 0, 1, '#666666');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_supply_order_state_lang`
--

CREATE TABLE `ps_supply_order_state_lang` (
  `id_supply_order_state` int(11) UNSIGNED NOT NULL,
  `id_lang` int(11) UNSIGNED NOT NULL,
  `name` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_supply_order_state_lang`
--

INSERT INTO `ps_supply_order_state_lang` (`id_supply_order_state`, `id_lang`, `name`) VALUES
(1, 1, '1 - Criação em progresso'),
(2, 1, '2 - Encomenda validada'),
(3, 1, '3 - A aguardar receção'),
(4, 1, '4 - Encomenda recebida em parte'),
(5, 1, '5 - Encomenda recebida na totalidade'),
(6, 1, '6 - Encomenda cancelada');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tab`
--

CREATE TABLE `ps_tab` (
  `id_tab` int(11) NOT NULL,
  `id_parent` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `module` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `class_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `hide_host_mode` tinyint(1) NOT NULL,
  `icon` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Extraindo dados da tabela `ps_tab`
--

INSERT INTO `ps_tab` (`id_tab`, `id_parent`, `position`, `module`, `class_name`, `active`, `hide_host_mode`, `icon`) VALUES
(1, 0, 0, NULL, 'AdminDashboard', 1, 0, 'trending_up'),
(2, 0, 1, NULL, 'SELL', 1, 0, ''),
(3, 2, 0, NULL, 'AdminParentOrders', 1, 0, 'shopping_basket'),
(4, 3, 0, NULL, 'AdminOrders', 1, 0, ''),
(5, 3, 1, NULL, 'AdminInvoices', 1, 0, ''),
(6, 3, 2, NULL, 'AdminSlip', 1, 0, ''),
(7, 3, 3, NULL, 'AdminDeliverySlip', 1, 0, ''),
(8, 3, 4, NULL, 'AdminCarts', 1, 0, ''),
(9, 2, 1, NULL, 'AdminCatalog', 1, 0, 'store'),
(10, 9, 0, NULL, 'AdminProducts', 1, 0, ''),
(11, 9, 1, NULL, 'AdminCategories', 1, 0, ''),
(12, 9, 2, NULL, 'AdminTracking', 1, 0, ''),
(13, 9, 3, NULL, 'AdminParentAttributesGroups', 1, 0, ''),
(14, 13, 0, NULL, 'AdminAttributesGroups', 1, 0, ''),
(15, 13, 1, NULL, 'AdminFeatures', 1, 0, ''),
(16, 9, 4, NULL, 'AdminParentManufacturers', 1, 0, ''),
(17, 16, 0, NULL, 'AdminManufacturers', 1, 0, ''),
(18, 16, 1, NULL, 'AdminSuppliers', 1, 0, ''),
(19, 9, 5, NULL, 'AdminAttachments', 1, 0, ''),
(20, 9, 6, NULL, 'AdminParentCartRules', 1, 0, ''),
(21, 20, 0, NULL, 'AdminCartRules', 1, 0, ''),
(22, 20, 1, NULL, 'AdminSpecificPriceRule', 1, 0, ''),
(23, 9, 7, NULL, 'AdminStockManagement', 1, 0, ''),
(24, 2, 2, NULL, 'AdminParentCustomer', 1, 0, 'account_circle'),
(25, 24, 0, NULL, 'AdminCustomers', 1, 0, ''),
(26, 24, 1, NULL, 'AdminAddresses', 1, 0, ''),
(27, 24, 2, NULL, 'AdminOutstanding', 0, 0, ''),
(28, 2, 3, NULL, 'AdminParentCustomerThreads', 1, 0, 'chat'),
(29, 28, 0, NULL, 'AdminCustomerThreads', 1, 0, ''),
(30, 28, 1, NULL, 'AdminOrderMessage', 1, 0, ''),
(31, 28, 2, NULL, 'AdminReturn', 1, 0, ''),
(32, 2, 4, NULL, 'AdminStats', 1, 0, 'assessment'),
(33, 2, 5, NULL, 'AdminStock', 1, 0, 'store'),
(34, 33, 0, NULL, 'AdminWarehouses', 1, 0, ''),
(35, 33, 1, NULL, 'AdminParentStockManagement', 1, 0, ''),
(36, 35, 0, NULL, 'AdminStockManagement', 1, 0, ''),
(37, 36, 0, NULL, 'AdminStockMvt', 1, 0, ''),
(38, 36, 1, NULL, 'AdminStockInstantState', 1, 0, ''),
(39, 36, 2, NULL, 'AdminStockCover', 1, 0, ''),
(40, 33, 2, NULL, 'AdminSupplyOrders', 1, 0, ''),
(41, 33, 3, NULL, 'AdminStockConfiguration', 1, 0, ''),
(42, 0, 2, NULL, 'IMPROVE', 1, 0, ''),
(43, 42, 0, NULL, 'AdminParentModulesSf', 1, 0, 'extension'),
(44, 43, 1, '', 'AdminModulesSf', 1, 0, ''),
(45, 44, 1, NULL, 'AdminModulesManage', 1, 0, ''),
(46, 44, 3, NULL, 'AdminModulesNotifications', 1, 0, ''),
(47, 44, 4, NULL, 'AdminModulesUpdates', 1, 0, ''),
(48, 43, 0, '', 'AdminParentModulesCatalog', 1, 0, ''),
(49, 48, 0, '', 'AdminModulesCatalog', 0, 0, ''),
(50, 48, 1, '', 'AdminAddonsCatalog', 0, 0, ''),
(51, 43, 2, NULL, 'AdminModules', 0, 0, ''),
(52, 42, 1, NULL, 'AdminParentThemes', 1, 0, 'desktop_mac'),
(53, 126, 1, '', 'AdminThemes', 1, 0, ''),
(54, 52, 1, '', 'AdminThemesCatalog', 0, 0, ''),
(55, 52, 2, NULL, 'AdminParentMailTheme', 1, 0, ''),
(56, 55, 0, NULL, 'AdminMailTheme', 1, 0, ''),
(57, 52, 3, NULL, 'AdminCmsContent', 1, 0, ''),
(58, 52, 4, NULL, 'AdminModulesPositions', 1, 0, ''),
(59, 52, 5, NULL, 'AdminImages', 1, 0, ''),
(60, 42, 2, NULL, 'AdminParentShipping', 1, 0, 'local_shipping'),
(61, 60, 0, NULL, 'AdminCarriers', 1, 0, ''),
(62, 60, 1, NULL, 'AdminShipping', 1, 0, ''),
(63, 42, 3, NULL, 'AdminParentPayment', 1, 0, 'payment'),
(64, 63, 0, NULL, 'AdminPayment', 1, 0, ''),
(65, 63, 1, NULL, 'AdminPaymentPreferences', 1, 0, ''),
(66, 42, 4, NULL, 'AdminInternational', 1, 0, 'language'),
(67, 66, 0, NULL, 'AdminParentLocalization', 1, 0, ''),
(68, 67, 0, NULL, 'AdminLocalization', 1, 0, ''),
(69, 67, 1, NULL, 'AdminLanguages', 1, 0, ''),
(70, 67, 2, NULL, 'AdminCurrencies', 1, 0, ''),
(71, 67, 3, NULL, 'AdminGeolocation', 1, 0, ''),
(72, 66, 1, NULL, 'AdminParentCountries', 1, 0, ''),
(73, 72, 0, NULL, 'AdminZones', 1, 0, ''),
(74, 72, 1, NULL, 'AdminCountries', 1, 0, ''),
(75, 72, 2, NULL, 'AdminStates', 1, 0, ''),
(76, 66, 2, NULL, 'AdminParentTaxes', 1, 0, ''),
(77, 76, 0, NULL, 'AdminTaxes', 1, 0, ''),
(78, 76, 1, NULL, 'AdminTaxRulesGroup', 1, 0, ''),
(79, 66, 3, NULL, 'AdminTranslations', 1, 0, ''),
(80, 0, 3, NULL, 'CONFIGURE', 1, 0, ''),
(81, 80, 0, NULL, 'ShopParameters', 1, 0, 'settings'),
(82, 81, 0, NULL, 'AdminParentPreferences', 1, 0, ''),
(83, 82, 0, NULL, 'AdminPreferences', 1, 0, ''),
(84, 82, 1, NULL, 'AdminMaintenance', 1, 0, ''),
(85, 81, 1, NULL, 'AdminParentOrderPreferences', 1, 0, ''),
(86, 85, 0, NULL, 'AdminOrderPreferences', 1, 0, ''),
(87, 85, 1, NULL, 'AdminStatuses', 1, 0, ''),
(88, 81, 2, NULL, 'AdminPPreferences', 1, 0, ''),
(89, 81, 3, NULL, 'AdminParentCustomerPreferences', 1, 0, ''),
(90, 89, 0, NULL, 'AdminCustomerPreferences', 1, 0, ''),
(91, 89, 1, NULL, 'AdminGroups', 1, 0, ''),
(92, 89, 2, NULL, 'AdminGenders', 1, 0, ''),
(93, 81, 4, NULL, 'AdminParentStores', 1, 0, ''),
(94, 93, 0, NULL, 'AdminContacts', 1, 0, ''),
(95, 93, 1, NULL, 'AdminStores', 1, 0, ''),
(96, 81, 5, NULL, 'AdminParentMeta', 1, 0, ''),
(97, 96, 0, NULL, 'AdminMeta', 1, 0, ''),
(98, 96, 1, NULL, 'AdminSearchEngines', 1, 0, ''),
(99, 96, 2, NULL, 'AdminReferrers', 1, 0, ''),
(100, 81, 6, NULL, 'AdminParentSearchConf', 1, 0, ''),
(101, 100, 0, NULL, 'AdminSearchConf', 1, 0, ''),
(102, 100, 1, NULL, 'AdminTags', 1, 0, ''),
(103, 80, 1, NULL, 'AdminAdvancedParameters', 1, 0, 'settings_applications'),
(104, 103, 0, NULL, 'AdminInformation', 1, 0, ''),
(105, 103, 1, NULL, 'AdminPerformance', 1, 0, ''),
(106, 103, 2, NULL, 'AdminAdminPreferences', 1, 0, ''),
(107, 103, 3, NULL, 'AdminEmails', 1, 0, ''),
(108, 103, 4, NULL, 'AdminImport', 1, 0, ''),
(109, 103, 5, NULL, 'AdminParentEmployees', 1, 0, ''),
(110, 109, 0, NULL, 'AdminEmployees', 1, 0, ''),
(111, 109, 1, NULL, 'AdminProfiles', 1, 0, ''),
(112, 109, 2, NULL, 'AdminAccess', 1, 0, ''),
(113, 103, 6, NULL, 'AdminParentRequestSql', 1, 0, ''),
(114, 113, 0, NULL, 'AdminRequestSql', 1, 0, ''),
(115, 113, 1, NULL, 'AdminBackup', 1, 0, ''),
(116, 103, 7, NULL, 'AdminLogs', 1, 0, ''),
(117, 103, 8, NULL, 'AdminWebservice', 1, 0, ''),
(118, 103, 9, NULL, 'AdminShopGroup', 0, 0, ''),
(119, 103, 10, NULL, 'AdminShopUrl', 0, 0, ''),
(120, -1, 0, NULL, 'AdminQuickAccesses', 1, 0, ''),
(121, 0, 4, NULL, 'DEFAULT', 1, 0, ''),
(122, -1, 1, NULL, 'AdminPatterns', 1, 0, ''),
(123, -1, 2, 'dashgoals', 'AdminDashgoals', 1, 0, ''),
(124, -1, 3, 'ps_faviconnotificationbo', 'AdminConfigureFaviconBo', 1, 0, ''),
(125, 52, 6, 'ps_linklist', 'AdminLinkWidget', 1, 0, ''),
(126, 52, 0, '', 'AdminThemesParent', 1, 0, ''),
(127, 126, 2, 'ps_themecusto', 'AdminPsThemeCustoConfiguration', 1, 0, ''),
(128, 126, 3, 'ps_themecusto', 'AdminPsThemeCustoAdvanced', 1, 0, ''),
(129, 0, 5, 'welcome', 'AdminWelcome', 1, 0, ''),
(130, 81, 7, 'gamification', 'AdminGamification', 1, 0, ''),
(131, 42, 5, 'emarketing', 'AdminEmarketing', 1, 0, 'track_changes'),
(132, -1, 4, 'psgdpr', 'AdminAjaxPsgdpr', 1, 0, ''),
(133, -1, 5, 'psgdpr', 'AdminDownloadInvoicesPsgdpr', 1, 0, ''),
(134, 48, 0, 'ps_mbo', 'AdminPsMboModule', 1, 0, ''),
(135, 48, 1, 'ps_mbo', 'AdminPsMboAddons', 1, 0, ''),
(136, -1, 0, 'ps_mbo', 'AdminPsMboRecommended', 1, 0, ''),
(137, 52, 1, 'ps_mbo', 'AdminPsMboTheme', 1, 0, ''),
(138, -1, 6, 'ps_buybuttonlite', 'AdminAjaxPs_buybuttonlite', 1, 0, ''),
(139, -1, 7, 'blockreassurance', 'AdminBlockListing', 1, 0, ''),
(140, 42, 6, 'producttabs', 'AdminProductTab', 1, 0, ''),
(141, 0, 6, 'producttabs', 'AdminProductTabs', 0, 0, ''),
(142, 140, 1, 'producttabs', 'AdminProductTabsSettings', 1, 0, ''),
(143, 140, 2, 'producttabs', 'AdminProductTabGlobal', 1, 0, ''),
(144, -1, 8, 'ps_emailsmanager', 'AdminEmailsManager', 1, 0, ''),
(145, 121, 1, 'autoupgrade', 'AdminSelfUpgrade', 1, 0, ''),
(146, 44, 2, 'ps_mbo', 'AdminPsMboUninstalledModules', 1, 0, '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tab_advice`
--

CREATE TABLE `ps_tab_advice` (
  `id_tab` int(11) NOT NULL,
  `id_advice` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_tab_advice`
--

INSERT INTO `ps_tab_advice` (`id_tab`, `id_advice`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 54),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(1, 60),
(1, 61),
(1, 62),
(1, 63),
(1, 64),
(1, 65),
(1, 66),
(1, 67),
(1, 68),
(1, 69),
(1, 70),
(1, 71),
(1, 72),
(1, 73),
(1, 74),
(1, 75),
(1, 76),
(1, 77),
(1, 78),
(1, 79),
(1, 80),
(1, 81),
(1, 82),
(1, 83),
(1, 84),
(1, 85),
(1, 86),
(1, 87),
(1, 88),
(1, 89),
(1, 90),
(1, 91),
(1, 92),
(1, 93),
(1, 94),
(1, 95),
(1, 96),
(1, 97),
(1, 98),
(1, 99),
(1, 100),
(1, 101),
(1, 102),
(1, 103),
(1, 104),
(1, 105),
(1, 106),
(1, 107),
(1, 108),
(1, 109),
(1, 110),
(1, 111),
(1, 112),
(1, 113),
(1, 114),
(1, 115),
(1, 116),
(1, 117),
(1, 118),
(1, 119),
(1, 120),
(1, 121),
(1, 122),
(1, 123),
(1, 124),
(1, 125),
(1, 126),
(1, 127),
(1, 128),
(1, 129),
(1, 130),
(1, 131),
(1, 132),
(1, 133),
(1, 134),
(1, 135),
(1, 136),
(1, 137),
(1, 138),
(1, 139),
(1, 140),
(1, 141),
(1, 142),
(1, 143),
(1, 144),
(1, 145),
(1, 146),
(1, 147),
(1, 148),
(1, 149),
(1, 150),
(1, 151),
(1, 152),
(1, 153),
(1, 154),
(1, 155),
(1, 156),
(1, 157),
(1, 158),
(1, 159),
(1, 160),
(1, 161),
(1, 162),
(1, 163),
(1, 164),
(1, 165),
(1, 166),
(1, 167),
(1, 168),
(1, 169),
(1, 170),
(1, 171),
(1, 172),
(1, 173),
(1, 174),
(1, 175),
(1, 176),
(1, 177),
(1, 178),
(1, 179),
(1, 180),
(1, 181),
(1, 182),
(1, 183),
(1, 184),
(1, 185),
(1, 186),
(1, 187),
(1, 188),
(1, 189),
(1, 190),
(1, 191),
(1, 192),
(1, 193),
(1, 194),
(1, 195),
(1, 196),
(1, 197),
(1, 198),
(1, 199),
(1, 200),
(1, 201),
(1, 202),
(1, 203),
(1, 204),
(1, 205),
(1, 206),
(1, 207),
(1, 208),
(1, 209),
(1, 210),
(1, 211),
(1, 212),
(1, 213),
(1, 214),
(1, 215),
(1, 216),
(1, 217),
(1, 218),
(1, 219),
(1, 220),
(1, 221),
(1, 222),
(1, 223),
(1, 224),
(1, 225),
(1, 226),
(1, 227),
(1, 228),
(1, 229),
(1, 230),
(1, 231),
(1, 232),
(1, 233),
(1, 234),
(1, 235),
(1, 236),
(1, 237),
(1, 238),
(1, 239),
(1, 240),
(1, 241),
(1, 242),
(1, 243),
(1, 244),
(1, 245),
(1, 246),
(1, 247),
(1, 248),
(1, 249),
(1, 250),
(1, 251),
(1, 252),
(1, 253),
(1, 254),
(1, 255),
(1, 256),
(1, 257),
(1, 258),
(1, 259),
(1, 260),
(1, 261),
(1, 262),
(1, 263),
(1, 264),
(1, 265),
(1, 266),
(1, 267),
(1, 268),
(1, 269),
(1, 270),
(1, 271),
(1, 272),
(1, 273),
(1, 274),
(1, 275),
(1, 276),
(1, 277),
(1, 278),
(1, 279),
(1, 280),
(1, 281),
(1, 282),
(1, 283),
(1, 284),
(1, 285),
(1, 286),
(1, 287),
(1, 288),
(1, 289),
(1, 290),
(1, 291),
(1, 292),
(1, 293),
(1, 294),
(1, 295),
(1, 296);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tab_lang`
--

CREATE TABLE `ps_tab_lang` (
  `id_tab` int(11) NOT NULL,
  `id_lang` int(11) NOT NULL,
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Extraindo dados da tabela `ps_tab_lang`
--

INSERT INTO `ps_tab_lang` (`id_tab`, `id_lang`, `name`) VALUES
(1, 1, 'Painel de controlo'),
(2, 1, 'Vender'),
(3, 1, 'Encomendas'),
(4, 1, 'Encomendas'),
(5, 1, 'Faturas'),
(6, 1, 'Notas de Crédito'),
(7, 1, 'Notas de Entrega'),
(8, 1, 'Carrinhos de Compras'),
(9, 1, 'Catálogo'),
(10, 1, 'Produtos'),
(11, 1, 'Categorias'),
(12, 1, 'Monitorização'),
(13, 1, 'Atributos e Características'),
(14, 1, 'Atributos'),
(15, 1, 'Funcionalidades'),
(16, 1, 'Marcas e Fornecedores'),
(17, 1, 'Marcas'),
(18, 1, 'Fornecedores'),
(19, 1, 'Ficheiros'),
(20, 1, 'Descontos'),
(21, 1, 'Regras de Carrinho'),
(22, 1, 'Regras de Preços do Catálogo'),
(23, 1, 'Stocks'),
(24, 1, 'Clientes'),
(25, 1, 'Clientes'),
(26, 1, 'Endereços'),
(27, 1, 'Clientes com Dívidas'),
(28, 1, 'Apoio ao Cliente'),
(29, 1, 'Apoio ao Cliente'),
(30, 1, 'Mensagens de Encomendas'),
(31, 1, 'Mercadorias Devolvidas'),
(32, 1, 'Estatísticas'),
(34, 1, 'Armazéns'),
(35, 1, 'Gestão de Inventário'),
(36, 1, 'Gestão de Inventário'),
(37, 1, 'Movimento de Inventário'),
(38, 1, 'Estado Instantâneo do Inventário'),
(39, 1, 'Cobertura do Inventário'),
(40, 1, 'Encomendas a Fornecedores'),
(41, 1, 'Configuração'),
(42, 1, 'Melhorar'),
(43, 1, 'Módulos'),
(44, 1, 'Module Manager'),
(45, 1, 'Módulos'),
(46, 1, 'Alerts'),
(47, 1, 'Updates'),
(48, 1, 'Marketplace'),
(49, 1, 'Marketplace'),
(50, 1, 'Module Selections'),
(52, 1, 'Design'),
(53, 1, 'Tema Gráfico e Logótipo'),
(54, 1, 'Catálogo do Tema Gráfico'),
(55, 1, 'Email Theme'),
(56, 1, 'Email Theme'),
(57, 1, 'Páginas'),
(58, 1, 'Posições'),
(59, 1, 'Definições de Imagem'),
(60, 1, 'Envio'),
(61, 1, 'Transportadoras'),
(62, 1, 'Preferências'),
(63, 1, 'Pagamento'),
(64, 1, 'Métodos de Pagamento'),
(65, 1, 'Preferências'),
(66, 1, 'International'),
(67, 1, 'Localização'),
(68, 1, 'Localização'),
(69, 1, 'Idiomas'),
(70, 1, 'Moedas'),
(71, 1, 'Geolocalização'),
(72, 1, 'Localizações'),
(73, 1, 'Zonas'),
(74, 1, 'Países'),
(75, 1, 'Estados/Distritos'),
(76, 1, 'IVA'),
(77, 1, 'IVA'),
(78, 1, 'Regras de IVA'),
(79, 1, 'Traduções'),
(80, 1, 'Configurar'),
(81, 1, 'Parâmetros da Loja'),
(82, 1, 'Geral'),
(83, 1, 'Geral'),
(84, 1, 'Manutenção'),
(85, 1, 'Definições da Encomenda'),
(86, 1, 'Definições da Encomenda'),
(87, 1, 'Estados das Encomendas'),
(88, 1, 'Produtos'),
(89, 1, 'Definições do cliente'),
(90, 1, 'Clientes'),
(91, 1, 'Grupos'),
(92, 1, 'Títulos Sociais'),
(93, 1, 'Contacto'),
(94, 1, 'Contactos'),
(95, 1, 'Lojas'),
(96, 1, 'Tráfego e SEO'),
(97, 1, 'SEO e URLs'),
(98, 1, 'Motores de Pesquisa'),
(99, 1, 'Referências'),
(100, 1, 'Pesquisar'),
(101, 1, 'Pesquisar'),
(102, 1, 'Etiquetas'),
(103, 1, 'Parâmetros Avançados'),
(104, 1, 'Informação'),
(105, 1, 'Desempenho'),
(106, 1, 'Administração'),
(107, 1, 'Email'),
(108, 1, 'Importar'),
(109, 1, 'Empregados'),
(110, 1, 'Funcionários'),
(111, 1, 'Perfis de utilizadores'),
(112, 1, 'Permissões'),
(113, 1, 'Base de dados'),
(114, 1, 'Gestor SQL'),
(115, 1, 'Cópia da Base de Dados'),
(116, 1, 'Registos'),
(117, 1, 'Webservice'),
(118, 1, 'Multi-Loja'),
(119, 1, 'Multi-Loja'),
(120, 1, 'Acesso Rápido'),
(121, 1, 'Mais'),
(123, 1, 'Dashgoals'),
(124, 1, 'Order Notifications on the Favicon'),
(125, 1, 'Link Widget'),
(126, 1, 'Tema Gráfico e Logótipo'),
(127, 1, 'Pages Configuration'),
(128, 1, 'Advanced Customization'),
(129, 1, 'Welcome'),
(130, 1, 'Merchant Expertise'),
(131, 1, 'Advertising'),
(132, 1, 'Conformidade oficial com o RGPD'),
(133, 1, 'Conformidade oficial com o RGPD'),
(134, 1, 'Marketplace'),
(135, 1, 'Module Selections'),
(136, 1, 'Module recommended'),
(137, 1, 'Catálogo do Tema Gráfico'),
(138, 1, 'ps_buybuttonlite'),
(139, 1, 'blockreassurance'),
(140, 1, 'Product Tab'),
(141, 1, 'Product Tabs'),
(142, 1, 'Product Tab Settings'),
(143, 1, 'Global Product Tabs'),
(144, 1, 'Emails Manager Preview'),
(145, 1, '1-Click Upgrade'),
(146, 1, 'Uninstalled modules');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tab_module_preference`
--

CREATE TABLE `ps_tab_module_preference` (
  `id_tab_module_preference` int(11) NOT NULL,
  `id_employee` int(11) NOT NULL,
  `id_tab` int(11) NOT NULL,
  `module` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tag`
--

CREATE TABLE `ps_tag` (
  `id_tag` int(10) UNSIGNED NOT NULL,
  `id_lang` int(10) UNSIGNED NOT NULL,
  `name` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tag_count`
--

CREATE TABLE `ps_tag_count` (
  `id_group` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `id_tag` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `id_lang` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `id_shop` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `counter` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_tag_count`
--

INSERT INTO `ps_tag_count` (`id_group`, `id_tag`, `id_lang`, `id_shop`, `counter`) VALUES
(0, 8, 1, 1, 1),
(0, 9, 1, 1, 1),
(0, 10, 1, 1, 1),
(0, 13, 1, 1, 1),
(1, 8, 1, 1, 1),
(1, 9, 1, 1, 1),
(1, 10, 1, 1, 1),
(1, 13, 1, 1, 1),
(2, 8, 1, 1, 1),
(2, 9, 1, 1, 1),
(2, 10, 1, 1, 1),
(2, 13, 1, 1, 1),
(3, 8, 1, 1, 1),
(3, 9, 1, 1, 1),
(3, 10, 1, 1, 1),
(3, 13, 1, 1, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tax`
--

CREATE TABLE `ps_tax` (
  `id_tax` int(10) UNSIGNED NOT NULL,
  `rate` decimal(10,3) NOT NULL,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_tax`
--

INSERT INTO `ps_tax` (`id_tax`, `rate`, `active`, `deleted`) VALUES
(1, 23.000, 1, 0),
(2, 13.000, 1, 0),
(3, 6.000, 1, 0),
(4, 20.000, 0, 0),
(5, 21.000, 0, 0),
(6, 20.000, 0, 0),
(7, 19.000, 0, 0),
(8, 21.000, 0, 0),
(9, 19.000, 0, 0),
(10, 25.000, 0, 0),
(11, 20.000, 0, 0),
(12, 21.000, 0, 0),
(13, 24.000, 0, 0),
(14, 20.000, 0, 0),
(15, 20.000, 0, 0),
(16, 23.000, 0, 0),
(17, 25.000, 0, 0),
(18, 27.000, 0, 0),
(19, 23.000, 0, 0),
(20, 22.000, 0, 0),
(21, 21.000, 0, 0),
(22, 17.000, 0, 0),
(23, 21.000, 0, 0),
(24, 18.000, 0, 0),
(25, 21.000, 0, 0),
(26, 23.000, 0, 0),
(27, 20.000, 0, 0),
(28, 25.000, 0, 0),
(29, 22.000, 0, 0),
(30, 20.000, 0, 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tax_lang`
--

CREATE TABLE `ps_tax_lang` (
  `id_tax` int(10) UNSIGNED NOT NULL,
  `id_lang` int(10) UNSIGNED NOT NULL,
  `name` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_tax_lang`
--

INSERT INTO `ps_tax_lang` (`id_tax`, `id_lang`, `name`) VALUES
(1, 1, 'IVA PT 23%'),
(2, 1, 'IVA PT 13%'),
(3, 1, 'IVA PT 6%'),
(4, 1, 'USt. AT 20%'),
(5, 1, 'TVA BE 21%'),
(6, 1, 'ДДС BG 20%'),
(7, 1, 'ΦΠΑ CY 19%'),
(8, 1, 'DPH CZ 21%'),
(9, 1, 'MwSt. DE 19%'),
(10, 1, 'moms DK 25%'),
(11, 1, 'km EE 20%'),
(12, 1, 'IVA ES 21%'),
(13, 1, 'ALV FI 24%'),
(14, 1, 'TVA FR 20%'),
(15, 1, 'VAT UK 20%'),
(16, 1, 'ΦΠΑ GR 23%'),
(17, 1, 'Croatia PDV 25%'),
(18, 1, 'ÁFA HU 27%'),
(19, 1, 'VAT IE 23%'),
(20, 1, 'IVA IT 22%'),
(21, 1, 'PVM LT 21%'),
(22, 1, 'TVA LU 17%'),
(23, 1, 'PVN LV 21%'),
(24, 1, 'VAT MT 18%'),
(25, 1, 'BTW NL 21%'),
(26, 1, 'PTU PL 23%'),
(27, 1, 'TVA RO 20%'),
(28, 1, 'Moms SE 25%'),
(29, 1, 'DDV SI 22%'),
(30, 1, 'DPH SK 20%');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tax_rule`
--

CREATE TABLE `ps_tax_rule` (
  `id_tax_rule` int(11) NOT NULL,
  `id_tax_rules_group` int(11) NOT NULL,
  `id_country` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `zipcode_from` varchar(12) NOT NULL,
  `zipcode_to` varchar(12) NOT NULL,
  `id_tax` int(11) NOT NULL,
  `behavior` int(11) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_tax_rule`
--

INSERT INTO `ps_tax_rule` (`id_tax_rule`, `id_tax_rules_group`, `id_country`, `id_state`, `zipcode_from`, `zipcode_to`, `id_tax`, `behavior`, `description`) VALUES
(159, 1, 231, 0, '0', '0', 1, 0, ''),
(160, 1, 244, 0, '0', '0', 1, 0, ''),
(161, 1, 230, 0, '0', '0', 1, 0, ''),
(162, 1, 38, 0, '0', '0', 1, 0, ''),
(163, 1, 39, 0, '0', '0', 1, 0, ''),
(164, 1, 40, 0, '0', '0', 1, 0, ''),
(165, 1, 41, 0, '0', '0', 1, 0, ''),
(166, 1, 42, 0, '0', '0', 1, 0, ''),
(167, 1, 232, 0, '0', '0', 1, 0, ''),
(168, 1, 43, 0, '0', '0', 1, 0, ''),
(169, 1, 44, 0, '0', '0', 1, 0, ''),
(170, 1, 45, 0, '0', '0', 1, 0, ''),
(171, 1, 46, 0, '0', '0', 1, 0, ''),
(172, 1, 24, 0, '0', '0', 1, 0, ''),
(173, 1, 2, 0, '0', '0', 1, 0, ''),
(174, 1, 47, 0, '0', '0', 1, 0, ''),
(175, 1, 48, 0, '0', '0', 1, 0, ''),
(176, 1, 49, 0, '0', '0', 1, 0, ''),
(177, 1, 50, 0, '0', '0', 1, 0, ''),
(178, 1, 51, 0, '0', '0', 1, 0, ''),
(179, 1, 52, 0, '0', '0', 1, 0, ''),
(180, 1, 3, 0, '0', '0', 1, 0, ''),
(181, 1, 53, 0, '0', '0', 1, 0, ''),
(182, 1, 54, 0, '0', '0', 1, 0, ''),
(183, 1, 55, 0, '0', '0', 1, 0, ''),
(184, 1, 56, 0, '0', '0', 1, 0, ''),
(185, 1, 34, 0, '0', '0', 1, 0, ''),
(186, 1, 233, 0, '0', '0', 1, 0, ''),
(187, 1, 57, 0, '0', '0', 1, 0, ''),
(188, 1, 234, 0, '0', '0', 1, 0, ''),
(189, 1, 58, 0, '0', '0', 1, 0, ''),
(190, 1, 235, 0, '0', '0', 1, 0, ''),
(191, 1, 59, 0, '0', '0', 1, 0, ''),
(192, 1, 236, 0, '0', '0', 1, 0, ''),
(193, 1, 60, 0, '0', '0', 1, 0, ''),
(194, 1, 61, 0, '0', '0', 1, 0, ''),
(195, 1, 62, 0, '0', '0', 1, 0, ''),
(196, 1, 63, 0, '0', '0', 1, 0, ''),
(197, 1, 64, 0, '0', '0', 1, 0, ''),
(198, 1, 4, 0, '0', '0', 1, 0, ''),
(199, 1, 65, 0, '0', '0', 1, 0, ''),
(200, 1, 237, 0, '0', '0', 1, 0, ''),
(201, 1, 66, 0, '0', '0', 1, 0, ''),
(202, 1, 67, 0, '0', '0', 1, 0, ''),
(203, 1, 68, 0, '0', '0', 1, 0, ''),
(204, 1, 5, 0, '0', '0', 1, 0, ''),
(205, 1, 238, 0, '0', '0', 1, 0, ''),
(206, 1, 239, 0, '0', '0', 1, 0, ''),
(207, 1, 69, 0, '0', '0', 1, 0, ''),
(208, 1, 70, 0, '0', '0', 1, 0, ''),
(209, 1, 71, 0, '0', '0', 1, 0, ''),
(210, 1, 72, 0, '0', '0', 1, 0, ''),
(211, 1, 240, 0, '0', '0', 1, 0, ''),
(212, 1, 73, 0, '0', '0', 1, 0, ''),
(213, 1, 74, 0, '0', '0', 1, 0, ''),
(214, 1, 75, 0, '0', '0', 1, 0, ''),
(215, 1, 76, 0, '0', '0', 1, 0, ''),
(216, 1, 16, 0, '0', '0', 1, 0, ''),
(217, 1, 20, 0, '0', '0', 1, 0, ''),
(218, 1, 77, 0, '0', '0', 1, 0, ''),
(219, 1, 78, 0, '0', '0', 1, 0, ''),
(220, 1, 79, 0, '0', '0', 1, 0, ''),
(221, 1, 80, 0, '0', '0', 1, 0, ''),
(222, 1, 81, 0, '0', '0', 1, 0, ''),
(223, 1, 82, 0, '0', '0', 1, 0, ''),
(224, 1, 83, 0, '0', '0', 1, 0, ''),
(225, 1, 84, 0, '0', '0', 1, 0, ''),
(226, 1, 85, 0, '0', '0', 1, 0, ''),
(227, 1, 86, 0, '0', '0', 1, 0, ''),
(228, 1, 87, 0, '0', '0', 1, 0, ''),
(229, 1, 88, 0, '0', '0', 1, 0, ''),
(230, 1, 89, 0, '0', '0', 1, 0, ''),
(231, 1, 90, 0, '0', '0', 1, 0, ''),
(232, 1, 7, 0, '0', '0', 1, 0, ''),
(233, 1, 8, 0, '0', '0', 1, 0, ''),
(234, 1, 241, 0, '0', '0', 1, 0, ''),
(235, 1, 242, 0, '0', '0', 1, 0, ''),
(236, 1, 243, 0, '0', '0', 1, 0, ''),
(237, 1, 91, 0, '0', '0', 1, 0, ''),
(238, 1, 92, 0, '0', '0', 1, 0, ''),
(239, 1, 93, 0, '0', '0', 1, 0, ''),
(240, 1, 1, 0, '0', '0', 1, 0, ''),
(241, 1, 94, 0, '0', '0', 1, 0, ''),
(242, 1, 97, 0, '0', '0', 1, 0, ''),
(243, 1, 9, 0, '0', '0', 1, 0, ''),
(244, 1, 96, 0, '0', '0', 1, 0, ''),
(245, 1, 95, 0, '0', '0', 1, 0, ''),
(246, 1, 98, 0, '0', '0', 1, 0, ''),
(247, 1, 99, 0, '0', '0', 1, 0, ''),
(248, 1, 100, 0, '0', '0', 1, 0, ''),
(249, 1, 101, 0, '0', '0', 1, 0, ''),
(250, 1, 102, 0, '0', '0', 1, 0, ''),
(251, 1, 103, 0, '0', '0', 1, 0, ''),
(252, 1, 104, 0, '0', '0', 1, 0, ''),
(253, 1, 105, 0, '0', '0', 1, 0, ''),
(254, 1, 106, 0, '0', '0', 1, 0, ''),
(255, 1, 108, 0, '0', '0', 1, 0, ''),
(256, 1, 22, 0, '0', '0', 1, 0, ''),
(257, 1, 143, 0, '0', '0', 1, 0, ''),
(258, 1, 109, 0, '0', '0', 1, 0, ''),
(259, 1, 110, 0, '0', '0', 1, 0, ''),
(260, 1, 111, 0, '0', '0', 1, 0, ''),
(261, 1, 112, 0, '0', '0', 1, 0, ''),
(262, 1, 113, 0, '0', '0', 1, 0, ''),
(263, 1, 26, 0, '0', '0', 1, 0, ''),
(264, 1, 29, 0, '0', '0', 1, 0, ''),
(265, 1, 10, 0, '0', '0', 1, 0, ''),
(266, 1, 32, 0, '0', '0', 1, 0, ''),
(267, 1, 115, 0, '0', '0', 1, 0, ''),
(268, 1, 11, 0, '0', '0', 1, 0, ''),
(269, 1, 116, 0, '0', '0', 1, 0, ''),
(270, 1, 117, 0, '0', '0', 1, 0, ''),
(271, 1, 118, 0, '0', '0', 1, 0, ''),
(272, 1, 119, 0, '0', '0', 1, 0, ''),
(273, 1, 120, 0, '0', '0', 1, 0, ''),
(274, 1, 121, 0, '0', '0', 1, 0, ''),
(275, 1, 122, 0, '0', '0', 1, 0, ''),
(276, 1, 123, 0, '0', '0', 1, 0, ''),
(277, 1, 124, 0, '0', '0', 1, 0, ''),
(278, 1, 125, 0, '0', '0', 1, 0, ''),
(279, 1, 126, 0, '0', '0', 1, 0, ''),
(280, 1, 127, 0, '0', '0', 1, 0, ''),
(281, 1, 128, 0, '0', '0', 1, 0, ''),
(282, 1, 129, 0, '0', '0', 1, 0, ''),
(283, 1, 130, 0, '0', '0', 1, 0, ''),
(284, 1, 131, 0, '0', '0', 1, 0, ''),
(285, 1, 12, 0, '0', '0', 1, 0, ''),
(286, 1, 132, 0, '0', '0', 1, 0, ''),
(287, 1, 133, 0, '0', '0', 1, 0, ''),
(288, 1, 134, 0, '0', '0', 1, 0, ''),
(289, 1, 135, 0, '0', '0', 1, 0, ''),
(290, 1, 136, 0, '0', '0', 1, 0, ''),
(291, 1, 137, 0, '0', '0', 1, 0, ''),
(292, 1, 138, 0, '0', '0', 1, 0, ''),
(293, 1, 139, 0, '0', '0', 1, 0, ''),
(294, 1, 114, 0, '0', '0', 1, 0, ''),
(295, 1, 140, 0, '0', '0', 1, 0, ''),
(296, 1, 141, 0, '0', '0', 1, 0, ''),
(297, 1, 142, 0, '0', '0', 1, 0, ''),
(298, 1, 35, 0, '0', '0', 1, 0, ''),
(299, 1, 144, 0, '0', '0', 1, 0, ''),
(300, 1, 145, 0, '0', '0', 1, 0, ''),
(301, 1, 146, 0, '0', '0', 1, 0, ''),
(302, 1, 147, 0, '0', '0', 1, 0, ''),
(303, 1, 148, 0, '0', '0', 1, 0, ''),
(304, 1, 149, 0, '0', '0', 1, 0, ''),
(305, 1, 150, 0, '0', '0', 1, 0, ''),
(306, 1, 151, 0, '0', '0', 1, 0, ''),
(307, 1, 152, 0, '0', '0', 1, 0, ''),
(308, 1, 153, 0, '0', '0', 1, 0, ''),
(309, 1, 154, 0, '0', '0', 1, 0, ''),
(310, 1, 155, 0, '0', '0', 1, 0, ''),
(311, 1, 156, 0, '0', '0', 1, 0, ''),
(312, 1, 13, 0, '0', '0', 1, 0, ''),
(313, 1, 157, 0, '0', '0', 1, 0, ''),
(314, 1, 158, 0, '0', '0', 1, 0, ''),
(315, 1, 27, 0, '0', '0', 1, 0, ''),
(316, 1, 159, 0, '0', '0', 1, 0, ''),
(317, 1, 160, 0, '0', '0', 1, 0, ''),
(318, 1, 31, 0, '0', '0', 1, 0, ''),
(319, 1, 161, 0, '0', '0', 1, 0, ''),
(320, 1, 162, 0, '0', '0', 1, 0, ''),
(321, 1, 163, 0, '0', '0', 1, 0, ''),
(322, 1, 23, 0, '0', '0', 1, 0, ''),
(323, 1, 164, 0, '0', '0', 1, 0, ''),
(324, 1, 165, 0, '0', '0', 1, 0, ''),
(325, 1, 166, 0, '0', '0', 1, 0, ''),
(326, 1, 167, 0, '0', '0', 1, 0, ''),
(327, 1, 168, 0, '0', '0', 1, 0, ''),
(328, 1, 169, 0, '0', '0', 1, 0, ''),
(329, 1, 170, 0, '0', '0', 1, 0, ''),
(330, 1, 171, 0, '0', '0', 1, 0, ''),
(331, 1, 172, 0, '0', '0', 1, 0, ''),
(332, 1, 173, 0, '0', '0', 1, 0, ''),
(333, 1, 14, 0, '0', '0', 1, 0, ''),
(334, 1, 15, 0, '0', '0', 1, 0, ''),
(335, 1, 174, 0, '0', '0', 1, 0, ''),
(336, 1, 175, 0, '0', '0', 1, 0, ''),
(337, 1, 176, 0, '0', '0', 1, 0, ''),
(338, 1, 36, 0, '0', '0', 1, 0, ''),
(339, 1, 177, 0, '0', '0', 1, 0, ''),
(340, 1, 178, 0, '0', '0', 1, 0, ''),
(341, 1, 179, 0, '0', '0', 1, 0, ''),
(342, 1, 180, 0, '0', '0', 1, 0, ''),
(343, 1, 181, 0, '0', '0', 1, 0, ''),
(344, 1, 182, 0, '0', '0', 1, 0, ''),
(345, 1, 183, 0, '0', '0', 1, 0, ''),
(346, 1, 184, 0, '0', '0', 1, 0, ''),
(347, 1, 185, 0, '0', '0', 1, 0, ''),
(348, 1, 186, 0, '0', '0', 1, 0, ''),
(349, 1, 187, 0, '0', '0', 1, 0, ''),
(350, 1, 188, 0, '0', '0', 1, 0, ''),
(351, 1, 189, 0, '0', '0', 1, 0, ''),
(352, 1, 190, 0, '0', '0', 1, 0, ''),
(353, 1, 191, 0, '0', '0', 1, 0, ''),
(354, 1, 192, 0, '0', '0', 1, 0, ''),
(355, 1, 25, 0, '0', '0', 1, 0, ''),
(356, 1, 37, 0, '0', '0', 1, 0, ''),
(357, 1, 193, 0, '0', '0', 1, 0, ''),
(358, 1, 194, 0, '0', '0', 1, 0, ''),
(359, 1, 195, 0, '0', '0', 1, 0, ''),
(360, 1, 30, 0, '0', '0', 1, 0, ''),
(361, 1, 196, 0, '0', '0', 1, 0, ''),
(362, 1, 28, 0, '0', '0', 1, 0, ''),
(363, 1, 6, 0, '0', '0', 1, 0, ''),
(364, 1, 197, 0, '0', '0', 1, 0, ''),
(365, 1, 198, 0, '0', '0', 1, 0, ''),
(366, 1, 199, 0, '0', '0', 1, 0, ''),
(367, 1, 200, 0, '0', '0', 1, 0, ''),
(368, 1, 201, 0, '0', '0', 1, 0, ''),
(369, 1, 18, 0, '0', '0', 1, 0, ''),
(370, 1, 19, 0, '0', '0', 1, 0, ''),
(371, 1, 202, 0, '0', '0', 1, 0, ''),
(372, 1, 203, 0, '0', '0', 1, 0, ''),
(373, 1, 204, 0, '0', '0', 1, 0, ''),
(374, 1, 205, 0, '0', '0', 1, 0, ''),
(375, 1, 206, 0, '0', '0', 1, 0, ''),
(376, 1, 33, 0, '0', '0', 1, 0, ''),
(377, 1, 207, 0, '0', '0', 1, 0, ''),
(378, 1, 208, 0, '0', '0', 1, 0, ''),
(379, 1, 209, 0, '0', '0', 1, 0, ''),
(380, 1, 210, 0, '0', '0', 1, 0, ''),
(381, 1, 211, 0, '0', '0', 1, 0, ''),
(382, 1, 212, 0, '0', '0', 1, 0, ''),
(383, 1, 213, 0, '0', '0', 1, 0, ''),
(384, 1, 214, 0, '0', '0', 1, 0, ''),
(385, 1, 215, 0, '0', '0', 1, 0, ''),
(386, 1, 216, 0, '0', '0', 1, 0, ''),
(387, 1, 217, 0, '0', '0', 1, 0, ''),
(388, 1, 17, 0, '0', '0', 1, 0, ''),
(389, 1, 21, 0, '0', '0', 1, 0, ''),
(390, 1, 218, 0, '0', '0', 1, 0, ''),
(391, 1, 219, 0, '0', '0', 1, 0, ''),
(392, 1, 220, 0, '0', '0', 1, 0, ''),
(393, 1, 107, 0, '0', '0', 1, 0, ''),
(394, 1, 221, 0, '0', '0', 1, 0, ''),
(395, 1, 222, 0, '0', '0', 1, 0, ''),
(396, 1, 223, 0, '0', '0', 1, 0, ''),
(397, 1, 224, 0, '0', '0', 1, 0, ''),
(398, 1, 225, 0, '0', '0', 1, 0, ''),
(399, 1, 226, 0, '0', '0', 1, 0, ''),
(400, 1, 227, 0, '0', '0', 1, 0, ''),
(401, 1, 228, 0, '0', '0', 1, 0, ''),
(402, 1, 229, 0, '0', '0', 1, 0, '');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tax_rules_group`
--

CREATE TABLE `ps_tax_rules_group` (
  `id_tax_rules_group` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `active` int(11) NOT NULL,
  `deleted` tinyint(1) UNSIGNED NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_tax_rules_group`
--

INSERT INTO `ps_tax_rules_group` (`id_tax_rules_group`, `name`, `active`, `deleted`, `date_add`, `date_upd`) VALUES
(1, 'PT Standard Rate (23%)', 1, 0, '2020-11-16 21:58:01', '2020-11-16 23:50:57'),
(2, 'PT Reduced Rate (13%)', 1, 0, '2020-11-16 21:58:01', '2020-11-16 21:58:01'),
(3, 'PT Super Reduced Rate (6%)', 1, 0, '2020-11-16 21:58:01', '2020-11-16 21:58:01'),
(4, 'PT Foodstuff Rate (6%)', 1, 0, '2020-11-16 21:58:01', '2020-11-16 21:58:01'),
(5, 'PT Books Rate (6%)', 1, 0, '2020-11-16 21:58:01', '2020-11-16 21:58:01'),
(6, 'EU VAT For Virtual Products', 1, 0, '2020-11-16 21:58:01', '2020-11-16 21:58:01');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_tax_rules_group_shop`
--

CREATE TABLE `ps_tax_rules_group_shop` (
  `id_tax_rules_group` int(11) UNSIGNED NOT NULL,
  `id_shop` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_tax_rules_group_shop`
--

INSERT INTO `ps_tax_rules_group_shop` (`id_tax_rules_group`, `id_shop`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_timezone`
--

CREATE TABLE `ps_timezone` (
  `id_timezone` int(10) UNSIGNED NOT NULL,
  `name` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_timezone`
--

INSERT INTO `ps_timezone` (`id_timezone`, `name`) VALUES
(1, 'Africa/Abidjan'),
(2, 'Africa/Accra'),
(3, 'Africa/Addis_Ababa'),
(4, 'Africa/Algiers'),
(5, 'Africa/Asmara'),
(6, 'Africa/Asmera'),
(7, 'Africa/Bamako'),
(8, 'Africa/Bangui'),
(9, 'Africa/Banjul'),
(10, 'Africa/Bissau'),
(11, 'Africa/Blantyre'),
(12, 'Africa/Brazzaville'),
(13, 'Africa/Bujumbura'),
(14, 'Africa/Cairo'),
(15, 'Africa/Casablanca'),
(16, 'Africa/Ceuta'),
(17, 'Africa/Conakry'),
(18, 'Africa/Dakar'),
(19, 'Africa/Dar_es_Salaam'),
(20, 'Africa/Djibouti'),
(21, 'Africa/Douala'),
(22, 'Africa/El_Aaiun'),
(23, 'Africa/Freetown'),
(24, 'Africa/Gaborone'),
(25, 'Africa/Harare'),
(26, 'Africa/Johannesburg'),
(27, 'Africa/Kampala'),
(28, 'Africa/Khartoum'),
(29, 'Africa/Kigali'),
(30, 'Africa/Kinshasa'),
(31, 'Africa/Lagos'),
(32, 'Africa/Libreville'),
(33, 'Africa/Lome'),
(34, 'Africa/Luanda'),
(35, 'Africa/Lubumbashi'),
(36, 'Africa/Lusaka'),
(37, 'Africa/Malabo'),
(38, 'Africa/Maputo'),
(39, 'Africa/Maseru'),
(40, 'Africa/Mbabane'),
(41, 'Africa/Mogadishu'),
(42, 'Africa/Monrovia'),
(43, 'Africa/Nairobi'),
(44, 'Africa/Ndjamena'),
(45, 'Africa/Niamey'),
(46, 'Africa/Nouakchott'),
(47, 'Africa/Ouagadougou'),
(48, 'Africa/Porto-Novo'),
(49, 'Africa/Sao_Tome'),
(50, 'Africa/Timbuktu'),
(51, 'Africa/Tripoli'),
(52, 'Africa/Tunis'),
(53, 'Africa/Windhoek'),
(54, 'America/Adak'),
(55, 'America/Anchorage '),
(56, 'America/Anguilla'),
(57, 'America/Antigua'),
(58, 'America/Araguaina'),
(59, 'America/Argentina/Buenos_Aires'),
(60, 'America/Argentina/Catamarca'),
(61, 'America/Argentina/ComodRivadavia'),
(62, 'America/Argentina/Cordoba'),
(63, 'America/Argentina/Jujuy'),
(64, 'America/Argentina/La_Rioja'),
(65, 'America/Argentina/Mendoza'),
(66, 'America/Argentina/Rio_Gallegos'),
(67, 'America/Argentina/Salta'),
(68, 'America/Argentina/San_Juan'),
(69, 'America/Argentina/San_Luis'),
(70, 'America/Argentina/Tucuman'),
(71, 'America/Argentina/Ushuaia'),
(72, 'America/Aruba'),
(73, 'America/Asuncion'),
(74, 'America/Atikokan'),
(75, 'America/Atka'),
(76, 'America/Bahia'),
(77, 'America/Barbados'),
(78, 'America/Belem'),
(79, 'America/Belize'),
(80, 'America/Blanc-Sablon'),
(81, 'America/Boa_Vista'),
(82, 'America/Bogota'),
(83, 'America/Boise'),
(84, 'America/Buenos_Aires'),
(85, 'America/Cambridge_Bay'),
(86, 'America/Campo_Grande'),
(87, 'America/Cancun'),
(88, 'America/Caracas'),
(89, 'America/Catamarca'),
(90, 'America/Cayenne'),
(91, 'America/Cayman'),
(92, 'America/Chicago'),
(93, 'America/Chihuahua'),
(94, 'America/Coral_Harbour'),
(95, 'America/Cordoba'),
(96, 'America/Costa_Rica'),
(97, 'America/Cuiaba'),
(98, 'America/Curacao'),
(99, 'America/Danmarkshavn'),
(100, 'America/Dawson'),
(101, 'America/Dawson_Creek'),
(102, 'America/Denver'),
(103, 'America/Detroit'),
(104, 'America/Dominica'),
(105, 'America/Edmonton'),
(106, 'America/Eirunepe'),
(107, 'America/El_Salvador'),
(108, 'America/Ensenada'),
(109, 'America/Fort_Wayne'),
(110, 'America/Fortaleza'),
(111, 'America/Glace_Bay'),
(112, 'America/Godthab'),
(113, 'America/Goose_Bay'),
(114, 'America/Grand_Turk'),
(115, 'America/Grenada'),
(116, 'America/Guadeloupe'),
(117, 'America/Guatemala'),
(118, 'America/Guayaquil'),
(119, 'America/Guyana'),
(120, 'America/Halifax'),
(121, 'America/Havana'),
(122, 'America/Hermosillo'),
(123, 'America/Indiana/Indianapolis'),
(124, 'America/Indiana/Knox'),
(125, 'America/Indiana/Marengo'),
(126, 'America/Indiana/Petersburg'),
(127, 'America/Indiana/Tell_City'),
(128, 'America/Indiana/Vevay'),
(129, 'America/Indiana/Vincennes'),
(130, 'America/Indiana/Winamac'),
(131, 'America/Indianapolis'),
(132, 'America/Inuvik'),
(133, 'America/Iqaluit'),
(134, 'America/Jamaica'),
(135, 'America/Jujuy'),
(136, 'America/Juneau'),
(137, 'America/Kentucky/Louisville'),
(138, 'America/Kentucky/Monticello'),
(139, 'America/Knox_IN'),
(140, 'America/La_Paz'),
(141, 'America/Lima'),
(142, 'America/Los_Angeles'),
(143, 'America/Louisville'),
(144, 'America/Maceio'),
(145, 'America/Managua'),
(146, 'America/Manaus'),
(147, 'America/Marigot'),
(148, 'America/Martinique'),
(149, 'America/Mazatlan'),
(150, 'America/Mendoza'),
(151, 'America/Menominee'),
(152, 'America/Merida'),
(153, 'America/Mexico_City'),
(154, 'America/Miquelon'),
(155, 'America/Moncton'),
(156, 'America/Monterrey'),
(157, 'America/Montevideo'),
(158, 'America/Montreal'),
(159, 'America/Montserrat'),
(160, 'America/Nassau'),
(161, 'America/New_York'),
(162, 'America/Nipigon'),
(163, 'America/Nome'),
(164, 'America/Noronha'),
(165, 'America/North_Dakota/Center'),
(166, 'America/North_Dakota/New_Salem'),
(167, 'America/Panama'),
(168, 'America/Pangnirtung'),
(169, 'America/Paramaribo'),
(170, 'America/Phoenix'),
(171, 'America/Port-au-Prince'),
(172, 'America/Port_of_Spain'),
(173, 'America/Porto_Acre'),
(174, 'America/Porto_Velho'),
(175, 'America/Puerto_Rico'),
(176, 'America/Rainy_River'),
(177, 'America/Rankin_Inlet'),
(178, 'America/Recife'),
(179, 'America/Regina'),
(180, 'America/Resolute'),
(181, 'America/Rio_Branco'),
(182, 'America/Rosario'),
(183, 'America/Santarem'),
(184, 'America/Santiago'),
(185, 'America/Santo_Domingo'),
(186, 'America/Sao_Paulo'),
(187, 'America/Scoresbysund'),
(188, 'America/Shiprock'),
(189, 'America/St_Barthelemy'),
(190, 'America/St_Johns'),
(191, 'America/St_Kitts'),
(192, 'America/St_Lucia'),
(193, 'America/St_Thomas'),
(194, 'America/St_Vincent'),
(195, 'America/Swift_Current'),
(196, 'America/Tegucigalpa'),
(197, 'America/Thule'),
(198, 'America/Thunder_Bay'),
(199, 'America/Tijuana'),
(200, 'America/Toronto'),
(201, 'America/Tortola'),
(202, 'America/Vancouver'),
(203, 'America/Virgin'),
(204, 'America/Whitehorse'),
(205, 'America/Winnipeg'),
(206, 'America/Yakutat'),
(207, 'America/Yellowknife'),
(208, 'Antarctica/Casey'),
(209, 'Antarctica/Davis'),
(210, 'Antarctica/DumontDUrville'),
(211, 'Antarctica/Mawson'),
(212, 'Antarctica/McMurdo'),
(213, 'Antarctica/Palmer'),
(214, 'Antarctica/Rothera'),
(215, 'Antarctica/South_Pole'),
(216, 'Antarctica/Syowa'),
(217, 'Antarctica/Vostok'),
(218, 'Arctic/Longyearbyen'),
(219, 'Asia/Aden'),
(220, 'Asia/Almaty'),
(221, 'Asia/Amman'),
(222, 'Asia/Anadyr'),
(223, 'Asia/Aqtau'),
(224, 'Asia/Aqtobe'),
(225, 'Asia/Ashgabat'),
(226, 'Asia/Ashkhabad'),
(227, 'Asia/Baghdad'),
(228, 'Asia/Bahrain'),
(229, 'Asia/Baku'),
(230, 'Asia/Bangkok'),
(231, 'Asia/Beirut'),
(232, 'Asia/Bishkek'),
(233, 'Asia/Brunei'),
(234, 'Asia/Calcutta'),
(235, 'Asia/Choibalsan'),
(236, 'Asia/Chongqing'),
(237, 'Asia/Chungking'),
(238, 'Asia/Colombo'),
(239, 'Asia/Dacca'),
(240, 'Asia/Damascus'),
(241, 'Asia/Dhaka'),
(242, 'Asia/Dili'),
(243, 'Asia/Dubai'),
(244, 'Asia/Dushanbe'),
(245, 'Asia/Gaza'),
(246, 'Asia/Harbin'),
(247, 'Asia/Ho_Chi_Minh'),
(248, 'Asia/Hong_Kong'),
(249, 'Asia/Hovd'),
(250, 'Asia/Irkutsk'),
(251, 'Asia/Istanbul'),
(252, 'Asia/Jakarta'),
(253, 'Asia/Jayapura'),
(254, 'Asia/Jerusalem'),
(255, 'Asia/Kabul'),
(256, 'Asia/Kamchatka'),
(257, 'Asia/Karachi'),
(258, 'Asia/Kashgar'),
(259, 'Asia/Kathmandu'),
(260, 'Asia/Katmandu'),
(261, 'Asia/Kolkata'),
(262, 'Asia/Krasnoyarsk'),
(263, 'Asia/Kuala_Lumpur'),
(264, 'Asia/Kuching'),
(265, 'Asia/Kuwait'),
(266, 'Asia/Macao'),
(267, 'Asia/Macau'),
(268, 'Asia/Magadan'),
(269, 'Asia/Makassar'),
(270, 'Asia/Manila'),
(271, 'Asia/Muscat'),
(272, 'Asia/Nicosia'),
(273, 'Asia/Novosibirsk'),
(274, 'Asia/Omsk'),
(275, 'Asia/Oral'),
(276, 'Asia/Phnom_Penh'),
(277, 'Asia/Pontianak'),
(278, 'Asia/Pyongyang'),
(279, 'Asia/Qatar'),
(280, 'Asia/Qyzylorda'),
(281, 'Asia/Rangoon'),
(282, 'Asia/Riyadh'),
(283, 'Asia/Saigon'),
(284, 'Asia/Sakhalin'),
(285, 'Asia/Samarkand'),
(286, 'Asia/Seoul'),
(287, 'Asia/Shanghai'),
(288, 'Asia/Singapore'),
(289, 'Asia/Taipei'),
(290, 'Asia/Tashkent'),
(291, 'Asia/Tbilisi'),
(292, 'Asia/Tehran'),
(293, 'Asia/Tel_Aviv'),
(294, 'Asia/Thimbu'),
(295, 'Asia/Thimphu'),
(296, 'Asia/Tokyo'),
(297, 'Asia/Ujung_Pandang'),
(298, 'Asia/Ulaanbaatar'),
(299, 'Asia/Ulan_Bator'),
(300, 'Asia/Urumqi'),
(301, 'Asia/Vientiane'),
(302, 'Asia/Vladivostok'),
(303, 'Asia/Yakutsk'),
(304, 'Asia/Yekaterinburg'),
(305, 'Asia/Yerevan'),
(306, 'Atlantic/Azores'),
(307, 'Atlantic/Bermuda'),
(308, 'Atlantic/Canary'),
(309, 'Atlantic/Cape_Verde'),
(310, 'Atlantic/Faeroe'),
(311, 'Atlantic/Faroe'),
(312, 'Atlantic/Jan_Mayen'),
(313, 'Atlantic/Madeira'),
(314, 'Atlantic/Reykjavik'),
(315, 'Atlantic/South_Georgia'),
(316, 'Atlantic/St_Helena'),
(317, 'Atlantic/Stanley'),
(318, 'Australia/ACT'),
(319, 'Australia/Adelaide'),
(320, 'Australia/Brisbane'),
(321, 'Australia/Broken_Hill'),
(322, 'Australia/Canberra'),
(323, 'Australia/Currie'),
(324, 'Australia/Darwin'),
(325, 'Australia/Eucla'),
(326, 'Australia/Hobart'),
(327, 'Australia/LHI'),
(328, 'Australia/Lindeman'),
(329, 'Australia/Lord_Howe'),
(330, 'Australia/Melbourne'),
(331, 'Australia/North'),
(332, 'Australia/NSW'),
(333, 'Australia/Perth'),
(334, 'Australia/Queensland'),
(335, 'Australia/South'),
(336, 'Australia/Sydney'),
(337, 'Australia/Tasmania'),
(338, 'Australia/Victoria'),
(339, 'Australia/West'),
(340, 'Australia/Yancowinna'),
(341, 'Europe/Amsterdam'),
(342, 'Europe/Andorra'),
(343, 'Europe/Athens'),
(344, 'Europe/Belfast'),
(345, 'Europe/Belgrade'),
(346, 'Europe/Berlin'),
(347, 'Europe/Bratislava'),
(348, 'Europe/Brussels'),
(349, 'Europe/Bucharest'),
(350, 'Europe/Budapest'),
(351, 'Europe/Chisinau'),
(352, 'Europe/Copenhagen'),
(353, 'Europe/Dublin'),
(354, 'Europe/Gibraltar'),
(355, 'Europe/Guernsey'),
(356, 'Europe/Helsinki'),
(357, 'Europe/Isle_of_Man'),
(358, 'Europe/Istanbul'),
(359, 'Europe/Jersey'),
(360, 'Europe/Kaliningrad'),
(361, 'Europe/Kiev'),
(362, 'Europe/Lisbon'),
(363, 'Europe/Ljubljana'),
(364, 'Europe/London'),
(365, 'Europe/Luxembourg'),
(366, 'Europe/Madrid'),
(367, 'Europe/Malta'),
(368, 'Europe/Mariehamn'),
(369, 'Europe/Minsk'),
(370, 'Europe/Monaco'),
(371, 'Europe/Moscow'),
(372, 'Europe/Nicosia'),
(373, 'Europe/Oslo'),
(374, 'Europe/Paris'),
(375, 'Europe/Podgorica'),
(376, 'Europe/Prague'),
(377, 'Europe/Riga'),
(378, 'Europe/Rome'),
(379, 'Europe/Samara'),
(380, 'Europe/San_Marino'),
(381, 'Europe/Sarajevo'),
(382, 'Europe/Simferopol'),
(383, 'Europe/Skopje'),
(384, 'Europe/Sofia'),
(385, 'Europe/Stockholm'),
(386, 'Europe/Tallinn'),
(387, 'Europe/Tirane'),
(388, 'Europe/Tiraspol'),
(389, 'Europe/Uzhgorod'),
(390, 'Europe/Vaduz'),
(391, 'Europe/Vatican'),
(392, 'Europe/Vienna'),
(393, 'Europe/Vilnius'),
(394, 'Europe/Volgograd'),
(395, 'Europe/Warsaw'),
(396, 'Europe/Zagreb'),
(397, 'Europe/Zaporozhye'),
(398, 'Europe/Zurich'),
(399, 'Indian/Antananarivo'),
(400, 'Indian/Chagos'),
(401, 'Indian/Christmas'),
(402, 'Indian/Cocos'),
(403, 'Indian/Comoro'),
(404, 'Indian/Kerguelen'),
(405, 'Indian/Mahe'),
(406, 'Indian/Maldives'),
(407, 'Indian/Mauritius'),
(408, 'Indian/Mayotte'),
(409, 'Indian/Reunion'),
(410, 'Pacific/Apia'),
(411, 'Pacific/Auckland'),
(412, 'Pacific/Chatham'),
(413, 'Pacific/Easter'),
(414, 'Pacific/Efate'),
(415, 'Pacific/Enderbury'),
(416, 'Pacific/Fakaofo'),
(417, 'Pacific/Fiji'),
(418, 'Pacific/Funafuti'),
(419, 'Pacific/Galapagos'),
(420, 'Pacific/Gambier'),
(421, 'Pacific/Guadalcanal'),
(422, 'Pacific/Guam'),
(423, 'Pacific/Honolulu'),
(424, 'Pacific/Johnston'),
(425, 'Pacific/Kiritimati'),
(426, 'Pacific/Kosrae'),
(427, 'Pacific/Kwajalein'),
(428, 'Pacific/Majuro'),
(429, 'Pacific/Marquesas'),
(430, 'Pacific/Midway'),
(431, 'Pacific/Nauru'),
(432, 'Pacific/Niue'),
(433, 'Pacific/Norfolk'),
(434, 'Pacific/Noumea'),
(435, 'Pacific/Pago_Pago'),
(436, 'Pacific/Palau'),
(437, 'Pacific/Pitcairn'),
(438, 'Pacific/Ponape'),
(439, 'Pacific/Port_Moresby'),
(440, 'Pacific/Rarotonga'),
(441, 'Pacific/Saipan'),
(442, 'Pacific/Samoa'),
(443, 'Pacific/Tahiti'),
(444, 'Pacific/Tarawa'),
(445, 'Pacific/Tongatapu'),
(446, 'Pacific/Truk'),
(447, 'Pacific/Wake'),
(448, 'Pacific/Wallis'),
(449, 'Pacific/Yap'),
(450, 'Brazil/Acre'),
(451, 'Brazil/DeNoronha'),
(452, 'Brazil/East'),
(453, 'Brazil/West'),
(454, 'Canada/Atlantic'),
(455, 'Canada/Central'),
(456, 'Canada/East-Saskatchewan'),
(457, 'Canada/Eastern'),
(458, 'Canada/Mountain'),
(459, 'Canada/Newfoundland'),
(460, 'Canada/Pacific'),
(461, 'Canada/Saskatchewan'),
(462, 'Canada/Yukon'),
(463, 'CET'),
(464, 'Chile/Continental'),
(465, 'Chile/EasterIsland'),
(466, 'CST6CDT'),
(467, 'Cuba'),
(468, 'EET'),
(469, 'Egypt'),
(470, 'Eire'),
(471, 'EST'),
(472, 'EST5EDT'),
(473, 'Etc/GMT'),
(474, 'Etc/GMT+0'),
(475, 'Etc/GMT+1'),
(476, 'Etc/GMT+10'),
(477, 'Etc/GMT+11'),
(478, 'Etc/GMT+12'),
(479, 'Etc/GMT+2'),
(480, 'Etc/GMT+3'),
(481, 'Etc/GMT+4'),
(482, 'Etc/GMT+5'),
(483, 'Etc/GMT+6'),
(484, 'Etc/GMT+7'),
(485, 'Etc/GMT+8'),
(486, 'Etc/GMT+9'),
(487, 'Etc/GMT-0'),
(488, 'Etc/GMT-1'),
(489, 'Etc/GMT-10'),
(490, 'Etc/GMT-11'),
(491, 'Etc/GMT-12'),
(492, 'Etc/GMT-13'),
(493, 'Etc/GMT-14'),
(494, 'Etc/GMT-2'),
(495, 'Etc/GMT-3'),
(496, 'Etc/GMT-4'),
(497, 'Etc/GMT-5'),
(498, 'Etc/GMT-6'),
(499, 'Etc/GMT-7'),
(500, 'Etc/GMT-8'),
(501, 'Etc/GMT-9'),
(502, 'Etc/GMT0'),
(503, 'Etc/Greenwich'),
(504, 'Etc/UCT'),
(505, 'Etc/Universal'),
(506, 'Etc/UTC'),
(507, 'Etc/Zulu'),
(508, 'Factory'),
(509, 'GB'),
(510, 'GB-Eire'),
(511, 'GMT'),
(512, 'GMT+0'),
(513, 'GMT-0'),
(514, 'GMT0'),
(515, 'Greenwich'),
(516, 'Hongkong'),
(517, 'HST'),
(518, 'Iceland'),
(519, 'Iran'),
(520, 'Israel'),
(521, 'Jamaica'),
(522, 'Japan'),
(523, 'Kwajalein'),
(524, 'Libya'),
(525, 'MET'),
(526, 'Mexico/BajaNorte'),
(527, 'Mexico/BajaSur'),
(528, 'Mexico/General'),
(529, 'MST'),
(530, 'MST7MDT'),
(531, 'Navajo'),
(532, 'NZ'),
(533, 'NZ-CHAT'),
(534, 'Poland'),
(535, 'Portugal'),
(536, 'PRC'),
(537, 'PST8PDT'),
(538, 'ROC'),
(539, 'ROK'),
(540, 'Singapore'),
(541, 'Turkey'),
(542, 'UCT'),
(543, 'Universal'),
(544, 'US/Alaska'),
(545, 'US/Aleutian'),
(546, 'US/Arizona'),
(547, 'US/Central'),
(548, 'US/East-Indiana'),
(549, 'US/Eastern'),
(550, 'US/Hawaii'),
(551, 'US/Indiana-Starke'),
(552, 'US/Michigan'),
(553, 'US/Mountain'),
(554, 'US/Pacific'),
(555, 'US/Pacific-New'),
(556, 'US/Samoa'),
(557, 'UTC'),
(558, 'W-SU'),
(559, 'WET'),
(560, 'Zulu');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_translation`
--

CREATE TABLE `ps_translation` (
  `id_translation` int(11) NOT NULL,
  `id_lang` int(11) NOT NULL,
  `key` text COLLATE utf8_unicode_ci NOT NULL,
  `translation` text COLLATE utf8_unicode_ci NOT NULL,
  `domain` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `theme` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_warehouse`
--

CREATE TABLE `ps_warehouse` (
  `id_warehouse` int(11) UNSIGNED NOT NULL,
  `id_currency` int(11) UNSIGNED NOT NULL,
  `id_address` int(11) UNSIGNED NOT NULL,
  `id_employee` int(11) UNSIGNED NOT NULL,
  `reference` varchar(64) DEFAULT NULL,
  `name` varchar(45) NOT NULL,
  `management_type` enum('WA','FIFO','LIFO') NOT NULL DEFAULT 'WA',
  `deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_warehouse_carrier`
--

CREATE TABLE `ps_warehouse_carrier` (
  `id_carrier` int(11) UNSIGNED NOT NULL,
  `id_warehouse` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_warehouse_product_location`
--

CREATE TABLE `ps_warehouse_product_location` (
  `id_warehouse_product_location` int(11) UNSIGNED NOT NULL,
  `id_product` int(11) UNSIGNED NOT NULL,
  `id_product_attribute` int(11) UNSIGNED NOT NULL,
  `id_warehouse` int(11) UNSIGNED NOT NULL,
  `location` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_warehouse_shop`
--

CREATE TABLE `ps_warehouse_shop` (
  `id_shop` int(11) UNSIGNED NOT NULL,
  `id_warehouse` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_webservice_account`
--

CREATE TABLE `ps_webservice_account` (
  `id_webservice_account` int(11) NOT NULL,
  `key` varchar(32) NOT NULL,
  `description` text,
  `class_name` varchar(50) NOT NULL DEFAULT 'WebserviceRequest',
  `is_module` tinyint(2) NOT NULL DEFAULT '0',
  `module_name` varchar(50) DEFAULT NULL,
  `active` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_webservice_account_shop`
--

CREATE TABLE `ps_webservice_account_shop` (
  `id_webservice_account` int(11) UNSIGNED NOT NULL,
  `id_shop` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_webservice_permission`
--

CREATE TABLE `ps_webservice_permission` (
  `id_webservice_permission` int(11) NOT NULL,
  `resource` varchar(50) NOT NULL,
  `method` enum('GET','POST','PUT','DELETE','HEAD') NOT NULL,
  `id_webservice_account` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_web_browser`
--

CREATE TABLE `ps_web_browser` (
  `id_web_browser` int(10) UNSIGNED NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_web_browser`
--

INSERT INTO `ps_web_browser` (`id_web_browser`, `name`) VALUES
(1, 'Safari'),
(2, 'Safari iPad'),
(3, 'Firefox'),
(4, 'Opera'),
(5, 'IE 6'),
(6, 'IE 7'),
(7, 'IE 8'),
(8, 'IE 9'),
(9, 'IE 10'),
(10, 'IE 11'),
(11, 'Chrome');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_zone`
--

CREATE TABLE `ps_zone` (
  `id_zone` int(10) UNSIGNED NOT NULL,
  `name` varchar(64) NOT NULL,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_zone`
--

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES
(1, 'Europe', 1),
(2, 'North America', 1),
(3, 'Asia', 1),
(4, 'Africa', 1),
(5, 'Oceania', 1),
(6, 'South America', 1),
(7, 'Europe (non-EU)', 1),
(8, 'Central America/Antilla', 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `ps_zone_shop`
--

CREATE TABLE `ps_zone_shop` (
  `id_zone` int(11) UNSIGNED NOT NULL,
  `id_shop` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `ps_zone_shop`
--

INSERT INTO `ps_zone_shop` (`id_zone`, `id_shop`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1);

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `ps_access`
--
ALTER TABLE `ps_access`
  ADD PRIMARY KEY (`id_profile`,`id_authorization_role`);

--
-- Índices para tabela `ps_accessory`
--
ALTER TABLE `ps_accessory`
  ADD KEY `accessory_product` (`id_product_1`,`id_product_2`);

--
-- Índices para tabela `ps_address`
--
ALTER TABLE `ps_address`
  ADD PRIMARY KEY (`id_address`),
  ADD KEY `address_customer` (`id_customer`),
  ADD KEY `id_country` (`id_country`),
  ADD KEY `id_state` (`id_state`),
  ADD KEY `id_manufacturer` (`id_manufacturer`),
  ADD KEY `id_supplier` (`id_supplier`),
  ADD KEY `id_warehouse` (`id_warehouse`);

--
-- Índices para tabela `ps_address_format`
--
ALTER TABLE `ps_address_format`
  ADD PRIMARY KEY (`id_country`);

--
-- Índices para tabela `ps_admin_filter`
--
ALTER TABLE `ps_admin_filter`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_filter_search_id_idx` (`employee`,`shop`,`controller`,`action`,`filter_id`);

--
-- Índices para tabela `ps_advice`
--
ALTER TABLE `ps_advice`
  ADD PRIMARY KEY (`id_advice`);

--
-- Índices para tabela `ps_advice_lang`
--
ALTER TABLE `ps_advice_lang`
  ADD PRIMARY KEY (`id_advice`,`id_lang`);

--
-- Índices para tabela `ps_alias`
--
ALTER TABLE `ps_alias`
  ADD PRIMARY KEY (`id_alias`),
  ADD UNIQUE KEY `alias` (`alias`);

--
-- Índices para tabela `ps_attachment`
--
ALTER TABLE `ps_attachment`
  ADD PRIMARY KEY (`id_attachment`);

--
-- Índices para tabela `ps_attachment_lang`
--
ALTER TABLE `ps_attachment_lang`
  ADD PRIMARY KEY (`id_attachment`,`id_lang`);

--
-- Índices para tabela `ps_attribute`
--
ALTER TABLE `ps_attribute`
  ADD PRIMARY KEY (`id_attribute`),
  ADD KEY `attribute_group` (`id_attribute_group`);

--
-- Índices para tabela `ps_attribute_group`
--
ALTER TABLE `ps_attribute_group`
  ADD PRIMARY KEY (`id_attribute_group`);

--
-- Índices para tabela `ps_attribute_group_lang`
--
ALTER TABLE `ps_attribute_group_lang`
  ADD PRIMARY KEY (`id_attribute_group`,`id_lang`),
  ADD KEY `IDX_4653726C67A664FB` (`id_attribute_group`),
  ADD KEY `IDX_4653726CBA299860` (`id_lang`);

--
-- Índices para tabela `ps_attribute_group_shop`
--
ALTER TABLE `ps_attribute_group_shop`
  ADD PRIMARY KEY (`id_attribute_group`,`id_shop`),
  ADD KEY `IDX_DB30BAAC67A664FB` (`id_attribute_group`),
  ADD KEY `IDX_DB30BAAC274A50A0` (`id_shop`);

--
-- Índices para tabela `ps_attribute_impact`
--
ALTER TABLE `ps_attribute_impact`
  ADD PRIMARY KEY (`id_attribute_impact`),
  ADD UNIQUE KEY `id_product` (`id_product`,`id_attribute`);

--
-- Índices para tabela `ps_attribute_lang`
--
ALTER TABLE `ps_attribute_lang`
  ADD PRIMARY KEY (`id_attribute`,`id_lang`),
  ADD KEY `IDX_3ABE46A77A4F53DC` (`id_attribute`),
  ADD KEY `IDX_3ABE46A7BA299860` (`id_lang`);

--
-- Índices para tabela `ps_attribute_shop`
--
ALTER TABLE `ps_attribute_shop`
  ADD PRIMARY KEY (`id_attribute`,`id_shop`),
  ADD KEY `IDX_A7DD8E677A4F53DC` (`id_attribute`),
  ADD KEY `IDX_A7DD8E67274A50A0` (`id_shop`);

--
-- Índices para tabela `ps_authorization_role`
--
ALTER TABLE `ps_authorization_role`
  ADD PRIMARY KEY (`id_authorization_role`),
  ADD UNIQUE KEY `slug` (`slug`);

--
-- Índices para tabela `ps_badge`
--
ALTER TABLE `ps_badge`
  ADD PRIMARY KEY (`id_badge`);

--
-- Índices para tabela `ps_badge_lang`
--
ALTER TABLE `ps_badge_lang`
  ADD PRIMARY KEY (`id_badge`,`id_lang`);

--
-- Índices para tabela `ps_carrier`
--
ALTER TABLE `ps_carrier`
  ADD PRIMARY KEY (`id_carrier`),
  ADD KEY `deleted` (`deleted`,`active`),
  ADD KEY `id_tax_rules_group` (`id_tax_rules_group`),
  ADD KEY `reference` (`id_reference`,`deleted`,`active`);

--
-- Índices para tabela `ps_carrier_group`
--
ALTER TABLE `ps_carrier_group`
  ADD PRIMARY KEY (`id_carrier`,`id_group`);

--
-- Índices para tabela `ps_carrier_lang`
--
ALTER TABLE `ps_carrier_lang`
  ADD PRIMARY KEY (`id_lang`,`id_shop`,`id_carrier`);

--
-- Índices para tabela `ps_carrier_shop`
--
ALTER TABLE `ps_carrier_shop`
  ADD PRIMARY KEY (`id_carrier`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_carrier_tax_rules_group_shop`
--
ALTER TABLE `ps_carrier_tax_rules_group_shop`
  ADD PRIMARY KEY (`id_carrier`,`id_tax_rules_group`,`id_shop`);

--
-- Índices para tabela `ps_carrier_zone`
--
ALTER TABLE `ps_carrier_zone`
  ADD PRIMARY KEY (`id_carrier`,`id_zone`);

--
-- Índices para tabela `ps_cart`
--
ALTER TABLE `ps_cart`
  ADD PRIMARY KEY (`id_cart`),
  ADD KEY `cart_customer` (`id_customer`),
  ADD KEY `id_address_delivery` (`id_address_delivery`),
  ADD KEY `id_address_invoice` (`id_address_invoice`),
  ADD KEY `id_carrier` (`id_carrier`),
  ADD KEY `id_lang` (`id_lang`),
  ADD KEY `id_currency` (`id_currency`),
  ADD KEY `id_guest` (`id_guest`),
  ADD KEY `id_shop_group` (`id_shop_group`),
  ADD KEY `id_shop_2` (`id_shop`,`date_upd`),
  ADD KEY `id_shop` (`id_shop`,`date_add`);

--
-- Índices para tabela `ps_cart_cart_rule`
--
ALTER TABLE `ps_cart_cart_rule`
  ADD PRIMARY KEY (`id_cart`,`id_cart_rule`),
  ADD KEY `id_cart_rule` (`id_cart_rule`);

--
-- Índices para tabela `ps_cart_product`
--
ALTER TABLE `ps_cart_product`
  ADD PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_customization`,`id_address_delivery`),
  ADD KEY `id_product_attribute` (`id_product_attribute`),
  ADD KEY `id_cart_order` (`id_cart`,`date_add`,`id_product`,`id_product_attribute`);

--
-- Índices para tabela `ps_cart_rule`
--
ALTER TABLE `ps_cart_rule`
  ADD PRIMARY KEY (`id_cart_rule`),
  ADD KEY `id_customer` (`id_customer`,`active`,`date_to`),
  ADD KEY `group_restriction` (`group_restriction`,`active`,`date_to`),
  ADD KEY `id_customer_2` (`id_customer`,`active`,`highlight`,`date_to`),
  ADD KEY `group_restriction_2` (`group_restriction`,`active`,`highlight`,`date_to`),
  ADD KEY `date_from` (`date_from`),
  ADD KEY `date_to` (`date_to`);

--
-- Índices para tabela `ps_cart_rule_carrier`
--
ALTER TABLE `ps_cart_rule_carrier`
  ADD PRIMARY KEY (`id_cart_rule`,`id_carrier`);

--
-- Índices para tabela `ps_cart_rule_combination`
--
ALTER TABLE `ps_cart_rule_combination`
  ADD PRIMARY KEY (`id_cart_rule_1`,`id_cart_rule_2`),
  ADD KEY `id_cart_rule_1` (`id_cart_rule_1`),
  ADD KEY `id_cart_rule_2` (`id_cart_rule_2`);

--
-- Índices para tabela `ps_cart_rule_country`
--
ALTER TABLE `ps_cart_rule_country`
  ADD PRIMARY KEY (`id_cart_rule`,`id_country`);

--
-- Índices para tabela `ps_cart_rule_group`
--
ALTER TABLE `ps_cart_rule_group`
  ADD PRIMARY KEY (`id_cart_rule`,`id_group`);

--
-- Índices para tabela `ps_cart_rule_lang`
--
ALTER TABLE `ps_cart_rule_lang`
  ADD PRIMARY KEY (`id_cart_rule`,`id_lang`);

--
-- Índices para tabela `ps_cart_rule_product_rule`
--
ALTER TABLE `ps_cart_rule_product_rule`
  ADD PRIMARY KEY (`id_product_rule`);

--
-- Índices para tabela `ps_cart_rule_product_rule_group`
--
ALTER TABLE `ps_cart_rule_product_rule_group`
  ADD PRIMARY KEY (`id_product_rule_group`);

--
-- Índices para tabela `ps_cart_rule_product_rule_value`
--
ALTER TABLE `ps_cart_rule_product_rule_value`
  ADD PRIMARY KEY (`id_product_rule`,`id_item`);

--
-- Índices para tabela `ps_cart_rule_shop`
--
ALTER TABLE `ps_cart_rule_shop`
  ADD PRIMARY KEY (`id_cart_rule`,`id_shop`);

--
-- Índices para tabela `ps_category`
--
ALTER TABLE `ps_category`
  ADD PRIMARY KEY (`id_category`),
  ADD KEY `category_parent` (`id_parent`),
  ADD KEY `nleftrightactive` (`nleft`,`nright`,`active`),
  ADD KEY `level_depth` (`level_depth`),
  ADD KEY `nright` (`nright`),
  ADD KEY `activenleft` (`active`,`nleft`),
  ADD KEY `activenright` (`active`,`nright`);

--
-- Índices para tabela `ps_category_group`
--
ALTER TABLE `ps_category_group`
  ADD PRIMARY KEY (`id_category`,`id_group`),
  ADD KEY `id_category` (`id_category`),
  ADD KEY `id_group` (`id_group`);

--
-- Índices para tabela `ps_category_lang`
--
ALTER TABLE `ps_category_lang`
  ADD PRIMARY KEY (`id_category`,`id_shop`,`id_lang`),
  ADD KEY `category_name` (`name`);

--
-- Índices para tabela `ps_category_product`
--
ALTER TABLE `ps_category_product`
  ADD PRIMARY KEY (`id_category`,`id_product`),
  ADD KEY `id_product` (`id_product`),
  ADD KEY `id_category` (`id_category`,`position`);

--
-- Índices para tabela `ps_category_shop`
--
ALTER TABLE `ps_category_shop`
  ADD PRIMARY KEY (`id_category`,`id_shop`);

--
-- Índices para tabela `ps_cms`
--
ALTER TABLE `ps_cms`
  ADD PRIMARY KEY (`id_cms`);

--
-- Índices para tabela `ps_cms_category`
--
ALTER TABLE `ps_cms_category`
  ADD PRIMARY KEY (`id_cms_category`),
  ADD KEY `category_parent` (`id_parent`);

--
-- Índices para tabela `ps_cms_category_lang`
--
ALTER TABLE `ps_cms_category_lang`
  ADD PRIMARY KEY (`id_cms_category`,`id_shop`,`id_lang`),
  ADD KEY `category_name` (`name`);

--
-- Índices para tabela `ps_cms_category_shop`
--
ALTER TABLE `ps_cms_category_shop`
  ADD PRIMARY KEY (`id_cms_category`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_cms_lang`
--
ALTER TABLE `ps_cms_lang`
  ADD PRIMARY KEY (`id_cms`,`id_shop`,`id_lang`);

--
-- Índices para tabela `ps_cms_role`
--
ALTER TABLE `ps_cms_role`
  ADD PRIMARY KEY (`id_cms_role`,`id_cms`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Índices para tabela `ps_cms_role_lang`
--
ALTER TABLE `ps_cms_role_lang`
  ADD PRIMARY KEY (`id_cms_role`,`id_lang`,`id_shop`);

--
-- Índices para tabela `ps_cms_shop`
--
ALTER TABLE `ps_cms_shop`
  ADD PRIMARY KEY (`id_cms`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_condition`
--
ALTER TABLE `ps_condition`
  ADD PRIMARY KEY (`id_condition`,`id_ps_condition`);

--
-- Índices para tabela `ps_condition_advice`
--
ALTER TABLE `ps_condition_advice`
  ADD PRIMARY KEY (`id_condition`,`id_advice`);

--
-- Índices para tabela `ps_condition_badge`
--
ALTER TABLE `ps_condition_badge`
  ADD PRIMARY KEY (`id_condition`,`id_badge`);

--
-- Índices para tabela `ps_configuration`
--
ALTER TABLE `ps_configuration`
  ADD PRIMARY KEY (`id_configuration`),
  ADD KEY `name` (`name`),
  ADD KEY `id_shop` (`id_shop`),
  ADD KEY `id_shop_group` (`id_shop_group`);

--
-- Índices para tabela `ps_configuration_kpi`
--
ALTER TABLE `ps_configuration_kpi`
  ADD PRIMARY KEY (`id_configuration_kpi`),
  ADD KEY `name` (`name`),
  ADD KEY `id_shop` (`id_shop`),
  ADD KEY `id_shop_group` (`id_shop_group`);

--
-- Índices para tabela `ps_configuration_kpi_lang`
--
ALTER TABLE `ps_configuration_kpi_lang`
  ADD PRIMARY KEY (`id_configuration_kpi`,`id_lang`);

--
-- Índices para tabela `ps_configuration_lang`
--
ALTER TABLE `ps_configuration_lang`
  ADD PRIMARY KEY (`id_configuration`,`id_lang`);

--
-- Índices para tabela `ps_connections`
--
ALTER TABLE `ps_connections`
  ADD PRIMARY KEY (`id_connections`),
  ADD KEY `id_guest` (`id_guest`),
  ADD KEY `date_add` (`date_add`),
  ADD KEY `id_page` (`id_page`);

--
-- Índices para tabela `ps_connections_page`
--
ALTER TABLE `ps_connections_page`
  ADD PRIMARY KEY (`id_connections`,`id_page`,`time_start`);

--
-- Índices para tabela `ps_connections_source`
--
ALTER TABLE `ps_connections_source`
  ADD PRIMARY KEY (`id_connections_source`),
  ADD KEY `connections` (`id_connections`),
  ADD KEY `orderby` (`date_add`),
  ADD KEY `http_referer` (`http_referer`),
  ADD KEY `request_uri` (`request_uri`);

--
-- Índices para tabela `ps_contact`
--
ALTER TABLE `ps_contact`
  ADD PRIMARY KEY (`id_contact`);

--
-- Índices para tabela `ps_contact_lang`
--
ALTER TABLE `ps_contact_lang`
  ADD PRIMARY KEY (`id_contact`,`id_lang`);

--
-- Índices para tabela `ps_contact_shop`
--
ALTER TABLE `ps_contact_shop`
  ADD PRIMARY KEY (`id_contact`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_contentbox`
--
ALTER TABLE `ps_contentbox`
  ADD PRIMARY KEY (`content_id`),
  ADD UNIQUE KEY `id_lang_id_store` (`id_lang`,`id_store`);

--
-- Índices para tabela `ps_contentbox_files`
--
ALTER TABLE `ps_contentbox_files`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_lang_id_store` (`id_lang`,`id_store`);

--
-- Índices para tabela `ps_country`
--
ALTER TABLE `ps_country`
  ADD PRIMARY KEY (`id_country`),
  ADD KEY `country_iso_code` (`iso_code`),
  ADD KEY `country_` (`id_zone`);

--
-- Índices para tabela `ps_country_lang`
--
ALTER TABLE `ps_country_lang`
  ADD PRIMARY KEY (`id_country`,`id_lang`);

--
-- Índices para tabela `ps_country_shop`
--
ALTER TABLE `ps_country_shop`
  ADD PRIMARY KEY (`id_country`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_currency`
--
ALTER TABLE `ps_currency`
  ADD PRIMARY KEY (`id_currency`),
  ADD KEY `currency_iso_code` (`iso_code`);

--
-- Índices para tabela `ps_currency_lang`
--
ALTER TABLE `ps_currency_lang`
  ADD PRIMARY KEY (`id_currency`,`id_lang`);

--
-- Índices para tabela `ps_currency_shop`
--
ALTER TABLE `ps_currency_shop`
  ADD PRIMARY KEY (`id_currency`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_customer`
--
ALTER TABLE `ps_customer`
  ADD PRIMARY KEY (`id_customer`),
  ADD KEY `customer_email` (`email`),
  ADD KEY `customer_login` (`email`,`passwd`),
  ADD KEY `id_customer_passwd` (`id_customer`,`passwd`),
  ADD KEY `id_gender` (`id_gender`),
  ADD KEY `id_shop_group` (`id_shop_group`),
  ADD KEY `id_shop` (`id_shop`,`date_add`);

--
-- Índices para tabela `ps_customer_group`
--
ALTER TABLE `ps_customer_group`
  ADD PRIMARY KEY (`id_customer`,`id_group`),
  ADD KEY `customer_login` (`id_group`),
  ADD KEY `id_customer` (`id_customer`);

--
-- Índices para tabela `ps_customer_message`
--
ALTER TABLE `ps_customer_message`
  ADD PRIMARY KEY (`id_customer_message`),
  ADD KEY `id_customer_thread` (`id_customer_thread`),
  ADD KEY `id_employee` (`id_employee`);

--
-- Índices para tabela `ps_customer_message_sync_imap`
--
ALTER TABLE `ps_customer_message_sync_imap`
  ADD KEY `md5_header_index` (`md5_header`(4));

--
-- Índices para tabela `ps_customer_session`
--
ALTER TABLE `ps_customer_session`
  ADD PRIMARY KEY (`id_customer_session`);

--
-- Índices para tabela `ps_customer_thread`
--
ALTER TABLE `ps_customer_thread`
  ADD PRIMARY KEY (`id_customer_thread`),
  ADD KEY `id_shop` (`id_shop`),
  ADD KEY `id_lang` (`id_lang`),
  ADD KEY `id_contact` (`id_contact`),
  ADD KEY `id_customer` (`id_customer`),
  ADD KEY `id_order` (`id_order`),
  ADD KEY `id_product` (`id_product`);

--
-- Índices para tabela `ps_customization`
--
ALTER TABLE `ps_customization`
  ADD PRIMARY KEY (`id_customization`,`id_cart`,`id_product`,`id_address_delivery`),
  ADD KEY `id_product_attribute` (`id_product_attribute`),
  ADD KEY `id_cart_product` (`id_cart`,`id_product`,`id_product_attribute`);

--
-- Índices para tabela `ps_customization_field`
--
ALTER TABLE `ps_customization_field`
  ADD PRIMARY KEY (`id_customization_field`),
  ADD KEY `id_product` (`id_product`);

--
-- Índices para tabela `ps_customization_field_lang`
--
ALTER TABLE `ps_customization_field_lang`
  ADD PRIMARY KEY (`id_customization_field`,`id_lang`,`id_shop`);

--
-- Índices para tabela `ps_customized_data`
--
ALTER TABLE `ps_customized_data`
  ADD PRIMARY KEY (`id_customization`,`type`,`index`);

--
-- Índices para tabela `ps_date_range`
--
ALTER TABLE `ps_date_range`
  ADD PRIMARY KEY (`id_date_range`);

--
-- Índices para tabela `ps_delivery`
--
ALTER TABLE `ps_delivery`
  ADD PRIMARY KEY (`id_delivery`),
  ADD KEY `id_zone` (`id_zone`),
  ADD KEY `id_carrier` (`id_carrier`,`id_zone`),
  ADD KEY `id_range_price` (`id_range_price`),
  ADD KEY `id_range_weight` (`id_range_weight`);

--
-- Índices para tabela `ps_emailsubscription`
--
ALTER TABLE `ps_emailsubscription`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `ps_employee`
--
ALTER TABLE `ps_employee`
  ADD PRIMARY KEY (`id_employee`),
  ADD KEY `employee_login` (`email`,`passwd`),
  ADD KEY `id_employee_passwd` (`id_employee`,`passwd`),
  ADD KEY `id_profile` (`id_profile`);

--
-- Índices para tabela `ps_employee_session`
--
ALTER TABLE `ps_employee_session`
  ADD PRIMARY KEY (`id_employee_session`);

--
-- Índices para tabela `ps_employee_shop`
--
ALTER TABLE `ps_employee_shop`
  ADD PRIMARY KEY (`id_employee`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_feature`
--
ALTER TABLE `ps_feature`
  ADD PRIMARY KEY (`id_feature`);

--
-- Índices para tabela `ps_feature_lang`
--
ALTER TABLE `ps_feature_lang`
  ADD PRIMARY KEY (`id_feature`,`id_lang`),
  ADD KEY `id_lang` (`id_lang`,`name`);

--
-- Índices para tabela `ps_feature_product`
--
ALTER TABLE `ps_feature_product`
  ADD PRIMARY KEY (`id_feature`,`id_product`,`id_feature_value`),
  ADD KEY `id_feature_value` (`id_feature_value`),
  ADD KEY `id_product` (`id_product`);

--
-- Índices para tabela `ps_feature_shop`
--
ALTER TABLE `ps_feature_shop`
  ADD PRIMARY KEY (`id_feature`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_feature_value`
--
ALTER TABLE `ps_feature_value`
  ADD PRIMARY KEY (`id_feature_value`),
  ADD KEY `feature` (`id_feature`);

--
-- Índices para tabela `ps_feature_value_lang`
--
ALTER TABLE `ps_feature_value_lang`
  ADD PRIMARY KEY (`id_feature_value`,`id_lang`);

--
-- Índices para tabela `ps_gender`
--
ALTER TABLE `ps_gender`
  ADD PRIMARY KEY (`id_gender`);

--
-- Índices para tabela `ps_gender_lang`
--
ALTER TABLE `ps_gender_lang`
  ADD PRIMARY KEY (`id_gender`,`id_lang`),
  ADD KEY `id_gender` (`id_gender`);

--
-- Índices para tabela `ps_group`
--
ALTER TABLE `ps_group`
  ADD PRIMARY KEY (`id_group`);

--
-- Índices para tabela `ps_group_lang`
--
ALTER TABLE `ps_group_lang`
  ADD PRIMARY KEY (`id_group`,`id_lang`);

--
-- Índices para tabela `ps_group_reduction`
--
ALTER TABLE `ps_group_reduction`
  ADD PRIMARY KEY (`id_group_reduction`),
  ADD UNIQUE KEY `id_group` (`id_group`,`id_category`);

--
-- Índices para tabela `ps_group_shop`
--
ALTER TABLE `ps_group_shop`
  ADD PRIMARY KEY (`id_group`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_guest`
--
ALTER TABLE `ps_guest`
  ADD PRIMARY KEY (`id_guest`),
  ADD KEY `id_customer` (`id_customer`),
  ADD KEY `id_operating_system` (`id_operating_system`),
  ADD KEY `id_web_browser` (`id_web_browser`);

--
-- Índices para tabela `ps_homeslider`
--
ALTER TABLE `ps_homeslider`
  ADD PRIMARY KEY (`id_homeslider_slides`,`id_shop`);

--
-- Índices para tabela `ps_homeslider_slides`
--
ALTER TABLE `ps_homeslider_slides`
  ADD PRIMARY KEY (`id_homeslider_slides`);

--
-- Índices para tabela `ps_homeslider_slides_lang`
--
ALTER TABLE `ps_homeslider_slides_lang`
  ADD PRIMARY KEY (`id_homeslider_slides`,`id_lang`);

--
-- Índices para tabela `ps_hook`
--
ALTER TABLE `ps_hook`
  ADD PRIMARY KEY (`id_hook`),
  ADD UNIQUE KEY `hook_name` (`name`);

--
-- Índices para tabela `ps_hook_alias`
--
ALTER TABLE `ps_hook_alias`
  ADD PRIMARY KEY (`id_hook_alias`),
  ADD UNIQUE KEY `alias` (`alias`);

--
-- Índices para tabela `ps_hook_module`
--
ALTER TABLE `ps_hook_module`
  ADD PRIMARY KEY (`id_module`,`id_hook`,`id_shop`),
  ADD KEY `id_hook` (`id_hook`),
  ADD KEY `id_module` (`id_module`),
  ADD KEY `position` (`id_shop`,`position`);

--
-- Índices para tabela `ps_hook_module_exceptions`
--
ALTER TABLE `ps_hook_module_exceptions`
  ADD PRIMARY KEY (`id_hook_module_exceptions`),
  ADD KEY `id_module` (`id_module`),
  ADD KEY `id_hook` (`id_hook`);

--
-- Índices para tabela `ps_iconepesquisa`
--
ALTER TABLE `ps_iconepesquisa`
  ADD PRIMARY KEY (`content_id`),
  ADD UNIQUE KEY `id_lang_id_store` (`id_lang`,`id_store`);

--
-- Índices para tabela `ps_iconepesquisa_files`
--
ALTER TABLE `ps_iconepesquisa_files`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_lang_id_store` (`id_lang`,`id_store`);

--
-- Índices para tabela `ps_image`
--
ALTER TABLE `ps_image`
  ADD PRIMARY KEY (`id_image`),
  ADD UNIQUE KEY `id_product_cover` (`id_product`,`cover`),
  ADD UNIQUE KEY `idx_product_image` (`id_image`,`id_product`,`cover`),
  ADD KEY `image_product` (`id_product`);

--
-- Índices para tabela `ps_image_lang`
--
ALTER TABLE `ps_image_lang`
  ADD PRIMARY KEY (`id_image`,`id_lang`),
  ADD KEY `id_image` (`id_image`);

--
-- Índices para tabela `ps_image_shop`
--
ALTER TABLE `ps_image_shop`
  ADD PRIMARY KEY (`id_image`,`id_shop`),
  ADD UNIQUE KEY `id_product` (`id_product`,`id_shop`,`cover`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_image_type`
--
ALTER TABLE `ps_image_type`
  ADD PRIMARY KEY (`id_image_type`),
  ADD KEY `image_type_name` (`name`);

--
-- Índices para tabela `ps_import_match`
--
ALTER TABLE `ps_import_match`
  ADD PRIMARY KEY (`id_import_match`);

--
-- Índices para tabela `ps_info`
--
ALTER TABLE `ps_info`
  ADD PRIMARY KEY (`id_info`);

--
-- Índices para tabela `ps_info_lang`
--
ALTER TABLE `ps_info_lang`
  ADD PRIMARY KEY (`id_info`,`id_lang`,`id_shop`);

--
-- Índices para tabela `ps_info_shop`
--
ALTER TABLE `ps_info_shop`
  ADD PRIMARY KEY (`id_info`,`id_shop`);

--
-- Índices para tabela `ps_lang`
--
ALTER TABLE `ps_lang`
  ADD PRIMARY KEY (`id_lang`);

--
-- Índices para tabela `ps_lang_shop`
--
ALTER TABLE `ps_lang_shop`
  ADD PRIMARY KEY (`id_lang`,`id_shop`),
  ADD KEY `IDX_2F43BFC7BA299860` (`id_lang`),
  ADD KEY `IDX_2F43BFC7274A50A0` (`id_shop`);

--
-- Índices para tabela `ps_layered_category`
--
ALTER TABLE `ps_layered_category`
  ADD PRIMARY KEY (`id_layered_category`),
  ADD KEY `id_category_shop` (`id_category`,`id_shop`,`type`,`id_value`,`position`),
  ADD KEY `id_category` (`id_category`,`type`);

--
-- Índices para tabela `ps_layered_filter`
--
ALTER TABLE `ps_layered_filter`
  ADD PRIMARY KEY (`id_layered_filter`);

--
-- Índices para tabela `ps_layered_filter_block`
--
ALTER TABLE `ps_layered_filter_block`
  ADD PRIMARY KEY (`hash`);

--
-- Índices para tabela `ps_layered_filter_shop`
--
ALTER TABLE `ps_layered_filter_shop`
  ADD PRIMARY KEY (`id_layered_filter`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_layered_indexable_attribute_group`
--
ALTER TABLE `ps_layered_indexable_attribute_group`
  ADD PRIMARY KEY (`id_attribute_group`);

--
-- Índices para tabela `ps_layered_indexable_attribute_group_lang_value`
--
ALTER TABLE `ps_layered_indexable_attribute_group_lang_value`
  ADD PRIMARY KEY (`id_attribute_group`,`id_lang`);

--
-- Índices para tabela `ps_layered_indexable_attribute_lang_value`
--
ALTER TABLE `ps_layered_indexable_attribute_lang_value`
  ADD PRIMARY KEY (`id_attribute`,`id_lang`);

--
-- Índices para tabela `ps_layered_indexable_feature`
--
ALTER TABLE `ps_layered_indexable_feature`
  ADD PRIMARY KEY (`id_feature`);

--
-- Índices para tabela `ps_layered_indexable_feature_lang_value`
--
ALTER TABLE `ps_layered_indexable_feature_lang_value`
  ADD PRIMARY KEY (`id_feature`,`id_lang`);

--
-- Índices para tabela `ps_layered_indexable_feature_value_lang_value`
--
ALTER TABLE `ps_layered_indexable_feature_value_lang_value`
  ADD PRIMARY KEY (`id_feature_value`,`id_lang`);

--
-- Índices para tabela `ps_layered_price_index`
--
ALTER TABLE `ps_layered_price_index`
  ADD PRIMARY KEY (`id_product`,`id_currency`,`id_shop`,`id_country`),
  ADD KEY `id_currency` (`id_currency`),
  ADD KEY `price_min` (`price_min`),
  ADD KEY `price_max` (`price_max`);

--
-- Índices para tabela `ps_layered_product_attribute`
--
ALTER TABLE `ps_layered_product_attribute`
  ADD PRIMARY KEY (`id_attribute`,`id_product`,`id_shop`),
  ADD UNIQUE KEY `id_attribute_group` (`id_attribute_group`,`id_attribute`,`id_product`,`id_shop`);

--
-- Índices para tabela `ps_linksmenutop`
--
ALTER TABLE `ps_linksmenutop`
  ADD PRIMARY KEY (`id_linksmenutop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_linksmenutop_lang`
--
ALTER TABLE `ps_linksmenutop_lang`
  ADD KEY `id_linksmenutop` (`id_linksmenutop`,`id_lang`,`id_shop`);

--
-- Índices para tabela `ps_link_block`
--
ALTER TABLE `ps_link_block`
  ADD PRIMARY KEY (`id_link_block`);

--
-- Índices para tabela `ps_link_block_lang`
--
ALTER TABLE `ps_link_block_lang`
  ADD PRIMARY KEY (`id_link_block`,`id_lang`);

--
-- Índices para tabela `ps_link_block_shop`
--
ALTER TABLE `ps_link_block_shop`
  ADD PRIMARY KEY (`id_link_block`,`id_shop`);

--
-- Índices para tabela `ps_log`
--
ALTER TABLE `ps_log`
  ADD PRIMARY KEY (`id_log`);

--
-- Índices para tabela `ps_mail`
--
ALTER TABLE `ps_mail`
  ADD PRIMARY KEY (`id_mail`),
  ADD KEY `recipient` (`recipient`(10));

--
-- Índices para tabela `ps_mailalert_customer_oos`
--
ALTER TABLE `ps_mailalert_customer_oos`
  ADD PRIMARY KEY (`id_customer`,`customer_email`,`id_product`,`id_product_attribute`,`id_shop`);

--
-- Índices para tabela `ps_manufacturer`
--
ALTER TABLE `ps_manufacturer`
  ADD PRIMARY KEY (`id_manufacturer`);

--
-- Índices para tabela `ps_manufacturer_lang`
--
ALTER TABLE `ps_manufacturer_lang`
  ADD PRIMARY KEY (`id_manufacturer`,`id_lang`);

--
-- Índices para tabela `ps_manufacturer_shop`
--
ALTER TABLE `ps_manufacturer_shop`
  ADD PRIMARY KEY (`id_manufacturer`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_memcached_servers`
--
ALTER TABLE `ps_memcached_servers`
  ADD PRIMARY KEY (`id_memcached_server`);

--
-- Índices para tabela `ps_menuicones`
--
ALTER TABLE `ps_menuicones`
  ADD PRIMARY KEY (`content_id`),
  ADD UNIQUE KEY `id_lang_id_store` (`id_lang`,`id_store`);

--
-- Índices para tabela `ps_menuicones_files`
--
ALTER TABLE `ps_menuicones_files`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_lang_id_store` (`id_lang`,`id_store`);

--
-- Índices para tabela `ps_message`
--
ALTER TABLE `ps_message`
  ADD PRIMARY KEY (`id_message`),
  ADD KEY `message_order` (`id_order`),
  ADD KEY `id_cart` (`id_cart`),
  ADD KEY `id_customer` (`id_customer`),
  ADD KEY `id_employee` (`id_employee`);

--
-- Índices para tabela `ps_message_readed`
--
ALTER TABLE `ps_message_readed`
  ADD PRIMARY KEY (`id_message`,`id_employee`);

--
-- Índices para tabela `ps_meta`
--
ALTER TABLE `ps_meta`
  ADD PRIMARY KEY (`id_meta`),
  ADD UNIQUE KEY `page` (`page`);

--
-- Índices para tabela `ps_meta_lang`
--
ALTER TABLE `ps_meta_lang`
  ADD PRIMARY KEY (`id_meta`,`id_shop`,`id_lang`),
  ADD KEY `id_shop` (`id_shop`),
  ADD KEY `id_lang` (`id_lang`);

--
-- Índices para tabela `ps_module`
--
ALTER TABLE `ps_module`
  ADD PRIMARY KEY (`id_module`),
  ADD UNIQUE KEY `name_UNIQUE` (`name`),
  ADD KEY `name` (`name`);

--
-- Índices para tabela `ps_module_access`
--
ALTER TABLE `ps_module_access`
  ADD PRIMARY KEY (`id_profile`,`id_authorization_role`);

--
-- Índices para tabela `ps_module_carrier`
--
ALTER TABLE `ps_module_carrier`
  ADD PRIMARY KEY (`id_module`,`id_shop`,`id_reference`);

--
-- Índices para tabela `ps_module_country`
--
ALTER TABLE `ps_module_country`
  ADD PRIMARY KEY (`id_module`,`id_shop`,`id_country`);

--
-- Índices para tabela `ps_module_currency`
--
ALTER TABLE `ps_module_currency`
  ADD PRIMARY KEY (`id_module`,`id_shop`,`id_currency`),
  ADD KEY `id_module` (`id_module`);

--
-- Índices para tabela `ps_module_group`
--
ALTER TABLE `ps_module_group`
  ADD PRIMARY KEY (`id_module`,`id_shop`,`id_group`);

--
-- Índices para tabela `ps_module_history`
--
ALTER TABLE `ps_module_history`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `ps_module_preference`
--
ALTER TABLE `ps_module_preference`
  ADD PRIMARY KEY (`id_module_preference`),
  ADD UNIQUE KEY `employee_module` (`id_employee`,`module`);

--
-- Índices para tabela `ps_module_shop`
--
ALTER TABLE `ps_module_shop`
  ADD PRIMARY KEY (`id_module`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_operating_system`
--
ALTER TABLE `ps_operating_system`
  ADD PRIMARY KEY (`id_operating_system`);

--
-- Índices para tabela `ps_orders`
--
ALTER TABLE `ps_orders`
  ADD PRIMARY KEY (`id_order`),
  ADD KEY `reference` (`reference`),
  ADD KEY `id_customer` (`id_customer`),
  ADD KEY `id_cart` (`id_cart`),
  ADD KEY `invoice_number` (`invoice_number`),
  ADD KEY `id_carrier` (`id_carrier`),
  ADD KEY `id_lang` (`id_lang`),
  ADD KEY `id_currency` (`id_currency`),
  ADD KEY `id_address_delivery` (`id_address_delivery`),
  ADD KEY `id_address_invoice` (`id_address_invoice`),
  ADD KEY `id_shop_group` (`id_shop_group`),
  ADD KEY `current_state` (`current_state`),
  ADD KEY `id_shop` (`id_shop`),
  ADD KEY `date_add` (`date_add`);

--
-- Índices para tabela `ps_order_carrier`
--
ALTER TABLE `ps_order_carrier`
  ADD PRIMARY KEY (`id_order_carrier`),
  ADD KEY `id_order` (`id_order`),
  ADD KEY `id_carrier` (`id_carrier`),
  ADD KEY `id_order_invoice` (`id_order_invoice`);

--
-- Índices para tabela `ps_order_cart_rule`
--
ALTER TABLE `ps_order_cart_rule`
  ADD PRIMARY KEY (`id_order_cart_rule`),
  ADD KEY `id_order` (`id_order`),
  ADD KEY `id_cart_rule` (`id_cart_rule`);

--
-- Índices para tabela `ps_order_detail`
--
ALTER TABLE `ps_order_detail`
  ADD PRIMARY KEY (`id_order_detail`),
  ADD KEY `order_detail_order` (`id_order`),
  ADD KEY `product_id` (`product_id`,`product_attribute_id`),
  ADD KEY `product_attribute_id` (`product_attribute_id`),
  ADD KEY `id_tax_rules_group` (`id_tax_rules_group`),
  ADD KEY `id_order_id_order_detail` (`id_order`,`id_order_detail`);

--
-- Índices para tabela `ps_order_detail_tax`
--
ALTER TABLE `ps_order_detail_tax`
  ADD KEY `id_order_detail` (`id_order_detail`),
  ADD KEY `id_tax` (`id_tax`);

--
-- Índices para tabela `ps_order_history`
--
ALTER TABLE `ps_order_history`
  ADD PRIMARY KEY (`id_order_history`),
  ADD KEY `order_history_order` (`id_order`),
  ADD KEY `id_employee` (`id_employee`),
  ADD KEY `id_order_state` (`id_order_state`);

--
-- Índices para tabela `ps_order_invoice`
--
ALTER TABLE `ps_order_invoice`
  ADD PRIMARY KEY (`id_order_invoice`),
  ADD KEY `id_order` (`id_order`);

--
-- Índices para tabela `ps_order_invoice_payment`
--
ALTER TABLE `ps_order_invoice_payment`
  ADD PRIMARY KEY (`id_order_invoice`,`id_order_payment`),
  ADD KEY `order_payment` (`id_order_payment`),
  ADD KEY `id_order` (`id_order`);

--
-- Índices para tabela `ps_order_invoice_tax`
--
ALTER TABLE `ps_order_invoice_tax`
  ADD KEY `id_tax` (`id_tax`);

--
-- Índices para tabela `ps_order_message`
--
ALTER TABLE `ps_order_message`
  ADD PRIMARY KEY (`id_order_message`);

--
-- Índices para tabela `ps_order_message_lang`
--
ALTER TABLE `ps_order_message_lang`
  ADD PRIMARY KEY (`id_order_message`,`id_lang`);

--
-- Índices para tabela `ps_order_payment`
--
ALTER TABLE `ps_order_payment`
  ADD PRIMARY KEY (`id_order_payment`),
  ADD KEY `order_reference` (`order_reference`);

--
-- Índices para tabela `ps_order_return`
--
ALTER TABLE `ps_order_return`
  ADD PRIMARY KEY (`id_order_return`),
  ADD KEY `order_return_customer` (`id_customer`),
  ADD KEY `id_order` (`id_order`);

--
-- Índices para tabela `ps_order_return_detail`
--
ALTER TABLE `ps_order_return_detail`
  ADD PRIMARY KEY (`id_order_return`,`id_order_detail`,`id_customization`);

--
-- Índices para tabela `ps_order_return_state`
--
ALTER TABLE `ps_order_return_state`
  ADD PRIMARY KEY (`id_order_return_state`);

--
-- Índices para tabela `ps_order_return_state_lang`
--
ALTER TABLE `ps_order_return_state_lang`
  ADD PRIMARY KEY (`id_order_return_state`,`id_lang`);

--
-- Índices para tabela `ps_order_slip`
--
ALTER TABLE `ps_order_slip`
  ADD PRIMARY KEY (`id_order_slip`),
  ADD KEY `order_slip_customer` (`id_customer`),
  ADD KEY `id_order` (`id_order`);

--
-- Índices para tabela `ps_order_slip_detail`
--
ALTER TABLE `ps_order_slip_detail`
  ADD PRIMARY KEY (`id_order_slip`,`id_order_detail`);

--
-- Índices para tabela `ps_order_slip_detail_tax`
--
ALTER TABLE `ps_order_slip_detail_tax`
  ADD KEY `id_order_slip_detail` (`id_order_slip_detail`),
  ADD KEY `id_tax` (`id_tax`);

--
-- Índices para tabela `ps_order_state`
--
ALTER TABLE `ps_order_state`
  ADD PRIMARY KEY (`id_order_state`),
  ADD KEY `module_name` (`module_name`);

--
-- Índices para tabela `ps_order_state_lang`
--
ALTER TABLE `ps_order_state_lang`
  ADD PRIMARY KEY (`id_order_state`,`id_lang`);

--
-- Índices para tabela `ps_pack`
--
ALTER TABLE `ps_pack`
  ADD PRIMARY KEY (`id_product_pack`,`id_product_item`,`id_product_attribute_item`),
  ADD KEY `product_item` (`id_product_item`,`id_product_attribute_item`);

--
-- Índices para tabela `ps_page`
--
ALTER TABLE `ps_page`
  ADD PRIMARY KEY (`id_page`),
  ADD KEY `id_page_type` (`id_page_type`),
  ADD KEY `id_object` (`id_object`);

--
-- Índices para tabela `ps_pagenotfound`
--
ALTER TABLE `ps_pagenotfound`
  ADD PRIMARY KEY (`id_pagenotfound`),
  ADD KEY `date_add` (`date_add`);

--
-- Índices para tabela `ps_page_type`
--
ALTER TABLE `ps_page_type`
  ADD PRIMARY KEY (`id_page_type`),
  ADD KEY `name` (`name`);

--
-- Índices para tabela `ps_page_viewed`
--
ALTER TABLE `ps_page_viewed`
  ADD PRIMARY KEY (`id_page`,`id_date_range`,`id_shop`);

--
-- Índices para tabela `ps_payzen_token`
--
ALTER TABLE `ps_payzen_token`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_pz_token_id_customer` (`customer_id`);

--
-- Índices para tabela `ps_product`
--
ALTER TABLE `ps_product`
  ADD PRIMARY KEY (`id_product`),
  ADD KEY `product_supplier` (`id_supplier`),
  ADD KEY `product_manufacturer` (`id_manufacturer`,`id_product`),
  ADD KEY `id_category_default` (`id_category_default`),
  ADD KEY `indexed` (`indexed`),
  ADD KEY `date_add` (`date_add`),
  ADD KEY `state` (`state`,`date_upd`);

--
-- Índices para tabela `ps_producttabs_settings`
--
ALTER TABLE `ps_producttabs_settings`
  ADD PRIMARY KEY (`id_producttabs_settings`);

--
-- Índices para tabela `ps_producttabs_settings_shop`
--
ALTER TABLE `ps_producttabs_settings_shop`
  ADD KEY `product_tab_shop` (`id_producttabs_settings`,`id_shop`,`product_id`,`tab_type`);

--
-- Índices para tabela `ps_product_attachment`
--
ALTER TABLE `ps_product_attachment`
  ADD PRIMARY KEY (`id_product`,`id_attachment`);

--
-- Índices para tabela `ps_product_attribute`
--
ALTER TABLE `ps_product_attribute`
  ADD PRIMARY KEY (`id_product_attribute`),
  ADD UNIQUE KEY `product_default` (`id_product`,`default_on`),
  ADD KEY `product_attribute_product` (`id_product`),
  ADD KEY `reference` (`reference`),
  ADD KEY `supplier_reference` (`supplier_reference`),
  ADD KEY `id_product_id_product_attribute` (`id_product_attribute`,`id_product`);

--
-- Índices para tabela `ps_product_attribute_combination`
--
ALTER TABLE `ps_product_attribute_combination`
  ADD PRIMARY KEY (`id_attribute`,`id_product_attribute`),
  ADD KEY `id_product_attribute` (`id_product_attribute`);

--
-- Índices para tabela `ps_product_attribute_image`
--
ALTER TABLE `ps_product_attribute_image`
  ADD PRIMARY KEY (`id_product_attribute`,`id_image`),
  ADD KEY `id_image` (`id_image`);

--
-- Índices para tabela `ps_product_attribute_shop`
--
ALTER TABLE `ps_product_attribute_shop`
  ADD PRIMARY KEY (`id_product_attribute`,`id_shop`),
  ADD UNIQUE KEY `id_product` (`id_product`,`id_shop`,`default_on`);

--
-- Índices para tabela `ps_product_carrier`
--
ALTER TABLE `ps_product_carrier`
  ADD PRIMARY KEY (`id_product`,`id_carrier_reference`,`id_shop`);

--
-- Índices para tabela `ps_product_country_tax`
--
ALTER TABLE `ps_product_country_tax`
  ADD PRIMARY KEY (`id_product`,`id_country`);

--
-- Índices para tabela `ps_product_download`
--
ALTER TABLE `ps_product_download`
  ADD PRIMARY KEY (`id_product_download`);

--
-- Índices para tabela `ps_product_group_reduction_cache`
--
ALTER TABLE `ps_product_group_reduction_cache`
  ADD PRIMARY KEY (`id_product`,`id_group`);

--
-- Índices para tabela `ps_product_lang`
--
ALTER TABLE `ps_product_lang`
  ADD PRIMARY KEY (`id_product`,`id_shop`,`id_lang`),
  ADD KEY `id_lang` (`id_lang`),
  ADD KEY `name` (`name`);

--
-- Índices para tabela `ps_product_sale`
--
ALTER TABLE `ps_product_sale`
  ADD PRIMARY KEY (`id_product`),
  ADD KEY `quantity` (`quantity`);

--
-- Índices para tabela `ps_product_shop`
--
ALTER TABLE `ps_product_shop`
  ADD PRIMARY KEY (`id_product`,`id_shop`),
  ADD KEY `id_category_default` (`id_category_default`),
  ADD KEY `date_add` (`date_add`,`active`,`visibility`),
  ADD KEY `indexed` (`indexed`,`active`,`id_product`);

--
-- Índices para tabela `ps_product_supplier`
--
ALTER TABLE `ps_product_supplier`
  ADD PRIMARY KEY (`id_product_supplier`),
  ADD UNIQUE KEY `id_product` (`id_product`,`id_product_attribute`,`id_supplier`),
  ADD KEY `id_supplier` (`id_supplier`,`id_product`);

--
-- Índices para tabela `ps_product_tab`
--
ALTER TABLE `ps_product_tab`
  ADD PRIMARY KEY (`id_product_tab`);

--
-- Índices para tabela `ps_product_tab_global`
--
ALTER TABLE `ps_product_tab_global`
  ADD PRIMARY KEY (`id_product_tab_global`);

--
-- Índices para tabela `ps_product_tab_global_categories`
--
ALTER TABLE `ps_product_tab_global_categories`
  ADD KEY `product_tab_global_categories` (`id_product_tab_global`,`category_id`);

--
-- Índices para tabela `ps_product_tab_global_group`
--
ALTER TABLE `ps_product_tab_global_group`
  ADD KEY `product_tab_global_group` (`id_product_tab_global`,`id_group`);

--
-- Índices para tabela `ps_product_tab_global_lang`
--
ALTER TABLE `ps_product_tab_global_lang`
  ADD KEY `product_tab_global_lang` (`id_product_tab_global`,`id_lang`,`id_shop`);

--
-- Índices para tabela `ps_product_tab_global_manufacturers`
--
ALTER TABLE `ps_product_tab_global_manufacturers`
  ADD KEY `product_tab_global_manufacturers` (`id_product_tab_global`,`manufacturer_id`);

--
-- Índices para tabela `ps_product_tab_global_shop`
--
ALTER TABLE `ps_product_tab_global_shop`
  ADD UNIQUE KEY `product_tab_global_shop` (`id_product_tab_global`,`id_shop`);

--
-- Índices para tabela `ps_product_tab_global_suppliers`
--
ALTER TABLE `ps_product_tab_global_suppliers`
  ADD KEY `product_tab_global_suppliers` (`id_product_tab_global`,`supplier_id`);

--
-- Índices para tabela `ps_product_tab_group`
--
ALTER TABLE `ps_product_tab_group`
  ADD KEY `product_tab_shop` (`id_product_tab`,`id_group`);

--
-- Índices para tabela `ps_product_tab_lang`
--
ALTER TABLE `ps_product_tab_lang`
  ADD KEY `product_tab_lang` (`id_product_tab`,`id_lang`,`id_shop`);

--
-- Índices para tabela `ps_product_tab_shop`
--
ALTER TABLE `ps_product_tab_shop`
  ADD KEY `product_tab_shop` (`id_product_tab`,`id_shop`,`product_id`,`tab_content_type`);

--
-- Índices para tabela `ps_product_tag`
--
ALTER TABLE `ps_product_tag`
  ADD PRIMARY KEY (`id_product`,`id_tag`),
  ADD KEY `id_tag` (`id_tag`),
  ADD KEY `id_lang` (`id_lang`,`id_tag`);

--
-- Índices para tabela `ps_profile`
--
ALTER TABLE `ps_profile`
  ADD PRIMARY KEY (`id_profile`);

--
-- Índices para tabela `ps_profile_lang`
--
ALTER TABLE `ps_profile_lang`
  ADD PRIMARY KEY (`id_profile`,`id_lang`);

--
-- Índices para tabela `ps_psgdpr_consent`
--
ALTER TABLE `ps_psgdpr_consent`
  ADD PRIMARY KEY (`id_gdpr_consent`,`id_module`);

--
-- Índices para tabela `ps_psgdpr_consent_lang`
--
ALTER TABLE `ps_psgdpr_consent_lang`
  ADD PRIMARY KEY (`id_gdpr_consent`,`id_lang`,`id_shop`);

--
-- Índices para tabela `ps_psgdpr_log`
--
ALTER TABLE `ps_psgdpr_log`
  ADD PRIMARY KEY (`id_gdpr_log`),
  ADD KEY `idx_id_customer` (`id_customer`,`id_guest`,`client_name`,`id_module`,`date_add`,`date_upd`);

--
-- Índices para tabela `ps_psreassurance`
--
ALTER TABLE `ps_psreassurance`
  ADD PRIMARY KEY (`id_psreassurance`);

--
-- Índices para tabela `ps_psreassurance_lang`
--
ALTER TABLE `ps_psreassurance_lang`
  ADD PRIMARY KEY (`id_psreassurance`,`id_shop`,`id_lang`);

--
-- Índices para tabela `ps_quick_access`
--
ALTER TABLE `ps_quick_access`
  ADD PRIMARY KEY (`id_quick_access`);

--
-- Índices para tabela `ps_quick_access_lang`
--
ALTER TABLE `ps_quick_access_lang`
  ADD PRIMARY KEY (`id_quick_access`,`id_lang`);

--
-- Índices para tabela `ps_range_price`
--
ALTER TABLE `ps_range_price`
  ADD PRIMARY KEY (`id_range_price`),
  ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`);

--
-- Índices para tabela `ps_range_weight`
--
ALTER TABLE `ps_range_weight`
  ADD PRIMARY KEY (`id_range_weight`),
  ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`);

--
-- Índices para tabela `ps_reassurance`
--
ALTER TABLE `ps_reassurance`
  ADD PRIMARY KEY (`id_reassurance`);

--
-- Índices para tabela `ps_reassurance_lang`
--
ALTER TABLE `ps_reassurance_lang`
  ADD PRIMARY KEY (`id_reassurance`,`id_lang`);

--
-- Índices para tabela `ps_referrer`
--
ALTER TABLE `ps_referrer`
  ADD PRIMARY KEY (`id_referrer`);

--
-- Índices para tabela `ps_referrer_cache`
--
ALTER TABLE `ps_referrer_cache`
  ADD PRIMARY KEY (`id_connections_source`,`id_referrer`);

--
-- Índices para tabela `ps_referrer_shop`
--
ALTER TABLE `ps_referrer_shop`
  ADD PRIMARY KEY (`id_referrer`,`id_shop`);

--
-- Índices para tabela `ps_request_sql`
--
ALTER TABLE `ps_request_sql`
  ADD PRIMARY KEY (`id_request_sql`);

--
-- Índices para tabela `ps_required_field`
--
ALTER TABLE `ps_required_field`
  ADD PRIMARY KEY (`id_required_field`),
  ADD KEY `object_name` (`object_name`);

--
-- Índices para tabela `ps_risk`
--
ALTER TABLE `ps_risk`
  ADD PRIMARY KEY (`id_risk`);

--
-- Índices para tabela `ps_risk_lang`
--
ALTER TABLE `ps_risk_lang`
  ADD PRIMARY KEY (`id_risk`,`id_lang`),
  ADD KEY `id_risk` (`id_risk`);

--
-- Índices para tabela `ps_search_engine`
--
ALTER TABLE `ps_search_engine`
  ADD PRIMARY KEY (`id_search_engine`);

--
-- Índices para tabela `ps_search_index`
--
ALTER TABLE `ps_search_index`
  ADD PRIMARY KEY (`id_word`,`id_product`),
  ADD KEY `id_product` (`id_product`,`weight`);

--
-- Índices para tabela `ps_search_word`
--
ALTER TABLE `ps_search_word`
  ADD PRIMARY KEY (`id_word`),
  ADD UNIQUE KEY `id_lang` (`id_lang`,`id_shop`,`word`);

--
-- Índices para tabela `ps_sekeyword`
--
ALTER TABLE `ps_sekeyword`
  ADD PRIMARY KEY (`id_sekeyword`);

--
-- Índices para tabela `ps_shop`
--
ALTER TABLE `ps_shop`
  ADD PRIMARY KEY (`id_shop`),
  ADD KEY `IDX_CBDFBB9EF5C9E40` (`id_shop_group`);

--
-- Índices para tabela `ps_shop_group`
--
ALTER TABLE `ps_shop_group`
  ADD PRIMARY KEY (`id_shop_group`);

--
-- Índices para tabela `ps_shop_url`
--
ALTER TABLE `ps_shop_url`
  ADD PRIMARY KEY (`id_shop_url`),
  ADD UNIQUE KEY `full_shop_url` (`domain`,`physical_uri`,`virtual_uri`),
  ADD UNIQUE KEY `full_shop_url_ssl` (`domain_ssl`,`physical_uri`,`virtual_uri`),
  ADD KEY `id_shop` (`id_shop`,`main`);

--
-- Índices para tabela `ps_smarty_cache`
--
ALTER TABLE `ps_smarty_cache`
  ADD PRIMARY KEY (`id_smarty_cache`),
  ADD KEY `name` (`name`),
  ADD KEY `cache_id` (`cache_id`),
  ADD KEY `modified` (`modified`);

--
-- Índices para tabela `ps_smarty_last_flush`
--
ALTER TABLE `ps_smarty_last_flush`
  ADD PRIMARY KEY (`type`);

--
-- Índices para tabela `ps_smarty_lazy_cache`
--
ALTER TABLE `ps_smarty_lazy_cache`
  ADD PRIMARY KEY (`template_hash`,`cache_id`,`compile_id`);

--
-- Índices para tabela `ps_specific_price`
--
ALTER TABLE `ps_specific_price`
  ADD PRIMARY KEY (`id_specific_price`),
  ADD UNIQUE KEY `id_product_2` (`id_product`,`id_product_attribute`,`id_customer`,`id_cart`,`from`,`to`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`id_specific_price_rule`),
  ADD KEY `id_product` (`id_product`,`id_shop`,`id_currency`,`id_country`,`id_group`,`id_customer`,`from_quantity`,`from`,`to`),
  ADD KEY `from_quantity` (`from_quantity`),
  ADD KEY `id_specific_price_rule` (`id_specific_price_rule`),
  ADD KEY `id_cart` (`id_cart`),
  ADD KEY `id_product_attribute` (`id_product_attribute`),
  ADD KEY `id_shop` (`id_shop`),
  ADD KEY `id_customer` (`id_customer`),
  ADD KEY `from` (`from`),
  ADD KEY `to` (`to`);

--
-- Índices para tabela `ps_specific_price_priority`
--
ALTER TABLE `ps_specific_price_priority`
  ADD PRIMARY KEY (`id_specific_price_priority`,`id_product`),
  ADD UNIQUE KEY `id_product` (`id_product`);

--
-- Índices para tabela `ps_specific_price_rule`
--
ALTER TABLE `ps_specific_price_rule`
  ADD PRIMARY KEY (`id_specific_price_rule`),
  ADD KEY `id_product` (`id_shop`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`from`,`to`);

--
-- Índices para tabela `ps_specific_price_rule_condition`
--
ALTER TABLE `ps_specific_price_rule_condition`
  ADD PRIMARY KEY (`id_specific_price_rule_condition`),
  ADD KEY `id_specific_price_rule_condition_group` (`id_specific_price_rule_condition_group`);

--
-- Índices para tabela `ps_specific_price_rule_condition_group`
--
ALTER TABLE `ps_specific_price_rule_condition_group`
  ADD PRIMARY KEY (`id_specific_price_rule_condition_group`,`id_specific_price_rule`);

--
-- Índices para tabela `ps_state`
--
ALTER TABLE `ps_state`
  ADD PRIMARY KEY (`id_state`),
  ADD KEY `id_country` (`id_country`),
  ADD KEY `name` (`name`),
  ADD KEY `id_zone` (`id_zone`);

--
-- Índices para tabela `ps_statssearch`
--
ALTER TABLE `ps_statssearch`
  ADD PRIMARY KEY (`id_statssearch`);

--
-- Índices para tabela `ps_stock`
--
ALTER TABLE `ps_stock`
  ADD PRIMARY KEY (`id_stock`),
  ADD KEY `id_warehouse` (`id_warehouse`),
  ADD KEY `id_product` (`id_product`),
  ADD KEY `id_product_attribute` (`id_product_attribute`);

--
-- Índices para tabela `ps_stock_available`
--
ALTER TABLE `ps_stock_available`
  ADD PRIMARY KEY (`id_stock_available`),
  ADD UNIQUE KEY `product_sqlstock` (`id_product`,`id_product_attribute`,`id_shop`,`id_shop_group`),
  ADD KEY `id_shop` (`id_shop`),
  ADD KEY `id_shop_group` (`id_shop_group`),
  ADD KEY `id_product` (`id_product`),
  ADD KEY `id_product_attribute` (`id_product_attribute`);

--
-- Índices para tabela `ps_stock_mvt`
--
ALTER TABLE `ps_stock_mvt`
  ADD PRIMARY KEY (`id_stock_mvt`),
  ADD KEY `id_stock` (`id_stock`),
  ADD KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`);

--
-- Índices para tabela `ps_stock_mvt_reason`
--
ALTER TABLE `ps_stock_mvt_reason`
  ADD PRIMARY KEY (`id_stock_mvt_reason`);

--
-- Índices para tabela `ps_stock_mvt_reason_lang`
--
ALTER TABLE `ps_stock_mvt_reason_lang`
  ADD PRIMARY KEY (`id_stock_mvt_reason`,`id_lang`);

--
-- Índices para tabela `ps_store`
--
ALTER TABLE `ps_store`
  ADD PRIMARY KEY (`id_store`);

--
-- Índices para tabela `ps_store_lang`
--
ALTER TABLE `ps_store_lang`
  ADD PRIMARY KEY (`id_store`,`id_lang`);

--
-- Índices para tabela `ps_store_shop`
--
ALTER TABLE `ps_store_shop`
  ADD PRIMARY KEY (`id_store`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_supplier`
--
ALTER TABLE `ps_supplier`
  ADD PRIMARY KEY (`id_supplier`);

--
-- Índices para tabela `ps_supplier_lang`
--
ALTER TABLE `ps_supplier_lang`
  ADD PRIMARY KEY (`id_supplier`,`id_lang`);

--
-- Índices para tabela `ps_supplier_shop`
--
ALTER TABLE `ps_supplier_shop`
  ADD PRIMARY KEY (`id_supplier`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_supply_order`
--
ALTER TABLE `ps_supply_order`
  ADD PRIMARY KEY (`id_supply_order`),
  ADD KEY `id_supplier` (`id_supplier`),
  ADD KEY `id_warehouse` (`id_warehouse`),
  ADD KEY `reference` (`reference`);

--
-- Índices para tabela `ps_supply_order_detail`
--
ALTER TABLE `ps_supply_order_detail`
  ADD PRIMARY KEY (`id_supply_order_detail`),
  ADD KEY `id_supply_order` (`id_supply_order`,`id_product`),
  ADD KEY `id_product_attribute` (`id_product_attribute`),
  ADD KEY `id_product_product_attribute` (`id_product`,`id_product_attribute`);

--
-- Índices para tabela `ps_supply_order_history`
--
ALTER TABLE `ps_supply_order_history`
  ADD PRIMARY KEY (`id_supply_order_history`),
  ADD KEY `id_supply_order` (`id_supply_order`),
  ADD KEY `id_employee` (`id_employee`),
  ADD KEY `id_state` (`id_state`);

--
-- Índices para tabela `ps_supply_order_receipt_history`
--
ALTER TABLE `ps_supply_order_receipt_history`
  ADD PRIMARY KEY (`id_supply_order_receipt_history`),
  ADD KEY `id_supply_order_detail` (`id_supply_order_detail`),
  ADD KEY `id_supply_order_state` (`id_supply_order_state`);

--
-- Índices para tabela `ps_supply_order_state`
--
ALTER TABLE `ps_supply_order_state`
  ADD PRIMARY KEY (`id_supply_order_state`);

--
-- Índices para tabela `ps_supply_order_state_lang`
--
ALTER TABLE `ps_supply_order_state_lang`
  ADD PRIMARY KEY (`id_supply_order_state`,`id_lang`);

--
-- Índices para tabela `ps_tab`
--
ALTER TABLE `ps_tab`
  ADD PRIMARY KEY (`id_tab`);

--
-- Índices para tabela `ps_tab_advice`
--
ALTER TABLE `ps_tab_advice`
  ADD PRIMARY KEY (`id_tab`,`id_advice`);

--
-- Índices para tabela `ps_tab_lang`
--
ALTER TABLE `ps_tab_lang`
  ADD PRIMARY KEY (`id_tab`,`id_lang`),
  ADD KEY `IDX_CFD9262DED47AB56` (`id_tab`),
  ADD KEY `IDX_CFD9262DBA299860` (`id_lang`);

--
-- Índices para tabela `ps_tab_module_preference`
--
ALTER TABLE `ps_tab_module_preference`
  ADD PRIMARY KEY (`id_tab_module_preference`),
  ADD UNIQUE KEY `employee_module` (`id_employee`,`id_tab`,`module`);

--
-- Índices para tabela `ps_tag`
--
ALTER TABLE `ps_tag`
  ADD PRIMARY KEY (`id_tag`),
  ADD KEY `tag_name` (`name`),
  ADD KEY `id_lang` (`id_lang`);

--
-- Índices para tabela `ps_tag_count`
--
ALTER TABLE `ps_tag_count`
  ADD PRIMARY KEY (`id_group`,`id_tag`),
  ADD KEY `id_group` (`id_group`,`id_lang`,`id_shop`,`counter`);

--
-- Índices para tabela `ps_tax`
--
ALTER TABLE `ps_tax`
  ADD PRIMARY KEY (`id_tax`);

--
-- Índices para tabela `ps_tax_lang`
--
ALTER TABLE `ps_tax_lang`
  ADD PRIMARY KEY (`id_tax`,`id_lang`);

--
-- Índices para tabela `ps_tax_rule`
--
ALTER TABLE `ps_tax_rule`
  ADD PRIMARY KEY (`id_tax_rule`),
  ADD KEY `id_tax_rules_group` (`id_tax_rules_group`),
  ADD KEY `id_tax` (`id_tax`),
  ADD KEY `category_getproducts` (`id_tax_rules_group`,`id_country`,`id_state`,`zipcode_from`);

--
-- Índices para tabela `ps_tax_rules_group`
--
ALTER TABLE `ps_tax_rules_group`
  ADD PRIMARY KEY (`id_tax_rules_group`);

--
-- Índices para tabela `ps_tax_rules_group_shop`
--
ALTER TABLE `ps_tax_rules_group_shop`
  ADD PRIMARY KEY (`id_tax_rules_group`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_timezone`
--
ALTER TABLE `ps_timezone`
  ADD PRIMARY KEY (`id_timezone`);

--
-- Índices para tabela `ps_translation`
--
ALTER TABLE `ps_translation`
  ADD PRIMARY KEY (`id_translation`),
  ADD KEY `IDX_ADEBEB36BA299860` (`id_lang`),
  ADD KEY `key` (`domain`);

--
-- Índices para tabela `ps_warehouse`
--
ALTER TABLE `ps_warehouse`
  ADD PRIMARY KEY (`id_warehouse`);

--
-- Índices para tabela `ps_warehouse_carrier`
--
ALTER TABLE `ps_warehouse_carrier`
  ADD PRIMARY KEY (`id_warehouse`,`id_carrier`),
  ADD KEY `id_warehouse` (`id_warehouse`),
  ADD KEY `id_carrier` (`id_carrier`);

--
-- Índices para tabela `ps_warehouse_product_location`
--
ALTER TABLE `ps_warehouse_product_location`
  ADD PRIMARY KEY (`id_warehouse_product_location`),
  ADD UNIQUE KEY `id_product` (`id_product`,`id_product_attribute`,`id_warehouse`);

--
-- Índices para tabela `ps_warehouse_shop`
--
ALTER TABLE `ps_warehouse_shop`
  ADD PRIMARY KEY (`id_warehouse`,`id_shop`),
  ADD KEY `id_warehouse` (`id_warehouse`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_webservice_account`
--
ALTER TABLE `ps_webservice_account`
  ADD PRIMARY KEY (`id_webservice_account`),
  ADD KEY `key` (`key`);

--
-- Índices para tabela `ps_webservice_account_shop`
--
ALTER TABLE `ps_webservice_account_shop`
  ADD PRIMARY KEY (`id_webservice_account`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- Índices para tabela `ps_webservice_permission`
--
ALTER TABLE `ps_webservice_permission`
  ADD PRIMARY KEY (`id_webservice_permission`),
  ADD UNIQUE KEY `resource_2` (`resource`,`method`,`id_webservice_account`),
  ADD KEY `resource` (`resource`),
  ADD KEY `method` (`method`),
  ADD KEY `id_webservice_account` (`id_webservice_account`);

--
-- Índices para tabela `ps_web_browser`
--
ALTER TABLE `ps_web_browser`
  ADD PRIMARY KEY (`id_web_browser`);

--
-- Índices para tabela `ps_zone`
--
ALTER TABLE `ps_zone`
  ADD PRIMARY KEY (`id_zone`);

--
-- Índices para tabela `ps_zone_shop`
--
ALTER TABLE `ps_zone_shop`
  ADD PRIMARY KEY (`id_zone`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `ps_address`
--
ALTER TABLE `ps_address`
  MODIFY `id_address` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1693;

--
-- AUTO_INCREMENT de tabela `ps_admin_filter`
--
ALTER TABLE `ps_admin_filter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT de tabela `ps_advice`
--
ALTER TABLE `ps_advice`
  MODIFY `id_advice` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de tabela `ps_alias`
--
ALTER TABLE `ps_alias`
  MODIFY `id_alias` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_attachment`
--
ALTER TABLE `ps_attachment`
  MODIFY `id_attachment` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_attachment_lang`
--
ALTER TABLE `ps_attachment_lang`
  MODIFY `id_attachment` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_attribute`
--
ALTER TABLE `ps_attribute`
  MODIFY `id_attribute` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_attribute_group`
--
ALTER TABLE `ps_attribute_group`
  MODIFY `id_attribute_group` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_attribute_impact`
--
ALTER TABLE `ps_attribute_impact`
  MODIFY `id_attribute_impact` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_authorization_role`
--
ALTER TABLE `ps_authorization_role`
  MODIFY `id_authorization_role` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=877;

--
-- AUTO_INCREMENT de tabela `ps_badge`
--
ALTER TABLE `ps_badge`
  MODIFY `id_badge` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=235;

--
-- AUTO_INCREMENT de tabela `ps_carrier`
--
ALTER TABLE `ps_carrier`
  MODIFY `id_carrier` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de tabela `ps_cart`
--
ALTER TABLE `ps_cart`
  MODIFY `id_cart` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2397;

--
-- AUTO_INCREMENT de tabela `ps_cart_rule`
--
ALTER TABLE `ps_cart_rule`
  MODIFY `id_cart_rule` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_cart_rule_product_rule`
--
ALTER TABLE `ps_cart_rule_product_rule`
  MODIFY `id_product_rule` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_cart_rule_product_rule_group`
--
ALTER TABLE `ps_cart_rule_product_rule_group`
  MODIFY `id_product_rule_group` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_category`
--
ALTER TABLE `ps_category`
  MODIFY `id_category` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT de tabela `ps_cms`
--
ALTER TABLE `ps_cms`
  MODIFY `id_cms` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT de tabela `ps_cms_category`
--
ALTER TABLE `ps_cms_category`
  MODIFY `id_cms_category` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_cms_category_shop`
--
ALTER TABLE `ps_cms_category_shop`
  MODIFY `id_cms_category` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_cms_role`
--
ALTER TABLE `ps_cms_role`
  MODIFY `id_cms_role` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_condition`
--
ALTER TABLE `ps_condition`
  MODIFY `id_condition` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=245;

--
-- AUTO_INCREMENT de tabela `ps_configuration`
--
ALTER TABLE `ps_configuration`
  MODIFY `id_configuration` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=577;

--
-- AUTO_INCREMENT de tabela `ps_configuration_kpi`
--
ALTER TABLE `ps_configuration_kpi`
  MODIFY `id_configuration_kpi` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT de tabela `ps_connections`
--
ALTER TABLE `ps_connections`
  MODIFY `id_connections` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133942;

--
-- AUTO_INCREMENT de tabela `ps_connections_source`
--
ALTER TABLE `ps_connections_source`
  MODIFY `id_connections_source` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24416;

--
-- AUTO_INCREMENT de tabela `ps_contact`
--
ALTER TABLE `ps_contact`
  MODIFY `id_contact` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_contentbox`
--
ALTER TABLE `ps_contentbox`
  MODIFY `content_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_contentbox_files`
--
ALTER TABLE `ps_contentbox_files`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_country`
--
ALTER TABLE `ps_country`
  MODIFY `id_country` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=245;

--
-- AUTO_INCREMENT de tabela `ps_currency`
--
ALTER TABLE `ps_currency`
  MODIFY `id_currency` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_customer`
--
ALTER TABLE `ps_customer`
  MODIFY `id_customer` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1724;

--
-- AUTO_INCREMENT de tabela `ps_customer_message`
--
ALTER TABLE `ps_customer_message`
  MODIFY `id_customer_message` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=219;

--
-- AUTO_INCREMENT de tabela `ps_customer_session`
--
ALTER TABLE `ps_customer_session`
  MODIFY `id_customer_session` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1270;

--
-- AUTO_INCREMENT de tabela `ps_customer_thread`
--
ALTER TABLE `ps_customer_thread`
  MODIFY `id_customer_thread` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=192;

--
-- AUTO_INCREMENT de tabela `ps_customization`
--
ALTER TABLE `ps_customization`
  MODIFY `id_customization` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_customization_field`
--
ALTER TABLE `ps_customization_field`
  MODIFY `id_customization_field` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_date_range`
--
ALTER TABLE `ps_date_range`
  MODIFY `id_date_range` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1175;

--
-- AUTO_INCREMENT de tabela `ps_delivery`
--
ALTER TABLE `ps_delivery`
  MODIFY `id_delivery` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT de tabela `ps_emailsubscription`
--
ALTER TABLE `ps_emailsubscription`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de tabela `ps_employee`
--
ALTER TABLE `ps_employee`
  MODIFY `id_employee` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `ps_employee_session`
--
ALTER TABLE `ps_employee_session`
  MODIFY `id_employee_session` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=235;

--
-- AUTO_INCREMENT de tabela `ps_feature`
--
ALTER TABLE `ps_feature`
  MODIFY `id_feature` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_feature_value`
--
ALTER TABLE `ps_feature_value`
  MODIFY `id_feature_value` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT de tabela `ps_gender`
--
ALTER TABLE `ps_gender`
  MODIFY `id_gender` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_group`
--
ALTER TABLE `ps_group`
  MODIFY `id_group` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `ps_group_reduction`
--
ALTER TABLE `ps_group_reduction`
  MODIFY `id_group_reduction` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_guest`
--
ALTER TABLE `ps_guest`
  MODIFY `id_guest` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131785;

--
-- AUTO_INCREMENT de tabela `ps_homeslider`
--
ALTER TABLE `ps_homeslider`
  MODIFY `id_homeslider_slides` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `ps_homeslider_slides`
--
ALTER TABLE `ps_homeslider_slides`
  MODIFY `id_homeslider_slides` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `ps_hook`
--
ALTER TABLE `ps_hook`
  MODIFY `id_hook` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=486;

--
-- AUTO_INCREMENT de tabela `ps_hook_alias`
--
ALTER TABLE `ps_hook_alias`
  MODIFY `id_hook_alias` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT de tabela `ps_hook_module_exceptions`
--
ALTER TABLE `ps_hook_module_exceptions`
  MODIFY `id_hook_module_exceptions` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=278;

--
-- AUTO_INCREMENT de tabela `ps_iconepesquisa`
--
ALTER TABLE `ps_iconepesquisa`
  MODIFY `content_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_iconepesquisa_files`
--
ALTER TABLE `ps_iconepesquisa_files`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_image`
--
ALTER TABLE `ps_image`
  MODIFY `id_image` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT de tabela `ps_image_type`
--
ALTER TABLE `ps_image_type`
  MODIFY `id_image_type` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de tabela `ps_import_match`
--
ALTER TABLE `ps_import_match`
  MODIFY `id_import_match` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_info`
--
ALTER TABLE `ps_info`
  MODIFY `id_info` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_lang`
--
ALTER TABLE `ps_lang`
  MODIFY `id_lang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_layered_category`
--
ALTER TABLE `ps_layered_category`
  MODIFY `id_layered_category` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT de tabela `ps_layered_filter`
--
ALTER TABLE `ps_layered_filter`
  MODIFY `id_layered_filter` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_linksmenutop`
--
ALTER TABLE `ps_linksmenutop`
  MODIFY `id_linksmenutop` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de tabela `ps_link_block`
--
ALTER TABLE `ps_link_block`
  MODIFY `id_link_block` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_link_block_shop`
--
ALTER TABLE `ps_link_block_shop`
  MODIFY `id_link_block` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_log`
--
ALTER TABLE `ps_log`
  MODIFY `id_log` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2198;

--
-- AUTO_INCREMENT de tabela `ps_mail`
--
ALTER TABLE `ps_mail`
  MODIFY `id_mail` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3954;

--
-- AUTO_INCREMENT de tabela `ps_manufacturer`
--
ALTER TABLE `ps_manufacturer`
  MODIFY `id_manufacturer` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `ps_memcached_servers`
--
ALTER TABLE `ps_memcached_servers`
  MODIFY `id_memcached_server` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_menuicones`
--
ALTER TABLE `ps_menuicones`
  MODIFY `content_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_menuicones_files`
--
ALTER TABLE `ps_menuicones_files`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_message`
--
ALTER TABLE `ps_message`
  MODIFY `id_message` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94;

--
-- AUTO_INCREMENT de tabela `ps_meta`
--
ALTER TABLE `ps_meta`
  MODIFY `id_meta` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT de tabela `ps_module`
--
ALTER TABLE `ps_module`
  MODIFY `id_module` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT de tabela `ps_module_history`
--
ALTER TABLE `ps_module_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT de tabela `ps_module_preference`
--
ALTER TABLE `ps_module_preference`
  MODIFY `id_module_preference` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_operating_system`
--
ALTER TABLE `ps_operating_system`
  MODIFY `id_operating_system` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de tabela `ps_orders`
--
ALTER TABLE `ps_orders`
  MODIFY `id_order` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=847;

--
-- AUTO_INCREMENT de tabela `ps_order_carrier`
--
ALTER TABLE `ps_order_carrier`
  MODIFY `id_order_carrier` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=847;

--
-- AUTO_INCREMENT de tabela `ps_order_cart_rule`
--
ALTER TABLE `ps_order_cart_rule`
  MODIFY `id_order_cart_rule` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_order_detail`
--
ALTER TABLE `ps_order_detail`
  MODIFY `id_order_detail` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1776;

--
-- AUTO_INCREMENT de tabela `ps_order_history`
--
ALTER TABLE `ps_order_history`
  MODIFY `id_order_history` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1005;

--
-- AUTO_INCREMENT de tabela `ps_order_invoice`
--
ALTER TABLE `ps_order_invoice`
  MODIFY `id_order_invoice` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `ps_order_message`
--
ALTER TABLE `ps_order_message`
  MODIFY `id_order_message` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_order_payment`
--
ALTER TABLE `ps_order_payment`
  MODIFY `id_order_payment` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT de tabela `ps_order_return`
--
ALTER TABLE `ps_order_return`
  MODIFY `id_order_return` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_order_return_state`
--
ALTER TABLE `ps_order_return_state`
  MODIFY `id_order_return_state` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_order_slip`
--
ALTER TABLE `ps_order_slip`
  MODIFY `id_order_slip` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_order_state`
--
ALTER TABLE `ps_order_state`
  MODIFY `id_order_state` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT de tabela `ps_page`
--
ALTER TABLE `ps_page`
  MODIFY `id_page` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105;

--
-- AUTO_INCREMENT de tabela `ps_pagenotfound`
--
ALTER TABLE `ps_pagenotfound`
  MODIFY `id_pagenotfound` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11736;

--
-- AUTO_INCREMENT de tabela `ps_page_type`
--
ALTER TABLE `ps_page_type`
  MODIFY `id_page_type` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT de tabela `ps_payzen_token`
--
ALTER TABLE `ps_payzen_token`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_product`
--
ALTER TABLE `ps_product`
  MODIFY `id_product` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT de tabela `ps_producttabs_settings`
--
ALTER TABLE `ps_producttabs_settings`
  MODIFY `id_producttabs_settings` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT de tabela `ps_product_attribute`
--
ALTER TABLE `ps_product_attribute`
  MODIFY `id_product_attribute` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_product_download`
--
ALTER TABLE `ps_product_download`
  MODIFY `id_product_download` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_product_supplier`
--
ALTER TABLE `ps_product_supplier`
  MODIFY `id_product_supplier` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT de tabela `ps_product_tab`
--
ALTER TABLE `ps_product_tab`
  MODIFY `id_product_tab` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=178;

--
-- AUTO_INCREMENT de tabela `ps_product_tab_global`
--
ALTER TABLE `ps_product_tab_global`
  MODIFY `id_product_tab_global` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `ps_profile`
--
ALTER TABLE `ps_profile`
  MODIFY `id_profile` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `ps_psgdpr_consent`
--
ALTER TABLE `ps_psgdpr_consent`
  MODIFY `id_gdpr_consent` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_psgdpr_consent_lang`
--
ALTER TABLE `ps_psgdpr_consent_lang`
  MODIFY `id_gdpr_consent` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_psgdpr_log`
--
ALTER TABLE `ps_psgdpr_log`
  MODIFY `id_gdpr_log` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=747;

--
-- AUTO_INCREMENT de tabela `ps_psreassurance`
--
ALTER TABLE `ps_psreassurance`
  MODIFY `id_psreassurance` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `ps_quick_access`
--
ALTER TABLE `ps_quick_access`
  MODIFY `id_quick_access` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `ps_range_price`
--
ALTER TABLE `ps_range_price`
  MODIFY `id_range_price` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de tabela `ps_range_weight`
--
ALTER TABLE `ps_range_weight`
  MODIFY `id_range_weight` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `ps_reassurance`
--
ALTER TABLE `ps_reassurance`
  MODIFY `id_reassurance` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `ps_reassurance_lang`
--
ALTER TABLE `ps_reassurance_lang`
  MODIFY `id_reassurance` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `ps_referrer`
--
ALTER TABLE `ps_referrer`
  MODIFY `id_referrer` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_referrer_shop`
--
ALTER TABLE `ps_referrer_shop`
  MODIFY `id_referrer` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_request_sql`
--
ALTER TABLE `ps_request_sql`
  MODIFY `id_request_sql` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_required_field`
--
ALTER TABLE `ps_required_field`
  MODIFY `id_required_field` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_risk`
--
ALTER TABLE `ps_risk`
  MODIFY `id_risk` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `ps_search_engine`
--
ALTER TABLE `ps_search_engine`
  MODIFY `id_search_engine` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT de tabela `ps_search_word`
--
ALTER TABLE `ps_search_word`
  MODIFY `id_word` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24324;

--
-- AUTO_INCREMENT de tabela `ps_sekeyword`
--
ALTER TABLE `ps_sekeyword`
  MODIFY `id_sekeyword` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_shop`
--
ALTER TABLE `ps_shop`
  MODIFY `id_shop` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_shop_group`
--
ALTER TABLE `ps_shop_group`
  MODIFY `id_shop_group` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_shop_url`
--
ALTER TABLE `ps_shop_url`
  MODIFY `id_shop_url` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_specific_price`
--
ALTER TABLE `ps_specific_price`
  MODIFY `id_specific_price` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_specific_price_priority`
--
ALTER TABLE `ps_specific_price_priority`
  MODIFY `id_specific_price_priority` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT de tabela `ps_specific_price_rule`
--
ALTER TABLE `ps_specific_price_rule`
  MODIFY `id_specific_price_rule` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_specific_price_rule_condition`
--
ALTER TABLE `ps_specific_price_rule_condition`
  MODIFY `id_specific_price_rule_condition` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_specific_price_rule_condition_group`
--
ALTER TABLE `ps_specific_price_rule_condition_group`
  MODIFY `id_specific_price_rule_condition_group` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_state`
--
ALTER TABLE `ps_state`
  MODIFY `id_state` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=325;

--
-- AUTO_INCREMENT de tabela `ps_statssearch`
--
ALTER TABLE `ps_statssearch`
  MODIFY `id_statssearch` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6224;

--
-- AUTO_INCREMENT de tabela `ps_stock`
--
ALTER TABLE `ps_stock`
  MODIFY `id_stock` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_stock_available`
--
ALTER TABLE `ps_stock_available`
  MODIFY `id_stock_available` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT de tabela `ps_stock_mvt`
--
ALTER TABLE `ps_stock_mvt`
  MODIFY `id_stock_mvt` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=284;

--
-- AUTO_INCREMENT de tabela `ps_stock_mvt_reason`
--
ALTER TABLE `ps_stock_mvt_reason`
  MODIFY `id_stock_mvt_reason` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT de tabela `ps_store`
--
ALTER TABLE `ps_store`
  MODIFY `id_store` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_supplier`
--
ALTER TABLE `ps_supplier`
  MODIFY `id_supplier` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ps_supply_order`
--
ALTER TABLE `ps_supply_order`
  MODIFY `id_supply_order` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_supply_order_detail`
--
ALTER TABLE `ps_supply_order_detail`
  MODIFY `id_supply_order_detail` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_supply_order_history`
--
ALTER TABLE `ps_supply_order_history`
  MODIFY `id_supply_order_history` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_supply_order_receipt_history`
--
ALTER TABLE `ps_supply_order_receipt_history`
  MODIFY `id_supply_order_receipt_history` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_supply_order_state`
--
ALTER TABLE `ps_supply_order_state`
  MODIFY `id_supply_order_state` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `ps_tab`
--
ALTER TABLE `ps_tab`
  MODIFY `id_tab` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=147;

--
-- AUTO_INCREMENT de tabela `ps_tab_module_preference`
--
ALTER TABLE `ps_tab_module_preference`
  MODIFY `id_tab_module_preference` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_tag`
--
ALTER TABLE `ps_tag`
  MODIFY `id_tag` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_tax`
--
ALTER TABLE `ps_tax`
  MODIFY `id_tax` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT de tabela `ps_tax_rule`
--
ALTER TABLE `ps_tax_rule`
  MODIFY `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=403;

--
-- AUTO_INCREMENT de tabela `ps_tax_rules_group`
--
ALTER TABLE `ps_tax_rules_group`
  MODIFY `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `ps_timezone`
--
ALTER TABLE `ps_timezone`
  MODIFY `id_timezone` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=561;

--
-- AUTO_INCREMENT de tabela `ps_translation`
--
ALTER TABLE `ps_translation`
  MODIFY `id_translation` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_warehouse`
--
ALTER TABLE `ps_warehouse`
  MODIFY `id_warehouse` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_warehouse_product_location`
--
ALTER TABLE `ps_warehouse_product_location`
  MODIFY `id_warehouse_product_location` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_webservice_account`
--
ALTER TABLE `ps_webservice_account`
  MODIFY `id_webservice_account` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_webservice_permission`
--
ALTER TABLE `ps_webservice_permission`
  MODIFY `id_webservice_permission` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `ps_web_browser`
--
ALTER TABLE `ps_web_browser`
  MODIFY `id_web_browser` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de tabela `ps_zone`
--
ALTER TABLE `ps_zone`
  MODIFY `id_zone` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

