[Spce-user] [EXTERNAL] detect divergence in mysql schemes mr12.5.1

[Mykola Malkov]

Hello Alexander,

> *************************** 1. row ***************************
>       Table: voip_dom_preferences
> Create Table: CREATE TABLE `voip_dom_preferences` (
>   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
>  `domain_id` int(11) unsigned NOT NULL,
>  `attribute_id` int(11) unsigned NOT NULL,
>  `value` varchar(128) NOT NULL,
>  `modify_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON
UPDATE current_timestamp(),
>  PRIMARY KEY (`id`),
>  KEY `domidattrid_idx` (`domain_id`,`attribute_id`),
>  KEY `domainid_idx` (`domain_id`),
>  KEY `attributeid_idx` (`attribute_id`),
>  CONSTRAINT `v_d_p_attributeid_ref` FOREIGN KEY (`attribute_id`)
REFERENCES `voip_preferences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
>  CONSTRAINT `v_d_p_domainid_ref` FOREIGN KEY (`domain_id`) REFERENCES
`voip_domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB AUTO_INCREMENT=377 DEFAULT CHARSET=utf8mb3
COLLATE=utf8mb3_general_ci

Hmm, I see the table contains all required constraints. I'm checking why
there are *_ibfk_1 constraints in our files.

On Fri, Feb 28, 2025 at 4:38 PM Alexander Schwarz <schwarz at flow7.de> wrote:

> Hello Mykola Malkov,
>
> could you give us a quick status?
> Will it be resolved in further versions or is there a bugfix?
>
> Best regards,
>
> Alex
>


-- 
WBR
---
Mykola Malkov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20250304/15a3158e/attachment.htm>