0001 - Initial baseline, in 'initialize.sql' [Rick Falkvinge=RF]
0002 - Added functions for account plan maintenance and back/forward links to FinancialAccounts. [RF]
0003 - Added 'Year' field for salary tax data. [RF]
0004 - Added BankProfile tables and stored procs to insert/update. [RF]
0005 - Changed PostalCodeLength for NO DK to 4; for GH to zero; added Country.Currency. [RF]
0006 - Added Memberships.LocalNumber and .FamilyNumber; added CurrencyExchangeRate tables/procs. [RF]
0007 - NL update; added Lat/Long to PostalCodes and to People, indexed [RF]
0008 - GeographyUpdate updates ahead of deploying: added country, Guid [RF]
0009 - Fixed SalaryTaxLevels and CreateExchangeRateDataPoint [RF]
0010 - Fix for CurrencyExchangeRateSnapshotData [RF]
0011 - Added tables, procedures for centralized, decentralized roles [RF]
0012 - Renamed "Roles" to "Positions" to clarify terminology [RF]
0013 - Added PositionTitles for organizational culture flexibility [RF]
0014 - Forgot one storedproc in Db0012; renamed CreateAssignedRole [RF]
0015 - Merged PositionsStandard and PositionsAdditional into one table [RF]
0016 - Added SetCashAdvanceBudget procedure [RF]
0017 - Added SetCashAdvanceAmountCents procedure [RF]
0018 - Added "IsContractor" field to Payroll [RF]
0019 - Added "Acting" field to PositionAssignments [RF] [deleted later]
0020 - Added concurrency check to TerminatePositionAssignment [RF]
0021 - Added PositionCustomTitles and its stored procedures [RF]
0022 - Added VolunteerPositions and its stored procedures [RF]
0023 - Added procs to change Facebook, Twitter, GPlus IDs [RF]
0024 - Maint on CreatePayrollItem [RF]
0025 - Bugfix for 0024 [RF]
0026 - Added first tables, procs for hot bitcoin wallets [RF]
0027 - Fixes and additions to HotBitcoinAddresses, -Unspents [RF]
0028 - Bugfix for 0027 [RF]
0029 - Added unspent satoshis to hotaddress on create unspent [RF]
0030 - Added flexibility for Resolver classes for OutboundComms [RF]
0031 - Added foreign ID tables, procs for transactions, to track blockchain [RF]
0032 - Added native currency to transaction rows, for multi-currency accounting [RF]
0033 - Added transaction row identity return, necessary for 0032 [RF]
0034 - Fix for SetFinancialTransactionRowNativeCurrency
0035 - Added OrganizationSequenceId on FinancialTransactions, VatCents setter on invoices [RF]
0036 - Added support for VatCents on ExpenseClaims [RF]
0037 - Added Suppliers, ExternalContacts tables; no procs for them yet [RF]
0038 - VAT Report tables and functions [RF]
0039 - VatReport.Guid added [RF]
0040 - Document.HiresStatus added [RF]
0041 - InboundInvoice housekeeping; added OrgSeqId [RF]
0042 - Bugfix to SetInboundInvoiceOrganizationSequenceId [RF]
0043 - FinancialTransactionRows housekeeping [RF]
0044 - Mark bitcoin as cryptocurrency [RF]
0045 - VAT Report work [RF]
0046 - VatReports.Turnover=>TurnoverCents [RF]
0047 - Fix for null case in SetVatReportReleased [RF]
0048 - Fix for CreateVatReportItem, ForeignObjectId=>ForeignId [RF]
0049 - Another fix for CreateVatReportItem
0050 - Added VatReports.OpenTransaction, .CloseTransaction
0051 - Fix for CreateFinancialTransactionStub with Amount field gone (caused in 0043) [RF]
0052 - Added database support for multiple Bitcoin chain forks [RF]
0053 - Bugfix for 0052 [RF]
0054 - Fix for Conditional-CreateUTXO procedure with fork in effect [RF]
0055 - Fix for bug introduced with 0054, hash collisions in index [RF]
0056 - Splitting a storedproc into two; debugging a weird multi-row select return [RF]
0057 - Bugfix for 0056: case insensitivity caused always-true comparison w/o qualifier [RF]
0058 - Fixing the other half of 0056 [RF]
0059 - Added BackendServiceOrders, quite a bit of code too, for returning echo UTXOs from backend [RF]
0060 - Dumb fix for BSO tables: forgot autoincrement on the primary keys [RF]
0061 - And CreatedDateTime can't be an INT, while we're at it; also renaming dateTime => nowUtc [RF]
0062 - Added OrganizationSequenceId to OutboundInvoices (like 0041 but outbound) [RF]
0063 - Added DeriveUnique to HotBitcoinAddresses for ability to create unique HBAs [RF]
0064 - Quick fix for OutboundInvoices (how did this error happen?) [RF]
0065 - Dumb fix for 0062 (or rather, the error was dumb) [RF]
0066 - Added OrganizationSequenceId to CashAdvances, ExpenseClaims [RF]
0067 - Bugfix for 0066 [RF]
0068 - Added SetSalaryOpen [RF]
0069 - Added table, procs for ExpenseClaimGroups [RF]
0070 - Added first Applications tables, procs [RF]
0071 - Renamed Application to Applicant, to avoid a marsh and misery of name collisions [RF]
0072 - Critical bugfix for 0069 [RF]
0073 - FinancialTransactions.Comment and People.Name to UTF8 explicit charset [RF]
0074 - Added FinancialTransaction.ImportSha256 for making bank import better [RF]
0075 - Added tables, storedprocs for better external bank import [RF]
0076 - Added MaintenanceDonation tables, storedprocs [RF]