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