Presence - Revision history

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T01:45:08Z

Minor formatting changes to match other database documentation pages

Kcozens: Changed colour of table headers and alternate lines in Table Structure table

2016-04-12T00:13:32Z

Changed colour of table headers and alternate lines in Table Structure table

Kcozens: Created

2016-04-11T23:55:48Z

Created

Justincc: Created page with "

 +-----------------+--------------+------+-----+--------------------------------------+-----------------------------+ | Field           | Type         | Null | Key | Default..."

2012-12-31T22:46:55Z

New page

<pre>
+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
| UserID | varchar(255) | NO | MUL | NULL | |
| RegionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | |
| SessionID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | |
| SecureSessionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | |
| LastSeen | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
</pre>

@@ Line 31: / Line 31: @@
 | '''[[#lastSeen|LastSeen]]''' || timestamp || utf8_general_ci || || No || CURRENT_TIMESTAMP ||
 |}
 <br />
 <br />
@@ Line 53: / Line 57: @@
 ----
-       (back to [[Database Documentation]])
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-−
 <br />
 [[Category:Database]]

@@ Line 12: / Line 12: @@
 <br />
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type
@@ Line 22: / Line 22: @@
 |-
 | '''[[#userID|UserID]]''' || varchar(255) || utf8_general_ci || || No || NULL ||
-|-
+|- style="background:#eee;"
 | '''[[#regionID|RegionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||
 |-
 | '''[[#sessionID|SessionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||
-|-
+|- style="background:#eee;"
 | '''[[#secureSessionID|SecureSessionID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||
 |-

@@ Line 1: / Line 1: @@
-<pre>
+__NOTOC__
-+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
+{{Quicklinks}}
-| Field           | Type         | Null | Key | Default                              | Extra                       |
+<br />
-+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
-| UserID          | varchar(255) | NO   | MUL | NULL                                 |                             |
+The '''Presence''' table contains region and session information for currently logged in users. Used for IM routing amongst other things.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-| RegionID        | char(36)     | NO   |     | 00000000-0000-0000-0000-000000000000 |                             |
+<br />
-| SessionID       | char(36)     | NO   | PRI | 00000000-0000-0000-0000-000000000000 |                             |
+<br />
-| SecureSessionID | char(36)     | NO   |     | 00000000-0000-0000-0000-000000000000 |                             |
-| LastSeen        | timestamp    | NO   |     | CURRENT_TIMESTAMP                    | on update CURRENT_TIMESTAMP |
+== Presence Table Structure ==
-+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
-</pre>
+The structure of the Presence table is as follows: