-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jan 18, 2025 at 10:32 AM
-- Server version: 10.11.10-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: `church`
--

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

--
-- Table structure for table `about_seo`
--

CREATE TABLE `about_seo` (
  `id` int(11) NOT NULL,
  `metatitle` varchar(200) NOT NULL,
  `metadescription` varchar(200) NOT NULL,
  `keywords` varchar(200) NOT NULL,
  `metatitlef` varchar(250) NOT NULL,
  `metadescriptionf` varchar(250) NOT NULL,
  `linkf` varchar(200) NOT NULL,
  `metatitlet` varchar(200) NOT NULL,
  `metadescriptiont` varchar(250) NOT NULL,
  `delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `about_seo`
--

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

--
-- Table structure for table `activity`
--

CREATE TABLE `activity` (
  `id` int(11) NOT NULL,
  `user_id` int(50) NOT NULL,
  `note` varchar(100) NOT NULL,
  `add_date` datetime NOT NULL DEFAULT current_timestamp(),
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activity`
--

INSERT INTO `activity` (`id`, `user_id`, `note`, `add_date`, `delete_status`) VALUES
(1, 1, 'login sucessfully', '2024-05-13 07:41:55', 0),
(2, 1, 'login sucessfully', '2024-05-13 07:42:53', 0),
(3, 1, 'login sucessfully', '2024-05-13 07:44:13', 0),
(4, 1, 'login sucessfully', '2024-05-14 07:26:39', 0),
(5, 1, 'login sucessfully', '2024-05-14 09:45:27', 0),
(6, 1, 'login sucessfully', '2024-05-14 11:25:24', 0),
(7, 1, 'login sucessfully', '2024-05-16 07:19:18', 0),
(8, 1, 'login sucessfully', '2024-05-17 07:23:00', 0),
(9, 1, 'login sucessfully', '2024-05-18 07:19:10', 0),
(10, 1, 'login sucessfully', '2024-05-18 09:53:33', 0),
(11, 1, 'login sucessfully', '2024-05-21 08:16:21', 0),
(12, 1, 'login sucessfully', '2024-05-22 07:23:58', 0),
(13, 1, 'login sucessfully', '2024-05-22 12:53:35', 0),
(14, 1, 'login sucessfully', '2024-05-23 07:29:20', 0),
(15, 1, 'login sucessfully', '2024-05-23 08:21:55', 0),
(16, 1, 'login sucessfully', '2024-05-23 08:23:27', 0),
(17, 1, 'login sucessfully', '2024-05-24 07:35:01', 0),
(18, 1, 'login sucessfully', '2024-05-24 12:13:04', 0),
(19, 1, 'login sucessfully', '2024-05-24 12:13:18', 0),
(20, 1, 'login sucessfully', '2024-05-24 12:58:32', 0),
(21, 1, 'login sucessfully', '2024-05-24 13:00:02', 0),
(22, 1, 'login sucessfully', '2024-05-24 13:01:05', 0),
(23, 1, 'login sucessfully', '2024-05-24 13:20:00', 0),
(24, 1, 'login sucessfully', '2024-05-24 13:38:44', 0),
(25, 1, 'login sucessfully', '2024-05-24 14:09:40', 0),
(26, 1, 'login sucessfully', '2024-05-24 14:25:26', 0),
(27, 1, 'login sucessfully', '2024-05-24 14:29:31', 0),
(28, 1, 'login sucessfully', '2024-05-27 07:02:59', 0),
(29, 1, 'login sucessfully', '2024-05-27 07:22:18', 0),
(30, 1, 'login sucessfully', '2024-05-27 08:00:47', 0),
(31, 1, 'login sucessfully', '2024-05-27 08:17:35', 0),
(32, 1, 'login sucessfully', '2024-05-27 08:32:52', 0),
(33, 1, 'login sucessfully', '2024-05-27 08:41:03', 0),
(34, 1, 'login sucessfully', '2024-05-27 08:54:10', 0),
(35, 1, 'login sucessfully', '2024-05-27 09:05:58', 0),
(36, 1, 'login sucessfully', '2024-05-27 09:10:30', 0),
(37, 1, 'login sucessfully', '2024-05-27 09:34:51', 0),
(38, 1, 'login sucessfully', '2024-05-27 09:40:29', 0),
(39, 1, 'login sucessfully', '2024-05-27 09:44:47', 0),
(40, 1, 'login sucessfully', '2024-05-27 10:04:51', 0),
(41, 1, 'login sucessfully', '2024-05-27 10:17:54', 0),
(42, 1, 'login sucessfully', '2024-05-27 11:14:29', 0),
(43, 1, 'login sucessfully', '2024-05-27 12:26:42', 0),
(44, 1, 'login sucessfully', '2024-05-27 12:30:10', 0),
(45, 1, 'login sucessfully', '2024-05-27 12:47:00', 0),
(46, 1, 'login sucessfully', '2024-05-27 13:00:20', 0),
(47, 1, 'login sucessfully', '2024-05-27 14:26:13', 0),
(48, 1, 'login sucessfully', '2024-05-28 07:15:21', 0),
(49, 1, 'login sucessfully', '2024-05-28 09:36:03', 0),
(50, 1, 'login sucessfully', '2024-05-28 10:18:52', 0),
(51, 1, 'login successfully', '2024-05-28 10:28:07', 0),
(52, 1, 'login sucessfully', '2024-05-28 11:30:19', 0),
(53, 1, 'login sucessfully', '2024-05-28 11:36:48', 0),
(54, 14, 'login successfully', '2024-05-28 13:43:43', 0),
(55, 11, 'login successfully', '2024-05-28 14:10:33', 0),
(56, 11, 'login successfully', '2024-05-29 07:51:45', 0),
(57, 11, 'login successfully', '2024-05-29 08:38:44', 0),
(58, 11, 'login successfully', '2024-05-30 10:43:48', 0),
(59, 14, 'login successfully', '2024-05-30 13:39:19', 0),
(60, 15, 'login successfully', '2024-05-30 13:42:05', 0),
(61, 11, 'login successfully', '2024-05-30 13:57:10', 0),
(62, 11, 'login successfully', '2024-05-31 07:51:33', 0),
(63, 16, 'login successfully', '2024-05-31 08:46:39', 0),
(64, 11, 'login successfully', '2024-05-31 08:46:59', 0),
(65, 11, 'login successfully', '2024-06-06 07:39:10', 0),
(66, 11, 'login successfully', '2024-06-06 07:55:28', 0),
(67, 11, 'login successfully', '2024-06-06 10:17:06', 0),
(68, 11, 'login successfully', '2024-06-06 10:19:28', 0),
(69, 11, 'login successfully', '2024-06-06 10:22:18', 0),
(70, 11, 'login successfully', '2024-06-06 10:22:42', 0),
(71, 11, 'login successfully', '2024-06-06 11:33:39', 0),
(72, 14, 'login successfully', '2024-06-06 13:36:13', 0),
(73, 11, 'login successfully', '2024-06-06 13:40:13', 0),
(74, 11, 'login successfully', '2024-06-07 08:38:31', 0),
(75, 11, 'login successfully', '2024-06-07 08:47:17', 0),
(76, 11, 'login successfully', '2024-06-08 07:52:43', 0),
(77, 11, 'login successfully', '2024-06-10 07:40:11', 0),
(78, 11, 'login successfully', '2024-06-10 09:22:38', 0),
(79, 11, 'login successfully', '2024-06-11 07:49:32', 0),
(80, 11, 'login successfully', '2024-06-13 07:53:43', 0),
(81, 11, 'login successfully', '2024-06-13 08:30:00', 0),
(82, 11, 'login successfully', '2024-06-13 10:56:57', 0),
(83, 11, 'login successfully', '2024-06-13 11:09:34', 0),
(84, 11, 'login successfully', '2024-06-13 11:24:54', 0),
(85, 11, 'login successfully', '2024-06-17 06:28:06', 0),
(86, 11, 'login successfully', '2024-08-15 06:21:27', 0),
(87, 11, 'login successfully', '2024-09-14 09:07:01', 0),
(88, 11, 'login successfully', '2024-09-14 09:09:27', 0),
(89, 11, 'login successfully', '2024-09-14 09:09:52', 0),
(90, 11, 'login successfully', '2024-09-15 14:13:05', 0),
(91, 11, 'login successfully', '2024-09-15 15:06:37', 0),
(92, 11, 'login successfully', '2024-09-29 07:54:55', 0),
(93, 11, 'login successfully', '2024-09-29 08:44:50', 0),
(94, 11, 'login successfully', '2024-09-29 08:48:09', 0),
(95, 11, 'login successfully', '2024-12-22 09:44:59', 0),
(96, 11, 'login successfully', '2024-12-29 04:46:11', 0),
(97, 11, 'login successfully', '2024-12-29 06:52:02', 0),
(98, 11, 'login successfully', '2024-12-29 18:54:06', 0),
(99, 11, 'login successfully', '2025-01-18 06:42:04', 0),
(100, 11, 'login successfully', '2025-01-18 07:19:55', 0),
(101, 11, 'login successfully', '2025-01-18 07:30:00', 0),
(102, 11, 'login successfully', '2025-01-18 07:37:23', 0),
(103, 11, 'login successfully', '2025-01-18 08:00:52', 0),
(104, 11, 'login successfully', '2025-01-18 08:10:19', 0),
(105, 11, 'login successfully', '2025-01-18 09:37:56', 0);

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

--
-- Table structure for table `application`
--

CREATE TABLE `application` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `message` varchar(200) NOT NULL,
  `file` varchar(200) NOT NULL,
  `exp` varchar(200) NOT NULL,
  `post` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `application`
--

INSERT INTO `application` (`id`, `name`, `phone`, `email`, `message`, `file`, `exp`, `post`) VALUES
(1, 'test', '3454354544', 'test@gmail.com', 'wrfsefs', '700.pdf', '1', 'UX Designer');

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

--
-- Table structure for table `asset`
--

CREATE TABLE `asset` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `assettype` varchar(100) NOT NULL,
  `valuation_date` date NOT NULL,
  `value_amount` text NOT NULL,
  `purchase_date` date NOT NULL,
  `purchase_price` text NOT NULL,
  `replace_value` text NOT NULL,
  `photo1` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `asset`
--

INSERT INTO `asset` (`id`, `branch`, `assettype`, `valuation_date`, `value_amount`, `purchase_date`, `purchase_price`, `replace_value`, `photo1`, `delete_status`) VALUES
(1, 'Norton ', 'Chairs ', '2024-05-01', '1000', '2024-05-01', '', '', '662618355f862.docx', 0),
(2, 'Norton ', 'computers ', '2024-05-01', '1000', '2024-05-11', '4000', '2000', 'CFS Website content-1 (2).docx', 0),
(3, 'Norton ', 'computers ', '2024-05-22', '1500', '2024-05-11', '4000', '2000', 'CFS Website content-1 (2).docx', 0),
(4, 'Norton ', 'Chairs ', '2024-05-04', '1000', '2024-05-17', '1000', '1000', 'CFS Website content-1 (1).docx', 0),
(5, 'Norton ', 'computers ', '2024-06-01', '10', '2024-05-17', '', '', 'CFS Website content-1 (1).docx', 0);

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

--
-- Table structure for table `assettype`
--

CREATE TABLE `assettype` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `category` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assettype`
--

INSERT INTO `assettype` (`id`, `name`, `category`, `delete_status`) VALUES
(1, 'Chairs', '2', 0),
(2, 'computers', '3', 0);

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

--
-- Table structure for table `batch`
--

CREATE TABLE `batch` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `member` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `note` varchar(100) NOT NULL,
  `status` tinyint(100) NOT NULL,
  `amount` text NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `batch`
--

INSERT INTO `batch` (`id`, `name`, `member`, `date`, `note`, `status`, `amount`, `delete_status`) VALUES
(1, '1st Services', '', '2024-05-01', 'dvfff', 0, '100', 0),
(2, '2nd Service', 'THAIKAWI TONGLUAN ', '2024-05-02', 'csdvs', 0, '100', 1),
(3, '1st Services', 'THAIKAWI TONGLUAN ', '2024-05-01', 'vff', 0, '100', 1),
(4, '2nd Service', 'member ', '2024-05-01', 'j,jl', 0, '100', 1);

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `b_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `notes` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`b_id`, `user_id`, `branch_name`, `notes`, `created_at`, `delete_status`) VALUES
(1, 1, 'Norton', 'norton', '2024-05-22 05:25:09', 0),
(2, 11, 'Agrashitionn', 'Agrashition', '2024-05-31 05:53:32', 1),
(3, 11, 'nn', 'bvb', '2024-06-06 08:24:10', 1),
(4, 11, 'Agrashition', 'Chitungwiza', '2024-06-06 10:25:13', 0),
(5, 11, 'Ambocrotia', 'Ambocrotia', '2024-06-07 07:10:10', 0);

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

