How do I update module without deleting module table records in PyroCMS?

Question

I have a products module. It's working fine.

I can add, update, delete and list products on the admin of pyrocms.

But now I need to add 4 columns namely for

Available, In Stock, On Hand, Delivered

something like that columns above.

whenever i uninstall my module it always deletes the default_products table.

Hope someone could Help.. Very Much Appreciated

Thanks..

Answer 1

You should use the upgrade function into the details.php file. In that function you have to insert all the query to manupulate the table. After the upload of the new module via Control Panel in the Add-on section you will see tha "Upgrade" button that will execute all the alter table query.

function upgrade($old){
//Your alter table query
}

Answer 2

There is some suggestion by my end

1. Either you can add these fields manual in the database table.
2. Take a back up of this table and add these fields in the module's detail.php so when you again install these module you can import the data from old table.

Hopefully this will help.

Answer 3

Your under-development module would work fine by adding the columns manually to the tables. no further work is needed.

Though you would need to update the detail.php of the module in order to install and uninstall the module.