X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=3d7248f33f936c72f62d8adaf8e2302a7d359e49;hp=c05bd9c13e9e9864a422ebd9cbd9b3639b426db2;hb=6c6163bb36ac4e425a7f109566d62c9bdf206bc7;hpb=cb9dc2ecd0c1dd9968d9cfec600933d8c184768f diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index c05bd9c13..3d7248f33 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -189,9 +189,9 @@ sub dbdef_dist { my $tables_hashref_torrus = tables_hashref_torrus(); - #create history tables (false laziness w/create-history-tables) + #create history tables foreach my $table ( - grep { ! /^clientapi_session/ + grep { ! /^(clientapi|access_user)_session/ && ! /^h_/ && ! /^log(_context)?$/ && ! /^legacy_cust_history$/ @@ -3944,6 +3944,19 @@ sub tables_hashref { 'index' => [], }, + 'access_user_session' => { + 'columns' => [ + 'sessionnum', 'serial', '', '', '', '', + 'sessionkey', 'varchar', '', $char_d, '', '', + 'usernum', 'int', '', '', '', '', + 'start_date', @date_type, '', '', + 'last_date', @date_type, '', '', + ], + 'primary_key' => 'sessionnum', + 'unique' => [ [ 'sessionkey' ] ], + 'index' => [], + }, + 'access_user' => { 'columns' => [ 'usernum', 'serial', '', '', '', '',