CREATE TABLE IF NOT EXISTS `vio`.`gang_vehicles` (
`GangID` INT( 4 ) NOT NULL ,
`Typ` INT( 3 ) NOT NULL DEFAULT '500',
`Tuning` VARCHAR( 50 ) NOT NULL DEFAULT '|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|',
`Spawnpos_X` FLOAT( 50 ) NOT NULL DEFAULT '0',
`Spawnpos_Y` FLOAT( 50 ) NOT NULL DEFAULT '0',
`Spawnpos_Z` FLOAT( 50 ) NOT NULL DEFAULT '0',
`Spawnrot_X` FLOAT( 50 ) NOT NULL DEFAULT '0',
`Spawnrot_Y` FLOAT( 50 ) NOT NULL DEFAULT '0',
`Spawnrot_Z` FLOAT( 50 ) NOT NULL DEFAULT '0',
`Farbe` VARCHAR( 50 ) NOT NULL DEFAULT '|0|0|0|0|',
`Paintjob` INT( 4 ) NOT NULL DEFAULT '0',
`Lights` VARCHAR( 13 ) NOT NULL DEFAULT '|255|255|255|'
) ENGINE = MYISAM ;

CREATE TABLE IF NOT EXISTS `vio`.`playingtime` (
  `Name` varchar(50) NOT NULL,
  `Time` int(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vio`.`gang_members` (
  `Name` varchar(50) NOT NULL,
  `Gang` int(4) NOT NULL DEFAULT '0',
  `Rang` int(2) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vio`.`gang_basic` (
  `Name` varchar(50) NOT NULL DEFAULT 'Def. Gang',
  `LeaderMSG` varchar(50) NOT NULL DEFAULT '',
  `Waffe` int(2) NOT NULL DEFAULT '0',
  `Skin` int(3) NOT NULL DEFAULT '7',
  `HausID` int(4) NOT NULL DEFAULT '0',
  `Rang1` varchar(50) NOT NULL DEFAULT 'Anfaenger',
  `Rang2` varchar(50) NOT NULL DEFAULT 'Mitglied',
  `Rang3` varchar(50) NOT NULL DEFAULT 'Anfuehrer',
  `MaxMembers` int(4) NOT NULL DEFAULT '8'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `vio`.`gunlicense` (
`Name` VARCHAR( 50 ) NOT NULL ,
`Time` INT( 20 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;

CREATE TABLE `vio_old`.`gunlicense` (
`Name` VARCHAR( 50 ) NOT NULL ,
`Time` INT( 20 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;

ALTER TABLE `vio`.`gangs` ADD `LastAttacked` INT( 20 ) NOT NULL DEFAULT '0'

ALTER TABLE `vio`.`bonustable` ADD `Schach` TINYINT( 1 ) NOT NULL DEFAULT '0'
ALTER TABLE `vio_old`.`bonustable` ADD `Schach` TINYINT( 1 ) NOT NULL DEFAULT '0'

INSERT INTO `vio`.`biz` (
`Biz` ,
`Inhaber` ,
`Kasse` ,
`Name` ,
`Preis`
)
VALUES ('Visage', 'none', '0', 'Visage Hotel', '10000000'), ('VankHoff', 'none', '0', 'Vank Hoff Hotel', '3000000');

-- http://www.phpmyadmin.net
--
-- Erstellungszeit: 26. Dezember 2010 um 20:58
-- Server Version: 5.1.41
-- PHP-Version: 5.3.1




--
-- Datenbank: `vio`
--

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

--
-- Tabellenstruktur für Tabelle `houses`
--

CREATE TABLE IF NOT EXISTS `houses` (
  `ID` int(11) NOT NULL,
  `SymbolX` double NOT NULL,
  `SymbolY` double NOT NULL,
  `SymbolZ` double NOT NULL,
  `Besitzer` varchar(50) NOT NULL,
  `Preis` int(11) NOT NULL,
  `Mindestzeit` int(11) NOT NULL,
  `CurrentInterior` int(11) NOT NULL,
  `Kasse` int(11) NOT NULL,
  `Miete` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `vio`.`houses` (`ID`, `SymbolX`, `SymbolY`, `SymbolZ`, `Besitzer`, `Preis`, `Mindestzeit`, `CurrentInterior`, `Kasse`, `Miete`) VALUES
(148, -2659.6962890625, 803.083984375, 49.9765625, 'none', 100000, 75, 4, 0, 0),
(149, -2685.044921875, 820.5185546875, 49.984375, 'none', 100000, 75, 5, 0, 0),
(150, -2563.1171875, 1149.1162109375, 55.7265625, 'none', 100000, 75, 4, 0, 0),
(151, -2900.7197265625, 1073.7763671875, 32.1328125, 'none', 75000, 50, 7, 0, 0),
(152, -2369.8935546875, 847.1103515625, 43.7890625, 'none', 157000, 100, 6, 0, 0),
(153, -2905.2578125, 1171.6455078125, 13.6640625, 'none', 75000, 50, 7, 0, 0),
(154, -2857.685546875, 957.0810546875, 44.0546875, 'none', 75000, 50, 7, 0, 0),
(155, -2860.740234375, 963.609375, 44.0546875, 'none', 75000, 50, 1, 0, 0),
(156, -2844.693359375, 921.2978515625, 44.0546875, 'none', 75000, 50, 1, 0, 0),
(157, -2843.220703125, 904.4736328125, 44.0546875, 'none', 75000, 50, 1, 0, 0),
(158, -2220.94921875, 99.875, 35.3203125, 'none', 75000, 50, 1, 0, 0),
(159, -2625.8642578125, 78.771484375, 7.203125, 'none', 250000, 150, 11, 0, 0),
(160, -2623.4296875, -99.337890625, 7.203125, 'none', 250000, 150, 11, 0, 0),
(161, -2725.7333984375, -92.4599609375, 7.203125, 'none', 275000, 150, 11, 0, 0),
(162, -2075.7568359375, -2312.7841796875, 31.13125038147, 'none', 350000, 150, 1, 0, 0),
(163, -2224.564453125, -2482.8828125, 31.816272735596, 'none', 250000, 150, 25, 0, 0),
(164, -2181.015625, -2519.98828125, 31.816270828247, 'none', 350000, 150, 25, 0, 0),
(165, 300.2001953125, 1141.1572265625, 9.1374855041504, 'none', 250000, 150, 1, 0, 0),
(166, 2373.4873046875, 1642.58984375, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(167, 2363.40234375, 1642.595703125, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(168, 2376.3408203125, 1682.8779296875, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(169, 2357.7431640625, 1653.83984375, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(170, 2357.75390625, 1669.3779296875, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(171, 2391.3486328125, 1682.8779296875, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(172, 2401.40625, 1682.875, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(173, 2357.7451171875, 1653.853515625, 14.281055450439, 'none', 30000, 30, 4, 0, 0),
(174, 2366.3154296875, 1682.87890625, 14.281055450439, 'none', 30000, 30, 4, 0, 0),
(175, 2517.03515625, 1674.2451171875, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(176, 2476.3134765625, 1682.869140625, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(177, 2496.36328125, 1682.8681640625, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(178, 2517.01953125, 1653.9091796875, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(179, 2503.498046875, 1643.5791015625, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(180, 2631.330078125, 1978.8408203125, 10.8203125, 'none', 30000, 30, 4, 0, 0),
(181, 2626.98828125, 2019.2138671875, 10.8203125, 'none', 30000, 30, 4, 0, 0),
(182, 2649.8779296875, 1978.83984375, 10.8203125, 'none', 30000, 30, 4, 0, 0),
(183, 2645.6044921875, 2019.2021484375, 10.816846847534, 'none', 30000, 30, 4, 0, 0),
(184, 2649.9072265625, 1978.83984375, 14.116060256958, 'none', 30000, 30, 4, 0, 0),
(185, 2633.1572265625, 1978.8466796875, 14.116060256958, 'none', 30000, 30, 4, 0, 0),
(186, 2634.5791015625, 2019.2041015625, 14.116060256958, 'none', 30000, 30, 4, 0, 0),
(187, 1967.3349609375, 2766.5439453125, 10.826543807983, 'none', 350000, 200, 10, 0, 0),
(188, 1992.5673828125, 2764.6357421875, 10.8203125, 'none', 500000, 250, 10, 0, 0),
(189, 2018.6494140625, 2766.5419921875, 10.826543807983, 'none', 350000, 200, 10, 0, 0),
(190, 2039.55859375, 2766.541015625, 10.826543807983, 'none', 350000, 200, 10, 0, 0),
(191, 2049.6025390625, 2764.2802734375, 10.8203125, 'none', 350000, 200, 10, 0, 0),
(192, 2018.1494140625, 2721.9443359375, 10.8203125, 'none', 250000, 200, 13, 0, 0);

ALTER TABLE `gang_basic`
ADD `Drugs` INT( 10 ) NOT NULL DEFAULT '0',
ADD `Mats` INT( 10 ) NOT NULL DEFAULT '0',
ADD `Money` INT( 10 ) NOT NULL DEFAULT '125000'