-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 25, 2026 at 01:54 PM
-- Server version: 8.0.45
-- PHP Version: 8.4.16

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

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

--
-- Table structure for table `ca_receipt`
--

CREATE TABLE `ca_receipt` (
  `id` int NOT NULL,
  `userid` int NOT NULL DEFAULT '0',
  `amount` float NOT NULL DEFAULT '0',
  `payable` decimal(10,2) NOT NULL DEFAULT '0.00',
  `send_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `orderid` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `transid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `Startdate` datetime NOT NULL,
  `hide` int NOT NULL DEFAULT '0',
  `enddate` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `hideforappstore` int NOT NULL DEFAULT '0',
  `isRazorpaymentgateway` int NOT NULL DEFAULT '0',
  `showdistrict_assembly` int NOT NULL DEFAULT '1',
  `playstore_url` varchar(500) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `appstore_url` varchar(500) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `version`, `Startdate`, `hide`, `enddate`, `hideforappstore`, `isRazorpaymentgateway`, `showdistrict_assembly`, `playstore_url`, `appstore_url`) VALUES
(1, '3', '2025-01-20 00:00:00', 0, '2026-01-30 00:00:00', 3, 2, 0, 'https://play.google.com/store/apps/details?id=com.shadekadappadi.moneypool', 'https://apps.apple.com/in/app/shade-kadappadi/id6569244236');

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

--
-- Table structure for table `tbl_assembly`
--

