Support: Unapplied Patches

The list below describes which patches have and have not been applied to the database, the aim is to have them all applied. If there are patches that have not been applied to the Simple Invoices database, please run the Update database by clicking update


UPDATE

Warning:
SQL patch 0, Start has already been applied in release 20060514
SQL patch 1, Create sql_patchmanger table has already been applied in release 20060514
SQL patch 2, Update invoice no details to have a default currency sign has already been applied in release 20060514
SQL patch 3, Add a row into the defaults table to handle the default number of line items has already been applied in release 20060514
SQL patch 4, Set the default number of line items to 5 has already been applied in release 20060514
SQL patch 5, Add logo and invoice footer support to biller has already been applied in release 20060514
SQL patch 6, Add default invoice template option has already been applied in release 20060514
SQL patch 7, Edit tax description field lenght to 50 has already been applied in release 20060526
SQL patch 8, Edit default invoice template field lenght to 50 has already been applied in release 20060526
SQL patch 9, Add consulting style invoice has already been applied in release 20060531
SQL patch 10, Add enabled to biller has already been applied in release 20060815
SQL patch 11, Add enabled to customers has already been applied in release 20060815
SQL patch 12, Add enabled to preferences has already been applied in release 20060815
SQL patch 13, Add enabled to products has already been applied in release 20060815
SQL patch 14, Add enabled to products has already been applied in release 20060815
SQL patch 15, Add tax_id into invoice_items table has already been applied in release 20060815
SQL patch 16, Add Payments table has already been applied in release 20060827
SQL patch 17, Adjust data type of quantity field has already been applied in release 20060827
SQL patch 18, Create Payment Types table has already been applied in release 20060909
SQL patch 19, Add info into the Payment Type table has already been applied in release 20060909
SQL patch 20, Adjust accounts payments table to add a type field has already been applied in release 20060909
SQL patch 21, Adjust the defautls table to add a payment type field has already been applied in release 20060909
SQL patch 22, Add note field to customer has already been applied in release 20061026
SQL patch 23, Add note field to Biller has already been applied in release 20061026
SQL patch 24, Add note field to Products has already been applied in release 20061026
SQL patch 25, Add street address 2 to customers has already been applied in release 20061211
SQL patch 26, Add custom fields to customers has already been applied in release 20061211
SQL patch 27, Add mobile phone to customers has already been applied in release 20061211
SQL patch 28, Add street address 2 to billers has already been applied in release 20061211
SQL patch 29, Add custom fields to billers has already been applied in release 20061211
SQL patch 30, Creating the custom fields table has already been applied in release 20061211
SQL patch 31, Adding data to the custom fields table has already been applied in release 20061211
SQL patch 32, Adding custom fields to products has already been applied in release 20061211
SQL patch 33, Alter product custom field 4 has already been applied in release 20061214
SQL patch 34, Reset invoice template to default refer Issue 70 has already been applied in release 20070125
SQL patch 35, Adding data to the custom fields table for invoices has already been applied in release 20070204
SQL patch 36, Adding custom fields to the invoices table has already been applied in release 20070204
SQL patch 37, Reset invoice template to default due to new invoice template system has already been applied in release 20070523
SQL patch 38, Alter custom field table - field length now 255 for field name has already been applied in release 20070523
SQL patch 39, Alter custom field table - field length now 255 for field label has already been applied in release 20070523
SQL patch 40, Alter field name in sql_patchmanager has already been applied in release 20070523
SQL patch 41, Alter field name in si_account_payments has already been applied in release 20070523
SQL patch 42, Alter field name b_name to name has already been applied in release 20070523
SQL patch 43, Alter field name b_id to id has already been applied in release 20070523
SQL patch 44, Alter field name b_street_address to street_address has already been applied in release 20070523
SQL patch 45, Alter field name b_street_address2 to street_address2 has already been applied in release 20070523
SQL patch 46, Alter field name b_city to city has already been applied in release 20070523
SQL patch 47, Alter field name b_state to state has already been applied in release 20070523
SQL patch 48, Alter field name b_zip_code to zip_code has already been applied in release 20070523
SQL patch 49, Alter field name b_country to country has already been applied in release 20070523
SQL patch 50, Alter field name b_phone to phone has already been applied in release 20070523
SQL patch 51, Alter field name b_mobile_phone to mobile_phone has already been applied in release 20070523
SQL patch 52, Alter field name b_fax to fax has already been applied in release 20070523
SQL patch 53, Alter field name b_email to email has already been applied in release 20070523
SQL patch 54, Alter field name b_co_logo to logo has already been applied in release 20070523
SQL patch 55, Alter field name b_co_footer to footer has already been applied in release 20070523
SQL patch 56, Alter field name b_notes to notes has already been applied in release 20070523
SQL patch 57, Alter field name b_enabled to enabled has already been applied in release 20070523
SQL patch 58, Alter field name b_custom_field1 to custom_field1 has already been applied in release 20070523
SQL patch 59, Alter field name b_custom_field2 to custom_field2 has already been applied in release 20070523
SQL patch 60, Alter field name b_custom_field3 to custom_field3 has already been applied in release 20070523
SQL patch 61, Alter field name b_custom_field4 to custom_field4 has already been applied in release 20070523
SQL patch 62, Introduce system_defaults table has already been applied in release 20070523
SQL patch 63, Insert date into the system_defaults table has already been applied in release 20070523
SQL patch 64, Alter field name prod_id to id has already been applied in release 20070523
SQL patch 65, Alter field name prod_description to description has already been applied in release 20070523
SQL patch 66, Alter field name prod_unit_price to unit_price has already been applied in release 20070523
SQL patch 67, Alter field name prod_custom_field1 to custom_field1 has already been applied in release 20070523
SQL patch 68, Alter field name prod_custom_field2 to custom_field2 has already been applied in release 20070523
SQL patch 69, Alter field name prod_custom_field3 to custom_field3 has already been applied in release 20070523
SQL patch 70, Alter field name prod_custom_field4 to custom_field4 has already been applied in release 20070523
SQL patch 71, Alter field name prod_notes to notes has already been applied in release 20070523
SQL patch 72, Alter field name prod_enabled to enabled has already been applied in release 20070523
SQL patch 73, Alter field name c_id to id has already been applied in release 20070523
SQL patch 74, Alter field name c_attention to attention has already been applied in release 20070523
SQL patch 75, Alter field name c_name to name has already been applied in release 20070523
SQL patch 76, Alter field name c_street_address to street_address has already been applied in release 20070523
SQL patch 77, Alter field name c_street_address2 to street_address2 has already been applied in release 20070523
SQL patch 78, Alter field name c_city to city has already been applied in release 20070523
SQL patch 79, Alter field name c_state to state has already been applied in release 20070523
SQL patch 80, Alter field name c_zip_code to zip_code has already been applied in release 20070523
SQL patch 81, Alter field name c_country to country has already been applied in release 20070523
SQL patch 82, Alter field name c_phone to phone has already been applied in release 20070523
SQL patch 83, Alter field name c_mobile_phone to mobile_phone has already been applied in release 20070523
SQL patch 84, Alter field name c_fax to fax has already been applied in release 20070523
SQL patch 85, Alter field name c_email to email has already been applied in release 20070523
SQL patch 86, Alter field name c_notes to notes has already been applied in release 20070523
SQL patch 87, Alter field name c_custom_field1 to custom_field1 has already been applied in release 20070523
SQL patch 88, Alter field name c_custom_field2 to custom_field2 has already been applied in release 20070523
SQL patch 89, Alter field name c_custom_field3 to custom_field3 has already been applied in release 20070523
SQL patch 90, Alter field name c_custom_field4 to custom_field4 has already been applied in release 20070523
SQL patch 91, Alter field name c_enabled to enabled has already been applied in release 20070523
SQL patch 92, Alter field name inv_id to id has already been applied in release 20070523
SQL patch 93, Alter field name inv_biller_id to biller_id has already been applied in release 20070523
SQL patch 94, Alter field name inv_customer_id to customer_id has already been applied in release 20070523
SQL patch 95, Alter field name inv_type type_id has already been applied in release 20070523
SQL patch 96, Alter field name inv_preference to preference_id has already been applied in release 20070523
SQL patch 97, Alter field name inv_date to date has already been applied in release 20070523
SQL patch 98, Alter field name invoice_custom_field1 to custom_field1 has already been applied in release 20070523
SQL patch 99, Alter field name invoice_custom_field2 to custom_field2 has already been applied in release 20070523
SQL patch 100, Alter field name invoice_custom_field3 to custom_field3 has already been applied in release 20070523
SQL patch 101, Alter field name invoice_custom_field4 to custom_field4 has already been applied in release 20070523
SQL patch 102, Alter field name inv_note to note has already been applied in release 20070523
SQL patch 103, Alter field name inv_it_id to id has not been applied to the database
SQL patch 104, Alter field name inv_it_invoice_id to invoice_id has not been applied to the database
SQL patch 105, Alter field name inv_it_quantity to quantity has not been applied to the database
SQL patch 106, Alter field name inv_it_product_id to product_id has not been applied to the database
SQL patch 107, Alter field name inv_it_unit_price to unit_price has not been applied to the database
SQL patch 108, Alter field name inv_it_tax_id to tax_id has not been applied to the database
SQL patch 109, Alter field name inv_it_tax to tax has not been applied to the database
SQL patch 110, Alter field name inv_it_tax_amount to tax_amount has not been applied to the database
SQL patch 111, Alter field name inv_it_gross_total to gross_total has not been applied to the database
SQL patch 112, Alter field name inv_it_description to description has not been applied to the database
SQL patch 113, Alter field name inv_it_total to total has not been applied to the database
SQL patch 114, Add logging table has not been applied to the database
SQL patch 115, Add logging system preference has not been applied to the database
SQL patch 116, System defaults conversion patch - set default biller has not been applied to the database
SQL patch 117, System defaults conversion patch - set default customer has not been applied to the database
SQL patch 118, System defaults conversion patch - set default tax has not been applied to the database
SQL patch 119, System defaults conversion patch - set default invoice reference has not been applied to the database
SQL patch 120, System defaults conversion patch - set default number of line items has not been applied to the database
SQL patch 121, System defaults conversion patch - set default invoice template has not been applied to the database
SQL patch 122, System defaults conversion patch - set default paymemt type has not been applied to the database
SQL patch 123, Add option to delete invoices into the system_defaults table has not been applied to the database
SQL patch 124, Set default language in new lang system has not been applied to the database
SQL patch 125, Change log table that usernames are also possible as id has not been applied to the database
SQL patch 126, Add visible attribute to the products table has not been applied to the database
SQL patch 127, Add last_id to logging table has not been applied to the database
SQL patch 128, Add user table has not been applied to the database
SQL patch 129, Fill user table with default values has not been applied to the database
SQL patch 130, Create auth_challenges table has not been applied to the database
SQL patch 131, Make tax field 3 decimal places has not been applied to the database