diff options
author | Mario Vavti <mario@mariovavti.com> | 2017-05-31 09:56:35 +0200 |
---|---|---|
committer | Mario Vavti <mario@mariovavti.com> | 2017-05-31 09:56:35 +0200 |
commit | 47d55694a4c84b6c12c0db61a69bcac8b671b20e (patch) | |
tree | b15e96f4ea67e2214a66a9d28dafaf53d25b98ec /install | |
parent | 087f9784e3c5a860ed2b86e7f9e8e9f312038546 (diff) | |
parent | f0e615dee529e031663576286345141ad2996974 (diff) | |
download | volse-hubzilla-47d55694a4c84b6c12c0db61a69bcac8b671b20e.tar.gz volse-hubzilla-47d55694a4c84b6c12c0db61a69bcac8b671b20e.tar.bz2 volse-hubzilla-47d55694a4c84b6c12c0db61a69bcac8b671b20e.zip |
Merge branch '2.4RC'2.4
Diffstat (limited to 'install')
-rw-r--r-- | install/schema_mysql.sql | 460 | ||||
-rw-r--r-- | install/schema_postgres.sql | 440 | ||||
-rw-r--r-- | install/update.php | 43 |
3 files changed, 496 insertions, 447 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index be5317722..ceb63fce9 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -1,7 +1,7 @@ CREATE TABLE IF NOT EXISTS `abconfig` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `chan` int(10) unsigned NOT NULL DEFAULT '0', + `chan` int(10) unsigned NOT NULL DEFAULT 0 , `xchan` char(255) NOT NULL DEFAULT '', `cat` char(255) NOT NULL DEFAULT '', `k` char(255) NOT NULL DEFAULT '', @@ -15,25 +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(255) 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_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(64) NOT NULL DEFAULT '', `abook_incl` TEXT NOT NULL DEFAULT '', `abook_excl` TEXT NOT NULL DEFAULT '', @@ -58,13 +59,14 @@ CREATE TABLE IF NOT EXISTS `abook` ( KEY `abook_pending` (`abook_pending`), KEY `abook_unconnected` (`abook_unconnected`), KEY `abook_self` (`abook_self`), + KEY `abook_not_here` (`abook_not_here`), KEY `abook_feed` (`abook_feed`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 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(255) NOT NULL DEFAULT '', `account_email` char(255) NOT NULL DEFAULT '', @@ -72,13 +74,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(255) 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 +100,10 @@ CREATE TABLE IF NOT EXISTS `addon` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aname` char(255) NOT NULL DEFAULT '', `version` char(255) 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 +120,13 @@ CREATE TABLE IF NOT EXISTS `app` ( `app_url` char(255) NOT NULL DEFAULT '', `app_photo` char(255) NOT NULL DEFAULT '', `app_version` char(255) NOT NULL DEFAULT '', - `app_channel` int(11) NOT NULL DEFAULT '0', + `app_channel` int(11) NOT NULL DEFAULT 0 , `app_addr` char(255) NOT NULL DEFAULT '', `app_price` char(255) NOT NULL DEFAULT '', `app_page` char(255) NOT NULL DEFAULT '', `app_requires` char(255) 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(255) 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', @@ -161,19 +163,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(64) NOT NULL DEFAULT '', `creator` char(128) NOT NULL DEFAULT '', `filename` char(255) NOT NULL DEFAULT '', `filetype` char(64) 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(64) 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 +207,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=MyISAM DEFAULT CHARSET=utf8; @@ -219,8 +221,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(255) NOT NULL DEFAULT '', `cal_name` varchar(255) NOT NULL DEFAULT '', `uri` varchar(255) NOT NULL DEFAULT '', @@ -239,8 +241,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(255) NOT NULL DEFAULT '', `channel_address` char(255) NOT NULL DEFAULT '', `channel_guid` char(255) NOT NULL DEFAULT '', @@ -252,41 +254,43 @@ CREATE TABLE IF NOT EXISTS `channel` ( `channel_startpage` char(255) 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(255) NOT NULL DEFAULT '', `channel_default_group` char(255) 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(255) NOT NULL DEFAULT '', + `channel_password` varchar(255) NOT NULL, + `channel_salt` varchar(255) NOT NULL, PRIMARY KEY (`channel_id`), UNIQUE KEY `channel_address_unique` (`channel_address`), KEY `channel_account_id` (`channel_account_id`), @@ -331,7 +335,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(255) NOT NULL DEFAULT '', `chat_text` mediumtext NOT NULL, `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -343,7 +347,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(255) NOT NULL DEFAULT '', `cp_last` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `cp_status` char(255) NOT NULL DEFAULT '', @@ -357,12 +361,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(255) 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, @@ -382,7 +386,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=MyISAM DEFAULT CHARSET=utf8; @@ -399,7 +403,7 @@ CREATE TABLE IF NOT EXISTS `conv` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `guid` char(255) NOT NULL DEFAULT '', `recips` mediumtext NOT NULL, - `uid` int(11) NOT NULL DEFAULT '0', + `uid` int(11) NOT NULL DEFAULT 0 , `creator` char(255) 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', @@ -411,7 +415,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(255) NOT NULL DEFAULT '', `dreport_site` char(255) NOT NULL DEFAULT '', `dreport_recip` char(255) NOT NULL DEFAULT '', @@ -430,9 +434,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(255) NOT NULL DEFAULT '', `event_hash` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -443,19 +447,19 @@ CREATE TABLE IF NOT EXISTS `event` ( `description` text NOT NULL, `location` text NOT NULL, `etype` char(255) 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(255) 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`), @@ -477,9 +481,9 @@ CREATE TABLE IF NOT EXISTS `event` ( CREATE TABLE IF NOT EXISTS `groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `hash` char(255) 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(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -491,8 +495,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(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -505,8 +509,8 @@ CREATE TABLE IF NOT EXISTS `hook` ( `hook` char(255) NOT NULL DEFAULT '', `file` char(255) NOT NULL DEFAULT '', `fn` char(255) 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`), @@ -520,8 +524,8 @@ CREATE TABLE IF NOT EXISTS `hubloc` ( `hubloc_hash` char(255) NOT NULL DEFAULT '', `hubloc_addr` char(255) 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(255) NOT NULL DEFAULT '', `hubloc_url_sig` text NOT NULL, `hubloc_host` char(255) NOT NULL DEFAULT '', @@ -530,10 +534,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`), @@ -554,11 +558,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(255) NOT NULL DEFAULT '', `k` char(255) 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`), @@ -571,8 +575,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(255) 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(255) NOT NULL DEFAULT '', PRIMARY KEY (`issue_id`), KEY `issue_created` (`issue_created`), @@ -586,9 +590,9 @@ CREATE TABLE IF NOT EXISTS `issue` ( CREATE TABLE IF NOT EXISTS `item` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mid` char(255) CHARACTER SET ascii 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(255) CHARACTER SET ascii NOT NULL DEFAULT '', `thr_parent` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -607,7 +611,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `html` mediumtext NOT NULL, `app` char(255) 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(255) NOT NULL DEFAULT '', `obj_type` char(255) NOT NULL DEFAULT '', `obj` text NOT NULL, @@ -631,32 +635,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`), @@ -719,8 +723,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(255) NOT NULL DEFAULT '', `service` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), @@ -732,10 +736,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(128) NOT NULL DEFAULT '', `likee` char(128) NOT NULL DEFAULT '', - `iid` int(11) unsigned NOT NULL DEFAULT '0', + `iid` int(11) unsigned NOT NULL DEFAULT 0 , `i_mid` char(255) NOT NULL DEFAULT '', `verb` char(255) NOT NULL DEFAULT '', `target_type` char(255) NOT NULL DEFAULT '', @@ -754,25 +758,27 @@ 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(255) NOT NULL DEFAULT '', - `mail_flags` int(10) unsigned NOT NULL DEFAULT '0', + `mail_flags` int(10) unsigned NOT NULL DEFAULT 0 , `from_xchan` char(255) NOT NULL DEFAULT '', `to_xchan` char(255) 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, `sig` text NOT NULL, `attach` mediumtext NOT NULL, `mid` char(255) NOT NULL DEFAULT '', `parent_mid` char(255) 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_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`), @@ -797,10 +803,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(255) NOT NULL DEFAULT '', `menu_desc` char(255) 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`), @@ -815,14 +821,14 @@ CREATE TABLE IF NOT EXISTS `menu_item` ( `mitem_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mitem_link` char(255) NOT NULL DEFAULT '', `mitem_desc` char(255) 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`), @@ -837,12 +843,12 @@ CREATE TABLE IF NOT EXISTS `notify` ( `photo` char(255) 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(255) NOT NULL DEFAULT '', `parent` char(255) 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(255) NOT NULL DEFAULT '', `otype` char(16) NOT NULL DEFAULT '', PRIMARY KEY (`id`), @@ -861,15 +867,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(255) NOT NULL DEFAULT '', - `obj_type` int(10) unsigned NOT NULL DEFAULT '0', + `obj_type` int(10) unsigned NOT NULL DEFAULT 0 , `obj_obj` char(255) NOT NULL DEFAULT '', - `obj_channel` int(10) unsigned NOT NULL DEFAULT '0', + `obj_channel` int(10) unsigned NOT NULL DEFAULT 0 , `obj_term` char(255) NOT NULL DEFAULT '', `obj_url` char(255) NOT NULL DEFAULT '', `obj_imgurl` char(255) 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, @@ -890,18 +896,18 @@ CREATE TABLE IF NOT EXISTS `obj` ( CREATE TABLE IF NOT EXISTS `outq` ( `outq_hash` char(255) 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(255) 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`), @@ -916,7 +922,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(255) CHARACTER SET ascii NOT NULL DEFAULT '', `k` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', `v` mediumtext NOT NULL, @@ -927,8 +933,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(255) NOT NULL DEFAULT '', `resource_id` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -938,18 +944,18 @@ CREATE TABLE IF NOT EXISTS `photo` ( `album` char(255) NOT NULL DEFAULT '', `filename` char(255) 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, @@ -972,10 +978,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`), @@ -984,10 +990,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`) @@ -1006,7 +1012,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(255) NOT NULL DEFAULT '', `k` char(255) NOT NULL DEFAULT '', `v` mediumtext NOT NULL, @@ -1019,11 +1025,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(255) 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(255) NOT NULL DEFAULT '', `pdesc` char(255) NOT NULL DEFAULT '', `chandesc` text NOT NULL, @@ -1060,7 +1066,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( `homepage` char(255) NOT NULL DEFAULT '', `photo` char(255) NOT NULL DEFAULT '', `thumb` char(255) NOT NULL DEFAULT '', - `publish` tinyint(1) NOT NULL DEFAULT '0', + `publish` tinyint(1) NOT NULL DEFAULT 0 , `profile_vcard` text NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `guid` (`profile_guid`,`uid`), @@ -1081,11 +1087,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(255) NOT NULL DEFAULT '', `sec` char(255) 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`), @@ -1098,7 +1104,7 @@ CREATE TABLE IF NOT EXISTS `register` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `hash` char(255) 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(255) NOT NULL DEFAULT '', `lang` char(16) NOT NULL DEFAULT '', PRIMARY KEY (`id`), @@ -1111,7 +1117,7 @@ CREATE TABLE IF NOT EXISTS `session` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sid` char(255) 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`) @@ -1119,8 +1125,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(255) NOT NULL DEFAULT '', PRIMARY KEY (`share_id`), KEY `share_type` (`share_type`), @@ -1130,8 +1136,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(255) NOT NULL DEFAULT '', @@ -1142,19 +1148,19 @@ CREATE TABLE IF NOT EXISTS `sign` ( CREATE TABLE IF NOT EXISTS `site` ( `site_url` char(255) 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(255) NOT NULL DEFAULT '', - `site_register` int(11) NOT NULL DEFAULT '0', + `site_register` int(11) NOT NULL DEFAULT 0 , `site_sellpage` char(255) NOT NULL DEFAULT '', `site_location` char(255) NOT NULL DEFAULT '', `site_realm` char(255) 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(255) NOT NULL DEFAULT '', `site_version` varchar(32) NOT NULL DEFAULT '', `site_crypto` text NOT NULL DEFAULT '', @@ -1175,7 +1181,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(255) NOT NULL DEFAULT '', `src_xchan` char(255) NOT NULL DEFAULT '', `src_patt` mediumtext NOT NULL, @@ -1191,17 +1197,17 @@ CREATE TABLE IF NOT EXISTS `sys_perms` ( `cat` char(255) NOT NULL DEFAULT '', `k` char(255) 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=MyISAM DEFAULT CHARSET=utf8; 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(255) NOT NULL DEFAULT '', `url` char(255) NOT NULL DEFAULT '', `imgurl` char(255) NOT NULL DEFAULT '', @@ -1223,9 +1229,9 @@ CREATE TABLE IF NOT EXISTS `tokens` ( `id` varchar(40) NOT NULL DEFAULT '', `secret` text NOT NULL, `client_id` varchar(20) 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`), @@ -1238,7 +1244,7 @@ CREATE TABLE IF NOT EXISTS `updates` ( `ud_guid` char(255) 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(255) NOT NULL DEFAULT '', PRIMARY KEY (`ud_id`), KEY `ud_date` (`ud_date`), @@ -1251,7 +1257,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(255) NOT NULL DEFAULT '', `meta` char(255) NOT NULL DEFAULT '', @@ -1266,8 +1272,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(255) NOT NULL DEFAULT '', PRIMARY KEY (`vote_id`), @@ -1293,16 +1299,16 @@ CREATE TABLE IF NOT EXISTS `xchan` ( `xchan_name` char(255) NOT NULL DEFAULT '', `xchan_network` char(255) NOT NULL DEFAULT '', `xchan_instance_url` char(255) 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`), @@ -1349,7 +1355,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(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -1360,10 +1366,10 @@ CREATE TABLE IF NOT EXISTS `xlink` ( `xlink_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `xlink_xchan` char(255) NOT NULL DEFAULT '', `xlink_link` char(255) 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`), @@ -1376,7 +1382,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`), @@ -1386,7 +1392,7 @@ CREATE TABLE IF NOT EXISTS `xperm` ( CREATE TABLE IF NOT EXISTS `xprof` ( `xprof_hash` char(255) NOT NULL, - `xprof_age` tinyint(3) unsigned NOT NULL DEFAULT '0', + `xprof_age` tinyint(3) unsigned NOT NULL DEFAULT 0 , `xprof_desc` char(255) NOT NULL DEFAULT '', `xprof_dob` char(12) NOT NULL DEFAULT '', `xprof_gender` char(255) NOT NULL DEFAULT '', @@ -1418,7 +1424,7 @@ CREATE TABLE IF NOT EXISTS `xtag` ( `xtag_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `xtag_hash` char(255) NOT NULL DEFAULT '', `xtag_term` char(255) 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`), diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index e78425828..e171d9baf 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -1,6 +1,6 @@ CREATE TABLE "abconfig" ( "id" serial NOT NULL, - "chan" bigint NOT NULL DEFAULT '0', + "chan" bigint NOT NULL DEFAULT 0, "xchan" text NOT NULL, "cat" text NOT NULL, "k" text NOT NULL, @@ -16,23 +16,24 @@ CREATE TABLE "abook" ( "abook_account" bigint NOT NULL, "abook_channel" bigint NOT NULL, "abook_xchan" text NOT NULL DEFAULT '', - "abook_my_perms" bigint NOT NULL DEFAULT '0', - "abook_their_perms" bigint NOT NULL DEFAULT '0', - "abook_closeness" numeric(3) NOT NULL DEFAULT '99', + "abook_my_perms" bigint NOT NULL DEFAULT 0, + "abook_their_perms" bigint NOT NULL DEFAULT 0, + "abook_closeness" numeric(3) NOT NULL DEFAULT 99, "abook_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "abook_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "abook_connected" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "abook_dob" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "abook_flags" bigint NOT NULL DEFAULT '0', - "abook_blocked" smallint NOT NULL DEFAULT '0', - "abook_ignored" smallint NOT NULL DEFAULT '0', - "abook_hidden" smallint NOT NULL DEFAULT '0', - "abook_archived" smallint NOT NULL DEFAULT '0', - "abook_pending" smallint NOT NULL DEFAULT '0', - "abook_unconnected" smallint NOT NULL DEFAULT '0', - "abook_self" smallint NOT NULL DEFAULT '0', - "abook_feed" smallint NOT NULL DEFAULT '0', - "abook_profile" char(64) NOT NULL DEFAULT '', + "abook_flags" bigint NOT NULL DEFAULT 0 , + "abook_blocked" smallint NOT NULL DEFAULT 0 , + "abook_ignored" smallint NOT NULL DEFAULT 0 , + "abook_hidden" smallint NOT NULL DEFAULT 0 , + "abook_archived" smallint NOT NULL DEFAULT 0 , + "abook_pending" smallint NOT NULL DEFAULT 0 , + "abook_unconnected" smallint NOT NULL DEFAULT 0 , + "abook_self" smallint NOT NULL DEFAULT 0 , + "abook_feed" smallint NOT NULL DEFAULT 0 , + "abook_not_here" smallint NOT NULL DEFAULT 0 , + "abook_profile" varchar(64) NOT NULL DEFAULT '', "abook_incl" TEXT NOT NULL DEFAULT '', "abook_excl" TEXT NOT NULL DEFAULT '', "abook_instance" TEXT NOT NULL DEFAULT '', @@ -55,6 +56,7 @@ CREATE TABLE "abook" ( create index "abook_unconnected" on abook ("abook_unconnected"); create index "abook_self" on abook ("abook_self"); create index "abook_feed" on abook ("abook_feed"); + create index "abook_not_here" on abook ("abook_not_here"); create index "abook_profile" on abook ("abook_profile"); create index "abook_dob" on abook ("abook_dob"); create index "abook_connected" on abook ("abook_connected"); @@ -62,22 +64,22 @@ CREATE TABLE "abook" ( CREATE TABLE "account" ( "account_id" serial NOT NULL, - "account_parent" bigint NOT NULL DEFAULT '0', - "account_default_channel" bigint NOT NULL DEFAULT '0', - "account_salt" char(32) NOT NULL DEFAULT '', + "account_parent" bigint NOT NULL DEFAULT 0 , + "account_default_channel" bigint NOT NULL DEFAULT 0 , + "account_salt" varchar(32) NOT NULL DEFAULT '', "account_password" text NOT NULL DEFAULT '', "account_email" text NOT NULL DEFAULT '', "account_external" text NOT NULL DEFAULT '', "account_language" varchar(16) NOT NULL DEFAULT 'en', "account_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "account_lastlog" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "account_flags" bigint NOT NULL DEFAULT '0', - "account_roles" bigint NOT NULL DEFAULT '0', + "account_flags" bigint NOT NULL DEFAULT 0 , + "account_roles" bigint NOT NULL DEFAULT 0 , "account_reset" text NOT NULL DEFAULT '', "account_expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "account_expire_notified" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "account_service_class" varchar(32) NOT NULL DEFAULT '', - "account_level" bigint NOT NULL DEFAULT '0', + "account_level" bigint NOT NULL DEFAULT 0 , "account_password_changed" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY ("account_id") ); @@ -95,11 +97,11 @@ create index "account_password_changed" on account ("account_password_changed") CREATE TABLE "addon" ( "id" serial NOT NULL, "aname" text NOT NULL, - "version" text NOT NULL DEFAULT '0', - "installed" numeric(1) NOT NULL DEFAULT '0', - "hidden" numeric(1) NOT NULL DEFAULT '0', - "tstamp" numeric(20) NOT NULL DEFAULT '0', - "plugin_admin" numeric(1) NOT NULL DEFAULT '0', + "version" text NOT NULL DEFAULT 0 , + "installed" numeric(1) NOT NULL DEFAULT 0 , + "hidden" numeric(1) NOT NULL DEFAULT 0 , + "tstamp" numeric(20) NOT NULL DEFAULT 0 , + "plugin_admin" numeric(1) NOT NULL DEFAULT 0 , PRIMARY KEY ("id") ); create index "addon_hidden_idx" on addon ("hidden"); @@ -115,13 +117,13 @@ CREATE TABLE "app" ( "app_url" text NOT NULL DEFAULT '', "app_photo" text NOT NULL DEFAULT '', "app_version" text NOT NULL DEFAULT '', - "app_channel" bigint NOT NULL DEFAULT '0', + "app_channel" bigint NOT NULL DEFAULT 0 , "app_addr" text NOT NULL DEFAULT '', "app_price" text NOT NULL DEFAULT '', "app_page" text NOT NULL DEFAULT '', "app_requires" text NOT NULL DEFAULT '', - "app_deleted" smallint NOT NULL DEFAULT '0', - "app_system" smallint NOT NULL DEFAULT '0', + "app_deleted" smallint NOT NULL DEFAULT 0 , + "app_system" smallint NOT NULL DEFAULT 0 , "app_plugin" text NOT NULL DEFAULT '', "app_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "app_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -156,19 +158,19 @@ create index atoken_expires on atoken (atoken_expires); CREATE TABLE "attach" ( "id" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', - "uid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , + "uid" bigint NOT NULL DEFAULT 0 , "hash" varchar(64) NOT NULL DEFAULT '', "creator" varchar(128) NOT NULL DEFAULT '', "filename" text NOT NULL DEFAULT '', "filetype" varchar(64) NOT NULL DEFAULT '', - "filesize" bigint NOT NULL DEFAULT '0', - "revision" bigint NOT NULL DEFAULT '0', + "filesize" bigint NOT NULL DEFAULT 0 , + "revision" bigint NOT NULL DEFAULT 0 , "folder" varchar(64) NOT NULL DEFAULT '', - "flags" bigint NOT NULL DEFAULT '0', - "is_dir" smallint NOT NULL DEFAULT '0', - "is_photo" smallint NOT NULL DEFAULT '0', - "os_storage" smallint NOT NULL DEFAULT '0', + "flags" bigint NOT NULL DEFAULT 0 , + "is_dir" smallint NOT NULL DEFAULT 0 , + "is_photo" smallint NOT NULL DEFAULT 0 , + "os_storage" smallint NOT NULL DEFAULT 0 , "os_path" text NOT NULL, "display_path" text NOT NULL, "content" bytea NOT NULL, @@ -212,8 +214,8 @@ CREATE TABLE "cache" ( ); CREATE TABLE "cal" ( "cal_id" serial NOT NULL, - "cal_aid" bigint NOT NULL DEFAULT '0', - "cal_uid" bigint NOT NULL DEFAULT '0', + "cal_aid" bigint NOT NULL DEFAULT 0 , + "cal_uid" bigint NOT NULL DEFAULT 0 , "cal_hash" text NOT NULL, "cal_name" text NOT NULL, "uri" text NOT NULL, @@ -221,7 +223,7 @@ CREATE TABLE "cal" ( "pass" text NOT NULL, "ctag" text NOT NULL, "synctoken" text NOT NULL, - "cal_types" text NOT NULL DEFAULT '0', + "cal_types" text NOT NULL DEFAULT 0 , PRIMARY KEY ("cal_id") ); create index "cal_hash_idx" on cal ("cal_hash"); @@ -232,8 +234,8 @@ create index "cal_uid_idx" on cal ("cal_uid"); CREATE TABLE "channel" ( "channel_id" serial NOT NULL, - "channel_account_id" bigint NOT NULL DEFAULT '0', - "channel_primary" numeric(1) NOT NULL DEFAULT '0', + "channel_account_id" bigint NOT NULL DEFAULT 0 , + "channel_primary" numeric(1) NOT NULL DEFAULT 0 , "channel_name" text NOT NULL DEFAULT '', "channel_address" text NOT NULL DEFAULT '', "channel_guid" text NOT NULL DEFAULT '', @@ -245,41 +247,43 @@ CREATE TABLE "channel" ( "channel_startpage" text NOT NULL DEFAULT '', "channel_pubkey" text NOT NULL, "channel_prvkey" text NOT NULL, - "channel_notifyflags" bigint NOT NULL DEFAULT '65535', - "channel_pageflags" bigint NOT NULL DEFAULT '0', + "channel_notifyflags" bigint NOT NULL DEFAULT 65535, + "channel_pageflags" bigint NOT NULL DEFAULT 0 , "channel_dirdate" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "channel_lastpost" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "channel_deleted" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "channel_max_anon_mail" bigint NOT NULL DEFAULT '10', - "channel_max_friend_req" bigint NOT NULL DEFAULT '10', - "channel_expire_days" bigint NOT NULL DEFAULT '0', + "channel_max_anon_mail" bigint NOT NULL DEFAULT 10, + "channel_max_friend_req" bigint NOT NULL DEFAULT 10, + "channel_expire_days" bigint NOT NULL DEFAULT 0 , "channel_passwd_reset" text NOT NULL DEFAULT '', "channel_default_group" text NOT NULL DEFAULT '', "channel_allow_cid" text , "channel_allow_gid" text , "channel_deny_cid" text , "channel_deny_gid" text , - "channel_r_stream" bigint NOT NULL DEFAULT '128', - "channel_r_profile" bigint NOT NULL DEFAULT '128', - "channel_r_photos" bigint NOT NULL DEFAULT '128', - "channel_r_abook" bigint NOT NULL DEFAULT '128', - "channel_w_stream" bigint NOT NULL DEFAULT '128', - "channel_w_wall" bigint NOT NULL DEFAULT '128', - "channel_w_tagwall" bigint NOT NULL DEFAULT '128', - "channel_w_comment" bigint NOT NULL DEFAULT '128', - "channel_w_mail" bigint NOT NULL DEFAULT '128', - "channel_w_photos" bigint NOT NULL DEFAULT '128', - "channel_w_chat" bigint NOT NULL DEFAULT '128', - "channel_a_delegate" bigint NOT NULL DEFAULT '0', - "channel_r_storage" bigint NOT NULL DEFAULT '128', - "channel_w_storage" bigint NOT NULL DEFAULT '128', - "channel_r_pages" bigint NOT NULL DEFAULT '128', - "channel_w_pages" bigint NOT NULL DEFAULT '128', - "channel_a_republish" bigint NOT NULL DEFAULT '128', - "channel_w_like" bigint NOT NULL DEFAULT '128', - "channel_removed" smallint NOT NULL DEFAULT '0', - "channel_system" smallint NOT NULL DEFAULT '0', + "channel_r_stream" bigint NOT NULL DEFAULT 0, + "channel_r_profile" bigint NOT NULL DEFAULT 0, + "channel_r_photos" bigint NOT NULL DEFAULT 0, + "channel_r_abook" bigint NOT NULL DEFAULT 0, + "channel_w_stream" bigint NOT NULL DEFAULT 0, + "channel_w_wall" bigint NOT NULL DEFAULT 0, + "channel_w_tagwall" bigint NOT NULL DEFAULT 0, + "channel_w_comment" bigint NOT NULL DEFAULT 0, + "channel_w_mail" bigint NOT NULL DEFAULT 0, + "channel_w_photos" bigint NOT NULL DEFAULT 0, + "channel_w_chat" bigint NOT NULL DEFAULT 0, + "channel_a_delegate" bigint NOT NULL DEFAULT 0 , + "channel_r_storage" bigint NOT NULL DEFAULT 0, + "channel_w_storage" bigint NOT NULL DEFAULT 0, + "channel_r_pages" bigint NOT NULL DEFAULT 0, + "channel_w_pages" bigint NOT NULL DEFAULT 0, + "channel_a_republish" bigint NOT NULL DEFAULT 0, + "channel_w_like" bigint NOT NULL DEFAULT 0, + "channel_removed" smallint NOT NULL DEFAULT 0 , + "channel_system" smallint NOT NULL DEFAULT 0 , "channel_moved" text NOT NULL DEFAULT '', + "channel_password" varchar(255) NOT NULL, + "channel_salt" varchar(255) NOT NULL, PRIMARY KEY ("channel_id"), UNIQUE ("channel_address") ); @@ -323,7 +327,7 @@ create index "channel_system" on channel ("channel_system"); create index "channel_moved" on channel ("channel_moved"); CREATE TABLE "chat" ( "chat_id" serial NOT NULL, - "chat_room" bigint NOT NULL DEFAULT '0', + "chat_room" bigint NOT NULL DEFAULT 0 , "chat_xchan" text NOT NULL DEFAULT '', "chat_text" text NOT NULL, "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -334,11 +338,11 @@ create index "chat_xchan_idx" on chat ("chat_xchan"); create index "chat_created_idx" on chat ("created"); CREATE TABLE "chatpresence" ( "cp_id" serial NOT NULL, - "cp_room" bigint NOT NULL DEFAULT '0', + "cp_room" bigint NOT NULL DEFAULT 0 , "cp_xchan" text NOT NULL DEFAULT '', "cp_last" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "cp_status" text NOT NULL, - "cp_client" char(128) NOT NULL DEFAULT '', + "cp_client" varchar(128) NOT NULL DEFAULT '', PRIMARY KEY ("cp_id") ); create index "cp_room" on chatpresence ("cp_room"); @@ -348,12 +352,12 @@ create index "cp_status" on chatpresence ("cp_status"); CREATE TABLE "chatroom" ( "cr_id" serial NOT NULL, - "cr_aid" bigint NOT NULL DEFAULT '0', - "cr_uid" bigint NOT NULL DEFAULT '0', + "cr_aid" bigint NOT NULL DEFAULT 0 , + "cr_uid" bigint NOT NULL DEFAULT 0 , "cr_name" text NOT NULL DEFAULT '', "cr_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "cr_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "cr_expire" bigint NOT NULL DEFAULT '0', + "cr_expire" bigint NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, @@ -372,7 +376,7 @@ CREATE TABLE "clients" ( "redirect_uri" varchar(200) NOT NULL, "clname" text, "icon" text, - "uid" bigint NOT NULL DEFAULT '0', + "uid" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("client_id") ); CREATE TABLE "config" ( @@ -399,14 +403,14 @@ create index "conv_updated_idx" on conv ("updated"); CREATE TABLE IF NOT EXISTS "dreport" ( "dreport_id" serial NOT NULL, - "dreport_channel" int NOT NULL DEFAULT '0', - "dreport_mid" char(255) NOT NULL DEFAULT '', - "dreport_site" char(255) NOT NULL DEFAULT '', - "dreport_recip" char(255) NOT NULL DEFAULT '', - "dreport_result" char(255) NOT NULL DEFAULT '', + "dreport_channel" int NOT NULL DEFAULT 0 , + "dreport_mid" varchar(255) NOT NULL DEFAULT '', + "dreport_site" varchar(255) NOT NULL DEFAULT '', + "dreport_recip" varchar(255) NOT NULL DEFAULT '', + "dreport_result" varchar(255) NOT NULL DEFAULT '', "dreport_time" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "dreport_xchan" char(255) NOT NULL DEFAULT '', - "dreport_queue" char(255) NOT NULL DEFAULT '', + "dreport_xchan" varchar(255) NOT NULL DEFAULT '', + "dreport_queue" varchar(255) NOT NULL DEFAULT '', PRIMARY KEY ("dreport_id") ); @@ -419,9 +423,9 @@ create index "dreport_channel" on dreport ("dreport_channel"); CREATE TABLE "event" ( "id" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , "uid" bigint NOT NULL, - "cal_id" bigint NOT NULL DEFAULT '0', + "cal_id" bigint NOT NULL DEFAULT 0 , "event_xchan" text NOT NULL DEFAULT '', "event_hash" text NOT NULL DEFAULT '', "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -432,19 +436,19 @@ CREATE TABLE "event" ( "description" text NOT NULL, "location" text NOT NULL, "etype" text NOT NULL, - "nofinish" numeric(1) NOT NULL DEFAULT '0', - "adjust" numeric(1) NOT NULL DEFAULT '1', - "dismissed" numeric(1) NOT NULL DEFAULT '0', + "nofinish" numeric(1) NOT NULL DEFAULT 0 , + "adjust" numeric(1) NOT NULL DEFAULT 1, + "dismissed" numeric(1) NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, "deny_gid" text NOT NULL, - "event_status" char(255) NOT NULL DEFAULT '', + "event_status" varchar(255) NOT NULL DEFAULT '', "event_status_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "event_percent" smallint NOT NULL DEFAULT '0', + "event_percent" smallint NOT NULL DEFAULT 0 , "event_repeat" text NOT NULL, - "event_sequence" smallint NOT NULL DEFAULT '0', - "event_priority" smallint NOT NULL DEFAULT '0', + "event_sequence" smallint NOT NULL DEFAULT 0 , + "event_priority" smallint NOT NULL DEFAULT 0 , "event_vdata" text NOT NULL, PRIMARY KEY ("id") ); @@ -478,8 +482,8 @@ CREATE TABLE "groups" ( "id" serial NOT NULL, "hash" text NOT NULL DEFAULT '', "uid" bigint NOT NULL, - "visible" numeric(1) NOT NULL DEFAULT '0', - "deleted" numeric(1) NOT NULL DEFAULT '0', + "visible" numeric(1) NOT NULL DEFAULT 0 , + "deleted" numeric(1) NOT NULL DEFAULT 0 , "gname" text NOT NULL, PRIMARY KEY ("id") @@ -494,8 +498,8 @@ CREATE TABLE "hook" ( "hook" text NOT NULL, "file" text NOT NULL, "fn" text NOT NULL, - "priority" smallint NOT NULL DEFAULT '0', - "hook_version" smallint NOT NULL DEFAULT '0', + "priority" smallint NOT NULL DEFAULT 0 , + "hook_version" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("id") ); @@ -510,8 +514,8 @@ CREATE TABLE "hubloc" ( "hubloc_hash" text NOT NULL, "hubloc_addr" text NOT NULL DEFAULT '', "hubloc_network" text NOT NULL DEFAULT '', - "hubloc_flags" bigint NOT NULL DEFAULT '0', - "hubloc_status" bigint NOT NULL DEFAULT '0', + "hubloc_flags" bigint NOT NULL DEFAULT 0 , + "hubloc_status" bigint NOT NULL DEFAULT 0 , "hubloc_url" text NOT NULL DEFAULT '', "hubloc_url_sig" text NOT NULL DEFAULT '', "hubloc_host" text NOT NULL DEFAULT '', @@ -520,10 +524,10 @@ CREATE TABLE "hubloc" ( "hubloc_sitekey" text NOT NULL DEFAULT '', "hubloc_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "hubloc_connected" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "hubloc_primary" smallint NOT NULL DEFAULT '0', - "hubloc_orphancheck" smallint NOT NULL DEFAULT '0', - "hubloc_error" smallint NOT NULL DEFAULT '0', - "hubloc_deleted" smallint NOT NULL DEFAULT '0', + "hubloc_primary" smallint NOT NULL DEFAULT 0 , + "hubloc_orphancheck" smallint NOT NULL DEFAULT 0 , + "hubloc_error" smallint NOT NULL DEFAULT 0 , + "hubloc_deleted" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("hubloc_id") ); create index "hubloc_url" on hubloc ("hubloc_url"); @@ -542,11 +546,11 @@ create index "hubloc_error" on hubloc ("hubloc_error"); create index "hubloc_deleted" on hubloc ("hubloc_deleted"); CREATE TABLE "iconfig" ( "id" serial NOT NULL, - "iid" bigint NOT NULL DEFAULT '0', + "iid" bigint NOT NULL DEFAULT 0 , "cat" text NOT NULL DEFAULT '', "k" text NOT NULL DEFAULT '', "v" text NOT NULL DEFAULT '', - "sharing" int NOT NULL DEFAULT '0', + "sharing" int NOT NULL DEFAULT 0 , PRIMARY KEY("id") ); create index "iconfig_iid" on iconfig ("iid"); @@ -573,9 +577,9 @@ create index "issue_component" on issue ("issue_component"); CREATE TABLE "item" ( "id" serial NOT NULL, "mid" text NOT NULL DEFAULT '', - "aid" bigint NOT NULL DEFAULT '0', - "uid" bigint NOT NULL DEFAULT '0', - "parent" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , + "uid" bigint NOT NULL DEFAULT 0 , + "parent" bigint NOT NULL DEFAULT 0 , "parent_mid" text NOT NULL DEFAULT '', "thr_parent" text NOT NULL DEFAULT '', "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -594,7 +598,7 @@ CREATE TABLE "item" ( "html" text NOT NULL, "app" text NOT NULL DEFAULT '', "lang" varchar(64) NOT NULL DEFAULT '', - "revision" bigint NOT NULL DEFAULT '0', + "revision" bigint NOT NULL DEFAULT 0 , "verb" text NOT NULL DEFAULT '', "obj_type" text NOT NULL DEFAULT '', "obj" text NOT NULL, @@ -618,32 +622,32 @@ CREATE TABLE "item" ( "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, "deny_gid" text NOT NULL, - "item_restrict" bigint NOT NULL DEFAULT '0', - "item_flags" bigint NOT NULL DEFAULT '0', - "item_private" numeric(4) NOT NULL DEFAULT '0', - "item_unseen" smallint NOT NULL DEFAULT '0', - "item_wall" smallint NOT NULL DEFAULT '0', - "item_origin" smallint NOT NULL DEFAULT '0', - "item_starred" smallint NOT NULL DEFAULT '0', - "item_uplink" smallint NOT NULL DEFAULT '0', - "item_consensus" smallint NOT NULL DEFAULT '0', - "item_thread_top" smallint NOT NULL DEFAULT '0', - "item_notshown" smallint NOT NULL DEFAULT '0', - "item_nsfw" smallint NOT NULL DEFAULT '0', - "item_relay" smallint NOT NULL DEFAULT '0', - "item_mentionsme" smallint NOT NULL DEFAULT '0', - "item_nocomment" smallint NOT NULL DEFAULT '0', - "item_obscured" smallint NOT NULL DEFAULT '0', - "item_verified" smallint NOT NULL DEFAULT '0', - "item_retained" smallint NOT NULL DEFAULT '0', - "item_rss" smallint NOT NULL DEFAULT '0', - "item_deleted" smallint NOT NULL DEFAULT '0', - "item_type" int NOT NULL DEFAULT '0', - "item_hidden" smallint NOT NULL DEFAULT '0', - "item_unpublished" smallint NOT NULL DEFAULT '0', - "item_delayed" smallint NOT NULL DEFAULT '0', - "item_pending_remove" smallint NOT NULL DEFAULT '0', - "item_blocked" smallint NOT NULL DEFAULT '0', + "item_restrict" bigint NOT NULL DEFAULT 0 , + "item_flags" bigint NOT NULL DEFAULT 0 , + "item_private" numeric(4) NOT NULL DEFAULT 0 , + "item_unseen" smallint NOT NULL DEFAULT 0 , + "item_wall" smallint NOT NULL DEFAULT 0 , + "item_origin" smallint NOT NULL DEFAULT 0 , + "item_starred" smallint NOT NULL DEFAULT 0 , + "item_uplink" smallint NOT NULL DEFAULT 0 , + "item_consensus" smallint NOT NULL DEFAULT 0 , + "item_thread_top" smallint NOT NULL DEFAULT 0 , + "item_notshown" smallint NOT NULL DEFAULT 0 , + "item_nsfw" smallint NOT NULL DEFAULT 0 , + "item_relay" smallint NOT NULL DEFAULT 0 , + "item_mentionsme" smallint NOT NULL DEFAULT 0 , + "item_nocomment" smallint NOT NULL DEFAULT 0 , + "item_obscured" smallint NOT NULL DEFAULT 0 , + "item_verified" smallint NOT NULL DEFAULT 0 , + "item_retained" smallint NOT NULL DEFAULT 0 , + "item_rss" smallint NOT NULL DEFAULT 0 , + "item_deleted" smallint NOT NULL DEFAULT 0 , + "item_type" int NOT NULL DEFAULT 0 , + "item_hidden" smallint NOT NULL DEFAULT 0 , + "item_unpublished" smallint NOT NULL DEFAULT 0 , + "item_delayed" smallint NOT NULL DEFAULT 0 , + "item_pending_remove" smallint NOT NULL DEFAULT 0 , + "item_blocked" smallint NOT NULL DEFAULT 0 , "item_search_vector" tsvector, PRIMARY KEY ("id") ); @@ -721,14 +725,14 @@ create index "itemid_service" on item_id ("service"); create index "itemid_iid" on item_id ("iid"); CREATE TABLE "likes" ( "id" serial NOT NULL, - "channel_id" bigint NOT NULL DEFAULT '0', - "liker" char(128) NOT NULL DEFAULT '', - "likee" char(128) NOT NULL DEFAULT '', - "iid" bigint NOT NULL DEFAULT '0', - "i_mid" char(255) NOT NULL DEFAULT '', + "channel_id" bigint NOT NULL DEFAULT 0 , + "liker" varchar(128) NOT NULL DEFAULT '', + "likee" varchar(128) NOT NULL DEFAULT '', + "iid" bigint NOT NULL DEFAULT 0 , + "i_mid" varchar(255) NOT NULL DEFAULT '', "verb" text NOT NULL DEFAULT '', "target_type" text NOT NULL DEFAULT '', - "target_id" char(128) NOT NULL DEFAULT '', + "target_id" varchar(128) NOT NULL DEFAULT '', "target" text NOT NULL, PRIMARY KEY ("id") ); @@ -742,25 +746,27 @@ create index "likes_target_type" on likes ("target_type"); create index "likes_target_id" on likes ("target_id"); CREATE TABLE "mail" ( "id" serial NOT NULL, - "convid" bigint NOT NULL DEFAULT '0', + "convid" bigint NOT NULL DEFAULT 0 , "conv_guid" text NOT NULL, - "mail_flags" bigint NOT NULL DEFAULT '0', + "mail_flags" bigint NOT NULL DEFAULT 0 , "from_xchan" text NOT NULL DEFAULT '', "to_xchan" text NOT NULL DEFAULT '', - "account_id" bigint NOT NULL DEFAULT '0', - "channel_id" bigint NOT NULL DEFAULT '0', + "account_id" bigint NOT NULL DEFAULT 0 , + "channel_id" bigint NOT NULL DEFAULT 0 , + "mail_mimetype" varchar(64) NOT NULL DEFAULT 'text/bbcode', "title" text NOT NULL, "body" text NOT NULL, "sig" text NOT NULL, "attach" text NOT NULL DEFAULT '', "mid" text NOT NULL, "parent_mid" text NOT NULL, - "mail_deleted" smallint NOT NULL DEFAULT '0', - "mail_replied" smallint NOT NULL DEFAULT '0', - "mail_isreply" smallint NOT NULL DEFAULT '0', - "mail_seen" smallint NOT NULL DEFAULT '0', - "mail_recalled" smallint NOT NULL DEFAULT '0', - "mail_obscured" smallint NOT NULL DEFAULT '0', + "mail_deleted" smallint NOT NULL DEFAULT 0 , + "mail_replied" smallint NOT NULL DEFAULT 0 , + "mail_isreply" smallint NOT NULL DEFAULT 0 , + "mail_seen" smallint NOT NULL DEFAULT 0 , + "mail_recalled" smallint NOT NULL DEFAULT 0 , + "mail_obscured" smallint NOT NULL DEFAULT 0 , + "mail_raw" smallint NOT NULL DEFAULT 0 , "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY ("id") @@ -784,10 +790,10 @@ create index "mail_recalled" on mail ("mail_recalled"); create index "mail_obscured" on mail ("mail_obscured"); CREATE TABLE "menu" ( "menu_id" serial NOT NULL, - "menu_channel_id" bigint NOT NULL DEFAULT '0', + "menu_channel_id" bigint NOT NULL DEFAULT 0 , "menu_name" text NOT NULL DEFAULT '', "menu_desc" text NOT NULL DEFAULT '', - "menu_flags" bigint NOT NULL DEFAULT '0', + "menu_flags" bigint NOT NULL DEFAULT 0 , "menu_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "menu_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY ("menu_id") @@ -801,14 +807,14 @@ CREATE TABLE "menu_item" ( "mitem_id" serial NOT NULL, "mitem_link" text NOT NULL DEFAULT '', "mitem_desc" text NOT NULL DEFAULT '', - "mitem_flags" bigint NOT NULL DEFAULT '0', + "mitem_flags" bigint NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, "deny_gid" text NOT NULL, "mitem_channel_id" bigint NOT NULL, - "mitem_menu_id" bigint NOT NULL DEFAULT '0', - "mitem_order" bigint NOT NULL DEFAULT '0', + "mitem_menu_id" bigint NOT NULL DEFAULT 0 , + "mitem_order" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("mitem_id") ); @@ -817,7 +823,7 @@ create index "mitem_menu_id" on menu_item ("mitem_menu_id"); create index "mitem_flags" on menu_item ("mitem_flags"); CREATE TABLE "notify" ( "id" serial NOT NULL, - "hash" char(64) NOT NULL, + "hash" varchar(64) NOT NULL, "xname" text NOT NULL, "url" text NOT NULL, "photo" text NOT NULL, @@ -827,7 +833,7 @@ CREATE TABLE "notify" ( "uid" bigint NOT NULL, "link" text NOT NULL, "parent" text NOT NULL DEFAULT '', - "seen" numeric(1) NOT NULL DEFAULT '0', + "seen" numeric(1) NOT NULL DEFAULT 0 , "ntype" bigint NOT NULL, "verb" text NOT NULL, "otype" varchar(16) NOT NULL, @@ -844,14 +850,14 @@ create index "notify_otype" on notify ("otype"); create index "notify_aid" on notify ("aid"); CREATE TABLE "obj" ( "obj_id" serial NOT NULL, - "obj_page" char(64) NOT NULL DEFAULT '', + "obj_page" varchar(64) NOT NULL DEFAULT '', "obj_verb" text NOT NULL DEFAULT '', "obj_type" bigint NOT NULL DEFAULT 0, "obj_obj" text NOT NULL DEFAULT '', "obj_channel" bigint NOT NULL DEFAULT 0, - "obj_term" char(255) NOT NULL DEFAULT '', - "obj_url" char(255) NOT NULL DEFAULT '', - "obj_imgurl" char(255) NOT NULL DEFAULT '', + "obj_term" varchar(255) NOT NULL DEFAULT '', + "obj_url" varchar(255) NOT NULL DEFAULT '', + "obj_imgurl" varchar(255) NOT NULL DEFAULT '', "obj_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "obj_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "obj_quantity" bigint NOT NULL DEFAULT 0, @@ -876,18 +882,18 @@ create index "obj_quantity" on obj ("obj_quantity"); CREATE TABLE "outq" ( "outq_hash" text NOT NULL, - "outq_account" bigint NOT NULL DEFAULT '0', - "outq_channel" bigint NOT NULL DEFAULT '0', + "outq_account" bigint NOT NULL DEFAULT 0 , + "outq_channel" bigint NOT NULL DEFAULT 0 , "outq_driver" varchar(32) NOT NULL DEFAULT '', "outq_posturl" text NOT NULL DEFAULT '', - "outq_async" numeric(1) NOT NULL DEFAULT '0', - "outq_delivered" numeric(1) NOT NULL DEFAULT '0', + "outq_async" numeric(1) NOT NULL DEFAULT 0 , + "outq_delivered" numeric(1) NOT NULL DEFAULT 0 , "outq_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "outq_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "outq_scheduled" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "outq_notify" text NOT NULL, "outq_msg" text NOT NULL, - "outq_priority" smallint NOT NULL DEFAULT '0', + "outq_priority" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("outq_hash") ); create index "outq_account" on outq ("outq_account"); @@ -902,7 +908,7 @@ create index "outq_priority" on outq ("outq_priority"); CREATE TABLE "pconfig" ( "id" serial NOT NULL, - "uid" bigint NOT NULL DEFAULT '0', + "uid" bigint NOT NULL DEFAULT 0 , "cat" text NOT NULL, "k" text NOT NULL, "v" text NOT NULL, @@ -912,7 +918,7 @@ CREATE TABLE "pconfig" ( CREATE TABLE "photo" ( "id" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , "uid" bigint NOT NULL, "xchan" text NOT NULL DEFAULT '', "resource_id" text NOT NULL, @@ -925,16 +931,16 @@ CREATE TABLE "photo" ( "mimetype" varchar(128) NOT NULL DEFAULT 'image/jpeg', "height" numeric(6) NOT NULL, "width" numeric(6) NOT NULL, - "filesize" bigint NOT NULL DEFAULT '0', + "filesize" bigint NOT NULL DEFAULT 0 , "content" bytea NOT NULL, - "imgscale" numeric(3) NOT NULL DEFAULT '0', - "profile" numeric(1) NOT NULL DEFAULT '0', - "photo_usage" smallint NOT NULL DEFAULT '0', - "is_nsfw" smallint NOT NULL DEFAULT '0', - "os_storage" smallint NOT NULL DEFAULT '0', + "imgscale" numeric(3) NOT NULL DEFAULT 0 , + "profile" numeric(1) NOT NULL DEFAULT 0 , + "photo_usage" smallint NOT NULL DEFAULT 0 , + "is_nsfw" smallint NOT NULL DEFAULT 0 , + "os_storage" smallint NOT NULL DEFAULT 0 , "os_path" text NOT NULL, "display_path" text NOT NULL, - "photo_flags" bigint NOT NULL DEFAULT '0', + "photo_flags" bigint NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, @@ -957,10 +963,10 @@ create index "photo_os_storage" on photo ("os_storage"); CREATE TABLE "poll" ( "poll_id" serial NOT NULL, - "poll_channel" bigint NOT NULL DEFAULT '0', + "poll_channel" bigint NOT NULL DEFAULT 0 , "poll_desc" text NOT NULL, - "poll_flags" bigint NOT NULL DEFAULT '0', - "poll_votes" bigint NOT NULL DEFAULT '0', + "poll_flags" bigint NOT NULL DEFAULT 0 , + "poll_votes" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("poll_id") ); @@ -969,10 +975,10 @@ create index "poll_flags" on poll ("poll_flags"); create index "poll_votes" on poll ("poll_votes"); CREATE TABLE "poll_elm" ( "pelm_id" serial NOT NULL, - "pelm_poll" bigint NOT NULL DEFAULT '0', + "pelm_poll" bigint NOT NULL DEFAULT 0 , "pelm_desc" text NOT NULL, - "pelm_flags" bigint NOT NULL DEFAULT '0', - "pelm_result" float NOT NULL DEFAULT '0', + "pelm_flags" bigint NOT NULL DEFAULT 0 , + "pelm_result" float NOT NULL DEFAULT 0 , PRIMARY KEY ("pelm_id") ); create index "pelm_poll" on poll_elm ("pelm_poll"); @@ -990,7 +996,7 @@ CREATE TABLE "profdef" ( create index "profdef_field_name" on profdef ("field_name"); CREATE TABLE "profext" ( "id" serial NOT NULL, - "channel_id" bigint NOT NULL DEFAULT '0', + "channel_id" bigint NOT NULL DEFAULT 0 , "hash" text NOT NULL DEFAULT '', "k" text NOT NULL DEFAULT '', "v" text NOT NULL, @@ -1002,12 +1008,12 @@ create index "profext_k" on profext ("k"); CREATE TABLE "profile" ( "id" serial NOT NULL, - "profile_guid" char(64) NOT NULL DEFAULT '', - "aid" bigint NOT NULL DEFAULT '0', + "profile_guid" varchar(64) NOT NULL DEFAULT '', + "aid" bigint NOT NULL DEFAULT 0 , "uid" bigint NOT NULL, "profile_name" text NOT NULL, - "is_default" numeric(1) NOT NULL DEFAULT '0', - "hide_friends" numeric(1) NOT NULL DEFAULT '0', + "is_default" numeric(1) NOT NULL DEFAULT 0 , + "hide_friends" numeric(1) NOT NULL DEFAULT 0 , "fullname" text NOT NULL, "pdesc" text NOT NULL DEFAULT '', "chandesc" text NOT NULL DEFAULT '', @@ -1044,7 +1050,7 @@ CREATE TABLE "profile" ( "homepage" text NOT NULL DEFAULT '', "photo" text NOT NULL, "thumb" text NOT NULL, - "publish" numeric(1) NOT NULL DEFAULT '0', + "publish" numeric(1) NOT NULL DEFAULT 0 , "profile_vcard" text NOT NULL DEFAULT '', PRIMARY KEY ("id"), UNIQUE ("profile_guid","uid") @@ -1066,7 +1072,7 @@ create index "profile_guid" on profile ("profile_guid"); CREATE TABLE "profile_check" ( "id" serial NOT NULL, "uid" bigint NOT NULL, - "cid" bigint NOT NULL DEFAULT '0', + "cid" bigint NOT NULL DEFAULT 0 , "dfrn_id" text NOT NULL, "sec" text NOT NULL, "expire" bigint NOT NULL, @@ -1101,8 +1107,8 @@ create index "session_sid" on session ("sid"); create index "session_expire" on session ("expire"); CREATE TABLE "shares" ( "share_id" serial NOT NULL, - "share_type" bigint NOT NULL DEFAULT '0', - "share_target" bigint NOT NULL DEFAULT '0', + "share_type" bigint NOT NULL DEFAULT 0 , + "share_target" bigint NOT NULL DEFAULT 0 , "share_xchan" text NOT NULL DEFAULT '', PRIMARY KEY ("share_id") ); @@ -1112,8 +1118,8 @@ create index "share_xchan" on shares ("share_xchan"); CREATE TABLE "sign" ( "id" serial NOT NULL, - "iid" bigint NOT NULL DEFAULT '0', - "retract_iid" bigint NOT NULL DEFAULT '0', + "iid" bigint NOT NULL DEFAULT 0 , + "retract_iid" bigint NOT NULL DEFAULT 0 , "signed_text" text NOT NULL, "signature" text NOT NULL, "signer" text NOT NULL, @@ -1124,19 +1130,19 @@ create index "sign_retract_iid" on "sign" ("retract_iid"); CREATE TABLE "site" ( "site_url" text NOT NULL, - "site_access" bigint NOT NULL DEFAULT '0', - "site_flags" bigint NOT NULL DEFAULT '0', + "site_access" bigint NOT NULL DEFAULT 0 , + "site_flags" bigint NOT NULL DEFAULT 0 , "site_update" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "site_pull" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "site_sync" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "site_directory" text NOT NULL DEFAULT '', - "site_register" bigint NOT NULL DEFAULT '0', + "site_register" bigint NOT NULL DEFAULT 0 , "site_sellpage" text NOT NULL DEFAULT '', "site_location" text NOT NULL DEFAULT '', "site_realm" text 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" text NOT NULL DEFAULT '', "site_version" text NOT NULL DEFAULT '', "site_crypto" text NOT NULL DEFAULT '', @@ -1156,7 +1162,7 @@ create index "site_project" on site ("site_project"); CREATE TABLE "source" ( "src_id" serial NOT NULL, - "src_channel_id" bigint NOT NULL DEFAULT '0', + "src_channel_id" bigint NOT NULL DEFAULT 0 , "src_channel_xchan" text NOT NULL DEFAULT '', "src_xchan" text NOT NULL DEFAULT '', "src_patt" text NOT NULL DEFAULT '', @@ -1176,8 +1182,8 @@ CREATE TABLE "sys_perms" ( ); CREATE TABLE "term" ( "tid" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', - "uid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , + "uid" bigint NOT NULL DEFAULT 0 , "oid" bigint NOT NULL, "otype" numeric(3) NOT NULL, "ttype" numeric(3) NOT NULL, @@ -1212,11 +1218,11 @@ create index "tokens_uid" on tokens ("uid"); CREATE TABLE "updates" ( "ud_id" serial NOT NULL, - "ud_hash" char(128) NOT NULL, + "ud_hash" varchar(128) NOT NULL, "ud_guid" text NOT NULL DEFAULT '', "ud_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "ud_last" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "ud_flags" bigint NOT NULL DEFAULT '0', + "ud_flags" bigint NOT NULL DEFAULT 0 , "ud_addr" text NOT NULL DEFAULT '', PRIMARY KEY ("ud_id") ); @@ -1228,7 +1234,7 @@ create index "ud_addr" on updates ("ud_addr"); create index "ud_last" on updates ("ud_last"); CREATE TABLE "verify" ( "id" serial NOT NULL, - "channel" bigint NOT NULL DEFAULT '0', + "channel" bigint NOT NULL DEFAULT 0 , "vtype" varchar(32) NOT NULL DEFAULT '', "token" text NOT NULL DEFAULT '', "meta" text NOT NULL DEFAULT '', @@ -1242,8 +1248,8 @@ create index "verify_meta" on verify ("meta"); create index "verify_created" on verify ("created"); CREATE TABLE "vote" ( "vote_id" serial NOT NULL, - "vote_poll" bigint NOT NULL DEFAULT '0', - "vote_element" bigint NOT NULL DEFAULT '0', + "vote_poll" bigint NOT NULL DEFAULT 0 , + "vote_element" bigint NOT NULL DEFAULT 0 , "vote_result" text NOT NULL, "vote_xchan" text NOT NULL DEFAULT '', PRIMARY KEY ("vote_id"), @@ -1268,16 +1274,16 @@ CREATE TABLE "xchan" ( "xchan_name" text NOT NULL DEFAULT '', "xchan_network" text NOT NULL DEFAULT '', "xchan_instance_url" text NOT NULL DEFAULT '', - "xchan_flags" bigint NOT NULL DEFAULT '0', + "xchan_flags" bigint NOT NULL DEFAULT 0 , "xchan_photo_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "xchan_name_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "xchan_hidden" smallint NOT NULL DEFAULT '0', - "xchan_orphan" smallint NOT NULL DEFAULT '0', - "xchan_censored" smallint NOT NULL DEFAULT '0', - "xchan_selfcensored" smallint NOT NULL DEFAULT '0', - "xchan_system" smallint NOT NULL DEFAULT '0', - "xchan_pubforum" smallint NOT NULL DEFAULT '0', - "xchan_deleted" smallint NOT NULL DEFAULT '0', + "xchan_hidden" smallint NOT NULL DEFAULT 0 , + "xchan_orphan" smallint NOT NULL DEFAULT 0 , + "xchan_censored" smallint NOT NULL DEFAULT 0 , + "xchan_selfcensored" smallint NOT NULL DEFAULT 0 , + "xchan_system" smallint NOT NULL DEFAULT 0 , + "xchan_pubforum" smallint NOT NULL DEFAULT 0 , + "xchan_deleted" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("xchan_hash") ); create index "xchan_guid" on xchan ("xchan_guid"); @@ -1322,7 +1328,7 @@ create index "xconfig_cat" on xconfig ("cat"); create index "xconfig_k" on xconfig ("k"); CREATE TABLE "xign" ( "id" serial NOT NULL, - "uid" bigint NOT NULL DEFAULT '0', + "uid" bigint NOT NULL DEFAULT 0 , "xchan" text NOT NULL DEFAULT '', PRIMARY KEY ("id") ); @@ -1332,10 +1338,10 @@ CREATE TABLE "xlink" ( "xlink_id" serial NOT NULL, "xlink_xchan" text NOT NULL DEFAULT '', "xlink_link" text NOT NULL DEFAULT '', - "xlink_rating" bigint NOT NULL DEFAULT '0', + "xlink_rating" bigint NOT NULL DEFAULT 0 , "xlink_rating_text" TEXT NOT NULL DEFAULT '', "xlink_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "xlink_static" numeric(1) NOT NULL DEFAULT '0', + "xlink_static" numeric(1) NOT NULL DEFAULT 0 , "xlink_sig" text NOT NULL DEFAULT '', PRIMARY KEY ("xlink_id") ); @@ -1347,7 +1353,7 @@ create index "xlink_static" on xlink ("xlink_static"); CREATE TABLE "xperm" ( "xp_id" serial NOT NULL, "xp_client" varchar( 20 ) NOT NULL DEFAULT '', - "xp_channel" bigint NOT NULL DEFAULT '0', + "xp_channel" bigint NOT NULL DEFAULT 0 , "xp_perm" varchar( 64 ) NOT NULL DEFAULT '', PRIMARY KEY ("xp_id") ); @@ -1356,7 +1362,7 @@ create index "xp_channel" on xperm ("xp_channel"); create index "xp_perm" on xperm ("xp_perm"); CREATE TABLE "xprof" ( "xprof_hash" text NOT NULL, - "xprof_age" numeric(3) NOT NULL DEFAULT '0', + "xprof_age" numeric(3) NOT NULL DEFAULT 0 , "xprof_desc" text NOT NULL DEFAULT '', "xprof_dob" varchar(12) NOT NULL DEFAULT '', "xprof_gender" text NOT NULL DEFAULT '', @@ -1387,7 +1393,7 @@ CREATE TABLE "xtag" ( "xtag_id" serial NOT NULL, "xtag_hash" text NOT NULL, "xtag_term" text NOT NULL DEFAULT '', - "xtag_flags" bigint NOT NULL DEFAULT '0', + "xtag_flags" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("xtag_id") ); create index "xtag_term" on xtag ("xtag_term"); diff --git a/install/update.php b/install/update.php index 87cf4ba60..f9f1d0a3c 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1188 ); +define( 'UPDATE_VERSION' , 1191 ); /** * @@ -2475,7 +2475,7 @@ function update_r1184() { function update_r1185() { - $r1 = q("alter table app add app_plugin char(255) not null default '' "); + $r1 = q("alter table app add app_plugin text not null default '' "); if($r1) return UPDATE_SUCCESS; @@ -2508,4 +2508,41 @@ function update_r1187() { return UPDATE_FAILED; -}
\ No newline at end of file +} + +function update_r1188() { + + $r1 = q("alter table channel add channel_password varchar(255) not null default '' "); + $r2 = q("alter table channel add channel_salt varchar(255) not null default '' "); + + if($r1 && $r2) + return UPDATE_SUCCESS; + return UPDATE_FAILED; + +} + +function update_r1189() { + + $r1 = q("alter table mail add mail_mimetype varchar(64) not null default 'text/bbcode' "); + + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { + $r2 = q("alter table mail add mail_raw smallint not null default 0 "); + } + else { + $r2 = q("alter table mail add mail_raw tinyint(4) not null default 0 "); + } + if($r1 && $r2) + return UPDATE_SUCCESS; + return UPDATE_FAILED; + +} + +function update_r1190() { + $r1 = q("alter table abook add abook_not_here smallint not null default 0 "); + + $r2 = q("create index abook_not_here on abook (abook_not_here)"); + + if($r1 && $r2) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} |