· 8 years ago · Apr 21, 2018, 02:18 PM
1-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost Database: altislife
4-- ------------------------------------------------------
5-- Server version 5.7.21-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `containers`
20--
21
22DROP TABLE IF EXISTS `containers`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `containers` (
26 `id` int(6) NOT NULL AUTO_INCREMENT,
27 `pid` varchar(17) NOT NULL,
28 `classname` varchar(32) NOT NULL,
29 `pos` varchar(64) DEFAULT NULL,
30 `inventory` text NOT NULL,
31 `gear` text NOT NULL,
32 `dir` varchar(128) DEFAULT NULL,
33 `active` tinyint(1) NOT NULL DEFAULT '0',
34 `owned` tinyint(1) DEFAULT '0',
35 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
36 PRIMARY KEY (`id`,`pid`)
37) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `containers`
42--
43
44LOCK TABLES `containers` WRITE;
45/*!40000 ALTER TABLE `containers` DISABLE KEYS */;
46INSERT INTO `containers` VALUES (20,'76561198335710399','B_supplyCrate_F','[21782.7,20643.3,15.4115]','\"[[],0]\"','\"[[[`H_ShemagOpen_tan`,`V_HarnessOGL_brn`,`U_I_G_resistanceLeader_F`],[1,1,1]],[[`30Rnd_556x45_Stanag`,`30Rnd_9x21_Mag`],[5,2]],[[`hgun_PDW2000_F`],[2]],[[`B_Carryall_cbr`],[1]]]\"','[[0.00427246,-0.999991,0],[0,0,1]]',0,1,'2018-04-21 14:15:15');
47/*!40000 ALTER TABLE `containers` ENABLE KEYS */;
48UNLOCK TABLES;
49/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
50
51/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
52/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
53/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
54/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
55/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
56/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
57/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
58
59-- Dump completed on 2018-04-21 16:17:09