YtjFXNqF

1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version   5.5.24-log
5 
6 
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11 
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15 
16 
17--
18-- Create schema perp
19--
20 
21CREATE DATABASE IF NOT EXISTS perp;
22USE perp;
23 
24--
25-- Definition of table `bans`
26--
27 
28DROP TABLE IF EXISTS `bans`;
29CREATE TABLE `bans` (
30  `ID` text,
31  `UNBAN` int(255) DEFAULT NULL,
32  `BANNER` text,
33  `NAME` text,
34  `REASON` text,
35  `BANNER_STEAMID` text
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37 
38--
39-- Dumping data for table `bans`
40--
41 
42/*!40000 ALTER TABLE `bans` DISABLE KEYS */;
43/*!40000 ALTER TABLE `bans` ENABLE KEYS */;
44 
45 
46--
47-- Definition of table `blacklist`
48--
49 
50DROP TABLE IF EXISTS `blacklist`;
51CREATE TABLE `blacklist` (
52  `id` int(11) NOT NULL AUTO_INCREMENT,
53  `admin` varchar(32) NOT NULL,
54  `player` varchar(32) NOT NULL,
55  `job` varchar(11) NOT NULL,
56  `time` int(11) NOT NULL,
57  `reason` varchar(256) NOT NULL,
58  `curtime` int(11) NOT NULL,
59  PRIMARY KEY (`id`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61 
62--
63-- Dumping data for table `blacklist`
64--
65 
66/*!40000 ALTER TABLE `blacklist` DISABLE KEYS */;
67/*!40000 ALTER TABLE `blacklist` ENABLE KEYS */;
68 
69 
70--
71-- Definition of table `cms_news`
72--
73 
74DROP TABLE IF EXISTS `cms_news`;
75CREATE TABLE `cms_news` (
76  `date` date NOT NULL DEFAULT '0000-00-00',
77  `title` text,
78  `poster` text,
79  `news` text,
80  PRIMARY KEY (`date`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82 
83--
84-- Dumping data for table `cms_news`
85--
86 
87/*!40000 ALTER TABLE `cms_news` DISABLE KEYS */;
88/*!40000 ALTER TABLE `cms_news` ENABLE KEYS */;
89 
90 
91--
92-- Definition of table `global_chat`
93--
94 
95DROP TABLE IF EXISTS `global_chat`;
96CREATE TABLE `global_chat` (
97  `user_name` text,
98  `message` text,
99  `server_id` int(1) NOT NULL DEFAULT '0',
100  PRIMARY KEY (`server_id`)
101) ENGINE=InnoDB DEFAULT CHARSET=latin1;
102 
103--
104-- Dumping data for table `global_chat`
105--
106 
107/*!40000 ALTER TABLE `global_chat` DISABLE KEYS */;
108/*!40000 ALTER TABLE `global_chat` ENABLE KEYS */;
109 
110 
111--
112-- Definition of table `rp_auth`
113--
114 
115DROP TABLE IF EXISTS `rp_auth`;
116CREATE TABLE `rp_auth` (
117  `server` int(11) DEFAULT NULL,
118  `steamid` text NOT NULL,
119  PRIMARY KEY (`steamid`(40))
120) ENGINE=InnoDB DEFAULT CHARSET=latin1;
121 
122--
123-- Dumping data for table `rp_auth`
124--
125 
126/*!40000 ALTER TABLE `rp_auth` DISABLE KEYS */;
127INSERT INTO `rp_auth` (`server`,`steamid`) VALUES
128 (0,'2');
129/*!40000 ALTER TABLE `rp_auth` ENABLE KEYS */;
130 
131 
132--
133-- Definition of table `rp_items`
134--
135 
136DROP TABLE IF EXISTS `rp_items`;
137CREATE TABLE `rp_items` (
138  `steamid` text,
139  `item_id` text,
140  `item_quantity` int(11) DEFAULT '0'
141) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142 
143--
144-- Dumping data for table `rp_items`
145--