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

START TRANSACTION;



--
-- Database: `thiruvananthapur_tvmadmin_hockey`
--

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

--
-- Table structure for table `ecm_tab`
--

CREATE TABLE `ecm_tab` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `profile_pic` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ecm_tab`
--

INSERT INTO `ecm_tab` (`id`, `name`, `designation`, `profile_pic`) VALUES
(13, 'Arun A Unnithan', 'President', 'profile_pics/8f0e6e1ee58eeea56d22d790c28461bearun.png'),
(14, 'ANILKUMAR R S', 'Secretary', 'profile_pics/d32d996d164c896769a091fd78d3429aanil.png'),
(15, 'ABHILASH M B', 'Treasurer', 'profile_pics/a27eb799b1cd6736743e715a0b8d6d1babi.png'),
(16, 'Omanakumari S', 'Patron', 'profile_pics/ccae10552c6bb867eaaf6e6421bfc215'),
(17, 'S Jayakumar', 'Patron', 'profile_pics/e2f261d475c1fd27202cf5cfa8351a11'),
(18, 'Kasi Kumar', 'Patron', 'profile_pics/34af9c7ff3f28a786f593e2c3ded63cb'),
(19, 'Arun A Unnithan', 'President', 'profile_pics/ba61e78923a89d4d1978d370fe6ea21carun.png'),
(20, 'Ayyapan R', 'Senior Vice President', 'profile_pics/2a91ee1a0d6b12b97b05362db41a2f0e'),
(21, 'Rajkumar R', 'Vice Presidents', 'profile_pics/8629b4d09b8862ad9913c9adc369be89'),
(22, 'M S Ambikasree', 'Vice Presidents', 'profile_pics/eedc5d24625f13948710d860fb9499a7'),
(23, 'Jayakumari', 'Vice Presidents', 'profile_pics/531054d701563f5ecd14265a65e199d7'),
(24, 'Satheesan', 'Vice Presidents', 'profile_pics/af9f0bf063261e4474ded423d0be4ce4'),
(25, 'ANILKUMAR R S L', 'Secretary', 'profile_pics/25e1d0e17ce48e6f794682cc5638cb16anil.png'),
(26, 'ABHILASH M B', 'Secretary', 'profile_pics/2d89871f017c8c715a3a082a796d755a'),
(27, 'kiran kumar G L', 'Joint Secretary', 'profile_pics/ffeac1b74605f2958a7103ccaeeb5c7e'),
(28, 'Anil kumar R S', 'Joint Secretary', 'profile_pics/f3d2cc30574a1d8ae53a82bd3f776539'),
(29, 'Rejitha R', 'Joint Secretary', 'profile_pics/9919459de78fa5c9290a94ad00b4b337'),
(30, 'Sunitha S K', 'Joint Secretary', 'profile_pics/96e5f87a9ff0d8cc1f5f4702eaf47588'),
(31, 'Abhilash M B ', 'Treasurer', 'profile_pics/efa358995d41720270515f2a78796abdabi.png'),
(32, 'Jayalekshmi M T', 'Exicutive Members', 'profile_pics/9a2e0a4180ddacb8568aced2013b9c55'),
(33, 'Arun Kiran A S', 'Exicutive Members', 'profile_pics/8080593cbc52d0c9966d16a66a84eea6'),
(34, 'Sanjay', 'Exicutive Members', 'profile_pics/e24e935adb8891a00565d5c9db6e9b4e'),
(35, 'Adam Sha', 'Exicutive Members', 'profile_pics/dd09120a4e88278792c61fb89d85a051'),
(36, 'Sindhu R', 'Exicutive Members', 'profile_pics/b54f3fd5aac62f1b7f7f0bc8dc560c30'),
(37, 'Suresh Kumar S', 'Associate Vice Presidents', 'profile_pics/3deeae1ccce10568323b1860886de83b'),
(38, '	Dr. Geetha', 'Associate Vice Presidents', 'profile_pics/62444845717719a02d4f7e589248d664'),
(39, 'Pratheesh', 'Associate Vice Presidents', 'profile_pics/c7e4b896539fca880c25088179f296f2'),
(40, 'Binu C P', 'Associate Vice Presidents', 'profile_pics/1e1d6844d8bd5df0e497503c0f1bfa09'),
(41, 'Ajeesh Chandran', 'Associate Joint Secretary', 'profile_pics/9de6240eece03c326262a0a3c00b0eb1');

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

--
-- Table structure for table `ob_tab`
--

CREATE TABLE `ob_tab` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `profile_pic` varchar(255) NOT NULL,
  `phone_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ob_tab`
--

INSERT INTO `ob_tab` (`id`, `name`, `designation`, `profile_pic`, `phone_no`) VALUES
(3, 'Jaya Kumar', 'Chairman', 'profile_pics/ob/260c88ed5a145487fb7ae07338809d52jaya.jpeg', '9447110553'),
(4, 'Dr. Arif Khan L', 'Convenor', 'profile_pics/ob/fc2cd698fecee743108950a5b8cec9f6arif.jpg', '6238264683'),
(5, 'Sivakumar M', 'Executive Members', 'profile_pics/ob/7b3340e69df09ab1243a53eff0403790', '9047033852'),
(6, 'Raji Kumar', 'Executive Members', 'profile_pics/ob/b581cdc4709c12ce62ae7e985e3ff752', '9447033978'),
(7, 'Sasi Kumar V', 'Executive Members', 'profile_pics/ob/fac5d3b1ba044cb8f9ac75cac3431dbc', '9387828168'),
(8, 'Anil R', 'Executive Members', 'profile_pics/ob/a5bcf1d19b848e5519650957c5a304ec', '9544977744'),
(9, 'Gokul G S Nair', 'Executive Members', 'profile_pics/ob/043ddb3a45994e8898708e5b1923d186', '9995373068');

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

--
-- Table structure for table `tb_associations`
--

CREATE TABLE `tb_associations` (
  `id` int NOT NULL,
  `assc_name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `nominee1` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `ads1` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `Phone1` text COLLATE utf8mb4_general_ci NOT NULL,
  `nominee2` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `p2` text COLLATE utf8mb4_general_ci NOT NULL,
  `ads2` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `nominee3` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `ads3` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `p3` text COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_associations`
--

INSERT INTO `tb_associations` (`id`, `assc_name`, `nominee1`, `ads1`, `Phone1`, `nominee2`, `p2`, `ads2`, `nominee3`, `ads3`, `p3`) VALUES
(54, 'sample', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `tb_image`
--

CREATE TABLE `tb_image` (
  `id` int NOT NULL,
  `image` varchar(100) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_image`
--

INSERT INTO `tb_image` (`id`, `image`) VALUES
(162, 'all_image/c008259344f21690d7da5e407be77713a4.png'),
(163, 'all_image/3353bff625d1902141a83e2b5b85c1bba3.png'),
(164, 'all_image/a4656d13ecd220cc94134dfead84dc2fa2.png'),
(165, 'all_image/b4ee0095d90693dee7a1ecd355683ca8aa.png');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ecm_tab`
--
ALTER TABLE `ecm_tab`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

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

--
-- AUTO_INCREMENT for table `tb_associations`
--
ALTER TABLE `tb_associations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `tb_image`
--
ALTER TABLE `tb_image`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=170;
COMMIT;

