/ var / www / html / temppayment / pg / studentsfee / database / [ HOME SHELL ]

Name	Size	Permission	Action
grabogec_iiitd.sql	18.58 KB	-rw-r--r--

Code Editor : grabogec_iiitd.sql

-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 26, 2020 at 04:28 PM
-- Server version: 5.6.41-84.1
-- PHP Version: 7.3.6

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: `grabogec_iiitd`
--

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

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

CREATE TABLE `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',
  `makerstamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updstamp` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `adminlogin` (`adID`, `adName`, `adEmail`, `adMobile`, `adPassword`, `adDate`, `tokenCode`, `userStatus`, `makerstamp`, `updstamp`) VALUES
(2, 'Admin', 'iiitdelhi@gmail.com', '88888888888', 'df5a48cb0f7349114cf50c5c1f1888926de60d75ba7c78809b5ceb719c12c4f4', '2019-10-10 17:49:54', '9ce3364cf8175cd64a285492eadb4c42', 'Y', '2019-10-13 07:45:51', '2020-05-01 13:18:00'),
(3, 'Satish Kumar', 'satish@gmail.com', '88888888888', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2019-10-13 08:27:11', '727c7df4182b89ac97e409523603843c', 'N', '2019-10-13 08:27:11', '0000-00-00 00:00:00'),
(4, 'Ankit Agarwal', 'ankit.agr23@gmail.com', '09899909776', '03ac674216f3e15c761ee1a5e255f067953623c8b388b4459e13f978d7c846f4', '2019-10-22 06:56:05', 'fe54030426e19055bbe29564df9f23ad', 'N', '2019-10-22 06:56:05', '0000-00-00 00:00:00');

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

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

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

--
-- Dumping data for table `authsession`
--

INSERT INTO `authsession` (`authsessionID`, `studentID`, `authtokenid`, `loginFlg`) VALUES
(70, 7, 'de7cfb8f8caa9e03b5f1e87b899d220a', 'Y'),
(60, 6, 'e7d67b049d17c6dc8030e71b6c1c909b', 'Y'),
(71, 2, '2be5fab98e5f87e151232bd53c779875', 'Y'),
(59, 4, '6c9ee3c3b916a468c17f083e785fdb4b', 'Y');

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

--
-- Table structure for table `batchupdate`
--

CREATE TABLE `batchupdate` (
  `batchID` int(11) NOT NULL,
  `programID` int(11) NOT NULL,
  `batch` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `batchupdate`
--

INSERT INTO `batchupdate` (`batchID`, `programID`, `batch`) VALUES
(53, 5, '2017'),
(52, 5, '2016'),
(51, 5, '2015'),
(50, 5, '2014'),
(49, 5, '2013'),
(48, 5, '2012'),
(47, 5, '2011'),
(46, 5, '2010'),
(45, 1, '2020'),
(44, 1, '2019'),
(43, 1, '2018'),
(42, 1, '2017'),
(41, 1, '2016'),
(40, 1, '2015'),
(39, 1, '2014'),
(38, 1, '2013'),
(37, 1, '2012'),
(36, 1, '2011'),
(35, 1, '2010'),
(54, 5, '2018'),
(55, 5, '2019'),
(56, 5, '2020'),
(57, 6, '2010'),
(58, 6, '2011'),
(59, 6, '2012'),
(60, 6, '2013'),
(61, 6, '2014'),
(62, 6, '2015'),
(63, 6, '2016'),
(64, 6, '2017'),
(65, 6, '2018'),
(66, 6, '2019'),
(67, 6, '2020'),
(68, 2, '2010'),
(69, 2, '2011'),
(70, 2, '2012'),
(71, 2, '2013'),
(72, 2, '2014'),
(73, 2, '2015'),
(74, 2, '2016'),
(75, 2, '2017'),
(76, 2, '2018'),
(77, 2, '2019'),
(78, 2, '2020'),
(79, 4, '2010'),
(80, 4, '2011'),
(81, 4, '2012'),
(82, 4, '2013'),
(83, 4, '2014'),
(84, 4, '2015'),
(85, 4, '2016'),
(86, 4, '2017'),
(87, 4, '2018'),
(88, 4, '2019'),
(89, 4, '2020');

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

--
-- Table structure for table `feeamountupdate`
--

CREATE TABLE `feeamountupdate` (
  `feeID` int(11) NOT NULL,
  `programID` int(11) NOT NULL,
  `batchID` int(11) NOT NULL,
  `feeAmount` varchar(100) NOT NULL,
  `cautionFee` varchar(100) NOT NULL,
  `alumniFee` varchar(100) NOT NULL,
  `makerstamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `feeamountupdate`
