/ var / www / html / greenpreneurs / [ HOME SHELL ]

Name	Size	Permission
api	[ DIR ]	drwxr-xr-x
client	[ DIR ]	drwxr-xr-x
node_modules	[ DIR ]	drwxr-xr-x
.env	733 B	-rw-r--r--
.gitignore	257 B	-rw-r--r--
ER Diagram.png	140.24 KB	-rw-r--r--
README.md	20 B	-rw-r--r--
auth.controller.js	5.83 KB	-rw-r--r--
database.sql	15.31 KB	-rw-r--r--
nohup.out	1.36 KB	-rw-------
package-lock.json	91.93 KB	-rw-r--r--
package.json	846 B	-rw-r--r--

Code Editor : database.sql

CREATE DATABASE  IF NOT EXISTS `greenpreneurs`;
USE `greenpreneurs`;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`AID` varchar(30) NOT NULL,
`Name` varchar(255) NOT NULL,
`Email` varchar(255) NOT NULL,
`ImageURL` varchar(255) DEFAULT NULL,
`totp_secret` varchar(36) NOT NULL,
`is_2fa_enabled` tinyint(1) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`last_login` timestamp NULL DEFAULT NULL,
`failed_attempts` int NOT NULL DEFAULT '0',
`locked_until` datetime DEFAULT NULL,
`backup_codes` text,
`salt` char(0) DEFAULT NULL,
PRIMARY KEY (`AID`),
UNIQUE KEY `Email` (`Email`)
);
LOCK TABLES `admin` WRITE;
INSERT INTO `admin` VALUES ('AID001','Satwik Garg','satwik22461@iiitd.ac.in','https://example.com/satwik1.jpg','PENDING',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),('AID002','Sanjeet Kumar Patel','sanjeet22444@iiitd.ac.in','https://example.com/satwik2.jpg','PENDING',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),('AID003','website','websitece81@gmail.com','https://example.com/admin.jpg','PENDING',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),('AID004','Jyoti Sharma','jyoti.sharma@iiitd.ac.in','https://example.com/admin.jpg','PENDING',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL);
UNLOCK TABLES;
DROP TABLE IF EXISTS `adminlog`;
CREATE TABLE `adminlog` (
`AID` varchar(30) NOT NULL,
`DateLogin` date NOT NULL,
`TimeLogin` time NOT NULL,
PRIMARY KEY (`AID`,`DateLogin`,`TimeLogin`),
CONSTRAINT `adminlog_ibfk_1` FOREIGN KEY (`AID`) REFERENCES `admin` (`AID`)
);
LOCK TABLES `adminlog` WRITE;
UNLOCK TABLES;
DROP TABLE IF EXISTS `blogdata`;
CREATE TABLE `blogdata` (
`BID` int NOT NULL AUTO_INCREMENT,
`ImageURL` varchar(255) DEFAULT NULL,
`CID` varchar(36) NOT NULL,
`Title` text NOT NULL,
`Content` text NOT NULL,
`AdminConfirmed` int DEFAULT '0',
`Date` date NOT NULL,
`Time` time NOT NULL,
PRIMARY KEY (`BID`),
KEY `CID` (`CID`),
CONSTRAINT `blogdata_ibfk_1` FOREIGN KEY (`CID`) REFERENCES `userdata` (`CID`)
);
LOCK TABLES `blogdata` WRITE;
INSERT INTO `blogdata` VALUES (1,'https://example.com/blog1.jpg','CID001','First Post','This is the content of the first post.',1,'2024-09-01','10:00:00'),(2,'https://example.com/blog2.jpg','CID002','Second Post','This is the content of the second post.',0,'2024-09-02','11:00:00'),(3,'https://example.com/blog3.jpg','CID003','Third Post','This is the content of the third post.',1,'2024-09-03','12:00:00'),(4,'https://example.com/blog4.jpg','CID004','Fourth Post','This is the content of the fourth post.',1,'2024-09-04','13:00:00'),(5,'https://example.com/blog5.jpg','CID005','Fifth Post','This is the content of the fifth post.',0,'2024-09-05','14:00:00'),(6,'https://example.com/blog6.jpg','CID006','Sixth Post','This is the content of the sixth post.',1,'2024-09-06','15:00:00'),(7,'https://example.com/blog7.jpg','CID007','Seventh Post','This is the content of the seventh post.',1,'2024-09-07','16:00:00'),(8,'https://example.com/blog8.jpg','CID008','Eighth Post','This is the content of the eighth post.',0,'2024-09-08','17:00:00'),(9,'https://example.com/blog9.jpg','CID009','Ninth Post','This is the content of the ninth post.',1,'2024-09-09','18:00:00'),(10,'https://example.com/blog10.jpg','CID010','Tenth Post','This is the content of the tenth post.',1,'2024-09-10','19:00:00');
UNLOCK TABLES;
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`CID` varchar(36) NOT NULL,
`BID` int NOT NULL,
`Text` text,
`Date` date NOT NULL,
`Time` time NOT NULL,
PRIMARY KEY (`CID`,`BID`,`Date`,`Time`),
KEY `BID` (`BID`),
CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`CID`) REFERENCES `userdata` (`CID`),
CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`BID`) REFERENCES `blogdata` (`BID`)
);

