# phpMyAdmin MySQL-Dump
# version 2.2.3
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Feb 09, 2001 at 02:14 PM
# Server version: 3.23.37
# PHP Version: 4.0.4pl1
# Database : `tourney`
# --------------------------------------------------------
#
# Table structure for table `ALLTOURNEY_players`
#
DROP TABLE IF EXISTS ALLTOURNEY_players;
CREATE TABLE ALLTOURNEY_players (
id int(11) unsigned NOT NULL auto_increment,
name text NOT NULL,
email text NOT NULL,
passwd text NOT NULL,
type smallint(3) unsigned NOT NULL default '0',
j_date date NOT NULL default '0000-00-00',
active char(1) NOT NULL default 'N',
ip text,
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Dumping data for table `ALLTOURNEY_players`
#
INSERT INTO ALLTOURNEY_players VALUES (1, 'ganon1', '[email protected]', 'ganon1', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (2, 'ganon2', '[email protected]', 'ganon2', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (3, 'ganon3', '[email protected]', 'ganon3', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (4, 'ganon4', '[email protected]', 'ganon4', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (5, 'ganon5', '[email protected]', 'ganon5', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (6, 'ganon6', '[email protected]', 'ganon6', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (7, 'ganon7', '[email protected]', 'ganon7', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (8, 'ganon8', '[email protected]', 'ganon8', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (9, 'ganon9', '[email protected]', 'ganon9', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (10, 'ganon10', '[email protected]', 'ganon10', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (11, 'ganon11', '[email protected]', 'ganon11', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (12, 'ganon12', '[email protected]', 'ganon12', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (13, 'ganon13', '[email protected]', 'ganon13', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (14, 'ganon14', '[email protected]', 'ganon14', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (15, 'ganon15', '[email protected]', 'ganon15', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (16, 'ganon16', '[email protected]', 'ganon16', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (17, 'ganon17', '[email protected]', 'ganon17', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (18, 'ganon18', '[email protected]', 'ganon18', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (19, 'ganon19', '[email protected]', 'ganon19', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (20, 'ganon20', '[email protected]', 'ganon20', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (21, 'ganon21', '[email protected]', 'ganon21', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (22, 'ganon22', '[email protected]', 'ganon22', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (23, 'ganon23', '[email protected]', 'ganon23', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (24, 'ganon24', '[email protected]', 'ganon24', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (25, 'ganon25', '[email protected]', 'ganon25', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (26, 'ganon26', '[email protected]', 'ganon26', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (27, 'ganon27', '[email protected]', 'ganon27', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (28, 'ganon28', '[email protected]', 'ganon28', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (29, 'ganon29', '[email protected]', 'ganon29', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (30, 'ganon30', '[email protected]', 'ganon30', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (31, 'ganon31', '[email protected]', 'ganon31', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (32, 'ganon32', '[email protected]', 'ganon32', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (33, 'ganon33', '[email protected]', 'ganon33', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (34, 'ganon34', '[email protected]', 'ganon34', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (35, 'ganon35', '[email protected]', 'ganon35', 0, '0000-00-00', 'Y', NULL);
INSERT INTO ALLTOURNEY_players VALUES (36, 'ganon36', '[email protected]', 'ganon36', 0, '0000-00-00', 'Y', NULL);
# --------------------------------------------------------
#
# Table structure for table `tourney_data_1`
#
DROP TABLE IF EXISTS tourney_data_1;
CREATE TABLE tourney_data_1 (
id int(11) unsigned NOT NULL default '0',
r1 int(3) unsigned default NULL,
r2 int(3) unsigned default NULL,
r3 int(3) unsigned default NULL,
r4 int(3) unsigned default NULL,
r5 int(3) unsigned default NULL,
r6 int(3) unsigned default NULL,
r7 int(3) unsigned default NULL,
r8 int(3) unsigned default NULL,
dead int(1) unsigned default NULL,
curround int(1) unsigned default NULL,
commment text
) TYPE=MyISAM;
#
# Dumping data for table `tourney_data_1`
#
INSERT INTO tourney_data_1 VALUES (2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '');
INSERT INTO tourney_data_1 VALUES (6, 2, 1, 1, NULL, NULL, NULL, NULL, NULL, 1, 3, '');
INSERT INTO tourney_data_1 VALUES (4, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '');
INSERT INTO tourney_data_1 VALUES (1, 4, 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, 'gg man');
INSERT INTO tourney_data_1 VALUES (3, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '');
INSERT INTO tourney_data_1 VALUES (7, 6, 3, 2, 1, NULL, NULL, NULL, NULL, 0, 4, NULL);
INSERT INTO tourney_data_1 VALUES (0, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL);
INSERT INTO tourney_data_1 VALUES (5, 8, 4, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, 'you own bad dood');
# --------------------------------------------------------
#
# Table structure for table `tourney_data_2`
#
DROP TABLE IF EXISTS tourney_data_2;
CREATE TABLE tourney_data_2 (
id int(11) unsigned NOT NULL default '0',
r1 int(3) unsigned default NULL,
r2 int(3) unsigned default NULL,
r3 int(3) unsigned default NULL,
r4 int(3) unsigned default NULL,
r5 int(3) unsigned default NULL,
r6 int(3) unsigned default NULL,
r7 int(3) unsigned default NULL,
r8 int(3) unsigned default NULL,
dead int(1) unsigned default NULL,
curround int(1) unsigned default NULL,
commment text
) TYPE=MyISAM;
#
# Dumping data for table `tourney_data_2`
#
# --------------------------------------------------------
#
# Table structure for table `tourney_data_3`
#
DROP TABLE IF EXISTS tourney_data_3;
CREATE TABLE tourney_data_3 (
id int(11) unsigned NOT NULL default '0',
r1 int(3) unsigned default NULL,
r2 int(3) unsigned default NULL,
r3 int(3) unsigned default NULL,
r4 int(3) unsigned default NULL,
r5 int(3) unsigned default NULL,
r6 int(3) unsigned default NULL,
r7 int(3) unsigned default NULL,
r8 int(3) unsigned default NULL,
dead int(1) unsigned default NULL,
curround int(1) unsigned default NULL,
commment text
) TYPE=MyISAM;
#
# Dumping data for table `tourney_data_3`
#
# --------------------------------------------------------
#
# Table structure for table `tourney_data_4`
#
DROP TABLE IF EXISTS tourney_data_4;
CREATE TABLE tourney_data_4 (
id int(11) unsigned NOT NULL default '0',
r1 int(3) unsigned default NULL,
r2 int(3) unsigned default NULL,
r3 int(3) unsigned default NULL,
r4 int(3) unsigned default NULL,
r5 int(3) unsigned default NULL,
r6 int(3) unsigned default NULL,
r7 int(3) unsigned default NULL,
r8 int(3) unsigned default NULL,
dead int(1) unsigned default NULL,
curround int(1) unsigned default NULL,
commment text
) TYPE=MyISAM;
#
# Dumping data for table `tourney_data_4`
#
INSERT INTO tourney_data_4 VALUES (4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO tourney_data_4 VALUES (6, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO tourney_data_4 VALUES (3, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO tourney_data_4 VALUES (5, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO tourney_data_4 VALUES (7, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO tourney_data_4 VALUES (1, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO tourney_data_4 VALUES (0, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO tourney_data_4 VALUES (2, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);
# --------------------------------------------------------
#
# Table structure for table ` " . $GLOBALS['dbtable_header'] . "info`
#
DROP TABLE IF EXISTS tourney_info;
CREATE TABLE tourney_info (
id int(11) unsigned NOT NULL auto_increment,
hostname text,
tname text,
tdatetime datetime default NULL,
ttype text,
tspeed text,
prize text,
maps blob,
nb_per_team int(3) unsigned NOT NULL default '0',
status int(1) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Dumping data for table ` " . $GLOBALS['dbtable_header'] . "info`
#
INSERT INTO tourney_info VALUES (1, 'Ganondorf', 'Tourney allready played', '2001-09-07 13:00:00', '2on2 Single elimination', '', 'Fame a Respect from the game community.', '<br> - First round : That map...\r\n<br> - Second round : That other map.\r\n<br> - Final : best of 3...', 2, 9);
INSERT INTO tourney_info VALUES (2, 'Ganondorf', 'Tourney 1on1', '2002-09-01 13:00:00', '1on1 single eliminations', '', '', 'Any Html Code in Here...', 1, 1);
INSERT INTO tourney_info VALUES (3, 'Ganondorf', 'tourney 2on2 #1', '2002-09-02 15:00:00', '2on2 tourney !', '', '', 'Any Html Code in Here...', 2, 2);
INSERT INTO tourney_info VALUES (4, 'Ganondorf', 'Tourney 2on2 #2', '2002-09-03 15:00:00', '2on2 tourney ', '', 'million dollar ', 'Any Html Code in Here...', 2, 8);
# --------------------------------------------------------
#
# Table structure for table `tourney_signup_1`
#
DROP TABLE IF EXISTS tourney_signup_1;
CREATE TABLE tourney_signup_1 (
ordre int(11) unsigned NOT NULL auto_increment,
id int(11) unsigned NOT NULL default '0',
checkin int(1) unsigned default NULL,
tid int(11) unsigned NOT NULL default '0',
teamname text,
PRIMARY KEY (ordre)
) TYPE=MyISAM;
#
# Dumping data for table `tourney_signup_1`
#
INSERT INTO tourney_signup_1 VALUES (1, 1, 1, 1, 'Team Ganon1');
INSERT INTO tourney_signup_1 VALUES (2, 2, 1, 2, 'Team Ganon2');
INSERT INTO tourney_signup_1 VALUES (3, 3, 1, 3, 'Team Ganon3');
INSERT INTO tourney_signup_1 VALUES (4, 4, 1, 4, 'team Ganon4');
INSERT INTO tourney_signup_1 VALUES (5, 5, 1, 5, 'Team ganon5');
INSERT INTO tourney_signup_1 VALUES (6, 6, 1, 6, 'Team ganon6');
INSERT INTO tourney_signup_1 VALUES (7, 7, 1, 7, 'team ganon7');
# --------------------------------------------------------
#
# Table structure for table `tourney_signup_2`
#
DROP TABLE IF EXISTS tourney_signup_2;
CREATE TABLE tourney_signup_2 (
ordre int(11) unsigned NOT NULL auto_increment,
id int(11) unsigned NOT NULL default '0',
checkin int(1) unsigned default NULL,
tid int(11) unsigned NOT NULL default '0',
teamname text,
PRIMARY KEY (ordre)
) TYPE=MyISAM;
#
# Dumping data for table `tourney_signup_2`
#
INSERT INTO tourney_signup_2 VALUES (1, 1, 0, 1, '');
INSERT INTO tourney_signup_2 VALUES (2, 2, 0, 2, '');
INSERT INTO tourney_signup_2 VALUES (3, 3, 0, 3, '');
# --------------------------------------------------------
#
# Table structure for table `tourney_signup_3`
#
DROP TABLE IF EXISTS tourney_signup_3;
CREATE TABLE tourney_signup_3 (
ordre int(11) unsigned NOT NULL auto_increment,
id int(11) unsigned NOT NULL default '0',
checkin int(1) unsigned default NULL,
tid int(11) unsigned NOT NULL default '0',
teamname text,
PRIMARY KEY (ordre)
) TYPE=MyISAM;
#
# Dumping data for table `tourney_signup_3`
#
INSERT INTO tourney_signup_3 VALUES (1, 1, 1, 1, 'Team ganon1');
INSERT INTO tourney_signup_3 VALUES (2, 2, 0, 2, 'Team ganon2');
INSERT INTO tourney_signup_3 VALUES (3, 3, 0, 3, 'Team ganon3');
INSERT INTO tourney_signup_3 VALUES (4, 4, 0, 4, 'team Ganon3');
INSERT INTO tourney_signup_3 VALUES (5, 5, 0, 5, 'team Ganon5');
# --------------------------------------------------------
#
# Table structure for table `tourney_signup_4`
#
DROP TABLE IF EXISTS tourney_signup_4;
CREATE TABLE tourney_signup_4 (
ordre int(11) unsigned NOT NULL auto_increment,
id int(11) unsigned NOT NULL default '0',
checkin int(1) unsigned default NULL,
tid int(11) unsigned NOT NULL default '0',
teamname text,
PRIMARY KEY (ordre)
) TYPE=MyISAM;
#
# Dumping data for table `tourney_signup_4`
#
INSERT INTO tourney_signup_4 VALUES (1, 1, 1, 1, 'Team ganon1');
INSERT INTO tourney_signup_4 VALUES (2, 2, 1, 2, 'Team ganon2');
INSERT INTO tourney_signup_4 VALUES (3, 3, 1, 3, 'team ganon3');
INSERT INTO tourney_signup_4 VALUES (4, 4, 1, 4, 'team ganon4');
INSERT INTO tourney_signup_4 VALUES (5, 5, 1, 5, 'team ganon5');
INSERT INTO tourney_signup_4 VALUES (6, 6, 1, 6, 'team ganon6');
INSERT INTO tourney_signup_4 VALUES (7, 7, 1, 7, 'team ganon7');
# --------------------------------------------------------
#
# Table structure for table `tourney_team_members_1`
#
DROP TABLE IF EXISTS tourney_team_members_1;
CREATE TABLE tourney_team_members_1 (
nb int(2) unsigned NOT NULL default '0',
id int(11) unsigned NOT NULL default '0',
pid int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `tourney_team_members_1`
#
INSERT INTO tourney_team_members_1 VALUES (1, 1, 1);
INSERT INTO tourney_team_members_1 VALUES (2, 1, 33);
INSERT INTO tourney_team_members_1 VALUES (1, 2, 2);
INSERT INTO tourney_team_members_1 VALUES (2, 2, 31);
INSERT INTO tourney_team_members_1 VALUES (1, 3, 3);
INSERT INTO tourney_team_members_1 VALUES (2, 3, 11);
INSERT INTO tourney_team_members_1 VALUES (1, 4, 4);
INSERT INTO tourney_team_members_1 VALUES (2, 4, 30);
INSERT INTO tourney_team_members_1 VALUES (1, 5, 5);
INSERT INTO tourney_team_members_1 VALUES (2, 5, 29);
INSERT INTO tourney_team_members_1 VALUES (1, 6, 6);
INSERT INTO tourney_team_members_1 VALUES (2, 6, 28);
INSERT INTO tourney_team_members_1 VALUES (1, 7, 7);
INSERT INTO tourney_team_members_1 VALUES (2, 7, 32);
# --------------------------------------------------------
#
# Table structure for table `tourney_team_members_2`
#
DROP TABLE IF EXISTS tourney_team_members_2;
CREATE TABLE tourney_team_members_2 (
nb int(2) unsigned NOT NULL default '0',
id int(11) unsigned NOT NULL default '0',
pid int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `tourney_team_members_2`
#
INSERT INTO tourney_team_members_2 VALUES (2, 3, 0);
INSERT INTO tourney_team_members_2 VALUES (2, 7, 8);
INSERT INTO tourney_team_members_2 VALUES (2, 6, 3);
INSERT INTO tourney_team_members_2 VALUES (1, 6, 6);
# --------------------------------------------------------
#
# Table structure for table `tourney_team_members_3`
#
DROP TABLE IF EXISTS tourney_team_members_3;
CREATE TABLE tourney_team_members_3 (
nb int(2) unsigned NOT NULL default '0',
id int(11) unsigned NOT NULL default '0',
pid int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `tourney_team_members_3`
#
INSERT INTO tourney_team_members_3 VALUES (1, 1, 1);
INSERT INTO tourney_team_members_3 VALUES (2, 1, 36);
INSERT INTO tourney_team_members_3 VALUES (1, 2, 2);
INSERT INTO tourney_team_members_3 VALUES (2, 2, 28);
INSERT INTO tourney_team_members_3 VALUES (1, 3, 3);
INSERT INTO tourney_team_members_3 VALUES (2, 3, 32);
INSERT INTO tourney_team_members_3 VALUES (1, 4, 4);
INSERT INTO tourney_team_members_3 VALUES (2, 4, 34);
INSERT INTO tourney_team_members_3 VALUES (1, 5, 5);
INSERT INTO tourney_team_members_3 VALUES (2, 5, 25);
# --------------------------------------------------------
#
# Table structure for table `tourney_team_members_4`
#
DROP TABLE IF EXISTS tourney_team_members_4;
CREATE TABLE tourney_team_members_4 (
nb int(2) unsigned NOT NULL default '0',
id int(11) unsigned NOT NULL default '0',
pid int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `tourney_team_members_4`
#
INSERT INTO tourney_team_members_4 VALUES (1, 1, 1);
INSERT INTO tourney_team_members_4 VALUES (2, 1, 31);
INSERT INTO tourney_team_members_4 VALUES (1, 2, 2);
INSERT INTO tourney_team_members_4 VALUES (2, 2, 32);
INSERT INTO tourney_team_members_4 VALUES (1, 3, 3);
INSERT INTO tourney_team_members_4 VALUES (2, 3, 30);
INSERT INTO tourney_team_members_4 VALUES (1, 4, 4);
INSERT INTO tourney_team_members_4 VALUES (2, 4, 24);
INSERT INTO tourney_team_members_4 VALUES (1, 5, 5);
INSERT INTO tourney_team_members_4 VALUES (2, 5, 28);
INSERT INTO tourney_team_members_4 VALUES (1, 6, 6);
INSERT INTO tourney_team_members_4 VALUES (2, 6, 27);
INSERT INTO tourney_team_members_4 VALUES (1, 7, 7);
INSERT INTO tourney_team_members_4 VALUES (2, 7, 23);
# --------------------------------------------------------