4da0c5f79a9c_create_tables Namespace Reference


Functions

def downgrade
def upgrade

Variables

 down_revision = None
list IAX_ENCRYPTION_VALUES = ['yes', 'no', 'aes128']
list IAX_REQUIRECALLTOKEN_VALUES = ['yes', 'no', 'auto']
list IAX_TRANSFER_VALUES = ['yes', 'no', 'mediaonly']
list MOH_MODE_VALUES = ['custom', 'files', 'mp3nb', 'quietmp3nb', 'quietmp3']
string revision = '4da0c5f79a9c'
list SIP_CALLINGPRES_VALUES
list SIP_DIRECTMEDIA_VALUES = ['yes', 'no', 'nonat', 'update']
list SIP_DTMFMODE_VALUES = ['rfc2833', 'info', 'shortinfo', 'inband', 'auto']
list SIP_PROGRESSINBAND_VALUES = ['yes', 'no', 'never']
list SIP_SESSION_REFRESHER_VALUES = ['uac', 'uas']
list SIP_SESSION_TIMERS_VALUES = ['accept', 'refuse', 'originate']
list SIP_TRANSPORT_VALUES = ['udp', 'tcp', 'tls', 'ws', 'wss', 'udp,tcp', 'tcp,udp']
list TYPE_VALUES = ['friend', 'user', 'peer']
list YESNO_VALUES = ['yes', 'no']


Function Documentation

def 4da0c5f79a9c_create_tables::downgrade (  ) 

Definition at line 325 of file 4da0c5f79a9c_create_tables.py.

00325                :
00326     op.drop_table('sippeers')
00327     op.drop_table('iaxfriends')
00328     op.drop_table('voicemail')
00329     op.drop_table('meetme')
00330     op.drop_table('musiconhold')
    op.drop_table('musiconhold')

def 4da0c5f79a9c_create_tables::upgrade (  ) 

Definition at line 56 of file 4da0c5f79a9c_create_tables.py.