CREATE TABLE `tbl_assembly` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `district` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_assembly`
--

INSERT INTO `tbl_assembly` (`id`, `name`, `district`, `status`) VALUES
(10, 'Vengara', 1, 0),
(9, 'Kondotty', 1, 0),
(1, 'Vallikkunnu', 1, 0),
(102, 'NA', 1, 0),
(15, 'Tirurangadi', 1, 0),
(16, 'Kottakkal', 1, 0);

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

--
-- Table structure for table `tbl_challenge`
--

CREATE TABLE `tbl_challenge` (
  `id` int NOT NULL,
  `challenge_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `challenge_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `challenge_startdate` date NOT NULL DEFAULT '1990-01-01',
  `challenge_enddate` date NOT NULL DEFAULT '1990-01-01',
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `description` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `product_name1` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `product_image1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `product_amount1` float NOT NULL DEFAULT '0',
  `productconversion1` int NOT NULL DEFAULT '1',
  `delivary_date1` date NOT NULL DEFAULT '1990-01-01',
  `product_name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `product_image2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `product_amount2` float NOT NULL DEFAULT '0',
  `productconversion2` int NOT NULL DEFAULT '1',
  `delivary_date2` date NOT NULL DEFAULT '1990-01-01',
  `product_name3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `product_image3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `product_amount3` float NOT NULL DEFAULT '0',
  `productconversion3` int NOT NULL DEFAULT '1',
  `delivary_date3` date DEFAULT '1990-01-01',
  `sponsorproductid1` int NOT NULL DEFAULT '0',
  `sponsorproductid2` int NOT NULL DEFAULT '0',
  `sponsorproductid3` int NOT NULL DEFAULT '0',
  `sponsorproductid4` int NOT NULL DEFAULT '0',
  `sponsorproductid5` int NOT NULL DEFAULT '0',
  `rate1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `rate2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `rate3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `rate4` decimal(10,2) NOT NULL DEFAULT '0.00',
  `rate5` decimal(10,2) NOT NULL DEFAULT '0.00',
  `unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '0',
  `showdistrictandassembly` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_challenge`
--

INSERT INTO `tbl_challenge` (`id`, `challenge_name`, `challenge_image`, `challenge_startdate`, `challenge_enddate`, `location`, `description`, `product_name1`, `product_image1`, `product_amount1`, `productconversion1`, `delivary_date1`, `product_name2`, `product_image2`, `product_amount2`, `productconversion2`, `delivary_date2`, `product_name3`, `product_image3`, `product_amount3`, `productconversion3`, `delivary_date3`, `sponsorproductid1`, `sponsorproductid2`, `sponsorproductid3`, `sponsorproductid4`, `sponsorproductid5`, `rate1`, `rate2`, `rate3`, `rate4`, `rate5`, `unit`, `status`, `showdistrictandassembly`) VALUES
(1, 'Biriyani Challenge', 'Dashboard.jpg', '2024-07-01', '2026-08-16', 'kadappadi,Malappuram,Kerala 676122', 'കൈകോർക്കാം നമുക്ക്\r\nപാവപ്പെട്ട കിഡ്നി രോഗികൾക്കായ് !\r\n\r\nപ്രിയപ്പെട്ടവരേ....\r\n\r\nഷെയ്ഡ് പൂക്കോയ തങ്ങൾ ഡയാലിസിസ് സെൻ്റർ സോഫ്റ്റ് ലോഞ്ചിംഗ് കഴിഞ്ഞ് രോഗികളെ പ്രവേശിപ്പിച്ച് തുടങ്ങിയിരിക്കുകയാണ്. സൗജന്യ ഡയാലിസിസ് പ്രക്രിയ മുന്നോട്ട് കൊണ്ടുപോകുന്നതിന്  ഇനിയും നിങ്ങളുടെയെല്ലാം സഹായങ്ങൾ ആവശ്യമാണ്. 2024 ആഗസ്റ്റ് 15 ന് ഷെയ്ഡ് നാലാമത് ബിരിയാണി ചലഞ്ച് സംഘടിപ്പിക്കുകയാണ്. നമ്മുടെ ഇഷ്ട ഭക്ഷണത്തോടൊപ്പം ഒരു രോഗിയെ എങ്കിലും നമുക്ക് ചേർത്ത് പിടിക്കാം!\r\nകഴിഞ്ഞ വർഷങ്ങളിൽ നമ്മൾ ഒരുമിച്ച് അവിസ്മരണീയമാക്കയതാണ്. ഇത്തവണയും പതിവ് തെറ്റാതെ കൂടെയുണ്ടാകുമെന്ന പ്രതീക്ഷയോടെ,\r\n\r\nടീം ഷെയ്ഡ് ചാരിറ്റി സെൽ, കാടപ്പടി', 'Chicken Biriyaani', 'Chicken Biryani.jpg', 1000, 1, '2024-05-20', 'Beef Biriyaani', 'KuttanBiryani.jpg', 10000, 10, '2024-05-21', '', '', 0, 1, '2024-05-22', 1, 2, 0, 0, 0, 3000.00, 200.00, 0.00, 0.00, 0.00, 'Packets', 0, 0);

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

--
-- Table structure for table `tbl_club`
--

CREATE TABLE `tbl_club` (
  `id` int NOT NULL,
  `club_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_club`
--

INSERT INTO `tbl_club` (`id`, `club_name`, `status`) VALUES
(1, 'OSCAR KAKKATHADAM9999', 0),
(2, 'ORUMA ALAKKAPARAMB', 0),
(3, 'msf k k padi', 0),
(4, 'farook college calicut', 0),
(5, 'FASAL SHADE ', 0),
(6, 'VYAPARI VYVASAYI PADIKKAL', 0),
(7, 'farook college kottakkal ', 0),
(8, 'P P T M COLLEGE CHERUR', 0),
(9, 'kamarudheen kadappadi', 0);

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

--
-- Table structure for table `tbl_customer`
--

CREATE TABLE `tbl_customer` (
  `id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `Address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `Mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `District` int NOT NULL DEFAULT '0',
  `Assembly` int NOT NULL DEFAULT '0',
  `Panchayat` int NOT NULL DEFAULT '0',
  `Ward` int NOT NULL DEFAULT '0',
  `Photo` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_customer`
--

INSERT INTO `tbl_customer` (`id`, `name`, `Address`, `Mobile`, `District`, `Assembly`, `Panchayat`, `Ward`, `Photo`) VALUES
(1, 'Faizal', '', '', 1, 1, 68, 1403, ''),
(2, 'fasal shade c/o', '', '7902498861', 1, 102, 123, 2315, ''),
(3, 'vyapari padikkal c/o', '', '', 1, 102, 123, 2315, ''),
(4, 'shukoor', '', '9947553324', 1, 102, 123, 2315, ''),
(5, 'shamil ap', '', '8547362136', 1, 102, 123, 2315, ''),
(6, 'Hussan kutty bapu', '', '', 1, 1, 68, 1403, ''),
(7, 'Kuttippa', '', '', 1, 1, 68, 1403, ''),
(8, 'Hassain PC', '', '', 1, 1, 68, 1403, ''),
(9, 'Gafoor kaku', '', '', 1, 1, 68, 1403, ''),
(10, 'Shareef', '', '', 1, 1, 68, 1403, ''),
(11, 'younus', '', '', 1, 1, 68, 1403, ''),
(12, 'Salam PC', '', '', 1, 1, 68, 1403, ''),
(13, 'Liyakhath ', '', '', 1, 1, 68, 1403, ''),
(14, 'Jaleel pc', '', '', 1, 1, 68, 1403, ''),
(15, 'Saidalavi kaka kolappuram', '', '', 1, 1, 68, 1403, ''),
(16, 'Rafi mannarcheeri', '', '', 1, 1, 68, 1403, ''),
(17, 'Davood mannarcheeri ', '', '', 1, 1, 68, 1403, ''),
(18, 'Mannarcheeri tharavad', '', '', 1, 1, 68, 1403, ''),
(19, 'Basheer kolappuram ', '', '', 1, 1, 68, 1403, ''),
(20, 'Salam PC', '', '', 1, 1, 68, 1403, ''),
(21, 'Muhammed Ali pc', '', '', 1, 1, 68, 1403, ''),
(22, 'Hameed chokly', '', '', 1, 1, 68, 1403, ''),
(23, 'Saidalavi malayil', '', '', 1, 1, 68, 1403, ''),
(24, 'Khader malayil', '', '', 1, 1, 68, 1403, ''),
(25, 'Fuvad PC', '', '', 1, 1, 68, 1403, ''),
(29, 'wa', 'yh', '9632587410', 1, 1, 68, 1392, ''),
(30, 'jwj', 'hh', '9632587410', 1, 1, 68, 1392, ''),
(31, 'fawas', '9746336033', '9746336033', 1, 1, 68, 1401, '');

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

--
-- Table structure for table `tbl_district`
--

CREATE TABLE `tbl_district` (
  `id` int NOT NULL,
  `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_district`
--

INSERT INTO `tbl_district` (`id`, `district_name`, `status`) VALUES
(1, 'Malappuram9', 0);

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

--
-- Table structure for table `tbl_panchayat`
--

CREATE TABLE `tbl_panchayat` (
  `id` int NOT NULL,
  `assembly_id` int NOT NULL DEFAULT '0',
  `panchayat_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_panchayat`
--

INSERT INTO `tbl_panchayat` (`id`, `assembly_id`, `panchayat_name`, `status`) VALUES
(1, 10, 'Abdu Rahiman Nagar8', 0),
(11, 1, 'Chelembra', 0),
(109, 9, 'Vazhakkad', 0),
(27, 10, 'Kannamangalam', 0),
(34, 9, 'Kondotty Muncipality', 0),
(36, 16, 'Kottakkal', 0),
(49, 1, 'Moonniyur', 0),
(61, 1, 'Pallikkal', 0),
(68, 1, 'Peruvallur', 0),
(85, 1, 'Thenhipalam', 0),
(123, 102, 'NA', 0),
(122, 16, 'Kottakkal Muncipality ', 0),
(121, 15, 'Perumanna klari', 0),
(120, 15, 'Edarikkode', 0),
(119, 15, 'Thennala', 0),
(93, 15, 'Tirurangadi muncipality', 0),
(118, 15, 'Nannambra', 0),
(97, 1, 'Vallikkunnu', 0),
(117, 15, 'Parappanagadi Muncipality', 0),
(116, 10, 'Othukkunagal', 0),
(115, 10, 'Parappur', 0),
(114, 10, 'Oorakam', 0),
(113, 9, 'Muthuvallur', 0),
(103, 10, 'Vengara', 0),
(112, 9, 'Cheekode', 0),
(111, 9, 'Cherukavu', 0),
(110, 9, 'Pulikkal ', 0),
(108, 9, 'Vazhayur ', 0);

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

--
-- Table structure for table `tbl_product`
--

CREATE TABLE `tbl_product` (
  `id` int NOT NULL,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_product`
--

INSERT INTO `tbl_product` (`id`, `product_name`, `amount`, `status`) VALUES
(1, 'Rice', 30000, 0),
(2, 'Chicken', 2000, 0);

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

--
-- Table structure for table `tbl_transaction`
--

CREATE TABLE `tbl_transaction` (
  `id` int NOT NULL,
  `donation` int NOT NULL DEFAULT '0',
  `sponsorship` int NOT NULL DEFAULT '0',
  `challengeid` int NOT NULL DEFAULT '0',
  `clubid` int NOT NULL DEFAULT '0',
  `hideidendity` int NOT NULL DEFAULT '0',
  `customerid` int NOT NULL DEFAULT '0',
  `orderforothers` int NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `dateadded` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Transid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `orderid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `Amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `Received` decimal(10,2) NOT NULL DEFAULT '0.00',
  `volunteer` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `uniquedid` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_Razor_payment_gateway` int NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_transaction`
--

INSERT INTO `tbl_transaction` (`id`, `donation`, `sponsorship`, `challengeid`, `clubid`, `hideidendity`, `customerid`, `orderforothers`, `name`, `address`, `mobile`, `dateadded`, `Transid`, `orderid`, `Amount`, `Received`, `volunteer`, `status`, `uniquedid`, `is_Razor_payment_gateway`) VALUES
(1, 0, 0, 1, 0, 0, 1, 0, '', '', '', '2025-08-08 11:09:50', '', '', 100.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(2, 0, 0, 1, 0, 0, 2, 0, '', '', '', '2025-08-09 08:50:55', '', '', 5000.00, 5000.00, 11, 0, 'b049d3e2f027453c1a7d8400473e0ec2c44f1895f150a8e1cbce78539f988230', 2),
(3, 0, 0, 1, 0, 0, 3, 0, '', '', '', '2025-08-09 08:57:00', '', '', 21000.00, 0.00, 12, 0, 'b049d3e2f027453c1a7d8400473e0ec2c44f1895f150a8e1cbce78539f988230', 2),
(4, 0, 0, 1, 0, 0, 4, 0, '', '', '', '2025-08-09 09:34:00', '', '', 30000.00, 30000.00, 13, 0, 'b049d3e2f027453c1a7d8400473e0ec2c44f1895f150a8e1cbce78539f988230', 2),
(5, 0, 0, 1, 0, 0, 5, 0, '', '', '', '2025-08-09 09:40:27', '', '', 500.00, 500.00, 9, 0, 'ea966bc09283b428aea23391fc32119a702c244f7e0e3efb4f3824f8c74d701b', 2),
(6, 0, 0, 1, 0, 0, 6, 0, '', '', '', '2025-08-10 08:42:02', '', '', 1000.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(7, 0, 0, 1, 0, 0, 7, 0, '', '', '', '2025-08-10 08:45:03', '', '', 600.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(8, 0, 0, 1, 0, 0, 8, 0, '', '', '', '2025-08-10 08:48:04', '', '', 400.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(9, 0, 0, 1, 0, 0, 9, 0, '', '', '', '2025-08-10 08:48:41', '', '', 300.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(10, 0, 0, 1, 0, 0, 10, 0, '', '', '', '2025-08-10 08:50:54', '', '', 600.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(11, 0, 0, 1, 0, 0, 11, 0, '', '', '', '2025-08-10 08:55:07', '', '', 200.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(12, 0, 0, 1, 0, 0, 12, 0, '', '', '', '2025-08-10 08:55:25', '', '', 200.00, 200.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(13, 0, 0, 1, 0, 0, 13, 0, '', '', '', '2025-08-10 08:55:43', '', '', 400.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(14, 0, 0, 1, 0, 0, 14, 0, '', '', '', '2025-08-10 09:10:22', '', '', 500.00, 500.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(15, 0, 0, 1, 0, 0, 15, 0, '', '', '', '2025-08-10 09:18:39', '', '', 500.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(16, 0, 0, 1, 0, 0, 16, 0, '', '', '', '2025-08-10 09:23:38', '', '', 300.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(17, 0, 0, 1, 0, 0, 17, 0, '', '', '', '2025-08-10 09:24:59', '', '', 400.00, 400.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(18, 0, 0, 1, 0, 0, 18, 0, '', '', '', '2025-08-10 09:26:43', '', '', 200.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(19, 0, 0, 1, 0, 0, 19, 0, '', '', '', '2025-08-10 09:36:05', '', '', 400.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(20, 0, 0, 1, 0, 0, 20, 0, '', '', '', '2025-08-10 09:39:59', '', '', 400.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(21, 0, 0, 1, 0, 0, 21, 0, '', '', '', '2025-08-10 09:42:48', '', '', 700.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(22, 0, 0, 1, 0, 0, 22, 0, '', '', '', '2025-08-10 10:05:22', '', '', 700.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(23, 0, 0, 1, 0, 0, 23, 0, '', '', '', '2025-08-10 20:24:46', '', '', 500.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(24, 0, 0, 1, 0, 0, 24, 0, '', '', '', '2025-08-10 20:25:02', '', '', 300.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(25, 0, 0, 1, 0, 0, 25, 0, '', '', '', '2025-08-12 13:54:02', '', '', 1200.00, 0.00, 4, 0, 'e31cde63c8b6222bf781ddb5b6064ce9f369b33fe4d93b043db0582fa3132e64', 2),
(29, 0, 0, 1, 0, 0, 29, 0, '', '', '', '2026-01-17 17:24:20', '', '570369229', 2100.00, 0.00, 0, 0, 'b44eeaaaa9060f091097a123a5cbec19d04c3c8ed61ef92ded019dcf3a2eb428', 2),
(30, 0, 1, 1, 0, 0, 30, 0, '', '', '', '2026-01-17 17:25:28', '', '200437030', 6400.00, 0.00, 0, 0, 'b44eeaaaa9060f091097a123a5cbec19d04c3c8ed61ef92ded019dcf3a2eb428', 2),
(31, 0, 0, 1, 0, 0, 31, 0, '', '', '', '2026-01-24 13:45:26', '', '647532631', 100.00, 0.00, 0, 0, '70f7d4fdd167782047a5e2811037de42199546fc51f2b7c471ee457bf71e5a80', 2);

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

--
-- Table structure for table `tbl_transactiondetails`
--

CREATE TABLE `tbl_transactiondetails` (
  `id` int NOT NULL,
  `hdrid` int NOT NULL DEFAULT '0',
  `item` int NOT NULL DEFAULT '0',
  `qty` int NOT NULL DEFAULT '0',
  `Totqty` int NOT NULL DEFAULT '0',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_transactiondetails`
--

INSERT INTO `tbl_transactiondetails` (`id`, `hdrid`, `item`, `qty`, `Totqty`, `rate`, `amount`) VALUES
(1, 1, 1, 1, 1, 100.00, 100.00),
(2, 2, 1, 50, 50, 100.00, 5000.00),
(3, 3, 1, 200, 200, 100.00, 20000.00),
(4, 3, 2, 1, 10, 1000.00, 1000.00),
(5, 4, 1, 300, 300, 100.00, 30000.00),
(6, 5, 1, 5, 5, 100.00, 500.00),
(7, 6, 1, 10, 10, 100.00, 1000.00),
(8, 7, 1, 6, 6, 100.00, 600.00),
(9, 8, 1, 4, 4, 100.00, 400.00),
(10, 9, 1, 3, 3, 100.00, 300.00),
(11, 10, 1, 6, 6, 100.00, 600.00),
(12, 11, 1, 2, 2, 100.00, 200.00),
(13, 12, 1, 2, 2, 100.00, 200.00),
(14, 13, 1, 4, 4, 100.00, 400.00),
(15, 14, 1, 5, 5, 100.00, 500.00),
(16, 15, 1, 5, 5, 100.00, 500.00),
(17, 16, 1, 3, 3, 100.00, 300.00),
(18, 17, 1, 4, 4, 100.00, 400.00),
(19, 18, 1, 2, 2, 100.00, 200.00),
(20, 19, 1, 4, 4, 100.00, 400.00),
(21, 20, 1, 4, 4, 100.00, 400.00),
(22, 21, 1, 7, 7, 100.00, 700.00),
(23, 22, 1, 7, 7, 100.00, 700.00),
(24, 23, 1, 5, 5, 100.00, 500.00),
(25, 24, 1, 3, 3, 100.00, 300.00),
(26, 25, 1, 12, 12, 100.00, 1200.00),
(32, 29, 2, 2, 20, 10000.00, 20000.00),
(31, 29, 1, 1, 1, 1000.00, 1000.00),
(33, 30, 1, 2, 2, 30000.00, 60000.00),
(34, 30, 2, 2, 2, 2000.00, 4000.00),
(35, 31, 1, 1, 1, 1000.00, 1000.00);

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE `tbl_user` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `user_type` int NOT NULL DEFAULT '0',
  `ward_id` int NOT NULL DEFAULT '0',
  `mobile` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '0',
  `clubid` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`id`, `name`, `username`, `password`, `user_type`, `ward_id`, `mobile`, `status`, `clubid`) VALUES
(1, 'Admin', 'admin', '4lApec45KtQ=', 1, 1, '8138010133', 0, 0),
(2, 'online', 'online', '4lApec45KtQ=', 1, 1, '8138010133', 0, 0),
(3, 'thoufeeq', '100003', 'pA12PZpsfZNqzA==', 2, 1399, '9567320776', 0, 0),
(4, 'faizal', '100004', 'tgRwMp1lNdY=', 2, 1403, '9809721612', 0, 0),
(5, 'jamsheeram ', '100005', 'ugR0O5RsfZBnnvmxCbQ=', 2, 1399, '9048911686', 0, 0),
(6, 'ahammadanafi', '100006', 'sQ14JZFofIMpnvL4Cbc=', 2, 1399, '9847652712', 0, 0),
(7, 'ayyoobac', '100007', 'sRxgJ5NreYFqyA==', 2, 1399, '9562707072', 0, 0),
(8, 'aflahpm', '100008', 'sQN1KZR5dc9/', 2, 1399, '8943141482', 0, 0),
(9, 'sabithpt', '100009', 'owR7IYhhaJZqxg==', 2, 2315, '7907940816', 0, 3),
(10, 'farookcollegecaicut', '1000010', 'tgRrJ5Nie40rk/H2QeIVBrZ64jMmCg==', 2, 2315, '8089139648', 0, 4),
(11, 'FASALSHADE', '1000011', 'liRKCbBaUKMDurmgFQ==', 2, 2315, '7902498861', 0, 5),
(12, 'mohdkutty', '1000012', 'vQpxLJd8bJY+0qWj', 2, 2315, '9895212029', 0, 6),
(13, 'pptmcollegecherur', '1000013', 'oBVtJZ9mdI4imPHyTOQGGqcipy0=', 2, 2315, '9947553324', 0, 8),
(14, 'kamarudheen', '1000014', 'uwR0KY58fIoimvq8FbU=', 2, 2315, '9447697417', 0, 9);

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

--
-- Table structure for table `tbl_ward`
--

CREATE TABLE `tbl_ward` (
  `id` int NOT NULL,
  `panchayat_id` int NOT NULL DEFAULT '0',
  `ward_name` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_ward`
--

INSERT INTO `tbl_ward` (`id`, `panchayat_id`, `ward_name`, `status`) VALUES
(1392, 68, '1 - VATTAPARAMBA', 0),
(1393, 68, '2 - CHATHRATHODI', 0),
(1394, 68, '3 - KAKKATHADAM', 0),
(1395, 68, '4 - KADAPPADI', 0),
(1396, 68, '5 - KARUVANKALLU', 0),
(1397, 68, '6 - NADUKKARA', 0),
(1398, 68, '7 - ILLATHUMADU', 0),
(1399, 68, '8 - SIDHEEQABAD', 0),
(1400, 68, '9 - PENGATTUKUNDU', 0),
(1401, 68, '10 - POTTAMMAL MADU', 0),
(1402, 68, '11 - KOLLAMCHINA', 0),
(1403, 68, '12 - NEDUMPALLIYALIL', 0),
(1404, 68, '13 - PARAMBIL PEEDIKA', 0),
(1405, 68, '14 - PARACHINAPURAYA', 0),
(1406, 68, '15 - CHENAKKAL', 0),
(1408, 68, '17 - KOOMANNA ', 0),
(1409, 68, '18 - SUPER BAZAR', 0),
(1410, 68, '19 - VALIYAPARAMB', 0),
(2310, 68, '21 - VADAKKEELMADU', 0),
(2309, 68, '20 - VARAPPARA', 0),
(2308, 68, '16 - PUVVATHUMADU', 0),
(2259, 68, 'PALAPETTIPARA-IRUMBANKUDUKK AREA', 0),
(2260, 68, 'SUPER BAZAR AREA', 0),
(2261, 68, 'VALIYA PARAMB AREA', 0),
(2262, 68, 'KOOMANNA CHINAKKAL AREA', 0),
(2263, 68, 'KARUVANKALLU AREA', 0),
(2283, 68, 'NADUKKARA AREA', 0),
(2285, 68, 'msf kadappadi unit', 0),
(2286, 68, 'LEAGUE HOUSE CHATHRATHODI', 0),
(2303, 68, 'MYL KOOMANNA VALIYAPARAMB', 0),
(2315, 123, 'NA', 0);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ca_receipt`
--
ALTER TABLE `ca_receipt`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_assembly`
--
ALTER TABLE `tbl_assembly`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT for table `tbl_challenge`
--
ALTER TABLE `tbl_challenge`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_club`
--
ALTER TABLE `tbl_club`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tbl_customer`
--
ALTER TABLE `tbl_customer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `tbl_district`
--
ALTER TABLE `tbl_district`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_panchayat`
--
ALTER TABLE `tbl_panchayat`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;

--
-- AUTO_INCREMENT for table `tbl_product`
--
ALTER TABLE `tbl_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_transaction`
--
ALTER TABLE `tbl_transaction`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `tbl_transactiondetails`
--
ALTER TABLE `tbl_transactiondetails`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `tbl_user`
--
ALTER TABLE `tbl_user`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_ward`
--
ALTER TABLE `tbl_ward`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2316;
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 */;