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
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?
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
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 61:40:52 |
Calls: | 6,488 |
Calls today: | 1 |
Files: | 12,096 |
Messages: | 5,274,433 |