-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 27, 2012 at 06:13 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

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: `ideal`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `email` varchar(100) NOT NULL,
  `paypalid` varchar(100) NOT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`admin_id`, `username`, `password`, `email`, `paypalid`) VALUES
(1, 'admin', 'admin', 'bobby@kmaxdesigns.com', 'jeff@kmaxdesigns.com');

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

--
-- Table structure for table `bulkemail`
--

CREATE TABLE IF NOT EXISTS `bulkemail` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `password` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `country` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `gender` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `Status` tinyint(4) NOT NULL DEFAULT '0',
  `reguser` int(15) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `bulkemail`
--

INSERT INTO `bulkemail` (`user_id`, `username`, `password`, `email`, `country`, `gender`, `Status`, `reguser`) VALUES
(2, '', '', 'ram@gmail.com', '', '', 1, 0),
(3, '', '', 'narayana@hlinesoft.com', '', '', 1, 0);

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

--
-- Table structure for table `coupons`
--

CREATE TABLE IF NOT EXISTS `coupons` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_name` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `coupon_descr` text COLLATE latin1_general_ci NOT NULL,
  `coupon_amt` float(10,2) NOT NULL,
  `amttype` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `notimes` int(11) NOT NULL,
  `coupon_min_amt` float(10,2) NOT NULL,
  `coupon_code` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `coupon_start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `coupon_end_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `coupon_users` varchar(150) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`coupon_id`, `coupon_name`, `coupon_descr`, `coupon_amt`, `amttype`, `notimes`, `coupon_min_amt`, `coupon_code`, `coupon_start_date`, `coupon_end_date`, `coupon_users`) VALUES
(6, 'fgfdg', 'fgfdg                    ', 20.00, '1', 3, 23.00, 'tmsvgy', '2011-04-09 01:00:00', '2011-04-15 01:00:00', '1'),
(7, 'ramesh', 'scv', 3.00, '1', 3, 2.00, 'k4dwnr', '2011-04-14 01:00:00', '2011-04-29 01:00:00', '5'),
(8, 'test', 'test', 1.00, '1', 6, 2.00, 'mgt9dx', '2011-05-25 01:00:00', '2011-05-31 01:00:00', '6');

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

--
-- Table structure for table `couponusage`
--

CREATE TABLE IF NOT EXISTS `couponusage` (
  `usageid` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_code` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `coupon_user_id` int(11) NOT NULL,
  `used_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`usageid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `couponusage`
--

INSERT INTO `couponusage` (`usageid`, `coupon_code`, `coupon_user_id`, `used_time`) VALUES
(1, 'tmsvgy', 1, '2011-04-10 04:51:49'),
(2, 'tmsvgy', 1, '2011-04-10 04:51:52'),
(3, 'tmsvgy', 1, '2011-04-10 04:51:55'),
(4, 'tmsvgy', 1, '2011-04-10 04:51:57'),
(5, 'mgt9dx', 6, '2011-05-26 02:09:52'),
(6, 'mgt9dx', 6, '2011-05-26 22:14:16');

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

--
-- Table structure for table `editphotos`
--

CREATE TABLE IF NOT EXISTS `editphotos` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `g_id` int(11) NOT NULL,
  `image` varchar(50) NOT NULL,
  `data` text NOT NULL,
  `price` varchar(250) NOT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `editphotos`
--

INSERT INTO `editphotos` (`p_id`, `g_id`, `image`, `data`, `price`) VALUES
(1, 1, 'felding.png', '', ''),
(2, 1, 'musical.png', '', ''),
(3, 1, 'latin.png', '', ''),
(4, 1, 'ewelfare.png', '', ''),
(5, 1, 'ming.png', '', '');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `g_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`g_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`g_id`, `name`) VALUES
(1, 'brands');

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

--
-- Table structure for table `ip_hits`
--

CREATE TABLE IF NOT EXISTS `ip_hits` (
  `ipid` int(15) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `clicks` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `date` varchar(255) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`ipid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ip_hits`
--


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

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `pid` int(15) NOT NULL AUTO_INCREMENT,
  `catid` int(10) NOT NULL,
  `subcat_id` int(11) NOT NULL,
  `subsubcatid` int(11) NOT NULL DEFAULT '0',
  `itemno` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `pname` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `price` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `color` varchar(150) COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `discount` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `mtitle` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `mkeywords` text COLLATE latin1_general_ci NOT NULL,
  `mdescription` text COLLATE latin1_general_ci NOT NULL,
  `status` int(1) NOT NULL,
  `addedon` date NOT NULL,
  `weight` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `size` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `image1` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `image2` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `image3` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `image4` varchar(150) COLLATE latin1_general_ci NOT NULL,
  `image5` varchar(150) COLLATE latin1_general_ci NOT NULL,
  `new` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `width` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `specifications` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`pid`, `catid`, `subcat_id`, `subsubcatid`, `itemno`, `pname`, `price`, `color`, `description`, `discount`, `mtitle`, `mkeywords`, `mdescription`, `status`, `addedon`, `weight`, `size`, `image1`, `image2`, `image3`, `image4`, `image5`, `new`, `width`, `specifications`) VALUES
