X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=aa87247db35c57dc2f68a079a1abe70995d28e6c;hb=e909beee040217c8164ebb13d34d8b118cb3ac59;hp=3f568a1dcf4a615b149907542ddc8cca460354a0;hpb=f68667e301728426923a3e4abf07dcf32b002f9f;p=friendica.git diff --git a/database.sql b/database.sql index 3f568a1dcf..aa87247db3 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ --- Friendica 3.6-dev (Asparagus) --- DB_UPDATE_VERSION 1253 +-- Friendica 2018-05-dev (The Tazmans Flax-lily) +-- DB_UPDATE_VERSION 1259 -- ------------------------------------------ @@ -8,12 +8,12 @@ -- TABLE addon -- CREATE TABLE IF NOT EXISTS `addon` ( - `id` int NOT NULL auto_increment COMMENT '', - `name` varchar(190) NOT NULL DEFAULT '' COMMENT '', - `version` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `name` varchar(50) NOT NULL DEFAULT '' COMMENT '', + `version` varchar(50) NOT NULL DEFAULT '' COMMENT '', `installed` boolean NOT NULL DEFAULT '0' COMMENT '', `hidden` boolean NOT NULL DEFAULT '0' COMMENT '', - `timestamp` bigint NOT NULL DEFAULT 0 COMMENT '', + `timestamp` int unsigned NOT NULL DEFAULT 0 COMMENT '', `plugin_admin` boolean NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY(`id`), UNIQUE INDEX `name` (`name`) @@ -23,12 +23,12 @@ CREATE TABLE IF NOT EXISTS `addon` ( -- TABLE attach -- CREATE TABLE IF NOT EXISTS `attach` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `hash` varchar(64) NOT NULL DEFAULT '' COMMENT '', `filename` varchar(255) NOT NULL DEFAULT '' COMMENT '', `filetype` varchar(64) NOT NULL DEFAULT '' COMMENT '', - `filesize` int NOT NULL DEFAULT 0 COMMENT '', + `filesize` int unsigned NOT NULL DEFAULT 0 COMMENT '', `data` longblob NOT NULL COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', @@ -55,22 +55,22 @@ CREATE TABLE IF NOT EXISTS `auth_codes` ( -- TABLE cache -- CREATE TABLE IF NOT EXISTS `cache` ( - `k` varbinary(255) NOT NULL COMMENT '', - `v` mediumtext COMMENT '', - `expire_mode` tinyint NOT NULL DEFAULT 0 COMMENT '', - `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', + `k` varbinary(255) NOT NULL COMMENT 'cache key', + `v` mediumtext COMMENT 'cached serialized value', + `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache expiration', + `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache insertion', PRIMARY KEY(`k`), - INDEX `expire_mode_updated` (`expire_mode`,`updated`) + INDEX `k_expires` (`k`,`expires`) ) DEFAULT COLLATE utf8mb4_general_ci; -- -- TABLE challenge -- CREATE TABLE IF NOT EXISTS `challenge` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `challenge` varchar(255) NOT NULL DEFAULT '' COMMENT '', `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `expire` int NOT NULL DEFAULT 0 COMMENT '', + `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '', `type` varchar(255) NOT NULL DEFAULT '' COMMENT '', `last_update` varchar(255) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY(`id`) @@ -85,7 +85,7 @@ CREATE TABLE IF NOT EXISTS `clients` ( `redirect_uri` varchar(200) NOT NULL DEFAULT '' COMMENT '', `name` text COMMENT '', `icon` text COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', PRIMARY KEY(`client_id`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -93,9 +93,9 @@ CREATE TABLE IF NOT EXISTS `clients` ( -- TABLE config -- CREATE TABLE IF NOT EXISTS `config` ( - `id` int NOT NULL auto_increment COMMENT '', - `cat` varbinary(255) NOT NULL DEFAULT '' COMMENT '', - `k` varbinary(255) NOT NULL DEFAULT '' COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `cat` varbinary(50) NOT NULL DEFAULT '' COMMENT '', + `k` varbinary(50) NOT NULL DEFAULT '' COMMENT '', `v` mediumtext COMMENT '', PRIMARY KEY(`id`), UNIQUE INDEX `cat_k` (`cat`,`k`) @@ -105,14 +105,14 @@ CREATE TABLE IF NOT EXISTS `config` ( -- TABLE contact -- CREATE TABLE IF NOT EXISTS `contact` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `self` boolean NOT NULL DEFAULT '0' COMMENT '', `remote_self` boolean NOT NULL DEFAULT '0' COMMENT '', - `rel` tinyint NOT NULL DEFAULT 0 COMMENT '', + `rel` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `duplex` boolean NOT NULL DEFAULT '0' COMMENT '', - `network` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `network` char(4) NOT NULL DEFAULT '' COMMENT '', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `nick` varchar(255) NOT NULL DEFAULT '' COMMENT '', `location` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -122,9 +122,9 @@ CREATE TABLE IF NOT EXISTS `contact` ( `xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT '', `attag` varchar(255) NOT NULL DEFAULT '' COMMENT '', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `photo` text COMMENT '', - `thumb` text COMMENT '', - `micro` text COMMENT '', + `photo` varchar(255) DEFAULT '' COMMENT '', + `thumb` varchar(255) DEFAULT '' COMMENT '', + `micro` varchar(255) DEFAULT '' COMMENT '', `site-pubkey` text COMMENT '', `issued-id` varchar(255) NOT NULL DEFAULT '' COMMENT '', `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -135,11 +135,11 @@ CREATE TABLE IF NOT EXISTS `contact` ( `pubkey` text COMMENT '', `prvkey` text COMMENT '', `batch` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `request` text COMMENT '', - `notify` text COMMENT '', - `poll` text COMMENT '', - `confirm` text COMMENT '', - `poco` text COMMENT '', + `request` varchar(255) COMMENT '', + `notify` varchar(255) COMMENT '', + `poll` varchar(255) COMMENT '', + `confirm` varchar(255) COMMENT '', + `poco` varchar(255) COMMENT '', `aes_allow` boolean NOT NULL DEFAULT '0' COMMENT '', `ret-aes` boolean NOT NULL DEFAULT '0' COMMENT '', `usehub` boolean NOT NULL DEFAULT '0' COMMENT '', @@ -153,7 +153,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `avatar-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `term-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `last-item` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', - `priority` tinyint NOT NULL DEFAULT 0 COMMENT '', + `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `blocked` boolean NOT NULL DEFAULT '1' COMMENT '', `readonly` boolean NOT NULL DEFAULT '0' COMMENT '', `writable` boolean NOT NULL DEFAULT '0' COMMENT '', @@ -165,13 +165,13 @@ CREATE TABLE IF NOT EXISTS `contact` ( `pending` boolean NOT NULL DEFAULT '1' COMMENT '', `rating` tinyint NOT NULL DEFAULT 0 COMMENT '', `reason` text COMMENT '', - `closeness` tinyint NOT NULL DEFAULT 99 COMMENT '', + `closeness` tinyint unsigned NOT NULL DEFAULT 99 COMMENT '', `info` mediumtext COMMENT '', - `profile-id` int NOT NULL DEFAULT 0 COMMENT '', + `profile-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', `bdyear` varchar(4) NOT NULL DEFAULT '' COMMENT '', `bd` date NOT NULL DEFAULT '0001-01-01' COMMENT '', `notify_new_posts` boolean NOT NULL DEFAULT '0' COMMENT '', - `fetch_further_information` tinyint NOT NULL DEFAULT 0 COMMENT '', + `fetch_further_information` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `ffi_keyword_blacklist` text COMMENT '', PRIMARY KEY(`id`), INDEX `uid_name` (`uid`,`name`(190)), @@ -179,8 +179,8 @@ CREATE TABLE IF NOT EXISTS `contact` ( INDEX `alias_uid` (`alias`(32),`uid`), INDEX `pending_uid` (`pending`,`uid`), INDEX `blocked_uid` (`blocked`,`uid`), - INDEX `uid_rel_network_poll` (`uid`,`rel`,`network`(4),`poll`(64),`archive`), - INDEX `uid_network_batch` (`uid`,`network`(4),`batch`(64)), + INDEX `uid_rel_network_poll` (`uid`,`rel`,`network`,`poll`(64),`archive`), + INDEX `uid_network_batch` (`uid`,`network`,`batch`(64)), INDEX `addr_uid` (`addr`(32),`uid`), INDEX `nurl_uid` (`nurl`(32),`uid`), INDEX `nick_uid` (`nick`(32),`uid`), @@ -192,10 +192,10 @@ CREATE TABLE IF NOT EXISTS `contact` ( -- TABLE conv -- CREATE TABLE IF NOT EXISTS `conv` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `guid` varchar(255) NOT NULL DEFAULT '' COMMENT '', `recips` text COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `creator` varchar(255) NOT NULL DEFAULT '' COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', @@ -212,7 +212,7 @@ CREATE TABLE IF NOT EXISTS `conversation` ( `reply-to-uri` varbinary(255) NOT NULL DEFAULT '' COMMENT '', `conversation-uri` varbinary(255) NOT NULL DEFAULT '' COMMENT '', `conversation-href` varbinary(255) NOT NULL DEFAULT '' COMMENT '', - `protocol` tinyint NOT NULL DEFAULT 0 COMMENT '', + `protocol` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `source` mediumtext COMMENT '', `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', PRIMARY KEY(`item-uri`), @@ -224,10 +224,10 @@ CREATE TABLE IF NOT EXISTS `conversation` ( -- TABLE event -- CREATE TABLE IF NOT EXISTS `event` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `guid` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `cid` int NOT NULL DEFAULT 0 COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `cid` int unsigned NOT NULL DEFAULT 0 COMMENT '', `uri` varchar(255) NOT NULL DEFAULT '' COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', @@ -236,7 +236,7 @@ CREATE TABLE IF NOT EXISTS `event` ( `summary` text COMMENT '', `desc` text COMMENT '', `location` text COMMENT '', - `type` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `type` varchar(20) NOT NULL DEFAULT '' COMMENT '', `nofinish` boolean NOT NULL DEFAULT '0' COMMENT '', `adjust` boolean NOT NULL DEFAULT '1' COMMENT '', `ignore` boolean NOT NULL DEFAULT '0' COMMENT '', @@ -252,7 +252,7 @@ CREATE TABLE IF NOT EXISTS `event` ( -- TABLE fcontact -- CREATE TABLE IF NOT EXISTS `fcontact` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `guid` varchar(255) NOT NULL DEFAULT '' COMMENT '', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -264,8 +264,8 @@ CREATE TABLE IF NOT EXISTS `fcontact` ( `notify` varchar(255) NOT NULL DEFAULT '' COMMENT '', `poll` varchar(255) NOT NULL DEFAULT '' COMMENT '', `confirm` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `priority` tinyint NOT NULL DEFAULT 0 COMMENT '', - `network` varchar(32) NOT NULL DEFAULT '' COMMENT '', + `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', + `network` char(4) NOT NULL DEFAULT '' COMMENT '', `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '', `pubkey` text COMMENT '', `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', @@ -278,9 +278,9 @@ CREATE TABLE IF NOT EXISTS `fcontact` ( -- TABLE fsuggest -- CREATE TABLE IF NOT EXISTS `fsuggest` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `cid` int NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `cid` int unsigned NOT NULL DEFAULT 0 COMMENT '', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '', `request` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -294,9 +294,9 @@ CREATE TABLE IF NOT EXISTS `fsuggest` ( -- TABLE gcign -- CREATE TABLE IF NOT EXISTS `gcign` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `gcid` int NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `gcid` int unsigned NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY(`id`), INDEX `uid` (`uid`), INDEX `gcid` (`gcid`) @@ -306,7 +306,7 @@ CREATE TABLE IF NOT EXISTS `gcign` ( -- TABLE gcontact -- CREATE TABLE IF NOT EXISTS `gcontact` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `nick` varchar(255) NOT NULL DEFAULT '' COMMENT '', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -326,18 +326,18 @@ CREATE TABLE IF NOT EXISTS `gcontact` ( `contact-type` tinyint NOT NULL DEFAULT -1 COMMENT '', `hide` boolean NOT NULL DEFAULT '0' COMMENT '', `nsfw` boolean NOT NULL DEFAULT '0' COMMENT '', - `network` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `network` char(4) NOT NULL DEFAULT '' COMMENT '', `addr` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `notify` text COMMENT '', + `notify` varchar(255) COMMENT '', `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `generation` tinyint NOT NULL DEFAULT 0 COMMENT '', + `generation` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `server_url` varchar(255) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY(`id`), UNIQUE INDEX `nurl` (`nurl`(190)), INDEX `name` (`name`(64)), INDEX `nick` (`nick`(32)), INDEX `addr` (`addr`(64)), - INDEX `hide_network_updated` (`hide`,`network`(4),`updated`), + INDEX `hide_network_updated` (`hide`,`network`,`updated`), INDEX `updated` (`updated`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -345,11 +345,11 @@ CREATE TABLE IF NOT EXISTS `gcontact` ( -- TABLE glink -- CREATE TABLE IF NOT EXISTS `glink` ( - `id` int NOT NULL auto_increment COMMENT '', - `cid` int NOT NULL DEFAULT 0 COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `gcid` int NOT NULL DEFAULT 0 COMMENT '', - `zcid` int NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `cid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `gcid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `zcid` int unsigned NOT NULL DEFAULT 0 COMMENT '', `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', PRIMARY KEY(`id`), UNIQUE INDEX `cid_uid_gcid_zcid` (`cid`,`uid`,`gcid`,`zcid`), @@ -360,8 +360,8 @@ CREATE TABLE IF NOT EXISTS `glink` ( -- TABLE group -- CREATE TABLE IF NOT EXISTS `group` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `visible` boolean NOT NULL DEFAULT '0' COMMENT '', `deleted` boolean NOT NULL DEFAULT '0' COMMENT '', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -373,9 +373,9 @@ CREATE TABLE IF NOT EXISTS `group` ( -- TABLE group_member -- CREATE TABLE IF NOT EXISTS `group_member` ( - `id` int NOT NULL auto_increment COMMENT '', - `gid` int NOT NULL DEFAULT 0 COMMENT '', - `contact-id` int NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `gid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY(`id`), INDEX `contactid` (`contact-id`), UNIQUE INDEX `gid_contactid` (`gid`,`contact-id`) @@ -385,18 +385,20 @@ CREATE TABLE IF NOT EXISTS `group_member` ( -- TABLE gserver -- CREATE TABLE IF NOT EXISTS `gserver` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '', `nurl` varchar(255) NOT NULL DEFAULT '' COMMENT '', `version` varchar(255) NOT NULL DEFAULT '' COMMENT '', `site_name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `info` text COMMENT '', `register_policy` tinyint NOT NULL DEFAULT 0 COMMENT '', - `registered-users` int NOT NULL DEFAULT 0 COMMENT '', + `registered-users` int unsigned NOT NULL DEFAULT 0 COMMENT '', `poco` varchar(255) NOT NULL DEFAULT '' COMMENT '', `noscrape` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `network` varchar(32) NOT NULL DEFAULT '' COMMENT '', + `network` char(4) NOT NULL DEFAULT '' COMMENT '', `platform` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `relay-subscribe` boolean NOT NULL DEFAULT '0' COMMENT 'Has the server subscribed to the relay system', + `relay-scope` varchar(10) NOT NULL DEFAULT '' COMMENT 'The scope of messages that the server wants to get', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `last_poco_query` datetime DEFAULT '0001-01-01 00:00:00' COMMENT '', `last_contact` datetime DEFAULT '0001-01-01 00:00:00' COMMENT '', @@ -405,27 +407,37 @@ CREATE TABLE IF NOT EXISTS `gserver` ( UNIQUE INDEX `nurl` (`nurl`(190)) ) DEFAULT COLLATE utf8mb4_general_ci; +-- +-- TABLE gserver-tag +-- +CREATE TABLE IF NOT EXISTS `gserver-tag` ( + `gserver-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'The id of the gserver', + `tag` varchar(100) NOT NULL DEFAULT '' COMMENT 'Tag that the server has subscribed', + PRIMARY KEY(`gserver-id`,`tag`), + INDEX `tag` (`tag`) +) DEFAULT COLLATE utf8mb4_general_ci; + -- -- TABLE hook -- CREATE TABLE IF NOT EXISTS `hook` ( - `id` int NOT NULL auto_increment COMMENT '', - `hook` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `file` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `function` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `priority` smallint NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `hook` varbinary(100) NOT NULL DEFAULT '' COMMENT '', + `file` varbinary(200) NOT NULL DEFAULT '' COMMENT '', + `function` varbinary(200) NOT NULL DEFAULT '' COMMENT '', + `priority` smallint unsigned NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY(`id`), - UNIQUE INDEX `hook_file_function` (`hook`(50),`file`(80),`function`(60)) + UNIQUE INDEX `hook_file_function` (`hook`,`file`,`function`) ) DEFAULT COLLATE utf8mb4_general_ci; -- -- TABLE intro -- CREATE TABLE IF NOT EXISTS `intro` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `fid` int NOT NULL DEFAULT 0 COMMENT '', - `contact-id` int NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `fid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', `knowyou` boolean NOT NULL DEFAULT '0' COMMENT '', `duplex` boolean NOT NULL DEFAULT '0' COMMENT '', `note` text COMMENT '', @@ -440,16 +452,15 @@ CREATE TABLE IF NOT EXISTS `intro` ( -- TABLE item -- CREATE TABLE IF NOT EXISTS `item` ( - `id` int NOT NULL auto_increment, + `id` int unsigned NOT NULL auto_increment, `guid` varchar(255) NOT NULL DEFAULT '' COMMENT '', `uri` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `contact-id` int NOT NULL DEFAULT 0 COMMENT '', - `gcontact-id` int NOT NULL DEFAULT 0 COMMENT '', - `type` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `type` varchar(20) NOT NULL DEFAULT '' COMMENT '', `wall` boolean NOT NULL DEFAULT '0' COMMENT '', - `gravity` tinyint NOT NULL DEFAULT 0 COMMENT '', - `parent` int NOT NULL DEFAULT 0 COMMENT '', + `gravity` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', + `parent` int unsigned NOT NULL DEFAULT 0 COMMENT '', `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT '', `extid` varchar(255) NOT NULL DEFAULT '' COMMENT '', `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -458,26 +469,27 @@ CREATE TABLE IF NOT EXISTS `item` ( `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', - `owner-id` int NOT NULL DEFAULT 0 COMMENT '', + `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', `owner-name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `owner-link` varchar(255) NOT NULL DEFAULT '' COMMENT '', `owner-avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `author-id` int NOT NULL DEFAULT 0 COMMENT '', + `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', `author-name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `author-link` varchar(255) NOT NULL DEFAULT '' COMMENT '', `author-avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `content-warning` varchar(255) NOT NULL DEFAULT '' COMMENT '', `body` mediumtext COMMENT '', `app` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `verb` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `object-type` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `verb` varchar(100) NOT NULL DEFAULT '' COMMENT '', + `object-type` varchar(100) NOT NULL DEFAULT '' COMMENT '', `object` text COMMENT '', - `target-type` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `target-type` varchar(100) NOT NULL DEFAULT '' COMMENT '', `target` text COMMENT '', `postopts` text COMMENT '', `plink` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `resource-id` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `event-id` int NOT NULL DEFAULT 0 COMMENT '', + `resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT '', + `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', `tag` mediumtext COMMENT '', `attach` mediumtext COMMENT '', `inform` mediumtext COMMENT '', @@ -498,9 +510,9 @@ CREATE TABLE IF NOT EXISTS `item` ( `unseen` boolean NOT NULL DEFAULT '1' COMMENT '', `deleted` boolean NOT NULL DEFAULT '0' COMMENT '', `origin` boolean NOT NULL DEFAULT '0' COMMENT '', - `forum_mode` tinyint NOT NULL DEFAULT 0 COMMENT '', + `forum_mode` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `mention` boolean NOT NULL DEFAULT '0' COMMENT '', - `network` varchar(32) NOT NULL DEFAULT '' COMMENT '', + `network` char(4) NOT NULL DEFAULT '' COMMENT '', `rendered-hash` varchar(32) NOT NULL DEFAULT '' COMMENT '', `rendered-html` mediumtext COMMENT '', `global` boolean NOT NULL DEFAULT '0' COMMENT '', @@ -513,19 +525,20 @@ CREATE TABLE IF NOT EXISTS `item` ( INDEX `uid_id` (`uid`,`id`), INDEX `uid_contactid_id` (`uid`,`contact-id`,`id`), INDEX `uid_created` (`uid`,`created`), + INDEX `uid_commented` (`uid`,`commented`), INDEX `uid_unseen_contactid` (`uid`,`unseen`,`contact-id`), - INDEX `uid_network_received` (`uid`,`network`(4),`received`), - INDEX `uid_network_commented` (`uid`,`network`(4),`commented`), + INDEX `uid_network_received` (`uid`,`network`,`received`), + INDEX `uid_network_commented` (`uid`,`network`,`commented`), INDEX `uid_thrparent` (`uid`,`thr-parent`(190)), INDEX `uid_parenturi` (`uid`,`parent-uri`(190)), INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`), INDEX `authorid_created` (`author-id`,`created`), INDEX `ownerid` (`owner-id`), INDEX `uid_uri` (`uid`,`uri`(190)), - INDEX `resource-id` (`resource-id`(191)), + INDEX `resource-id` (`resource-id`), INDEX `contactid_allowcid_allowpid_denycid_denygid` (`contact-id`,`allow_cid`(10),`allow_gid`(10),`deny_cid`(10),`deny_gid`(10)), - INDEX `uid_type_changed` (`uid`,`type`(190),`changed`), - INDEX `contactid_verb` (`contact-id`,`verb`(190)), + INDEX `uid_type_changed` (`uid`,`type`,`changed`), + INDEX `contactid_verb` (`contact-id`,`verb`), INDEX `deleted_changed` (`deleted`,`changed`), INDEX `uid_wall_changed` (`uid`,`wall`,`changed`), INDEX `uid_eventid` (`uid`,`event-id`), @@ -537,10 +550,10 @@ CREATE TABLE IF NOT EXISTS `item` ( -- TABLE locks -- CREATE TABLE IF NOT EXISTS `locks` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `name` varchar(128) NOT NULL DEFAULT '' COMMENT '', `locked` boolean NOT NULL DEFAULT '0' COMMENT '', - `pid` int NOT NULL DEFAULT 0 COMMENT '', + `pid` int unsigned NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY(`id`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -548,14 +561,14 @@ CREATE TABLE IF NOT EXISTS `locks` ( -- TABLE mail -- CREATE TABLE IF NOT EXISTS `mail` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `guid` varchar(255) NOT NULL DEFAULT '' COMMENT '', `from-name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `from-photo` varchar(255) NOT NULL DEFAULT '' COMMENT '', `from-url` varchar(255) NOT NULL DEFAULT '' COMMENT '', `contact-id` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `convid` int NOT NULL DEFAULT 0 COMMENT '', + `convid` int unsigned NOT NULL DEFAULT 0 COMMENT '', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '', `body` mediumtext COMMENT '', `seen` boolean NOT NULL DEFAULT '0' COMMENT '', @@ -577,8 +590,8 @@ CREATE TABLE IF NOT EXISTS `mail` ( -- TABLE mailacct -- CREATE TABLE IF NOT EXISTS `mailacct` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `server` varchar(255) NOT NULL DEFAULT '' COMMENT '', `port` smallint unsigned NOT NULL DEFAULT 0 COMMENT '', `ssltype` varchar(16) NOT NULL DEFAULT '' COMMENT '', @@ -586,7 +599,7 @@ CREATE TABLE IF NOT EXISTS `mailacct` ( `user` varchar(255) NOT NULL DEFAULT '' COMMENT '', `pass` text COMMENT '', `reply_to` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `action` tinyint NOT NULL DEFAULT 0 COMMENT '', + `action` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `movetofolder` varchar(255) NOT NULL DEFAULT '' COMMENT '', `pubmail` boolean NOT NULL DEFAULT '0' COMMENT '', `last_check` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', @@ -597,9 +610,9 @@ CREATE TABLE IF NOT EXISTS `mailacct` ( -- TABLE manage -- CREATE TABLE IF NOT EXISTS `manage` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `mid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `mid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', PRIMARY KEY(`id`), UNIQUE INDEX `uid_mid` (`uid`,`mid`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -608,21 +621,21 @@ CREATE TABLE IF NOT EXISTS `manage` ( -- TABLE notify -- CREATE TABLE IF NOT EXISTS `notify` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `hash` varchar(64) NOT NULL DEFAULT '' COMMENT '', - `type` smallint NOT NULL DEFAULT 0 COMMENT '', + `type` smallint unsigned NOT NULL DEFAULT 0 COMMENT '', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '', `photo` varchar(255) NOT NULL DEFAULT '' COMMENT '', `date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `msg` mediumtext COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `link` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `iid` int NOT NULL DEFAULT 0 COMMENT '', - `parent` int NOT NULL DEFAULT 0 COMMENT '', + `iid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `parent` int unsigned NOT NULL DEFAULT 0 COMMENT '', `seen` boolean NOT NULL DEFAULT '0' COMMENT '', - `verb` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `otype` varchar(16) NOT NULL DEFAULT '' COMMENT '', + `verb` varchar(100) NOT NULL DEFAULT '' COMMENT '', + `otype` varchar(10) NOT NULL DEFAULT '' COMMENT '', `name_cache` tinytext COMMENT '', `msg_cache` mediumtext COMMENT '', PRIMARY KEY(`id`), @@ -636,11 +649,11 @@ CREATE TABLE IF NOT EXISTS `notify` ( -- TABLE notify-threads -- CREATE TABLE IF NOT EXISTS `notify-threads` ( - `id` int NOT NULL auto_increment COMMENT '', - `notify-id` int NOT NULL DEFAULT 0 COMMENT '', - `master-parent-item` int NOT NULL DEFAULT 0 COMMENT '', - `parent-item` int NOT NULL DEFAULT 0 COMMENT '', - `receiver-uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `notify-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `master-parent-item` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `parent-item` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `receiver-uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', PRIMARY KEY(`id`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -649,7 +662,7 @@ CREATE TABLE IF NOT EXISTS `notify-threads` ( -- CREATE TABLE IF NOT EXISTS `oembed` ( `url` varbinary(255) NOT NULL COMMENT '', - `maxwidth` mediumint NOT NULL COMMENT '', + `maxwidth` mediumint unsigned NOT NULL COMMENT '', `content` mediumtext COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', PRIMARY KEY(`url`,`maxwidth`), @@ -673,10 +686,10 @@ CREATE TABLE IF NOT EXISTS `parsed_url` ( -- TABLE participation -- CREATE TABLE IF NOT EXISTS `participation` ( - `iid` int NOT NULL COMMENT '', + `iid` int unsigned NOT NULL COMMENT '', `server` varchar(60) NOT NULL COMMENT '', - `cid` int NOT NULL COMMENT '', - `fid` int NOT NULL COMMENT '', + `cid` int unsigned NOT NULL COMMENT '', + `fid` int unsigned NOT NULL COMMENT '', PRIMARY KEY(`iid`,`server`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -684,10 +697,10 @@ CREATE TABLE IF NOT EXISTS `participation` ( -- TABLE pconfig -- CREATE TABLE IF NOT EXISTS `pconfig` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `cat` varbinary(255) NOT NULL DEFAULT '' COMMENT '', - `k` varbinary(255) NOT NULL DEFAULT '' COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `cat` varbinary(50) NOT NULL DEFAULT '' COMMENT '', + `k` varbinary(100) NOT NULL DEFAULT '' COMMENT '', `v` mediumtext COMMENT '', PRIMARY KEY(`id`), UNIQUE INDEX `uid_cat_k` (`uid`,`cat`,`k`) @@ -697,23 +710,23 @@ CREATE TABLE IF NOT EXISTS `pconfig` ( -- TABLE photo -- CREATE TABLE IF NOT EXISTS `photo` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `contact-id` int NOT NULL DEFAULT 0 COMMENT '', - `guid` varchar(64) NOT NULL DEFAULT '' COMMENT '', - `resource-id` varchar(255) NOT NULL DEFAULT '' COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `guid` char(16) NOT NULL DEFAULT '' COMMENT '', + `resource-id` char(32) NOT NULL DEFAULT '' COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '', `desc` text COMMENT '', `album` varchar(255) NOT NULL DEFAULT '' COMMENT '', `filename` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `type` varchar(128) NOT NULL DEFAULT 'image/jpeg', - `height` smallint NOT NULL DEFAULT 0 COMMENT '', - `width` smallint NOT NULL DEFAULT 0 COMMENT '', - `datasize` int NOT NULL DEFAULT 0 COMMENT '', + `type` varchar(30) NOT NULL DEFAULT 'image/jpeg', + `height` smallint unsigned NOT NULL DEFAULT 0 COMMENT '', + `width` smallint unsigned NOT NULL DEFAULT 0 COMMENT '', + `datasize` int unsigned NOT NULL DEFAULT 0 COMMENT '', `data` mediumblob NOT NULL COMMENT '', - `scale` tinyint NOT NULL DEFAULT 0 COMMENT '', + `scale` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `profile` boolean NOT NULL DEFAULT '0' COMMENT '', `allow_cid` mediumtext COMMENT '', `allow_gid` mediumtext COMMENT '', @@ -724,16 +737,16 @@ CREATE TABLE IF NOT EXISTS `photo` ( INDEX `uid_contactid` (`uid`,`contact-id`), INDEX `uid_profile` (`uid`,`profile`), INDEX `uid_album_scale_created` (`uid`,`album`(32),`scale`,`created`), - INDEX `uid_album_resource-id_created` (`uid`,`album`(32),`resource-id`(64),`created`), - INDEX `resource-id` (`resource-id`(64)) + INDEX `uid_album_resource-id_created` (`uid`,`album`(32),`resource-id`,`created`), + INDEX `resource-id` (`resource-id`) ) DEFAULT COLLATE utf8mb4_general_ci; -- -- TABLE poll -- CREATE TABLE IF NOT EXISTS `poll` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `q0` text COMMENT '', `q1` text COMMENT '', `q2` text COMMENT '', @@ -752,9 +765,9 @@ CREATE TABLE IF NOT EXISTS `poll` ( -- TABLE poll_result -- CREATE TABLE IF NOT EXISTS `poll_result` ( - `id` int NOT NULL auto_increment COMMENT '', - `poll_id` int NOT NULL DEFAULT 0, - `choice` tinyint NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `poll_id` int unsigned NOT NULL DEFAULT 0, + `choice` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY(`id`), INDEX `poll_id` (`poll_id`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -763,7 +776,7 @@ CREATE TABLE IF NOT EXISTS `poll_result` ( -- TABLE process -- CREATE TABLE IF NOT EXISTS `process` ( - `pid` int NOT NULL COMMENT '', + `pid` int unsigned NOT NULL COMMENT '', `command` varbinary(32) NOT NULL DEFAULT '' COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', PRIMARY KEY(`pid`), @@ -774,8 +787,8 @@ CREATE TABLE IF NOT EXISTS `process` ( -- TABLE profile -- CREATE TABLE IF NOT EXISTS `profile` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `profile-name` varchar(255) NOT NULL DEFAULT '' COMMENT '', `is-default` boolean NOT NULL DEFAULT '0' COMMENT '', `hide-friends` boolean NOT NULL DEFAULT '0' COMMENT '', @@ -824,12 +837,12 @@ CREATE TABLE IF NOT EXISTS `profile` ( -- TABLE profile_check -- CREATE TABLE IF NOT EXISTS `profile_check` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `cid` int NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `cid` int unsigned NOT NULL DEFAULT 0 COMMENT '', `dfrn_id` varchar(255) NOT NULL DEFAULT '' COMMENT '', `sec` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `expire` int NOT NULL DEFAULT 0 COMMENT '', + `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY(`id`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -837,12 +850,12 @@ CREATE TABLE IF NOT EXISTS `profile_check` ( -- TABLE push_subscriber -- CREATE TABLE IF NOT EXISTS `push_subscriber` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `callback_url` varchar(255) NOT NULL DEFAULT '' COMMENT '', `topic` varchar(255) NOT NULL DEFAULT '' COMMENT '', `nickname` varchar(255) NOT NULL DEFAULT '' COMMENT '', - `push` tinyint NOT NULL DEFAULT 0 COMMENT '', + `push` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `last_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `secret` varchar(255) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY(`id`) @@ -852,9 +865,9 @@ CREATE TABLE IF NOT EXISTS `push_subscriber` ( -- TABLE queue -- CREATE TABLE IF NOT EXISTS `queue` ( - `id` int NOT NULL auto_increment COMMENT '', - `cid` int NOT NULL DEFAULT 0 COMMENT 'Message receiver', - `network` varchar(32) NOT NULL DEFAULT '' COMMENT 'Receiver\'s network', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Message receiver', + `network` char(4) NOT NULL DEFAULT '' COMMENT 'Receiver\'s network', `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Unique GUID of the message', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date, when the message was created', `last` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last trial', @@ -871,10 +884,10 @@ CREATE TABLE IF NOT EXISTS `queue` ( -- TABLE register -- CREATE TABLE IF NOT EXISTS `register` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `hash` varchar(255) NOT NULL DEFAULT '' COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `password` varchar(255) NOT NULL DEFAULT '' COMMENT '', `language` varchar(16) NOT NULL DEFAULT '' COMMENT '', `note` text COMMENT '', @@ -885,8 +898,8 @@ CREATE TABLE IF NOT EXISTS `register` ( -- TABLE search -- CREATE TABLE IF NOT EXISTS `search` ( - `id` int NOT NULL auto_increment COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', `term` varchar(255) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY(`id`), INDEX `uid` (`uid`) @@ -896,10 +909,10 @@ CREATE TABLE IF NOT EXISTS `search` ( -- TABLE session -- CREATE TABLE IF NOT EXISTS `session` ( - `id` bigint NOT NULL auto_increment COMMENT '', + `id` bigint unsigned NOT NULL auto_increment COMMENT '', `sid` varbinary(255) NOT NULL DEFAULT '' COMMENT '', `data` text COMMENT '', - `expire` int NOT NULL DEFAULT 0 COMMENT '', + `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY(`id`), INDEX `sid` (`sid`(64)), INDEX `expire` (`expire`) @@ -909,8 +922,8 @@ CREATE TABLE IF NOT EXISTS `session` ( -- TABLE sign -- CREATE TABLE IF NOT EXISTS `sign` ( - `id` int NOT NULL auto_increment COMMENT '', - `iid` int NOT NULL DEFAULT 0 COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', + `iid` int unsigned NOT NULL DEFAULT 0 COMMENT '', `signed_text` mediumtext COMMENT '', `signature` text COMMENT '', `signer` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -922,18 +935,18 @@ CREATE TABLE IF NOT EXISTS `sign` ( -- TABLE term -- CREATE TABLE IF NOT EXISTS `term` ( - `tid` int NOT NULL auto_increment COMMENT '', - `oid` int NOT NULL DEFAULT 0 COMMENT '', - `otype` tinyint NOT NULL DEFAULT 0 COMMENT '', - `type` tinyint NOT NULL DEFAULT 0 COMMENT '', + `tid` int unsigned NOT NULL auto_increment COMMENT '', + `oid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `otype` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', + `type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `term` varchar(255) NOT NULL DEFAULT '' COMMENT '', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '', `guid` varchar(255) NOT NULL DEFAULT '' COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `global` boolean NOT NULL DEFAULT '0' COMMENT '', - `aid` int NOT NULL DEFAULT 0 COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `aid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', PRIMARY KEY(`tid`), INDEX `oid_otype_type_term` (`oid`,`otype`,`type`,`term`(32)), INDEX `uid_otype_type_term_global_created` (`uid`,`otype`,`type`,`term`(32),`global`,`created`), @@ -945,12 +958,11 @@ CREATE TABLE IF NOT EXISTS `term` ( -- TABLE thread -- CREATE TABLE IF NOT EXISTS `thread` ( - `iid` int NOT NULL DEFAULT 0 COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', - `contact-id` int NOT NULL DEFAULT 0 COMMENT '', - `gcontact-id` int NOT NULL DEFAULT 0 COMMENT '', - `owner-id` int NOT NULL DEFAULT 0 COMMENT '', - `author-id` int NOT NULL DEFAULT 0 COMMENT '', + `iid` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', @@ -968,9 +980,9 @@ CREATE TABLE IF NOT EXISTS `thread` ( `unseen` boolean NOT NULL DEFAULT '1' COMMENT '', `deleted` boolean NOT NULL DEFAULT '0' COMMENT '', `origin` boolean NOT NULL DEFAULT '0' COMMENT '', - `forum_mode` tinyint NOT NULL DEFAULT 0 COMMENT '', + `forum_mode` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `mention` boolean NOT NULL DEFAULT '0' COMMENT '', - `network` varchar(32) NOT NULL DEFAULT '' COMMENT '', + `network` char(4) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY(`iid`), INDEX `uid_network_commented` (`uid`,`network`,`commented`), INDEX `uid_network_created` (`uid`,`network`,`created`), @@ -994,7 +1006,7 @@ CREATE TABLE IF NOT EXISTS `tokens` ( `client_id` varchar(20) NOT NULL DEFAULT '', `expires` int NOT NULL DEFAULT 0 COMMENT '', `scope` varchar(200) NOT NULL DEFAULT '' COMMENT '', - `uid` mediumint NOT NULL DEFAULT 0 COMMENT 'User id', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', PRIMARY KEY(`id`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -1002,8 +1014,8 @@ CREATE TABLE IF NOT EXISTS `tokens` ( -- TABLE user -- CREATE TABLE IF NOT EXISTS `user` ( - `uid` mediumint NOT NULL auto_increment COMMENT '', - `parent-uid` mediumint NOT NULL DEFAULT 0 COMMENT 'The parent user that has full control about this user', + `uid` mediumint unsigned NOT NULL auto_increment COMMENT '', + `parent-uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'The parent user that has full control about this user', `guid` varchar(64) NOT NULL DEFAULT '' COMMENT '', `username` varchar(255) NOT NULL DEFAULT '' COMMENT '', `password` varchar(255) NOT NULL DEFAULT '' COMMENT '', @@ -1028,20 +1040,20 @@ CREATE TABLE IF NOT EXISTS `user` ( `hidewall` boolean NOT NULL DEFAULT '0' COMMENT '', `blocktags` boolean NOT NULL DEFAULT '0' COMMENT '', `unkmail` boolean NOT NULL DEFAULT '0' COMMENT '', - `cntunkmail` int NOT NULL DEFAULT 10 COMMENT '', + `cntunkmail` int unsigned NOT NULL DEFAULT 10 COMMENT '', `notify-flags` smallint unsigned NOT NULL DEFAULT 65535 COMMENT '', - `page-flags` tinyint NOT NULL DEFAULT 0 COMMENT '', - `account-type` tinyint NOT NULL DEFAULT 0 COMMENT '', + `page-flags` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', + `account-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '', `prvnets` boolean NOT NULL DEFAULT '0' COMMENT '', `pwdreset` varchar(255) COMMENT 'Password reset request token', `pwdreset_time` datetime COMMENT 'Timestamp of the last password reset request', - `maxreq` int NOT NULL DEFAULT 10 COMMENT '', - `expire` int NOT NULL DEFAULT 0 COMMENT '', + `maxreq` int unsigned NOT NULL DEFAULT 10 COMMENT '', + `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '', `account_removed` boolean NOT NULL DEFAULT '0' COMMENT '', `account_expired` boolean NOT NULL DEFAULT '0' COMMENT '', `account_expires_on` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', `expire_notification_sent` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '', - `def_gid` int NOT NULL DEFAULT 0 COMMENT '', + `def_gid` int unsigned NOT NULL DEFAULT 0 COMMENT '', `allow_cid` mediumtext COMMENT '', `allow_gid` mediumtext COMMENT '', `deny_cid` mediumtext COMMENT '', @@ -1055,7 +1067,7 @@ CREATE TABLE IF NOT EXISTS `user` ( -- TABLE userd -- CREATE TABLE IF NOT EXISTS `userd` ( - `id` int NOT NULL auto_increment COMMENT '', + `id` int unsigned NOT NULL auto_increment COMMENT '', `username` varchar(255) NOT NULL COMMENT '', PRIMARY KEY(`id`), INDEX `username` (`username`(32)) @@ -1065,11 +1077,11 @@ CREATE TABLE IF NOT EXISTS `userd` ( -- TABLE workerqueue -- CREATE TABLE IF NOT EXISTS `workerqueue` ( - `id` int NOT NULL auto_increment COMMENT 'Auto incremented worker task id', + `id` int unsigned NOT NULL auto_increment COMMENT 'Auto incremented worker task id', `parameter` mediumblob COMMENT 'Task command', - `priority` tinyint NOT NULL DEFAULT 0 COMMENT 'Task priority', + `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Task priority', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation date', - `pid` int NOT NULL DEFAULT 0 COMMENT 'Process id of the worker', + `pid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Process id of the worker', `executed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Execution date', `done` boolean NOT NULL DEFAULT '0' COMMENT 'Marked when the task was done, will be deleted later', PRIMARY KEY(`id`), @@ -1079,3 +1091,4 @@ CREATE TABLE IF NOT EXISTS `workerqueue` ( INDEX `executed` (`executed`) ) DEFAULT COLLATE utf8mb4_general_ci; +