 (3, '2.0i 4doors Hybrid i-VTEC Auto', 2014, 31, 1, 0),
 (4, '2.0i 4doors Hybrid TECH i-VTEC Auto', 2014, 31, 1, 0);
 
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tbl_package_series`
+--
+
+CREATE TABLE `tbl_package_series` (
+  `sId` int(11) NOT NULL,
+  `sName` varchar(200) NOT NULL,
+  `sYear` varchar(100) NOT NULL,
+  `sBrand` int(11) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `tbl_package_series`
+--
+
+INSERT INTO `tbl_package_series` (`sId`, `sName`, `sYear`, `sBrand`) VALUES
+(1, 'Accord', '2014,2013', 31),
+(2, 'Brio', '2014,2013', 31),
+(3, 'City', '2014,2013', 31),
+(4, 'Civic', '2014,2013', 31),
+(5, 'CR-V', '2014,2013', 31),
+(6, 'CR-Z', '2014,2013', 31),
+(7, 'Freed', '2014,2013', 31),
+(8, 'HRV', '2014', 31),
+(9, 'Jazz', '2014,2013', 31),
+(10, 'Mobilio', '2014', 31),
+(11, 'Odyssey', '2014,2013', 31),
+(15, 'STEPWGN SPADA', '2013', 31);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tbl_package_type`
+--
+
+CREATE TABLE `tbl_package_type` (
+  `tId` int(11) NOT NULL,
+  `tName` varchar(200) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tbl_package_year`
+--
+
+CREATE TABLE `tbl_package_year` (
+  `yId` int(11) NOT NULL,
+  `yName` int(4) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `tbl_package_year`
+--
+
+INSERT INTO `tbl_package_year` (`yId`, `yName`) VALUES
+(1, 2015),
+(2, 2014),
+(3, 2013),
+(4, 2012),
+(5, 2011),
+(6, 2010),
+(7, 2009),
+(8, 2008),
+(9, 2007),
+(10, 2006);
+
 --
 -- Indexes for dumped tables
 --
+
+--
+-- Indexes for table `tbl_customers`
+--
+ALTER TABLE `tbl_customers`
+  ADD PRIMARY KEY (`cusId`);
+
+--
+-- Indexes for table `tbl_package_brand`
+--
+ALTER TABLE `tbl_package_brand`
+  ADD PRIMARY KEY (`bId`);
+
+--
+-- Indexes for table `tbl_package_level`
+--
+ALTER TABLE `tbl_package_level`
+  ADD PRIMARY KEY (`lvId`);
 
 --
 -- Indexes for table `tbl_package_main`

  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

