/ home / ankit@iiitd.edu.in / [ HOME SHELL ]

Name	Size	Permission
.cache	[ DIR ]	drwx------
.bash_history	354 B	-rw-------
.bash_logout	220 B	-rw-r--r--
.bashrc	3.68 KB	-rw-r--r--
.mysql_history	1.81 KB	-rw-------
.mysql_history.TMP	0 B	-rw-------
.profile	807 B	-rw-r--r--
cipdapp2025.sql	5.34 KB	-rw-r--r--
ihernblog_db.sql	1.34 MB	-rw-r--r--
mathnew.sql	16.46 MB	-rw-r--r--

Code Editor : cipdapp2025.sql

-- phpMyAdmin SQL Dump
-- version 4.4.15.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 31, 2025 at 12:10 PM
-- Server version: 5.7.14-log
-- PHP Version: 5.4.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `cipdapp2025`
--

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

--
-- Table structure for table `adminlogin`
--

CREATE TABLE IF NOT EXISTS `adminlogin` (
  `adID` int(11) NOT NULL,
  `adName` varchar(100) NOT NULL,
  `adEmail` varchar(100) NOT NULL,
  `adMobile` varchar(50) NOT NULL,
  `adPassword` varchar(100) NOT NULL,
  `adDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tokenCode` varchar(100) NOT NULL,
  `userStatus` enum('Y','N') DEFAULT 'N'
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adminlogin`
--

INSERT INTO `adminlogin` (`adID`, `adName`, `adEmail`, `adMobile`, `adPassword`, `adDate`, `tokenCode`, `userStatus`) VALUES
(1, 'CIPD Admin 1', 'cipdadmin@gmail.com', '88888888888', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2024-12-08 20:03:48', 'f4c08fa48f44fcd991f4be2200db739b', 'Y'),
(3, 'Satish Kumar', 'satish@gmail.com', '88888888888', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2024-12-13 13:54:34', '24e3442cdc9c7db08e55b5cf2cb1f005', 'Y'),
(4, 'CIPDAdmin 2', 'cipdadmin2@gmail.com', '9999408072', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2024-12-21 11:47:48', '73d733aa87482f44acf6a587db966136', 'Y'),
(5, 'CIPD Admin', 'cipd@iiitd.ac.in', '9899909776', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2024-02-09 17:04:38', '8e2f0ad8df6d51f93514474494296114', 'Y');

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

--
-- Table structure for table `authsession`
--

CREATE TABLE IF NOT EXISTS `authsession` (
  `authsessionID` int(11) NOT NULL,
  `studentID` int(11) NOT NULL,
  `authtokenid` varchar(500) NOT NULL,
  `loginFlg` varchar(100) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `personalinformation`
--

CREATE TABLE IF NOT EXISTS `personalinformation` (
  `PID` int(11) NOT NULL,
  `studentID` int(11) NOT NULL,
  `studentName` varchar(222) NOT NULL,
  `emailID` varchar(200) NOT NULL,
  `countryCode` varchar(10) NOT NULL,
  `mobileNumber` varchar(15) NOT NULL,
  `institutionName` varchar(500) NOT NULL,
  `department` varchar(15) NOT NULL,
  `yourTitle` varchar(200) NOT NULL,
  `institutionType` varchar(100) NOT NULL,
  `firstChoice` varchar(100) NOT NULL,
  `howManyTimes` varchar(100) NOT NULL,
  `secondChoice` varchar(200) NOT NULL,
  `howManyTimes2` varchar(52) NOT NULL,
  `feecover` varchar(100) NOT NULL,
  `approverEmail` varchar(200) NOT NULL,
  `approverTitle` varchar(200) NOT NULL,
  `approverOtherTitle` varchar(200) NOT NULL,
  `applicationStatus` varchar(100) NOT NULL,
  `formStatus` varchar(22) NOT NULL,
  `Subdate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `studentregistration`
--

CREATE TABLE IF NOT EXISTS `studentregistration` (
  `studentID` int(11) NOT NULL,
  `studentName` varchar(100) NOT NULL,
  `studentEmail` varchar(100) NOT NULL,
  `studentMobile` varchar(100) NOT NULL,
  `institutionName` varchar(500) NOT NULL,
  `domains` varchar(500) NOT NULL,
  `subdomains` varchar(500) NOT NULL,
  `experience` varchar(500) NOT NULL,
  `yourTitle` varchar(100) NOT NULL,
  `linkdinurl` varchar(500) NOT NULL,
  `weburl` varchar(500) NOT NULL,
  `studentPassword` varchar(500) NOT NULL,
  `regDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lcv` varchar(200) DEFAULT NULL,
  `tokenCode` varchar(100) NOT NULL,
  `userStatus` enum('Y','N') DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `adminlogin`
--
ALTER TABLE `adminlogin`
  ADD PRIMARY KEY (`adID`);

--
-- Indexes for table `authsession`
--
ALTER TABLE `authsession`
  ADD PRIMARY KEY (`authsessionID`);

--
-- Indexes for table `personalinformation`
--
ALTER TABLE `personalinformation`
  ADD PRIMARY KEY (`PID`);

--
-- Indexes for table `studentregistration`
--
ALTER TABLE `studentregistration`
  ADD PRIMARY KEY (`studentID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `adminlogin`
--
ALTER TABLE `adminlogin`
  MODIFY `adID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `authsession`
--
ALTER TABLE `authsession`
  MODIFY `authsessionID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `personalinformation`
--
ALTER TABLE `personalinformation`
  MODIFY `PID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `studentregistration`
--
ALTER TABLE `studentregistration`
  MODIFY `studentID` int(11) NOT NULL AUTO_INCREMENT;
/*!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 */;

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.

${this.title}

Code Editor : cipdapp2025.sql

Urban Research Lab