Use new race infrastructure for members stats

[ndwebbie.git] / database / ndawn.sql

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 2da8987c6f2f16ad7bcd5e16dee86e169be1783e..f1301f0df0c7f73ebf30dc6f24a69881dc92f51d 100644 (file)
--- a/database/ndawn.sql
+++ b/database/ndawn.sql
@@ -2142,6 +2142,7 @@ CREATE TABLE raids (
     tick integer NOT NULL,
     open boolean DEFAULT false NOT NULL,
     waves integer DEFAULT 3 NOT NULL,
+    open_tick integer,
     message text NOT NULL,
     removed boolean DEFAULT false NOT NULL,
     released_coords boolean DEFAULT false NOT NULL,
@@ -3316,6 +3317,8 @@ CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
 
 
+CREATE INDEX forum_threads_mtime_index ON forum_threads USING btree (mtime);
+
 --
 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: ndawn
 --