Re: Diagnosing simple problems with "create table"

[Peter Brawley]

varchar column needs a length spec.

not null is redundant where the column is a PK.

column and FK declarations need to be separate eg ...

service_threshold_fk int not null,
foreign key (service_foreign_fk) references service_threshold(id),

Not a syntax error but auto_inc IDs will use positive ints, so best declare them int unsigned. And will you really need 2 or 4 billion IDs? If not, consider mediumint or smallint.

DDL is best executed interactively rather than by piping files.

Use the bug page (url at the top of forum page) to make a feature request re error reporting,