Re: [Modeling-users] mdl_generate_DB_schema: table creation problem

[Sebastien B. <sbi...@us...>]

> Yes it is exactly it.
> I have entered bug num 695671

Fixed in CVS repository.

Note: INTEGER(#) is an invalid SQL data type (not postgres nor mysql sp=
ecific)

>=20
>   It must be because INTEGER(20) is invalid -- I get the same error w=
ith
>   postgresql until I replaced it with INTEGER alone.
>=20
>   --> Just remove any 'width' for id and hopefully it will be ok.
>=20
> I am feeding a simple (and with only one table) model to
> mdl_generate_DB_schema, that validates and generates python code OK. =
It
> fails with the log below.
>=20
>   Please fill in a bug report: the validation should detect that.
>=20
>   Can someone with a mysql at hand confirm that INTEGER(#) is also in=
valid for
>   mysql?
>=20
>=20
> -- S=E9bastien.