Project

General

Profile

RE: Wrong links for attachments » attachments.sql

record for file 200_300_SUTEEV.jpg - Mad Geniy, 2015-02-09 10:47

 
-- phpMyAdmin SQL Dump
-- version 3.3.3
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Фев 09 2015 г., 12:45
-- Версия сервера: 5.5.34
-- Версия PHP: 5.3.10-1ubuntu3.15

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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



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

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

CREATE TABLE IF NOT EXISTS `attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`container_id` int(11) DEFAULT NULL,
`container_type` varchar(30) DEFAULT NULL,
`filename` varchar(255) NOT NULL DEFAULT '',
`disk_filename` varchar(255) NOT NULL DEFAULT '',
`filesize` int(11) NOT NULL DEFAULT '0',
`content_type` varchar(255) DEFAULT '',
`digest` varchar(40) NOT NULL DEFAULT '',
`downloads` int(11) NOT NULL DEFAULT '0',
`author_id` int(11) NOT NULL DEFAULT '0',
`created_on` datetime DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`disk_directory` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_attachments_on_author_id` (`author_id`),
KEY `index_attachments_on_created_on` (`created_on`),
KEY `index_attachments_on_container_id_and_container_type` (`container_id`,`container_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

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

INSERT INTO `attachments` (`id`, `container_id`, `container_type`, `filename`, `disk_filename`, `filesize`, `content_type`, `digest`, `downloads`, `author_id`, `created_on`, `description`, `disk_directory`) VALUES
(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');
    (1-1/1)