[Spce-user] Fwd: ngcp-fraud-auto-lock

[Jon Bonilla (Manwe)]

El Thu, 21 Mar 2013 20:00:45 +0100 (CET)
Alejandro Sanchez Gimenez <alesg at coit.es> escribió:

> Hello Richard, 
> 
> 
> this is what I get: 
> 

Please, can you repeat the same queries with \G at the end?

Like

mysql> select * from contracts where id = 22\G;



btw I don't know why your mail is not an answer to the one Richard sent. It's
in a new thread.

 

> 
> 
> 


> +----+-------------+-------------+------------+----------+--------+-------------+---------------------+---------------------+---------------------+---------------------+ 
> | id | customer_id | reseller_id | contact_id | order_id | status |
> external_id | modify_timestamp | create_timestamp | activate_timestamp |
> terminate_timestamp |
> +----+-------------+-------------+------------+----------+--------+-------------+---------------------+---------------------+---------------------+---------------------+
> | 22 | NULL | 1 | NULL | NULL | active | asdfasdfsdf | 2013-03-21 15:02:14 |
> 2013-03-21 15:02:14 | 2013-03-21 15:02:14 | NULL |
> +----+-------------+-------------+------------+----------+--------+-------------+---------------------+---------------------+---------------------+---------------------+
> 1 row in set (0.00 sec) 
> 
> 
> 
> 
> mysql> select * from contract_balances where contract_id = 22; 
> +----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+ 
> | id | contract_id | cash_balance | cash_balance_interval | free_time_balance
> | free_time_balance_interval | start | end | invoice_id |
> +----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
> | 21 | 22 | 0 | 0 | 0 | 0 | 2013-03-01 00:00:00 | 2013-03-31 23:59:59 | NULL
> |
> +----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
> 1 row in set (0.00 sec) 
> 
> 
> 
> 
> mysql> select * from billing.billing_mappings m, billing.billing_profiles p 
> -> where p.id = m.billing_profile_id and m.contract_id = 22; 
> +----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+ 
> | id | start_date | end_date | billing_profile_id | contract_id | product_id
> | id | reseller_id | handle | name | prepaid | interval_charge |
> interval_free_time | interval_free_cash | interval_unit | interval_count |
> fraud_interval_limit | fraud_interval_lock | fraud_interval_notify |
> fraud_daily_limit | fraud_daily_lock | fraud_daily_notify | currency |
> vat_rate | vat_included |
> +----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+
> | 22 | NULL | NULL | 4 | 22 | NULL | 4 | 1 | Tarifa_plana | Tarifa plana | 0
> | 0 | 0 | 0 | month | 1 | 100 | 3 | | 100 | 3 | NULL | ⬠| 0 | 0 |
> +----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+
> 1 row in set (0.00 sec) 
> 
> 
> 
> 
> Thank you very much!!! 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130321/c6bdda5b/attachment-0001.asc>