samp sql file

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50524
Source Host           : localhost:3306
Source Database       : hidden(my db name right?)

Target Server Type    : MYSQL
Target Server Version : 50524
File Encoding         : 65001

Date: 2014-02-13 23:25:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for accounts
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_name` varchar(24) NOT NULL,
  `account_pass` varchar(256) NOT NULL,
  `account_level` int(11) NOT NULL DEFAULT '0',
  `account_lastip` varchar(32) NOT NULL,
  `account_registerip` varchar(32) NOT NULL,
  `account_registerdate` datetime NOT NULL,
  `account_registerstamp` int(11) NOT NULL,
  `account_lastaccessdate` datetime NOT NULL,
  `account_lastaccessstamp` int(11) NOT NULL,
  `account_allowedips` int(11) NOT NULL DEFAULT '0',
  `account_email` varchar(50) NOT NULL,
  `account_suspictions` varchar(64) NOT NULL,
  `banned` int(11) NOT NULL DEFAULT '0',
  `account_playedtime` int(11) NOT NULL,
  `account_autologin` int(11) NOT NULL DEFAULT '0',
  `inuse` int(11) NOT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for bans
-- ----------------------------
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `ban_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `admin` varchar(24) NOT NULL,
  `reason` varchar(256) NOT NULL,
  `expiration` int(11) NOT NULL,
  `ban_status` int(11) NOT NULL,
  `ip` varchar(32) DEFAULT NULL,
  `char_id` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `account_name` varchar(32) DEFAULT NULL,
  `char_name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`ban_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for chars
-- ----------------------------
DROP TABLE IF EXISTS `chars`;
CREATE TABLE `chars` (
  `char_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `char_name` varchar(24) NOT NULL,
  `char_lastuse` datetime NOT NULL,
  `char_lastusestamp` int(11) NOT NULL,
  `helpmsgs` int(11) NOT NULL,
  `banned` int(11) NOT NULL,
  PRIMARY KEY (`char_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for iptracking
-- ----------------------------
DROP TABLE IF EXISTS `iptracking`;
CREATE TABLE `iptracking` (
  `ip_used` varchar(32) NOT NULL,
  `account_id` int(11) NOT NULL,
  `banned` int(11) NOT NULL,
  `account_name` varchar(255) NOT NULL,
  `dateregistered` datetime NOT NULL,
  `datestamp` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for mainconfig
-- ----------------------------
DROP TABLE IF EXISTS `mainconfig`;
CREATE TABLE `mainconfig` (
  `damagemul` float NOT NULL DEFAULT '1',
  `critchancemul` float NOT NULL DEFAULT '1',
  `spawntimemul` float NOT NULL DEFAULT '1',
  `critchance` float NOT NULL DEFAULT '5',
  `vote` int(11) NOT NULL DEFAULT '1',
  `votekick` int(11) NOT NULL DEFAULT '1',
  `voteban` int(11) NOT NULL DEFAULT '1',
  `votescramble` int(11) NOT NULL DEFAULT '1',
  `votemode` int(11) NOT NULL DEFAULT '1',
  `votemap` int(11) NOT NULL DEFAULT '1',
  `votereset` int(11) NOT NULL DEFAULT '1',
  `DefWeather` int(11) NOT NULL DEFAULT '1',
  `DefTime` int(11) NOT NULL DEFAULT '1',
  `ServerCrashed` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for punishments
-- ----------------------------
DROP TABLE IF EXISTS `punishments`;
CREATE TABLE `punishments` (
  `punishmenttype` varchar(24) NOT NULL,
  `char_id` int(11) DEFAULT NULL,
  `char_name` varchar(32) DEFAULT NULL,
  `account_id` int(11) NOT NULL,
  `account_name` varchar(32) DEFAULT NULL,
  `issuername` varchar(32) NOT NULL,
  `timeissued` datetime NOT NULL,
  `reason` varchar(156) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for reports
-- ----------------------------
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `reporter_acc_name` varchar(24) NOT NULL,
  `reported_acc_name` varchar(24) NOT NULL,
  `reportdate` datetime NOT NULL,
  `report` varchar(255) NOT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for stats
-- ----------------------------
DROP TABLE IF EXISTS `stats`;
CREATE TABLE `stats` (
  `char_id` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `class` int(11) DEFAULT NULL,
  `kills` int(11) NOT NULL DEFAULT '0',
  `score` int(11) NOT NULL DEFAULT '0',
  `captures` int(11) NOT NULL DEFAULT '0',
  `defenses` int(11) NOT NULL DEFAULT '0',
  `destructions` int(11) NOT NULL DEFAULT '0',
  `assists` int(11) NOT NULL DEFAULT '0',
  `damagedealt` float NOT NULL DEFAULT '0',
  `healed` float NOT NULL DEFAULT '0',
  `saps` int(11) NOT NULL DEFAULT '0',
  `backstabs` int(11) NOT NULL DEFAULT '0',
  `constructions` int(11) NOT NULL DEFAULT '0',
  `headshoots` int(11) NOT NULL DEFAULT '0',
  `ubers` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `criticals` int(11) NOT NULL DEFAULT '0',
  `victories` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;