 --
 -- Database: `insure_db`
 --
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tbl_customers`
+--
+
+CREATE TABLE `tbl_customers` (
+  `cusId` int(11) NOT NULL,
+  `cusFullname` varchar(80) NOT NULL,
+  `cusAdrs` text NOT NULL,
+  `cusPhone` varchar(10) NOT NULL,
+  `cusEmail` varchar(80) NOT NULL,
+  `cusUsername` varchar(16) NOT NULL,
+  `cusPassword` varchar(150) NOT NULL,
+  `cusToken` text NOT NULL,
+  `cusCreateAt` datetime NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `tbl_customers`
+--
+
+INSERT INTO `tbl_customers` (`cusId`, `cusFullname`, `cusAdrs`, `cusPhone`, `cusEmail`, `cusUsername`, `cusPassword`, `cusToken`, `cusCreateAt`) VALUES
+(1, '', '', '', '', '', '', '', '0000-00-00 00:00:00'),
+(2, 'pudthai pichet', '123/zzzz', '0959356049', 'pudthaiiii@gmail.com', 'pudthai', '55c3b5386c486feb662a0785f340938f518d547f', '4da210603ad12e519341ceeb96f6de28556b4a97280240.26549340', '2015-06-01 00:53:27'),
+(3, 'pichet Kunjai', '123434', '0959356049', 'pudthaiiii@gmail.com', 'pudthaiiii', '10470c3b4b1fed12c3baac014be15fac67c6e815', '8138ef59051cd99c7681e9275dbd2d26556b56c4ea9732.81761580', '2015-06-01 01:45:24');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tbl_package_brand`
+--
+
+CREATE TABLE `tbl_package_brand` (
+  `bId` int(11) NOT NULL,
+  `bName` varchar(200) NOT NULL,
+  `bYear` int(11) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `tbl_package_brand`
+--
+
+INSERT INTO `tbl_package_brand` (`bId`, `bName`, `bYear`) VALUES
+(1, 'ALFA ROMEO', 0),
+(2, 'AMC', 0),
+(3, 'ASTON MARTIN', 0),
+(4, 'ATTHAM', 0),
+(5, 'AUDI', 0),
+(6, 'AUSTIN', 0),
+(7, 'BENTLEY', 0),
+(8, 'BMW', 0),
+(9, 'BUFORI', 0),
+(10, 'BUICK', 0),
+(11, 'CADILLAC', 0),
+(12, 'CHERY', 0),
+(13, 'CHEVROLET', 0),
+(14, 'CHRYSLER', 0),
+(15, 'CITROEN', 0),
+(16, 'DAEWOO', 0),
+(17, 'DAIHATSU', 0),
+(18, 'DELOREAN', 0),
+(19, 'DEVA', 0),
+(20, 'DFM', 0),
+(21, 'DODGE', 0),
+(22, 'FERRARI', 0),
+(23, 'FIAT', 0),
+(24, 'FORD', 0),
+(25, 'FOTON', 0),
+(26, 'GATSBY', 0),
+(27, 'GMC', 0),
+(28, 'HILLMAN', 0),
+(29, 'HINO', 0),
+(30, 'HOLDEN', 0),
+(31, 'HONDA', 0),
+(32, 'HUMMER', 0),
+(33, 'HYUNDAI', 0),
+(34, 'INFINITI', 0),
+(35, 'ISUZU', 0),
+(36, 'JAGUAR', 0),
+(37, 'JEEP', 0),
+(38, 'JINBEI', 0),
+(39, 'JOYLONG', 0),
+(40, 'JRD', 0),
+(41, 'KIA', 0),
+(42, 'LADA', 0),
+(43, 'LAMBORGHINI', 0),
+(44, 'LANCIA', 0),
+(45, 'LAND ROVER', 0),
+(46, 'LEXUS', 0),
+(47, 'LINCOLN', 0),
+(48, 'LOTUS', 0),
+(49, 'MASERATI', 0),
+(50, 'MAYBACH', 0),
+(51, 'MAZDA', 0),
+(52, 'MCLAREN', 0),
+(53, 'MERCEDES-BENZ', 0),
+(54, 'MG', 0),
+(55, 'MINI', 0),
+(56, 'MITSUBISHI', 0),
+(57, 'MITSUOKA', 0),
+(58, 'NAZA', 0),
+(59, 'NISSAN', 0),
+(60, 'NSU', 0),
+(61, 'OLDSMOBILE', 0),
+(62, 'OPEL', 0),
+(63, 'PERODUA', 0),
+(64, 'PEUGEOT', 0),
+(65, 'PLYMOUTH', 0),
+(66, 'PONTIAC', 0),
+(67, 'PORSCHE', 0),
+(68, 'PROTON', 0),
+(69, 'RENAULT', 0),
+(70, 'ROLLS-ROYCE', 0),
+(71, 'ROVER', 0),
+(72, 'RUF', 0),
+(73, 'SAAB', 0),
+(74, 'SEAT', 0),
+(75, 'SHINERAY', 0),
+(76, 'SKODA', 0),
+(77, 'SMART', 0),
+(78, 'SOKON', 0),
+(79, 'SSANGYONG', 0),
+(80, 'SUBARU', 0),
+(81, 'SUZUKI', 0),
+(82, 'TATA', 0),
+(83, 'TESLA', 0),
+(84, 'TOYOTA', 0),
+(85, 'TRIUMPH', 0),
+(86, 'VOLKSWAGEN', 0),
+(87, 'VOLVO', 0),
+(88, 'WIESMANN', 0),
+(89, 'WULING', 0);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tbl_package_level`
+--
+
+CREATE TABLE `tbl_package_level` (
+  `lvId` int(11) NOT NULL,
+  `lvType` varchar(11) NOT NULL,
+  `lvPrice` int(11) NOT NULL,
+  `lvLimit` int(11) NOT NULL,
+  `lvGroup` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 

  ADD PRIMARY KEY (`mId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_package_main`
--
ALTER TABLE `tbl_package_main`
  MODIFY `mId` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Jun 06, 2015 at 05:41 AM
-- Server version: 5.5.42
-- PHP Version: 5.6.7

