Re: foreign key errors

Mayuran Yogarajah wrote: Mayuran Yogarajah wrote: The following is a transaction from MySQL: smysql> show tables; Empty set (0.00 sec) mysql> CREATE TABLE Userlist ( -> UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> Status VARCHAR(1) NOT NULL, -> EmailAddress

Re: foreign key errors

Mayuran Yogarajah wrote: The following is a transaction from MySQL: smysql> show tables; Empty set (0.00 sec) mysql> CREATE TABLE Userlist ( -> UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> Status VARCHAR(1) NOT NULL, -> EmailAddress VARCHAR(64) NOT NULL, -

foreign key errors

The following is a transaction from MySQL: smysql> show tables; Empty set (0.00 sec) mysql> CREATE TABLE Userlist ( -> UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> Status VARCHAR(1) NOT NULL, -> EmailAddress VARCHAR(64) NOT NULL, -> Password VARCHAR