Created
November 16, 2018 14:46
-
-
Save dckc/3f0b6eaeb7b23bf05b9329adad4dde32 to your computer and use it in GitHub Desktop.
Review of Oct (201810) Rewards by TAC and Guides #1011
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
insert into reward_fixed | |
(select * from reward where pay_period = '2018-10-01' and reward_usd > 0); | |
-- 24 rows processed | |
select count(*), count(distinct worker), count(distinct issue_num), sum(reward_usd) | |
from reward_fixed where pay_period = '2018-10-01'; | |
insert into pay_period values ('2018-11-01', '2018-11-30', 1, null); | |
commit; | |
update admin_settings set current_pay_period = '2018-11-01'; | |
commit; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
issue_num | title | worker | reward_usd | percent_avg | budget_usd | voter_qty | voters | reward_provisional | budget_provisional | pay_period | labels | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
831 | Add RChain to the Digital Life Collective Decentralized System Network Map | owans | 250 | 50 | 500 | 3 | pmoorman, owans, TrenchFloat | 250 | 500 | 10/01/18 | ["colab","needs-SMART-objective","zz-Marketing"] | |
831 | Add RChain to the Digital Life Collective Decentralized System Network Map | TrenchFloat | 250 | 50 | 500 | 3 | pmoorman, owans, TrenchFloat | 250 | 500 | 10/01/18 | ["colab","needs-SMART-objective","zz-Marketing"] | |
919 | Provide Feedback on Rholang Tutorial | Barkov-F | 129 | 50 | 258.82 | 3 | JoshOrndorff, pmoorman, TrenchFloat | 129 | 258.82 | 10/01/18 | ["Help Wanted","developer-education"] | |
919 | Provide Feedback on Rholang Tutorial | TrenchFloat | 129 | 50 | 258.82 | 3 | JoshOrndorff, pmoorman, TrenchFloat | 129 | 258.82 | 10/01/18 | ["Help Wanted","developer-education"] | |
986 | Genesis Protocol Guide to creating an RChain network | David405 | 510 | 56.67 | 900 | 3 | David405, TrenchFloat, Valentine-Mario | 510 | 900 | 10/01/18 | ["developer-education"] | |
986 | Genesis Protocol Guide to creating an RChain network | TrenchFloat | 180 | 20 | 900 | 2 | David405, TrenchFloat | 180 | 900 | 10/01/18 | ["developer-education"] | |
986 | Genesis Protocol Guide to creating an RChain network | Valentine-Mario | 225 | 25 | 900 | 2 | David405, Valentine-Mario | 225 | 900 | 10/01/18 | ["developer-education"] | |
994 | Walkthrough video of the nthCaller game | David405 | 765 | 45 | 1700 | 2 | sypha999, Valentine-Mario | 765 | 1700 | 10/01/18 | ["developer-education"] | |
994 | Walkthrough video of the nthCaller game | Ojimadu | 85 | 5 | 1700 | 2 | sypha999, Valentine-Mario | 85 | 1700 | 10/01/18 | ["developer-education"] | |
994 | Walkthrough video of the nthCaller game | sypha999 | 595 | 35 | 1700 | 2 | sypha999, Valentine-Mario | 595 | 1700 | 10/01/18 | ["developer-education"] | |
994 | Walkthrough video of the nthCaller game | Valentine-Mario | 255 | 15 | 1700 | 2 | sypha999, Valentine-Mario | 255 | 1700 | 10/01/18 | ["developer-education"] | |
996 | Rock Paper Scissors Example dApp in Python | David405 | 210 | 70 | 300 | 3 | David405, sypha999, Valentine-Mario | 210 | 300 | 10/01/18 | ["developer-education"] | |
996 | Rock Paper Scissors Example dApp in Python | Valentine-Mario | 90 | 30 | 300 | 3 | David405, sypha999, Valentine-Mario | 90 | 300 | 10/01/18 | ["developer-education"] | |
997 | RChain Blog Article - HOW TO: RHOC Wallet Setup and Instructional Step-by-Step First Time Use | owans | 200 | 100 | 200 | 2 | kitblake, owans | 200 | 200 | 10/01/18 | [] | |
1000 | RChain platform core dev work for Oct | glenbraun | 1218 | 28 | 4350 | 2 | dckc, zsluedem | 1218 | 4350 | 10/01/18 | ["core-dev"] | |
1000 | RChain platform core dev work for Oct | xiphiness | 1218 | 28 | 4350 | 3 | dckc, zsluedem, xiphiness | 1218 | 4350 | 10/01/18 | ["core-dev"] | |
1000 | RChain platform core dev work for Oct | zsluedem | 2001 | 46 | 4350 | 3 | dckc, zsluedem, xiphiness | 2001 | 4350 | 10/01/18 | ["core-dev"] | |
1004 | Create Library of RChain | pmoorman | 280 | 70 | 400 | 2 | pmoorman, TrenchFloat | 280 | 400 | 10/01/18 | ["Discussion","developer-education"] | |
1004 | Create Library of RChain | TrenchFloat | 120 | 30 | 400 | 2 | pmoorman, TrenchFloat | 120 | 400 | 10/01/18 | ["Discussion","developer-education"] | |
1008 | Rholang Office Hours | David405 | 275 | 55 | 500 | 2 | David405, Valentine-Mario | 275 | 500 | 10/01/18 | ["colab","developer-education"] | |
1008 | Rholang Office Hours | Valentine-Mario | 175 | 35 | 500 | 2 | David405, Valentine-Mario | 175 | 500 | 10/01/18 | ["colab","developer-education"] | |
1010 | Co-op Board Resolutions Transparency Report | kirkwood | 16 | 20 | 80 | 3 | kitblake, pmoorman, TrenchFloat | 16 | 80 | 10/01/18 | [] | |
1010 | Co-op Board Resolutions Transparency Report | TrenchFloat | 64 | 80 | 80 | 3 | kitblake, pmoorman, TrenchFloat | 64 | 80 | 10/01/18 | [] | |
1014 | RChain Blog Article: CoLab October Summary | owans | 200 | 100 | 200 | 2 | kitblake, owans | 200 | 200 | 10/01/18 | ["colab"] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
count(*) | count(distinct worker) | count(distinct issue_num) | sum(reward_usd) | |
---|---|---|---|---|
24 | 12 | 11 | 9440 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment