/ var / www / html / cipdapplication / old / database / [ HOME SHELL ]

Name	Size	Permission	Action
iiitdfeeportal (6).sql	8.43 KB	-rw-r--r--

Code Editor : iiitdfeeportal (6).sql

-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 13, 2019 at 01:20 PM
-- Server version: 5.7.21
-- PHP Version: 5.6.35

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

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

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

DROP TABLE IF EXISTS `adminlogin`;
CREATE TABLE IF NOT EXISTS `adminlogin` (
  `adID` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`adID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `adminlogin` (`adID`, `adName`, `adEmail`, `adMobile`, `adPassword`, `adDate`, `tokenCode`, `userStatus`) VALUES
(1, 'Admin', 'iiitdadmin@gmail.com', '88888888888', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2019-10-08 20:03:48', 'f4c08fa48f44fcd991f4be2200db739b', 'Y'),
(3, 'Satish Kumar', 'satish@gmail.com', '88888888888', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2019-10-13 13:54:34', '24e3442cdc9c7db08e55b5cf2cb1f005', 'Y');

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

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

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

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

INSERT INTO `authsession` (`authsessionID`, `studentID`, `authtokenid`, `loginFlg`) VALUES
(39, 1, '4c39b0fc453348266880fd88db87deac', 'Y'),
(38, 4, '9601e04c0343548b9b1a45001d887ac9', 'Y');

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

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

DROP TABLE IF EXISTS `hostelfee`;
CREATE TABLE IF NOT EXISTS `hostelfee` (
  `hostelfeeID` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`hostelfeeID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 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`) VALUES
(1, 4, 'Ramjee Bharti', '8840268108', 'B. Tech', 'Semester I', 'CSE', 'ramjeeit3029@gmail.com', '1398', '2019-10-13 18:01:16', 'NEFT-RTGS', 'N', '', '', '', '', '3232', '10/11/2019', '', '', 'HOSTELFEE', '556655', '', 'hdfc', '', '10/13/2019', 'Sharing', '600');

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

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

DROP TABLE IF EXISTS `studentregistration`;
CREATE TABLE IF NOT EXISTS `studentregistration` (
  `studentID` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`studentID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

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

INSERT INTO `studentregistration` (`studentID`, `studentName`, `studentEmail`, `studentMobile`, `studentPassword`, `regDate`, `tokenCode`, `userStatus`) VALUES
(4, 'Ramjee Bharti', 'ramjeeit3029@gmail.com', '8840268108', 'df5a48cb0f7349114cf50c5c1f1888926de60d75ba7c78809b5ceb719c12c4f4', '2019-10-02 21:29:59', 'cb805c2f9633744a526cf66ac664008b', 'Y'),
(5, 'Shivjee Bharti', 'ramjee9889@gmail.com', '8840268108', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2019-10-02 22:07:11', 'f306ef84c85f09b0cac920a74fd0b5ca', 'Y'),
(6, 'Ankit Agrawal', 'test@gmail.com', '8840268108', '65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5', '2019-10-09 21:33:27', 'a76b8ebed6e45a9b0099ce1b31db8acb', 'Y');

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

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

DROP TABLE IF EXISTS `tutionfee`;
CREATE TABLE IF NOT EXISTS `tutionfee` (
  `tutionfeeID` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  `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 '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,
  PRIMARY KEY (`tutionfeeID`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

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

INSERT INTO `tutionfee` (`tutionfeeID`, `studentID`, `studentName`, `studentMobile`, `program`, `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`) VALUES
(72, 4, 'Ramjee Bharti', '8840268108', 'B. Tech', 'Semester I', 'CSE', 'ramjeeit3029@gmail.com', '100000', '4000', '', '106000', '2019-10-13 12:30:28', '2000', 'Demand-Draft', 'N', '123450', '122222', 'ICICI BANK LTD', '10/14/2019', '', '', '', '', 'TUTIONFEE', '556655', '', '', '', '10/13/2019'),
(71, 5, 'Shivjee Bharti', '8840268108', 'B. Tech', 'Semester I', 'CSE', 'ramjee9889@gmail.com', '100000', '4000', '500', '106500', '2019-10-13 09:47:23', '2000', 'Demand-Draft', 'N', '123450', '122222', 'ICICI BANK LTD', '10/17/2019', '', '', '', '', 'TUTIONFEE', '556655', '', '', '', '10/13/2019');
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 : iiitdfeeportal (6).sql

Urban Research Lab