User:Woozle/Friendica/2017 upgrade/gcontact

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search

This SQL showed syntax errors in MySQL Workbench, but executed successfully nonetheless:<mysql>ALTER TABLE`gcontact` ADD COLUMN `nick` varchar(255) NOT NULL DEFAULT AFTER `name`, ADD COLUMN `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' AFTER `nick`, ADD COLUMN `updated` datetime DEFAULT '0001-01-01 00:00:00' AFTER `created`, ADD COLUMN `last_contact` datetime DEFAULT '0001-01-01 00:00:00' AFTER `updated`, ADD COLUMN `last_failure` datetime DEFAULT '0001-01-01 00:00:00' AFTER `last_contact`, ADD COLUMN `location` varchar(255) NOT NULL DEFAULT AFTER `last_failure`, ADD COLUMN `about` text AFTER `location`, ADD COLUMN `keywords` text AFTER `about`, ADD COLUMN `gender` varchar(32) NOT NULL DEFAULT AFTER `keywords`, ADD COLUMN `birthday` varchar(32) NOT NULL DEFAULT '0000-00-00' AFTER `gender`, ADD COLUMN `community` tinyint(1) NOT NULL DEFAULT 0 AFTER `birthday`, ADD COLUMN `contact-type` tinyint(1) NOT NULL DEFAULT -1 AFTER `community`, ADD COLUMN `hide` tinyint(1) NOT NULL DEFAULT 0 AFTER `contact-type`, ADD COLUMN `nsfw` tinyint(1) NOT NULL DEFAULT 0 AFTER `hide`, ADD COLUMN `network` varchar(255) NOT NULL DEFAULT AFTER `nsfw`, ADD COLUMN `addr` varchar(255) NOT NULL DEFAULT AFTER `network`, ADD COLUMN `notify` text AFTER `addr`, ADD COLUMN `alias` varchar(255) NOT NULL DEFAULT AFTER `notify`, ADD COLUMN `generation` tinyint(3) NOT NULL DEFAULT 0 AFTER `alias`, ADD COLUMN `server_url` varchar(255) NOT NULL DEFAULT AFTER `generation`, ADD INDEX `nick` (`nick`(32)), ADD INDEX `addr` (`addr`(64)), ADD INDEX `hide_network_updated` (`hide`,`network`,`updated`), ADD INDEX `updated` (`updated`)</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=User:Woozle/Friendica/2017_upgrade/gcontact&oldid=22483"