Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create database tables to store miner and stat information. #14

Open
dialmaster opened this issue Feb 12, 2022 · 0 comments
Open

Create database tables to store miner and stat information. #14

dialmaster opened this issue Feb 12, 2022 · 0 comments

Comments

@dialmaster
Copy link
Owner

dialmaster commented Feb 12, 2022

DMO Monitor needs a table to store miner configuration information.

My initial thought is we should have a table structure as follows, but this is a ROUGH DRAFT and will initially only support solo mining options. Pool changes to be added later.

table miners
id int not null auto_increment primary key,
user_id int
miner_ident_string varchar(64), (see #13)
display_name varchar(64),
miner_config_id int

// NOTE I think we might have some default configs that any user could utilize
// In that case user_id would be null

// If solo is true then pool_id would be left as null...
// If solo is false fullnode_id would be null as would starting_diff
table miner_configs
id int not null auto increment primary key,
user_id int
solo bool
pool_id int
miner_opts varchar(128) (eg "GPU,179200,32,0,0")
fullnode_id int
starting_diff int
receiving_address_id int

table fullnode_configs
id int not null auto increment primary key,
user_id int
node_url varchar(64)
node_user varchar(64)
node_pass varchar(64)

table pool_configs
id int not null auto increment primary key,
user_id int
pool_user varchar(64)
mode varchar(32)
server varchar(32)
port varchar(6)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant