aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
AgeCommit message (Collapse)Author
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
2022-02-22[age restriction] progress 16/n - refresh/reveal/link testsÖzgür Kesim
Age restriction works now with withdraw, melt/refresh/reveal and link, including tests. However, there is still a problem with the tests: The melting operation "refresh-melt-failing-age" that should fail (because of conflict), but currently fails for other reasons. I decided to disable that particular test (and the next) and submit the patch I have so far.
2022-02-17-migrate to Postgress 11: use BIGINT GENERATED BY DEFAULT AS IDENTITY ↵Christian Grothoff
instead of BIGSERIAL
2022-02-17-use age_maskChristian Grothoff
2022-02-17-fix CS nonce reuse check logicChristian Grothoff
2022-02-16[age restriction] progress 14/n - withdraw and depositÖzgür Kesim
Age restriction support for - withdraw is done and tested - deposit is done and tested TODOs: - melt/refresh/reveal - link ------ Added functions - TALER_age_restriction_commit - TALER_age_commitment_derive - TALER_age_commitment_hash - TALER_age_restriction_commitment_free_inside - Hash of age commitment passed around API boundaries Exchangedb adjustments for denominations - all prepared statements re: denominations now handle age_mask - signature parameters adjusted Hash and signature verification of /keys adjusted - Hashes of (normal) denominations and age-restricted denominations are calculated seperately - The hash of the age-restricted ones will then be added to the other hash - The total hash is signed/verified Tests for withdraw with age restriction added - TALER_EXCHANGE_DenomPublickey now carries age_mask - TALER_TESTING_cmd_withdraw_amount* takes age parameter - TALER_TESTING_find_pk takes boolean age_restricted - WithdrawState carries age_commitment and its hash - withdraw_run derives new age commitment, if applicable - Added age parameter to testing (13 as example) Various Fixes and changes - Fixes of post handler for /management/extensions - Fixes for offline tool extensions signing - Slight refactoring of extensions - Age restriction extension simplified - config is now global to extension - added global TEH_age_restriction_enabled and TEH_age_mask in taler-exchange-httpd - helper functions and macros introduced