Database Upgrade Manager
Your version of SimpleInvoices can now be upgraded. With this new release there are database patches that need to be applied
The list below describes which patches have and have not been applied to the database. If there are patches that have not been applied, run the Update database by clicking update.
Warning: Please backup your database before upgrading!
- *** Previously applied patches skipped to #297 ***
- SQL patch 297, Add User Security enhancement fields and values has already been applied in release 20180924
- SQL patch 298, Add Signature field to the biller table. has already been applied in release 20181003
- SQL patch 299, Add check number field to the payment table. has already been applied in release 20181003
- SQL patch 300, Add install complete table. has already been applied in release 20181008
- SQL patch 301, Add last_activity_date, aging_date and aging_value to invoices. has already been applied in release 20181012
- SQL patch 302, Added owing to invoices table has already been applied in release 20181017
- SQL patch 303, Add invoice custom field report extension to standard application and add sales_representative field. has already been applied in release 20181018
- SQL patch 304, Add default_invoice field to the customers table. has already been applied in release 20181020
- SQL patch 305, Add expense tables to the database. has already been applied in release 20181027
- SQL patch 306, Clean up default_tax_id and default_tax_id_2 for products has already been applied in release 20190329
- SQL patch 307, Fix cron_log cron_id data type has already been applied in release 20190329
- SQL patch 308, Remove dup id key from invoice_item_attachments and fix products_attributes type_id data type has already been applied in release 20190329
- SQL patch 309, Rename userid to user_id in log table has already been applied in release 20190329
- SQL patch 310, Make record unique id fields consistent in size and properties has already been applied in release 20190329
- SQL patch 311, Remove default from all id fields. has already been applied in release 20190329
- SQL patch 312, Remove default from domain_id & set misc id characteristics. has already been applied in release 20190329
- SQL patch 313, Use common characteristics for all non-autoincrement id type fields. has already been applied in release 20190329
- SQL patch 314, Create the index items for all auto increment fields. has already been applied in release 20190329
- SQL patch 315, Make all tables InnoDB, utf8 and utr8_unicode_ci has already been applied in release 20190329
- SQL patch 316, Change character type field settings to charset utf8 collate utf8_unicode_ci has already been applied in release 20190329
- SQL patch 317, Additional field characteristic setting changes prior to declaring foreign keys. has already been applied in release 20190425
- SQL patch 318, Add foreign keys to tables. has not been applied to the database
- SQL patch 319, Add set_aging field to si_preferences has not been applied to the database
Update