Notes

-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- Üretim Zamanı: 29 Tem 2015, 00:54:32
-- Sunucu sürümü: 5.5.42-cll
-- PHP Sürümü: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Veritabanı: `instagra_m`
--

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `adminLog`
--

CREATE TABLE IF NOT EXISTS `adminLog` (
`id` bigint(250) NOT NULL AUTO_INCREMENT,
`aID` int(11) NOT NULL,
`byProcessed` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`logContent` text COLLATE utf8_turkish_ci NOT NULL,
`lDate` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`yBaslik` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`yEmail` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`yPassword` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ;

--
-- Tablo döküm verisi `admins`
--

INSERT INTO `admins` (`id`, `yBaslik`, `yEmail`, `yPassword`) VALUES
(1, 'Selçuk Çelik', '[email protected]', 'a7c9b9a27dbed64ea11b93003b1b8b92'),
(2, 'Rıfat Özkan', '[email protected]', '20e263475a8a535c137925aa1531ce2b');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `applications`
--

CREATE TABLE IF NOT EXISTS `applications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`appBaslik` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`clientID` varchar(3000) CHARACTER SET utf8 NOT NULL,
`clientSecret` varchar(3000) CHARACTER SET utf8 NOT NULL,
`callbackURL` varchar(3000) CHARACTER SET utf8 NOT NULL,
`accessToken` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`uStatus` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ;

--
-- Tablo döküm verisi `applications`
--

INSERT INTO `applications` (`id`, `appBaslik`, `clientID`, `clientSecret`, `callbackURL`, `accessToken`, `uStatus`) VALUES
(2, 'Instanaliz -1', '369586004e0049c988f3a504db1b2ba0', 'a90acc0be59242f68bbfcab6f6b83904', 'https://www.instanaliz.com/callback', '1515905958.1677ed0.eb2e533fefd249cdaed5b4c154433659', 1);

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `likeAccounts`
--

CREATE TABLE IF NOT EXISTS `likeAccounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`authType` int(1) NOT NULL DEFAULT '0',
`appID` int(11) NOT NULL,
`genderID` int(1) NOT NULL DEFAULT '0',
`iUserName` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`_iID` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`likeJSON` text COLLATE utf8_turkish_ci NOT NULL,
`_ID` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`regexString` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`commentCheck` int(1) NOT NULL DEFAULT '0',
`endDate` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
`lastCheck` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `likeComments`
--

CREATE TABLE IF NOT EXISTS `likeComments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`aID` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
`comments` longtext CHARACTER SET utf16 COLLATE utf16_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `likeLogs`
--

CREATE TABLE IF NOT EXISTS `likeLogs` (
`id` bigint(250) NOT NULL AUTO_INCREMENT,
`aID` int(11) NOT NULL,
`logType` int(1) NOT NULL DEFAULT '0',
`_ID` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`iURL` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`quantity` bigint(250) NOT NULL,
`lDate` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `members`
--

CREATE TABLE IF NOT EXISTS `members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`appID` int(11) NOT NULL,
`_ID` bigint(250) NOT NULL,
`iUserName` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`iPassword` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`iFullName` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`iGender` int(1) NOT NULL DEFAULT '0',
`iProfileImage` varchar(3000) COLLATE utf8_turkish_ci NOT NULL,
`iMediaCount` int(11) NOT NULL,
`iFollowersCount` int(11) NOT NULL,
`iFollowedCount` int(11) NOT NULL,
`accessToken` varchar(3000) COLLATE utf8_turkish_ci NOT NULL,
`dCredit` int(11) NOT NULL,
`mType` int(1) NOT NULL DEFAULT '0',
`gEndDate` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
`iAdvertising` int(1) NOT NULL DEFAULT '0',
`iOzel` int(1) NOT NULL DEFAULT '0',
`iOzelLimit` text COLLATE utf8_turkish_ci NOT NULL,
`iCookie` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `payments`
--

CREATE TABLE IF NOT EXISTS `payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`_ID` varchar(1000) CHARACTER SET utf8 NOT NULL,
`comment` varchar(5000) COLLATE utf8_turkish_ci NOT NULL,
`amount` varchar(1000) CHARACTER SET utf8 NOT NULL,
`orginalAmount` varchar(1000) CHARACTER SET utf8 NOT NULL,
`payerEmail` varchar(1000) CHARACTER SET utf8 NOT NULL,
`pDate` varchar(100) CHARACTER SET utf8 NOT NULL,
`pStatus` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=8 ;

--
-- Tablo döküm verisi `payments`
--

INSERT INTO `payments` (`id`, `_ID`, `comment`, `amount`, `orginalAmount`, `payerEmail`, `pDate`, `pStatus`) VALUES
(1, '1575092675', '100(OK) - @ogimese06 100 Kredi Satin Alma', '9.21', '10.00', '[email protected]', '1437172338', 1),
(2, '1575092675', '100(OK) - @ogimese06 100 Kredi Satin Alma', '9.21', '10.00', '[email protected]', '1437173584', 1),
(3, '342227015', '100(OK) - @erkan_ur 100 Kredi Satin Alma', '9.21', '10.00', '[email protected]', '1437176487', 1),
(5, '342227015', '100(OK) - @erkan_ur 100 Kredi Satin Alma', '9.21', '10.00', '[email protected]', '1437183326', 1),
(6, '1303627866', '100(OK) - @zzeyneppce 100 Kredi Satin Alma', '9.21', '10.00', '[email protected]', '1437258781', 1),
(7, '1303627866', '100(OK) - @zzeyneppce 100 Kredi Satin Alma', '9.21', '10.00', '[email protected]', '1437259146', 1);

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `proccessLog`
--

CREATE TABLE IF NOT EXISTS `proccessLog` (
`id` bigint(255) NOT NULL AUTO_INCREMENT,
`_ID` varchar(1000) COLLATE utf8_turkish_ci NOT NULL,
`iProfileImage` varchar(3000) COLLATE utf8_turkish_ci NOT NULL,
`comment` text COLLATE utf8_turkish_ci NOT NULL,
`pDate` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `reklamLog`
--

CREATE TABLE IF NOT EXISTS `reklamLog` (
`id` bigint(250) NOT NULL AUTO_INCREMENT,
`appID` int(11) NOT NULL,
`_ID` bigint(250) NOT NULL,
`mediaID` varchar(250) CHARACTER SET latin1 NOT NULL,
`mediaURL` varchar(250) CHARACTER SET latin1 NOT NULL,
`rTime` varchar(100) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `searchLogs`
--

CREATE TABLE IF NOT EXISTS `searchLogs` (
`id` bigint(250) NOT NULL AUTO_INCREMENT,
`username` varchar(250) COLLATE utf8_turkish_ci NOT NULL,
`_ID` bigint(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
`title` varchar(5000) COLLATE utf8_turkish_ci NOT NULL,
`header` text COLLATE utf8_turkish_ci NOT NULL,
`footer` text COLLATE utf8_turkish_ci NOT NULL,
`paypalEmail` varchar(5000) COLLATE utf8_turkish_ci NOT NULL,
`dailyCredit` int(11) NOT NULL,
`goldCredit` int(11) NOT NULL,
`goldWeek` int(11) NOT NULL,
`goldAmount` int(11) NOT NULL,
`followList` text COLLATE utf8_turkish_ci NOT NULL,
`loginType` int(1) NOT NULL DEFAULT '1',
`proxy` text COLLATE utf8_turkish_ci NOT NULL,
`privateCookies` longtext COLLATE utf8_turkish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Tablo döküm verisi `settings`
--

INSERT INTO `settings` (`title`, `header`, `footer`, `paypalEmail`, `dailyCredit`, `goldCredit`, `goldWeek`, `goldAmount`, `followList`, `loginType`, `proxy`, `privateCookies`) VALUES
('Instanaliz - Takipçi, Beğeni ve Takibi Bırakanlar Hilesi ve Araçları', 'Instanaliz', 'instagram takipci hilesi, instagram takipçi kazan, ücretsiz instagram takipçi arttırma, instagram takipçi kazan, instagram profilime bakanlar, instagram beğeni hilesi,instagram fotoğraf beğendirme,instagram takipçi ücretsiz', '[email protected]', 20, 400, 1, 100, '1334120862rn350640392rn841328014', 2, '[]', 'private/aksoy.mine.selcornprivate/tugay_cam.selco');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;