· 8 years ago · Aug 26, 2018, 08:48 PM
1[SQL] Query altislife start
2[ERR] 1044 - Access denied for user 'root'@'localhost' to database 'information_schema'
3[ERR] SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
4SET time_zone = "+00:00";
5--
6-- Compatible with newer MySQL versions. (After MySQL-5.5)
7-- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.
8--
9
10
11/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
12/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
13/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
14/*!40101 SET NAMES utf8mb4 */;
15-- --------------------------------------------------------
16
17--
18-- Table structure for table `players`
19--
20
21CREATE TABLE IF NOT EXISTS `players` (
22 `uid` int(6) NOT NULL AUTO_INCREMENT,
23 `name` varchar(32) NOT NULL,
24 `aliases` text NOT NULL,
25 `pid` varchar(17) NOT NULL,
26 `cash` int(100) NOT NULL DEFAULT '0',
27 `bankacc` int(100) NOT NULL DEFAULT '0',
28 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
29 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
30 `civ_licenses` text NOT NULL,
31 `cop_licenses` text NOT NULL,
32 `med_licenses` text NOT NULL,
33 `civ_gear` text NOT NULL,
34 `cop_gear` text NOT NULL,
35 `med_gear` text NOT NULL,
36 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
37 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
38 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
39 `arrested` tinyint(1) NOT NULL DEFAULT '0',
40 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
41 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
42 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
43 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
44 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
45 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
46 `insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
47 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
48 PRIMARY KEY (`uid`),
49 UNIQUE KEY `pid` (`pid`),
50 KEY `name` (`name`),
51 KEY `blacklist` (`blacklist`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=12 ;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `vehicles`
58--
59
60CREATE TABLE IF NOT EXISTS `vehicles` (
61 `id` int(6) NOT NULL AUTO_INCREMENT,
62 `side` varchar(16) NOT NULL,
63 `classname` varchar(64) NOT NULL,
64 `type` varchar(16) NOT NULL,
65 `pid` varchar(17) NOT NULL,
66 `alive` tinyint(1) NOT NULL DEFAULT '1',
67 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
68 `active` tinyint(1) NOT NULL DEFAULT '0',
69 `plate` int(20) NOT NULL,
70 `color` int(20) NOT NULL,
71 `inventory` text NOT NULL,
72 `gear` text NOT NULL,
73 `fuel` double NOT NULL DEFAULT '1',
74 `damage` varchar(256) NOT NULL,
75 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
76 PRIMARY KEY (`id`),
77 KEY `side` (`side`),
78 KEY `pid` (`pid`),
79 KEY `type` (`type`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;
81
82-- --------------------------------------------------------
83
84--
85-- Table structure for table `houses`
86-- Needed for extDB latest update on git
87--
88
89CREATE TABLE IF NOT EXISTS `houses` (
90 `id` int(6) NOT NULL AUTO_INCREMENT,
91 `pid` varchar(17) NOT NULL,
92 `pos` varchar(64) DEFAULT NULL,
93 `owned` tinyint(1) DEFAULT '0',
94 `garage` tinyint(1) NOT NULL DEFAULT '0',
95 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
96 PRIMARY KEY (`id`,`pid`)
97) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `gangs`
103-- Needed for extDB latest update on git
104--
105
106CREATE TABLE IF NOT EXISTS `gangs` (
107 `id` int(6) NOT NULL AUTO_INCREMENT,
108 `owner` varchar(32) DEFAULT NULL,
109 `name` varchar(32) DEFAULT NULL,
110 `members` text,
111 `maxmembers` int(3) DEFAULT '8',
112 `bank` int(100) DEFAULT '0',
113 `active` tinyint(1) DEFAULT '1',
114 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
115 PRIMARY KEY (`id`),
116 UNIQUE KEY `name_UNIQUE` (`name`)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
118
119-- --------------------------------------------------------
120
121--
122-- Table structure for table `containers`
123-- Needed for extDB latest update on git
124--
125
126CREATE TABLE IF NOT EXISTS `container
127[SQL] Finished with error