Page 1 of 1
Deleted tables and fields remain in the database
Posted: 2020-01-16 17:58
by mgoetze
I looked inside Phpmyadmin today and noticed that there were a bunch of old tables that we had deleted in Appgini. Apparently deleting a table in the Appgini software does not actually delete the table in mysql. The same goes for fields within the table, the ones that we deleted long ago inside the Appgini desktop app are still in the database table.
Is this by design?
Re: Deleted tables and fields remain in the database
Posted: 2020-01-16 20:58
by jsetzer
Hi,
I have just added a test-table to one project, then generated the application, then removed the table and generated again.
I can confirm that the generated database migration script (updateDB.php) does NOT contain any DROP TABLE statements for tables which have been removed from the model. This means, as you have stated, the application will not delete existing tables during automatic migration.
I guess this is by design and I'm happy with keeping existing data.
Best,
Jan