summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--extensions/RequestNagger/Extension.pm32
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 {