<center>http://i.cubeupload.com/jRKIMn.png</center> With the last hardfork 20, several changes have been made to the blockchain data. SteemSQL has supported these changes as soon as the harfork was activated. Here is the detailed information about the changes that have been applied to the SteemSQL database. ### New tables Two new table have been added to support the new operations: ##### TxAccountsClaims This table contains the “requests” from users or dApps to create new accounts. These operations are issued **before** the actual creation of the account on the blockchain. Although at the blockchain level the operation of creating a claimed account is of different type (_create_claimed_account_) from the previous account creation operations (_account_create_ and _account_create_with_delegation_), SteemSQL stores them all in a single table: `TxAccountCreates`. ##### TxWitnessSetProperties This table contains the operations published by the witnesses to adapt the dynamic parameters of the blockchain. ### Modified tables ##### Table Accounts - new fields Several new fields have been added to this table: * _voting_manabar_current_mana_ * _voting_manabar_last_update_time_ * _reward_sbd_balance_ * _reward_steem_balance_ * _reward_vesting_balance_ * _reward_vesting_steem_ * _last_vote_time_ * _post_bandwidth_ * _pending_claimed_accounts_ ##### Table TxAccountsCreate - new fields Two new fields have been added to this table to support the new _create_claimed_account_ operation: * _fee_ * _extensions_ ##### TVOCommentBenefactorRewards The single `reward` fields has been deleted and replaced with 3 new ones * _sbd_payout_ * _steem_payout_ * _vesting_payout_ The values previously stored in the `reward` field have been transferred to `vesting_payout` ### New database diagram Here an updated diagram of the database: ![](https://cdn.steemitimages.com/DQmcfVJEdu64DNKbNUYexzc6QEnQBTaoKx5TDLrn9RzLcwR/Diagram.jpg) Visit [SteemSQL website](https://steemsql.com) for more information. ### Roadmap * Many of you have asked us to be able to access the parameter of the blockchain directly from SteemSQL to be able to directly perform certain operations in their queries (convert the VESTS to STEEM POWER for example). This will be done in the coming days. * Revamping of the tables structure to reclaim storage space and improve performances is planned. * I plan to improve the documentation of SteemSQL and provide more tutorial on how to write efficient queries. This will done after SteemFest³. Thanks for reading! --- <center>![](https://cdn.steemitimages.com/DQmSwK83yagygSK63SVVQzKA9jdsFmJnXyx3CoqwaYjo6bE/meetme-sf3-s.png)</center> ### <center>Do you like my work to support the community. [Vote for my witness](https://steemit.com/~witnesses)</center>
author | arcange |
---|---|
permlink | steemsql-hf20-update |
category | steemsql |
json_metadata | {"tags":["steemsql","steemit","database","sql","programming"],"image":["http://i.cubeupload.com/jRKIMn.png","https://cdn.steemitimages.com/DQmcfVJEdu64DNKbNUYexzc6QEnQBTaoKx5TDLrn9RzLcwR/Diagram.jpg","https://cdn.steemitimages.com/DQmSwK83yagygSK63SVVQzKA9jdsFmJnXyx3CoqwaYjo6bE/meetme-sf3-s.png"],"links":["https://steemsql.com","https://steemit.com/~witnesses"],"app":"steemit/0.1","format":"markdown"} |
created | 2018-10-11 16:09:15 |
last_update | 2018-10-11 16:09:15 |
depth | 0 |
children | 4 |
last_payout | 2018-10-18 16:09:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 8.352 HBD |
curator_payout_value | 2.440 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 2,802 |
author_reputation | 1,065,066,100,905,268 |
root_title | "SteemSQL - HF20 update" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 73,085,911 |
net_rshares | 7,928,004,304,606 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
teamsteem | 0 | 6,364,363,336,715 | 100% | ||
writewords | 0 | 923,126,134 | 14% | ||
kenny-crane | 0 | 96,111,804,694 | 25% | ||
g-dubs | 0 | 3,182,557,483 | 2% | ||
raphaelle | 0 | 52,129,293,355 | 100% | ||
ace108 | 0 | 170,693,717,503 | 13% | ||
remlaps | 0 | 6,196,677,073 | 25% | ||
sc-steemit | 0 | 27,426,837,232 | 15% | ||
nadin3 | 0 | 32,069,315,219 | 100% | ||
bosjaya | 0 | 21,249,939 | 5% | ||
jenkinrocket | 0 | 34,414,181,122 | 40% | ||
loreennaa | 0 | 2,947,352,684 | 20% | ||
gokulnk | 0 | 18,595,167,521 | 100% | ||
paulag | 0 | 142,954,076,197 | 100% | ||
dwarrilow2002 | 0 | 35,135,084,491 | 50% | ||
eturnerx | 0 | 403,624,290,856 | 100% | ||
jacekw | 0 | 66,603,212,935 | 100% | ||
mister-futurist | 0 | 720,074,440 | 100% | ||
rizkirz | 0 | 219,692,472 | 50% | ||
crokkon | 0 | 92,165,679,483 | 100% | ||
vlemon | 0 | 12,296,231,495 | 13% | ||
repu-tacion | 0 | 371,076,965 | 20% | ||
gregan | 0 | 2,512,352,639 | 20% | ||
keviginge | 0 | 764,589,416 | 100% | ||
muhammadrizki96 | 0 | 2,284,672,149 | 100% | ||
intansuryani | 0 | 150,376,089 | 100% | ||
idikuci | 0 | 39,510,959,840 | 100% | ||
kryptokenny | 0 | 3,996,340,954 | 100% | ||
zahratulmulia | 0 | 219,210,669 | 50% | ||
tychoxi | 0 | 1,347,708,792 | 100% | ||
holger80 | 0 | 51,856,360,740 | 30% | ||
spikezoid | 0 | 512,692,395 | 100% | ||
albipratama | 0 | 223,546,922 | 50% | ||
andimywapblog12 | 0 | 976,163,190 | 100% | ||
kulin12 | 0 | 189,228,403 | 50% | ||
bryanadam21 | 0 | 279,477,816 | 100% | ||
catataniranda | 0 | 1,795,413,600 | 100% | ||
muhammadmd | 0 | 164,559,616 | 50% | ||
myusuf01 | 0 | 200,140,245 | 50% | ||
andimywapblog14 | 0 | 189,820,051 | 100% | ||
xxxpron | 0 | 290,829,830 | 100% | ||
rismawar | 0 | 179,405,789 | 50% | ||
bittrex12 | 0 | 233,009,083 | 100% | ||
bryanwilliam | 0 | 337,583,207 | 100% | ||
arsyilasani | 0 | 223,972,046 | 50% | ||
dchadney | 0 | 178,380,185 | 100% | ||
lisnizar | 0 | 218,142,298 | 50% | ||
dhitalajay | 0 | 89,548,231 | 23% | ||
intansafrina | 0 | 179,114,254 | 50% | ||
grwd | 0 | 2,011,439,642 | 100% | ||
marcovugts | 0 | 2,075,332,769 | 100% | ||
pitabas89 | 0 | 556,593,110 | 100% | ||
steemhost01 | 0 | 1,194,937,275 | 50% | ||
safratyusuf | 0 | 415,373,536 | 100% | ||
steem.talk | 0 | 221,993,029 | 100% | ||
mahfuz42 | 0 | 232,574,468 | 100% | ||
fux | 0 | 814,746,676 | 100% | ||
steemerjp | 0 | 418,047,432 | 100% | ||
steem-ua | 0 | 246,817,301,599 | 1.84% | ||
dewarrilow | 0 | 690,515,419 | 100% | ||
jefferson45 | 0 | 287,815,194 | 100% |
Ich schätze, eure Arbeit und die Mühe, die ihr euch macht sehr. 👍😊 Danke!
author | natha93 |
---|---|
permlink | re-arcange-steemsql-hf20-update-20181011t161540383z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"community":"steempeak","app":"steempeak"} |
created | 2018-10-11 16:15:42 |
last_update | 2018-10-11 16:15:42 |
depth | 1 |
children | 0 |
last_payout | 2018-10-18 16:15:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 74 |
author_reputation | 6,178,768,594,802 |
root_title | "SteemSQL - HF20 update" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 73,086,359 |
net_rshares | 11,346,471,414 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
igel2017 | 0 | 11,346,471,414 | 100% |
awesome
author | paulag |
---|---|
permlink | re-arcange-steemsql-hf20-update-20181011t232142543z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2018-10-11 23:21:42 |
last_update | 2018-10-11 23:21:42 |
depth | 1 |
children | 0 |
last_payout | 2018-10-18 23:21:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 7 |
author_reputation | 274,264,287,951,003 |
root_title | "SteemSQL - HF20 update" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 73,106,822 |
net_rshares | 0 |
#### Hi @arcange! Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation! Your **UA** account score is currently 7.759 which ranks you at **#42** across all Steem accounts. Your rank has not changed in the last three days. In our last Algorithmic Curation Round, consisting of 391 contributions, your post is ranked at **#23**. ##### Evaluation of your UA score: * Your follower network is great! * The readers appreciate your great work! * Good user engagement! **Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**
author | steem-ua |
---|---|
permlink | re-steemsql-hf20-update-20181016t154412z |
category | steemsql |
json_metadata | "{"app": "beem/0.20.7"}" |
created | 2018-10-16 15:44:12 |
last_update | 2018-10-16 15:44:12 |
depth | 1 |
children | 0 |
last_payout | 2018-10-23 15:44:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 595 |
author_reputation | 23,214,230,978,060 |
root_title | "SteemSQL - HF20 update" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 73,420,722 |
net_rshares | 0 |
Thank you for the updates. Take care @arcange Posted using [Partiko iOS](https://steemit.com/@partiko-ios)
author | vlemon |
---|---|
permlink | vlemon-re-arcange-steemsql-hf20-update-20181012t085937107z |
category | steemsql |
json_metadata | {"app":"partiko"} |
created | 2018-10-12 08:59:36 |
last_update | 2018-10-12 08:59:36 |
depth | 1 |
children | 0 |
last_payout | 2018-10-19 08:59:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 108 |
author_reputation | 820,959,422,800,927 |
root_title | "SteemSQL - HF20 update" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 73,133,234 |
net_rshares | 0 |