13 lines
340 B
SQL
13 lines
340 B
SQL
DROP TABLE IF EXISTS `tax_rule`;
|
|
|
|
CREATE TABLE `tax_rule` (
|
|
`tax_rule_id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`tax_type_id` INT NOT NULL,
|
|
`tax_rate_id` INT NOT NULL,
|
|
`based` TEXT NOT NULL,
|
|
`priority` INTEGER NOT NULL DEFAULT '1'
|
|
-- PRIMARY KEY (`tax_rule_id`)
|
|
);
|
|
|
|
CREATE INDEX `tax_rule_index` ON `tax_rule` (`tax_type_id`, `tax_rate_id`);
|