X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=67cf606fe4bc44d79b9525fdf4954292e644249b;hp=2850d4f137ef04fd6ee60f35dcf6ee53273c8527;hb=9d97d8bcc06f8c0fc12cdba4fe9cb5a0ac993066;hpb=1ef4eaf915eedd13ce92b99469f243bfa7b6edfd diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 2850d4f13..67cf606fe 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1660,16 +1660,31 @@ sub tables_hashref { 'last_login', @date_type, '', '', 'last_logout', @date_type, '', '', #communigate pro fields (quota = MaxAccountSize) + 'cgp_aliases', 'varchar', 'NULL', 255, '', '', + #settings + 'cgp_type', 'varchar', 'NULL', $char_d, '', '', #AccountType 'file_quota', 'varchar', 'NULL', $char_d, '', '', #MaxWebSize 'file_maxnum', 'varchar', 'NULL', $char_d, '', '', #MaxWebFiles 'file_maxsize', 'varchar', 'NULL', $char_d, '', '', #MaxFileSize 'cgp_accessmodes', 'varchar', 'NULL', 255, '', '', #AccessModes 'password_selfchange','char', 'NULL', 1, '', '', #PWDAllowed - 'password_recover', 'char', 'NULL', 1, '', '', #PasswordRecovery - 'cgp_type', 'varchar', 'NULL', $char_d, '', '', #AccountType - 'cgp_aliases', 'varchar', 'NULL', 255, '', '', + 'password_recover', 'char', 'NULL', 1, 'Y','', #PasswordRecovery + 'cgp_rulesallowed','varchar', 'NULL', $char_d, '', '', #RulesAllowed + 'cgp_rpopallowed', 'char', 'NULL', 1, '', '', #RPOPAllowed + 'cgp_mailtoall', 'char', 'NULL', 1, '', '', #MailToAll + 'cgp_addmailtrailer', 'char', 'NULL', 1, '', '', #AddMailTrailer + #XXX archive messages, mailing lists + #preferences 'cgp_deletemode', 'varchar', 'NULL', $char_d, '', '', #DeleteMode 'cgp_emptytrash', 'varchar', 'NULL', $char_d, '', '', #EmptyTrash + 'cgp_language', 'varchar', 'NULL', $char_d, '', '', #Language + 'cgp_timezone', 'varchar', 'NULL', $char_d, '', '', #TimeZone + 'cgp_skinname', 'varchar', 'NULL', $char_d, '', '', #SkinName + #XXX pronto style? + 'cgp_sendmdnmode', 'varchar', 'NULL', $char_d, '', '', #SendMDNMode + #mail +#vacation message, redirect all mail, mail rules + #XXX RPOP settings ], 'primary_key' => 'svcnum', #'unique' => [ [ 'username', 'domsvc' ] ], @@ -1715,17 +1730,32 @@ sub tables_hashref { 'expiration_date', @date_type, '', '', #communigate pro fields (quota = MaxAccountSize) 'max_accounts', 'int', 'NULL', '', '', '', + 'trailer', 'text', 'NULL', '', '', '', 'cgp_aliases', 'varchar', 'NULL', 255, '', '', 'cgp_accessmodes','varchar','NULL', 255, '', '', #DomainAccessModes + #settings 'acct_def_password_selfchange','char', 'NULL', 1, '', '', - 'acct_def_password_recover', 'char', 'NULL', 1, '', '', + 'acct_def_password_recover', 'char', 'NULL', 1, 'Y', '', 'acct_def_cgp_accessmodes', 'varchar', 'NULL', 255, '', '', 'acct_def_quota', 'varchar', 'NULL', $char_d, '', '', 'acct_def_file_quota', 'varchar', 'NULL', $char_d, '', '', 'acct_def_file_maxnum', 'varchar', 'NULL', $char_d, '', '', 'acct_def_file_maxsize', 'varchar', 'NULL', $char_d, '', '', + 'acct_def_cgp_rulesallowed','varchar', 'NULL', $char_d, '', '', + 'acct_def_cgp_rpopallowed', 'char', 'NULL', 1, '', '', + 'acct_def_cgp_mailtoall', 'char', 'NULL', 1, '', '', + 'acct_def_cgp_addmailtrailer', 'char', 'NULL', 1, '', '', + #XXX archive messages + #preferences 'acct_def_cgp_deletemode', 'varchar', 'NULL', $char_d, '', '', 'acct_def_cgp_emptytrash', 'varchar', 'NULL', $char_d, '', '', + 'acct_def_cgp_language', 'varchar', 'NULL', $char_d, '', '', + 'acct_def_cgp_timezone', 'varchar', 'NULL', $char_d, '', '', + 'acct_def_cgp_skinname', 'varchar', 'NULL', $char_d, '', '', + #XXX pronto style? + 'acct_def_cgp_sendmdnmode', 'varchar', 'NULL', $char_d, '', '', + #mail + #XXX rules, archive rule, spam foldering rule(s) ], 'primary_key' => 'svcnum', 'unique' => [ ],