-- phpMyAdmin SQL Dump
-- version 5.0.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3307
-- Generation Time: Nov 28, 2022 at 03:17 PM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `inventory_pctl`
--

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

--
-- Table structure for table `industries`
--

CREATE TABLE `industries` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `doc` timestamp NULL DEFAULT current_timestamp(),
  `createdby` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `industries`
--

INSERT INTO `industries` (`id`, `name`, `status`, `doc`, `createdby`) VALUES
(1, 'Agriculture & Forestry/Wildlife', 'active', '2020-07-23 04:16:17', 1),
(2, 'Automotive', 'active', '2020-07-23 04:16:17', 1),
(3, 'Business Support & Supplies', 'active', '2020-07-23 04:16:17', 1),
(4, 'Computers & Electronics ', 'active', '2020-07-23 04:16:17', 1),
(5, 'Construction & Contractors ', 'active', '2020-07-23 04:16:17', 1),
(6, 'Education', 'active', '2020-07-23 04:16:17', 1),
(7, 'Entertainment', 'active', '2020-07-23 04:16:17', 1),
(8, 'Food & Dining ', 'active', '2020-07-23 04:16:17', 1),
(9, 'Health & Medicine ', 'active', '2020-07-23 04:16:17', 1),
(10, 'Home & Garden ', 'active', '2020-07-23 04:16:17', 1),
(11, 'Legal & Financial ', 'active', '2020-07-23 04:18:26', 1),
(12, 'Manufacturing, Wholesale,\r\nDistribution', 'active', '2020-07-23 04:18:26', 1),
(13, 'Merchants (Retail) ', 'active', '2020-07-23 04:18:26', 1),
(14, 'Miscellaneous', 'active', '2020-07-23 04:18:26', 1),
(15, 'Personal Care & Services ', 'active', '2020-07-23 04:18:26', 1),
(16, 'Real Estate & Housing', 'active', '2020-07-23 04:18:26', 1),
(17, 'Safety/Security', 'active', '2020-07-23 04:18:26', 1),
(18, 'Legal & Financial ', 'active', '2020-07-23 04:21:28', 1),
(19, 'Merchants Retail ', 'active', '2020-07-23 04:21:28', 1),
(20, 'Miscellaneous', 'active', '2020-07-23 04:21:28', 1),
(21, 'Personal Care & Services ', 'active', '2020-07-23 04:21:28', 1),
(22, 'Real Estate & Housing', 'active', '2020-07-23 04:21:28', 1),
(23, 'Safety/Security', 'active', '2020-07-23 04:21:28', 1),
(24, 'Hardware', 'active', '2020-08-27 07:29:27', 1),
(25, 'Transportation', 'active', '2020-08-27 07:29:27', 1),
(26, 'Petrol station', 'active', '2020-08-27 07:29:27', 1),
(27, 'Furnitures', 'active', '2020-08-27 07:29:27', 1),
(28, 'Furniture', 'active', '2020-08-27 07:29:27', 1),
(29, 'Importation', 'active', '2020-08-27 07:29:27', 1),
(30, 'Consultancy', 'active', '2020-08-27 07:29:27', 1),
(31, 'Tourism', 'active', '2020-09-01 12:25:13', NULL),
(32, 'Hospitality', 'active', '2020-09-01 12:26:09', NULL),
(33, 'NOT AVAILABLE', 'active', '2020-09-02 12:57:29', NULL),
(34, 'LOGISTICS', 'active', '2020-09-02 13:36:05', NULL),
(35, 'Stationary', 'active', '2020-09-03 07:27:33', NULL),
(36, 'Wholesaler', 'active', '2020-09-03 07:27:51', NULL),
(37, 'Others', 'active', '2020-09-03 07:29:46', NULL),
(38, 'Jewellery', 'active', '2020-09-03 08:09:24', NULL),
(39, 'Agriculture', 'active', '2020-09-03 08:13:18', NULL),
(40, 'Bakery', 'active', '2020-09-03 11:36:24', NULL),
(41, 'Internet Cafe', 'active', '2020-09-03 12:30:48', NULL),
(42, 'Construction and Electronics', 'active', '2020-09-03 12:52:27', NULL),
(43, 'insurance', 'active', '2020-09-03 13:01:15', NULL),
(44, 'Spare parts', 'active', '2020-09-03 13:09:57', NULL),
(45, 'Supplier', 'active', '2020-09-04 07:04:39', NULL),
(46, 'Telecommunication', 'active', '2020-09-04 07:05:09', NULL),
(47, 'OIL AND GAS', 'active', '2020-09-04 12:33:00', NULL),
(48, 'AUDITING', 'active', '2020-09-04 12:33:14', NULL),
(49, 'TIMBER', 'active', '2020-09-04 13:06:17', NULL),
(50, 'Information Technology', 'active', '2020-09-07 08:29:44', NULL),
(51, 'PRINTING', 'active', '2020-09-07 13:02:24', NULL),
(52, 'BAR', 'active', '2020-09-08 08:06:54', NULL),
(53, 'DECORATION', 'active', '2020-09-08 08:10:48', NULL),
(54, 'SUPERMARKET', 'active', '2020-09-08 09:56:24', NULL),
(55, 'Clearing and Forwading', 'active', '2020-09-09 07:56:56', NULL),
(56, 'Beverages', 'active', '2020-09-10 07:01:17', NULL),
(57, 'POULTRY', 'active', '2020-09-10 07:21:43', NULL),
(58, 'Data Processing', 'active', '2020-09-11 06:50:58', NULL),
(59, 'OIL AND LUBRICANT', 'active', '2020-09-11 08:04:19', NULL),
(60, 'FLOWER AND GARDEN', 'active', '2020-09-14 09:25:11', NULL),
(61, 'LIQUOR STORE', 'active', '2020-09-15 07:06:56', NULL),
(62, 'ELECTRONICS', 'active', '2020-09-16 07:37:05', NULL),
(63, 'MOBILE FINANCIAL SERVICES', 'active', '2020-09-16 09:25:26', NULL),
(64, 'SERVICE GIVING COMPANY', 'active', '2020-09-16 13:09:42', NULL),
(65, 'LABATORY EQUIPMENT & CHEMICALS', 'active', '2020-09-17 07:48:33', NULL),
(66, 'PHONE ACCESSORIES', 'active', '2020-09-17 07:58:16', NULL),
(67, 'PROCUREMENT', 'active', '2020-09-17 08:18:38', NULL),
(68, 'FABRICS', 'active', '2020-09-18 11:24:43', NULL),
(69, 'MARKETING', 'active', '2020-09-18 11:38:48', NULL),
(70, 'MINING', 'active', '2020-09-30 07:27:28', NULL),
(71, 'PHARMACY', 'active', '2020-09-30 08:50:16', NULL),
(72, 'BROKERS', 'active', '2020-10-09 07:34:45', NULL),
(73, 'GRAPHICS', 'active', '2020-10-13 11:17:01', NULL),
(74, 'TOURS', 'active', '2020-10-13 11:17:12', NULL),
(75, 'PLUMBERING', 'active', '2020-10-19 08:05:34', NULL),
(76, 'CLEANING SERVICES', 'active', '2020-10-27 07:51:17', NULL),
(77, 'FISHING INDUSTRY', 'active', '2020-10-27 08:35:59', NULL),
(78, 'MECHANIC', 'active', '2020-10-30 09:37:25', NULL),
(79, 'IMPORT AND EXPORT', 'active', '2020-11-04 09:17:15', NULL),
(80, 'ENGINEERING', 'active', '2020-11-04 11:17:00', NULL),
(81, 'LAUNDRY AND DRY CLEANING', 'active', '2020-11-25 13:34:53', NULL),
(82, 'CEREALS', 'active', '2020-11-30 12:34:19', NULL),
(83, 'LODGE', 'active', '2020-12-14 07:57:57', NULL),
(84, 'Default Industry', 'active', '2020-12-14 07:57:57', NULL);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `industries`
--
ALTER TABLE `industries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
