LFnDkJT9

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8mb4 */;
8
9
10CREATE TABLE IF NOT EXISTS `phone_app_chat` (
11  `id` int(11) NOT NULL,
12  `channel` varchar(20) NOT NULL,
13  `message` varchar(255) NOT NULL,
14  `time` timestamp NOT NULL DEFAULT current_timestamp()
15) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16
17CREATE TABLE IF NOT EXISTS `phone_calls` (
18  `id` int(11) NOT NULL,
19  `owner` varchar(10) NOT NULL COMMENT 'Num tel proprio',
20  `num` varchar(10) NOT NULL COMMENT 'Num reférence du contact',
21  `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
22  `time` timestamp NOT NULL DEFAULT current_timestamp(),
23  `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas'
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
26CREATE TABLE IF NOT EXISTS `phone_messages` (
27  `id` int(11) NOT NULL,
28  `transmitter` varchar(10) NOT NULL,
29  `receiver` varchar(10) NOT NULL,
30  `message` varchar(255) NOT NULL DEFAULT '0',
31  `time` timestamp NOT NULL DEFAULT current_timestamp(),
32  `isRead` int(11) NOT NULL DEFAULT 0,
33  `owner` int(11) NOT NULL DEFAULT 0
34) ENGINE=MyISAM DEFAULT CHARSET=utf8;
35
36CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
37  `id` int(11) NOT NULL,
38  `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
39  `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
40  `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1'
41) ENGINE=MyISAM DEFAULT CHARSET=utf8;
42
43CREATE TABLE IF NOT EXISTS `ples_logs` (
44  `id` int(11) NOT NULL,
45  `user_id` int(11) NOT NULL,
46  `name` varchar(50) NOT NULL DEFAULT 'Unknown',
47  `action` int(5) NOT NULL DEFAULT 0,
48  `text` varchar(300) DEFAULT NULL,
49  `time` timestamp NOT NULL DEFAULT current_timestamp()
50) ENGINE=InnoDB DEFAULT CHARSET=latin1;
51
52CREATE TABLE IF NOT EXISTS `times` (
53  `identifier` varchar(100) NOT NULL,
54  `Seconds` int(10) NOT NULL,
55  `Minutes` int(10) NOT NULL,
56  `Hours` int(10) NOT NULL,
57  `Days` int(10) NOT NULL
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60CREATE TABLE IF NOT EXISTS `vrp_business` (
61  `id` int(255) NOT NULL,
62  `x` float NOT NULL,
63  `y` float NOT NULL,
64  `z` float NOT NULL,
65  `bizName` text CHARACTER SET latin1 NOT NULL,
66  `bizDescription` text CHARACTER SET latin1 NOT NULL,
67  `bizPrice` int(255) NOT NULL DEFAULT 0,
68  `bizType` text CHARACTER SET latin1 NOT NULL,
69  `bizCashier` bigint(255) NOT NULL DEFAULT 0,
70  `bizSupplies` int(255) NOT NULL DEFAULT 75,
71  `bizOwner` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
72  `bizOwnerID` int(255) NOT NULL,
73  `bizForSale` int(255) NOT NULL DEFAULT 0,
74  `bizSalePrice` int(255) NOT NULL,
75  `bizStrikes` int(255) NOT NULL DEFAULT 0,
76  `bizImunity` int(255) NOT NULL DEFAULT 0
77) ENGINE=InnoDB DEFAULT CHARSET=utf8;
78
79CREATE TABLE IF NOT EXISTS `vrp_giftbox` (
80  `user_id` int(255) NOT NULL,
81  `giftbox` int(255) NOT NULL
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83
84CREATE TABLE IF NOT EXISTS `vrp_srv_data` (
85  `dkey` varchar(100) NOT NULL,
86  `dvalue` text DEFAULT NULL
87) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88
89CREATE TABLE IF NOT EXISTS `vrp_turfs` (
90  `id` int(255) NOT NULL,
91  `x` float NOT NULL,
92  `y` float NOT NULL,
93  `z` float NOT NULL,
94  `radius` float NOT NULL,
95  `blipColor` int(255) NOT NULL,
96  `faction` text NOT NULL,
97  `locatie` text DEFAULT NULL
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99
100CREATE TABLE IF NOT EXISTS `vrp_users` (
101  `id` int(11) NOT NULL,
102  `last_login` varchar(100) DEFAULT NULL,
103  `whitelisted` tinyint(1) DEFAULT NULL,
104  `banned` tinyint(1) DEFAULT NULL,
105  `DmvTest` varchar(50) NOT NULL DEFAULT 'Required',
106  `GunLicense` varchar(55) NOT NULL DEFAULT 'Required',
107  `CarInsurance` varchar(55) NOT NULL DEFAULT 'No',
108  `aJailTime` int(255) NOT NULL DEFAULT 0,
109  `aJailReason` text DEFAULT NULL,
110  `raport` int(30) DEFAULT 0
111) ENGINE=InnoDB DEFAULT CHARSET=latin1;
112
113CREATE TABLE IF NOT EXISTS `vrp_user_data` (
114  `user_id` int(11) NOT NULL,
115  `dkey` varchar(100) NOT NULL,
116  `dvalue` text DEFAULT NULL
117) ENGINE=InnoDB DEFAULT CHARSET=latin1;
118
119CREATE TABLE IF NOT EXISTS `vrp_user_homes` (
120  `user_id` int(11) NOT NULL DEFAULT 0,
121  `home` varchar(100) DEFAULT NULL,
122  `number` int(11) DEFAULT NULL
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124
125CREATE TABLE IF NOT EXISTS `vrp_user_identities` (
126  `user_id` int(11) NOT NULL DEFAULT 0,
127  `registration` varchar(100) DEFAULT NULL,
128  `phone` varchar(100) DEFAULT NULL,
129  `firstname` varchar(100) DEFAULT NULL,
130  `name` varchar(100) DEFAULT NULL,
131  `age` int(11) DEFAULT NULL
132) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133
134CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
135  `identifier` varchar(100) NOT NULL,
136  `user_id` int(11) DEFAULT NULL
137) ENGINE=InnoDB DEFAULT CHARSET=latin1;
138
139CREATE TABLE IF NOT EXISTS `vrp_user_moneys` (
140  `user_id` int(11) NOT NULL DEFAULT 0,
141  `wallet` int(255) DEFAULT NULL,
142  `bank` int(11) DEFAULT NULL,
143  `adminPoints` int(255) NOT NULL DEFAULT 0
144) ENGINE=InnoDB DEFAULT CHARSET=latin1;
145
146CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
147  `user_id` int(11) NOT NULL DEFAULT 0,
148  `impounded` int(11) NOT NULL DEFAULT 0,
149  `stage` int(11) NOT NULL DEFAULT 0,
150  `vehicle` varchar(100) NOT NULL DEFAULT '',
151  `upgrades` text DEFAULT NULL,
152  `vehicle_plate` varchar(255) NOT NULL,
153  `veh_type` varchar(255) NOT NULL DEFAULT 'default'
154) ENGINE=InnoDB DEFAULT CHARSET=latin1;
155
156
157ALTER TABLE `phone_app_chat`
158  ADD PRIMARY KEY (`id`);
159
160ALTER TABLE `phone_calls`
161  ADD PRIMARY KEY (`id`);
162
163ALTER TABLE `phone_messages`
164  ADD PRIMARY KEY (`id`);
165
166ALTER TABLE `phone_users_contacts`
167  ADD PRIMARY KEY (`id`);
168
169ALTER TABLE `ples_logs`
170  ADD PRIMARY KEY (`id`);
171
172ALTER TABLE `times`
173  ADD PRIMARY KEY (`identifier`);
174
175ALTER TABLE `vrp_business`
176  ADD PRIMARY KEY (`id`);
177
178ALTER TABLE `vrp_giftbox`
179  ADD PRIMARY KEY (`user_id`);
180
181ALTER TABLE `vrp_srv_data`
182  ADD PRIMARY KEY (`dkey`);
183
184ALTER TABLE `vrp_turfs`
185  ADD PRIMARY KEY (`id`);
186
187ALTER TABLE `vrp_users`
188  ADD PRIMARY KEY (`id`);
189
190ALTER TABLE `vrp_user_data`
191  ADD PRIMARY KEY (`user_id`,`dkey`);
192
193ALTER TABLE `vrp_user_homes`
194  ADD PRIMARY KEY (`user_id`),
195  ADD UNIQUE KEY `home` (`home`,`number`);
196
197ALTER TABLE `vrp_user_identities`
198  ADD PRIMARY KEY (`user_id`),
199  ADD KEY `registration` (`registration`),
200  ADD KEY `phone` (`phone`);
201
202ALTER TABLE `vrp_user_ids`
203  ADD PRIMARY KEY (`identifier`),
204  ADD KEY `fk_user_ids_users` (`user_id`);
205
206ALTER TABLE `vrp_user_moneys`
207  ADD PRIMARY KEY (`user_id`);
208
209ALTER TABLE `vrp_user_vehicles`
210  ADD PRIMARY KEY (`user_id`,`vehicle`);
211
212
213ALTER TABLE `phone_app_chat`
214  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
215ALTER TABLE `phone_calls`
216  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
217ALTER TABLE `phone_messages`
218  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
219ALTER TABLE `phone_users_contacts`
220  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
221ALTER TABLE `ples_logs`
222  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
223ALTER TABLE `vrp_business`
224  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;
225ALTER TABLE `vrp_users`
226  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
227
228ALTER TABLE `vrp_user_data`
229  ADD CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
230
231ALTER TABLE `vrp_user_homes`
232  ADD CONSTRAINT `fk_user_homes_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
233
234ALTER TABLE `vrp_user_identities`
235  ADD CONSTRAINT `fk_user_identities_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
236
237ALTER TABLE `vrp_user_ids`
238  ADD CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
239
240ALTER TABLE `vrp_user_moneys`
241  ADD CONSTRAINT `fk_user_moneys_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
242
243ALTER TABLE `vrp_user_vehicles`
244  ADD CONSTRAINT `fk_user_vehicles_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
245
246/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
247/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
248/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;