How to change the pk_calls constraint

Tom Bilan ( tom@tdi.net )
Mon, 05 May 1997 22:42:52 -0400

I want to change the pk_calls constraint the the following so I can
hopefully
get rid of my USR recurring AcctSessionID problem. If it just so
happens that the
same user logged into the same port and got the same Accouting ID AND
the same
FramedAddress 3 months ago then I guess it wasn't meant to be logged
anyway!

AcctStatusType tinyint NOT NULL CONSTRAINT pk_Calls PRIMARY KEY
(NASIdentifier, NASPort, AcctSessionID, AcctStatusType, UserName,
FramedAddress)

The question is, how can I change the constrait to match the above? (A
nice
clean SQL command would do :)

Thanks,
Tom