Add roomlist, per-room image limits

1 files changed, 8 insertions, 1 deletions

diff --git a/db/0-create.psql b/db/0-create.psql
index 649d74f..68f9bfd 100644
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -29,10 +29,17 @@ CREATE TABLE rooms (
     created_on timestamp NOT NULL DEFAULT now(),
     admin_only bool NOT NULL DEFAULT false,
     active bool NOT NULL DEFAULT true,
-    history_size integer NOT NULL DEFAULT 25
+    history_size integer NOT NULL DEFAULT 25,
+    max_file_size integer NOT NULL DEFAULT 1048576,
+    max_image_width integer NOT NULL DEFAULT 2000,
+    max_image_height integer NOT NULL DEFAULT 2000
 );
 
+
 -- ALTER TABLE rooms ADD COLUMN history_size integer NOT NULL DEFAULT 25;
+-- ALTER TABLE rooms ADD COLUMN max_file_size integer NOT NULL DEFAULT 1048576;
+-- ALTER TABLE rooms ADD COLUMN max_image_width integer NOT NULL DEFAULT 2000;
+-- ALTER TABLE rooms ADD COLUMN max_image_height integer NOT NULL DEFAULT 2000;
 
 CREATE TABLE messages (
     message_id SERIAL PRIMARY KEY,