From f1c347386eceb02f60f41792e8b0e00601977446 Mon Sep 17 00:00:00 2001 From: Scott Ostler Date: Thu, 9 Sep 2010 03:07:50 -0400 Subject: Add roomlist, per-room image limits --- db/0-create.psql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'db') 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, -- cgit v1.2.3-70-g09d2