0000660: MySQL DDL files use wrong syntax

ID	Project	Category	View Status	Date Submitted	Last Update

0000660	bareos-core	director	public	2016-05-18 12:21	2017-11-28 12:34

Reporter	mosi0815	Assigned To
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	duplicate
Platform	Linux	OS	Ubuntu	OS Version	14.04
Product Version	15.2.3

Summary	0000660: MySQL DDL files use wrong syntax
Description	Let's take one table out of the create script for the database: CREATE TABLE Device ( ... MediaTypeId INTEGER UNSIGNED DEFAULT 0 REFERENCES MediaType, ... ); This is not gonna work. MySQL silently ignores REFERENCES in column definitions. From the manual: "MySQL parses but ignores “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. MySQL accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification" http://dev.mysql.com/doc/refman/5.7/en/create-table.html
Steps To Reproduce	Create the catalog in MySQL. Look at a DDL dump afterwards. The FKs are gone.
Tags	No tags attached.

Date Modified	Username	Field	Change
2016-05-18 12:21	mosi0815	New Issue
2016-10-07 12:25	joergs	Relationship added	related to 0000705
2017-11-28 12:33	joergs	Relationship replaced	duplicate of 0000705
2017-11-28 12:34	joergs	Note Added: 0002825
2017-11-28 12:34	joergs	Status	new => closed
2017-11-28 12:34	joergs	Resolution	open => duplicate

joergs 2017-11-28 12:34 developer ~0002825	I marked this as a duplicate of 0000705, even so this ticket has been created earlier, as ticket 705 contains a patch for this problem.