[1.2] alternative .sql-Datei zum Download

**eaxo** · 26.01.2008, 23:06

Wenn ich das hier aus den Augen verliere und die Datei vom Server lösche mal die .sql im Codefenster:

Code:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


CREATE TABLE IF NOT EXISTS `v12_aktivierungen` (
  `uid` int(7) NOT NULL default '0',
  `ak` varchar(32) NOT NULL default '',
  KEY `aktivierungs_code` (`ak`)
) ENGINE=MyISAM;



CREATE TABLE IF NOT EXISTS `v12_aktivralley` (
  `uid` int(7) NOT NULL default '0',
  `punkte` double(100,2) NOT NULL default '0.00',
  `ausgezahlt` int(11) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;


CREATE TABLE IF NOT EXISTS `v12_bilanz` (
  `date` int(10) NOT NULL,
  `ein` double(15,2) NOT NULL,
  `aus` double(15,2) NOT NULL,
  PRIMARY KEY  (`date`)
) ENGINE=MyISAM;


CREATE TABLE IF NOT EXISTS `v12_buchungen` (
  `uid` int(7) NOT NULL default '0',
  `buchungszeit` int(10) NOT NULL default '0',
  `buchungs_id` varchar(14) NOT NULL default '',
  `buchungsmenge` double(10,2) NOT NULL default '0.00',
  `verwendungszweck` varchar(40) NOT NULL default '',
  KEY `user` (`uid`)
) ENGINE=MyISAM;


CREATE TABLE IF NOT EXISTS `v12_crons` (
  `id` int(11) NOT NULL,
  `cron` varchar(50) NOT NULL default '',
  `laufzeit` int(11) NOT NULL default '0',
  `datei` varchar(250) NOT NULL default '',
  `bezeichnung` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;


INSERT INTO `v12_crons` (`id`, `cron`, `laufzeit`, `datei`, `bezeichnung`) VALUES
(1, 'int_forcedbanner', 1184066684, 'crons/fuco-ads.int.php', 'Forcedbanner FuCo-Ads'),
(2, 'int_forcedbanner', 1187204732, 'crons/webmasterlose.int.php', 'Forcedbanner Webmasterlose'),
(3, 'int_forcedbanner', 1183938260, 'crons/hp-lose.int.php', 'Forcedbanner HP-Lose'),
(4, 'int_forcedbanner', 1106400662, 'crons/lose-ads.int.php', 'Forcedbanner Lose-Ads'),
(5, 'int_forcedbanner', 1106400676, 'crons/losebox.int.php', 'Forcedbanner Losebox'),
(6, 'ext_cron', 1105221240, 'crons/refzahlungen.knt.php', 'Ext. Refzahlungen');


CREATE TABLE IF NOT EXISTS `v12_emaildaten` (
  `uid` int(7) NOT NULL default '0',
  `emailadresse` varchar(100) NOT NULL default '',
  `freigabe_fuer` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  KEY `freigabe_fuer` (`freigabe_fuer`)
) ENGINE=MyISAM;


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


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

INSERT INTO `v12_interface` (`interface`, `betreiber`, `seite`, `pass`, `eigenverdienst`, `mindestverguetung`, `restklicks`, `umrechnung`, `aufendhalt`, `surfview`, `surfklick`) VALUES
('fuco-ads', 0, 0, '0', 0, 0.000000, 0, 0.0000, 0, 0.00, 0.00),
('webmasterlose', 0, 0, '0', 0, 0.000000, 50, 0.0000, 0, 0.00, 0.00),
('lose-ads', 0, 0, '0', 0, 0.000000, 0, 0.0000, 0, 0.00, 0.00),
('losebox', 0, 0, '0', 0, 0.000000, 0, 0.0000, 0, 0.00, 0.00),
('hp-lose', 0, 0, '0', 0, 0.000000, 0, 0.0000, 0, 0.00, 0.00);


CREATE TABLE IF NOT EXISTS `v12_klickralley` (
  `uid` int(7) NOT NULL default '0',
  `klicks` int(11) NOT NULL default '0',
  `ausgezahlt` int(11) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;


CREATE TABLE IF NOT EXISTS `v12_kontodaten` (
  `uid` int(7) NOT NULL default '0',
  `passwort` varchar(32) NOT NULL default '',
  `status` tinyint(1) NOT NULL default '0',
  `hinweis` longtext NOT NULL,
  `kontostand` double(100,2) NOT NULL default '0.00',
  `login_ip` varchar(15) NOT NULL default '',
  `loginzeit` int(11) NOT NULL default '0',
  `last_active` int(11) NOT NULL default '0',
  `klicks` bigint(20) NOT NULL default '0',
  `kv` double(100,2) NOT NULL default '0.00',
  `angebettelt` bigint(20) NOT NULL default '0',
  `bv` double(100,2) NOT NULL default '0.00',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `v12_news` (
  `id` int(11) NOT NULL,
  `zeit` int(11) NOT NULL default '0',
  `titel` varchar(60) NOT NULL default '',
  `news` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `v12_paidmails_empfaenger` (
  `uid` int(7) NOT NULL default '0',
  `gueltig` int(11) NOT NULL default '0',
  `tan` varchar(14) NOT NULL default '',
  `status` int(11) NOT NULL default '0',
  `aufendhalt` int(11) NOT NULL default '0',
  `start` int(11) NOT NULL default '0',
  UNIQUE KEY `primary_ersatz` (`uid`,`tan`)
) ENGINE=MyISAM;

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

CREATE TABLE IF NOT EXISTS `v12_ralleydaten` (
  `ralley` varchar(50) NOT NULL default '',
  `start` int(11) NOT NULL default '0',
  `ende` int(11) NOT NULL default '0',
  `art` varchar(50) NOT NULL default '',
  `pro` double(10,2) NOT NULL default '0.00',
  `jackpot` double(10,2) NOT NULL default '0.00',
  `plaetze` int(2) NOT NULL default '0',
  `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',
  PRIMARY KEY  (`ralley`)
) ENGINE=MyISAM;

INSERT INTO `v12_ralleydaten` (`ralley`, `start`, `ende`, `art`, `pro`, `jackpot`, `plaetze`, `p1`, `p2`, `p3`, `p4`, `p5`, `p6`, `p7`, `p8`, `p9`, `p10`) VALUES
('refralley', 1135689000, 1293455400, 'statisch', 0.00, 0.00, 3, 150.00, 500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
('aktivralley', 1112047200, 1112292000, 'statisch', 6.00, 0.00, 5, 1000.00, 750.00, 500.00, 250.00, 100.00, 0.00, 0.00, 0.00, 0.00, 0.00),
('klickralley', 1104534000, 1230764400, 'dynamisch', 3.00, 0.00, 2, 1000000.00, 500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00);


CREATE TABLE IF NOT EXISTS `v12_reloads` (
  `ip` varchar(15) NOT NULL default '',
  `uid` int(7) NOT NULL default '0',
  `tan` varchar(32) NOT NULL default '',
  `bis` int(10) NOT NULL default '0',
  KEY `klick4` (`tan`,`uid`,`ip`)
) ENGINE=MyISAM;


CREATE TABLE IF NOT EXISTS `v12_schnittstelle` (
  `betreiber_id` int(8) NOT NULL default '0',
  `betreiber_passwort` varchar(50) NOT NULL default '',
  `betreiber_kennung` int(8) NOT NULL default '0',
  `schnittstelle` varchar(20) NOT NULL default '',
  `einzahltext` varchar(40) NOT NULL default '',
  `auszahltext` varchar(40) NOT NULL default '',
  `einzahlsumme` int(11) NOT NULL default '0',
  `auszahlsumme` int(11) NOT NULL default '0',
  `anfragen_tag` int(11) NOT NULL default '0',
  `anfragen_user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`schnittstelle`)
) ENGINE=MyISAM;

INSERT INTO `v12_schnittstelle` (`betreiber_id`, `betreiber_passwort`, `betreiber_kennung`, `schnittstelle`, `einzahltext`, `auszahltext`, `einzahlsumme`, `auszahlsumme`, `anfragen_tag`, `anfragen_user`) VALUES
(0, '0', 0, 'klamm', 'Einzahlung', 'Auszahlung', 0, 0, 0, 0);

CREATE TABLE IF NOT EXISTS `v12_schnittstelle_anfragen` (
  `zeit` int(11) NOT NULL default '0',
  `uid` int(7) NOT NULL default '0',
  KEY `uid` (`uid`)
) ENGINE=MyISAM;


CREATE TABLE IF NOT EXISTS `v12_seitenkonfig` (
  `wartung` int(1) NOT NULL default '0',
  `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
) ENGINE=MyISAM;

INSERT INTO `v12_seitenkonfig` (`wartung`, `einzahlgrenze`, `re1`, `re2`, `re3`, `min_betteln`, `max_betteln`, `reload_betteln`, `denied_domains`) VALUES
(0, 100000, 8.00, 3.00, 1.00, 50.00, 250.00, 0, '@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');

CREATE TABLE IF NOT EXISTS `v12_userblacklist` (
  `uid` int(7) NOT NULL default '0',
  `zeit` bigint(11) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `v12_userdaten` (
  `uid` int(7) NOT NULL default '0',
  `nickname` varchar(255) NOT NULL default '',
  `vorname` varchar(50) NOT NULL default '',
  `nachname` varchar(50) NOT NULL default '',
  `angemeldet_seit` int(10) NOT NULL default '0',
  `max_forced` int(11) NOT NULL default '5',
  `notizen` text NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;


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

Gruß
Eaxo

Thema: [1.2] alternative .sql-Datei zum Download

Themen-Optionen

Anzeige

Baum-Darstellung

Ähnliche Themen

Kingbonus alternative

Captcha Alternative/Zusatz

Linux zip-Alternative ?

Paint (Alternative) für MacOS X 10.5.

Berechtigungen