63 lines
1.9 KiB
SQL
63 lines
1.9 KiB
SQL
|
|
# This is a fix for InnoDB in MySQL >= 4.1.x
|
|
# It "suspends judgement" for fkey relationships until are tables are set.
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ---------------------------------------------------------------------
|
|
-- rewriting_redirect_type
|
|
-- ---------------------------------------------------------------------
|
|
|
|
DROP TABLE IF EXISTS `rewriting_redirect_type`;
|
|
|
|
CREATE TABLE `rewriting_redirect_type`
|
|
(
|
|
`id` INTEGER NOT NULL,
|
|
`httpcode` INTEGER,
|
|
PRIMARY KEY (`id`),
|
|
CONSTRAINT `rewriting_redirect_type_FK_1`
|
|
FOREIGN KEY (`id`)
|
|
REFERENCES `rewriting_url` (`id`)
|
|
ON DELETE CASCADE
|
|
) ENGINE=InnoDB;
|
|
|
|
-- ---------------------------------------------------------------------
|
|
-- rewriteurl_rule
|
|
-- ---------------------------------------------------------------------
|
|
|
|
DROP TABLE IF EXISTS `rewriteurl_rule`;
|
|
|
|
CREATE TABLE `rewriteurl_rule`
|
|
(
|
|
`id` INTEGER NOT NULL AUTO_INCREMENT,
|
|
`rule_type` VARCHAR(64) NOT NULL,
|
|
`value` VARCHAR(255),
|
|
`only404` TINYINT(1) NOT NULL,
|
|
`redirect_url` VARCHAR(255) NOT NULL,
|
|
`position` INTEGER(255) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB;
|
|
|
|
-- ---------------------------------------------------------------------
|
|
-- rewriteurl_rule_param
|
|
-- ---------------------------------------------------------------------
|
|
|
|
DROP TABLE IF EXISTS `rewriteurl_rule_param`;
|
|
|
|
CREATE TABLE `rewriteurl_rule_param`
|
|
(
|
|
`id` INTEGER NOT NULL AUTO_INCREMENT,
|
|
`id_rule` INTEGER NOT NULL,
|
|
`param_name` VARCHAR(255) NOT NULL,
|
|
`param_condition` VARCHAR(64) NOT NULL,
|
|
`param_value` VARCHAR(255),
|
|
PRIMARY KEY (`id`),
|
|
INDEX `rewriteurl_rule_rule_param_FI_id` (`id_rule`),
|
|
CONSTRAINT `rewriteurl_rule_rule_param_FK_id`
|
|
FOREIGN KEY (`id_rule`)
|
|
REFERENCES `rewriteurl_rule` (`id`)
|
|
ON DELETE CASCADE
|
|
) ENGINE=InnoDB;
|
|
|
|
# This restores the fkey checks, after having unset them earlier
|
|
SET FOREIGN_KEY_CHECKS = 1;
|