Revize ed986471
Přidáno uživatelem Ondřej Fibich před téměř 6 roky(ů)
| db_upgrades/upgrade_1.1.0.php | ||
|---|---|---|
|
`comments_thread_id` INT NULL DEFAULT NULL ,
|
||
|
PRIMARY KEY ( `id` ),
|
||
|
FOREIGN KEY `closed_by_user_id_fk` (`closed_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
|
||
|
FOREIGN KEY `comments_thread_id_fk` (`comments_thread_id`) REFERENCES `comments_threads` (`id`) ON DELETE SET NULL
|
||
|
FOREIGN KEY `log_queues_comments_thread_id_fk` (`comments_thread_id`) REFERENCES `comments_threads` (`id`) ON DELETE SET NULL
|
||
|
) ENGINE = InnoDB;",
|
||
|
|
||
|
/**
|
||
| ... | ... | |
|
PRIMARY KEY (`id`),
|
||
|
INDEX `since_index` (`since`),
|
||
|
INDEX `until` (`until`),
|
||
|
FOREIGN KEY `member_id_fk` (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE
|
||
|
FOREIGN KEY `members_whitelists_member_id_fk` (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE
|
||
|
) ENGINE = InnoDB COMMENT = 'Redirection member white list.';",
|
||
|
/* Import old data */
|
||
|
// association
|
||
Také k dispozici: Unified diff
Refs #1101: Support for Debian Stretch (PHP 7.0 + Maria DB 15.1). Improved setup that no longer support database creation (in Maria DB it is hard to do so from non-root user due to security restrictions), database setup error cause was added, disabling Settings DB queries in non-setup environment. In order to fix DB init some FK indexes/constrains must have been renamed in 1.1.0 SQL script (Maria DB enforces uniqueness on FK names).