--

INSERT INTO `feeamountupdate` (`feeID`, `programID`, `batchID`, `feeAmount`, `cautionFee`, `alumniFee`, `makerstamp`) VALUES
(42, 6, 66, '175000', '0', '0', '2019-11-24 15:41:30'),
(34, 4, 88, '87500', '0', '0', '2019-11-24 15:37:29'),
(41, 6, 65, '137500', '0', '0', '2019-11-24 15:41:14'),
(40, 6, 64, '150000', '0', '0', '2019-11-24 15:40:44'),
(39, 6, 63, '150000', '0', '0', '2019-11-24 15:40:32'),
(38, 5, 55, '288000', '0', '0', '2019-11-24 15:39:37'),
(37, 5, 54, '288000', '0', '0', '2019-11-24 15:39:25'),
(36, 5, 53, '288000', '0', '0', '2019-11-24 15:39:12'),
(35, 5, 52, '288000', '0', '0', '2019-11-24 15:39:00'),
(33, 4, 87, '87500', '0', '0', '2019-11-24 15:37:15'),
(32, 2, 77, '70000', '0', '0', '2019-11-24 15:36:45'),
(31, 2, 76, '70000', '0', '0', '2019-11-24 15:36:25'),
(30, 1, 44, '175000', '0', '0', '2019-11-24 15:33:28'),
(29, 1, 43, '137500', '0', '0', '2019-11-24 15:33:15'),
(28, 1, 42, '150000', '0', '0', '2019-11-24 15:32:42'),
(27, 1, 41, '150000', '0', '0', '2019-11-24 15:32:19');

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

--
-- Table structure for table `feesubmitdate`
--

