-
Notifications
You must be signed in to change notification settings - Fork 2
/
files.sql
114 lines (97 loc) · 5.07 KB
/
files.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1
-- Время создания: Мар 05 2015 г., 23:30
-- Версия сервера: 5.5.25
-- Версия PHP: 5.3.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 */;
--
-- База данных: `files`
--
-- --------------------------------------------------------
--
-- Структура таблицы `comments`
--
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`number` int(11) NOT NULL,
`path` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`fileid` int(11) NOT NULL,
`text` varchar(200) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `fileid` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
--
-- Дамп данных таблицы `comments`
--
INSERT INTO `comments` (`id`, `number`, `path`, `name`, `fileid`, `text`, `time`) VALUES
(1, 1, '1', 'Аноним', 13, '2323', '2015-03-04 08:02:55'),
(2, 2, '2', 'Аноним', 13, '123', '2015-03-04 08:02:57'),
(3, 3, '3', 'Аноним', 13, '1111', '2015-03-04 08:03:00'),
(4, 1, '1.1', 'Аноним', 13, '212', '2015-03-04 08:03:19'),
(5, 1, '3.1', 'Аноним', 13, '2323', '2015-03-04 08:03:26'),
(6, 1, '3.1.1', 'Аноним', 13, '23232', '2015-03-04 08:03:36'),
(7, 1, '1.1.1', 'Аноним', 13, '23232323', '2015-03-04 08:03:45'),
(8, 4, '4', 'Аноним', 12, '234', '2015-03-04 08:19:40'),
(9, 1, '4.1', 'Аноним', 12, '2342', '2015-03-04 08:19:42'),
(10, 1, '4.1.1', 'Аноним', 12, '234', '2015-03-04 08:19:44'),
(11, 5, '5', 'Аноним', 12, '234', '2015-03-04 08:19:46'),
(12, 6, '6', 'Аноним', 12, '23423', '2015-03-04 08:19:50'),
(13, 1, '5.1', 'Аноним', 12, '234', '2015-03-04 08:19:53'),
(14, 1, '6.1', 'Аноним', 12, '234', '2015-03-04 08:19:56'),
(15, 2, '3.2', 'Аноним', 13, '5656', '2015-03-04 10:50:04'),
(16, 1, '3.2.1', 'Аноним', 13, '54545', '2015-03-05 14:00:42');
-- --------------------------------------------------------
--
-- Структура таблицы `files`
--
CREATE TABLE IF NOT EXISTS `files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`size` int(11) NOT NULL,
`uploadtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`comment` varchar(500) NOT NULL,
`code` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
--
-- Дамп данных таблицы `files`
--
INSERT INTO `files` (`id`, `type`, `name`, `size`, `uploadtime`, `comment`, `code`) VALUES
(1, 'image/jpeg', '14246400880390.jpg', 115754, '2015-02-27 08:05:54', '', 'b600lg7qxkvmb9045fdcder80ght36om'),
(2, 'image/jpeg', 'hotkeysublime.jpg', 676750, '2015-02-27 08:06:06', '', '53kwzy1fnt8qnnjdop5v9w4jh2wpln2e'),
(3, 'image/jpeg', '14246322457130.jpg', 314070, '2015-02-27 08:06:12', '', '6h6pq8z978ea2hnqzd23vr3ga54ygcs2'),
(4, 'text/plain', 'file.txt', 14, '2015-02-27 08:06:17', '', '8tc61k3e1dgf9hcwji7y1lyapg0vi1ab'),
(5, 'application/pdf', 'sublime_text_2_hotkeys.pdf', 77463, '2015-02-27 08:06:30', '', 'ju0l1lbgsvnnnpgelozf7s00v9ek8g9a'),
(6, 'image/jpeg', 'LdRVGqHYAAM.jpg', 107244, '2015-02-27 10:32:59', '', '5sb811mpyeaor13ym7cy3mj0dv6v65ry'),
(7, 'image/png', 'logo.png', 46522, '2015-02-27 12:01:29', '', '43fneev4dtdi87hjtmpdc4cpgsokxom6'),
(8, 'image/jpeg', 'ddddddddddddd.jpg', 335728, '2015-02-27 12:57:10', '', 'ntmozzw2w0rj9c07jy6s0pcl5ewlbqpp'),
(9, 'application/pdf', 'c-ruby.pdf', 194329, '2015-02-27 12:58:00', '', '5lndel7smra95dx2xvy950exy2jg3s5q'),
(10, 'application/pdf', 'c-ruby.pdf', 194329, '2015-02-27 12:58:14', '', 'b4o0y3cf63rw3ftfthbf7zo3xc02bpgn'),
(11, 'application/pdf', 'c-ruby.pdf', 194329, '2015-02-27 12:58:24', '', 'xhfb10db6ltao4opmu0mmj5hvv6ennfg'),
(12, 'image/jpeg', '14246322457130.jpg', 314070, '2015-02-27 13:29:41', '', 'i8ymz5m36etmedl3idnuftnuwp2kg6k4'),
(13, 'image/png', '128.png', 20922, '2015-03-03 19:07:08', '', 'whdtkctdadmy75nw5900qlgb73c60zhc'),
(14, 'image/jpeg', 'hotkeysublime.jpg', 676750, '2015-03-05 15:14:40', '', '1cwatmykpntkl3xpfwleywvug3i0skkc'),
(15, 'image/jpeg', 'fizr.jpg', 123301, '2015-03-05 16:07:08', '', 's5l2iinzt98o31dasrs4c636cjrrjdry'),
(16, 'image/jpeg', 'fizr.jpg', 123301, '2015-03-05 16:07:30', '', '4nwebzoygjnobvro7bsqokvdqtuknjjp');
--
-- Ограничения внешнего ключа сохраненных таблиц
--
--
-- Ограничения внешнего ключа таблицы `comments`
--
ALTER TABLE `comments`
ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`fileid`) REFERENCES `files` (`id`);
/*!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 */;