added config table

1 files changed, 10 insertions, 0 deletions

diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql
index 5b4d0485a..dbfd50098 100644
--- a/db/statusnet_pg.sql
+++ b/db/statusnet_pg.sql
@@ -549,3 +549,13 @@ create index noticecontent_idx on notice using gist(to_tsvector('english',conten
 create trigger textsearchupdate before insert or update on profile for each row
 execute procedure tsvector_update_trigger(textsearch, 'pg_catalog.english', nickname, fullname, location, bio, homepage);
 
+
+create table config (
+
+    section varchar(32) /* comment 'configuration section'*/,
+    setting varchar(32) /* comment 'configuration setting'*/,
+    value varchar(255) /* comment 'configuration value'*/,
+
+    primary key (section, setting)
+
+);