--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `thenewsvani_stock` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `thenewsvani_stock`;

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` VALUES
(1,'About US','<p>Hi Tech Agro is a privately owned company that offers technologies and services in the field of Municipal Solid Waste and Biomass Processing.&nbsp;We help people use all types of Biomass, Municipal and Industrial residues to produce Clean, Affordable, and Renewable Energy.</p><p>We do this by providing Customized Technologies to fit specific customer needs along with Reliable, Knowledgeable, and Experienced Consulting and Technical Support.</p>','image1719156810776883Screenshot 2023-06-13 at 10.09.03 PM.png');

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `punch_in` datetime DEFAULT current_timestamp(),
  `punch_out` datetime DEFAULT NULL,
  `total_working_time` varchar(150) DEFAULT NULL,
  `working_time` varchar(10) DEFAULT NULL,
  `over_time` varchar(50) DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `attendance`
--

INSERT INTO `attendance` VALUES
(2,12,'2024-08-05 05:06:00',NULL,NULL,'8',NULL,NULL,1),
(3,21,'2024-08-05 19:16:00',NULL,NULL,'6',NULL,NULL,1),
(4,21,'2024-08-06 15:22:00','2024-08-06 15:23:00','0:01','6','0:00',NULL,1),
(5,21,'2024-08-07 23:36:00',NULL,NULL,'8',NULL,NULL,1);

--
-- Table structure for table `banner_image`
--

CREATE TABLE `banner_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `banner_name` text NOT NULL,
  `created_at` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banner_image`
--

INSERT INTO `banner_image` VALUES
(16,'915198463171956552925 (1).jpg','2024-06-28 14:35:29'),
(17,'116118627171956553626.jpg','2024-06-28 14:35:36'),
(18,'485769770171956554127.jpg','2024-06-28 14:35:41');

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_details` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` VALUES
(12,'<p>Developing countries are very environment sensitive when it comes to activities such as energy&nbsp;generation, heat production and cooking. For this reason, we have come up with inventions to&nbsp;replace coal and charcoal which lets out harmful gases in the air and such inventions include the use&nbsp;of biomass such as in the Paddy straw Briquetting plant.fdf</p><p>The Straw Briquette Machine has high productivity and is easy to operate. It is a kind of&nbsp;environmental friendly and energy saving machine for biomass, which is very helpful to the rural&nbsp;areas. It can help farmers turn waste into wealth and make great profit.</p><figure class=\"image\"><img style=\"aspect-ratio:823/465;\" src=\"https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/02/integrated-olant.png?w=825\" alt=\"integrated olant\" srcset=\"https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/02/integrated-olant.png 3088w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/02/integrated-olant.png?w=150&amp;h=85 150w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/02/integrated-olant.png?w=300&amp;h=169 300w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/02/integrated-olant.png?w=768&amp;h=434 768w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/02/integrated-olant.png?w=1024&amp;h=578 1024w\" sizes=\"100vw\" width=\"823\" height=\"465\"></figure><p><i>Integrates Briquetting Plant By HiTech Agro</i></p><p>&nbsp;</p><p>The BINDERLESS EXTRUSION BRIQUETTING PRESS by HiTech Agro is a reliable heavy duty ram type press designed for continuous operation, equipped with a sturdy crank gear, cross head and two flywheels. One of the fly wheels acts as a pulley and is driven by the main motor through flat belt. Forced lubrication is provided by oil circulating system with dual filtration and forced cooling. Material is continuously fed through a hopper by means of a vertical feeder with its own gear box and&nbsp;motor. Regulated feed to the press is provided by independently driven feeding system.</p><p>Dry ground or granulated material is fed to the top of the vertical feeder by screw conveyor. The&nbsp;vertical screw pre-compresses and forces the material downwards into pre-compression chamber.&nbsp;Here the material is forced by the ram through a die system into briquettes to the cooling line. The&nbsp;total operation is continuous and controlled from the main electrical panel.</p><p>The Paddy straw Briquetting process</p><ol><li>Crushing of the Straws</li></ol><p>The long and thick straws are crushed into smaller sizes in two stages.</p><ol><li>Drying</li></ol><p>The crushed straws are then dried; this could be by either sun drying or by use of a dryer where they&nbsp;were completely wet. They are made into straw powder.</p><ol><li>Briquetting</li></ol><p>The crushed and dried powder is channelled to the briquetting machine where great pressure is&nbsp;generated to form great density briquettes.</p><ol><li>Cooling</li></ol><p>They are then cooled to room temperature.</p><p>&nbsp;</p><p>For a seamless processing of paddy straw briquettes, HiTech Agro also provides:</p><p><strong>HOLDING BIN</strong></p><p>To ensure continuous working and high productivity from densification plant (both briquetting and&nbsp;pelletising) it is desirable that intermediate storage is built in between biomass processing and&nbsp;densification system. 15 – 20 minutes intermediate storage helps in uninterrupted production.&nbsp;Holding bin is capable of feeding variable quantity to densification system and can be interlocked with densification plant.</p><p><strong>INTEGRATED GRINDING SYSTEM (IGS)</strong></p><p>Most of the agro residues are not available for in forms that can be directly fed to the briquetting&nbsp;press, therefore the IGS is designed to convert materials such as Soya Husk, Cotton Stalks, Rice Husk, Groundnut Shells, Wood Chips, Mustard Stalk, Sugarcane Trash, Horticultural and Forest Residues into a form that can be accepted by the Briquetting/Pelletizing press.</p><p><strong>TURBO DRYER</strong></p><p><strong>&nbsp;</strong>This TD series dryer is made for suspension drying of powdery/granular material such as sawvdust, press mud, and bagasse pith etc. Having max. Moisture cont. Of 20 % [wet basis]</p><p><strong>CUTTER CUM GRINDER</strong></p><p><strong>&nbsp;</strong>Many agro/forestry/wood residues are not available in forms that can be easily handled/processed.vThe cutter cum grinder is designed in such a manner that the odd size objects can be directly fed into&nbsp;the system manually or through a belt conveyor to get output suitable for feeding to&nbsp;boilers/briquette/pellet machines.</p><figure class=\"image\"><img style=\"aspect-ratio:696/462;\" src=\"https://hitechagroenergy.wordpress.com/wp-content/uploads/2017/11/np_india_burning_51_6315309556-696x462.jpg?w=825\" alt=\"NP_India_burning_51_6315309556-696x462\" srcset=\"https://hitechagroenergy.wordpress.com/wp-content/uploads/2017/11/np_india_burning_51_6315309556-696x462.jpg 696w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2017/11/np_india_burning_51_6315309556-696x462.jpg?w=150&amp;h=100 150w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2017/11/np_india_burning_51_6315309556-696x462.jpg?w=300&amp;h=199 300w\" sizes=\"100vw\" width=\"696\" height=\"462\"></figure><p><i>Stubble burning in Punjab | Source: Neil Palmer/ Wikimedia commons</i></p><p>&nbsp;</p><p>Punjab generates around 18 millions of paddy straw every year. Out of the total, only 10-15 per cent&nbsp;is used in co-generation. Paddy Straw Briquetting has a potential of utilising around one million&nbsp;tonnes of paddy straw per annum by brick-kilns across the state of Punjab. Besides, it can also help in&nbsp;the socio-economic uplift of the farming community as a lot of paddy straw is burnt in the fields every&nbsp;year.</p><p>Importance of this technology</p><p>The machine is reliable and the process has the following desirable features:</p><ul><li>Energy efficient</li><li>High cost performance</li><li>High Production capacity</li><li>Produce low net greenhouse gases emission</li><li>Non-carbonaceous</li></ul><p>Paddy Straw briquetting technology has been considered in many parts of the world today, especially&nbsp;in areas where rice straw do well. It is environment friendly, energy efficient and cost effective.</p><p><strong>BUY WITH CONFIDENCE</strong></p><p><strong>&nbsp;</strong>We at <a href=\"http://hitechagro.org/\">HiTech Agro</a>, stand behind our products and the quality with which they are made. As industry&nbsp;leaders in manufacturing biomass processing equipment, we continually exceed industry standards&nbsp;in providing our customers with the best products and services on the market. Shop with confidence&nbsp;in knowing you’re getting the best in quality.</p>','image17269172787583748integrated-olant (1).png','Paddy Straw based Briquetting Plant in Punjab, India'),
(13,'<p>For thousands of years, people have burned wood for heat. From campfires to fireplaces,&nbsp;people love the idea of a wood fire heating their house. But wood-burning appliances and fireplaces may emit large quantities of air pollutants. Wood smoke contains hundreds of chemical compounds including nitrogen oxides, carbon monoxide, organic gases, and particulate matter, many of which have adverse health effects. In many urban and rural areas, smoke from wood burning is a major contributor to air pollution.</p><p>Because of so many adverse effects wood burning for home heating has since rebounded with a newer method of heating;&nbsp;<strong>pellet&nbsp;burning</strong>.&nbsp;If you don’t already use this method, here are some reasons why you should consider using wood pellet heating for your house.</p><figure class=\"image\"><img style=\"aspect-ratio:796/550;\" src=\"https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/03/mczstovelrg.jpg?w=825\" alt=\"MCZstovelrg.jpg\" srcset=\"https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/03/mczstovelrg.jpg 796w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/03/mczstovelrg.jpg?w=150&amp;h=104 150w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/03/mczstovelrg.jpg?w=300&amp;h=207 300w, https://hitechagroenergy.wordpress.com/wp-content/uploads/2018/03/mczstovelrg.jpg?w=768&amp;h=531 768w\" sizes=\"100vw\" width=\"796\" height=\"550\"></figure><p>&nbsp;</p><h3>WHAT ARE PELLET STOVES?</h3><p>Wood pellet stoves resemble wood burning stoves and fireplaces, but the similarities end there. These stoves are electronically sophisticated appliances that offer an environmentally friendly and low-cost heating option for your home. In a time when environmental awarenes­s is at the forefront and families are keeping a close eye on their finances, wood pellet stoves have become all the rage. ­</p><p>All wood pellet stoves require the same kind of fuel – the wood pellet. These pellets are the byproduct of sawmills and are made from recycled sawdust and wood shavings. They are&nbsp;eco-friendly, cheap and easy to manufacture. Plus, they have a very low pollution rate.</p><h3>WHAT DOES A PELLET STOVE OFFER YOU?</h3><p>Pellet burning has a lot that it can offer a home owner as an alternative to oil heating.</p><p>&nbsp;</p><p>â—&nbsp;<strong>Ease of use.</strong>&nbsp;A pellet stove is easy to load, and easy to&nbsp;maintain. Most stoves will take about 2 bags of pellets a day&nbsp;(which is about 80 pounds). The pellets are loaded into the&nbsp;machine and automatically fed through an auger into the flames.&nbsp;This allows for a&nbsp;<strong>smooth, consistent burn</strong>&nbsp;all day, with very&nbsp;minimal involvement.</p><p>â—&nbsp;<strong>Environment friendly.</strong>&nbsp;They boast an impressive efficiency rating. This means more of&nbsp;your moolah is being converted to heat, which is what you’re&nbsp;looking for! Since we’re burning the pellets, we’re also burning&nbsp;off a lot less of a chemical called&nbsp;<strong>creosote</strong>. Creosote is used&nbsp;to treat wood to keep it from drying out. Since the pellets we use&nbsp;are dried to begin with and tightly packed, a lot less creosote is&nbsp;used, and subsequently released.</p><p>â—&nbsp;<strong>Money saving.</strong>&nbsp;No matter which way you slice it, pellet&nbsp;burning is going to come out cheaper than oil. The upfront&nbsp;investment of a pellet stove may seem a bit hefty, but the long term&nbsp;investment is going to save you money in the&nbsp;winters to come. The energy cost from running the machine is&nbsp;also very minimal, and guaranteed not to put a dent in your electric bill.</p><p><strong>BUY WITH CONFIDENCE</strong></p><p>We at&nbsp;<a href=\"http://hitechagro.org/\">HiTech Agro</a>, stand behind our products and the quality with which they are made. As industry leaders in manufacturing pellet mills, we continually exceed industry standards in providing our customers with the best products on the market. Shop with confidence in knowing you’re getting the best in quality.</p>','image17269173583886811mczstovelrg.jpg','It’s time for the pellet to shine.');

--
-- Table structure for table `client_details`
--

CREATE TABLE `client_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `client_details`
--

