| Patch ID | Description | Release |
|---|---|---|
| 0 | Start | 20060514 |
| 1 | Create sql_patchmanger table | 20060514 |
| 200 | Update extensions table | 20090529 |
| 201 | Set domain_id on system defaults table to 1 | 20090622 |
| 202 | Set extension_id on system defaults table to 1 | 20090622 |
| 203 | Move all old consulting style invoices to itemised | 20090704 |
| 252 | Language - reset to en_US - due to folder renaming | 20100419 |
| 270 | Make SimpleInvoices faster - add index | 20100419 |
| 271 | Make SimpleInvoices faster - add index | 20100419 |
| 253 | Add PaymentsGateway API ID field | 20110918 |
| 254 | Product Matrix - update line items table | 20130313 |
| 255 | Product Matrix - update line items table | 20130313 |
| 256 | Product Matrix - update line items table | 20130313 |
| 257 | Product Matrix - update line items table | 20130313 |
| 258 | Product Matrix - update line items table | 20130313 |
| 259 | Product Matrix - update line items table | 20130313 |
| 260 | Product Matrix - update line items table | 20130313 |
| 261 | Product Matrix - update line items table | 20130313 |
| 262 | Add product attributes system preference | 20130313 |
| 263 | Product Matrix - update line items table | 20130313 |
| 272 | Add product attributes system preference | 20130313 |
| 264 | Product - use notes as default line item description | 20130314 |
| 265 | Product - expand/show line item description | 20130314 |
| 266 | Product - expand/show line item description | 20130322 |
| 267 | Product Matrix - insert attribute types | 20130325 |
| 268 | Product Matrix - insert attribute types | 20130327 |
| 269 | Product Matrix - insert attribute types | 20130327 |
| 273 | Make SimpleInvoices faster - add index | 20130927 |
| 274 | Only One Default Variable name per domain allowed - add unique index | 20131007 |
| 275 | Make EMail / Password pair unique per domain - add unique index | 20131007 |
| 276 | Each invoice Item must belong to a specific Invoice with a specific domain_id | 20131008 |
| 277 | Add Index for Quick Invoice Item Search for a domain_id | 20131008 |
| 278 | Each Invoice Item can have only one instance of each tax | 20131008 |
| 279 | Drop unused superseded table si_product_matrix if present | 20131009 |
| 280 | Each domain has their own extension instances | 20131011 |
| 281 | Each domain has their own custom_field id sets | 20131011 |
| 282 | Each domain has their own logs | 20131011 |
| 283 | Match field type with foreign key field si_user.id | 20131012 |
| 284 | Make si_index sub_node and sub_node_2 fields as integer | 20131016 |
| 285 | Fix compound Primary Key for si_index table | 20131016 |
| 286 | Speedup lookups from si_index table with indices in si_invoices table | 20131016 |
| 287 | Populate additional user roles like domain_administrator | 20131017 |
| 288 | Fully relational now - do away with the si_index table | 20131017 |
| 289 | Each cron_id can run a maximum of only once a day for each domain_id | 20131108 |
| 290 | Set all Flag fields to tinyint(1) and other 1 byte fields to char | 20131109 |
| 291 | Clipped size of zip_code and credit_card_number fields to realistic values | 20131111 |
| 292 | Added Customer/Biller User ID column to user table | 20140103 |
| 293 | Add department to the customers | 20161004 |
| 294 | Add custom_flags table for products. | 20180922 |
| 295 | Add net income report. | 20180923 |
| 296 | Add past due report. | 20180924 |
| 297 | Add User Security enhancement fields and values | 20180924 |
| 298 | Add Signature field to the biller table. | 20181003 |
| 299 | Add check number field to the payment table. | 20181003 |
| 300 | Add install complete table. | 20181008 |
| 301 | Add last_activity_date, aging_date and aging_value to invoices. | 20181012 |
| 302 | Added owing to invoices table | 20181017 |
| 303 | Add invoice custom field report extension to standard application and add sales_representative field. | 20181018 |
| 304 | Add default_invoice field to the customers table. | 20181020 |
| 305 | Add expense tables to the database. | 20181027 |
| 306 | Clean up default_tax_id and default_tax_id_2 for products | 20190329 |
| 307 | Fix cron_log cron_id data type | 20190329 |
| 308 | Remove dup id key from invoice_item_attachments and fix products_attributes type_id data type | 20190329 |
| 309 | Rename userid to user_id in log table | 20190329 |
| 310 | Make record unique id fields consistent in size and properties | 20190329 |
| 311 | Remove default from all id fields. | 20190329 |
| 312 | Remove default from domain_id & set misc id characteristics. | 20190329 |
| 313 | Use common characteristics for all non-autoincrement id type fields. | 20190329 |
| 314 | Create the index items for all auto increment fields. | 20190329 |
| 315 | Make all tables InnoDB, utf8 and utr8_unicode_ci | 20190329 |
| 316 | Change character type field settings to charset utf8 collate utf8_unicode_ci | 20190329 |
| 317 | Additional field characteristic setting changes prior to declaring foreign keys. | 20190425 |
| 318 | Add foreign keys to tables. | 20190507 |
| 319 | Add set_aging field to si_preferences | 20200123 |