EligiusEligius mining pool | About | Help | FAQ | Special pages | Log in

Printable version | Disclaimers | Privacy policy

PostgreSQL Schema

From Eligius

(TODO: explain stuff)

Table users

CREATE TABLE users (

 id serial NOT NULL,
 username character varying(128) NOT NULL,
 keyhash bit(160),
 workername character varying(64),

);

Table hosts

CREATE TABLE hosts (

 id serial NOT NULL,
 user_id integer,
 host character varying(128) NOT NULL,

);

Table shares

CREATE TABLE shares (

 server smallint NOT NULL,
 id bigint NOT NULL,
 "time" timestamp without time zone NOT NULL,
 rem_host_id integer NOT NULL,
 user_id integer NOT NULL,
 our_result boolean NOT NULL,
 upstream_result boolean,
 reason character varying(32),
 solution bytea NOT NULL,
 targetmask smallint,

);

Retrieved from "http://eligius.st/wiki/index.php/PostgreSQL_Schema"

This page was last modified on 7 July 2011, at 21:31.


Find

Browse
Main page
Community portal
Current events
Recent changes
Help
Edit
View source
Editing help
This page
Discuss this page
New section
Printable version
Context
Page history
What links here
Related changes
My pages
Wiki Log in
Special pages
New pages
File list
Statistics
Moreā€¦