INSERT INTO `client_details` VALUES
(14,'Tata Tea','image171956580947072027.jpg'),
(15,'NRDC','image171956582023984236 (3).jpg'),
(16,'Indian Post','image17213746199920147department-of-posts.jpg'),
(17,'Square Image - Make image square','image17213767439099153images.jpg'),
(18,'Altos','image172138325140650831600w-nwGjVuSJ-D0.webp'),
(19,'Company','image17213832597663761dda587d35b48fd01947cf38931323161.jpg');

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mobile_number` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` VALUES
(1,'9898989898','support@gmail.com','<p>Dwarka Delhi</p>');

--
-- Table structure for table `enquiry`
--

CREATE TABLE `enquiry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `city` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `enquiry`
--

INSERT INTO `enquiry` VALUES
(1,'ded','dfdfdf@gmail.com','2342132138','reraeda','nkjdhlkfjelkdjeld','2024-06-15 15:12:33'),
(2,'ded','dfdfdf@gmail.com','2342132138','reraeda','nkjdhlkfjelkdjeld','2024-06-16 09:11:32'),
(3,'ded','dfdfdf@gmail.com','2342132138','reraeda','nkjdhlkfjelkdjeld','2024-06-16 09:14:11'),
(4,'YOGESH SINGH','yogesh0805kumar@gmal.com','9649541656','basai','Hii','2024-09-30 16:06:00'),
(5,'sandeep singh','shekhawatsandeep302@gmail.com','7891111836','binagunj','hii','2024-09-30 16:24:31');

--
-- Table structure for table `machine`
--

CREATE TABLE `machine` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `machine_name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `machine`
--

INSERT INTO `machine` VALUES
(8,'BRIQUETTE PRESS-1'),
(9,'BRIQUETTE PRESS-2'),
(10,'BRIQUETTE PRESS-3'),
(11,'HAMMER MILL'),
(12,'OTHERS');

--
-- Table structure for table `permission`
--

