12 lines
398 B
SQL
12 lines
398 B
SQL
DROP TABLE IF EXISTS `tax_rule`;
|
|
|
|
CREATE TABLE `tax_rule` (
|
|
`tax_rule_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`tax_type_id` INT UNSIGNED NOT NULL,
|
|
`tax_rate_id` INT UNSIGNED NOT NULL,
|
|
`based` varchar(10) NOT NULL,
|
|
`priority` int NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`tax_rule_id`),
|
|
KEY `tax_rule` (`tax_type_id`, `tax_rate_id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|