· 6 years ago · Oct 06, 2019, 04:52 PM
1-- --------------------------------------------------------
2-- Host: 85.25.117.239
3-- Server version: 10.1.31-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for rockford
16CREATE DATABASE IF NOT EXISTS `rockford` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `rockford`;
18
19-- Dumping structure for table rockford.phone_app_chat
20CREATE TABLE IF NOT EXISTS `phone_app_chat` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `channel` varchar(20) NOT NULL,
23 `message` varchar(255) NOT NULL,
24 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
25 PRIMARY KEY (`id`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28-- Data exporting was unselected.
29
30-- Dumping structure for table rockford.phone_calls
31CREATE TABLE IF NOT EXISTS `phone_calls` (
32 `id` int(11) NOT NULL AUTO_INCREMENT,
33 `owner` varchar(10) NOT NULL COMMENT 'Num tel proprio',
34 `num` varchar(10) NOT NULL COMMENT 'Num reférence du contact',
35 `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
36 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
37 `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
38 PRIMARY KEY (`id`)
39) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
40
41-- Data exporting was unselected.
42
43-- Dumping structure for table rockford.phone_messages
44CREATE TABLE IF NOT EXISTS `phone_messages` (
45 `id` int(11) NOT NULL AUTO_INCREMENT,
46 `transmitter` varchar(10) NOT NULL,
47 `receiver` varchar(10) NOT NULL,
48 `message` varchar(255) NOT NULL DEFAULT '0',
49 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
50 `isRead` int(11) NOT NULL DEFAULT '0',
51 `owner` int(11) NOT NULL DEFAULT '0',
52 PRIMARY KEY (`id`)
53) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
54
55-- Data exporting was unselected.
56
57-- Dumping structure for table rockford.phone_users_contacts
58CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
59 `id` int(11) NOT NULL AUTO_INCREMENT,
60 `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
61 `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
62 `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1',
63 PRIMARY KEY (`id`)
64) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
65
66-- Data exporting was unselected.
67
68-- Dumping structure for table rockford.twitter_accounts
69CREATE TABLE IF NOT EXISTS `twitter_accounts` (
70 `id` int(11) NOT NULL AUTO_INCREMENT,
71 `username` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
72 `password` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
73 `avatar_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
74 PRIMARY KEY (`id`),
75 UNIQUE KEY `username` (`username`)
76) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
77
78-- Data exporting was unselected.
79
80-- Dumping structure for table rockford.twitter_likes
81CREATE TABLE IF NOT EXISTS `twitter_likes` (
82 `id` int(11) NOT NULL AUTO_INCREMENT,
83 `authorId` int(11) DEFAULT NULL,
84 `tweetId` int(11) DEFAULT NULL,
85 PRIMARY KEY (`id`),
86 KEY `FK_twitter_likes_twitter_accounts` (`authorId`),
87 KEY `FK_twitter_likes_twitter_tweets` (`tweetId`),
88 CONSTRAINT `FK_twitter_likes_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`),
89 CONSTRAINT `FK_twitter_likes_twitter_tweets` FOREIGN KEY (`tweetId`) REFERENCES `twitter_tweets` (`id`) ON DELETE CASCADE
90) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
91
92-- Data exporting was unselected.
93
94-- Dumping structure for table rockford.twitter_tweets
95CREATE TABLE IF NOT EXISTS `twitter_tweets` (
96 `id` int(11) NOT NULL AUTO_INCREMENT,
97 `authorId` int(11) NOT NULL,
98 `realUser` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
99 `message` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
100 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
101 `likes` int(11) NOT NULL DEFAULT '0',
102 PRIMARY KEY (`id`),
103 KEY `FK_twitter_tweets_twitter_accounts` (`authorId`),
104 CONSTRAINT `FK_twitter_tweets_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`)
105) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
106
107-- Data exporting was unselected.
108
109-- Dumping structure for table rockford.user_lastcharacter
110CREATE TABLE IF NOT EXISTS `user_lastcharacter` (
111 `steamid` varchar(255) NOT NULL,
112 `charid` int(11) NOT NULL
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114
115-- Data exporting was unselected.
116
117-- Dumping structure for table rockford.vehicles
118CREATE TABLE IF NOT EXISTS `vehicles` (
119 `cid` int(11) DEFAULT NULL,
120 `model` varchar(50) DEFAULT NULL,
121 `price` int(11) DEFAULT NULL,
122 `colour` int(11) DEFAULT NULL,
123 `scolour` int(11) DEFAULT NULL,
124 `wheels` int(11) DEFAULT NULL,
125 `windows` int(11) DEFAULT NULL,
126 `platetype` int(11) DEFAULT NULL,
127 `exhausts` int(11) DEFAULT NULL,
128 `grills` int(11) DEFAULT NULL,
129 `spoiler` int(11) DEFAULT NULL
130) ENGINE=InnoDB DEFAULT CHARSET=latin1;
131
132-- Data exporting was unselected.
133
134-- Dumping structure for table rockford.vrp_characters
135CREATE TABLE IF NOT EXISTS `vrp_characters` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `user_id` int(11) DEFAULT NULL,
138 PRIMARY KEY (`id`),
139 KEY `fk_characters_users` (`user_id`),
140 CONSTRAINT `fk_characters_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
141) ENGINE=InnoDB AUTO_INCREMENT=288 DEFAULT CHARSET=latin1;
142
143-- Data exporting was unselected.
144
145-- Dumping structure for table rockford.vrp_character_business
146CREATE TABLE IF NOT EXISTS `vrp_character_business` (
147 `character_id` int(11) NOT NULL,
148 `name` varchar(30) DEFAULT NULL,
149 `description` text,
150 `capital` int(11) DEFAULT NULL,
151 `laundered` int(11) DEFAULT NULL,
152 `reset_timestamp` int(11) DEFAULT NULL,
153 PRIMARY KEY (`character_id`),
154 CONSTRAINT `fk_character_business_characters` FOREIGN KEY (`character_id`) REFERENCES `vrp_characters` (`id`) ON DELETE CASCADE
155) ENGINE=InnoDB DEFAULT CHARSET=latin1;
156
157-- Data exporting was unselected.
158
159-- Dumping structure for table rockford.vrp_character_data
160CREATE TABLE IF NOT EXISTS `vrp_character_data` (
161 `character_id` int(11) NOT NULL,
162 `dkey` varchar(100) NOT NULL,
163 `dvalue` blob,
164 PRIMARY KEY (`character_id`,`dkey`),
165 CONSTRAINT `fk_character_data_characters` FOREIGN KEY (`character_id`) REFERENCES `vrp_characters` (`id`) ON DELETE CASCADE
166) ENGINE=InnoDB DEFAULT CHARSET=latin1;
167
168-- Data exporting was unselected.
169
170-- Dumping structure for table rockford.vrp_character_identities
171CREATE TABLE IF NOT EXISTS `vrp_character_identities` (
172 `character_id` int(11) NOT NULL,
173 `registration` varchar(20) DEFAULT NULL,
174 `phone` varchar(20) DEFAULT NULL,
175 `firstname` varchar(50) DEFAULT NULL,
176 `name` varchar(50) DEFAULT NULL,
177 `age` int(11) DEFAULT NULL,
178 PRIMARY KEY (`character_id`),
179 KEY `registration` (`registration`),
180 KEY `phone` (`phone`),
181 CONSTRAINT `fk_character_identities_characters` FOREIGN KEY (`character_id`) REFERENCES `vrp_characters` (`id`) ON DELETE CASCADE
182) ENGINE=InnoDB DEFAULT CHARSET=latin1;
183
184-- Data exporting was unselected.
185
186-- Dumping structure for table rockford.vrp_global_data
187CREATE TABLE IF NOT EXISTS `vrp_global_data` (
188 `dkey` varchar(100) NOT NULL,
189 `dvalue` blob,
190 PRIMARY KEY (`dkey`)
191) ENGINE=InnoDB DEFAULT CHARSET=latin1;
192
193-- Data exporting was unselected.
194
195-- Dumping structure for table rockford.vrp_server_data
196CREATE TABLE IF NOT EXISTS `vrp_server_data` (
197 `id` varchar(100) NOT NULL,
198 `dkey` varchar(100) NOT NULL,
199 `dvalue` blob,
200 PRIMARY KEY (`id`,`dkey`)
201) ENGINE=InnoDB DEFAULT CHARSET=latin1;
202
203-- Data exporting was unselected.
204
205-- Dumping structure for table rockford.vrp_users
206CREATE TABLE IF NOT EXISTS `vrp_users` (
207 `id` int(11) NOT NULL AUTO_INCREMENT,
208 `whitelisted` tinyint(1) DEFAULT NULL,
209 `banned` tinyint(1) DEFAULT NULL,
210 PRIMARY KEY (`id`)
211) ENGINE=InnoDB AUTO_INCREMENT=235 DEFAULT CHARSET=latin1;
212
213-- Data exporting was unselected.
214
215-- Dumping structure for table rockford.vrp_user_data
216CREATE TABLE IF NOT EXISTS `vrp_user_data` (
217 `user_id` int(11) NOT NULL,
218 `dkey` varchar(100) NOT NULL,
219 `dvalue` blob,
220 PRIMARY KEY (`user_id`,`dkey`),
221 CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
222) ENGINE=InnoDB DEFAULT CHARSET=latin1;
223
224-- Data exporting was unselected.
225
226-- Dumping structure for table rockford.vrp_user_ids
227CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
228 `identifier` varchar(100) NOT NULL,
229 `user_id` int(11) DEFAULT NULL,
230 PRIMARY KEY (`identifier`),
231 KEY `fk_user_ids_users` (`user_id`),
232 CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
233) ENGINE=InnoDB DEFAULT CHARSET=latin1;
234
235-- Data exporting was unselected.
236
237/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
238/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
239/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;