| .. |
|
0001-init.sql
|
#2: add trading account type type and fix schema migrations machinery
|
2025-04-20 17:11:49 +02:00 |
|
0002-trading-accounts.sql
|
#3: create account in SQL not in Python.
|
2025-04-20 17:42:12 +02:00 |
|
0003-new-account.sql
|
#3: create account in SQL not in Python.
|
2025-04-20 17:42:12 +02:00 |
|
0004-add-account-barcode.sql
|
#4: add account to barcode stored procedure.
|
2025-04-20 17:55:18 +02:00 |
|
0005-rename-account.sql
|
#5: rename account stored function
|
2025-04-20 18:00:40 +02:00 |
|
0006-new-currency.sql
|
#6: new currency stored function
|
2025-04-20 19:15:23 +02:00 |
|
0007-update-currency-sell-rate.sql
|
#7: migrate to stored function for updating currency sell rate.
|
2025-04-20 19:22:19 +02:00 |
|
0008-update-currency-buy-rate.sql
|
#8: stored function to update currency buy rate
|
2025-04-20 19:27:02 +02:00 |
|
0009-shop-sell.sql
|
Schema 0009: fix type inference for id
|
2025-07-10 16:17:34 +02:00 |
|
0010-shop-sell-for-cash.sql
|
0010: lookup item currency id
|
2025-07-12 18:52:21 +02:00 |
|
0011-shop-undo-sale.sql
|
Schema 0011: fix type inference for id
|
2025-07-10 16:19:25 +02:00 |
|
0012-shop-add-credit.sql
|
#12 - stored function for cash deposit transactions - remove duplicate fn
|
2025-04-21 17:30:57 +02:00 |
|
0013-shop-withdraw-credit.sql
|
#13: stored function for cash withdrawal transactions
|
2025-04-21 17:37:31 +02:00 |
|
0014-shop-transfer-credit.sql
|
fix bugs in schema version checking
|
2025-04-21 18:45:00 +02:00 |
|
0015-shop-buy-for-cash.sql
|
0015: find_buy_rate takes currency ID
|
2025-07-17 17:30:44 +02:00 |
|
0016-shop-receipt-to-credit.sql
|
Fix i_transaction_id as v_transaction_id.
|
2025-07-17 16:50:02 +02:00 |
|
0017-shop-fix-inventory.sql
|
0017: use proper account id argument - not a constant
|
2025-07-12 15:15:21 +02:00 |
|
0018-shop-fix-cash.sql
|
Schema 0018: fix ac-c-ounts
|
2025-07-10 16:24:31 +02:00 |
|
0019-shop-consolidate.sql
|
#17: stored function for "fixing" inventory transaction
|
2025-04-21 21:14:18 +02:00 |
|
0020-shop-undo.sql
|
o_id -> i_id
|
2025-07-12 19:12:52 +02:00 |
|
0021-constraints-on-numeric-columns.sql
|
0021: constraints on currency columns in database: numbers only
|
2025-07-17 16:02:50 +02:00 |
|
0022-shop-init.sql
|
0022: drop: add cascade
|
2025-07-21 16:34:28 +02:00 |
|
0023-inventory-balance.sql
|
0023: security definer
|
2025-07-21 17:02:02 +02:00 |
|
0024-find-rates-fix.sql
|
0024: drop old versions before installing new ones
|
2025-07-26 16:02:47 +02:00 |
