Просмотр архива Скрипт раскрутки ВК

-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb2
--
http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время
создания: Ноя 21 2013 г., 16:15
-- Версия сервера:
5.5.31
-- Версия PHP: 5.4.4-14+deb7u5

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 */;

--
-- База данных: `admin_mixlike`
--

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

--
--
Структура таблицы `done`
--

CREATE TABLE IF NOT EXISTS
`done` (
  `uid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `mode`
varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `social` varchar(2) COLLATE
utf8_unicode_ci NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT
NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
--
Структура таблицы `orders`
--

CREATE TABLE IF NOT EXISTS
`orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT
NULL,
  `bal` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `status`
varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `summ` int(11) NOT NULL,
 
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1
;

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

--
--
Структура таблицы `tasks`
--

CREATE TABLE IF NOT EXISTS
`tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `social` varchar(2)
COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(10) COLLATE
utf8_unicode_ci NOT NULL,
  `url` varchar(40) COLLATE utf8_unicode_ci NOT
NULL,
  `uid` int(11) NOT NULL,
  `pay` int(11) NOT NULL,
  `bal` int(16)
NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=51 ;

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

--
--
Структура таблицы `users`
--

CREATE TABLE IF NOT EXISTS
`users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(16)
COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(32) COLLATE
utf8_unicode_ci NOT NULL,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT
NULL,
  `lastname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `email`
varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `bday` int(2) NOT NULL,
 
`bmonth` int(2) NOT NULL,
  `byear` int(4) NOT NULL,
  `confirm` int(1) NOT
NULL,
  `balance` int(16) NOT NULL DEFAULT '50',
  `money` int(16) NOT
NULL,
  `photo` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `referer`
int(11) NOT NULL,
  `social:vk` int(15) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=35 ;

/*!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 */;