diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-04-05 12:46:30 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-04-05 12:46:30 -0700 |
| commit | 26010ef38cea8b15bc01ede43817ec7e22efbf47 (patch) | |
| tree | c821d31e2aa3cfb63a623752a02ee601f7738e8d /FS/FS/Schema.pm | |
| parent | b04dfa7c78a316b6b00afa17903424d71ba18cc4 (diff) | |
installers, RT#16584
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 6a7f38c6c..60860b056 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -3877,6 +3877,44 @@ sub tables_hashref { 'index' => [], }, + 'sched_item' => { + 'columns' => [ + 'itemnum', 'serial', '', '', '', '', + 'usernum', 'int', 'NULL', '', '', '', + #'itemname', 'varchar', $char_d, '', '', '', + 'disabled', 'char', 'NULL', 1, '', '', + ], + 'primary_key' => 'itemnum', + 'unique' => [ [ 'usernum' ] ], + 'index' => [], + 'foreign_keys' => [ + { columns => [ 'usernum' ], + table => 'access_user', + }, + ], + }, + + #'sched_item_class' + + 'sched_avail' => { + 'columns' => [ + 'availnum', 'serial', '', '', '', '', + 'itemnum', 'int', '', '', '', '', + 'wday', 'int', '', '', '', '', + 'stime', 'int', '', '', '', '', + 'etime', 'int', '', '', '', '', + 'override_date', @date_type, '', '', + ], + 'primary_key' => 'availnum', + 'unique' => [], + 'index' => [], + 'foreign_keys' => [ + { columns => [ 'itemnum' ], + table => 'sched_item', + }, + ], + }, + 'svc_phone' => { 'columns' => [ 'svcnum', 'int', '', '', '', '', |