Jerry Stuckle wrote:
On 12/7/2019 11:49 AM, ^Bart wrote:
I don't understand which is this warning :\
CREATE TABLE subfoodgroups
(
subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
language_id SMALLINT(5) UNSIGNED NOT NULL,
foodgroup_id INT(10) UNSIGNED NOT NULL,
rawmaterial ENUM ("Yes","No"),
PRIMARY KEY (subfoodgroup_id),
INDEX (language_id),
FOREIGN KEY (language_id) REFERENCES languages (language_id),
INDEX (language_id),
FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
)
ENGINE=INNODB;
^Bart
What was the warning?
Agreed.
FWIW, ERROR_CANNOT_REPRODUCE
mysql> create table languages
-> (
-> language_id smallint(5) unsigned not null auto_increment primary key
-> ) engine=innodb;
Query OK, 0 rows affected (0.00 sec)
mysql> create table foodgroups
-> (
-> foodgroup_id int(10) unsigned not null auto_increment primary key
-> ) engine=innodb;
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE TABLE subfoodgroups
-> (
-> subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
-> name VARCHAR(30) NOT NULL,
-> language_id SMALLINT(5) UNSIGNED NOT NULL,
-> foodgroup_id INT(10) UNSIGNED NOT NULL,
-> rawmaterial ENUM ("Yes","No"),
-> PRIMARY KEY (subfoodgroup_id),
-> INDEX (language_id),
-> FOREIGN KEY (language_id) REFERENCES languages (language_id),
-> INDEX (language_id),
-> FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
-> )
-> ENGINE=INNODB;
Query OK, 0 rows affected (0.02 sec)
mysql> explain subfoodgroups; +-----------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+----------------------+------+-----+---------+----------------+
| subfoodgroup_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(30) | NO | | NULL | |
| language_id | smallint(5) unsigned | NO | MUL | NULL | |
| foodgroup_id | int(10) unsigned | NO | MUL | NULL | |
| rawmaterial | enum('Yes','No') | YES | | NULL | |
+-----------------+----------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql>
--
Lew Pitcher
"In Skills, We Trust"
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)