-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- 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_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_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_ward`
--
ALTER TABLE `tbl_ward`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2316;
COMMIT;

