6JkYhFKp

1--YOU ARE WELCOME RANDOM INTERWEBS PEOPLES - Reptilian---
2 
3SET FOREIGN_KEY_CHECKS=0;
4-- ----------------------------
5-- Table structure for bans
6-- ----------------------------
7DROP TABLE IF EXISTS `bans`;
8CREATE TABLE `bans` (
9  `ID` text,
10  `UNBAN` int(255) DEFAULT NULL,
11  `BANNER` text,
12  `NAME` text,
13  `REASON` text,
14  `BANNER_STEAMID` text
15) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16 
17-- ----------------------------
18-- Table structure for cms_news
19-- ----------------------------
20DROP TABLE IF EXISTS `cms_news`;
21CREATE TABLE `cms_news` (
22  `date` date NOT NULL DEFAULT '0000-00-00',
23  `title` text,
24  `poster` text,
25  `news` text,
26  PRIMARY KEY (`date`)
27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28 
29-- ----------------------------
30-- Table structure for global_chat
31-- ----------------------------
32DROP TABLE IF EXISTS `global_chat`;
33CREATE TABLE `global_chat` (
34  `user_name` text,
35  `message` text,
36  `server_id` int(1) NOT NULL DEFAULT '0',
37  PRIMARY KEY (`server_id`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39 
40-- ----------------------------
41-- Table structure for rp_auth
42-- ----------------------------
43DROP TABLE IF EXISTS `rp_auth`;
44CREATE TABLE `rp_auth` (
45  `server` int(11) DEFAULT NULL,
46  `steamid` text NOT NULL,
47  PRIMARY KEY (`steamid`(40))
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49 
50-- ----------------------------
51-- Table structure for rp_items
52-- ----------------------------
53DROP TABLE IF EXISTS `rp_items`;
54CREATE TABLE `rp_items` (
55  `steamid` text,
56  `item_id` text,
57  `item_quantity` int(11) DEFAULT '0'
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59 
60-- ----------------------------
61-- Table structure for rp_lottery
62-- ----------------------------
63DROP TABLE IF EXISTS `rp_lottery`;
64CREATE TABLE `rp_lottery` (
65  `steamid` text,
66  `claimed` int(1) NOT NULL DEFAULT '0',
67  PRIMARY KEY (`claimed`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69 
70-- ----------------------------
71-- Table structure for rp_org
72-- ----------------------------
73DROP TABLE IF EXISTS `rp_org`;
74CREATE TABLE `rp_org` (
75  `id` int(11) NOT NULL AUTO_INCREMENT,
76  `owner_steamid` text,
77  `motd` text,
78  `name` text,
79  PRIMARY KEY (`id`)
80) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
81 
82-- ----------------------------
83-- Table structure for rp_system
84-- ----------------------------
85DROP TABLE IF EXISTS `rp_system`;
86CREATE TABLE `rp_system` (
87  `redownload_inventory` int(200) NOT NULL DEFAULT '0',
88  `cash_flow` text,
89  PRIMARY KEY (`redownload_inventory`)
90) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91 
92-- ----------------------------
93-- Table structure for rp_users
94-- ----------------------------
95DROP TABLE IF EXISTS `rp_users`;
96CREATE TABLE `rp_users` (
97  `steamid` text NOT NULL,
98  `name` text,
99  `money` int(255) DEFAULT '10000',
100  `org` text,
101  `blacklist` text,
102  `model` text,
103  `vehicles` text,
104  `vehicle_skins` text,
105  `time_played` text,
106  `free_points` int(3) DEFAULT '6',
107  `fat` text,
108  `skill_dexterity` text,
109  `skill_stamina` text,
110  `skill_intelligence` text,
111  `skill_strength` text,
112  `skill_craftiness` text,
113  `ammo_pistol` text,
114  `ammo_rifle` text,
115  `ammo_shotgun` text,
116  `bbcu` text,
117  `rank` int(11) DEFAULT '5',
118  PRIMARY KEY (`steamid`(40))
119) ENGINE=InnoDB DEFAULT CHARSET=latin1;
120 
121-- ----------------------------
122-- Table structure for site_blacklist
123-- ----------------------------
124DROP TABLE IF EXISTS `site_blacklist`;
125CREATE TABLE `site_blacklist` (
126  `IP` text,
127  `Why` text
128) ENGINE=InnoDB DEFAULT CHARSET=latin1;
129 
130-- ----------------------------
131-- Records
132-- ----------------------------
133----------------------------------------------VUAL-----------------------------------------------