https://htyp.org/mw/index.php?action=history&feed=atom&title=User%3AWoozle%2FFriendica%2F2017_upgrade%2Fgcontact 2026-09-24T23:12:03Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=User:Woozle/Friendica/2017_upgrade/gcontact&diff=22483&oldid=prev 2017-04-08T19:07:53Z

<p>Created page with &quot;This SQL showed syntax errors in <a href="/MySQL_Workbench" title="MySQL Workbench">MySQL Workbench</a>, but executed successfully nonetheless:&lt;mysql&gt;ALTER TABLE`gcontact` ADD COLUMN `nick` varchar(255) NOT NULL DEFAULT &#039;&#039; AFT...&quot;</p> <p><b>New page</b></p><div>This SQL showed syntax errors in [[MySQL Workbench]], but executed successfully nonetheless:&lt;mysql&gt;ALTER TABLE`gcontact`<br /> ADD COLUMN `nick` varchar(255) NOT NULL DEFAULT &#039;&#039; AFTER `name`,<br /> ADD COLUMN `created` datetime NOT NULL DEFAULT &#039;0001-01-01 00:00:00&#039; AFTER `nick`,<br /> ADD COLUMN `updated` datetime DEFAULT &#039;0001-01-01 00:00:00&#039; AFTER `created`,<br /> ADD COLUMN `last_contact` datetime DEFAULT &#039;0001-01-01 00:00:00&#039; AFTER `updated`,<br /> ADD COLUMN `last_failure` datetime DEFAULT &#039;0001-01-01 00:00:00&#039; AFTER `last_contact`,<br /> ADD COLUMN `location` varchar(255) NOT NULL DEFAULT &#039;&#039; AFTER `last_failure`,<br /> ADD COLUMN `about` text AFTER `location`,<br /> ADD COLUMN `keywords` text AFTER `about`,<br /> ADD COLUMN `gender` varchar(32) NOT NULL DEFAULT &#039;&#039; AFTER `keywords`,<br /> ADD COLUMN `birthday` varchar(32) NOT NULL DEFAULT &#039;0000-00-00&#039; AFTER `gender`,<br /> ADD COLUMN `community` tinyint(1) NOT NULL DEFAULT 0 AFTER `birthday`,<br /> ADD COLUMN `contact-type` tinyint(1) NOT NULL DEFAULT -1 AFTER `community`,<br /> ADD COLUMN `hide` tinyint(1) NOT NULL DEFAULT 0 AFTER `contact-type`,<br /> ADD COLUMN `nsfw` tinyint(1) NOT NULL DEFAULT 0 AFTER `hide`,<br /> ADD COLUMN `network` varchar(255) NOT NULL DEFAULT &#039;&#039; AFTER `nsfw`,<br /> ADD COLUMN `addr` varchar(255) NOT NULL DEFAULT &#039;&#039; AFTER `network`,<br /> ADD COLUMN `notify` text AFTER `addr`,<br /> ADD COLUMN `alias` varchar(255) NOT NULL DEFAULT &#039;&#039; AFTER `notify`,<br /> ADD COLUMN `generation` tinyint(3) NOT NULL DEFAULT 0 AFTER `alias`,<br /> ADD COLUMN `server_url` varchar(255) NOT NULL DEFAULT &#039;&#039; AFTER `generation`,<br /> ADD INDEX `nick` (`nick`(32)),<br /> ADD INDEX `addr` (`addr`(64)),<br /> ADD INDEX `hide_network_updated` (`hide`,`network`,`updated`),<br /> ADD INDEX `updated` (`updated`)&lt;/mysql&gt;</div>

Woozle