(2, 1, 5, 0, '', 'Alpha Audio', '9.00           ', 'Grey           ', '<ul><li>You&#39;ll never leave home without your shoes on with the Ariat&reg; Argyle Loafer Knee Hi.</li><li>Knee high with a novelty pattern.</li><li>Logo band.</li><li>Machine wash warm and tumble dry.</li><li>Material: 60% cotton, 38% polyester, 2% spandex </li></ul>                                       ', '', '', '', '', 1, '2011-12-22', '1', 'One Size           ', 'p_g_1.png', 'small.gif', '', '', '', '1', '', '<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Specifications</strong></p><ul><li>You&#39;ll never leave home without your shoes on with the Ariat&reg; Argyle Loafer Knee Hi.</li><li>Knee high with a novelty pattern.</li><li>Logo band.</li><li>Machine wash warm and tumble dry.</li><li>Material: 60% cotton, 38% polyester, 2% spandex </li></ul><p>&nbsp;</p>'),
(3, 1, 5, 0, '', 'test', '3435     ', 'Grey     ', 'rgtg                                       ', '', '', '', '', 1, '2012-01-07', '1', 'One Size     ', '_MG_3304.JPG', '_MG_3301.JPG', '', '', '', '1', '', 'fgfg');

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

--
-- Table structure for table `proimg`
--

