Question for the #MySQL / #MariaDB buffs, I have three tables defined thus:
CREATE TABLE IF NOT EXISTS `user` (
`uid` mediumint unsigned NOT NULL auto_increment COMMENT 'sequential ID',
...
PRIMARY KEY(`uid`)
);
CREATE TABLE IF NOT EXISTS `gserver` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
...
PRIMARY KEY(`id`)
);
CREATE TABLE IF NOT EXISTS `user-gserver` (
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
`gsid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Gserver id',
...
PRIMARY KEY(`uid`,`gsid`),
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
FOREIGN KEY (`gsid`) REFERENCES `gserver` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
); Running the last query triggers the error Foreign key constraint is incorrectly formed. Is there no way to reference multiple tables in foreign keys out of a compound primary key?
DBA a life in the shadows Database administration is weird. The job is a strange combination of theory and practice, strictness and loose rules mixed together in a magic blend.
The DBA is probably one of the most obscure and one of the less appreciated roles within the IT organisations.
Article claims #MariaDB's for-profit arm is headed for bankruptcy after a merger that the author claims was basically a hostile takeover. Fortunately, mariadb.com and the corporation don't own the crucial copyrights over the FLOSS code. Those are owned by mariadb.org and the foundation.
In the meantime, the new owners, having fired the founder (Monty, who also founded #MySQL) are now lawyering up in preparation for legions of lawsuits. Or at least, that's what the article says.
Kinda worried once it sat at "[Server] Server upgrade from '80030' to '80032' started." for longer than a few seconds cause I didn't know how long it was going to take.
With full joy I will be talking in #LibrePlanet 2023 about a free system for cataloguing challenging museum-libraries items like manuscripts and books with dedication/marginalia.
¿alguien me sabe recomendar alguna lectura o vídeo sobre las diferencias entre #oracle y #mysql? es para el curro, esque he preguntado en twitter y no me escribe nadie
Depending on my skills, available time, and whether the projects' CoCs are acceptable, I would also like to contribute to both #GNU_Social and #Friendica. I know both projects can use a little additional momentum.