aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-rw-r--r--install/sample-nginx.conf2
-rw-r--r--install/schema_mysql.sql458
-rw-r--r--install/schema_postgres.sql398
-rw-r--r--install/update.php2
4 files changed, 430 insertions, 430 deletions
diff --git a/install/sample-nginx.conf b/install/sample-nginx.conf
index 85178596a..4121ff2ec 100644
--- a/install/sample-nginx.conf
+++ b/install/sample-nginx.conf
@@ -56,7 +56,7 @@ server {
ssl_certificate_key /etc/nginx/ssl/example.net.key;
ssl_session_timeout 5m;
ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
- ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-DSS-AES128-SHA256:DHE-DSS-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA:!DHE-RSA-AES128-GCM-SHA256:!DHE-RSA-AES256-GCM-SHA384:!DHE-RSA-AES128-SHA256:!DHE-RSA-AES256-SHA:!DHE-RSA-AES128-SHA:!DHE-RSA-AES256-SHA256:!DHE-RSA-CAMELLIA128-SHA:!DHE-RSA-CAMELLIA256-SHA;
+ ssl_ciphers ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS;
ssl_prefer_server_ciphers on;
fastcgi_param HTTPS on;
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)");