Jump to content

Edit History

ps8modules

ps8modules

@madpugger

Hi. I'll give you the SQL with the tables. Just upload the SQL to phpMyAdmin and run it. It will delete the corrupted tables and upload new ones including the original data, as in the initial installation.

The following tables will be restored:

ps_tax, ps_tax_rule, ps_tax_rules_group, ps_tax_rules_group_shop

Alternatively, choose what you want to restore, but I recommend restoring all of the tables mentioned. 


DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ps_tax` (`id_tax`, `rate`, `active`, `deleted`) VALUES
(1, 4.000, 1, 0),
(2, 0.000, 1, 0),
(3, 6.600, 1, 0),
(4, 6.000, 1, 0),
(5, 8.250, 1, 0),
(6, 2.900, 1, 0),
(7, 0.000, 1, 0),
(8, 0.000, 1, 0),
(9, 6.000, 1, 0),
(10, 4.000, 1, 0),
(11, 4.000, 1, 0),
(12, 6.000, 1, 0),
(13, 6.250, 1, 0),
(14, 7.000, 1, 0),
(15, 6.000, 1, 0),
(16, 5.300, 1, 0),
(17, 6.000, 1, 0),
(18, 4.000, 1, 0),
(19, 5.000, 1, 0),
(20, 6.000, 1, 0),
(21, 6.250, 1, 0),
(22, 6.000, 1, 0),
(23, 6.875, 1, 0),
(24, 7.000, 1, 0),
(25, 4.225, 1, 0),
(26, 0.000, 1, 0),
(27, 5.500, 1, 0),
(28, 6.850, 1, 0),
(29, 0.000, 1, 0),
(30, 7.000, 1, 0),
(31, 5.125, 1, 0),
(32, 4.000, 1, 0),
(33, 5.500, 1, 0),
(34, 5.000, 1, 0),
(35, 5.500, 1, 0),
(36, 4.500, 1, 0),
(37, 0.000, 1, 0),
(38, 6.000, 1, 0),
(39, 7.000, 1, 0),
(40, 6.000, 1, 0),
(41, 4.000, 1, 0),
(42, 7.000, 1, 0),
(43, 6.250, 1, 0),
(44, 4.750, 1, 0),
(45, 6.000, 1, 0),
(46, 4.000, 1, 0),
(47, 6.500, 1, 0),
(48, 6.000, 1, 0),
(49, 5.000, 1, 0),
(50, 4.000, 1, 0),
(51, 5.500, 1, 0),
(52, 6.000, 1, 0);

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

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
(1, 1, 21, 4, '0', '0', 1, 1, ''),
(2, 2, 21, 5, '0', '0', 2, 1, ''),
(3, 3, 21, 6, '0', '0', 3, 1, ''),
(4, 4, 21, 7, '0', '0', 4, 1, ''),
(5, 5, 21, 8, '0', '0', 5, 1, ''),
(6, 6, 21, 9, '0', '0', 6, 1, ''),
(7, 7, 21, 10, '0', '0', 7, 1, ''),
(8, 8, 21, 11, '0', '0', 8, 1, ''),
(9, 9, 21, 12, '0', '0', 9, 1, ''),
(10, 10, 21, 13, '0', '0', 10, 1, ''),
(11, 11, 21, 14, '0', '0', 11, 1, ''),
(12, 12, 21, 15, '0', '0', 12, 1, ''),
(13, 13, 21, 16, '0', '0', 13, 1, ''),
(14, 14, 21, 17, '0', '0', 14, 1, ''),
(15, 15, 21, 18, '0', '0', 15, 1, ''),
(16, 16, 21, 19, '0', '0', 16, 1, ''),
(17, 17, 21, 20, '0', '0', 17, 1, ''),
(18, 18, 21, 21, '0', '0', 18, 1, ''),
(19, 19, 21, 22, '0', '0', 19, 1, ''),
(20, 20, 21, 23, '0', '0', 20, 1, ''),
(21, 21, 21, 24, '0', '0', 21, 1, ''),
(22, 22, 21, 25, '0', '0', 22, 1, ''),
(23, 23, 21, 26, '0', '0', 23, 1, ''),
(24, 24, 21, 27, '0', '0', 24, 1, ''),
(25, 25, 21, 28, '0', '0', 25, 1, ''),
(26, 26, 21, 29, '0', '0', 26, 1, ''),
(27, 27, 21, 30, '0', '0', 27, 1, ''),
(28, 28, 21, 31, '0', '0', 28, 1, ''),
(29, 29, 21, 32, '0', '0', 29, 1, ''),
(30, 30, 21, 33, '0', '0', 30, 1, ''),
(31, 31, 21, 34, '0', '0', 31, 1, ''),
(32, 32, 21, 35, '0', '0', 32, 1, ''),
(33, 33, 21, 36, '0', '0', 33, 1, ''),
(34, 34, 21, 37, '0', '0', 34, 1, ''),
(35, 35, 21, 38, '0', '0', 35, 1, ''),
(36, 36, 21, 39, '0', '0', 36, 1, ''),
(37, 37, 21, 40, '0', '0', 37, 1, ''),
(38, 38, 21, 41, '0', '0', 38, 1, ''),
(39, 39, 21, 42, '0', '0', 39, 1, ''),
(40, 40, 21, 43, '0', '0', 40, 1, ''),
(41, 41, 21, 44, '0', '0', 41, 1, ''),
(42, 42, 21, 45, '0', '0', 42, 1, ''),
(43, 43, 21, 46, '0', '0', 43, 1, ''),
(44, 44, 21, 47, '0', '0', 44, 1, ''),
(45, 45, 21, 48, '0', '0', 45, 1, ''),
(46, 46, 21, 49, '0', '0', 46, 1, ''),
(47, 47, 21, 50, '0', '0', 47, 1, ''),
(48, 48, 21, 51, '0', '0', 48, 1, ''),
(49, 49, 21, 52, '0', '0', 49, 1, ''),
(50, 50, 21, 53, '0', '0', 50, 1, ''),
(51, 51, 21, 54, '0', '0', 51, 1, ''),
(52, 52, 21, 56, '0', '0', 52, 1, '');

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ps_tax_rules_group` (`id_tax_rules_group`, `name`, `active`, `deleted`, `date_add`, `date_upd`) VALUES
(1, 'US-AL Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(2, 'US-AK Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(3, 'US-AZ Rate (6.6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(4, 'US-AR Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(5, 'US-CA Rate (8.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(6, 'US-CO Rate (2.9%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(7, 'US-CT Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(8, 'US-DE Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(9, 'US-FL Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(10, 'US-GA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(11, 'US-HI Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(12, 'US-ID Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(13, 'US-IL Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(14, 'US-IN Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(15, 'US-IA Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(16, 'US-KS Rate (5.3%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(17, 'US-KY Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(18, 'US-LA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(19, 'US-ME Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(20, 'US-MD Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(21, 'US-MA Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(22, 'US-MI Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(23, 'US-MN Rate (6.875%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(24, 'US-MS Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(25, 'US-MO Rate (4.225%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(26, 'US-MT Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(27, 'US-NE Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(28, 'US-NV Rate (6.85%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(29, 'US-NH Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(30, 'US-NJ Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(31, 'US-NM Rate (5.125%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(32, 'US-NY Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(33, 'US-NC Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(34, 'US-ND Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(35, 'US-OH Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(36, 'US-OK Rate (4.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(37, 'US-OR Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(38, 'US-PA Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(39, 'US-RI Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(40, 'US-SC Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(41, 'US-SD Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(42, 'US-TN Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(43, 'US-TX Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(44, 'US-UT Rate (4.75%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(45, 'US-VT Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(46, 'US-VA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(47, 'US-WA Rate (6.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(48, 'US-WV Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(49, 'US-WI Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(50, 'US-WY Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(51, 'US-PR Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(52, 'US-DC Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21');

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

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),
(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);


ALTER TABLE `ps_tax`
  ADD PRIMARY KEY (`id_tax`);

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`);

ALTER TABLE `ps_tax_rules_group`
  ADD PRIMARY KEY (`id_tax_rules_group`);

ALTER TABLE `ps_tax_rules_group_shop`
  ADD PRIMARY KEY (`id_tax_rules_group`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);


ALTER TABLE `ps_tax`
  MODIFY `id_tax` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

ALTER TABLE `ps_tax_rule`
  MODIFY `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

ALTER TABLE `ps_tax_rules_group`
  MODIFY `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

 

ps8modules

ps8modules

@madpugger

Hi. I'll give you the SQL with the tables. Just upload the SQL to phpMyAdmin and run it. It will delete the corrupted tables and upload new ones including the original data, as in the initial installation.

The following tables will be restored:

ps_tax, ps_tax_rule, ps_tax_rules_group, ps_tax_rules_group_shop 


DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ps_tax` (`id_tax`, `rate`, `active`, `deleted`) VALUES
(1, 4.000, 1, 0),
(2, 0.000, 1, 0),
(3, 6.600, 1, 0),
(4, 6.000, 1, 0),
(5, 8.250, 1, 0),
(6, 2.900, 1, 0),
(7, 0.000, 1, 0),
(8, 0.000, 1, 0),
(9, 6.000, 1, 0),
(10, 4.000, 1, 0),
(11, 4.000, 1, 0),
(12, 6.000, 1, 0),
(13, 6.250, 1, 0),
(14, 7.000, 1, 0),
(15, 6.000, 1, 0),
(16, 5.300, 1, 0),
(17, 6.000, 1, 0),
(18, 4.000, 1, 0),
(19, 5.000, 1, 0),
(20, 6.000, 1, 0),
(21, 6.250, 1, 0),
(22, 6.000, 1, 0),
(23, 6.875, 1, 0),
(24, 7.000, 1, 0),
(25, 4.225, 1, 0),
(26, 0.000, 1, 0),
(27, 5.500, 1, 0),
(28, 6.850, 1, 0),
(29, 0.000, 1, 0),
(30, 7.000, 1, 0),
(31, 5.125, 1, 0),
(32, 4.000, 1, 0),
(33, 5.500, 1, 0),
(34, 5.000, 1, 0),
(35, 5.500, 1, 0),
(36, 4.500, 1, 0),
(37, 0.000, 1, 0),
(38, 6.000, 1, 0),
(39, 7.000, 1, 0),
(40, 6.000, 1, 0),
(41, 4.000, 1, 0),
(42, 7.000, 1, 0),
(43, 6.250, 1, 0),
(44, 4.750, 1, 0),
(45, 6.000, 1, 0),
(46, 4.000, 1, 0),
(47, 6.500, 1, 0),
(48, 6.000, 1, 0),
(49, 5.000, 1, 0),
(50, 4.000, 1, 0),
(51, 5.500, 1, 0),
(52, 6.000, 1, 0);

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

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
(1, 1, 21, 4, '0', '0', 1, 1, ''),
(2, 2, 21, 5, '0', '0', 2, 1, ''),
(3, 3, 21, 6, '0', '0', 3, 1, ''),
(4, 4, 21, 7, '0', '0', 4, 1, ''),
(5, 5, 21, 8, '0', '0', 5, 1, ''),
(6, 6, 21, 9, '0', '0', 6, 1, ''),
(7, 7, 21, 10, '0', '0', 7, 1, ''),
(8, 8, 21, 11, '0', '0', 8, 1, ''),
(9, 9, 21, 12, '0', '0', 9, 1, ''),
(10, 10, 21, 13, '0', '0', 10, 1, ''),
(11, 11, 21, 14, '0', '0', 11, 1, ''),
(12, 12, 21, 15, '0', '0', 12, 1, ''),
(13, 13, 21, 16, '0', '0', 13, 1, ''),
(14, 14, 21, 17, '0', '0', 14, 1, ''),
(15, 15, 21, 18, '0', '0', 15, 1, ''),
(16, 16, 21, 19, '0', '0', 16, 1, ''),
(17, 17, 21, 20, '0', '0', 17, 1, ''),
(18, 18, 21, 21, '0', '0', 18, 1, ''),
(19, 19, 21, 22, '0', '0', 19, 1, ''),
(20, 20, 21, 23, '0', '0', 20, 1, ''),
(21, 21, 21, 24, '0', '0', 21, 1, ''),
(22, 22, 21, 25, '0', '0', 22, 1, ''),
(23, 23, 21, 26, '0', '0', 23, 1, ''),
(24, 24, 21, 27, '0', '0', 24, 1, ''),
(25, 25, 21, 28, '0', '0', 25, 1, ''),
(26, 26, 21, 29, '0', '0', 26, 1, ''),
(27, 27, 21, 30, '0', '0', 27, 1, ''),
(28, 28, 21, 31, '0', '0', 28, 1, ''),
(29, 29, 21, 32, '0', '0', 29, 1, ''),
(30, 30, 21, 33, '0', '0', 30, 1, ''),
(31, 31, 21, 34, '0', '0', 31, 1, ''),
(32, 32, 21, 35, '0', '0', 32, 1, ''),
(33, 33, 21, 36, '0', '0', 33, 1, ''),
(34, 34, 21, 37, '0', '0', 34, 1, ''),
(35, 35, 21, 38, '0', '0', 35, 1, ''),
(36, 36, 21, 39, '0', '0', 36, 1, ''),
(37, 37, 21, 40, '0', '0', 37, 1, ''),
(38, 38, 21, 41, '0', '0', 38, 1, ''),
(39, 39, 21, 42, '0', '0', 39, 1, ''),
(40, 40, 21, 43, '0', '0', 40, 1, ''),
(41, 41, 21, 44, '0', '0', 41, 1, ''),
(42, 42, 21, 45, '0', '0', 42, 1, ''),
(43, 43, 21, 46, '0', '0', 43, 1, ''),
(44, 44, 21, 47, '0', '0', 44, 1, ''),
(45, 45, 21, 48, '0', '0', 45, 1, ''),
(46, 46, 21, 49, '0', '0', 46, 1, ''),
(47, 47, 21, 50, '0', '0', 47, 1, ''),
(48, 48, 21, 51, '0', '0', 48, 1, ''),
(49, 49, 21, 52, '0', '0', 49, 1, ''),
(50, 50, 21, 53, '0', '0', 50, 1, ''),
(51, 51, 21, 54, '0', '0', 51, 1, ''),
(52, 52, 21, 56, '0', '0', 52, 1, '');

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ps_tax_rules_group` (`id_tax_rules_group`, `name`, `active`, `deleted`, `date_add`, `date_upd`) VALUES
(1, 'US-AL Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(2, 'US-AK Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(3, 'US-AZ Rate (6.6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(4, 'US-AR Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(5, 'US-CA Rate (8.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(6, 'US-CO Rate (2.9%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(7, 'US-CT Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(8, 'US-DE Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(9, 'US-FL Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(10, 'US-GA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(11, 'US-HI Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(12, 'US-ID Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(13, 'US-IL Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(14, 'US-IN Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(15, 'US-IA Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(16, 'US-KS Rate (5.3%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(17, 'US-KY Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(18, 'US-LA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(19, 'US-ME Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(20, 'US-MD Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(21, 'US-MA Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(22, 'US-MI Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(23, 'US-MN Rate (6.875%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(24, 'US-MS Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(25, 'US-MO Rate (4.225%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(26, 'US-MT Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(27, 'US-NE Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(28, 'US-NV Rate (6.85%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(29, 'US-NH Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(30, 'US-NJ Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(31, 'US-NM Rate (5.125%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(32, 'US-NY Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(33, 'US-NC Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(34, 'US-ND Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(35, 'US-OH Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(36, 'US-OK Rate (4.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(37, 'US-OR Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(38, 'US-PA Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(39, 'US-RI Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(40, 'US-SC Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(41, 'US-SD Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(42, 'US-TN Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(43, 'US-TX Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(44, 'US-UT Rate (4.75%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(45, 'US-VT Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(46, 'US-VA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(47, 'US-WA Rate (6.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(48, 'US-WV Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(49, 'US-WI Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(50, 'US-WY Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(51, 'US-PR Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(52, 'US-DC Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21');

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

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),
(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);


ALTER TABLE `ps_tax`
  ADD PRIMARY KEY (`id_tax`);

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`);

ALTER TABLE `ps_tax_rules_group`
  ADD PRIMARY KEY (`id_tax_rules_group`);

ALTER TABLE `ps_tax_rules_group_shop`
  ADD PRIMARY KEY (`id_tax_rules_group`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);


ALTER TABLE `ps_tax`
  MODIFY `id_tax` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

ALTER TABLE `ps_tax_rule`
  MODIFY `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

ALTER TABLE `ps_tax_rules_group`
  MODIFY `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

 

ps8modules

ps8modules

@madpugger

Hi. I'll give you the SQL with the tables. Just upload the SQL to phpMyAdmin and run it. It will delete the corrupted tables and upload new ones including the original data, as in the initial installation. 


DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ps_tax` (`id_tax`, `rate`, `active`, `deleted`) VALUES
(1, 4.000, 1, 0),
(2, 0.000, 1, 0),
(3, 6.600, 1, 0),
(4, 6.000, 1, 0),
(5, 8.250, 1, 0),
(6, 2.900, 1, 0),
(7, 0.000, 1, 0),
(8, 0.000, 1, 0),
(9, 6.000, 1, 0),
(10, 4.000, 1, 0),
(11, 4.000, 1, 0),
(12, 6.000, 1, 0),
(13, 6.250, 1, 0),
(14, 7.000, 1, 0),
(15, 6.000, 1, 0),
(16, 5.300, 1, 0),
(17, 6.000, 1, 0),
(18, 4.000, 1, 0),
(19, 5.000, 1, 0),
(20, 6.000, 1, 0),
(21, 6.250, 1, 0),
(22, 6.000, 1, 0),
(23, 6.875, 1, 0),
(24, 7.000, 1, 0),
(25, 4.225, 1, 0),
(26, 0.000, 1, 0),
(27, 5.500, 1, 0),
(28, 6.850, 1, 0),
(29, 0.000, 1, 0),
(30, 7.000, 1, 0),
(31, 5.125, 1, 0),
(32, 4.000, 1, 0),
(33, 5.500, 1, 0),
(34, 5.000, 1, 0),
(35, 5.500, 1, 0),
(36, 4.500, 1, 0),
(37, 0.000, 1, 0),
(38, 6.000, 1, 0),
(39, 7.000, 1, 0),
(40, 6.000, 1, 0),
(41, 4.000, 1, 0),
(42, 7.000, 1, 0),
(43, 6.250, 1, 0),
(44, 4.750, 1, 0),
(45, 6.000, 1, 0),
(46, 4.000, 1, 0),
(47, 6.500, 1, 0),
(48, 6.000, 1, 0),
(49, 5.000, 1, 0),
(50, 4.000, 1, 0),
(51, 5.500, 1, 0),
(52, 6.000, 1, 0);

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

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
(1, 1, 21, 4, '0', '0', 1, 1, ''),
(2, 2, 21, 5, '0', '0', 2, 1, ''),
(3, 3, 21, 6, '0', '0', 3, 1, ''),
(4, 4, 21, 7, '0', '0', 4, 1, ''),
(5, 5, 21, 8, '0', '0', 5, 1, ''),
(6, 6, 21, 9, '0', '0', 6, 1, ''),
(7, 7, 21, 10, '0', '0', 7, 1, ''),
(8, 8, 21, 11, '0', '0', 8, 1, ''),
(9, 9, 21, 12, '0', '0', 9, 1, ''),
(10, 10, 21, 13, '0', '0', 10, 1, ''),
(11, 11, 21, 14, '0', '0', 11, 1, ''),
(12, 12, 21, 15, '0', '0', 12, 1, ''),
(13, 13, 21, 16, '0', '0', 13, 1, ''),
(14, 14, 21, 17, '0', '0', 14, 1, ''),
(15, 15, 21, 18, '0', '0', 15, 1, ''),
(16, 16, 21, 19, '0', '0', 16, 1, ''),
(17, 17, 21, 20, '0', '0', 17, 1, ''),
(18, 18, 21, 21, '0', '0', 18, 1, ''),
(19, 19, 21, 22, '0', '0', 19, 1, ''),
(20, 20, 21, 23, '0', '0', 20, 1, ''),
(21, 21, 21, 24, '0', '0', 21, 1, ''),
(22, 22, 21, 25, '0', '0', 22, 1, ''),
(23, 23, 21, 26, '0', '0', 23, 1, ''),
(24, 24, 21, 27, '0', '0', 24, 1, ''),
(25, 25, 21, 28, '0', '0', 25, 1, ''),
(26, 26, 21, 29, '0', '0', 26, 1, ''),
(27, 27, 21, 30, '0', '0', 27, 1, ''),
(28, 28, 21, 31, '0', '0', 28, 1, ''),
(29, 29, 21, 32, '0', '0', 29, 1, ''),
(30, 30, 21, 33, '0', '0', 30, 1, ''),
(31, 31, 21, 34, '0', '0', 31, 1, ''),
(32, 32, 21, 35, '0', '0', 32, 1, ''),
(33, 33, 21, 36, '0', '0', 33, 1, ''),
(34, 34, 21, 37, '0', '0', 34, 1, ''),
(35, 35, 21, 38, '0', '0', 35, 1, ''),
(36, 36, 21, 39, '0', '0', 36, 1, ''),
(37, 37, 21, 40, '0', '0', 37, 1, ''),
(38, 38, 21, 41, '0', '0', 38, 1, ''),
(39, 39, 21, 42, '0', '0', 39, 1, ''),
(40, 40, 21, 43, '0', '0', 40, 1, ''),
(41, 41, 21, 44, '0', '0', 41, 1, ''),
(42, 42, 21, 45, '0', '0', 42, 1, ''),
(43, 43, 21, 46, '0', '0', 43, 1, ''),
(44, 44, 21, 47, '0', '0', 44, 1, ''),
(45, 45, 21, 48, '0', '0', 45, 1, ''),
(46, 46, 21, 49, '0', '0', 46, 1, ''),
(47, 47, 21, 50, '0', '0', 47, 1, ''),
(48, 48, 21, 51, '0', '0', 48, 1, ''),
(49, 49, 21, 52, '0', '0', 49, 1, ''),
(50, 50, 21, 53, '0', '0', 50, 1, ''),
(51, 51, 21, 54, '0', '0', 51, 1, ''),
(52, 52, 21, 56, '0', '0', 52, 1, '');

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ps_tax_rules_group` (`id_tax_rules_group`, `name`, `active`, `deleted`, `date_add`, `date_upd`) VALUES
(1, 'US-AL Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(2, 'US-AK Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(3, 'US-AZ Rate (6.6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(4, 'US-AR Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(5, 'US-CA Rate (8.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(6, 'US-CO Rate (2.9%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(7, 'US-CT Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(8, 'US-DE Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(9, 'US-FL Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(10, 'US-GA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(11, 'US-HI Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(12, 'US-ID Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(13, 'US-IL Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(14, 'US-IN Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(15, 'US-IA Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(16, 'US-KS Rate (5.3%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(17, 'US-KY Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(18, 'US-LA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(19, 'US-ME Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(20, 'US-MD Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(21, 'US-MA Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(22, 'US-MI Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(23, 'US-MN Rate (6.875%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(24, 'US-MS Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(25, 'US-MO Rate (4.225%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(26, 'US-MT Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(27, 'US-NE Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(28, 'US-NV Rate (6.85%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(29, 'US-NH Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(30, 'US-NJ Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(31, 'US-NM Rate (5.125%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(32, 'US-NY Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(33, 'US-NC Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(34, 'US-ND Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(35, 'US-OH Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(36, 'US-OK Rate (4.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(37, 'US-OR Rate (0%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(38, 'US-PA Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(39, 'US-RI Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(40, 'US-SC Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(41, 'US-SD Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(42, 'US-TN Rate (7%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(43, 'US-TX Rate (6.25%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(44, 'US-UT Rate (4.75%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(45, 'US-VT Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(46, 'US-VA Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(47, 'US-WA Rate (6.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(48, 'US-WV Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(49, 'US-WI Rate (5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(50, 'US-WY Rate (4%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(51, 'US-PR Rate (5.5%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21'),
(52, 'US-DC Rate (6%)', 1, 0, '2025-07-15 22:52:21', '2025-07-15 22:52:21');

DROP TABLE IF EXISTS `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=utf8mb4 COLLATE=utf8mb4_general_ci;

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),
(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);


ALTER TABLE `ps_tax`
  ADD PRIMARY KEY (`id_tax`);

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`);

ALTER TABLE `ps_tax_rules_group`
  ADD PRIMARY KEY (`id_tax_rules_group`);

ALTER TABLE `ps_tax_rules_group_shop`
  ADD PRIMARY KEY (`id_tax_rules_group`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);


ALTER TABLE `ps_tax`
  MODIFY `id_tax` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

ALTER TABLE `ps_tax_rule`
  MODIFY `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

ALTER TABLE `ps_tax_rules_group`
  MODIFY `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

 

×
×
  • Create New...