-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Host: 68.178.143.158
-- Generation Time: Mar 16, 2017 at 05:47 AM
-- Server version: 5.5.43
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Database: `pmAnywhere3`
--

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

--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `brand_id` int(11) NOT NULL AUTO_INCREMENT,
  `brand` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  `brand_category` varchar(100) NOT NULL,
  `brand_resource` varchar(500) NOT NULL,
  `brand_creation_date` varchar(50) NOT NULL,
  `brand_company_id` int(11) NOT NULL,
  `brand_status` int(11) NOT NULL,
  PRIMARY KEY (`brand_id`),
  KEY `brand_company_id` (`brand_company_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` VALUES(1, 'Toyota', 'Corolla (2017)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(2, 'Caterpillar', 'D8R2 (2004)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(3, 'Caterpillar', 'D10 (2004)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(4, 'Hyundai ', 'R140LC-9A (2014)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(5, 'Komatsu ', 'PW220-7 (2012)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(6, 'Hewlett-Packard', 'Pavilion Notebook 17-ab000nx', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(7, 'Hewlett-Packard', 'Laserjet P2015n', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(8, 'Toyota', 'Camry (2017)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(9, 'Chevrolet ', 'Tahoe (2017)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(10, 'GMC', 'Yukon (2016)', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(11, 'Ford', 'Expedition (2017) ', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(12, 'Lenovo', 'ThinkCentre M900z', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(13, 'LG', 'Gold Plus Eco B1827H', '', '', '2017-1-17', 261, 1);
INSERT INTO `brand` VALUES(14, 'Carrier', 'Infinity 21', '', '', '2017-1-17', 261, 1);