CREATE TABLE IF NOT EXISTS `vms_adminblacklist` (
  `tan` varchar(32) NOT NULL,
  `time` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_aktivierungen` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `ak` varchar(32) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_bettel_buchung` (
`id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `refferer` text NOT NULL,
  `betrag` double(10,2) NOT NULL,
  `zeit` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `vms_bilanz` (
  `id` int(11) NOT NULL,
  `datum` int(11) NOT NULL,
  `ein` double(100,2) NOT NULL,
  `aus` double(100,2) NOT NULL,
  `gruppe` text NOT NULL,
  `name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `vms_bilanz`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_bilanz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

CREATE TABLE IF NOT EXISTS `vms_box_admin` (
`id` int(11) NOT NULL,
  `name` text NOT NULL,
  `ordnung` int(11) NOT NULL DEFAULT '1',
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

INSERT INTO `vms_box_admin` (`id`, `name`, `ordnung`, `status`) VALUES
(4, 'Usersystem', 3, 1),
(5, 'Newssystem', 4, 1),
(6, 'Konfigurationen', 5, 1),
(7, 'Texte bearbeiten', 6, 1),
(8, 'Werbung ein.', 7, 1),
(9, 'Interfacebanner', 8, 1),
(10, 'CMS', 10, 1);

CREATE TABLE IF NOT EXISTS `vms_box_user` (
`id` int(11) NOT NULL,
  `name` text NOT NULL,
  `ordnung` int(11) NOT NULL DEFAULT '1',
  `sichtbar` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

INSERT INTO `vms_box_user` (`id`, `name`, `ordnung`, `sichtbar`) VALUES
(6, 'Navigation', 1, 3),
(7, 'Verdienen', 2, 3);

CREATE TABLE IF NOT EXISTS `vms_buchungen` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `buchungszeit` int(10) NOT NULL DEFAULT '0',
  `buchungs_id` varchar(14) NOT NULL DEFAULT '',
  `buchungsmenge` double(11,2) NOT NULL DEFAULT '0.00',
  `verwendungszweck` varchar(40) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_chat` (
`id` int(11) NOT NULL,
  `absender` text NOT NULL,
  `nachricht` longtext NOT NULL,
  `time` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO `vms_chat` (`id`, `absender`, `nachricht`, `time`) VALUES
(8, '1', '', 1458122676),
(9, '1', 'Hallo du da', 1458123078);

CREATE TABLE IF NOT EXISTS `vms_chat_einstellungen` (
`id` int(11) NOT NULL,
  `chat_aktiv` int(11) NOT NULL,
  `hintergrundfarbe` text NOT NULL,
  `textfarbe` text NOT NULL,
  `profillink` text NOT NULL,
  `anzahl` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `vms_chat_einstellungen` (`id`, `chat_aktiv`, `hintergrundfarbe`, `textfarbe`, `profillink`, `anzahl`) VALUES
(1, 2, '#000000', '#FFFFFF', '#FF6600', 100);

CREATE TABLE IF NOT EXISTS `vms_cms_seiten` (
`id` int(11) NOT NULL,
  `titel` text NOT NULL,
  `text` longtext NOT NULL,
  `sichtbar` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_crons` (
`id` int(11) NOT NULL,
  `cron` varchar(50) NOT NULL DEFAULT '',
  `laufzeit` int(11) NOT NULL DEFAULT '0',
  `datei` varchar(250) NOT NULL DEFAULT '',
  `bezeichnung` varchar(250) NOT NULL DEFAULT ''
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `vms_crons` (`id`, `cron`, `laufzeit`, `datei`, `bezeichnung`) VALUES
(1, 'ext_cron', 0, 'crons/refzahlungen.knt.php', 'Ext. Refzahlungen'),
(2, 'framebrecher', 0, 'crons/framebrecherdown.php', 'Adscan.de Cron'),
(3, 'fakecheck', 0, 'crons/fakecheck.php', 'Einmal pro Tag laufen lassen zur festlegeung ab wieviel Klicks Fakecheck gemacht wird.'),
(4, 'DB-Backup', 0, 'crons/db_backup.php', 'Datenbank Backup erstellen');

CREATE TABLE IF NOT EXISTS `vms_emaildaten` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `emailadresse` varchar(100) NOT NULL DEFAULT '',
  `freigabe_fuer` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `vms_emaildaten` (`uid`, `emailadresse`, `freigabe_fuer`) VALUES
(1, 'e-mail@mail.de', 1);

CREATE TABLE IF NOT EXISTS `vms_fakecheck` (
  `fc_klicks` varchar(255) NOT NULL,
  `fake_schluessel` text NOT NULL,
  `zahl_von` int(11) NOT NULL,
  `zahl_bis` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vms_fakecheck` (`fc_klicks`, `fake_schluessel`, `zahl_von`, `zahl_bis`) VALUES
('93', '', 80, 100);

CREATE TABLE IF NOT EXISTS `vms_fb_blacklist` (
  `sponsor` varchar(255) NOT NULL,
  `kid` int(10) NOT NULL,
  `grund` tinyint(1) NOT NULL,
  `werbeart` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_gebuchte_werbung` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `tan` varchar(32) NOT NULL DEFAULT '',
  `kid` int(11) NOT NULL DEFAULT '0',
  `ziel` varchar(250) NOT NULL DEFAULT '',
  `banner` varchar(250) NOT NULL DEFAULT '',
  `verdienst` double(10,2) NOT NULL DEFAULT '0.00',
  `preis` double(10,2) NOT NULL DEFAULT '0.00',
  `aufendhalt` int(11) NOT NULL DEFAULT '0',
  `menge` int(11) NOT NULL DEFAULT '0',
  `reload` int(11) NOT NULL DEFAULT '0',
  `sponsor` varchar(25) NOT NULL DEFAULT '',
  `werbeart` varchar(50) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_geburtstag` (
  `geb_mail` int(11) NOT NULL,
  `geb_hoehe` double(100,2) NOT NULL,
  `geb_text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vms_geburtstag` (`geb_mail`, `geb_hoehe`, `geb_text`) VALUES
(1, 100.00, 'Hallo du da');

CREATE TABLE IF NOT EXISTS `vms_interface` (
  `interface` varchar(50) NOT NULL DEFAULT '',
  `betreiber` int(7) NOT NULL DEFAULT '0',
  `seite` int(7) NOT NULL DEFAULT '0',
  `pass` varchar(50) NOT NULL DEFAULT '',
  `eigenverdienst` int(2) NOT NULL DEFAULT '0',
  `mindestverguetung` double(8,6) NOT NULL DEFAULT '0.000000',
  `restklicks` int(4) NOT NULL DEFAULT '0',
  `umrechnung` double(10,4) NOT NULL DEFAULT '0.0000',
  `aufendhalt` int(3) NOT NULL DEFAULT '0',
  `surfview` double(10,2) NOT NULL DEFAULT '0.00',
  `surfklick` double(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_kontodaten` (
`uid` int(7) NOT NULL,
  `passwort` char(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `hinweis` longtext NOT NULL,
  `kontostand` double(100,2) NOT NULL DEFAULT '0.00',
  `login_ip` varchar(15) NOT NULL DEFAULT '',
  `loginzeit` int(11) NOT NULL DEFAULT '0',
  `last_active` int(11) NOT NULL DEFAULT '0',
  `klicks` bigint(20) NOT NULL DEFAULT '0',
  `kv` double(100,2) NOT NULL DEFAULT '0.00',
  `angebettelt` bigint(20) NOT NULL DEFAULT '0',
  `bv` double(100,2) NOT NULL DEFAULT '0.00',
  `bettel_sperre` int(11) NOT NULL DEFAULT '0',
  `forced_sperre` int(11) NOT NULL DEFAULT '0',
  `fc_klicks` int(100) NOT NULL,
  `fc_trys` int(10) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `vms_kontodaten` (`uid`, `passwort`, `status`, `hinweis`, `kontostand`, `login_ip`, `loginzeit`, `last_active`, `klicks`, `kv`, `angebettelt`, `bv`, `bettel_sperre`, `forced_sperre`, `fc_klicks`, `fc_trys`) VALUES
(1, '0659c7992e268962384eb17fafe88364', 1, '', 719.44, '192.168.0.14', 1460018904, 1460018904, 0, 0.00, 4, 709.44, 0, 1, 0, 0);

CREATE TABLE IF NOT EXISTS `vms_links_user` (
  `link` text NOT NULL,
  `name` text NOT NULL,
  `box` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_menu_admin` (
`id` int(11) NOT NULL,
  `link` text NOT NULL,
  `name` text NOT NULL,
  `ordnung` double(10,2) NOT NULL,
  `box` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

INSERT INTO `vms_menu_admin` (`id`, `link`, `name`, `ordnung`, `box`) VALUES
(1, 'usersystem/liste', 'Userliste', 1.00, 4),
(2, 'usersystem/doppelaccis', 'Doppelaccounts', 1.10, 4),
(3, 'usersystem/RefSchleifen', 'Refschleifen', 1.20, 4),
(4, 'newssystem/news', 'News schreiben', 1.00, 5),
(5, 'interfacedaten/pageconfig', 'Grundeinstellungen', 1.00, 6),
(6, 'interfacedaten/crons', 'Crons', 1.10, 6),
(7, 'interfacedaten/betreiber', 'Betreiberdaten', 1.20, 6),
(8, 'phpinfo', 'PHPInfo', 1.21, 6),
(9, 'interfacedaten/boxen_user', 'Boxverwaltung User', 1.30, 6),
(10, 'interfacedaten/boxen_admin', 'Boxverwaltung Admin', 1.31, 6),
(11, 'interfacedaten/menue_user', 'Menüverwaltung User', 1.40, 6),
(12, 'interfacedaten/menue_admin', 'Menüverwaltung Admin', 1.41, 6),
(13, 'texte/alternativwerbung', 'Alternativwerbung', 1.00, 7),
(14, 'texte/agb', 'AGB', 2.00, 7),
(15, 'texte/faq', 'FAQ', 3.00, 7),
(16, 'texte/wartung', 'Wartungstext', 4.00, 7),
(17, 'werbesystem/forcedbanner_468', 'Forced 468', 1.00, 8),
(18, 'werbesystem/paidmail', 'Paidmails verschicken', 2.00, 8),
(19, 'werbesystem/paidmail_hist', 'Paidmail History', 3.00, 8),
(20, 'interfacebanner/admin', 'Adminbanner', 1.00, 9),
(21, 'interfacebanner/blacklist', 'Blacklist', 2.00, 9),
(26, 'interfacedaten/chat_einstellungen', 'Chat Einstellungen', 1.22, 6),
(27, 'cms/neue_seite', 'Neue Seite erstellen', 1.00, 11),
(28, 'cms/bearbeiten_seite', 'Seiten bearbeiten', 2.00, 11),
(29, 'interfacedaten/fackecheck', 'Google Fackecheck', 1.50, 6),
(30, 'texte/startseite', 'Startseitentext', 5.00, 7),
(31, 'buchungen', 'User-Buchungen', 1.30, 4),
(32, 'interfacedaten/db_backup', 'Datenbank Backup', 1.51, 6);

CREATE TABLE IF NOT EXISTS `vms_menu_user` (
`id` int(11) NOT NULL,
  `link` text NOT NULL,
  `name` text NOT NULL,
  `ordnung` double(10,2) NOT NULL,
  `box` int(11) NOT NULL,
  `cms_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

INSERT INTO `vms_menu_user` (`id`, `link`, `name`, `ordnung`, `box`, `cms_id`) VALUES
(5, 'konto/uebersicht', 'Kontoübersicht', 1.00, 6, 0),
(6, 'konto/einzahlen', 'Einzahlen', 1.21, 6, 0),
(7, 'konto/auszahlen', 'Auszahlen', 1.20, 6, 0),
(8, 'konto/buchungen', 'Buchungen', 1.30, 6, 0),
(9, 'konto/refuebersicht', 'Refübersicht', 1.40, 6, 0),
(10, 'konto/userprofil', 'Userprofil', 1.50, 6, 0),
(11, 'intern/startseite&logout=true', 'Logout', 2.00, 6, 0),
(12, 'verdienen/forcedbanner', 'Forcedbanner', 1.00, 7, 0),
(13, 'verdienen/betteln4', 'Betteln4Lose', 1.10, 7, 0),
(14, 'verdienen/paidmails', 'Paidmails', 1.20, 7, 0),
(15, 'framebrecher', 'Framebrecher', 1.00, 8, 0);

CREATE TABLE IF NOT EXISTS `vms_multi_konten` (
  `uid` int(1) unsigned NOT NULL,
  `kontoid` varchar(32) NOT NULL,
  `waehrung` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_news` (
`id` int(11) NOT NULL,
  `zeit` int(11) NOT NULL DEFAULT '0',
  `titel` varchar(60) NOT NULL DEFAULT '',
  `news` longtext NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `vms_news` (`id`, `zeit`, `titel`, `news`) VALUES
(1, 1459700771, 'Erste News', 'Das ist eine Test News');

CREATE TABLE IF NOT EXISTS `vms_news_komment` (
`id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `datum` int(11) NOT NULL,
  `news` int(11) NOT NULL,
  `kommentar` longtext NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `vms_news_komment` (`id`, `uid`, `datum`, `news`, `kommentar`) VALUES
(1, 1, 1459701800, 1, 'Das ist der erste Test');

CREATE TABLE `vms_nickpage` (
  `uid` int(11) NOT NULL,
  `sex` int(11) NOT NULL,
  `ort` int(11) NOT NULL,
  `land` int(11) NOT NULL,
  `hobbys` int(11) NOT NULL,
  `beruf` int(11) NOT NULL,
  `icq` int(11) NOT NULL,
  `msn` int(11) NOT NULL,
  `aim` int(11) NOT NULL,
  `skype` int(11) NOT NULL,
  `www` int(11) NOT NULL,
  `www1` int(11) NOT NULL,
  `www2` int(11) NOT NULL,
  `www3` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_paidmails_empfaenger` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `gueltig` int(11) NOT NULL DEFAULT '0',
  `tan` varchar(14) NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT '0',
  `aufendhalt` int(11) NOT NULL DEFAULT '0',
  `start` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_paidmails_versendet` (
  `tan` varchar(14) NOT NULL DEFAULT '',
  `menge` int(11) NOT NULL DEFAULT '0',
  `bestaedigt` int(11) NOT NULL DEFAULT '0',
  `verdienst` double(10,2) NOT NULL DEFAULT '0.00',
  `ziel` varchar(250) NOT NULL DEFAULT '',
  `beschreibung` varchar(50) NOT NULL DEFAULT '',
  `mailtext` longtext NOT NULL,
  `aufendhalt` int(11) NOT NULL DEFAULT '0',
  `gesendet` int(11) NOT NULL DEFAULT '0',
  `gueltig` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_rallydaten` (
`id` tinyint(1) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `beschrieb` longtext NOT NULL,
  `status` enum('aktive','deaktiviert') NOT NULL,
  `start` int(11) NOT NULL DEFAULT '0',
  `ende_art` enum('punkt','zeit') NOT NULL DEFAULT 'zeit' COMMENT 'nach was die rally beendet wird',
  `ende_zeit` int(11) NOT NULL DEFAULT '0',
  `ende_punkte` double(15,2) NOT NULL,
  `ende_punkte_aktuell` double(15,2) NOT NULL DEFAULT '0.00' COMMENT 'wie viel schon erreicht ist von ende_punkte',
  `ende_punkte_anzahl` varchar(10) NOT NULL,
  `ende_formulierung` varchar(50) NOT NULL DEFAULT '' COMMENT 'Was in der Seite fr eine formulierung steht',
  `ende_vortschritt` enum('Jeden Tag','Jede Woche','Jeden Monat','Jedes Jahr','datum') NOT NULL DEFAULT 'datum',
  `gewinn_art` enum('statisch','dynamisch') NOT NULL DEFAULT 'statisch' COMMENT 'gewinntopf dynmaisch oder statisch',
  `gewinn_dyn_steigerung` varchar(50) NOT NULL DEFAULT '0.00' COMMENT 'steigerung des gewinnes bei dynamisch',
  `gewinn_topf` double(15,2) NOT NULL DEFAULT '0.00',
  `gewinner_anzahl` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50') NOT NULL DEFAULT '0',
  `mindestpunktzhl` int(10) NOT NULL DEFAULT '0',
  `sperruser` varchar(200) NOT NULL,
  `tagpotstart` double(15,2) NOT NULL,
  `einheit` varchar(50) NOT NULL,
  `p1` double(10,2) NOT NULL DEFAULT '0.00',
  `p2` double(10,2) NOT NULL DEFAULT '0.00',
  `p3` double(10,2) NOT NULL DEFAULT '0.00',
  `p4` double(10,2) NOT NULL DEFAULT '0.00',
  `p5` double(10,2) NOT NULL DEFAULT '0.00',
  `p6` double(10,2) NOT NULL DEFAULT '0.00',
  `p7` double(10,2) NOT NULL DEFAULT '0.00',
  `p8` double(10,2) NOT NULL DEFAULT '0.00',
  `p9` double(10,2) NOT NULL DEFAULT '0.00',
  `p10` double(10,2) NOT NULL DEFAULT '0.00',
  `p11` double(10,2) NOT NULL DEFAULT '0.00',
  `p12` double(10,2) NOT NULL DEFAULT '0.00',
  `p13` double(10,2) NOT NULL DEFAULT '0.00',
  `p14` double(10,2) NOT NULL DEFAULT '0.00',
  `p15` double(10,2) NOT NULL DEFAULT '0.00',
  `p16` double(10,2) NOT NULL DEFAULT '0.00',
  `p17` double(10,2) NOT NULL DEFAULT '0.00',
  `p18` double(10,2) NOT NULL DEFAULT '0.00',
  `p19` double(10,2) NOT NULL DEFAULT '0.00',
  `p20` double(10,2) NOT NULL DEFAULT '0.00',
  `p21` double(10,2) NOT NULL DEFAULT '0.00',
  `p22` double(10,2) NOT NULL DEFAULT '0.00',
  `p23` double(10,2) NOT NULL DEFAULT '0.00',
  `p24` double(10,2) NOT NULL DEFAULT '0.00',
  `p25` double(10,2) NOT NULL DEFAULT '0.00',
  `p26` double(10,2) NOT NULL DEFAULT '0.00',
  `p27` double(10,2) NOT NULL DEFAULT '0.00',
  `p28` double(10,2) NOT NULL DEFAULT '0.00',
  `p29` double(10,2) NOT NULL DEFAULT '0.00',
  `p30` double(10,2) NOT NULL DEFAULT '0.00',
  `p31` double(10,2) NOT NULL DEFAULT '0.00',
  `p32` double(10,2) NOT NULL DEFAULT '0.00',
  `p33` double(10,2) NOT NULL DEFAULT '0.00',
  `p34` double(10,2) NOT NULL DEFAULT '0.00',
  `p35` double(10,2) NOT NULL DEFAULT '0.00',
  `p36` double(10,2) NOT NULL DEFAULT '0.00',
  `p37` double(10,2) NOT NULL DEFAULT '0.00',
  `p38` double(10,2) NOT NULL DEFAULT '0.00',
  `p39` double(10,2) NOT NULL DEFAULT '0.00',
  `p40` double(10,2) NOT NULL DEFAULT '0.00',
  `p41` double(10,2) NOT NULL DEFAULT '0.00',
  `p42` double(10,2) NOT NULL DEFAULT '0.00',
  `p43` double(10,2) NOT NULL DEFAULT '0.00',
  `p44` double(10,2) NOT NULL DEFAULT '0.00',
  `p45` double(10,2) NOT NULL DEFAULT '0.00',
  `p46` double(10,2) NOT NULL DEFAULT '0.00',
  `p47` double(10,2) NOT NULL DEFAULT '0.00',
  `p48` double(10,2) NOT NULL DEFAULT '0.00',
  `p49` double(10,2) NOT NULL DEFAULT '0.00',
  `p50` double(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

INSERT INTO `vms_rallydaten` (`id`, `name`, `beschrieb`, `status`, `start`, `ende_art`, `ende_zeit`, `ende_punkte`, `ende_punkte_aktuell`, `ende_punkte_anzahl`, `ende_formulierung`, `ende_vortschritt`, `gewinn_art`, `gewinn_dyn_steigerung`, `gewinn_topf`, `gewinner_anzahl`, `mindestpunktzhl`, `sperruser`, `tagpotstart`, `einheit`, `p1`, `p2`, `p3`, `p4`, `p5`, `p6`, `p7`, `p8`, `p9`, `p10`, `p11`, `p12`, `p13`, `p14`, `p15`, `p16`, `p17`, `p18`, `p19`, `p20`, `p21`, `p22`, `p23`, `p24`, `p25`, `p26`, `p27`, `p28`, `p29`, `p30`, `p31`, `p32`, `p33`, `p34`, `p35`, `p36`, `p37`, `p38`, `p39`, `p40`, `p41`, `p42`, `p43`, `p44`, `p45`, `p46`, `p47`, `p48`, `p49`, `p50`) VALUES
(1, 'Tagesklick', ' Diese rally wird Täglich um Mitternacht neugestartet', 'aktive', 1230768000, 'zeit', 1388534400, 0.00, 0.00, '*0+1', 'mal die Maus gequält', 'Jeden Tag', 'dynamisch', '/100*2.5', 0.00, '10', 50, ' ', 100000.00, ' Klicks', 45.00, 20.00, 10.00, 5.00, 4.00, 3.50, 3.00, 2.50, 2.00, 1.50, 1.00, 0.90, 0.70, 0.50, 0.40, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(4, 'Klick', ' ', 'deaktiviert', 0, 'zeit', 0, 0.00, 0.00, '0', ' ', 'datum', 'statisch', '0.00', 0.00, '0', 0, ' ', 0.00, ' ', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(6, 'Aktive', ' ', 'deaktiviert', 0, 'zeit', 0, 0.00, 0.00, '0', ' ', 'datum', 'statisch', '0.00', 0.00, '0', 0, ' ', 0.00, ' ', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(7, 'Bettel', ' ', 'deaktiviert', 0, 'zeit', 0, 0.00, 0.00, '0', ' ', 'datum', 'statisch', '0.00', 0.00, '0', 0, ' ', 0.00, ' ', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00);

CREATE TABLE IF NOT EXISTS `vms_rallyorte` (
`id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `welche_rallys` varchar(1000) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

INSERT INTO `vms_rallyorte` (`id`, `name`, `welche_rallys`) VALUES
(1, 'Forcedbanner-Normal', '1,4,6'),
(2, 'Paidmails-Normal', '1,4,6'),
(6, 'Betteln', '6,7');

CREATE TABLE IF NOT EXISTS `vms_rallyuser` (
  `rally` char(20) NOT NULL DEFAULT '0',
  `uid` int(7) NOT NULL DEFAULT '0',
  `punkte` int(11) NOT NULL DEFAULT '0',
  `ausgezahlt` int(11) NOT NULL DEFAULT '0',
  `auszahlungssumme` double(15,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_reloads` (
  `ip` varchar(15) NOT NULL DEFAULT '',
  `uid` int(7) NOT NULL DEFAULT '0',
  `tan` varchar(32) NOT NULL DEFAULT '',
  `bis` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_schnittstelle` (
  `betreiber_id` int(8) NOT NULL DEFAULT '0',
  `betreiber_passwort` varchar(50) NOT NULL DEFAULT '',
  `betreiber_kennung` int(8) NOT NULL DEFAULT '0',
  `schnittstelle` varchar(20) NOT NULL DEFAULT '',
  `einzahltext` varchar(40) NOT NULL DEFAULT '',
  `auszahltext` varchar(40) NOT NULL DEFAULT '',
  `einzahlsumme` int(11) NOT NULL DEFAULT '0',
  `auszahlsumme` int(11) NOT NULL DEFAULT '0',
  `anfragen_tag` int(11) NOT NULL DEFAULT '0',
  `anfragen_user` int(11) NOT NULL DEFAULT '0',
  `aktiv` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `waehrung_name` varchar(32) NOT NULL DEFAULT '0',
  `punktewert` double NOT NULL DEFAULT '0',
  `wertepunkt` double NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_schnittstelle_anfragen` (
  `zeit` int(11) NOT NULL DEFAULT '0',
  `uid` int(7) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `vms_schnittstelle_anfragen` (`zeit`, `uid`) VALUES
(0, 1);

CREATE TABLE `vms_seitenkonfig` (
  `wartung` int(1) NOT NULL DEFAULT '0',
  `domain` text NOT NULL,
  `seitenname` text NOT NULL,
  `waehrung` text NOT NULL,
  `betreibermail` text NOT NULL,
  `cron_pw` text NOT NULL,
  `einzahlgrenze` int(11) NOT NULL DEFAULT '0',
  `re1` double(10,2) NOT NULL DEFAULT '0.00',
  `re2` double(10,2) NOT NULL DEFAULT '0.00',
  `re3` double(10,2) NOT NULL DEFAULT '0.00',
  `min_betteln` double(10,2) NOT NULL DEFAULT '0.00',
  `max_betteln` double(10,2) NOT NULL DEFAULT '0.00',
  `reload_betteln` int(11) NOT NULL DEFAULT '0',
  `denied_domains` text NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `admin_pass` varchar(255) NOT NULL,
  `auszahlgrenze` double NOT NULL DEFAULT '100',
  `chat_aktiv` int(11) NOT NULL,
  `fake_schluessel` text NOT NULL,
  `anzeige_chat` int(11) NOT NULL,
  `anzeige_text` int(11) NOT NULL,
  `geb_addon` int(11) NOT NULL,
  `news_komment` int(11) NOT NULL,
  `buchungen_loeschen` int(11) NOT NULL DEFAULT '0',
  `buchungen_loeschen_tage` int(11) NOT NULL DEFAULT '0',
  `reload_start` int(11) NOT NULL,
  `verdienst_start` double(100,2) NOT NULL,
  `popup_start` tinyint(1) NOT NULL DEFAULT '1',
  `auszahlung_sperre` int(11) NOT NULL DEFAULT '0',
  `ip_erlaubt` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vms_texte` (
  `name` text NOT NULL,
  `text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vms_texte` (`name`, `text`) VALUES
('agb', 'AGB'),
('faq', 'FAQ');

CREATE TABLE IF NOT EXISTS `vms_userblacklist` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `zeit` bigint(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `vms_userdaten` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `nickname` varchar(255) NOT NULL DEFAULT '',
  `vorname` varchar(50) NOT NULL DEFAULT '',
  `nachname` varchar(50) NOT NULL DEFAULT '',
  `angemeldet_seit` int(10) NOT NULL DEFAULT '0',
  `max_forced` int(11) NOT NULL DEFAULT '5',
  `max_paidlinks` int(11) NOT NULL DEFAULT '5',
  `notizen` text NOT NULL,
  `chat_sperre` int(11) NOT NULL DEFAULT '0',
  `bdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `vms_userdaten` (`uid`, `nickname`, `vorname`, `nachname`, `angemeldet_seit`, `max_forced`, `notizen`, `chat_sperre`) VALUES
(1, 'Admin', 'g', 'g', 1402062767, 5, '', 0);

CREATE TABLE IF NOT EXISTS `vms_werberdaten` (
  `uid` int(7) NOT NULL DEFAULT '0',
  `werber` int(7) NOT NULL DEFAULT '0',
  `umsatz` double(10,2) NOT NULL DEFAULT '0.00',
  `zuordnungszeit` int(10) NOT NULL DEFAULT '0',
  `reset` double(10,2) NOT NULL DEFAULT '0.00',
  `resetzeit` int(11) NOT NULL DEFAULT '0',
  `gesamt` double(10,2) NOT NULL DEFAULT '0.00',
  `refback` int(3) NOT NULL DEFAULT '0',
  `aktivzeit` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `vms_werberdaten` (`uid`, `werber`, `umsatz`, `zuordnungszeit`, `reset`, `resetzeit`, `gesamt`, `refback`, `aktivzeit`) VALUES
(1, 0, 0.00, 1402062767, 0.00, 0, 0.00, 0, 0);

ALTER TABLE `vms_adminblacklist`
 ADD PRIMARY KEY (`tan`);

ALTER TABLE `vms_aktivierungen`
 ADD KEY `aktivierungs_code` (`ak`);

ALTER TABLE `vms_bettel_buchung`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_bilanz`
 ADD PRIMARY KEY (`datum`);

ALTER TABLE `vms_box_admin`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_box_user`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_buchungen`
 ADD KEY `user` (`uid`);

ALTER TABLE `vms_chat`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_chat_einstellungen`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_cms_seiten`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_crons`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_emaildaten`
 ADD PRIMARY KEY (`uid`), ADD KEY `freigabe_fuer` (`freigabe_fuer`);

ALTER TABLE `vms_fakecheck`
 ADD KEY `fc_klicks` (`fc_klicks`);

ALTER TABLE `vms_fb_blacklist`
 ADD UNIQUE KEY `sponsor` (`sponsor`,`kid`,`werbeart`);

ALTER TABLE `vms_gebuchte_werbung`
 ADD KEY `klick4` (`werbeart`,`menge`,`status`,`verdienst`,`sponsor`), ADD KEY `crons` (`sponsor`,`werbeart`,`status`);

ALTER TABLE `vms_interface`
 ADD KEY `interface` (`interface`);

ALTER TABLE `vms_kontodaten`
 ADD PRIMARY KEY (`uid`);

ALTER TABLE `vms_menu_admin`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_menu_user`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_multi_konten`
 ADD KEY `uid` (`uid`,`kontoid`);

ALTER TABLE `vms_news`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_news_komment`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_paidmails_empfaenger`
 ADD UNIQUE KEY `primary_ersatz` (`uid`,`tan`);

ALTER TABLE `vms_paidmails_versendet`
 ADD UNIQUE KEY `primary_ersatz` (`tan`);

ALTER TABLE `vms_rallydaten`
 ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `sperruser` (`sperruser`);

ALTER TABLE `vms_rallyorte`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_rallyuser`
 ADD PRIMARY KEY (`rally`,`uid`,`ausgezahlt`);

ALTER TABLE `vms_reloads`
 ADD KEY `klick4` (`tan`,`uid`,`ip`);

ALTER TABLE `vms_schnittstelle`
 ADD PRIMARY KEY (`schnittstelle`), ADD KEY `aktiv` (`aktiv`);

ALTER TABLE `vms_schnittstelle_anfragen`
 ADD KEY `uid` (`uid`);

ALTER TABLE `vms_userblacklist`
 ADD PRIMARY KEY (`uid`);

ALTER TABLE `vms_userdaten`
 ADD PRIMARY KEY (`uid`);

ALTER TABLE `vms_werberdaten`
 ADD PRIMARY KEY (`uid`);

ALTER TABLE `vms_bettel_buchung`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `vms_box_admin`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;

ALTER TABLE `vms_box_user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;

ALTER TABLE `vms_chat`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;

ALTER TABLE `vms_chat_einstellungen`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

ALTER TABLE `vms_cms_seiten`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `vms_crons`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;

ALTER TABLE `vms_kontodaten`
MODIFY `uid` int(7) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

ALTER TABLE `vms_menu_admin`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;

ALTER TABLE `vms_menu_user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;

ALTER TABLE `vms_news`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

ALTER TABLE `vms_news_komment`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

ALTER TABLE `vms_rallydaten`
MODIFY `id` tinyint(1) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;

ALTER TABLE `vms_rallyorte`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;