|
1
|
-- phpMyAdmin SQL Dump
|
|
2
|
-- version 3.3.3
|
|
3
|
-- http://www.phpmyadmin.net
|
|
4
|
--
|
|
5
|
-- Хост: localhost
|
|
6
|
-- Время создания: Фев 09 2015 г., 12:45
|
|
7
|
-- Версия сервера: 5.5.34
|
|
8
|
-- Версия PHP: 5.3.10-1ubuntu3.15
|
|
9
|
|
|
10
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
|
|
11
|
|
|
12
|
|
|
13
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
14
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
15
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
16
|
/*!40101 SET NAMES utf8 */;
|
|
17
|
|
|
18
|
|
|
19
|
|
|
20
|
-- --------------------------------------------------------
|
|
21
|
|
|
22
|
--
|
|
23
|
-- Структура таблицы `attachments`
|
|
24
|
--
|
|
25
|
|
|
26
|
CREATE TABLE IF NOT EXISTS `attachments` (
|
|
27
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
28
|
`container_id` int(11) DEFAULT NULL,
|
|
29
|
`container_type` varchar(30) DEFAULT NULL,
|
|
30
|
`filename` varchar(255) NOT NULL DEFAULT '',
|
|
31
|
`disk_filename` varchar(255) NOT NULL DEFAULT '',
|
|
32
|
`filesize` int(11) NOT NULL DEFAULT '0',
|
|
33
|
`content_type` varchar(255) DEFAULT '',
|
|
34
|
`digest` varchar(40) NOT NULL DEFAULT '',
|
|
35
|
`downloads` int(11) NOT NULL DEFAULT '0',
|
|
36
|
`author_id` int(11) NOT NULL DEFAULT '0',
|
|
37
|
`created_on` datetime DEFAULT NULL,
|
|
38
|
`description` varchar(255) DEFAULT NULL,
|
|
39
|
`disk_directory` varchar(255) DEFAULT NULL,
|
|
40
|
PRIMARY KEY (`id`),
|
|
41
|
KEY `index_attachments_on_author_id` (`author_id`),
|
|
42
|
KEY `index_attachments_on_created_on` (`created_on`),
|
|
43
|
KEY `index_attachments_on_container_id_and_container_type` (`container_id`,`container_type`)
|
|
44
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
|
|
45
|
|
|
46
|
--
|
|
47
|
-- Дамп данных таблицы `attachments`
|
|
48
|
--
|
|
49
|
|
|
50
|
INSERT INTO `attachments` (`id`, `container_id`, `container_type`, `filename`, `disk_filename`, `filesize`, `content_type`, `digest`, `downloads`, `author_id`, `created_on`, `description`, `disk_directory`) VALUES
|
|
51
|
(24, 1, 'Project', '200_300_SUTEEV.jpg', '150209122932_200_300_SUTEEV.jpg', 58698, 'image/jpeg', 'deae947248a14e76546d0d71708da795', 0, 1, '2015-02-09 12:29:32', '', '2015/02');
|