[Spce-user] Editing billing fees through SQL directly

[Alex Lutay]

Hi Jiri,

Sipwise REST API is stable, with backward compatibility.
DB schema is a subject for changes without notifications.

Local DB changes are often an issue for upgrade to the new releases. It
is highly NOT recommended to change DB directly.

On 11/30/20 3:56 PM, Jiri Ptacnik wrote:
> Thanks, I know, but it needs a lot of coding. Working in SQL is a
> piece of cake, it is a line of query.
> 
> I know, it could be dangerous, but still curious.
> 
> JGP
> 
> po 30. 11. 2020 v 15:42 odesílatel Matthias Hohl
> <matthias.hohl at telematica.at> napsal:
>>
>> I would recommend you to look into the API documentation.
>>
>> Via API you can modify your billing Profiles und Fees.
>>
>>
>>
>>
>>
>>
>>
>> Von: Jiri Ptacnik <ptakjura at gmail.com>
>> Gesendet: Montag, 30. November 2020 13:50
>> An: spce-user <spce-user at lists.sipwise.com>
>> Betreff: [Spce-user] Editing billing fees through SQL directly
>>
>>
>>
>> If one wants to edit billing fees not through GUI, but directly in
>> MySQL... I mean change for example Onpeak init rate on existing fee,
>> not creating a new one.
>>
>> Is it matter of "billing_fees" or "billing_fees_history" table. Or both?
>>
>> Or when I change billing_fees table, billing_fees_history updates
>> myself and keeps new values and historical too? And it should be the
>> right path...?
>>
>> thanks
>>
>> J. George P.
>>
>> --
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
> 

-- 
Alex Lutay