Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
None
-
None
Description
I have a table in mysql (in attachment, mytable.sql), I export it to a db_schema.dba (also in attachment)
Then (I drop mytable table), and I load again this db_schema.dba to test the file with:
bin/php/ezsqlinsertschema.php --type=mysql --user=root db_schema.dba mydatabase
And I get the error (impossible to load the .dba file), in my error.log:
[ Oct 13 2011 12:38:36 ] [] eZMySQLDB: Query error: Invalid default value for 'prefix_id'. Query: CREATE TABLE mytable ( prefix_id tinyint(3) NOT NULL DEFAULT '', xx_id int(10) NOT NULL DEFAULT '0', UNIQUE KEY country ( prefix_id, xx_id ) ) [ Oct 13 2011 12:38:36 ] [] : Failed inserting the SQL: CREATE TABLE mytable ( prefix_id tinyint(3) NOT NULL DEFAULT '', xx_id int(10) NOT NULL DEFAULT '0', UNIQUE KEY country ( prefix_id, xx_id ) )