g9yHSnw8

1CREATE TABLE IF NOT EXISTS `pool_worker` (
2  `id` int(255) NOT NULL AUTO_INCREMENT,
3  `associatedUserID` int(255) NOT NULL,
4  `username` varchar(50) DEFAULT NULL,
5  `password` varchar(255) DEFAULT NULL,
6  `allowed_hosts` text,
7  PRIMARY KEY (`id`),
8  KEY `INDEX_username` (`username`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1;
10
11CREATE TABLE IF NOT EXISTS `shares` (
12  `id` bigint(30) NOT NULL AUTO_INCREMENT,
13  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14  `rem_host` varchar(255) NOT NULL,
15  `username` varchar(120) NOT NULL,
16  `our_result` tinyint(1) DEFAULT NULL,
17  `our_result_bitcoin` tinyint(1) DEFAULT NULL,
18  `our_result_namecoin` tinyint(1) DEFAULT NULL,
19  `upstream_result` tinyint(1) DEFAULT NULL,
20  `reason` varchar(50) DEFAULT NULL,
21  `source` varchar(255) DEFAULT NULL,
22  `solution` varchar(257) DEFAULT NULL,
23  `block_num` varchar(45) DEFAULT NULL,
24  `prev_block_hash` varchar(65) DEFAULT NULL,
25  `useragent` varchar(128) DEFAULT NULL,
26  PRIMARY KEY (`id`),
27  KEY `INDEX_username` (`username`)
28) ENGINE=MyISAM DEFAULT CHARSET=latin1;