Файл: X-MAN/БД.sql
Строк: 36
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
--
http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время
создания: Окт 09 2012 г., 10:26
-- Версия сервера:
5.1.58
-- Версия PHP: 5.2.17
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 */;
--
--------------------------------------------------------
--
--
Структура таблицы `bann`
--
CREATE TABLE IF NOT EXISTS
`bann` (
`id` int(11) NOT NULL,
`ip` text COLLATE utf8_unicode_ci NOT
NULL,
`status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
--
--------------------------------------------------------
--
--
Структура таблицы `url`
--
CREATE TABLE IF NOT EXISTS
`url` (
`url` text COLLATE utf8_unicode_ci NOT NULL,
`scan` int(11) NOT
NULL,
`active` tinyint(4) NOT NULL,
`count` int(11) NOT NULL,
`bann`
tinyint(4) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`pos`
int(11) NOT NULL,
`review` int(11) NOT NULL,
`allcount` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ;
--
-- Дамп данных
таблицы `url`
--
INSERT INTO `url` (`url`, `scan`, `active`,
`count`, `bann`, `id`, `pos`, `review`, `allcount`)
VALUES
('http://qscr.ru', 3, 1, 3, 0, 3, 0, 6, 1),
('http://wxdev.ru', 3,
1, 3, 0, 4, 0, 6, 1);
/*!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 */;