wZJv1wf6

1USE gta5_gamemode_essential;
2
3CREATE TABLE IF NOT EXISTS `jobs` (
4  `job_id` int(11) NOT NULL AUTO_INCREMENT,
5  `job_name` varchar(40) NOT NULL,
6  `salary` int(11) NOT NULL DEFAULT '500',
7  PRIMARY KEY (`job_id`)
8) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
9
10CREATE TABLE IF NOT EXISTS `users` (
11  `identifier` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
12  `group` varchar(50) NOT NULL DEFAULT '0',
13  `permission_level` int(11) NOT NULL DEFAULT '0',
14  `money` double NOT NULL DEFAULT '0',
15  `bankbalance` int(32) DEFAULT '0',
16  `job` int(11) DEFAULT '1',
17  `lastpos` varchar(255) DEFAULT '{-1044.99914550781,-2749.8173828125,21.3634204864502}',
18  `personalvehicle` varchar(60) DEFAULT NULL,
19  `isFirstConnection` int(11) DEFAULT '1',
20  `nom` varchar(128) NOT NULL DEFAULT '',
21  `prenom` varchar(128) NOT NULL DEFAULT '',
22  `dateNaissance` date DEFAULT '0000-01-01',
23  `sexe` varchar(1) NOT NULL DEFAULT 'f',
24  `taille` int(10) unsigned NOT NULL DEFAULT '0',
25  `enService` boolean NOT NULL DEFAULT FALSE
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28ALTER TABLE users ADD `JOB` int(11) DEFAULT '1';
29
30INSERT INTO `jobs` (`job_id`, `job_name`, `salary`) VALUES (11, 'Ambulancier', 1200);
31
32UPDATE users SET job = 11 WHERE identifier = 'steam:';
33
34ALTER TABLE users ADD `enService` boolean NOT NULL DEFAULT FALSE;