· 7 years ago · Sep 02, 2018, 03:54 PM
1-- --------------------------------------------------------
2-- Host: 79.133.48.75
3-- Server Version: 5.7.21-log - MySQL Community Server (GPL)
4-- Server Betriebssystem: Win64
5-- HeidiSQL Version: 9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Exportiere Struktur von Tabelle arma3life.entreprises
15CREATE TABLE IF NOT EXISTS `entreprises` (
16 `id` int(6) NOT NULL AUTO_INCREMENT,
17 `name` varchar(32) NOT NULL,
18 `pdg_pid` varchar(17) NOT NULL DEFAULT '0',
19 `pdg_name` varchar(32) NOT NULL,
20 `members` text NOT NULL,
21 `prices` text NOT NULL,
22 `items_stock` text NOT NULL,
23 `max_stock` int(3) NOT NULL DEFAULT '0',
24 `items_stock_2` text NOT NULL,
25 `max_stock_2` int(3) NOT NULL DEFAULT '0',
26 `bankacc` int(100) NOT NULL DEFAULT '0',
27 `position` varchar(32) DEFAULT NULL,
28 `objects` text NOT NULL,
29 `type` varchar(32) NOT NULL,
30 `active` tinyint(1) NOT NULL DEFAULT '1',
31 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
34
35-- Exportiere Daten aus Tabelle arma3life.entreprises: ~13 rows (ungefähr)
36/*!40000 ALTER TABLE `entreprises` DISABLE KEYS */;
37INSERT INTO `entreprises` (`id`, `name`, `pdg_pid`, `pdg_name`, `members`, `prices`, `items_stock`, `max_stock`, `items_stock_2`, `max_stock_2`, `bankacc`, `position`, `objects`, `type`, `active`, `insert_time`) VALUES
38 (1, 'Telefongesellschaft Weber Inc.', '76561197993837219', '[F06-10]Helmut Weber', '"[[`76561197993837219`,`[F06-10]Helmut Weber`,2]]"', '"[]"', '"[]"', 0, '"[]"', 0, 8161250, 'property4', '"[[`Land_InfoStand_V1_F`,[9360.57,6564.53,1.12277],[[-0.411685,0.911326,0],[0,0,1]]]]"', 'gewerbe', 1, '2018-05-10 20:20:37'),
39 (2, 'Rick Continentals', '76561198238408502', 'Rick sanchez', '"[[`76561198238408502`,`Rick sanchez`,2],[`76561197985560975`,`Dom Hobbs`,1],[`76561198072537789`,`Berkay Aygül`,1],[`76561198067039134`,`Alex Steiger`,1],[`76561198304436118`,`Andy Adair`,1],[`76561198157010713`,`Dimitrij Iwanow`,1],[`76561198070493718`,`Jason Cone`,1],[`76561198303499660`,`Kevin Steiger`,1]]"', '"[[`tbacon`,67309]]"', '"[]"', 100, '"[[`rabbit`,28],[`tbacon`,7],[`redgull`,2],[`moonshine`,13],[`beer`,16],[`ouzo`,8]]"', 150, 0, 'property9', '"[[`Land_InfoStand_V1_F`,[7984.79,5386.51,2.03126],[[0.641433,0.767179,0],[0,0,1]]],[`Land_InfoStand_V2_F`,[7990.57,5383.71,0.553322],[[0.632336,0.774694,0],[0,0,1]]],[`sp_marker`,[7999.32,5369.09,0],44.8001]]"', 'gewerbe', 1, '2018-05-10 20:21:22'),
40 (3, 'LackBude', '76561198161334416', 'Bob Lunarlander', '"[[`76561198161334416`,`Bob Lunarlander`,2],[`76561198272897457`,`Sebo Cordwell`,0],[`76561198042682640`,`Aiden McCunningham`,1],[`76561198040884164`,`Ipoi Locker`,0],[`76561198327112704`,`Akiyama Lee`,0],[`76561198095491404`,`Lukas Pray`,0]]"', '"[]"', '"[]"', 25, '"[]"', 25, 770300, 'property2', '"[[`sp_marker`,[8063.66,2557.97,0],123.29]]"', 'gewerbe', 1, '2018-05-10 20:43:37'),
41 (4, 'Lucky Shots', '76561198132565571', 'Lena Morrison', '"[[`76561198132565571`,`Lena Morrison`,2],[`76561198006275902`,`Thomas Kowalskie`,1],[`76561198112469300`,`Paul Kowalskie`,1],[`76561198146689096`,`Tyrone White`,0],[`76561198036036911`,`Jackson Scofield [BW]`,1],[`76561198061140494`,`David Hayter [BW]`,1],[`76561197975876114`,`Leon Striker`,1],[`76561198228877220`,`Angelo Schluz`,0],[`76561198134194577`,`Cassandra Martinez`,0],[`76561198160202964`,`Gus Silvester`,0]]"', '"[]"', '"[[`apple`,1]]"', 150, '"[[`apple`,1]]"', 75, 200382, 'property6', '"[[`Land_InfoStand_V1_F`,[9331.47,6651.69,1.43108],[[0.994483,-0.104894,0],[0,0,1]]],[`sp_marker`,[9328.57,6632.27,0],6.26703]]"', 'kleingewerbe', 1, '2018-05-10 23:37:05'),
42 (6, 'Malone Immobilien GmbH', '76561198052880468', 'Peter Malone', '"[[`76561198052880468`,`Peter Malone`,2],[`76561198058632913`,`Phil Lücker`,1]]"', '"[]"', '"[]"', 50, '"[]"', 0, 0, 'property12', '"[[`Land_InfoStand_V1_F`,[9143.56,6587.73,0.2995],[[0.101153,0.994871,0],[0,0,1]]],[`Land_InfoStand_V2_F`,[9127.59,6589.29,0.0211811],[[0.987863,-0.15533,0],[0,0,1]]],[`sp_marker`,[9121.71,6592.28,0],282.022]]"', 'nebengewerbe', 1, '2018-05-14 23:01:21'),
43 (7, 'Meep Meep', '76561198124990601', 'Tia O´Leary', '"[[`76561198124990601`,`Tia O´Leary`,2],[`76561198104723912`,`Ricardo Camillo`,1],[`76561198118563204`,`Phil De Vogel`,1],[`76561198142572845`,`Herbert Oemmel`,1]]"', '"[]"', '"[]"', 0, '"[]"', 0, 0, 'property7', '"[[`Land_InfoStand_V2_F`,[5029.73,1080.36,0.0211816],[[-0.943226,-0.332153,0],[0,0,1]]],[`sp_marker`,[5033.72,1083.44,0],252.844]]"', 'nebengewerbe', 1, '2018-05-15 17:35:35'),
44 (8, 'Kanzlei ClearWater ', '76561197962287149', 'Tyrell Murphy', '"[[`76561197962287149`,`Tyrell Murphy`,2]]"', '"[]"', '"[]"', 0, '"[]"', 0, 25000, NULL, '"[]"', 'nebengewerbe', 1, '2018-05-15 20:32:37'),
45 (9, 'Black Security GmbH', '76561198052746805', 'Argon Black', '"[[`76561198052746805`,`Argon Black`,2]]"', '"[]"', '"[]"', 50, '"[]"', 0, 530000, 'property13', '"[[`Land_InfoStand_V1_F`,[5307.14,3130.48,4.25247],[[0.884704,-0.466154,0],[0,0,1]]],[`sp_marker`,[5312.64,3126.68,0],211.34]]"', 'nebengewerbe', 1, '2018-05-16 18:55:57'),
46 (10, 'The Tribe', '76561198196555770', 'Sam Campell', '"[[`76561198196555770`,`Sam Campell`,2],[`76561197984999822`,`Morris Brown`,1],[`76561197997339214`,`Philipp Schreiber`,1]]"', '"[[`pickaxe`,0],[`toolkit`,0],[`fuelFull`,0],[`fuelEmpty`,0],[`gold`,0],[`goldbar`,0],[`redgull`,0],[`coffee`,0],[`waterBottle`,0],[`tbacon`,0],[`donuts`,0]]"', '"[[`toolkit`,5],[`redgull`,2],[`tbacon`,25]]"', 300, '"[]"', 150, 342000, 'property8', '"[[`Land_InfoStand_V1_F`,[4928.57,3006.79,-0.0229778],[[-0.0418703,0.999123,0],[0,0,1]]],[`Land_InfoStand_V2_F`,[4934,2985.98,0.573387],[[-0.659432,-0.751764,0],[0,0,1]]],[`sp_marker`,[4923.37,2990.83,0],145.699]]"', 'gewerbe', 1, '2018-05-18 15:24:03'),
47 (11, 'Firefighters Inn', '76561198181812057', 'Mamfred Puls', '"[[`76561198181812057`,`Mamfred Puls`,2]]"', '"[[`apple`,1]]"', '"[]"', 75, '"[]"', 0, 0, NULL, '"[]"', 'kleingewerbe', 0, '2018-05-18 19:32:22'),
48 (12, 'Li´s Asia Wok', '76561198175463793', 'Martin Li', '"[[`76561198175463793`,`Martin Li`,2],[`76561198141354093`,`Imortek Kaneki`,1],[`76561198258072819`,`Kerstin Jamar`,1],[`76561198130450999`,`Shaun Miller [LCN]`,0]]"', '"[[`cocaine_processed`,0]]"', '"[[`cocaine_processed`,47]]"', 50, '"[]"', 0, 31, 'property11', '"[[`Land_InfoStand_V1_F`,[9477.42,7049.38,-0.134724],[[-0.419172,-0.907907,0],[0,0,1]]],[`sp_marker`,[9463.96,7062.18,0],297.981]]"', 'nebengewerbe', 1, '2018-05-25 18:34:41'),
49 (13, 'Bet at Lakeside', '76561198142373984', 'Richard von Schöneberg', '"[[`76561198142373984`,`Richard von Schöneberg`,2],[`76561198062886347`,`Billy Vega`,1],[`76561198071363806`,`Juà n Antònio Reyes`,1],[`76561198011455319`,`Martinez Raûl Tico Reyes`,1],[`76561198169802281`,`Kurt Kretschma`,1]]"', '"[]"', '"[]"', 0, '"[]"', 0, 1653027, NULL, '"[]"', 'gewerbe', 1, '2018-08-08 05:38:52'),
50 (15, 'Logistik Kaiser GmbH', '76561198099770323', 'Hector Kaiser', '"[[`76561198099770323`,`Hector Kaiser`,2]]"', '"[]"', '"[]"', 0, '"[]"', 0, 10003, NULL, '"[]"', 'kleingewerbe', 1, '2018-09-02 13:22:05');
51/*!40000 ALTER TABLE `entreprises` ENABLE KEYS */;
52
53/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
54/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;