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

START TRANSACTION;



--
-- Database: `ksca`
--

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

--
-- Table structure for table `add_expense`
--

CREATE TABLE `add_expense` (
  `id` int(11) NOT NULL,
  `expense_head_id` varchar(250) DEFAULT NULL,
  `name` varchar(250) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `amount` bigint(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `zone_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `club`
--

CREATE TABLE `club` (
  `id` int(11) NOT NULL,
  `clubname` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `secratery` varchar(255) DEFAULT NULL,
  `semail` varchar(255) DEFAULT NULL,
  `scontact` varchar(24) DEFAULT NULL,
  `password` varchar(355) DEFAULT NULL,
  `previous_division` varchar(255) DEFAULT NULL,
  `present_division` varchar(255) DEFAULT NULL,
  `zone_id` int(50) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_branch` varchar(255) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `account_no` varchar(255) DEFAULT NULL,
  `ifsc_code` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `category_id` int(50) DEFAULT NULL,
  `group_id` int(50) DEFAULT NULL,
  `tlocation` varchar(255) DEFAULT NULL,
  `plocation` varchar(255) DEFAULT NULL,
  `sphoto` varchar(255) DEFAULT NULL,
  `pname` varchar(255) DEFAULT NULL,
  `pphoto` varchar(255) DEFAULT NULL,
  `paddress` varchar(255) DEFAULT NULL,
  `pcontact` varchar(255) DEFAULT NULL,
  `pemail` varchar(255) DEFAULT NULL,
  `pan` varchar(255) DEFAULT NULL,
  `reset_password_key` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `club`
--

INSERT INTO `club` (`id`, `clubname`, `address`, `secratery`, `semail`, `scontact`, `password`, `previous_division`, `present_division`, `zone_id`, `bank_name`, `bank_branch`, `account_name`, `account_no`, `ifsc_code`, `logo`, `category_id`, `group_id`, `tlocation`, `plocation`, `sphoto`, `pname`, `pphoto`, `paddress`, `pcontact`, `pemail`, `pan`, `reset_password_key`, `status`) VALUES
(1, 'Galaxy Cricket Club', '# 361, Athmiya, LBS Nagar, Park Opposite, Shimoga - 577201', 'Yashwanth Kumar Nayak', 'info@webschedio.com', '9986809661', '3fc8d6a635d8b68523fbccd6262b44518e7515fa37bcf5ca0c5d4b21252963e12ce2d45d0bfd879117b83ee03961bf2ee140496820d9122b8c2fb8c3f30aa7b6MSNlaxcOGzYu75zsPQ88Se09G9KvGwcyh4QjNqYH/p4=', '1', '1', 1, 'Canara Bank ', 'S.M. Circle, Shimoga', 'Galaxy Cricket Club', '0524101042853', 'CNRB0000524', 'IMG-6399.JPG', 2, 1, 'Shimoga', 'NES College Campus, Shimoga', 'photo_(1).JPG', 'D S Arun', 'dsa_passport_photo3.jpg', 'Deepak Petrol Bunk, B H Road, Shimoga - 577201', '9019641307', 'jagadish.meghwal@webschedio.com', 'A12345678Z', '4dae91c8cf52478d4256e1fc3cd0da74', 1),
(6, 'Adarsha Cricket Club', 'J H Patel Complex, Nehru Road, Shimoga - 577201 ', 'Ramananda D N', 'ramananda.nandan@gmail.com', '9743163434', '73d90fd3fc2ef0b6b133b84be23050eaf8bd4f54f2ccaca98b27f02d7080ed7ea13a6663006babfa73844ad2ab0c7d53d6050d581088e94acbcafde265e2ba0fowdJU3XtMiWVM+B69rhoSRQyzU+aVQOvsHmqccEK6U8=', '1', '2', 1, 'XXXX', 'XXXXX', 'XXXXXX', 'XXXXXXX', 'XXXXXX', '', 1, 1, 'Shimoga', 'NES College Campus, Shimoga', '', 'Arun D S', '', 'Deepak Petrol Bunk, B H Road, Shimoga - 577201', '9845353867', 'adharshcc313@gmail.com', 'XXXXXXXX', NULL, 0),
(3, 'JNNCE Sports Club', 'Jawaharlal Nehru National College of Engineering, Savallanga Road, Navule, Shimoga - 577204', 'Chethan V', 'chetu01287@gmail.com', '9844520488', '84ee0bbb44b170bc883ca521ed8de12506ddc7650c648b92598e37b0ff7e6ddb157d0fe779dbb29293a8b49ac9fa6a9d5dcf7487f51b408c1ada329bb6d5c249aClY8d/7IXFQY/g6+WBW2v9/zckpDKgkr9KLsw+nGis=', '1', '1', 1, 'Canara Bank', 'Shivamogga JNNCE Campus', 'JNNCE Sports Club', '135210003149', 'CNRB0006322', '', 1, 1, 'Shimoga', 'JNNCE Stadium, Shimoga', '', 'Dr. H R Mahadevaswamy', '', 'Jawaharlal Nehru National College of Engineering, Savallanga Road, Navule, Shimoga - 577204', '7899478990', 'principal@jnnce.ac.in', 'AABAJ6774A', NULL, 0),
(4, 'Pranteeya Cricket Club', 'Nisarani, Kerekoppa, Ulavi Post, Soraba - 577434', 'Manjunath K L', 'rajeshml.mavinasara@gmail.com', '9449950902', '8c0f07b421d545f4404679fe7032cd4fb4c05279506d90e058e9e3f58eb9de71259849522c0c3460809a634970d9970c3f4567eadb58c5d80f6ec15899b4a737Qt+eLd8hNY0c/Ly240jvtxifUtCAv2xwf6UK5FZ0z9Q=', '2', '2', 1, 'Karnataka Bank Ltd', 'Sagar', 'Pranteeya Cricket Club', '7122500101386301', 'KARB0000712', '', NULL, 1, 'Nisarani', 'Padavagodu & Sagar', '', 'Subraya K L', 'chandan4.jpg', 'Nisarani, Kerekoppa, Ulavi Post, Soraba - 577434', '9448200121', 'pranteeyaccnisarani@gmail.com', '-', NULL, 1),
(5, 'Durgigudi Cricket Association', '# 62, D-10, B-14, Old Barline Road, Near Lakshminarasimha Stores, Shimoga - 577202', 'Subramanya K L', 'subramanyakl1954@gmail.com', '9886407485', '490606975823c9f448bc71a1688ae36f36f2df6a15c52d9cdb370ad81bb61b3af977801c2961123c78e8455884a1b17281bd59d2078a6f163a259742b16ee659LR6zGIofyQE/Cp/T/HAIpSXs+RQ/v+0YtUP04B56IHk=', '1', '1', 1, 'Canara Bank', 'Nehru Road Shimoga', 'Durgigudi Cricket Association', '0521101038553', 'CNRB0000521', '', NULL, 1, 'Shimoga', 'NES College Campus, Shimoga', '', 'Nagaraj D R', '', 'S/o Ranga Rao, Sree Srinivas Nilaya, 6th A Cross, Gandhi Nagar, Shimoga - 577201', '9844041806', 'jagadish@webschedio.com', '-', NULL, 1),
(7, 'Chikkamagalur Cricket Club', 'S/o Late Teja Lal Patel, Shivashakthi Timbers and Traders, Mudigere Road, Tegur Post, Chikkamagalur - 577101', 'Leeladhar T Patel ', 'ltpatel54360@gmail.com', '9448354360', 'ec8eadf8a65afde6c09bd484bb68a95c4f50e4954db626fcb02683e7625cebd8c78eeb6f12149e11e8425e241585ab4705517fd693d999f3ff77fa9e91e750ffoFi/65lWhoR4i/GEsdmYEZDBat61EaHO0Wg+bCtG6s8=', '1', '2', 1, 'ICICI Bank', 'Chickkamagalur', 'Chikkamagalur Cricket Club', '12345678910', 'ICIC000030', 'Capture1.PNG', 1, 1, 'Chikkamagaluru', '-', '', 'Dr. K R Krishna', '', 'New Mysore Clinic, Fort, Chikkamagaluru - 577101', '9448201994', 'ccc122@gmail.com', 'AYIPJ9252G', NULL, 1),
(8, 'Cricket Club of Sagar', '3rd Cross, Maya Bazaar, Subash Nagar, Sorab Road, Sagar - 577401', 'Narayan', 'sagar@ksbcl.com', '9449992727', '9c776d4bc02f82a9b0c53dd061abd7c399db5707939657b47d5a9910587c9c06f39644bdb00c8d667eaa251baf9f6de62c106b86fc890c28597491174f86a909cEZfylk8E242A6/AESkXrxiZQSkdm509QQCJcJ22GJU=', '2', '2', 1, '-', '-', '-', '-', '-', '', 1, 1, 'Sagar', 'Gopala Gowda Stadium, Sagar', '', 'Sridhar H L', '', 'Asst., Store Keeper, MESCOM, Sagar - 577401', '9880759820', 'ccs49@gmail.com', '-', NULL, 1),
(9, 'Dev Cricket Club', 'Officer, Office of Central Exise, HMT Bhavan, Bellary Road, Near Mekhri Circle, Bengaluru - 560032', 'Devaraj Patil', 'devrajpatil.st@gmail.com', '9886761284', 'd4e6af5943a5c1da5d5b9985693f9991b2490808d2c7e25bc6131e683b18f130178b45ef833fe5985b9043c1c77e87b79e0eda1aa62ecf61fcd06b22b5e72ab0cLZgqhCIZxwj7XVb7ixOndt2D/RCwvObB96fIl+Pxbk=', '2', '1', 1, '-', '-', '-', '-', '-', '', NULL, 1, 'Shimoga', '-', 'download.jpg', 'Manjunath M Kasetty', 'Untitled__.png', '# 902, 2nd Main, 4th Block, Rajaji Nagar, Bengaluru - 560010', '9886750884', 'manjunathkasetty@gmail.com', '-', NULL, 1),
(11, 'Cricketers Association of Hassan', 'Udaya Ravi, 3rd Cross, 2nd Stage, Sangameshwara Extension, Hassan - 573201', 'Dr. M. K. Ravishankar', 'mkravishankar@rediffmail.com', '9448459066', '42953ada0d1d71187a7eb65b28015eb66cd2f86860f4f4cfd084016a286e246f3f286fc48a8f7ea6f4cc677cff7488b6188e2ece7bbdb7872226578622664500B3Q4Lovr6RdzsejZu1PkRC6inK9+LIs/wWNFmyPCs5s=', '1', '1', 1, '-', '-', '-', '-', '-', '', 2, 1, 'Hassan', 'Government Science College, Hassan ', 'RS.png', 'Venkatesh T N', 'RS.png', '\"Karna Krupa\", Near Hoysala Hospital, Vishweshwaraiah Road, Hassan - 573201', '9448061388', 'venkatpalya@yahoo.com', '-', NULL, 1),
(12, 'Malnad Cricket Club', 'D.No. 277, Ashraya, Ashoka Road, Vidya Nagar, Near Land Army Office, Hassan - 573201', 'Ashok Kumar D', 'ashokkumarhassan@gmail.com', '9448653746', '99ea90ca2fe43fb3763f8f35bb4cd0fe58886d77dcf7e90f1761fc8789bd99caff01406ef6947de4fb67954b64550db7842729129c8622059ce3ced10ec6cd54jufk1UBihLlr38xM+bjy6iDkHMoH0lQWwyqcAlAL2jE=', '2', '2', 1, 'Vijaya Bank', '-', 'Malnad Cricket Club', '13390101000869', '-', '', 1, 1, 'Hassan', 'Government Science College, Hassan ', '', 'Dr. A Nagaraj', '', 'Swarnamba X Ray, Hotel Harsha Mahal Road, Hassan - 573201', '9448178661', 'nagaraj.swarnamba@gmail.com', '-', NULL, 1),
(13, 'Diamond Cricket Club', '\"Bharani\", 2nd Cross, Achutha Rao Layout, Shimoga - 577201', 'Sukumar Patel S S', 'sukumarpatel9@gmail.com', '9448139982', '21c38f00a60b6f53cba0ffb8fbd6b5b5dc2715f30103942acf5400894590d1dfd25fdc5d31ff06d9744bcf629febe3a8da6740ab23208231f0b94f01c660b85a1zPgPABEfUgQLOM5TzOA208FYW0opE8gvc9wXe7Tf/k=', '1', '1', 1, 'Syndicate Bank', 'Gandhi Nagar', 'Diamond Cricket Club', '19002200006193', 'SYND0001900', '', 1, 1, 'Shimoga', 'NES College Campus, Shimoga', 'FB_IMG_1514962289477.jpg', 'Rajendra Kamath', 'FB_IMG_1514962474195.jpg', '2nd Cross, Achutha Rao Layout, Shimoga - 577201', '9902191333', 'kamathgas@gmail.com ', '-', NULL, 1),
(14, 'Kalpatharu Cricket Club', 'S/o K S Gopalakrishna Gowda, Kagganagadde Balehonnur, B Kanabur, Balehonnur, NR Pura, Chikkamagaluru - 577112', 'Sahadev K G', 'sahadevkg@gmail.com', '9448869753', '32143f68ae3d79f8e2cb30d7649c34bbceb940ce2fa40e261e4adeb32ec981702be08cc5cf55308cbe66479411ce308f9a3c051102ea50e68950864570a0f10bL5n5qqUAIrHXah8EgJWCpVq2NS7z6CZacgkojafbJC0=', '2', '3', 1, '-', '-', '-', '-', '-', '', 3, 1, 'Balehonnur', '-', 'WhatsApp_Image_2018-01-03_at_1_45_59_PM.jpeg', 'Prasanna Kumar M S', 'WhatsApp_Image_2018-01-03_at_1_45_58_PM.jpeg', 'S/o M K Shivarame Gowda, \'Shivapoorna Nilaya\', Annapoorna Estate, Emmanahadlu, Adigebylu, Hiregadde, Chikkamagaluru - 577117', '9448665637', 'kcc13@gmail.com', '-', NULL, 1),
(15, 'McGann Cricket Club', 'M.I.G - 76, \"B\" Group, K.H.B.Colony, II Phase, Kallahalli, Vinobhanagar, Shimoga - 577202', 'Ravindra Kumar', 'savanmik@gmail.com', '9448238836', 'eb2b1ca9b53223c3573284bc04e4a81eda0f809165ad38efe1f607a74343a7e8b1b964b00b42aaf2dba7dc65d1bbd26dd61a4c7678f5ad1f39386dd9ca01d274E6ZuPq65Lqlltvc4BVZWV6iLi2J50lR9eRE0q0gAu3Y=', '3', '2', 1, '-', '-', '-', '-', '-', 'AIbEiAIAAABDCIii3Yqp4vH2BCILdmNhcmRfcGhvdG8qKDA3NzE2MDdmMjg3MmFkMWRmNDY0ZGFmNTI2MzE3Zjk1NDRiYjA1YTEwAc4kMiGihqiibo84WqULP9I0VAMg.jpg', 1, 1, 'Shimoga', '-', 'AIbEiAIAAABDCIii3Yqp4vH2BCILdmNhcmRfcGhvdG8qKDA3NzE2MDdmMjg3MmFkMWRmNDY0ZGFmNTI2MzE3Zjk1NDRiYjA1YTEwAc4kMiGihqiibo84WqULP9I0VAMg.jpg', '-', 'AIbEiAIAAABDCIii3Yqp4vH2BCILdmNhcmRfcGhvdG8qKDA3NzE2MDdmMjg3MmFkMWRmNDY0ZGFmNTI2MzE3Zjk1NDRiYjA1YTEwAc4kMiGihqiibo84WqULP9I0VAMg.jpg', '-', '8618073858', 'mcganncricketclub@gmail.com', '-', NULL, 1),
(17, 'Shimoga Cricket Club', 'Navale, Sowlanga Road, Shimoga - 577201', 'Mr. Chandan', 'jagadish@webschedio.com', '9741033817', '490606975823c9f448bc71a1688ae36f36f2df6a15c52d9cdb370ad81bb61b3af977801c2961123c78e8455884a1b17281bd59d2078a6f163a259742b16ee659LR6zGIofyQE/Cp/T/HAIpSXs+RQ/v+0YtUP04B56IHk=', '1', '1', 1, 'Canara Bank', 'Shimoga - 572201', 'Bharath Cricket Club', '6400356807', 'CNRB0000521', 'cricketclub2.png', 3, 1, 'Bhadravathi Road, Shimoga', 'NES College Campus, Shimoga - 577202', 'chandan2.jpg', 'Mr. Vinayak', 'dsa_passport_photo2.jpg', 'Shimoga', '9986809661', 'jagadish.meghwal@gmail.com', 'AA1235FR12', '4dae91c8cf52478d4256e1fc3cd0da74', 1),
(19, 'Rana Sports Club', 'C/o.Maruthi Auto Financiers, Market Road, Chikkamagalur - 577201', 'A. B. Sudarshan', 'suchitrasudhu@gmail.com', '9448277408', '697e168de1d70d5e685bb49e6723f96d8db1b0bf1663320710e6ee450e03271ea4cf1d4449bb6d3eb1125ab59acc794ea5654de441f60f355d31ce847ab898b58xzKJKobpA5l/uvcqkWvU9UyJPsACCx8WBZFhruOg7k=', '1', '1', 1, '-', '-', '-', '-', '-', 'RANA_CLUB-_JPG.jpg', 1, 1, 'Chikkamagaluru', 'District Ground Stadium, Chikkamagaluru', '', 'T Jayaprakash', '', 'No: 276/8, 6th \'A\' Cross, 15th Main, AMB Extension, Sadashivnagar, Bangalore - 577301 ', '9845911115', 'rsc47@gmail.com', '-', NULL, 1),
(20, 'Hemavathi Cricket Club', 'Sakaleshapura Coffee Supplies, Brahmin Street, Sakaleshapura - 573134', 'Sreekanth S V', 'sreekanthsv8@gmail.com', '9449692925', '00f2e855bd4622bad276cc7ab66677195ade55afbdd8339b5fd10601e664b041322bfa1700f4e12ef81e38118247999a49d7602bb635572a10bf667f20e0e2c6pZz2MoDnM0VTt1tktczOCLLCZpHEU6UCQuWonZe7fMA=', '2', '2', 1, '-', '-', '-', '-', '-', '', 1, 1, 'Sakaleshapura', '-', '', 'Vasudeva Sharma K S', '', 'Coffee Grower, No: 486, Laxmipuram Extn., Sakaleshapura - 573134', '9242412752', 'hemavathicc@gmail.com', '-', NULL, 1),
(22, 'Jagadish Cricket Club', 'Shivamogga - 577205', 'Mr. Chandan 01', 'jagadish@webchedio41.com', '8527413692', '890c74ef59be1520074291627c78fa3c387ed8937361dc9654ede5984043191ddde026249bb999c4f37ea7f816e9718596e44b6ff0f05d52ce9fd23a8c4c16fdsR2/DGDT2J456QKalsn8YSLkrH/9lIi5w12QlDnfzw4=', '1', '1', 1, NULL, NULL, NULL, NULL, NULL, 'cricketclub9.png', 1, 1, 'JNNC Ground', 'Bhadravathi', 'dsa_passport_photo27.jpg', 'Mr. Vinayak 1', 'chandan26.jpg', 'Shivamooga', '9966332255', 'vinayak@webschedio89.com', NULL, NULL, 1),
(23, 'lk;asdjf', 'aksdfj', 'af', 'jagadish@webschedioASDF1.com', '9741033818', '50b1170b50c72e644eb4dcef74b5a5e4da27fae501124e74c7d3143d8644bccf2df4194a9b48af80186ae4540af30ed2ed72db93131b0df4c9d7ea730f322c26gZEtx54OwZbCj4b2neDZbSobBJzjE3vwXMBchbRgpPY=', '1', '1', 1, NULL, NULL, NULL, NULL, NULL, 'dsa_passport_photo32.jpg', 1, 1, 'asdf', 'jkj', 'cricketclub14.png', 'asdf', 'chandan31.jpg', 'dfs', '131321564564', 'vinayak@webschedioasdfe.com', NULL, NULL, 1),
(24, 'Bharat Cricket Club', 'dfasdf', 'jkLKFJ', 'JKLJ@GM.AOCM', '0', '27852f3a36188d41847196eff8411f98d71f99986c163cc909b42099ce5170ff09cbcf0a6a9d9587fc6d182119f850de068d5c547b89fc9313f2ff344aabd4bfqNd6b93GtVJueMqwWlXTVjUq/pS8AlTswr5jn7pN9Ks=', '1', '1', 1, NULL, NULL, NULL, NULL, NULL, 'cricketclub15.png', 1, 1, 'hkhkj', 'jhkhjk', 'dsa_passport_photo33.jpg', 'asdf', 'chandan32.jpg', 'asdfjasdlkjf', '9019641307', 'asdf@asf.com', NULL, NULL, 1),
(25, 'dfdsafa', 'fasdf', 'asdf', 'sadd@asdfl.com', '0', '2febf1b221dd35cb0075dc85970c6a561ce961bbd2fd9270dd19c9d3fecce0d814acb1cb43a0e229946562b7b0c0070830589cd97e6e35af96ca29db4fb262aaXgEhWCdFNkbFVljB0TWdJrV40sb0xcm0XecnF7+zWts=', '1', '1', 1, 'icii', 'shimoga', 'shivamgi', '789456123456', 'icici302', 'dsa_passport_photo34.jpg', 0, 1, 'jkhkj', 'hjkh', 'Capture5.PNG', 'sdf', 'chandan33.jpg', 'asdfasdf', '7894561235', 'asdf@asfasdf.com', 'dasdf456123', NULL, 1);

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

--
-- Table structure for table `club_category`
--

CREATE TABLE `club_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `club_category`
--

INSERT INTO `club_category` (`id`, `name`) VALUES
(1, 'IM - Institutional Member'),
(2, 'IA - Institutional Affiliates'),
(3, 'TA - Temporary Affiliates');

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

--
-- Table structure for table `club_office`
--

CREATE TABLE `club_office` (
  `id` int(50) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `club_id` int(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cricket_group`
--

CREATE TABLE `cricket_group` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cricket_group`
--

INSERT INTO `cricket_group` (`id`, `name`) VALUES
(1, 'Group - I'),
(2, 'Group - II'),
(3, 'School'),
(4, 'College');

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

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

CREATE TABLE `expense` (
  `id` int(50) NOT NULL,
  `expense_head` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `zone_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `fixture`
--

CREATE TABLE `fixture` (
  `id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `team_a` varchar(255) DEFAULT NULL,
  `team_b` varchar(255) DEFAULT NULL,
  `scorer_name` varchar(255) DEFAULT NULL,
  `umpire_name` varchar(255) DEFAULT NULL,
  `stadium_name` varchar(255) DEFAULT NULL,
  `match_no` int(11) DEFAULT NULL,
  `zone_id` varchar(255) NOT NULL,
  `scorer_name2` varchar(255) DEFAULT NULL,
  `umpire_name2` varchar(255) DEFAULT NULL,
  `umpire_name3` varchar(255) DEFAULT NULL,
  `referee` varchar(255) DEFAULT NULL,
  `division_id` int(10) NOT NULL,
  `group_id` int(10) NOT NULL,
  `tournament_id` int(10) NOT NULL,
  `tournament_group_id` int(11) DEFAULT NULL,
  `day` int(10) NOT NULL,
  `max_m` int(10) NOT NULL,
  `assigned` int(5) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fixture`
--

INSERT INTO `fixture` (`id`, `date`, `team_a`, `team_b`, `scorer_name`, `umpire_name`, `stadium_name`, `match_no`, `zone_id`, `scorer_name2`, `umpire_name2`, `umpire_name3`, `referee`, `division_id`, `group_id`, `tournament_id`, `tournament_group_id`, `day`, `max_m`, `assigned`) VALUES
(865, '2021-01-11', '5', '9', '12', NULL, '14', 15, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 5, 3, 0),
(864, '2021-01-15', '11', '17', '12', NULL, '15', 14, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 5, 3, 0),
(863, '2021-01-14', '1', '13', '6', NULL, '13', 13, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 5, 3, 0),
(862, '2021-01-13', '11', '5', '12', NULL, '14', 12, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 4, 3, 0),
(861, '2021-01-12', '13', '9', '12', NULL, '10', 11, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 4, 3, 0),
(860, '2021-01-10', '1', '17', '12', NULL, '13', 10, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 4, 3, 0),
(859, '2021-01-09', '13', '11', '12', NULL, '12', 9, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 3, 3, 0),
(858, '2021-01-08', '17', '5', NULL, NULL, '12', 8, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 3, 3, 0),
(857, '2021-01-07', '1', '9', NULL, NULL, '14', 7, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 3, 3, 0),
(856, '2021-01-03', '17', '13', '12', NULL, '13', 6, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 2, 3, 0),
(855, '2021-01-06', '9', '11', NULL, '11', '12', 5, '1', NULL, '10', NULL, NULL, 1, 1, 45, NULL, 2, 3, 0),
(854, '2021-01-04', '1', '5', '12', '10', '10', 4, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 2, 3, 0),
(853, '2021-01-02', '9', '17', NULL, NULL, '15', 3, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 1, 3, 0),
(852, '2021-01-02', '5', '13', '13', NULL, '13', 2, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 1, 3, 0),
(850, '2021-01-06', '17', '13', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 44, 81, 3, 1, 0),
(851, '2021-01-02', '1', '11', NULL, '10', '10', 1, '1', NULL, NULL, NULL, NULL, 1, 1, 45, NULL, 1, 3, 0),
(849, '2021-01-03', '5', '13', NULL, '1', '10', 2, '1', NULL, '10', NULL, NULL, 1, 1, 44, 81, 2, 1, 0),
(847, '2021-01-07', '10', '3', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 44, 80, 3, 1, 0),
(848, '2021-01-02', '5', '17', '12', NULL, '14', 1, '1', NULL, '1', NULL, NULL, 1, 1, 44, 81, 1, 1, 0),
(846, '2021-01-05', '1', '3', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 45, 80, 2, 1, 0),
(844, NULL, '20', '15', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 61, 3, 1, 0),
(845, '2021-01-02', '1', '10', '6', '11', '12', 1, '1', NULL, NULL, NULL, NULL, 1, 1, 44, 80, 1, 1, 0),
(842, NULL, '12', '20', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 61, 1, 1, 0),
(843, NULL, '12', '15', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 61, 2, 1, 0),
(841, NULL, '7', '4', NULL, NULL, NULL, 6, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 60, 3, 2, 0),
(839, NULL, '8', '7', NULL, NULL, NULL, 4, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 60, 2, 2, 0),
(840, NULL, '6', '8', NULL, NULL, NULL, 5, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 60, 3, 2, 0),
(837, NULL, '4', '8', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 60, 1, 2, 0),
(838, NULL, '6', '4', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 60, 2, 2, 0),
(835, NULL, '19', '17', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 55, 3, 1, 0),
(836, NULL, '6', '7', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 2, 1, 21, 60, 1, 2, 0),
(834, NULL, '13', '17', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 55, 2, 1, 0),
(832, NULL, '11', '10', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 52, 3, 1, 0),
(833, NULL, '13', '19', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 55, 1, 1, 0),
(830, NULL, '9', '11', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 52, 1, 1, 0),
(831, NULL, '9', '10', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 52, 2, 1, 0),
(828, NULL, '1', '3', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 51, 2, 1, 0),
(829, NULL, '5', '3', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 51, 3, 1, 0),
(827, NULL, '1', '5', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 20, 51, 1, 1, 0),
(825, NULL, '3', '19', NULL, NULL, NULL, 35, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 9, 4, 0),
(826, NULL, '9', '10', NULL, NULL, NULL, 36, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 9, 4, 0),
(824, NULL, '11', '17', NULL, NULL, NULL, 34, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 9, 4, 0),
(822, NULL, '5', '9', NULL, NULL, NULL, 32, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 8, 4, 0),
(823, NULL, '1', '13', NULL, NULL, NULL, 33, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 9, 4, 0),
(821, NULL, '3', '10', NULL, NULL, NULL, 31, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 8, 4, 0),
(819, NULL, '1', '17', NULL, NULL, NULL, 29, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 8, 4, 0),
(820, NULL, '13', '19', NULL, NULL, NULL, 30, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 8, 4, 0),
(818, NULL, '3', '5', NULL, NULL, NULL, 28, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 7, 4, 0),
(816, NULL, '13', '10', NULL, NULL, NULL, 26, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 7, 4, 0),
(817, NULL, '11', '9', NULL, NULL, NULL, 27, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 7, 4, 0),
(814, NULL, '11', '3', NULL, NULL, NULL, 24, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 6, 4, 0),
(815, NULL, '1', '19', NULL, NULL, NULL, 25, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 7, 4, 0),
(813, NULL, '13', '5', NULL, NULL, NULL, 23, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 6, 4, 0),
(811, NULL, '19', '10', NULL, NULL, NULL, 21, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 6, 4, 0),
(812, NULL, '17', '9', NULL, NULL, NULL, 22, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 6, 4, 0),
(810, NULL, '13', '11', NULL, NULL, NULL, 20, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 5, 4, 0),
(808, NULL, '19', '5', NULL, NULL, NULL, 18, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 5, 4, 0),
(809, NULL, '17', '3', NULL, NULL, NULL, 19, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 5, 4, 0),
(807, NULL, '1', '10', NULL, NULL, NULL, 17, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 5, 4, 0),
(805, NULL, '19', '11', NULL, NULL, NULL, 15, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 4, 4, 0),
(806, NULL, '17', '13', NULL, NULL, NULL, 16, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 4, 4, 0),
(804, NULL, '10', '5', NULL, NULL, NULL, 14, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 4, 4, 0),
(802, NULL, '19', '17', NULL, NULL, NULL, 12, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 3, 4, 0),
(803, NULL, '1', '9', NULL, NULL, NULL, 13, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 4, 4, 0),
(801, NULL, '10', '11', NULL, NULL, NULL, 11, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 3, 4, 0),
(799, NULL, '1', '5', NULL, NULL, NULL, 9, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 3, 4, 0),
(800, NULL, '9', '3', NULL, NULL, NULL, 10, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 3, 4, 0),
(773, NULL, '1', '17', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 45, 1, 1, 0),
(774, NULL, '1', '13', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 45, 2, 1, 0),
(775, NULL, '17', '13', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 45, 3, 1, 0),
(776, NULL, '3', '19', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 46, 1, 1, 0),
(777, NULL, '3', '5', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 46, 2, 1, 0),
(778, NULL, '19', '5', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 46, 3, 1, 0),
(779, NULL, '9', '11', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 47, 1, 1, 0),
(780, NULL, '9', '10', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 47, 2, 1, 0),
(781, NULL, '11', '10', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 12, 47, 3, 1, 0),
(782, NULL, '1', '5', NULL, '1', NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 48, 1, 1, 0),
(783, NULL, '1', '3', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 48, 2, 1, 0),
(784, NULL, '5', '3', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 48, 3, 1, 0),
(785, NULL, '9', '11', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 49, 1, 1, 0),
(786, NULL, '9', '10', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 49, 2, 1, 0),
(787, NULL, '11', '10', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 49, 3, 1, 0),
(788, NULL, '13', '19', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 50, 1, 1, 0),
(789, NULL, '13', '17', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 50, 2, 1, 0),
(790, NULL, '19', '17', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 30, 50, 3, 1, 0),
(791, NULL, '1', '11', NULL, NULL, NULL, 1, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 1, 4, 0),
(792, NULL, '3', '13', NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 1, 4, 0),
(793, NULL, '5', '17', NULL, NULL, NULL, 3, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 1, 4, 0),
(794, NULL, '9', '19', NULL, NULL, NULL, 4, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 1, 4, 0),
(795, NULL, '1', '3', NULL, NULL, NULL, 5, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 2, 4, 0),
(796, NULL, '5', '11', NULL, NULL, NULL, 6, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 2, 4, 0),
(797, NULL, '9', '13', NULL, NULL, NULL, 7, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 2, 4, 0),
(798, NULL, '10', '17', NULL, NULL, NULL, 8, '1', NULL, NULL, NULL, NULL, 1, 1, 24, NULL, 2, 4, 0);

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

--
-- Table structure for table `group_divisions`
--

CREATE TABLE `group_divisions` (
  `id` int(50) NOT NULL,
  `divison_name` varchar(255) DEFAULT NULL,
  `group_id` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `group_divisions`
--

INSERT INTO `group_divisions` (`id`, `divison_name`, `group_id`) VALUES
(1, 'Division - I', 2),
(2, 'Division - II', 3),
(3, 'Division - III', 3),
(4, 'Division - IV', 2),
(5, 'Division - V', 1),
(6, 'Age Group', 1),
(7, 'Non-Affiliate', 1);

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

--
-- Table structure for table `main_user`
--

CREATE TABLE `main_user` (
  `id` int(10) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `main_user`
--

INSERT INTO `main_user` (`id`, `username`, `password`, `email`, `contact`) VALUES
(1, 'admin', 'admin', 'admin@admin.com', '1234567890');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(10) NOT NULL,
  `match_id` int(10) NOT NULL DEFAULT 0,
  `scorer_id` int(10) DEFAULT 0,
  `umpire_id` int(10) DEFAULT 0,
  `referee_id` int(10) DEFAULT 0,
  `tournament_id` int(10) NOT NULL DEFAULT 0,
  `reason` text DEFAULT NULL,
  `zone_id` int(10) DEFAULT NULL,
  `notified` int(2) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `match_id`, `scorer_id`, `umpire_id`, `referee_id`, `tournament_id`, `reason`, `zone_id`, `notified`) VALUES
(34, 857, 12, 0, 0, 45, 'Not well', 1, 1),
(33, 855, 12, 0, 0, 45, 'Personal work again', 1, 1),
(30, 850, 12, 0, 0, 44, 'Friend wedding on this day', 1, 1),
(32, 847, 12, 0, 0, 44, 'Personal Work', 1, 1),
(31, 846, 12, 0, 0, 44, 'I will be out of station', 1, 1),
(35, 858, 12, 0, 0, 45, 'Friend wedding on this day', 1, 1),
(36, 857, 0, 10, 0, 45, 'I will be out of station', 1, 1);

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

--
-- Table structure for table `pachievements`
--

CREATE TABLE `pachievements` (
  `achievement_id` int(50) NOT NULL,
  `player_id` int(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `description` varchar(3500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `players`
--

CREATE TABLE `players` (
  `id` int(11) NOT NULL,
  `name` varchar(60) NOT NULL,
  `display_name` varchar(25) NOT NULL,
  `email` varchar(65) NOT NULL,
  `password` varchar(500) NOT NULL,
  `season` varchar(10) NOT NULL,
  `gender` varchar(8) NOT NULL,
  `father_name` varchar(100) NOT NULL,
  `father_mobile` bigint(11) NOT NULL,
  `mother_name` varchar(60) NOT NULL,
  `mother_mobile` varchar(255) DEFAULT NULL,
  `gaurdian_name` varchar(255) DEFAULT NULL,
  `gaurdian_mobile` varchar(255) DEFAULT NULL,
  `bowling_style_right` varchar(255) DEFAULT 'None',
  `bowling_style_type` varchar(20) NOT NULL,
  `permanent_address` varchar(255) DEFAULT NULL,
  `domicile_address` varchar(255) NOT NULL,
  `proficiency` varchar(20) NOT NULL,
  `wicket_keeper` tinyint(4) NOT NULL,
  `batting_style` varchar(15) NOT NULL,
  `primary_season` varchar(255) DEFAULT NULL,
  `primary_zone_id` int(3) NOT NULL,
  `primary_club_name_id` int(3) NOT NULL,
  `previous_season` varchar(255) DEFAULT NULL,
  `previous_zone_id` varchar(255) DEFAULT NULL,
  `contact` bigint(11) NOT NULL,
  `dob` date NOT NULL,
  `bowling_style` varchar(25) NOT NULL DEFAULT 'None',
  `previous_club_name_id` varchar(255) DEFAULT NULL,
  `valid_id_card` varchar(255) NOT NULL,
  `age_proof` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `secondary_zone_id` varchar(255) DEFAULT NULL,
  `secondary_club_id` varchar(255) DEFAULT NULL,
  `approved` tinyint(10) NOT NULL DEFAULT 0,
  `zone_approve` int(11) NOT NULL DEFAULT 0,
  `secondary_approval` tinyint(1) NOT NULL DEFAULT 0,
  `transfer_club_id` varchar(255) DEFAULT NULL,
  `transfer_zone_id` varchar(255) DEFAULT NULL,
  `transfer_in_approval` tinyint(1) NOT NULL DEFAULT 0,
  `transfer_out_approval` tinyint(1) NOT NULL DEFAULT 0,
  `qualification` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `college` varchar(255) DEFAULT NULL,
  `occupation` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_ac_name` varchar(255) DEFAULT NULL,
  `bank_ac_no` varchar(255) DEFAULT NULL,
  `bank_ifsc` varchar(255) DEFAULT NULL,
  `bank_branch` varchar(255) DEFAULT NULL,
  `uid_no` varchar(255) NOT NULL,
  `adhaar` varchar(255) DEFAULT NULL,
  `reset_password_key` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `players`
--

INSERT INTO `players` (`id`, `name`, `display_name`, `email`, `password`, `season`, `gender`, `father_name`, `father_mobile`, `mother_name`, `mother_mobile`, `gaurdian_name`, `gaurdian_mobile`, `bowling_style_right`, `bowling_style_type`, `permanent_address`, `domicile_address`, `proficiency`, `wicket_keeper`, `batting_style`, `primary_season`, `primary_zone_id`, `primary_club_name_id`, `previous_season`, `previous_zone_id`, `contact`, `dob`, `bowling_style`, `previous_club_name_id`, `valid_id_card`, `age_proof`, `photo`, `secondary_zone_id`, `secondary_club_id`, `approved`, `zone_approve`, `secondary_approval`, `transfer_club_id`, `transfer_zone_id`, `transfer_in_approval`, `transfer_out_approval`, `qualification`, `school`, `college`, `occupation`, `bank_name`, `bank_ac_name`, `bank_ac_no`, `bank_ifsc`, `bank_branch`, `uid_no`, `adhaar`, `reset_password_key`) VALUES
(1, 'Chandan V', 'Chandan', 'scorerchandan@gmail.com', '208ac37ed3e5cb9e15f9ca431bbfeceb997aef55221982aaa3ed6ae6f26e629de7a7ffaa45f94123a36b13fe32816aafdd7cc78de8297acfe5591a8397a95793Piv7DzmQyhqpM9HlVejhl9FW62WObQn2xkz8sa0lrKU=', '2017-18', 'Male', 'Venugopal', 9141559914, 'Saraswathi', '', 'Yashwanth Kumar Nayak', '', 'None', 'None', '# DWC 117/A, Hutta Colony, Bhadravathi - 577301', '# DWC 117/A, Hutta Colony, Bhadravathi - 577301', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 1, NULL, '1', 9741033817, '1992-02-05', 'Right Arm Fast Medium', '1', 'Aadhar_Card1.pdf', '', 'Happpy_birthday_chandu_20170503_1844111.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'BBM', 'Paper Town High School, Bhadravathi', 'Sahyadri College, Shimoga', 'Business', 'State Bank of India', 'Chandan V', '64006356807', 'SBIN0040241', 'Paper Town', '2018SM1001', '866747517709', '7573311d1e685b5d374dd6ff793bfce4'),
(5, 'HARISH V', 'HARISH', 'pranteeyaccnisarani@gmail.com', '9166ce59dc17cfc2cf0538f68670e395e78ef4da39cc69296c2562bf6c8a2a1929275eba011eb901f6e258ad5f32f3c3d57b94b2cb6659a3a78a62e5a07cef0fkriuvULB8IhPmLmlI56K+osrjMDBa/xV7jJ3EMPBTfc=', '2017-18', 'Male', 'GEETHA', 0, 'GEETHA', '', '', '', 'None', 'None', 'chipli,varadamoola road sagara-577401', 'chipli,varadamoola road sagara-577401', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 4, NULL, '1', 9964517956, '1985-01-01', 'Right Arm Off Spin', '4', 'scan0023.jpg', '', 'scan0022.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'PUC', 'GHS SN NAGARA SAGAR', '', 'Employee', '', '', '', '', '', '2018SM1005', '', NULL),
(4, 'Ranjan v', 'Ranjan vijayakumar', 'Ranjanranju0000@gmail.com', 'fce3dabb5e2a6f36860fece6d6ad014cc33ffd57e1510346f89bfe24cf363253ec9f130a9c34f0710ae4dd3669bb2ee3880e864924701ece9b57c8ee081fdcdd04RqhO5HAta99gbplSFJFHJIjqbGXD+r8qiksnvE2y4=', '2017-18', 'Male', 'Vijayakumar s', 9686373614, 'Jayanthi v', '9901372626', 'Kiran kumar', '', 'None', 'None', 'No.103 1st stage 1st cross vinobhanagar shimoga', 'No.103 1st stage 1st cross vinobhanagar shimoga', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 6, NULL, '1', 9964057221, '1994-09-09', 'Right Arm Fast Medium', '6', 'IMG_4965.JPG', '', 'IMG_1495.JPG', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'Bcom', 'Dca high school', 'Atncc ', 'Employee', 'Icici ', 'Sb', '231601522365', 'Icic000009', 'Bangalore', '2018SM1002', '239887191812', NULL),
(6, 'RAJESHA M L', 'RAJESH', 'rajeshml.mavinasara@gmail.com', 'f7d72ba2bece13d9c8165755111256344883f0915a502ad4d9b0d8326d169d067cc40d3193c70f3c800a840190f97baa30c3245821e89ae5f7b1f5a61e631116d0wec+yc1I9gLCdr9JCc8dr6o/qcQTCMqd+n1B/kzTc=', '2017-18', 'Male', 'LAKSHMINARAYANA', 9482860902, 'GAYATHRI M L', '9482860902', '', '', 'None', 'None', 'MAVINASARA HONNESARA POST SAGAR TALUK-577417', 'MAVINASARA HONNESARA POST SAGAR TALUK-577417', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 5, NULL, '1', 9449950902, '1988-11-13', 'Right Arm Off Spin', '4', 'scan0035.jpg', '', 'scan0034.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'DIPLOMA', 'VSHS KEDALASARA', 'SMP COLLEGE SAGARA', 'Employee', '', '', '', '', '', '2018SM1006', '262596965123', NULL),
(7, 'SAVINAYA M S', 'SAVINAYA', 'savimalve@gmail.com', '2a905a35d5b65498bc5380e3713bcde2d36455f5399363c8d36cc6775c7962e0c193c8766dede281806c3e07cb955a1c4f708ab56f62b81dfcb273621590f43dJ2XwCNhf6X2+TGUB5SX0zajpaWLNhlzre9McVzSkX9c=', '2017-18', 'Male', 'SATHISH KUMAR L', 0, 'VIDYA', '', '', '', 'None', 'None', 'MALWE HANDIGODU POST SAGAR TALUK 577401', 'MALWE HANDIGODU POST SAGAR TALUK 577401', 'Batsman', 0, 'Right-Hand', NULL, 1, 5, NULL, '1', 9535771787, '1991-06-04', 'Right Arm Off Spin', '4', 'SaviAdhar.pdf', '', 'Passport.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'DEGREE', 'PRAGATHO COMPOSITE HIGH SCHOOL SAGARA', 'LB COLLEGE SAGARA', 'Student', '', '', '', '', '', '2018SM1007', '328333188886', NULL),
(8, 'SANTHOSH KUMAR N', 'SANTHOSH', 'POWERVM.KUMAR@gmail.com', '5eea0caf3d3212c3ce38ca4d1cb8622d6e0c00aeaab84efce67d94bef7ec693740c3a209e51ff5a6aaecc87a343fa2567c0f928cc3879dfd718a17e778e76309I+6Mm31KqYtSeemIv88Hr7MwTtGoAcK+YHQ1w8Yve3A=', '2017-18', 'Male', 'NARAYANASWAMY T V', 0, 'BHAGEERATHI', '', '', '', 'None', 'None', 'VIJAYANAGARA SAGAR', 'VIJAYANAGARA SAGAR', 'Bowler', 0, 'Right-Hand', NULL, 1, 5, NULL, '1', 9448781307, '1981-05-30', 'Right Arm Fast Medium', '4', 'IMG-20180103-WA0031.jpg', '', 'IMG-20180103-WA0030.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'PUC', 'MGN PAI HIGH SCHOOL', 'LB COLLEGE SAGARA', 'Unemployed', '', '', '', '', '', '2018SM1008', '', NULL),
(10, 'dhilip chandrashekar', 'Dhilchan', 'dhilip1v1dm@gmail.com', '8cb10fb193aa2db3a7ae058099c65ce79cba4fffebc4d050bd79fa7d0025abf6de24c753b8ac25fb159029441ea12c769c698dfada1fd05528192986d9c9308dFEq6RIz3rQTXxvJb4b1Gl5AYW8Gxz4w5DUXN8Fn4IuI=', '2017-18', 'Male', 'P Chandrasekhar', 9538956385, 'Sarah\'s devi', '9739286789', '', '', 'None', 'None', 'No 9 8th D Cross\r\n3rd Main Venkatapura kormangala', 'No 9 8th D Cross\r\n3rd Main Venkatapura kormangala', 'Bowler', 0, 'Right-Hand', NULL, 1, 10, NULL, '1', 9538956385, '1993-10-26', 'Right Arm Fast Medium', '10', '', '', '', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'B.com', 'Christ', '', 'Employee', 'Icici bank', 'Savings bank', '316801000444', 'Icic0003168', 'Hsr layout', '2018SM1009', '888123144026', NULL),
(11, 'Mani CE', 'Mani CE', 'Manice012@gmail.com', '7b0ed89b0a8a23c483f1bb900735b0c4e3952645ebd40c3faf60c9ec78ad80eb37891da90e5df7f398f880c02a0381d441524a1a2ff360a63ce9d6761f88f495f0S110GJdWwsl7Et/qGjAvcS/9yZl3cHWYF8GJAmiSw=', '2017-18', 'Male', 'C. G. Eshwarappa ', 9916791176, 'Jayalashmma. M', '8310904747', 'Mani CE', '8431795155', 'None', 'None', 'D No 06 Muniyappa Budling, Hongasandra, Begur main road, Bangalore -560068', 'D No 06 Muniyappa Budling, Hongasandra, Begur main road, Bangalore -560068', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 1, NULL, '1', 8431795155, '1998-03-05', 'Right Arm Fast Medium', '1', '1515258455026356240507.jpg', '', 'IMG_20171231_212553.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'Diploma ', 'G. H. S Begur ', 'Oxford college ', 'Student', 'Kotak Mahindra Bank ', '9411988433', '9411988433', '8049', 'Ulsoor Branch ', '2018SM1011', '525293969115', NULL),
(12, 'Roshan kumar Bastia', 'Roshan kumar Bastia', 'rk020398@gmail.com', '327fdb1691e58196be8a64f4f2cf764d3492a3a9c257b72199e3c5bae3b86b64bba73ae063a7b934703b71442a3969bcad97067dc4da789d53f7c3a10d9fdc1csM3XB7bRofuDhdq+GBSCTKC00hg6JQuMdifwamCvfco=', '2017-18', 'Male', 'subhash bastia', 0, 'rita devi', '7259912960', '', '', 'None', 'None', 'qno 483 west nepalgate churcha colliery , koriya ,chhattisgarh(497339)', '#607 aecs layout b block singasndra,bangalore(560068)', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 17, NULL, '3', 7000203780, '1998-01-02', 'Right Arm Fast Medium', '15', '1515258455026356240507.jpg', '', 'BHUSA.jpg', '3', '14', 1, 1, 0, '11', '2', 0, 0, '12th pass', 'kendriya vidyalaya, baikunthpur,chhattisgarh', 'jain university,bangalore', 'Student', 'state bank of india', 'roshan kumar bastia', '20312903432', 'SBIN006792', 'churcha', '2018SM1012', '947333023092', NULL),
(13, 'Prabhuswamy.HD', 'Prabhu', 'PrabhudarlingN17@gmail.com', '2c620ccb61ca3b9a3e852ab0c811226dad09cbc989c8ab1eb21766712cefc0acca615f4e186d4cee40947eb4f8853fca78ba878ba65c93bef18a1c5d5536d903gcU4j44Bz9PPkVJT1hgD6WB7Baukh4d/vqvSLnbxdgI=', '2017-18', 'Male', 'Late Devukumar HS', 0, 'Vijayalakhmi KM', '9035822149', '', '', 'None', 'None', 'GK college Road Jaraganahalli.near metro station, Bangalore south Bangalore', 'Haroshivanahalli(v) uyyamballi (Ho)Kanakapura(Tq) Ramanagara(Dist) Bangalore Rural', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 1, NULL, '1', 9945620149, '1995-11-17', 'Right Arm Fast', '1', 'IMG-20170818-WA0006.jpg', '', 'IMG-20170818-WA0006.jpg', NULL, NULL, 2, 0, 0, NULL, NULL, 0, 0, 'B.com', 'GHS uyyamballi', 'Rural college Kanakapura', 'Employee', 'Karnataka', 'Savings bank account', '4402500100976601', 'KARB0000440', 'Kanakapura branch', '2018SM1013', '936613818370', NULL),
(21, 'Jagadish B', 'Jagadish', 'jagadish.meghwal@gmail.com', '490606975823c9f448bc71a1688ae36f36f2df6a15c52d9cdb370ad81bb61b3af977801c2961123c78e8455884a1b17281bd59d2078a6f163a259742b16ee659LR6zGIofyQE/Cp/T/HAIpSXs+RQ/v+0YtUP04B56IHk=', '2017-18', 'Male', 'Bhawarlal', 9018641307, 'Mangi Devi', '9018641307', '', '', 'None', 'None', 'Basaveshwara Nagar, Shimoga', 'Basaveshwara Nagar, Shimoga', 'Bowler', 0, 'Left-Hand', NULL, 1, 17, NULL, '1', 9980980038, '1988-10-19', 'Left Arm Orthodox', '17', 'id1.jpg', '', 'jagadish1.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'B.E', 'Max Muller High School', 'JSS College of Engineering', 'Business', 'Vijaya Bank', 'Jagadish', '45678907654', 'VIJ897765', 'Shimoga', '2018SM1021', '3456 7890 5643', '7f92565897ca8b366b8977238799785f'),
(19, 'Sachin', 'Shet', 'sachinrevankar999@gmail.com', '35f45818ff5ea7dc0b137395e50c1cff1d8320679a93c229071b8ed82d7efcfcf71e272ecf8f954848808d089f1f0c7bc962b0d3ba740775abab5a51404a34815WVxOgZLdPLDX4FIMkSa5M1vAZdObCfv5Ksbt+H1zNs=', '2017-18', 'Male', 'Venkatesh Shet', 9980395039, 'Prameela Shet', '9980395039', '', '', 'None', 'None', 'LBS Nagar, Shimoga', 'LBS Nagar, Shimoga', 'Batsman', 0, 'Right-Hand', NULL, 1, 17, NULL, '1', 9980395039, '1992-08-06', 'Right Arm Off Spin', '1', 'card.jpg', '', 'sachin.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'B.E', 'Saandeepini English High School', 'JNNCE Shimoga', 'Business', 'SBI', 'Sachin V', '44870985656', 'SBINOOOOO6', 'Shimoga', '2018SM1014', '5678 9876 9534', 'a774fa2759c8b54d369d5b0ac961ccc1'),
(20, 'Vinayaka', 'Vinay', 'vinayakaanvekar98@gmail.com', '35f45818ff5ea7dc0b137395e50c1cff1d8320679a93c229071b8ed82d7efcfcf71e272ecf8f954848808d089f1f0c7bc962b0d3ba740775abab5a51404a34815WVxOgZLdPLDX4FIMkSa5M1vAZdObCfv5Ksbt+H1zNs=', '2017-18', 'Male', 'RAMESH SHET', 9986809661, 'Gulabi', '9980980038', '', '', 'None', 'None', 'LBS Nagar, Shimoga', 'LBS Nagar, Shimoga', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 17, NULL, '1', 9986809661, '1990-03-01', 'Right Arm Fast Medium', '17', 'id.jpg', '', 'vinayaka1.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'B.E', 'Sadana Vidya Kendra', 'East West Institute of Technology', 'Business', 'SBI ', 'Vinayaka', '45678499887', 'sbi00007', 'Shimoga', '2018SM1020', '8796 7896 6543', NULL),
(22, 'Anil Shetty', 'Anil', 'anilsagar7@gmail.com', '35f45818ff5ea7dc0b137395e50c1cff1d8320679a93c229071b8ed82d7efcfcf71e272ecf8f954848808d089f1f0c7bc962b0d3ba740775abab5a51404a34815WVxOgZLdPLDX4FIMkSa5M1vAZdObCfv5Ksbt+H1zNs=', '2017-18', 'Male', 'Shekar Shetty', 9742573991, 'Jayanthi', '9742573991', '', '', 'None', 'None', 'Anandapura, Shimoga District', 'Anandapura, Shimoga District', 'Batsman', 0, 'Right-Hand', NULL, 1, 17, NULL, '1', 9742573991, '1989-05-17', 'Right Arm Fast Medium', '17', 'id2.jpg', '', 'anil.jpg', NULL, NULL, 2, 0, 0, NULL, NULL, 0, 0, 'M.B.A', 'Jnanashyadhri School', 'JSS College', 'Business', 'Corporation ', 'Anil', '5671234789', 'CORP00008', 'Shimoga', '2018SM1022', '7896 5463 7685', NULL),
(23, 'Sanjeev Harikant', 'Sanjeev', 'sanjeev@gmail.com', '35f45818ff5ea7dc0b137395e50c1cff1d8320679a93c229071b8ed82d7efcfcf71e272ecf8f954848808d089f1f0c7bc962b0d3ba740775abab5a51404a34815WVxOgZLdPLDX4FIMkSa5M1vAZdObCfv5Ksbt+H1zNs=', '2017-18', 'Male', 'S N Harikant', 9738485895, 'Geetha', '9738485895', '', '', 'None', 'None', 'Vinobha Nagar, Shimoga', 'Vinobha Nagar, Shimoga', 'Batsman', 0, 'Right-Hand', NULL, 1, 17, NULL, '1', 9738485895, '1989-05-01', 'Right Arm Leg Spin', '17', 'id3.jpg', '', 'sanjeev.jpg', NULL, NULL, 2, 0, 0, NULL, NULL, 0, 0, 'M.B.A', 'Kumta High School', 'Bapuji Institute of Management', 'Business', 'SBI', 'Sanjeev', '678954321', 'SBI000098', 'Shimoga', '2018SM1023', '4567 8976 7865', NULL),
(24, 'Harish', 'Harish', 'siva@sportsmechanics.in', 'baa6f146196096472258eb2a41fb5b7e76ea9b2d5422dfa02acce21294795d33365f49c90ef79435b77c554098a91d08a9702979e8d0d6786a47510d10d44225pQRLVLxOdfFlk8zcl880p0j1JHzTQCQBpuE8pCmWLCA=', '2018-19', 'Male', 'Vijay', 0, 'Girija', '', '', '', 'None', 'None', 'Bangalore', 'Bangalore', 'Batsman', 0, 'Right-Hand', NULL, 1, 17, NULL, '1', 9940089022, '1989-09-25', 'Right Arm Fast Medium', '17', 'competitive-exams-courses-500x500.png', '', 'post12.jpg', NULL, NULL, 1, 1, 0, NULL, NULL, 0, 0, 'PUC', 'Vidya High School', '', 'Student', '', '', '', '', '', '2018SM1024', '77888965520', NULL),
(25, 'Shrikant swaroop BN', 'Shrikant swaroop BN', 'shrikantbn186@gmail.com', '624701253bd32029e76b671ea01343891cf55a67c6197294816b076c403f04067395db5084553a39759bbeb5c677ccdda59e77a9b3cbfee83cad16f4b2acd938Xmy9yqS+uUPkCxTUBKDuQHXIqN1tt+EkWSysLLewVVg=', '2017-18', 'Male', 'BP NATARAJ', 7760051587, 'Sudha G', '9611466062', '', '', 'None', 'None', '#209,karugal Street, birur 577116', '#209,karugal Street, birur 577116', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 7, NULL, '1', 9739299192, '1998-04-06', 'Right Arm Fast', '7', 'New_Doc_2018-06-29_11.jpg', '', 'New_Doc_2018-06-27_11.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, '10+2 and above', 'Kramuka high school ', 'Sri Aurobindo (Ind) pre university college, shimoga', 'Student', 'Karnataka Bank Pvt.Ltd', 'Savings Bank ', '9252500101109501', 'KARB0000925', 'Birur', '2018SM1025', '292803021251', NULL),
(26, 'PATHAPATI AKHILESH', 'AKHIL', 'akhileshbabupathpati@gmail.com', '6c813c37073a24a55c616b6a317d8196d4bb5dca89f34daa96086ab2b8840b403e324286305da392941f4d53acf7da3ebfe631937e290287f7cf608a94cabf3evjPPAlpyau/4WXuNc3aBfkZsozPuO0gLuv7ubHFSVnI=', '2018-19', 'Male', 'PATHAPATI AKHILESH', 9492010903, 'PATHAPATI ANASUYA', '8985148703', 'MEDA DIVYA', '9494285915', 'None', 'None', 'MACHILIPATNAM KRISHNA DISTRICT ANDHRAPRADESH', 'TAVISIPUDI MANGINAPUDIPOST', 'All-Rounder', 0, 'Left-Hand', NULL, 1, 1, NULL, '0', 9490010903, '1992-02-08', 'Right Arm Fast Medium', '', 'aadhaar.jpg', '', '3522k.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'DIPLOMA IN CIVIL ENGINEERING', 'ZPH SCHOOL TVISIPUDI', 'SVLP COLLEGE MACHILIPATNAM', 'Unemployed', 'STAEBANK OF INDIA', 'PATHAPATI AKHILESH', '20157552067', 'SBIN000874', 'LAXMITALKIES BRANCH MACHILIPATNAM', '2018SM1026', '317210607068', NULL),
(27, 'Prakash Shetty', 'Prakash Shetty', 'prakashshetty5@hotmail.com', '0c1fce4081ad768015998d91d033e3c2c2a9aca2544c1e366b2bf6327411821f880cf3df54875da297d1371ff0547076eab05023427bf9cfdce427ebec87efe79xUDUnGatspIEFDvVoa92JjbhHDk3zzoMLNoEeyJY/I=', '2018-19', 'Male', 'Maranna Shetty', 0, 'Sheela Shetty', '', '', '', 'None', 'None', 'Madhya Kullanaglu house , madhya post & village , Mangalore', 'E-302, ajmera infinity , Electronic city ', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 1, NULL, '2', 9920290672, '1985-04-05', 'Right Arm Fast Medium', NULL, 'AADHAR_CARD2.jpg', '', 'Prakash_0012.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'Diploma Engineering ', 'Vidhyandheeni', '', 'Employee', 'ICICI', 'Prakash Shetty', '000201675345', 'ICIC0000002', 'commissariat road, karnataka ,Bangalore - 560025', '2018SM1027', '802169520595', NULL),
(28, 'NITU ROY', 'NITU ROY', 'nituroy9613@gmail.com', '854abb95082afc877e0919a4a61482d0ce04b2bc368274b38fd30b75e49b45d8b74215bd5b56aed8bfb54ec643ca25080bff650793ce3f6f0323063003d1bd2dhzsqbnxSi36LmYlw/F57CkLubnNfZ4xd4ZVaOTIg358=', '2017-18', 'Male', 'NIRMAL ROY', 8812877181, 'HIMANI ROY', '9401453313', 'NIRMAL ROY', '8812877181', 'None', 'None', 'VILL - BERATUK P.O - ANIPUR P.S - RATABARI DIST - KARIMGANJ (ASSAM) PIN - 788734', 'VILL - BERATUK P.O - ANIPUR P.S - RATABARI DIST - KARIMGANJ (ASSAM) PIN - 788734', 'Batsman', 0, 'Left-Hand', NULL, 1, 10, NULL, '1', 9401187947, '1999-08-09', 'Right Arm Leg Spin', '17', '272.jpg', '', 'Photo_1_15_MB_JPG2.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'H.S PASSED', 'RAM KRISHNA VIDYAPITH H.S SCHOOL', 'RAM KRISHNA NAGAR COLLEGE', 'Student', 'YES BANK', 'NITU ROY', '70070079546500', 'YESB0CMSNOC', 'BENGALURE', '2018SM1028', '590573938320', NULL),
(29, 'j', 'w', 'd', '567e1870259d0a02eb02739c295a4ee9298f05be03fd9835cc794d5d8199494b1258ea3d3357d958d9e20f91be5ef90523869f4b028fd7e53462fd6fb5403cfaTOXigVmfP9kYxTeMIqgIRl9QZgj91ZY+Uw1gILJTnIk=', '2017-18', 'Male', 'a', 0, 'a', 'a', 'a', 'a', 'None', 'None', 'a', 'sa', 'All-Rounder', 0, 'Right-Hand', NULL, 1, 6, NULL, '1', 2, '2019-09-26', 'Right Arm Leg Spin', '6', 'cat_sketch1.jpg', '', 'cat_sketch.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'a', 'a', 'a', 'Student', 'a', 'a', 'a', 'a', 'a', '2018SM1029', 'a', NULL),
(30, 'Tejas R', 'Tejas R', 'lakshmiraghu313@gmail.com', '97c3d24e63da3e1c264b728beb68d4c2f6a65f6e8eac8bff015639ad3247a3321e324b04f6388d6230dd561a613746f613686bbf811e0f5e0907dde2f596d53blycq72nYs1tywcDDJPAS0WaIbUFbkP3ynMpj/6LsHgw=', '2017-18', 'Male', 'AV Raghavendra', 7204459788, 'V Lakshmi', '9945278256', 'Harikiran BM', '7259298095', 'None', 'None', '#41,1st main road, subbanna garden, vijaynagar, Bangalore 560040', '#41,1st main road, subbanna garden, vijaynagar, Bangalore 560040', 'Batsman', 0, 'Right-Hand', NULL, 1, 1, NULL, '2', 7204459788, '2000-10-29', 'Right-Arm', NULL, 'IMG-20200806-WA00052.jpg', '', 'IMG-20200806-WA0007~22.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, '3rd BE Civil Engineer', 'Vasavi Vidya Peeta', 'Jnana Vikas Institute of Technology', 'Student', 'Canara bank', 'Tejas R', '1146101937017', 'CNRB0001146', 'Vijaynagar', '2018SM1030', '661221618278', NULL),
(31, 'Ganesh Chattrad', 'G N chhatrada', 'ganeshnc555@gmail.com', '5a968a0da2ddabbb5eb09891cecab91ba7936946768c0e2ddc3924d3dbc22d83d8b373f6c8f34e6b0f012d3a45c827a1ffca9eea83321ea5424c451715636be21PiRfNe2NSrsRx85GLc/J6BNZnpHDU2vLccmjmIUzLo=', '2018-19', 'Male', 'Neelappa', 9972024313, 'Puttavva', '+918088571369', 'G N Chhatrada', '+918088571369', 'None', 'None', 'Agadi\r\nPlat', 'Agadi\r\nPlat', 'Bowler', 0, 'Right-Hand', NULL, 1, 7, NULL, '1', 8088571369, '2003-04-20', 'Right Arm Fast', '17', '1599367487237570900326.jpg', '', '1599367384428508353542.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, '1st puc', 'H P S byagawadi', 'K L I College', 'Student', 'Ganesh  N Chatrada', 'GANESH.N.CHATRAD NEELAPP N', '89042070669', 'KVGB0007105', 'KUSANUR', '2018SM1031', '491120152635', NULL),
(32, 'Sukhpreet Singh Gill', 'Sukhpreet Singh', 'sukhpreetsinghgill12@gmail.com', '7422dce840cd04dacd414c7961cfde9699bc84eb88677260af40a7565054e2d02d958068f2f3164fd544020112ca42c34a2b38075ea78d6ed2491af120f707f8H6rQWZg+4inWhwuQl41jzeMK6DRH3IpDmAp1xVJTNa0=', '2018-19', 'Male', 'Roop Singh', 916280424224, 'Supinder Kaur', '+91 96203 19846', '', '', 'None', 'None', '175, Gulmohar Trends, Dhakoli,Zirakpur,Punjab ', '175, Gulmohar Trends, Dhakoli,Zirakpur,Punjab ', 'Batsman', 0, 'Right-Hand', NULL, 1, 17, NULL, '1', 918872907742, '2000-11-01', 'Right Arm Fast', '17', '75032DC3-1FAF-4EC8-A5A9-22644131F21C2.jpeg', '', 'E604DE82-DFBF-4478-9534-ED53F3241D8F2.jpeg', NULL, NULL, 2, 0, 0, NULL, NULL, 0, 0, 'Student', 'DAV Sn Secondary Lahore', '', 'Student', 'Punjab National Bank', 'Sukhpreet Singh', '5126522024145659', '', 'PNB Zirakpur', '2018SM1032', '475723595331', '5646c5342b7089ed608f21425d226230'),
(33, 'sukhpreet', 'sukhpreet singh', 'sukhpreetgill0308@gmail.com', '8ac62fc5578f7f03a5bd2481e56c0505869f392252ddfefaf0ab08c7388a340f197d1eafdcad382f9d57988b96d7e22e9b80113650b4063f40f2241c5ca6d34b+3D6oDrrW6RBik6q10OUf0T2mTV9jWuLsC1sKdbjJ78=', '2018-19', 'Male', 'roop singh', 8872907742, 'supinder kaur', '6280424224', '', '', 'None', 'None', '175 gulmohar trends dhakoli zirakpur  Punjab ', '175 gulmohar trends dhakoli zirakpur', 'Batsman', 0, 'Right-Hand', NULL, 1, 1, NULL, '1', 8872907742, '2000-11-01', 'Right Arm Fast', '1', 'IMG-20201003-WA0021.jpg', '', 'IMG-20201003-WA0007.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'student', 'dav senior secondary school chandigarg', '', 'Student', 'punjab national bank', 'sukhpreet singh', '617000150007931', 'PUNB0617000 ', 'dhakoli', '2018SM1033', '475723595331', '1d82433be0f1cdd861766af841df1cc6'),
(34, 'Honakerappa Baxappanavar', 'Honakerappa', 'honakerappab103@gmail.com', '698543ce1cb30a63cb01183f0fffa140ba2c526d859a12dced4ffc033c7fdd5b52968dabb20ccd7fcd2f9f4955b917c5ae109590278277d72c18ef33ec56b11dO2B2/rdb0of3CyT5V7zdyRCkAIJneQRi0KpjKanL3sg=', '2017-18', 'Male', 'siddappa', 8431694943, 'mariyavva', '', '', '', 'None', 'None', 'at post bagewadi. tq mundaragi', 'S/o siddappa baxappanavar\r\nat post bagewadi. tq mundaragi', 'Bowler', 0, 'Right-Hand', NULL, 1, 14, NULL, '1', 8660636967, '1995-10-16', 'Right Arm Leg Spin', '10', 'Screenshot_20201026-233542.png', '', 'photo1.jpg', NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 'engineer', 'ssbps bagewadi', '', 'Employee', 'IDFC FIRST BANK', 'Honakerappa Baxappanavar', '10058198170', 'IDFB0080151', 'Bangalore ', '2018SM1034', '899825675329', 'd871bd4f43fa4af636eb505e7435e7e1'),
(35, 'Jagadish Scorer', 'Jaggu', 'jagadish@autosnehitchitradurga.com', 'fe1308d87de7b90ae5b384344ee0cc48397ebe899f8c63fc9b24f91f229d6e457392a8c7e8b77748b6dcb4e3ddeec3f15dbee180ffaf9078418837ad115dcbf8Hf1JAo6hnIIb1aUAjcPnjLFulrX/VLkJsIw65wpVsNw=', '', 'on', 'Subhash', 4678945613, 'xx', NULL, '', NULL, 'None', 'None', '', 'll', 'All-Rounder', 0, 'Left-Hand', NULL, 1, 4, NULL, NULL, 7984561322, '2007-02-08', 'Left-Arm', NULL, 'Capture18.PNG', 'autosnehi13.PNG', 'dsa_passport_photo15.jpg', '', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021SM1035', '436545380470', NULL),
(36, 'Jagadish Scorer', 'Keshav', 'jagadish@autosnehitchitradurga55.com', '53c4eea59db5ae52c2c2a2966ab9d5f6e296a30e5d451d4a0549956d4bb631ce26c49b8f8e3e8f166d7f43f2bb7f5778ffff44ec7b2b5ba3cdc2e97938921052Bh9Yj2tsaasntDDKf1gK4+yRXSCtReFgx2GFIiahaC4=', '4', 'Male', 'Subhash', 4678945613, 'Muniyamma', NULL, '', NULL, 'None', 'Medium', '', 'kl', 'Bowler', 0, 'Left-Hand', NULL, 1, 17, NULL, NULL, 7984561356, '2020-12-28', 'Left-Arm', NULL, 'dsa_passport_photo22.jpg', 'chandan21.jpg', 'cricketclub4.png', '', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021SM1036', '436545380470', NULL),
(37, 'Jagadish Scorer', 'Keshav', 'jagadish@autosnehitchitradurga85.com', '752addf2366d6b0a1e29285217ce8c5576a419cc8feadf472849a282de363ffdd82f1a5eb34d45684d9fc2ce31210176d4579a6b8ecfebed7a6f4c8977639c57Da6Mkve0mCk5Xc6q+fRvpEs5DiOxtHcFd8ui8rUHFsk=', '4', 'Male', 'Subhash', 4678945613, 'Muniyamma', NULL, '', NULL, 'None', 'Medium', '', 'kl', 'Bowler', 0, 'Left-Hand', NULL, 1, 1, NULL, NULL, 7984561353, '2020-12-28', 'Left-Arm', NULL, 'dsa_passport_photo23.jpg', 'chandan22.jpg', 'cricketclub5.png', '', NULL, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021SM1037', '436545380470', NULL);

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

--
-- Table structure for table `rachievements`
--

CREATE TABLE `rachievements` (
  `achievement_id` int(50) NOT NULL,
  `referee_id` int(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `description` varchar(3500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `referee`
--

CREATE TABLE `referee` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `mobile` bigint(12) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `father_name` varchar(255) DEFAULT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `age` varchar(255) DEFAULT NULL,
  `age_proof` varchar(255) DEFAULT NULL,
  `residence_no` varchar(255) DEFAULT NULL,
  `office_no` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `mtofoncommitment` varchar(255) DEFAULT NULL,
  `mtofoccassionally` varchar(255) DEFAULT NULL,
  `ssgeneral` varchar(255) DEFAULT NULL,
  `registration_type` varchar(255) DEFAULT NULL,
  `club_name_id` int(50) DEFAULT NULL,
  `cgroup` varchar(255) DEFAULT NULL,
  `division` varchar(255) DEFAULT NULL,
  `zone_id` int(50) DEFAULT NULL,
  `qfksca` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_ac_name` varchar(255) DEFAULT NULL,
  `bank_ac_no` varchar(255) DEFAULT NULL,
  `bank_ifsc` varchar(255) DEFAULT NULL,
  `bank_branch` varchar(255) DEFAULT NULL,
  `uid_registration` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `college` varchar(255) DEFAULT NULL,
  `occupation` varchar(255) DEFAULT NULL,
  `pan` varchar(255) DEFAULT NULL,
  `adhaar` varchar(255) DEFAULT NULL,
  `reset_password_key` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `referee`
--

INSERT INTO `referee` (`id`, `name`, `display_name`, `email`, `password`, `address`, `mobile`, `photo`, `father_name`, `dob`, `age`, `age_proof`, `residence_no`, `office_no`, `qualification`, `mtofoncommitment`, `mtofoccassionally`, `ssgeneral`, `registration_type`, `club_name_id`, `cgroup`, `division`, `zone_id`, `qfksca`, `bank_name`, `bank_ac_name`, `bank_ac_no`, `bank_ifsc`, `bank_branch`, `uid_registration`, `gender`, `college`, `occupation`, `pan`, `adhaar`, `reset_password_key`) VALUES
(7, 'Preetham', 'Preetham', 'sachinrevankar999@gmail.com', '5179c017ff7166458e91caddb0238747dc9e4ae803c5b9664c00643b8637194797199543e1d305d169ad4651b3837f97e5a370c58738507cf68a770c0f6b1dfaWgbhj7uDAQo6tOtPUJYekPRAexJI4WIWQpoFMXGQZZI=', 'Sagara, Shimoga Karnataka', 9980395039, 'chandan1.jpg', 'Manjunath', '1986-12-18', '33', 'id9.jpg', '9980305039', '9980395039', 'B.E', 'No', 'No', 'No', 'Renewal', NULL, NULL, NULL, 1, '2020-01-01', 'ICICI', 'Pretham', '245345777456', 'ICICI0000005', 'Sagara', 'nRruXq', 'Male', 'PES College of Engineering', 'Business', 'AWSER54623', '7645 3456 9876', '2cc380034cbd8ac14301cf8a163782da'),
(9, 'Gagan', 'Gagan', 'vinayakaanvekar98@gmail.com', '5179c017ff7166458e91caddb0238747dc9e4ae803c5b9664c00643b8637194797199543e1d305d169ad4651b3837f97e5a370c58738507cf68a770c0f6b1dfaWgbhj7uDAQo6tOtPUJYekPRAexJI4WIWQpoFMXGQZZI=', 'Gopala, Shimoga', 9986809661, 'anil1.jpg', 'Shiva', '1988-12-08', '29', 'card2.jpg', '9986809661', '9986809661', 'B.E', 'Yes', 'Yes', 'Yes', 'Renewal', NULL, NULL, NULL, 1, '2017-08-19', 'Federal Bank', 'Gagan', '5678423678', 'FED000657', 'Shimoga', 'BeG3mf', 'Male', 'JNNCE, Shimoga', 'Test Engineer', 'GHTYI34567', '9894 2634 6754', NULL),
(10, 'Abhishek', 'Abhishek', 'jagadish.meghwal@gmail.com', '490606975823c9f448bc71a1688ae36f36f2df6a15c52d9cdb370ad81bb61b3af977801c2961123c78e8455884a1b17281bd59d2078a6f163a259742b16ee659LR6zGIofyQE/Cp/T/HAIpSXs+RQ/v+0YtUP04B56IHk=', 'Ravindra Nagar, Shimoga', 9019641307, 'jagadish4.jpg', 'Pramod', '1988-07-08', '29', 'id10.jpg', '9019641307', '9019641307', 'B.E', 'Yes', 'Yes', 'Yes', 'Renewal', NULL, NULL, NULL, 1, '2017-05-20', 'SBI', 'Abhishek', '6785935678', 'SBI000067', 'Shimoga', 'Af9sxH', 'Male', 'PES College of Engineering', 'Tester', 'EDRU67467', '4356 7895 6789', NULL),
(11, 'Manmohan', 'Man', 'manmohan@gmai.com', 'f1f18c9f9ca01f0a964a261dc15a2546be49a92a067610dbdce59380e5063b009f5efd7d78fd58e7b54173a349037e261401310f53dc7027e0ef2aa305938f39VrregNGvNWu3CpLykPHDhUzEppxVxrawFxyMNIOVqZc=', 'Savalanga Road, Shiomoga, Karnataka - 577201', 9972385086, 'geography2.jpg', 'Laxman', '1988-02-05', '32', 'img21.jpg', '8529637412', '2589631472', 'BA', 'Yes', 'Yes', 'Yes', 'Renewal', NULL, NULL, NULL, 1, '2008-02-05', 'SBBJ', 'Manmohan', '25361478952', 'PNB0001', 'Kota', 'GXeT3w', 'Male', 'GTU', 'Teacher', 'AYIPJ9252B', '4365453804788', NULL);

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

--
-- Table structure for table `referee_accept`
--

CREATE TABLE `referee_accept` (
  `id` int(11) NOT NULL,
  `match_id` int(10) NOT NULL,
  `referee_id` int(10) NOT NULL,
  `tournament_id` int(10) NOT NULL,
  `acceptance` int(5) NOT NULL,
  `reason` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report_gallery`
--

CREATE TABLE `report_gallery` (
  `id` int(11) NOT NULL,
  `report_id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `video` varchar(800) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `report_gallery`
--

INSERT INTO `report_gallery` (`id`, `report_id`, `image`, `video`, `created_by`, `created_at`) VALUES
(1, 35, 'autosnehi1.PNG', NULL, 1, '2021-01-28'),
(2, 35, 'Capture.PNG', NULL, 1, '2021-01-28'),
(3, 35, 'Capture1.PNG', NULL, 1, '2021-01-28'),
(4, 35, 'chandan.jpg', NULL, 1, '2021-01-28'),
(5, 35, 'cricketclub.png', NULL, 1, '2021-01-28'),
(6, 35, 'dsa_passport_photo.jpg', NULL, 1, '2021-01-28'),
(7, 35, NULL, 'https://studio.youtube.coam/video/f6vc5qBTkxI/edit', 1, '2021-01-28'),
(8, 36, 'Capture2.PNG', NULL, 1, '2021-01-28'),
(9, 36, 'j1.PNG', NULL, 1, '2021-01-28'),
(10, 36, NULL, 'https://studio.youtube.coam/video/f6vc5qBTkxI/edit', 1, '2021-01-28'),
(11, 43, 'Capture3.PNG', NULL, 1, '2021-02-25'),
(12, 43, 'Capture11.PNG', NULL, 1, '2021-02-25'),
(13, 43, 'cricketclub1.png', NULL, 1, '2021-02-25'),
(14, 43, 'dsa_passport_photo1.jpg', NULL, 1, '2021-02-25'),
(15, 43, NULL, 'dfas', 1, '2021-02-25');

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

--
-- Table structure for table `sachievements`
--

CREATE TABLE `sachievements` (
  `achievement_id` int(50) NOT NULL,
  `scorer_id` int(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `description` varchar(3500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `scorers`
--

CREATE TABLE `scorers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `mobile` bigint(12) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `age_proof` varchar(255) NOT NULL,
  `address_proof` varchar(200) NOT NULL,
  `residence_no` varchar(255) DEFAULT NULL,
  `office_no` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) NOT NULL,
  `mtofoncommitment` varchar(255) NOT NULL,
  `mtofoccassionally` varchar(255) NOT NULL,
  `ssgeneral` varchar(255) NOT NULL,
  `registration_type` varchar(255) NOT NULL,
  `club_name_id` int(50) DEFAULT NULL,
  `cgroup` varchar(255) DEFAULT NULL,
  `division` varchar(255) DEFAULT NULL,
  `zone_id` varchar(255) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_ac_name` varchar(255) NOT NULL,
  `bank_ac_no` varchar(255) NOT NULL,
  `bank_ifsc` varchar(255) NOT NULL,
  `bank_branch` varchar(255) NOT NULL,
  `uid_registration` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `representative_cricket` text NOT NULL,
  `pan` varchar(255) DEFAULT NULL,
  `adhaar` varchar(255) DEFAULT NULL,
  `reset_password_key` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `scorers`
--

INSERT INTO `scorers` (`id`, `name`, `display_name`, `email`, `password`, `address`, `mobile`, `photo`, `father_name`, `dob`, `age_proof`, `address_proof`, `residence_no`, `office_no`, `qualification`, `mtofoncommitment`, `mtofoccassionally`, `ssgeneral`, `registration_type`, `club_name_id`, `cgroup`, `division`, `zone_id`, `bank_name`, `bank_ac_name`, `bank_ac_no`, `bank_ifsc`, `bank_branch`, `uid_registration`, `gender`, `representative_cricket`, `pan`, `adhaar`, `reset_password_key`, `status`) VALUES
(11, 'Shankar', 'Shankar', 'vinayakaanvekar98@gmail.com', 'a265d55e8db46354295116ff6f33a3ea494e44d9a9767694c28d3bf4a7be0953c878fefacef420323a6a06c054561da6c23b06231e6f6681274fd4f3cac96d0286sxRuy6KCg941DUgLf8fjQSvvkpgDMshwV1Jfnf0To=', 'Ravindra Nagar, Shimoga', 9986809661, 'vinayaka2.jpg', 'Ramesh', '1990-03-01', 'id4.jpg', '', '08182 222345', '08182 233456', 'B.E', 'Yes', 'No', 'Yes', 'Fresh', NULL, NULL, NULL, '1', 'Vijaya Bank', 'Shankar', '76548796', 'VIJ897765', 'Shimoga', '5btFsT', 'Male', 'East West College of Engineering', 'ASWE3456', '5467 8769 0987', NULL, 1),
(6, 'Neeraj Kubsad', 'Neeraj', 'sachinrevankar9999@gmail.com', 'a265d55e8db46354295116ff6f33a3ea494e44d9a9767694c28d3bf4a7be0953c878fefacef420323a6a06c054561da6c23b06231e6f6681274fd4f3cac96d0286sxRuy6KCg941DUgLf8fjQSvvkpgDMshwV1Jfnf0To=', 'Shimoga', 9980395039, 'sachin1.jpg', 'Chandrashekar', '1992-08-20', 'card1.jpg', '', '08182 228091', '08182 222980', 'B.E', 'Yes', 'Yes', 'Yes', 'Fresh', NULL, NULL, NULL, '1', 'SBI', 'Neeraj K', '2234567887', 'SBI000008', 'Shimoga', 'Blg7p6', 'Male', 'JNNCE', 'ASF345678', '5678 9876 2345', 'e5af5026dd48085110177f3fc77d3249', 2),
(12, 'Nikhil', 'Nikhil', 'jagadish.meghwal@gmail.com', '7c4d6bbea4d5120e2c3b2a385664e65276b1165159f08f3d216b67bf5c27cb2dfc157dfe300800a8244826dbff1a1477a421c55a1b2372d63b8ee191d3d74915g4zB8jg3LGQ/kkxik5J9217PuWywTaSpZGkBLs+6QBE=', 'Jaya Nagar, Bangalore', 9019641307, 'jagadish2.jpg', 'Vijay', '1987-06-07', 'id5.jpg', '', '08182-33345', '08185-234567', 'B.E', 'Yes', 'Yes', 'Yes', 'Renewal', NULL, NULL, NULL, '1', 'Corporation ', 'Nikhil', '345267893', 'CORP00008', 'Bangalore', 'SCLRBo', 'Male', 'ATNCE, Bangalore', 'ASWE23455', '5678 9435 8765', NULL, 1),
(13, 'Pradeep', 'Pradeep', 'jagadish.meghwal1@gmail.com', '735cb38444091e1448b0145275351354bc0c35139298a37ce9024ce071b30e5ec544c6fa2da5dc798047fa7854017ef9588bdc08ca70a8a93c284e48181447bbEKcGKBeTwSLFs6oL+nehQxDeA43QAqDPOwRCwM7FfKE=', 'Savalanga Road, Shiomoga, Karnataka - 577201', 9019641307, 'DSC_1703.JPG', 'Bhawarala', '1996-02-06', 'error-maharatha.JPG', '', '23567814', '2589631472', 'BE', 'Yes', 'Yes', 'Yes', 'Fresh', NULL, NULL, NULL, '1', 'PNB', 'Pradeep', '25361478952', 'PNB0001', 'Kota', 'j7Koqa', 'Male', 'RTU', 'AYIPJ9252B', '436545380470', NULL, 1),
(14, 'Pradeep', 'Pradeep', 'jagadish.meghwal1@gmail.com', '78cabbb92650bad79a97e359dafb2e9f56411f8a67205e5423aaf17af0e37b50b275304e5b3f4ca8b762527aa8660f9ce5ef03ff509d24134fbccc8129888d1fcAsG4Bv5Et+zOmOvwtwCMf2Fz1Kt/ToT4Zxg+PFb7gM=', 'Savalanga Road, Shiomoga, Karnataka - 577201', 9019641307, 'DSC_17031.JPG', 'Bhawarala', '1996-02-06', 'error-maharatha1.JPG', '', '23567814', '2589631472', 'BE', 'Yes', 'Yes', 'Yes', 'Fresh', NULL, NULL, NULL, '1', 'PNB', 'Pradeep', '25361478952', 'PNB0001', 'Kota', 'jsQkBv', 'Male', 'RTU', 'AYIPJ9252B', '436545380470', NULL, 2),
(15, 'Jagadish Scorer', 'Jaggu', 'jagadish@autosnehitchitradurga.com', '2a37702236432ef38699139b0c4fd8dc26e157b20e7e06c319901bc88a316f489c053d8d00451d3098d1e9978635e7e261418052d62e669d7e895ee1432a60d9JuLDomGIeNQxlHuPmypuoyo4AOrugK2UZTIXvlRTRac=', 'Shimoga address', 789456132, 'DSC_17032.JPG', 'Bhawarala', '1995-02-05', '', '', '859674123', '859674123', 'BA', 'Yes', 'No', 'Yes', 'Fresh', NULL, NULL, NULL, '1', 'PNB', 'Pradeep', '25361478952', 'PNB0001', 'Kota', '', 'Male', 'RTU', 'AYIPJ9252B', '436545380470', NULL, 2),
(17, 'Chandan', 'Chandu', 'chandanscorer@gmail.com', '0169f17f68a7f2f9539ef1c3dfd442317fe56bfbfa69d1c5d9129e48fded712058b6ee1a028c94a23cfd820269a3d44b2dabcd35a4f6a33b6281ab533368ac57JLXoWyNC8lPHNR08tnrTnenS3wQ6KMUbU7ulEid0b0Y=', 'Bhadravathi, Shivamogga, Karnataka', 9986809661, 'chandan11.jpg', 'Subhash', '1990-10-05', 'autosnehi11.PNG', 'dsa_passport_photo10.jpg', '7894561233', '1234567899', '2018', 'No', 'No', 'No', 'Renewal', NULL, NULL, NULL, '1', 'PNB', 'Chandan S', '00240100214944', 'UCBA0000024', 'Shimoga', 'k2RWaE', 'Male', 'Played Zonal matches', 'AA1235FR12', '852963741123', NULL, 0),
(18, 'Jagadish Scorer', 'Jaggu', 'jagadish@autosnehichitradurga44.com', '49ab7436525110fe87b76a2486f1d7face24735589e8310927054fa484fbbc4c4c8f691bcb7f81b4767cb5c5f27191ba62cd06485fc2ddb7d12c95fe2ba331d8Ld5pOqgOMOxUMzSvltugKscp3K2hZTFv1rsqT9+7KUU=', 'jljklj', 8596741584, 'dsa_passport_photo19.jpg', 'Bhawarala', '1995-02-05', 'chandan18.jpg', 'Capture4.PNG', '8529637412', '3692581472', '2015', 'Yes', 'Yes', 'Yes', 'Fresh', NULL, NULL, NULL, '1', 'PNB', 'Pradeep', '25361478952', 'PNB0001', 'Kota', 'wGXuUJ', 'on', 'jl', '', '', NULL, 0);

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

--
-- Table structure for table `scorer_accept`
--

CREATE TABLE `scorer_accept` (
  `id` int(10) NOT NULL,
  `match_id` int(10) NOT NULL,
  `scorer_id` int(10) NOT NULL,
  `tournament_id` int(10) NOT NULL,
  `acceptance` int(5) NOT NULL DEFAULT 0,
  `reason` text NOT NULL,
  `zone_id` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `scorer_accept`
--

INSERT INTO `scorer_accept` (`id`, `match_id`, `scorer_id`, `tournament_id`, `acceptance`, `reason`, `zone_id`) VALUES
(30, 846, 12, 44, 2, 'I will be out of station', 1),
(29, 847, 12, 44, 1, '', 1),
(25, 848, 12, 44, 1, '', 1),
(31, 847, 12, 44, 2, 'Personal Work', 1),
(32, 854, 12, 45, 1, '', 1),
(33, 855, 12, 45, 2, 'Personal work again', 1),
(34, 857, 12, 45, 2, 'Not well', 1),
(35, 858, 12, 45, 2, 'Friend wedding on this day', 1),
(36, 859, 12, 45, 1, '', 1),
(37, 860, 12, 45, 1, '', 1),
(38, 865, 12, 45, 1, '', 1),
(39, 861, 12, 45, 1, '', 1);

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

--
-- Table structure for table `scorer_committee`
--

CREATE TABLE `scorer_committee` (
  `id` int(50) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `zone_id` int(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `scorer_committee`
--

INSERT INTO `scorer_committee` (`id`, `name`, `email`, `contact`, `password`, `zone_id`) VALUES
(1, 'Scorer Committee', 'jagadish.meghwal@gmail.com', '1234567890', 'club123', 1);

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

--
-- Table structure for table `score_card`
--

CREATE TABLE `score_card` (
  `id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `scorer_id` int(11) NOT NULL,
  `toss` int(11) NOT NULL,
  `decided` varchar(50) NOT NULL,
  `result` varchar(50) NOT NULL,
  `win` int(11) DEFAULT NULL,
  `win_by` varchar(10) DEFAULT NULL,
  `winrunswkts` int(5) NOT NULL,
  `points_team_a` decimal(10,0) NOT NULL,
  `points_team_b` decimal(10,0) NOT NULL,
  `team_a` int(11) NOT NULL,
  `team_b` int(11) NOT NULL,
  `runs_team_a` int(11) NOT NULL DEFAULT 0,
  `runs_team_b` int(11) NOT NULL DEFAULT 0,
  `innings1_overs` int(3) NOT NULL,
  `innings2_overs` int(3) NOT NULL,
  `innings1_wkts` int(2) NOT NULL,
  `innings2_wkts` int(2) NOT NULL,
  `team_a_byes` int(3) NOT NULL DEFAULT 0,
  `team_b_byes` int(3) NOT NULL DEFAULT 0,
  `team_a_leg_byes` int(11) NOT NULL DEFAULT 0,
  `team_b_leg_byes` int(11) NOT NULL DEFAULT 0,
  `team_a_wide` int(11) NOT NULL DEFAULT 0,
  `team_b_wide` int(11) NOT NULL DEFAULT 0,
  `team_a_no_balls` int(11) NOT NULL DEFAULT 0,
  `team_b_no_balls` int(11) NOT NULL DEFAULT 0,
  `team_a_penalty` int(11) NOT NULL DEFAULT 0,
  `team_b_penalty` int(11) NOT NULL DEFAULT 0,
  `date_added` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `score_card`
--

INSERT INTO `score_card` (`id`, `match_id`, `scorer_id`, `toss`, `decided`, `result`, `win`, `win_by`, `winrunswkts`, `points_team_a`, `points_team_b`, `team_a`, `team_b`, `runs_team_a`, `runs_team_b`, `innings1_overs`, `innings2_overs`, `innings1_wkts`, `innings2_wkts`, `team_a_byes`, `team_b_byes`, `team_a_leg_byes`, `team_b_leg_byes`, `team_a_wide`, `team_b_wide`, `team_a_no_balls`, `team_b_no_balls`, `team_a_penalty`, `team_b_penalty`, `date_added`) VALUES
(2, 848, 12, 17, 'Bat', 'WIN', 5, 'wkts', 1, '0', '0', 17, 5, 215, 222, 39, 28, 3, 1, 5, 3, 2, 1, 0, 1, 1, 2, 0, 0, '0000-00-00');

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

--
-- Table structure for table `score_card_batting`
--

CREATE TABLE `score_card_batting` (
  `id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `team_id` int(11) NOT NULL,
  `p_runs` int(11) NOT NULL,
  `p_minutes` int(11) NOT NULL,
  `p_out` varchar(50) DEFAULT NULL,
  `p_bowler` int(11) NOT NULL,
  `p_fielder` int(11) NOT NULL,
  `p_balls` int(11) NOT NULL,
  `p4` int(11) NOT NULL DEFAULT 0,
  `p6` int(11) NOT NULL DEFAULT 0,
  `date_added` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `score_card_batting`
--

INSERT INTO `score_card_batting` (`id`, `match_id`, `player_id`, `team_id`, `p_runs`, `p_minutes`, `p_out`, `p_bowler`, `p_fielder`, `p_balls`, `p4`, `p6`, `date_added`) VALUES
(1, 848, 12, 17, 110, 150, 'C', 7, 6, 89, 10, 3, '0000-00-00'),
(2, 848, 21, 17, 50, 62, 'C&b', 7, 7, 60, 3, 2, '0000-00-00'),
(3, 848, 19, 17, 18, 30, 'St', 6, 8, 20, 1, 0, '0000-00-00'),
(4, 848, 20, 17, 29, 40, 'Not Out', 0, 0, 39, 1, 1, '0000-00-00'),
(5, 848, 6, 5, 80, 110, 'Caught', 21, 12, 90, 5, 6, '0000-00-00'),
(6, 848, 7, 5, 100, 145, 'NotOut', 0, 0, 89, 11, 5, '0000-00-00'),
(7, 848, 8, 5, 35, 35, 'NotOut', 0, 0, 12, 4, 3, '0000-00-00');

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

--
-- Table structure for table `score_card_bowling`
--

CREATE TABLE `score_card_bowling` (
  `id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `team_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `povers` float NOT NULL,
  `pmaidens` int(11) NOT NULL,
  `pruns` int(11) NOT NULL,
  `pwickets` int(11) NOT NULL,
  `pwide` int(11) NOT NULL,
  `pnb` int(11) NOT NULL,
  `date_added` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `score_card_bowling`
--

INSERT INTO `score_card_bowling` (`id`, `match_id`, `team_id`, `player_id`, `povers`, `pmaidens`, `pruns`, `pwickets`, `pwide`, `pnb`, `date_added`) VALUES
(1, 848, 5, 6, 10, 1, 75, 1, 4, 0, '0000-00-00'),
(2, 848, 5, 7, 10, 0, 90, 2, 1, 1, '0000-00-00'),
(3, 848, 5, 8, 9, 2, 70, 0, 1, 0, '0000-00-00'),
(4, 848, 17, 21, 9.3, 1, 85, 1, 0, 0, '0000-00-00'),
(5, 848, 17, 12, 10, 0, 75, 0, 0, 1, '0000-00-00'),
(6, 848, 17, 19, 8, 0, 95, 0, 1, 1, '0000-00-00');

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

--
-- Table structure for table `season`
--

CREATE TABLE `season` (
  `season_id` int(50) NOT NULL,
  `season_year` varchar(255) NOT NULL,
  `current_season` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `season`
--

INSERT INTO `season` (`season_id`, `season_year`, `current_season`) VALUES
(2, '2019-20', 0),
(3, '2020-21', 0),
(4, '2021-22', 1);

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

--
-- Table structure for table `squad`
--

CREATE TABLE `squad` (
  `squad_id` int(50) NOT NULL,
  `club_id` int(50) DEFAULT NULL,
  `tournament_id` int(50) DEFAULT NULL,
  `year` varchar(255) DEFAULT NULL,
  `player_id` int(50) DEFAULT NULL,
  `zone_id` int(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `squad`
--

INSERT INTO `squad` (`squad_id`, `club_id`, `tournament_id`, `year`, `player_id`, `zone_id`) VALUES
(56, 17, 24, '2018-19', 12, 1),
(57, 17, 24, '2018-19', 21, 1),
(58, 17, 24, '2018-19', 24, 1),
(59, 17, 26, '2018-19', 12, 1),
(60, 17, 26, '2018-19', 21, 1),
(61, 17, 26, '2018-19', 24, 1),
(62, 17, 20, '2018-19', 20, 1),
(63, 17, 20, '2018-19', 24, 1),
(64, 17, 28, '2018-19', 12, 1),
(65, 17, 28, '2018-19', 21, 1),
(66, 17, 44, '2018-19', 12, 1),
(67, 17, 44, '2018-19', 21, 1),
(68, 17, 44, '2018-19', 19, 1),
(69, 17, 44, '2018-19', 20, 1),
(70, 17, 45, NULL, 12, 1),
(71, 17, 45, NULL, 21, 1),
(74, 17, 45, NULL, 19, 1),
(75, 17, 45, NULL, 20, 1),
(76, 5, 44, NULL, 6, 1),
(77, 5, 44, NULL, 7, 1),
(78, 5, 44, NULL, 8, 1);

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

--
-- Table structure for table `stadium`
--

CREATE TABLE `stadium` (
  `id` int(40) NOT NULL,
  `stadiumname` varchar(255) NOT NULL,
  `curator1_name` varchar(255) NOT NULL,
  `curator1_email` varchar(255) NOT NULL,
  `curator1_contact` bigint(12) NOT NULL,
  `curator2_name` varchar(255) DEFAULT NULL,
  `curator2_email` varchar(255) DEFAULT NULL,
  `curator2_contact` bigint(12) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `zone_id` varchar(255) NOT NULL,
  `wtype` varchar(255) DEFAULT NULL,
  `wends` varchar(255) DEFAULT NULL,
  `wends_two` varchar(255) DEFAULT NULL,
  `groundsmen` int(10) DEFAULT NULL,
  `ground_area` varchar(50) DEFAULT NULL,
  `wickets` int(10) DEFAULT NULL,
  `pwickets` int(10) DEFAULT NULL,
  `building` varchar(50) DEFAULT NULL,
  `toilet` varchar(50) DEFAULT NULL,
  `score_board` varchar(50) DEFAULT NULL,
  `gym` varchar(50) DEFAULT NULL,
  `swimming` varchar(50) DEFAULT NULL,
  `sitting_area` varchar(50) DEFAULT NULL,
  `camara_stand` varchar(50) DEFAULT NULL,
  `sight_screen` varchar(50) DEFAULT NULL,
  `electricity_power` varchar(50) DEFAULT NULL,
  `medical_kit` varchar(50) DEFAULT NULL,
  `one_ton_roller` varchar(50) DEFAULT NULL,
  `two_ton_roller` varchar(50) DEFAULT NULL,
  `grass_cutter` varchar(50) DEFAULT NULL,
  `super_sopper` varchar(50) DEFAULT NULL,
  `reset_password_key` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stadium`
--

INSERT INTO `stadium` (`id`, `stadiumname`, `curator1_name`, `curator1_email`, `curator1_contact`, `curator2_name`, `curator2_email`, `curator2_contact`, `address`, `password`, `zone_id`, `wtype`, `wends`, `wends_two`, `groundsmen`, `ground_area`, `wickets`, `pwickets`, `building`, `toilet`, `score_board`, `gym`, `swimming`, `sitting_area`, `camara_stand`, `sight_screen`, `electricity_power`, `medical_kit`, `one_ton_roller`, `two_ton_roller`, `grass_cutter`, `super_sopper`, `reset_password_key`) VALUES
(10, 'JNNCE College Ground', 'Vivek', 'sachinrevankar999@gmail.com', 9980395039, 'Abhijith', 'abhi786@gmail.com', 7795506923, 'JNNCE College of Engineering', '1f5fdcd2fea06299e1541a4da6781b8bfc370eba8149e71a3d20c47d911a074d35d210bfd0bb70fec771192cc058b682b48719f7490356834db3e8f6dafce12aIuBp3XNEL81+MLas40/UXK0G5WM/XCdvibeUm5/KoWg=', '1', 'Mating', 'Pavilion End 1', 'Pavilion End 2', 15, '85 * 90 yards', 2, 4, 'Yes', 'No', 'Normal', 'No', 'Yes', 'No', 'Yes', 'No', 'Yes', 'No', 'Yes', 'No', 'Yes', 'No', '319cff49eb6cf07e038258bcf74ad309'),
(12, 'AG College Ground ', 'Kiran', 'vinayakaanvekar98@gmail.com', 9986809661, 'Rahul', 'rahul12345@gmail.com', 9986809661, 'Shimoga', '1f5fdcd2fea06299e1541a4da6781b8bfc370eba8149e71a3d20c47d911a074d35d210bfd0bb70fec771192cc058b682b48719f7490356834db3e8f6dafce12aIuBp3XNEL81+MLas40/UXK0G5WM/XCdvibeUm5/KoWg=', '1', 'Mating', 'Pavilion End 1', 'Pavilion End 2', 20, '84*90 yards', 4, 5, 'Yes', 'No', 'Normal', 'No', 'Yes', 'No', 'Yes', 'No', 'Yes', 'No', 'Yes', 'No', 'No', 'Yes', NULL),
(13, 'District Ground', 'Naveen', 'jagadish.meghwal@gmail.com', 9019641307, 'Pavan', 'pavan62@gmail.com', 9019641307, 'Chikkamagaluru', '490606975823c9f448bc71a1688ae36f36f2df6a15c52d9cdb370ad81bb61b3af977801c2961123c78e8455884a1b17281bd59d2078a6f163a259742b16ee659LR6zGIofyQE/Cp/T/HAIpSXs+RQ/v+0YtUP04B56IHk=', '1', 'Mating', 'Pavilion End 1', 'Pavilion End 2', 32, '85*92 yards', 3, 5, 'Yes', 'No', 'Normal', 'Yes', 'Yes', 'No', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', NULL),
(14, 'Govt Arts College Ground', 'Manikanta', 'anil@gmail.com', 9986809661, 'Upendra', 'Uppi123@gmail.com', 9986809661, 'Hassan', '1f5fdcd2fea06299e1541a4da6781b8bfc370eba8149e71a3d20c47d911a074d35d210bfd0bb70fec771192cc058b682b48719f7490356834db3e8f6dafce12aIuBp3XNEL81+MLas40/UXK0G5WM/XCdvibeUm5/KoWg=', '1', 'Turf', 'Pavilion End 1', 'Pavilion End 2', 23, '85*95 yards', 2, 4, 'Yes', 'Yes', 'Big', 'Yes', 'Yes', 'Yes', 'Yes', 'No', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', NULL),
(15, 'S Gopal Gowda Stadium', 'Nithin', 'sanjeev@gmail.com', 9019641307, 'Rohith', 'Roni@gmail.com', 9019641307, 'Sagara', '1f5fdcd2fea06299e1541a4da6781b8bfc370eba8149e71a3d20c47d911a074d35d210bfd0bb70fec771192cc058b682b48719f7490356834db3e8f6dafce12aIuBp3XNEL81+MLas40/UXK0G5WM/XCdvibeUm5/KoWg=', '1', 'Mating', 'Pavilion End 1', 'Pavilion End 2', 20, '84*90 yards', 2, 4, 'Yes', 'Yes', 'Normal', 'Yes', 'No', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', NULL);

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

--
-- Table structure for table `stadium_photo`
--

CREATE TABLE `stadium_photo` (
  `stadiumid` int(11) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `stadium_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stadium_photo`
--

INSERT INTO `stadium_photo` (`stadiumid`, `photo`, `stadium_id`) VALUES
(20, 'stadium2.jpg', 10),
(21, 'stadium3.jpg', 10),
(22, 'stadium4.jpg', 10),
(23, 'stadium5.jpg', 10),
(24, 'stadium1.jpg', 10),
(25, 'stadium6.jpg', 12),
(26, 'stadium7.jpg', 12),
(27, 'stadium8.jpg', 12),
(28, 'stadium9.jpg', 13),
(29, 'stadium10.jpg', 13);

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

--
-- Table structure for table `tournament`
--

CREATE TABLE `tournament` (
  `tournament_id` int(50) NOT NULL,
  `year` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `division_id` int(50) NOT NULL,
  `zone_id` int(50) NOT NULL,
  `group_id` int(10) DEFAULT NULL,
  `match_format` varchar(20) NOT NULL,
  `player_represent` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tournament`
--

INSERT INTO `tournament` (`tournament_id`, `year`, `name`, `division_id`, `zone_id`, `group_id`, `match_format`, `player_represent`) VALUES
(44, '2020-21', 'KSCA Division - I Tournament', 1, 1, 1, 'One Day', 'Same Team'),
(45, '2020-21', 'KSCA Division - I Tournament without Groups', 1, 1, 1, 'One Day', 'Same Team'),
(46, '2021-22', 'New tournament', 1, 1, 1, 'One Day', 'Same Team'),
(47, '2021-22', 'New Akshay Tournament', 1, 1, 1, 'One Day', 'Same Team'),
(48, '2019-20', 'Akshay Trophy ', 1, 1, 1, 'One Day', 'Same Team');

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

--
-- Table structure for table `tournament_club_entries`
--

CREATE TABLE `tournament_club_entries` (
  `id` int(11) NOT NULL,
  `club` int(11) NOT NULL,
  `tournament` int(11) NOT NULL,
  `accept` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tournament_club_entries`
--

INSERT INTO `tournament_club_entries` (`id`, `club`, `tournament`, `accept`, `status`) VALUES
(28, 1, 44, 0, 0),
(29, 3, 44, 0, 0),
(30, 5, 44, 0, 0),
(31, 9, 44, 0, 0),
(32, 10, 44, 0, 0),
(33, 11, 44, 0, 0),
(34, 13, 44, 1, 1),
(35, 17, 44, 1, 1),
(36, 19, 44, 0, 0),
(37, 1, 45, 1, 1),
(38, 3, 45, 0, 0),
(39, 5, 45, 1, 1),
(40, 9, 45, 1, 1),
(41, 10, 45, 0, 0),
(42, 11, 45, 1, 1),
(43, 13, 45, 0, 1),
(44, 17, 45, 2, 0),
(45, 19, 45, 0, 0),
(46, 1, 46, 0, 0),
(47, 3, 46, 0, 0),
(48, 5, 46, 0, 0),
(49, 9, 46, 0, 0),
(50, 11, 46, 0, 0),
(51, 13, 46, 0, 0),
(52, 17, 46, 1, 0),
(53, 19, 46, 0, 0),
(54, 1, 47, 0, 0),
(55, 3, 47, 0, 0),
(56, 5, 47, 0, 0),
(57, 9, 47, 0, 0),
(58, 11, 47, 0, 0),
(59, 13, 47, 0, 0),
(60, 17, 47, 0, 0),
(61, 19, 47, 0, 0),
(62, 5, 48, 1, 1),
(63, 9, 48, 1, 1),
(64, 11, 48, 1, 1),
(65, 13, 48, 0, 0),
(66, 17, 48, 1, 1),
(67, 19, 48, 0, 0);

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

--
-- Table structure for table `tournament_groups`
--

CREATE TABLE `tournament_groups` (
  `id` int(10) NOT NULL,
  `tournament_id` int(10) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tournament_groups`
--

INSERT INTO `tournament_groups` (`id`, `tournament_id`, `name`) VALUES
(80, 44, 'Group A'),
(81, 44, 'Group B'),
(82, 44, 'Group A'),
(83, 44, 'Group B'),
(84, 44, 'Group A'),
(85, 44, 'Group B'),
(86, 44, 'Group A'),
(87, 44, 'Group B'),
(88, 44, 'Group A'),
(89, 44, 'Group B'),
(90, 45, 'a'),
(91, 44, 'Group A'),
(92, 44, 'Group A'),
(93, 44, 'Group B'),
(94, 44, 'Group A'),
(95, 44, 'Group B');

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

--
-- Table structure for table `tournament_teams_group`
--

CREATE TABLE `tournament_teams_group` (
  `id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `team_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tournament_teams_group`
--

INSERT INTO `tournament_teams_group` (`id`, `group_id`, `team_id`) VALUES
(175, 80, 1),
(176, 80, 3),
(177, 81, 5),
(178, 80, 10),
(179, 81, 13),
(180, 81, 17);

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

--
-- Table structure for table `uachievements`
--

CREATE TABLE `uachievements` (
  `achievement_id` int(50) NOT NULL,
  `umpire_id` int(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `description` varchar(3500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `umpires`
--

CREATE TABLE `umpires` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `mobile` bigint(12) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `age` varchar(255) DEFAULT NULL,
  `age_proof` varchar(255) NOT NULL,
  `residence_no` varchar(255) DEFAULT NULL,
  `office_no` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) NOT NULL,
  `mtofoncommitment` varchar(255) NOT NULL,
  `mtofoccassionally` varchar(255) NOT NULL,
  `ssgeneral` varchar(255) NOT NULL,
  `registration_type` varchar(255) NOT NULL,
  `club_name_id` int(50) DEFAULT NULL,
  `cgroup` varchar(255) DEFAULT NULL,
  `division` varchar(255) DEFAULT NULL,
  `zone_id` int(50) NOT NULL,
  `qfksca` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_ac_name` varchar(255) NOT NULL,
  `bank_ac_no` varchar(255) NOT NULL,
  `bank_ifsc` varchar(255) NOT NULL,
  `bank_branch` varchar(255) NOT NULL,
  `uid_registration` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `address_proof` varchar(255) NOT NULL,
  `representative_cricket` text DEFAULT NULL,
  `pan` varchar(255) DEFAULT NULL,
  `adhaar` varchar(255) DEFAULT NULL,
  `reset_password_key` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `umpires`
--

INSERT INTO `umpires` (`id`, `name`, `display_name`, `email`, `password`, `address`, `mobile`, `photo`, `father_name`, `dob`, `age`, `age_proof`, `residence_no`, `office_no`, `qualification`, `mtofoncommitment`, `mtofoccassionally`, `ssgeneral`, `registration_type`, `club_name_id`, `cgroup`, `division`, `zone_id`, `qfksca`, `bank_name`, `bank_ac_name`, `bank_ac_no`, `bank_ifsc`, `bank_branch`, `uid_registration`, `gender`, `address_proof`, `representative_cricket`, `pan`, `adhaar`, `reset_password_key`, `status`) VALUES
(1, 'Subramanya', 'Subbu', 'sachinrevankar999@gmail.com', 'b3bdebd17ae448a86adf7e05fc4a0b541be00680dfab26c328059fbce5e31ea4066a6b057140a55e8159252a17ec0426cabd00ccc69e398368d4a7b01ed0e498EZVRpw60efEiNfkMmgnQhEzdLWHVWUFm8Ee+TzPl1Ko=', 'Honnali, Davanagere', 9980395039, 'sachin2.jpg', 'Shankar', '1983-07-06', '38', 'id6.jpg', '9876534567', '08185 67349', 'B.Com', 'Yes', 'Yes', 'Yes', 'Renewal', NULL, NULL, NULL, 1, '2018-01-04', 'Canara', 'Subramanya', '456637899', 'CANARA9986345', 'Davanagere', '950GmD', 'Male', 'Executive Officer ', 'GIT, Davanagere', 'HGTY343423', '9876 5643 2345', 'dfc7ff2eaab63c913ea0129c037a0800', 2),
(10, 'Vinod Kumar', 'Vinu', 'jagadish.meghwal@gmail.com', '7c9153899b5557c7be9b5c8ad4961c08d3a85988db0ae56882c40391ecc0332d33b0a1d8394b56cb076b3b32bd1b0245ed221d41f68f7d8ff172c585ea20f3efwL1bwsaudkwBUaTRziszEKrnKTvE93xxgxf16MKN2g4=', 'Vijaya Nagar, Bangalore', 9019641307, 'jagadish3.jpg', 'Ramesh', '1987-06-01', '30', 'id8.jpg', '9019641307', '9019641307', 'B.Arc', 'Yes', 'Yes', 'Yes', 'Fresh', NULL, NULL, NULL, 1, '2017-11-09', 'HDFC', 'Vinod', '87656477773', 'HDFC998765', 'Bangalore', 'Bdhk4Z', 'Male', 'Employee', 'Bangalore University', 'RDFT3456', '4536 7865 9876', NULL, 1),
(11, 'Jagadish Umpire', 'Jagadish', 'jagadish@autosnehichitradurga.com', 'ce314006c915a59fa18dee8e7f133977a35064f228fb22c846b8db4099dddbdccc0e852a7a13ce6f4fa30980233906ee7f382047cf4364756bdde511686296af/ZaFmpPXP/9TtpGw14E/c5lqe7OADScxOt/hpS3WiBM=', 'shimoga Karnataka', 9019641307, 'DSC_170313.JPG', 'Bhawarala', '1996-02-25', NULL, '', '789456123', '798456123', 'BA', 'Yes', 'Yes', 'Yes', 'Renewal', NULL, NULL, NULL, 1, '2019-05-02', 'PNB', 'Manmohan', '25361478952', 'PNB0001', 'Kota', 'jLeBuc', 'Male', 'Teacher', 'RTU', 'AYIPJ9252B', '4365453804788', NULL, 1),
(12, 'Keshav Kolle', 'Keshav', 'keshav.kolle@gmail.com', '4b46184f03c056894479eb07346349627022285e0b216ef0fa5d0b02a66fa1e2dd4c5da6598505059bece5740f8618bb48bf7e4791ae268580d157c637da39bcYwK+WnLzY4D1+5xnDgp5ix0qnOcH38nLSBjxvI2lUGs=', 'Vinobhanagar, Near Police chowki, Shimoga Karnataka - 577201', 8596741236, 'chandan6.jpg', 'Subray', '1985-02-01', NULL, '', '8529637412', '3692581472', '2015', 'Yes', 'No', 'Yes', 'Fresh', NULL, NULL, NULL, 1, NULL, 'Canara Bank', 'Keshav Kolle', '00240100214922', 'UCBA0000024', 'K G Road', 'r0431C', 'Male', '', 'Presented Indian under 19 in world cup', 'AYIPJ9252B', '123456789123', NULL, 0),
(13, 'Keshav Kolle', 'Keshav', 'keshav.kolle1@gmail.com', '5b731a9a22285bfcff30c778ffbb885a5068ab5854d36036e259bbc1da417a694ac221e6278d368f8486f511f9a9e43e287937f123ee35d1dc00437a5bc8e9faQ2YrWAUCTveCemSTl7UFWyPxfOdV+j/mGl2FmV2qaUk=', 'Vinobhanagar, Near Police chowki, Shimoga Karnataka - 577201', 8596741236, 'chandan9.jpg', 'Subray', '1985-02-01', NULL, 'Capture15.PNG', '8529637412', '3692581472', '2015', 'Yes', 'No', 'Yes', 'Fresh', NULL, NULL, NULL, 1, NULL, 'Canara Bank', 'Keshav Kolle', '00240100214922', 'UCBA0000024', 'K G Road', 'D2Gxro', 'Male', 'dsa_passport_photo8.jpg', 'Presented Indian under 19 in world cup', 'AYIPJ9252B', '123456789123', NULL, 0);

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

--
-- Table structure for table `umpire_accept`
--

CREATE TABLE `umpire_accept` (
  `id` int(11) NOT NULL,
  `match_id` int(10) NOT NULL,
  `umpire_id` int(10) NOT NULL,
  `tournament_id` int(10) NOT NULL,
  `acceptance` int(5) NOT NULL,
  `reason` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `umpire_accept`
--

INSERT INTO `umpire_accept` (`id`, `match_id`, `umpire_id`, `tournament_id`, `acceptance`, `reason`) VALUES
(21, 851, 10, 45, 1, ''),
(20, 849, 10, 44, 1, ''),
(19, 848, 10, 44, 2, 'Friend wedding on this day'),
(22, 854, 10, 45, 1, ''),
(23, 855, 10, 45, 1, ''),
(24, 857, 10, 45, 2, 'I will be out of station');

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

--
-- Table structure for table `umpire_committee`
--

CREATE TABLE `umpire_committee` (
  `id` int(50) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `zone_id` int(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `umpire_committee`
--

INSERT INTO `umpire_committee` (`id`, `name`, `email`, `contact`, `password`, `zone_id`) VALUES
(1, 'Umpire Committee', 'jagadish.meghwal@gmail.com', '1234567890', 'club123', 1);

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

--
-- Table structure for table `umpire_team_photo`
--

CREATE TABLE `umpire_team_photo` (
  `id` int(11) NOT NULL,
  `umpire_id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `photo` varchar(200) NOT NULL,
  `upload_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `umpire_team_photo`
--

INSERT INTO `umpire_team_photo` (`id`, `umpire_id`, `match_id`, `photo`, `upload_date`) VALUES
(1, 10, 849, '20160216_1353031.jpg', '2021-01-03'),
(2, 10, 851, 'Capture.JPG', '2021-01-04');

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

--
-- Table structure for table `user_admin`
--

CREATE TABLE `user_admin` (
  `id` int(50) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `zone_id` int(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_admin`
--

INSERT INTO `user_admin` (`id`, `name`, `email`, `contact`, `password`, `zone_id`) VALUES
(1, 'zonaladmin', 'admin@admin.com', '1234567890', 'admin123', 1);

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

--
-- Table structure for table `zonal_reports`
--

CREATE TABLE `zonal_reports` (
  `id` int(11) NOT NULL,
  `zone_id` int(11) NOT NULL,
  `report_type` int(11) NOT NULL,
  `organization` varchar(10) DEFAULT NULL,
  `tournament` varchar(255) DEFAULT NULL,
  `season` varchar(20) DEFAULT NULL,
  `team` varchar(255) DEFAULT NULL,
  `umpire1` varchar(50) DEFAULT NULL,
  `umpire2` varchar(50) DEFAULT NULL,
  `umpire3` varchar(50) DEFAULT NULL,
  `scorer1` varchar(50) DEFAULT NULL,
  `scorer2` varchar(50) DEFAULT NULL,
  `referee` varchar(50) DEFAULT NULL,
  `vedio_analyst` varchar(50) DEFAULT NULL,
  `event_name` varchar(500) DEFAULT NULL,
  `event_year` varchar(20) DEFAULT NULL,
  `education_staff` varchar(50) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `report_date` date NOT NULL,
  `added_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `zonal_reports`
--

INSERT INTO `zonal_reports` (`id`, `zone_id`, `report_type`, `organization`, `tournament`, `season`, `team`, `umpire1`, `umpire2`, `umpire3`, `scorer1`, `scorer2`, `referee`, `vedio_analyst`, `event_name`, `event_year`, `education_staff`, `comments`, `report_date`, `added_date`) VALUES
(1, 2, 1, 'KSCA', 'Ranji Trophy', '2019-20', 'Karnataka Vs Hyderabad', 'Anil', 'Sanjeev', 'Kiran', 'Chandan', 'Suman', 'Karthik', 'Murlidhar', NULL, NULL, NULL, 'This match was a test match played on 23 janaury 2021', '2021-01-22', '0000-00-00'),
(2, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Award function ceremony', '2019-20', NULL, 'Award function ceremony held at KSCA stadium shivamogga\r\n', '2021-01-20', '2021-01-23'),
(3, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Scorer exam education program', '2020', 'Scorers', 'Training was provided to 200 scorers at KSCA stadium', '2021-01-18', '2021-01-23'),
(4, 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'General meeting ', NULL, NULL, 'Meeting was held at stadium for future course of action', '2021-01-17', '2021-01-23'),
(5, 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'General meeting ', NULL, NULL, 'Meeting was held at stadium for future course of action', '2021-01-11', '2021-01-23'),
(6, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Award function ceremony', '2020', NULL, 'esafqasdfasdf', '2021-01-12', '2021-01-25'),
(7, 1, 1, 'BCCI', 'Rajiv trophy', '2020-22', 'Rajasthan Vs Kolkata', 'Anil', 'Sanjeev', 'Keshav', 'Chandan', 'Vinayak', 'Jagadish', 'Akshay', NULL, NULL, NULL, NULL, '2021-01-18', '2021-01-25'),
(8, 1, 1, 'BCCI', 'Rajiv trophy', '2020-22', 'Rajasthan Vs Kolkata', 'Anil', 'Sanjeev', 'Keshav', 'Chandan', 'Vinayak', 'Jagadish', 'Akshay', NULL, NULL, NULL, NULL, '2021-01-18', '2021-01-25'),
(9, 1, 1, 'KSCA', 'KSCA League Trophy', '2019-20', 'Hubli Vs Bangalore', 'Anil', 'Sanjeev', 'Kiran', 'Chandan', 'Suman', 'Karthik', 'Murlidhar', NULL, NULL, NULL, NULL, '2021-01-11', '2021-01-25'),
(10, 1, 1, 'KSCA', 'Ranji Trophy', '2019-20', 'Karnataka Vs Hyderabad', 'Anil', 'Sanjeev', 'Kiran', 'Chandan', 'Suman', 'Karthik', 'Murlidhar', NULL, NULL, NULL, NULL, '2021-01-13', '2021-01-25'),
(11, 1, 1, 'KSCA', 'Ranji Trophy', '2019-20', 'adasd', 'asdf', 'Sanjeev', 'Kiran', 'sf', 'Suman', 'Karthik', 'asf', NULL, NULL, NULL, NULL, '2021-01-12', '2021-01-25'),
(12, 1, 1, 'KSCA', 'Ranji Trophy', 'adasd', 'asdf', 'assdf', 'asdf', 'asdf', 'asf', 'sdf', 'asdf', 'asf', NULL, NULL, NULL, NULL, '2021-01-06', '2021-01-25'),
(13, 1, 1, 'KSCA', 'Cricket 2020', '2019-20', 'Kolkata vs Chennai', 'Anil', 'Sanjeev', 'Kiran', 'Chandan', 'Suman', 'Karthik', 'Murlidhar', NULL, NULL, NULL, NULL, '2021-01-12', '2021-01-25'),
(14, 1, 1, 'KSCA', 'Ranji Trophy', 'sd', 'asdf', 'asf', 'sadf', '', 'adf', 'asdf', 'asdf', 'asf', NULL, NULL, NULL, NULL, '2021-01-01', '2021-01-26'),
(15, 1, 1, 'KSCA', 'Ranji Trophy', '2020-21', 'Delhi Vs Karnataka', 'Keshav Kolle ', 'Abhijit', '', 'Chandan', 'Harish', 'Manjunath', 'Vikas', NULL, NULL, NULL, NULL, '2021-01-05', '2021-01-26'),
(16, 1, 1, 'KSCA', 'Ranji Trophy', 'asdf', 'asdf', 'df', 'af', 'asddf', 'asdf', 'asdf', 'asdf', 'asdf', NULL, NULL, NULL, NULL, '2021-01-13', '2021-01-26'),
(17, 1, 1, 'KSCA', 'Ranji Trophy', 'adasd', 'as', 'Anil', 'asdf', '', 'sf', '', 'asdf', '', NULL, NULL, NULL, NULL, '2021-01-19', '2021-01-26'),
(18, 1, 1, 'KSCA', 'Ranji Trophy', 'adasd', 'asdf', 'assdf', 'asdf', '', 'asf', '', '', '', NULL, NULL, NULL, NULL, '2021-01-20', '2021-01-27'),
(19, 1, 1, 'KSCA', 'asf', 'af', 'af', 'asdf', 'sadf', 'asf', 'sadf', 'asdf', '', '', NULL, NULL, NULL, NULL, '2021-01-19', '2021-01-27'),
(20, 1, 1, 'KSCA', 'Ranji Trophy', 'dsaf', 'asdf', 'asdf', 'asdf', 's', 'af', 'sf', '', '', NULL, NULL, NULL, NULL, '2021-01-11', '2021-01-27'),
(21, 1, 1, 'KSCA', 'ardg', 'jk', 'hh', 'jkh', 'kjh', 'kjh', 'kj', 'hk', 'jh', 'kjhjk', NULL, NULL, NULL, NULL, '2021-01-06', '2021-01-27'),
(22, 1, 1, 'KSCA', 'a', 'hkj', 'h', 'hkj', 'hkj', 'hkj', 'h', 'hkj', 'h', 'kjh', NULL, NULL, NULL, NULL, '2021-01-13', '2021-01-27'),
(23, 1, 1, 'KSCA', 'lkj', 'Ranji Trophy', 'jklj', 'jkl', 'jkl', '', 'jkl', '', '', '', NULL, NULL, NULL, NULL, '2021-01-12', '2021-01-27'),
(24, 1, 1, 'KSCA', 'Ranji Trophy', 'sf', 'jkl', 'kj', 'kjl', '', 'jkl', '', '', '', NULL, NULL, NULL, NULL, '2020-10-10', '2021-01-27'),
(25, 1, 1, 'KSCA', 'jkj', 'jlk', 'jlk', 'jl', 'kl', 'lkjk', 'ljkl', 'jkl', 'jk', 'jkl', NULL, NULL, NULL, NULL, '2021-02-02', '2021-01-27'),
(26, 1, 1, 'KSCA', 'Ranji Trophy', 'df', 'sadf', 'sdf', 'sdf', 'asdf', 'af', 'asdf', '', '', NULL, NULL, NULL, NULL, '2021-01-13', '2021-01-28'),
(27, 1, 1, 'KSCA', 'Ranji Trophy', 'd', 'sd', 'sd', 'sdf', '', 'df', '', '', '', NULL, NULL, NULL, NULL, '2021-01-07', '2021-01-28'),
(28, 1, 1, 'KSCA', 'Ranji Trophy', 'adasd', 'asdf', 'nkj', 'kj', 'k', 'jl', '', '', '', NULL, NULL, NULL, NULL, '2021-01-13', '2021-01-28'),
(29, 1, 1, 'KSCA', 'Ranji Trophy', 'sadf', 'asd', 'asd', 'sadf', 'sadf', 'sf', '', 'sdf', '', NULL, NULL, NULL, NULL, '2021-01-08', '2021-01-28'),
(30, 1, 1, 'BCCI', 'Ranji Trophy', 'asf', 'as', 'asdf', 'sad', '', 'sf', '', '', '', NULL, NULL, NULL, NULL, '2021-01-05', '2021-01-28'),
(31, 1, 1, 'KSCA', 'Ranji Trophy', 'asdf', 'asdf', 'asdf', 'asdff', '', 'sdf', '', '', '', NULL, NULL, NULL, NULL, '2021-01-21', '2021-01-28'),
(32, 1, 1, 'BCCI', 'df', 'ASDF', 'ASDF', 'ASDF', 'ASFD', '', 'AF', '', '', '', NULL, NULL, NULL, NULL, '2020-12-30', '2021-01-28'),
(33, 1, 1, 'KSCA', 'lj', 'Ranji Trophy', 'lj', 'jl', 'lkj', 'j', 'jkl', '', '', '', NULL, NULL, NULL, NULL, '2021-01-11', '2021-01-28'),
(34, 1, 1, 'BCCI', 'Ranji Trophy', 'asd', 'as', 'asdf', 'asdf', 'asd', 'asfd', '', '', '', NULL, NULL, NULL, NULL, '2021-01-14', '2021-01-28'),
(35, 1, 1, 'KSCA', 'Jagadish Tropht', '2019-20', 'West Bengal Vs Bihar', 'Sanjeev', 'Keshav', 'Abhi', 'Chidanand', 'Anil', 'Manikantan', 'Mukesh', NULL, NULL, NULL, NULL, '2021-01-20', '2021-01-28'),
(36, 1, 1, 'KSCA', 'Ranji Trophy', 'adasd', 'jaskdjf', 'kljLKJ', 'KLJKL', 'J', 'LKJ', 'LKJ', 'KLJ', 'LKJ', NULL, NULL, NULL, NULL, '2021-01-14', '2021-01-28'),
(37, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Award function ceremony', '2019-20', NULL, NULL, '2021-02-03', '2021-02-03'),
(38, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Awards function', '2020', NULL, NULL, '2021-02-02', '2021-02-03'),
(39, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Awards function', '2020', NULL, NULL, '2021-02-01', '2021-02-03'),
(40, 1, 1, 'KSCA', 'fasdas', '2021-22', 'Karnataka Vs Kerala', 'Akshay', 'Akshay2', 'Akshay3', 'Jagadish', 'Jagadish 1', 'Shirodkar', 'Anand', NULL, NULL, NULL, NULL, '2021-02-01', '2021-02-16'),
(41, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dfas', 'adsf', 'Coaches', NULL, '2021-02-01', '2021-02-16'),
(42, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dsf', 'sg', 'Coaches', NULL, '2021-02-25', '2021-02-25'),
(43, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'asdf', 'sg', 'Scorers', NULL, '2021-02-25', '2021-02-25');

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

--
-- Table structure for table `zonal_report_infrastructure`
--

CREATE TABLE `zonal_report_infrastructure` (
  `id` int(11) NOT NULL,
  `report_id` int(11) NOT NULL,
  `zone_id` int(5) NOT NULL,
  `infra_name` varchar(255) NOT NULL,
  `service_provider` varchar(255) NOT NULL,
  `units` int(5) DEFAULT NULL,
  `days` int(4) NOT NULL,
  `payment` varchar(25) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `date_added` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `zonal_report_infrastructure`
--

INSERT INTO `zonal_report_infrastructure` (`id`, `report_id`, `zone_id`, `infra_name`, `service_provider`, `units`, `days`, `payment`, `comments`, `date_added`) VALUES
(1, 13, 1, 'Lighting', 'Light system solution shimoga', 25, 5, '0', NULL, '2021-01-25'),
(2, 14, 1, 'asdf', 'dd', 0, 0, '0', NULL, '2021-01-26'),
(3, 15, 1, 'Water Service', 'Spoorthy packaging, Bhadravathi', 50, 5, '0', NULL, '2021-01-26'),
(4, 15, 1, 'Lightning', 'BEML', 20, 5, '0', NULL, '2021-01-26'),
(5, 15, 1, 'Catering service', 'Ganesh Canteen', 100, 5, '0', NULL, '2021-01-26'),
(6, 16, 1, 'adf', 'sdSDF', 0, 0, 'Cheque', NULL, '2021-01-26'),
(7, 19, 1, 'asdf', 'sd', 12, 1, 'Cheque', NULL, '2021-01-27'),
(8, 20, 1, 'sdf', 'sdfd', 10, 1, 'Cheque', NULL, '2021-01-27'),
(9, 21, 1, 'hkjh', 'kjhkj', 0, 0, 'Online Payment', NULL, '2021-01-27'),
(10, 22, 1, 'jhk', 'hkh', 0, 0, 'Online Payment', NULL, '2021-01-27'),
(11, 23, 1, 'lkj', 'jk', 0, 0, 'Online Payment', NULL, '2021-01-27'),
(12, 24, 1, 'hk', 'hkh', 0, 0, 'Online Payment', NULL, '2021-01-27'),
(13, 25, 1, 'hhjk', 'hj', 0, 0, 'Online Payment', NULL, '2021-01-27'),
(14, 26, 1, 'sdf', 'sf', 10, 1, 'Online Payment', NULL, '2021-01-28'),
(15, 27, 1, 'sf', 'sd', 1, 1, '', NULL, '2021-01-28'),
(16, 28, 1, 'dafd', 'asdf', 0, 0, 'Online Payment', NULL, '2021-01-28'),
(17, 29, 1, 'sadf', 'asdf', 10, 10, 'Online Payment', NULL, '2021-01-28'),
(18, 30, 1, 'df', 'adf', 10, 2, 'Online Payment', NULL, '2021-01-28'),
(19, 31, 1, 'sdg', 'as', 10, 10, 'Online Payment', NULL, '2021-01-28'),
(20, 32, 1, 'ER', 'sdfg', 5, 5, 'Online Payment', NULL, '2021-01-28'),
(21, 33, 1, 'jl', 'lkj', 0, 0, 'Online Payment', NULL, '2021-01-28'),
(22, 34, 1, 'adf', 'asd', 10, 10, 'Online Payment', NULL, '2021-01-28'),
(23, 35, 1, 'Lightning System', 'Infocom', 5, 5, 'Cheque', 'This payment was done from personal account so the amount was debited for personal account, infact the service provided was also good', '2021-01-28'),
(24, 35, 1, 'Water Service', 'Finex', 500, 5, 'Cheque', 'this is the second comment', '2021-01-28'),
(25, 36, 1, 'DFJKJ', 'KJ', 0, 0, 'Online Payment', NULL, '2021-01-28'),
(26, 40, 1, 'Drinking Water', 'Spoorthy Water packaging Pvt Ltd', 500, 5, 'Cash', NULL, '2021-02-16'),
(27, 40, 1, 'Food', 'Akshay Food Company', 1500, 5, 'Cash', NULL, '2021-02-16'),
(28, 42, 1, 'fd', 'water packaing ltd', 100, 2, 'Online Payment', NULL, '2021-02-25'),
(29, 43, 1, 'new infra', 'webschedio ', 1, 2, 'Online Payment', NULL, '2021-02-25');

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

--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `id` int(11) NOT NULL,
  `zone` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zones`
--

INSERT INTO `zones` (`id`, `zone`) VALUES
(1, 'KSCA Shimoga'),
(72, 'KSCA Mangalore'),
(71, 'KSCA Mysore'),
(70, 'KSCA Dharwad'),
(73, 'KSCA Tumkur'),
(74, 'KSCA Raichur'),
(75, 'KSCA Bangalore');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `pachievements`
--
ALTER TABLE `pachievements`
  ADD PRIMARY KEY (`achievement_id`);

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

--
-- Indexes for table `rachievements`
--
ALTER TABLE `rachievements`
  ADD PRIMARY KEY (`achievement_id`);

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

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

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

--
-- Indexes for table `sachievements`
--
ALTER TABLE `sachievements`
  ADD PRIMARY KEY (`achievement_id`);

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

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

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

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

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

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

--
-- Indexes for table `season`
--
ALTER TABLE `season`
  ADD PRIMARY KEY (`season_id`);

--
-- Indexes for table `squad`
--
ALTER TABLE `squad`
  ADD PRIMARY KEY (`squad_id`);

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

--
-- Indexes for table `stadium_photo`
--
ALTER TABLE `stadium_photo`
  ADD PRIMARY KEY (`stadiumid`);

--
-- Indexes for table `tournament`
--
ALTER TABLE `tournament`
  ADD UNIQUE KEY `tournament_id` (`tournament_id`);

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

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

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

--
-- Indexes for table `uachievements`
--
ALTER TABLE `uachievements`
  ADD PRIMARY KEY (`achievement_id`);

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `club_office`
--
ALTER TABLE `club_office`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `expense`
--
ALTER TABLE `expense`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `pachievements`
--
ALTER TABLE `pachievements`
  MODIFY `achievement_id` int(50) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `rachievements`
--
ALTER TABLE `rachievements`
  MODIFY `achievement_id` int(50) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `sachievements`
--
ALTER TABLE `sachievements`
  MODIFY `achievement_id` int(50) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `season`
--
ALTER TABLE `season`
  MODIFY `season_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `squad`
--
ALTER TABLE `squad`
  MODIFY `squad_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `stadium`
--
ALTER TABLE `stadium`
  MODIFY `id` int(40) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `stadium_photo`
--
ALTER TABLE `stadium_photo`
  MODIFY `stadiumid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `tournament`
--
ALTER TABLE `tournament`
  MODIFY `tournament_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

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

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

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

--
-- AUTO_INCREMENT for table `uachievements`
--
ALTER TABLE `uachievements`
  MODIFY `achievement_id` int(50) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `zones`
--
ALTER TABLE `zones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;
COMMIT;

