1#@!#!123s

https 1#@!#!123s
: / home / u565127238 / domains / stjamesion.edu.pk / public_html / database /
Filename : theclassico_st.sql
back
-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 31, 2021 at 07:19 PM
-- Server version: 10.4.18-MariaDB
-- PHP Version: 8.0.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `theclassico_st`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `name`, `email`, `password`, `image`) VALUES
(1, 'ST. JAMES', 'st@gmial.com', '12345', 'https://freepikpsd.com/wp-content/uploads/2019/10/admin-logo-png-3-Free-PNG-Images-Transparent.png');

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` int(11) NOT NULL,
  `image` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `image` varchar(200) NOT NULL,
  `page` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`id`, `image`, `page`) VALUES
(2, 'images/banner/Home_Banner.jpg', 'index'),
(3, 'images/banner/b2.jpg', 'history'),
(4, 'images/banner/b3.jpg', 'vision'),
(5, 'images/banner/images.jpg', 'contact'),
(6, 'images/banner/b2.jpg', 'alumni'),
(7, 'images/banner/Research_Banner.jpg', 'research'),
(8, 'images/banner/Practical_Banner.jpg', 'practicals'),
(9, 'images/banner/Faculty_Banner.jpg', 'committe'),
(10, 'images/banner/Faculty_Banner.jpg', 'student-body'),
(11, 'images/banner/Faculty_Banner.jpg', 'management'),
(12, 'images/banner/Faculty_Banner.jpg', 'faculty'),
(13, 'images/banner/slider1.jpg', 'gallery'),
(14, 'images/banner/slider2.jpg', 'video'),
(15, 'images/banner/gallery-post.jpg', 'admission'),
(16, 'images/banner/choose2.jpg', 'admission');

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

--
-- Table structure for table `dept`
--

CREATE TABLE `dept` (
  `id` int(11) NOT NULL,
  `dept_name` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dept`
--

INSERT INTO `dept` (`id`, `dept_name`, `date`) VALUES
(1, 'bs/cs', '2021-03-26'),
(2, 'skill lab', '2021-05-10'),
(3, 'science lab', '2021-05-10'),
(4, 'computer lab', '2021-05-10');

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

--
-- Table structure for table `faculty`
--

