put user_id in the contact table as a fk.
good luck.
"Michael P. Mehl" <[EMAIL PROTECTED]> wrote in message
002901c0f96c$908a97c0$0a00a8c0@sokrates">news:002901c0f96c$908a97c0$0a00a8c0@sokrates...
> Hi!
>
> I've got two tables:
>
> CREATE TABLE users (
>user_id bigint(20) unsigned DEFAULT '0
Hi!
I've got two tables:
CREATE TABLE users (
user_id bigint(20) unsigned DEFAULT '0' NOT NULL,
contact_id bigint(20) unsigned DEFAULT '0',
user_login varchar(100) NOT NULL,
PRIMARY KEY (user_id),
UNIQUE UC_user_id (user_id)
