diff options
Diffstat (limited to 'contrib/ast-db-manage/config/versions/4da0c5f79a9c_create_tables.py')
-rw-r--r-- | contrib/ast-db-manage/config/versions/4da0c5f79a9c_create_tables.py | 116 |
1 files changed, 77 insertions, 39 deletions
diff --git a/contrib/ast-db-manage/config/versions/4da0c5f79a9c_create_tables.py b/contrib/ast-db-manage/config/versions/4da0c5f79a9c_create_tables.py index f6bed958b..77ba6904d 100644 --- a/contrib/ast-db-manage/config/versions/4da0c5f79a9c_create_tables.py +++ b/contrib/ast-db-manage/config/versions/4da0c5f79a9c_create_tables.py @@ -75,9 +75,12 @@ def upgrade(): sa.Column('secret', sa.String(40)), sa.Column('md5secret', sa.String(40)), sa.Column('remotesecret', sa.String(40)), - sa.Column('transport', sa.Enum(*SIP_TRANSPORT_VALUES)), - sa.Column('dtmfmode', sa.Enum(*SIP_DTMFMODE_VALUES)), - sa.Column('directmedia', sa.Enum(*SIP_DIRECTMEDIA_VALUES)), + sa.Column('transport', sa.Enum(*SIP_TRANSPORT_VALUES, + name='sip_transport_values')), + sa.Column('dtmfmode', sa.Enum(*SIP_DTMFMODE_VALUES, + name='sip_dtmfmode_values')), + sa.Column('directmedia', sa.Enum(*SIP_DIRECTMEDIA_VALUES, + name='sip_directmedia_values')), sa.Column('nat', sa.String(29)), sa.Column('callgroup', sa.String(40)), sa.Column('pickupgroup', sa.String(40)), @@ -85,26 +88,37 @@ def upgrade(): sa.Column('disallow', sa.String(200)), sa.Column('allow', sa.String(200)), sa.Column('insecure', sa.String(40)), - sa.Column('trustrpid', sa.Enum(*YESNO_VALUES)), - sa.Column('progressinband', sa.Enum(*SIP_PROGRESSINBAND_VALUES)), - sa.Column('promiscredir', sa.Enum(*YESNO_VALUES)), - sa.Column('useclientcode', sa.Enum(*YESNO_VALUES)), + sa.Column('trustrpid', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('progressinband', sa.Enum(*SIP_PROGRESSINBAND_VALUES, + name='sip_progressinband_values')), + sa.Column('promiscredir', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('useclientcode', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('accountcode', sa.String(40)), sa.Column('setvar', sa.String(200)), sa.Column('callerid', sa.String(40)), sa.Column('amaflags', sa.String(40)), - sa.Column('callcounter', sa.Enum(*YESNO_VALUES)), + sa.Column('callcounter', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('busylevel', sa.Integer), - sa.Column('allowoverlap', sa.Enum(*YESNO_VALUES)), - sa.Column('allowsubscribe', sa.Enum(*YESNO_VALUES)), - sa.Column('videosupport', sa.Enum(*YESNO_VALUES)), + sa.Column('allowoverlap', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('allowsubscribe', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('videosupport', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('maxcallbitrate', sa.Integer), - sa.Column('rfc2833compensate', sa.Enum(*YESNO_VALUES)), + sa.Column('rfc2833compensate', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('mailbox', sa.String(40)), - sa.Column('session-timers', sa.Enum(*SIP_SESSION_TIMERS_VALUES)), + sa.Column('session-timers', sa.Enum(*SIP_SESSION_TIMERS_VALUES, + name='sip_session_timers_values')), sa.Column('session-expires', sa.Integer), sa.Column('session-minse', sa.Integer), - sa.Column('session-refresher', sa.Enum(*SIP_SESSION_REFRESHER_VALUES)), + sa.Column('session-refresher', sa.Enum(*SIP_SESSION_REFRESHER_VALUES, + name='sip_session_refresher_values')), sa.Column('t38pt_usertpsource', sa.String(40)), sa.Column('regexten', sa.String(40)), sa.Column('fromdomain', sa.String(40)), @@ -113,13 +127,15 @@ def upgrade(): sa.Column('defaultip', sa.String(45)), sa.Column('rtptimeout', sa.Integer), sa.Column('rtpholdtimeout', sa.Integer), - sa.Column('sendrpid', sa.Enum(*YESNO_VALUES)), + sa.Column('sendrpid', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('outboundproxy', sa.String(40)), sa.Column('callbackextension', sa.String(40)), sa.Column('timert1', sa.Integer), sa.Column('timerb', sa.Integer), sa.Column('qualifyfreq', sa.Integer), - sa.Column('constantssrc', sa.Enum(*YESNO_VALUES)), + sa.Column('constantssrc', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('contactpermit', sa.String(95)), sa.Column('contactdeny', sa.String(95)), sa.Column('usereqphone', sa.Enum(*YESNO_VALUES)), @@ -130,20 +146,26 @@ def upgrade(): sa.Column('fullname', sa.String(40)), sa.Column('trunkname', sa.String(40)), sa.Column('cid_number', sa.String(40)), - sa.Column('callingpres', sa.Enum(*SIP_CALLINGPRES_VALUES)), + sa.Column('callingpres', sa.Enum(*SIP_CALLINGPRES_VALUES, + name='sip_callingpres_values')), sa.Column('mohinterpret', sa.String(40)), sa.Column('mohsuggest', sa.String(40)), sa.Column('parkinglot', sa.String(40)), - sa.Column('hasvoicemail', sa.Enum(*YESNO_VALUES)), - sa.Column('subscribemwi', sa.Enum(*YESNO_VALUES)), + sa.Column('hasvoicemail', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('subscribemwi', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('vmexten', sa.String(40)), sa.Column('autoframing', sa.Enum(*YESNO_VALUES)), sa.Column('rtpkeepalive', sa.Integer), sa.Column('call-limit', sa.Integer), - sa.Column('g726nonstandard', sa.Enum(*YESNO_VALUES)), - sa.Column('ignoresdpversion', sa.Enum(*YESNO_VALUES)), - sa.Column('allowtransfer', sa.Enum(*YESNO_VALUES)), - sa.Column('dynamic', sa.Enum(*YESNO_VALUES)), + sa.Column('g726nonstandard', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('ignoresdpversion', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('allowtransfer', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('dynamic', sa.Enum(*YESNO_VALUES, name='yes_no_values')), sa.Column('path', sa.String(256)), sa.Column('supportpath', sa.Enum(*YESNO_VALUES)) ) @@ -185,16 +207,22 @@ def upgrade(): sa.Column('trunk', sa.Enum(*YESNO_VALUES)), sa.Column('auth', sa.String(20)), sa.Column('maxauthreq', sa.Integer), - sa.Column('requirecalltoken', sa.Enum(*IAX_REQUIRECALLTOKEN_VALUES)), - sa.Column('encryption', sa.Enum(*IAX_ENCRYPTION_VALUES)), - sa.Column('transfer', sa.Enum(*IAX_TRANSFER_VALUES)), - sa.Column('jitterbuffer', sa.Enum(*YESNO_VALUES)), - sa.Column('forcejitterbuffer', sa.Enum(*YESNO_VALUES)), + sa.Column('requirecalltoken', sa.Enum(*IAX_REQUIRECALLTOKEN_VALUES, + name='iax_requirecalltoken_values')), + sa.Column('encryption', sa.Enum(*IAX_ENCRYPTION_VALUES, + name='iax_encryption_values')), + sa.Column('transfer', sa.Enum(*IAX_TRANSFER_VALUES, + name='iax_transfer_values')), + sa.Column('jitterbuffer', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('forcejitterbuffer', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('disallow', sa.String(200)), sa.Column('allow', sa.String(200)), sa.Column('codecpriority', sa.String(40)), sa.Column('qualify', sa.String(10)), - sa.Column('qualifysmoothing', sa.Enum(*YESNO_VALUES)), + sa.Column('qualifysmoothing', + sa.Enum(*YESNO_VALUES, name='yes_no_values')), sa.Column('qualifyfreqok', sa.String(10)), sa.Column('qualifyfreqnotok', sa.String(10)), sa.Column('timezone', sa.String(20)), @@ -225,16 +253,25 @@ def upgrade(): sa.Column('serveremail', sa.String(80)), sa.Column('language', sa.String(20)), sa.Column('tz', sa.String(30)), - sa.Column('deletevoicemail', sa.Enum(*YESNO_VALUES)), - sa.Column('saycid', sa.Enum(*YESNO_VALUES)), - sa.Column('sendvoicemail', sa.Enum(*YESNO_VALUES)), - sa.Column('review', sa.Enum(*YESNO_VALUES)), - sa.Column('tempgreetwarn', sa.Enum(*YESNO_VALUES)), - sa.Column('operator', sa.Enum(*YESNO_VALUES)), - sa.Column('envelope', sa.Enum(*YESNO_VALUES)), + sa.Column('deletevoicemail', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('saycid', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('sendvoicemail', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('review', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('tempgreetwarn', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('operator', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('envelope', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('sayduration', sa.Integer), - sa.Column('forcename', sa.Enum(*YESNO_VALUES)), - sa.Column('forcegreetings', sa.Enum(*YESNO_VALUES)), + sa.Column('forcename', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), + sa.Column('forcegreetings', sa.Enum(*YESNO_VALUES, + name='yes_no_values')), sa.Column('callback', sa.String(80)), sa.Column('dialout', sa.String(80)), sa.Column('exitcontext', sa.String(80)), @@ -249,7 +286,8 @@ def upgrade(): ) op.create_index('voicemail_mailbox', 'voicemail', ['mailbox']) op.create_index('voicemail_context', 'voicemail', ['context']) - op.create_index('voicemail_mailbox_context', 'voicemail', ['mailbox', 'context']) + op.create_index('voicemail_mailbox_context', 'voicemail', + ['mailbox', 'context']) op.create_index('voicemail_imapuser', 'voicemail', ['imapuser']) op.create_table( |