· 7 years ago · Sep 10, 2018, 06:54 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.5.25 - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL version: 7.0.0.4053
6-- Date/time: 2012-07-12 18:35:09
7-- --------------------------------------------------------
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
12
13-- Dumping structure for table myrpg.c_randomnames
14CREATE TABLE IF NOT EXISTS `c_randomnames` (
15 `type` int(11) NOT NULL,
16 `name` varchar(45) NOT NULL
17) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Nomes aleatórios para registro.';
18
19-- Dumping data for table myrpg.c_randomnames: ~0 rows (approximately)
20/*!40000 ALTER TABLE `c_randomnames` DISABLE KEYS */;
21/*!40000 ALTER TABLE `c_randomnames` ENABLE KEYS */;
22
23
24-- Dumping structure for table myrpg.faction_flag_info
25CREATE TABLE IF NOT EXISTS `faction_flag_info` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `factionid` int(11) NOT NULL DEFAULT '0',
28 `index` int(3) NOT NULL DEFAULT '0' COMMENT 'De 1 até 31. (limite de 32bits para flags)',
29 `name` varchar(64) NOT NULL DEFAULT 'Nada',
30 PRIMARY KEY (`id`),
31 UNIQUE KEY `index` (`index`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Tabela para permissões, ou "departamentos".';
33
34-- Dumping data for table myrpg.faction_flag_info: ~0 rows (approximately)
35/*!40000 ALTER TABLE `faction_flag_info` DISABLE KEYS */;
36/*!40000 ALTER TABLE `faction_flag_info` ENABLE KEYS */;
37
38
39-- Dumping structure for table myrpg.faction_info
40CREATE TABLE IF NOT EXISTS `faction_info` (
41 `id` int(11) NOT NULL AUTO_INCREMENT,
42 `name` varchar(64) NOT NULL DEFAULT 'Civil',
43 `type` int(11) NOT NULL DEFAULT '0',
44 `bank` int(11) NOT NULL DEFAULT '0',
45 `x` double NOT NULL DEFAULT '0',
46 `y` double NOT NULL DEFAULT '0',
47 `z` double NOT NULL DEFAULT '0',
48 `rank1` varchar(64) NOT NULL DEFAULT 'Civil',
49 `rank2` varchar(64) NOT NULL DEFAULT 'Civil',
50 `rank3` varchar(64) NOT NULL DEFAULT 'Civil',
51 `rank4` varchar(64) NOT NULL DEFAULT 'Civil',
52 `rank5` varchar(64) NOT NULL DEFAULT 'Civil',
53 `rank6` varchar(64) NOT NULL DEFAULT 'Civil',
54 `rank7` varchar(64) NOT NULL DEFAULT 'Civil',
55 `rank8` varchar(64) NOT NULL DEFAULT 'Civil',
56 `rank9` varchar(64) NOT NULL DEFAULT 'Civil',
57 `rank10` varchar(64) NOT NULL DEFAULT 'Civil',
58 PRIMARY KEY (`id`),
59 UNIQUE KEY `id` (`id`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Infos from the Families';
61
62-- Dumping data for table myrpg.faction_info: ~0 rows (approximately)
63/*!40000 ALTER TABLE `faction_info` DISABLE KEYS */;
64/*!40000 ALTER TABLE `faction_info` ENABLE KEYS */;
65
66
67-- Dumping structure for table myrpg.inventory_info
68CREATE TABLE IF NOT EXISTS `inventory_info` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `pid` int(11) NOT NULL DEFAULT '0',
71 `item` int(11) NOT NULL DEFAULT '0',
72 `info` int(11) NOT NULL DEFAULT '0',
73 `slot` int(11) NOT NULL DEFAULT '0' COMMENT 'Isto basicamente seria o slot especial. Os itens que tem como slot 0, serão exibidos normalmente em sua ordem.',
74 PRIMARY KEY (`id`),
75 UNIQUE KEY `id` (`id`)
76) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Infos from the Families';
77
78-- Dumping data for table myrpg.inventory_info: ~0 rows (approximately)
79/*!40000 ALTER TABLE `inventory_info` DISABLE KEYS */;
80/*!40000 ALTER TABLE `inventory_info` ENABLE KEYS */;
81
82
83-- Dumping structure for table myrpg.player_info
84CREATE TABLE IF NOT EXISTS `player_info` (
85 `id` int(10) NOT NULL AUTO_INCREMENT,
86 `name` varchar(25) NOT NULL,
87 `charname` varchar(64) NOT NULL,
88 `password` varchar(129) NOT NULL,
89 `attrib` int(11) NOT NULL DEFAULT '0',
90 `skin` int(11) NOT NULL DEFAULT '167',
91 `level` int(11) NOT NULL DEFAULT '1',
92 `exp` int(11) NOT NULL DEFAULT '0',
93 `cash` int(11) NOT NULL DEFAULT '5000',
94 `money` int(11) NOT NULL DEFAULT '10000',
95 `paycheck` int(11) NOT NULL DEFAULT '255',
96 `savings` int(11) NOT NULL DEFAULT '0',
97 `family` int(11) NOT NULL DEFAULT '0',
98 `familyrank` int(11) NOT NULL DEFAULT '0',
99 `familyjoin` int(11) NOT NULL DEFAULT '0',
100 `job` int(11) NOT NULL DEFAULT '0',
101 `jobrank` int(11) NOT NULL DEFAULT '0',
102 `jobtime` int(11) NOT NULL DEFAULT '0',
103 `spawn` int(10) NOT NULL DEFAULT '0',
104 `backpack` int(10) NOT NULL DEFAULT '1',
105 `autoreload` int(1) NOT NULL DEFAULT '1',
106 `sex` int(1) NOT NULL,
107 PRIMARY KEY (`id`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Infos from players';
109
110-- Dumping data for table myrpg.player_info: ~0 rows (approximately)
111/*!40000 ALTER TABLE `player_info` DISABLE KEYS */;
112/*!40000 ALTER TABLE `player_info` ENABLE KEYS */;
113
114
115-- Dumping structure for table myrpg.property_info
116CREATE TABLE IF NOT EXISTS `property_info` (
117 `id` int(11) NOT NULL AUTO_INCREMENT,
118 `attrib` int(11) NOT NULL DEFAULT '0',
119 `type` int(11) NOT NULL DEFAULT '0',
120 `level` int(11) NOT NULL DEFAULT '0',
121 `price` int(11) NOT NULL DEFAULT '0',
122 `ext_x` double NOT NULL DEFAULT '0',
123 `ext_y` double NOT NULL DEFAULT '0',
124 `ext_z` double NOT NULL DEFAULT '0',
125 `ext_prop` double NOT NULL DEFAULT '0',
126 `int_x` double NOT NULL DEFAULT '0',
127 `int_y` double NOT NULL DEFAULT '0',
128 `int_z` double NOT NULL DEFAULT '0',
129 `int_int` double NOT NULL DEFAULT '0',
130 `owner` int(11) NOT NULL DEFAULT '0',
131 `locked` tinyint(4) NOT NULL DEFAULT '0',
132 `name` varchar(32) NOT NULL DEFAULT '',
133 `motd` varchar(100) NOT NULL DEFAULT 'Bem-vindo à propriedade!',
134 PRIMARY KEY (`id`),
135 UNIQUE KEY `id` (`id`)
136) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Infos from the Families';
137
138-- Dumping data for table myrpg.property_info: ~0 rows (approximately)
139/*!40000 ALTER TABLE `property_info` DISABLE KEYS */;
140/*!40000 ALTER TABLE `property_info` ENABLE KEYS */;
141
142
143-- Dumping structure for table myrpg.property_inv_info
144CREATE TABLE IF NOT EXISTS `property_inv_info` (
145 `id` int(10) NOT NULL AUTO_INCREMENT,
146 `prop` int(10) NOT NULL DEFAULT '0',
147 `item` int(10) NOT NULL DEFAULT '0',
148 `info` int(10) NOT NULL DEFAULT '0',
149 PRIMARY KEY (`id`)
150) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Produtos/Componentes para empresas/casas';
151
152-- Dumping data for table myrpg.property_inv_info: ~0 rows (approximately)
153/*!40000 ALTER TABLE `property_inv_info` DISABLE KEYS */;
154/*!40000 ALTER TABLE `property_inv_info` ENABLE KEYS */;
155
156
157-- Dumping structure for table myrpg.record_info
158CREATE TABLE IF NOT EXISTS `record_info` (
159 `id` int(11) NOT NULL AUTO_INCREMENT,
160 `pid` int(11) NOT NULL DEFAULT '0',
161 `type` int(11) NOT NULL DEFAULT '0',
162 `stamp` int(10) NOT NULL DEFAULT '0',
163 `reason` varchar(255) NOT NULL DEFAULT 'Sem motivo',
164 `time` int(11) NOT NULL DEFAULT '0',
165 `admin` int(11) NOT NULL DEFAULT '0',
166 `lifted` int(2) NOT NULL DEFAULT '0',
167 `liftadmin` int(11) NOT NULL DEFAULT '0',
168 `liftreason` varchar(255) NOT NULL DEFAULT '',
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB DEFAULT CHARSET=latin1;
171
172-- Dumping data for table myrpg.record_info: ~0 rows (approximately)
173/*!40000 ALTER TABLE `record_info` DISABLE KEYS */;
174/*!40000 ALTER TABLE `record_info` ENABLE KEYS */;
175
176
177-- Dumping structure for table myrpg.session_info
178CREATE TABLE IF NOT EXISTS `session_info` (
179 `id` int(11) NOT NULL,
180 `pid` int(11) NOT NULL,
181 `ip` varchar(16) NOT NULL,
182 `host` varchar(255) NOT NULL,
183 `serial` varchar(128) NOT NULL,
184 `login` int(11) NOT NULL,
185 `logout` int(11) NOT NULL,
186 PRIMARY KEY (`id`)
187) ENGINE=InnoDB DEFAULT CHARSET=utf8;
188
189-- Dumping data for table myrpg.session_info: ~0 rows (approximately)
190/*!40000 ALTER TABLE `session_info` DISABLE KEYS */;
191/*!40000 ALTER TABLE `session_info` ENABLE KEYS */;
192
193
194-- Dumping structure for table myrpg.vehicle_info
195CREATE TABLE IF NOT EXISTS `vehicle_info` (
196 `id` int(10) NOT NULL AUTO_INCREMENT,
197 `type` int(10) NOT NULL DEFAULT '0',
198 `owner` int(10) NOT NULL DEFAULT '0',
199 `model` int(10) NOT NULL DEFAULT '0',
200 `color1` int(10) NOT NULL DEFAULT '0',
201 `color2` int(10) NOT NULL DEFAULT '0',
202 `insurances` int(10) NOT NULL DEFAULT '0',
203 `timesdestroyed` int(10) NOT NULL DEFAULT '0',
204 `paintjob` int(10) NOT NULL DEFAULT '0',
205 `damage` double NOT NULL DEFAULT '0',
206 `damage_panels` int(11) NOT NULL DEFAULT '0',
207 `damage_doors` int(11) NOT NULL DEFAULT '0',
208 `damage_lights` int(11) NOT NULL DEFAULT '0',
209 `damage_tires` int(11) NOT NULL DEFAULT '0',
210 `gas` double NOT NULL DEFAULT '0',
211 `x` double NOT NULL DEFAULT '0',
212 `y` double NOT NULL DEFAULT '0',
213 `z` double NOT NULL DEFAULT '0',
214 `rz` double NOT NULL DEFAULT '0',
215 `prop` int(11) NOT NULL DEFAULT '0',
216 `permission` int(11) NOT NULL DEFAULT '0',
217 `plate` varchar(50) NOT NULL DEFAULT '0',
218 PRIMARY KEY (`id`)
219) ENGINE=InnoDB DEFAULT CHARSET=latin1;
220
221-- Dumping data for table myrpg.vehicle_info: ~0 rows (approximately)
222/*!40000 ALTER TABLE `vehicle_info` DISABLE KEYS */;
223/*!40000 ALTER TABLE `vehicle_info` ENABLE KEYS */;
224/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
225/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;