Ravan/MySQL_Structure.txt at master · Lavakumar/Ravan · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
--

-- Database: `ravanroot`

--

CREATE DATABASE `ravanroot` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

USE `ravanroot`;


-- --------------------------------------------------------


--

-- Table structure for table `slots_done`

--


CREATE TABLE `slots_done` (

  `hash_id` int(11) NOT NULL,

  `worker_id` text NOT NULL,

  `slot` int(11) NOT NULL,

  `cracked` tinyint(1) NOT NULL,

  `clear` text NOT NULL,

  `is_read` tinyint(1) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--

-- Table structure for table `slots_todo`

--


CREATE TABLE `slots_todo` (

  `id` int(11) NOT NULL auto_increment,

  `hash_id` int(11) NOT NULL,

  `worker_id` text NOT NULL,

  `slots` text NOT NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--

-- Table structure for table `submit_hashes`

--


CREATE TABLE `submit_hashes` (

  `hash` text NOT NULL,

  `salt` text NOT NULL,

  `hash_id` int(11) NOT NULL auto_increment,

  `password` text NOT NULL,

  `clear` text NOT NULL,

  `algo` int(11) NOT NULL,

  `salt_location` int(11) NOT NULL,

  `keyspace` text NOT NULL,

  `timestamp` bigint(20) NOT NULL,

  PRIMARY KEY  (`hash_id`),

  UNIQUE KEY `hash_id` (`hash_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------