Skip to content
Snippets Groups Projects
mysql.txt 27.5 KiB
Newer Older
isaack's avatar
1.1
isaack committed
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;

isaack's avatar
isaack committed
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;
isaack's avatar
1.1
isaack committed

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),
isaack's avatar
isaack committed
(9, 'Interfacebanner', 8, 1),
isaack's avatar
isaack committed
(10, 'CMS', 10, 1);
isaack's avatar
1.1
isaack committed

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),
isaack's avatar
isaack committed
(7, 'Verdienen', 2, 3);
isaack's avatar
1.1
isaack committed

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');
isaack's avatar
1.1
isaack committed

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;

isaack's avatar
isaack committed
CREATE TABLE `vms_kontodaten` (
isaack's avatar
isaack committed
  `uid` int(7) NOT NULL,
isaack's avatar
isaack committed
  `passwort` char(100) NOT NULL,
isaack's avatar
1.1
isaack committed
  `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',
isaack's avatar
isaack committed
  `p_klicks` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `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,
isaack's avatar
isaack committed
  `fc_trys` int(10) NOT NULL,
  `s_aufrufe` int(11) NOT NULL,
  `s_verdienst` double(100,2) NOT NULL,
  `auszahlung_sperre` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

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),
isaack's avatar
1.1
isaack committed
(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);
isaack's avatar
1.1
isaack committed

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),
isaack's avatar
isaack committed
(15, 'framebrecher', 'Framebrecher', 1.00, 8, 0);
isaack's avatar
1.1
isaack committed

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');

isaack's avatar
isaack committed
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;

isaack's avatar
1.1
isaack committed
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` (
isaack's avatar
1.1
isaack committed
  `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
isaack's avatar
1.1
isaack committed
) 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;

isaack's avatar
isaack committed
CREATE TABLE `vms_userdaten` (
isaack's avatar
1.1
isaack committed
  `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',
isaack's avatar
isaack committed
  `max_paidlinks` int(11) NOT NULL DEFAULT '5',
isaack's avatar
1.1
isaack committed
  `notizen` text NOT NULL,
isaack's avatar
isaack committed
  `chat_sperre` int(11) NOT NULL DEFAULT '0',
  `bdate` int(11) NOT NULL
isaack's avatar
1.1
isaack committed
) 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_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;