* Moved the `unread` value of messages out into a new table so that this value can now be user-specific

1 files changed, 8 insertions, 1 deletions

diff --git a/schema.sql b/schema.sql
index 5dd4a10..2171cde 100644
--- a/schema.sql
+++ b/schema.sql
@@ -69,6 +69,14 @@ CREATE TABLE `obj_member` (
     PRIMARY KEY (`guid`,`member`)
 );
 
+/* Scheme for logging if a message has been seen by a user on a wide scale */
+DROP TABLE IF EXISTS `msg_read`;
+CREATE TABLE `msg_read` (
+    `guid`   varchar(10)          NOT NULL,
+    `user`   varchar(10)          NOT NULL,
+    PRIMARY KEY (`guid`,`user`)
+);
+
 /* User objects - special attributes */
 /* Notice: 'timeUpdated' field should be used to store the time of the start of the user's current session */
 /* Notice: 'key' field is the user's hashed and salted password -- SHA256 */
@@ -135,7 +143,6 @@ DROP TABLE IF EXISTS `message`;
 CREATE TABLE `message` (
     `guid`   varchar(10)          NOT NULL,
     `author` varchar(10)          NOT NULL,
-    `unread` int(10) unsigned     NOT NULL DEFAULT 1,
     `message` text            DEFAULT NULL,
     PRIMARY KEY (`guid`)
 );