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