-- phpMyAdmin SQL Dump
-- version 4.1.6
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Erstellungszeit: 03. Jul 2014 um 12:21
-- Server Version: 5.6.16
-- PHP-Version: 5.5.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `arma3life`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `homes`
--

CREATE TABLE IF NOT EXISTS `homes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` text NOT NULL,
  `price` int(10) unsigned NOT NULL DEFAULT '100000',
  `home_group` text NOT NULL,
  `name` text,
  `marker_spawn` text NOT NULL,
  `marker_car_spawn` text NOT NULL,
  `inventory` text NOT NULL,
  `real_item_inventory` text NOT NULL,
  `owned` tinyint(1) NOT NULL DEFAULT '0',
  `price_sell` int(11) NOT NULL DEFAULT '2000',
  `inventory_weight` int(11) NOT NULL DEFAULT '600',
  `ownername` text NOT NULL,
  `inventory_maxweight` int(11) NOT NULL DEFAULT '1200',
  `upgrade_safe` tinyint(1) NOT NULL DEFAULT '0',
  `safe_inventory` text NOT NULL,
  `trustedpersons` text NOT NULL,
  `buyable` tinyint(1) NOT NULL DEFAULT '1',
  `donator` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=118 ;

--
-- Daten für Tabelle `homes`
--