--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `id` int(11) NOT NULL,
  `content` varchar(200) NOT NULL,
  `photo` varchar(200) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` (`id`, `content`, `photo`, `delete_status`) VALUES
(1, 'We deal in the Dell portfolio of networking, server, storage and IT products and offer highly competitive pricing due to the strength of the economy of scale, achieved over a decade of experience.', '65cb59d1ddcd1.jpg', 0),
(2, 'Octagon Distribution has been supplying HP solutions for almost 12 years and holds a large inventory of HP’s servers, storage, printing and systems range of products at multiple locations around the w', '65cb59f20e3e5.jpg', 0),
(3, 'Octagon having created a robust network of sourcing products from across the world coupled with a extremely professional team, provides a competitive advantage in pricing and availability of Avaya pro', '65cb5a13cc111.jpg', 0),
(4, 'We hold a large inventory of Cisco products including switching infrastructure, routing, unified computing, security, wireless, phone and collaboration endpoints available for immediate dispatch.', '65cb551ba8506.jpg', 0);

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

--
-- Table structure for table `calender`
--

CREATE TABLE `calender` (
  `id` int(11) NOT NULL,
  `cname` varchar(100) NOT NULL,
  `color` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `calender`
--

INSERT INTO `calender` (`id`, `cname`, `color`, `delete_status`) VALUES
(1, 'sunday sevice', '#d1ba39', 0),
(2, 'sunday sevice', 'red', 1),
(3, 'sunday sevice', 'green', 1),
(4, 'pledgeee', '#871d1d', 1);

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

--
-- Table structure for table `campaign`
--

CREATE TABLE `campaign` (
  `id` int(11) NOT NULL,
  `cam_name` varchar(100) NOT NULL,
  `goal` decimal(10,0) NOT NULL,
  `sdate` date NOT NULL DEFAULT current_timestamp(),
  `edate` date NOT NULL DEFAULT current_timestamp(),
  `notes` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `campaign`
--

INSERT INTO `campaign` (`id`, `cam_name`, `goal`, `sdate`, `edate`, `notes`, `status`, `delete_status`) VALUES
(1, 'Building of a Mission House', 100, '2024-05-10', '2024-05-12', 'vfgf', '0', 0),
(2, 'Church Bus', 1000, '2024-05-01', '2024-05-31', 'vfng', '0', 0),
(3, 'Building of a Mission House', 100, '2024-05-04', '2024-05-05', 'dss', '0', 1);

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

--
-- Table structure for table `career`
--

CREATE TABLE `career` (
  `id` int(10) NOT NULL,
  `heading` longtext NOT NULL,
  `location` longtext NOT NULL,
  `department` longtext NOT NULL,
  `description` longtext NOT NULL,
  `time` int(11) NOT NULL,
  `delete_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `career`