CREATE TABLE `faculty` (
  `page` varchar(200) NOT NULL,
  `page_c` varchar(200) NOT NULL,
  `id` int(11) NOT NULL,
  `dep_id` varchar(100) NOT NULL,
  `name` varchar(200) NOT NULL,
  `position` varchar(200) NOT NULL,
  `education` text NOT NULL,
  `message` text NOT NULL,
  `img` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `faculty`
--

INSERT INTO `faculty` (`page`, `page_c`, `id`, `dep_id`, `name`, `position`, `education`, `message`, `img`) VALUES
('alumni', '', 2, 'Bs in Computer science', 'Henery', 'Professor', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries,\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries,', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries,', 'images/faculty/3.jpg'),
('faculty', 'practicals', 3, 'computer lab', 'testing', 'abc', 'lorem ispam', 'lorem ispam', 'images/faculty/Web and Mobile App Development.jpg'),
('faculty', 'management', 9, 'Select Department', 'James Watt', 'Director', 'RN, DWA, DTA, DCN, BScN', '', 'images/faculty/James Watt.jpg'),
('faculty', 'management', 10, 'Select Department', 'Mrs. Bashiran James', 'Vice Chairperson', 'RN, RM, DWA, DTA, BScn\r\n\r\n', '', 'images/faculty/Mrs.Bashiran James.jpg'),
('faculty', 'management', 11, 'Select Department', 'Doris Lawrance', 'Principal', 'RN, DICU, BScN, MScN\r\n\r\n', '', 'images/faculty/Doris Lawrance.jpg'),
('faculty', 'management', 12, 'Select Department', 'Elizbeth Feroz Din', 'Vice Principal', 'RN, RM, DWA, DTA, DPN, BScN\r\n\r\n', '', 'images/faculty/Elizbeth Feroz Din.jpg'),
('faculty', 'management', 13, 'Select Department', 'Mrs. Parveen Durani', 'Nurse Midwife Co-Ordinator', 'RN, RM, DWA, DTA, DCN, BScN\r\n\r\n', '', 'images/faculty/Mrs. Parveen Durani.jpg'),
('faculty', 'management', 14, 'Select Department', 'Ms. Martha Rehmat', 'Chief Operating Officer', 'RN, RM, BScN, MBA\r\n', '', 'images/faculty/Ms. Martha Rehmat.jpg'),
('faculty', 'faculty', 15, 'Select Department', 'Sineer Micah', 'Visiting Faculty', 'RN, DCN, BScN, MScN\r\n', '', 'images/faculty/Sineer Micah.jpg'),
('faculty', 'faculty', 16, 'Select Department', 'Ashir Ghori', 'Visiting Faculty', 'RN, DICU, BScN, MScN\r\n', '', 'images/faculty/Ashir Ghori.jpg'),
('faculty', 'faculty', 17, 'Select Department', 'Mr. Hakim Shah', 'Visiting Faculty', 'BSc, RN, BScN, MScN\r\n\r\n', '', 'images/faculty/Mr. Hakim Shah.jpg'),
('faculty', 'faculty', 18, 'Select Department', 'Arsalan Siddiqui', 'Visiting Faculty', 'M.A Lits, M.phil, M.A ELT\r\n\r\n', '', 'images/faculty/Arsalan Siddiqui.jpg'),
('faculty', 'faculty', 19, 'Select Department', 'Syed Irshad Ali Naqvi', 'Visiting Faculty', 'BA, Master in English\r\n\r\n', '', 'images/faculty/Syed Irshad Ali Naqvi.jpg'),
('faculty', 'faculty', 20, 'Select Department', 'Shazia Anjum', 'Visiting Faculty', 'BSc, B.ed, M.Sc in Microbiology\r\n\r\n', '', 'images/faculty/Shazia Anjum.jpg');

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

--
-- Table structure for table `inquiry`
--

CREATE TABLE `inquiry` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `message` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `magazine`
--

CREATE TABLE `magazine` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `cover` varchar(250) NOT NULL,
  `pdf_file` varchar(200) NOT NULL,
  `des` longtext NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `magazine`
--

INSERT INTO `magazine` (`id`, `title`, `cover`, `pdf_file`, `des`, `date`) VALUES
(7, 'St James 2018', 'img/pdfcoverimage/Magzine_0.jpg', 'img/pdf/Invoice-299071.pdf', 'The state of art skill, lab has been established at the institute of Nursing building with latest and sophisticated models, maniquins and all medical equipments under supervision of experienced med-ical technologist. Before clinical training at affiliated hospitals every student receives extensive hands on training in relevant skills in the skill, lab under supervision of faculty.', '2021-05-22'),
(8, 'St James 2019', 'img/pdfcoverimage/Magzine_1.jpg', 'img/pdf/Invoice-299071.pdf', 'The state of art skill, lab has been established at the institute of Nursing building with latest and sophisticated models, maniquins and all medical equipments under supervision of experienced med-ical technologist. Before clinical training at affiliated hospitals every student receives extensive hands on training in relevant skills in the skill, lab under supervision of faculty.', '2021-05-22'),
(9, 'St James 2020', 'img/pdfcoverimage/Magzine_2.jpg', 'img/pdf/Invoice-299071.pdf', 'The state of art skill, lab has been established at the institute of Nursing building with latest and sophisticated models, maniquins and all medical equipments under supervision of experienced med-ical technologist. Before clinical training at affiliated hospitals every student receives extensive hands on training in relevant skills in the skill, lab under supervision of faculty.', '2021-05-22');

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `selector` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `store_path` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `selector`, `title`, `store_path`, `date`) VALUES
(1, 'Video', 'How to perform CPR - Clinical skills for student nurses', 'img/media/JumanjiTheNextLevel_x264.mp4', '2021-03-26'),
(2, 'Image', 'imagesssss', 'img/media/yapp-1024x442.jpg', '2021-03-26'),
(3, 'Video', 'How to perform CPR - Clinical skills for student nurses', 'img/media/JumanjiTheNextLevel_x264.mp4', '2021-03-26'),
(4, 'Video', 'How to perform CPR - Clinical skills for student nurses', 'img/media/JumanjiTheNextLevel_x264.mp4', '2021-03-26'),
(5, 'Video', 'How to perform CPR - Clinical skills for student nurses', 'img/media/JumanjiTheNextLevel_x264.mp4', '2021-03-26');

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

--
-- Table structure for table `newsandevent`
--

