fix a merge mixup on install/schema_msyql.php

1 files changed, 230 insertions, 230 deletions

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 4de9c0917..0d3ca2e71 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -15,26 +15,26 @@ CREATE TABLE IF NOT EXISTS `abconfig` (
 
 CREATE TABLE IF NOT EXISTS `abook` (
   `abook_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `abook_account` int(10) unsigned NOT NULL DEFAULT '0',
-  `abook_channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `abook_account` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `abook_channel` int(10) unsigned NOT NULL DEFAULT 0 ,
   `abook_xchan` char(191) NOT NULL DEFAULT '',
-  `abook_my_perms` int(11) NOT NULL DEFAULT '0',
-  `abook_their_perms` int(11) NOT NULL DEFAULT '0',
-  `abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT '99',
+  `abook_my_perms` int(11) NOT NULL DEFAULT 0 ,
+  `abook_their_perms` int(11) NOT NULL DEFAULT 0 ,
+  `abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT 99,
   `abook_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `abook_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `abook_connected` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `abook_dob` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `abook_flags` int(11) NOT NULL DEFAULT '0',
-  `abook_blocked` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_ignored` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_hidden` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_archived` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_pending` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_unconnected` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_self` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_feed` tinyint(4) NOT NULL DEFAULT '0',
-  `abook_not_here` tinyint(4) NOT NULL DEFAULT '0',
+  `abook_flags` int(11) NOT NULL DEFAULT 0 ,
+  `abook_blocked` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_ignored` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_hidden` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_archived` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_pending` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_unconnected` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_self` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_feed` tinyint(4) NOT NULL DEFAULT 0 ,
+  `abook_not_here` tinyint(4) NOT NULL DEFAULT 0 ,
   `abook_profile` char(191) NOT NULL DEFAULT '',
   `abook_incl` TEXT NOT NULL,
   `abook_excl` TEXT NOT NULL,
@@ -63,8 +63,8 @@ CREATE TABLE IF NOT EXISTS `abook` (
 
 CREATE TABLE IF NOT EXISTS `account` (
   `account_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `account_parent` int(10) unsigned NOT NULL DEFAULT '0',
-  `account_default_channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `account_parent` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `account_default_channel` int(10) unsigned NOT NULL DEFAULT 0 ,
   `account_salt` char(32) NOT NULL DEFAULT '',
   `account_password` char(191) NOT NULL DEFAULT '',
   `account_email` char(191) NOT NULL DEFAULT '',
@@ -72,13 +72,13 @@ CREATE TABLE IF NOT EXISTS `account` (
   `account_language` char(16) NOT NULL DEFAULT 'en',
   `account_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `account_lastlog` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `account_flags` int(10) unsigned NOT NULL DEFAULT '0',
-  `account_roles` int(10) unsigned NOT NULL DEFAULT '0',
+  `account_flags` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `account_roles` int(10) unsigned NOT NULL DEFAULT 0 ,
   `account_reset` char(191) NOT NULL DEFAULT '',
   `account_expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `account_expire_notified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `account_service_class` char(32) NOT NULL DEFAULT '',
-  `account_level` int(10) unsigned NOT NULL DEFAULT '0',
+  `account_level` int(10) unsigned NOT NULL DEFAULT 0 ,
   `account_password_changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   PRIMARY KEY (`account_id`),
   KEY `account_email` (`account_email`),
@@ -98,10 +98,10 @@ CREATE TABLE IF NOT EXISTS `addon` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `aname` char(191) NOT NULL DEFAULT '',
   `version` char(191) NOT NULL DEFAULT '',
-  `installed` tinyint(1) NOT NULL DEFAULT '0',
-  `hidden` tinyint(1) NOT NULL DEFAULT '0',
-  `tstamp` bigint(20) NOT NULL DEFAULT '0',
-  `plugin_admin` tinyint(1) NOT NULL DEFAULT '0',
+  `installed` tinyint(1) NOT NULL DEFAULT 0 ,
+  `hidden` tinyint(1) NOT NULL DEFAULT 0 ,
+  `tstamp` bigint(20) NOT NULL DEFAULT 0 ,
+  `plugin_admin` tinyint(1) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
   KEY `hidden` (`hidden`),
   KEY `aname` (`aname`),
@@ -118,13 +118,13 @@ CREATE TABLE IF NOT EXISTS `app` (
   `app_url` char(191) NOT NULL DEFAULT '',
   `app_photo` char(191) NOT NULL DEFAULT '',
   `app_version` char(191) NOT NULL DEFAULT '',
-  `app_channel` int(11) NOT NULL DEFAULT '0',
+  `app_channel` int(11) NOT NULL DEFAULT 0 ,
   `app_addr` char(191) NOT NULL DEFAULT '',
   `app_price` char(191) NOT NULL DEFAULT '',
   `app_page` char(191) NOT NULL DEFAULT '',
   `app_requires` char(191) NOT NULL DEFAULT '',
-  `app_deleted` int(11) NOT NULL DEFAULT '0',
-  `app_system` int(11) NOT NULL DEFAULT '0',
+  `app_deleted` int(11) NOT NULL DEFAULT 0 ,
+  `app_system` int(11) NOT NULL DEFAULT 0 ,
   `app_plugin` char(191) NOT NULL DEFAULT '',
   `app_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `app_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -145,8 +145,8 @@ CREATE TABLE IF NOT EXISTS `app` (
 
 CREATE TABLE IF NOT EXISTS `atoken` (
   `atoken_id` int(11) NOT NULL AUTO_INCREMENT,
-  `atoken_aid` int(11) NOT NULL DEFAULT 0,
-  `atoken_uid` int(11) NOT NULL DEFAULT 0,
+  `atoken_aid` int(11) NOT NULL DEFAULT 0 ,
+  `atoken_uid` int(11) NOT NULL DEFAULT 0 ,
   `atoken_name` char(191) NOT NULL DEFAULT '',
   `atoken_token` char(191) NOT NULL DEFAULT '',
   `atoken_expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -161,19 +161,19 @@ CREATE TABLE IF NOT EXISTS `atoken` (
 
 CREATE TABLE IF NOT EXISTS `attach` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
+  `aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `hash` char(191) NOT NULL DEFAULT '',
   `creator` char(191) NOT NULL DEFAULT '',
   `filename` char(191) NOT NULL DEFAULT '',
   `filetype` char(191) NOT NULL DEFAULT '',
-  `filesize` int(10) unsigned NOT NULL DEFAULT '0',
-  `revision` int(10) unsigned NOT NULL DEFAULT '0',
+  `filesize` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `revision` int(10) unsigned NOT NULL DEFAULT 0 ,
   `folder` char(191) NOT NULL DEFAULT '',
-  `flags` int(10) unsigned NOT NULL DEFAULT '0',
-  `is_dir` tinyint(1) NOT NULL DEFAULT '0',
-  `is_photo` tinyint(1) NOT NULL DEFAULT '0',
-  `os_storage` tinyint(1) NOT NULL DEFAULT '0',
+  `flags` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `is_dir` tinyint(1) NOT NULL DEFAULT 0 ,
+  `is_photo` tinyint(1) NOT NULL DEFAULT 0 ,
+  `os_storage` tinyint(1) NOT NULL DEFAULT 0 ,
   `os_path` mediumtext NOT NULL,
   `display_path` mediumtext NOT NULL,
   `content` longblob NOT NULL,
@@ -205,7 +205,7 @@ CREATE TABLE IF NOT EXISTS `auth_codes` (
   `id` varchar(40) NOT NULL DEFAULT '',
   `client_id` varchar(20) NOT NULL DEFAULT '',
   `redirect_uri` varchar(200) NOT NULL DEFAULT '',
-  `expires` int(11) NOT NULL DEFAULT '0',
+  `expires` int(11) NOT NULL DEFAULT 0 ,
   `auth_scope` varchar(512) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
@@ -219,8 +219,8 @@ CREATE TABLE IF NOT EXISTS `cache` (
 
 CREATE TABLE IF NOT EXISTS `cal` (
   `cal_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `cal_aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `cal_uid` int(10) unsigned NOT NULL DEFAULT '0',
+  `cal_aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `cal_uid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `cal_hash` varchar(191) NOT NULL DEFAULT '',
   `cal_name` varchar(191) NOT NULL DEFAULT '',
   `uri` varchar(191) NOT NULL DEFAULT '',
@@ -239,8 +239,8 @@ CREATE TABLE IF NOT EXISTS `cal` (
 
 CREATE TABLE IF NOT EXISTS `channel` (
   `channel_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `channel_account_id` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_primary` tinyint(1) unsigned NOT NULL DEFAULT '0',
+  `channel_account_id` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_primary` tinyint(1) unsigned NOT NULL DEFAULT 0 ,
   `channel_name` char(191) NOT NULL DEFAULT '',
   `channel_address` char(191) NOT NULL DEFAULT '',
   `channel_guid` char(191) NOT NULL DEFAULT '',
@@ -252,40 +252,40 @@ CREATE TABLE IF NOT EXISTS `channel` (
   `channel_startpage` char(191) NOT NULL DEFAULT '',
   `channel_pubkey` text NOT NULL,
   `channel_prvkey` text NOT NULL,
-  `channel_notifyflags` int(10) unsigned NOT NULL DEFAULT '65535',
-  `channel_pageflags` int(10) unsigned NOT NULL DEFAULT '0',
+  `channel_notifyflags` int(10) unsigned NOT NULL DEFAULT 65535,
+  `channel_pageflags` int(10) unsigned NOT NULL DEFAULT 0 ,
   `channel_dirdate` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `channel_lastpost` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `channel_deleted` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `channel_max_anon_mail` int(10) unsigned NOT NULL DEFAULT '10',
-  `channel_max_friend_req` int(10) unsigned NOT NULL DEFAULT '10',
-  `channel_expire_days` int(11) NOT NULL DEFAULT '0',
+  `channel_max_anon_mail` int(10) unsigned NOT NULL DEFAULT 10,
+  `channel_max_friend_req` int(10) unsigned NOT NULL DEFAULT 10,
+  `channel_expire_days` int(11) NOT NULL DEFAULT 0 ,
   `channel_passwd_reset` char(191) NOT NULL DEFAULT '',
   `channel_default_group` char(191) NOT NULL DEFAULT '',
   `channel_allow_cid` mediumtext NOT NULL,
   `channel_allow_gid` mediumtext NOT NULL,
   `channel_deny_cid` mediumtext NOT NULL,
   `channel_deny_gid` mediumtext NOT NULL,
-  `channel_r_stream` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_r_profile` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_r_photos` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_r_abook` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_stream` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_wall` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_comment` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_mail` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_photos` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_chat` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_r_storage` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_storage` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_r_pages` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_pages` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_a_republish` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_w_like` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_removed` tinyint(1) NOT NULL DEFAULT '0',
-  `channel_system` tinyint(1) NOT NULL DEFAULT '0',
+  `channel_r_stream` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_r_profile` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_r_photos` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_r_abook` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_stream` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_wall` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_comment` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_mail` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_photos` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_chat` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_r_storage` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_storage` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_r_pages` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_pages` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_a_republish` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_w_like` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_removed` tinyint(1) NOT NULL DEFAULT 0 ,
+  `channel_system` tinyint(1) NOT NULL DEFAULT 0 ,
   `channel_moved` char(191) NOT NULL DEFAULT '',
   `channel_password` varchar(191) NOT NULL,
   `channel_salt` varchar(191) NOT NULL,
@@ -315,7 +315,7 @@ CREATE TABLE IF NOT EXISTS `channel` (
 
 CREATE TABLE IF NOT EXISTS `chat` (
   `chat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `chat_room` int(10) unsigned NOT NULL DEFAULT '0',
+  `chat_room` int(10) unsigned NOT NULL DEFAULT 0 ,
   `chat_xchan` char(191) NOT NULL DEFAULT '',
   `chat_text` mediumtext NOT NULL,
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -327,7 +327,7 @@ CREATE TABLE IF NOT EXISTS `chat` (
 
 CREATE TABLE IF NOT EXISTS `chatpresence` (
   `cp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `cp_room` int(10) unsigned NOT NULL DEFAULT '0',
+  `cp_room` int(10) unsigned NOT NULL DEFAULT 0 ,
   `cp_xchan` char(191) NOT NULL DEFAULT '',
   `cp_last` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `cp_status` char(191) NOT NULL DEFAULT '',
@@ -341,12 +341,12 @@ CREATE TABLE IF NOT EXISTS `chatpresence` (
 
 CREATE TABLE IF NOT EXISTS `chatroom` (
   `cr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `cr_aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `cr_uid` int(10) unsigned NOT NULL DEFAULT '0',
+  `cr_aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `cr_uid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `cr_name` char(191) NOT NULL DEFAULT '',
   `cr_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `cr_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `cr_expire` int(10) unsigned NOT NULL DEFAULT '0',
+  `cr_expire` int(10) unsigned NOT NULL DEFAULT 0 ,
   `allow_cid` mediumtext NOT NULL,
   `allow_gid` mediumtext NOT NULL,
   `deny_cid` mediumtext NOT NULL,
@@ -366,7 +366,7 @@ CREATE TABLE IF NOT EXISTS `clients` (
   `redirect_uri` varchar(200) NOT NULL DEFAULT '',
   `clname` text,
   `icon` text,
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`client_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
@@ -383,7 +383,7 @@ CREATE TABLE IF NOT EXISTS `conv` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `guid` char(191) NOT NULL DEFAULT '',
   `recips` mediumtext NOT NULL,
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   `creator` char(191) NOT NULL DEFAULT '',
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -395,7 +395,7 @@ CREATE TABLE IF NOT EXISTS `conv` (
 
 CREATE TABLE IF NOT EXISTS `dreport` (
   `dreport_id` int(11) NOT NULL AUTO_INCREMENT,
-  `dreport_channel` int(11) NOT NULL DEFAULT '0',
+  `dreport_channel` int(11) NOT NULL DEFAULT 0 ,
   `dreport_mid` char(191) NOT NULL DEFAULT '',
   `dreport_site` char(191) NOT NULL DEFAULT '',
   `dreport_recip` char(191) NOT NULL DEFAULT '',
@@ -414,9 +414,9 @@ CREATE TABLE IF NOT EXISTS `dreport` (
 
 CREATE TABLE IF NOT EXISTS `event` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `uid` int(11) NOT NULL DEFAULT '0',
-  `cal_id` int(11) unsigned NOT NULL DEFAULT '0',
+  `aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `uid` int(11) NOT NULL DEFAULT 0 ,
+  `cal_id` int(11) unsigned NOT NULL DEFAULT 0 ,
   `event_xchan` char(191) NOT NULL DEFAULT '',
   `event_hash` char(191) NOT NULL DEFAULT '',
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -427,19 +427,19 @@ CREATE TABLE IF NOT EXISTS `event` (
   `description` text NOT NULL,
   `location` text NOT NULL,
   `etype` char(191) NOT NULL DEFAULT '',
-  `nofinish` tinyint(1) NOT NULL DEFAULT '0',
-  `adjust` tinyint(1) NOT NULL DEFAULT '1',
-  `dismissed` tinyint(1) NOT NULL DEFAULT '0',
+  `nofinish` tinyint(1) NOT NULL DEFAULT 0 ,
+  `adjust` tinyint(1) NOT NULL DEFAULT 1,
+  `dismissed` tinyint(1) NOT NULL DEFAULT 0 ,
   `allow_cid` mediumtext NOT NULL,
   `allow_gid` mediumtext NOT NULL,
   `deny_cid` mediumtext NOT NULL,
   `deny_gid` mediumtext NOT NULL,
   `event_status` char(191) NOT NULL DEFAULT '',
   `event_status_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `event_percent` smallint(6) NOT NULL DEFAULT '0',
+  `event_percent` smallint(6) NOT NULL DEFAULT 0 ,
   `event_repeat` text NOT NULL,
-  `event_sequence` smallint(6) NOT NULL DEFAULT '0',
-  `event_priority` smallint(6) NOT NULL DEFAULT '0',
+  `event_sequence` smallint(6) NOT NULL DEFAULT 0 ,
+  `event_priority` smallint(6) NOT NULL DEFAULT 0 ,
   `event_vdata` text NOT NULL,
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
@@ -461,9 +461,9 @@ CREATE TABLE IF NOT EXISTS `event` (
 CREATE TABLE IF NOT EXISTS `groups` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `hash` char(191) NOT NULL DEFAULT '',
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
-  `visible` tinyint(1) NOT NULL DEFAULT '0',
-  `deleted` tinyint(1) NOT NULL DEFAULT '0',
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `visible` tinyint(1) NOT NULL DEFAULT 0 ,
+  `deleted` tinyint(1) NOT NULL DEFAULT 0 ,
   `gname` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
@@ -475,8 +475,8 @@ CREATE TABLE IF NOT EXISTS `groups` (
 
 CREATE TABLE IF NOT EXISTS `group_member` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
-  `gid` int(10) unsigned NOT NULL DEFAULT '0',
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `gid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `xchan` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
@@ -489,8 +489,8 @@ CREATE TABLE IF NOT EXISTS `hook` (
   `hook` char(191) NOT NULL DEFAULT '',
   `file` char(191) NOT NULL DEFAULT '',
   `fn` char(191) NOT NULL DEFAULT '',
-  `priority` smallint NOT NULL DEFAULT '0',
-  `hook_version` int(11) NOT NULL DEFAULT '0',
+  `priority` smallint NOT NULL DEFAULT 0 ,
+  `hook_version` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
   KEY `hook` (`hook`),
   KEY `priority` (`priority`),
@@ -504,8 +504,8 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
   `hubloc_hash` char(191) NOT NULL DEFAULT '',
   `hubloc_addr` char(191) NOT NULL DEFAULT '',
   `hubloc_network` char(32) NOT NULL DEFAULT '',
-  `hubloc_flags` int(10) unsigned NOT NULL DEFAULT '0',
-  `hubloc_status` int(10) unsigned NOT NULL DEFAULT '0',
+  `hubloc_flags` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `hubloc_status` int(10) unsigned NOT NULL DEFAULT 0 ,
   `hubloc_url` char(191) NOT NULL DEFAULT '',
   `hubloc_url_sig` text NOT NULL,
   `hubloc_host` char(191) NOT NULL DEFAULT '',
@@ -514,10 +514,10 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
   `hubloc_sitekey` text NOT NULL,
   `hubloc_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `hubloc_connected` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `hubloc_primary` tinyint(1) NOT NULL DEFAULT '0',
-  `hubloc_orphancheck` tinyint(1) NOT NULL DEFAULT '0',
-  `hubloc_error` tinyint(1) NOT NULL DEFAULT '0',
-  `hubloc_deleted` tinyint(1) NOT NULL DEFAULT '0',
+  `hubloc_primary` tinyint(1) NOT NULL DEFAULT 0 ,
+  `hubloc_orphancheck` tinyint(1) NOT NULL DEFAULT 0 ,
+  `hubloc_error` tinyint(1) NOT NULL DEFAULT 0 ,
+  `hubloc_deleted` tinyint(1) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`hubloc_id`),
   KEY `hubloc_url` (`hubloc_url`),
   KEY `hubloc_guid` (`hubloc_guid`),
@@ -539,11 +539,11 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
 
 CREATE TABLE IF NOT EXISTS `iconfig` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `iid` int(11) NOT NULL DEFAULT '0',
+  `iid` int(11) NOT NULL DEFAULT 0 ,
   `cat` char(191) NOT NULL DEFAULT '',
   `k` char(191) NOT NULL DEFAULT '',
   `v` mediumtext NOT NULL,
-  `sharing` int(11) NOT NULL DEFAULT '0',
+  `sharing` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
   KEY `iid` (`iid`),
   KEY `cat` (`cat`),
@@ -556,8 +556,8 @@ CREATE TABLE IF NOT EXISTS `issue` (
   `issue_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `issue_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `issue_assigned` char(191) NOT NULL DEFAULT '',
-  `issue_priority` int(11) NOT NULL DEFAULT '0',
-  `issue_status` int(11) NOT NULL DEFAULT '0',
+  `issue_priority` int(11) NOT NULL DEFAULT 0 ,
+  `issue_status` int(11) NOT NULL DEFAULT 0 ,
   `issue_component` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`issue_id`),
   KEY `issue_created` (`issue_created`),
@@ -571,9 +571,9 @@ CREATE TABLE IF NOT EXISTS `issue` (
 CREATE TABLE IF NOT EXISTS `item` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `mid` char(191) NOT NULL DEFAULT '',
-  `aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
-  `parent` int(10) unsigned NOT NULL DEFAULT '0',
+  `aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `parent` int(10) unsigned NOT NULL DEFAULT 0 ,
   `parent_mid` char(191) NOT NULL DEFAULT '',
   `thr_parent` char(191) NOT NULL DEFAULT '',
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -592,7 +592,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `html` mediumtext NOT NULL,
   `app` char(191) NOT NULL DEFAULT '',
   `lang` char(64) NOT NULL DEFAULT '',
-  `revision` int(10) unsigned NOT NULL DEFAULT '0',
+  `revision` int(10) unsigned NOT NULL DEFAULT 0 ,
   `verb` char(191) NOT NULL DEFAULT '',
   `obj_type` char(191) NOT NULL DEFAULT '',
   `obj` text NOT NULL,
@@ -615,32 +615,32 @@ CREATE TABLE IF NOT EXISTS `item` (
   `allow_gid` mediumtext NOT NULL,
   `deny_cid` mediumtext NOT NULL,
   `deny_gid` mediumtext NOT NULL,
-  `item_restrict` int(11) NOT NULL DEFAULT '0',
-  `item_flags` int(11) NOT NULL DEFAULT '0',
-  `item_private` tinyint(1) NOT NULL DEFAULT '0',
-  `item_origin` tinyint(1) NOT NULL DEFAULT '0',
-  `item_unseen` tinyint(1) NOT NULL DEFAULT '0',
-  `item_starred` tinyint(1) NOT NULL DEFAULT '0',
-  `item_uplink` tinyint(1) NOT NULL DEFAULT '0',
-  `item_consensus` tinyint(1) NOT NULL DEFAULT '0',
-  `item_wall` tinyint(1) NOT NULL DEFAULT '0',
-  `item_thread_top` tinyint(1) NOT NULL DEFAULT '0',
-  `item_notshown` tinyint(1) NOT NULL DEFAULT '0',
-  `item_nsfw` tinyint(1) NOT NULL DEFAULT '0',
-  `item_relay` tinyint(1) NOT NULL DEFAULT '0',
-  `item_mentionsme` tinyint(1) NOT NULL DEFAULT '0',
-  `item_nocomment` tinyint(1) NOT NULL DEFAULT '0',
-  `item_obscured` tinyint(1) NOT NULL DEFAULT '0',
-  `item_verified` tinyint(1) NOT NULL DEFAULT '0',
-  `item_retained` tinyint(1) NOT NULL DEFAULT '0',
-  `item_rss` tinyint(1) NOT NULL DEFAULT '0',
-  `item_deleted` tinyint(1) NOT NULL DEFAULT '0',
-  `item_type` int(11) NOT NULL DEFAULT '0',
-  `item_hidden` tinyint(1) NOT NULL DEFAULT '0',
-  `item_unpublished` tinyint(1) NOT NULL DEFAULT '0',
-  `item_delayed` tinyint(1) NOT NULL DEFAULT '0',
-  `item_pending_remove` tinyint(1) NOT NULL DEFAULT '0',
-  `item_blocked` tinyint(1) NOT NULL DEFAULT '0',
+  `item_restrict` int(11) NOT NULL DEFAULT 0 ,
+  `item_flags` int(11) NOT NULL DEFAULT 0 ,
+  `item_private` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_origin` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_unseen` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_starred` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_uplink` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_consensus` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_wall` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_thread_top` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_notshown` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_nsfw` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_relay` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_mentionsme` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_nocomment` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_obscured` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_verified` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_retained` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_rss` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_deleted` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_type` int(11) NOT NULL DEFAULT 0 ,
+  `item_hidden` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_unpublished` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_delayed` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_pending_remove` tinyint(1) NOT NULL DEFAULT 0 ,
+  `item_blocked` tinyint(1) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
   KEY `parent` (`parent`),
@@ -697,8 +697,8 @@ CREATE TABLE IF NOT EXISTS `item` (
 
 CREATE TABLE IF NOT EXISTS `item_id` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `iid` int(11) NOT NULL DEFAULT '0',
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `iid` int(11) NOT NULL DEFAULT 0 ,
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   `sid` char(191) NOT NULL DEFAULT '',
   `service` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
@@ -710,10 +710,10 @@ CREATE TABLE IF NOT EXISTS `item_id` (
 
 CREATE TABLE IF NOT EXISTS `likes` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `channel_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `channel_id` int(10) unsigned NOT NULL DEFAULT 0 ,
   `liker` char(191) NOT NULL DEFAULT '',
   `likee` char(191) NOT NULL DEFAULT '',
-  `iid` int(11) unsigned NOT NULL DEFAULT '0',
+  `iid` int(11) unsigned NOT NULL DEFAULT 0 ,
   `i_mid` char(191) NOT NULL DEFAULT '',
   `verb` char(191) NOT NULL DEFAULT '',
   `target_type` char(191) NOT NULL DEFAULT '',
@@ -732,13 +732,13 @@ CREATE TABLE IF NOT EXISTS `likes` (
 
 CREATE TABLE IF NOT EXISTS `mail` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `convid` int(10) unsigned NOT NULL DEFAULT '0',
+  `convid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `conv_guid` char(191) NOT NULL DEFAULT '',
-  `mail_flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `mail_flags` int(10) unsigned NOT NULL DEFAULT 0 ,
   `from_xchan` char(191) NOT NULL DEFAULT '',
   `to_xchan` char(191) NOT NULL DEFAULT '',
-  `account_id` int(10) unsigned NOT NULL DEFAULT '0',
-  `channel_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `account_id` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `channel_id` int(10) unsigned NOT NULL DEFAULT 0 ,
   `mail_mimetype` char(64) NOT NULL DEFAULT 'text/bbcode',
   `title` text NOT NULL,
   `body` mediumtext NOT NULL,
@@ -746,13 +746,13 @@ CREATE TABLE IF NOT EXISTS `mail` (
   `attach` mediumtext NOT NULL,
   `mid` char(191) NOT NULL DEFAULT '',
   `parent_mid` char(191) NOT NULL DEFAULT '',
-  `mail_deleted` tinyint(4) NOT NULL DEFAULT '0',
-  `mail_replied` tinyint(4) NOT NULL DEFAULT '0',
-  `mail_isreply` tinyint(4) NOT NULL DEFAULT '0',
-  `mail_seen` tinyint(4) NOT NULL DEFAULT '0',
-  `mail_recalled` tinyint(4) NOT NULL DEFAULT '0',
-  `mail_obscured` smallint(6) NOT NULL DEFAULT '0',
-  `mail_raw` tinyint(4) NOT NULL DEFAULT '0',
+  `mail_deleted` tinyint(4) NOT NULL DEFAULT 0 ,
+  `mail_replied` tinyint(4) NOT NULL DEFAULT 0 ,
+  `mail_isreply` tinyint(4) NOT NULL DEFAULT 0 ,
+  `mail_seen` tinyint(4) NOT NULL DEFAULT 0 ,
+  `mail_recalled` tinyint(4) NOT NULL DEFAULT 0 ,
+  `mail_obscured` smallint(6) NOT NULL DEFAULT 0 ,
+  `mail_raw` tinyint(4) NOT NULL DEFAULT 0 ,
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   PRIMARY KEY (`id`),
@@ -777,10 +777,10 @@ CREATE TABLE IF NOT EXISTS `mail` (
 
 CREATE TABLE IF NOT EXISTS `menu` (
   `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `menu_channel_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `menu_channel_id` int(10) unsigned NOT NULL DEFAULT 0 ,
   `menu_name` char(191) NOT NULL DEFAULT '',
   `menu_desc` char(191) NOT NULL DEFAULT '',
-  `menu_flags` int(11) NOT NULL DEFAULT '0',
+  `menu_flags` int(11) NOT NULL DEFAULT 0 ,
   `menu_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `menu_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   PRIMARY KEY (`menu_id`),
@@ -795,14 +795,14 @@ CREATE TABLE IF NOT EXISTS `menu_item` (
   `mitem_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `mitem_link` char(191) NOT NULL DEFAULT '',
   `mitem_desc` char(191) NOT NULL DEFAULT '',
-  `mitem_flags` int(11) NOT NULL DEFAULT '0',
+  `mitem_flags` int(11) NOT NULL DEFAULT 0 ,
   `allow_cid` mediumtext NOT NULL,
   `allow_gid` mediumtext NOT NULL,
   `deny_cid` mediumtext NOT NULL,
   `deny_gid` mediumtext NOT NULL,
-  `mitem_channel_id` int(10) unsigned NOT NULL DEFAULT '0',
-  `mitem_menu_id` int(10) unsigned NOT NULL DEFAULT '0',
-  `mitem_order` int(11) NOT NULL DEFAULT '0',
+  `mitem_channel_id` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `mitem_menu_id` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `mitem_order` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`mitem_id`),
   KEY `mitem_channel_id` (`mitem_channel_id`),
   KEY `mitem_menu_id` (`mitem_menu_id`),
@@ -817,12 +817,12 @@ CREATE TABLE IF NOT EXISTS `notify` (
   `photo` char(191) NOT NULL DEFAULT '',
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `msg` mediumtext NOT NULL,
-  `aid` int(11) NOT NULL DEFAULT '0',
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `aid` int(11) NOT NULL DEFAULT 0 ,
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   `link` char(191) NOT NULL DEFAULT '',
   `parent` char(191) NOT NULL DEFAULT '',
-  `seen` tinyint(1) NOT NULL DEFAULT '0',
-  `ntype` int(11) NOT NULL DEFAULT '0',
+  `seen` tinyint(1) NOT NULL DEFAULT 0 ,
+  `ntype` int(11) NOT NULL DEFAULT 0 ,
   `verb` char(191) NOT NULL DEFAULT '',
   `otype` char(16) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
@@ -841,15 +841,15 @@ CREATE TABLE IF NOT EXISTS `obj` (
   `obj_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `obj_page` char(64) NOT NULL DEFAULT '',
   `obj_verb` char(191) NOT NULL DEFAULT '',
-  `obj_type` int(10) unsigned NOT NULL DEFAULT '0',
+  `obj_type` int(10) unsigned NOT NULL DEFAULT 0 ,
   `obj_obj` char(191) NOT NULL DEFAULT '',
-  `obj_channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `obj_channel` int(10) unsigned NOT NULL DEFAULT 0 ,
   `obj_term` char(191) NOT NULL DEFAULT '',
   `obj_url` char(191) NOT NULL DEFAULT '',
   `obj_imgurl` char(191) NOT NULL DEFAULT '',
   `obj_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `obj_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `obj_quantity` int(11) NOT NULL DEFAULT '0',
+  `obj_quantity` int(11) NOT NULL DEFAULT 0 ,
   `allow_cid` mediumtext NOT NULL,
   `allow_gid` mediumtext NOT NULL,
   `deny_cid` mediumtext NOT NULL,
@@ -870,18 +870,18 @@ CREATE TABLE IF NOT EXISTS `obj` (
 
 CREATE TABLE IF NOT EXISTS `outq` (
   `outq_hash` char(191) NOT NULL,
-  `outq_account` int(10) unsigned NOT NULL DEFAULT '0',
-  `outq_channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `outq_account` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `outq_channel` int(10) unsigned NOT NULL DEFAULT 0 ,
   `outq_driver` char(32) NOT NULL DEFAULT '',
   `outq_posturl` char(191) NOT NULL DEFAULT '',
-  `outq_async` tinyint(1) NOT NULL DEFAULT '0',
-  `outq_delivered` tinyint(1) NOT NULL DEFAULT '0',
+  `outq_async` tinyint(1) NOT NULL DEFAULT 0 ,
+  `outq_delivered` tinyint(1) NOT NULL DEFAULT 0 ,
   `outq_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `outq_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `outq_scheduled` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `outq_notify` mediumtext NOT NULL,
   `outq_msg` mediumtext NOT NULL,
-  `outq_priority` smallint(6) NOT NULL DEFAULT '0',
+  `outq_priority` smallint(6) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`outq_hash`),
   KEY `outq_account` (`outq_account`),
   KEY `outq_channel` (`outq_channel`),
@@ -896,7 +896,7 @@ CREATE TABLE IF NOT EXISTS `outq` (
 
 CREATE TABLE IF NOT EXISTS `pconfig` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   `cat` char(100) NOT NULL DEFAULT '',
   `k` char(100) NOT NULL DEFAULT '',
   `v` mediumtext NOT NULL,
@@ -907,8 +907,8 @@ CREATE TABLE IF NOT EXISTS `pconfig` (
 
 CREATE TABLE IF NOT EXISTS `photo` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
+  `aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `xchan` char(191) NOT NULL DEFAULT '',
   `resource_id` char(191) NOT NULL DEFAULT '',
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -918,18 +918,18 @@ CREATE TABLE IF NOT EXISTS `photo` (
   `album` char(191) NOT NULL DEFAULT '',
   `filename` char(191) NOT NULL DEFAULT '',
   `mimetype` char(128) NOT NULL DEFAULT 'image/jpeg',
-  `height` smallint(6) NOT NULL DEFAULT '0',
-  `width` smallint(6) NOT NULL DEFAULT '0',
-  `filesize` int(10) unsigned NOT NULL DEFAULT '0',
+  `height` smallint(6) NOT NULL DEFAULT 0 ,
+  `width` smallint(6) NOT NULL DEFAULT 0 ,
+  `filesize` int(10) unsigned NOT NULL DEFAULT 0 ,
   `content` mediumblob NOT NULL,
-  `imgscale` tinyint(3) NOT NULL DEFAULT '0',
-  `photo_usage` smallint(6) NOT NULL DEFAULT '0',
-  `profile` tinyint(1) NOT NULL DEFAULT '0',
-  `is_nsfw` tinyint(1) NOT NULL DEFAULT '0',
-  `os_storage` tinyint(1) NOT NULL DEFAULT '0',
+  `imgscale` tinyint(3) NOT NULL DEFAULT 0 ,
+  `photo_usage` smallint(6) NOT NULL DEFAULT 0 ,
+  `profile` tinyint(1) NOT NULL DEFAULT 0 ,
+  `is_nsfw` tinyint(1) NOT NULL DEFAULT 0 ,
+  `os_storage` tinyint(1) NOT NULL DEFAULT 0 ,
   `os_path` mediumtext NOT NULL,
   `display_path` mediumtext NOT NULL,
-  `photo_flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `photo_flags` int(10) unsigned NOT NULL DEFAULT 0 ,
   `allow_cid` mediumtext NOT NULL,
   `allow_gid` mediumtext NOT NULL,
   `deny_cid` mediumtext NOT NULL,
@@ -952,10 +952,10 @@ CREATE TABLE IF NOT EXISTS `photo` (
 
 CREATE TABLE IF NOT EXISTS `poll` (
   `poll_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `poll_channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `poll_channel` int(10) unsigned NOT NULL DEFAULT 0 ,
   `poll_desc` text NOT NULL,
-  `poll_flags` int(11) NOT NULL DEFAULT '0',
-  `poll_votes` int(11) NOT NULL DEFAULT '0',
+  `poll_flags` int(11) NOT NULL DEFAULT 0 ,
+  `poll_votes` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`poll_id`),
   KEY `poll_channel` (`poll_channel`),
   KEY `poll_flags` (`poll_flags`),
@@ -964,10 +964,10 @@ CREATE TABLE IF NOT EXISTS `poll` (
 
 CREATE TABLE IF NOT EXISTS `poll_elm` (
   `pelm_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `pelm_poll` int(10) unsigned NOT NULL DEFAULT '0',
+  `pelm_poll` int(10) unsigned NOT NULL DEFAULT 0 ,
   `pelm_desc` text NOT NULL,
-  `pelm_flags` int(11) NOT NULL DEFAULT '0',
-  `pelm_result` float NOT NULL DEFAULT '0',
+  `pelm_flags` int(11) NOT NULL DEFAULT 0 ,
+  `pelm_result` float NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`pelm_id`),
   KEY `pelm_poll` (`pelm_poll`),
   KEY `pelm_result` (`pelm_result`)
@@ -986,7 +986,7 @@ CREATE TABLE IF NOT EXISTS `profdef` (
 
 CREATE TABLE IF NOT EXISTS `profext` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `channel_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `channel_id` int(10) unsigned NOT NULL DEFAULT 0 ,
   `hash` char(191) NOT NULL DEFAULT '',
   `k` char(191) NOT NULL DEFAULT '',
   `v` mediumtext NOT NULL,
@@ -999,11 +999,11 @@ CREATE TABLE IF NOT EXISTS `profext` (
 CREATE TABLE IF NOT EXISTS `profile` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `profile_guid` char(64) NOT NULL DEFAULT '',
-  `aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   `profile_name` char(191) NOT NULL DEFAULT '',
-  `is_default` tinyint(1) NOT NULL DEFAULT '0',
-  `hide_friends` tinyint(1) NOT NULL DEFAULT '0',
+  `is_default` tinyint(1) NOT NULL DEFAULT 0 ,
+  `hide_friends` tinyint(1) NOT NULL DEFAULT 0 ,
   `fullname` char(191) NOT NULL DEFAULT '',
   `pdesc` char(191) NOT NULL DEFAULT '',
   `chandesc` text NOT NULL,
@@ -1040,7 +1040,7 @@ CREATE TABLE IF NOT EXISTS `profile` (
   `homepage` char(191) NOT NULL DEFAULT '',
   `photo` char(191) NOT NULL DEFAULT '',
   `thumb` char(191) NOT NULL DEFAULT '',
-  `publish` tinyint(1) NOT NULL DEFAULT '0',
+  `publish` tinyint(1) NOT NULL DEFAULT 0 ,
   `profile_vcard` text NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `guid` (`profile_guid`,`uid`),
@@ -1061,11 +1061,11 @@ CREATE TABLE IF NOT EXISTS `profile` (
 
 CREATE TABLE IF NOT EXISTS `profile_check` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
-  `cid` int(10) unsigned NOT NULL DEFAULT '0',
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `cid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `dfrn_id` char(191) NOT NULL DEFAULT '',
   `sec` char(191) NOT NULL DEFAULT '',
-  `expire` int(11) NOT NULL DEFAULT '0',
+  `expire` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
   KEY `cid` (`cid`),
@@ -1078,7 +1078,7 @@ CREATE TABLE IF NOT EXISTS `register` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `hash` char(191) NOT NULL DEFAULT '',
   `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `password` char(191) NOT NULL DEFAULT '',
   `lang` char(16) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
@@ -1091,7 +1091,7 @@ CREATE TABLE IF NOT EXISTS `session` (
   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   `sid` char(191) NOT NULL DEFAULT '',
   `sess_data` text NOT NULL,
-  `expire` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `expire` bigint(20) unsigned NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
   KEY `sid` (`sid`),
   KEY `expire` (`expire`)
@@ -1099,8 +1099,8 @@ CREATE TABLE IF NOT EXISTS `session` (
 
 CREATE TABLE IF NOT EXISTS `shares` (
   `share_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `share_type` int(11) NOT NULL DEFAULT '0',
-  `share_target` int(10) unsigned NOT NULL DEFAULT '0',
+  `share_type` int(11) NOT NULL DEFAULT 0 ,
+  `share_target` int(10) unsigned NOT NULL DEFAULT 0 ,
   `share_xchan` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`share_id`),
   KEY `share_type` (`share_type`),
@@ -1110,8 +1110,8 @@ CREATE TABLE IF NOT EXISTS `shares` (
 
 CREATE TABLE IF NOT EXISTS `sign` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `iid` int(10) unsigned NOT NULL DEFAULT '0',
-  `retract_iid` int(10) unsigned NOT NULL DEFAULT '0',
+  `iid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `retract_iid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `signed_text` mediumtext NOT NULL,
   `signature` text NOT NULL,
   `signer` char(191) NOT NULL DEFAULT '',
@@ -1122,19 +1122,19 @@ CREATE TABLE IF NOT EXISTS `sign` (
 
 CREATE TABLE IF NOT EXISTS `site` (
   `site_url` char(191) NOT NULL,
-  `site_access` int(11) NOT NULL DEFAULT '0',
-  `site_flags` int(11) NOT NULL DEFAULT '0',
+  `site_access` int(11) NOT NULL DEFAULT 0 ,
+  `site_flags` int(11) NOT NULL DEFAULT 0 ,
   `site_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `site_pull` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `site_sync` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `site_directory` char(191) NOT NULL DEFAULT '',
-  `site_register` int(11) NOT NULL DEFAULT '0',
+  `site_register` int(11) NOT NULL DEFAULT 0 ,
   `site_sellpage` char(191) NOT NULL DEFAULT '',
   `site_location` char(191) NOT NULL DEFAULT '',
   `site_realm` char(191) NOT NULL DEFAULT '',
-  `site_valid` smallint NOT NULL DEFAULT '0',
-  `site_dead` smallint NOT NULL DEFAULT '0',
-  `site_type` smallint NOT NULL DEFAULT '0',
+  `site_valid` smallint NOT NULL DEFAULT 0 ,
+  `site_dead` smallint NOT NULL DEFAULT 0 ,
+  `site_type` smallint NOT NULL DEFAULT 0 ,
   `site_project` char(191) NOT NULL DEFAULT '',
   `site_version` varchar(32) NOT NULL DEFAULT '',
   `site_crypto` text NOT NULL,
@@ -1155,7 +1155,7 @@ CREATE TABLE IF NOT EXISTS `site` (
 
 CREATE TABLE IF NOT EXISTS `source` (
   `src_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `src_channel_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `src_channel_id` int(10) unsigned NOT NULL DEFAULT 0 ,
   `src_channel_xchan` char(191) NOT NULL DEFAULT '',
   `src_xchan` char(191) NOT NULL DEFAULT '',
   `src_patt` mediumtext NOT NULL,
@@ -1171,17 +1171,17 @@ CREATE TABLE IF NOT EXISTS `sys_perms` (
   `cat` char(191) NOT NULL DEFAULT '',
   `k` char(191) NOT NULL DEFAULT '',
   `v` mediumtext NOT NULL,
-  `public_perm` tinyint(1) unsigned NOT NULL DEFAULT '0',
+  `public_perm` tinyint(1) unsigned NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
 CREATE TABLE IF NOT EXISTS `term` (
   `tid` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `aid` int(10) unsigned NOT NULL DEFAULT '0',
-  `uid` int(10) unsigned NOT NULL DEFAULT '0',
-  `oid` int(10) unsigned NOT NULL DEFAULT '0',
-  `otype` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `ttype` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `aid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `oid` int(10) unsigned NOT NULL DEFAULT 0 ,
+  `otype` tinyint(3) unsigned NOT NULL DEFAULT 0 ,
+  `ttype` tinyint(3) unsigned NOT NULL DEFAULT 0 ,
   `term` char(191) NOT NULL DEFAULT '',
   `url` char(191) NOT NULL DEFAULT '',
   `imgurl` char(191) NOT NULL DEFAULT '',
@@ -1203,9 +1203,9 @@ CREATE TABLE IF NOT EXISTS `tokens` (
   `id` varchar(191) NOT NULL DEFAULT '',
   `secret` text NOT NULL,
   `client_id` varchar(191) NOT NULL DEFAULT '',
-  `expires` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `expires` bigint(20) unsigned NOT NULL DEFAULT 0 ,
   `auth_scope` varchar(512) NOT NULL DEFAULT '',
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
   KEY `client_id` (`client_id`),
   KEY `expires` (`expires`),
@@ -1218,7 +1218,7 @@ CREATE TABLE IF NOT EXISTS `updates` (
   `ud_guid` char(191) NOT NULL DEFAULT '',
   `ud_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `ud_last` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `ud_flags` int(11) NOT NULL DEFAULT '0',
+  `ud_flags` int(11) NOT NULL DEFAULT 0 ,
   `ud_addr` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`ud_id`),
   KEY `ud_date` (`ud_date`),
@@ -1231,7 +1231,7 @@ CREATE TABLE IF NOT EXISTS `updates` (
 
 CREATE TABLE IF NOT EXISTS `verify` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `channel` int(10) unsigned NOT NULL DEFAULT 0 ,
   `vtype` char(32) NOT NULL DEFAULT '',
   `token` char(191) NOT NULL DEFAULT '',
   `meta` char(191) NOT NULL DEFAULT '',
@@ -1246,8 +1246,8 @@ CREATE TABLE IF NOT EXISTS `verify` (
 
 CREATE TABLE IF NOT EXISTS `vote` (
   `vote_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `vote_poll` int(11) NOT NULL DEFAULT '0',
-  `vote_element` int(11) NOT NULL DEFAULT '0',
+  `vote_poll` int(11) NOT NULL DEFAULT 0 ,
+  `vote_element` int(11) NOT NULL DEFAULT 0 ,
   `vote_result` text NOT NULL,
   `vote_xchan` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`vote_id`),
@@ -1273,16 +1273,16 @@ CREATE TABLE IF NOT EXISTS `xchan` (
   `xchan_name` char(191) NOT NULL DEFAULT '',
   `xchan_network` char(191) NOT NULL DEFAULT '',
   `xchan_instance_url` char(191) NOT NULL DEFAULT '',
-  `xchan_flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `xchan_flags` int(10) unsigned NOT NULL DEFAULT 0 ,
   `xchan_photo_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `xchan_name_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `xchan_hidden` tinyint(1) NOT NULL DEFAULT '0',
-  `xchan_orphan` tinyint(1) NOT NULL DEFAULT '0',
-  `xchan_censored` tinyint(1) NOT NULL DEFAULT '0',
-  `xchan_selfcensored` tinyint(1) NOT NULL DEFAULT '0',
-  `xchan_system` tinyint(1) NOT NULL DEFAULT '0',
-  `xchan_pubforum` tinyint(1) NOT NULL DEFAULT '0',
-  `xchan_deleted` tinyint(1) NOT NULL DEFAULT '0',
+  `xchan_hidden` tinyint(1) NOT NULL DEFAULT 0 ,
+  `xchan_orphan` tinyint(1) NOT NULL DEFAULT 0 ,
+  `xchan_censored` tinyint(1) NOT NULL DEFAULT 0 ,
+  `xchan_selfcensored` tinyint(1) NOT NULL DEFAULT 0 ,
+  `xchan_system` tinyint(1) NOT NULL DEFAULT 0 ,
+  `xchan_pubforum` tinyint(1) NOT NULL DEFAULT 0 ,
+  `xchan_deleted` tinyint(1) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`xchan_hash`),
   KEY `xchan_guid` (`xchan_guid`),
   KEY `xchan_addr` (`xchan_addr`),
@@ -1329,7 +1329,7 @@ CREATE TABLE IF NOT EXISTS `xconfig` (
 
 CREATE TABLE IF NOT EXISTS `xign` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `uid` int(11) NOT NULL DEFAULT '0',
+  `uid` int(11) NOT NULL DEFAULT 0 ,
   `xchan` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
@@ -1340,10 +1340,10 @@ CREATE TABLE IF NOT EXISTS `xlink` (
   `xlink_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `xlink_xchan` char(191) NOT NULL DEFAULT '',
   `xlink_link` char(191) NOT NULL DEFAULT '',
-  `xlink_rating` int(11) NOT NULL DEFAULT '0',
+  `xlink_rating` int(11) NOT NULL DEFAULT 0 ,
   `xlink_rating_text` text NOT NULL,
   `xlink_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-  `xlink_static` tinyint(1) NOT NULL DEFAULT '0',
+  `xlink_static` tinyint(1) NOT NULL DEFAULT 0 ,
   `xlink_sig` text NOT NULL,
   PRIMARY KEY (`xlink_id`),
   KEY `xlink_xchan` (`xlink_xchan`),
@@ -1356,7 +1356,7 @@ CREATE TABLE IF NOT EXISTS `xlink` (
 CREATE TABLE IF NOT EXISTS `xperm` (
   `xp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `xp_client` varchar(20) NOT NULL DEFAULT '',
-  `xp_channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `xp_channel` int(10) unsigned NOT NULL DEFAULT 0 ,
   `xp_perm` varchar(64) NOT NULL DEFAULT '',
   PRIMARY KEY (`xp_id`),
   KEY `xp_client` (`xp_client`),
@@ -1366,7 +1366,7 @@ CREATE TABLE IF NOT EXISTS `xperm` (
 
 CREATE TABLE IF NOT EXISTS `xprof` (
   `xprof_hash` char(191) NOT NULL,
-  `xprof_age` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `xprof_age` tinyint(3) unsigned NOT NULL DEFAULT 0 ,
   `xprof_desc` char(191) NOT NULL DEFAULT '',
   `xprof_dob` char(12) NOT NULL DEFAULT '',
   `xprof_gender` char(191) NOT NULL DEFAULT '',
@@ -1398,7 +1398,7 @@ CREATE TABLE IF NOT EXISTS `xtag` (
   `xtag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `xtag_hash` char(191) NOT NULL DEFAULT '',
   `xtag_term` char(191) NOT NULL DEFAULT '',
-  `xtag_flags` int(11) NOT NULL DEFAULT '0',
+  `xtag_flags` int(11) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`xtag_id`),
   KEY `xtag_term` (`xtag_term`),
   KEY `xtag_hash` (`xtag_hash`),