INSERT INTO `homes` (`id`, `owner`, `price`, `home_group`, `name`, `marker_spawn`, `marker_car_spawn`, `inventory`,`real_item_inventory`, `owned`, `price_sell`, `inventory_weight`, `ownername`, `inventory_maxweight`, `upgrade_safe`, `safe_inventory`, `trustedpersons`, `buyable`, `donator`) VALUES
(1, '76561197960421692', 2000000, 'KAVALA', 'house_01', 'house_01_spawn', 'house_01_car_spawn', '"[["money",297011]]"','"[[],[],[],[],[],[],[]]"', 1, 2000, 555, 'Cifon', 1200, 0, '"[]"', '"[]"', 1, 0),
(2, ' ', 2000000, 'KAVALA', 'house_02', 'house_02_spawn', 'house_02_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(3, ' ', 2000000, 'KAVALA', 'house_03', 'house_03_spawn', 'house_03_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(4, ' ', 2000000, 'KAVALA', 'house_04', 'house_04_spawn', 'house_04_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(5, ' ', 2000000, 'KAVALA', 'house_05', 'house_05_spawn', 'house_05_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"',0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(6, ' ', 2000000, 'KAVALA', 'house_06', 'house_06_spawn', 'house_06_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(7, ' ', 2000000, 'KAVALA', 'house_07', 'house_07_spawn', 'house_07_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(8, '76561198009924275', 2000000, 'KAVALA', 'house_08', 'house_08_spawn', 'house_08_car_spawn', '"[["money",3]]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(9, '76561198009924275', 3000000, 'KAVALA', 'house_09', 'house_09_spawn', 'house_09_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 700, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(10, '76561198009924275', 3000000, 'KAVALA', 'house_10', 'house_10_spawn', 'house_10_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(11, ' ', 3000000, 'KAVALA', 'house_11', 'house_11_spawn', 'house_11_car_spawn', '"[]"', 0, 500000, 100,'"[[],[],[],[],[],[],[]]"', ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(12, '76561198012583829', 3000000, 'KAVALA', 'house_12', 'house_12_spawn', 'house_12_car_spawn', '"[["money",3e+006]]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 100, 'phoenic', 1200, 0, '"[]"', '"[]"', 1, 0),
(13, '76561198009924275', 3000000, 'KAVALA', 'house_13', 'house_13_spawn', 'house_13_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(14, '76561198009924275', 3000000, 'KAVALA', 'house_14', 'house_14_spawn', 'house_14_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(15, '76561197965456523', 3000000, 'KAVALA', 'house_15', 'house_15_spawn', 'house_15_car_spawn', '"[["furniture_01",0],["furniture_02",0],["furniture_03",0],["furniture_04",0],["furniture_05",0]]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 700, 'Gorki', 1200, 0, '"[]"', '"[]"', 1, 0),
(16, '76561198009924275', 3000000, 'KAVALA', 'house_16', 'house_16_spawn', 'house_16_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(17, '76561198009924275', 3000000, 'KAVALA', 'house_17', 'house_17_spawn', 'house_17_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 500000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(18, ' ', 3000000, 'KAVALA', 'house_18', 'house_18_spawn', 'house_18_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 500000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(19, ' ', 3000000, 'KAVALA', 'house_19', 'house_19_spawn', 'house_19_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 500000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(20, ' ', 3000000, 'KAVALA', 'house_20', 'house_20_spawn', 'house_20_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 500000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(21, ' ', 3000000, 'KAVALA', 'house_21', 'house_21_spawn', 'house_21_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 500000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(22, ' ', 3000000, 'KAVALA', 'house_22', 'house_22_spawn', 'house_22_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 500000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(23, ' ', 2000000, 'SE SOFIA', 'house_23', 'house_23_spawn', 'house_23_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(24, ' ', 2000000, 'SE SOFIA', 'house_24', 'house_24_spawn', 'house_24_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(25, ' ', 2000000, 'KAVALA', 'house_26', 'house_26_spawn', 'house_26_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(26, ' ', 2000000, 'DP4', 'house_26', 'house_26_spawn', 'house_26_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 2000, 100, ' ', 1200, 0, '"[]"', '"[]"', 0, 1),
(27, ' ', 3000000, 'DP4', 'house_27', 'house_27_spawn', 'house_27_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(28, ' ', 3000000, 'HEROFELD', 'house_28', 'house_28_spawn', 'house_28_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 2000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(29, ' ', 2000000, 'KAVALA', 'house_29', 'house_29_spawn', 'house_29_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 2000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(30, ' ', 2000000, 'KAVALA', 'house_30', 'house_30_spawn', 'house_30_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 2000, 100, 'Cifon', 1200, 0, '"[]"', '"[]"', 1, 0),
(31, ' ', 3000000, 'Syrta', 'house_31', 'house_31_spawn', 'house_31_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 2000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(32, ' ', 3000000, 'KAVALA', 'house_32', 'house_32_spawn', 'house_32_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(33, ' ', 2000000, 'KAVALA', 'house_33', 'house_33_spawn', 'house_33_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(34, ' ', 2000000, 'KAVALA', 'house_34', 'house_34_spawn', 'house_34_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(35, ' ', 2000000, 'KAVALA', 'house_35', 'house_35_spawn', 'house_35_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(36, ' ', 2000000, 'KAVALA', 'house_36', 'house_36_spawn', 'house_36_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(37, ' ', 2000000, 'KAVALA', 'house_37', 'house_37_spawn', 'house_37_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(38, '76561198009924275', 2000000, 'KAVALA', 'house_38', 'house_38_spawn', 'house_38_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(39, '76561198009924275', 2000000, 'KAVALA', 'house_39', 'house_39_spawn', 'house_39_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(40, '76561198009924275', 2000000, 'KAVALA', 'house_40', 'house_40_spawn', 'house_40_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(41, '76561198009924275', 2000000, 'KAVALA', 'house_41', 'house_41_spawn', 'house_41_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(42, '76561198009924275', 2000000, 'KAVALA', 'house_42', 'house_42_spawn', 'house_42_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(43, ' ', 2000000, 'KAVALA', 'house_43', 'house_43_spawn', 'house_43_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(44, ' ', 2000000, 'KAVALA', 'house_44', 'house_44_spawn', 'house_44_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(45, ' ', 2000000, 'KAVALA', 'house_45', 'house_45_spawn', 'house_45_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(46, '76561198009924275', 2000000, 'KAVALA', 'house_46', 'house_46_spawn', 'house_46_car_spawn','"[[],[],[],[],[],[],[]]"', '"[]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(47, ' ', 2000000, 'KAVALA', 'house_47', 'house_47_spawn', 'house_47_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(48, '76561197960421692', 2000000, 'KAVALA', 'house_48', 'house_48_spawn', 'house_48_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'Cifon', 1200, 0, '"[]"', '"[]"', 1, 0),
(49, '76561198012583829', 2000000, 'KAVALA', 'house_49', 'house_49_spawn', 'house_49_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'phoenic', 1200, 0, '"[]"', '"[]"', 1, 0),
(50, ' ', 2000000, 'KAVALA', 'house_50', 'house_50_spawn', 'house_50_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(54, ' ', 2000000, 'ATHIRA', 'house_54', 'house_54_spawn', 'house_54_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(55, ' ', 2000000, 'ATHIRA', 'house_55', 'house_55_spawn', 'house_55_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(56, '76561198009924275', 2000000, 'ATHIRA', 'house_56', 'house_56_spawn', 'house_56_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'HODOR', 1200, 0, '"[]"', '"[]"', 1, 0),
(57, ' ', 2000000, 'ATHIRA', 'house_57', 'house_57_spawn', 'house_57_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(58, ' ', 2000000, 'ATHIRA', 'house_58', 'house_58_spawn', 'house_58_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(59, ' ', 2000000, 'ATHIRA', 'house_59', 'house_59_spawn', 'house_59_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(60, ' ', 3000000, 'ATHIRA', 'house_60', 'house_60_spawn', 'house_60_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(61, '76561198007650853', 3000000, 'ATHIRA', 'house_61', 'house_61_spawn', 'house_61_car_spawn', '"[["money",200000]]"', 1, 250000, 100, '[GSG] Duke', 1200, 0, '"[]"', '"[["76561198009924275","HODOR"]]"', 1, 0),
(62, ' ', 3000000, 'ATHIRA', 'house_62', 'house_62_spawn', 'house_62_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(63, ' ', 3000000, 'ATHIRA', 'house_63', 'house_63_spawn', 'house_63_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(64, ' ', 3000000, 'ATHIRA', 'house_64', 'house_64_spawn', 'house_64_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(91, '76561198057416294', 2000000, 'SOVIA', 'house_91', 'house_91_spawn', 'house_91_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 1, 250000, 100, 'Das Sams', 1200, 0, '"[]"', '"[]"', 1, 0),
(92, ' ', 2000000, 'SOVIA', 'house_92', 'house_92_spawn', 'house_92_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(93, ' ', 2000000, 'SOVIA', 'house_93', 'house_93_spawn', 'house_93_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(94, ' ', 2000000, 'SOVIA', 'house_94', 'house_94_spawn', 'house_94_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(95, ' ', 2000000, 'SOVIA', 'house_95', 'house_95_spawn', 'house_95_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(96, ' ', 2000000, 'SOVIA', 'house_96', 'house_96_spawn', 'house_96_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(97, ' ', 3000000, 'SOVIA', 'house_97', 'house_97_spawn', 'house_97_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(98, ' ', 3000000, 'SOVIA', 'house_98', 'house_98_spawn', 'house_98_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(99, ' ', 2000000, 'SOVIA', 'house_99', 'house_99_spawn', 'house_99_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(100, ' ', 2000000, 'SOVIA', 'house_100', 'house_100_spawn', 'house_100_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(101, ' ', 2000000, 'SOVIA', 'house_101', 'house_101_spawn', 'house_101_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(102, ' ', 2000000, 'SOVIA', 'house_102', 'house_102_spawn', 'house_102_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0),
(103, ' ', 2000000, 'SOVIA', 'house_103', 'house_103_spawn', 'house_103_car_spawn', '"[]"','"[[],[],[],[],[],[],[]]"', 0, 250000, 100, ' ', 1200, 0, '"[]"', '"[]"', 1, 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;