+CREATE TABLE users (
+  id SERIAL PRIMARY KEY,
+  name VARCHAR(80) NOT NULL,
+  email VARCHAR(100) NOT NULL,
+  address VARCHAR(2500) NOT NULL,
+  ward INTEGER,
+  admin BOOLEAN DEFAULT false,
+  active BOOLEAN DEFAULT false,
+  city VARCHAR(200),
+  state VARCHAR(200),
+  zipcode VARCHAR(200),
+  photo VARCHAR(300)
+);
 
 CREATE TABLE main_topics (
   id SERIAL PRIMARY KEY,
   title VARCHAR(80),
   description VARCHAR(10000),
-  active boolean
+  active BOOLEAN DEFAULT false,
+  upcoming BOOLEAN DEFAULT false
 );
 
 CREATE TABLE subtopics (
   id SERIAL PRIMARY KEY,
   title VARCHAR(80),
   description VARCHAR(10000),
-  main_id integer REFERENCES main_topics
+  main_id integer REFERENCES main_topics,
+  active BOOLEAN DEFAULT false,
+  upcoming BOOLEAN DEFAULT false
 );
 
 CREATE TABLE ideas (

  user_id integer REFERENCES users,
  idea_id integer REFERENCES ideas
);

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name VARCHAR(80) NOT NULL,
  email VARCHAR(100) NOT NULL,
  address VARCHAR(2500) NOT NULL,
  ward VARCHAR(80),
  admin BOOLEAN DEFAULT false
);

  comment_id integer REFERENCES comments
);

CREATE TABLE subcomments_likes (
  id SERIAL PRIMARY KEY,
  user_id integer REFERENCES users,
  subcomment_id integer REFERENCES subcomments
