Permits Table Schema #811

0x4007 · 2023-09-23T13:39:00Z

Permits

Holds the permit details associated with some credits.

Field	Type	Description	Example Value
`id`	int8	Unique identifier for the permit entry.	101
`created`	timestamptz	Timestamp when the permit was created.	2023-09-15T11:20:23.004Z
`updated`	timestamptz	Timestamp when the permit was last updated.	2023-09-15T11:22:40.050Z
`network`	smallserial	Network identifier.	100
`token`	CHAR(42)	Token associated with the permit.	0xe92E133E0b41519A2Ce9Dd4D7945Fa863463a97e
`amount`	int8	Amount associated with the token for the permit.	150000000000000000000
`nonce`	int8	Nonce associated with the permit.	8802044552...
`deadline`	int8	Deadline associated with the permit.	115792089237316195423570985008687907853269984665640564039457584007913129640000
`beneficiary`	CHAR(42)	Destination address for the permit's transfer.	0x4008FE2190c8F3E18098aeB4A40bb8eC149a342d
`owner`	CHAR(42)	Owner of the credit.	0xf88da4592C791213e52840d120E7E0B38B818bD2
`signature`	CHAR(132)	Signature associated with the credit.	0xecb65ed54b2ee7a0ffad5aff8314eef684f80dcb78c18b4ea9f588e083a0fa114546d466befa23cb81d040957615b5b1ad08966b64c5778802e5e115cdcd39241b

The text was updated successfully, but these errors were encountered:

seprintour · 2023-09-23T15:37:37Z

/start

ubiquibot · 2023-09-23T15:37:42Z




Deadline
Sat, 23 Sep 2023 17:37:41 UTC


Registered Wallet
0x3623338046b101ecEc741De9C3594CC2176f39E5

Tips:

Use /wallet 0x0000...0000 if you want to update your registered payment wallet address @user.
Be sure to open a draft pull request as soon as possible to communicate updates on your progress.
Be sure to provide timely updates to us when requested, or you will be automatically unassigned from the bounty.

seprintour · 2023-09-23T15:57:57Z

@pavlovcik deadline is out of range for type int8

I am trying to move existing data from permit to the new table, so the number is from one of the permit data that is apparently out of range for it

0x4007 · 2023-09-23T15:58:57Z

/ask what data type should we use

ubiquibot · 2023-09-23T15:58:59Z

! Error: This model's maximum context length is 16385 tokens. However, you requested 17805 tokens (1421 in the messages, 16384 in the completion). Please reduce the length of the messages or completion.

0x4007 · 2023-09-23T15:59:31Z

Oh I just realized something. This is a config error I think.

0x4007 · 2023-09-23T16:00:21Z

/ask what data type should we use

0x4007 · 2023-09-23T16:01:53Z

@pavlovcik deadline is out of range for type int8

I am trying to move existing data from permit to the new table, so the number is from one of the permit data that is apparently out of range for it

Chatgpt also recommended timestamptz but unsure if that's valid. I have to check in a bit I'm a bit occupied at the moment

seprintour · 2023-09-23T16:02:07Z

This is the deadline 115792089237316195423570985008687907853269984665640564039457584007913129639935

seprintour · 2023-09-23T16:06:47Z

Had to make deadline, nonce and amount numeric, bigint or int8 did not cut it

seprintour · 2023-09-23T16:38:36Z

Had to make deadline, nonce and amount numeric, bigint or int8 did not cut it

This means i'd have to change the Debit amount to numeric too, int8 supports up to 1e18 but no permit amount is just going to be 1 ETH or equivalent.

So it goes past 18 and int8 returns an out of range error

seprintour · 2023-09-23T16:40:25Z

0x4007 · 2023-09-24T08:44:50Z

Another idea I might add to a new scope, but we can save so much on memory if we have:

a foreign key to recognized partner wallet address (partner_wallet_id)
recognized token addresses (token_id) and a new tokens table.
bounty hunter address should be a foreign key also (wallet_id).

Tokens table:

id, created, updated, network, address

ubiquibot · 2023-10-08T02:40:28Z

Do you have any updates @seprintour? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Wed Oct 04 2023 02:12:08 GMT+0000 (Coordinated Universal Time)

seprintour · 2023-10-08T06:11:46Z

Still in review

ubiquibot · 2023-10-13T14:45:08Z

Do you have any updates @seprintour? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Mon Oct 09 2023 11:32:12 GMT+0000 (Coordinated Universal Time)

