aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
AgeCommit message (Collapse)Author
2023-07-30unify to TEXT instead of mixing TEXT and VARCHARChristian Grothoff
2023-07-28finalize v3/v4 -> v2 exchange schema mergerÖzgür Kesim
2023-07-28-fix type defsChristian Grothoff
2023-07-27[WiP] added TALER_AMOUNT type to Postgres - first in age_withdrawÖzgür Kesim
- Added a type TALER_AMOUNT (val INT8, frac INT4) to Postgres. - Added PLSQL functions/procedures - amount_normalize(a) - amount_add(a, b) - amount_left_minus_right(l, r, diff, ok bool) - Added PQ-helper functions - TALER_PQ_query_param_amount_tuple() - TALER_PQ_result_spec_amount_tuple() - In table 'age_withdraw', changed fields 'amount_with_fee_val' and '..._frac' into single field 'amount_with_fee' be of type TALER_AMOUNT - Changed functions/stored procedures 'do_age_withdraw' and 'get_age_withdraw' to use new APIs. => make check runs through without errors, age-withdraw and -reveal test passes.
2023-01-11-no dropChristian Grothoff
2022-11-27-db tests pass againChristian Grothoff
2022-11-27more work on SQL refactoringChristian Grothoff
2022-11-27more sql refactoringChristian Grothoff
2022-11-27more work on SQL refactoringChristian Grothoff
2022-11-27more sql refactoringChristian Grothoff
2022-11-27intermediate step in major SQL refactoring (not done at all)Christian Grothoff
2022-03-31remove built sql files from vcMarco Boss
2022-03-31add shard init for shard nodeMarco Boss
2022-03-31add sharding logicMarco Boss
2022-03-27-remove tiny field, no longer neededChristian Grothoff
2022-03-27towards removing tiny bitChristian Grothoff
2022-03-26change sharding strategy for refund tableChristian Grothoff
2022-03-26add partitions to new p2p tablesChristian Grothoff
2022-03-24rework deposits sharding, towards making aggregator faster (not necessarily ↵Christian Grothoff
done)
2022-03-24first draft of service API for p2p paymentsChristian Grothoff
2022-03-23more skeleton logic for P2P operations on DBChristian Grothoff
2022-03-23revise P2P signatures and signing schema to address recently discovered ↵Christian Grothoff
design concern resulting in the split of the purse key into purse-contract and purse-merge keys
2022-03-22-fix drop SQL issue: drop functions properlyChristian Grothoff
2022-03-22implement helper functions for p2p signatures, clean up existing signature logicChristian Grothoff
2022-03-20ideas for mbossChristian Grothoff
2022-03-20add p2p tables from dd13Christian Grothoff
2022-03-19more work on recoup_by_reserve: add new materialized index to avoid hitting ↵Christian Grothoff
all partitions for the query
2022-03-19add missing index, move indices closer to table generationChristian Grothoff
2022-03-18add deposits_by_coin table to speed-up certain queries (in theory)Christian Grothoff
2022-03-18add selection by shard, ignore KYC in revocation test aggregationChristian Grothoff
2022-03-18change table structures again to shard better by coin_pub and not use ↵Christian Grothoff
known_coin_id so much
2022-03-17-remove dead field, return h_commitment_age to auditorChristian Grothoff
2022-03-17-misc fixesChristian Grothoff
2022-03-14attempt to make GRID5K_MARCO_OPT superfluousChristian Grothoff
2022-03-05work on global fee structureChristian Grothoff
2022-03-05refactor /wire to include logic to return the wad fee (for W2W payments)Christian Grothoff
2022-03-03use 32 byte hash for hpayto, use that for joins on queries to better align ↵Christian Grothoff
queries with partitions
2022-03-02include partitioning logic in dbinitMarco Boss
2022-03-01stay with partitions for now - find shards on dev/boss/shardingMarco Boss
2022-03-01tested shard creation locallyMarco Boss
2022-03-01prepare sharding / partitioning initMarco Boss
- create exchange-0001.sql with functions to create all tables and partitions / shards - create exchange-0002.sql for the master db
2022-02-28-work on test_sync.sh, incompleteChristian Grothoff
2022-02-28cleaner sqlMarco Boss
2022-02-28get test-auditor and #7181 to passChristian Grothoff
2022-02-27towards adding shard/partitioning init functionalityMarco Boss
2022-02-26add index on wire_targetsMarco Boss
- better performance on local db - many queries use wire_target_serial_id as join condition -> discussion use this as shard key?
2022-02-24Fix ON CONFLICT statements for distributed tablesMarco Boss
2022-02-24-on conflict exampleChristian Grothoff
2022-02-24-fix aggregator with deferred constraintChristian Grothoff
2022-02-24-unique constraint is crucialChristian Grothoff