1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / eltoro_wholesale / db /
Filename : projects_hoarding.sql
back
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 15, 2024 at 09:54 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29

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: `projects_hoarding`
--

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

--
-- Table structure for table `tbl_company`
--

CREATE TABLE `tbl_company` (
  `id` int(11) NOT NULL,
  `company_name` longtext DEFAULT NULL,
  `company_slug` varchar(150) DEFAULT NULL,
  `company_domain` varchar(250) DEFAULT NULL,
  `company_contact_name` longtext DEFAULT NULL,
  `company_email_address` longtext DEFAULT NULL,
  `company_mobile_no` longtext DEFAULT NULL,
  `company_address` longtext DEFAULT NULL,
  `company_city` longtext DEFAULT NULL,
  `company_state` longtext DEFAULT NULL,
  `company_pin_code` longtext DEFAULT NULL,
  `company_landline_number` longtext DEFAULT NULL,
  `company_logo` longtext DEFAULT NULL,
  `company_currency_name` longtext DEFAULT NULL,
  `company_currency_symbol` longtext DEFAULT NULL,
  `company_status` enum('1','0') NOT NULL COMMENT '1 - Active, 0 - Inactive',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted` int(11) NOT NULL COMMENT '0 - No, 1 - Yes',
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_company`
--

INSERT INTO `tbl_company` (`id`, `company_name`, `company_slug`, `company_domain`, `company_contact_name`, `company_email_address`, `company_mobile_no`, `company_address`, `company_city`, `company_state`, `company_pin_code`, `company_landline_number`, `company_logo`, `company_currency_name`, `company_currency_symbol`, `company_status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`, `deleted_by`, `deleted_at`) VALUES
(1, '8296a1052d2ee525bfdc3f24c0cf0c1bfd120ca143979371d0f8b4d01cf8438e0d0aba08368e388d38f915a3a9777799ab18f46d5d0ed2cd054c803b3ad7039dPWMKRL7QJVOlMG8gdn3jxwbLtFJP0yJziMOEmW8=', 'alpha_company', 'http://localhost/addo/new_banks/alpha_company', 'Mani', 'alpha@gmail.com', '1234567899', 'Main Road', 'Salem', 'TN', '636009', NULL, '15702047531731478577.jpg', NULL, NULL, '1', 1, '2024-10-26 08:34:12', 2, '2024-11-13 07:16:17', 0, NULL, NULL),
(2, '03825f9993d5de7748ca1dc90b76ce5a633a14ae16c1c4ad535d5ff70c8184a022ae3f2776a64e3bd74098bb0f03f7d7f6c427d419434631478ae70e0b229e7dwoflLLqBgL9wdpU2LqCuwap07pXLev8thoC/vA==', 'beta_company', 'http://localhost/addo/new_banks/beta_company', 'Beta', 'beta@gmail.com', '9898898989', 'Main Road', 'Salem', 'TN', '633233', NULL, '17667896981731480041.jpg', NULL, NULL, '1', 1, '2024-10-26 09:57:14', 2, '2024-11-13 07:40:41', 0, NULL, NULL);

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

--
-- Table structure for table `tbl_encryption_data_fields`
--

CREATE TABLE `tbl_encryption_data_fields` (
  `id` int(11) NOT NULL,
  `tbl_name` varchar(255) NOT NULL,
  `field_name` varchar(255) NOT NULL,
  `active` int(11) NOT NULL COMMENT '0 - No, 1 - Yes',
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_encryption_data_fields`
--

INSERT INTO `tbl_encryption_data_fields` (`id`, `tbl_name`, `field_name`, `active`, `created_by`, `created_at`) VALUES
(1, 'tbl_company', 'company_name', 0, 1, '2024-10-05 12:02:50');

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

--
-- Table structure for table `tbl_hoarding`
--

CREATE TABLE `tbl_hoarding` (
  `id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `hoarding_name` longtext DEFAULT NULL,
  `hoarding_description` longtext DEFAULT NULL,
  `hoarding_location` longtext DEFAULT NULL,
  `hoarding_coordinates` longtext DEFAULT NULL,
  `hoarding_dimensions` longtext DEFAULT NULL,
  `hoarding_orientation` longtext DEFAULT NULL,
  `hoarding_type_id` int(11) DEFAULT NULL,
  `hoarding_material_id` int(11) DEFAULT NULL,
  `hoarding_status` enum('1','0') NOT NULL COMMENT '1 - Active, 0 - Inactive',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted` int(11) NOT NULL COMMENT '0 - No, 1 - Yes',
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_hoarding`
--

INSERT INTO `tbl_hoarding` (`id`, `company_id`, `hoarding_name`, `hoarding_description`, `hoarding_location`, `hoarding_coordinates`, `hoarding_dimensions`, `hoarding_orientation`, `hoarding_type_id`, `hoarding_material_id`, `hoarding_status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`, `deleted_by`, `deleted_at`) VALUES
(1, 1, 'testing', 'Main Street – Near City Mall', 'vadapalani,chennai', '36.00 x 47.00', '100 x 100', 'east-facing', 1, 1, '1', 2, '2024-11-14 08:43:05', NULL, NULL, 0, NULL, NULL);

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

--
-- Table structure for table `tbl_hoarding_category_master`
--

CREATE TABLE `tbl_hoarding_category_master` (
  `id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `hoarding_type` longtext DEFAULT NULL,
  `hoarding_material` longtext DEFAULT NULL,
  `status` enum('1','0') NOT NULL COMMENT '1 - Active, 0 - Inactive',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted` int(11) NOT NULL COMMENT '0 - No, 1 - Yes',
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_hoarding_category_master`
--

INSERT INTO `tbl_hoarding_category_master` (`id`, `company_id`, `hoarding_type`, `hoarding_material`, `status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`, `deleted_by`, `deleted_at`) VALUES
(1, 1, 'billboard', 'metal', '1', 2, '2024-11-14 07:49:00', NULL, NULL, 0, NULL, NULL);

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `user_id` int(11) NOT NULL,
  `user_company_id` int(11) DEFAULT NULL,
  `user_name` varchar(250) DEFAULT NULL,
  `user_email_address` varchar(250) DEFAULT NULL,
  `user_mobile_no` varchar(250) DEFAULT NULL,
  `user_password` text DEFAULT NULL,
  `user_status` int(11) DEFAULT NULL COMMENT '1 - Active, 0 - Inprocess',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted` int(11) NOT NULL COMMENT '0 - No, 1 - Yes',
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`user_id`, `user_company_id`, `user_name`, `user_email_address`, `user_mobile_no`, `user_password`, `user_status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted`, `deleted_by`, `deleted_at`) VALUES
(1, 0, 'Master Admin', 'admin@gmail.com', '1234567891', '21232f297a57a5a743894a0e4a801fc3', 1, NULL, NULL, 1, '2024-11-11 08:27:19', 0, NULL, NULL),
(2, 1, 'testing', 'testing@gmail.com', NULL, 'ae2b1fca515949e5d54fb22b8ed95575', 1, 1, '2024-11-11 08:32:18', 1, '2024-11-13 07:27:22', 0, 1, '2024-11-11 08:52:26'),
(3, 2, 'parkar', 'parkar@gmail.com', NULL, '36c0cfe05a0080fa3826b6d280d5a65f', 1, 1, '2024-11-13 07:26:50', NULL, NULL, 0, NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;