Таблы - PROFIWM.COM

[мошенник]

[автор] (10 июн 2015, 02:05) [0/0] [0] [спам] [под]

Где тут ошибка????

-- phpMyAdmin SQL Dump
-- version 4.0.10
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1:3306
-- Время создания: Май 20 2015 г., 20:42
-- Версия сервера: 5.5.37-log
-- Версия PHP: 5.3.28

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

/*!40101 SET Удалён */;
/*!40101 SET Удалён */;
/*!40101 SET Удалён */;
/*!40101 SET NAMES utf8 */;

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

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

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

CREATE TABLE IF NOT EXISTS `ads_manager` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`area` varchar(64) NOT NULL,
`title` varchar(64) NOT NULL,
`url` text NOT NULL,
`img` text NOT NULL,
`names` text NOT NULL,
`time` int(11) NOT NULL,
`position` int(11) NOT NULL,
`count` int(11) NOT NULL,
`go` set('0','1') NOT NULL DEFAULT '0',
`br` set('0','1') NOT NULL DEFAULT '0',
`ot_date` int(11) NOT NULL,
`do_date` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `area` (`area`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `artists` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`path` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `path` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `contacts` (
`uid` int(11) NOT NULL,
`cid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`type` char(10) NOT NULL DEFAULT 'total',
`confirm` enum('0','1') DEFAULT '0',
KEY `uid` (`uid`,`cid`,`type`,`time`,`confirm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `forums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`pos` int(11) NOT NULL,
`about` varchar(512) DEFAULT NULL,
`subforum` int(11) DEFAULT '0',
`thems` int(11) NOT NULL DEFAULT '0',
`postov` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `subforum` (`subforum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `forum_p` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`forum` int(11) NOT NULL,
`subforum` int(11) NOT NULL,
`them` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`create` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`cit` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `create` (`create`),
KEY `forum` (`forum`),
KEY `subforum` (`subforum`),
KEY `them` (`them`),
FULLTEXT KEY `msg` (`msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `forum_t` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`forum` int(11) NOT NULL,
`subforum` int(11) NOT NULL,
`name` varchar(32) NOT NULL,
`uid` int(11) NOT NULL,
`create` int(11) NOT NULL,
`time` int(11) NOT NULL,
`up` set('0','1') DEFAULT '0',
`close` set('0','1') DEFAULT '0',
`postov` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `forum` (`forum`),
KEY `subforum` (`subforum`),
KEY `time` (`time`),
KEY `create` (`create`),
FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `guests` (
`sess` varchar(128) NOT NULL,
`ip` bigint(20) NOT NULL,
`ua` varchar(32) NOT NULL,
`date_aut` int(11) NOT NULL,
`date_last` int(11) NOT NULL,
`pereh` int(11) NOT NULL DEFAULT '0',
`refer` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`query` text NOT NULL,
KEY `ip` (`ip`),
KEY `sess` (`sess`),
KEY `ua` (`ua`),
KEY `date_last` (`date_last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `guests`
--

INSERT INTO `guests` (`sess`, `ip`, `ua`, `date_aut`, `date_last`, `pereh`, `refer`, `url`, `query`) VALUES
('m8rs8m0qfousrmc2g5f5vdit43', 2130706433, 'Mozilla', 1432135050, 1432139003, 24, '', '/index-aut?report=%D0%94%D0%BB%D1%8F%20%D0%B2%D1%85%D0%BE%D0%B4%D0%B0%20%D0%B2%20%D0%BA%D0%B0%D0%B1%D0%B8%D0%BD%D0%B5%D1%82%20%D0%BD%D0%B5%D0%BE%D0%B1%D1%85%D0%BE%D0%B4%D0%B8%D0%BC%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE%D1%80%D0%B8%D0%B7%D0%BE%D0%B2%D0%B0%D1%82', '');

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

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

CREATE TABLE IF NOT EXISTS `minichat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(128) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `news_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`time` int(11) NOT NULL,
`news` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `news` (`news`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `opsos` (
`min` bigint(11) DEFAULT NULL,
`max` bigint(11) DEFAULT NULL,
`opsos` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
KEY `min` (`min`,`max`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `photo_albums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
`about` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `photo_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`image` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
PRIMARY KEY (`id`),
KEY `image` (`image`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `photo_img` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`album` int(11) NOT NULL,
`about` varchar(512) NOT NULL,
`path` varchar(255) NOT NULL,
`time` int(11) NOT NULL,
`rating` int(11) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `album` (`album`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `private` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`cid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`read` enum('0','1') DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`,`cid`),
KEY `read` (`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `track_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`msg` varchar(1024) NOT NULL,
`create` int(11) NOT NULL,
`track` int(11) NOT NULL,
`otzyv` set('+','-') NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `track` (`track`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `track_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`artist` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`path` varchar(255) NOT NULL,
`media` text NOT NULL,
`size` float NOT NULL,
`count` int(11) NOT NULL,
`create` int(11) NOT NULL,
`lastload` int(11) NOT NULL,
`rating` float NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `path` (`path`),
KEY `artist` (`artist`),
KEY `create` (`create`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

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

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick` varchar(16) NOT NULL,
`pass` varchar(64) NOT NULL,
`date_reg` int(11) NOT NULL,
`date_last` int(11) DEFAULT NULL,
`pol` enum('1','2') DEFAULT '2',
`golosov` int(11) DEFAULT '0',
`bonus` int(11) DEFAULT '0',
`ip` bigint(20) NOT NULL DEFAULT '0',
`ua` varchar(32) DEFAULT NULL,
`level` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`moder` enum('0','1','2','3','4') DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `nick` (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Дамп данных таблицы `users`
--

INSERT INTO `users` (`id`, `nick`, `pass`, `date_reg`, `date_last`, `pol`, `golosov`, `bonus`, `ip`, `ua`, `level`, `moder`) VALUES
(1, 'admin', '2826d7e96f03c6e1b6c4bd4a2810ea57', 1432135079, 1432138881, '2', 0, 0, 2130706433, 'Mozilla', '5', '0'),
(2, 'klevuu', '2826d7e96f03c6e1b6c4bd4a2810ea57', 1432138852, 1432139859, '2', 0, 0, 2130706433, 'Mozilla', '0', '1');

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

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

CREATE TABLE IF NOT EXISTS `users_info` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(12) DEFAULT NULL,
`gorod` varchar(20) DEFAULT NULL,
`god_r` int(4) DEFAULT NULL,
`mes_r` int(2) DEFAULT NULL,
`days_r` int(2) DEFAULT NULL,
`email` varchar(32) DEFAULT NULL,
`icq` varchar(10) DEFAULT NULL,
`tel` varchar(14) DEFAULT NULL,
`osebe` varchar(512) DEFAULT NULL,
`music` varchar(512) DEFAULT NULL,
`films` varchar(512) DEFAULT NULL,
`knigi` varchar(512) DEFAULT NULL,
`citate` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Дамп данных таблицы `users_info`
--

INSERT INTO `users_info` (`id`, `name`, `gorod`, `god_r`, `mes_r`, `days_r`, `email`, `icq`, `tel`, `osebe`, `music`, `films`, `knigi`, `citate`) VALUES
(1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

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

CREATE TABLE IF NOT EXISTS `video` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_p` int(11) NOT NULL,
`type` set('1','2','3') NOT NULL,
`name` varchar(255) NOT NULL,
`path` varchar(255) NOT NULL,
`folder` varchar(255) NOT NULL,
`about` text NOT NULL,
`size` float NOT NULL,
`loads` int(11) NOT NULL,
`create` int(11) NOT NULL,
`lastload` int(11) NOT NULL,
`position` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `path` (`path`),
KEY `id_p` (`id_p`),
KEY `folder` (`folder`),
KEY `create` (`create`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

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

CREATE TABLE IF NOT EXISTS `video_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`msg` varchar(1024) NOT NULL,
`create` int(11) NOT NULL,
`file` int(11) NOT NULL,
`otzyv` set('+','-') NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `file` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `zakazy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nickname` varchar(32) NOT NULL,
`opis` varchar(255) NOT NULL,
`otvet` varchar(255) NOT NULL,
`create` int(11) NOT NULL,
`status` enum('1','2','3') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=Удалён */;
/*!40101 SET CHARACTER_SET_RESULTS=Удалён */;
/*!40101 SET COLLATION_CONNECTION=Удалён */;