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

START TRANSACTION;



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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `category_id` int(11) NOT NULL COMMENT 'NN',
  `category_name` varchar(100) NOT NULL,
  `category_slug` varchar(150) NOT NULL COMMENT 'SLUG',
  `category_image` varchar(300) NOT NULL COMMENT 'IMAGE',
  `category_text` text NOT NULL COMMENT 'EDITOR|NIL',
  `category_featured` varchar(100) NOT NULL,
  `category_type` varchar(100) NOT NULL,
  `category_relation` varchar(100) NOT NULL COMMENT 'NN',
  `entry_process` varchar(10) NOT NULL DEFAULT 'pending' COMMENT 'NN',
  `category_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN',
  `category_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`category_id`, `category_name`, `category_slug`, `category_image`, `category_text`, `category_featured`, `category_type`, `category_relation`, `entry_process`, `category_date`, `category_status`) VALUES
(1, 'red', 'red-0', '1.jpg', '<p>fsdfdsf ssdasdas asdsadsdds</p>', 'yes', 'women', 'men', 'complete', '2021-02-24 23:02:50', 0),
(2, 'blue', 'blue', '2.jpg', '', 'yes', 'women', 'men', 'completed', '2021-02-24 23:02:50', 0),
(3, 'ornage', 'ornage', '3.jpg', '', 'no', 'men', 'women', 'completed', '2021-02-24 23:03:06', 0),
(4, 'pink', 'pink', '4.jpg', '', 'yes', 'men', 'women', 'completed', '2021-02-24 23:03:06', 0),
(12, 'Taylor Vang', 'taylor-vang', 'buffet-at-nda-restaurant.jpg', '<p>fsd sdfsdf sf sdf sdfsdfsdfsd</p>', 'Pariatur Perferendi', 'Commodi quo sed vel ', '', 'complete', '2021-07-12 23:15:20', 0);

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

--
-- Table structure for table `classi`
--

