diff options
Diffstat (limited to 'util')
| -rw-r--r-- | util/dump.sql | 1 | ||||
| -rw-r--r-- | util/updates/update_2.8.sql | 5 |
2 files changed, 6 insertions, 0 deletions
diff --git a/util/dump.sql b/util/dump.sql index 10d13b9d..c952c162 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -240,6 +240,7 @@ CREATE TABLE threads_boards ( tid integer NOT NULL DEFAULT 0, type character(2) NOT NULL DEFAULT 0, iid integer NOT NULL DEFAULT 0, + lastread smallint NOT NULL, PRIMARY KEY(tid, type, iid) ); diff --git a/util/updates/update_2.8.sql b/util/updates/update_2.8.sql index 2993467c..a90b3ac2 100644 --- a/util/updates/update_2.8.sql +++ b/util/updates/update_2.8.sql @@ -59,3 +59,8 @@ ALTER TABLE releases_producers ADD COLUMN developer boolean NOT NULL DEFAULT FAL ALTER TABLE releases_producers ADD COLUMN publisher boolean NOT NULL DEFAULT TRUE; ALTER TABLE releases_producers ADD CHECK(developer OR publisher); + +-- Keep track of last read post for PMs +ALTER TABLE threads_boards ADD COLUMN lastread smallint; + + |