· 8 years ago · Mar 16, 2018, 08:04 PM
1-- phpMyAdmin SQL Dump
2-- version 4.3.11.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Mar 27, 2015 at 07:09 AM
7-- Server version: 5.6.23
8-- PHP Version: 5.5.22
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `php101_gallery`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `albums`
27--
28
29CREATE TABLE IF NOT EXISTS `albums` (
30 `id` int(11) NOT NULL,
31 `name` varchar(255) NOT NULL,
32 `description` text NOT NULL,
33 `created_on` datetime NOT NULL,
34 `user_id` int(11) NOT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
36
37--
38-- Dumping data for table `albums`
39--
40
41INSERT INTO `albums` (`id`, `name`, `description`, `created_on`, `user_id`) VALUES
42(1, 'Sephia', 'Photos with vintage filter effect', '2015-03-27 06:43:49', 2),
43(2, 'Nature', 'Natural by Nature', '2015-03-27 06:05:12', 2),
44(3, 'Randomness', 'Elit commodo natus orci penatibus, leo, quibusdam bibendum? Vitae bibendum fugit sed litora iusto arcu. Maecenas condimentum praesentium ratione vero, aspernatur, elementum commodi in, hac possimus adipisicing molestias? Congue cillum.', '2015-03-27 06:25:07', 2);
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `photos`
50--
51
52CREATE TABLE IF NOT EXISTS `photos` (
53 `id` int(11) NOT NULL,
54 `filename` varchar(255) NOT NULL,
55 `type` varchar(50) NOT NULL,
56 `size` int(11) NOT NULL,
57 `album_id` int(11) NOT NULL,
58 `uploaded_on` datetime NOT NULL,
59 `uploaded_by` int(11) NOT NULL
60) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
61
62--
63-- Dumping data for table `photos`
64--
65
66INSERT INTO `photos` (`id`, `filename`, `type`, `size`, `album_id`, `uploaded_on`, `uploaded_by`) VALUES
67(1, '2_56H.jpg', 'image/jpeg', 269242, 1, '2015-03-27 06:05:32', 2),
68(2, '2_75H.jpg', 'image/jpeg', 368106, 1, '2015-03-27 06:05:42', 2),
69(3, '2_58H.jpg', 'image/jpeg', 827496, 1, '2015-03-27 06:05:53', 2),
70(4, '2_179H.jpg', 'image/jpeg', 197627, 1, '2015-03-27 06:06:00', 2),
71(5, '2_169H.jpg', 'image/jpeg', 514355, 1, '2015-03-27 06:06:09', 2),
72(6, '2_60H.jpg', 'image/jpeg', 458298, 1, '2015-03-27 06:06:37', 2),
73(7, '2_107H.jpg', 'image/jpeg', 877746, 2, '2015-03-27 06:06:51', 2),
74(8, '2_175H.jpg', 'image/jpeg', 447584, 2, '2015-03-27 06:07:00', 2),
75(9, '2_168H.jpg', 'image/jpeg', 297244, 2, '2015-03-27 06:07:12', 2),
76(10, '2_46H.jpg', 'image/jpeg', 665683, 2, '2015-03-27 06:07:21', 2),
77(11, '2_10H.jpg', 'image/jpeg', 445769, 2, '2015-03-27 06:07:27', 2),
78(12, '2_37H.jpg', 'image/jpeg', 1193365, 2, '2015-03-27 06:07:35', 2),
79(13, '2_39H.jpg', 'image/jpeg', 97142, 2, '2015-03-27 06:07:50', 2),
80(14, '2_16H.jpg', 'image/jpeg', 371937, 1, '2015-03-27 06:18:45', 2),
81(15, '2_86H.jpg', 'image/jpeg', 458053, 1, '2015-03-27 06:19:02', 2),
82(16, '2_131H.jpg', 'image/jpeg', 342056, 1, '2015-03-27 06:19:13', 2),
83(17, '2_156H.jpg', 'image/jpeg', 477567, 1, '2015-03-27 06:19:23', 2),
84(18, '2_11H.jpg', 'image/jpeg', 202805, 3, '2015-03-27 06:25:26', 2),
85(19, '2_53H.jpg', 'image/jpeg', 289327, 3, '2015-03-27 06:25:35', 2),
86(20, '2_49H.jpg', 'image/jpeg', 137900, 3, '2015-03-27 06:25:41', 2),
87(21, '2_64H.jpg', 'image/jpeg', 526615, 3, '2015-03-27 06:25:47', 2),
88(22, '2_67H.jpg', 'image/jpeg', 969664, 3, '2015-03-27 06:25:52', 2),
89(23, '2_83H.jpg', 'image/jpeg', 255700, 3, '2015-03-27 06:25:58', 2),
90(24, '2_85H.jpg', 'image/jpeg', 247955, 3, '2015-03-27 06:26:03', 2),
91(25, '2_98H.jpg', 'image/jpeg', 821260, 3, '2015-03-27 06:26:09', 2),
92(26, '2_134H.jpg', 'image/jpeg', 285537, 3, '2015-03-27 06:26:18', 2),
93(27, '2_146H.jpg', 'image/jpeg', 479437, 3, '2015-03-27 06:26:26', 2),
94(28, '2_157H.jpg', 'image/jpeg', 379965, 3, '2015-03-27 06:26:35', 2),
95(29, '2_160H.jpg', 'image/jpeg', 289293, 3, '2015-03-27 06:26:41', 2),
96(30, '2_177H.jpg', 'image/jpeg', 253068, 3, '2015-03-27 06:26:50', 2),
97(31, '2_blue_van.jpg', 'image/jpeg', 396884, 3, '2015-03-27 06:26:56', 2),
98(32, '2_KDOALRLDV8.jpg', 'image/jpeg', 315848, 3, '2015-03-27 06:27:03', 2),
99(33, '2_67H.jpg', 'image/jpeg', 969664, 1, '2015-03-27 06:28:35', 2);
100
101-- --------------------------------------------------------
102
103--
104-- Table structure for table `users`
105--
106
107CREATE TABLE IF NOT EXISTS `users` (
108 `id` int(11) NOT NULL,
109 `username` varchar(255) NOT NULL,
110 `password` varchar(32) NOT NULL,
111 `admin` tinyint(1) NOT NULL DEFAULT '0'
112) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
113
114
115--
116-- Indexes for dumped tables
117--
118
119--
120-- Indexes for table `albums`
121--
122ALTER TABLE `albums`
123 ADD PRIMARY KEY (`id`);
124
125--
126-- Indexes for table `photos`
127--
128ALTER TABLE `photos`
129 ADD PRIMARY KEY (`id`);
130
131--
132-- Indexes for table `users`
133--
134ALTER TABLE `users`
135 ADD PRIMARY KEY (`id`);
136
137--
138-- AUTO_INCREMENT for dumped tables
139--
140
141--
142-- AUTO_INCREMENT for table `albums`
143--
144ALTER TABLE `albums`
145 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
146--
147-- AUTO_INCREMENT for table `photos`
148--
149ALTER TABLE `photos`
150 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34;
151--
152-- AUTO_INCREMENT for table `users`
153--
154ALTER TABLE `users`
155 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
156/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
157/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
158/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;