mirror of https://github.com/sipwise/db-schema.git
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
mr13.3
mr13.3.1
master
mr13.2
mr13.2.1
mr12.5.1
mr11.5.1
mr12.5
mr11.5
mr13.1
mr13.1.1
mr13.0.1
mr13.0
mr10.5
mr10.5.8
mr12.3.1
mr12.4.1
mr12.3
mr12.4
mr9.5
mr9.5.9
mr12.2.1
mr10.5.7
mr12.2
mr11.0.1
mr9.5.1
mr10.5.5
mr10.5.4
mr10.5.3
mr10.5.2
mr10.5.1
mr12.1.1
mr12.0.1
mr11.4.1
mr10.5.6
mr9.5.8
mr11.4
mr12.1
mr12.0
mr11.3.1
mr11.3
mr8.5
mr8.5.12
mr11.2.1
mr11.1.1
mr11.2
mr11.1
mr11.0
mr8.5.11
mr9.5.7
mr8.5.10
mr9.5.6
mr9.5.2
mr7.5
mr7.5.13
mr9.5.5
mr8.5.9
mr9.5.4
mr9.5.3
mr7.5.12
mr10.4
mr10.4.1
mr8.5.8
mr10.3
mr10.3.1
mr7.5.11
mr10.2.1
mr8.5.5
mr8.5.6
mr8.5.7
mr10.2
mr10.1.1
mr10.1
mr6.5
mr6.5.13
mr10.0.1
mr10.0
mr7.5.10
mr7.5.9
mr9.4.1
mr9.3.1
mr9.3
mr9.4
mr8.5.4
mr7.5.8
mr6.5.12
mr9.2
mr9.1
mr7.5.7
mr8.5.3
mr9.2.1
mr6.5.11
mr9.1.1
mr5.5
mr5.5.13
mr8.5.2
mr7.5.6
mr9.0
mr9.0.1
mr6.5.10
mr8.4
mr8.4.2
mr8.5.1
mr7.5.5
mr8.3
mr8.3.2
mr5.5.12
mr8.4.1
mr8.1.1
mr8.0.1
mr8.2
mr8.1
mr8.0
mr6.5.9
mr8.0.2
mr8.1.2
mr8.2.1
mr8.2.2
mr8.3.1
mr7.5.4
mr6.5.8
mr7.5.3
mr6.5.7
mr5.5.11
mr7.5.2
mr4.5
mr4.5.13
mr6.5.6
mr7.4
mr7.4.2
mr7.5.1
mr5.5.10
mr7.3
mr7.3.2
mr5.5.9
mr7.4.1
mr6.5.5
mr7.2
mr7.2.2
mr7.3.1
mr7.2.1
mr6.5.4
mr7.0
mr7.1
mr7.0.2
mr7.1.2
mr6.5.3
mr5.5.8
mr5.5.7
mr4.5.12
mr7.1.1
mr6.5.2
mr7.0.1
mr5.5.6
mr4.5.11
mr6.0.1
mr6.1.1
mr6.2.1
mr6.3.1
mr6.4.1
mr5.5.1
mr5.5.2
mr5.5.3
mr5.5.4
mr5.5.5
mr6.0.2
mr6.1.2
mr6.2.2
mr6.3.2
mr6.4.2
mr6.5.1
mr6.4
mr6.3
mr6.2
mr6.1
mr6.0
mr4.5.10
mr3.8
mr3.8.13
mr4.5.9
mr4.5.8
mr4.5.7
mr3.8.12
mr5.4
mr5.4.2
mr4.5.6
mr3.8.11
mr5.3
mr5.3.2
mr5.4.1
mr4.5.5
mr5.2
mr5.2.2
mr5.3.1
mr5.1
mr5.1.2
mr3.8.10
mr5.1.1
mr5.2.1
mr4.5.4
mr5.0
mr5.0.2
mr3.8.9
mr5.0.1
mr4.5.3
mr4.5.2
mr3.8.8
mr4.5.1
mr4.4
mr4.4.2
mr3.8.7
mr4.4.1
mr4.3
mr4.3.2
mr4.3.1
mr3.8.6
rkrenn/callingparty
mr3.5.1
mr3.5
mr4.2.2
mr4.2
mr3.8.4
mr3.8.5
mr4.1.2
mr4.2.1
mr4.1
mr4.1.1
mr4.0
mr3.8.3
mr4.0.2
mr4.0.1
apogrebennyk/force_outb_patterns
agranig/mult-billprof
mr3.8.2
mr3.8.1
mr3.7.2
mr3.7.1
mr3.7
rkrenn/api-journal
ipeshinskaya/11147
3.0
3.1
mr3.2.1
mr3.2.2
mr3.2
mr3.3.1
mr3.3.2
mr3.3
mr3.4.1
mr3.4.2
mr3.4
mr3.6.1
mr3.6.2
mr3.6
ipeshinskaya/9177
agranig/gpp
2.8
vseva/8117
agranig/pbx-dev-map
gjungwirth/voicemail_numbers
gjungwirth/subscriber_groups
ipeshinskaya/InvoiceTemplate5
agranig/subprof
vseva/5635
apogrebennyk/3_1_force_outbound
apogrebennyk/3_0_peer_route
mprokop/mt4973_sp2-db
agranig/aa-destination
agranig/peering-route
mprokop/sort_order
agranig/pref-label
vseva/pbx_groups
2.7
kamailio4
2.6
0.1
3.1.6
3.1.4
3.1.2
3.0.9
3.1.0
3.0.8
3.0.5
3.0.3
3.0.2
3.0.1
3.0.0
2.7.2
2.8.3
2.8.2
2.8.1
2.8.0
2.7.1
2.7.0
2.6.5
2.6.4
2.6.3
2.6.2
2.6.1
2.6.0
0.1.3
0.1.2
0.1.1
0.1.0
2.8.4
2.8.5
2.8.6
2.8.7
3.0.10
3.0.11
3.0.12
3.0.4
3.0.6
3.0.7
3.1.1
3.1.3
3.1.5
3.1.7
3.1.8
mr10.0.1.1
mr10.1.1.1
mr10.1.1.2
mr10.2.1.1
mr10.2.1.2
mr10.2.1.3
mr10.2.1.4
mr10.2.1.5
mr10.3.1.1
mr10.4.1.1
mr10.5.1.1
mr10.5.1.2
mr10.5.1.3
mr10.5.2.1
mr10.5.2.2
mr10.5.2.3
mr10.5.3.1
mr10.5.3.2
mr10.5.3.3
mr10.5.4.1
mr10.5.4.2
mr10.5.4.3
mr10.5.5.1
mr10.5.5.2
mr10.5.5.3
mr10.5.6.1
mr10.5.6.2
mr10.5.7.1
mr10.5.8.1
mr11.0.1.1
mr11.0.1.2
mr11.0.1.3
mr11.1.1.1
mr11.1.1.2
mr11.1.1.3
mr11.1.1.4
mr11.1.1.5
mr11.1.1.6
mr11.2.1.1
mr11.2.1.2
mr11.2.1.3
mr11.2.1.4
mr11.2.1.5
mr11.3.1.1
mr11.3.1.2
mr11.3.1.3
mr11.3.1.4
mr11.3.1.5
mr11.3.1.6
mr11.3.1.7
mr11.3.1.8
mr11.3.1.9
mr11.4.1.1
mr11.4.1.2
mr11.4.1.3
mr11.4.1.4
mr11.4.1.5
mr11.4.1.6
mr11.4.1.7
mr11.5.1.1
mr11.5.1.10
mr11.5.1.11
mr11.5.1.12
mr11.5.1.13
mr11.5.1.2
mr11.5.1.3
mr11.5.1.4
mr11.5.1.5
mr11.5.1.6
mr11.5.1.7
mr11.5.1.8
mr11.5.1.9
mr12.0.1.1
mr12.0.1.2
mr12.0.1.3
mr12.0.1.4
mr12.0.1.5
mr12.0.1.6
mr12.0.1.7
mr12.1.1.1
mr12.1.1.2
mr12.1.1.3
mr12.1.1.4
mr12.2.1.1
mr12.2.1.2
mr12.2.1.3
mr12.2.1.4
mr12.2.1.5
mr12.3.1.1
mr12.3.1.2
mr12.3.1.3
mr12.3.1.4
mr12.3.1.5
mr12.4.1.1
mr12.4.1.2
mr12.4.1.3
mr12.4.1.4
mr12.4.1.5
mr12.5.1.1
mr12.5.1.10
mr12.5.1.11
mr12.5.1.12
mr12.5.1.2
mr12.5.1.3
mr12.5.1.4
mr12.5.1.5
mr12.5.1.6
mr12.5.1.7
mr12.5.1.8
mr12.5.1.9
mr13.0.1.1
mr13.0.1.2
mr13.0.1.3
mr13.0.1.4
mr13.1.1.1
mr13.2.1.1
mr13.2.1.2
mr13.2.1.3
mr13.2.1.4
mr3.2.1.1
mr3.2.1.2
mr3.2.1.3
mr3.2.2.1
mr3.2.2.2
mr3.3.1.1
mr3.3.1.2
mr3.3.1.3
mr3.3.1.4
mr3.3.1.5
mr3.3.1.6
mr3.3.2.1
mr3.3.2.2
mr3.3.2.3
mr3.3.2.4
mr3.3.2.5
mr3.4.1.1
mr3.4.1.2
mr3.4.1.3
mr3.4.1.4
mr3.4.1.5
mr3.4.2.1
mr3.4.2.2
mr3.4.2.3
mr3.5.1.1
mr3.5.1.2
mr3.5.1.3
mr3.5.1.4
mr3.5.1.5
mr3.6.1.1
mr3.6.1.2
mr3.6.2.1
mr3.6.2.2
mr3.7.1.1
mr3.7.1.10
mr3.7.1.11
mr3.7.1.12
mr3.7.1.2
mr3.7.1.3
mr3.7.1.4
mr3.7.1.5
mr3.7.1.6
mr3.7.1.7
mr3.7.1.8
mr3.7.1.9
mr3.7.2.1
mr3.7.2.2
mr3.7.2.3
mr3.7.2.4
mr3.7.2.5
mr3.7.2.6
mr3.7.2.7
mr3.8.1.1
mr3.8.1.2
mr3.8.1.3
mr3.8.1.4
mr3.8.1.5
mr3.8.1.6
mr3.8.1.7
mr3.8.10.1
mr3.8.11.1
mr3.8.12.1
mr3.8.13.1
mr3.8.2.1
mr3.8.2.2
mr3.8.3.1
mr3.8.3.2
mr3.8.3.3
mr3.8.3.4
mr3.8.4.1
mr3.8.4.2
mr3.8.5.1
mr3.8.5.2
mr3.8.6.1
mr3.8.6.2
mr3.8.6.3
mr3.8.6.4
mr3.8.6.5
mr3.8.7.1
mr3.8.7.2
mr3.8.7.3
mr3.8.8.1
mr3.8.8.2
mr3.8.9.1
mr4.0.1.1
mr4.0.1.2
mr4.0.1.3
mr4.0.1.4
mr4.0.1.5
mr4.0.1.6
mr4.0.1.7
mr4.0.2.1
mr4.1.1.1
mr4.1.1.2
mr4.1.1.3
mr4.1.1.4
mr4.1.2.1
mr4.1.2.2
mr4.2.1.1
mr4.2.1.2
mr4.2.2.1
mr4.2.2.2
mr4.3.1.1
mr4.3.1.2
mr4.3.1.3
mr4.3.1.4
mr4.3.1.5
mr4.3.1.6
mr4.3.2.1
mr4.4.1.1
mr4.4.1.2
mr4.4.1.3
mr4.4.1.4
mr4.4.1.5
mr4.4.1.6
mr4.4.1.7
mr4.4.1.8
mr4.4.2.1
mr4.5.1.1
mr4.5.1.2
mr4.5.1.3
mr4.5.10.1
mr4.5.11.1
mr4.5.12.1
mr4.5.13.1
mr4.5.2.1
mr4.5.2.2
mr4.5.2.3
mr4.5.2.4
mr4.5.3.1
mr4.5.3.2
mr4.5.3.3
mr4.5.4.1
mr4.5.5.1
mr4.5.6.1
mr4.5.7.1
mr4.5.8.1
mr4.5.9.1
mr5.0.1.1
mr5.0.1.2
mr5.0.1.3
mr5.0.2.1
mr5.1.1.1
mr5.1.1.2
mr5.1.2.1
mr5.2.1.1
mr5.2.1.2
mr5.2.2.1
mr5.3.1.1
mr5.3.2.1
mr5.4.1.1
mr5.4.2.1
mr5.5.1.1
mr5.5.1.2
mr5.5.1.3
mr5.5.1.4
mr5.5.10.1
mr5.5.11.1
mr5.5.12.1
mr5.5.13.1
mr5.5.2.1
mr5.5.2.2
mr5.5.2.3
mr5.5.3.1
mr5.5.3.2
mr5.5.4.1
mr5.5.4.2
mr5.5.4.3
mr5.5.5.1
mr5.5.5.2
mr5.5.5.3
mr5.5.5.4
mr5.5.5.5
mr5.5.5.6
mr5.5.6.1
mr5.5.6.2
mr5.5.6.3
mr5.5.6.4
mr5.5.7.1
mr5.5.7.2
mr5.5.7.3
mr5.5.7.4
mr5.5.8.1
mr5.5.8.2
mr5.5.9.1
mr5.5.9.2
mr5.5.9.3
mr5.5.9.4
mr6.0.1.1
mr6.0.1.2
mr6.0.1.3
mr6.0.1.4
mr6.0.2.1
mr6.0.2.2
mr6.0.2.3
mr6.0.2.4
mr6.1.1.1
mr6.1.1.2
mr6.1.1.3
mr6.1.1.4
mr6.1.1.5
mr6.1.2.1
mr6.1.2.2
mr6.1.2.3
mr6.1.2.4
mr6.1.2.5
mr6.2.1.1
mr6.2.1.2
mr6.2.1.3
mr6.2.1.4
mr6.2.1.5
mr6.2.1.6
mr6.2.2.1
mr6.2.2.2
mr6.3.1.1
mr6.3.1.2
mr6.3.1.3
mr6.3.1.4
mr6.3.1.5
mr6.3.1.6
mr6.3.2.1
mr6.3.2.2
mr6.3.2.3
mr6.4.1.1
mr6.4.1.2
mr6.4.1.3
mr6.4.1.4
mr6.4.1.5
mr6.4.2.1
mr6.4.2.2
mr6.4.2.3
mr6.5.1.1
mr6.5.1.2
mr6.5.1.3
mr6.5.1.4
mr6.5.10.1
mr6.5.11.1
mr6.5.12.1
mr6.5.13.1
mr6.5.2.1
mr6.5.2.2
mr6.5.2.3
mr6.5.3.1
mr6.5.3.2
mr6.5.3.3
mr6.5.3.4
mr6.5.4.1
mr6.5.4.2
mr6.5.4.3
mr6.5.5.1
mr6.5.6.1
mr6.5.7.1
mr6.5.8.1
mr6.5.8.2
mr6.5.9.1
mr7.0.1.1
mr7.0.1.2
mr7.0.2.1
mr7.0.2.2
mr7.0.2.3
mr7.1.1.1
mr7.1.1.2
mr7.1.2.1
mr7.1.2.2
mr7.2.1.1
mr7.2.1.2
mr7.2.1.3
mr7.2.1.4
mr7.2.2.1
mr7.3.1.1
mr7.3.1.2
mr7.3.2.1
mr7.4.1.1
mr7.4.2.1
mr7.5.1.1
mr7.5.10.1
mr7.5.11.1
mr7.5.11.2
mr7.5.12.1
mr7.5.13.1
mr7.5.2.1
mr7.5.3.1
mr7.5.3.2
mr7.5.4.1
mr7.5.4.2
mr7.5.5.1
mr7.5.6.1
mr7.5.7.1
mr7.5.8.1
mr7.5.9.1
mr8.0.1.1
mr8.0.1.2
mr8.0.1.3
mr8.0.2.1
mr8.0.2.2
mr8.0.2.3
mr8.1.1.1
mr8.1.1.2
mr8.1.1.3
mr8.1.2.1
mr8.1.2.2
mr8.1.2.3
mr8.2.1.1
mr8.2.1.2
mr8.2.1.3
mr8.2.2.1
mr8.2.2.2
mr8.3.1.1
mr8.3.1.2
mr8.3.1.3
mr8.3.2.1
mr8.4.1.1
mr8.4.1.2
mr8.4.1.3
mr8.4.2.1
mr8.5.1.1
mr8.5.10.1
mr8.5.11.1
mr8.5.12.1
mr8.5.2.1
mr8.5.3.1
mr8.5.4.1
mr8.5.5.1
mr8.5.5.2
mr8.5.6.1
mr8.5.6.2
mr8.5.7.1
mr8.5.7.2
mr8.5.8.1
mr8.5.9.1
mr9.0.1.1
mr9.0.1.2
mr9.1.1.1
mr9.1.1.2
mr9.2.1.1
mr9.3.1.1
mr9.3.1.2
mr9.4.1.1
mr9.4.1.2
mr9.5.1.1
mr9.5.1.2
mr9.5.2.1
mr9.5.2.2
mr9.5.2.3
mr9.5.3.1
mr9.5.3.2
mr9.5.3.3
mr9.5.3.4
mr9.5.4.1
mr9.5.4.2
mr9.5.5.1
mr9.5.6.1
mr9.5.7.1
mr9.5.8.1
mr9.5.8.2
mr9.5.9.1
${ noResults }
15 lines
1020 B
15 lines
1020 B
use provisioning;
|
|
set autocommit=0;
|
|
|
|
SELECT id into @vpg_id FROM voip_preference_groups where name = 'Cloud PBX';
|
|
|
|
INSERT INTO voip_preferences (voip_preference_groups_id, attribute, label, type, max_occur, usr_pref, prof_pref, dom_pref, peer_pref, contract_pref, modify_timestamp, internal, expose_to_customer, data_type, read_only, description)
|
|
VALUES
|
|
(@vpg_id, 'csta_controller', "CSTA Controller", 0, 1, 1, 0, 0, 0, 0, NOW(), 0, 1, 'boolean', 0, 'Allow this subscriber to initiate CTI sessions to other subscribers within the same customer using uaCSTA via SIP.');
|
|
|
|
INSERT INTO voip_preferences (voip_preference_groups_id, attribute, label, type, max_occur, usr_pref, prof_pref, dom_pref, peer_pref, contract_pref, modify_timestamp, internal, expose_to_customer, data_type, read_only, description)
|
|
VALUES
|
|
(@vpg_id, 'csta_client', "CSTA Client", 0, 1, 1, 0, 0, 0, 0, NOW(), 0, 1, 'boolean', 0, 'Allow this subscriber to be controlled by a CTI subscriber within the same customer using uaCSTA via SIP.');
|
|
|
|
commit;
|