From 4c0c153b8f23a2e6cbd037591af982232cb77989 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Sun, 5 Mar 2017 16:18:09 -0800 Subject: move emoji emoticons (not reactions) to plugin --- install/update.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'install') diff --git a/install/update.php b/install/update.php index 87cf4ba60..dd3a42c78 100644 --- a/install/update.php +++ b/install/update.php @@ -2508,4 +2508,5 @@ function update_r1187() { return UPDATE_FAILED; -} \ No newline at end of file +} + -- cgit v1.2.3 From d7f4526a00dba2c6a97bc4c231f57c7aa179a691 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Wed, 12 Apr 2017 17:32:28 -0700 Subject: backend infrastructure for 'channel protection password'; which will be used to optionally encrypt export files and resolve channel/identity ownership/hijacking disputes --- install/schema_mysql.sql | 2 ++ install/schema_postgres.sql | 4 +++- install/update.php | 13 ++++++++++++- 3 files changed, 17 insertions(+), 2 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index be5317722..e075006e1 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -287,6 +287,8 @@ CREATE TABLE IF NOT EXISTS `channel` ( `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`), diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index e78425828..1a5fe942f 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -170,7 +170,7 @@ CREATE TABLE "attach" ( "is_photo" smallint NOT NULL DEFAULT '0', "os_storage" smallint NOT NULL DEFAULT '0', "os_path" text NOT NULL, - "display_path" text NOT NULL, +4 "display_path" text NOT NULL, "content" bytea NOT NULL, "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -280,6 +280,8 @@ CREATE TABLE "channel" ( "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") ); diff --git a/install/update.php b/install/update.php index dd3a42c78..b37af9cef 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ Date: Wed, 12 Apr 2017 18:48:06 -0700 Subject: typo --- install/schema_postgres.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 1a5fe942f..be72a85e1 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -170,7 +170,7 @@ CREATE TABLE "attach" ( "is_photo" smallint NOT NULL DEFAULT '0', "os_storage" smallint NOT NULL DEFAULT '0', "os_path" text NOT NULL, -4 "display_path" text NOT NULL, + "display_path" text NOT NULL, "content" bytea NOT NULL, "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', -- cgit v1.2.3 From a3b1eec5484eef8e2872df139cdd868222c95dda Mon Sep 17 00:00:00 2001 From: zotlabs Date: Wed, 12 Apr 2017 17:32:28 -0700 Subject: backend infrastructure for 'channel protection password'; which will be used to optionally encrypt export files and resolve channel/identity ownership/hijacking disputes --- install/schema_postgres.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index be72a85e1..1a5fe942f 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -170,7 +170,7 @@ CREATE TABLE "attach" ( "is_photo" smallint NOT NULL DEFAULT '0', "os_storage" smallint NOT NULL DEFAULT '0', "os_path" text NOT NULL, - "display_path" text NOT NULL, +4 "display_path" text NOT NULL, "content" bytea NOT NULL, "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', -- cgit v1.2.3 From d3feb93619b7e453d07710e0e32c3049eed85bcc Mon Sep 17 00:00:00 2001 From: zotlabs Date: Wed, 12 Apr 2017 18:48:06 -0700 Subject: typo --- install/schema_postgres.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 1a5fe942f..be72a85e1 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -170,7 +170,7 @@ CREATE TABLE "attach" ( "is_photo" smallint NOT NULL DEFAULT '0', "os_storage" smallint NOT NULL DEFAULT '0', "os_path" text NOT NULL, -4 "display_path" text NOT NULL, + "display_path" text NOT NULL, "content" bytea NOT NULL, "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', -- cgit v1.2.3 From 7d5ee81628a08dd560f7fdaa5b4d5a3f5ce3fb95 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Tue, 25 Apr 2017 21:52:24 -0700 Subject: database support for client side e2ee for private mail --- install/schema_mysql.sql | 2 ++ install/schema_postgres.sql | 2 ++ install/update.php | 13 ++++++++++++- 3 files changed, 16 insertions(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index e075006e1..b64c1ae61 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -763,6 +763,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( `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', + `mail_mimetype` char(64) NOT NULL DEFAULT 'text/bbcode', `title` text NOT NULL, `body` mediumtext NOT NULL, `sig` text NOT NULL, @@ -775,6 +776,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( `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`), diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index be72a85e1..0328040f4 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -751,6 +751,7 @@ CREATE TABLE "mail" ( "to_xchan" text NOT NULL DEFAULT '', "account_id" bigint NOT NULL DEFAULT '0', "channel_id" bigint NOT NULL DEFAULT '0', + "mail_mimetype char(64) NOT NULL DEFAULT '0', "title" text NOT NULL, "body" text NOT NULL, "sig" text NOT NULL, @@ -763,6 +764,7 @@ CREATE TABLE "mail" ( "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") diff --git a/install/update.php b/install/update.php index b37af9cef..84f1a799c 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ Date: Wed, 26 Apr 2017 19:47:05 -0700 Subject: issues from hubzilla:#737 --- install/update.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'install') diff --git a/install/update.php b/install/update.php index 84f1a799c..ce65d1db9 100644 --- a/install/update.php +++ b/install/update.php @@ -2512,8 +2512,8 @@ function update_r1187() { function update_r1188() { - $r1 = q("alter table channel add channel_password varchar(255) not null "); - $r2 = q("alter table channel add channel_salt varchar(255) not null "); + $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; -- cgit v1.2.3 From f9d40adb188ef09cb2d76d1bcab9d50391334b7a Mon Sep 17 00:00:00 2001 From: Andrew Manning Date: Sun, 30 Apr 2017 13:49:53 -0400 Subject: Update INSTALL.txt The webpage element portation tools need the zip extension, such as the `php7.0-zip` package on Debian. --- install/INSTALL.txt | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/INSTALL.txt b/install/INSTALL.txt index 7d4ed9534..c059fadf1 100644 --- a/install/INSTALL.txt +++ b/install/INSTALL.txt @@ -110,7 +110,7 @@ technical abilities. php.ini file - and with no hosting provider restrictions on the use of exec() and proc_open(). - - curl, gd (with at least jpeg and png support), mysqli, mbstring, xml, + - curl, gd (with at least jpeg and png support), mysqli, mbstring, xml, zip and openssl extensions. The imagick extension MAY be used instead of gd, but is not required and MAY also be disabled via configuration option. -- cgit v1.2.3 From b7df4de4b751203f43ccf73ca88a2ac3b6c39729 Mon Sep 17 00:00:00 2001 From: Klaus Weidenbach Date: Fri, 5 May 2017 23:13:54 +0200 Subject: :construction_worker::white_check_mark::bug: Import table structure in TravisCI. Fix a syntax error in schema_postres.sql which was discovered while working on this. --- install/schema_postgres.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 0328040f4..4c65d165d 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -751,7 +751,7 @@ CREATE TABLE "mail" ( "to_xchan" text NOT NULL DEFAULT '', "account_id" bigint NOT NULL DEFAULT '0', "channel_id" bigint NOT NULL DEFAULT '0', - "mail_mimetype char(64) NOT NULL DEFAULT '0', + "mail_mimetype" char(64) NOT NULL DEFAULT '0', "title" text NOT NULL, "body" text NOT NULL, "sig" text NOT NULL, -- cgit v1.2.3 From 3919c8f79f9f104e99b161e9034c68eba3fe86a0 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Wed, 3 May 2017 18:50:32 -0700 Subject: abook_not_here flag created to indicate singleton connections which are connected to this channel but not on this hub. abook_instance enumerates which hubs the connections is valid, but we ultimately need something more efficiently searchable to decide what operations are supported w/r/t this connection in the context of this hub. This flag is ignored during sync to clones although the code to set it correctly during channel creation, import, and sync has not yet been implemented. --- install/schema_mysql.sql | 2 ++ install/schema_postgres.sql | 2 ++ install/update.php | 11 ++++++++++- 3 files changed, 14 insertions(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index b64c1ae61..602f7ac2f 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -34,6 +34,7 @@ CREATE TABLE IF NOT EXISTS `abook` ( `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,6 +59,7 @@ 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; diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 4c65d165d..389cc6a84 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -32,6 +32,7 @@ CREATE TABLE "abook" ( "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" char(64) NOT NULL DEFAULT '', "abook_incl" TEXT NOT NULL DEFAULT '', "abook_excl" 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"); diff --git a/install/update.php b/install/update.php index ce65d1db9..65506a2f7 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ Date: Sun, 14 May 2017 18:37:36 -0700 Subject: always wonder about people who say "do as I say, not as I do..." --- install/schema_mysql.sql | 458 ++++++++++++++++++++++---------------------- install/schema_postgres.sql | 398 +++++++++++++++++++------------------- install/update.php | 2 +- 3 files changed, 429 insertions(+), 429 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 602f7ac2f..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,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(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_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(64) NOT NULL DEFAULT '', `abook_incl` TEXT NOT NULL DEFAULT '', `abook_excl` TEXT NOT NULL DEFAULT '', @@ -65,8 +65,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(255) NOT NULL DEFAULT '', `account_email` char(255) NOT NULL DEFAULT '', @@ -74,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`), @@ -100,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`), @@ -120,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', @@ -163,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, @@ -207,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; @@ -221,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 '', @@ -241,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 '', @@ -254,40 +254,40 @@ 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, @@ -335,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', @@ -347,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 '', @@ -361,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, @@ -386,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; @@ -403,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', @@ -415,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 '', @@ -434,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', @@ -447,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`), @@ -481,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`), @@ -495,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`), @@ -509,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`), @@ -524,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 '', @@ -534,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`), @@ -558,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`), @@ -575,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`), @@ -590,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', @@ -611,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, @@ -635,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`), @@ -723,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`), @@ -736,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 '', @@ -758,13 +758,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(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, @@ -772,13 +772,13 @@ CREATE TABLE IF NOT EXISTS `mail` ( `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_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`), @@ -803,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`), @@ -821,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`), @@ -843,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`), @@ -867,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, @@ -896,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`), @@ -922,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, @@ -933,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', @@ -944,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, @@ -978,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`), @@ -990,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`) @@ -1012,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, @@ -1025,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, @@ -1066,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`), @@ -1087,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`), @@ -1104,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`), @@ -1117,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`) @@ -1125,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`), @@ -1136,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 '', @@ -1148,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 '', @@ -1181,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, @@ -1197,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 '', @@ -1229,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`), @@ -1244,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`), @@ -1257,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 '', @@ -1272,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`), @@ -1299,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`), @@ -1355,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`), @@ -1366,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`), @@ -1382,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`), @@ -1392,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 '', @@ -1424,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 389cc6a84..a5231b40c 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,23 @@ 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_not_here" smallint NOT NULL DEFAULT '0', + "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" char(64) NOT NULL DEFAULT '', "abook_incl" TEXT NOT NULL DEFAULT '', "abook_excl" TEXT NOT NULL DEFAULT '', @@ -64,8 +64,8 @@ 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_parent" bigint NOT NULL DEFAULT 0 , + "account_default_channel" bigint NOT NULL DEFAULT 0 , "account_salt" char(32) NOT NULL DEFAULT '', "account_password" text NOT NULL DEFAULT '', "account_email" text NOT NULL DEFAULT '', @@ -73,13 +73,13 @@ CREATE TABLE "account" ( "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") ); @@ -97,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"); @@ -117,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', @@ -158,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, @@ -214,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, @@ -223,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"); @@ -234,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 '', @@ -247,40 +247,40 @@ 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, @@ -327,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', @@ -338,7 +338,7 @@ 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, @@ -352,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, @@ -376,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" ( @@ -403,7 +403,7 @@ 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_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 '', @@ -423,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', @@ -436,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_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") ); @@ -482,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") @@ -498,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") ); @@ -514,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 '', @@ -524,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"); @@ -546,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"); @@ -577,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', @@ -598,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, @@ -622,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") ); @@ -725,10 +725,10 @@ 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', + "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', + "iid" bigint NOT NULL DEFAULT 0 , "i_mid" char(255) NOT NULL DEFAULT '', "verb" text NOT NULL DEFAULT '', "target_type" text NOT NULL DEFAULT '', @@ -746,27 +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', - "mail_mimetype" char(64) NOT NULL DEFAULT '0', + "account_id" bigint NOT NULL DEFAULT 0 , + "channel_id" bigint NOT NULL DEFAULT 0 , + "mail_mimetype" char(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_raw" 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") @@ -790,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") @@ -807,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") ); @@ -833,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, @@ -882,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"); @@ -908,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, @@ -918,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, @@ -931,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, @@ -963,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") ); @@ -975,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"); @@ -996,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, @@ -1009,11 +1009,11 @@ 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', + "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 '', @@ -1050,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") @@ -1072,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, @@ -1107,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") ); @@ -1118,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, @@ -1130,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 '', @@ -1162,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 '', @@ -1182,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, @@ -1222,7 +1222,7 @@ CREATE TABLE "updates" ( "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") ); @@ -1234,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 '', @@ -1248,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"), @@ -1274,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"); @@ -1328,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") ); @@ -1338,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") ); @@ -1353,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") ); @@ -1362,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 '', @@ -1393,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 65506a2f7..ca347e4c2 100644 --- a/install/update.php +++ b/install/update.php @@ -2533,7 +2533,7 @@ function update_r1189() { } function update_r1190() { - $r1 = q("alter table abook add abook_not_here int(11) not null default '0' "); + $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)"); -- cgit v1.2.3 From 1a9fdc565cb86f0b7b4e570085c3bb4ba83f3176 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Mon, 15 May 2017 22:58:13 -0700 Subject: resolve merge conflict --- install/schema_postgres.sql | 44 ++++++++++++++++++++++---------------------- install/update.php | 4 ++-- 2 files changed, 24 insertions(+), 24 deletions(-) (limited to 'install') diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index a5231b40c..e171d9baf 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -33,7 +33,7 @@ CREATE TABLE "abook" ( "abook_self" smallint NOT NULL DEFAULT 0 , "abook_feed" smallint NOT NULL DEFAULT 0 , "abook_not_here" smallint NOT NULL DEFAULT 0 , - "abook_profile" char(64) NOT NULL DEFAULT '', + "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 '', @@ -66,7 +66,7 @@ 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_salt" varchar(32) NOT NULL DEFAULT '', "account_password" text NOT NULL DEFAULT '', "account_email" text NOT NULL DEFAULT '', "account_external" text NOT NULL DEFAULT '', @@ -342,7 +342,7 @@ CREATE TABLE "chatpresence" ( "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"); @@ -404,13 +404,13 @@ 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_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") ); @@ -443,7 +443,7 @@ CREATE TABLE "event" ( "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_repeat" text NOT NULL, @@ -726,13 +726,13 @@ 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 '', + "liker" varchar(128) NOT NULL DEFAULT '', + "likee" varchar(128) NOT NULL DEFAULT '', "iid" bigint NOT NULL DEFAULT 0 , - "i_mid" char(255) NOT NULL DEFAULT '', + "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") ); @@ -753,7 +753,7 @@ CREATE TABLE "mail" ( "to_xchan" text NOT NULL DEFAULT '', "account_id" bigint NOT NULL DEFAULT 0 , "channel_id" bigint NOT NULL DEFAULT 0 , - "mail_mimetype" char(64) NOT NULL DEFAULT 'text/bbcode', + "mail_mimetype" varchar(64) NOT NULL DEFAULT 'text/bbcode', "title" text NOT NULL, "body" text NOT NULL, "sig" text NOT NULL, @@ -823,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, @@ -850,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, @@ -1008,7 +1008,7 @@ create index "profext_k" on profext ("k"); CREATE TABLE "profile" ( "id" serial NOT NULL, - "profile_guid" char(64) NOT NULL DEFAULT '', + "profile_guid" varchar(64) NOT NULL DEFAULT '', "aid" bigint NOT NULL DEFAULT 0 , "uid" bigint NOT NULL, "profile_name" text NOT NULL, @@ -1218,7 +1218,7 @@ 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', diff --git a/install/update.php b/install/update.php index ca347e4c2..06084a422 100644 --- a/install/update.php +++ b/install/update.php @@ -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; @@ -2523,7 +2523,7 @@ function update_r1188() { function update_r1189() { - $r1 = q("alter table mail add mail_mimetype char(64) not null default 'text/bbcode' "); + $r1 = q("alter table mail add mail_mimetype varchar(64) not null default 'text/bbcode' "); $r2 = q("alter table mail add mail_raw int(4) not null default '0' "); if($r1 && $r2) -- cgit v1.2.3 From 11cecea597441d4bd688c3fa73e85b91a01ad173 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Sun, 28 May 2017 17:54:05 +0200 Subject: fix update_r1189() for mysql and postgres --- install/update.php | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'install') diff --git a/install/update.php b/install/update.php index 06084a422..f9f1d0a3c 100644 --- a/install/update.php +++ b/install/update.php @@ -2524,8 +2524,13 @@ function update_r1188() { function update_r1189() { $r1 = q("alter table mail add mail_mimetype varchar(64) not null default 'text/bbcode' "); - $r2 = q("alter table mail add mail_raw int(4) not null default '0' "); + 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; -- cgit v1.2.3