I updated the diaspora* interface translation to my native language: Spanish (Argentina). I'm still in the top 5 on the list of top translators. 😀

Actualicé la traducción de la interfaz de diaspora* a mi idioma nativo, el español de Argentina. Todavía permanezco en el top 5 en la lista de mayores traductores. 😀

https://webtranslateit.com/

#diaspora #pods #dispersion #socialnetwork #social #hello #hola #newhere #freedom #freesoftware #posts #love #mywork #fediverse #podmin #question #publish #home #account #database #network #followme #followyou #users #top #webtranslateit

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
);