· 6 years ago · Sep 09, 2019, 10:42 PM
1-- MySQL dump 10.16 Distrib 10.1.31-MariaDB, for debian-linux-gnu (x86_64)
2--
3-- Host: mysql-mariadb-5-101.zap-hosting.com Database: zap420998-1
4-- ------------------------------------------------------
5-- Server version 10.1.38-MariaDB-1~jessie
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 `addon_account`
20--
21
22DROP TABLE IF EXISTS `addon_account`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `addon_account` (
26 `name` varchar(60) NOT NULL,
27 `label` varchar(255) NOT NULL,
28 `shared` int(11) NOT NULL,
29 PRIMARY KEY (`name`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `addon_account`
35--
36
37LOCK TABLES `addon_account` WRITE;
38/*!40000 ALTER TABLE `addon_account` DISABLE KEYS */;
39INSERT INTO `addon_account` VALUES ('bank_savings','Bank Savings',0),('caution','caution',0),('property_black_money','Argent Sale Propriété',0),('society_ambulance','Ambulance',1),('society_banker','Banker',1),('society_cardealer','Cardealer',1),('society_mechanic','Mechanic',1),('society_police','Police',1),('society_realestateagent','Agent immobilier',1),('society_taxi','Taxi',1);
40/*!40000 ALTER TABLE `addon_account` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `addon_account_data`
45--
46
47DROP TABLE IF EXISTS `addon_account_data`;
48/*!40101 SET @saved_cs_client = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `addon_account_data` (
51 `id` int(11) NOT NULL AUTO_INCREMENT,
52 `account_name` varchar(255) DEFAULT NULL,
53 `money` double NOT NULL,
54 `owner` varchar(255) DEFAULT NULL,
55 PRIMARY KEY (`id`),
56 KEY `owner` (`owner`)
57) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `addon_account_data`
62--
63
64LOCK TABLES `addon_account_data` WRITE;
65/*!40000 ALTER TABLE `addon_account_data` DISABLE KEYS */;
66INSERT INTO `addon_account_data` VALUES (1,'society_ambulance',0,NULL),(2,'society_banker',0,NULL),(3,'society_cardealer',0,NULL),(4,'society_police',0,NULL),(5,'society_realestateagent',0,NULL),(6,'society_taxi',0,NULL),(10,'society_mechanic',0,NULL),(11,'caution',0,'steam:11000010959c0b0'),(12,'bank_savings',0,'steam:11000010959c0b0'),(13,'property_black_money',0,'steam:11000010959c0b0'),(14,'caution',0,'steam:11000011a2a5073'),(15,'property_black_money',0,'steam:11000011a2a5073'),(16,'bank_savings',0,'steam:11000011a2a5073'),(17,'caution',0,'steam:110000114b853e6'),(18,'bank_savings',0,'steam:110000114b853e6'),(19,'property_black_money',0,'steam:110000114b853e6'),(20,'bank_savings',0,'steam:11000013361c805'),(21,'property_black_money',0,'steam:11000013361c805'),(22,'caution',0,'steam:11000013361c805');
67/*!40000 ALTER TABLE `addon_account_data` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `addon_inventory`
72--
73
74DROP TABLE IF EXISTS `addon_inventory`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!40101 SET character_set_client = utf8 */;
77CREATE TABLE `addon_inventory` (
78 `name` varchar(60) NOT NULL,
79 `label` varchar(255) NOT NULL,
80 `shared` int(11) NOT NULL,
81 PRIMARY KEY (`name`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Dumping data for table `addon_inventory`
87--