Skip to content
Snippets Groups Projects
mysql.txt 34.9 KiB
Newer Older
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
Eric Laufer's avatar
Eric Laufer committed
(1, 'ext_cron', 1551285195, 'refzahlungen.knt.php', 'Ext. Refzahlungen'),
Eric Laufer's avatar
Eric Laufer committed
(2, '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
Eric Laufer's avatar
Eric Laufer committed
(1, 'admin@admin.com', 1);
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
INSERT INTO `vms_gebuchte_werbung` (`uid`, `tan`, `kid`, `ziel`, `banner`, `betreff`, `text`, `verdienst`, `preis`, `aufendhalt`, `menge`, `reload`, `sponsor`, `werbeart`, `status`) VALUES
(0, 'bV57H6KzquoJVJXps4XqSbAGxqPjTbk6', 0, 'https://vms1-scripte.de', 'http://www.allways-slots.com/img/a/aw468.gif', '', '', 100.00, 0.00, 10, 70, 130, 'administrator', 'forcedbanner', 1),
(0, 'iubwüvoub49uvbswivb', 0, 'https://vms1-scripte.de', '', 'Test', 'Das ist ein reiner test der nichts zu sagen hat.', 120000.00, 0.00, 20, 1000, 20, 'administrator', 'paidmail', 1);

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

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
Eric Laufer's avatar
Eric Laufer committed
(1, '73238e5a5177906079438bbbffaa2ec1dd3c09fd739aa686c5cf24dfde21407e', 1, '', 120.00, 15274.00, '', 1551270348, 1551273789, 75, 0, 7500.00, 4, 709.44, 0, 0, 0, 75, 0, 17, 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),
(19, 0, 'werbesystem/paidmail_hist', 'Paidmail History', 3.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),
(30, 0, 'texte/startseite', 'Startseitentext', 5.00, 7),
(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);
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
Eric Laufer's avatar
Eric Laufer committed
(1, '', 'Freiberg', 'Deutschland', 'keine', 'blöd', 319565870, 'keine@keine.de', 'jfiobvhv', 'b@b.de', '', '', '', '');
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

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', '00:00:00.00000', '2019-02-24', 'zeit', '23:59:00.00000', '2019-02-24', 0.00, 0.00, '*0+1', 'mal die Maus gequält', 'Jeden Tag', 'dynamisch', '/100*2.5', 100020.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', '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', ' ', '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),
(7, 'Bettel', ' ', '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);
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', 'Anlegen', 'menu/menu_neu.php', '', 1),
(18, 'link_bearbeiten', '', '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),
(31, 'updaten_betreiberdaten', 'Updaten', 'class/betreiber.class.php', '', 1),
(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, 'updaten', 'Updaten !', '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', 'Speichern', 'menu/menu_neu.php', 'Neuen Menüpunkt anlegen', 1),
(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 Ändern', 'setting/admin.php', 'Zugangsdaten Admin ändern', 1),
(66, 'checkAdmin', 'Login', 'AdminLogin.php', 'Adminlogin', 1);
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,
  `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;

Eric Laufer's avatar
Eric Laufer committed
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`, `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, 20, '1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;21', 50.00, 250.00, 3600, '@sofort-mail.de;@trash-mail.de;@mailinator.com;@spamgourmet.com;@spammotel.com;@centermail.com;@discardmail.com;@sneakemail.com;@netzidiot.de;@myTrashMail.com;@wegwerfadresse.de;@nervmich.net;@nervtmich.net;@mailinator.net;@klassmaster.com;@mailin8r.com;@sogetthis.com;@mailinator2.com', '', '49063964bcbd485b6c42bf2cc3169d036d4bc8d26785689f7db7e297c0f489ab', 100, 2, '', 0, 0, 1, 1, 0, 0, 3600, 0.00, 1, 1, '', 'termin.coinhivepro.de', 465, 'termina@termin.coinhivepro.de', 'Lottchen27', 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
('AGB', '<p>das sind die AGB2</p>\r\n'),
('FAQ', '<p>Das sind die FAQ3</p>\r\n'),
('Wartungstext', '<p>Das ist der Wartungstext4</p>\r\n'),
isaack's avatar
1.1
isaack committed
('agb', 'AGB'),
Eric Laufer's avatar
Eric Laufer committed
('faq', 'FAQ'),
('impressum', 'Hier ist das Impressum');
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', 'Laufer', 'Eric', 1402062767, 5, 5, '', 1520726400, '1.png');
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
Eric Laufer's avatar
Eric Laufer committed
(1, 0, 100.00, 1402062767, 0.00, 0, 0.00, 0, 1548680439);
Eric Laufer's avatar
Eric Laufer committed

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

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

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

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

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

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

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

isaack's avatar
1.1
isaack committed
ALTER TABLE `vms_chat_einstellungen`
Eric Laufer's avatar
Eric Laufer committed
  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_cms_seiten`
Eric Laufer's avatar
Eric Laufer committed
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
Eric Laufer's avatar
Eric Laufer committed

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

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

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

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

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

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

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

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

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

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

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

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