1. How to check if the database has a table?
Customer can remove the plugin folder (not unistall) and the database can have old tables
I want to remove old tables if a customer tries to install plugin again?
2. How to add the new column and remove old columns using Migration
I saw that I need to create the new NopMigration class and remove the attributes 'SkipMigrationOnUpdate'
[SkipMigrationOnUpdate]
[NopMigration("2020/06/18 09:27:23:6455432", "MyPlugin.NameOfPlugin base schema")]
public class SchemaMigration : AutoReversingMigration
3. Can I use the SQL script in migration?
I saw examples from official site than I can use this command.
Execute.Script(sqlscript);
How to use it?
Thank you.