diff options
Diffstat (limited to 'src/auditor/auditor-basedb.sql')
| -rw-r--r-- | src/auditor/auditor-basedb.sql | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/src/auditor/auditor-basedb.sql b/src/auditor/auditor-basedb.sql index 5c776606b..e5bd88ff3 100644 --- a/src/auditor/auditor-basedb.sql +++ b/src/auditor/auditor-basedb.sql @@ -1424,7 +1424,7 @@ COMMENT ON COLUMN public.deposits.done IS 'Set to TRUE once we have included thi -- Name: COLUMN deposits.shard; Type: COMMENT; Schema: public; Owner: grothoff -- -COMMENT ON COLUMN public.deposits.shard IS 'Used for load sharding. Should be set based on h_wire, merchant_pub and a service salt. Default of 0 onlyapplies for colums migrated from a previous version without sharding support. 64-bit value because we need an *unsigned* 32-bit value.'; +COMMENT ON COLUMN public.deposits.shard IS 'Used for load sharding. Should be set based on h_wire, merchant_pub and a service salt. Default of 0 onlyapplies for columns migrated from a previous version without sharding support. 64-bit value because we need an *unsigned* 32-bit value.'; -- @@ -5527,9 +5527,9 @@ COPY public.merchant_accounts (account_serial, merchant_serial, h_wire, salt, pa -- COPY public.merchant_contract_terms (order_serial, merchant_serial, order_id, contract_terms, h_contract_terms, creation_time, pay_deadline, refund_deadline, paid, wired, fulfillment_url, session_id) FROM stdin; -1 1 2021.011-AKS8401AF50G0 \\x7b22616d6f756e74223a22544553544b55444f533a34222c2273756d6d617279223a2268656c6c6f20776f726c64222c2266756c66696c6c6d656e745f75726c223a2274616c65723a2f2f66756c66696c6c6d656e742d737563636573732f746878222c22726566756e645f646561646c696e65223a7b22745f6d73223a313631303335353937363030307d2c22776972655f7472616e736665725f646561646c696e65223a7b22745f6d73223a313631303335353937363030307d2c2270726f6475637473223a5b5d2c22685f77697265223a225946544d4e4b385632574a5642564431325932344e3947373736365a5753353833564d37384a5a50594b485a4e3445355a54475443484d4844513835563239344d3532595348374d5650385a4e46544a335630374a424a434e454d4e4b423641585a4848423230222c22776972655f6d6574686f64223a22782d74616c65722d62616e6b222c226f726465725f6964223a22323032312e3031312d414b5338343031414635304730222c2274696d657374616d70223a7b22745f6d73223a313631303335353037363030307d2c227061795f646561646c696e65223a7b22745f6d73223a313631303335383637363030307d2c226d61785f776972655f666565223a22544553544b55444f533a31222c226d61785f666565223a22544553544b55444f533a31222c22776972655f6665655f616d6f7274697a6174696f6e223a312c226d65726368616e745f626173655f75726c223a22687474703a2f2f6c6f63616c686f73743a393936362f222c226d65726368616e74223a7b226e616d65223a2264656661756c74222c22696e7374616e6365223a2264656661756c74222c2261646472657373223a7b7d2c226a7572697364696374696f6e223a7b7d7d2c2265786368616e676573223a5b7b2275726c223a22687474703a2f2f6c6f63616c686f73743a383038312f222c226d61737465725f707562223a22304e5a45354e4735354a50444a4b53334b4e524b545a3344504d4639304a344a484839474335304a35545454514b564a43355447227d5d2c2261756469746f7273223a5b5d2c226d65726368616e745f707562223a2237564e39305837514e5648323448464a4d584a4450474e5a4e50364741334645533034445836514a34463458534d454d42515347222c226e6f6e6365223a2258333044355736355044474b414b3251355659304b394535374b434d38533044455130303452585952334e39365a343551575747227d \\x0ddb75312662ab63ecc16003666a47e6a56d971e6609bf006b3e95507f77ec8818b8b9464eed754be5ccfaa779c43b2d00105489457517ddb4937eb593a15011 1610355076000000 1610358676000000 1610355976000000 t f taler://fulfillment-success/thx -2 1 2021.011-01G89XA95V1FM \\x7b22616d6f756e74223a22544553544b55444f533a37222c2273756d6d617279223a226f7264657220746861742077696c6c20626520726566756e646564222c2266756c66696c6c6d656e745f75726c223a2274616c65723a2f2f66756c66696c6c6d656e742d737563636573732f746878222c22726566756e645f646561646c696e65223a7b22745f6d73223a313631303335353938333030307d2c22776972655f7472616e736665725f646561646c696e65223a7b22745f6d73223a313631303335353938333030307d2c2270726f6475637473223a5b5d2c22685f77697265223a225946544d4e4b385632574a5642564431325932344e3947373736365a5753353833564d37384a5a50594b485a4e3445355a54475443484d4844513835563239344d3532595348374d5650385a4e46544a335630374a424a434e454d4e4b423641585a4848423230222c22776972655f6d6574686f64223a22782d74616c65722d62616e6b222c226f726465725f6964223a22323032312e3031312d3031473839584139355631464d222c2274696d657374616d70223a7b22745f6d73223a313631303335353038333030307d2c227061795f646561646c696e65223a7b22745f6d73223a313631303335383638333030307d2c226d61785f776972655f666565223a22544553544b55444f533a31222c226d61785f666565223a22544553544b55444f533a31222c22776972655f6665655f616d6f7274697a6174696f6e223a312c226d65726368616e745f626173655f75726c223a22687474703a2f2f6c6f63616c686f73743a393936362f222c226d65726368616e74223a7b226e616d65223a2264656661756c74222c22696e7374616e6365223a2264656661756c74222c2261646472657373223a7b7d2c226a7572697364696374696f6e223a7b7d7d2c2265786368616e676573223a5b7b2275726c223a22687474703a2f2f6c6f63616c686f73743a383038312f222c226d61737465725f707562223a22304e5a45354e4735354a50444a4b53334b4e524b545a3344504d4639304a344a484839474335304a35545454514b564a43355447227d5d2c2261756469746f7273223a5b5d2c226d65726368616e745f707562223a2237564e39305837514e5648323448464a4d584a4450474e5a4e50364741334645533034445836514a34463458534d454d42515347222c226e6f6e6365223a224654454b32585345524751323442394d4434544a365145584842384b475145565654304550535236374a483456374759414b5330227d \\x21a27562bc99c3f9ad0645b80c06091025170fd8165e5c7709a51fc7f1737fe8da22b00e54295c4ca72e3486771388c816608b2e4821c59f5a56bb853244307b 1610355083000000 1610358683000000 1610355983000000 t f taler://fulfillment-success/thx -3 1 2021.011-0049H0MV0D6C2 \\x7b22616d6f756e74223a22544553544b55444f533a33222c2273756d6d617279223a227061796d656e7420616674657220726566756e64222c2266756c66696c6c6d656e745f75726c223a2274616c65723a2f2f66756c66696c6c6d656e742d737563636573732f746878222c22726566756e645f646561646c696e65223a7b22745f6d73223a313631303335353938353030307d2c22776972655f7472616e736665725f646561646c696e65223a7b22745f6d73223a313631303335353938353030307d2c2270726f6475637473223a5b5d2c22685f77697265223a225946544d4e4b385632574a5642564431325932344e3947373736365a5753353833564d37384a5a50594b485a4e3445355a54475443484d4844513835563239344d3532595348374d5650385a4e46544a335630374a424a434e454d4e4b423641585a4848423230222c22776972655f6d6574686f64223a22782d74616c65722d62616e6b222c226f726465725f6964223a22323032312e3031312d3030343948304d563044364332222c2274696d657374616d70223a7b22745f6d73223a313631303335353038353030307d2c227061795f646561646c696e65223a7b22745f6d73223a313631303335383638353030307d2c226d61785f776972655f666565223a22544553544b55444f533a31222c226d61785f666565223a22544553544b55444f533a31222c22776972655f6665655f616d6f7274697a6174696f6e223a312c226d65726368616e745f626173655f75726c223a22687474703a2f2f6c6f63616c686f73743a393936362f222c226d65726368616e74223a7b226e616d65223a2264656661756c74222c22696e7374616e6365223a2264656661756c74222c2261646472657373223a7b7d2c226a7572697364696374696f6e223a7b7d7d2c2265786368616e676573223a5b7b2275726c223a22687474703a2f2f6c6f63616c686f73743a383038312f222c226d61737465725f707562223a22304e5a45354e4735354a50444a4b53334b4e524b545a3344504d4639304a344a484839474335304a35545454514b564a43355447227d5d2c2261756469746f7273223a5b5d2c226d65726368616e745f707562223a2237564e39305837514e5648323448464a4d584a4450474e5a4e50364741334645533034445836514a34463458534d454d42515347222c226e6f6e6365223a2247533350534156344358365956453544413831384a423736314431375644315346565248373239355a474b4b4d5947354d444230227d \\x58029ce22a69b90e90ca40f9d144f1c606d60ba7f824fdf685222b91a5fa94848e6d085cdc604e67236c800884fa3b3d5203eb32a5fadfca3c73a6e41e9e690f 1610355085000000 1610358685000000 1610355985000000 t f taler://fulfillment-success/thx +1 1 2021.011-AKS8401AF50G0 \\x7b22616d6f756e74223a22544553544b55444f533a34222c2273756d6d617279223a2268656c6c6f20776f726c64222c2266756c66696c6c6d656e745f75726c223a2274616c65723a2f2f66756c66696c6c6d656e742d737563636573732f746878222c22726566756e645f646561646c696e65223a7b22745f6d73223a313631303335353937363030307d2c22776972655f7472616e736665725f646561646c696e65223a7b22745f6d73223a313631303335353937363030307d2c2270726f6475637473223a5b5d2c22685f77697265223a225946544d4e4b385632574a5642564431325932344e3947373736365a5753353833564d37384a5a50594b485a4e3445355a54475443484d4844513835563239344d3532595348374d5650385a4e46544a335630374a424a434e454d4e4b423641585a4848423230222c22776972655f6d6574686f64223a22782d74616c65722d62616e6b222c226f726465725f6964223a22323032312e3031312d414b5338343031414635304730222c2274696d657374616d70223a7b22745f6d73223a313631303335353037363030307d2c227061795f646561646c696e65223a7b22745f6d73223a313631303335383637363030307d2c226d61785f776972655f666565223a22544553544b55444f533a31222c226d61785f666565223a22544553544b55444f533a31222c22776972655f6665655f616d6f7274697a6174696f6e223a312c226d65726368616e745f626173655f75726c223a22687474703a2f2f6c6f63616c686f73743a393936362f222c226d65726368616e74223a7b226e616d65223a2264656661756c74222c22696e7374616e6365223a2264656661756c74222c2261646472657373223a7b7d2c226a7572697364696374696f6e223a7b7d7d2c2265786368616e676573223a5b7b2275726c223a22687474703a2f2f6c6f63616c686f73743a383038312f222c226d61737465725f707562223a22304e5a45354e4735354a50444a4b53334b4e524b545a3344504d4639304a344a484839474335304a35545454514b564a43355447227d5d2c2261756469746f7273223a5b5d2c226d65726368616e745f707562223a2237564e39305837514e5648323448464a4d584a4450474e5a4e50364741334645533034445836514a34463458534d454d42515347222c226e6f6e6365223a2258333044355736355044474b414b3251355659304b394535374b434d38533044455130303452585952334e39365a343551575747227d \\x0ddb75312662ab63ecc16003666a47e6a56d971e6609bf006b3e95507f77ec8818b8b9464eed754be5ccfaa779c43b2d00105489457517ddb4937eb593a15011 1610355076000000 1610358676000000 1610355976000000 t f taler://fulfillment-success/thx +2 1 2021.011-01G89XA95V1FM \\x7b22616d6f756e74223a22544553544b55444f533a37222c2273756d6d617279223a226f7264657220746861742077696c6c20626520726566756e646564222c2266756c66696c6c6d656e745f75726c223a2274616c65723a2f2f66756c66696c6c6d656e742d737563636573732f746878222c22726566756e645f646561646c696e65223a7b22745f6d73223a313631303335353938333030307d2c22776972655f7472616e736665725f646561646c696e65223a7b22745f6d73223a313631303335353938333030307d2c2270726f6475637473223a5b5d2c22685f77697265223a225946544d4e4b385632574a5642564431325932344e3947373736365a5753353833564d37384a5a50594b485a4e3445355a54475443484d4844513835563239344d3532595348374d5650385a4e46544a335630374a424a434e454d4e4b423641585a4848423230222c22776972655f6d6574686f64223a22782d74616c65722d62616e6b222c226f726465725f6964223a22323032312e3031312d3031473839584139355631464d222c2274696d657374616d70223a7b22745f6d73223a313631303335353038333030307d2c227061795f646561646c696e65223a7b22745f6d73223a313631303335383638333030307d2c226d61785f776972655f666565223a22544553544b55444f533a31222c226d61785f666565223a22544553544b55444f533a31222c22776972655f6665655f616d6f7274697a6174696f6e223a312c226d65726368616e745f626173655f75726c223a22687474703a2f2f6c6f63616c686f73743a393936362f222c226d65726368616e74223a7b226e616d65223a2264656661756c74222c22696e7374616e6365223a2264656661756c74222c2261646472657373223a7b7d2c226a7572697364696374696f6e223a7b7d7d2c2265786368616e676573223a5b7b2275726c223a22687474703a2f2f6c6f63616c686f73743a383038312f222c226d61737465725f707562223a22304e5a45354e4735354a50444a4b53334b4e524b545a3344504d4639304a344a484839474335304a35545454514b564a43355447227d5d2c2261756469746f7273223a5b5d2c226d65726368616e745f707562223a2237564e39305837514e5648323448464a4d584a4450474e5a4e50364741334645533034445836514a34463458534d454d42515347222c226e6f6e6365223a224654454b32585345524751323442394d4434544a365145584842384b475145565654304550535236374a483456374759414b5330227d \\x21a27562bc99c3f9ad0645b80c06091025170fd8165e5c7709a51fc7f1737fe8da22b00e54295c4ca72e3486771388c816608b2e4821c59f5a56bb853244307b 1610355083000000 1610358683000000 1610355983000000 t f taler://fulfillment-success/thx +3 1 2021.011-0049H0MV0D6C2 \\x7b22616d6f756e74223a22544553544b55444f533a33222c2273756d6d617279223a227061796d656e7420616674657220726566756e64222c2266756c66696c6c6d656e745f75726c223a2274616c65723a2f2f66756c66696c6c6d656e742d737563636573732f746878222c22726566756e645f646561646c696e65223a7b22745f6d73223a313631303335353938353030307d2c22776972655f7472616e736665725f646561646c696e65223a7b22745f6d73223a313631303335353938353030307d2c2270726f6475637473223a5b5d2c22685f77697265223a225946544d4e4b385632574a5642564431325932344e3947373736365a5753353833564d37384a5a50594b485a4e3445355a54475443484d4844513835563239344d3532595348374d5650385a4e46544a335630374a424a434e454d4e4b423641585a4848423230222c22776972655f6d6574686f64223a22782d74616c65722d62616e6b222c226f726465725f6964223a22323032312e3031312d3030343948304d563044364332222c2274696d657374616d70223a7b22745f6d73223a313631303335353038353030307d2c227061795f646561646c696e65223a7b22745f6d73223a313631303335383638353030307d2c226d61785f776972655f666565223a22544553544b55444f533a31222c226d61785f666565223a22544553544b55444f533a31222c22776972655f6665655f616d6f7274697a6174696f6e223a312c226d65726368616e745f626173655f75726c223a22687474703a2f2f6c6f63616c686f73743a393936362f222c226d65726368616e74223a7b226e616d65223a2264656661756c74222c22696e7374616e6365223a2264656661756c74222c2261646472657373223a7b7d2c226a7572697364696374696f6e223a7b7d7d2c2265786368616e676573223a5b7b2275726c223a22687474703a2f2f6c6f63616c686f73743a383038312f222c226d61737465725f707562223a22304e5a45354e4735354a50444a4b53334b4e524b545a3344504d4639304a344a484839474335304a35545454514b564a43355447227d5d2c2261756469746f7273223a5b5d2c226d65726368616e745f707562223a2237564e39305837514e5648323448464a4d584a4450474e5a4e50364741334645533034445836514a34463458534d454d42515347222c226e6f6e6365223a2247533350534156344358365956453544413831384a423736314431375644315346565248373239355a474b4b4d5947354d444230227d \\x58029ce22a69b90e90ca40f9d144f1c606d60ba7f824fdf685222b91a5fa94848e6d085cdc604e67236c800884fa3b3d5203eb32a5fadfca3c73a6e41e9e690f 1610355085000000 1610358685000000 1610355985000000 t f taler://fulfillment-success/thx \. @@ -8176,4 +8176,3 @@ ALTER TABLE ONLY public.aggregation_tracking -- -- PostgreSQL database dump complete -- - |