· 6 years ago · Aug 07, 2019, 07:40 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : Divi Gaming
5Source Server Version : 50505
6Source Host : 92.222.67.204:3306
7Source Database : Divi
8
9Target Server Type : MYSQL
10Target Server Version : 50505
11File Encoding : 65001
12
13Date: 2019-08-07 21:33:21
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for Userdata
20-- ----------------------------
21DROP TABLE IF EXISTS `Userdata`;
22CREATE TABLE `Userdata` (
23 `UID` int(11) NOT NULL AUTO_INCREMENT,
24 `Name` varchar(255) NOT NULL,
25 `Money` bigint(255) NOT NULL DEFAULT '350',
26 `Bankmoney` bigint(255) NOT NULL DEFAULT '500',
27 `Spawn_X` varchar(255) NOT NULL DEFAULT '1567.8955078125',
28 `Spawn_Y` varchar(255) NOT NULL DEFAULT '-1890.69921875',
29 `Spawn_Z` varchar(255) NOT NULL DEFAULT '13.559101104736',
30 `Spawn_Rot` varchar(255) NOT NULL DEFAULT '0',
31 `Spawn_Dim` varchar(255) NOT NULL DEFAULT '0',
32 `Spawn_Int` varchar(255) NOT NULL DEFAULT '0',
33 `Skin` smallint(6) NOT NULL DEFAULT '1',
34 `Adminlevel` int(255) NOT NULL DEFAULT '0',
35 `Playingtime` double(11,0) NOT NULL DEFAULT '0',
36 `LastLogin` longtext NOT NULL,
37 `Identitycard` smallint(6) NOT NULL DEFAULT '0',
38 `Faction` int(11) NOT NULL DEFAULT '0',
39 `Factionrang` int(11) NOT NULL DEFAULT '0',
40 `Companies` varchar(255) NOT NULL,
41 `Gang` varchar(255) NOT NULL DEFAULT '-',
42 `Hunger` int(11) NOT NULL DEFAULT '100',
43 `Number` int(11) NOT NULL,
44 `SocialState` varchar(255) NOT NULL,
45 `Wanteds` smallint(6) NOT NULL DEFAULT '0',
46 `Stvo` smallint(6) NOT NULL DEFAULT '0',
47 `Experience` bigint(20) NOT NULL DEFAULT '0',
48 `Level` bigint(20) NOT NULL DEFAULT '1',
49 `currentVehicle` int(11) NOT NULL DEFAULT '0',
50 `maxVehicle` int(11) NOT NULL DEFAULT '10',
51 `customSlot` tinyint(255) NOT NULL,
52 `LoggedIn` smallint(6) NOT NULL,
53 ‘blueprints’ varchar(256) NOT NULL DEFAULT '[ [ false, false, false, false, false, false, false, false, false, false, false, false, false, false, false ] ]'
54) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;