-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `order_pro_details`
--

CREATE TABLE `order_pro_details` (
  `orderid` varchar(25) NOT NULL,
  `productname` varchar(150) NOT NULL,
  `price_type` varchar(150) NOT NULL,
  `price` varchar(25) NOT NULL DEFAULT '0',
  `quantity` varchar(25) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_pro_details`
--

INSERT INTO `order_pro_details` (`orderid`, `productname`, `price_type`, `price`, `quantity`) VALUES
('20190112776854', 'BMW', 'normal price', '4782255', '100'),
('20190112718445', 'Sport Bicycle', 'Price', '45000', '100');

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

--
-- Table structure for table `tbl_cartlist`
--

CREATE TABLE `tbl_cartlist` (
  `c_id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `price_id` varchar(25) NOT NULL,
  `quantity` varchar(25) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL,
  `added_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_cartlist`
--

INSERT INTO `tbl_cartlist` (`c_id`, `p_id`, `price_id`, `quantity`, `userid`, `added_at`, `updated_at`) VALUES
(6, 11, '7', '400', 6, '2019-01-12 12:27:02', '2019-01-12 16:08:30'),
(7, 9, '5', '100', 6, '2019-01-12 14:36:09', '2019-01-12 17:24:04');

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

--
-- Table structure for table `tbl_categories`
--

CREATE TABLE `tbl_categories` (
  `cat_id` int(11) NOT NULL,
  `cname` varchar(200) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'status: 1 - active , 0 - inactive',
  `added_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_categories`
--

INSERT INTO `tbl_categories` (`cat_id`, `cname`, `status`, `added_at`, `updated_at`) VALUES
(11, 'Category1', 1, '2019-01-02 16:01:31', '2019-01-07 11:49:40'),
(12, 'Vehicles', 1, '2019-01-02 16:01:36', '2019-01-08 15:12:26'),
(13, 'Category3', 1, '2019-01-07 11:19:19', '0000-00-00 00:00:00'),
(14, 'Category4', 1, '2019-01-07 11:19:30', '2019-01-08 15:06:13');

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

--
-- Table structure for table `tbl_orders`
--

CREATE TABLE `tbl_orders` (
  `id` int(11) NOT NULL,
  `orderid` varchar(50) NOT NULL,
  `userid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `e_mail` varchar(500) NOT NULL,
  `mobile_no` varchar(15) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(500) NOT NULL,
  `zipcode` int(11) NOT NULL,
  `address` varchar(600) NOT NULL,
  `note` varchar(350) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'status: 0 - pending , 1 - completed,2- cancelled',
  `added_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_orders`
--

INSERT INTO `tbl_orders` (`id`, `orderid`, `userid`, `name`, `e_mail`, `mobile_no`, `city`, `state`, `zipcode`, `address`, `note`, `status`, `added_at`) VALUES
(1, '20190112776854', 6, '', '', '', '', '', 0, '', '', 0, '2019-01-12 16:13:09'),
(2, '20190112718445', 6, '', '', '', '', '', 0, '', '', 0, '2019-01-12 16:22:40');

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

--
-- Table structure for table `tbl_products`
--

CREATE TABLE `tbl_products` (
  `p_id` int(11) NOT NULL,
  `p_name` varchar(350) NOT NULL,
  `pc_type` int(11) NOT NULL,
  `psubcat_type` int(11) NOT NULL,
  `short_description` text NOT NULL,
  `long_description` text NOT NULL,
  `images` varchar(450) NOT NULL,
  `added_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'status: 1 - active, 0 - Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_products`
--

INSERT INTO `tbl_products` (`p_id`, `p_name`, `pc_type`, `psubcat_type`, `short_description`, `long_description`, `images`, `added_at`, `updated_at`, `status`) VALUES
(7, 'Wooden Blinds', 11, 9, 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', '[\"1546938992_dblind1.jpg\",\"1546938992_image6.jpg\"]', '2019-01-08 14:46:32', '0000-00-00 00:00:00', 1),
(8, 'Wood', 11, 9, 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', '[\"1546939118_dblind1.jpg\",\"1546939118_dblind1.jpg\"]', '2019-01-08 14:48:38', '0000-00-00 00:00:00', 1),
(9, 'Sport Bicycle', 12, 11, 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', '[\"1546939289_bike.png\",\"1546939289_theme20.jpg\"]', '2019-01-08 14:51:29', '0000-00-00 00:00:00', 1),
(10, 'Product 	Zebra Blinds', 11, 10, 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', '[\"1546940460_blind1.jpg\",\"1546940460_blind1.jpg\",\"1546940460_dblind2.jpg\"]', '2019-01-08 15:11:00', '0000-00-00 00:00:00', 1),
(11, 'BMW', 12, 12, 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', 'Fabrics with horizontal segments alternating between sheer and semi-opaque are made in dual layers parallel to each other. When the sheer band of fabric is aligned each other parallel a blurred view through will be possible, light filters through the sheer fabric. When an opaque band of fabric is aligned each other parallel light is diffused for light filtering shades, for room darkening shades light is blocked and the view through is blocked, light filters through the sheer fabric when the shade partially raised or lowered', '[\"1546940756_img12.jpg\",\"1546940756_img4.jpg\"]', '2019-01-08 15:15:56', '2019-01-09 15:34:14', 1);

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

--
-- Table structure for table `tbl_specifications`
--

CREATE TABLE `tbl_specifications` (
  `title` varchar(250) NOT NULL,
  `type` varchar(500) NOT NULL,
  `p_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_specifications`
--

INSERT INTO `tbl_specifications` (`title`, `type`, `p_id`) VALUES
('Modal Type', 'Extra', 4),
('Modal Type', 'Extra', 5),
('Brand Name', 'Something else', 7),
('Type', 'normal', 7),
('Title1', 'normal', 8),
('Modal Type', 'Extra', 8),
('Modal Type', 'Normal', 9),
('Product Information', '3324144', 9),
('Modal Type', 'Extra', 10),
('Product Information', 'something else', 10),
('Modal Type', 'BMW2', 11),
('Engine Type', 'Extra', 11);

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

--
-- Table structure for table `tbl_subcategories`
--

CREATE TABLE `tbl_subcategories` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `image` varchar(350) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'status: 0 - inactive, 1 - active',
  `addedAt` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_subcategories`
--

INSERT INTO `tbl_subcategories` (`id`, `cat_id`, `name`, `image`, `status`, `addedAt`, `updated_at`) VALUES
(9, 11, 'Wooden Blinds', '1546927982_dblind1.jpg', 1, '2019-01-07 18:15:36', '2019-01-08 14:35:43'),
(10, 11, 'Zebra Blinds', '1546928050_dblind2.jpg', 1, '2019-01-08 11:16:29', '2019-01-08 14:36:10'),
(11, 12, 'Bicycle', '1546938477_bike.png', 1, '2019-01-08 12:12:36', '2019-01-08 14:37:57'),
(12, 12, 'Cars', '1546940626_img10.jpg', 1, '2019-01-08 15:13:46', '0000-00-00 00:00:00');

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

--
-- Table structure for table `tbl_varieties`
--

CREATE TABLE `tbl_varieties` (
  `price_id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `price` varchar(25) NOT NULL,
  `pid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_varieties`
--

INSERT INTO `tbl_varieties` (`price_id`, `name`, `price`, `pid`) VALUES
(1, 'Second price', '123', 4),
(2, 'Second price', '123', 5),
(3, 'Price', '50000', 7),
(4, 'Price', '1500', 8),
(5, 'Price', '45000', 9),
(6, 'Price', '15000', 10),
(7, 'Price', '45555500', 11),
(8, 'normal price', '4782255', 11);

--
-- Indexes for table `tbl_cartlist`
--
ALTER TABLE `tbl_cartlist`
  ADD PRIMARY KEY (`c_id`);

--
-- Indexes for table `tbl_categories`
--
ALTER TABLE `tbl_categories`
  ADD PRIMARY KEY (`cat_id`),
  ADD UNIQUE KEY `cname` (`cname`);

--
-- Indexes for table `tbl_orders`
--
ALTER TABLE `tbl_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orderid` (`orderid`);

--
-- Indexes for table `tbl_products`
--
ALTER TABLE `tbl_products`
  ADD PRIMARY KEY (`p_id`);

--
-- Indexes for table `tbl_subcategories`
--
ALTER TABLE `tbl_subcategories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_varieties`
--
ALTER TABLE `tbl_varieties`
  ADD PRIMARY KEY (`price_id`);

--
-- AUTO_INCREMENT for table `tbl_cartlist`
--
ALTER TABLE `tbl_cartlist`
  MODIFY `c_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_categories`
--
ALTER TABLE `tbl_categories`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_orders`
--
ALTER TABLE `tbl_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_products`
--
ALTER TABLE `tbl_products`
  MODIFY `p_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tbl_subcategories`
--
ALTER TABLE `tbl_subcategories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_varieties`
--
ALTER TABLE `tbl_varieties`
  MODIFY `price_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

