-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- المزود: localhost
-- أنشئ في: 06 يوليو 2015 الساعة 00:23
-- إصدارة المزود: 5.0.45
--  PHP إصدارة: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- قاعدة البيانات: `ecommerce`
-- 

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

-- 
-- بنية الجدول `brands`
-- 

CREATE TABLE `brands` (
  `brand_id` int(11) NOT NULL auto_increment,
  `brand_title` text NOT NULL,
  PRIMARY KEY  (`brand_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- إرجاع أو إستيراد بيانات الجدول `brands`
-- 

INSERT INTO `brands` VALUES (1, 'DELL');
INSERT INTO `brands` VALUES (2, 'HP');
INSERT INTO `brands` VALUES (3, 'SAMSUNG');
INSERT INTO `brands` VALUES (4, 'SONY');
INSERT INTO `brands` VALUES (5, 'YAMAHA');
INSERT INTO `brands` VALUES (6, 'MICROSOFT');
INSERT INTO `brands` VALUES (7, 'NOKIA');
INSERT INTO `brands` VALUES (8, 'TIDE');
INSERT INTO `brands` VALUES (9, 'ARIAL');
INSERT INTO `brands` VALUES (10, 'LEE');

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

-- 
-- بنية الجدول `categories`
-- 

CREATE TABLE `categories` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_title` text NOT NULL,
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- إرجاع أو إستيراد بيانات الجدول `categories`
-- 

INSERT INTO `categories` VALUES (1, 'Laptops');
INSERT INTO `categories` VALUES (2, 'Computers');
INSERT INTO `categories` VALUES (3, 'Tablets');
INSERT INTO `categories` VALUES (4, 'Cameras');
INSERT INTO `categories` VALUES (5, 'Mobiles');
INSERT INTO `categories` VALUES (6, 'Bikes');
INSERT INTO `categories` VALUES (7, 'Cars');
INSERT INTO `categories` VALUES (8, 'TV`s');
INSERT INTO `categories` VALUES (9, 'Bantlon');
INSERT INTO `categories` VALUES (10, 'Skirts');

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

-- 
-- بنية الجدول `products`
-- 

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL auto_increment,
  `product_cat` int(11) NOT NULL,
  `product_brand` int(11) NOT NULL,
  `product_title` varchar(255) NOT NULL,
  `product_price` int(11) NOT NULL,
  `product_desc` text NOT NULL,
  `product_image` text NOT NULL,
  `product_keywords` text NOT NULL,
  PRIMARY KEY  (`product_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;

-- 
-- إرجاع أو إستيراد بيانات الجدول `products`
-- 

INSERT INTO `products` VALUES (1, 0, 0, 'HP New Laptop', 350, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '1.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (2, 0, 0, 'HP New Laptop', 400, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '2.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (3, 0, 0, 'HP New Laptop', 500, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '3.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (4, 1, 0, 'HP New Laptop', 600, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '4.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (5, 0, 0, 'HP New Laptop', 700, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '5.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (6, 0, 0, 'HP New Laptop', 800, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '6.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (7, 0, 0, 'HP New Laptop', 900, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '7.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (8, 0, 0, 'HP New Laptop', 700, '<p>HP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the WorldHP Laptop is the Best Product In the World</p>', '8.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (9, 0, 0, 'HP New Laptop', 300, '<p>hp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptopshp,laptop,newlaptop,laptops</p>', '9.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (10, 10, 10, 'HP New Laptop', 340, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '10.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (11, 10, 10, 'HP New Laptop', 400, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '11.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (12, 1, 0, 'HP New Laptop', 360, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '12.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (13, 5, 7, 'HP New Laptop', 200, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '13.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (14, 5, 4, 'iphone', 370, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '14.jpg', 'iphone');
INSERT INTO `products` VALUES (15, 7, 10, 'Ipad', 500, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '15.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (16, 5, 3, 's4', 390, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '16.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (17, 9, 10, 'T-shirt', 100, '<p>HP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New LaptopHP New Laptop</p>', '17.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (18, 2, 1, 'Coputer p4', 450, '<p>&nbsp;Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4</p>', '18.jpg', 'Coputer p4,DELL,Computers');
INSERT INTO `products` VALUES (19, 1, 2, 'HP New Laptop', 300, '<p>Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4</p>', '19.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (20, 3, 6, 'HP New Laptop', 100, '<p>&nbsp;Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4</p>', '20.jpg', 'hp,laptop,newlaptop,laptops');
INSERT INTO `products` VALUES (21, 5, 5, 'iphone', 250, '<p>Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4Coputer p4</p>', '21.jpg', 'iphone');
INSERT INTO `products` VALUES (22, 6, 10, 'Tshirt1', 100, '<p>&nbsp;Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1</p>', '24.jpg', 'Tshirt1');
INSERT INTO `products` VALUES (23, 9, 10, 'Tshirt2', 100, '<p>Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1</p>', '25.jpg', 'Tshirt2');
INSERT INTO `products` VALUES (24, 9, 10, 'Tshirt3', 100, '<p>Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1</p>', '26.jpg', '');
INSERT INTO `products` VALUES (25, 9, 10, 'Tshirt4', 100, '<p>Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1Tshirt1</p>', '29.jpg', '');
INSERT INTO `products` VALUES (26, 5, 3, 'samsung S3', 100, '<p>samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3</p>', '33.jpg', 'samsung S3');
INSERT INTO `products` VALUES (27, 5, 3, 'samsung S4', 140, '<p>samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3</p>', '41.jpg', 'samsung S4');
INSERT INTO `products` VALUES (28, 5, 3, 'samsung S5', 250, '<p>samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3</p>', '40.jpg', 'samsung S5');
INSERT INTO `products` VALUES (29, 0, 3, 'samsung Note4', 280, '<p>samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3</p>', '35.jpg', 'samsung grand4');
INSERT INTO `products` VALUES (30, 5, 3, 'samsung Grand2', 100, '<p>samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2samsung Grand2</p>', '44.jpg', 'samsung Grand2');
INSERT INTO `products` VALUES (31, 5, 3, 'samsung galaxy stsar2', 100, '<p>samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3samsung S3</p>', '38.jpg', 'samsung S3');
INSERT INTO `products` VALUES (32, 5, 5, 'iphone5 s', 380, '<p>iphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 s</p>', '47.jpg', 'iphone5 s');
INSERT INTO `products` VALUES (33, 5, 5, 'iphone5 c', 200, '<p>iphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 s</p>', '49.jpg', 'iphone5 s');
INSERT INTO `products` VALUES (34, 5, 5, 'iphone4', 100, '<p>iphone4&nbsp;iphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 siphone5 s</p>', '46.jpg', 'iphone4');
INSERT INTO `products` VALUES (35, 5, 5, 'iphone6', 800, '<p>iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6iphone6</p>', '50.jpg', 'iphone6');