 CREATE UNIQUE INDEX index_on_users_nickname
   ON users (nickname);
 
+DROP INDEX IF EXISTS index_on_users_nickname_and_email;
+
+CREATE UNIQUE INDEX index_on_users_nickname_and_email
+  ON users (nickname, email);
+
 
 CREATE TABLE "posts" (
   "pID"      SERIAL  NOT NULL,


DROP INDEX IF EXISTS index_on_members_forum_and_author;

CREATE UNIQUE INDEX index_on_members_forum_and_author ON members (forum, author);

CREATE INDEX index_on_posts_parent
  ON posts (parent);

-- DROP INDEX IF EXISTS index_on_posts_path;

-- CREATE INDEX index_on_posts_path
--   ON posts (path);

-- DROP INDEX IF EXISTS index_on_posts_id_and_path_and_thread;

-- CREATE INDEX index_on_posts_id_and_path_and_thread
--   ON posts ("pID", thread, path);

-- DROP INDEX IF EXISTS index_on_posts_id_and_path;

-- CREATE INDEX index_on_posts_id_and_path
--   ON posts ("pID", path);


CREATE TABLE "threads" (
