X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=8fa20be52c464b295f517d337ad9d7805a8459cc;hb=01558d6dda2fa18cdfd1860e53f60e0ccef62905;hp=71a5f0ae5fe9c9d77ad7ca78bdc7d2e0467c9101;hpb=66819fadfd823751e268b55141a1a69702e41e57;p=friendica.git diff --git a/database.sql b/database.sql index 71a5f0ae5f..8fa20be52c 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2022.12-dev (Giant Rhubarb) --- DB_UPDATE_VERSION 1489 +-- DB_UPDATE_VERSION 1491 -- ------------------------------------------ @@ -80,7 +80,7 @@ CREATE TABLE IF NOT EXISTS `user` ( `pwdreset` varchar(255) COMMENT 'Password reset request token', `pwdreset_time` datetime COMMENT 'Timestamp of the last password reset request', `maxreq` int unsigned NOT NULL DEFAULT 10 COMMENT '', - `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '', + `expire` int unsigned NOT NULL DEFAULT 0 COMMENT 'Delay in days before deleting user-related posts. Scope is controlled by pConfig.', `account_removed` boolean NOT NULL DEFAULT '0' COMMENT 'if 1 the account is removed', `account_expired` boolean NOT NULL DEFAULT '0' COMMENT '', `account_expires_on` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'timestamp when account expires and will be deleted', @@ -1651,7 +1651,7 @@ CREATE TABLE IF NOT EXISTS `register` ( -- CREATE TABLE IF NOT EXISTS `report` ( `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', - `uid` mediumint unsigned NOT NULL COMMENT 'Reporting user', + `uid` mediumint unsigned COMMENT 'Reporting user', `cid` int unsigned NOT NULL COMMENT 'Reported contact', `comment` text COMMENT 'Report', `forward` boolean COMMENT 'Forward the report to the remote server',