Skip to content
Snippets Groups Projects
mysql.txt 35.6 KiB
Newer Older
Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_AddBlackList` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `datum` int(11) NOT NULL,
  `tan` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_adminblacklist` (
isaack's avatar
1.1
isaack committed
  `tan` varchar(32) NOT NULL,
  `time` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_aktivierungen` (
isaack's avatar
1.1
isaack committed
  `uid` int(7) NOT NULL DEFAULT '0',
  `ak` varchar(32) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_bettel_buchung` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `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;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_box_admin` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `name` text NOT NULL,
  `ordnung` int(11) NOT NULL DEFAULT '1',
Eric Laufer's avatar
Eric Laufer committed
  `status` int(11) NOT NULL DEFAULT '1',
  `sichtbar` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

CREATE TABLE `vms_box_user` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `name` text NOT NULL,
  `ordnung` int(11) NOT NULL DEFAULT '1',
  `sichtbar` int(11) NOT NULL
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

INSERT INTO `vms_box_user` (`id`, `name`, `ordnung`, `sichtbar`) VALUES
Eric Laufer's avatar
Eric Laufer committed
(6, 'Navigation', 1, 1),
(7, 'Verdienen', 2, 1);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_buchungen` (
  `id` int(11) NOT NULL,
  `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 '',
  `buchung_ok` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_chat` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `absender` text NOT NULL,
  `nachricht` longtext NOT NULL,
  `time` int(11) NOT NULL
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_chat_einstellungen` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `chat_aktiv` int(11) NOT NULL,
  `hintergrundfarbe` text NOT NULL,
  `textfarbe` text NOT NULL,
  `profillink` text NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `anzahl` int(11) NOT NULL,
  `sb_reload` int(11) NOT NULL,
  `sb_verguetung` double(100,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
INSERT INTO `vms_chat_einstellungen` (`id`, `chat_aktiv`, `hintergrundfarbe`, `textfarbe`, `profillink`, `anzahl`, `sb_reload`, `sb_verguetung`) VALUES
Eric Laufer's avatar
Eric Laufer committed
(1, 2, '#000000', '#ffffff', '#ff6600', 100, 20, 100.00);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_cms_seiten` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `titel` text NOT NULL,
  `text` longtext NOT NULL,
  `sichtbar` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_crons` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `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 ''
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

INSERT INTO `vms_crons` (`id`, `cron`, `laufzeit`, `datei`, `bezeichnung`) VALUES
(1, 'ext_cron', 1553343847, 'refzahlungen.knt.php', 'Ext. Refzahlungen'),
Eric Laufer's avatar
Eric Laufer committed
(4, 'DB-Backup', 1550494451, 'db_backup.php', 'Datenbank Backup erstellen');
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_emaildaten` (
isaack's avatar
1.1
isaack committed
  `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, '', 2);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_fb_blacklist` (
isaack's avatar
1.1
isaack committed
  `sponsor` varchar(255) NOT NULL,
  `kid` int(10) NOT NULL,
  `grund` tinyint(1) NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `werbeart` varchar(255) NOT NULL,
  `tan` text NOT NULL
isaack's avatar
1.1
isaack committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_gebuchte_werbung` (
isaack's avatar
1.1
isaack committed
  `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 '',
Eric Laufer's avatar
Eric Laufer committed
  `betreff` text NOT NULL,
  `text` longtext NOT NULL,
isaack's avatar
1.1
isaack committed
  `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;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_geburtstag` (
isaack's avatar
1.1
isaack committed
  `geb_mail` int(11) NOT NULL,
  `geb_hoehe` double(100,2) NOT NULL,
  `geb_text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_interface` (
isaack's avatar
1.1
isaack committed
  `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,
Eric Laufer's avatar
Eric Laufer committed
  `kontostand_a` double(100,2) NOT NULL DEFAULT '0.00',
  `kontostand_b` double(100,2) NOT NULL DEFAULT '0.00',
isaack's avatar
1.1
isaack committed
  `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',
Eric Laufer's avatar
Eric Laufer committed
  `chat_sperre` int(11) NOT NULL DEFAULT '0',
isaack's avatar
1.1
isaack committed
  `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

--
-- Daten für Tabelle `vms_kontodaten`
--

Eric Laufer's avatar
Eric Laufer committed
INSERT INTO `vms_kontodaten` (`uid`, `passwort`, `status`, `hinweis`, `kontostand_a`, `kontostand_b`, `login_ip`, `loginzeit`, `last_active`, `klicks`, `p_klicks`, `kv`, `angebettelt`, `bv`, `bettel_sperre`, `forced_sperre`, `chat_sperre`, `fc_klicks`, `fc_trys`, `s_aufrufe`, `s_verdienst`, `auszahlung_sperre`) VALUES
(1, '5fae31539e070a690c1b63720c25eb5b86084b5098a942c86c89c1d67157ed6b', 1, '', 520656.09, 15274.00, '', 1553343744, 1553345635, 101, 0, 252902.00, 1, 54.09, 0, 0, 0, 101, 0, 21, 0.00, 1);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_links_user` (
isaack's avatar
1.1
isaack committed
  `link` text NOT NULL,
  `name` text NOT NULL,
  `box` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_menu_admin` (
  `id` int(11) NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `uid` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `link` text NOT NULL,
  `name` text NOT NULL,
  `ordnung` double(10,2) NOT NULL,
  `box` int(11) NOT NULL
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
INSERT INTO `vms_menu_admin` (`id`, `uid`, `link`, `name`, `ordnung`, `box`) VALUES
(1, 0, 'usersystem/liste', 'Userliste', 1.00, 4),
(2, 0, 'usersystem/doppelaccis', 'Doppelaccounts', 1.10, 4),
(3, 0, 'usersystem/RefSchleifen', 'Refschleifen', 1.20, 4),
(4, 0, 'newssystem/news', 'News schreiben', 1.00, 5),
(5, 0, 'interfacedaten/pageconfig', 'Grundeinstellungen', 1.00, 6),
(6, 0, 'interfacedaten/crons', 'Crons', 1.10, 6),
(7, 0, 'interfacedaten/betreiber', 'Betreiberdaten', 1.20, 6),
(8, 0, 'phpinfo', 'PHPInfo', 1.21, 6),
(9, 0, 'interfacedaten/boxen_user', 'Boxverwaltung User', 1.30, 6),
(10, 0, 'interfacedaten/boxen_admin', 'Boxverwaltung Admin', 1.31, 6),
(11, 0, 'interfacedaten/menue_user', 'Menüverwaltung User', 1.40, 6),
(12, 0, 'interfacedaten/menue_admin', 'Menüverwaltung Admin', 1.41, 6),
(13, 0, 'texte/alternativwerbung', 'Alternativwerbung', 1.00, 7),
(17, 0, 'werbesystem/forcedbanner_468', 'Forced 468', 1.00, 8),
(18, 0, 'werbesystem/paidmail', 'Paidmails verschicken', 2.00, 8),
(20, 0, 'interfacebanner/admin', 'Adminbanner', 1.00, 9),
(21, 0, 'interfacebanner/blacklist', 'Blacklist', 2.00, 9),
(26, 0, 'interfacedaten/chat_einstellungen', 'Chat Einstellungen', 1.22, 6),
(27, 0, 'cms/neue_seite', 'Neue Seite erstellen', 1.00, 10),
(28, 0, 'cms/bearbeiten_seite', 'Seiten bearbeiten', 2.00, 10),
(31, 0, 'buchungen', 'User-Buchungen', 1.30, 4),
(32, 0, 'interfacedaten/db_backup', 'Datenbank Backup', 1.51, 6),
(33, 0, 'texte/texte', 'Texte bearbeiten', 1.00, 7),
(35, 0, 'kjkjg', 'dggfo', 0.00, 0),
(37, 0, 'kjkjg', 'dggfo', 0.00, 0),
(39, 0, '', '', 0.00, 0),
(40, 0, 'inaktiv', 'Inaktivensuche', 12.00, 4);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_menu_user` (
  `id` int(11) NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `uid` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `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'
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

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

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_multi_konten` (
  `uid` int(1) UNSIGNED NOT NULL,
isaack's avatar
1.1
isaack committed
  `kontoid` varchar(32) NOT NULL,
  `waehrung` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_news` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `zeit` int(11) NOT NULL DEFAULT '0',
  `titel` varchar(60) NOT NULL DEFAULT '',
  `news` longtext NOT NULL
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_news_komment` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `uid` int(11) NOT NULL,
  `datum` int(11) NOT NULL,
  `news` int(11) NOT NULL,
  `kommentar` longtext NOT NULL
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

isaack's avatar
isaack committed
CREATE TABLE `vms_nickpage` (
  `uid` int(11) NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `sex` text NOT NULL,
  `ort` text NOT NULL,
  `land` text NOT NULL,
  `hobbys` longtext NOT NULL,
  `beruf` text NOT NULL,
isaack's avatar
isaack committed
  `icq` int(11) NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `msn` text NOT NULL,
  `aim` text NOT NULL,
  `skype` text NOT NULL,
  `www` text NOT NULL,
  `www1` text NOT NULL,
  `www2` text NOT NULL,
  `www3` text NOT NULL
isaack's avatar
isaack committed
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
INSERT INTO `vms_nickpage` (`uid`, `sex`, `ort`, `land`, `hobbys`, `beruf`, `icq`, `msn`, `aim`, `skype`, `www`, `www1`, `www2`, `www3`) VALUES
(1, '', '', '', '', '', '', '', '', '', '', '', '', '');
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_rallydaten` (
  `id` tinyint(1) NOT NULL,
isaack's avatar
1.1
isaack committed
  `name` varchar(50) NOT NULL DEFAULT '',
Eric Laufer's avatar
Eric Laufer committed
  `beschriebf` longtext NOT NULL,
isaack's avatar
1.1
isaack committed
  `status` enum('aktive','deaktiviert') NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `start_time` time(5) NOT NULL,
  `start_date` date NOT NULL,
isaack's avatar
1.1
isaack committed
  `ende_art` enum('punkt','zeit') NOT NULL DEFAULT 'zeit' COMMENT 'nach was die rally beendet wird',
Eric Laufer's avatar
Eric Laufer committed
  `ende_time` time(5) NOT NULL DEFAULT '00:00:00.00000',
  `ende_date` date NOT NULL,
isaack's avatar
1.1
isaack committed
  `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'
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

--
-- Daten für Tabelle `vms_rallydaten`
--

Eric Laufer's avatar
Eric Laufer committed
INSERT INTO `vms_rallydaten` (`id`, `name`, `beschriebf`, `status`, `start_time`, `start_date`, `ende_art`, `ende_time`, `ende_date`, `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', '13:53:00.00000', '2019-03-23', 'zeit', '23:59:00.00000', '2019-03-23', 100.00, 0.00, '*0+1', 'mal die Maus gequält', 'Jeden Tag', 'dynamisch', '/100*2.5', 100000.00, '10', 3, ' ', 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),
Eric Laufer's avatar
Eric Laufer committed
(4, 'Klick', ' ', 'deaktiviert', '00:00:00.00000', '0000-00-00', 'zeit', '00:00:00.00000', '0000-00-00', 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', ' ', 'aktive', '00:00:00.00000', '2019-03-15', 'punkt', '00:00:00.00000', '0000-00-00', 10000.00, 601.00, '*0+1', ' ', 'datum', 'statisch', '0.00', 0.00, '5', 0, ' ', 0.00, ' ', 50.00, 30.00, 20.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 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', ' ', 'aktive', '00:00:00.00000', '2019-03-15', 'punkt', '00:00:00.00000', '0000-00-00', 10.00, 54.09, '*0+1', ' ', 'datum', 'statisch', '0.00', 100.00, '5', 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);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_rallyorte` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `name` varchar(50) NOT NULL,
  `welche_rallys` varchar(1000) NOT NULL
Eric Laufer's avatar
Eric Laufer committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed

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

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_rallyuser` (
isaack's avatar
1.1
isaack committed
  `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;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_reloads` (
isaack's avatar
1.1
isaack committed
  `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;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_run_inc` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `value` text NOT NULL,
  `datei` text NOT NULL,
  `beschreibung` text NOT NULL,
  `berechtigung` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vms_run_inc` (`id`, `name`, `value`, `datei`, `beschreibung`, `berechtigung`) VALUES
(1, 'chat_absenden', 'Absenden', 'chat.php', 'Chat absenden', 0),
(2, 'news_komment', 'Kommentar Speichern', 'news/kommentar.php', 'News Kommentieren', 0),
(3, 'anmelden', 'Jetzt anmelden!', 'konto/anmelden.php', 'Registrtieren', 0),
(4, 'auszahlen', 'Auszahlen', 'konto/auszahlen.php', 'Auszahlen', 0),
(5, 'ueberweisen', 'Senden', 'konto/ueberweisen.php', 'Überweisen', 0),
(6, 'aendern_nickpage', 'Speichern', 'konto/nickpage.php', 'Nickpage Speichern', 0),
(7, 'checkid', 'Login', 'session/login.php', 'Login', 0),
(8, 'anf_daten', 'Anfordern!', 'konto/daten.php', 'Passwort anfordern', 0),
Eric Laufer's avatar
Eric Laufer committed
(9, 'box_admin_box_save', 'Speichern', 'boxen/box_save.php', 'Menübox Adminbereich erstellen', 1),
(10, 'box_admin_box_loschen', 'Löschen', 'boxen/loschen.php', 'Menüboxen admin löschen', 1),
(11, 'box_admin_box_aendern', 'Ändern', 'boxen/box_edit.php', 'Menübocen admin bearbeiten', 1),
(12, 'box_user_box_save', 'Speichern', 'boxen/box_save.php', 'Menüboxen User erstellen', 1),
(13, 'box_user_box_aendern', 'Ändern', 'boxen/box_edit.php', 'Menüboxen User bearbeiten', 1),
(14, 'box_user_box_loschen', 'Löschen', 'boxen/loschen.php', 'Menüboxen User löschen', 1),
Eric Laufer's avatar
Eric Laufer committed
(15, 'link_zuordnen_neu', 'Bearbeiten', 'menu/zuordnung_menu_neu.php', '', 1),
(16, 'link_zuordnen_loschen', 'Löschen', 'menu/zuordnung_menu_neu_losch.php', '', 1),
(17, 'menue_neu_save_admin', 'Speichern', 'menu/menu_neu.php', '', 1),
Eric Laufer's avatar
Eric Laufer committed
(18, 'link_menu_admin_update', 'Speichern', 'menu/menu_bearbeiten.php', '', 1),
Eric Laufer's avatar
Eric Laufer committed
(19, 'link_menu_user_delete', 'löschen', 'menu/menu_loschen.php', '', 1),
Eric Laufer's avatar
Eric Laufer committed
(20, 'admin_link_zuordnen_neu', '', 'menu/admin_zuordnung_menu_neu.php', '', 1),
(21, 'admin_link_zuordnen_loschen', '', 'menu/admin_zuordnung_menu_neu_losch.php', '', 1),
(22, 'admin_menue_neu_save', '', 'menu/admin_menu_neu.php', '', 1),
(23, 'admin_link_bearbeiten', '', 'menu/admin_menu_bearbeiten.php', '', 1),
Eric Laufer's avatar
Eric Laufer committed
(24, 'link_menu_admin_delete', 'löschen', 'menu/menu_loschen.php', '', 1),
Eric Laufer's avatar
Eric Laufer committed
(28, 'chat_save', 'Chat Einstellungen Speichern', 'chat/einstellungen.php', '', 1),
(29, 'chat_nachricht_loeschen', 'Löschen', 'chat/nachrichten_loeschen.php', '', 1),
(30, 'seite_save', 'Speichern', 'cms/neue_seite.php', '', 1),
Eric Laufer's avatar
Eric Laufer committed
(31, 'updaten_betreiberdaten', 'Hinzufügen !', 'setting/schnitt_save.php', 'Schnittstelle hinzufügen', 1),
Eric Laufer's avatar
Eric Laufer committed
(33, 'einzahlen', 'Einzahlen', 'konto/einzahlen.php', '', 0),
(34, 'aendern', 'Jetzt ändern!', 'konto/user_daten.php', '', 0),
(35, 'pw_neu', 'Speichern', 'konto/pass_neu.php', '', 0),
(36, 'acc_del', 'Jetzt löschen!', 'konto/delete_acc.php', '', 0),
(37, 'profile_save', 'Allgemeine Daten Speichern', 'user/profil.php', '', 1),
(38, 'notice', 'Notiz hinzufügen', 'user/notiz.php', 'User Notizen hinzufügen', 1),
(39, 'FBbuchen', 'Jetzt Buchen', 'werbung/FBEintragen.php', 'Forcedbanner Eintragen', 1),
(40, 'PaidMailSenden', 'Jetzt Buchen', 'werbung/PaidMailSenden.php', 'Paidmail Senden', 1),
Eric Laufer's avatar
Eric Laufer committed
(41, 'FBDelete', 'Löschen', 'werbung/FBDelete.php', 'Banner Löschen', 1),
Eric Laufer's avatar
Eric Laufer committed
(42, 'GrunConfigUpdate', 'Speichern', 'setting/grundeinstellung.php', 'Grundeinstellungen Speichern', 1),
Eric Laufer's avatar
Eric Laufer committed
(43, 'link_menu_user_update', 'Speichern', 'menu/menu_bearbeiten.php', 'bearbeiten von Links im Menü', 1),
(44, 'news4', 'Seite', 'news.php', 'News ohne Newsletter', 1),
(45, 'news3', 'Newsletter', 'news.php', 'Nur Newsletter', 1),
(46, 'news2', 'Newsletter und Seite', 'news.php', 'Newsletter und Seite', 1),
(47, 'news_delete', 'löschen', 'news.php', 'News löschen', 1),
(49, 'TexteUpdaten', 'Updaten !', 'texte/texte.php', 'Texte speichern', 1),
(50, 'menue_neu_save_user', 'Speichern', 'menu/menu_neu.php', 'Neuen Menüpunkt anlegen', 1),
Eric Laufer's avatar
Eric Laufer committed
(52, 'seite_bearbeiten', 'Speichern', 'cms/bearbeiten_seite.php', 'CMS Seite bearbeiten', 1),
(53, 'seite_loeschen', 'Seite löschen', 'cms/loeschen_seite.php', 'CMS Seite löschen', 1),
(54, 'rally', 'Eintragen', 'rally/haupt.php', 'Anlegen einer neuen Rally', 1),
(55, 'rallyDelete', 'Löschen', 'rally/haupt.php', 'Löschen einer vorhandenen Rally', 1),
(56, 'eintragen', 'Neue Position', 'rally/haupt.php', 'Neuen Rallyort hinzufügen', 1),
(57, 'OrtEdit', 'bearbeiten', 'rally/haupt.php', 'Bearbeiten von Rallyorten', 1),
(58, 'OrtDelete', 'Löschen', 'rally/OrtDelete.php', 'Löschen von RallyOrten', 1),
(59, 'RallyConfig', 'Speichern', 'rally/haupt.php', 'Rallydaten bearbeiten/speichern', 1),
(60, 'rally_verteilung', 'Speichern', 'rally/haupt.php', 'Rally gewinn Verteilung Speichern', 1),
(61, 'RallyReset', 'Reseten', 'rally/haupt.php', 'Reset der Rally auslösen', 1),
(62, 'RallyAuswerten', 'Auswerten', 'rally/haupt.php', 'Rally Manuell auswerten', 1),
(63, 'AvaUpload', 'Hochladen', 'konto/AvaUpload.php', 'Hochladen des Profilbildes', 0),
(64, 'refebenenSave', 'Speichern', 'setting/ref.php', 'Refebenen Speichern', 1),
Eric Laufer's avatar
Eric Laufer committed
(65, 'adminPW', 'Zugangsdaten Updaten', 'setting/admin.php', 'Zugangsdaten Admin ändern', 1),
(66, 'checkAdmin', 'Login', 'AdminLogin.php', 'Adminlogin', 1),
(67, 'GrunConfigUpdate', 'Währung Speichern', 'setting/grundeinstellung.php', 'Grundeinstellungen Speichern', 1),
(68, 'GrunConfigUpdate', 'Nutzer Speichern', 'setting/grundeinstellung.php', 'Grundeinstellungen Speichern', 1),
Eric Laufer's avatar
Eric Laufer committed
(69, 'GrunConfigUpdate', 'SMTP Speichern', 'setting/grundeinstellung.php', 'Grundeinstellungen Speichern', 1),
(70, 'BannerDelete', 'Banner Sperren', 'werbung/BannerDelete.php', 'Deaktivieren von Bannern', 1),
(71, 'BannerFree', 'Banner freigeben', 'werbung/BannerFree.php', 'Banner wieder freischalten', 1),
(72, 'updaten_alternativwerbung', 'Speichern', 'texte/AWerbung.php', 'Speichern der Alternativen Werbung', 1),
Eric Laufer's avatar
Eric Laufer committed
(73, 'InaktiveSuchen', 'Suchen', 'inaktive.php', 'Inaktivensuche Adminbereich', 1),
Eric Laufer's avatar
Eric Laufer committed
(75, 'updaten_betreiberdaten', 'Updaten', 'setting/schnitt_update.php', '', 1),
(76, 'veri', 'Verifizieren', 'konto/ver.php', 'Verfizierung externes Konto', 0);
Eric Laufer's avatar
Eric Laufer committed

CREATE TABLE `vms_schnittstelle` (
  `name` text NOT NULL,
isaack's avatar
1.1
isaack committed
  `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',
Eric Laufer's avatar
Eric Laufer committed
  `aktiv` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `aktiv_ein` int(11) NOT NULL DEFAULT '0',
  `aktiv_aus` int(11) NOT NULL DEFAULT '0',
isaack's avatar
1.1
isaack committed
  `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;

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_schnittstelle_anfragen` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
  `zeit` int(11) NOT NULL DEFAULT '0',
Eric Laufer's avatar
Eric Laufer committed
  `uid` int(7) NOT NULL DEFAULT '0',
  `betrag` double(100,2) NOT NULL,
  `art` text NOT NULL
isaack's avatar
1.1
isaack committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `vms_seitenkonfig` (
Eric Laufer's avatar
Eric Laufer committed
  `id` int(11) NOT NULL,
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',
Eric Laufer's avatar
Eric Laufer committed
  `RefEbenen` int(11) NOT NULL,
  `RefVerg` varchar(255) NOT NULL,
isaack's avatar
1.1
isaack committed
  `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',
Eric Laufer's avatar
Eric Laufer committed
  `ip_erlaubt` text NOT NULL,
  `SMTP_HOST` text NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `SMTP_PORT` int(8) NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `SMTP_LOGIN` text NOT NULL,
  `SMTP_PASS` text NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `SMTP_VERBINDUNG` text NOT NULL,
Eric Laufer's avatar
Eric Laufer committed
  `kontostand_b` int(11) NOT NULL DEFAULT '0',
  `kontostand_b_name` text NOT NULL
isaack's avatar
1.1
isaack committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `vms_seitenkonfig`
--

INSERT INTO `vms_seitenkonfig` (`id`, `wartung`, `domain`, `seitenname`, `waehrung`, `betreibermail`, `cron_pw`, `einzahlgrenze`, `re1`, `re2`, `re3`, `RefEbenen`, `RefVerg`, `min_betteln`, `max_betteln`, `reload_betteln`, `denied_domains`, `admin_name`, `admin_pass`, `auszahlgrenze`, `chat_aktiv`, `fake_schluessel`, `anzeige_chat`, `anzeige_text`, `geb_addon`, `news_komment`, `buchungen_loeschen`, `buchungen_loeschen_tage`, `reload_start`, `verdienst_start`, `popup_start`, `auszahlung_sperre`, `ip_erlaubt`, `SMTP_HOST`, `SMTP_PORT`, `SMTP_LOGIN`, `SMTP_PASS`, `SMTP_VERBINDUNG`, `kontostand_b`, `kontostand_b_name`) VALUES
Eric Laufer's avatar
Eric Laufer committed
(1, 0, 'http://vms-suee.vms1-scripte.de', 'Vms SUEE', 'suees', 'info@vms1-scripte.de', 'cronpw', 100000, 8.00, 3.00, 1.00, 0, '20', 50.00, 250.00, 3600, '', 'YWRtaW4=', '5fae31539e070a690c1b63720c25eb5b86084b5098a942c86c89c1d67157ed6b', 100, 2, '', 1, 1, 1, 1, 0, 0, 3600, 0.00, 1, 0, '', 'localhost', '', '', '', 'ssl', 1, 'bonuswährung');
Eric Laufer's avatar
Eric Laufer committed

CREATE TABLE `vms_texte` (
isaack's avatar
1.1
isaack committed
  `name` text NOT NULL,
  `text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vms_texte` (`name`, `text`) VALUES
Eric Laufer's avatar
Eric Laufer committed
('Wartungstext', '<p>Das ist der Wartungstext4</p>\r\n'),
('impressum', '<p>Hier ist das Impressum</p>\r\n\r\n<p>123456</p>\r\n'),
('Datenschutz', '<p>Das ist der Datenschutz</p>\r\n\r\n<p>123456</p>\r\n'),
('FAQ', '<p>Das sind die FAQ</p>\r\n\r\n<p>123456</p>\r\n'),
('AGB', '<p>Test 123456</p>\r\n'),
('Startseite', '<p>test</p>\r\n'),
('awerbung', '{\"start\":\"67890\",\"start_popup\":\"123456\",\"bettelwerbung\":\"54321\"}');
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_userblacklist` (
isaack's avatar
1.1
isaack committed
  `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,
Eric Laufer's avatar
Eric Laufer committed
  `bdate` int(11) NOT NULL,
  `ava` varchar(10) NOT NULL
isaack's avatar
1.1
isaack committed
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Eric Laufer's avatar
Eric Laufer committed
INSERT INTO `vms_userdaten` (`uid`, `nickname`, `vorname`, `nachname`, `angemeldet_seit`, `max_forced`, `max_paidlinks`, `notizen`, `bdate`, `ava`) VALUES
(1, 'admin', '', '', '', '', '', '', '', '');
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
CREATE TABLE `vms_user_notizen` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `datum` int(11) NOT NULL,
  `text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `vms_werberdaten` (
isaack's avatar
1.1
isaack committed
  `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, 245618.09, 1402062767, 0.00, 0, 0.00, 0, 1553344180);
Eric Laufer's avatar
Eric Laufer committed

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

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_adminblacklist`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`tan`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_aktivierungen`
Eric Laufer's avatar
Eric Laufer committed
  ADD KEY `aktivierungs_code` (`ak`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_bettel_buchung`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);

ALTER TABLE `vms_bilanz`
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_box_admin`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_box_user`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_buchungen`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`uid`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_chat`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_chat_einstellungen`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_cms_seiten`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_crons`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_emaildaten`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`uid`),
  ADD KEY `freigabe_fuer` (`freigabe_fuer`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_fb_blacklist`
Eric Laufer's avatar
Eric Laufer committed
  ADD UNIQUE KEY `sponsor` (`sponsor`,`kid`,`werbeart`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_gebuchte_werbung`
Eric Laufer's avatar
Eric Laufer committed
  ADD KEY `klick4` (`werbeart`,`menge`,`status`,`verdienst`,`sponsor`),
  ADD KEY `crons` (`sponsor`,`werbeart`,`status`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_interface`
Eric Laufer's avatar
Eric Laufer committed
  ADD KEY `interface` (`interface`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_kontodaten`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`uid`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_menu_admin`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_menu_user`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_multi_konten`
Eric Laufer's avatar
Eric Laufer committed
  ADD KEY `uid` (`uid`,`kontoid`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_news`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_news_komment`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_rallydaten`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
ALTER TABLE `vms_rallydaten` ADD FULLTEXT KEY `sperruser` (`sperruser`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_rallyorte`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_rallyuser`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`rally`,`uid`,`ausgezahlt`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_reloads`
Eric Laufer's avatar
Eric Laufer committed
  ADD KEY `klick4` (`tan`,`uid`,`ip`);

ALTER TABLE `vms_run_inc`
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_schnittstelle`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`schnittstelle`),
  ADD KEY `aktiv` (`aktiv`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_schnittstelle_anfragen`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_seitenkonfig`
  ADD PRIMARY KEY (`id`);

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_userblacklist`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`uid`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_userdaten`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`uid`);

ALTER TABLE `vms_user_notizen`
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed

ALTER TABLE `vms_werberdaten`
Eric Laufer's avatar
Eric Laufer committed
  ADD PRIMARY KEY (`uid`);
isaack's avatar
1.1
isaack committed

Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_AddBlackList`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
Eric Laufer's avatar
Eric Laufer committed

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_bettel_buchung`
Eric Laufer's avatar
Eric Laufer committed
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_bilanz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_box_admin`
Eric Laufer's avatar
Eric Laufer committed
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_box_user`
Eric Laufer's avatar
Eric Laufer committed
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_buchungen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_chat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_chat_einstellungen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_cms_seiten`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_crons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_kontodaten`
  MODIFY `uid` int(7) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_menu_admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_menu_user`
Eric Laufer's avatar
Eric Laufer committed
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_news_komment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_rallydaten`
Eric Laufer's avatar
Eric Laufer committed
  MODIFY `id` tinyint(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_rallyorte`
Eric Laufer's avatar
Eric Laufer committed
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_run_inc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_schnittstelle_anfragen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_seitenkonfig`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

Eric Laufer's avatar
Eric Laufer committed
ALTER TABLE `vms_user_notizen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;