Skip to content

Instantly share code, notes, and snippets.

@lazyatom
Created March 14, 2013 13:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lazyatom/5161278 to your computer and use it in GitHub Desktop.
Save lazyatom/5161278 to your computer and use it in GitHub Desktop.
Ruby Manor 4.0 voting - anonymised
select substring(md5(<first salt> || proposal_id) for 8) as proposal_hash, substring(md5(<second salt> || user_id) for 8) as user_hash from selections;
proposal_hash user_hash
d9b7d3f4 c147bc72
b6222845 c147bc72
86790b1b c147bc72
28756656 c147bc72
09713087 c147bc72
30caca5f c147bc72
028a91c7 c147bc72
86790b1b 73c124e8
47154096 73c124e8
c83f2172 73c124e8
269a7df7 73c124e8
b0ddf47a d7aba6e2
5dbccb6e d7aba6e2
269a7df7 d7aba6e2
7a8a3e70 2b184972
28756656 d7aba6e2
1e5a66b5 e21e9982
09713087 d7aba6e2
c83f2172 e21e9982
269a7df7 e21e9982
c1d2c124 2b184972
df686687 e21e9982
28756656 e21e9982
86790b1b e21e9982
822cff51 e21e9982
029da557 2b184972
d2de16a0 e21e9982
d2de16a0 73c124e8
700106b9 2b184972
93b38596 73c124e8
30caca5f 2b184972
b6222845 2b184972
30caca5f f08a243a
df686687 f08a243a
1e5a66b5 73c124e8
28756656 73c124e8
f137feb2 2b184972
028a91c7 2b184972
028a91c7 f332f841
d9b7d3f4 f332f841
28756656 bd18e1fe
5dbccb6e bd18e1fe
d2de16a0 bd18e1fe
c1d2c124 bd18e1fe
822cff51 bd18e1fe
269a7df7 bd18e1fe
5dbccb6e f332f841
09713087 bd18e1fe
c6f3f384 f332f841
09713087 f332f841
b0ddf47a f332f841
1e95ceab f332f841
269a7df7 f332f841
1e95ceab d0e91072
c6f3f384 d0e91072
c1d2c124 457c49b1
09713087 457c49b1
28756656 457c49b1
028a91c7 457c49b1
93b38596 457c49b1
c6302bd9 457c49b1
d2de16a0 457c49b1
029da557 457c49b1
1e5a66b5 8e8b8e4b
822cff51 8e8b8e4b
d2de16a0 8e8b8e4b
30caca5f 8e8b8e4b
28756656 8e8b8e4b
f3c96c50 8e8b8e4b
62699cd2 8e8b8e4b
7a8a3e70 8e8b8e4b
5dbccb6e 30942fb9
f3c96c50 561c53c2
c6f3f384 30942fb9
86790b1b 30942fb9
b0ddf47a 30942fb9
028a91c7 30942fb9
df686687 561c53c2
269a7df7 561c53c2
dae433fa 561c53c2
09713087 561c53c2
84a5b4ad 30942fb9
c83f2172 561c53c2
86790b1b 561c53c2
28756656 561c53c2
029da557 30942fb9
c4cca131 30942fb9
df686687 87dc6128
5dbccb6e 87dc6128
028a91c7 87dc6128
269a7df7 87dc6128
1570f231 87dc6128
f3c96c50 87dc6128
c1d2c124 87dc6128
84a5b4ad 87dc6128
269a7df7 f08a243a
f3c96c50 f08a243a
28756656 f08a243a
269a7df7 7ab1d631
c1d2c124 7ab1d631
7742c9ed 7ab1d631
f3c96c50 7ab1d631
30caca5f 7ab1d631
df686687 7ab1d631
269a7df7 45806c95
62699cd2 45806c95
09713087 45806c95
c6f3f384 45806c95
c1d2c124 45806c95
b0ddf47a 45806c95
b0ddf47a 63ea0dd8
029da557 63ea0dd8
c6f3f384 63ea0dd8
d9b7d3f4 63ea0dd8
09713087 63ea0dd8
7742c9ed 63ea0dd8
028a91c7 63ea0dd8
c1d2c124 63ea0dd8
7a8a3e70 ba336a0e
86790b1b 02efc338
1e95ceab 02efc338
c1d2c124 ba336a0e
269a7df7 02efc338
c6f3f384 ba336a0e
b0ddf47a 02efc338
822cff51 02efc338
269a7df7 ba336a0e
df686687 02efc338
822cff51 ba336a0e
d2de16a0 ba336a0e
d9b7d3f4 02efc338
30caca5f 02efc338
df686687 ba336a0e
029da557 ba336a0e
08f9ffc4 6d68d2e6
b0ddf47a 6d68d2e6
028a91c7 8eca7ec5
c6f3f384 6d68d2e6
df686687 6d68d2e6
5dbccb6e 6d68d2e6
93b38596 8eca7ec5
f3c96c50 6d68d2e6
c1d2c124 6d68d2e6
62699cd2 6d68d2e6
28756656 8eca7ec5
b0ddf47a 9a61cf60
d737e3dc 3da18083
7a8a3e70 3da18083
62699cd2 3da18083
5dbccb6e 3da18083
c6f3f384 3da18083
47154096 3da18083
28756656 9a61cf60
62699cd2 7fed3666
c1d2c124 9a61cf60
c6f3f384 616dd147
269a7df7 8eca7ec5
86790b1b 8eca7ec5
269a7df7 3a03cbcb
d2de16a0 cfc0188f
269a7df7 616dd147
029da557 cfc0188f
c6302bd9 cfc0188f
f3c96c50 3a03cbcb
86790b1b 616dd147
7742c9ed cfc0188f
08f9ffc4 cfc0188f
dae433fa 404c68e6
1e5a66b5 404c68e6
1570f231 404c68e6
f137feb2 404c68e6
c83f2172 404c68e6
09713087 cfc0188f
822cff51 404c68e6
df686687 404c68e6
28756656 404c68e6
d2de16a0 d7aba6e2
f137feb2 cfc0188f
7a8a3e70 cfc0188f
93b38596 7fed3666
09713087 7fed3666
b0ddf47a 8189db3c
d737e3dc 8189db3c
c1d2c124 8189db3c
6e639202 616dd147
b6222845 8189db3c
269a7df7 8189db3c
d9b7d3f4 616dd147
029da557 8189db3c
28756656 616dd147
30caca5f 616dd147
5dbccb6e 8189db3c
7a8a3e70 8189db3c
28756656 3a03cbcb
28756656 45806c95
df686687 3a03cbcb
7742c9ed 3a03cbcb
30caca5f 3a03cbcb
d2de16a0 c2821c61
f3c96c50 7ba89bce
1e95ceab 7ba89bce
b0ddf47a 7ba89bce
d2de16a0 7ba89bce
d737e3dc 7ba89bce
c83f2172 7ba89bce
269a7df7 7ba89bce
df686687 7ba89bce
dae433fa 11d39698
d737e3dc 11d39698
c6302bd9 11d39698
029da557 11d39698
93b38596 11d39698
822cff51 11d39698
1e5a66b5 11d39698
c1d2c124 11d39698
c6f3f384 2551ce09
028a91c7 522735de
09713087 522735de
b6222845 2551ce09
269a7df7 2551ce09
269a7df7 522735de
7742c9ed 2551ce09
09713087 2551ce09
30caca5f 2551ce09
62699cd2 2551ce09
d737e3dc 2551ce09
b0ddf47a 8a7ef3ea
8d01080d 8a7ef3ea
c1d2c124 8a7ef3ea
028a91c7 8a7ef3ea
62699cd2 8a7ef3ea
09713087 37089987
62699cd2 175be7ef
08f9ffc4 175be7ef
f137feb2 175be7ef
30caca5f 175be7ef
09713087 175be7ef
1570f231 175be7ef
30caca5f 7fed3666
269a7df7 7fed3666
c1d2c124 7fed3666
86790b1b 7fed3666
b0ddf47a bd9b5f3f
f137feb2 bd9b5f3f
028a91c7 bd9b5f3f
28756656 bd9b5f3f
1e95ceab bd9b5f3f
f3c96c50 bd9b5f3f
c6f3f384 bd9b5f3f
6e639202 bd9b5f3f
09713087 a26ef252
62699cd2 a26ef252
028a91c7 f93436f1
5dbccb6e f93436f1
1e95ceab f93436f1
f3c96c50 f93436f1
b6222845 37089987
30caca5f 9f26c4df
28756656 9f26c4df
f137feb2 9f26c4df
dae433fa 9f26c4df
7a8a3e70 9f26c4df
822cff51 9f26c4df
7742c9ed 9f26c4df
09713087 9f26c4df
30caca5f 9ca31cae
d9b7d3f4 9ca31cae
93b38596 f93436f1
c1d2c124 f93436f1
09713087 9ca31cae
c6f3f384 f93436f1
dae433fa f93436f1
7742c9ed 9ca31cae
28756656 bc9175e3
86790b1b bc9175e3
269a7df7 bc9175e3
5dbccb6e bc9175e3
c6f3f384 bc9175e3
30caca5f bc9175e3
1e5a66b5 175be7ef
700106b9 9ca31cae
1e95ceab 9ca31cae
86790b1b 9ca31cae
269a7df7 9ca31cae
7742c9ed 175be7ef
c1d2c124 c147bc72
dae433fa 7c49cd68
f137feb2 7c49cd68
269a7df7 7c49cd68
1e95ceab 7c49cd68
df686687 7c49cd68
028a91c7 7c49cd68
d9b7d3f4 7c49cd68
28756656 7c49cd68
7a8a3e70 1db89b8b
f3c96c50 1db89b8b
d2de16a0 1db89b8b
b0ddf47a 1db89b8b
df686687 1db89b8b
7742c9ed 1db89b8b
28756656 1db89b8b
028a91c7 1db89b8b
62699cd2 37089987
7742c9ed 37089987
f137feb2 37089987
269a7df7 37089987
700106b9 37089987
d9b7d3f4 37089987
dae433fa 7636c1a9
62699cd2 7636c1a9
f3c96c50 7636c1a9
269a7df7 7636c1a9
86790b1b 7636c1a9
700106b9 7636c1a9
30caca5f 7636c1a9
df686687 7636c1a9
700106b9 d7aba6e2
7742c9ed d7aba6e2
f137feb2 236710d9
c6f3f384 236710d9
28756656 236710d9
09713087 236710d9
30caca5f 236710d9
c1d2c124 236710d9
028a91c7 236710d9
8d01080d 236710d9
d737e3dc d0e91072
5dbccb6e d0e91072
269a7df7 d0e91072
86790b1b d0e91072
08f9ffc4 d0e91072
7742c9ed d0e91072
d2de16a0 2941317d
028a91c7 2941317d
86790b1b 2941317d
c6f3f384 2941317d
f3c96c50 2941317d
b0ddf47a 2941317d
09713087 2941317d
30caca5f 2941317d
269a7df7 5d2ac436
c6f3f384 5d2ac436
d2de16a0 471249cf
1e95ceab 471249cf
8d01080d 471249cf
1e5a66b5 471249cf
c6f3f384 471249cf
b0ddf47a 471249cf
5dbccb6e 471249cf
62699cd2 471249cf
df686687 c5481ff2
dae433fa c5481ff2
c6f3f384 c5481ff2
269a7df7 c5481ff2
7742c9ed c5481ff2
09713087 c5481ff2
d9b7d3f4 c5481ff2
09713087 e7515fe6
269a7df7 e7515fe6
822cff51 e7515fe6
df686687 e7515fe6
30caca5f e7515fe6
f3c96c50 e7515fe6
86790b1b e7515fe6
62699cd2 e7515fe6
f137feb2 f1e65c20
dae433fa f1e65c20
269a7df7 f1e65c20
30caca5f f1e65c20
86790b1b f1e65c20
1570f231 f1e65c20
f3c96c50 f1e65c20
7a8a3e70 f1e65c20
c1d2c124 5a73f5ae
b6222845 5a73f5ae
f3c96c50 5a73f5ae
822cff51 5a73f5ae
269a7df7 5a73f5ae
86790b1b 5a73f5ae
30caca5f 5a73f5ae
700106b9 5a73f5ae
c1d2c124 bc9175e3
028a91c7 9c579ff2
c6302bd9 9c579ff2
86790b1b 9c579ff2
029da557 9c579ff2
6e639202 9c579ff2
b0ddf47a 9c579ff2
d737e3dc 9c579ff2
7742c9ed 9c579ff2
f137feb2 c2821c61
269a7df7 c2821c61
df686687 c2821c61
b0ddf47a c2821c61
62699cd2 c2821c61
30caca5f c2821c61
09713087 c2821c61
28756656 2a7520d9
08f9ffc4 2a7520d9
df686687 2a7520d9
1e5a66b5 2a7520d9
f3c96c50 2a7520d9
269a7df7 2a7520d9
30caca5f 2a7520d9
f137feb2 2a7520d9
86790b1b be6896fd
c6f3f384 be6896fd
8d01080d be6896fd
f137feb2 be6896fd
028a91c7 be6896fd
029da557 be6896fd
30caca5f be6896fd
c1d2c124 be6896fd
28756656 5d2ac436
f3c96c50 289d9fd4
62699cd2 289d9fd4
c1d2c124 289d9fd4
30caca5f 289d9fd4
822cff51 289d9fd4
86790b1b 289d9fd4
b0ddf47a 289d9fd4
269a7df7 079a6f90
028a91c7 079a6f90
d9b7d3f4 079a6f90
1570f231 079a6f90
8d01080d 079a6f90
822cff51 079a6f90
f137feb2 079a6f90
7742c9ed 079a6f90
09713087 09f7eb4b
700106b9 09f7eb4b
1e5a66b5 d1a7e4c7
c1d2c124 d1a7e4c7
8d01080d d1a7e4c7
d2de16a0 d1a7e4c7
029da557 d1a7e4c7
1570f231 d1a7e4c7
5dbccb6e d1a7e4c7
62699cd2 d1a7e4c7
b0ddf47a 09f7eb4b
f137feb2 6c1c01ab
822cff51 39e645b0
5dbccb6e 6c1c01ab
df686687 6c1c01ab
1e95ceab 08cd9b68
c1d2c124 08cd9b68
d2de16a0 08cd9b68
28756656 08cd9b68
df686687 08cd9b68
08f9ffc4 08cd9b68
d737e3dc 08cd9b68
86790b1b 08cd9b68
dae433fa 39e645b0
f3c96c50 39e645b0
c6f3f384 39e645b0
1e95ceab 7cf98138
b0ddf47a 7cf98138
1e95ceab ea189842
5dbccb6e 7cf98138
8d01080d 7cf98138
c6302bd9 7cf98138
028a91c7 7cf98138
029da557 7cf98138
d2de16a0 7cf98138
c6f3f384 d5dd2969
b0ddf47a d5dd2969
700106b9 d5dd2969
f3c96c50 d5dd2969
08f9ffc4 af4a1a86
b0ddf47a af4a1a86
dae433fa af4a1a86
1e5a66b5 af4a1a86
269a7df7 d5dd2969
028a91c7 d5dd2969
09713087 d5dd2969
029da557 af4a1a86
f3c96c50 af4a1a86
1e95ceab d5dd2969
62699cd2 9a61cf60
93b38596 ea189842
7742c9ed ea189842
028a91c7 ea189842
822cff51 ea189842
028a91c7 7e36d76b
b6222845 ea189842
28756656 af4a1a86
c6f3f384 ea189842
f3c96c50 ea189842
c1d2c124 4705da10
f3c96c50 4705da10
b6222845 4705da10
269a7df7 4705da10
700106b9 4705da10
30caca5f 4705da10
09713087 4705da10
28756656 b6c34a73
c4cca131 b6c34a73
df686687 4705da10
028a91c7 b6c34a73
09713087 b6c34a73
1e95ceab b6c34a73
c83f2172 b6c34a73
09713087 f08a243a
c1d2c124 b6c34a73
86790b1b f08a243a
f137feb2 b6c34a73
7742c9ed f08a243a
c6302bd9 f38d8335
1e95ceab f38d8335
028a91c7 f38d8335
700106b9 bc9175e3
029da557 f38d8335
1e5a66b5 f38d8335
dae433fa f38d8335
d737e3dc f38d8335
5dbccb6e f38d8335
1e95ceab 980725aa
b6222845 980725aa
86790b1b 980725aa
df686687 980725aa
c1d2c124 5bcee703
f3c96c50 5bcee703
700106b9 5bcee703
269a7df7 5bcee703
c6f3f384 5bcee703
09713087 5bcee703
1e95ceab 5bcee703
dae433fa 5bcee703
1e5a66b5 980725aa
6e639202 980725aa
028a91c7 980725aa
c1d2c124 980725aa
09713087 57a0dd71
df686687 616dd147
28756656 57a0dd71
269a7df7 57a0dd71
62699cd2 57a0dd71
c1d2c124 57a0dd71
93b38596 57a0dd71
c6f3f384 57a0dd71
f137feb2 57a0dd71
c6f3f384 e49c42d7
8d01080d e49c42d7
822cff51 e49c42d7
d2de16a0 e49c42d7
029da557 e49c42d7
7742c9ed e49c42d7
09713087 e49c42d7
df686687 e49c42d7
30caca5f b8be3975
28756656 b8be3975
09713087 b8be3975
f3c96c50 b8be3975
f137feb2 b8be3975
c1d2c124 b8be3975
700106b9 b8be3975
d2de16a0 b8be3975
d9b7d3f4 061a0ce6
30caca5f 061a0ce6
09713087 061a0ce6
28756656 061a0ce6
86790b1b 061a0ce6
269a7df7 061a0ce6
c6f3f384 061a0ce6
62699cd2 061a0ce6
86790b1b 7ab1d631
d2de16a0 7ab1d631
09713087 7ceb3b11
d2de16a0 7ceb3b11
f137feb2 7ceb3b11
269a7df7 7ceb3b11
7742c9ed 7ceb3b11
08f9ffc4 7ceb3b11
1570f231 7ceb3b11
86790b1b 7ceb3b11
8d01080d 39e645b0
d737e3dc 53c9df5f
dae433fa 53c9df5f
c1d2c124 53c9df5f
c6f3f384 53c9df5f
86790b1b 53c9df5f
822cff51 53c9df5f
b0ddf47a 53c9df5f
93b38596 53c9df5f
1e95ceab db14e2d7
28756656 db14e2d7
c6f3f384 db14e2d7
1570f231 40075add
029da557 40075add
1e5a66b5 40075add
28756656 40075add
b0ddf47a 40075add
1e95ceab 40075add
df686687 40075add
d737e3dc 40075add
f3c96c50 0deee0e1
df686687 0deee0e1
f137feb2 0deee0e1
28756656 0deee0e1
dae433fa a3922839
1e5a66b5 a3922839
b6222845 a3922839
8d01080d 7fffbaab
df686687 7fffbaab
269a7df7 7fffbaab
700106b9 7fffbaab
c6302bd9 db14e2d7
8d01080d db14e2d7
c4cca131 db14e2d7
c6f3f384 78c5a897
1e95ceab 78c5a897
93b38596 09f7eb4b
8d01080d 09f7eb4b
c1d2c124 09f7eb4b
1e5a66b5 09f7eb4b
7a8a3e70 09f7eb4b
f3c96c50 7fffbaab
d9b7d3f4 4631b551
b0ddf47a 7fffbaab
028a91c7 7fffbaab
b0ddf47a 4631b551
86790b1b 4631b551
c6f3f384 4631b551
09713087 7fffbaab
b0ddf47a 39e645b0
09713087 39e645b0
28756656 39e645b0
62699cd2 4631b551
08f9ffc4 4631b551
1e95ceab 4631b551
c1d2c124 4631b551
30caca5f 05787e09
09713087 05787e09
1570f231 05787e09
f137feb2 05787e09
28756656 05787e09
86790b1b 05787e09
7742c9ed 05787e09
f3c96c50 05787e09
09713087 9a61cf60
8d01080d e9f397f1
df686687 e9f397f1
7a8a3e70 e9f397f1
5dbccb6e e9f397f1
08f9ffc4 e9f397f1
c1d2c124 e9f397f1
b0ddf47a e9f397f1
28756656 e9f397f1
b0ddf47a a43f1003
28756656 a43f1003
86790b1b a43f1003
028a91c7 4452fae3
269a7df7 4452fae3
c83f2172 4452fae3
1e5a66b5 02263ee9
f3c96c50 02263ee9
47154096 02263ee9
8d01080d 02263ee9
822cff51 02263ee9
d2de16a0 02263ee9
b0ddf47a 02263ee9
09713087 02263ee9
028a91c7 0deee0e1
269a7df7 0deee0e1
7742c9ed 0deee0e1
09713087 0deee0e1
86790b1b a26ef252
28756656 a26ef252
1e5a66b5 74b53cb1
f137feb2 74b53cb1
86790b1b 74b53cb1
c6f3f384 74b53cb1
1e95ceab 74b53cb1
c6302bd9 74b53cb1
28756656 74b53cb1
f3c96c50 74b53cb1
269a7df7 98a7bca2
c1d2c124 98a7bca2
dae433fa 98a7bca2
b0ddf47a 98a7bca2
28756656 98a7bca2
df686687 98a7bca2
822cff51 98a7bca2
30caca5f 98a7bca2
1570f231 a3922839
08f9ffc4 be3acf24
30caca5f be3acf24
d9b7d3f4 a3922839
028a91c7 be3acf24
df686687 be3acf24
c1d2c124 be3acf24
700106b9 a3922839
dae433fa be3acf24
f3c96c50 be3acf24
c1d2c124 a97069c6
f137feb2 a97069c6
c6f3f384 a97069c6
8d01080d a97069c6
d2de16a0 a97069c6
1e95ceab a97069c6
df686687 a97069c6
7742c9ed a97069c6
09713087 be3acf24
f3c96c50 7dd760d7
47154096 7dd760d7
c1d2c124 7dd760d7
700106b9 7dd760d7
5dbccb6e 7dd760d7
7742c9ed 7dd760d7
c6f3f384 7dd760d7
1570f231 7dd760d7
c83f2172 a3922839
269a7df7 a3922839
d9b7d3f4 032fb1f1
28756656 032fb1f1
62699cd2 032fb1f1
8d01080d 032fb1f1
f3c96c50 032fb1f1
7742c9ed 032fb1f1
09713087 032fb1f1
1570f231 6eb492b0
f3c96c50 6eb492b0
c83f2172 6eb492b0
d2de16a0 6eb492b0
d9b7d3f4 6eb492b0
dae433fa 6eb492b0
93b38596 6eb492b0
30caca5f 6eb492b0
7a8a3e70 c838fb49
62699cd2 c838fb49
8d01080d c838fb49
269a7df7 c838fb49
028a91c7 c838fb49
f3c96c50 c838fb49
09713087 af4a1a86
93b38596 c838fb49
c1d2c124 c838fb49
86790b1b 6bbe7cfc
5dbccb6e 6bbe7cfc
700106b9 6bbe7cfc
93b38596 6bbe7cfc
269a7df7 6bbe7cfc
09713087 82c04ade
7742c9ed 82c04ade
d2de16a0 82c04ade
c1d2c124 82c04ade
86790b1b 82c04ade
c6f3f384 82c04ade
dae433fa 82c04ade
62699cd2 82c04ade
f137feb2 81f90cc4
c6302bd9 81f90cc4
7742c9ed 81f90cc4
09713087 81f90cc4
08f9ffc4 81f90cc4
6e639202 81f90cc4
700106b9 81f90cc4
d9b7d3f4 81f90cc4
d2de16a0 6bbe7cfc
029da557 6bbe7cfc
c1d2c124 6bbe7cfc
1e95ceab 51eb04a9
f137feb2 9a61cf60
30caca5f 9a61cf60
269a7df7 9a61cf60
df686687 a43f1003
1e5a66b5 a43f1003
f3c96c50 a43f1003
1e95ceab a43f1003
269a7df7 a43f1003
029da557 5ba512cc
c6f3f384 5ba512cc
c1d2c124 5ba512cc
f137feb2 5ba512cc
652fc72d 07795a77
1570f231 07795a77
d2de16a0 07795a77
822cff51 5ba512cc
c6f3f384 07795a77
029da557 07795a77
30caca5f 5ba512cc
1e95ceab 5ba512cc
b0ddf47a 07795a77
f3c96c50 07795a77
8d01080d 07795a77
47154096 5ba512cc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment