/ var / www / html / cipd-org-old / [ HOME SHELL ]

Name	Size	Permission	Action
database-bkup	[ DIR ]	drwxr-xr-x
instance	[ DIR ]	drwxr-xr-x
old-data	[ DIR ]	drwxr-xr-x
static	[ DIR ]	drwxr-xr-x
templates	[ DIR ]	dr-xr-xr-x
CIPD.zip	110.34 MB	-rw-r--r--
app.py	6.63 KB	-rwxr-xr-x
cipd.sql	12.2 KB	-rw-r--r--
data.py	3.91 KB	-rw-r--r--
get-pip.py	1.82 MB	-rw-r--r--
index.html-old	20 B	-rw-r--r--
nohup.out	12.27 MB	-rw-------
tempCodeRunnerFile.py	4.74 KB	-rw-r--r--
test_connection.py	307 B	-rw-r--r--

Code Editor : cipd.sql

--#drop database if exists CIPD;
--#CREATE DATABASE CIPD;
USE cipd;

CREATE TABLE Leaders (
    PID INT AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(255) NOT NULL,
    Designation VARCHAR(255) NOT NULL,
    Institute_Company VARCHAR(255),
    Image VARCHAR(255),
    Role VARCHAR(255),
    Profile_Link VARCHAR(255),
    Description TEXT   
);
CREATE TABLE Experts (
    PID INT AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(255) NOT NULL,
    Designation VARCHAR(255) NOT NULL,
    Institute_Company VARCHAR(255),
    Image VARCHAR(255),
    Profile_Link VARCHAR(255),
    Qualification VARCHAR(255)
);
CREATE TABLE Interns (
    PID INT AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(255) NOT NULL,
    Student_Category VARCHAR(255) NOT NULL,
    Institute VARCHAR(255) NOT NULL,
    Image VARCHAR(255),
    LinkedIn_Profile_Link VARCHAR(255)
);
CREATE TABLE Partners (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    image_url VARCHAR(200),
    category VARCHAR(50)
);

CREATE TABLE Services (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT NOT NULL,
    image VARCHAR(255) NOT NULL
);

CREATE TABLE Banners (
    id INT AUTO_INCREMENT PRIMARY KEY,
    location VARCHAR(255) NOT NULL,
    type ENUM('video', 'image') NOT NULL,
    device ENUM('mobile', 'laptop') NOT NULL,
    date_valid_from DATE,
    date_valid_to DATE
);
CREATE TABLE Products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    image VARCHAR(255),
    description TEXT,
    key_point_1 VARCHAR(255),
    key_point_2 VARCHAR(255),
    key_point_3 VARCHAR(255),
    key_point_4 VARCHAR(255),
    key_point_5 VARCHAR(255),
    key_point_6 VARCHAR(255),
    link VARCHAR(255)
);
CREATE TABLE contact (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
	phone VARCHAR(50) NOT NULL,
    email VARCHAR(100) ,
    organization VARCHAR(100) ,
	role VARCHAR(50) ,
    message TEXT NOT NULL
);

INSERT INTO Leaders (Name, Designation, Institute_Company, Image, Role, Profile_Link, Description) VALUES
('Dr. Anuj Grover', 'Associate Professor', 'IIIT-Delhi', 'images/dranuj.jpg', 'Head CiPD', 'https://www.iiitd.ac.in/anujg', '');
INSERT INTO Leaders (Name, Designation, Institute_Company, Image, Role, Profile_Link, Description) VALUES
('Late Mr. Mahendra Pratap', 'Cofounder', 'HCL', 'images/mahendrapratap.jpg', 'Ex CSO','https://www.linkedin.com/in/mahendra-pratap-386166a/?originalSubdomain=in', 'Some Description');
INSERT INTO Experts (Name, Designation, Institute_Company, Image, Profile_Link, Qualification) VALUES
('A V Subramaniyam', 'Head (ECE) & Associate Professor (ECE, CSE)', 'IIIT-Delhi', 'images/subramanyam.jpg', 'https://iiitd.ac.in/subramanyam', 'Ph.D. (2012), Nanyang Technological University, Singapore'),
('Anmol Srivastava', 'Assistant Professor (HCD)', 'IIIT-Delhi', 'images/335514.jpg', 'https://www.iiitd.ac.in/anmol', 'Ph.D. (2019), IIT Guwahati, India'),
('Anubha Gupta', 'Associate Professor', 'IIIT-Delhi', 'images/anubhag.jpg', 'https://www.iiitd.ac.in/anubha', 'PhD (2015), IIT-Delhi'),
('Anuj Grover', 'Professor (ECE)', 'IIIT-Delhi', 'images/dranuj.jpg', 'https://www.iiitd.ac.in/anujg', 'PhD (2015), IIT-Delhi'),
('Arani Bhattacharya', 'Associate Professor(CSE,ECE)', 'IIIT-Delhi', 'images/cipdsirarani.jpg', 'https://iiitd.ac.in/arani', 'Ph.D. (2019), Stony Brook University'),
('Bapi Chatterjee', 'Assistant Professor (CSE)', 'IIIT-Delhi', 'images/bapi.jpg', 'https://iiitd.ac.in/bapi', 'Ph.D. (2018), Chalmers University of Technology, Gothenburg, Sweden'),
('Debidas Kundu', 'Assistant Professor (ECE)', 'IIIT-Delhi', 'images/cipdwebsitedesbidas.jpeg', 'https://www.iiitd.ac.in/debidas', 'Ph.D. (2018), Indian Institute of Technology Kharagpur, India'),
('Dhananjay V. Gadre', 'Associate Professor', 'NSUT', 'images/dvg.png', 'http://nsut.ac.in/en/node/269', 'MSc, University of Delhi and M.Engr, University of Idaho, USA'),
('Dhruv Kumar', 'Assistant Professor (CSE)', 'IIIT-Delhi', 'images/dhruvk.jpg', 'https://www.iiitd.ac.in/dhruv', 'Ph.D. (2022), University of Minnesota, Twin Cities, USA'),
('Dipali Bansal', 'Campus Director (EE)', 'DSEU Okhla', 'images/drdiplaibansal.jpeg', 'https://dseu.ac.in/faculties/dipali-bansal/index.html', 'Ph.D., Jamia Millia Islamia, Delhi, India'),
('Jainendra Shukla', 'Assistant Professor (CSE, HCD)', 'IIIT-Delhi', 'images/Jainendra.jpg', 'https://www.iiitd.ac.in/jainendra', 'Ph.D. (2018), Universitat Rovira i Virgili (URV), Spain'),
('Kalpana Shankhwar', 'Assistant Professor (HCD)', 'IIIT-Delhi', 'images/kalpana.jpg', 'https://www.iiitd.ac.in/kalpana', 'Ph.D. (2022), National Taiwan University'),
('Kaushik Saha', 'Professor', 'IIT-Delhi', 'images/cipdwebsitekaushik.jpg', 'https://ctech.iitd.ac.in/ksaha.html', 'Ph.D., IIT-Delhi'),
('Manish Verma', 'Industry Expert and Consultant', '', 'images/manish.png', 'http://LinkedIn.com/in/manishve', 'Ph.D., Amity University Noida'),
('Mukulika Maity', 'Assistant Professor (CSE)', 'IIIT-Delhi', 'images/mukulikam.jpg', 'https://iiitd.ac.in/mukulika', 'Ph.D. (2017), IIT Bombay, India'),
('Ojaswa Sharma', 'Associate Professor', 'IIIT-Delhi', 'images/ojaswa.jpg', 'https://www.iiitd.ac.in/ojaswa', 'Ph.D. (2010), Technical University of Denmark, Denmark'),
('Piyus Kedia', 'Assistant Professor (CSE)', 'IIIT-Delhi', 'images/piyuskedia.jpg', 'https://www.iiitd.ac.in/piyus', 'Ph.D., IIT-Delhi'),
('Pravesh Biyani', 'Associate Professor (ECE)', 'IIIT-Delhi', 'images/praveshbiyani.jpg', 'https://www.iiitd.ac.in/praveshb', 'Ph.D. (2012), IIT-Delhi'),
('P. V. Madhusudhan Rao', 'Professor', 'IIT-Delhi', 'images/pvm.jpg', 'https://web.iitd.ac.in/~pvmrao/', 'Ph.D., IIT-Kanpur'),
('Rajiv Ratn Shah', 'Associate Professor (CSE, HCD)', 'IIIT-Delhi', 'images/ratn.jpg', 'https://www.iiitd.ac.in/rajivratn', 'Ph.D. (2017), National University of Singapore, Singapore'),
('Ramanathan Meipporul','Industry Expert and Consultant','','images/Ramanathan.jpg','https://www.linkedin.com/in/ramanathanmeipporul/?originalSubdomain=in','Madurai Kamaraj University')  ,      
('Rihan Suri','Director, Centre for Innovation & Entrepreneurship','JMI Central University','images/cipdwebsiterihan.jpeg','https://www.linkedin.com/in/profrihansuri/','Ph.D. in Management from Jamia Hamdard (Hamdard University), New Delhi.'),
('Rinku Shah', 'Assistant Professor (CSE)', 'IIIT-Delhi', 'images/rinku.jpg', 'https://iiitd.ac.in/rinku', 'Ph.D. (2021), IIT Bombay'),
('Sabyasachi Paldas', 'Professor of Practice', 'IIT-Delhi', 'images/sp photo.jpg', '', ''),
('Sanat K Biswas', 'Assistant Professor (ECE)', 'IIIT-Delhi', 'images/sanatk.jpg', 'https://iiitd.ac.in/sanat', 'Ph.D. (2018), Space Vehicle Navigation, The University of New South Wales'),
('Sayan Basu Roy', 'Assistant Professor (ECE)', 'IIIT-Delhi', 'images/sayan.jpg', 'https://www.iiitd.ac.in/sayan', 'Ph.D. (2019), IIT-Delhi'),
('Sneh Saurabh', 'Associate Professor (ECE)', 'IIIT-Delhi', 'images/sneh.jpg', 'https://www.iiitd.ac.in/sneh', 'Ph.D. (2012), IIT-Delhi'),
('Subir Dey', 'Assistant Professor', 'IIT-Delhi', 'images/2061201.jpg', 'https://iitd.irins.org/profile/206120', 'Ph.D., Indian Institute of Technology Guwahati'),
('Sujay Deb', 'Professor (ECE, CSE)', 'IIIT-Delhi', 'images/sujay.jpg', 'https://iiitd.ac.in/sded', 'Ph.D. (2012), Washington State University'),
('Sumit J Darak', 'Associate Professor (ECE)', 'IIIT-Delhi', 'images/sumit.jpg', 'https://iiitd.ac.in/sumit', 'Ph.D. (2013), Nanyang Technological University (NTU), Singapore'),
('Sunil Jha', 'Professor', 'IIT-Delhi', 'images/suniljha.jpg', 'https://mech.iitd.ac.in/content/jha-sunil', 'Ph.D., IIT-Kanpur'),
('Vinayak Abrol', 'Assistant Professor (CSE)', 'IIIT-Delhi', 'images/vabrol.jpg', 'https://iiitd.ac.in/vabrol', 'Ph.D. (2018), IIT-Mandi'),
('Vivek Bohara', 'Professor (ECE)', 'IIIT-Delhi', 'images/vivek.jpg', 'https://www.iiitd.ac.in/vivek', 'Ph.D. (2011), Nanyang Technological University, Singapore');