DROP TABLE IF EXISTS `editorial`;
CREATE TABLE `editorial` (
`EDID` int NOT NULL,
`Text` text,
`Date` date DEFAULT NULL,
`Time` time DEFAULT NULL,
PRIMARY KEY (`EDID`)
);
LOCK TABLES `editorial` WRITE;
INSERT INTO `editorial` VALUES (1,'Edotorial 1 content','2024-09-01','09:00:00'),(2,'Editorial 1 content.','2024-09-01','09:00:00'),(3,'Editorial 2 content.','2024-09-02','10:00:00'),(4,'Editorial 3 content.','2024-09-03','11:00:00'),(5,'Editorial 4 content.','2024-09-04','12:00:00'),(6,'Editorial 5 content.','2024-09-05','13:00:00'),(7,'Editorial 6 content.','2024-09-06','14:00:00'),(8,'Editorial 7 content.','2024-09-07','15:00:00'),(9,'Editorial 8 content.','2024-09-08','16:00:00'),(10,'Editorial 9 content.','2024-09-09','17:00:00'),(11,'Editorial 10 content.','2024-09-10','18:00:00');
UNLOCK TABLES;
DROP TABLE IF EXISTS `event`;
CREATE TABLE `event` (
`EID` int NOT NULL,
`Time` time DEFAULT NULL,
`Date` date DEFAULT NULL,
`URL` varchar(255) DEFAULT NULL,
`PhotoURL` varchar(255) DEFAULT NULL,
`Title` varchar(255) NOT NULL,
`Description` text,
PRIMARY KEY (`EID`)
);
LOCK TABLES `event` WRITE;
INSERT INTO `event` VALUES (1,'10:00:00','2024-10-01','https://event.com/1','https://event.com/photo1.jpg','Event 1','Description of event 1'),(2,'14:30:00','2024-10-02','https://event.com/2','https://event.com/photo2.jpg','Event 2','Description of event 2'),(3,'16:00:00','2024-10-03','https://event.com/3','https://event.com/photo3.jpg','Event 3','Description of event 3');
UNLOCK TABLES;
DROP TABLE IF EXISTS `likedata`;
CREATE TABLE `likedata` (
`CID` varchar(36) NOT NULL,
`BID` int NOT NULL,
`TotalLike` int DEFAULT '0',
PRIMARY KEY (`CID`,`BID`),
KEY `BID` (`BID`),
CONSTRAINT `likedata_ibfk_1` FOREIGN KEY (`CID`) REFERENCES `userdata` (`CID`),
CONSTRAINT `likedata_ibfk_2` FOREIGN KEY (`BID`) REFERENCES `blogdata` (`BID`)
);
LOCK TABLES `likedata` WRITE;
INSERT INTO `likedata` VALUES ('CID001',1,5),('CID002',2,3),('CID003',3,8),('CID004',4,2),('CID005',5,10),('CID006',6,7),('CID007',7,4),('CID008',8,6),('CID009',9,1),('CID010',10,9);
UNLOCK TABLES;
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`Email` varchar(255) NOT NULL,
`DateLogin` date NOT NULL,
`TimeLogin` time NOT NULL,
PRIMARY KEY (`Email`,`DateLogin`,`TimeLogin`)
);
LOCK TABLES `log` WRITE;
UNLOCK TABLES;
DROP TABLE IF EXISTS `product_list`;
CREATE TABLE `product_list` (
`PID` int NOT NULL AUTO_INCREMENT,
`CID` varchar(36) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`description` text,
`cost` decimal(10,2) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`imageURL` varchar(255) DEFAULT NULL,
PRIMARY KEY (`PID`),
KEY `CID` (`CID`),
CONSTRAINT `product_list_ibfk_1` FOREIGN KEY (`CID`) REFERENCES `userdata` (`CID`)
);
LOCK TABLES `product_list` WRITE;
UNLOCK TABLES;
DROP TABLE IF EXISTS `resources`;
CREATE TABLE `resources` (
`id` int NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`description` text,
`imageURL` varchar(255) DEFAULT NULL,
`websiteURL` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
);
LOCK TABLES `resources` WRITE;
INSERT INTO `resources` VALUES (1,'Learn Python','A beginner-friendly guide to learning Python programming.','https://example.com/python.jpg','https://example.com/python'),(2,'Web Development','Comprehensive tutorials on full-stack web development.','https://example.com/webdev.jpg','https://example.com/webdev');
UNLOCK TABLES;
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
`id` varchar(36) NOT NULL,
`user_id` varchar(36) NOT NULL,
`last_activity` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`expires_at` timestamp NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
CONSTRAINT `sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
);
LOCK TABLES `sessions` WRITE;
UNLOCK TABLES;
DROP TABLE IF EXISTS `sharedata`;
CREATE TABLE `sharedata` (
`BID` int NOT NULL,
`TotalShare` int DEFAULT '0',
`Date` date DEFAULT NULL,
`Time` time DEFAULT NULL,
PRIMARY KEY (`BID`),
CONSTRAINT `sharedata_ibfk_1` FOREIGN KEY (`BID`) REFERENCES `blogdata` (`BID`)
);
LOCK TABLES `sharedata` WRITE;
INSERT INTO `sharedata` VALUES (1,12,'2024-09-01','10:45:00'),(2,8,'2024-09-02','11:45:00'),(3,15,'2024-09-03','12:45:00'),(4,10,'2024-09-04','13:45:00'),(5,20,'2024-09-05','14:45:00'),(6,18,'2024-09-06','15:45:00'),(7,7,'2024-09-07','16:45:00'),(8,13,'2024-09-08','17:45:00'),(9,11,'2024-09-09','18:45:00'),(10,9,'2024-09-10','19:45:00');
UNLOCK TABLES;
DROP TABLE IF EXISTS `stories`;
CREATE TABLE `stories` (
`id` int NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`description` text,
`imageURL` varchar(255) DEFAULT NULL,
`websiteURL` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
);
LOCK TABLES `stories` WRITE;
INSERT INTO `stories` VALUES (1,'Overcoming Challenges','An inspiring story of overcoming life’s challenges.','https://example.com/challenges.jpg','https://example.com/challenges'),(2,'Tech Innovations','How technology is changing the world for the better.','https://example.com/tech.jpg','https://example.com/tech');
UNLOCK TABLES;
DROP TABLE IF EXISTS `userdata`;
CREATE TABLE `userdata` (
`CID` varchar(36) NOT NULL,
`Name` varchar(255) NOT NULL,
`Email` varchar(255) NOT NULL,
`ImageURL` varchar(255) DEFAULT NULL,
`totp_secret` varchar(32) NOT NULL DEFAULT 'PENDING',
`is_2fa_enabled` tinyint(1) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`last_login` timestamp NULL DEFAULT NULL,
`failed_attempts` int NOT NULL DEFAULT '0',
`locked_until` datetime DEFAULT NULL,
`backup_codes` text,
`salt` char(0) DEFAULT NULL,
PRIMARY KEY (`CID`),
UNIQUE KEY `Email` (`Email`),
UNIQUE KEY `idx_email` (`Email`)
);
LOCK TABLES `userdata` WRITE;
INSERT INTO `userdata` VALUES ('111566347630620970073','Udbhav Varma','varmaudbhav03@gmail.com','https://lh3.googleusercontent.com/a/ACg8ocK2X8m5AB7mFKnMBetOW9K-ZBQhHj1voEStKR5OPMdUJewgcdt4=s96-c','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('9f27e39b-20be-11f0-a8af-902e16a57733','Udbhav Varma','louistrance123@gmail.com',NULL,'JQ2WOVSUNQRXKL2GLU5WWOB7EUYWCWTM',0,'2025-04-24 03:45:53','2025-04-24 03:45:53',NULL,0,NULL,'[\"670154a6bcce553b31da81e34abedb475f643136919dfc7e15b6af3ed5e86177\",\"3dec355b8e7a49d1dcc1a15fd4684ada0ec5d88977e9fa68a7cd5a45150e06ed\",\"5c151b1a3c80549777eb5b5d248fdca47634433b4d64f86b08fbc33621c16402\",\"a7a3686a0bbafcbac413c7a41513ae86c8c03dabbba18f9197ed56d42c2502b5\",\"d51a05c552195ddda5a68350e0183db5d759fcb32fe22a190ab8f0dc298ffbd5\",\"003bdf8671ad7f206c9a2d4060a9850c95ad2e0357bac37059b82671e8ae85e3\",\"33e668f9298b8456e8555f612ffe1e8b6abc01ee8b140038f0ebb7581d38a6ce\",\"ca4df46aee4a91e7cd5e29ab61c8be93997db47915d059e08c7e16dce2fee639\"]',NULL),('ccbf9819-201f-11f0-a8af-902e16a57733','Udbhav Varma','udbhav21433@iiitd.ac.in',NULL,'FFPCQ4D5IYUXOSZDNASE422JKRBSYWZZ',1,'2025-04-23 08:48:59','2025-04-23 16:17:50','2025-04-23 16:17:50',0,NULL,'[\"25a8a2c26069f77aab01611f1228d0e2ac4b1072247aa82333bcd2c5514d89aa\",\"5b9303640f6b3d3116af3810934926437fe56503a817494a0f7eb468ef1b1cce\",\"4c8dd309abaa847a24da4c607841ada639fc1b61885f0f4931eb8b9ce4e6151d\",\"024c630c0a5506ab129aa52dfd507e2309b4a58a48480f8c21e6eea0ebb9d30d\",\"1f774a4a803157287afa9bb2a954b771657144e1b48f6c24a95da9c34382cf4e\",\"88593db119c3afa58f6c0de20d294ed48c137cbd823641fe20dbb2d774e82d67\",\"ec33b5559218885819b123fabc8bb5e807c81d418113e18cbf04e77497db42ec\"]',NULL),('CID001','Alice Smith','alice@example.com','https://example.com/alice.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID002','Bob Johnson','bob@example.com','https://example.com/bob.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID003','Charlie Brown','charlie@example.com','https://example.com/charlie.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID004','David Lee','david@example.com','https://example.com/david.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID005','Eva Adams','eva@example.com','https://example.com/eva.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID006','Frank White','frank@example.com','https://example.com/frank.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID007','Grace Green','grace@example.com','https://example.com/grace.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID008','Hannah Black','hannah@example.com','https://example.com/hannah.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID009','Ian Gray','ian@example.com','https://example.com/ian.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('CID010','Jane Blue','jane@example.com','https://example.com/jane.jpg','PENDING',0,'2025-04-23 06:05:39','2025-04-23 06:17:33',NULL,0,NULL,NULL,NULL),('eca922c0-201e-11f0-a8af-902e16a57733','Udbhav Varma','varmaudbhav@gmail.com',NULL,'OYUDMT2VI4STC5KXN5OUOZSHJNBFELDO',0,'2025-04-23 08:42:44','2025-04-23 08:42:44',NULL,0,NULL,'[\"ff8abbf845916bfe2fc5cc0bcc8f00511dd5d79d629179c8309d84bb1065ad6b\",\"c10fab8d64e34171ebd9014da0a8579b5f669f7f912688b7d90e6f3eb9e69a5d\",\"9ac9803af9497cbaf00ad02936949aa03011bcaaa36785e9dfa95a8824fc4be9\",\"1598ba702b60ae161e76c0647810fb58e585532d4ada8ad5eb86ff3f74ed1b5d\",\"1cec1c7a8a645f09d6954231e6f61ada9da34b7ab1abab322b0b1b8a9a6ab2a4\",\"14c75a7e131833835f4164d7f9a54858bb029ccc6aeef21541826b0b5c476edb\",\"82b3f89483722e33cb912301242d701570502bd484042b380d394f6c89f142ad\",\"fb1dba07cb806aae1d7bcb3fbbe8ea04cf64efe360e8c90f8cb3cfe51eff1c0a\"]',NULL);
UNLOCK TABLES;

DROP TABLE IF EXISTS `verified_ent_map_user`;
CREATE TABLE `verified_ent_map_user` (
`CID` varchar(36) NOT NULL,
`id` int NOT NULL,
PRIMARY KEY (`CID`,`id`),
KEY `id` (`id`),
CONSTRAINT `verified_ent_map_user_ibfk_1` FOREIGN KEY (`CID`) REFERENCES `userdata` (`CID`),
CONSTRAINT `verified_ent_map_user_ibfk_2` FOREIGN KEY (`id`) REFERENCES `verifiedent` (`id`)
);
LOCK TABLES `verified_ent_map_user` WRITE;
UNLOCK TABLES;
DROP TABLE IF EXISTS `verifiedent`;
CREATE TABLE `verifiedent` (
`id` int NOT NULL,
`FirstName` varchar(50) NOT NULL,
`LastName` varchar(50) NOT NULL,
`LinkedinProfileURL` varchar(255) NOT NULL,
`Email` varchar(100) NOT NULL,
`Website` varchar(255) NOT NULL,
`IsVerified` int DEFAULT '0',
`ProfileImage` varchar(255) DEFAULT NULL,
`Description` text,
PRIMARY KEY (`id`),
UNIQUE KEY `LinkedinProfileURL` (`LinkedinProfileURL`),
UNIQUE KEY `Email` (`Email`),
UNIQUE KEY `Website` (`Website`)
);
LOCK TABLES `verifiedent` WRITE;
INSERT INTO `verifiedent` VALUES (1,'Anshu','Gupta','/','a@','a',1,'https://i.ibb.co/mXD8mL7/goonj-founder.jpg','Founder, Goonj'),(2,'Tusshar','Aggarwal','/1','b@','b',1,'https://i.ibb.co/9bQn8T2/tushar.jpg','Founder, Rise'),(3,'Robert','Saik','/2','c@','3',1,'https://i.ibb.co/vX8nkhW/robert.jpg','Founder, AGvisorPRO'),(4,'Amrit','Om Nayak','/d','/d@','d',1,'https://i.ibb.co/WWX4Gp9/image.png','Co-founder, Indra\nWater'),(5,'Hank','Adams','/e','e@','e',1,'https://i.ibb.co/jvK5BYw/image.png','Founder, Rise Garden');
UNLOCK TABLES;
DROP TABLE IF EXISTS `viewdata`;
CREATE TABLE `viewdata` (
`BID` int NOT NULL,
`TotalViews` int DEFAULT '0',
`Date` date NOT NULL,
`Time` time NOT NULL,
PRIMARY KEY (`BID`),
CONSTRAINT `viewdata_ibfk_1` FOREIGN KEY (`BID`) REFERENCES `blogdata` (`BID`)
);
LOCK TABLES `viewdata` WRITE;
INSERT INTO `viewdata` VALUES (1,121,'2024-09-01','10:30:00'),(2,85,'2024-09-01','11:00:00'),(3,200,'2024-09-02','09:15:00'),(4,150,'2024-09-03','12:45:00'),(5,61,'2024-09-04','14:10:00');
UNLOCK TABLES;
SET FOREIGN_KEY_CHECKS = 1;

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

Urban Research Lab