Deleted tables and fields remain in the database

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
mgoetze
Posts: 23
Joined: 2014-12-02 06:59

Deleted tables and fields remain in the database

Post by mgoetze » 2020-01-16 17:58

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?

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Deleted tables and fields remain in the database

Post by jsetzer » 2020-01-16 20:58

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
Kind regards,
<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 readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply