-- http://www.phpmyadmin.net
--




--
-- Database: `psychic`
--
CREATE DATABASE IF NOT EXISTS `psychic` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `psychic`;

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

--
-- Table structure for table `certificates`
--

CREATE TABLE IF NOT EXISTS `certificates` (
  `CertificateId` int(11) NOT NULL AUTO_INCREMENT,
  `CertificateTitle` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `CertificateImgPath` varchar(500) NOT NULL,
  PRIMARY KEY (`CertificateId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;

--
-- Dumping data for table `certificates`
--

INSERT INTO `certificates` (`CertificateId`, `CertificateTitle`, `CertificateImgPath`) VALUES
(1, 'Experience Certificate (Omniscient Softwares Pvt. Ltd.) 2015', 'psychic/certificate-images/omni-experience.jpg'),
(2, 'Congratutaltions Letter from MLA Mr. Balasaheb Thorat 2015', 'psychic/certificate-images/congrats-letter.jpg'),
(3, 'Microsoft Technology Associate (Software Development Fundamentals) 2012', 'psychic/certificate-images/microsoft2.jpg'),
(4, 'Microsoft Technology Associate (Database Administration Fundamentals) 2012', 'psychic/certificate-images/microsoft1.jpg'),
(5, 'Android Application Development Version 4.0 (Technocorp) 2014', 'psychic/certificate-images/Android-Technocorp.jpg'),
(6, 'Introduction to Embedded Programming Seminar 2015', 'psychic/certificate-images/Embedded-Systems.jpg'),
(7, 'Certified Android Application Development Expert Version 1.0 (GeeksLAB) 2012', 'psychic/certificate-images/android1.jpg'),
(8, 'Certified Android Application Development Expert Version 1.0 (GeeksLAB) 2013', 'psychic/certificate-images/android2.jpg'),
(9, 'Android Seminar Invitation from Sangamner College 2014', 'psychic/certificate-images/Android-Seminar-Sangamner-Invitation-Letter.jpg'),
(10, 'Android Seminar Experience Letter by Sangamner College 2014', 'psychic/certificate-images/Android-Seminar-Sangamner-Experience-Letter.jpg'),
(11, 'Android Seminar Invitation from Sahyadri College 2014', 'psychic/certificate-images/Android-Seminar-Sahyadri-Invitation-Letter.jpg'),
(12, 'Android Seminar Experience Letter by Sahyadri College 2014', 'psychic/certificate-images/Android-Seminar-Sahyadri-Experience-Letter.jpg'),
(13, 'BSc Computer Science Result on Notice Board 2013', 'psychic/certificate-images/first-rank-bcs.jpg'),
(14, 'Student Research Project Gold Medal 2013', 'psychic/certificate-images/gold-medal.jpg'),
(15, 'HTML5-CSS3-JAVASCRIPT-PHP 2014', 'psychic/certificate-images/Bitcode.jpg'),
(16, 'Computer Fundamentals & Assembling Seminar 2013', 'psychic/certificate-images/Computer-Fundamentals.jpg'),
(17, 'Modern Operating Systems Installations 2014', 'psychic/certificate-images/MultiOS2.jpg'),
(18, 'Modern Operating Systems Installations 2015', 'psychic/certificate-images/MultiOS1.jpg'),
(19, 'MSc Computer Science Third Semester Marksheet 2015', 'psychic/certificate-images/MCS-sem3.jpg'),
(20, 'Microsoft Transcript 2012', 'psychic/certificate-images/Microsoft-Transcript.jpg'),
(21, 'BSc Computer Science Third Year Marksheet 2013', 'psychic/certificate-images/TYBCS.jpg'),
(22, 'BSc Computer Science Degree Certificate 2013', 'psychic/certificate-images/BCS-Degree-Certificate.jpg'),
(23, 'Secondary School Certificate 2008', 'psychic/certificate-images/SSC-result.jpg'),
(24, 'Higher Secondary Certificate 2010', 'psychic/certificate-images/HSC-result.jpg'),
(25, 'Blood Donation 2010', 'psychic/certificate-images/blood-donation1.jpg'),
(26, 'Blood Donation 2013', 'psychic/certificate-images/blood-donation2.jpg'),
(27, 'Avishkar Certificate of Honour 2013', 'psychic/certificate-images/Avishkar1.jpg'),
(28, 'Avishkar Zonal Level Research Project Competition 2012', 'psychic/certificate-images/Avishkar2.jpg'),
(29, 'Ethical Hacking & Cyber Crime Investigation 2011', 'psychic/certificate-images/Ethical-Hacking.jpg'),
(30, 'Fest-Der-Tech District Level Event 2012', 'psychic/certificate-images/Fest-Der-Tech.jpg'),
(31, 'ASP.NET Programming course 2013', 'psychic/certificate-images/asp.jpg'),
(32, 'C# Programming course 2013', 'psychic/certificate-images/csharp.jpg'),
(33, 'VB.NET Programming course 2012', 'psychic/certificate-images/vbnet.jpg'),
(34, 'VB Programming course 2012', 'psychic/certificate-images/vb.jpg'),
(35, 'Research Galaxy - Two Day National Level Event 2010', 'psychic/certificate-images/Galaxy.jpg'),
(36, 'Logica - Festival of Technology 2011', 'psychic/certificate-images/logica.jpg'),
(37, 'Texephyr - Conquering Horizons 2014', 'psychic/certificate-images/MIT.jpg'),
(38, 'NNSC - National Network Security Championship 2014', 'psychic/certificate-images/Networking-seminar.jpg'),
(39, 'Student Research Project Competition 2013', 'psychic/certificate-images/research.jpg'),
(40, 'Society of Promotion of Excellence in Electronics Discipline  2012', 'psychic/certificate-images/speed.jpg'),
(41, 'Powerpoint Presentation 2012', 'psychic/certificate-images/powerpoint1.jpg'),
(42, 'Powerpoint Presentation  2013', 'psychic/certificate-images/powerpoint2.jpg'),
(43, 'Science Quiz 2011', 'psychic/certificate-images/science-quiz.jpg'),
(44, 'KWIZ REDICULE - Sparx 2012', 'psychic/certificate-images/MET-QUIZ.jpg'),
(45, 'Paper Presentation - Sparx 2012', 'psychic/certificate-images/MET-PPT.jpg'),
(46, 'Poster Presentation - Sparx 2012', 'psychic/certificate-images/MET-POSTER.jpg'),
(47, 'Java Programming course 2012', 'psychic/certificate-images/java.jpg'),
(48, 'महाराष्ट्र वाहतूक सुरक्षा दल आणि नागरी सौरक्षण संघटन २०१०', 'psychic/certificate-images/RSP.jpg'),
(49, 'क्रीडा व युवक संचालनाय स्पर्धा  - जिल्हा स्तरीय फुटबॉल स्पर्धा २००८ ', 'psychic/certificate-images/Football-District-Level.jpg'),
(50, 'Football Competition 2007', 'psychic/certificate-images/football1.jpg'),
(51, 'Football Competition 2010', 'psychic/certificate-images/football2.jpg'),
(52, 'Langhadi Competition 1999', 'psychic/certificate-images/langhadi.jpg'),
(53, 'Long Jump Competition 2003', 'psychic/certificate-images/long-jump1.jpg'),
(54, 'Long Jump Competition 2004', 'psychic/certificate-images/long-jump4.jpg'),
(55, 'Long Jump Competition 2008', 'psychic/certificate-images/long-jump3.jpg'),
(56, 'Long Jump Competition 2010', 'psychic/certificate-images/long-jump2.jpg'),
(57, 'Mararthi Essay Competition 2001', 'psychic/certificate-images/marathi-essay.jpg'),
(58, 'English Hand Writting Competition 2003', 'psychic/certificate-images/english-hand writting.jpg'),
(59, '100 Meters Running Competition 2007', 'psychic/certificate-images/running1.jpg'),
(60, '100 Meters Running Competition 2007', 'psychic/certificate-images/running2.jpg'),
(61, 'Drawing Competition 2001', 'psychic/certificate-images/Drawing1.jpg'),
(62, 'Drawing Competition 2000', 'psychic/certificate-images/Drawing2.jpg');

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

--
-- Table structure for table `contactme`
--

CREATE TABLE IF NOT EXISTS `contactme` (
  `ContactId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `EmailId` varchar(100) NOT NULL,
  `PhoneNumber` varchar(10) NOT NULL,
  `Message` varchar(1000) NOT NULL,
  PRIMARY KEY (`ContactId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `contactme`
--

INSERT INTO `contactme` (`ContactId`, `Name`, `EmailId`, `PhoneNumber`, `Message`) VALUES
(1, 'Tejashri', 'tejashribedarkar@gmail.com', '7798777465', 'Hiiiiiiiiii'),
(2, 'Madhu', 'madhuchandane123@gmail.com', '9561921668', 'Hi Suyog....!!!'),
(3, 'Teju', 'tejashri.abc@gmail.com', '8605794261', 'Hello....!!!'),
(4, 'Teju', 'tejashri.abc@gmail.com', '8605794261', 'Hello...!!!');

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

--
-- Table structure for table `myproject`
--

CREATE TABLE IF NOT EXISTS `myproject` (
  `ProjectId` int(11) NOT NULL AUTO_INCREMENT,
  `ProjectTitle` varchar(200) NOT NULL,
  `ProjectDescription` varchar(500) NOT NULL,
  `ProjectImagePath` varchar(500) NOT NULL,
  `ReleaseDate` date NOT NULL,
  `CurrentVersion` varchar(50) NOT NULL,
  `Technology` varchar(100) NOT NULL,
  `Details` varchar(5000) NOT NULL,
  `DownloadLink` varchar(500) NOT NULL,
  `FrontImage` varchar(500) NOT NULL,
  PRIMARY KEY (`ProjectId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `myproject`
--

INSERT INTO `myproject` (`ProjectId`, `ProjectTitle`, `ProjectDescription`, `ProjectImagePath`, `ReleaseDate`, `CurrentVersion`, `Technology`, `Details`, `DownloadLink`, `FrontImage`) VALUES
(1, 'SANGAMNER COLLEGE', 'An official Android Application for Sangamner College', 'psychic/img/portfolio/sangamnercollegeL.png', '2015-12-25', '', 'Android & PHP', 'Sangamner college is actively engaged in imparting instructions up to postgraduate level in faculties of Arts, Commerce and Science. It has emerged as one of the best college in Pune University area. The college is known for executing innovative programmes such as restructuring of the courses at the undergraduate level and innumerable socio-oriented activities. For outstanding performance, the college was selected as the "Best College" by Pune University in 2002 and 2008. The college is re-accredited with ''A'' grade by NAAC in 2009. Further, the college has been ISO 2008:9001 certified recently.\r\nGet full Insight of Sangamner College Now\r\n\r\n- About College\r\n- Vision\r\n- Mission\r\n- People\r\n- Departments\r\n- Academics\r\n- Administration\r\n- Student Corner\r\n- Quality Policies\r\n- Careers & Placements\r\n- Research & Development\r\n- IQAC\r\n- Infrastructure & Facilities\r\n\r\nAnd Many More......\r\n\r\nOur Aim is "Spread Knowledge Unto the Last"', 'https://play.google.com/store/apps/details?id=com.sangamner.college', 'psychic/img/portfolio/sangamnercollege.png'),
(2, 'SANGAMNER-IN MY POCKET', 'A Sangamner City Guide Application at your Finger Tip', 'psychic/img/portfolio/sangamnerimp.png', '2015-04-08', ' 1.6.4 Beta', 'Android & PhP', 'SANGAMNER IS IN YOUR POCKET NOW !!!\r\n\r\nABOUT SANGAMNER- Information about your city\r\nSANGAMNER MAP & PLACES - Search for a place, Check Live Traffic\r\nBUS SCHEDULE - bus timetable for sangamner city\r\nPOEMS - famous poems abouts sangamner\r\nPHOTO GALLERY - Photography of Sangamner\r\nNEARBY ME - Find Hospitals, ATMs, McDonald''s, KFC & almost anything nearby you\r\nPICNIC SPOTS - Places to hang out in & around Sangamner\r\nSANGAMNER NEWS - Latest happenings in Sangamner\r\nFOODY MOOD - Get Restaurants in your area\r\nMARATHI CALENDAR\r\n''GOAST EKA GAVACHI'' Book by Dr. Santosh Khedlekar\r\nPHONE DAIRY- Important contacts in need & can update your own contact Number too\r\nRIVERS - Info about Rivers\r\nEDUCATIONAL INFO\r\nENTERTAINMENTS IN SANGAMNER\r\nBUSSINESSESS IN SANGAMNER\r\nEMERGENCY CONTACTS\r\nFREE ADVERTISEMENTS\r\nWEATHER FORECAST\r\nSANGAMNER TAHSHIL\r\nSANGAMNER GEET\r\nSANGAMNER GOVERNMENT OFFICES DETAILS\r\nSANGAMNER POLITICAL DETAILS\r\nSANGAMNER CULTURAL INFO', 'https://play.google.com/store/apps/details?id=com.sangamner.city&hl=en', 'psychic/img/portfolio/sangamner.png'),
(3, 'UNIX-IN MY POCKET', 'Only Android Application having Unix Algorithms Explained in detail', 'psychic/img/portfolio/uniximp.png', '2014-08-15', '1.0.0 Alpha', 'Android', 'This is the perfect app to have a good time with your Unix Operating System. It is designed to help Unix Lovers to learn different things related to Unix. Includes all Unix Internals Algorithms with Explanation.\r\n\r\n<b>Key Features: </b> History of Unix Algorithms with Explanation Famous Quotes Info about Inventors Flavours of Unix Study Material (Commands & Concepts)', 'https://play.google.com/store/apps/details?id=com.app.unix&hl=en', 'psychic/img/portfolio/unix.png'),
(4, 'TELECOM SERVICES', 'An Application to provide all Telecom Services at your Finger Tip', 'psychic/img/portfolio/telecomservices.png', '2014-11-25', '', 'Android & PHP', 'The project entitled "Telecom Services – An Android Application" deals with fully automated Android Application used by the Telecom department & their Consumers. \r\n\r\nTelecom industry is one of the major sectors, which provides so many services to their customers such as request for a new connection, change of number, billing etc. Maintaining all these services manually is complicated process. The main objective of this project is to automate the services provided by telecom companies, by which customer can use all the services online. \r\n\r\nThe mission of the project is that it would concentrate on BSNL in all dimensions, so that all the services provided by BSNL should reach to common man.', '', 'psychic/img/portfolio/telecom.png'),
(5, 'FEEDBACK', 'An Android Application to deal with all Feedbacks those encountered', 'psychic/img/portfolio/feedbackapp.png', '2015-07-05', '', 'Android & PHP', 'Getting the right feedback at right time is of at most importance ,for any organization or faculties of an institution .Getting the feedback from the users will help an organization or faculty to provide better services to the users or students. Ongoing interaction with users can help improve the efficiency of an organization, and enable them to provide better service to the users. \r\n\r\nCollecting feedback from the users is very important thing for any organization. Until now , feedback collection process is conducted manually, using printed forms. All that has changed with the computer network as well as World Wide Web, making communication far easy .It is very easy to collect feedback about an organization , or about the staff of an institution through a web based system. \r\n\r\nFor All to enhance relationships and define roles to provide a ''positive'' teacher/student partnership, which in turn has more chance of ensuring high quality teaching, thereby meeting learners'' needs to establish learning objectives, and measure the extent to which they are met to inform executive action, policy developments and resource allocation as part of quality assurance . Feedback should be encouraged to be positive as well as giving suggestions concerning areas that could be enhanced.', '', 'psychic/img/portfolio/feedback.png'),
(6, 'TELECOM CONNECTION WEBSITE', 'A Website to provide all Telecom Services\r\n\r\n\r\n', 'psychic/img/portfolio/telecomsiteL.png', '2013-03-20', '', 'JAVA & PHP', 'The project entitled "Telecom Connection System" deals with fully automated website used by the Telecom department & their Consumers. \r\n\r\nTelecom industry is one of the major sectors, which provides so many services to their customers such as request for a new connection, change of number, billing etc. Maintaining all these services manually is complicated process. The main objective of this project is to automate the services provided by telecom companies, by which customer can use all the services online. \r\n\r\nThe mission of the project is that it would concentrate on BSNL in all dimensions, so that all the services provided by BSNL should reach to common man.', '', 'psychic/img/portfolio/telecomsite.png'),
(7, 'LIFE-CYCLE OF A C-PROGRAM', 'A PHP Tool to demonstrate the Life Cycle of a C-Program', 'psychic/img/portfolio/toolchainL.png', '2014-07-05', '', 'PHP', '"Life-Cycle of a C-Program" is a simple PHP tool designed to trace the life-cycle of a C-program \r\nIt is a practical view of C Toolchain which consists : \r\n1)Editor \r\n2)Preprocessor \r\n3)Compiler \r\n4)Assembler \r\n5)Linker \r\n6)Loader \r\n\r\nUsing this Tool you can see a C-program''s source code,preprocessed code,compiled code,assembled code & output', '', 'psychic/img/portfolio/toolchain.png'),
(8, 'APTITUDE TEST GENERATION SYSTEM', 'A tool to set Aptitude paper in an very efficient manner', 'psychic/img/portfolio/aptitudeL.png', '2013-12-20', '', 'PHP', 'Aptitude Test is basically made for reducing paper work of traditional Aptitude(any) test.Also it is available anytime,anywhere so that students need not go to examination centre. Students can easily get registered and take the test.After the test is over,their result will be displayed within seconds,in this way it reduces time of submitting and checking the test papers. Adminitrator has the priviledge to check the details of students,their results,their feedback and also delete their records.', '', 'psychic/img/portfolio/aptitude.png'),
(9, 'ONLINE COLLEGE ADMISSION SYSTEM', 'A website for managing all college admission stuff online', 'psychic/img/portfolio/online_admissionL.png', '2013-03-20', '', 'PHP', 'Online Admission System is aimed at developing an online admission application for a college. \r\no	This system is an online system that can be accessed throughout the organization and outside as well with proper login provided. \r\no	Our system has two type of accessing modes , administrator and user. \r\no	Student management system is managed by an administrator. \r\no	It is the job of the administrator to admit and monitor the whole process. \r\no	When a user log in to the system. \r\no	He would only view details of the student. He can''t perform any changes. \r\n\r\no	The system has two modules : \r\n- User \r\n- Administrator \r\n\r\no	Students logging is to apply for the course by filling an application form provided by online. \r\no	College principal/administrator logging in may also access/search information put up by the students', '', 'psychic/img/portfolio/online_admission.png');

