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;
--
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,
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
--