Why this error?

[lurtnowski]

im getting

ut this is in the script

SET foreign_key_checks = 0;

DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS drawing_section_templates;
DROP TABLE IF EXISTS dynamic_blocks;
DROP TABLE IF EXISTS drawings;
DROP TABLE IF EXISTS projects;
DROP TABLE IF EXISTS materials;
DROP TABLE IF EXISTS rooms;
DROP TABLE IF EXISTS buildings;
DROP TABLE IF EXISTS sites;
DROP TABLE IF EXISTS locations;

SET foreign_key_checks = 1;

[Martyr2]

And that is all you have in the script? There should be nothing wrong with that. The only thing I can think of is that you either are dropping some other table by accident or not running this particular script correctly. Are there any other tables or is that all of them?

[lurtnowski]

Sorry or not being clear, but after drop them and turn back on foreign keys, I create those tables.

[Martyr2]

Ok but is the error because of the drops or because of adding the tables? Remember if you have constraints on those tables during their creation, you will need to make sure to create the tables in the correct order.