From f49ce500a1aad627de4d1558b0d018735a1a6e31 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Tue, 6 Jun 2017 18:12:44 -0700 Subject: fix a merge mixup on install/schema_msyql.php --- install/schema_mysql.sql | 460 +++++++++++++++++++++++------------------------ 1 file 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`), -- cgit v1.2.3