 
 DROP INDEX IF EXISTS index_on_members_forum_and_author;
 
-CREATE UNIQUE INDEX index_on_members_forum_and_author ON members (forum, 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 (path, "pID", thread);



CREATE TABLE "threads" (

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,
