-- 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_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 `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 `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_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 `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 `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_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 `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_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 `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_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 `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `rachievements`
--
ALTER TABLE `rachievements`
  ADD PRIMARY KEY (`achievement_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 `scorer_accept`
--
ALTER TABLE `scorer_accept`
  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_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 `umpire_accept`
--
ALTER TABLE `umpire_accept`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `umpire_team_photo`
--
ALTER TABLE `umpire_team_photo`
  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_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 `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 `rachievements`
--
ALTER TABLE `rachievements`
  MODIFY `achievement_id` int(50) NOT NULL AUTO_INCREMENT;

--
-- 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 `scorer_accept`
--
ALTER TABLE `scorer_accept`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- 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_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 `umpire_accept`
--
ALTER TABLE `umpire_accept`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- 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 `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;

