Feedback page & Misc

config/db_schema_postgres.sql

@@ -410,6 +410,13 @@ CREATE TABLE IF NOT EXISTS "responsible" (
 ); -- TODO info: this had collation latin1_swedish_ci
 CREATE UNIQUE INDEX IF NOT EXISTS "responsible_course_id_user_id_index" ON "responsible" ("course_id","user_id");
 
+CREATE TABLE IF NOT EXISTS "feedback" (
+    "id" serial NOT NULL,
+    "time_created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "email" character varying(128) DEFAULT NULL,
+    "text" text COLLATE "pg_catalog"."und-x-icu" NOT NULL,
+    CONSTRAINT "feedback_pkey" PRIMARY KEY ("id")
+);
 
 CREATE VIEW "courses" AS
     SELECT *