3. How do we solve the bugs?
You need to send the bug in a detailed format and we would solve the bug on cost basis. Bugs are solved at a flat rate of USD 10 per hour.

13. How to correct / update the database while upgrading the software?
You need to follow the steps to upgrade the software:
Step 1: Take backup of old application and database.

Step 2: Replace the old application with the new one or add the new files in the old application.

Step 3: Compare the Old Database with the New Database. Please remember you would need to upgrade the old database as the previous processed information is stored in the old database. Hence you need to compare the old database with the new database. Use the following command to check for new tables in the new database.
select table_name from newdb .information_schema.tables where table_name not in (
select Table_name from olddb .information_schema.columns
) order by 1

Step 4: Once you have updated the data tables, now you need to check if there is any difference with respect to the data columns. Use the following command:
select table_name,Column_name from newdb .information_schema.columns where column_name not in (
select Column_name from olddb .information_schema.columns
)
order by 1