View Issue Detail

ID	Project	Category	Submitted / Last Updated
00034	UserSpice	User Management Code	2018-03-10 21:15:30 / 2018-05-19 19:15:47
Reported	Brandin Arsenault	Assigned To	Unassigned
Priority	low	Reported	4.3.14
Status	closed fixed	Resolution Version and Commit	4.3.21 cd2b64
Summary	If you change your password any remote sessions should be destroyed
Description	<p>Try using a password ID that is checked in session and destroyed if it doesn't match the DB???</p> <p> </p>

November 2021

<pre style="font-family: 'Courier New'; font-size: 9pt;"><span style="color: #000080; font-weight: bold;">CREATE TABLE </span>us_user_sessions (<br /> <span style="color: #660e7a; font-weight: bold;">kUserSessionID </span><span style="color: #000080; font-weight: bold;">int</span>(<span style="color: #0000ff;">11</span>) <span style="color: #000080; font-weight: bold;">UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT</span>,<br /> <span style="color: #660e7a; font-weight: bold;">fkUserID </span><span style="color: #000080; font-weight: bold;">int</span>(<span style="color: #0000ff;">11</span>) <span style="color: #000080; font-weight: bold;">UNSIGNED NOT NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserFingerprint </span><span style="color: #000080; font-weight: bold;">varchar</span>(<span style="color: #0000ff;">255</span>) <span style="color: #000080; font-weight: bold;">NOT NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionIP </span><span style="color: #000080; font-weight: bold;">varchar</span>(<span style="color: #0000ff;">255</span>) <span style="color: #000080; font-weight: bold;">NOT NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionOS </span><span style="color: #000080; font-weight: bold;">varchar</span>(<span style="color: #0000ff;">255</span>) <span style="color: #000080; font-weight: bold;">NOT NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionBrowser </span><span style="color: #000080; font-weight: bold;">varchar</span>(<span style="color: #0000ff;">255</span>) <span style="color: #000080; font-weight: bold;">NOT NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionStarted </span><span style="color: #000080; font-weight: bold;">timestamp NOT NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionLastUsed </span><span style="color: #000080; font-weight: bold;">datetime NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionLastPage </span><span style="color: #000080; font-weight: bold;">varchar</span>(<span style="color: #0000ff;">255</span>) <span style="color: #000080; font-weight: bold;">NOT NULL</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionEnded </span><span style="color: #000080; font-weight: bold;">tinyint</span>(<span style="color: #0000ff;">1</span>) <span style="color: #000080; font-weight: bold;">NOT NULL DEFAULT </span><span style="color: #0000ff;">0</span>,<br /> <span style="color: #660e7a; font-weight: bold;">UserSessionEnded_Time </span><span style="color: #000080; font-weight: bold;">datetime DEFAULT NULL<br /></span>);</pre>