-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 16, 2025 at 06:00 PM
-- Server version: 9.1.0
-- PHP Version: 8.3.14

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

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

--
-- Table structure for table `accountdetail`
--

DROP TABLE IF EXISTS `accountdetail`;
CREATE TABLE IF NOT EXISTS `accountdetail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bid` int NOT NULL,
  `ac_number` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `ifsc` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `date_time` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `time_stamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bank`
--

DROP TABLE IF EXISTS `bank`;
CREATE TABLE IF NOT EXISTS `bank` (
  `id` int NOT NULL AUTO_INCREMENT,
  `b_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bank`
--

INSERT INTO `bank` (`id`, `b_name`, `timestamp`) VALUES
(8, 'Bank of Maharashtra', '2025-06-10 16:03:46'),
(7, 'State Bank of India', '2025-06-10 16:02:22');

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

--
-- Table structure for table `bank_accounts`
--

DROP TABLE IF EXISTS `bank_accounts`;
CREATE TABLE IF NOT EXISTS `bank_accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kyc_id` int DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_number` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ifsc_code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_holder` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `transaction_id` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hold_amount` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kyc_id` (`kyc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bank_accounts`
--

INSERT INTO `bank_accounts` (`id`, `kyc_id`, `bank_id`, `bank_name`, `account_number`, `ifsc_code`, `account_holder`, `transaction_id`, `hold_amount`) VALUES
(32, 29, 8, 'Bank of Maharashtra', '332944', 'BRBK0X123', '', '123', '50'),
(31, 29, 7, 'State Bank of India', '33292929589', 'SBIN0000532', '', '123', '5000'),
(30, 28, 7, 'State Bank of India', '18760110100530', 'NSPB000054', '', '103055140204', '1213'),
(29, 27, 8, 'Bank of Maharashtra', '55', '55', '555', '55', '12');

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

--
-- Table structure for table `cctv`
--

DROP TABLE IF EXISTS `cctv`;
CREATE TABLE IF NOT EXISTS `cctv` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `pid` int NOT NULL,
  `police_id` int NOT NULL,
  `notice_id` int NOT NULL,
  `subject_id` int NOT NULL,
  `acknowledgement_no` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `complainant_name` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `cctv_details` varchar(5000) COLLATE utf8mb4_general_ci NOT NULL,
  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cctv`
--

INSERT INTO `cctv` (`id`, `uid`, `pid`, `police_id`, `notice_id`, `subject_id`, `acknowledgement_no`, `complainant_name`, `cctv_details`, `time_stamp`) VALUES
(7, 12, 20, 6, 5, 12, '31102250038313', 'KRUNAL GAMIT', '[{\"bank_id\":\"7\",\"bank_name\":\"State Bank of India\",\"atm_id\":\"526l\",\"start_date_time\":\"16/06/2025, 03:14 pm\",\"end_date_time\":\"16/06/2025, 08:18 pm\"}]', '2025-06-16 04:14:27'),
(6, 11, 15, 5, 7, 12, '9287489346298', 'CCTV MARU NAME', '[{\"bank_id\":\"8\",\"bank_name\":\"Bank of Maharashtra\",\"atm_id\":\"1234232323339\",\"start_date_time\":\"10/06/2025, 01:34 pm\",\"end_date_time\":\"06/06/2025, 01:34 pm\"},{\"bank_id\":\"8\",\"bank_name\":\"Bank of Maharashtra\",\"atm_id\":\"1343254\",\"start_date_time\":\"12/06/2025, 01:35 pm\",\"end_date_time\":\"30/06/2025, 01:35 pm\"}]', '2025-06-16 02:35:33');

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

--
-- Table structure for table `cdr`
--

DROP TABLE IF EXISTS `cdr`;
CREATE TABLE IF NOT EXISTS `cdr` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `pid` int NOT NULL,
  `police_id` int NOT NULL,
  `atf` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'acknowlegement,ticket,fir no',
  `ack_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `notice_id` int NOT NULL,
  `subject_id` int NOT NULL,
  `cdr_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cdr`
--

INSERT INTO `cdr` (`id`, `uid`, `pid`, `police_id`, `atf`, `ack_no`, `notice_id`, `subject_id`, `cdr_id`, `created_at`) VALUES
(20, 12, 20, 6, '0', '3110', 8, 13, '[{\"number\":\"+917043311587\",\"from_date\":\"01-06-2025\",\"to_date\":\"16-06-2025\"},{\"number\":\"+918320255573\",\"from_date\":\"01-06-2025\",\"to_date\":\"16-06-2025\"}]', '2025-06-16 09:49:53');

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

--
-- Table structure for table `comply_order`
--

DROP TABLE IF EXISTS `comply_order`;
CREATE TABLE IF NOT EXISTS `comply_order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `pid` int NOT NULL,
  `police_id` int NOT NULL,
  `court_order` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `acknowlegement_no` int NOT NULL,
  `subject_id` int NOT NULL,
  `v_name` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `v_bank` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `v_ac_no` int NOT NULL,
  `v_ifsc` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `bank_data` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'IT USING IN ARAY BUT UPDATE THAN COMMENT AND NULL IT ',
  `time_stamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `c_bank_data`
--

DROP TABLE IF EXISTS `c_bank_data`;
CREATE TABLE IF NOT EXISTS `c_bank_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `comply_order_id` int NOT NULL,
  `bank_id` int NOT NULL,
  `account_number` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `ifsc_code` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `account_holder` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `release_amount` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `domain_data`
--

DROP TABLE IF EXISTS `domain_data`;
CREATE TABLE IF NOT EXISTS `domain_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `pid` int NOT NULL,
  `police_id` int NOT NULL,
  `atf` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'acknowlegement,ticket,fir no',
  `ack_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `fraud_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `notice_id` int NOT NULL,
  `subject_id` int NOT NULL,
  `domain_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `domain_data`
--

INSERT INTO `domain_data` (`id`, `uid`, `pid`, `police_id`, `atf`, `ack_no`, `fraud_type`, `notice_id`, `subject_id`, `domain_id`, `created_at`) VALUES
(1, 12, 20, 6, '0', '112', 'cyber_fraud', 5, 11, '[\"google.com\"]', '2025-06-16 07:14:17'),
(2, 11, 15, 5, '0', '123456789864', '', 5, 10, '[\"godaddy\"]', '2025-06-16 07:33:36'),
(3, 11, 15, 5, '0', '54546253536275', '', 5, 10, '[\"www.google.com\"]', '2025-06-16 07:45:45');

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

--
-- Table structure for table `kyc`
--

DROP TABLE IF EXISTS `kyc`;
CREATE TABLE IF NOT EXISTS `kyc` (
  `id` int NOT NULL AUTO_INCREMENT,
  `acknowledgement_no` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `complainant_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `policestation_id` int DEFAULT NULL,
  `police_id` int DEFAULT NULL,
  `subject_id` int DEFAULT NULL,
  `notice_id` int DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `kyc`
--

INSERT INTO `kyc` (`id`, `acknowledgement_no`, `complainant_name`, `policestation_id`, `police_id`, `subject_id`, `notice_id`, `type`, `created_by`, `created_at`) VALUES
(29, '123', 'krunal', 20, 6, 8, 7, 'LIEN AMOUNT', 12, '2025-06-11 08:23:06'),
(28, '97896387527', 'VISHAL prajapat', 15, 5, 8, 7, 'LIEN AMOUNT', 11, '2025-06-11 08:18:08'),
(27, '123', 'krunal', 20, 6, 8, 7, 'LIEN AMOUNT', 12, '2025-06-10 17:48:57');

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

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
CREATE TABLE IF NOT EXISTS `logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `pid` int NOT NULL,
  `ip_address` varchar(220) COLLATE utf8mb4_general_ci NOT NULL,
  `in_out` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'in',
  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `uid`, `pid`, `ip_address`, `in_out`, `time_stamp`) VALUES
(1, 12, 20, '::1', 'in', '2025-06-10 19:25:22'),
(2, 12, 20, '::1', 'out', '2025-06-10 14:00:25'),
(3, 11, 15, '::1', 'in', '2025-06-11 07:51:44'),
(4, 11, 15, '::1', 'out', '2025-06-11 02:23:58'),
(5, 11, 15, '::1', 'in', '2025-06-11 07:54:14'),
(6, 11, 15, '::1', 'out', '2025-06-11 02:28:04'),
(7, 13, 16, '::1', 'in', '2025-06-11 07:58:18'),
(8, 19, 23, '10.11.28.173', 'in', '2025-06-11 07:58:31'),
(9, 13, 16, '::1', 'out', '2025-06-11 02:30:38'),
(10, 12, 20, '::1', 'in', '2025-06-11 08:00:42'),
(11, 12, 20, '::1', 'out', '2025-06-11 02:32:15'),
(12, 12, 20, '::1', 'in', '2025-06-11 08:02:20'),
(13, 12, 20, '::1', 'out', '2025-06-11 02:33:27'),
(14, 12, 20, '::1', 'in', '2025-06-11 08:03:37'),
(15, 19, 23, '10.11.28.173', 'out', '2025-06-11 02:34:56'),
(16, 11, 15, '10.11.28.173', 'in', '2025-06-11 08:05:20'),
(17, 11, 15, '10.11.28.173', 'in', '2025-06-11 08:11:45'),
(18, 11, 15, '10.11.28.173', 'out', '2025-06-11 02:50:30'),
(19, 11, 15, '10.11.28.173', 'in', '2025-06-11 08:20:51'),
(20, 12, 20, '::1', 'out', '2025-06-11 05:39:46'),
(21, 19, 23, '::1', 'in', '2025-06-11 11:09:59'),
(22, 19, 23, '::1', 'out', '2025-06-11 05:47:47'),
(23, 12, 20, '::1', 'in', '2025-06-15 11:15:35'),
(24, 12, 20, '::1', 'in', '2025-06-15 12:50:13'),
(25, 12, 20, '::1', 'in', '2025-06-16 04:41:17'),
(26, 11, 15, '10.11.12.18', 'in', '2025-06-16 06:27:51'),
(27, 11, 15, '10.11.12.18', 'out', '2025-06-16 02:27:53'),
(28, 19, 23, '10.11.12.18', 'in', '2025-06-16 07:58:39'),
(29, 19, 23, '10.11.12.18', 'out', '2025-06-16 02:29:08'),
(30, 11, 15, '10.11.12.18', 'in', '2025-06-16 07:59:16'),
(31, 11, 15, '10.11.12.18', 'in', '2025-06-16 07:59:34'),
(32, 12, 20, '::1', 'in', '2025-06-16 12:57:20');

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

--
-- Table structure for table `notice`
--

DROP TABLE IF EXISTS `notice`;
CREATE TABLE IF NOT EXISTS `notice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `n_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `time_stamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notice`
--

INSERT INTO `notice` (`id`, `n_name`, `time_stamp`) VALUES
(5, 'NOTICE UNDER SECTION 94 OF B.N.S.S 2023 ', '2025-05-25 16:34:36'),
(7, 'NOTICE UNDER SECTION 94 OF B.N.S.S 2023 - UNDER SECTION 63 OF BSA ACT 2023', '2025-06-10 21:30:41'),
(8, 'Request under section 95 of BNSS 2003', '2025-06-16 13:20:53');

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

--
-- Table structure for table `police`
--

DROP TABLE IF EXISTS `police`;
CREATE TABLE IF NOT EXISTS `police` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pid` int NOT NULL,
  `i_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `i_number` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `i_designation` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `i_sign` longtext COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `police`
--

INSERT INTO `police` (`id`, `pid`, `i_name`, `i_number`, `i_designation`, `i_sign`) VALUES
(6, 20, 'N.S.CHAUHAN', '9925100309', 'Police Inspector', ''),
(5, 15, 'A.R.JADAV', '9925100309', 'Police Inspector', '');

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

--
-- Table structure for table `policestation`
--

DROP TABLE IF EXISTS `policestation`;
CREATE TABLE IF NOT EXISTS `policestation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `spid` int NOT NULL,
  `p_name` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `p_address` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `p_landline` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `p_number` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `p_email` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `policestation`
--

INSERT INTO `policestation` (`id`, `spid`, `p_name`, `p_address`, `p_landline`, `p_number`, `p_email`, `timestamp`) VALUES
(15, 5, 'NIZAR POLICE STATION', 'DIST-NIZAR-VYARA', '02624-244233', '+91 6359629504', 'Polstn-nizar-tapi@gujarat.govt.in', '2025-06-10 16:10:10'),
(16, 5, 'KAKARAPAR POLICE STATION', 'DIST-TAPI-VYARA', '02624-234222', '+91 6359626158', 'polstn-kak-tapi@gujarat.govt.in', '2025-06-10 16:11:35'),
(17, 5, 'DOLVAN POLICE STATION', 'DIST-TAPI-VYARA', '02626251252', '+91 6359636162', 'polstn-dolvan-tapi@gujarat.govt.in', '2025-06-10 16:12:44'),
(18, 5, 'VALOD POLICE STATION', 'DIST-TAPI-VYARA', '02625-220048', '+91 6359626166', 'polstn-valod-tapi@gujarat.gov.in', '2025-06-10 16:13:34'),
(19, 5, 'VYARA POLICE STATION', 'DIST-TAPI-VYARA', '02626220033', '+91 6359626149', 'polstn-vyara-tapi@gujarat.govt.in', '2025-06-10 16:14:33'),
(20, 5, 'SONGADH POLICE STATION', 'DIST-TAPI-SONGADH', '02624-222033', '+91 6359626151', 'polstn-son-tapi@gujarat.govt.in', '2025-06-10 16:17:03'),
(21, 5, 'UKAI POLICE STATION', 'DIST-UKAI-VYARA', '2624233236', '+91 6359626156', 'polstn-ukai-sur@gujarat.govt.in', '2025-06-10 16:18:30'),
(22, 5, 'UCHCHHAL POLICE STATION', 'DIST-TAPI-UCHCHHAL', '02628-231112', '+91 63596 26154', 'polstn-uch-tapi@gujarat.govt.in', '2025-06-10 16:33:33'),
(23, 5, 'CYBER CRIME POLICE STATION', 'DIST-VYARA-TAPI', '1930', '+91 6359629509', 'polstn-cyber-tapi@gujarat.gov.in', '2025-06-10 16:43:27'),
(24, 5, 'MAHILA POLICE STATION', 'DIST-TAPI-VYARA', '02626-225033', '6359629516', 'polstn-mahila-tapi@gujarat.govt.in', '2025-06-11 13:31:09');

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

--
-- Table structure for table `social_media`
--

DROP TABLE IF EXISTS `social_media`;
CREATE TABLE IF NOT EXISTS `social_media` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `pid` int NOT NULL,
  `police_id` int NOT NULL,
  `atf` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'acknowlegement,ticket,fir no',
  `ack_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `fraud_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `notice_id` int NOT NULL,
  `subject_id` int NOT NULL,
  `social_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'facebook,instagram,whatsapp',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `social_media`
--

INSERT INTO `social_media` (`id`, `uid`, `pid`, `police_id`, `atf`, `ack_no`, `fraud_type`, `notice_id`, `subject_id`, `social_id`, `created_at`, `type`) VALUES
(19, 12, 20, 6, '0', '3110', '', 5, 10, '[\"krunal9797\"]', '2025-06-16 05:16:18', 'facebook'),
(20, 12, 20, 6, '0', '112', '', 5, 10, '[\"krunal9797\"]', '2025-06-16 06:10:32', 'instagram'),
(21, 12, 20, 6, '0', '112', '', 5, 10, '[\"+917043311587\"]', '2025-06-16 06:10:51', 'whatsapp'),
(22, 12, 20, 6, '0', '445', '', 5, 10, '[\"krunal9797\"]', '2025-06-16 06:11:13', 'twitter'),
(23, 12, 20, 6, '0', '102', '', 5, 10, '[\"krunal_97\"]', '2025-06-16 06:12:19', 'snapchat'),
(24, 12, 20, 6, '0', '122', '', 5, 10, '[\"gamitkrunal7997@gmail.com\"]', '2025-06-16 06:14:24', 'lers'),
(25, 12, 20, 6, '0', '112', '', 5, 10, '[\"gamitkrunal7997@gmail.com\"]', '2025-06-16 06:16:26', 'google');

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

--
-- Table structure for table `spoffice`
--

DROP TABLE IF EXISTS `spoffice`;
CREATE TABLE IF NOT EXISTS `spoffice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sp_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `sp_address` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `sp_tel` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `sp_number` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `sp_email` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `time_stamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `spoffice`
--

INSERT INTO `spoffice` (`id`, `sp_name`, `sp_address`, `sp_tel`, `sp_number`, `sp_email`, `is_delete`, `time_stamp`) VALUES
(5, 'Shri Rahul Patel', 'SP Office Vyara', '02626-222700', '9978405488', 'sp-tapi@gujarat.gov.in', 0, '2025-06-10 16:06:54');

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

--
-- Table structure for table `subject`
--

DROP TABLE IF EXISTS `subject`;
CREATE TABLE IF NOT EXISTS `subject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `s_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `time_stamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subject`
--

INSERT INTO `subject` (`id`, `s_name`, `time_stamp`) VALUES
(10, 'Request for Suspect Account Information', '2025-06-15 16:51:15'),
(8, 'Provide Information related to Accounts to prepare a court order. ', '2025-06-10 21:31:55'),
(11, 'Request for Domain Ownership and Hosting Details', '2025-06-16 12:47:51'),
(12, 'Request for CCTV Footage of ATM ID :', '2025-06-16 13:24:25'),
(13, 'Request for CDR, CAF, and SDR Details for the Following Numbers', '2025-06-16 13:42:32');

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pid` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `au` tinyint(1) NOT NULL COMMENT 'admin/users',
  `time_stamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `pid`, `name`, `email`, `password`, `au`, `time_stamp`) VALUES
(14, 17, 'Er. Bakul Gamit', 'u.bakulkumar@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:28:03'),
(13, 16, 'Er. Mehul Chaudhari ', 'mehulchaudhari578@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:24:20'),
(12, 20, 'Er. Krunal Gamit', 'gamitkrunal7997@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:22:44'),
(11, 15, 'Er. Vishal Prajapat', 'vishalbprajapat@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:21:46'),
(15, 19, 'Mr.  Ashish Dhodia', 'ap9798050@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:29:43'),
(16, 21, 'Mr. Sharukh Multani', 'sharukh.multani16@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:32:02'),
(17, 22, 'Er. Vinaykumar Vasava ', 'vasavavinay844@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:34:43'),
(18, 23, 'Cyber Crime', 'gamitkrunal7997@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 16:44:53'),
(19, 23, 'Admin ', 'admin@admin.com', '81dc9bdb52d04dc20036dbd8313ed055', 1, '2025-06-10 16:47:24'),
(20, 18, 'Nachiket Patel', 'nachiket9727@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-10 17:16:53'),
(21, 24, 'Alpa Rana', 'rana.alpa23@gmail.com', '81dc9bdb52d04dc20036dbd8313ed055', 0, '2025-06-11 13:31:52');
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 */;
