summaryrefslogtreecommitdiff
path: root/FS/FS/Schema.pm
diff options
context:
space:
mode:
authorMark Wells <mark@freeside.biz>2016-04-05 12:51:49 -0700
committerMark Wells <mark@freeside.biz>2016-04-05 13:06:22 -0700
commit39d666f254532a3d2d75c44b22ffe482073ed65b (patch)
tree3b2652169a5fa07ff7e9fdd958088a63fac0cffb /FS/FS/Schema.pm
parent343ae4008c577b1bab4e79b70895fe7c894a6d2f (diff)
persistent user prefs for UI pages, #41397
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r--FS/FS/Schema.pm20
1 files changed, 20 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index f28864c..5e97d79 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -5829,6 +5829,26 @@ sub tables_hashref {
'index' => [ ['usernum'], ['path'], ['_date'] ],
},
+ 'access_user_page_pref' => {
+ 'columns' => [
+ 'prefnum' => 'serial', '', '', '', '',
+ 'usernum' => 'int', '', '', '', '',
+ 'path' => 'text', '', '', '', '',
+ 'tablenum' => 'int', 'NULL', '', '', '',
+ '_date' => @date_type, '', '',
+ 'prefname' => 'varchar', '', $char_d, '', '',
+ 'prefvalue' => 'text', '', '', '', '',
+ ],
+ 'primary_key' => 'prefnum',
+ 'unique' => [ [ 'usernum', 'path', 'tablenum', 'prefname' ] ],
+ 'index' => [],
+ 'foreign_keys' => [
+ { columns => [ 'usernum' ],
+ table => 'access_user'
+ },
+ ],
+ },
+
'sched_item' => {
'columns' => [
'itemnum', 'serial', '', '', '', '',