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 |