/*
MySQL Data Transfer
Source Host: localhost
Source Database: root
Target Host: localhost
Target Database: root
Date: 1/10/2010 7:36:19 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bans
-- ----------------------------
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `ID` text,
  `UNBAN` int(255) DEFAULT NULL,
  `BANNER` text,
  `NAME` text,
  `REASON` text,
  `BANNER_STEAMID` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
  `date` date NOT NULL DEFAULT '0000-00-00',
  `title` text,
  `poster` text,
  `news` text,
  PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for global_chat
-- ----------------------------
DROP TABLE IF EXISTS `global_chat`;
CREATE TABLE `global_chat` (
  `user_name` text,
  `message` text,
  `server_id` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_auth
-- ----------------------------
DROP TABLE IF EXISTS `rp_auth`;
CREATE TABLE `rp_auth` (
  `server` int(11) DEFAULT NULL,
  `steamid` text NOT NULL,
  PRIMARY KEY (`steamid`(40))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_items
-- ----------------------------
DROP TABLE IF EXISTS `rp_items`;
CREATE TABLE `rp_items` (
  `steamid` text,
  `item_id` text,
  `item_quantity` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_lottery
-- ----------------------------
DROP TABLE IF EXISTS `rp_lottery`;
CREATE TABLE `rp_lottery` (
  `steamid` text,
  `claimed` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`claimed`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_org
-- ----------------------------
DROP TABLE IF EXISTS `rp_org`;
CREATE TABLE `rp_org` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_steamid` text,
  `motd` text,
  `name` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_system
-- ----------------------------
DROP TABLE IF EXISTS `rp_system`;
CREATE TABLE `rp_system` (
  `redownload_inventory` int(200) NOT NULL DEFAULT '0',
  `cash_flow` text,
  PRIMARY KEY (`redownload_inventory`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_users
-- ----------------------------
DROP TABLE IF EXISTS `rp_users`;
CREATE TABLE `rp_users` (
  `steamid` text NOT NULL,
  `name` text,
  `money` int(255) DEFAULT '10000',
  `org` text,
  `blacklist` text,
  `model` text,
  `vehicles` text,
  `vehicle_skins` text,
  `time_played` text,
  `free_points` int(3) DEFAULT '6',
  `fat` text,
  `skill_dexterity` text,
  `skill_stamina` text,
  `skill_intelligence` text,
  `skill_strength` text,
  `skill_craftiness` text,
  `ammo_pistol` text,
  `ammo_rifle` text,
  `ammo_shotgun` text,
  `bbcu` text,
  `rank` int(11) DEFAULT '5',
  PRIMARY KEY (`steamid`(40))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for site_blacklist
-- ----------------------------
DROP TABLE IF EXISTS `site_blacklist`;
CREATE TABLE `site_blacklist` (
  `IP` text,
  `Why` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;