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?
Deleted tables and fields remain in the database
Re: Deleted tables and fields remain in the database
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
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
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools