D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
shubmkcj
/
praneshaswalphotography.com
/
Filename :
photogallery.sql
back
Copy
-- phpMyAdmin SQL Dump -- version 4.9.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 20, 2021 at 10:14 AM -- Server version: 10.3.16-MariaDB -- PHP Version: 7.3.6 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `photogallery` -- -- -------------------------------------------------------- -- -- Table structure for table `about` -- CREATE TABLE `about` ( `id` int(11) NOT NULL, `description` longtext NOT NULL, `image` varchar(100) NOT NULL, `date` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `about` -- INSERT INTO `about` (`id`, `description`, `image`, `date`) VALUES (1, 'I\'m a professional photographer based in Dehradun, Uttarakhand. There is always a feeling of thrill when I get behind the camera and shoot people, to bring out what seems to connect them together in those moments of love and togetherness.<br /><br /><br />\r\n<br /><br /><br />\r\nIt\'s always a pleasure to see the celebration of self and love in and out of the studio.<br /><br /><br />\r\n<br /><br /><br />\r\nI\'ve been fascinated by travel and nature, walking closely under the embrace of mother Earth and capture her beauty.<br /><br /><br />\r\n<br /><br /><br />\r\nI appreciate knowing the customers and what they want in order to capture the best in order to weave their story in a way that could be cherished forever.', 'art28072020091557.jpg', '2020-07-28'); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `id` int(11) NOT NULL, `category` varchar(50) NOT NULL, `date_creation` varchar(10) NOT NULL, `sub_cat` varchar(10) NOT NULL DEFAULT 'no', `sort` varchar(10) NOT NULL DEFAULT 'main' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id`, `category`, `date_creation`, `sub_cat`, `sort`) VALUES (57, 'Wedding Photography', '2020-03-31', 'no', 'main'), (56, 'Fashion Photography', '2020-03-31', 'no', 'main'); -- -------------------------------------------------------- -- -- Table structure for table `photos` -- CREATE TABLE `photos` ( `id` int(11) NOT NULL, `image` varchar(100) NOT NULL, `category` varchar(20) NOT NULL, `heading` varchar(100) NOT NULL, `description` longtext NOT NULL, `size` varchar(50) NOT NULL, `medium` varchar(50) NOT NULL, `surface` varchar(50) NOT NULL, `artwork` varchar(50) NOT NULL, `sku` varchar(50) NOT NULL, `created_in` varchar(50) NOT NULL, `certificate_artist` varchar(50) NOT NULL, `quality` varchar(50) NOT NULL, `image_tag` varchar(50) NOT NULL, `date` varchar(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `photos` -- INSERT INTO `photos` (`id`, `image`, `category`, `heading`, `description`, `size`, `medium`, `surface`, `artwork`, `sku`, `created_in`, `certificate_artist`, `quality`, `image_tag`, `date`) VALUES (159, 'art30122020140538.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-12-30'), (160, 'art30122020140552.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-12-30'), (163, 'art02012021141819.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2021-01-02'), (164, 'art02012021141835.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2021-01-02'), (162, 'art02012021141759.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2021-01-02'), (158, 'art30122020140455.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-12-30'), (155, 'art30122020120110.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-12-30'), (156, 'art30122020121050.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-12-30'), (151, 'art19082020152930.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (152, 'art19082020152956.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (153, 'art19082020153013.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (154, 'art30122020115721.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-12-30'), (147, 'art19082020152710.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (148, 'art19082020152752.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (149, 'art19082020152837.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (150, 'art19082020152902.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (143, 'art19082020152423.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (144, 'art19082020152442.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (145, 'art19082020152536.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (146, 'art19082020152653.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (139, 'art19082020152101.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (140, 'art19082020152315.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (141, 'art19082020152333.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (142, 'art19082020152353.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (135, 'art19082020151820.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (136, 'art19082020151848.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (137, 'art19082020151917.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (138, 'art19082020152043.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (133, 'art19082020151633.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (134, 'art19082020151801.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (131, 'art19082020151543.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (132, 'art19082020151606.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (125, 'art19082020151204.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (126, 'art19082020151230.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (127, 'art19082020151255.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (128, 'art19082020151338.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (129, 'art19082020151406.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (130, 'art19082020151502.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (118, 'art19082020150736.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (119, 'art19082020150805.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (120, 'art19082020150822.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (121, 'art19082020150842.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (122, 'art19082020150918.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (123, 'art19082020150947.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (124, 'art19082020151035.jpg', 'Fashion Photography', '', '', '', '', '', '', '', '', '', '', '', '2020-08-19'), (165, 'art02012021142001.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2021-01-02'), (166, 'art02012021151038.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2021-01-02'), (167, 'art02012021151105.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2021-01-02'), (168, 'art02012021151128.jpg', 'Wedding Photography', '', '', '', '', '', '', '', '', '', '', '', '2021-01-02'), (169, 'art02012021151206.jpg', 'Wedding Photography', 'baba', '', '', '', '', '', '', '', '', '', '', '2021-01-02'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `email` varchar(100) NOT NULL, `password` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `email`, `password`) VALUES (1, 'ponuaswal761@gmail.com', 'photo'); -- -- Indexes for dumped tables -- -- -- Indexes for table `about` -- ALTER TABLE `about` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `photos` -- ALTER TABLE `photos` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `about` -- ALTER TABLE `about` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59; -- -- AUTO_INCREMENT for table `photos` -- ALTER TABLE `photos` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT; /*!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 */;