-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Host: 127.0.0.1
-- Generation Time: Aug 06, 2013 at 11:09 PM
-- Server version: 5.1.66
-- PHP Version: 5.3.3-7+squeeze15
-- 
-- Database: `cs_61stats`
-- 

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

-- 
-- Table structure for table `kills`
-- 

CREATE TABLE `kills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wpn` int(11) NOT NULL,
  `player` int(11) NOT NULL,
  `map` int(11) NOT NULL,
  `ct` tinyint(1) NOT NULL,
  `num` int(11) NOT NULL DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `kills`
-- 


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

-- 
-- Table structure for table `maps`
-- 

CREATE TABLE `maps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `ct_wins` int(11) NOT NULL DEFAULT '0',
  `ct_loss` int(11) NOT NULL DEFAULT '0',
  `te_wins` int(11) NOT NULL DEFAULT '0',
  `te_loss` int(11) NOT NULL DEFAULT '0',
  `ct_kills` int(11) NOT NULL DEFAULT '0',
  `ct_deaths` int(11) NOT NULL DEFAULT '0',
  `te_kills` int(11) NOT NULL DEFAULT '0',
  `te_deaths` int(11) NOT NULL DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `maps`
-- 


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

-- 
-- Table structure for table `player`
-- 

CREATE TABLE `player` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `nick` varchar(10) NOT NULL,
  `name` varchar(25) DEFAULT NULL,
  `ct_kills` int(11) NOT NULL DEFAULT '0',
  `ct_deaths` int(11) NOT NULL DEFAULT '0',
  `te_kills` int(11) NOT NULL DEFAULT '0',
  `te_deaths` int(11) NOT NULL DEFAULT '0',
  `ratio` float NOT NULL,
  `kills_part` int(3) NOT NULL DEFAULT '0',
  `ct_wins` int(11) NOT NULL DEFAULT '0',
  `ct_loss` int(11) NOT NULL DEFAULT '0',
  `te_wins` int(11) NOT NULL DEFAULT '0',
  `te_loss` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=358 ;

-- 
-- Dumping data for table `player`
-- 

INSERT INTO `player` (`id`, `uid`, `nick`, `name`, `ct_kills`, `ct_deaths`, `te_kills`, `te_deaths`, `ratio`, `kills_part`, `ct_wins`, `ct_loss`, `te_wins`, `te_loss`, `time`) VALUES 
(315, NULL, '', 'Shock3R', 80, 50, 0, 0, 1.6, 6, 0, 0, 0, 0, 0),
(314, NULL, '', 'Alex', 26, 65, 0, 0, 0.4, 2, 0, 0, 0, 0, 0),
(313, NULL, '', 'Hammurabi', 4, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(312, NULL, '', 'Kaan', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(311, NULL, '', 'Vagina', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(310, NULL, '', 'BeTa-Cs', 28, 29, 0, 0, 0.97, 2, 0, 0, 0, 0, 0),
(309, NULL, '', 'umut', 3, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(308, NULL, '', 'Zorky', 17, 16, 0, 0, 1.06, 1, 0, 0, 0, 0, 0),
(307, NULL, '', '{56K}Nastar', 2, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(306, NULL, '', 'Maj0', 2, 25, 0, 0, 0.08, 0, 0, 0, 0, 0, 0),
(305, NULL, '', 'geberik', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(304, NULL, '', 'Barnknullarn', 4, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(303, NULL, '', 'SapowiTz', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(302, NULL, '', '[56LaG]JoeyHill!!', 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(300, NULL, '', 'MAQTINSVK', 1, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(301, NULL, '', '[W4U]Morpheus', 5, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(299, NULL, '', 'yezzah', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(298, NULL, '', '[TAMM]Gotteshand', 42, 19, 0, 0, 2.21, 3, 0, 0, 0, 0, 0),
(297, NULL, '', '[TAMM]Seeth', 18, 62, 0, 0, 0.29, 1, 0, 0, 0, 0, 0),
(296, NULL, '', 'FatBoy', 24, 2, 0, 0, 12, 2, 0, 0, 0, 0, 0),
(295, NULL, '', '[W4U]TheSaint', 47, 31, 0, 0, 1.52, 4, 0, 0, 0, 0, 0),
(294, NULL, '', '[SA]SirChakotay', 41, 64, 0, 0, 0.64, 3, 0, 0, 0, 0, 0),
(293, NULL, '', '3v1L', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(292, NULL, '', 'oHaAaa', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(291, NULL, '', '[56kLaG]JaYHiLL', 28, 27, 0, 0, 1.04, 2, 0, 0, 0, 0, 0),
(290, NULL, '', 'roflcakes', 12, 38, 0, 0, 0.32, 1, 0, 0, 0, 0, 0),
(289, NULL, '', 'Connorcpu', 22, 31, 0, 0, 0.71, 2, 0, 0, 0, 0, 0),
(288, NULL, '', 'Cnegurozka', 50, 63, 0, 0, 0.79, 4, 0, 0, 0, 0, 0),
(287, NULL, '', 'MAQTIN', 13, 15, 0, 0, 0.87, 1, 0, 0, 0, 0, 0),
(285, NULL, '', 'FatBoySVK', 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(286, NULL, '', 'Eisbaer', 50, 58, 0, 0, 0.86, 4, 0, 0, 0, 0, 0),
(284, NULL, '', 'Oyuncu', 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(283, NULL, '', 'ruzgar', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(282, NULL, '', 'PatSVK', 127, 91, 0, 0, 1.4, 10, 0, 0, 0, 0, 0),
(281, NULL, '', 'Mike', 5, 20, 0, 0, 0.25, 0, 0, 0, 0, 0, 0),
(280, NULL, '', 'Stepp', 13, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0),
(316, NULL, '', 'maximus', 11, 15, 0, 0, 0.73, 1, 0, 0, 0, 0, 0),
(317, NULL, '', 'SaKaL', 5, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(318, NULL, '', 'BizedeBekleriz', 6, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(321, NULL, '', 'Tug', 85, 37, 0, 0, 2.3, 7, 0, 0, 0, 0, 0),
(319, NULL, '', 'Wave', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(320, NULL, '', 'Blade', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(331, NULL, '', '$ilver$oldier', 4, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(322, NULL, '', 'patafoin', 10, 21, 0, 0, 0.48, 1, 0, 0, 0, 0, 0),
(323, NULL, '', 'Zorky.SWE', 46, 56, 0, 0, 0.82, 4, 0, 0, 0, 0, 0),
(324, NULL, '', 'Tobbz', 13, 38, 0, 0, 0.34, 1, 0, 0, 0, 0, 0),
(325, NULL, '', 'Fume_de_la_poudre_a_canon', 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(326, NULL, '', 'chos3n', 82, 82, 0, 0, 1, 6, 0, 0, 0, 0, 0),
(327, NULL, '', 'slash0r', 81, 70, 0, 0, 1.16, 6, 0, 0, 0, 0, 0),
(328, NULL, '', 'big_ava', 25, 44, 0, 0, 0.57, 2, 0, 0, 0, 0, 0),
(329, NULL, '', 'optic0n', 9, 6, 0, 0, 0, 1, 0, 0, 0, 0, 0),
(330, NULL, '', 'Gram Brangs MOTHERFUCKER', 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(332, NULL, '', '2L*', 5, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(333, NULL, '', 'kocak', 7, 7, 0, 0, 0, 1, 0, 0, 0, 0, 0),
(334, NULL, '', 'Connor', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(335, NULL, '', 'sie', 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(343, NULL, '', 'WarezFrog', 62, 29, 0, 0, 2.14, 5, 0, 0, 0, 0, 0),
(336, NULL, '', 'mark', 26, 31, 0, 0, 0.84, 2, 0, 0, 0, 0, 0),
(337, NULL, '', 'Bluechildren', 15, 13, 0, 0, 1.15, 1, 0, 0, 0, 0, 0),
(338, NULL, '', 'ANYMAN', 1, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(339, NULL, '', 'ethan', 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(340, NULL, '', 'Esc', 6, 14, 0, 0, 0.43, 0, 0, 0, 0, 0, 0),
(341, NULL, '', 'SERKAN', 22, 17, 0, 0, 1.29, 2, 0, 0, 0, 0, 0),
(342, NULL, '', 'gasca', 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(344, NULL, '', 'ClinT.mne', 11, 25, 0, 0, 0.44, 1, 0, 0, 0, 0, 0),
(345, NULL, '', 'isa', 11, 27, 0, 0, 0.41, 1, 0, 0, 0, 0, 0),
(346, NULL, '', 'gokhan', 23, 27, 0, 0, 0.85, 2, 0, 0, 0, 0, 0),
(347, NULL, '', 'musty48', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(348, NULL, '', 'legolasysn', 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(349, NULL, '', 'user', 3, 21, 0, 0, 0.14, 0, 0, 0, 0, 0, 0),
(350, NULL, '', 'hazard', 20, 3, 0, 0, 6.67, 2, 0, 0, 0, 0, 0),
(351, NULL, '', 'Rocca', 3, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(352, NULL, '', 'eru', 5, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(353, NULL, '', 'SpawN', 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(354, NULL, '', 'Jawnt', 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(355, NULL, '', 'clyfen', 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(356, NULL, '', 'Rage', 5, 15, 0, 0, 0.33, 0, 0, 0, 0, 0, 0),
(357, NULL, '', 'Wmers', 10, 5, 0, 0, 0, 1, 0, 0, 0, 0, 0);

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

-- 
-- Table structure for table `weapons`
-- 

CREATE TABLE `weapons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ent` varchar(20) NOT NULL,
  `name` varchar(40) NOT NULL,
  `ct_kills` int(11) NOT NULL DEFAULT '0',
  `te_kills` int(11) NOT NULL DEFAULT '0',
  `kills_part` int(3) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '6',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

-- 
-- Dumping data for table `weapons`
-- 

INSERT INTO `weapons` (`id`, `ent`, `name`, `ct_kills`, `te_kills`, `kills_part`, `type`) VALUES 
(1, 'usp', 'H&K .45 Tactical', 77, 0, 5, 1),
(2, 'glock18', 'Glock18 Select Fire', 32, 0, 4, 1),
(3, 'deagle', 'Desert Eagle .50 AE', 61, 0, 4, 1),
(4, 'p228', 'SIG P228', 9, 0, 2, 1),
(5, 'm3', 'Benelli M3 Super 90', 21, 0, 2, 4),
(6, 'xm1014', 'Benelli XM1014', 5, 0, 1, 4),
(7, 'mp5navy', 'H&K MP5-Navy', 256, 0, 0, 2),
(8, 'tmp', 'Steyr Tactical Machine Pistol', 19, 0, 1, 2),
(9, 'p90', 'FN P90', 49, 0, 3, 2),
(10, 'mac10', 'Ingram MAC-10', 3, 0, 3, 2),
(11, 'ak47', 'AK-47', 210, 0, 11, 3),
(12, 'sg552', 'Sig SG-552 Commando', 61, 0, 5, 3),
(13, 'm4a1', 'Colt M4A1 Carbine', 243, 0, 17, 3),
(14, 'aug', 'Steyr Aug', 56, 0, 2, 3),
(15, 'scout', 'Steyr Scout', 20, 0, 2, 7),
(16, 'awp', 'Al Acrtic Warfare/Magnum', 111, 0, 11, 7),
(17, 'g3sg1', 'H&K G3/SG-1 Sniper Rifle', 4, 0, 1, 7),
(18, 'm249', 'FN M249 Para', 4, 0, 1, 5),
(19, 'grenade', 'HE Grenade', 18, 0, 0, 6),
(20, 'world_worldspawn', 'Suicide by Falling/Drowning', 13, 0, 1, 6),
(21, 'knife', 'Knife', 20, 0, 1, 6),
(22, 'self_grenade', 'Suicide by HE Grenade', 1, 0, 0, 6),
(23, 'self_world', 'Suicide', 104, 0, 8, 6),
(24, 'world_trigger_hurt', 'Unknown', 7, 0, 0, 6),
(25, 'world_door', 'Door', 0, 0, 0, 6),
(26, 'world_train', 'Train', 1, 0, 0, 6);

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

-- 
-- Table structure for table `wpn_types`
-- 

CREATE TABLE `wpn_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `ct_kills` int(11) NOT NULL DEFAULT '0',
  `te_kills` int(11) NOT NULL DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `wpn_types`
-- 

INSERT INTO `wpn_types` (`id`, `name`, `ct_kills`, `te_kills`) VALUES 
(1, 'Handgun', 0, 0),
(2, 'Sub-Machine Gun', 0, 0),
(3, 'Assault Rifle', 0, 0),
(4, 'Shotgun', 0, 0),
(5, 'Machinegun', 0, 0),
(6, 'Other', 0, 0),
(7, 'Sniper Rifle', 0, 0);
