diff options
| -rw-r--r-- | extensions/RequestNagger/Extension.pm | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/extensions/RequestNagger/Extension.pm b/extensions/RequestNagger/Extension.pm index 0ed517244..fa570edab 100644 --- a/extensions/RequestNagger/Extension.pm +++ b/extensions/RequestNagger/Extension.pm @@ -323,6 +323,38 @@ sub db_schema_abstract_schema { }, ], }; + $args->{'schema'}->{'nag_settings'} = { + FIELDS => [ + id => { + TYPE => 'MEDIUMSERIAL', + NOTNULL => 1, + PRIMARYKEY => 1, + }, + user_id => { + TYPE => 'INT3', + NOTNULL => 1, + REFERENCES => { + TABLE => 'profiles', + COLUMN => 'userid', + DELETE => 'CASCADE', + } + }, + setting_name => { + TYPE => 'VARCHAR(16)', + NOTNULL => 1, + }, + setting_value => { + TYPE => 'VARCHAR(16)', + NOTNULL => 1, + }, + ], + INDEXES => [ + nag_watch_idx => { + FIELDS => [ 'user_id', 'setting_name' ], + TYPE => 'UNIQUE', + }, + ], + }; } sub install_update_db { |