-
Notifications
You must be signed in to change notification settings - Fork 0
/
pdonew.sql
102 lines (88 loc) · 3.87 KB
/
pdonew.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 15, 2018 at 05:29 PM
-- Server version: 10.1.37-MariaDB
-- PHP Version: 7.2.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `pdonew`
--
-- --------------------------------------------------------
--
-- Table structure for table `pdotrial1`
--
CREATE TABLE `pdotrial1` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`institute` text NOT NULL,
`designation` varchar(255) NOT NULL,
`acad_year` text NOT NULL,
`phone` bigint(11) NOT NULL,
`team_name` text NOT NULL,
`team_size` text NOT NULL,
`athletics` tinyint(1) DEFAULT NULL,
`aquatics` tinyint(1) DEFAULT NULL,
`cricket` tinyint(1) DEFAULT NULL,
`football` tinyint(1) DEFAULT NULL,
`volleyball` tinyint(1) DEFAULT NULL,
`basketball` tinyint(1) DEFAULT NULL,
`badminton` tinyint(1) DEFAULT NULL,
`chess` tinyint(1) DEFAULT NULL,
`carrom` tinyint(1) DEFAULT NULL,
`squash` tinyint(1) DEFAULT NULL,
`table_tennis` tinyint(1) DEFAULT NULL,
`lawn_tennis` tinyint(1) DEFAULT NULL,
`snooker` tinyint(1) DEFAULT NULL,
`power_lifting` tinyint(1) DEFAULT NULL,
`pubg` tinyint(1) DEFAULT NULL,
`athletics_girls` tinyint(1) DEFAULT NULL,
`aquatics_girls` tinyint(1) DEFAULT NULL,
`volleyball_girls` tinyint(1) DEFAULT NULL,
`basketball_girls` tinyint(1) DEFAULT NULL,
`badminton_girls` tinyint(1) DEFAULT NULL,
`chess_girls` tinyint(1) DEFAULT NULL,
`carrom_girls` tinyint(1) DEFAULT NULL,
`squash_girls` tinyint(1) DEFAULT NULL,
`table_tennis_girls` tinyint(1) DEFAULT NULL,
`lawn_tennis_girls` tinyint(1) DEFAULT NULL,
`snooker_girls` tinyint(1) DEFAULT NULL,
`power_lifting_girls` tinyint(1) DEFAULT NULL,
`pubg_girls` tinyint(1) DEFAULT NULL,
`events` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `pdotrial1`
--
INSERT INTO `pdotrial1` (`id`, `name`, `email`, `institute`, `designation`, `acad_year`, `phone`, `team_name`, `team_size`, `athletics`, `aquatics`, `cricket`, `football`, `volleyball`, `basketball`, `badminton`, `chess`, `carrom`, `squash`, `table_tennis`, `lawn_tennis`, `snooker`, `power_lifting`, `pubg`, `athletics_girls`, `aquatics_girls`, `volleyball_girls`, `basketball_girls`, `badminton_girls`, `chess_girls`, `carrom_girls`, `squash_girls`, `table_tennis_girls`, `lawn_tennis_girls`, `snooker_girls`, `power_lifting_girls`, `pubg_girls`, `events`) VALUES
(90, 'Ekansh', '[email protected]', 'IIITA', '', '', 9876543212, 'test', '50', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'Athletics <br>Aquatics <br>Cricket <br>Football <br>Volleyball <br>Basketball <br>Badminton <br>Chess <br>Carrom <br>Squash <br>Table Tennis <br>Lawn Tennis <br>Snooker <br>Power Lifting <br>PUBG <br>Athletics (GIRLS) <br>Aquatics (GIRLS) <br>Volleyball (GIRLS) <br>Basketball (GIRLS) <br>Badminton (GIRLS) <br>Chess (GIRLS) <br>Carrom (GIRLS) <br>Squash (GIRLS) <br>Table Tennis (GIRLS) <br>Lawn Tennis (GIRLS) <br>Snooker (GIRLS) <br>Power Lifting (GIRLS) <br>PUBG (GIRLS) <br>');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `pdotrial1`
--
ALTER TABLE `pdotrial1`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `pdotrial1`
--
ALTER TABLE `pdotrial1`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;
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 */;