· 8 years ago · Apr 13, 2018, 05:26 PM
1
2CREATE TABLE IF NOT EXISTS `players` (
3 `uid` varchar(64) NOT NULL,
4 `profileName` varchar(32) NOT NULL,
5 `RP_firstname` varchar(32) DEFAULT NULL,
6 `RP_lastname` varchar(32) DEFAULT NULL,
7 `RP_birth` text,
8 `RP_nationality` varchar(32) DEFAULT NULL,
9 `RP_sexe` varchar(32) DEFAULT NULL,
10 `DYN_markers` text NOT NULL,
11 `LEVEL_donator` enum('2','1','0') NOT NULL DEFAULT '0',
12 `HEALTH_blood` int(3) NOT NULL DEFAULT '4000',
13 `HEALTH_bleed` int(3) NOT NULL DEFAULT '0',
14 `HEALTH_coma` tinyint(1) NOT NULL DEFAULT '0',
15 `POS_x` int(50) NOT NULL DEFAULT '0',
16 `POS_y` int(50) NOT NULL DEFAULT '0',
17 `POS_z` int(50) NOT NULL DEFAULT '0',
18 `POS_alive` int(50) NOT NULL DEFAULT '0',
19 `HEALTH_deseases` varchar(100) NOT NULL DEFAULT '[[],[],[]]',
20 `HEALTH_hunger` int(50) NOT NULL DEFAULT '100',
21 `HEALTH_thirst` int(50) NOT NULL DEFAULT '100',
22 `WEST_level` varchar(2) NOT NULL DEFAULT '0',
23 `GUER_level` varchar(2) NOT NULL DEFAULT '0',
24 `EAST_level` varchar(2) NOT NULL DEFAULT '0',
25 `CIV_level` varchar(2) NOT NULL DEFAULT '1',
26 `JAIL_prison` text,
27 `JAIL_cell` text,
28 `JAIL_time` int(50) DEFAULT NULL,
29 `JAIL_caution` text,
30 `JAIL_reason` text,
31 `JAIL_escape` tinyint(1) NOT NULL DEFAULT '0',
32 `JAIL_gear` text,
33 `PHONE_number` varchar(50) DEFAULT NULL,
34 `PHONE_contacts` varchar(100) DEFAULT NULL,
35 `PHONE_messages` varchar(100) DEFAULT NULL,
36 `PHONE_forfait` varchar(10) DEFAULT NULL,
37 `PHONE_blacklist` varchar(100) DEFAULT NULL,
38 `TABLET_apps` text,
39 `RP_face` varchar(32) DEFAULT NULL,
40 `HEALTH_alcool` int(50) DEFAULT '0',
41 `HEALTH_hurt` int(50) DEFAULT '100',
42 `PHONE_annuaire` varchar(150) NOT NULL DEFAULT '"[]"',
43 `CIV_licenses` text,
44 `CIV_cash` int(50) DEFAULT '0',
45 `CIV_atm` int(50) DEFAULT '15000',
46 `CIV_inventory` text,
47 `CIV_gear` text,
48 `EAST_licenses` text,
49 `EAST_cash` int(50) DEFAULT '0',
50 `EAST_atm` int(50) DEFAULT '15000',
51 `EAST_inventory` text,
52 `EAST_gear` text,
53 `WEST_licenses` text,
54 `WEST_cash` int(50) NOT NULL DEFAULT '0',
55 `WEST_atm` int(50) NOT NULL DEFAULT '50000',
56 `WEST_inventory` text,
57 `WEST_gear` text,
58 `GUER_licenses` text,
59 `GUER_cash` int(50) NOT NULL DEFAULT '0',
60 `GUER_atm` int(50) NOT NULL DEFAULT '50000',
61 `GUER_inventory` text,
62 `GUER_gear` text,
63 `HEALTH_fatigue` int(1) DEFAULT '0'
64) ENGINE=InnoDB DEFAULT CHARSET=utf8;
65
66--
67-- Contenu de la table `players`
68--
69
70INSERT INTO `players` (`uid`, `profileName`, `RP_firstname`, `RP_lastname`, `RP_birth`, `RP_nationality`, `RP_sexe`, `DYN_markers`, `LEVEL_donator`, `HEALTH_blood`, `HEALTH_bleed`, `HEALTH_coma`, `POS_x`, `POS_y`, `POS_z`, `POS_alive`, `HEALTH_deseases`, `HEALTH_hunger`, `HEALTH_thirst`, `WEST_level`, `GUER_level`, `EAST_level`, `CIV_level`, `JAIL_prison`, `JAIL_cell`, `JAIL_time`, `JAIL_caution`, `JAIL_reason`, `JAIL_escape`, `JAIL_gear`, `PHONE_number`, `PHONE_contacts`, `PHONE_messages`, `PHONE_forfait`, `PHONE_blacklist`, `TABLET_apps`, `RP_face`, `HEALTH_alcool`, `HEALTH_hurt`, `PHONE_annuaire`, `CIV_licenses`, `CIV_cash`, `CIV_atm`, `CIV_inventory`, `CIV_gear`, `EAST_licenses`, `EAST_cash`, `EAST_atm`, `EAST_inventory`, `EAST_gear`, `WEST_licenses`, `WEST_cash`, `WEST_atm`, `WEST_inventory`, `WEST_gear`, `GUER_licenses`, `GUER_cash`, `GUER_atm`, `GUER_inventory`, `GUER_gear`, `HEALTH_fatigue`) VALUES
71('76561197978113679', 'Raymond Vanderflutten', 'Raymond', 'Vanderflutten', '"[19,8,1992]"', 'France', 'Homme', '"[]"', '0', 4000, 0, 0, 0, 0, 0, 0, '"[[],[],[]]"', 100, 100, '0', '0', '0', '1', NULL, NULL, NULL, NULL, NULL, 0, '"[]"', NULL, '"[]"', '"[]"', NULL, '"[]"', '"[]"', 'asczHead_austin_A3', 0, 100, '"[]"', '"[]"', 2000, 15000, '"[]"', '"[]"', '"[]"', 0, 15000, '"[]"', '"[]"', '"[]"', 0, 50000, '"[]"', '"[]"', '"[]"', 0, 50000, '"[]"', '"[]"', 0);