CREATE TABLE `feesubmitdate` (
  `feeID` int(11) NOT NULL,
  `program` varchar(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `firstDate` varchar(200) NOT NULL,
  `secondDate` varchar(200) NOT NULL,
  `thirdDate` varchar(200) NOT NULL,
  `forthDate` varchar(200) NOT NULL,
  `firstFineamount` varchar(200) NOT NULL,
  `secondFineAmount` varchar(100) NOT NULL,
  `makerstamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updstamp` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `feesubmitdate`
--

INSERT INTO `feesubmitdate` (`feeID`, `program`, `semester`, `firstDate`, `secondDate`, `thirdDate`, `forthDate`, `firstFineamount`, `secondFineAmount`, `makerstamp`, `updstamp`) VALUES
(1, 'B. Tech', 'Semester I', '11/15/2020', '11/30/2020', '11/31/2020', '11/30/2020', '1000', '10000', '2019-10-23 17:16:59', '2020-05-01 13:30:02');

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

--
-- Table structure for table `hostelfee`
--

CREATE TABLE `hostelfee` (
  `hostelfeeID` int(11) NOT NULL,
  `studentID` int(11) NOT NULL,
  `studentName` varchar(100) NOT NULL,
  `studentMobile` varchar(15) NOT NULL,
  `program` varchar(50) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `branch` varchar(15) NOT NULL,
  `studentEmail` varchar(200) NOT NULL,
  `totalfee` varchar(200) NOT NULL,
  `makerstamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `paymentmode` varchar(100) NOT NULL,
  `paymentstatus` enum('Y','N') DEFAULT 'N',
  `ddNumber` varchar(200) NOT NULL,
  `ddAmount` varchar(200) NOT NULL,
  `ddIssuingBank` varchar(200) NOT NULL,
  `ddIssueDate` varchar(100) NOT NULL,
  `utrNumber` varchar(200) NOT NULL,
  `neftRtgsDate` varchar(100) NOT NULL,
  `utrBankNumber` varchar(200) NOT NULL,
  `bankDate` varchar(100) NOT NULL,
  `feetype` varchar(100) NOT NULL,
  `rollNumber` varchar(300) NOT NULL,
  `otherDetails` varchar(300) NOT NULL,
  `remitterBank` varchar(500) NOT NULL,
  `bRemitterBank` varchar(500) NOT NULL,
  `subDate` varchar(100) NOT NULL,
  `roomType` varchar(300) NOT NULL,
  `roomNo` varchar(300) NOT NULL,
  `batch` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hostelfee`
--

INSERT INTO `hostelfee` (`hostelfeeID`, `studentID`, `studentName`, `studentMobile`, `program`, `semester`, `branch`, `studentEmail`, `totalfee`, `makerstamp`, `paymentmode`, `paymentstatus`, `ddNumber`, `ddAmount`, `ddIssuingBank`, `ddIssueDate`, `utrNumber`, `neftRtgsDate`, `utrBankNumber`, `bankDate`, `feetype`, `rollNumber`, `otherDetails`, `remitterBank`, `bRemitterBank`, `subDate`, `roomType`, `roomNo`, `batch`) VALUES
(2, 4, 'Ankit Agrawal', '8840268108', 'B. Tech', 'Semester I', 'CSE', 'admin@gmail.com', '1398', '2019-10-13 12:39:46', 'Demand-Draft', 'N', '123450', '122222', 'ICICI BANK LTD', '10/17/2019', '', '', '', '', 'HOSTELFEE', '556655', '', '', '', '10/13/2019', 'Single', '212', '');

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

--
-- Table structure for table `programname`
--

CREATE TABLE `programname` (
  `id` int(11) NOT NULL,
  `program` varchar(500) NOT NULL,
  `status` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `programname`
--

INSERT INTO `programname` (`id`, `program`, `status`) VALUES
(1, 'B. Tech', '2'),
(2, 'M. Tech (CB)', '2'),
(3, 'PhD', '1'),
(4, 'M. Tech (ECE/CSE)', '2'),
(5, 'B. Tech - DASA', '2'),
(6, 'B. Tech - DASA (CIWG)', '2');

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

--
-- Table structure for table `studentdetail`
--

CREATE TABLE `studentdetail` (
  `id` int(11) NOT NULL,
  `rollNumber` varchar(277) NOT NULL,
  `studentName` varchar(55) NOT NULL,
  `program` varchar(55) NOT NULL,
  `allottedSpecialisation` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `category` varchar(300) NOT NULL,
  `emailD` varchar(500) NOT NULL,
  `studentStatus` varchar(200) NOT NULL,
  `fatherName` varchar(200) NOT NULL,
  `status` varchar(100) NOT NULL,
  `branch` varchar(300) NOT NULL,
  `batch` varchar(500) NOT NULL,
  `semester` varchar(500) NOT NULL,
  `mobile` varchar(500) NOT NULL,
  `tutionFee` varchar(500) NOT NULL,
  `cautionFee` varchar(500) NOT NULL,
  `alumniFee` varchar(500) NOT NULL,
  `fine` varchar(500) NOT NULL,
  `totalFee` varchar(500) NOT NULL,
  `paidFee` varchar(500) NOT NULL,
  `balanceFee` varchar(500) NOT NULL,
  `feestatus` varchar(500) NOT NULL,
  `insurancePremium` varchar(300) NOT NULL,
  `swf` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `studentdetail`
--

INSERT INTO `studentdetail` (`id`, `rollNumber`, `studentName`, `program`, `allottedSpecialisation`, `gender`, `category`, `emailD`, `studentStatus`, `fatherName`, `status`, `branch`, `batch`, `semester`, `mobile`, `tutionFee`, `cautionFee`, `alumniFee`, `fine`, `totalFee`, `paidFee`, `balanceFee`, `feestatus`, `insurancePremium`, `swf`) VALUES
(84, 'MT18007', 'Anuparna Deb', 'MTECH', 'Artifical Intelligence', 'Female', 'General', 'anuparna18001@iiitd.ac.in', '', 'Subhabrata Deb', '2', 'CSE', '2018', 'II', '9992999', '50000', '0', '0', '', '50000', '0', '0', 'PENDING', '0', '0'),
(82, 'MT18006', 'Anuparna Deb', 'MTECH', 'Artifical Intelligence', 'Female', 'General', 'anuparna18001@iiitd.ac.in', '', 'Subhabrata Deb', '2', 'CSE', '2018', 'II', '9992999', '100000', '10000', '2000', '0', '100000', '0', '0', 'SUCCESS', '1100', '500'),
(83, 'MT18006', 'Anuparna Deb', 'MTECH', 'Artifical Intelligence', 'Female', 'General', 'anuparna18001@iiitd.ac.in', '', 'Subhabrata Deb', '2', 'CSE', '2018', 'III', '9992999', '50000', '0', '0', '', '50000', '0', '0', 'PENDING', '0', '0');

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

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

CREATE TABLE `studentregistration` (
  `studentID` int(11) NOT NULL,
  `rollNumber` varchar(100) NOT NULL,
  `studentName` varchar(100) NOT NULL,
  `studentEmail` varchar(100) NOT NULL,
  `studentMobile` varchar(50) NOT NULL,
  `studentPassword` varchar(100) NOT NULL,
  `regDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tokenCode` varchar(100) NOT NULL,
  `userStatus` enum('Y','N') DEFAULT 'N',
  `makerstamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updstamp` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `studentregistration`
--

INSERT INTO `studentregistration` (`studentID`, `rollNumber`, `studentName`, `studentEmail`, `studentMobile`, `studentPassword`, `regDate`, `tokenCode`, `userStatus`, `makerstamp`, `updstamp`) VALUES
(4, '', 'Ankit Agrawal', 'admin@gmail.com', '8840268108', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2019-10-02 21:29:59', '160c3cb5760c45cd596e81f94486b83f', 'Y', '2019-10-13 07:46:44', '0000-00-00 00:00:00'),
(7, 'MT18006', 'Ankit Agrawal', 'rahul3029@gmail.com', '8888888888', 'df5a48cb0f7349114cf50c5c1f1888926de60d75ba7c78809b5ceb719c12c4f4', '2020-05-01 13:38:36', '77ee7c94711a091c768d1ae1fb308433', 'Y', '2020-05-01 13:38:36', '2020-05-01 13:38:52');

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

--
-- Table structure for table `tutionfee`
--

CREATE TABLE `tutionfee` (
  `tutionfeeID` int(11) NOT NULL,
  `studentID` int(11) NOT NULL,
  `studentName` varchar(100) NOT NULL,
  `studentMobile` varchar(15) NOT NULL,
  `programID` varchar(110) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `branch` varchar(15) NOT NULL,
  `studentEmail` varchar(200) NOT NULL,
  `tutionFee` varchar(200) NOT NULL,
  `cautionFee` varchar(200) NOT NULL,
  `fine` varchar(200) NOT NULL,
  `totalfee` varchar(200) NOT NULL,
  `makerstamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `alumnifee` varchar(100) NOT NULL,
  `paymentmode` varchar(100) NOT NULL,
  `paymentstatus` enum('Y','N') DEFAULT 'Y',
  `ddNumber` varchar(200) NOT NULL,
  `ddAmount` varchar(200) NOT NULL,
  `ddIssuingBank` varchar(200) NOT NULL,
  `ddIssueDate` varchar(100) NOT NULL,
  `utrNumber` varchar(200) NOT NULL,
  `neftRtgsDate` varchar(100) NOT NULL,
  `utrBankNumber` varchar(200) NOT NULL,
  `bankDate` varchar(100) NOT NULL,
  `feetype` varchar(100) NOT NULL,
  `rollNumber` varchar(300) NOT NULL,
  `otherDetails` varchar(500) NOT NULL,
  `remitterBank` varchar(300) NOT NULL,
  `bRemitterBank` varchar(500) NOT NULL,
  `subDate` varchar(100) NOT NULL,
  `batchID` varchar(110) NOT NULL,
  `allottedSpecialisation` varchar(300) NOT NULL,
  `paidFee` varchar(500) NOT NULL,
  `balanceFee` varchar(200) NOT NULL,
  `feeStatus` varchar(300) NOT NULL,
  `payment` varchar(300) NOT NULL,
  `insurancePremium` varchar(300) NOT NULL,
  `swf` varchar(500) NOT NULL,
  `paystatus` varchar(20) NOT NULL,
  `fileUpload` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tutionfee`
--

INSERT INTO `tutionfee` (`tutionfeeID`, `studentID`, `studentName`, `studentMobile`, `programID`, `semester`, `branch`, `studentEmail`, `tutionFee`, `cautionFee`, `fine`, `totalfee`, `makerstamp`, `alumnifee`, `paymentmode`, `paymentstatus`, `ddNumber`, `ddAmount`, `ddIssuingBank`, `ddIssueDate`, `utrNumber`, `neftRtgsDate`, `utrBankNumber`, `bankDate`, `feetype`, `rollNumber`, `otherDetails`, `remitterBank`, `bRemitterBank`, `subDate`, `batchID`, `allottedSpecialisation`, `paidFee`, `balanceFee`, `feeStatus`, `payment`, `insurancePremium`, `swf`, `paystatus`, `fileUpload`) VALUES
(70, 7, 'Ankit Agrawal', '8888888888', 'MTECH', 'II', 'CSE', 'rahul3029@gmail.com', '100000', '-20000', '0', '100000', '2020-06-24 15:51:40', '0', 'Demand-Draft', 'Y', '88', '9999', 'iii', '07/02/2020', '', '', '', '', 'TUTIONFEE', 'MT18006', '', '', '', '06/24/2020', '2018', 'Artifical Intelligence', '53600', '46400', 'PARTIAL-PAYMENT', '26400', '0', '0', 'Y', ''),
(71, 7, 'Ankit Agrawal', '8888888888', 'MTECH', 'II', 'CSE', 'rahul3029@gmail.com', '100000', '10000', '0', '100000', '2020-06-24 15:53:17', '0', 'NEFT-RTGS', 'Y', '', '', '', '', '77', '06/30/2020', '', '', 'TUTIONFEE', 'MT18006', '', 'jj', '', '06/24/2020', '2018', 'Artifical Intelligence', '80000', '20000', 'FULL-PAYMENT', '20000', '0', '0', 'Y', ''),
(69, 7, 'Ankit Agrawal', '8888888888', 'MTECH', 'II', 'CSE', 'rahul3029@gmail.com', '100000', '-50000', '0', '100000', '2020-06-24 15:36:17', '2000', 'NEFT-RTGS', 'Y', '', '', '', '', '77', '07/31/2020', '', '', 'TUTIONFEE', 'MT18006', '', 'jj', '', '06/24/2020', '2018', 'Artifical Intelligence', '0', '0', 'PARTIAL-PAYMENT', '53600', '1100', '500', 'Y', '');

--
-- 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 `batchupdate`
--
ALTER TABLE `batchupdate`
  ADD PRIMARY KEY (`batchID`);

--
-- Indexes for table `feeamountupdate`
--
ALTER TABLE `feeamountupdate`
  ADD PRIMARY KEY (`feeID`);

--
-- Indexes for table `feesubmitdate`
--
ALTER TABLE `feesubmitdate`
  ADD PRIMARY KEY (`feeID`);

--
-- Indexes for table `hostelfee`
--
ALTER TABLE `hostelfee`
  ADD PRIMARY KEY (`hostelfeeID`);

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

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

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

--
-- Indexes for table `tutionfee`
--
ALTER TABLE `tutionfee`
  ADD PRIMARY KEY (`tutionfeeID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `adminlogin`
--
ALTER TABLE `adminlogin`
  MODIFY `adID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `authsession`
--
ALTER TABLE `authsession`
  MODIFY `authsessionID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `batchupdate`
--
ALTER TABLE `batchupdate`
  MODIFY `batchID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- AUTO_INCREMENT for table `feeamountupdate`
--
ALTER TABLE `feeamountupdate`
  MODIFY `feeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `feesubmitdate`
--
ALTER TABLE `feesubmitdate`
  MODIFY `feeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `hostelfee`
--
ALTER TABLE `hostelfee`
  MODIFY `hostelfeeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `programname`
--
ALTER TABLE `programname`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `studentdetail`
--
ALTER TABLE `studentdetail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT for table `studentregistration`
--
ALTER TABLE `studentregistration`
  MODIFY `studentID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tutionfee`
--
ALTER TABLE `tutionfee`
  MODIFY `tutionfeeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;
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 */;

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 : grabogec_iiitd.sql

Urban Research Lab