X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=cd8213a786be2fe6c0c5fd84d87737c264c1136a;hb=28cd25044dcda22e1e879e94d953c98f32be2b28;hp=b7ec7df194e75298a4f2f6971fbbb3eb7f81c51a;hpb=5efca2378f5eb82e5c807cbcc66c72d91fd267c3;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index b7ec7df19..cd8213a78 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -5094,6 +5094,7 @@ sub tables_hashref { 'graphnum', 'int', 'NULL', '', '', '', 'imported', @date_type, '', '', 'content', 'text', 'NULL', '', '', '', + 'thumbnail', 'text', 'NULL', '', '', '', ], 'primary_key' => 'cacti_pagenum', 'unique' => [ ], @@ -5220,6 +5221,28 @@ sub tables_hashref { ], }, + 'saved_search' => { + 'columns' => [ + 'searchnum', 'serial', '', '', '', '', + 'usernum', 'int', 'NULL', '', '', '', + 'searchname', 'varchar', '', $char_d, '', '', + 'path', 'varchar', '', $char_d, '', '', + 'params', 'text', 'NULL', '', '', '', + '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', + }, + ], + }, + # name type nullability length default local #'new_table' => {