Просмотр архива Портфолио от Миледи

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

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

--
-- База данных: `my.local`
--

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

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

CREATE TABLE IF NOT
EXISTS `blacklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip`
varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `categories` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name`
varchar(50) NOT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `categories` (`c_id`, `c_name`) VALUES
(3,
'Тест');

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

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

CREATE TABLE IF NOT EXISTS
`comments` (
  `com_id` int(11) NOT NULL AUTO_INCREMENT,
  `com_name`
varchar(25) NOT NULL,
  `com_text` text NOT NULL,
  `com_type` int(11) NOT
NULL,
  `com_date` date NOT NULL,
  `com_uagent` varchar(150) NOT NULL,
 
`com_ip` varchar(15) NOT NULL,
  PRIMARY KEY (`com_id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`files` (
  `f_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) NOT
NULL,
  `f_path` varchar(255) NOT NULL,
  `f_name` varchar(255) NOT NULL,
 
`f_size` int(11) NOT NULL,
  `f_ext` varchar(11) NOT NULL,
 
`f_loads_count` int(11) NOT NULL,
  PRIMARY KEY (`f_id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`projects` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_name`
varchar(255) NOT NULL,
  `p_desc` text NOT NULL,
  `p_screen` varchar(50)
NOT NULL,
  `p_date` datetime NOT NULL,
  `p_ltime` varchar(50) NOT NULL,
 
`p_cid` int(11) NOT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF
NOT EXISTS `project_comments` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
 
`c_name` varchar(25) NOT NULL,
  `c_text` text NOT NULL,
  `c_rating`
int(11) NOT NULL,
  `c_date` datetime NOT NULL,
  `c_p_id` int(11) NOT
NULL,
  `c_ip` varchar(25) NOT NULL,
  `c_uagent` varchar(250) NOT NULL,
 
PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`settings` (
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;

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

INSERT INTO `settings` (`status`) VALUES
(0);

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