Database patches applied to Simple Invoices


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