-- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 23, 2008 at 12:50 PM -- Server version: 5.0.51 -- PHP Version: 5.2.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: `newtshirts` -- -- -------------------------------------------------------- -- -- Table structure for table `aboutus` -- CREATE TABLE `aboutus` ( `aboutus_id` int(11) NOT NULL auto_increment, `aboutus` text NOT NULL, UNIQUE KEY `aboutus_id` (`aboutus_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `aboutus` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_user` -- CREATE TABLE `admin_user` ( `admin_user_id` int(11) NOT NULL auto_increment, `Name` varchar(250) NOT NULL default '', `password` varchar(250) NOT NULL default '', UNIQUE KEY `admin_user_id` (`admin_user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `admin_user` -- INSERT INTO `admin_user` (`admin_user_id`, `Name`, `password`) VALUES (10, 'admin', 'admin'), (11, 'test123', 'test123'); -- -------------------------------------------------------- -- -- Table structure for table `atribute_value` -- CREATE TABLE `atribute_value` ( `atribute_value_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `atribute_id` int(11) NOT NULL default '0', `atribute_value` text NOT NULL, UNIQUE KEY `atribute_value_id` (`atribute_value_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `atribute_value` -- -- -------------------------------------------------------- -- -- Table structure for table `banner` -- CREATE TABLE `banner` ( `banner_id` int(11) NOT NULL auto_increment, `tbanner_name` varchar(250) NOT NULL default '', `tbanner_img` varchar(250) NOT NULL default '', `tbanner_img_two` varchar(250) NOT NULL default '', `tbanner_img_three` varchar(250) NOT NULL default '', `tbanner_img_four` varchar(250) NOT NULL default '', `bbanner_name` varchar(250) NOT NULL default '', `bbanner_img` varchar(250) NOT NULL default '', `page_name` varchar(250) NOT NULL default '', `top_link` varchar(250) NOT NULL default '', `top_link_two` varchar(200) NOT NULL default '', `top_link_three` varchar(200) NOT NULL default '', `top_link_four` varchar(200) NOT NULL default '', `bottom_link` varchar(250) NOT NULL default '', UNIQUE KEY `banner_id` (`banner_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `banner` -- -- -------------------------------------------------------- -- -- Table structure for table `cart` -- CREATE TABLE `cart` ( `cart_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `product_details_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `quantity` int(5) NOT NULL default '0', `totalamt` varchar(200) NOT NULL, `size` varchar(250) NOT NULL, `color` varchar(250) NOT NULL, `sessionid` varchar(200) NOT NULL, `ono` int(11) NOT NULL default '0', UNIQUE KEY `cart_id` (`cart_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ; -- -- Dumping data for table `cart` -- INSERT INTO `cart` (`cart_id`, `product_id`, `product_details_id`, `user_id`, `quantity`, `totalamt`, `size`, `color`, `sessionid`, `ono`) VALUES (1, 8, 4, 0, 10, '3300', 'medium', '', '3cc5eab84bed5031ff3b3acd366145cb', 0), (3, 8, 4, 0, 1, '330', 'large', '', '7ec44c633e44a10810cb11d43f818597', 0), (4, 11, 7, 0, 2, '600', 'medium', '', '3cc5eab84bed5031ff3b3acd366145cb', 0), (6, 11, 7, 0, 1, '300', 'medium', '', '8f672b7147908435d79bf30a21c2debe', 0), (7, 13, 9, 0, 1, '330', 'medium', '', '8f672b7147908435d79bf30a21c2debe', 0), (8, 8, 4, 0, 2, '660', 'large', '', '3cc5eab84bed5031ff3b3acd366145cb', 0), (9, 11, 7, 0, 1, '300', 'medium', '', 'd0ca3df2289f99ee24ef456638e55ca1', 0), (10, 11, 7, 0, 1, '300', 'medium', '', '6ca714cfb6de4aa4114114b3124ea9bb', 0), (11, 12, 8, 0, 1, '330', 'medium', '', '45b351b9ef36ec52217ccd0fdfd6676f', 0), (12, 16, 12, 0, 1, '330', 'medium', '', '06888608523e1640a5d46dcb0475c342', 0), (13, 14, 10, 0, 1, '330', 'large', '', '06888608523e1640a5d46dcb0475c342', 0), (14, 8, 4, 0, 3, '990', 'medium', '', '27693c2d4f4a6e700e36df96f770c9ae', 0), (15, 1, 2, 0, 1, '200', 'small', '', '387da6e73eeb6933e2c884d6a46a546d', 0), (16, 1, 2, 0, 1, '200', 'medium', '', '4f232af8d6a4dd9949e80d2a0bfd2b3c', 0), (17, 13, 9, 0, 1, '330', 'medium', '', 'cd2e04b1e109763ccef27e9524ce1a25', 0), (18, 15, 11, 0, 1, '330', 'small', '', 'dbb5741912587519294d568920efb7ad', 0), (19, 13, 9, 0, 1, '330', 'medium', '', '67292fca4b0801103a22217f8e753e3c', 0), (20, 15, 11, 0, 1, '330', 'medium', '', 'efc5daa3373e477f2b084f45a86f7c1f', 0), (21, 11, 7, 0, 3, '900', 'medium', '', '387da6e73eeb6933e2c884d6a46a546d', 0), (22, 12, 8, 0, 1, '330', 'medium', '', '69cc50ffa14a3f2b12d13009c639e03a', 0), (23, 15, 11, 0, 1, '330', 'medium', '', 'fbb7c2ef5a066d9057a14de2a9d03462', 0), (26, 17, 18, 0, 1, '300', 'medium', '', 'ee33cc5ec24383db747864696610c721', 0), (27, 1, 2, 0, 1, '200', 'large', '', 'fd81950017cfdab63f15a65136dc6a42', 0), (28, 13, 17, 0, 1, '330', 'medium', '', '648cac866d0fbcf38f75ebf828e1886b', 0), (29, 17, 18, 0, 2, '600', 'medium', '', '93b52bd390c5824529fdd71e25e2c5ef', 0), (30, 1, 13, 0, 1, '200', 'medium', '', '6e85393b8d76027b1ad749da0d86ee75', 0), (31, 1, 14, 0, 10, '2000', 'medium', '', 'e5f34d74d758f5159079a41f95b71e2c', 0), (32, 14, 10, 0, 2, '660', 'xl', '', 'e5f34d74d758f5159079a41f95b71e2c', 0), (33, 11, 7, 0, 6, '1800', 'medium', '', 'b1dbcfcab09360f6b30863a3f3cfdc0c', 0), (34, 1, 13, 0, 1, '200', 'large', '', '0e0at4b02s4j43ijhqrfh0ok91', 0), (35, 8, 15, 0, 2, '660', 'large', '', 'uer3mrcpuegrt649p53p161j54', 4), (36, 8, 4, 0, 1, '330', 'medium', '', 'uer3mrcpuegrt649p53p161j54', 4), (37, 1, 0, 0, 0, '0', 'large', '', 'ul695k67r9hi5dj7t18g2gppu4', 0), (38, 1, 0, 0, 10, '2000', '', '', 'ul695k67r9hi5dj7t18g2gppu4', 0), (40, 1, 14, 0, 5, '1000', 'xl', '', 'ul695k67r9hi5dj7t18g2gppu4', 0), (41, 1, 13, 0, 3, '600', 'small', '', 'ul695k67r9hi5dj7t18g2gppu4', 0), (42, 13, 0, 0, 1, '330', '', '', 'rliq01cgpdds2m8pf63ofecfh7', 0), (43, 13, 17, 0, 1, '330', 'large', '', 'rliq01cgpdds2m8pf63ofecfh7', 0), (44, 1, 14, 0, 7, '1400', 'large', '', 'ap8iug90173r53i44ol99ka592', 0), (46, 1, 0, 0, 0, '0', '', '', 'ap8iug90173r53i44ol99ka592', 0), (47, 13, 9, 0, 1, '330', 'medium', '', 'ap8iug90173r53i44ol99ka592', 0), (48, 13, 16, 0, 2, '660', 'xl', '', 'ap8iug90173r53i44ol99ka592', 0), (49, 1, 13, 0, 1, '200', 'medium', '', 'j517mpqu8f3ojnvog8ae1s34h6', 0), (50, 1, 0, 0, 2, '400', 'small', '', 'da92iima5oavmdi6a5hgdkhj52', 0), (51, 1, 13, 0, 1, '200', 'medium', '', 'da92iima5oavmdi6a5hgdkhj52', 0), (52, 1, 13, 0, 10, '2000', 'medium', '', '6kmhfeue7a137ivddq813gc6r1', 0), (55, 13, 16, 0, 1, '330', 'large', '', '6kmhfeue7a137ivddq813gc6r1', 0); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `category_id` int(11) NOT NULL auto_increment, `category_name` varchar(250) NOT NULL, `parent_category_id` int(11) NOT NULL default '0', `cimg` varchar(250) NOT NULL, UNIQUE KEY `category_id` (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `category` -- INSERT INTO `category` (`category_id`, `category_name`, `parent_category_id`, `cimg`) VALUES (1, 'Tshirts', 0, ''), (2, 'Parents Approved', 1, 'parentsapprove-title.gif'), (3, 'Parents not Approved', 1, 'parentsntapprove-title.gif'), (4, 'Best Deals', 1, 'bestdeals-title.jpg'), (5, 'Top Ten', 1, 'topblue-title.gif'), (6, 'Men', 2, ''), (7, 'Women', 2, ''), (8, 'Men', 3, ''), (9, 'Women', 3, ''), (10, 'Men', 4, ''), (11, 'Women', 4, ''), (12, 'Men', 5, ''), (13, 'Women', 5, ''), (15, 'New of the month', 1, 'icon-newbustees.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `category_atribute` -- CREATE TABLE `category_atribute` ( `category_atribute_id` int(11) NOT NULL auto_increment, `atribute_name` varchar(250) NOT NULL, `category_id` int(11) NOT NULL default '0', `image_path` varchar(250) NOT NULL, UNIQUE KEY `category_atribute_id` (`category_atribute_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `category_atribute` -- -- -------------------------------------------------------- -- -- Table structure for table `color` -- CREATE TABLE `color` ( `color_id` int(11) NOT NULL auto_increment, `color_name` varchar(250) NOT NULL, UNIQUE KEY `color_id` (`color_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `color` -- -- -------------------------------------------------------- -- -- Table structure for table `contactus` -- CREATE TABLE `contactus` ( `contactus_id` int(11) NOT NULL auto_increment, `contactus` text NOT NULL, UNIQUE KEY `contactus_id` (`contactus_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `contactus` -- -- -------------------------------------------------------- -- -- Table structure for table `emailupdate` -- CREATE TABLE `emailupdate` ( `emailupdate_id` int(11) NOT NULL auto_increment, `emailupdate` varchar(250) NOT NULL, PRIMARY KEY (`emailupdate_id`), UNIQUE KEY `emailupdate_id` (`emailupdate_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `emailupdate` -- INSERT INTO `emailupdate` (`emailupdate_id`, `emailupdate`) VALUES (1, 'pranavkapur@hotmail.com'); -- -------------------------------------------------------- -- -- Table structure for table `faq` -- CREATE TABLE `faq` ( `faq_id` int(11) NOT NULL auto_increment, `faq_title` varchar(250) NOT NULL, `faq_date` varchar(250) NOT NULL, `faq_content` text NOT NULL, UNIQUE KEY `faq_id` (`faq_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `faq` -- -- -------------------------------------------------------- -- -- Table structure for table `info` -- CREATE TABLE `info` ( `info_id` int(11) NOT NULL auto_increment, `info` text NOT NULL, PRIMARY KEY (`info_id`), UNIQUE KEY `info_id` (`info_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `info` -- -- -------------------------------------------------------- -- -- Table structure for table `knowledge` -- CREATE TABLE `knowledge` ( `knowledge_id` int(11) NOT NULL auto_increment, `knowledge` text NOT NULL, PRIMARY KEY (`knowledge_id`), UNIQUE KEY `info_id` (`knowledge_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `knowledge` -- -- -------------------------------------------------------- -- -- Table structure for table `newletter_email_id` -- CREATE TABLE `newletter_email_id` ( `email_id` int(11) NOT NULL auto_increment, `email` varchar(200) NOT NULL, UNIQUE KEY `email_id` (`email_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `newletter_email_id` -- -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE `news` ( `news_id` int(11) NOT NULL auto_increment, `news_title` varchar(250) NOT NULL, `news_date` varchar(250) NOT NULL, `news_content` text NOT NULL, UNIQUE KEY `news_id` (`news_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `news` -- INSERT INTO `news` (`news_id`, `news_title`, `news_date`, `news_content`) VALUES (1, '1st update', '1212396585', 'ABOUT US 

bluebustees is the maiden entrepreneurial venture of two tee-shirt aficionados who want to save the country from the scum of bad tee-shirt designs! It’s an online “witty” tee-shirt selling site, the first of its kind in India. Having traveled extensively in the US, Abhir and Pranav realized that tees in the US had much cooler deigns and captions than those available in India. And that’s how bluebustees was born, on a New York – Mumbai flight, just when they were several thousand kilometers above Dubai. There was a shapely gorgeous girl sitting at the window seat next to Pranav with a caption on the bust of her tee which said …

 

I know where you’re looking

BITCH

 

The caption just seemed to talk to them. They knew it was a sign … of times to come. One idea led to another and by the time they landed, they had already started looking out for a name. And yes, when they did come up with the name, the shuttle providing them a transfer from the tarmac to the airport was a blue bus indeed!

 

Of course, being tired of working with their dads provided a boost to the idea, so did their prior experience. Abhir has worked in the fashion line a good 4 crazy years while Pranav has in-depth knowledge about textiles. Their mission is to manufacture high quality tees with jaw-dropping, in-your-face kinda designs. The dudes envision expanding from their current 500 square feet office to a 5000 square feet office in the next 12 months!

 

Abhir always believed in fashion that is simple yet smart. It’s all about wearing an attitude. And bluebustees gives you loads of it! A great colour with a wicked caption speaks a lot about the humorous side of your personality. Pranav, on the other hand, is here to make sure that the tee shirt fits you like hell, devils!

 

From the promoters’ desk:

 

“You can expect reasonable prices, fantastic captions, a service that leaves nothing desired and a 100% customer friendly policy when you buy a tee from us. You can also expect to attract attention and turn a lot of heads towards you when you wear a tee that you have bought from us. We believe that we look cool only when we can make you look cool. And this is just the beginning, watch out for more cool stuff …”

'); -- -------------------------------------------------------- -- -- Table structure for table `newslettermail` -- CREATE TABLE `newslettermail` ( `content` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `newslettermail` -- INSERT INTO `newslettermail` (`content`) VALUES ('hello  all hope u good'); -- -------------------------------------------------------- -- -- Table structure for table `order_details` -- CREATE TABLE `order_details` ( `ono` int(11) NOT NULL auto_increment, `cno` int(11) NOT NULL default '0', `total_price` double(10,2) NOT NULL, `shipping` double(10,2) NOT NULL, `ostatus` varchar(250) NOT NULL, `payment_method` varchar(250) NOT NULL, `sessionid` varchar(200) NOT NULL, `paypal` varchar(200) NOT NULL, `odate` varchar(200) NOT NULL, `name` varchar(250) NOT NULL, `address` tinytext NOT NULL, `city` varchar(250) NOT NULL, `zipcode` varchar(250) NOT NULL, `state` varchar(250) NOT NULL, `country` varchar(250) NOT NULL, `phone` varchar(250) NOT NULL, `bill_name` varchar(250) NOT NULL, `bill_phone` varchar(250) NOT NULL, `bill_address` tinytext NOT NULL, `bill_city` varchar(250) NOT NULL, `bill_state` varchar(250) NOT NULL, `bill_zipcode` varchar(250) NOT NULL, `bill_country` varchar(250) NOT NULL, `payment_status` int(11) NOT NULL default '0', UNIQUE KEY `ono` (`ono`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `order_details` -- INSERT INTO `order_details` (`ono`, `cno`, `total_price`, `shipping`, `ostatus`, `payment_method`, `sessionid`, `paypal`, `odate`, `name`, `address`, `city`, `zipcode`, `state`, `country`, `phone`, `bill_name`, `bill_phone`, `bill_address`, `bill_city`, `bill_state`, `bill_zipcode`, `bill_country`, `payment_status`) VALUES (1, 3, 330.00, 0.00, 'new', '', 'cd2e04b1e109763ccef27e9524ce1a25', '', '1212563605', 'pranav', '101 oxford tower,\r\noff new link rd,\r\noshiwara\r\n', 'mumbai', '400053', 'maharashtra', 'india', '9892245234', 'pranav', '9892245234', '101 oxford tower,\r\noff new link rd,\r\noshiwara\r\n', 'mumbai', 'maharashtra', '400053', 'india', 0), (3, 3, 370.00, 40.00, 'new', '', 'ee33cc5ec24383db747864696610c721', '', '1212650013', 'pranav', '101 oxford tower, off new link rd.\r\n ', 'mumbai', '400053', 'maha', 'india', '9892245234', 'pranav', '9892245234', '101 oxford tower, off new link rd.\r\n ', 'mumbai', 'maha', '400053', 'india', 0), (4, 3, 1070.00, 80.00, 'new', '', 'uer3mrcpuegrt649p53p161j54', '', '1213245555', 'pranav', ' sfsfda', 'sdfsfas', 'sfsd', 'dfsa', 'sdfs', '9892245234', 'pranav', '9892245234', ' sfsfda', 'sdfsfas', 'dfsa', 'sfsd', 'sdfs', 0); -- -------------------------------------------------------- -- -- Table structure for table `privacy` -- CREATE TABLE `privacy` ( `privacy_id` int(11) NOT NULL auto_increment, `privacy` text NOT NULL, UNIQUE KEY `terms_id` (`privacy_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `privacy` -- INSERT INTO `privacy` (`privacy_id`, `privacy`) VALUES (4, '

  

  

  

--::About Us::--
--::Page under construction ::--

'); -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `product_id` int(11) NOT NULL auto_increment, `category_id` int(11) NOT NULL default '0', `product_name` varchar(250) NOT NULL, `description` text NOT NULL, `price` double(10,2) NOT NULL default '0.00', `featured` int(11) NOT NULL default '0', `related` varchar(250) NOT NULL, `alldesign` int(11) NOT NULL default '0', `bestdeals` int(11) NOT NULL default '0', `approved` int(11) NOT NULL default '0', `notapproved` int(11) NOT NULL default '0', `topten` int(11) NOT NULL default '0', `pcode` varchar(250) NOT NULL, UNIQUE KEY `product_id` (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; -- -- Dumping data for table `product` -- INSERT INTO `product` (`product_id`, `category_id`, `product_name`, `description`, `price`, `featured`, `related`, `alldesign`, `bestdeals`, `approved`, `notapproved`, `topten`, `pcode`) VALUES (1, 6, 'THE MAN THE LEGEND', '

is tee is one of a best seller, we have a load of players as buyers

Game Over….. Its over for both of us!!

Basic Tee 100%  super soft cotton
', 200.00, 1, '1', 1, 0, 0, 0, 0, 'RBT101'), (8, 6, 'orgasm donar', '100 cotton tee', 330.00, 1, '', 1, 0, 0, 0, 0, 'bbt111'), (11, 6, 'I''VE BEEN USED', '

I have been used and how......... 

100 % cotton fabric. we have used silicon washed 180 gsm combed cotton fabric for our tees.and the rib is lycra so that it does loose its shap

', 300.00, 1, '', 1, 0, 1, 0, 0, 'bbt 105'), (12, 6, 'Office party', '

any office that party like this i''m sending my CV to them 

100 % cotton fabric. we have used silicon washed 180 gsm combed cotton fabric for our tees.and the rib is lycra so that it does loose its shap

 

', 330.00, 1, '', 1, 0, 0, 0, 0, 'bbt162'), (13, 6, 'Internation sign for marrage', '

do i need to explain why i''m still single 

100 % cotton fabric. we have used silicon washed 180 gsm combed cotton fabric for our tees.and the rib is lycra so that it does loose its shap

', 330.00, 0, '', 1, 0, 1, 0, 0, 'bbt111'), (14, 6, 'Smile if you are horny', '

common baby smile a little 

100 % cotton fabric. we have used silicon washed 180 gsm combed cotton fabric for our tees.and the rib is lycra so that it does loose its shap

', 330.00, 1, '', 1, 0, 0, 0, 0, 'bbt163'), (15, 6, 'I CAME FOR THE BEER.......', '

..............AND THE BITCHES 

100 % cotton fabric. we have used silicon washed 180 gsm combed cotton fabric for our tees.and the rib is lycra so that it does loose its shap

', 330.00, 0, '8,12', 1, 0, 0, 0, 0, 'BBT170'), (16, 6, 'I HAVE BEEN USED', 'again and again. and iam ready to be used aga', 330.00, 1, '', 1, 0, 1, 0, 0, 'BBT190'), (17, 6, 'NEW T-SHIRT', '

ABHIR FAV T-SHIRT

', 300.00, 0, '1,13', 0, 0, 0, 0, 0, 'BBT 110'), (18, 6, '2 new t- shirt', 'check the photo ', 300.00, 0, '', 0, 0, 0, 0, 0, 'bbt 999'), (19, 6, 'nuns tees', 'check the photo ', 300.00, 0, '', 0, 0, 0, 0, 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `product_color_size` -- CREATE TABLE `product_color_size` ( `product_color_size_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `color_id` int(11) NOT NULL default '0', `size` varchar(250) NOT NULL, `image` varchar(250) NOT NULL, UNIQUE KEY `product_color_size_id` (`product_color_size_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `product_color_size` -- -- -------------------------------------------------------- -- -- Table structure for table `product_details` -- CREATE TABLE `product_details` ( `product_details_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL, `color_name` varchar(250) NOT NULL, `small_qty` int(11) NOT NULL default '0', `medium_qty` int(11) NOT NULL default '0', `large_qty` int(11) NOT NULL default '0', `xl_qty` int(11) NOT NULL default '0', `xxl_qty` int(11) NOT NULL default '0', `xxxl_qty` int(11) NOT NULL default '0', `product_img` varchar(250) NOT NULL, `color_icon` varchar(250) NOT NULL, `category_id` int(11) NOT NULL, UNIQUE KEY `img_id` (`product_details_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; -- -- Dumping data for table `product_details` -- INSERT INTO `product_details` (`product_details_id`, `product_id`, `color_name`, `small_qty`, `medium_qty`, `large_qty`, `xl_qty`, `xxl_qty`, `xxxl_qty`, `product_img`, `color_icon`, `category_id`) VALUES (4, 8, 'red', 0, 5, 5, 5, 0, 0, 'rbt150.jpg', 'rbt150.jpg', 6), (7, 11, 'white', 2, 10, 10, 10, 0, 0, 'rbt105.jpg', 'rbt105.jpg', 6), (8, 12, 'yellow', 0, 10, 10, 10, 0, 0, 'rbt162.jpg', 'rbt162.jpg', 6), (9, 13, 'blue', 5, 10, 10, 10, 0, 0, 'rbt111.jpg', 'rbt111.jpg', 6), (10, 14, 'blue', 10, 0, 0, 0, 1, 22, 'rbt163.jpg', 'rbt163.jpg', 6), (11, 15, 'BROWN', 5, 10, 10, 10, 0, 0, 'PICT6103.JPG', 'PICT6103.JPG', 6), (12, 16, 'orange', 0, 10, 10, 10, 10, 0, 'PICT6105.JPG', 'PICT6106.JPG', 6), (13, 1, 'red', 11, 10, 0, 0, 0, 11, 'rbt161.jpg', 'rbt161.jpg', 6), (14, 1, 'white', 10, 0, 11, 11, 0, 0, 'rbt115.jpg', 'rbt115.jpg', 6), (15, 8, 'white', 0, 10, 10, 10, 0, 0, 'rbt104.jpg', 'rbt104.jpg', 6), (16, 13, 'SKY BLUE', 0, 5, 5, 5, 5, 0, 'PICT6101.JPG', 'PICT6101.JPG', 6), (17, 13, 'lt blue', 0, 5, 5, 5, 0, 0, 'Untitled-1 copy.jpg', 'Untitled-1 copy.jpg', 6), (18, 17, 'BLUE', 0, 10, 5, 10, 10, 0, 'Untitled-1 copy.jpg', 'Untitled-1 copy.jpg', 6), (19, 19, 'white', 5, 5, 5, 5, 0, 0, 'shirt low res.jpg', 'shirt low res.jpg', 6), (20, 19, 'red', 0, 5, 5, 5, 0, 0, 'shirt low res.jpg', 'shirt low res.jpg', 6); -- -------------------------------------------------------- -- -- Table structure for table `product_old` -- CREATE TABLE `product_old` ( `product_id` int(11) NOT NULL auto_increment, `category_id` int(11) NOT NULL default '0', `product_name` varchar(250) NOT NULL, `description` text NOT NULL, `price` double(10,2) NOT NULL default '0.00', `large_image` varchar(250) NOT NULL, `small_image` varchar(250) NOT NULL, `featured` int(11) NOT NULL default '0', `related` varchar(250) NOT NULL, `small` int(5) NOT NULL default '0', `medium` int(5) NOT NULL default '0', `large` int(5) NOT NULL default '0', `xl` int(5) NOT NULL default '0', `xxl` int(5) NOT NULL default '0', `xxxl` int(5) NOT NULL default '0', UNIQUE KEY `product_id` (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `product_old` -- -- -------------------------------------------------------- -- -- Table structure for table `seo` -- CREATE TABLE `seo` ( `seo_id` int(11) NOT NULL auto_increment, `pagename` varchar(250) NOT NULL, `pagetitle` varchar(250) NOT NULL, `pagekeywords` varchar(250) NOT NULL, `pagedescription` varchar(250) NOT NULL, UNIQUE KEY `seo_id` (`seo_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `seo` -- -- -------------------------------------------------------- -- -- Table structure for table `shipping` -- CREATE TABLE `shipping` ( `shipping_id` int(11) NOT NULL auto_increment, `shipping` double(10,2) NOT NULL default '0.00', PRIMARY KEY (`shipping_id`), UNIQUE KEY `shipping_id` (`shipping_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `shipping` -- INSERT INTO `shipping` (`shipping_id`, `shipping`) VALUES (1, 40.00); -- -------------------------------------------------------- -- -- Table structure for table `sitemap` -- CREATE TABLE `sitemap` ( `sitemap_id` int(11) NOT NULL auto_increment, `sitemap` text NOT NULL, UNIQUE KEY `sitemap_id` (`sitemap_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `sitemap` -- INSERT INTO `sitemap` (`sitemap_id`, `sitemap`) VALUES (4, '

  

  

  

--::About Us::--
--::Page under construction ::--

'); -- -------------------------------------------------------- -- -- Table structure for table `support` -- CREATE TABLE `support` ( `support_id` int(11) NOT NULL auto_increment, `support` text NOT NULL, UNIQUE KEY `support_id` (`support_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `support` -- -- -------------------------------------------------------- -- -- Table structure for table `terms` -- CREATE TABLE `terms` ( `terms_id` int(11) NOT NULL auto_increment, `terms` text NOT NULL, UNIQUE KEY `terms_id` (`terms_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `terms` -- -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `user_id` int(11) NOT NULL auto_increment, `name` varchar(250) NOT NULL, `email` varchar(250) NOT NULL, `gender` varchar(250) NOT NULL, `password` varchar(250) NOT NULL, `phone` varchar(250) NOT NULL, `address` text NOT NULL, `city` varchar(250) NOT NULL, `state` varchar(250) NOT NULL, `zipcode` varchar(250) NOT NULL, `country` varchar(250) NOT NULL, `newsletter` varchar(100) NOT NULL default '0', `reg_date` varchar(200) NOT NULL, UNIQUE KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `user` -- INSERT INTO `user` (`user_id`, `name`, `email`, `gender`, `password`, `phone`, `address`, `city`, `state`, `zipcode`, `country`, `newsletter`, `reg_date`) VALUES (2, 'Abhir Khanna', 'abhirkhanna@gmail.com', '--- Please Select ---', 'deepali1234', '24136344', '', '', '', '', '', '0', ''), (3, 'pranav', 'pranavkapur@hotmail.com', '--- Please Select ---', 'kapur3301', '9892245234', '', '', '', '', '', '0', ''), (4, '', 'pranav@blubustees.com', '', '', '', '', '', '', '', '', '0', ''), (5, 'rewrasfas', 'sdfasdf@sdfsa.com', '', '111111', 'dfasdf', '', '', '', '', '', '0', ''), (6, 'yasir', 'netmetro@gmail.com', '', '111111', '111111111', '', '', '', '', '', '0', '');