CREATE TABLE `newsandevent` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` longtext NOT NULL,
  `images` varchar(250) NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `newsandevent`
--

INSERT INTO `newsandevent` (`id`, `title`, `description`, `images`, `date`) VALUES
(7, 'Nurses don\'t have the luxury to stay home.', 'Nurses don\'t have the luxury to stay home. Because panic or not, the nurses will still be the ones showing up to work, the ones dealing with sweating through their shifts in their, the ones risking exposure to care for anyone who does experience complications.  They will be the ones calming patients who are genuinely fearful of what this virus can do to them, the ones watching when positive tests do come back, and the ones we will all turn to if the virus moves from something that is happening to other people and into something that affects us or our loved ones.  We are proud of our students, who are working voluntarily under the supervision of WHO tream at Jinnah International Airport Karachi to fight against COVID-19. May God protect and shelter these young souls.', 'img/store/News_01.jpg', '2021-05-21'),
(8, 'Project-Based Research Seminar', 'Project-Based Research Seminar (Session 2017-2019) was prearranged by St. James School of Nursing and Health Sciences along with Jesus and Mary Institute of Nursing and Allied Sciences at Arts Council Karachi on 27th July 2019.  The students showcased and presented their Research Project of various topics. Some of most respectful and honorable leaders took part in the seminar as an attendees and observers.', 'img/store/News_02.jpg', '2021-05-21'),
(9, 'KARACHI YOUTH MODEL UNITED NATIONS (KYMUN VII)', 'Students of St. James School of Nursing participated at Asia\'s biggest confernce KARACHI YOUTH MODEL UNITED NATIONS (KYMUN VII) held from 28th June to 1st July 2018 at Movenpick Hotel Karachi. Here, our students learned how to debate and build self confidence with themselves. It was a good experience overall of students to interact with new people from different Schools and Colleges in the City. Some renowned personalities like Mubashir Luqman, Arif Alvi, Amir Liaqat, Jibran Nasir, Imran Ismail, Farooq Sattar and much more also joined the session for the motivation of participants.', 'img/store/News_03.jpg', '2021-05-21'),
(10, 'Welcome Party  for 1st Semester BSCN students ', 'A beautiful Welcome Party with lots of laughs, music and entertainment was organised by 3rd Semester BSCN students for the new 1st Semester BSCN students at St. James School of Nursing', 'img/store/News_04.jpg', '2021-05-21'),
(11, '1st and 2nd Year students visited Karachi Slaughter House', 'Several students including 1st and 2nd Year students visited Karachi Slaughter House in the area of Bhains Colony. Here the students learned about how the specific place is provided to slaughter various animals. After that the meat is verified and supplies to different areas across the city.', 'img/store/News_05.jpg', '2021-05-21'),
(12, 'Students of 1st Year, 2nd Year, 3rd and Specialization represented', 'Students of 1st Year, 2nd Year, 3rd and Specialization represented, ST. JAMES SCHOOL OF NURSING at 4 days Conference of KARACHI YOUTH MODEL UNITED NATIONS held at Marriott Hotel karachi. Here, our students learned how to debate and build self confidence with themselves. It was a good experience overall of students  to interact with new people from different Schools and Colleges in the City.', 'img/store/News_06.jpg', '2021-05-21'),
(13, 'Pakistan\'s First Nurses Delegation of St. James School of Nursing to Visit USA', 'Proud to announce that we are Pakistan\'s First Nurses Delegation of St. James School of Nursing to Visit The United States of America to attend the conference held by HARVARD UNIVERSITY (Historical and World\'s Top Ranked) in City of Boston.', 'img/store/News_07.jpg', '2021-05-21');

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `newsletter`
--

INSERT INTO `newsletter` (`id`, `email`) VALUES
(2, 'ather@gmail.com'),
(3, 'athershahid@gmail.com'),
(4, 'hammad@gmail.com');

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

--
-- Table structure for table `sitesetting`
--

CREATE TABLE `sitesetting` (
  `id` int(11) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `cellno` varchar(100) NOT NULL,
  `phone1` varchar(100) NOT NULL,
  `phone2` varchar(100) NOT NULL,
  `facebook` varchar(100) NOT NULL,
  `twitter` varchar(100) NOT NULL,
  `instagram` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sitesetting`
--

INSERT INTO `sitesetting` (`id`, `logo`, `address`, `email`, `cellno`, `phone1`, `phone2`, `facebook`, `twitter`, `instagram`) VALUES
(1, 'images/logo.png', 'A-32, block D/3, Baloch Goth, Gulshan-e-iqbal, karachi', 'info@stjamesion.edu.pk', '123891391', '+92-00-000 00 001', '+92-00-000 00 002', '', '', '');

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

--
-- Table structure for table `submission`
--

CREATE TABLE `submission` (
  `id` int(11) NOT NULL,
  `s_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `submission`
--

INSERT INTO `submission` (`id`, `s_type`, `file`, `date`) VALUES
(1, 'DIPLOMA IN GENERAL NURSING', 'images/pdf/Invoice-299071.pdf', '2021-05-19'),
(2, 'DIPLOMA IN GENERAL MIDWIFERY', 'images/pdf/Invoice-299071.pdf', '2021-05-19'),
(3, 'POST BASIC SPECIALIZATION IN CARDIC NURSING', 'images/pdf/Kongo_Website-Wirefram_Second-Draft_2-23-21.pdf', '2021-05-19');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `newsletter`
--
ALTER TABLE `newsletter`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `ads`
--
ALTER TABLE `ads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `inquiry`
--
ALTER TABLE `inquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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