00056              :
00057     op.create_table(
00058         'sippeers',
00059         sa.Column('id', sa.Integer, primary_key=True, nullable=False,
00060                   autoincrement=True),
00061         sa.Column('name', sa.String(40), nullable=False, unique=True),
00062         sa.Column('ipaddr', sa.String(45)),
00063         sa.Column('port', sa.Integer),
00064         sa.Column('regseconds', sa.Integer),
00065         sa.Column('defaultuser', sa.String(40)),
00066         sa.Column('fullcontact', sa.String(80)),
00067         sa.Column('regserver', sa.String(20)),
00068         sa.Column('useragent', sa.String(20)),
00069         sa.Column('lastms', sa.Integer),
00070         sa.Column('host', sa.String(40)),
00071         sa.Column('type', sa.Enum(*TYPE_VALUES, name='type_values')),
00072         sa.Column('context', sa.String(40)),
00073         sa.Column('permit', sa.String(95)),
00074         sa.Column('deny', sa.String(95)),
00075         sa.Column('secret', sa.String(40)),
00076         sa.Column('md5secret', sa.String(40)),
00077         sa.Column('remotesecret', sa.String(40)),
00078         sa.Column('transport', sa.Enum(*SIP_TRANSPORT_VALUES,
00079                   name='sip_transport_values')),
00080         sa.Column('dtmfmode', sa.Enum(*SIP_DTMFMODE_VALUES,
00081                   name='sip_dtmfmode_values')),
00082         sa.Column('directmedia', sa.Enum(*SIP_DIRECTMEDIA_VALUES,
00083                   name='sip_directmedia_values')),
00084         sa.Column('nat', sa.String(29)),
00085         sa.Column('callgroup', sa.String(40)),
00086         sa.Column('pickupgroup', sa.String(40)),
00087         sa.Column('language', sa.String(40)),
00088         sa.Column('disallow', sa.String(200)),
00089         sa.Column('allow', sa.String(200)),
00090         sa.Column('insecure', sa.String(40)),
00091         sa.Column('trustrpid', sa.Enum(*YESNO_VALUES,
00092                   name='yes_no_values')),
00093         sa.Column('progressinband', sa.Enum(*SIP_PROGRESSINBAND_VALUES,
00094                   name='sip_progressinband_values')),
00095         sa.Column('promiscredir', sa.Enum(*YESNO_VALUES,
00096                   name='yes_no_values')),
00097         sa.Column('useclientcode', sa.Enum(*YESNO_VALUES,
00098                   name='yes_no_values')),
00099         sa.Column('accountcode', sa.String(40)),
00100         sa.Column('setvar', sa.String(200)),
00101         sa.Column('callerid', sa.String(40)),
00102         sa.Column('amaflags', sa.String(40)),
00103         sa.Column('callcounter', sa.Enum(*YESNO_VALUES,
00104                   name='yes_no_values')),
00105         sa.Column('busylevel', sa.Integer),
00106         sa.Column('allowoverlap', sa.Enum(*YESNO_VALUES,
00107                   name='yes_no_values')),
00108         sa.Column('allowsubscribe', sa.Enum(*YESNO_VALUES,
00109                   name='yes_no_values')),
00110         sa.Column('videosupport', sa.Enum(*YESNO_VALUES,
00111                   name='yes_no_values')),
00112         sa.Column('maxcallbitrate', sa.Integer),
00113         sa.Column('rfc2833compensate', sa.Enum(*YESNO_VALUES,
00114                   name='yes_no_values')),
00115         sa.Column('mailbox', sa.String(40)),
00116         sa.Column('session-timers', sa.Enum(*SIP_SESSION_TIMERS_VALUES,
00117                   name='sip_session_timers_values')),
00118         sa.Column('session-expires', sa.Integer),
00119         sa.Column('session-minse', sa.Integer),
00120         sa.Column('session-refresher', sa.Enum(*SIP_SESSION_REFRESHER_VALUES,
00121                   name='sip_session_refresher_values')),
00122         sa.Column('t38pt_usertpsource', sa.String(40)),
00123         sa.Column('regexten', sa.String(40)),
00124         sa.Column('fromdomain', sa.String(40)),
00125         sa.Column('fromuser', sa.String(40)),
00126         sa.Column('qualify', sa.String(40)),
00127         sa.Column('defaultip', sa.String(45)),
00128         sa.Column('rtptimeout', sa.Integer),
00129         sa.Column('rtpholdtimeout', sa.Integer),
00130         sa.Column('sendrpid', sa.Enum(*YESNO_VALUES,
00131                   name='yes_no_values')),
00132         sa.Column('outboundproxy', sa.String(40)),
00133         sa.Column('callbackextension', sa.String(40)),
00134         sa.Column('timert1', sa.Integer),
00135         sa.Column('timerb', sa.Integer),
00136         sa.Column('qualifyfreq', sa.Integer),
00137         sa.Column('constantssrc', sa.Enum(*YESNO_VALUES,
00138                   name='yes_no_values')),
00139         sa.Column('contactpermit', sa.String(95)),
00140         sa.Column('contactdeny', sa.String(95)),
00141         sa.Column('usereqphone', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00142         sa.Column('textsupport', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00143         sa.Column('faxdetect', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00144         sa.Column('buggymwi', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00145         sa.Column('auth', sa.String(40)),
00146         sa.Column('fullname', sa.String(40)),
00147         sa.Column('trunkname', sa.String(40)),
00148         sa.Column('cid_number', sa.String(40)),
00149         sa.Column('callingpres', sa.Enum(*SIP_CALLINGPRES_VALUES,
00150                   name='sip_callingpres_values')),
00151         sa.Column('mohinterpret', sa.String(40)),
00152         sa.Column('mohsuggest', sa.String(40)),
00153         sa.Column('parkinglot', sa.String(40)),
00154         sa.Column('hasvoicemail', sa.Enum(*YESNO_VALUES,
00155                   name='yes_no_values')),
00156         sa.Column('subscribemwi', sa.Enum(*YESNO_VALUES,
00157                   name='yes_no_values')),
00158         sa.Column('vmexten', sa.String(40)),
00159         sa.Column('autoframing', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00160         sa.Column('rtpkeepalive', sa.Integer),
00161         sa.Column('call-limit', sa.Integer),
00162         sa.Column('g726nonstandard', sa.Enum(*YESNO_VALUES,
00163                   name='yes_no_values')),
00164         sa.Column('ignoresdpversion', sa.Enum(*YESNO_VALUES,
00165                   name='yes_no_values')),
00166         sa.Column('allowtransfer', sa.Enum(*YESNO_VALUES,
00167                   name='yes_no_values')),
00168         sa.Column('dynamic', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00169         sa.Column('path', sa.String(256)),
00170         sa.Column('supportpath', sa.Enum(*YESNO_VALUES, name='yes_no_values'))
00171     )
00172     op.create_index('sippeers_name', 'sippeers', ['name'])
00173     op.create_index('sippeers_name_host', 'sippeers', ['name', 'host'])
00174     op.create_index('sippeers_ipaddr_port', 'sippeers', ['ipaddr', 'port'])
00175     op.create_index('sippeers_host_port', 'sippeers', ['host', 'port'])
00176 
00177     op.create_table(
00178         'iaxfriends',
00179         sa.Column('id', sa.Integer, primary_key=True, nullable=False,
00180                   autoincrement=True),
00181         sa.Column('name', sa.String(40), nullable=False, unique=True),
00182         sa.Column('type', sa.Enum(*TYPE_VALUES, name='type_values')),
00183         sa.Column('username', sa.String(40)),
00184         sa.Column('mailbox', sa.String(40)),
00185         sa.Column('secret', sa.String(40)),
00186         sa.Column('dbsecret', sa.String(40)),
00187         sa.Column('context', sa.String(40)),
00188         sa.Column('regcontext', sa.String(40)),
00189         sa.Column('host', sa.String(40)),
00190         sa.Column('ipaddr', sa.String(40)),
00191         sa.Column('port', sa.Integer),
00192         sa.Column('defaultip', sa.String(20)),
00193         sa.Column('sourceaddress', sa.String(20)),
00194         sa.Column('mask', sa.String(20)),
00195         sa.Column('regexten', sa.String(40)),
00196         sa.Column('regseconds', sa.Integer),
00197         sa.Column('accountcode', sa.String(20)),
00198         sa.Column('mohinterpret', sa.String(20)),
00199         sa.Column('mohsuggest', sa.String(20)),
00200         sa.Column('inkeys', sa.String(40)),
00201         sa.Column('outkeys', sa.String(40)),
00202         sa.Column('language', sa.String(10)),
00203         sa.Column('callerid', sa.String(100)),
00204         sa.Column('cid_number', sa.String(40)),
00205         sa.Column('sendani', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00206         sa.Column('fullname', sa.String(40)),
00207         sa.Column('trunk', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00208         sa.Column('auth', sa.String(20)),
00209         sa.Column('maxauthreq', sa.Integer),
00210         sa.Column('requirecalltoken', sa.Enum(*IAX_REQUIRECALLTOKEN_VALUES,
00211                   name='iax_requirecalltoken_values')),
00212         sa.Column('encryption', sa.Enum(*IAX_ENCRYPTION_VALUES,
00213                   name='iax_encryption_values')),
00214         sa.Column('transfer', sa.Enum(*IAX_TRANSFER_VALUES,
00215                   name='iax_transfer_values')),
00216         sa.Column('jitterbuffer', sa.Enum(*YESNO_VALUES,
00217                   name='yes_no_values')),
00218         sa.Column('forcejitterbuffer', sa.Enum(*YESNO_VALUES,
00219                   name='yes_no_values')),
00220         sa.Column('disallow', sa.String(200)),
00221         sa.Column('allow', sa.String(200)),
00222         sa.Column('codecpriority', sa.String(40)),
00223         sa.Column('qualify', sa.String(10)),
00224         sa.Column('qualifysmoothing',
00225                   sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00226         sa.Column('qualifyfreqok', sa.String(10)),
00227         sa.Column('qualifyfreqnotok', sa.String(10)),
00228         sa.Column('timezone', sa.String(20)),
00229         sa.Column('adsi', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00230         sa.Column('amaflags', sa.String(20)),
00231         sa.Column('setvar', sa.String(200))
00232     )
00233     op.create_index('iaxfriends_name', 'iaxfriends', ['name'])
00234     op.create_index('iaxfriends_name_host', 'iaxfriends', ['name', 'host'])
00235     op.create_index('iaxfriends_name_ipaddr_port', 'iaxfriends',
00236                     ['name', 'ipaddr', 'port'])
00237     op.create_index('iaxfriends_ipaddr_port', 'iaxfriends', ['ipaddr', 'port'])
00238     op.create_index('iaxfriends_host_port', 'iaxfriends', ['host', 'port'])
00239 
00240     op.create_table(
00241         'voicemail',
00242         sa.Column('uniqueid', sa.Integer, primary_key=True, nullable=False,
00243                   autoincrement=True),
00244         sa.Column('context', sa.String(80), nullable=False),
00245         sa.Column('mailbox', sa.String(80), nullable=False),
00246         sa.Column('password', sa.String(80), nullable=False),
00247         sa.Column('fullname', sa.String(80)),
00248         sa.Column('alias', sa.String(80)),
00249         sa.Column('email', sa.String(80)),
00250         sa.Column('pager', sa.String(80)),
00251         sa.Column('attach', sa.Enum(*YESNO_VALUES, name='yes_no_values')),
00252         sa.Column('attachfmt', sa.String(10)),
00253         sa.Column('serveremail', sa.String(80)),
00254         sa.Column('language', sa.String(20)),
00255         sa.Column('tz', sa.String(30)),
00256         sa.Column('deletevoicemail', sa.Enum(*YESNO_VALUES,
00257                   name='yes_no_values')),
00258         sa.Column('saycid', sa.Enum(*YESNO_VALUES,
00259                   name='yes_no_values')),
00260         sa.Column('sendvoicemail', sa.Enum(*YESNO_VALUES,
00261                   name='yes_no_values')),
00262         sa.Column('review', sa.Enum(*YESNO_VALUES,
00263                   name='yes_no_values')),
00264         sa.Column('tempgreetwarn', sa.Enum(*YESNO_VALUES,
00265                   name='yes_no_values')),
00266         sa.Column('operator', sa.Enum(*YESNO_VALUES,
00267                   name='yes_no_values')),
00268         sa.Column('envelope', sa.Enum(*YESNO_VALUES,
00269                   name='yes_no_values')),
00270         sa.Column('sayduration', sa.Integer),
00271         sa.Column('forcename', sa.Enum(*YESNO_VALUES,
00272                   name='yes_no_values')),
00273         sa.Column('forcegreetings', sa.Enum(*YESNO_VALUES,
00274                   name='yes_no_values')),
00275         sa.Column('callback', sa.String(80)),
00276         sa.Column('dialout', sa.String(80)),
00277         sa.Column('exitcontext', sa.String(80)),
00278         sa.Column('maxmsg', sa.Integer),
00279         sa.Column('volgain', sa.Numeric(precision=5, scale=2)),
00280         sa.Column('imapuser', sa.String(80)),
00281         sa.Column('imappassword', sa.String(80)),
00282         sa.Column('imapserver', sa.String(80)),
00283         sa.Column('imapport', sa.String(8)),
00284         sa.Column('imapflags', sa.String(80)),
00285         sa.Column('stamp', sa.DateTime())
00286     )
00287     op.create_index('voicemail_mailbox', 'voicemail', ['mailbox'])
00288     op.create_index('voicemail_context', 'voicemail', ['context'])
00289     op.create_index('voicemail_mailbox_context', 'voicemail',
00290                     ['mailbox', 'context'])
00291     op.create_index('voicemail_imapuser', 'voicemail', ['imapuser'])
00292 
00293     op.create_table(
00294         'meetme',
00295         sa.Column('bookid', sa.Integer, primary_key=True, nullable=False,
00296                   autoincrement=True),
00297         sa.Column('confno', sa.String(80), nullable=False),
00298         sa.Column('starttime', sa.DateTime()),
00299         sa.Column('endtime', sa.DateTime()),
00300         sa.Column('pin', sa.String(20)),
00301         sa.Column('adminpin', sa.String(20)),
00302         sa.Column('opts', sa.String(20)),
00303         sa.Column('adminopts', sa.String(20)),
00304         sa.Column('recordingfilename', sa.String(80)),
00305         sa.Column('recordingformat', sa.String(10)),
00306         sa.Column('maxusers', sa.Integer),
00307         sa.Column('members', sa.Integer, nullable=False, default=0)
00308     )
00309     op.create_index('meetme_confno_start_end', 'meetme',
00310                     ['confno', 'starttime', 'endtime'])
00311 
00312     op.create_table(
00313         'musiconhold',
00314         sa.Column('name', sa.String(80), primary_key=True, nullable=False),
00315         sa.Column('mode', sa.Enum(*MOH_MODE_VALUES, name='moh_mode_values')),
00316         sa.Column('directory', sa.String(255)),
00317         sa.Column('application', sa.String(255)),
00318         sa.Column('digit', sa.String(1)),
00319         sa.Column('sort', sa.String(10)),
00320         sa.Column('format', sa.String(10)),
00321         sa.Column('stamp', sa.DateTime())
00322     )
00323 
00324 
def downgrade():


Variable Documentation

down_revision = None

Definition at line 29 of file 4da0c5f79a9c_create_tables.py.

list IAX_ENCRYPTION_VALUES = ['yes', 'no', 'aes128']

Definition at line 50 of file 4da0c5f79a9c_create_tables.py.

list IAX_REQUIRECALLTOKEN_VALUES = ['yes', 'no', 'auto']

Definition at line 49 of file 4da0c5f79a9c_create_tables.py.

list IAX_TRANSFER_VALUES = ['yes', 'no', 'mediaonly']

Definition at line 51 of file 4da0c5f79a9c_create_tables.py.

list MOH_MODE_VALUES = ['custom', 'files', 'mp3nb', 'quietmp3nb', 'quietmp3']

Definition at line 53 of file 4da0c5f79a9c_create_tables.py.

string revision = '4da0c5f79a9c'

Definition at line 28 of file 4da0c5f79a9c_create_tables.py.

Initial value:

['allowed_not_screened', 'allowed_passed_screen',
                          'allowed_failed_screen', 'allowed',
                          'prohib_not_screened', 'prohib_passed_screen',
                          'prohib_failed_screen', 'prohib']

Definition at line 44 of file 4da0c5f79a9c_create_tables.py.

list SIP_DIRECTMEDIA_VALUES = ['yes', 'no', 'nonat', 'update']

Definition at line 40 of file 4da0c5f79a9c_create_tables.py.

list SIP_DTMFMODE_VALUES = ['rfc2833', 'info', 'shortinfo', 'inband', 'auto']

Definition at line 39 of file 4da0c5f79a9c_create_tables.py.

list SIP_PROGRESSINBAND_VALUES = ['yes', 'no', 'never']

Definition at line 41 of file 4da0c5f79a9c_create_tables.py.

list SIP_SESSION_REFRESHER_VALUES = ['uac', 'uas']

Definition at line 43 of file 4da0c5f79a9c_create_tables.py.

list SIP_SESSION_TIMERS_VALUES = ['accept', 'refuse', 'originate']

Definition at line 42 of file 4da0c5f79a9c_create_tables.py.

list SIP_TRANSPORT_VALUES = ['udp', 'tcp', 'tls', 'ws', 'wss', 'udp,tcp', 'tcp,udp']

Definition at line 38 of file 4da0c5f79a9c_create_tables.py.

list TYPE_VALUES = ['friend', 'user', 'peer']

Definition at line 36 of file 4da0c5f79a9c_create_tables.py.

list YESNO_VALUES = ['yes', 'no']

Definition at line 35 of file 4da0c5f79a9c_create_tables.py.


Generated on Thu Apr 16 06:41:37 2015 for Asterisk - The Open Source Telephony Project by  doxygen 1.5.6