CREATE TABLE `classi` (
  `classi_id` int(11) NOT NULL COMMENT 'NN',
  `sub_category_id` int(11) NOT NULL COMMENT 'SELFDROP',
  `classi_name` varchar(300) NOT NULL,
  `classi_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `classi_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `classi`
--

INSERT INTO `classi` (`classi_id`, `sub_category_id`, `classi_name`, `classi_status`, `classi_date`) VALUES
(1, 1, 'Google', 0, '2021-03-09 18:30:32'),
(2, 1, 'Yahoo', 0, '2021-03-09 18:30:32');

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

--
-- Table structure for table `pre_image`
--

CREATE TABLE `pre_image` (
  `pre_image_id` int(11) NOT NULL,
  `test_id` int(11) NOT NULL,
  `pre_image_image` varchar(300) NOT NULL,
  `pre_image_status` tinyint(1) NOT NULL DEFAULT 0,
  `pre_image_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pre_image`
--

INSERT INTO `pre_image` (`pre_image_id`, `test_id`, `pre_image_image`, `pre_image_status`, `pre_image_date`) VALUES
(1, 1, '9.jpg', 0, '2021-03-24 00:50:46'),
(2, 1, '10.jpg', 0, '2021-03-24 00:50:46'),
(3, 1, '11.jpg', 0, '2021-03-24 00:50:46'),
(4, 1, '2.jpg', 0, '2021-03-24 01:12:35');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `product_id` int(11) NOT NULL COMMENT 'NN',
  `category_id` int(11) NOT NULL COMMENT 'SELFDROP',
  `sub_category_id` int(11) NOT NULL COMMENT 'RELATION_category_id',
  `product_image` varchar(300) NOT NULL COMMENT 'IMGREL_product_img|MULTIIMAGE',
  `product_name` varchar(150) NOT NULL,
  `product_slug` varchar(200) NOT NULL COMMENT 'SLUG',
  `regular_price` double(10,2) NOT NULL,
  `is_featured` enum('yes','no') NOT NULL COMMENT 'ENUM|NIL',
  `discount_price` double(10,2) NOT NULL,
  `product_color_id` int(11) NOT NULL COMMENT 'NIL|SELFDROP',
  `product_size_id` int(11) NOT NULL COMMENT 'NIL|SELFDROP',
  `quantity` int(11) NOT NULL,
  `purchase_date` date NOT NULL COMMENT 'DATE|NIL',
  `purchase_date_time` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'TIMESTAMP|NIL',
  `product_descripition` text NOT NULL COMMENT 'EDITOR|NIL',
  `entry_process` enum('complete','pending') NOT NULL DEFAULT 'pending' COMMENT 'NN',
  `product_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `product_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`product_id`, `category_id`, `sub_category_id`, `product_image`, `product_name`, `product_slug`, `regular_price`, `is_featured`, `discount_price`, `product_color_id`, `product_size_id`, `quantity`, `purchase_date`, `purchase_date_time`, `product_descripition`, `entry_process`, `product_status`, `product_date`) VALUES
(4, 1, 2, 'Johnson_Mens_Leather_Jacket__67562_std.jpg', 'ne jeacket 2', 'ne-jeacket-2', 122.00, 'no', 200.00, 1, 1, 12, '2020-03-16', '2021-04-16 19:34:01', '<p>adasd asd asdasd</p>', 'complete', 0, '2021-04-16 19:34:01'),
(3, 1, 1, 'Brown_Leather_Bomber_Jacket__58311_std.jpg', 'men jacker', 'men-jacker', 100.00, 'yes', 0.00, 2, 1, 100, '2021-04-16', '2021-04-16 19:32:23', '<p>this is a test product</p>', 'complete', 0, '2021-04-16 19:32:23'),
(15, 1, 1, 'ndi-restaurant.jpg', 'adsasdadsdsdsd', 'adsasdadsdsdsd-0', 0.00, 'yes', 0.00, 1, 2, 123, '0000-00-00', '2021-07-12 23:21:02', '<p>czcsad as dasd asd</p>', 'complete', 0, '2021-07-12 23:21:02');

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

--
-- Table structure for table `product_color`
--

CREATE TABLE `product_color` (
  `product_color_id` int(11) NOT NULL COMMENT 'NN',
  `product_color_name` varchar(50) NOT NULL,
  `product_color_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `product_color_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_color`
--

INSERT INTO `product_color` (`product_color_id`, `product_color_name`, `product_color_status`, `product_color_date`) VALUES
(1, 'Red', 0, '2021-02-25 23:40:46'),
(2, 'Green', 0, '2021-02-25 23:40:46'),
(3, 'Blue', 0, '2021-02-25 23:40:55'),
(4, 'Yellow', 0, '2021-02-25 23:40:55');

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `product_images_id` int(11) NOT NULL COMMENT 'NN',
  `product_id` int(11) NOT NULL COMMENT 'SELFDROP',
  `product_images_image` varchar(300) NOT NULL COMMENT 'IMAGE',
  `product_images_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `product_images_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_img`
--

CREATE TABLE `product_img` (
  `product_img_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_img_image` varchar(300) NOT NULL,
  `product_img_status` tinyint(4) NOT NULL DEFAULT 0,
  `product_img_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_img`
--

INSERT INTO `product_img` (`product_img_id`, `product_id`, `product_img_image`, `product_img_status`, `product_img_date`) VALUES
(1, 3, 'B3_Bomber_Leather_Jacket__35231_std4.jpg', 0, '2021-04-16 19:32:32'),
(2, 3, 'Bomber_Hooded_Leather_Jacket__45484_std4.jpg', 0, '2021-04-16 19:32:32'),
(3, 3, 'Brown_Leather_Bomber_Jacket__58311_std4.jpg', 0, '2021-04-16 19:32:32'),
(4, 3, 'Johnson_Camel_Brown_Leather_Jacket__62858_std4.jpg', 0, '2021-04-16 19:32:32'),
(5, 3, 'Johnson_Mens_Leather_Jacket__67562_std4.jpg', 0, '2021-04-16 19:32:32'),
(6, 4, 'B3_Bomber_Leather_Jacket__35231_std5.jpg', 0, '2021-04-16 19:34:11'),
(7, 4, 'Bomber_Hooded_Leather_Jacket__45484_std5.jpg', 0, '2021-04-16 19:34:11'),
(8, 4, 'Brown_Leather_Bomber_Jacket__58311_std5.jpg', 0, '2021-04-16 19:34:11'),
(9, 4, 'Johnson_Camel_Brown_Leather_Jacket__62858_std5.jpg', 0, '2021-04-16 19:34:11'),
(10, 4, 'Johnson_Mens_Leather_Jacket__67562_std5.jpg', 0, '2021-04-16 19:34:11'),
(11, 15, 'buffet-at-nda-restaurant.jpg', 0, '2021-07-12 23:21:18'),
(12, 15, 'fec1a817-0d45-4922-8e0b-4cef57202f85-restaurants-with-the-best-views-in-the-usa.jpg', 0, '2021-07-12 23:21:18'),
(13, 15, 'ndi-restaurant.jpg', 0, '2021-07-12 23:21:18'),
(14, 15, 'THDP-and-Their-Luxuriously-Delicious-Restaurant-Designs1-1-760x600.jpg', 0, '2021-07-12 23:21:18'),
(15, 16, '14.png', 0, '2021-08-07 00:58:51'),
(16, 16, '28.jpg', 0, '2021-08-07 00:58:51'),
(17, 16, '37.jpg', 0, '2021-08-07 00:58:51'),
(18, 16, '47.jpg', 0, '2021-08-07 00:58:51'),
(19, 16, '55.jpg', 0, '2021-08-07 00:58:51'),
(20, 16, '64.jpg', 0, '2021-08-07 00:58:51'),
(21, 16, '6-3.jpg', 0, '2021-08-07 00:58:51'),
(22, 16, '75.jpg', 0, '2021-08-07 00:58:51'),
(23, 16, '83.jpg', 0, '2021-08-07 00:58:51'),
(24, 16, '93.jpg', 0, '2021-08-07 00:58:51'),
(25, 16, '103.jpg', 0, '2021-08-07 00:58:51'),
(26, 16, '113.jpg', 0, '2021-08-07 00:58:51'),
(27, 16, 'crop_php.jpg', 0, '2021-08-07 00:58:51'),
(28, 16, 'pjimage-20.jpg', 0, '2021-08-07 00:58:51'),
(29, 16, 'satoru-gojo-de-jujutsu-kaisen_1920x1080_6717.jpg', 0, '2021-08-07 00:58:51'),
(30, 16, 'thumb-1920-1037245.png', 0, '2021-08-07 00:58:51'),
(31, 16, 'wallpapersden_com_shinobu-kochou-and-kanao-tsuyuri_2122x1461.jpg', 0, '2021-08-07 00:58:51'),
(32, 15, 'PngItem_5882963.png', 0, '2021-09-17 20:06:04'),
(36, 15, 'toppng_com-stealth-ghost-rider-jacket-for-men-autum-590x765.png', 0, '2021-09-17 20:06:04'),
(37, 15, '12-kg-Lory-Pearls_(1)-min.png', 0, '2021-09-17 20:06:04');

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

--
-- Table structure for table `product_size`
--

CREATE TABLE `product_size` (
  `product_size_id` int(11) NOT NULL COMMENT 'NN',
  `product_size_name` varchar(50) NOT NULL,
  `product_size_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `product_size_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_size`
--

INSERT INTO `product_size` (`product_size_id`, `product_size_name`, `product_size_status`, `product_size_date`) VALUES
(1, 'Small', 0, '2021-02-25 23:41:06'),
(2, 'Medium', 0, '2021-02-25 23:41:06'),
(3, 'XL', 0, '2021-02-25 23:41:19'),
(4, 'XXL', 0, '2021-02-25 23:41:19');

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

--
-- Table structure for table `sartaj`
--

CREATE TABLE `sartaj` (
  `sartaj_id` int(11) NOT NULL COMMENT 'NN',
  `product_id` int(11) NOT NULL COMMENT 'SELFDROP',
  `sartaj_image` varchar(300) NOT NULL,
  `sartaj_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `sartaj_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sartaj`
--

INSERT INTO `sartaj` (`sartaj_id`, `product_id`, `sartaj_image`, `sartaj_status`, `sartaj_date`) VALUES
(1, 2, 'kama.jpg', 0, '2021-03-02 00:58:52'),
(2, 2, 'rama.jpg', 0, '2021-03-02 00:58:52');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `settings_id` int(11) NOT NULL COMMENT 'UONLY|NN',
  `title` varchar(50) NOT NULL,
  `header_logo` varchar(100) NOT NULL COMMENT 'IMAGE',
  `info_email` varchar(200) NOT NULL,
  `entry_process` enum('complete','pending') NOT NULL DEFAULT 'pending',
  `settings_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `settings_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`settings_id`, `title`, `header_logo`, `info_email`, `entry_process`, `settings_status`, `settings_date`) VALUES
(1, 'Advance Panel', '2d4dd32a6e69bd21e595ae0c74a823eb.jpg', 'info@advancepanel.com', 'complete', 0, '2021-02-23 22:46:32');

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

--
-- Table structure for table `sub_category`
--

CREATE TABLE `sub_category` (
  `sub_category_id` int(11) NOT NULL COMMENT 'NN',
  `category_id` int(11) NOT NULL COMMENT 'SELFDROP',
  `sub_category_name` varchar(150) NOT NULL COMMENT 'RELATION_category_id',
  `sub_category_slug` varchar(200) NOT NULL COMMENT 'SLUG',
  `sub_category_image` varchar(300) NOT NULL COMMENT 'IMAGE',
  `entry_process` enum('complete','pending') NOT NULL DEFAULT 'pending' COMMENT 'NN',
  `sub_category_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN',
  `sub_category_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_category`
--

INSERT INTO `sub_category` (`sub_category_id`, `category_id`, `sub_category_name`, `sub_category_slug`, `sub_category_image`, `entry_process`, `sub_category_date`, `sub_category_status`) VALUES
(8, 0, '', '', '', 'pending', '2021-07-12 23:44:15', 0),
(7, 0, '', '', '', 'pending', '2021-07-12 23:43:47', 0);

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

--
-- Table structure for table `test`
--

CREATE TABLE `test` (
  `test_id` int(11) NOT NULL COMMENT 'NN',
  `test_name` varchar(100) NOT NULL,
  `test_image` varchar(300) NOT NULL COMMENT 'IMGREL_pre_image|MULTIIMAGE',
  `entry_process` enum('complete','pending') NOT NULL DEFAULT 'pending' COMMENT 'NN',
  `test_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'NN',
  `test_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'NN'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`test_id`, `test_name`, `test_image`, `entry_process`, `test_status`, `test_date`) VALUES
(1, 'james cross', '21.jpg', 'complete', 0, '2021-03-24 00:44:59');

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `classi`
--
ALTER TABLE `classi`
  ADD PRIMARY KEY (`classi_id`);

--
-- Indexes for table `pre_image`
--
ALTER TABLE `pre_image`
  ADD PRIMARY KEY (`pre_image_id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `product_color`
--
ALTER TABLE `product_color`
  ADD PRIMARY KEY (`product_color_id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`product_images_id`);

--
-- Indexes for table `product_img`
--
ALTER TABLE `product_img`
  ADD PRIMARY KEY (`product_img_id`);

--
-- Indexes for table `product_size`
--
ALTER TABLE `product_size`
  ADD PRIMARY KEY (`product_size_id`);

--
-- Indexes for table `sartaj`
--
ALTER TABLE `sartaj`
  ADD PRIMARY KEY (`sartaj_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`settings_id`);

--
-- Indexes for table `sub_category`
--
ALTER TABLE `sub_category`
  ADD PRIMARY KEY (`sub_category_id`);

--
-- Indexes for table `test`
--
ALTER TABLE `test`
  ADD PRIMARY KEY (`test_id`);

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `classi`
--
ALTER TABLE `classi`
  MODIFY `classi_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `pre_image`
--
ALTER TABLE `pre_image`
  MODIFY `pre_image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `product_color`
--
ALTER TABLE `product_color`
  MODIFY `product_color_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `product_images_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN';

--
-- AUTO_INCREMENT for table `product_img`
--
ALTER TABLE `product_img`
  MODIFY `product_img_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `product_size`
--
ALTER TABLE `product_size`
  MODIFY `product_size_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sartaj`
--
ALTER TABLE `sartaj`
  MODIFY `sartaj_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'UONLY|NN', AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sub_category`
--
ALTER TABLE `sub_category`
  MODIFY `sub_category_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `test`
--
ALTER TABLE `test`
  MODIFY `test_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'NN', AUTO_INCREMENT=2;
COMMIT;