INSERT INTO Interns (Name, Student_Category, Institute, Image, LinkedIn_Profile_Link) VALUES
('Aditya Yadav', 'Btech', 'IIIT-Delhi', 'images/adityayadav.jpg', NULL),
('Aniket Kanojia', 'Btech', 'IIIT-Delhi', 'images/aniketkanojia.jpg', 'www.linkedin.com/in/aniket-kanojia-4a73b8239'),
('Archit Garg', 'Btech', 'IIIT-Delhi', 'images/archit.jpg', 'https://www.linkedin.com/in/archit-garg-6719a020a'),
('Dhruv Garg', 'Btech', 'IIIT-Delhi', 'images/dhruvg.jpg', 'https://www.linkedin.com/in/dhruv-garg-7324171b2'),
('Himanshu Choudhary', 'Btech', 'IIIT-Delhi', 'images/himanshuchoudhary.jpg', NULL),
('Raj Gupta', 'Btech', 'IIIT-Delhi', 'images/Raj.jpg', 'https://www.linkedin.com/in/raj-gupta-626870202');

INSERT INTO Partners (name, image_url, category) VALUES
    ("GB pant", "images/pantcollege.jpg", "Academic"),
    ("iit delhi", "images/iitlogo.png", "Academic"),
    ("jamia milia islamia", "images/jamiacollege.jpg", "Academic"),
    ("nsut", "images/NSUT_logo.png", "Academic"),
    ("desmania", "images/desmania_logo.jpeg", "Industry"),
    ("elcina", "images/elcinalogo.png", "Industry"),
    ("epic", "images/epic.jpg", "Industry"),
    ("iesa", "images/iesa.jpg", "Industry"),
    ("onchip", "images/onchip_logo.jpeg", "Industry"),
    ("zettaone", "images/logo68.png", "Industry");