CREATE TABLE `permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ur_id` int(11) DEFAULT NULL,
  `is_users` tinyint(4) DEFAULT 0,
  `is_register_request` tinyint(4) DEFAULT 0,
  `is_all_users` tinyint(4) DEFAULT 0,
  `is_add_user` tinyint(4) DEFAULT 0,
  `is_edit_user` tinyint(4) DEFAULT 0,
  `is_delete_user` tinyint(4) DEFAULT 0,
  `all_stock` tinyint(4) DEFAULT 0,
  `machine_name` tinyint(4) DEFAULT 0,
  `stock_unit` tinyint(4) DEFAULT 0,
  `stock_list` tinyint(4) DEFAULT 0,
  `add_stock` tinyint(4) DEFAULT 0,
  `edit_stock` tinyint(4) DEFAULT 0,
  `delete_stock` tinyint(4) DEFAULT 0,
  `view_stock_in_out` tinyint(4) DEFAULT 0,
  `delete_stock_in_out` tinyint(4) DEFAULT 0,
  `attendance` tinyint(4) DEFAULT 0,
  `mark_attendance` tinyint(4) DEFAULT 0,
  `view_attendance` tinyint(4) DEFAULT 0,
  `delete_attendance` tinyint(4) DEFAULT 0,
  `view_plant` tinyint(4) DEFAULT 0,
  `add_plant` tinyint(4) DEFAULT 0,
  `delete_plant` tinyint(4) DEFAULT 0,
  `view_banner` tinyint(4) DEFAULT 0,
  `add_banner` tinyint(4) DEFAULT 0,
  `delete_banner` tinyint(4) DEFAULT 0,
  `view_role` tinyint(4) DEFAULT 0,
  `add_role` tinyint(4) DEFAULT 0,
  `delete_role` tinyint(4) DEFAULT 0,
  `view_clients` tinyint(4) DEFAULT 0,
  `add_clients` tinyint(4) DEFAULT 0,
  `delete_clients` tinyint(4) DEFAULT 0,
  `view_blog` tinyint(4) DEFAULT 0,
  `add_blog` tinyint(4) DEFAULT 0,
  `edit_blog` tinyint(4) DEFAULT 0,
  `delete_blog` tinyint(4) DEFAULT 0,
  `view_contact` tinyint(4) DEFAULT 0,
  `edit_contact` tinyint(4) DEFAULT 0,
  `view_about` tinyint(4) DEFAULT 0,
  `edit_about` tinyint(4) DEFAULT 0,
  `view_permission` tinyint(4) NOT NULL DEFAULT 0,
  `add_permission` tinyint(4) NOT NULL DEFAULT 0,
  `edit_permission` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `ur_id` (`ur_id`),
  CONSTRAINT `permission_ibfk_1` FOREIGN KEY (`ur_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permission`
--

INSERT INTO `permission` VALUES
(1,12,1,1,1,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2024-08-22 12:30:00','2024-08-22 18:28:41'),
(2,24,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2024-09-30 13:05:00','2024-09-30 18:10:49'),
(3,26,0,0,0,0,0,0,1,1,1,1,1,1,0,1,0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2024-10-07 09:29:35','2024-10-07 09:29:35'),
(4,38,1,1,1,1,1,0,1,1,1,1,1,1,1,0,0,1,0,1,1,1,1,0,1,0,0,1,1,0,1,1,0,0,0,0,0,1,1,1,0,1,0,0,'2024-10-07 10:12:16','2024-10-07 10:12:16');

--
-- Table structure for table `plant_location`
--

CREATE TABLE `plant_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plant_location` varchar(255) NOT NULL,
  `plant_address` text NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `plant_location`
--

INSERT INTO `plant_location` VALUES
(9,'Atru','Mermachah, Atru','76.6698362','24.877725'),
(10,'Aron','Aron, Guna, Madhya Pradesh','77.40047153479563','24.396827799999997'),
(11,'BINAGANJ','BINAGANJ, BYAWARA, MADHYA PRADESH','77.0331716','24.1879436'),
(12,'BALIPARA, TEZPUR','GHORAMARI, BALIPARA, TEZPUR, ASSAM','',''),
(13,'sample','delhi','','');

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

CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) DEFAULT NULL,
  `product_thumbnail_img` varchar(255) DEFAULT NULL,
  `product_description` text DEFAULT NULL,
  `product_images` text DEFAULT NULL,
  `product_price` int(11) DEFAULT NULL,
  `product_status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `product` VALUES
(8,'BRIQUETTE PRESS','thumb_17257987297591447briquette.jpg','Briquette Press Are Manufacturer By Hi Tech Agro Are Based On The High Pressure Ram','img_1725800260976849briquette.jpg',350000,1,'2024-09-08 17:29:55'),
(9,'PELLET PRESS','thumb_17258002809728005pellet.jpg','We offer fully integrated and automated Pellet Plants especially suited for low density fibrous biomass.\r\nHighlights of our technology are.\r\n\r\n Lower electricity consumption.\r\n Ability to run round the clock.\r\n Lower Downtime.\r\n Low cost of wear parts and consumables.\r\n Dust Free operations.\r\n Flexibility to suit all Raw Materials.\r\n Minimum manpower requirement.','img_17258002808867829pellet.jpg',250000,1,'2024-09-08 17:33:53'),
(10,'BRIQUETTE PRESS','thumb_17257987297591447briquette.jpg','Briquette Press Are Manufacturer By Hi Tech Agro Are Based On The High Pressure Ram','img_1725800260976849briquette.jpg',350000,1,'2024-09-08 17:29:55'),
(11,'PELLET PRESS','thumb_17258002809728005pellet.jpg','We offer fully integrated and automated Pellet Plants especially suited for low density fibrous biomass.\r\nHighlights of our technology are.\r\n\r\n Lower electricity consumption.\r\n Ability to run round the clock.\r\n Lower Downtime.\r\n Low cost of wear parts and consumables.\r\n Dust Free operations.\r\n Flexibility to suit all Raw Materials.\r\n Minimum manpower requirement.','img_17258002808867829pellet.jpg',250000,1,'2024-09-08 17:33:53'),
(12,'BRIQUETTE PRESS','thumb_17257987297591447briquette.jpg','Briquette Press Are Manufacturer By Hi Tech Agro Are Based On The High Pressure Ram','img_1725800260976849briquette.jpg',350000,1,'2024-09-08 17:29:55'),
(13,'PELLET PRESS','thumb_17258002809728005pellet.jpg','We offer fully integrated and automated Pellet Plants especially suited for low density fibrous biomass.\r\nHighlights of our technology are.\r\n\r\n Lower electricity consumption.\r\n Ability to run round the clock.\r\n Lower Downtime.\r\n Low cost of wear parts and consumables.\r\n Dust Free operations.\r\n Flexibility to suit all Raw Materials.\r\n Minimum manpower requirement.','img_17258002808867829pellet.jpg',250000,1,'2024-09-08 17:33:53'),
(14,'BRIQUETTE PRESS','thumb_17257987297591447briquette.jpg','Briquette Press Are Manufacturer By Hi Tech Agro Are Based On The High Pressure Ram','img_1725800260976849briquette.jpg',350000,1,'2024-09-08 17:29:55'),
(15,'PELLET PRESS','thumb_17258002809728005pellet.jpg','We offer fully integrated and automated Pellet Plants especially suited for low density fibrous biomass.\r\nHighlights of our technology are.\r\n\r\n Lower electricity consumption.\r\n Ability to run round the clock.\r\n Lower Downtime.\r\n Low cost of wear parts and consumables.\r\n Dust Free operations.\r\n Flexibility to suit all Raw Materials.\r\n Minimum manpower requirement.','img_17258002808867829pellet.jpg',250000,1,'2024-09-08 17:33:53');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES
(15,'OPERATOR-L1'),
(16,'Sr. OPERATOR-L2'),
(17,'HELPER'),
(18,'MAINTENANCE INCHARGE-L2'),
(19,'SHIFT INCHARGE-L2'),
(20,'PLANT INCHARGE-L3'),
(21,'ELECTRICIAN-L2'),
(22,'STORE MANAGER-L3'),
(23,'ASST. MANAGER-L4'),
(24,'MANAGER-L5'),
(25,'SUB ADMIN-L4'),
(26,'ADMIN-L6'),
(27,'CLIENT');

--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `part_name` text DEFAULT NULL,
  `uom` text DEFAULT NULL,
  `category` text DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `min_quantity` int(11) DEFAULT NULL,
  `unit` varchar(80) DEFAULT NULL,
  `plant_name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `created_ad` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=907 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock`
--

INSERT INTO `stock` VALUES
(1,'Ram - 630 X 90 ',NULL,'WEAR PARTS',5,4,'3','9',NULL,NULL,NULL,'2024-09-30 11:12:39'),
(2,'Taper Die - 98 x 90 x 200',NULL,'WEAR PARTS',10,4,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(3,'Split Die - 88 Dia x 480 ',NULL,'WEAR PARTS',6,4,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(4,'Split Die - 88 Dia x 650 ',NULL,'WEAR PARTS',0,0,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(5,'Split Die - 86 Dia x 480 ',NULL,'WEAR PARTS',3,2,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(6,'Split Die - 87 Dia x 480 ',NULL,'WEAR PARTS',0,0,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(7,'Taper Die - 90.5 x 96.5 x 200 (WPS)',NULL,'WEAR PARTS',0,0,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(8,'Wearing - 90 Dia x 40  (WPS)',NULL,'WEAR PARTS',0,0,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(9,'Wearing - 91 Dia ',NULL,'WEAR PARTS',22,6,'3','9',NULL,NULL,NULL,'2024-09-29 15:50:24'),
(317,'Ram - 630 X 90 ',NULL,'WEAR PARTS',6,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(318,'Taper Die - 98 x 90 x 200',NULL,'WEAR PARTS',10,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(319,'Split Die - 88 Dia x 480 ',NULL,'WEAR PARTS',6,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(320,'Split Die - 88 Dia x 650 ',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(321,'Split Die - 86 Dia x 480 ',NULL,'WEAR PARTS',3,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(322,'Split Die - 87 Dia x 480 ',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(323,'Taper Die - 90.5 x 96.5 x 200 (WPS)',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(324,'Wearing - 90 Dia x 40  (WPS)',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(325,'Wearing - 91 Dia ',NULL,'WEAR PARTS',22,6,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(326,'Feeder Box',NULL,'WEAR PARTS',2,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(327,'Vertical Screw with Chuck Nuts',NULL,'WEAR PARTS',4,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(328,'Collet BP 90200- 90 mm',NULL,'WEAR PARTS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(329,'Collet BP 90200- 88 mm',NULL,'WEAR PARTS',1,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(330,'Collet BP 90200- 89 mm',NULL,'WEAR PARTS',1,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(331,'Collet BP 90200- 89.5 mm',NULL,'WEAR PARTS',1,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(332,'Die Holder',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(333,'Die Holder Locking Plate BP 90200',NULL,'SPARE PART',2,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(334,'Die Holder Lifting Rod With Nut (ear)',NULL,'SPARE PART',2,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(335,'Die Holder Chuck Nut',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(336,'C-Clamp for Die Holder',NULL,'SPARE PART',4,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(337,'Flat Belt   6000 x 240',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(338,'King Pin BP 90200',NULL,'SPARE PART',2,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(339,'King Pin Bush',NULL,'WEAR PARTS',2,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(340,'Side Housing Bush',NULL,'WEAR PARTS',0,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(341,'Connecting Link Bush (2 Parts)',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(342,'Hammer Set (HM-3232)- 230X50X10 (144 NOS.)',NULL,'WEAR PARTS',1,1,'4','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(343,'Grinding Bar (HM-3232)-25X25X800 (18 Nos.)',NULL,'WEAR PARTS',1,1,'4','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(344,'Grinding bar (HM-3232) 40X40X800 (14 Nos.)',NULL,'WEAR PARTS',0,0,'4','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(345,'Hammer Screen (HM-3232)- 8 MM hole size',NULL,'WEAR PARTS',1,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(346,'Hammer Screen (HM-3232)- 10 MM hole size',NULL,'WEAR PARTS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(347,'Hammer Screen (HM-3232)- 12 MM hole size',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(348,'Hammer Screen (HM-3232)- 14 MM hole size',NULL,'WEAR PARTS',2,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(349,'Hammer Screen (HM-3232)- 20 MM hole size',NULL,'WEAR PARTS',1,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(350,'Hammer Screen Locking Flat',NULL,'SPARE PART',0,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(351,'Oil Pump -20 LPM',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(352,'Oil Seal- Housing (225x175x15)',NULL,'WEAR PARTS',7,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(353,'Oil Seal- Housing (225x174x15)',NULL,'WEAR PARTS',6,6,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(354,'Oil Seal- RAM (110x90x8)',NULL,'WEAR PARTS',22,8,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(355,'Oil Seal- Piston- 250x225x18',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(356,'Oil Seal for  Vertical Screw GB 70X85X10',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(357,'Oil Seal 45X62X8-Gear Box 3503',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(358,'Bearing Block- Hammer Mill',NULL,'SPARE PART',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(359,'Bearing- Hammer Mill- No. 22320 with Sleeve (H2320)',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(360,'Bearing (6213)',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(361,'Bearing (1213 K)',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(362,'Bearing UCF 217 K',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(363,'UCF 214',NULL,'',3,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(364,'Bearing- F-208',NULL,'',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(365,'Pin Bush Coupling For HM-3232',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(366,'Pin and Bush set for coupling',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(367,'Gear Coupling Coupling For HM-3232',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(368,'EN8 coupling for HM feeding Conveyor',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(369,'Chain Coupling for Leveller',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(370,'EN8 coupling for Belt Feeder Head Pulley',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(371,'Chain Coupling forDust Filter Airlock',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(372,'Chain Coupling for Dust Conveor',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(373,'Chain Coupling for Cyclone airlock',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(374,'Chain Coupling for Distribution Conveyor',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(375,'EN8 coupling for Agitator',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(376,'Chain Coupling for BP feeding Conveyor',NULL,'SPARE PART',1,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(377,'Chain Sprocket foe Leveller',NULL,'SPARE PART',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(378,'V Belt 47 No.',NULL,'SPARE PART',1,1,'4','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(379,'Coupling Set for Oil Pump',NULL,'SPARE PART',3,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(380,'Chain for Chain Coupling',NULL,'SPARE PART',0,0,'15','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(381,'Universal Coupling',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(382,'Oil Filter Assembly',NULL,'SPARE PART',1,1,'4','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(383,'Oil Filter Element- 149 Microne (Wire Mesh)',NULL,'WEAR PARTS',0,6,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(384,'Oil Filter Element- 25 Microne (Paper Mesh)',NULL,'WEAR PARTS',6,6,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(385,'Air Filter',NULL,'WEAR PARTS',7,3,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(386,'Oil Block Fitting BP 90200',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(387,'Dust Filter  Solenoid Valve 1.5inch, 40 NB',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(388,'PU Pipe 10 mm',NULL,'SPARE PART',0,0,'15','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(389,'PU Pipe Connector 1/4 X 10 ',NULL,'SPARE PART',8,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(390,'Solenoid for Pneumatic Gate ',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(391,'V- Belt B47- Vertica;l Screw Gear Box',NULL,'WEAR PARTS',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(392,'PVC Sheet  1 m X 1 m',NULL,'WEAR PARTS',0,0,'15','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(393,'Airlock Liner for 600 Dia Airlock 3inch',NULL,'WEAR PARTS',0,0,'15','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(394,'Belt Spray ',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(395,'Gland Rope  16 mm',NULL,'CONSUMABLES',22,8,'9','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(396,'Gland Rope  10 mm',NULL,'CONSUMABLES',15,8,'9','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(397,'Asbestos Rope 6 mm',NULL,'CONSUMABLES',1,1,'10','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(398,'Welding Rod - 8 Nos.',NULL,'CONSUMABLES',1,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(399,'Welding Rod -10 Nos.',NULL,'CONSUMABLES',2,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(400,'Hard Facing welding Rod ',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(401,'Pressure Switch KU-15',NULL,'SPARE PART',4,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(402,'Normal Grease CASTROL',NULL,'CONSUMABLES',10,5,'9','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(403,'LONG LIFE GREASE',NULL,'CONSUMABLES',20,10,'9','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(404,'Pressure Transducer (Gefran)',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(405,'Acrylic Cover',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(406,'Castrol Alpha SP 460 (210 Ltr)',NULL,'CONSUMABLES',180,100,'11','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(407,'Compressor Oil- [ 20W40 Castrol ]',NULL,'CONSUMABLES',10,3,'11','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(408,'Acrylic Cover Rubber Packing 5 mm Sheet (6+6) 70X1400/70X670',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(409,'Cooling Line Gate with Weight',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(410,'Pressure Switch PFO H30 100 Bar',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(411,'Mask Regular',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(412,'Mask Standard',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(413,'Gloves',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(414,'Goggels',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(415,'Cylinder with Piston Ring 100X60 mm Complete for 7.5 HP Compressor',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(416,'Thermocouple J Type Washer (2 Meters Length) Teflon',NULL,'SPARE PART',2,5,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(417,'Castrol Long Life Grease',NULL,'CONSUMABLES',15,5,'9','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(418,'Flat Pulley 260 X 240 mm',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(419,'Motor Pulley 8inch',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(420,'Air Filter Regulator AirMax 1/2inch ',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(421,'Waste Cloth',NULL,'CONSUMABLES',10,5,'9','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(422,'Cello Tape 2inch',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(423,'M seal [500 Grams ]',NULL,'CONSUMABLES',250,250,'13','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(424,'Emry Paper - 120 Grit ',NULL,'CONSUMABLES',0,0,'15','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(425,'Gasket 1.5 mm for Scrapper Plate',NULL,'CONSUMABLES',3,1,'15','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(426,'Cyclone Bend -323 Heavy Without Pocket',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(427,'Pressure Gauge Glycrene filled 4 inch Dial (BSP 1/2 inch)',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(428,'Teflon Tape',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(429,'Motor 75 HP, 4 Pole, Foot mounted',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(430,'Motor 7.5 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(431,'Motor 1 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(432,'Motor 2 HP, 4 Pole, Foot mounted',NULL,'SPARE PART',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(433,'Motor 3 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(434,'Motor 5 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',0,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(435,'Impeller 30 HP Fan',NULL,'SPARE PART',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(436,'Power Contractors M095',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(437,'Add on Block 2 No. + NC CS94596/10',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(438,'Screen 3 mm for Hammer Mill Feeding Conveyor (1429X1250X3 mm)',NULL,'WEAR PARTS',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(439,'Pressure Switch for 7.5 HP Compressor',NULL,'SPARE PART',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(440,'Cutting wheel 4inch',NULL,'CONSUMABLES',8,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(441,'Grinding Wheel 4inch',NULL,'CONSUMABLES',2,2,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(442,'Buffing Wheel 50 mm',NULL,'CONSUMABLES',7,5,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(443,'Drill 6.8',NULL,'TOOLS',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(444,'Drill 8.5',NULL,'TOOLS',0,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(445,'Drill 10.2',NULL,'TOOLS',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(446,'Tap 8 mm',NULL,'TOOLS',0,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(447,'Tap 10 mm',NULL,'TOOLS',0,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(448,'Tap 12 mm',NULL,'TOOLS',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(449,'Tap 16 mm',NULL,'TOOLS',0,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(450,'Tap 20 mm',NULL,'TOOLS',0,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(451,'Allen Key Box mm',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(452,'Allen Key Box inch',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(453,'D Spanner 12 x 13',NULL,'TOOLS',2,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(454,'D Spanner 14 x 15',NULL,'TOOLS',2,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(455,'D Spanner 18 x 19',NULL,'TOOLS',3,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(456,'D Spanner 24 x 27',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(457,'Ring Spanner  12 x 13',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(458,'Ring Spanner  14 x 15',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(459,'Ring Spanner  18 x 19',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(460,'Ring Spanner  24 x 27',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(461,'Hand Drill machine',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(462,'Hand Grinder-4inch',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(463,'High pressure Air Spray Gun',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(464,'Grease Gun ',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(465,'Ratchet Socket Wrench Spanner Goti Set',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(466,'Feeler Guage 6 inch',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(467,'Pipe Wrench 14 inch',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(468,'Side Wrench 14 inch',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(469,'Flat file with handle 12inch ',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(470,'Round file with handle 12inch',NULL,'TOOLS',1,1,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(471,'Allen Bolt  12 x 35',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(472,'Allen Bolt  12 x 50',NULL,'CONSUMABLES',27,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(473,'Allen Bolt  10 x 70',NULL,'CONSUMABLES',10,5,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(474,'Hex Bolt with Nut M10X50 for Gland Rope Locking Plate',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(475,'Allen Bolt M12X35 for Ram for Wear Ring Locking Plate',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(476,'Hex Bolt 1/2 Inch X 25 mm ',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(477,'Hex Bolt 3/8 Inch X 25 mm ',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(478,'Hex Bolt M12 X 40 ',NULL,'CONSUMABLES',20,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(479,'Grub screw (M8X35)',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(480,'Hammer Mill Cover Bolts 1/2 inch X 40 mm',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(481,'Collet Puller Bolt M16X100 FULL THREADED- Allen bolt',NULL,'CONSUMABLES',4,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(482,'Hex Bolt M 10 X35 for Ram oil seal locking plate',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(483,'Hex bolt with nut M10X75 for gland rope locking plate',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(484,'Allen Bolt M12X50 for Ram collet',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(485,'Square bar for key, 10 mm, 14 mm, 16 mm, 18 mm, 20 MM- 1 No. each 300 long',NULL,'CONSUMABLES',1,1,'4','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(486,'Collet Jack Bolts M16 X 100',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(487,'Gurb Screw M8 X 20',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(488,'Hex Bolt + Nut M16X80',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(489,'Hex Bolt M16X50',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(490,'Feeder Box Bolt 16 X 300',NULL,'CONSUMABLES',8,4,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(491,'Collet Extraction Bolt 16 X 65',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(492,'Collet Tightening Bolt 12 X 40',NULL,'CONSUMABLES',6,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(493,'Feeder Box Plate Bolts Hex 10X35',NULL,'CONSUMABLES',16,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(494,'Scrapper Box Plate Bolts Hex 10X35',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(495,'Gurb Screw 6X35',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(496,'Allen Bolt  12 x 40',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(497,'Hex Bolt- M8X40 for Airlock Liner',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(498,'Hex Bolt for Die Locking 12x35',NULL,'CONSUMABLES',20,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(499,'Hex Bolt- M10X60 ',NULL,'CONSUMABLES',30,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(500,'Hex Bolt- M8X35 ',NULL,'CONSUMABLES',30,10,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(501,'Grub screw (M10X75)',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(502,'Flywheel Pulley Nut with Bolt',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(503,'Foundation Bolt 1.25X24 with Nut Two & Washer Two',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(504,'Elbow 3/8 MF',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(505,'Elbow 3/8',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(506,'HEX Nipple 3/8',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(507,'Adapter 3/8',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(508,'Adapter 1/4X3/8',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(509,'Adapter 1/2X3/8',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(510,'Adapter 1/2X3/8 3LG',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(511,'Hose Pipe 3/8 STX90 10.5',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(512,'Hose Pipe 3/8 STX90 16.25',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(513,'Hose Pipe 3/8 STX90 51',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(514,'Hose Pipe 3/8 STXST 24 (6+10EXTRA)',NULL,'CONSUMABLES',17,6,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(515,'Hose Pipe 3/8 STXST 10.25',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(516,'Hose Pipe 3/8 STXST 21 (3+2EXTRA)',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(517,'Hex (N+B) M16X45',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(518,'Geaser Pipe 1/2 inch threaded- 1 mtr long',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(519,'Counter Head Allenkey Bolts- M10X25, with Spring Washer',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(520,'Hose Pipe- 3/4 inch threaded- 5 Feet long',NULL,'CONSUMABLES',0,0,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(521,'Gyeser Pipe- 1/2 inch',NULL,'SPARE PART',9,3,'6','10',NULL,NULL,NULL,'2024-09-30 09:25:51'),
(704,'Ram - 630 X 90 ',NULL,'WEAR PARTS',5,4,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(705,'Taper Die - 98 x 90 x 200',NULL,'WEAR PARTS',8,4,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(706,'Split Die - 88 Dia x 480 ',NULL,'WEAR PARTS',5,4,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(707,'Split Die - 88 Dia x 650 ',NULL,'WEAR PARTS',2,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(708,'Split Die - 86 Dia x 480 ',NULL,'WEAR PARTS',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(709,'Split Die - 87 Dia x 480 ',NULL,'WEAR PARTS',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(710,'Taper Die - 90.5 x 96.5 x 200 (WPS)',NULL,'WEAR PARTS',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(711,'Wearing - 90 Dia x 40  (WPS)',NULL,'WEAR PARTS',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(712,'Wearing - 91 Dia ',NULL,'WEAR PARTS',7,6,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(713,'Feeder Box',NULL,'WEAR PARTS',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(714,'Vertical Screw with Check Nuts',NULL,'WEAR PARTS',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(715,'Collet BP 90200- 90 mm',NULL,'WEAR PARTS',4,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(716,'Collet BP 90200- 88 mm',NULL,'WEAR PARTS',1,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(717,'Collet BP 90200- 89 mm',NULL,'WEAR PARTS',1,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(718,'Collet BP 90200- 89.5 mm',NULL,'WEAR PARTS',1,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(719,'Die Holder',NULL,'SPARE PART',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(720,'Die Holder Locking Plate BP 90200',NULL,'SPARE PART',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(721,'Die Holder Lifting Rod  (Ear)',NULL,'SPARE PART',2,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(722,'Die Holder Chuck Nut',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(723,'C-Clamp for Die Holder',NULL,'SPARE PART',2,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(724,'Flat Belt   6000 x 240',NULL,'SPARE PART',2,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(725,'King Pin BP 90200',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(726,'King Pin Bush',NULL,'WEAR PARTS',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(727,'Side Housing Bush',NULL,'WEAR PARTS',2,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(728,'Connecting Link Bush (2 Parts)',NULL,'WEAR PARTS',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(729,'Hammer Set (HM-3232)- 230X50X10 (144 NOS.)',NULL,'WEAR PARTS',1,1,'4','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(730,'Grinding Bar (HM-3232)-25X25X800 (18 Nos.)',NULL,'WEAR PARTS',9,9,'4','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(731,'Grinding bar (HM-3232) 40X40X800 (14 Nos.)',NULL,'WEAR PARTS',0,0,'4','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(732,'Hammer Screen (HM-3232)- 8 MM hole size',NULL,'WEAR PARTS',1,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(733,'Hammer Screen (HM-3232)- 10 MM hole size',NULL,'WEAR PARTS',2,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(734,'Hammer Screen (HM-3232)- 12 MM hole size',NULL,'WEAR PARTS',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(735,'Hammer Screen (HM-3232)- 14 MM hole size',NULL,'WEAR PARTS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(736,'Hammer Screen (HM-3232)- 20 MM hole size',NULL,'WEAR PARTS',1,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(737,'Hammer Screen Locking Flat',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(738,'Oil Pump-20 LPM',NULL,'SPARE PART',2,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(739,'Oil Seal- Housing (210×175x15)_x000D_',NULL,'WEAR PARTS',10,6,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(740,'Oil Seal- Housing (210x174x15)',NULL,'WEAR PARTS',6,6,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(741,'Oil Seal- RAM (110x90x8)',NULL,'WEAR PARTS',16,6,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(742,'Oil Seal- Piston- 250x225x15',NULL,'WEAR PARTS',2,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(743,'Oil Seal for  Vertical Screw GB 70X85X10',NULL,'WEAR PARTS',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(744,'Oil Seal 45X62X8-Gear Box 3503',NULL,'WEAR PARTS',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(745,'Bearing Block- Hammer Mill',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(746,'Bearing- Hammer Mill- No. 22320',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(747,'Bearing (6213)',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(748,'Bearing (1213 K)',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(749,'Bearing F217',NULL,'SPARE PART',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(750,'Pin Bush Coupling For HM-3232',NULL,'SPARE PART',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(751,'Pin and Bush set for coupling',NULL,'SPARE PART',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(752,'Gear Coupling Coupling For HM-3232',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(753,'EN8 coupling for HM feeding Conveyor',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(754,'Chain Coupling for Leveller',NULL,'SPARE PART',2,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(755,'EN8 coupling for Belt Feeder Head Pulley',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(756,'Chain Coupling forDust Filter Airlock',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(757,'Chain Coupling for Dust Conveor',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(758,'Chain Coupling for Cyclone airlock',NULL,'SPARE PART',2,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(759,'Chain Coupling for Distribution Conveyor',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(760,'EN8 coupling for Agitator',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(761,'Chain Coupling for BP feeding Conveyor',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(762,'Coupling Set for Oil Pump',NULL,'SPARE PART',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(763,'Chain for Chain Coupling',NULL,'SPARE PART',0,1,'15','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(764,'Universal Coupling',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(765,'Oil Filter Assembly',NULL,'SPARE PART',1,1,'4','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(766,'Oil Filter Element- 149 Microne (Wire Mesh)',NULL,'WEAR PARTS',3,5,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(767,'Oil Filter Element- 25 Microne (Paper Mesh)',NULL,'WEAR PARTS',9,5,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(768,'Oil Block Fitting BP 90200',NULL,'SPARE PART',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(769,'Dust Filter  Solenoid Valve 1.5\", 40 NB',NULL,'SPARE PART',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(770,'PU Pipe 10 mm',NULL,'SPARE PART',0,10,'15','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(771,'PU Pipe Connector 1/4 X 10 ',NULL,'SPARE PART',0,8,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(772,'Solenoid for Pneumatic Gate ',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(773,'V- Belt B47- Vertica;l Screw Gear Box',NULL,'WEAR PARTS',0,3,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(774,'PVC Sheet  1 m X 1 m',NULL,'WEAR PARTS',0,2,'15','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(775,'Airlock Liner for 600 Dia Airlock 3\"',NULL,'WEAR PARTS',3,3,'15','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(776,'Belt Spray ',NULL,'CONSUMABLES',4,6,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(777,'Gland Rope  16 mm',NULL,'CONSUMABLES',22,8,'9','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(778,'Gland Rope  10 mm',NULL,'CONSUMABLES',15,8,'9','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(779,'Asbestos Rope 6 mm',NULL,'CONSUMABLES',3,1,'10','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(780,'Welding Rod ',NULL,'CONSUMABLES',4,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(781,'Hard Facing welding Rod ',NULL,'CONSUMABLES',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(782,'Pressure Switch KU-15',NULL,'SPARE PART',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(783,'Normal Grease Servo',NULL,'CONSUMABLES',0,5,'9','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(784,'Pressure Transducer (Gefran)',NULL,'SPARE PART',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(785,'Acrylic Cover',NULL,'SPARE PART',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(786,'Castrol Alpha SP 460 (210 Ltr)',NULL,'CONSUMABLES',150,100,'11','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(787,'Compressor Oil- [ 20W40 Castrol ]',NULL,'CONSUMABLES',7,2,'11','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(788,'Acrylic Cover Rubber Packing 5 mm Sheet (6+6) 70X1400/70X670',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(789,'Cooling Line Gate with Weight',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(790,'Pressure Switch PFO H30 100 Bar',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(791,'Mask Regular',NULL,'CONSUMABLES',0,50,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(792,'Mask Standard',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(793,'Gloves',NULL,'CONSUMABLES',0,20,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(794,'Goggels',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(795,'Cylinder with Piston Ring 100X60 mm Complete for 7.5 HP Compressor',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(796,'Thermocouple J Type Washer (2 Meters Length) Teflon',NULL,'SPARE PART',0,5,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(797,'Castrol Long Life Grease',NULL,'CONSUMABLES',0,10,'9','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(798,'Flat Pulley 260 X 240 mm',NULL,'SPARE PART',1,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(799,'Motor Pulley 8\"',NULL,'SPARE PART',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(800,'Air Filter Regulator AirMax 1/2\" ',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(801,'Waste Cloth',NULL,'CONSUMABLES',0,5,'9','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(802,'Cello Tape 2\"',NULL,'CONSUMABLES',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(803,'M seal [500 Grams ]',NULL,'CONSUMABLES',0,250,'13','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(804,'Emry Paper - 120 Grit ',NULL,'CONSUMABLES',0,5,'15','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(805,'Gasket 1.5 mm for Scrapper Plate',NULL,'CONSUMABLES',2,2,'15','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(806,'Cyclone Bend -323 Heavy Without Pocket',NULL,'SPARE PART',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(807,'Pressure Gauge Glycrene filled 4 inch Dial (BSP 1/2 inch)',NULL,'SPARE PART',2,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(808,'Teflon Tape',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(809,'Motor 75 HP, 4 Pole, Foot mounted',NULL,'SPARE PART',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(810,'Motor 7.5 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(811,'Motor 1 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(812,'Motor 2 HP, 4 Pole, Foot mounted',NULL,'SPARE PART',2,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(813,'Motor 3 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(814,'Motor 5 HP, 4 Pole, Flange mounted',NULL,'SPARE PART',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(815,'Impeller 30 HP Fan',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(816,'Power Contractors M095',NULL,'SPARE PART',4,2,'16','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(817,'Add on Block 2 No. + NC CS94596/10',NULL,'SPARE PART',0,1,'17','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(818,'Screen 3 mm for Hammer Mill Feeding Conveyor (1429X1250X3 mm)',NULL,'WEAR PARTS',1,1,'16','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(819,'Pressure Switch for 7.5 HP Compressor',NULL,'SPARE PART',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(820,'Cutting wheel 4\"',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(821,'Grinding Wheel 4\"',NULL,'CONSUMABLES',0,5,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(822,'Buffing Wheel 50 mm',NULL,'CONSUMABLES',0,5,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(823,'Drill 6.8',NULL,'TOOLS',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(824,'Drill 8.5',NULL,'TOOLS',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(825,'Drill 10.2',NULL,'TOOLS',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(826,'Tap 8 mm',NULL,'TOOLS',3,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(827,'Tap 10 mm',NULL,'TOOLS',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(828,'Tap 12 mm',NULL,'TOOLS',3,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(829,'Tap 16 mm',NULL,'TOOLS',3,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(830,'Tap 20 mm',NULL,'TOOLS',3,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(831,'Allen Key 3mm to 12 mm',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(832,'D Spanner 12 x 13',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(833,'D Spanner 14 x 15',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(834,'D Spanner 18 x 19',NULL,'TOOLS',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(835,'D Spanner 24 x 27',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(836,'Ring Spanner  12 x 13',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(837,'Ring Spanner  14 x 15',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(838,'Ring Spanner  18 x 19',NULL,'TOOLS',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(839,'Ring Spanner  24 x 27',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(840,'Hand Drill machine',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(841,'Hand Grinder-4\"',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(842,'High pressure Air Spray Gun',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(843,'Grease Gun ',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(844,'Ratchet Socket Wrench Spanner Goti Set',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(845,'Feeler Guage 6\"',NULL,'TOOLS',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(846,'Pipe Wrench 14\"',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(847,'Side Wrench 14\"',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(848,'Flat file with handle 12\" ',NULL,'TOOLS',0,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(849,'Round file with handle 12\"',NULL,'TOOLS',1,1,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(850,'Allen Bolt  12 x 35',NULL,'CONSUMABLES',5,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(851,'Allen Bolt  12 x 45',NULL,'CONSUMABLES',10,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(852,'Hex Bolt with Nut M10X50 for Gland Rope Locking Plate',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(853,'Allen Bolt M12X35 for Ram for Wear Ring Locking Plate',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(854,'Hex Bolt 1/2 Inch X 25 mm ',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(855,'Hex Bolt 3/8 Inch X 25 mm ',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(856,'Hex Bolt M12 X 40 ',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(857,'Grub screw (M8X35)',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(858,'Hammer Mill Cover Bolts 1/2 inch X 40 mm',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(859,'Collet Puller Bolt M16X100 FULL THREADED- Allen bolt',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(860,'Hex Bolt M 10 X35 for Ram oil seal locking plate',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(861,'Hex bolt with nut M10X75 for gland rope locking plate',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(862,'Allen Bolt M12X50 for Ram collet',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(863,'Square bar for key, 10 mm, 14 mm, 16 mm, 18 mm- 1 No. each 300 long',NULL,'CONSUMABLES',1,1,'4','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(864,'Collet Jack Bolts M16 X 100',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(865,'Gurb Screw M8 X 20',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(866,'Hex Bolt + Nut M16X80',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(867,'Hex Bolt M16X50',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(868,'Feeder Box Bolt 16 X 300',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(869,'Collet Extraction Bolt 16 X 65',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(870,'Collet Tightening Bolt 12 X 35',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(871,'Feeder Box Plate Bolts Hex 10X35',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(872,'Scrapper Box Plate Bolts Hex 10X35',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(873,'Gurb Screw 6X35',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(874,'Allen Bolt  12 x 40',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(875,'Hex Bolt- M8X40 for Airlock Liner',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(876,'Grub screw (M10X75)',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(877,'Flywheel Pulley Nut with Bolt',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(878,'Foundation Bolt 1.25\"X24\" with Nut Two & Washer Two',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(879,'Elbow 3/8 MF',NULL,'CONSUMABLES',3,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(880,'Elbow 3/8',NULL,'CONSUMABLES',2,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(881,'HEX Nipple 3/8',NULL,'CONSUMABLES',3,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(882,'Adapter 3/8',NULL,'CONSUMABLES',2,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(883,'Adapter 1/4X3/8',NULL,'CONSUMABLES',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(884,'Adapter 1/2X3/8',NULL,'CONSUMABLES',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(885,'Adapter 1/2X3/8 3LG',NULL,'CONSUMABLES',0,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(886,'Hose Pipe 3/8 STX90 10.5',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(887,'Hose Pipe 3/8 STX90 16.25',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(888,'Hose Pipe 3/8 STX90 51',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(889,'Hose Pipe 3/8 STXST 24 (6+10EXTRA)',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(890,'Hose Pipe 3/8 STXST 10.25',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(891,'Hose Pipe 3/8 STXST 21 (3+2EXTRA)',NULL,'CONSUMABLES',0,0,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(892,'Hex (N+B) M16X45',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(893,'Geaser Pipe 1/2 inch threaded- 1 mtr long',NULL,'CONSUMABLES',5,5,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(894,'Counter Head Allenkey Bolts- M10X25, with Spring Washer',NULL,'CONSUMABLES',0,10,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(895,'Hose Pipe- 3/4 inch threaded- 5 Feet long',NULL,'CONSUMABLES',0,5,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(896,'bearing p 208',NULL,'SPARE PART',4,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(897,'bearingT 112',NULL,'SPARE PART',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(898,'bearing F 212',NULL,'SPARE PART',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(899,'bearing F214',NULL,'SPARE PART',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(900,'bearingF217',NULL,'SPARE PART',1,2,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(901,'hose pipe 2 feet',NULL,'CONSUMABLES',8,6,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(902,'hose pipe 1.5 feet l tipe',NULL,'CONSUMABLES',3,4,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(903,'hose pipe  1feet L tipe',NULL,'CONSUMABLES',2,4,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(904,'hose pipe 270 mm',NULL,'CONSUMABLES',10,4,'6','11',NULL,NULL,NULL,'2024-10-01 06:23:46'),
(905,'Sample',NULL,'Sample',100,6,'4','13',NULL,'image17278961712780226pellet.jpg',NULL,'2024-10-02 19:09:31'),
(906,'second sample',NULL,'Sample',200,10,'4','13',NULL,'image17278970322074159briquette.jpg',NULL,'2024-10-05 10:49:51');

--
-- Table structure for table `stock_history`
--

CREATE TABLE `stock_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `machine_name` text DEFAULT NULL,
  `stock_in` int(11) DEFAULT NULL,
  `stock_out` int(11) DEFAULT NULL,
  `stock_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `unit_name` varchar(100) DEFAULT NULL,
  `plant_name` varchar(255) DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `date_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_history`
--

INSERT INTO `stock_history` VALUES
(6,'PC',10,0,1,21,'','9,10','hi','2024-07-31 05:10:14'),
(7,'HP',100,0,1,21,'','9,10','hi','2024-07-31 05:11:30'),
(11,'HP',100,0,1,21,'','9','hi','2024-08-06 05:11:30'),
(12,'BRIQUETTE PRESS-1',4,0,1,12,'','10','','2024-08-07 08:45:24'),
(13,'BRIQUETTE PRESS-2',5,0,45,12,'','11','','2024-08-08 06:27:23'),
(14,'BRIQUETTE PRESS-1',10,0,1,21,'','9','hello','2024-08-09 14:07:00'),
(15,'BRIQUETTE PRESS-2',50,0,3,21,'Set','10','hi','2024-08-11 13:54:28'),
(16,'BRIQUETTE PRESS-2',50,0,1,21,'Nos','10,11','hi','2024-08-11 13:56:28'),
(17,'BRIQUETTE PRESS-1',0,10,1,21,'Nos','9,11','hi','2024-08-12 07:49:44'),
(18,'BRIQUETTE PRESS-1',0,10,1,21,'Nos','9','hi','2024-08-12 07:53:58'),
(19,'BRIQUETTE PRESS-1',0,10,1,21,'Nos','10','hi','2024-08-12 07:56:17'),
(20,'BRIQUETTE PRESS-1',10,0,1,21,'Nos','11','hi','2024-08-12 09:06:02'),
(21,'BRIQUETTE PRESS-1',10,0,1,21,'Nos','12','hi','2024-08-13 08:01:00'),
(22,'BRIQUETTE PRESS-1',100,0,1,24,'Nos','Unknown','Hello','2024-08-27 15:58:30'),
(23,'BRIQUETTE PRESS-1',100,0,1,24,'Nos','Unknown','Hello I Added 100 Quantity Of Ram','2024-08-27 16:01:18'),
(24,'BRIQUETTE PRESS-1',100,0,1,24,'Nos','9','hi','2024-08-27 23:15:43'),
(25,'BRIQUETTE PRESS-1',100,0,1,24,'Nos','9','Hello','2024-08-28 18:04:22'),
(26,'BRIQUETTE PRESS-1',2,0,1,12,'Nos','10','','2024-09-13 19:42:24'),
(27,'BRIQUETTE PRESS-3',0,1,1,12,'Nos','10','ram change','2024-09-13 19:43:05'),
(28,'BRIQUETTE PRESS-1',100,0,1,21,'Nos','9','Hello','2024-09-21 07:17:41'),
(29,'BRIQUETTE PRESS-2',0,1,1,12,'nos.','10','','2024-09-30 07:12:39'),
(30,'BRIQUETTE PRESS-1',100,0,906,24,'Set','13','Hello','2024-10-05 06:49:51');

--
-- Table structure for table `stock_unit`
--

CREATE TABLE `stock_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_unit`
--

INSERT INTO `stock_unit` VALUES
(4,'Set'),
(5,'Liter'),
(6,'nos.'),
(7,'mtr'),
(9,'kg'),
(10,'roll'),
(11,'ltr'),
(13,'gms'),
(15,'meter'),
(16,'nos'),
(17,'nos,');

--
-- Table structure for table `supports`
--

CREATE TABLE `supports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ur_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `supports`
--

INSERT INTO `supports` VALUES
(1,12),
(2,24);

--
--

USE `thenewsvani_stock`;

--