seprintour · 2023-10-15T23:28:05Z

Going to test the new implementations

ubiquibot · 2023-10-19T23:39:43Z

Do you have any updates @seprintour? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Sun Oct 15 2023 23:28:05 GMT+0000 (Coordinated Universal Time)

ubiquibot · 2023-10-22T23:54:16Z

@seprintour - Releasing the bounty back to dev pool because the allocated duration already ended!
Last activity time: Sun Oct 15 2023 23:28:05 GMT+0000 (Coordinated Universal Time)

ubiquibot · 2024-02-17T10:23:23Z

+ Evaluating results. Please wait...

ubiquibot · 2024-02-17T10:34:25Z

@pavlovcik the deadline is at 2024-02-17T12:34:24.911Z

ubiquibot · 2024-02-19T23:32:04Z

+ Evaluating results. Please wait...

ubiquibot · 2024-02-19T23:34:13Z

[ 415.8 WXDAI ]

@pavlovcik

Contributions Overview

View	Contribution	Count	Reward
Issue	Specification	1	80
Issue	Task	1.00	112.5
Issue	Comment	3	33.4
Issue	Comment	3	0
Review	Comment	15	126.6
Review	Comment	15	63.3

Conversation Incentives

Comment	Formatting	Relevance	Reward
## Permits Holds the permit details associated with some ...	80 h2: count: 1 score: "1" words: 3 code: count: 11 score: "11" words: 11 td: count: 44 score: "44" words: 129	1	80
Oh I just realized something. This is a config error I think. ...	2.4	0.52	2.4
> ![Screenshot 2023-09-23 at 4 57 02 PM](https://github.com/ubiq...	7 code: count: 2 score: "2" words: 2	0.81	7
Another idea I might add to a new scope, but we can save so much...	24 li: count: 3 score: "3" words: 36 code: count: 4 score: "4" words: 4 hr: count: 1 score: "1" words: 0	0.44	24
Oh I just realized something. This is a config error I think. ...	-	0.52	-
> ![Screenshot 2023-09-23 at 4 57 02 PM](https://github.com/ubiq...	- code: count: 2 score: "0" words: 2	0.81	-
Another idea I might add to a new scope, but we can save so much...	- li: count: 3 score: "0" words: 36 code: count: 4 score: "0" words: 4 hr: count: 1 score: "0" words: 0	0.44	-
This should have merged this in weeks ago. The number of outstan...	18.2	-	18.2
@0xcodercrane In this case you should consider just regenerating...	7.6	-	7.6
Don't think it matters the order regarding conflicts but technic...	3.8	-	3.8
> The bot is expected to be stable after these changes are imple...	2.4	-	2.4
Will need to e2e test and merge...	1.4	-	1.4
To be honest I spent a significant amount of time trying to comp...	13.2	-	13.2
Review comments at https://github.com/ubiquity/ubiquibot/pull/84...	2	-	2
There are many dimensions of your proposal to consider so it's h...	16.8	-	16.8
This should work on personal accounts (not just organizations) a...	4.8	-	4.8
Notes to self on incentive calculation architecture: work bac...	9.6 li: count: 2 score: "4" words: 21	-	9.6
I think next week. It feels really close to being done but I'm a...	5.6	-	5.6
@wannacfuture its better that you branch from here instead of pu...	3.8	-	3.8
> I'm trying to use the new version with workflow dispatcher and...	17 code: count: 1 score: "2" words: 26	-	17
You guys should make sure you're using the same version of Node....	18.4	-	18.4
@gitcoindev maybe you can help fix the knip CI here...	2	-	2
This should have merged this in weeks ago. The number of outstan...	9.1	-	9.1
@0xcodercrane In this case you should consider just regenerating...	3.8	-	3.8
Don't think it matters the order regarding conflicts but technic...	1.9	-	1.9
> The bot is expected to be stable after these changes are imple...	1.2	-	1.2
Will need to e2e test and merge...	0.7	-	0.7
To be honest I spent a significant amount of time trying to comp...	6.6	-	6.6
Review comments at https://github.com/ubiquity/ubiquibot/pull/84...	1	-	1
There are many dimensions of your proposal to consider so it's h...	8.4	-	8.4
This should work on personal accounts (not just organizations) a...	2.4	-	2.4
Notes to self on incentive calculation architecture: work bac...	4.8 li: count: 2 score: "2" words: 21	-	4.8
I think next week. It feels really close to being done but I'm a...	2.8	-	2.8
@wannacfuture its better that you branch from here instead of pu...	1.9	-	1.9
> I'm trying to use the new version with workflow dispatcher and...	8.5 code: count: 1 score: "1" words: 26	-	8.5
You guys should make sure you're using the same version of Node....	9.2	-	9.2
@gitcoindev maybe you can help fix the knip CI here...	1	-	1

[ 21.45 WXDAI ]

@seprintour

Contributions Overview

View	Contribution	Count	Reward
Issue	Comment	7	14.8
Review	Comment	8	6.65

Conversation Incentives

Comment	Formatting	Relevance	Reward
![Screenshot 2023-09-23 at 4 57 02 PM](https://github.com/ubiqui...	4.5 code: count: 2 score: "0.5" words: 2	0.75	4.5
This is the deadline `115792089237316195423570985008687907853269...	0.75 code: count: 1 score: "0.25" words: 1	0.73	0.75
Had to make `deadline`, `nonce` and `amount` numeric, bigint or ...	2.25 code: count: 3 score: "0.75" words: 3	0.73	2.25
> Had to make `deadline`, `nonce` and `amount` numeric, bigint o...	6.4 code: count: 8 score: "2" words: 9	0.555	6.4
![Screenshot 2023-09-23 at 5 39 39 PM](https://github.com/ubiqui...	-	0.375	-
Still in review ...	0.3	0.53	0.3
Going to test the new implementations...	0.6	0.41	0.6
@pavlovcik PR attached...	0.3	-	0.3
> From #787 > > Shouldn't you refactor functions that interact ...	0.6	-	0.6
> Shouldn't you refactor functions that interact with these tabl...	1.4	-	1.4
> Code looks good just have some rename requests Fixed issues...	0.2	-	0.2
Ping @pavlovcik @whilefoo ...	0.3	-	0.3
> Even if we ignore the bug with char(x), people are mostly reco...	2.2	-	2.2
@0xcodercrane @whilefoo i made it a `text` with a length constra...	1.55 code: count: 1 score: "0.25" words: 1	-	1.55
> @seprintour can you make new QA issue to make sure everything ...	0.1	-	0.1

[ 0 WXDAI ]

@BeanieMen

Contributions Overview

View	Contribution	Count	Reward
Review	Comment	1	0

Conversation Incentives

Comment	Formatting	Relevance	Reward
🎉...	-	-	-

[ 52.6 WXDAI ]

@gitcoindev

Contributions Overview

View	Contribution	Count	Reward
Review	Comment	7	52.6

Conversation Incentives

Comment	Formatting	Relevance	Reward
> There also seems to be an issue with ubiquibot-logger > > `...	9.1 code: count: 4 score: "4" words: 4	-	9.1
> > Hi @whilefoo , the `ubiquibot-logger` is an ESM module https...	7.3 code: count: 5 score: "5" words: 7	-	7.3
> > > Hi @whilefoo , the `ubiquibot-logger` is an ESM module htt...	14.9 code: count: 7 score: "7" words: 10	-	14.9
hi @whilefoo I will give this priority and try to fix till Monda...	1.4	-	1.4
@whilefoo I am on v0.3.4 already, so far no luck but closer and ...	5.2	-	5.2
hi @whilefoo could you please check ubiquibot-logger v0.3.5 ? I...	8.9 code: count: 1 score: "1" words: 6	-	8.9
Btw, about @pavlovcik 's last comment, I agree that we should sy...	5.8	-	5.8

[ 1.6 WXDAI ]

@0xcodercrane

Contributions Overview

View	Contribution	Count	Reward
Review	Comment	1	1.6

Conversation Incentives

Comment	Formatting	Relevance	Reward
should I merge https://github.com/ubiquity/ubiquibot/pull/643 in...	1.6	-	1.6

[ 0.6 WXDAI ]

@wannacfuture

Contributions Overview

View	Contribution	Count	Reward
Review	Comment	1	0.6

Conversation Incentives

Comment	Formatting	Relevance	Reward
should I resolve the conflicts? @pavlovcik ...	0.6	-	0.6

[ 139.7 WXDAI ]

@rndquu

Contributions Overview

View	Contribution	Count	Reward
Review	Comment	3	139.7

Conversation Incentives

Comment Formatting Relevance Reward

@pavlovcik
There is the supabase [diff tool](https://supabas...

42.1

a:
  count: 4
  score: "4"
  words: 7
li:
  count: 7
  score: "7"
  words: 110
code:
  count: 10
  score: "10"
  words: 11

-

42.1

@pavlovcik
Regarding the `locations` and metadata.

This i...

96

h2:
  count: 2
  score: "2"
  words: 11
h3:
  count: 4
  score: "4"
  words: 4
a:
  count: 2
  score: "2"
  words: 3
li:
  count: 10
  score: "10"
  words: 170
code:
  count: 21
  score: "21"
  words: 67
td:
  count: 16
  score: "16"
  words: 57

-

96

> Alternatively we do the two API calls but there's a good chanc...

1.6

-

1.6

[ 26.7 WXDAI ]

@whilefoo

Contributions Overview

View	Contribution	Count	Reward
Review	Comment	6	26.7

Conversation Incentives

Comment Formatting Relevance Reward

@seprintour can you make new QA issue to make sure everything is...

1.3

-

1.3

I'm trying to use the new version with workflow dispatcher and I...

6.8

code:
  count: 1
  score: "1"
  words: 26

-

6.8

There also seems to be an issue with ubiquibot-logger

co...</a></h6></td><td><details><summary>7.9</summary>
<pre>code:
  count: 1
  score: "1"
  words: 0
</pre>
</details></td><td>-</td><td>7.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1850189172">> Hi @whilefoo , the `ubiquibot-logger` is an ESM module https:/...</a></h6></td><td><details><summary>8.9</summary>
<pre>code:
  count: 5
  score: "5"
  words: 7
</pre>
</details></td><td>-</td><td>8.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1859155851">> Following the article https://dev.to/tigawanna/building-and-pu...</a></h6></td><td>1.2</td><td>-</td><td>1.2</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1872954224">@gitcoindev it's working now, thanks!...</a></h6></td><td>0.6</td><td>-</td><td>0.6</td></tr></tbody></table>
  </details>
  

  <details>
    <summary>
      <b
        ><h3>
          <a
            href="https://pay.ubq.fi/?claim=W3sidHlwZSI6ImVyYzIwLXBlcm1pdCIsInBlcm1pdCI6eyJwZXJtaXR0ZWQiOnsidG9rZW4iOiIweGU5MUQxNTNFMGI0MTUxOEEyQ2U4RGQzRDc5NDRGYTg2MzQ2M2E5N2QiLCJhbW91bnQiOiIzNzAwMDAwMDAwMDAwMDAwMDAwIn0sIm5vbmNlIjoiODgzMjYzODU5NzQyNzAwNzQxMTk3MTExOTg2ODU3MDgyOTQwODE5MDIzNDQ2NjA5MDE2NDAyNDAyNzgxOTE2MTc3MzM4MTA5NTA1NDYiLCJkZWFkbGluZSI6IjExNTc5MjA4OTIzNzMxNjE5NTQyMzU3MDk4NTAwODY4NzkwNzg1MzI2OTk4NDY2NTY0MDU2NDAzOTQ1NzU4NDAwNzkxMzEyOTYzOTkzNSJ9LCJ0cmFuc2ZlckRldGFpbHMiOnsidG8iOiIweGM0ZmM2M2Q4OGRkNDExYjE5YWNmODZmYjU2YmE1MDk0MTYxMWIzYTciLCJyZXF1ZXN0ZWRBbW91bnQiOiIzNzAwMDAwMDAwMDAwMDAwMDAwIn0sIm93bmVyIjoiMHg0NENhMTVEYjEwMWZEMWMxOTQ0NjdEYjZBRjBjNjdDNkJiRjRBQjUxIiwic2lnbmF0dXJlIjoiMHg1M2U0N2U0NDA1YTE4NDQ3YmZjNDI0ZDQxMjYyN2YwZDQ4NDUzMjA0Yjc5YjRmODdkMGNjYzc3YjU2ZDUwM2IxN2EwYjIwYmRlMjg2NThlMmQ5Nzg3MGNkNWYxODU0YTAzYWNmN2NjYjcwMjAwOGExMDAwOTA3ZjI0YjcxZjRmMjFjIiwibmV0d29ya0lkIjoxMDB9XQ%3D%3D"
          >
            [ 3.7 WXDAI ]</a
          >
        </h3>
        <h6>@EtherealGlow</h6></b
      >
    </summary>
    <h6>Contributions Overview</h6>
<table><thead>
<tr><th>View</th><th>Contribution</th><th>Count</th><th>Reward</th>
</thead><tbody>
<tr><td>Review</td><td>Comment</td><td>5</td><td>3.7</td></tr>
</tbody></table>
    <h6>Conversation Incentives</h6><table><thead><tr><th>Comment</th><th>Formatting</th><th>Relevance</th><th>Reward</th></tr></thead><tbody><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1783856208">I pray for the refactor to be done quickly 🙏...</a></h6></td><td>0.9</td><td>-</td><td>0.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1792385039">Do you guys have any estimate on when the refactor will be done ...</a></h6></td><td>1.3</td><td>-</td><td>1.3</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1807904469">Any new estimate for how much time is left?...</a></h6></td><td>0.9</td><td>-</td><td>0.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1823077738">🙏...</a></h6></td><td>-</td><td>-</td><td>-</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1840080819">When will the refactor be done 😭...</a></h6></td><td>0.6</td><td>-</td><td>0.6</td></tr></tbody></table>
  </details>
  
<!-- Ubiquity - Transactions - generatePermits - 6fa67c1
[
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "415800000000000000000"
      },
      "nonce": "38333513034576047603728459465198316047124679771248676106363099599649098504953",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x4007CE2083c7F3E18097aeB3A39bb8eC149a341d",
      "requestedAmount": "415800000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x288c7bf33277aa5a387ac27d8254840eaed0f61928e6038b1573752678003d6d5fbe262a90523995c904bbd5f83eebed5626e1334d17f3e0fb0ccad43f1a01711b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "21450000000000000000"
      },
      "nonce": "117449658478690774674475525924420994617664497531755087127592854646509219775",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x3623338046b101ecEc741De9C3594CC2176f39E5",
      "requestedAmount": "21450000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x8fcc4838628c4819766b9979a71b5a1f9e0872e53e0ae63468334712aa4f2f9e67c76dcac2d12cce23e1b9d95ed90ab16682f23ff9b5617c2b402d86e45cb58b1b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "0"
      },
      "nonce": "3921308704506634558874978975902617481676142385297996325523544826075305884605",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x24fbA1343132DE969Aeef0B1BD5CaAE1fB102978",
      "requestedAmount": "0"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x179a9ea17b0a66e5c4b98a47eb8b19255dd381660db9b8b539e069900c3a7df914c3c5d0e0c985bdb0a745abde74923758107e9ae86a3b2846b9ea49ed27b88a1c",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "52600000000000000000"
      },
      "nonce": "93625225420778288626721908622555336405149280690419865457364005434953601216838",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x7e92476D69Ff1377a8b45176b1829C4A5566653a",
      "requestedAmount": "52600000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0xb9c3f1863abf7a2b899b9e5f1f5da462628d4f8c85ab346926781f36749fd95b69524eb7652b34a6c5739f9aad01cf476f0de859446bd10a2073761fbe3933331c",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "1600000000000000000"
      },
      "nonce": "21500989528261682282368831072225924668672457587738053361370500713718917095890",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x00868BB3BA2B36316c2fc42E4aFB6D4246b77E46",
      "requestedAmount": "1600000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x05cd28189b4a91515fbec46e775dc0789a6902e3ce0428d2089376fb53aca70c52015c78677b468a7fa31765aec889b960c447f1999fdbe80fd49d4aa56684b41b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "600000000000000000"
      },
      "nonce": "39492798009574994231859345838586385697312571820604356901527821921348733072636",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x9e4ef4353c928cd3eb473e8f12aecf58c208ef40",
      "requestedAmount": "600000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x76708b2dfd82c9381f1c3cb9f896c719287b602c9e853942bfd0cee00141701d06fc86bb4b84599c85b6bb8d988f85d193ed46846e558a72e119d19072ba46981c",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "139700000000000000000"
      },
      "nonce": "101037746493808896729975079893798855587964602988535544269442456995751816023311",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x336C033842FA316d470e820c81b742e62A0765DC",
      "requestedAmount": "139700000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0xe27e3ca284ab2ca9691cd371b66223b9a084247f8c434c54d0f4791b9d7d7740518e51cf4ecd08746181314eb5d9a720c8d4edfe60efc71e91c0c9d7ce523c941b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "26700000000000000000"
      },
      "nonce": "7251030676004232400502645155768651013789703615509732741149337744142548259684",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0xCee33C98410DEbe67A319Cb94F39e403435Df319",
      "requestedAmount": "26700000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x06c5711cf053e65f72a23f53d143e5a6b0cdb58ecdfa871319f797beb261c4824174279e8634ea738fac999fc76765b326e994566bb668791ed83fb36d96ac471c",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "3700000000000000000"
      },
      "nonce": "88326385974270074119711198685708294081902344660901640240278191617733810950546",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0xc4fc63d88dd411b19acf86fb56ba50941611b3a7",
      "requestedAmount": "3700000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x53e47e4405a18447bfc424d412627f0d48453204b79b4f87d0ccc77b56d503b17a0b20bde28658e2d97870cd5f1854a03acf7ccb702008a1000907f24b71f4f21c",
    "networkId": 100
  }
]
-->

0x4007 mentioned this issue Sep 23, 2023

Database Schema Design: October 2023 #787

Open

5 tasks

0x4007 added Priority: 3 (High) Time: <2 Hours labels Sep 23, 2023

ubiquibot bot added the Price: 112.5 USD label Sep 23, 2023

0x4007 mentioned this issue Sep 23, 2023

Database Re-Architecture #812

Closed

ubiquibot bot mentioned this issue Sep 23, 2023

Permits Table Schema ubiquity/devpool-directory#955

Closed

ubiquibot bot assigned seprintour Sep 23, 2023

0x4007 mentioned this issue Sep 23, 2023

Ask ChatGPT /ask #291

Open

seprintour mentioned this issue Sep 23, 2023

chore: create permit table and move data #817

Open

0x4007 mentioned this issue Sep 24, 2023

Permits Table Schema II #819

Open

seprintour mentioned this issue Sep 25, 2023

Settlements Table Schema #808

Closed

0x4007 linked a pull request Oct 16, 2023 that will close this issue

Refactor/general #644

Merged

ubiquibot bot unassigned seprintour Oct 22, 2023

korrrba-bot bot mentioned this issue Nov 6, 2023

Permits Table Schema korrrba/devpool-directory#32

Open

gitcoindev mentioned this issue Nov 14, 2023

Taiko #883

Open

0x4007 closed this as completed in #644 Feb 17, 2024

0x4007 self-assigned this Feb 17, 2024

0x4007 reopened this Feb 19, 2024

0x4007 closed this as completed Feb 19, 2024

Permits Table Schema #811

Permits Table Schema #811

Comments

0x4007 commented Sep 23, 2023 • edited

Permits

seprintour commented Sep 23, 2023

ubiquibot bot commented Sep 23, 2023

Tips:

seprintour commented Sep 23, 2023 • edited

0x4007 commented Sep 23, 2023

ubiquibot bot commented Sep 23, 2023

0x4007 commented Sep 23, 2023

0x4007 commented Sep 23, 2023

0x4007 commented Sep 23, 2023

seprintour commented Sep 23, 2023

seprintour commented Sep 23, 2023

seprintour commented Sep 23, 2023

seprintour commented Sep 23, 2023

0x4007 commented Sep 24, 2023 • edited

ubiquibot bot commented Oct 8, 2023

seprintour commented Oct 8, 2023

ubiquibot bot commented Oct 13, 2023

seprintour commented Oct 15, 2023

ubiquibot bot commented Oct 19, 2023

ubiquibot bot commented Oct 22, 2023

ubiquibot bot commented Feb 17, 2024

ubiquibot bot commented Feb 17, 2024

ubiquibot bot commented Feb 19, 2024

ubiquibot bot commented Feb 19, 2024

Contributions Overview

Conversation Incentives

## **Permits** Holds the permit details associated with some ...

Notes to self on incentive calculation architecture: work bac...

Notes to self on incentive calculation architecture: work bac...

Contributions Overview

Conversation Incentives

> Code looks good just have some rename requests Fixed issues...

Ping @pavlovcik @whilefoo ...

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

@pavlovcik There is the supabase [diff tool](https://supabas...

@pavlovcik Regarding the locations and metadata. This i...

Contributions Overview

Conversation Incentives

0x4007 commented Sep 23, 2023 •

edited

seprintour commented Sep 23, 2023 •

edited

0x4007 commented Sep 24, 2023 •

edited

## Permits
Holds the permit details associated with some ...

Notes to self on incentive calculation architecture:

work bac...

Notes to self on incentive calculation architecture:

work bac...

> Code looks good just have some rename requests
Fixed issues...

Ping @pavlovcik @whilefoo

...

@pavlovcik
There is the supabase [diff tool](https://supabas...

@pavlovcik
Regarding the `locations` and metadata.

This i...