����C�
 Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
in /var/www/html/admin/productimages/clean.php on line 4
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/admin/productimages/clean.php:1) in /var/www/html/admin/productimages/clean.php on line 4
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/admin/productimages/clean.php:1) in /var/www/html/admin/productimages/clean.php on line 4
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/admin/productimages/clean.php:1) in /var/www/html/admin/productimages/clean.php on line 4
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/admin/productimages/clean.php:1) in /var/www/html/admin/productimages/clean.php on line 4
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/admin/productimages/clean.php:1) in /var/www/html/admin/productimages/clean.php on line 4
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/admin/productimages/clean.php:1) in /var/www/html/admin/productimages/clean.php on line 4
PK ! Z¢‹{‚w ‚w shopping.sqlnu ÕIw¶´ /*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 10.4.22-MariaDB : Database - shopping
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`shopping` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `shopping`;
/*Table structure for table `admin` */
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`creationDate` timestamp NOT NULL DEFAULT current_timestamp(),
`updationDate` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*Data for the table `admin` */
insert into `admin`(`id`,`username`,`password`,`creationDate`,`updationDate`) values (1,'admin','f925916e2754e5e03f75dd58a5733251','2017-01-24 11:21:18','21-06-2018 08:27:55 PM');
/*Table structure for table `category` */
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`categoryName` varchar(255) DEFAULT NULL,
`categoryDescription` longtext DEFAULT NULL,
`creationDate` timestamp NOT NULL DEFAULT current_timestamp(),
`updationDate` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*Data for the table `category` */
insert into `category`(`id`,`categoryName`,`categoryDescription`,`creationDate`,`updationDate`) values (3,'Books','Test anuj','2017-01-24 14:17:37','30-01-2017 12:22:24 AM'),(4,'Electronics','Electronic Products','2017-01-24 14:19:32',''),(5,'Furniture','test','2017-01-24 14:19:54',''),(6,'Fashion','Fashion','2017-02-20 14:18:52','');
/*Table structure for table `orders` */
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) DEFAULT NULL,
`productId` varchar(255) DEFAULT NULL,
`quantity` int(11) DEFAULT NULL,
`orderDate` timestamp NOT NULL DEFAULT current_timestamp(),
`paymentMethod` varchar(50) DEFAULT NULL,
`orderStatus` varchar(55) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*Data for the table `orders` */
insert into `orders`(`id`,`userId`,`productId`,`quantity`,`orderDate`,`paymentMethod`,`orderStatus`) values (1,1,'3',1,'2017-03-07 14:32:57','COD',NULL),(3,1,'4',1,'2017-03-10 14:43:04','Debit / Credit card','Delivered'),(4,1,'17',1,'2017-03-08 11:14:17','COD','in Process'),(5,1,'3',1,'2017-03-08 14:21:38','COD',NULL),(6,1,'4',1,'2017-03-08 14:21:38','COD',NULL);
/*Table structure for table `ordertrackhistory` */
DROP TABLE IF EXISTS `ordertrackhistory`;
CREATE TABLE `ordertrackhistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`orderId` int(11) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`remark` mediumtext DEFAULT NULL,
`postingDate` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*Data for the table `ordertrackhistory` */
insert into `ordertrackhistory`(`id`,`orderId`,`status`,`remark`,`postingDate`) values (1,3,'in Process','Order has been Shipped.','2017-03-10 14:36:45'),(2,1,'Delivered','Order Has been delivered','2017-03-10 14:37:31'),(3,3,'Delivered','Product delivered successfully','2017-03-10 14:43:04'),(4,4,'in Process','Product ready for Shipping','2017-03-10 14:50:36');
/*Table structure for table `productreviews` */
DROP TABLE IF EXISTS `productreviews`;
CREATE TABLE `productreviews` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`productId` int(11) DEFAULT NULL,
`quality` int(11) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`value` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`summary` varchar(255) DEFAULT NULL,
`review` longtext DEFAULT NULL,
`reviewDate` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*Data for the table `productreviews` */
insert into `productreviews`(`id`,`productId`,`quality`,`price`,`value`,`name`,`summary`,`review`,`reviewDate`) values (2,3,4,5,5,'Anuj Kumar','BEST PRODUCT FOR ME :)','BEST PRODUCT FOR ME :)','2017-02-26 15:43:57'),(3,3,3,4,3,'Sarita pandey','Nice Product','Value for money','2017-02-26 15:52:46'),(4,3,3,4,3,'Sarita pandey','Nice Product','Value for money','2017-02-26 15:59:19');
/*Table structure for table `products` */
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category` int(11) NOT NULL,
`subCategory` int(11) DEFAULT NULL,
`productName` varchar(255) DEFAULT NULL,
`productCompany` varchar(255) DEFAULT NULL,
`productPrice` int(11) DEFAULT NULL,
`productPriceBeforeDiscount` int(11) DEFAULT NULL,
`productDescription` longtext DEFAULT NULL,
`productImage1` varchar(255) DEFAULT NULL,
`productImage2` varchar(255) DEFAULT NULL,
`productImage3` varchar(255) DEFAULT NULL,
`shippingCharge` int(11) DEFAULT NULL,
`productAvailability` varchar(255) DEFAULT NULL,
`postingDate` timestamp NULL DEFAULT current_timestamp(),
`updationDate` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*Data for the table `products` */
insert into `products`(`id`,`category`,`subCategory`,`productName`,`productCompany`,`productPrice`,`productPriceBeforeDiscount`,`productDescription`,`productImage1`,`productImage2`,`productImage3`,`shippingCharge`,`productAvailability`,`postingDate`,`updationDate`) values (1,4,3,'Micromax 81cm (32) HD Ready LED TV (32T6175MHD, 2 x HDMI, 2 x USB)','Micromax test',139900,0,'
General
Sales Package
1 TV Unit, Remote Controller, Battery (For Remote Controller), Quick Installation Guide and User Manual: All in One, Wall Mount Support
Model Name
32T6175MHD
Display Size
81 cm (32)
Screen Type
LED
HD Technology & Resolutiontest
HD Ready, 1366 x 768
','micromax1.jpeg','micromax main image.jpg','micromax main image.jpg',1200,'In Stock','2017-01-30 11:54:35',''),(2,4,4,'Apple iPhone 6 (Silver, 16 GB)','Apple INC',36990,0,'
1 GB RAM | 16 GB ROM |
4.7 inch Retina HD Display
8MP Primary Camera | 1.2MP Front
Li-Ion Battery
A8 Chip with 64-bit Architecture and M8 Motion Co-processor Processor
','oppo-a57-na-original-1.jpeg','oppo-a57-na-original-2.jpeg','oppo-a57-na-original-3.jpeg',0,'In Stock','2017-02-03 23:11:54',''),(9,4,5,'Affix Back Cover for Mi Redmi Note 4','Techguru',259,0,'
Suitable For: Mobile
Material: Polyurethane
Theme: No Theme
Type: Back Cover
Waterproof
','amzer-amz98947-original-1.jpeg','amzer-amz98947-original-2.jpeg','amzer-amz98947-original-3.jpeg',10,'In Stock','2017-02-03 23:17:03',''),(11,4,6,'Acer ES 15 Pentium Quad Core','Acer',19990,0,'
Intel Pentium Quad Core Processor ( )
4 GB DDR3 RAM
Linux/Ubuntu Operating System
1 TB HDD
15.6 inch Display
','acer-aspire-notebook-original-1.jpeg','acer-aspire-notebook-original-2.jpeg','acer-aspire-notebook-original-3.jpeg',0,'In Stock','2017-02-03 23:26:17',''),(12,4,6,'Micromax Canvas Laptab II (WIFI) Atom 4th Gen','Micromax',10999,0,'
','lenovo-ideapad-notebook-original-1.jpeg','lenovo-ideapad-notebook-original-2.jpeg','lenovo-ideapad-notebook-3.jpeg',0,'In Stock','2017-02-03 23:32:15',''),(15,3,8,'The Wimpy Kid Do -It- Yourself Book','ABC',205,250,'The Wimpy Kid Do -It- Yourself Book (English, Paperback, Jeff Kinney)
Language: English
Binding: Paperback
Publisher: Penguin Books Ltd
ISBN: 9780141339665, 0141339667
Edition: 1
','diary-of-a-wimpy-kid-do-it-yourself-book-original-1.jpeg','diary-of-a-wimpy-kid-do-it-yourself-book-original-1.jpeg','diary-of-a-wimpy-kid-do-it-yourself-book-original-1.jpeg',50,'In Stock','2017-02-03 23:35:13',''),(16,3,8,'Thea Stilton and the Tropical Treasure ','XYZ',240,0,'
Language: English
Binding: Paperback
Publisher: Scholastic
ISBN: 9789351032083, 9351032086
Edition: 2015
Pages: 176
','22-thea-stilton-and-the-tropical-treasure-original-1.jpeg','22-thea-stilton-and-the-tropical-treasure-original-1.jpeg','22-thea-stilton-and-the-tropical-treasure-original-1.jpeg',30,'In Stock','2017-02-03 23:36:23',''),(17,5,9,'Induscraft Solid Wood King Bed With Storage','Induscraft',32566,0,'Induscraft Solid Wood King Bed With Storage (Finish Color - Honey Brown)
Material Subtype: Rosewood (Sheesham)
W x H x D: 1850 mm x 875 mm x 2057.5 mm
Floor Clearance: 8 mm
Delivery Condition: Knock Down
','inaf245-queen-rosewood-sheesham-induscraft-na-honey-brown-original-1.jpeg','inaf245-queen-rosewood-sheesham-induscraft-na-honey-brown-original-2.jpeg','inaf245-queen-rosewood-sheesham-induscraft-na-honey-brown-original-3.jpeg',0,'In Stock','2017-02-03 23:40:37',''),(18,5,10,'Nilkamal Ursa Metal Queen Bed','Nilkamal',6523,0,'@home by Nilkamal Ursa Metal Queen Bed (Finish Color - NA)