diff options
| author | Mark Wells <mark@freeside.biz> | 2016-09-08 11:25:07 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2016-09-08 11:25:07 -0700 |
| commit | 9a9f45c82bc7901cfa94b6e64a2e3e4d5b15abff (patch) | |
| tree | a7abbfd6c9224bef21565d337974ceee979880b0 /FS/FS/Schema.pm | |
| parent | 91c2a52f4d319809c3a248bb31aa72aecb38ade2 (diff) | |
saved searches, core stuff, #72101
Diffstat (limited to 'FS/FS/Schema.pm')
| -rw-r--r-- | FS/FS/Schema.pm | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index bb62fef..a00e90f 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -7462,6 +7462,44 @@ sub tables_hashref { ], }, + 'saved_search' => { + 'columns' => [ + 'searchnum', 'serial', '', '', '', '', + 'usernum', 'int', 'NULL', '', '', '', + 'searchname', 'varchar', '', $char_d, '', '', + 'path', 'varchar', '', $char_d, '', '', + 'disabled', 'char', 'NULL', 1, '', '', + 'freq', 'varchar', 'NULL', 16, '', '', + 'last_sent', 'int', 'NULL', '', '', '', + 'format', 'varchar', 'NULL', 32, '', '', + ], + 'primary_key' => 'searchnum', + 'unique' => [], + 'index' => [], + 'foreign_keys' => [ + { columns => [ 'usernum' ], + table => 'access_user', + }, + ], + }, + + 'saved_search_option' => { + 'columns' => [ + 'optionnum', 'serial', '', '', '', '', + 'searchnum', 'int', '', '', '', '', + 'optionname', 'varchar', '', $char_d, '', '', + 'optionvalue', 'text', 'NULL', '', '', '', + ], + 'primary_key' => 'optionnum', + 'unique' => [ [ 'searchnum', 'optionname' ] ], + 'index' => [], + 'foreign_keys' => [ + { columns => [ 'searchnum' ], + table => 'saved_search', + }, + ], + }, + # name type nullability length default local #'new_table' => { |