View Issue Detail

ID	Project	Category	Submitted / Last Updated
00936	UserSpice	Misc	2020-07-18 06:14:09 / 2020-10-20 03:16:47
Reported	Brandin Arsenault	Assigned To	Unassigned
Priority	low	Reported	5.1.4
Status	closed fixed	Resolution Version and Commit	5.1.7 e53610
Summary	Misc DB issues
Description	<p>Users</p> <p>> permissions - is this needed anymore? If so, the default value seems to be 1, set this in the DB. This column needs to be true/false 1/0, set this to BOOLEAN instead </p> <p>> logins - set this default to 0</p> <p>> account_owner - is this used in core? If not, pull it </p> <p>> account_id - is this used in core? If not, pull it</p> <p>> company - is this used in core? If not, pull it</p> <p>> join_date - why isn't there a default CURRENT_TIMESTAMP() for this?</p> <p>> email_verified - what are the options for this? true/false 1/0? if so, boolean it</p> <p>> active - is this what we use for blocking? if so, boolean it, otherwise, pull it</p> <p>> oauth_provider - this shouldnt be in core anymore</p> <p>> oauth_uid - this shouldnt be in core anymore</p> <p>> gender - remove</p> <p>> locale - remove??</p> <p>> gpluslink - remove this </p> <p>> picture, idk, should we have this by default? seems like pfps should be an addon, we use gravtar by default </p> <p>> created, this should use a default CURRENT_TIMESTAMP(), but why do we have this AND join_date?</p> <p>> modified, ON_UPDATE CURRENT_TIMESTAMP() should be applied to this</p> <p>> fb_uid - remove</p> <p>> un_changed - should this have a default value? what are its options? true/false 1/0? if so, boolean it</p> <p>> msg_exempt - remove, messaging isnt core </p> <p>> last_confirm - we dont do this in the db anymore right? if not, pull it</p> <p>> protected, boolean</p> <p>> dev_user, boolean? i dont know if we still need this, pull it if not </p> <p>> msg_notification - pull </p> <p>> force_pr - boolean</p> <p>> twoKey, twoEnabled, twoDate - pull </p> <p>> cloak_allowed - is cloaking still in core? if so it should be pluginified </p> <p>> org - this shouldnt be in core </p> <p>> account_mgr - this shouldnt be in core </p> <p>> oauth_tos_accepted - shouldnt be in core </p>

November 2021

<p>This is going to be a lot of work, but we'll get it.</p>