Skip to content
Snippets Groups Projects
Find file Normal view History Permalink
mysql.txt 31.2 KiB
Newer Older
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
1 
CREATE TABLE `vms_adminblacklist` (
isaack's avatar
1.1
isaack committed
2 3 4 5 
  `tan` varchar(32) NOT NULL,
  `time` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
6 
CREATE TABLE `vms_aktivierungen` (
isaack's avatar
1.1
isaack committed
7 8 9 10 
  `uid` int(7) NOT NULL DEFAULT '0',
  `ak` varchar(32) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
11 12 
CREATE TABLE `vms_bettel_buchung` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
13 14 15 16 17 18 
  `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
funktion bilanz()  
isaack committed
19 20 21 22 23 24 25 26 27 
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
Version 0.0.6  
Eric Laufer committed
28 29 
CREATE TABLE `vms_box_admin` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
30 31 
  `name` text NOT NULL,
  `ordnung` int(11) NOT NULL DEFAULT '1',
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 
  `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),
(6, 'Konfigurationen', 5, 1, 1),
(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
47 48 49 
  `name` text NOT NULL,
  `ordnung` int(11) NOT NULL DEFAULT '1',
  `sichtbar` int(11) NOT NULL
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
50 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
51 52 

INSERT INTO `vms_box_user` (`id`, `name`, `ordnung`, `sichtbar`) VALUES
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
53 54 
(6, 'Navigation', 1, 1),
(7, 'Verdienen', 2, 1);
isaack's avatar
1.1
isaack committed
55
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
56 57 58 59 60 61 62 63 64 65 66 
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
67 68 69 70 71 72 73 
  `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
Version 0.0.6  
Eric Laufer committed
74 75 
CREATE TABLE `vms_chat` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
76 77 78 
  `absender` text NOT NULL,
  `nachricht` longtext NOT NULL,
  `time` int(11) NOT NULL
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
79 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
80
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
81 82 
CREATE TABLE `vms_chat_einstellungen` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
83 84 85 86 
  `chat_aktiv` int(11) NOT NULL,
  `hintergrundfarbe` text NOT NULL,
  `textfarbe` text NOT NULL,
  `profillink` text NOT NULL,
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
87 88 89 90 
  `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
91
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
92 93 
INSERT INTO `vms_chat_einstellungen` (`id`, `chat_aktiv`, `hintergrundfarbe`, `textfarbe`, `profillink`, `anzahl`, `sb_reload`, `sb_verguetung`) VALUES
(1, 2, '#000000', '#FFFFFF', '#FF6600', 100, 20, 100.00);
isaack's avatar
1.1
isaack committed
94
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
95 96 
CREATE TABLE `vms_cms_seiten` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
97 98 99 100 101 
  `titel` text NOT NULL,
  `text` longtext NOT NULL,
  `sichtbar` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
102 103 
CREATE TABLE `vms_crons` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
104 105 106 107 
  `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
Version 0.0.6  
Eric Laufer committed
108 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
109 110 111 

INSERT INTO `vms_crons` (`id`, `cron`, `laufzeit`, `datei`, `bezeichnung`) VALUES
(1, 'ext_cron', 0, 'crons/refzahlungen.knt.php', 'Ext. Refzahlungen'),
isaack's avatar
Texte,Cokkiehinweiß,News,meldung(),Buchungsliste  
isaack committed
112 113 
(2, 'framebrecher', 0, 'crons/framebrecherdown.php', 'Adscan.de Cron'),
(4, 'DB-Backup', 0, 'crons/db_backup.php', 'Datenbank Backup erstellen');
isaack's avatar
1.1
isaack committed
114
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
115 
CREATE TABLE `vms_emaildaten` (
isaack's avatar
1.1
isaack committed
116 117 118 119 120 121 
  `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
Version 0.0.6  
Eric Laufer committed
122 
(1, 'admin@admin.com', 1);
isaack's avatar
1.1
isaack committed
123
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
124 
CREATE TABLE `vms_fb_blacklist` (
isaack's avatar
1.1
isaack committed
125 126 127 
  `sponsor` varchar(255) NOT NULL,
  `kid` int(10) NOT NULL,
  `grund` tinyint(1) NOT NULL,
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
128 129 
  `werbeart` varchar(255) NOT NULL,
  `tan` text NOT NULL
isaack's avatar
1.1
isaack committed
130 131 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
132 
CREATE TABLE `vms_gebuchte_werbung` (
isaack's avatar
1.1
isaack committed
133 134 135 136 137 
  `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
Version 0.0.6  
Eric Laufer committed
138 139 
  `betreff` text NOT NULL,
  `text` longtext NOT NULL,
isaack's avatar
1.1
isaack committed
140 141 142 143 144 145 146 147 148 149 
  `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
Version 0.0.6  
Eric Laufer committed
150 
CREATE TABLE `vms_geburtstag` (
isaack's avatar
1.1
isaack committed
151 152 153 154 155 156 157 158 
  `geb_mail` int(11) NOT NULL,
  `geb_hoehe` double(100,2) NOT NULL,
  `geb_text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vms_geburtstag` (`geb_mail`, `geb_hoehe`, `geb_text`) VALUES
(1, 100.00, 'Hallo du da');
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
159 
CREATE TABLE `vms_interface` (
isaack's avatar
1.1
isaack committed
160 161 162 163 164 165 166 167 168 169 170 171 172 
  `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
Bug #2  
isaack committed
173 
CREATE TABLE `vms_kontodaten` (
isaack's avatar
bug  
isaack committed
174 
  `uid` int(7) NOT NULL,
isaack's avatar
neue Funktion  
isaack committed
175 
  `passwort` char(100) NOT NULL,
isaack's avatar
1.1
isaack committed
176 177 
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `hinweis` longtext NOT NULL,
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
178 179 
  `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
180 181 182 183 
  `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
bug  
isaack committed
184 
  `p_klicks` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
185 186 187 188 189 
  `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
Version 0.0.6  
Eric Laufer committed
190 
  `chat_sperre` int(11) NOT NULL DEFAULT '0',
isaack's avatar
1.1
isaack committed
191 
  `fc_klicks` int(100) NOT NULL,
isaack's avatar
bug  
isaack committed
192 193 194 195 196 
  `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
197
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
198 199 
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, '73238e5a5177906079438bbbffaa2ec1dd3c09fd739aa686c5cf24dfde21407e', 1, '', 3200.00, 15274.00, '', 1548507606, 1548507606, 51, 0, 5100.00, 4, 709.44, 0, 0, 0, 51, 0, 1, 0.00, 1);
isaack's avatar
1.1
isaack committed
200
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
201 
CREATE TABLE `vms_links_user` (
isaack's avatar
1.1
isaack committed
202 203 204 205 206 
  `link` text NOT NULL,
  `name` text NOT NULL,
  `box` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
207 208 
CREATE TABLE `vms_menu_admin` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
209 210 211 212 
  `link` text NOT NULL,
  `name` text NOT NULL,
  `ordnung` double(10,2) NOT NULL,
  `box` int(11) NOT NULL
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
213 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
214 215 216 217 218 219 220 221 222 223 224 225 

INSERT INTO `vms_menu_admin` (`id`, `link`, `name`, `ordnung`, `box`) VALUES
(1, 'usersystem/liste', 'Userliste', 1.00, 4),
(2, 'usersystem/doppelaccis', 'Doppelaccounts', 1.10, 4),
(3, 'usersystem/RefSchleifen', 'Refschleifen', 1.20, 4),
(4, 'newssystem/news', 'News schreiben', 1.00, 5),
(5, 'interfacedaten/pageconfig', 'Grundeinstellungen', 1.00, 6),
(6, 'interfacedaten/crons', 'Crons', 1.10, 6),
(7, 'interfacedaten/betreiber', 'Betreiberdaten', 1.20, 6),
(8, 'phpinfo', 'PHPInfo', 1.21, 6),
(9, 'interfacedaten/boxen_user', 'Boxverwaltung User', 1.30, 6),
(10, 'interfacedaten/boxen_admin', 'Boxverwaltung Admin', 1.31, 6),
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
226 227 
(11, 'interfacedaten/menue_user', 'Menüverwaltung User', 1.40, 6),
(12, 'interfacedaten/menue_admin', 'Menüverwaltung Admin', 1.41, 6),
isaack's avatar
1.1
isaack committed
228 229 230 231 232 233 234 235 236 
(13, 'texte/alternativwerbung', 'Alternativwerbung', 1.00, 7),
(14, 'texte/agb', 'AGB', 2.00, 7),
(15, 'texte/faq', 'FAQ', 3.00, 7),
(16, 'texte/wartung', 'Wartungstext', 4.00, 7),
(17, 'werbesystem/forcedbanner_468', 'Forced 468', 1.00, 8),
(18, 'werbesystem/paidmail', 'Paidmails verschicken', 2.00, 8),
(19, 'werbesystem/paidmail_hist', 'Paidmail History', 3.00, 8),
(20, 'interfacebanner/admin', 'Adminbanner', 1.00, 9),
(21, 'interfacebanner/blacklist', 'Blacklist', 2.00, 9),
isaack's avatar
Texte,Cokkiehinweiß,News,meldung(),Buchungsliste  
isaack committed
237 
(26, 'interfacedaten/chat_einstellungen', 'Chat Einstellungen', 1.22, 6),
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
238 239 
(27, 'cms/neue_seite', 'Neue Seite erstellen', 1.00, 10),
(28, 'cms/bearbeiten_seite', 'Seiten bearbeiten', 2.00, 10),
isaack's avatar
Texte,Cokkiehinweiß,News,meldung(),Buchungsliste  
isaack committed
240 241 242 243 
(29, 'interfacedaten/fackecheck', 'Google Fackecheck', 1.50, 6),
(30, 'texte/startseite', 'Startseitentext', 5.00, 7),
(31, 'buchungen', 'User-Buchungen', 1.30, 4),
(32, 'interfacedaten/db_backup', 'Datenbank Backup', 1.51, 6);
isaack's avatar
1.1
isaack committed
244
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
245 246 
CREATE TABLE `vms_menu_user` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
247 248 249 250 251 
  `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
Version 0.0.6  
Eric Laufer committed
252 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
253 254 

INSERT INTO `vms_menu_user` (`id`, `link`, `name`, `ordnung`, `box`, `cms_id`) VALUES
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
255 
(5, 'konto/uebersicht', 'Kontoübersicht', 1.00, 6, 0),
isaack's avatar
1.1
isaack committed
256 257 258 
(6, 'konto/einzahlen', 'Einzahlen', 1.21, 6, 0),
(7, 'konto/auszahlen', 'Auszahlen', 1.20, 6, 0),
(8, 'konto/buchungen', 'Buchungen', 1.30, 6, 0),
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
259 
(9, 'konto/refuebersicht', 'Refübersicht', 1.40, 6, 0),
isaack's avatar
1.1
isaack committed
260 261 262 263 264 
(10, 'konto/userprofil', 'Userprofil', 1.50, 6, 0),
(11, 'intern/startseite&logout=true', 'Logout', 2.00, 6, 0),
(12, 'verdienen/forcedbanner', 'Forcedbanner', 1.00, 7, 0),
(13, 'verdienen/betteln4', 'Betteln4Lose', 1.10, 7, 0),
(14, 'verdienen/paidmails', 'Paidmails', 1.20, 7, 0),
isaack's avatar
kleine bugfix  
isaack committed
265 
(15, 'framebrecher', 'Framebrecher', 1.00, 8, 0);
isaack's avatar
1.1
isaack committed
266
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
267 268 
CREATE TABLE `vms_multi_konten` (
  `uid` int(1) UNSIGNED NOT NULL,
isaack's avatar
1.1
isaack committed
269 270 271 272 
  `kontoid` varchar(32) NOT NULL,
  `waehrung` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
273 274 
CREATE TABLE `vms_news` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
275 276 277 
  `zeit` int(11) NOT NULL DEFAULT '0',
  `titel` varchar(60) NOT NULL DEFAULT '',
  `news` longtext NOT NULL
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
278 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
279
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
280 281 
CREATE TABLE `vms_news_komment` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
282 283 284 285 
  `uid` int(11) NOT NULL,
  `datum` int(11) NOT NULL,
  `news` int(11) NOT NULL,
  `kommentar` longtext NOT NULL
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
286 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
287
isaack's avatar
kleine bugs  
isaack committed
288 289 
CREATE TABLE `vms_nickpage` (
  `uid` int(11) NOT NULL,
Eric Laufer's avatar
Bug, Update run.inc.php  
Eric Laufer committed
290 291 292 293 294 
  `sex` text NOT NULL,
  `ort` text NOT NULL,
  `land` text NOT NULL,
  `hobbys` longtext NOT NULL,
  `beruf` text NOT NULL,
isaack's avatar
kleine bugs  
isaack committed
295 
  `icq` int(11) NOT NULL,
Eric Laufer's avatar
Bug, Update run.inc.php  
Eric Laufer committed
296 297 298 299 300 301 302 
  `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
kleine bugs  
isaack committed
303 304 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
305 306 
INSERT INTO `vms_nickpage` (`uid`, `sex`, `ort`, `land`, `hobbys`, `beruf`, `icq`, `msn`, `aim`, `skype`, `www`, `www1`, `www2`, `www3`) VALUES
(1, '', '', '', '', 'blöd', '', 'keine@keine.de', '', 'b@b.de', '', '', '', '');
isaack's avatar
1.1
isaack committed
307
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
308 309 
CREATE TABLE `vms_rallydaten` (
  `id` tinyint(1) NOT NULL,
isaack's avatar
1.1
isaack committed
310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 
  `name` varchar(50) NOT NULL DEFAULT '',
  `beschrieb` longtext NOT NULL,
  `status` enum('aktive','deaktiviert') NOT NULL,
  `start` int(11) NOT NULL DEFAULT '0',
  `ende_art` enum('punkt','zeit') NOT NULL DEFAULT 'zeit' COMMENT 'nach was die rally beendet wird',
  `ende_zeit` int(11) NOT NULL DEFAULT '0',
  `ende_punkte` double(15,2) NOT NULL,
  `ende_punkte_aktuell` double(15,2) NOT NULL DEFAULT '0.00' COMMENT 'wie viel schon erreicht ist von ende_punkte',
  `ende_punkte_anzahl` varchar(10) NOT NULL,
  `ende_formulierung` varchar(50) NOT NULL DEFAULT '' COMMENT 'Was in der Seite fr eine formulierung steht',
  `ende_vortschritt` enum('Jeden Tag','Jede Woche','Jeden Monat','Jedes Jahr','datum') NOT NULL DEFAULT 'datum',
  `gewinn_art` enum('statisch','dynamisch') NOT NULL DEFAULT 'statisch' COMMENT 'gewinntopf dynmaisch oder statisch',
  `gewinn_dyn_steigerung` varchar(50) NOT NULL DEFAULT '0.00' COMMENT 'steigerung des gewinnes bei dynamisch',
  `gewinn_topf` double(15,2) NOT NULL DEFAULT '0.00',
  `gewinner_anzahl` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50') NOT NULL DEFAULT '0',
  `mindestpunktzhl` int(10) NOT NULL DEFAULT '0',
  `sperruser` varchar(200) NOT NULL,
  `tagpotstart` double(15,2) NOT NULL,
  `einheit` varchar(50) NOT NULL,
  `p1` double(10,2) NOT NULL DEFAULT '0.00',
  `p2` double(10,2) NOT NULL DEFAULT '0.00',
  `p3` double(10,2) NOT NULL DEFAULT '0.00',
  `p4` double(10,2) NOT NULL DEFAULT '0.00',
  `p5` double(10,2) NOT NULL DEFAULT '0.00',
  `p6` double(10,2) NOT NULL DEFAULT '0.00',
  `p7` double(10,2) NOT NULL DEFAULT '0.00',
  `p8` double(10,2) NOT NULL DEFAULT '0.00',
  `p9` double(10,2) NOT NULL DEFAULT '0.00',
  `p10` double(10,2) NOT NULL DEFAULT '0.00',
  `p11` double(10,2) NOT NULL DEFAULT '0.00',
  `p12` double(10,2) NOT NULL DEFAULT '0.00',
  `p13` double(10,2) NOT NULL DEFAULT '0.00',
  `p14` double(10,2) NOT NULL DEFAULT '0.00',
  `p15` double(10,2) NOT NULL DEFAULT '0.00',
  `p16` double(10,2) NOT NULL DEFAULT '0.00',
  `p17` double(10,2) NOT NULL DEFAULT '0.00',
  `p18` double(10,2) NOT NULL DEFAULT '0.00',
  `p19` double(10,2) NOT NULL DEFAULT '0.00',
  `p20` double(10,2) NOT NULL DEFAULT '0.00',
  `p21` double(10,2) NOT NULL DEFAULT '0.00',
  `p22` double(10,2) NOT NULL DEFAULT '0.00',
  `p23` double(10,2) NOT NULL DEFAULT '0.00',
  `p24` double(10,2) NOT NULL DEFAULT '0.00',
  `p25` double(10,2) NOT NULL DEFAULT '0.00',
  `p26` double(10,2) NOT NULL DEFAULT '0.00',
  `p27` double(10,2) NOT NULL DEFAULT '0.00',
  `p28` double(10,2) NOT NULL DEFAULT '0.00',
  `p29` double(10,2) NOT NULL DEFAULT '0.00',
  `p30` double(10,2) NOT NULL DEFAULT '0.00',
  `p31` double(10,2) NOT NULL DEFAULT '0.00',
  `p32` double(10,2) NOT NULL DEFAULT '0.00',
  `p33` double(10,2) NOT NULL DEFAULT '0.00',
  `p34` double(10,2) NOT NULL DEFAULT '0.00',
  `p35` double(10,2) NOT NULL DEFAULT '0.00',
  `p36` double(10,2) NOT NULL DEFAULT '0.00',
  `p37` double(10,2) NOT NULL DEFAULT '0.00',
  `p38` double(10,2) NOT NULL DEFAULT '0.00',
  `p39` double(10,2) NOT NULL DEFAULT '0.00',
  `p40` double(10,2) NOT NULL DEFAULT '0.00',
  `p41` double(10,2) NOT NULL DEFAULT '0.00',
  `p42` double(10,2) NOT NULL DEFAULT '0.00',
  `p43` double(10,2) NOT NULL DEFAULT '0.00',
  `p44` double(10,2) NOT NULL DEFAULT '0.00',
  `p45` double(10,2) NOT NULL DEFAULT '0.00',
  `p46` double(10,2) NOT NULL DEFAULT '0.00',
  `p47` double(10,2) NOT NULL DEFAULT '0.00',
  `p48` double(10,2) NOT NULL DEFAULT '0.00',
  `p49` double(10,2) NOT NULL DEFAULT '0.00',
  `p50` double(10,2) NOT NULL DEFAULT '0.00'
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
379 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
380 381 

INSERT INTO `vms_rallydaten` (`id`, `name`, `beschrieb`, `status`, `start`, `ende_art`, `ende_zeit`, `ende_punkte`, `ende_punkte_aktuell`, `ende_punkte_anzahl`, `ende_formulierung`, `ende_vortschritt`, `gewinn_art`, `gewinn_dyn_steigerung`, `gewinn_topf`, `gewinner_anzahl`, `mindestpunktzhl`, `sperruser`, `tagpotstart`, `einheit`, `p1`, `p2`, `p3`, `p4`, `p5`, `p6`, `p7`, `p8`, `p9`, `p10`, `p11`, `p12`, `p13`, `p14`, `p15`, `p16`, `p17`, `p18`, `p19`, `p20`, `p21`, `p22`, `p23`, `p24`, `p25`, `p26`, `p27`, `p28`, `p29`, `p30`, `p31`, `p32`, `p33`, `p34`, `p35`, `p36`, `p37`, `p38`, `p39`, `p40`, `p41`, `p42`, `p43`, `p44`, `p45`, `p46`, `p47`, `p48`, `p49`, `p50`) VALUES
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
382 
(1, 'Tagesklick', ' Diese rally wird Täglich um Mitternacht neugestartet', 'aktive', 1230768000, 'zeit', 1388534400, 0.00, 0.00, '*0+1', 'mal die Maus gequält', 'Jeden Tag', 'dynamisch', '/100*2.5', 0.00, '10', 50, ' ', 100000.00, ' Klicks', 45.00, 20.00, 10.00, 5.00, 4.00, 3.50, 3.00, 2.50, 2.00, 1.50, 1.00, 0.90, 0.70, 0.50, 0.40, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
isaack's avatar
1.1
isaack committed
383 384 385 386 
(4, 'Klick', ' ', 'deaktiviert', 0, 'zeit', 0, 0.00, 0.00, '0', ' ', 'datum', 'statisch', '0.00', 0.00, '0', 0, ' ', 0.00, ' ', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(6, 'Aktive', ' ', 'deaktiviert', 0, 'zeit', 0, 0.00, 0.00, '0', ' ', 'datum', 'statisch', '0.00', 0.00, '0', 0, ' ', 0.00, ' ', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(7, 'Bettel', ' ', 'deaktiviert', 0, 'zeit', 0, 0.00, 0.00, '0', ' ', 'datum', 'statisch', '0.00', 0.00, '0', 0, ' ', 0.00, ' ', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00);
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
387 388 
CREATE TABLE `vms_rallyorte` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
389 390 
  `name` varchar(50) NOT NULL,
  `welche_rallys` varchar(1000) NOT NULL
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
391 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
1.1
isaack committed
392 393 394 395 396 397 

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
Version 0.0.6  
Eric Laufer committed
398 
CREATE TABLE `vms_rallyuser` (
isaack's avatar
1.1
isaack committed
399 400 401 402 403 404 405 
  `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
Version 0.0.6  
Eric Laufer committed
406 
CREATE TABLE `vms_reloads` (
isaack's avatar
1.1
isaack committed
407 408 409 410 411 412 
  `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
Version 0.0.6  
Eric Laufer committed
413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 
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),
(9, 'admin_box_save', 'Speichern', 'boxen/admin_boxen_neu.php', 'Menübox Adminbereich erstellen', 1),
(10, 'admin_box_loschen', 'Löschen', 'boxen/admin_loschen.php', 'Menüboxen admin löschen', 1),
(11, 'admin_box_aendern', 'Ändern', 'boxen/admin_andern.php', 'Menübocen admin bearbeiten', 1),
(12, 'box_save', 'Speichern', 'boxen/boxen_neu.php', 'Menüboxen User erstellen', 1),
(13, 'aendern', 'Ändern', 'boxen/andern.php', 'Menüboxen User bearbeiten', 1),
(14, 'box_loschen', 'Löschen', 'boxen/loschen.php', 'Menüboxen User löschen', 1),
(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),
(19, 'link_loschen', '', 'menu/menu_loschen.php', '', 1),
(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),
(24, 'admin_link_loschen', '', 'menu/admin_menu_loschen.php', '', 1),
(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),
(41, 'FBDelete', 'Löschen', 'werbung/FBDelete.php', 'Banner Löschen', 1);

CREATE TABLE `vms_schnittstelle` (
  `name` text NOT NULL,
isaack's avatar
1.1
isaack committed
463 464 465 466 467 468 469 470 471 472 
  `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
Version 0.0.6  
Eric Laufer committed
473 474 475 
  `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
476 477 478 479 480 
  `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
Version 0.0.6  
Eric Laufer committed
481 482 
CREATE TABLE `vms_schnittstelle_anfragen` (
  `id` int(11) NOT NULL,
isaack's avatar
1.1
isaack committed
483 
  `zeit` int(11) NOT NULL DEFAULT '0',
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
484 485 486 
  `uid` int(7) NOT NULL DEFAULT '0',
  `betrag` double(100,2) NOT NULL,
  `art` text NOT NULL
isaack's avatar
1.1
isaack committed
487 488 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
DB-Backup,Design und Bugfix, Funktionen  
isaack committed
489 
CREATE TABLE `vms_seitenkonfig` (
isaack's avatar
1.1
isaack committed
490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 
  `wartung` int(1) NOT NULL DEFAULT '0',
  `domain` text NOT NULL,
  `seitenname` text NOT NULL,
  `waehrung` text NOT NULL,
  `betreibermail` text NOT NULL,
  `cron_pw` text NOT NULL,
  `einzahlgrenze` int(11) NOT NULL DEFAULT '0',
  `re1` double(10,2) NOT NULL DEFAULT '0.00',
  `re2` double(10,2) NOT NULL DEFAULT '0.00',
  `re3` double(10,2) NOT NULL DEFAULT '0.00',
  `min_betteln` double(10,2) NOT NULL DEFAULT '0.00',
  `max_betteln` double(10,2) NOT NULL DEFAULT '0.00',
  `reload_betteln` int(11) NOT NULL DEFAULT '0',
  `denied_domains` text NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `admin_pass` varchar(255) NOT NULL,
  `auszahlgrenze` double NOT NULL DEFAULT '100',
  `chat_aktiv` int(11) NOT NULL,
  `fake_schluessel` text NOT NULL,
  `anzeige_chat` int(11) NOT NULL,
  `anzeige_text` int(11) NOT NULL,
  `geb_addon` int(11) NOT NULL,
isaack's avatar
DB-Backup,Design und Bugfix, Funktionen  
isaack committed
512 513 514 515 516 517 518 
  `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
Version 0.0.6  
Eric Laufer committed
519 520 521 522 523 524 
  `ip_erlaubt` text NOT NULL,
  `SMTP_HOST` text NOT NULL,
  `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
525 526 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
527 528 529 530 
INSERT INTO `vms_seitenkonfig` (`wartung`, `domain`, `seitenname`, `waehrung`, `betreibermail`, `cron_pw`, `einzahlgrenze`, `re1`, `re2`, `re3`, `min_betteln`, `max_betteln`, `reload_betteln`,  `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_LOGIN`, `SMTP_PASS`, `kontostand_b`, `kontostand_b_name`) VALUES
(0, 'http://vms-suee.vms1-scripte.de', 'Vms SUEE', 'suees', 'info@vms1-scripte.de', 'cronpw', 100000, 8.00, 3.00, 1.00, 50.00, 250.00, 0, 100, 2, '', 1, 1, 1, 1, 0, 0, 0, 0.00, 1, 0, '', 'termin.coinhivepro.de', 'termina@termin.coinhivepro.de', 'Lottchen27', 1, 'bonuswährung');

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

INSERT INTO `vms_texte` (`name`, `text`) VALUES
('agb', 'AGB'),
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
537 538 
('faq', 'FAQ'),
('impressum', 'Hier ist das Impressum');
isaack's avatar
1.1
isaack committed
539
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
540 
CREATE TABLE `vms_userblacklist` (
isaack's avatar
1.1
isaack committed
541 542 543 544 
  `uid` int(7) NOT NULL DEFAULT '0',
  `zeit` bigint(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
isaack's avatar
kleine bugs  
isaack committed
545 
CREATE TABLE `vms_userdaten` (
isaack's avatar
1.1
isaack committed
546 547 548 549 550 551 
  `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
kleine bugs  
isaack committed
552 
  `max_paidlinks` int(11) NOT NULL DEFAULT '5',
isaack's avatar
1.1
isaack committed
553 
  `notizen` text NOT NULL,
isaack's avatar
kleine bugs  
isaack committed
554 
  `bdate` int(11) NOT NULL
isaack's avatar
1.1
isaack committed
555 556 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
557 558 
INSERT INTO `vms_userdaten` (`uid`, `nickname`, `vorname`, `nachname`, `angemeldet_seit`, `max_forced`, `max_paidlinks`, `notizen`, `bdate`) VALUES
(1, 'admin', 'g', 'g', 1402062767, 5, 5, '', 1520726400);
isaack's avatar
1.1
isaack committed
559
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
560 561 562 563 564 565 566 567 
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
568 569 570 571 572 573 574 575 576 577 578 579 
  `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
Version 0.0.6  
Eric Laufer committed
580 
(1, 0, 100.00, 0, 0.00, 0, 0.00, 0, 0);
Eric Laufer's avatar
run.inc.php  
Eric Laufer committed
581
isaack's avatar
1.1
isaack committed
582 
ALTER TABLE `vms_adminblacklist`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
583 
  ADD PRIMARY KEY (`tan`);
isaack's avatar
1.1
isaack committed
584 585 

ALTER TABLE `vms_aktivierungen`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
586 
  ADD KEY `aktivierungs_code` (`ak`);
isaack's avatar
1.1
isaack committed
587 588 

ALTER TABLE `vms_bettel_buchung`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
589 590 591 592 
  ADD PRIMARY KEY (`id`);

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

ALTER TABLE `vms_box_admin`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
595 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
596 597 

ALTER TABLE `vms_box_user`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
598 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
599 600 

ALTER TABLE `vms_buchungen`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
601 602 
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`uid`);
isaack's avatar
1.1
isaack committed
603 604 

ALTER TABLE `vms_chat`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
605 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
606 607 

ALTER TABLE `vms_chat_einstellungen`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
608 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
609 610 

ALTER TABLE `vms_cms_seiten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
611 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
612 613 

ALTER TABLE `vms_crons`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
614 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
615 616 

ALTER TABLE `vms_emaildaten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
617 618 
  ADD PRIMARY KEY (`uid`),
  ADD KEY `freigabe_fuer` (`freigabe_fuer`);
isaack's avatar
1.1
isaack committed
619 620 

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

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

ALTER TABLE `vms_interface`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
628 
  ADD KEY `interface` (`interface`);
isaack's avatar
1.1
isaack committed
629 630 

ALTER TABLE `vms_kontodaten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
631 
  ADD PRIMARY KEY (`uid`);
isaack's avatar
1.1
isaack committed
632 633 

ALTER TABLE `vms_menu_admin`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
634 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
635 636 

ALTER TABLE `vms_menu_user`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
637 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
638 639 

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

ALTER TABLE `vms_news`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
643 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
644 645 

ALTER TABLE `vms_news_komment`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
646 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
647 648 

ALTER TABLE `vms_rallydaten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
649 650 
  ADD PRIMARY KEY (`id`);
ALTER TABLE `vms_rallydaten` ADD FULLTEXT KEY `sperruser` (`sperruser`);
isaack's avatar
1.1
isaack committed
651 652 

ALTER TABLE `vms_rallyorte`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
653 
  ADD PRIMARY KEY (`id`);
isaack's avatar
1.1
isaack committed
654 655 

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

ALTER TABLE `vms_reloads`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
659 660 661 662 
  ADD KEY `klick4` (`tan`,`uid`,`ip`);

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

ALTER TABLE `vms_schnittstelle`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
665 666 
  ADD PRIMARY KEY (`schnittstelle`),
  ADD KEY `aktiv` (`aktiv`);
isaack's avatar
1.1
isaack committed
667 668 

ALTER TABLE `vms_schnittstelle_anfragen`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
669 670 
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`);
isaack's avatar
1.1
isaack committed
671 672 

ALTER TABLE `vms_userblacklist`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
673 
  ADD PRIMARY KEY (`uid`);
isaack's avatar
1.1
isaack committed
674 675 

ALTER TABLE `vms_userdaten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
676 677 678 679 
  ADD PRIMARY KEY (`uid`);

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

ALTER TABLE `vms_werberdaten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
682 
  ADD PRIMARY KEY (`uid`);
isaack's avatar
1.1
isaack committed
683 684 

ALTER TABLE `vms_bettel_buchung`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
685 686 687 688 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

ALTER TABLE `vms_box_admin`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
691 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
692 693 

ALTER TABLE `vms_box_user`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
694 695 696 697 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

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

ALTER TABLE `vms_chat`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
700 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
701 702 

ALTER TABLE `vms_chat_einstellungen`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
703 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
704 705 

ALTER TABLE `vms_cms_seiten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
706 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
isaack's avatar
1.1
isaack committed
707 708 

ALTER TABLE `vms_crons`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
709 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
710 711 

ALTER TABLE `vms_kontodaten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
712 
  MODIFY `uid` int(7) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
713 714 

ALTER TABLE `vms_menu_admin`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
715 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
716 717 

ALTER TABLE `vms_menu_user`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
718 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
719 720 

ALTER TABLE `vms_news`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
721 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
722 723 

ALTER TABLE `vms_news_komment`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
724 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
725 726 

ALTER TABLE `vms_rallydaten`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
727 
  MODIFY `id` tinyint(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
isaack's avatar
1.1
isaack committed
728 729 

ALTER TABLE `vms_rallyorte`
Eric Laufer's avatar
Version 0.0.6  
Eric Laufer committed
730 731 732 733 734 735 736 737 738 739 
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

ALTER TABLE `vms_run_inc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

ALTER TABLE `vms_schnittstelle_anfragen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

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