-- phpMyAdmin SQL Dump
-- version 4.4.12
--
phpMyAdmin
--
-- Host: localhost
-- Generation Time: Jul 05, 2017 at 10:01 AM
-- Server version: 5.6.34
-- PHP Version: 5.6.26-pl0-gentoo
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `colosseumgaming_statistics`
--
-- --------------------------------------------------------
--
-- Table structure for table `hl_gangs_groups`
--
CREATE TABLE IF NOT EXISTS `hl_gangs_groups` (
`id` int(20) NOT NULL,
`gang` varchar(32) NOT NULL,
`health` int(16) NOT NULL,
`damage` int(16) NOT NULL,
`gravity` int(16) NOT NULL,
`speed` int(16) NOT NULL,
`size` int(16) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `hl_gangs_players`
--
CREATE TABLE IF NOT EXISTS `hl_gangs_players` (
`id` int(20) NOT NULL,
`steamid` varchar(32) NOT NULL,
`playername` varchar(32) NOT NULL,
`gang` varchar(32) NOT NULL,
`rank` int(16) NOT NULL,
`invitedby` varchar(32) NOT NULL,
`date` int(32) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `hl_gangs_statistics`
--
CREATE TABLE IF NOT EXISTS `hl_gangs_statistics` (
`id` int(20) NOT NULL,
`gang` varchar(32) NOT NULL,
`ctkills` int(16) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `hl_gangs_groups`
--
ALTER TABLE `hl_gangs_groups`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `gang` (`gang`),
ADD UNIQUE KEY `gang_2` (`gang`),
ADD UNIQUE KEY `gang_3` (`gang`),
ADD UNIQUE KEY `gang_4` (`gang`),
ADD UNIQUE KEY `gang_5` (`gang`),
ADD UNIQUE KEY `gang_6` (`gang`),
ADD UNIQUE KEY `gang_7` (`gang`),
ADD UNIQUE KEY `gang_8` (`gang`),
ADD UNIQUE KEY `gang_9` (`gang`),
ADD UNIQUE KEY `gang_10` (`gang`),
ADD UNIQUE KEY `gang_11` (`gang`),
ADD UNIQUE KEY `gang_12` (`gang`),
ADD UNIQUE KEY `gang_13` (`gang`),
ADD UNIQUE KEY `gang_14` (`gang`),
ADD UNIQUE KEY `gang_15` (`gang`),
ADD UNIQUE KEY `gang_16` (`gang`),
ADD UNIQUE KEY `gang_17` (`gang`),
ADD UNIQUE KEY `gang_18` (`gang`),
ADD UNIQUE KEY `gang_19` (`gang`),
ADD UNIQUE KEY `gang_20` (`gang`),
ADD UNIQUE KEY `gang_21` (`gang`),
ADD UNIQUE KEY `gang_22` (`gang`),
ADD UNIQUE KEY `gang_23` (`gang`),
ADD UNIQUE KEY `gang_24` (`gang`),
ADD UNIQUE KEY `gang_25` (`gang`),
ADD UNIQUE KEY `gang_26` (`gang`),
ADD UNIQUE KEY `gang_27` (`gang`),
ADD UNIQUE KEY `gang_28` (`gang`),
ADD UNIQUE KEY `gang_29` (`gang`),
ADD UNIQUE KEY `gang_30` (`gang`),
ADD UNIQUE KEY `gang_31` (`gang`),
ADD UNIQUE KEY `gang_32` (`gang`),
ADD UNIQUE KEY `gang_33` (`gang`),
ADD UNIQUE KEY `gang_34` (`gang`),
ADD UNIQUE KEY `gang_35` (`gang`),
ADD UNIQUE KEY `gang_36` (`gang`),
ADD UNIQUE KEY `gang_37` (`gang`),
ADD UNIQUE KEY `gang_38` (`gang`),
ADD UNIQUE KEY `gang_39` (`gang`),
ADD UNIQUE KEY `gang_40` (`gang`),
ADD UNIQUE KEY `gang_41` (`gang`),
ADD UNIQUE KEY `gang_42` (`gang`),
ADD UNIQUE KEY `gang_43` (`gang`),
ADD UNIQUE KEY `gang_44` (`gang`),
ADD UNIQUE KEY `gang_45` (`gang`),
ADD UNIQUE KEY `gang_46` (`gang`),
ADD UNIQUE KEY `gang_47` (`gang`),
ADD UNIQUE KEY `gang_48` (`gang`),
ADD UNIQUE KEY `gang_49` (`gang`),
ADD UNIQUE KEY `gang_50` (`gang`),
ADD UNIQUE KEY `gang_51` (`gang`),
ADD UNIQUE KEY `gang_52` (`gang`),
ADD UNIQUE KEY `gang_53` (`gang`),
ADD UNIQUE KEY `gang_54` (`gang`),
ADD UNIQUE KEY `gang_55` (`gang`),
ADD UNIQUE KEY `gang_56` (`gang`),
ADD UNIQUE KEY `gang_57` (`gang`),
ADD UNIQUE KEY `gang_58` (`gang`),
ADD UNIQUE KEY `gang_59` (`gang`),
ADD UNIQUE KEY `gang_60` (`gang`),
ADD UNIQUE KEY `gang_61` (`gang`),
ADD UNIQUE KEY `gang_62` (`gang`),
ADD UNIQUE KEY `gang_63` (`gang`);
--
-- Indexes for table `hl_gangs_players`
--
ALTER TABLE `hl_gangs_players`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `hl_gangs_statistics`
--
ALTER TABLE `hl_gangs_statistics`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `gang` (`gang`),
ADD UNIQUE KEY `gang_2` (`gang`),
ADD UNIQUE KEY `gang_3` (`gang`),
ADD UNIQUE KEY `gang_4` (`gang`),
ADD UNIQUE KEY `gang_5` (`gang`),
ADD UNIQUE KEY `gang_6` (`gang`),
ADD UNIQUE KEY `gang_7` (`gang`),
ADD UNIQUE KEY `gang_8` (`gang`),
ADD UNIQUE KEY `gang_9` (`gang`),
ADD UNIQUE KEY `gang_10` (`gang`),
ADD UNIQUE KEY `gang_11` (`gang`),
ADD UNIQUE KEY `gang_12` (`gang`),
ADD UNIQUE KEY `gang_13` (`gang`),
ADD UNIQUE KEY `gang_14` (`gang`),
ADD UNIQUE KEY `gang_15` (`gang`),
ADD UNIQUE KEY `gang_16` (`gang`),
ADD UNIQUE KEY `gang_17` (`gang`),
ADD UNIQUE KEY `gang_18` (`gang`),
ADD UNIQUE KEY `gang_19` (`gang`),
ADD UNIQUE KEY `gang_20` (`gang`),
ADD UNIQUE KEY `gang_21` (`gang`),
ADD UNIQUE KEY `gang_22` (`gang`),
ADD UNIQUE KEY `gang_23` (`gang`),
ADD UNIQUE KEY `gang_24` (`gang`),
ADD UNIQUE KEY `gang_25` (`gang`),
ADD UNIQUE KEY `gang_26` (`gang`),
ADD UNIQUE KEY `gang_27` (`gang`),
ADD UNIQUE KEY `gang_28` (`gang`),
ADD UNIQUE KEY `gang_29` (`gang`),
ADD UNIQUE KEY `gang_30` (`gang`),
ADD UNIQUE KEY `gang_31` (`gang`),
ADD UNIQUE KEY `gang_32` (`gang`),
ADD UNIQUE KEY `gang_33` (`gang`),
ADD UNIQUE KEY `gang_34` (`gang`),
ADD UNIQUE KEY `gang_35` (`gang`),
ADD UNIQUE KEY `gang_36` (`gang`),
ADD UNIQUE KEY `gang_37` (`gang`),
ADD UNIQUE KEY `gang_38` (`gang`),
ADD UNIQUE KEY `gang_39` (`gang`),
ADD UNIQUE KEY `gang_40` (`gang`),
ADD UNIQUE KEY `gang_41` (`gang`),
ADD UNIQUE KEY `gang_42` (`gang`),
ADD UNIQUE KEY `gang_43` (`gang`),
ADD UNIQUE KEY `gang_44` (`gang`),
ADD UNIQUE KEY `gang_45` (`gang`),
ADD UNIQUE KEY `gang_46` (`gang`),
ADD UNIQUE KEY `gang_47` (`gang`),
ADD UNIQUE KEY `gang_48` (`gang`),
ADD UNIQUE KEY `gang_49` (`gang`),
ADD UNIQUE KEY `gang_50` (`gang`),
ADD UNIQUE KEY `gang_51` (`gang`),
ADD UNIQUE KEY `gang_52` (`gang`),
ADD UNIQUE KEY `gang_53` (`gang`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `hl_gangs_groups`
--
ALTER TABLE `hl_gangs_groups`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `hl_gangs_players`
--
ALTER TABLE `hl_gangs_players`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `hl_gangs_statistics`
--
ALTER TABLE `hl_gangs_statistics`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;