CREATE TABLE IF NOT EXISTS `proimg` (
  `proimgid` int(11) NOT NULL AUTO_INCREMENT,
  `proid` int(11) NOT NULL,
  `colname` varchar(20) NOT NULL,
  `colval` varchar(20) NOT NULL,
  `imgname` varchar(50) NOT NULL,
  PRIMARY KEY (`proimgid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `proimg`
--


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

--
-- Table structure for table `register`
--

CREATE TABLE IF NOT EXISTS `register` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `Fname` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `Lname` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `ipaddress` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `Phone` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `Fax` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `Password` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `discount` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `amounttype` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `billingaddress1` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `billingaddress2` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `billingcity` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `billingstate` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `billingzip` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `billingcountry` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `billingphone` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `shippingaddress1` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `shippingaddress2` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `shippingcity` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `shippingstate` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `shippingzip` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `shippingcountry` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `shippingphone` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `Maillist` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No',
  `Status` tinyint(4) NOT NULL DEFAULT '0',
  `shippingfax` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `billingfax` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `register`
--

INSERT INTO `register` (`user_id`, `Fname`, `Lname`, `Email`, `ipaddress`, `Phone`, `Fax`, `Password`, `discount`, `amounttype`, `billingaddress1`, `billingaddress2`, `billingcity`, `billingstate`, `billingzip`, `billingcountry`, `billingphone`, `shippingaddress1`, `shippingaddress2`, `shippingcity`, `shippingstate`, `shippingzip`, `shippingcountry`, `shippingphone`, `Maillist`, `Status`, `shippingfax`, `billingfax`) VALUES
(1, 'test', 'test', 'test@test.com', '', '1234566776', '0987654321', '123', '', '', 'test                                                                                                ', '', 'los angels', 'CA', '12345', 'USA', '1234566776', 'test                                                                                                ', '', 'los angels', 'CA', '12345', 'USA', '1234566776', 'No', 1, '0987654321', '0987654321'),
(2, 'test', 'test', 'test@test.com', '', '40429479581', '1234', '1234', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'No', 0, '', ''),
(3, 'narayana', 'g', 'narayana@hlinesoft.com', '', '12343556', '0987654321', '1234', '', '', '                       etrtrt                                                                       ', '', 'los angels', 'CA', '12345', 'US', '12343556', '                       etrtrt                                                                       ', '', 'los angels', 'CA', '12345', 'US', '12343556', 'No', 0, '0987654321', '0987654321'),
(4, 'wewr', 'eee', 'eewre@gmail.com', '', '3434543645654', '54645', '123', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'No', 0, '', '');

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

--
-- Table structure for table `store`
--

CREATE TABLE IF NOT EXISTS `store` (
  `stid` int(15) NOT NULL AUTO_INCREMENT,
  `storename` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`stid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=21 ;

--
-- Dumping data for table `store`
--

INSERT INTO `store` (`stid`, `storename`, `description`) VALUES
(1, 'Home', '<p>Established in 1968, our company is one of the largest manufacturers of violins, cellos, double basses and guitars in China. </p>                                   <p>The company has assets exceeding  $10M and employs more than 1300   people, 400 of which are highly  skilled techicians.&nbsp; Annually our   factory now produces 300,000  violins, 30,000 cellos, 500,000 guitars and   ukeles and 200,000  electric guitars.&nbsp; We are world leaders in the   production of violins  and we have a staggering 20% share of the world   market.&nbsp; Our products  are sold in more than 60 countries. </p>'),
(2, 'Questions & Answers', 'Coming Soon<br />'),
(3, 'Bargain Cave', '<strong>coming soon</strong><br />'),
(4, 'Retail Stores', 'Coming soon'),
(5, 'Our History ', 'Coming soon'),
(6, 'Investor Relations', 'coming soon'),
(7, 'Careers', 'coming soon'),
(8, 'Corporate Partners', 'Coming soon'),
(9, 'Articles & Information ', 'Coming soon'),
(10, 'Talk Forums', 'Coming Soon'),
(11, 'Game & Fish Info', 'Coming Soon'),
(12, 'Trophy Room', 'Coming soon'),
(13, 'Pro Staff', 'Coming soon'),
(14, 'Gift Cards', 'coming soon'),
(15, 'Special Orders', 'coming soon'),
(16, 'Catalog Quick Order', 'coming soon'),
(17, 'Free Catalog', 'coming soon'),
(18, 'E-Gift Certificate', 'sdsd'),
(19, 'Help', ''),
(20, 'Contact Us', '');

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

--
-- Table structure for table `tax`
--

CREATE TABLE IF NOT EXISTS `tax` (
  `t_id` int(11) NOT NULL AUTO_INCREMENT,
  `tax` varchar(100) NOT NULL,
  PRIMARY KEY (`t_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tax`
--

INSERT INTO `tax` (`t_id`, `tax`) VALUES
(1, '6'),
(2, '75');

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

--
-- Table structure for table `tblcart`
--

CREATE TABLE IF NOT EXISTS `tblcart` (
  `cartid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `status` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `prototal` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `ship` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `method` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `tax` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `discount` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `grandtotal` float NOT NULL,
  PRIMARY KEY (`cartid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tblcart`
--

INSERT INTO `tblcart` (`cartid`, `userid`, `status`, `time`, `prototal`, `ship`, `method`, `tax`, `discount`, `grandtotal`) VALUES
(1, '1', '0', '2011-12-27 12:48:27', '9', '0', 'GND', '0.54', '', 9.54),
(2, '1', '0', '2012-01-06 15:28:57', '9', '0', 'GND', '0.54', '', 9.54),
(3, '1', '0', '2012-01-06 16:48:17', '9', '0', 'GND', '0.54', '', 9.54),
(4, '1', '0', '2012-01-10 11:20:00', '3435', '0', 'GND', '206.1', '', 3641.1);

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

--
-- Table structure for table `tblcartdetails`
--

CREATE TABLE IF NOT EXISTS `tblcartdetails` (
  `tblcartid` int(11) NOT NULL AUTO_INCREMENT,
  `cartid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `pname` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `UNITPRICE` text COLLATE latin1_general_ci NOT NULL,
  `qty` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `total` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `status` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '1',
  `itemno` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `sizes` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `attime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tax` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `colorindex` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`tblcartid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tblcartdetails`
--

INSERT INTO `tblcartdetails` (`tblcartid`, `cartid`, `productid`, `pname`, `UNITPRICE`, `qty`, `total`, `status`, `itemno`, `sizes`, `attime`, `tax`, `colorindex`) VALUES
(1, 1, 2, 'Alpha Audio', '9.00', '1', '9', '0', '', '', '2011-12-27 12:48:27', '', ''),
(2, 2, 2, 'Alpha Audio', '9.00', '1', '9', '0', '', '', '2012-01-06 15:28:57', '', ''),
(3, 3, 2, 'Alpha Audio', '9.00', '1', '9', '0', '', '', '2012-01-06 16:48:17', '', ''),
(4, 4, 3, 'test', '3435', '1', '3435', '0', '', '', '2012-01-10 11:20:00', '', '');

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

--
-- Table structure for table `tblcategories`
--

CREATE TABLE IF NOT EXISTS `tblcategories` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryname` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `image` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `description` varchar(500) COLLATE latin1_general_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `mtitle` text COLLATE latin1_general_ci NOT NULL,
  `mkeywords` text COLLATE latin1_general_ci NOT NULL,
  `mdescription` text COLLATE latin1_general_ci NOT NULL,
  `active` int(11) NOT NULL,
  `addedon` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tblcategories`
--

INSERT INTO `tblcategories` (`category_id`, `categoryname`, `image`, `description`, `status`, `mtitle`, `mkeywords`, `mdescription`, `active`, `addedon`) VALUES
(1, 'String instruments', '', '', 1, '', '', '', 0, '0000-00-00 00:00:00'),
(2, 'Wood Wind Instruments', '', '', 1, '', '', '', 0, '0000-00-00 00:00:00'),
(3, 'Brass wind', '', '', 1, '', '', '', 0, '0000-00-00 00:00:00'),
(4, 'Orchestral Percussion', '', '', 1, '', '', '', 0, '0000-00-00 00:00:00'),
(5, 'Marching band', '', '', 1, '', '', '', 0, '0000-00-00 00:00:00'),
(6, 'Accessories', '', '', 1, '', '', '', 0, '0000-00-00 00:00:00');

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

--
-- Table structure for table `tblsubcategories`
--

CREATE TABLE IF NOT EXISTS `tblsubcategories` (
  `subcat_id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryid` int(11) NOT NULL,
  `subcat_name` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `addedon` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL,
  `mtitle` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `mkeywords` text COLLATE latin1_general_ci NOT NULL,
  `mdescription` text COLLATE latin1_general_ci NOT NULL,
  `deselect` int(5) NOT NULL,
  `special` int(11) NOT NULL,
  PRIMARY KEY (`subcat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=35 ;

--
-- Dumping data for table `tblsubcategories`
--

INSERT INTO `tblsubcategories` (`subcat_id`, `categoryid`, `subcat_name`, `description`, `addedon`, `status`, `mtitle`, `mkeywords`, `mdescription`, `deselect`, `special`) VALUES
(1, 1, 'Violin', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 1),
(2, 1, 'Viola', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(3, 1, 'Cello', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(4, 1, 'Bass', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(5, 1, 'Classical Guitars', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 1),
(6, 1, 'Acoustic and Folk guitars', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 1),
(7, 1, 'Electric Guitars', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(8, 1, 'Electric Bass', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(9, 1, 'Latin American Folk instruments', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(10, 2, 'Flute', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 1),
(11, 2, 'Piccolo', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(12, 2, 'Oboe', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(13, 2, 'Bassoon', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(14, 2, 'English Horn', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(15, 2, 'Saxophon', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(16, 2, 'Clarinet', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(17, 3, 'Trompet', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(18, 3, 'Trombone', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(19, 3, 'Euphonium', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(20, 3, 'Tuba', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(21, 4, 'Xylophone', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(22, 4, 'Marimba', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(23, 4, 'Vibraphone', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(24, 4, 'Bass drum', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(25, 4, 'Snare Drum', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(26, 4, 'Tympani Set', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(27, 5, 'Woodwind', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(28, 5, 'Brass wind', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(29, 5, 'Percussion', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(30, 6, 'Bow string Instruments Accesories', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(31, 6, 'Plucked Instruments Accessories', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(32, 6, 'Woodwind Instruments Accessories', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(33, 6, 'BrassWind Instruments Accessories', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0),
(34, 6, 'Percussion Instruments Accessories', '', '0000-00-00 00:00:00', 1, '', '', '', 0, 0);

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

--
-- Table structure for table `tblsubsubcategories`
--

CREATE TABLE IF NOT EXISTS `tblsubsubcategories` (
  `subsubcatid` int(11) NOT NULL AUTO_INCREMENT,
  `subcatid` int(11) NOT NULL,
  `categoryid` int(11) NOT NULL,
  `subsubcat_name` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `desc1` text COLLATE latin1_general_ci NOT NULL,
  `subsubtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `subsubaddedon` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `subsubstatus` int(1) NOT NULL,
  `subsubmtitle` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `subsubmkeywords` text COLLATE latin1_general_ci NOT NULL,
  `subsubmdescription` text COLLATE latin1_general_ci NOT NULL,
  `subsubdeselect` int(5) NOT NULL,
  `ssimage` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`subsubcatid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tblsubsubcategories`
--

