Fwd: sqlbill (change log 13 Dec 2004)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear All,

  I have some problem about new sqlbill when i upgrade to prepaid,
table voipuser id and accountid is links ? ( i think is error )
-----------------
voipdb=> select * from voipaccount;
 id |        created         | closed | disabled | balance |
balancelimit | currencysym
----+------------------------+--------+----------+---------+--------------+-------------
  1 | 2005-06-10 12:36:41+07 |        | f        | 10.0000 |       0.0000 | USD
  2 | 2005-06-10 12:37:08+07 |        | f        | 10.0000 |       0.0000 | USD
  3 | 2005-06-10 12:37:09+07 |        | f        | 10.0000 |       0.0000 | USD
  4 | 2005-06-10 12:37:10+07 |        | f        | 10.0000 |       0.0000 | USD
(4 rows)

voipdb=> select id,h323id,accountid,firstname,surname from voipuser;
 id | h323id | accountid | firstname | surname
----+--------+-----------+-----------+---------
  1 | voip1  |         1 | John      | Smith
  2 | voip2  |         1 | Joe       | Smith
(2 rows)

if i add new user to use account id 4 will show error

voipdb=> INSERT INTO voipuser (h323id, accountid, chappassword,
firstname, surname)  VALUES ('voip4', 4, 'secret', '4444', '4444');
ERROR:  insert or update on table "voipuser" violates foreign key
constraint "voipuser_account_exists"
DETAIL:  Key (accountid)=(4) is not present in table "voipuser".

i think forignkey is wrong link
it not link to table voipaccount

Best,


-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.  
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r 
_______________________________________________________

Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id?49
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/


[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux