Database Re-Architecture #812

0x4007 · 2023-09-23T13:50:11Z

Tables

Every table should start with the following columns: id, created, updated and have foreign keys in the last columns.
We should completely stop using GitHub user/repo/org names as they have led to issues with renames etc. Instead we should ONLY use GitHub IDs (integers)
I am referencing the production database, so some tables like multiplier might not exist in other databases. If so a comment should be left so that we handle the deletion.

Access

The columns should be renamed and adhere to the above rules.

id, created, updated, user_id, organization_id, repository_id, multiplier, priority, time, price.

Issues

Should be deleted. No idea why this exists in the first place. @0xcodercrane rfc

This seems to be constantly updated so its logic must be disconnected from the bot side.

Logs

Will make an exception since they are ephemeral and connected to multiple systems.

Multiplier

Delete.

Penalty

Debits Table Schema #809

Permits

Permits Table Schema #811

Users

Seems nice to have even if we have no immediate plans for the data. We will leave it unchanged.

Wallets

id, created, updated, user_id, wallet (char42)

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

Keyrxng · 2023-09-23T17:17:12Z

/start

ubiquibot · 2023-09-23T17:17:17Z

Too many assigned issues, you have reached your max of 2

molecula451 · 2023-09-23T21:41:14Z

/start

ubiquibot · 2023-09-23T21:41:22Z




Deadline
Sun, 24 Sep 2023 01:41:21 UTC


Registered Wallet
0x4D0704f400D57Ba93eEa88765C3FcDBD826dCFc4

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.

ubiquibot · 2023-09-28T10:50:11Z

Do you have any updates @molecula451? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Sat Sep 23 2023 21:41:14 GMT+0000 (Coordinated Universal Time)

ubiquibot · 2023-09-28T10:50:12Z

Do you have any updates @molecula451? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Sat Sep 23 2023 21:41:14 GMT+0000 (Coordinated Universal Time)

molecula451 · 2023-10-03T07:21:57Z

/start

ubiquibot · 2023-10-03T07:22:04Z


  
  
    
    
  
  
    Deadline
    Tue, 03 Oct 2023 11:22:03 UTC
  
  
    Registered Wallet
    0x4D0704f400D57Ba93eEa88765C3FcDBD826dCFc4

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.

ubiquibot · 2023-10-07T21:26:19Z

Do you have any updates @molecula451? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Tue Oct 03 2023 07:21:57 GMT+0000 (Coordinated Universal Time)

ubiquibot · 2023-10-10T11:51:36Z

@molecula451 - Releasing the bounty back to dev pool because the allocated duration already ended!
Last activity time: Tue Oct 03 2023 07:21:57 GMT+0000 (Coordinated Universal Time)

molecula451 · 2023-10-10T21:59:47Z

/start

ubiquibot · 2023-10-10T21:59:53Z


  
  
    
    
  
  
    Deadline
    Wed, 11 Oct 2023 01:59:51 UTC
  
  
    Registered Wallet
    0x4D0704f400D57Ba93eEa88765C3FcDBD826dCFc4

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.

0xcodercrane · 2023-10-11T08:45:39Z

Should be deleted. No idea why this exists in the first place. @0xcodercrane rfc

Originally created it for data analytics of issues. but looks like no need to use it for even weekly reports. agree to delete.
@molecula451

ubiquibot · 2023-10-15T00:10:27Z

Do you have any updates @molecula451? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Tue Oct 10 2023 21:59:47 GMT+0000 (Coordinated Universal Time)

ubiquibot · 2023-10-18T03:30:34Z

@molecula451 - Releasing the bounty back to dev pool because the allocated duration already ended!
Last activity time: Tue Oct 10 2023 21:59:47 GMT+0000 (Coordinated Universal Time)

ubiquibot · 2023-10-19T04:45:31Z

@pavlovcik The time limit for this bounty is on Thu, 19 Oct 2023 08:45:31 UTC

ubiquibot · 2023-10-19T04:45:35Z

@pavlovcik - Releasing the bounty back to dev pool because the allocated duration already ended!
Last activity time: Sat Sep 23 2023 13:50:11 GMT+0000 (Coordinated Universal Time)

molecula451 · 2023-10-22T14:12:03Z

/start

ubiquibot · 2023-10-22T14:12:09Z


  
  
    
    
  
  
    Deadline
    Sun, 22 Oct 2023 18:12:08 UTC
  
  
    Registered Wallet
    0x4D0704f400D57Ba93eEa88765C3FcDBD826dCFc4

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.

rndquu · 2023-10-22T16:33:20Z

/start

I don't think the current issue is relevant/available because (as far as I understand) it's going to be solved as a part of #644

molecula451 · 2023-10-22T16:48:45Z

i was thinking the same after seeing #644 linked to this issue but i didnt see relevant/related commits at #644

molecula451 · 2023-10-23T01:10:03Z

@pavlovcik can you confirm us?

Also can you confirm this?

on "Access" table you are mentioning "multiplier" but you also mention Multiplier to be delete

0x4007 · 2023-10-23T06:47:11Z

I consolidated multiplier details in the access table. Perhaps we should rename the access table but it holds the miscellaneous user information.

I guess I don't get "activity credit" cause I'm active on a branch off of my linked pull request right now, rebuilding the comment incentives code.

molecula451 · 2023-10-26T00:07:29Z

@pavlovcik look what i have for you

id.mp4

the 'wallet' table is ready

@rndquu

rndquu · 2023-10-26T07:24:08Z

@pavlovcik look what i have for you

id.mp4
the 'wallet' table is ready

@rndquu

This is great but I still think that the current issue should be solved after #644 is merged because #812 and #644 are heavily interconnected

molecula451 · 2023-10-26T19:46:02Z

well yes, makes a bit of some sense just in case the bot unassign me and the /start command it's still disabled this is the branch i was working development...molecula451:ubiquibot:db-testing these are the changes for the table so it's hopefully useful to pavlovick

ubiquibot · 2023-10-30T22:59:41Z

Do you have any updates @molecula451? If you would like to release the bounty back to the DevPool, please comment /stop
Last activity time: Thu Oct 26 2023 19:46:02 GMT+0000 (Coordinated Universal Time)

ubiquibot · 2023-11-02T22:00:46Z

@molecula451 - Releasing the bounty back to dev pool because the allocated duration already ended!
Last activity time: Thu Oct 26 2023 19:46:02 GMT+0000 (Coordinated Universal Time)

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

+ Evaluating results. Please wait...

ubiquibot · 2024-02-17T10:33:46Z

@pavlovcik the deadline is at 2024-02-17T14:33:46.314Z

ubiquibot · 2024-02-19T23:31:07Z

+ Evaluating results. Please wait...

ubiquibot · 2024-02-19T23:33:08Z

[ 458.3 WXDAI ]

@pavlovcik

Contributions Overview

View	Contribution	Count	Reward
Issue	Specification	1	56.8
Issue	Task	1.00	225
Issue	Comment	1	10
Issue	Comment	1	0
Review	Comment	13	111
Review	Comment	13	55.5

Conversation Incentives

Comment	Formatting	Relevance	Reward
# Tables Every table should start with the following column...	56.8 h1: count: 1 score: "1" words: 1 h2: count: 8 score: "8" words: 8 li: count: 5 score: "5" words: 98 code: count: 5 score: "5" words: 4	1	56.8
I consolidated multiplier details in the access table. Perhaps w...	10	0.6	10
I consolidated multiplier details in the access table. Perhaps w...	-	0.6	-
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
Will need to e2e test and merge...	1.4	-	1.4
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
Will need to e2e test and merge...	0.7	-	0.7
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

[ 12.6 WXDAI ]

@molecula451

Contributions Overview

View	Contribution	Count	Reward
Issue	Comment	4	12.6

Conversation Incentives

Comment	Formatting	Relevance	Reward
i was thinking the same after seeing #644 linked to this issue b...	2.1	0.43	2.1
@pavlovcik can you confirm us? Also can you confirm this? ...	2.5	0.68	2.5
@pavlovcik look what i have for you https://github.com/ubiqui...	2.5	0.69	2.5
well yes, makes a bit of some sense just in case the bot unassig...	5.5	0.67	5.5

[ 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

[ 4 WXDAI ]

@0xcodercrane

Contributions Overview

View	Contribution	Count	Reward
Issue	Comment	1	2.4
Review	Comment	1	1.6

Conversation Incentives

Comment	Formatting	Relevance	Reward
> Should be deleted. No idea why this exists in the first place....	2.4	0.77	2.4
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

[ 147.3 WXDAI ]

@rndquu

Contributions Overview

View	Contribution	Count	Reward
Issue	Comment	2	7.6
Review	Comment	3	139.7

Conversation Incentives

Comment	Formatting	Relevance	Reward
> /start I don't think the current issue is relevant/availabl...	3.3	0.53	3.3
> @pavlovcik look what i have for you id.mp4 the 'wa...	4.3	0.55	4.3
@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

[ 25.4 WXDAI ]

@whilefoo

Contributions Overview

View	Contribution	Count	Reward
Review	Comment	5	25.4

Conversation Incentives

Comment Formatting Relevance Reward

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=W3sidHlwZSI6ImVyYzIwLXBlcm1pdCIsInBlcm1pdCI6eyJwZXJtaXR0ZWQiOnsidG9rZW4iOiIweGU5MUQxNTNFMGI0MTUxOEEyQ2U4RGQzRDc5NDRGYTg2MzQ2M2E5N2QiLCJhbW91bnQiOiIzNzAwMDAwMDAwMDAwMDAwMDAwIn0sIm5vbmNlIjoiNTk4ODM2Nzg3NTY4MjY2ODA5MTQ5NjY2MTc5ODYwMDc1OTE3ODgxODM1OTExNjAxODg5MDI3MjE0MDY4ODYxMTA4NzY4ODQ4ODc0MTgiLCJkZWFkbGluZSI6IjExNTc5MjA4OTIzNzMxNjE5NTQyMzU3MDk4NTAwODY4NzkwNzg1MzI2OTk4NDY2NTY0MDU2NDAzOTQ1NzU4NDAwNzkxMzEyOTYzOTkzNSJ9LCJ0cmFuc2ZlckRldGFpbHMiOnsidG8iOiIweGM0ZmM2M2Q4OGRkNDExYjE5YWNmODZmYjU2YmE1MDk0MTYxMWIzYTciLCJyZXF1ZXN0ZWRBbW91bnQiOiIzNzAwMDAwMDAwMDAwMDAwMDAwIn0sIm93bmVyIjoiMHg0NENhMTVEYjEwMWZEMWMxOTQ0NjdEYjZBRjBjNjdDNkJiRjRBQjUxIiwic2lnbmF0dXJlIjoiMHgzOGU0YWZjMzBjNmRiNWRlYmE3YmRmMjc1NzhmN2I1NjczM2ZmZjNlNTBkMjQ5ZjEzODNjZTBkYjA3MjgzN2Q2MGQ3ZjBlMzUwMDBjNmVlMjY1YjMyNTUyMWZmNzYwYmE5NDU2MmFkOGQ4NTQ1M2I2MjViMTlmZDU2MmFhZTlmODFiIiwibmV0d29ya0lkIjoxMDB9XQ%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": "458300000000000000000"
      },
      "nonce": "90458115034262081205345373146063713476472817040868510242819320726954521352625",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x4007CE2083c7F3E18097aeB3A39bb8eC149a341d",
      "requestedAmount": "458300000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x38d9b6e69dd8986b17d749ebcd4da123fb362a7f375eeefb658e3419e14110173d616ada5801b4810420bd09bf62cce41c46f31bb96f7aea392de352b7f3a62b1b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "12600000000000000000"
      },
      "nonce": "110099339885451226162857872926912701911377525436024768956912307306332584705076",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x4D0704f400D57Ba93eEa88765C3FcDBD826dCFc4",
      "requestedAmount": "12600000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x3d7ebf32ca969377179276722e7eedfdf43bf386d38530d4bf82a87796296beb3c398ab1c50825f7eadac3a7438509901a4a94c1c4227301024f54b869a8690b1b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "0"
      },
      "nonce": "109303442468556615015751960666333647024818132142523107665140875427877494151781",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x24fbA1343132DE969Aeef0B1BD5CaAE1fB102978",
      "requestedAmount": "0"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x8e96a4ea850545e2edf753e195187aea216cdbc078e6dbf56aca7ba5c9af523e4ccb52b49422cdae66139429e01121742a46e2d54323e5235f4f19ed9858f1e51b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "52600000000000000000"
      },
      "nonce": "70126982497457742632469508041607863493686911979317900876010413759469475575281",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x7e92476D69Ff1377a8b45176b1829C4A5566653a",
      "requestedAmount": "52600000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x89bb8798582b9d9cc81810c4392a823d72e8631cb9ef5d7f520c42be748e67ee5cdeabbba5c317b3a93744ecd99d3238e403e423330159d6da387471ed45c8f41b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "4000000000000000000"
      },
      "nonce": "54328315592133534935349332078749185924836726186819750544653085932115010516394",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x00868BB3BA2B36316c2fc42E4aFB6D4246b77E46",
      "requestedAmount": "4000000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x6347b52feaf9f76c35f85fb1d9b9609939f3ca3629747119fd9e5beb3c6690c678475a0ec14867156bb8961db7a3fdc4dcccc910593e6838d4364692d23c1c011b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "600000000000000000"
      },
      "nonce": "111839274192495963390100141526482646054186311810995915850704502714370134444019",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x9e4ef4353c928cd3eb473e8f12aecf58c208ef40",
      "requestedAmount": "600000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0xae938f84889220d856560404e03cbbc4e4dd3489ec9241e98e47013577ff94b7014e9dc2cd5d9f6c250336429418c9b0aa40bbea4adf9f5f43ee0dc77545cf721c",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "147300000000000000000"
      },
      "nonce": "47208889644711080771995965518357055794184157070825533348625187191039990374339",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0x336C033842FA316d470e820c81b742e62A0765DC",
      "requestedAmount": "147300000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x3fa495443aa6d2632dfb2dbd25bbdb422fe394116cc744daebdcffe50448fcc03436949a4e69442064b18da9f7a159a973e0d57c47dfbc4f77e2920d3b5e9c531b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "25400000000000000000"
      },
      "nonce": "39690301517341908438753291538534958637612761322638359270779594793025202747991",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0xCee33C98410DEbe67A319Cb94F39e403435Df319",
      "requestedAmount": "25400000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x1ab776b339d4c01abf150326e2557a10adf5b9af3b21e1360089c3eb0aaa02b638661e7bc38568e50d471529451967e0b4154f02a593f569afb3d9d6e7bbe98a1b",
    "networkId": 100
  },
  {
    "permit": {
      "permitted": {
        "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
        "amount": "3700000000000000000"
      },
      "nonce": "59883678756826680914966617986007591788183591160188902721406886110876884887418",
      "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
    },
    "transferDetails": {
      "to": "0xc4fc63d88dd411b19acf86fb56ba50941611b3a7",
      "requestedAmount": "3700000000000000000"
    },
    "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
    "signature": "0x38e4afc30c6db5deba7bdf27578f7b56733fff3e50d249f1383ce0db072837d60d7f0e35000c6ee265b325521ff760ba94562ad8d85453b625b19fd562aae9f81b",
    "networkId": 100
  }
]
-->

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

ubiquibot bot added Price: 225 USD labels Sep 23, 2023

seprintour mentioned this issue Sep 23, 2023

Debits Table Schema #809

Closed

ubiquibot bot mentioned this issue Sep 23, 2023

Database Re-Architecture ubiquity/devpool-directory#959

Closed

Keyrxng mentioned this issue Sep 23, 2023

chore: debug #815

Closed

ubiquibot bot assigned molecula451 Sep 23, 2023

ubiquibot bot unassigned molecula451 Oct 1, 2023

ubiquibot bot assigned molecula451 Oct 3, 2023

ubiquibot bot unassigned molecula451 Oct 10, 2023

ubiquibot bot assigned molecula451 Oct 10, 2023

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

Refactor/general #644

Merged

ubiquibot bot unassigned molecula451 Oct 18, 2023

0x4007 self-assigned this Oct 19, 2023

ubiquibot bot unassigned 0x4007 Oct 19, 2023

ubiquibot bot assigned molecula451 Oct 22, 2023

molecula451 mentioned this issue Oct 22, 2023

feat: update database architecture #869

Draft

ubiquibot bot unassigned molecula451 Nov 2, 2023

korrrba-bot bot mentioned this issue Nov 6, 2023

Database Re-Architecture korrrba/devpool-directory#31

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

Database Re-Architecture #812

Database Re-Architecture #812

Comments

0x4007 commented Sep 23, 2023 • edited Loading

Tables

Access

Issues

Logs

Multiplier

Penalty

Permits

Users

Wallets

Keyrxng commented Sep 23, 2023

ubiquibot bot commented Sep 23, 2023

molecula451 commented Sep 23, 2023

ubiquibot bot commented Sep 23, 2023

Tips:

ubiquibot bot commented Sep 28, 2023

ubiquibot bot commented Sep 28, 2023

molecula451 commented Oct 3, 2023

ubiquibot bot commented Oct 3, 2023

Tips:

ubiquibot bot commented Oct 7, 2023

ubiquibot bot commented Oct 10, 2023

molecula451 commented Oct 10, 2023

ubiquibot bot commented Oct 10, 2023

Tips:

0xcodercrane commented Oct 11, 2023 • edited Loading

ubiquibot bot commented Oct 15, 2023

ubiquibot bot commented Oct 18, 2023

ubiquibot bot commented Oct 19, 2023

ubiquibot bot commented Oct 19, 2023

molecula451 commented Oct 22, 2023

ubiquibot bot commented Oct 22, 2023

Tips:

rndquu commented Oct 22, 2023

molecula451 commented Oct 22, 2023 • edited Loading

molecula451 commented Oct 23, 2023

0x4007 commented Oct 23, 2023 • edited Loading

molecula451 commented Oct 26, 2023

rndquu commented Oct 26, 2023

molecula451 commented Oct 26, 2023 • edited Loading

ubiquibot bot commented Oct 30, 2023

ubiquibot bot commented Nov 2, 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

# Tables Every table should start with the following column...

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

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

Contributions Overview

Conversation Incentives

@pavlovcik can you confirm us? Also can you confirm this? ...

@pavlovcik look what i have for you https://github.com/ubiqui...

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

> /start I don't think the current issue is relevant/availabl...

> @pavlovcik look what i have for you id.mp4 the 'wa...

@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

Loading

0xcodercrane commented Oct 11, 2023 •

edited

Loading

molecula451 commented Oct 22, 2023 •

edited

Loading

0x4007 commented Oct 23, 2023 •

edited

Loading

molecula451 commented Oct 26, 2023 •

edited

Loading

# Tables

Every table should start with the following column...

Notes to self on incentive calculation architecture:

work bac...

Notes to self on incentive calculation architecture:

work bac...

@pavlovcik can you confirm us?
Also can you confirm this?

...

@pavlovcik look what i have for you

https://github.com/ubiqui...

> /start
I don't think the current issue is relevant/availabl...

> @pavlovcik look what i have for you

id.mp4
the 'wa...

@pavlovcik

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

@pavlovcik
Regarding the `locations` and metadata.

This i...