* new table provisioning.voip_subscriber_password_journal
containing encrypted last used sip passwords from voip_subscribers
* new table provisioning.voip_subscriber_webpassword_journal
containing encrypted last used web passwords from voip_subscribers
* new table billing.admin_password_journal
containing encrypted last used password from admins
* provisoning.voip_subscribers new fields
- password_last_modify_timestmp
- webpassword_last_modify_timestmp
* billing.admins new fields
- saltedpass_last_modify_timestmp
Change-Id: I39ea5db4a007f16c9e5c4113971d619e70cbef37
inbound/outbound no longer represent the "full" direction and belong
only to A leg, so they are renamed to a_inbound/a_outbound accordingly.
Change-Id: I430f8a29cdb5e5af8fb8aac40168d218876b57bf
This is needed to perform manipulations to the SIP message
just before it leaves the system on the B-Leg side.
Change-Id: Ib7dccaa270154893d66285d312da3434d9b3039d
* relation to lcr_gw is now by foreign.id instead of foreign.flags,
that is to reflect the change that provisioning.voip_peer_hosts.id
and kamailio.lcr_gw.id is now equal and lcr_gw.flags no longer holds
the voip_peer_hosts id reference
Change-Id: Iec28e4f29468420917a4bb5d7f9d44409ea6a5c5
* virtual_child_sound_sets is a virtual view that fetches
all child sound sets of the one that is defined as a placeholder
argument
Change-Id: I74b38328130cbb85cb0d559033408620f721caa2
* voip_sound_sets new field 'parent_id'
* voip_sound_sets new field 'expose_to_customer'
* voip_sound_files new field 'use_parent'
* add new table (view) 'v_sound_set_files'
Change-Id: Ida6643ac7fcb2ab5860c5f306f3e4d8842e15e9c
Generating the statistics table is very expensive, takes much space, and
we can get that data already from kamailio RPCs or from Redis. Remove it
to avoid the redundant data and the wasted load.
Change-Id: I6b013d627c1e6b26eacc5250ec5dfbb78a811dab
- Add "billing_acl_roles" DBIx declaration, "admins" belongs to it.
- Add "billing_acl_role_mappings" DBIx declaration to organise the
roles hierarchy - "role_foo" has access to "role_baz" etc.
Change-Id: I9f3cc8dc1fd66b12469fb0f43ddd82dee4855490
* billing.domain_reseller is no longer in use by ngcp-schema as
the table is now deprecated
* add billing.domains.reseller_id field
* add billing.domains "belongs_to" relation to billing.resellers
* add billing.resellers "has_many" relation to billing.domains
Change-Id: Ia485ddac66a5063605f506dd888be550f7327bea
* add new columns and a primary key to sems_registrations
* voip_peer_hosts add might_have relation to kamailio.lcr_gw
* update kamailio.subscriber table fields
* change provisioning_voip_subscriber -> kamailio_subscriber relation
from has_many to has_one
Change-Id: I96e4aa7d68c09146d373e7300a762fd1c7b3f7da
fee matching works in 2 attempts:
1. try to find a fee matching <user@domain>
2. if none found, try to find a fee matching <user>
the billing_profile record will get a new field
"ignore_domain". if set to "1", step#1 above
should be skipped.
see 1af70b001db36cfbd9791ab90b7030cfa35a110e
Change-Id: Ia188a79e775d851e2309116232973d61acff6a20
* The 'is_system' column will be used for users
that will have permission to see, create,
edit, delete lawful intercept admins
Change-Id: Ic7fd79717426013ffc9643764ea44f4de7adc7f9
* Store 'email' for administrators to use
for password reset
* Additional 'ca_reset_passsword' column
to indicate wether an admin can request
password reset
Change-Id: Ifddbe500dfbf4cf034c23717cd377840da78ff63
Rene Krenn
Kirill Solomko
Marco Capetta
Fabricio Santolin da Silva
Guillem Jover
Oleksandr Duts
Flaviu Mates