summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2009-08-28 20:33:49 +1200
committerBrenda Wallace <shiny@cpan.org>2009-08-28 20:33:49 +1200
commita0e41693e48be87feb0baa378c74e8309146c9c5 (patch)
treec0d323d9219f7d2aeac9fea6bc76873daf8567dd /db
parent06514aa001f8c567918a5e5533b3d4a24f427439 (diff)
added config table
Diffstat (limited to 'db')
-rw-r--r--db/statusnet_pg.sql10
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)
+
+);