INSERT INTO Services (name, description, image) VALUES
    ("Ideation", "In CiPD, when we work on a problem, we use some of the most powerful tools like TRIZ to first understand the problem in detail and then come up with powerful ideas quickly.", "images/idea.jpg"),
    ("Research", "IIIT Delhi takes pride in being a research led teaching institute. We have numerous cross-disciplinary research centres that can explore help identify the best solutions and overcome challenges faced in implementing them.", "images/research.jpg"),
    ("Product", "When we work on a product at CiPD, we can help you handle immediate challenges to turn your offering into a globally competitive product. It may involve feature upgrades or additions, human-centred design/ redesign, embedding (more) intelligence (think AI), DFX (X could be manufacturability, repairability, cost, usability etc) and so on.", "images/product.jpg"),
    ("Solution", "Products are typically a part of a context where they serve a purpose. At CiPD we can help you expand the purposefulness of your products and repurpose them to create new solutions which can help you increase TAM and SAM.", "images/solution.jpg"),
    ("Consultancy", "We can offer you support and consultancy on any part of the design cycle above.", "images/consultancy.jpeg"),
    ("Mentoring and Support", "If you wish to develop the capability for in-house RnD, then we can help in nurturing your talented pool of engineers to add more value to your products and services.", "images/mentoring.webp");
    
    
    INSERT INTO Banners (location, type, device, date_valid_from, date_valid_to)
VALUES
    ('banners/CiPDslideshow.mp4', 'video', 'laptop', '2024-05-20', '2024-05-30'), -- Valid today
    ('banners/42470.jpg', 'image', 'laptop', '2024-05-01', '2024-05-10'), -- Not valid today
('banners/5879.jpg', 'image', 'mobile', NULL, NULL);

INSERT INTO Products
(name, image, description, key_point_1, key_point_2, key_point_3, key_point_4, key_point_5, key_point_6,link)
VALUES
('Water Pump Controller', 'images/waterpump2.png',
 'Meet the Water Pump Controller, a pivotal piece of our IoT-driven Intelligent Water Management System. With its cutting-edge AI, it enhances water efficiency and distribution for both urban and rural areas. This device smartly processes data to forecast demand, identify leaks, and guarantee effective delivery, making water management smarter and more sustainable. Welcome a future where managing water is more precise, reliable, and user-friendly.',
 'AI-Optimized', 'Leak Detection', 'Demand Forecasting', 'Real-Time Analysis', 'User-Friendly', 'Scalable',NULL);

INSERT INTO Products 
(name, image, description, key_point_1, key_point_2, key_point_3, key_point_4, key_point_5, key_point_6,link) 
VALUES 
('Tablet', 'images/tablet.png', 'Introducing India\'s premier student-focused tablet, meticulously crafted to revolutionize the educational landscape. Elevating the experience further, it seamlessly integrates the cutting-edge, AI-powered BharatGPT capabilities, setting a new benchmark in interactive learning.', 'AI-Powered', 'Powerful Processor', 'Latest Android OS', '8-inch HD Display', 'Repairable & Upgradable', NULL,'www.google.com');

Urban Research Lab

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.