X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=FS%2FFS%2FSchema.pm;h=2cb942524db55fd1dc1ff2c3ac62650f19f7bc7c;hb=cc40b7d77271966a6922317774f63f8fa86d0871;hp=c27b727b8653d8656321d52f6bfbff17ca9a38d9;hpb=97dab063eab4cd6106b2d4f96d574a9594984cf7;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index c27b727b8..2cb942524 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -5812,6 +5812,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', '', '', '', '',