· 8 years ago · Aug 26, 2018, 02:38 AM
1[SQL] Query life start
2[ERR] 1046 - No database selected
3[ERR] -- --------------------------------------------------------
4-- Host: 37.187.248.84
5-- Server version: 5.6.20-log - MySQL Community Server (GPL)
6-- Server OS: Win64
7-- HeidiSQL Version: 8.3.0.4694
8-- --------------------------------------------------------
9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET NAMES utf8 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14
15-- Dumping database structure for life
16DROP DATABASE IF EXISTS `life`;
17
18-- Dumping structure for table life.gangs
19DROP TABLE IF EXISTS `gangs`;
20
21-- Dumping structure for table life.servers
22DROP TABLE IF EXISTS `servers`;
23CREATE TABLE IF NOT EXISTS `servers` (
24 `id` int(11) NOT NULL AUTO_INCREMENT,
25 `name` varchar(255) DEFAULT NULL,
26 `ip` varchar(55) DEFAULT NULL,
27 `port` varchar(10) DEFAULT NULL,
28 `password` varchar(255) DEFAULT NULL,
29 `status` varchar(5) DEFAULT NULL,
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
32
33-- Dumping data for table life.servers: ~0 rows (approximately)
34DELETE FROM `servers`;
35/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
36INSERT INTO `servers` (`id`, `name`, `ip`, `port`, `password`, `status`) VALUES
37 (1, 'EU #1 - ArmA 3 Life Official', '37.187.248.84', '2302', 'hannes101', '1'),
38 (2, 'US #1 - ArmA 3 Life Official', '192.99.18.123', '2302', 'hannes99', '1');
39/*!40000 ALTER TABLE `servers` ENABLE KEYS */;
40
41-- ----------------------------
42-- Table structure for usertable
43-- ----------------------------
44DROP TABLE IF EXISTS `usertable`;
45CREATE TABLE `usertable` (
46 `id` int(11) NOT NULL AUTO_INCREMENT,
47 `name` varchar(50) DEFAULT NULL,
48 `uid` varchar(50) DEFAULT NULL,
49 UNIQUE KEY `id` (`id`)
50) ENGINE=InnoDB AUTO_INCREMENT=2162 DEFAULT CHARSET=utf8;
51
52-- ----------------------------
53-- Records of usertable
54-- ----------------------------
55
56
57-- Dumping structure for table life.vehicles
58DROP TABLE IF EXISTS `vehicles`;
59CREATE TABLE IF NOT EXISTS `vehicles` (
60 `id` int(12) NOT NULL AUTO_INCREMENT,
61 `side` varchar(15) NOT NULL,
62 `classname` varchar(32) NOT NULL,
63 `type` varchar(12) NOT NULL,
64 `pid` varchar(32) NOT NULL,
65 `alive` tinyint(1) NOT NULL DEFAULT '1',
66 `active` tinyint(1) NOT NULL DEFAULT '0',
67 `plate` int(20) NOT NULL,
68 `color` int(20) NOT NULL,
69 `inventory` varchar(500) NOT NULL,
70 PRIMARY KEY (`id`),
71 KEY `side` (`side`),
72 KEY `pid` (`pid`),
73 KEY `type` (`type`)
74) ENGINE=InnoDB AUTO_INCREMENT=19690 DEFAULT CHARSET=latin1;
75
76-- Dumping data for table life.vehicles: ~8,072 rows (approximately)
77DELETE FROM `vehicles`;
78/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
79
80/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
81/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
82/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
84
85[SQL] Finished with error