X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fdatabase%2Fdb_user.md;h=e9306f8c5a9f2228bc05f8657cd122732219705c;hb=076cf702b03574d1ec154597b10d333ce5e9f68c;hp=21ca211d731fc98f7b2c7e0bada1d9955f6b5bec;hpb=8ec424325375aa923c7d2d78ac8ddcc352f09cff;p=friendica.git diff --git a/doc/database/db_user.md b/doc/database/db_user.md index 21ca211d73..e9306f8c5a 100644 --- a/doc/database/db_user.md +++ b/doc/database/db_user.md @@ -12,8 +12,8 @@ Table user | openid | | varchar(255) | NO | | | | | timezone | PHP-legal timezone | varchar(128) | NO | | | | | language | default language | varchar(32) | NO | | en | | -| register_date | timestamp of registration | datetime | NO | | 0000-00-00 00:00:00 | | -| login_date | timestamp of last login | datetime | NO | | 0000-00-00 00:00:00 | | +| register_date | timestamp of registration | datetime | NO | | 0001-01-01 00:00:00 | | +| login_date | timestamp of last login | datetime | NO | | 0001-01-01 00:00:00 | | | default-location | Default for item.location | varchar(255) | NO | | | | | allow_location | 1 allows to display the location | tinyint(1) | NO | | 0 | | | theme | user theme preference | varchar(255) | NO | | | | @@ -36,8 +36,8 @@ Table user | expire | | int(11) unsigned | NO | | 0 | | | account_removed | if 1 the account is removed | tinyint(1) | NO | | 0 | | | account_expired | | tinyint(1) | NO | | 0 | | -| account_expires_on | timestamp when account expires and will be deleted | datetime | NO | | 0000-00-00 00:00:00 | | -| expire_notification_sent | timestamp of last warning of account expiration | datetime | NO | | 0000-00-00 00:00:00 | | +| account_expires_on | timestamp when account expires and will be deleted | datetime | NO | | 0001-01-01 00:00:00 | | +| expire_notification_sent | timestamp of last warning of account expiration | datetime | NO | | 0001-01-01 00:00:00 | | | service_class | service class for this account, determines what if any limits/restrictions are in place | varchar(32) | NO | | | | | def_gid | | int(11) | NO | | 0 | | | allow_cid | default permission for this user | mediumtext | NO | | NULL | |