diff options
Diffstat (limited to 'db/statusnet_pg.sql')
-rw-r--r-- | db/statusnet_pg.sql | 10 |
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) + +); |