X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=281ca6ba16497261a279359a7e617e3db22e2c16;hb=1594e450be1c4f0c9f9a2d98ab72c714a4695bdc;hp=e95e1f704e0ad6709538834d47a189c338df715c;hpb=53b930cc67361258ea40f793ca1eb0b3d976bd9c;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index e95e1f704..281ca6ba1 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1861,13 +1861,25 @@ sub tables_hashref { 'staticips', 'text', 'NULL', '', '', '', 'monitored', 'char', 'NULL', 1, '', '', 'last_pull', 'int', 'NULL', '', '', '', - 'notes', 'text', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', 'unique' => [ ], 'index' => [ ['phonenum'], ['vendor_order_id'] ], }, - + + 'dsl_note' => { + 'columns' => [ + 'notenum', 'serial', '', '', '', '', + 'svcnum', 'int', '', '', '', '', + 'by', 'varchar', 'NULL', $char_d, '', '', + 'priority', 'char', 'NULL', 1, '', '', + 'date', 'int', 'NULL', '', '', '', + 'note', 'text', '', '', '', '', + ], + 'primary_key' => 'notenum', + 'unique' => [ ], + 'index' => [ ['svcnum'] ], + }, 'domain_record' => { 'columns' => [