X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fndawn.sql;h=f1301f0df0c7f73ebf30dc6f24a69881dc92f51d;hb=75707e9b9cb6a816379ac2a8ac0c215a4bbe2545;hp=177a3f9139ea61b381ef72492e0bfc3082bbcdcb;hpb=5e6cbd6690cb6007e3cadd5b93e93b8b12a09f56;p=ndwebbie.git

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 177a3f9..f1301f0 100644
--- a/database/ndawn.sql
+++ b/database/ndawn.sql
@@ -1462,10 +1462,10 @@ CREATE TABLE email_change (
     id text DEFAULT md5(((now() + (random() * '100 years'::interval)))::text) NOT NULL,
     uid integer NOT NULL,
     email text NOT NULL,
-    confirmed boolean DEFAULT false NOT NULL
+    confirmed boolean DEFAULT false NOT NULL,
+    time timestamptz DEFAULT now()
 );
 
-
 ALTER TABLE email_change OWNER TO ndawn;
 
 --
@@ -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
 --
@@ -3469,6 +3472,8 @@ CREATE TRIGGER update_forum_thread_posts AFTER INSERT OR DELETE OR UPDATE ON for
 
 CREATE TRIGGER update_planet AFTER UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE update_user_planet();
 
+CREATE TRIGGER update_user_planet_check BEFORE UPDATE ON users FOR EACH ROW WHEN (NEW.pid IS NOT NULL AND OLD.pid IS NULL) EXECUTE PROCEDURE update_user_planet_check();
+
 
 --
 -- Name: update_wiki_page; Type: TRIGGER; Schema: public; Owner: ndawn