· 8 years ago · Dec 12, 2017, 07:50 PM
1create database hashdb;
2
3CREATE TABLE IF NOT EXISTS `hashlist` (
4 `ID` int(4) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
5 `cleartext` varchar(60) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The cleartext password',
6 `md2hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The md2 digest',
7 `md4hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The md4 digest',
8 `md5hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The md5 digest',
9 `md5md5hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The md5 in md5 digest',
10 `sha1hash` char(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The sha1 digest',
11 `sha256hash` char(64) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The sha256 digest',
12 `sha384hash` char(96) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The sha384 digest',
13 `sha512hash` char(128) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The sha512 digest',
14 `ripemd128hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Ripemd128 digest',
15 `ripemd160hash` char(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Ripemd160 digest',
16 `ripemd256hash` char(64) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Ripemd256 digest',
17 `ripemd320hash` char(80) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Ripemd320 digest',
18 `whirlpoolhash` char(128) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Whirlpool digest',
19 `tiger1283hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Tiger128,3 digest',
20 `tiger1603hash` char(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Tiger160,3 digest',
21 `tiger1923hash` char(48) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Tiger192,3 digest',
22 `tiger1284hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Tiger128,4 digest',
23 `tiger1604hash` char(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Tiger160,4 digest',
24 `tiger1924hash` char(48) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Tiger192,4 digest',
25 `snefruhash` char(64) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Snefru digest',
26 `gosthash` char(64) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Gost digest',
27 `haval1283hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval128,3 digest',
28 `haval1603hash` char(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval160,3 digest',
29 `haval1923hash` char(48) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval192,3 digest',
30 `haval2243hash` char(56) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval224,3 digest',
31 `haval2563hash` char(64) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval256,3 digest',
32 `haval1284hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval128,4 digest',
33 `haval1604hash` char(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval160,4 digest',
34 `haval1924hash` char(48) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval192,4 digest',
35 `haval2564hash` char(64) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval256,4 digest',
36 `haval1285hash` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval128,5 digest',
37 `haval1605hash` char(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval160,5 digest',
38 `haval1925hash` char(48) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval192,5 digest',
39 `haval2565hash` char(64) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The Haval256,5 digest',
40 `mysqlpwhash` char(41) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The MySQL PASSWORD digest',
41 `mysqloldpwhash` char(16) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The 4.1 MySQL OLD_PASSWORD digest',
42 `freq` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'How frequently is password used',
43 PRIMARY KEY (`id`),
44 UNIQUE `cleartext_idx` (`cleartext`),
45 KEY `md2hash_idx` (md2hash(12)),
46 KEY `md4hash_idx` (md4hash(12)),
47 KEY `md5hash_idx` (md5hash(12)),
48 KEY `md5md5hash_idx` (md5md5hash(12)),
49 KEY `sha1hash_idx` (sha1hash(12)),
50 KEY `sha256hash_idx` (sha256hash(12)),
51 KEY `sha384hash_idx` (sha384hash(12)),
52 KEY `sha512hash_idx` (sha512hash(12)),
53 KEY `ripemd128hash_idx` (ripemd128hash(12)),
54 KEY `ripemd160hash_idx` (ripemd160hash(12)),
55 KEY `ripemd256hash_idx` (ripemd256hash(12)),
56 KEY `ripemd320hash_idx` (ripemd320hash(12)),
57 KEY `whirlpoolhash_idx` (whirlpoolhash(12)),
58 KEY `tiger1283hash_idx` (tiger1283hash(12)),
59 KEY `tiger1603hash_idx` (tiger1603hash(12)),
60 KEY `tiger1923hash_idx` (tiger1923hash(12)),
61 KEY `tiger1284hash_idx` (tiger1284hash(12)),
62 KEY `tiger1604hash_idx` (tiger1604hash(12)),
63 KEY `tiger1924hash_idx` (tiger1924hash(12)),
64 KEY `snefruhash_idx` (snefruhash(12)),
65 KEY `gosthash_idx` (gosthash(12)),
66 KEY `havah1283hash_idx` (haval1283hash(12)),
67 KEY `havah1603hash_idx` (haval1603hash(12)),
68 KEY `havah1923hash_idx` (haval1923hash(12)),
69 KEY `havah2243hash_idx` (haval2243hash(12)),
70 KEY `havah2563hash_idx` (haval2563hash(12)),
71 KEY `havah1284hash_idx` (haval1284hash(12)),
72 KEY `havah1604hash_idx` (haval1604hash(12)),
73 KEY `havah1924hash_idx` (haval1924hash(12)),
74 KEY `havah2564hash_idx` (haval2564hash(12)),
75 KEY `havah1285hash_idx` (haval1285hash(12)),
76 KEY `havah1605hash_idx` (haval1605hash(12)),
77 KEY `havah1925hash_idx` (haval1925hash(12)),
78 KEY `havah2565hash_idx` (haval2565hash(12)),
79 KEY `mysqlpwhash_idx` (mysqlpwhash(13)),
80 KEY `mysqloldpwhash_idx` (mysqloldpwhash(13))
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;