-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Jan 16, 2023 at 12:57 PM -- Server version: 10.5.12-MariaDB-cll-lve -- PHP Version: 7.2.34 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `u201022062_participant` -- -- -------------------------------------------------------- -- -- Table structure for table `participant` -- CREATE TABLE `participant` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `gender` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `contact` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `dob` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `eventname` varchar(90) COLLATE utf8mb4_unicode_ci NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `participant` -- INSERT INTO `participant` (`id`, `name`, `gender`, `contact`, `email`, `dob`, `eventname`, `status`) VALUES (13, 'kanishka singh', 'male', '3646789876', 'kani@g.com', '2010-02-02', 'coding', 0), (15, 'sedfad', 'male', '4333333333', 'dewsD@DFD.C', '2023-01-06', 'coding', 0), (16, 'fvwdfsbs', 'male', '3383873373', 'asdfvda@sdsa.c', '2023-01-06', 'singing', 0), (18, 'Sunil Yadav', 'male', '4765765465', 'asdcasd@sdcsadfda.c', '2023-01-04', 'singing', 0), (19, 'Elon Mask', 'female', '8767876787', 'dasasdads@wd.com', '2023-01-01', 'coding', 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `participant` -- ALTER TABLE `participant` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `participant` -- ALTER TABLE `participant` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;