hi,
I am not able to create the third table i.e. AUTHENTICATE, In the first
two tables I have no problem ( i.e. DOMAIN and USER), I am giving you
the structure of all the three table along with the error i am getting..
I am not able to find out the mistake have done, please, help me..
-------------------------------------------
mysql> Create table DOMAIN
-> (
-> DOMAINID INT(4) UNSIGNED AUTO_INCREMENT ,
-> DOMAIN_ADDR VARCHAR(80),
-> DOMAIN_NAME CHAR(50) UNIQUE KEY,
-> DOMAIN_PORT INT(6) UNSIGNED,
-> DOMAIN_IP CHAR(12),
-> CREATED_BY VARCHAR(40),
-> CREATED_DATE DATE,
-> PRIMARY KEY (DOMAINID)) TYPE=InnoDB;
Query OK, 0 rows affected (0.05 sec)
------------------------------------------
mysql> Create table USER
-> (
-> USERID INT(4) UNSIGNED AUTO_INCREMENT ,
-> DOMAINID INT(4) ,
-> INDEX DOID (DOMAINID),
-> USERNAME VARCHAR(30) UNIQUE KEY,
-> USERFLAG CHAR(1) ,
-> USERPASSWD VARCHAR(8) ,
-> USERADDR VARCHAR(120),
-> USEREMAIL VARCHAR(50),
-> CREATED_BY VARCHAR(30),
-> CREATED_DATE DATE,
-> FOREIGN KEY (DOMAINID) REFERENCES DOMAIN(DOMAINID),
-> PRIMARY KEY (USERID)) TYPE=InnoDB;
Query OK, 0 rows affected (0.00 sec)
-------------------------------------------------------------------
mysql> Create table AUTHENTICATE
-> (
-> USERID INT(4) UNSIGNED,
-> INDEX USID (USERID),
-> AUTH_TYPE ENUM('BASIC','DIGEST'),
-> ALGO_USED ENUM('MD5','SESSION'),
-> NONCE VARCHAR(50),
-> FOREIGN KEY (USERID) REFERENCES USER(USERID))
TYPE=InnoDB;
ERROR 1064: You have an error in your SQL syntax near 'USER(USERID))
TYPE=InnoDB' at line 8
Thanks and regards,
Chetan Lavti
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
