N9u4F5cp

1server.json::
2
3
4 "sharelog" : true,
5 "stmt.sharelog" :
6 "INSERT INTO shares (ctime, rem_host, username, our_result, upstream_result, reason, solution) VALUES (UNIX_TIMESTAMP(),?,?,?,?,?,?)",
7
8 "stmt.pwdb" :
9 "SELECT password FROM pool_worker WHERE username = ?"
10
11
12SQL:
13
14--
15-- Table structure for table `pool_worker`
16--
17
18CREATE TABLE IF NOT EXISTS `pool_worker` (
19  `id` int(11) NOT NULL AUTO_INCREMENT,
20  `username` varchar(128) NOT NULL,
21  `password` varchar(128) NOT NULL,
22  PRIMARY KEY (`id`)
23) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
24
25--
26-- Dumping data for table `pool_worker`
27--
28
29INSERT INTO `pool_worker` (`id`, `username`, `password`) VALUES
30(1, 'test', 'test'),
31(4, 'public', 'testing');
32
33
34-- --------------------------------------------------------
35
36--
37-- Table structure for table `shares`
38--
39
40CREATE TABLE IF NOT EXISTS `shares` (
41  `id` int(11) NOT NULL AUTO_INCREMENT,
42  `ctime` decimal(11,0) NOT NULL,
43  `rem_host` text NOT NULL,
44  `username` text NOT NULL,
45  `our_result` text,
46  `upstream_result` text,
47  `reason` text,
48  `solution` text,
49  PRIMARY KEY (`id`)
50) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1473 ;
51
52--
53-- Dumping data for table `shares`
54--