"I want to download and audit the Scorebot from DEF CON 21 CTF."
### ####### ##### ### ####### ### ###### ## ####### #######
### ####### ###### ### ####### ### ####### ## ####### #######
### ### ### ### ## ## ##
### ####### ## ### ### ### ### ## # ## ## ## ### #######
### ### ### # ### ### ### ## # ## ## ## ### ###
####### ####### ###### ### ###### ### ## # ## ## ## ###### #######
####### ####### #### ### ##### ### ## # ## ####### ##### #######
###### ## ## #### ### ###### ####### #### ####
### ## ## ### ### ####### ####### ### ###
### ## ## ### ### ## ### ### ###
###### ## ## ### ### ## ## ####### ### ###
### ### ## ### ### ## ## ### ### ###
### ####### ####### ### ## ## ####### ####### #######
###### ###### ###### ### ## ## ####### ###### ######
#### ## ## ###### ##### ### ##### ## ####### #######
### ### ### ####### ###### ### ###### ## ####### #######
### ####### ## ### ### ### ### ##
### ##### ## ## ## ## ### ## ## ## ### #######
### ## ## ## ### ### ### ## ## ### ###
####### ### ## ## ###### ### ###### ## ## ###### #######
###### ### ## ## ##### ### ##### ####### ##### #######
▒█▀▀█ ▒█▀▀█ ▒█▀▀▀ ▒█▀▀▀█ ▒█▀▀▀ ▒█▄░▒█ ▀▀█▀▀ ▒█▀▀▀█ ▄
▒█▄▄█ ▒█▄▄▀ ▒█▀▀▀ ░▀▀▀▄▄ ▒█▀▀▀ ▒█▒█▒█ ░▒█░░ ░▀▀▀▄▄ ░
▒█░░░ ▒█░▒█ ▒█▄▄▄ ▒█▄▄▄█ ▒█▄▄▄ ▒█░░▀█ ░▒█░░ ▒█▄▄▄█ ▀
╭━━━┳━━━┳━━━╮╭━━━┳━━━┳━╮╱╭╮╭━━━╮╭╮
╰╮╭╮┃╭━━┫╭━━╯┃╭━╮┃╭━╮┃┃╰╮┃┃┃╭━╮┣╯┃
╱┃┃┃┃╰━━┫╰━━╮┃┃╱╰┫┃╱┃┃╭╮╰╯┃╰╯╭╯┣╮┃
╱┃┃┃┃╭━━┫╭━━╯┃┃╱╭┫┃╱┃┃┃╰╮┃┃╭━╯╭╯┃┃
╭╯╰╯┃╰━━┫┃╱╱╱┃╰━╯┃╰━╯┃┃╱┃┃┃┃┃╰━┳╯╰╮
╰━━━┻━━━┻╯╱╱╱╰━━━┻━━━┻╯╱╰━╯╰━━━┻━━╯
╭━━━┳━━━┳━━━┳━━━━┳╮╱╭┳━━━┳━━━╮
┃╭━╮┃╭━╮┃╭━╮┃╭╮╭╮┃┃╱┃┃╭━╮┃╭━━╯
┃┃╱╰┫┃╱┃┃╰━╯┣╯┃┃╰┫┃╱┃┃╰━╯┃╰━━╮
┃┃╱╭┫╰━╯┃╭━━╯╱┃┃╱┃┃╱┃┃╭╮╭┫╭━━╯
┃╰━╯┃╭━╮┃┃╱╱╱╱┃┃╱┃╰━╯┃┃┃╰┫╰━━╮
╰━━━┻╯╱╰┻╯╱╱╱╱╰╯╱╰━━━┻╯╰━┻━━━╯
╭━━━━┳╮╱╭┳━━━╮╭━━━┳╮╱╱╭━━━┳━━━╮
┃╭╮╭╮┃┃╱┃┃╭━━╯┃╭━━┫┃╱╱┃╭━╮┃╭━╮┃
╰╯┃┃╰┫╰━╯┃╰━━╮┃╰━━┫┃╱╱┃┃╱┃┃┃╱╰╯
╱╱┃┃╱┃╭━╮┃╭━━╯┃╭━━┫┃╱╭┫╰━╯┃┃╭━╮
╱╱┃┃╱┃┃╱┃┃╰━━╮┃┃╱╱┃╰━╯┃╭━╮┃╰┻━┃
╱╱╰╯╱╰╯╱╰┻━━━╯╰╯╱╱╰━━━┻╯╱╰┻━━━╯
## ### # ### ## ## ## # ###
## # # ### # #### ## ## ## ## ## ##
## ## ## ## ## ## ## ## ###### ## ##
#### ## ## ## ## ## ## ## #### # ## ##
## ## # # ### ## ## ## ## ## # ## #####
### ## ### # ### ## ## ### ## ## ## ##
##### ### # ####### ###### ##### ## ## ##
FOR POSTGRES 9.2-COMPATIBLE DATABASES
Installation instructions for Postgres 9.2:
> createdb scorebot_production
> psql scorebot_production < scorebot_production.1376266721.sql
> psql scorebot_production
scorebot_production=# select id, name from teams order by name asc;
id | name
----+-------------------------------
13 | 9447
18 | APT8
19 | Alternatives
21 | Legitimate Business Syndicate
2 | PPP
20 | Robot Mafia
1 | Samurai
6 | The European Nopsled Team
12 | WOWHacker-BI0S
3 | [Technopandas]
8 | blue lotus
15 | clgt
14 | men in black hats
7 | more smoked leet chicken
5 | pwnies
17 | pwningyeti
4 | raon_ASRT
9 | routards
10 | shell corp
11 | shellphish
16 | sutegoma2
(21 rows)
An Entity Relationship Diagram is made available for your perusal.
THIS SQL DUMP IS PROVIDED UNDER THE CREATIVE COMMONS CC0 LICENSE
To the extent possible under law, Legitimate Business Syndicate has waived all copyright and related or neighboring rights to the DEF CON 21 CTF SQL dump. This work is published from: United States.