--

INSERT INTO `career` (`id`, `heading`, `location`, `department`, `description`, `time`, `delete_status`) VALUES
(1, 'UX Designer', 'Nashik Maharashtra', 'Engineering', '<p>We are seeking a Senior Software Engineer to join our dynamic team in Bangalore. The ideal candidate will have extensive experience in full-stack development, with expertise in Java, JavaScript, and React. This role offers the opportunity to work on innovative projects and contribute to the growth of our company.</p><p>Role Introduction</p><p>We are seeking a Senior Software Engineer to join our dynamic team in Bangalore. The ideal candidate will have extensive experience in full-stack development, with expertise in Java, JavaScript, and React. This role offers the opportunity to work on innovative projects and contribute to the growth of our company.</p><p>Job Responsibility and Duties</p><ul><li>Design, develop, and maintain high-quality software solutions using Java, JavaScript, and React.</li><li>Collaborate with cross-functional teams to understand project requirements and translate them into technical specifications.</li><li>Conduct code reviews and ensure adherence to coding standards and best practices.</li><li>Architect scalable and efficient solutions that meet the needs of the business and align with industry standards.</li><li>Participate in agile ceremonies such as sprint planning, daily stand-ups, and retrospectives.</li></ul>', 2, 0),
(2, 'Web Designer', 'Mumbai Maharashtra', 'Engineering', '<p>We are seeking a Senior Software Engineer to join our dynamic team in Bangalore. The ideal candidate will have extensive experience in full-stack development, with expertise in Java, JavaScript, and React. This role offers the opportunity to work on innovative projects and contribute to the growth of our company.</p><p>Role Introduction</p><p>We are seeking a Senior Software Engineer to join our dynamic team in Bangalore. The ideal candidate will have extensive experience in full-stack development, with expertise in Java, JavaScript, and React. This role offers the opportunity to work on innovative projects and contribute to the growth of our company.</p><p>Job Responsibility and Duties</p><ul><li>Design, develop, and maintain high-quality software solutions using Java, JavaScript, and React.</li><li>Collaborate with cross-functional teams to understand project requirements and translate them into technical specifications.</li><li>Conduct code reviews and ensure adherence to coding standards and best practices.</li><li>Architect scalable and efficient solutions that meet the needs of the business and align with industry standards.</li><li>Participate in agile ceremonies such as sprint planning, daily stand-ups, and retrospectives.</li></ul>', 1, 0),
(3, 'Digital Marketer', 'Nagpur Maharashtra', 'Engineering', '<p>We are seeking a Senior Software Engineer to join our dynamic team in Bangalore. The ideal candidate will have extensive experience in full-stack development, with expertise in Java, JavaScript, and React. This role offers the opportunity to work on innovative projects and contribute to the growth of our company.</p><p>Role Introduction</p><p>We are seeking a Senior Software Engineer to join our dynamic team in Bangalore. The ideal candidate will have extensive experience in full-stack development, with expertise in Java, JavaScript, and React. This role offers the opportunity to work on innovative projects and contribute to the growth of our company.</p><p>Job Responsibility and Duties</p><ul><li>Design, develop, and maintain high-quality software solutions using Java, JavaScript, and React.</li><li>Collaborate with cross-functional teams to understand project requirements and translate them into technical specifications.</li><li>Conduct code reviews and ensure adherence to coding standards and best practices.</li><li>Architect scalable and efficient solutions that meet the needs of the business and align with industry standards.</li><li>Participate in agile ceremonies such as sprint planning, daily stand-ups, and retrospectives.</li></ul>', 1, 0);

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

--
-- Table structure for table `cashflow_report`
--

CREATE TABLE `cashflow_report` (
  `id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `fromdate` date NOT NULL,
  `todate` date NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `category_name` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `category` (`id`, `category_name`, `delete_status`) VALUES
(1, 'member', 0),
(2, 'event', 0);

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

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `subject` varchar(300) NOT NULL,
  `contact` varchar(200) NOT NULL,
  `message` varchar(200) NOT NULL,
  `delete_status` tinyint(2) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contactus`
--

INSERT INTO `contactus` (`id`, `name`, `email`, `subject`, `contact`, `message`, `delete_status`, `created_date`) VALUES
(1, 'test', 'test@gmail.com', 'test', '3456789767', 'test', 0, '2024-04-13 12:50:39');

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

--
-- Table structure for table `contact_seo`
--

CREATE TABLE `contact_seo` (
  `id` int(11) NOT NULL,
  `metatitle` varchar(200) NOT NULL,
  `metadescription` varchar(200) NOT NULL,
  `keywords` varchar(200) NOT NULL,
  `metatitlef` varchar(250) NOT NULL,
  `metadescriptionf` varchar(250) NOT NULL,
  `linkf` varchar(200) NOT NULL,
  `metatitlet` varchar(200) NOT NULL,
  `metadescriptiont` varchar(250) NOT NULL,
  `delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact_seo`
--

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

--
-- Table structure for table `contribution`
--

CREATE TABLE `contribution` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `member` varchar(100) NOT NULL,
  `amount` int(11) NOT NULL,
  `batch` varchar(100) NOT NULL,
  `contritype` varchar(100) NOT NULL,
  `fund` varchar(100) NOT NULL,
  `paymentmethod` varchar(100) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `payment_id` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contribution`
--

INSERT INTO `contribution` (`id`, `branch`, `member`, `amount`, `batch`, `contritype`, `fund`, `paymentmethod`, `date`, `payment_id`, `total`, `status`, `delete_status`) VALUES
(1, 'Norton ', 'THAIKAWI TONGLUAN ', 100, '1st Services ', '', 'General Fund ', 'cash ', '2024-06-11 00:00:00', 0, 0, 0, 0),
(2, 'Norton ', 'THAIKAWI TONGLUAN ', 110, '1st Services ', 'Building Fund ', 'General Fund ', 'cash ', '2024-06-11 00:00:00', 0, 0, 0, 0),
(3, 'Norton ', 'THAIKAWI TONGLUAN ', 0, '', '', '', '', '2024-06-11 00:00:00', 0, 0, 0, 0),
(4, 'Agrashition ', 'member ', 1000, '1st Services ', 'Building Fund ', 'General Fund ', 'cash ', '2024-06-11 00:00:00', 0, 0, 0, 0);

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

--
-- Table structure for table `contribution_details`
--

CREATE TABLE `contribution_details` (
  `contribution_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `batch` varchar(100) NOT NULL,
  `contritype` varchar(100) NOT NULL,
  `fund` varchar(100) NOT NULL,
  `paymentmethod` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contribution_details`
--

INSERT INTO `contribution_details` (`contribution_id`, `amount`, `batch`, `contritype`, `fund`, `paymentmethod`, `delete_status`) VALUES
(1, 100, '1st Services ', 'Building Fund ', 'dfwfe ', 'online payment ', 0),
(1, 1000, '1st Services ', 'Building Fund ', 'dfwfe ', 'online payment ', 0),
(1, 0, '', '', '', '', 0),
(2, 0, '', '', '', '', 0),
(2, 0, '', '', '', '', 0),
(3, 0, '', '', '', '', 0),
(3, 0, '', '', '', '', 0),
(4, 0, '', '', '', '', 0),
(4, 0, '', '', '', '', 0),
(5, 1001, '1st Services ', 'Building Fund ', 'dfwfe ', 'online payment ', 0),
(5, 0, '', '', '', '', 0),
(6, 1001, '1st Services ', 'Building Fund ', 'dfwfe ', 'online payment ', 0),
(6, 0, '', '', '', '', 0),
(7, 1200, '1st Services ', 'Building Fund ', 'dfwfe ', 'online payment ', 0),
(8, 12001, '1st Services ', 'Building Fund ', 'dfwfe ', 'online payment ', 0);

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

--
-- Table structure for table `contritype`
--

CREATE TABLE `contritype` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contritype`
--

INSERT INTO `contritype` (`id`, `name`, `delete_status`) VALUES
(1, 'Building Fund1', 1),
(2, 'Building Fund', 0);

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

--
-- Table structure for table `custom_field`
--

CREATE TABLE `custom_field` (
  `id` int(11) NOT NULL,
  `category` varchar(100) NOT NULL,
  `field_name` varchar(100) NOT NULL,
  `field` tinyint(4) NOT NULL,
  `field_type` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `custom_field`
--

INSERT INTO `custom_field` (`id`, `category`, `field_name`, `field`, `field_type`, `delete_status`) VALUES
(1, 'member ', '', 1, '', 1),
(2, 'event ', 'Department', 0, '1', 1),
(3, 'member ', '', 1, '', 1),
(4, 'member ', '', 1, '', 1),
(5, 'member ', '', 0, '', 1),
(6, 'member ', 'Department', 0, '2', 0),
(7, 'member ', 'Department', 0, '1', 0),
(8, 'event ', 'Department', 0, '1', 1);

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

--
-- Table structure for table `donar`
--

CREATE TABLE `donar` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobileno` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `donar`
--

INSERT INTO `donar` (`id`, `name`, `email`, `mobileno`) VALUES
(1, 'user1', 'user1@gmail.com', '9898989892'),
(2, 'user2', 'use2r@gmail.com', '9898989893');

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

--
-- Table structure for table `emailsetting`
--

CREATE TABLE `emailsetting` (
  `id` int(11) NOT NULL,
  `smtp_server` varchar(255) NOT NULL,
  `smtp_username` varchar(255) NOT NULL,
  `smtp_password` varchar(255) NOT NULL,
  `stmp_port` varchar(255) NOT NULL,
  `smtp_type` varchar(255) NOT NULL,
  `email` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `emailsetting`
--

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

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int(11) NOT NULL,
  `ename` varchar(100) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `notes` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event`
--

INSERT INTO `event` (`id`, `ename`, `branch`, `start_date`, `end_date`, `notes`, `delete_status`) VALUES
(1, 'Esinida', 'Norton ', '2024-05-01 00:00:00', '2024-05-04 00:00:00', 'jmkj', 0),
(5, 'prayer', '', '2024-05-16 00:00:00', '2024-05-29 00:00:00', '', 0),
(6, 'Esinida', '', '2024-06-01 00:00:00', '2024-06-07 00:00:00', 'gbgn', 0);

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

--
-- Table structure for table `expense`
--

CREATE TABLE `expense` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `expensetype` varchar(100) NOT NULL,
  `amount` text NOT NULL,
  `date` datetime NOT NULL,
  `recurring` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `photo1` varchar(100) NOT NULL,
  `total_expense` int(11) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `expense`
--

INSERT INTO `expense` (`id`, `branch`, `expensetype`, `amount`, `date`, `recurring`, `description`, `photo1`, `total_expense`, `delete_status`) VALUES
(1, 'Norton ', 'mail ', '100', '2024-04-03 00:00:00', '0', 'dvdd', 'CFS Website content-1 (1).docx', 1300, 0),
(2, 'Norton ', 'Cleaning supplies ', '100', '2024-04-02 00:00:00', '1', 'ddd', 'CFS Website content-1.docx', 1300, 0),
(3, 'Agrashition ', 'mail ', '100', '2024-05-01 00:00:00', '1', 'vf', 'CFS Website content-1.docx', 100, 0),
(4, 'Norton ', 'mail ', '100', '2024-05-01 00:00:00', '0', 'gff', '662618355f862.docx', 1300, 0),
(5, 'Norton ', 'Cleaning supplies ', '1000', '2024-05-03 00:00:00', '0', 'xscx', '', 1300, 1);

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

--
-- Table structure for table `expensetype`
--

CREATE TABLE `expensetype` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `expensetype`
--

INSERT INTO `expensetype` (`id`, `name`, `delete_status`) VALUES
(1, 'mail', 0),
(2, 'Cleaning supplies', 0);

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

--
-- Table structure for table `followup_category`
--

CREATE TABLE `followup_category` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `day` int(11) NOT NULL,
  `note` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `followup_category`
--

INSERT INTO `followup_category` (`id`, `name`, `day`, `note`, `delete_status`) VALUES
(1, 'Ten', 2, 'gfg', 0),
(2, 'Uche jumbo', 2, 'fbfbf', 0),
(3, 'Ten', 2, ' gfg', 1);

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

--
-- Table structure for table `follow_up`
--

CREATE TABLE `follow_up` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `member` varchar(100) NOT NULL,
  `user` varchar(100) NOT NULL,
  `category` varchar(100) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `description` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `follow_up`
--

INSERT INTO `follow_up` (`id`, `branch`, `member`, `user`, `category`, `status`, `description`, `created_at`, `delete_status`) VALUES
(1, 'Agrashition ', 'test ', 'Admin Account ', 'Ten ', 2, 'hdhd', '2024-05-13 00:00:00', 1),
(2, 'Norton ', 'Morire Olayinka ', 'Admin Account ', 'Ten ', 0, 'ndvf', '2024-05-13 14:37:20', 0),
(3, 'Norton ', 'THAIKAWI TONGLUAN ', 'Admin Account ', 'Ten ', 0, 'dgd', '2024-05-22 12:22:13', 0),
(4, 'Norton ', 'THAIKAWI TONGLUAN ', 'member ', 'Ten ', 0, '', '2024-05-31 11:37:33', 0);

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

--
-- Table structure for table `fund`
--

CREATE TABLE `fund` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `note` varchar(100) NOT NULL,
  `total` text NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fund`
--

INSERT INTO `fund` (`id`, `name`, `note`, `total`, `delete_status`) VALUES
(1, 'General Fund', 'frr', '1233', 1),
(2, 'General Fund', 'fbbf', '1233', 1),
(3, 'General Fund', 'General Fund', '1222', 0);

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `description`, `delete_status`) VALUES
(1, 'admin', 'admin', 0),
(2, 'user', 'manage user', 0),
(3, 'member', 'member', 0);

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

--
-- Table structure for table `home_seo`
--

CREATE TABLE `home_seo` (
  `id` int(11) NOT NULL,
  `metatitle` varchar(200) NOT NULL,
  `metadescription` varchar(200) NOT NULL,
  `keywords` varchar(200) NOT NULL,
  `metatitlef` varchar(250) NOT NULL,
  `metadescriptionf` varchar(250) NOT NULL,
  `linkf` varchar(200) NOT NULL,
  `metatitlet` varchar(200) NOT NULL,
  `metadescriptiont` varchar(250) NOT NULL,
  `keywordst` varchar(200) NOT NULL,
  `conical` varchar(200) NOT NULL,
  `delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_seo`
--

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

--
-- Table structure for table `income`
--

CREATE TABLE `income` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `incometype` varchar(100) NOT NULL,
  `amount` text NOT NULL,
  `date` date NOT NULL DEFAULT current_timestamp(),
  `description` varchar(100) NOT NULL,
  `photo1` varchar(100) NOT NULL,
  `total_income` int(11) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `income`
--

INSERT INTO `income` (`id`, `branch`, `incometype`, `amount`, `date`, `description`, `photo1`, `total_income`, `delete_status`) VALUES
(1, 'Norton ', 'Donations ', '100', '2024-04-02', 'fvfff', 'CFS Website content-1.docx', 200, 0),
(2, 'Norton ', 'Donations ', '100', '2024-05-01', 'fggg', 'CFS Website content-1.docx', 200, 1);

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

--
-- Table structure for table `incometype`
--

CREATE TABLE `incometype` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `incometype`
--

INSERT INTO `incometype` (`id`, `name`, `delete_status`) VALUES
(1, 'Donationss', 0),
(2, 'Welfare offering', 0);

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

--
-- Table structure for table `instapayment`
--

CREATE TABLE `instapayment` (
  `id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `amount` int(11) NOT NULL,
  `purpose` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `instapayment`
--

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

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`id`, `name`, `delete_status`) VALUES
(1, 'nashik', 1),
(2, 'mumbai', 1),
(3, 'nashikk', 1),
(4, 'Building Fund', 0),
(5, 'General Fund', 1);

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` int(10) NOT NULL,
  `email` varchar(150) NOT NULL,
  `password` varchar(150) NOT NULL,
  `username` varchar(150) NOT NULL,
  `mobileno` varchar(150) NOT NULL,
  `role` varchar(100) NOT NULL,
  `image` varchar(150) NOT NULL,
  `otp` varchar(100) NOT NULL,
  `random` varchar(100) NOT NULL,
  `delete_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `email`, `password`, `username`, `mobileno`, `role`, `image`, `otp`, `random`, `delete_status`) VALUES
(11, 'mayuri.infospace@gmail.com', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', 'Mrs. Mayuri', '+919529230459', '0', 'mayurik.png', '', '', 0),
(14, 'user1@gmail.com', '0a041b9462caa4a31bac3567e0b6e6fd9100787db2ab433d96f6d178cabfce90', 'user', '9856598989', '2 ', 'admin.jpg', '', '', 0),
(15, 'member@gmail.com', 'e31ab643c44f7a0ec824b59d1194d60dac334200d845e61d2d289daa0f087ea4', 'member', '9856598989', '3 ', 'member.png', '', '', 0),
(16, 'user2@gmail.com', '6025d18fe48abd45168528f18a82e265dd98d421a7084aa09f61b341703901a3', 'user2', '9856598989', '2 ', '', '', '', 0);
-- --------------------------------------------------------

--
-- Table structure for table `manage_web`
--

CREATE TABLE `manage_web` (
  `id` int(10) NOT NULL,
  `photo1` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `photos` varchar(255) NOT NULL,
  `sitekey` varchar(255) NOT NULL,
  `secretkey` varchar(255) NOT NULL,
  `contact` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `address` varchar(200) NOT NULL,
  `instance` varchar(100) NOT NULL,
  `access_token` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `manage_web`
--

INSERT INTO `manage_web` (`id`, `photo1`, `title`, `photos`, `sitekey`, `secretkey`, `contact`, `email`, `address`, `instance`, `access_token`) VALUES
(1, '678b58547e0de.png', '10x Church Software by Mayuri K. Freelancer', '678b5695990b5.jpg', '', '', '+919529230459', 'mayuri.infospace@gmail.com', 'India', '', '');

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

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `id` int(11) NOT NULL,
  `batch_id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `marital` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `phone_no` text NOT NULL,
  `email` varchar(100) NOT NULL,
  `bod` date NOT NULL,
  `address` varchar(100) NOT NULL,
  `campaign` varchar(100) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `photo1` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `group` varchar(100) NOT NULL,
  `testfield` varchar(100) NOT NULL,
  `department` varchar(100) NOT NULL,
  `uplata` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `member`
--

INSERT INTO `member` (`id`, `batch_id`, `branch`, `name`, `gender`, `marital`, `status`, `phone_no`, `email`, `bod`, `address`, `campaign`, `photo`, `description`, `photo1`, `location`, `group`, `testfield`, `department`, `uplata`, `delete_status`) VALUES
(5, 1, 'Norton', 'Anita Fernandes', '2', '1', '1', '9876543210', 'anita.fernandes@gmail.com', '1990-08-15', 'Mumbai', '3', 'anita.jpg', 'description 1', 'anita1.docx', 'Mumbai', '1', 'abc', 'SUNDAY_SCHOOL', '2023', 0),
(6, 2, 'Norton', 'David Dsouza', '1', '2', '1', '9876543211', 'david.dsouza@gmail.com', '1985-04-12', 'Pune', '3', 'david.jpg', 'description 2', 'david1.docx', 'Pune', '2', 'xyz', 'YOUTH_MINISTRY', '2022', 0),
(7, 3, 'Norton', 'Joseph Thomas', '1', '1', '1', '9876543212', 'joseph.thomas@gmail.com', '1995-12-25', 'Kochi', '2', 'joseph.jpg', 'description 3', 'joseph1.docx', 'Kochi', '3', 'lmno', 'KAMA', '2021', 0),
(8, 4, 'Norton', 'Maria George', '2', '1', '1', '9876543213', 'maria.george@gmail.com', '1988-01-18', 'Chennai', '3', 'maria.jpg', 'description 4', 'maria1.docx', 'Chennai', '1', 'opqr', 'SUNDAY_SCHOOL', '2023', 0),
(9, 5, 'Norton', 'Peter Jacob', '1', '2', '1', '9876543214', 'peter.jacob@gmail.com', '1993-03-20', 'Bangalore', '1', 'peter.jpg', 'description 5', 'peter1.docx', 'Bangalore', '2', 'stuv', 'YOUTH_MINISTRY', '2022', 0),
(10, 6, 'Norton', 'Grace Williams', '2', '1', '1', '9876543215', 'grace.williams@gmail.com', '1992-06-17', 'Goa', '2', 'grace.jpg', 'description 6', 'grace1.docx', 'Goa', '3', 'wxyz', 'KAMA', '2021', 0),
(11, 7, 'Norton', 'John Matthew', '1', '1', '1', '9876543216', 'john.matthew@gmail.com', '1990-11-10', 'Hyderabad', '3', 'john.jpg', 'description 7', 'john1.docx', 'Hyderabad', '1', 'abcd', 'SUNDAY_SCHOOL', '2023', 0),
(12, 8, 'Norton', 'Sofia Joseph', '2', '2', '1', '9876543217', 'sofia.joseph@gmail.com', '1996-07-22', 'Kochi', '3', 'sofia.jpg', 'description 8', 'sofia1.docx', 'Kochi', '2', 'efgh', 'YOUTH_MINISTRY', '2022', 0),
(13, 9, 'Norton', 'Samuel Peter', '1', '1', '1', '9876543218', 'samuel.peter@gmail.com', '1994-05-25', 'Chennai', '2', 'samuel.jpg', 'description 9', 'samuel1.docx', 'Chennai', '3', 'ijkl', 'KAMA', '2021', 0),
(14, 10, 'Norton', 'Rachel Abraham', '2', '1', '1', '9876543219', 'rachel.abraham@gmail.com', '1992-09-14', 'Bangalore', '3', 'rachel.jpg', 'description 10', 'rachel1.docx', 'Bangalore', '1', 'mnop', 'SUNDAY_SCHOOL', '2023', 0),
(15, 11, 'Norton', 'Matthew Thomas', '1', '2', '1', '9876543220', 'matthew.thomas@gmail.com', '1991-02-28', 'Mumbai', '1', 'matthew.jpg', 'description 11', 'matthew1.docx', 'Mumbai', '2', 'qrst', 'YOUTH_MINISTRY', '2022', 0),
(16, 12, 'Norton', 'Catherine George', '2', '1', '1', '9876543221', 'catherine.george@gmail.com', '1990-05-05', 'Goa', '2', 'catherine.jpg', 'description 12', 'catherine1.docx', 'Goa', '3', 'uvwx', 'KAMA', '2021', 0),
(17, 13, 'Norton', 'Philip Dsouza', '1', '2', '1', '9876543222', 'philip.dsouza@gmail.com', '1993-08-30', 'Pune', '1', 'philip.jpg', 'description 13', 'philip1.docx', 'Pune', '2', 'yzab', 'SUNDAY_SCHOOL', '2023', 0),
(18, 14, 'Norton', 'Elizabeth John', '2', '1', '1', '9876543223', 'elizabeth.john@gmail.com', '1992-12-01', 'Chennai', '3', 'elizabeth.jpg', 'description 14', 'elizabeth1.docx', 'Chennai', '1', 'cdef', 'YOUTH_MINISTRY', '2022', 0),
(19, 15, 'Norton', 'Luke Williams', '1', '1', '1', '9876543224', 'luke.williams@gmail.com', '1991-06-18', 'Hyderabad', '2', 'luke.jpg', 'description 15', 'luke1.docx', 'Hyderabad', '2', 'ghij', 'KAMA', '2021', 0),
(20, 16, 'Norton', 'Martha Thomas', '2', '1', '1', '9876543225', 'martha.thomas@gmail.com', '1994-10-12', 'Bangalore', '3', 'martha.jpg', 'description 16', 'martha1.docx', 'Bangalore', '1', 'klmn', 'SUNDAY_SCHOOL', '2023', 0);

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `member` varchar(100) NOT NULL,
  `amount` int(11) NOT NULL,
  `date` date NOT NULL,
  `paymentmethod` varchar(100) NOT NULL,
  `notes` varchar(100) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `member`, `amount`, `date`, `paymentmethod`, `notes`, `payment_id`, `delete_status`) VALUES
(1, 'THAIKAWI TONGLUAN ', 100, '2024-05-01', 'online payment ', 'sdscs', 0, 0),
(2, 'member ', 1000, '2024-05-30', 'Cash', 'axa', 0, 0),
(3, 'THAIKAWI TONGLUAN ', 1110, '2024-05-31', 'Online Payment', 'scs', 0, 0),
(4, '', 0, '0000-00-00', 'Cash', '', 0, 0),
(5, '', 0, '0000-00-00', 'Cash', '', 0, 0);

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

--
-- Table structure for table `paymentmethod`
--

CREATE TABLE `paymentmethod` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `paymentmethod`
--

INSERT INTO `paymentmethod` (`id`, `name`, `delete_status`) VALUES
(1, 'CASHhh', 1),
(2, 'CASH', 1),
(3, 'cash', 0),
(4, 'cash', 1),
(5, 'cash', 1),
(6, 'cash', 1),
(7, 'Mobile Money', 1),
(8, 'online payment', 0);

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

--
-- Table structure for table `payroll`
--

CREATE TABLE `payroll` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `user_name` varchar(100) NOT NULL,
  `employee_name` varchar(100) NOT NULL,
  `payroll_date` date NOT NULL DEFAULT current_timestamp(),
  `extra_time` text NOT NULL,
  `Timein_late` text NOT NULL,
  `total_pay` int(11) NOT NULL,
  `total_deduction` int(11) NOT NULL,
  `net_pay` int(11) NOT NULL,
  `payment_method` varchar(100) NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `acc_no` varchar(100) NOT NULL,
  `decription` varchar(100) NOT NULL,
  `paid_amount` int(11) NOT NULL,
  `comment` varchar(100) NOT NULL,
  `recurring` tinyint(4) NOT NULL,
  `recur_frequency` int(11) NOT NULL,
  `recur_type` varchar(100) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `total_payroll` int(11) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payroll`
--

INSERT INTO `payroll` (`id`, `branch`, `user_name`, `employee_name`, `payroll_date`, `extra_time`, `Timein_late`, `total_pay`, `total_deduction`, `net_pay`, `payment_method`, `bank_name`, `acc_no`, `decription`, `paid_amount`, `comment`, `recurring`, `recur_frequency`, `recur_type`, `start_date`, `end_date`, `total_payroll`, `delete_status`) VALUES
(1, 'Norton ', 'user ', 'xyz', '2024-05-29', '100', '50', 300, 60, 240, 'cash', 'sbi', '4566456554665', 'cc', 240, 'ccs', 1, 0, '', NULL, NULL, 600, 0),
(2, 'Norton ', 'user ', 'xyz', '2024-05-29', '200', '10', 300, 60, 240, 'cash', 'sbi', '4566456554665', 'cc', 240, 'ccs', 1, 0, '', NULL, NULL, 600, 0);

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

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

CREATE TABLE `permission` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `display_name` varchar(100) NOT NULL,
  `operation` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `permission` (`id`, `name`, `display_name`, `operation`) VALUES
(1, 'role_management', 'role_management', 'role_management'),
(2, 'add_role', 'add_role', 'add_role'),
(3, 'member_management', 'member_management', 'member_management'),
(4, 'add_member', 'add_member', 'add_member'),
(5, 'user_management', 'user_management', 'user_management'),
(6, 'add_user', 'add_user', 'add_user'),
(7, 'edit_user', 'edit_user', 'edit_user'),
(8, 'payroll_management', 'payroll_management', 'payroll_management'),
(9, 'add_payroll', 'add_payroll', 'add_payroll'),
(10, 'edit_payroll', 'edit_payroll', 'edit_payroll'),
(11, 'delete_payroll', 'delete_payroll', 'delete_payroll'),
(12, 'view_payroll', 'view_payroll', 'view_payroll'),
(13, 'view_role', 'view_role', 'view_role'),
(14, 'view_user', 'view_user', 'view_user'),
(15, 'view_member', 'view_member', 'view_member'),
(17, 'edit_member', 'edit_member', 'edit_member'),
(18, 'delete_member', 'delete_member', 'delete_member'),
(19, 'expense_management', 'expense_management', 'expense_management'),
(20, 'add_expense', 'add_expense', 'add_expense'),
(21, 'view_expense', 'view_expense', 'view_expense'),
(22, 'edit_expense', 'edit_expense', 'edit_expense'),
(23, 'income_management', 'income_management', 'income_management'),
(24, 'add_income', 'add_income', 'add_income'),
(25, 'view_income', 'view_income', 'view_income'),
(26, 'edit_income', 'edit_income', 'edit_income'),
(38, 'branch_management', 'branch_management', 'branch_management'),
(39, 'add_branch', 'add_branch', 'add_branch'),
(40, 'edit_branch', 'edit_branch', 'edit_branch'),
(41, 'view_branch', 'view_branch', 'view_branch'),
(42, 'report', 'report', 'report'),
(43, 'asset_management', 'asset_management', 'asset_management'),
(44, 'add_asset', 'add_asset', 'add_asset'),
(45, 'edit_asset', 'edit_asset', 'edit_asset'),
(46, 'view_asset', 'view_asset', 'view_asset'),
(47, 'soul_winning_mgnt', 'soul_winning_mgnt', 'soul_winning_mgnt'),
(48, 'add_soul_winning', 'add_soul_winning', 'add_soul_winning'),
(49, 'view_soul_winning', 'view_soul_winning', 'view_soul_winning'),
(50, 'edit_soul_winning', 'edit_soul_winning', 'edit_soul_winning'),
(51, 'event_mangement', 'event_mangement', 'event_mangement'),
(52, 'view_event', 'view_event', 'view_event'),
(53, 'add_event', 'add_event', 'add_event'),
(54, 'add_location', 'add_location', 'add_location'),
(55, 'view_location', 'view_location', 'view_location'),
(56, 'add_calender', 'add_calender', 'add_calender'),
(57, 'view_calender', 'view_calender', 'view_calender'),
(58, 'pledge_management', 'pledge_management', 'pledge_management'),
(59, 'add_pledge', 'add_pledge', 'add_pledge'),
(60, 'view_pledge', 'view_pledge', 'view_pledge'),
(61, 'edit_pledge', 'edit_pledge', 'edit_pledge'),
(62, 'campaign', 'campaign', 'campaign'),
(63, 'add_campaign', 'add_campaign', 'add_campaign'),
(64, 'view_campaign', 'view_campaign', 'view_campaign'),
(65, 'edit_campaign', 'edit_campaign', 'edit_campaign'),
(66, 'manage_campaign', 'manage_campaign', 'manage_campaign'),
(67, 'contribution_mgnt', 'contribution_mgnt', 'contribution_mgnt'),
(68, 'add_contribution', 'add_contribution', 'add_contribution'),
(69, 'view_contribution', 'view_contribution', 'view_contribution'),
(70, 'delete_contribution', 'delete_contribution', 'delete_contribution'),
(71, 'followups_management', 'followups_management', 'followups_management'),
(72, 'add_followup', 'add_followup', 'add_followup'),
(73, 'view_followup', 'view_followup', 'view_followup'),
(74, 'delete_followup', 'delete_followup', 'delete_followup'),
(75, 'add_followupcategory', 'add_followupcategory', 'add_followupcategory'),
(76, 'view_followupcategory', 'view_followupcategory', 'view_followupcategory'),
(77, 'edit_followupcategory', 'edit_followupcategory', 'edit_followupcategory'),
(78, 'edit_followup', 'edit_followup', 'edit_followup'),
(79, 'communication', 'communication', 'communication'),
(80, 'email', 'email', 'email'),
(81, 'custom_field_management', 'custom_field_management', 'custom_field_management'),
(82, 'add_custom_field', 'add_custom_field', 'add_custom_field'),
(83, 'view_custom_field', 'view_custom_field', 'view_custom_field'),
(84, 'edit_custom_field', 'edit_custom_field', 'edit_custom_field'),
(85, 'delete_custom_field', 'delete_custom_field', 'delete_custom_field'),
(86, 'add_volunteerrole', 'add_volunteerrole', 'add_volunteerrole'),
(87, 'view_volunteerrole', 'view_volunteerrole', 'view_volunteerrole'),
(88, 'add_batch', 'add_batch', 'add_batch'),
(89, 'view_batch', 'view_batch', 'view_batch'),
(90, 'add_fund', 'add_fund', 'add_fund'),
(91, 'view_fund', 'view_fund', 'view_fund'),
(92, 'add_paymentmethod', 'add_paymentmethod', 'add_paymentmethod'),
(93, 'view_paymentmethod', 'view_paymentmethod', 'view_paymentmethod'),
(94, 'add_contritype', 'add_contritype', 'add_contritype'),
(95, 'view_contritype', 'view_contritype', 'view_contritype'),
(98, 'add_assettype', 'add_assettype', 'add_assettype'),
(99, 'view_assettype', 'view_assettype', 'view_assettype'),
(100, 'audit_trail', 'audit_trail', 'audit_trail'),
(101, 'view_audit_trail', 'view_audit_trail', 'view_audit_trail'),
(102, 'delete_user', 'delete_user', 'delete_user'),
(103, 'view_payment', 'view_payment', 'view_payment');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`id`, `permission_id`, `group_id`) VALUES
(1, 1, 1),
(2, 2, 1),
(3, 13, 1),
(4, 5, 2),
(5, 6, 2),
(6, 7, 2),
(7, 14, 2),
(8, 3, 3),
(9, 4, 3),
(10, 15, 3),
(11, 17, 3);

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

--
-- Table structure for table `pledges`
--

CREATE TABLE `pledges` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `campaign` varchar(100) NOT NULL,
  `member` varchar(100) NOT NULL,
  `pledges_amount` decimal(10,0) NOT NULL,
  `date` date NOT NULL DEFAULT current_timestamp(),
  `recurring` tinyint(4) NOT NULL,
  `notes` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `total_pledges` int(11) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pledges`
--

INSERT INTO `pledges` (`id`, `branch`, `campaign`, `member`, `pledges_amount`, `date`, `recurring`, `notes`, `email`, `total_pledges`, `delete_status`) VALUES
(1, 'Norton ', 'Church Bus ', 'THAIKAWI TONGLUAN ', 100, '2024-05-01', 2, 'scdv', '', 10100, 0),
(2, 'Norton ', 'Building of a Mission House ', 'THAIKAWI TONGLUAN ', 10000, '2024-06-01', 2, 'scsc', '', 10100, 0),
(3, 'Agrashition ', 'Building of a Mission House ', 'Morire Olayinka ', 1000, '2024-06-12', 2, 'cff', '', 1000, 0);

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

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

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `roles` (`id`, `name`, `description`, `delete_status`) VALUES
(1, 'member', '', 0),
(2, 'role', '', 0);

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

--
-- Table structure for table `send_email`
--

CREATE TABLE `send_email` (
  `id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `to_member` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `message` varchar(100) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `send_email`
--

INSERT INTO `send_email` (`id`, `member_id`, `to_member`, `subject`, `message`, `date`, `delete_status`) VALUES
(1, 0, 'THAIKAWI@gmail.com', 'dddd', '<p>cccc</p>', '2024-05-01 00:00:00', 0),
(2, 0, 'THAIKAWI@gmail.com', 'dddd', '<p>cccc</p>', '2024-05-01 00:00:00', 0),
(3, 0, 'THAIKAWI@gmail.com', 'dddd', '<p>cccc</p>', '2024-05-01 00:00:00', 0),
(4, 0, 'THAIKAWI@gmail.com', 'bbb', '<p>zxcfd</p>', '2024-05-23 00:00:00', 0),
(6, 8, 'test@gmail.com', 'document', '<p>dsds</p>', '2024-05-02 11:58:27', 0),
(7, 8, 'THAIKAWI@gmail.com', 'document', '<p>bbbgrgr dvgrgr</p>', '2024-05-02 12:06:08', 0),
(8, 2, 'tt@gmail.com', 'noo', '<p>dvhdgd</p>', '2024-05-17 14:29:25', 0),
(9, 2, 'member@gmail.com', 'bbb', '<p>ffef</p>', '2024-05-31 12:06:51', 0);

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(11) NOT NULL,
  `heading` varchar(200) NOT NULL,
  `photo` varchar(200) NOT NULL,
  `short_content` varchar(200) NOT NULL,
  `content` longtext DEFAULT NULL,
  `date` date NOT NULL DEFAULT current_timestamp(),
  `amount` varchar(200) NOT NULL,
  `metatitle` varchar(200) NOT NULL,
  `metadescription` varchar(200) NOT NULL,
  `keywords` varchar(200) NOT NULL,
  `robots` varchar(200) NOT NULL,
  `photo1` varchar(200) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service`
--

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

--
-- Table structure for table `service_seo`
--

CREATE TABLE `service_seo` (
  `id` int(11) NOT NULL,
  `metatitle` varchar(200) NOT NULL,
  `metadescription` varchar(200) NOT NULL,
  `keywords` varchar(200) NOT NULL,
  `metatitlef` varchar(250) NOT NULL,
  `metadescriptionf` varchar(250) NOT NULL,
  `linkf` varchar(200) NOT NULL,
  `metatitlet` varchar(200) NOT NULL,
  `metadescriptiont` varchar(250) NOT NULL,
  `delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_seo`
--

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(10) NOT NULL,
  `photo` varchar(300) NOT NULL,
  `heading` varchar(300) NOT NULL,
  `heading1` varchar(200) NOT NULL,
  `delete_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `photo`, `heading`, `heading1`, `delete_status`) VALUES
(1, '6619070390f8c.jpg', 'Unlocking Talent Potential', 'Navigating Success Together', 0),
(3, '661907465639e.jpg', 'Unlocking Talent Potential', 'Where Vision Meets Talent', 0);

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

--
-- Table structure for table `sms_gateway`
--

CREATE TABLE `sms_gateway` (
  `id` int(11) NOT NULL,
  `fromname` varchar(100) NOT NULL,
  `toname` varchar(100) NOT NULL,
  `message` varchar(100) NOT NULL,
  `url` varchar(100) NOT NULL,
  `note` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sms_gateway1`
--

CREATE TABLE `sms_gateway1` (
  `id` int(11) NOT NULL,
  `phone` text NOT NULL,
  `message` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `solutions_seo`
--

CREATE TABLE `solutions_seo` (
  `id` int(11) NOT NULL,
  `metatitle` varchar(200) NOT NULL,
  `metadescription` varchar(200) NOT NULL,
  `keywords` varchar(200) NOT NULL,
  `metatitlef` varchar(250) NOT NULL,
  `metadescriptionf` varchar(250) NOT NULL,
  `linkf` varchar(200) NOT NULL,
  `metatitlet` varchar(200) NOT NULL,
  `metadescriptiont` varchar(250) NOT NULL,
  `delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `solutions_seo`
--

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

--
-- Table structure for table `soul_winning`
--

CREATE TABLE `soul_winning` (
  `id` int(11) NOT NULL,
  `branch` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `marital` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `phone_no` text NOT NULL,
  `email` varchar(100) NOT NULL,
  `bod` date NOT NULL,
  `address` varchar(100) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `photo1` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `soul_winning`
--

INSERT INTO `soul_winning` (`id`, `branch`, `name`, `gender`, `marital`, `status`, `phone_no`, `email`, `bod`, `address`, `photo`, `description`, `photo1`, `delete_status`) VALUES
(1, '', '', '', '', '', '', '', '0000-00-00', '', '', 'no ', '', 1),
(2, 'Norton ', 'nnn', '1', '1', '3', '8787878787', 's@gmail.com', '2019-09-23', 'mumbai', '65fa72f3af3cc.jpg', 'bfvb', 'CFS Website content-1 (1).docx', 1),
(3, 'Norton ', 'bbb', '1', '1', '1', '8787878787', 's@gmail.com', '2021-10-22', 'mumbai', '65fa72fe8fe0d.jpg', 'dvfd', 'CFS Website content-1 (1).docx', 1),
(4, 'Norton ', 'test', '1', '1', '1', '8787878787', 'test@gmail.com', '2022-07-01', 'nashik', '65f998725ab69.jpg', 'ddv', '', 1),
(5, 'Norton ', 'test', '1', '1', '2', '8787878787', 'test@gmail.com', '2024-06-07', 'pune', '660bddb9b2d2c.png', 'dvdv', 'CFS Website content-1 (2).docx', 0),
(6, 'Agrashition ', 'dsouza', '1', '1', '1', '8787878787', 'd@gmail.com', '2000-07-24', 'frgt', '65f998725ab69.jpg', 'gfh', 'CFS Website content-1 (2).docx', 0);

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

--
-- Table structure for table `totals`
--

CREATE TABLE `totals` (
  `id` int(11) NOT NULL,
  `total_contri` int(11) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `gender` tinyint(4) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `mobileno` varchar(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `repassword` varchar(100) NOT NULL,
  `role` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `notes` varchar(100) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `update_date` datetime NOT NULL DEFAULT current_timestamp(),
  `last_login` datetime NOT NULL DEFAULT current_timestamp(),
  `otp` varchar(100) NOT NULL,
  `random` varchar(100) NOT NULL,
  `auth` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `admin_id`, `branch_id`, `username`, `gender`, `photo`, `mobileno`, `email`, `password`, `repassword`, `role`, `address`, `notes`, `date`, `update_date`, `last_login`, `otp`, `random`, `auth`, `status`, `delete_status`) VALUES
(1, 0, 0, 'member', 1, '', '9856598989', 'member@gmail.com', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '3 ', 'hdd', 'dd', '2024-05-28 13:17:26', '2024-05-28 13:17:26', '2024-05-28 13:17:26', '', '', 0, 0, 0),
(2, 0, 0, 'user', 1, '', '9856598989', 'user1@gmail.com', '0a041b9462caa4a31bac3567e0b6e6fd9100787db2ab433d96f6d178cabfce90', '0a041b9462caa4a31bac3567e0b6e6fd9100787db2ab433d96f6d178cabfce90', '2 ', 'efef', 'fefe', '2024-05-28 15:07:48', '2024-05-28 15:07:48', '2024-05-28 15:07:48', '', '', 0, 0, 0),
(3, 0, 0, 'member', 1, '', '9856598989', 'member@gmail.com', 'e31ab643c44f7a0ec824b59d1194d60dac334200d845e61d2d289daa0f087ea4', 'e31ab643c44f7a0ec824b59d1194d60dac334200d845e61d2d289daa0f087ea4', '3 ', 'nashik', 'fdgfg', '2024-05-28 15:51:35', '2024-05-28 15:51:35', '2024-05-28 15:51:35', '', '', 0, 0, 0);

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

--
-- Table structure for table `volunteerrole`
--

CREATE TABLE `volunteerrole` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `notes` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `volunteerrole`
--

INSERT INTO `volunteerrole` (`id`, `name`, `notes`, `delete_status`) VALUES
(1, 'test1', 'testcccc', 0),
(2, 'test', 'test11', 0);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`b_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
  MODIFY `b_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

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

--
-- AUTO_INCREMENT for table `career`
--
ALTER TABLE `career`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cashflow_report`
--
ALTER TABLE `cashflow_report`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `sms_gateway`
--
ALTER TABLE `sms_gateway`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sms_gateway1`
--
ALTER TABLE `sms_gateway1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `totals`
--
ALTER TABLE `totals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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