More db actions and forms.

1 files changed, 21 insertions, 0 deletions

diff --git a/SCHEMA.sql b/SCHEMA.sql
index 1c5c372..6832923 100644
--- a/SCHEMA.sql
+++ b/SCHEMA.sql
@@ -3,3 +3,24 @@ CREATE TABLE users (
 	nick TEXT,
 	created INT
 );
+CREATE TABLE questions (
+	id SERIAL PRIMARY KEY,
+	question TEXT,
+	neg_answer TEXT,
+	pos_answer TEXT,
+	created INT
+);
+CREATE TABLE answers (
+	id SERIAL PRIMARY KEY,
+	user_id INT,
+	question_id INT,
+	answer INT,
+	created INT
+);
+CREATE TABLE questionaires (
+	id SERIAL PRIMARY KEY,
+	questionset INT[] DEFAULT '{}',
+	creator_id INT,
+	ready BOOLEAN DEFAULT FALSE,
+	created INT
+);