Jcyu991t

1-- phpMyAdmin SQL Dump
2-- version 3.4.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Feb 09, 2019 at 09:49 AM
7-- Server version: 5.5.16
8-- PHP Version: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `feedback_system`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `subject_specifics`
27--
28
29CREATE TABLE IF NOT EXISTS `subject_specifics` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `department` text NOT NULL,
32  `regulation` text NOT NULL,
33  `year` text NOT NULL,
34  `semester` text NOT NULL,
35  `theory_subject1_code` text NOT NULL,
36  `theory_subject1_name` text NOT NULL,
37  `theory_subject2_code` text NOT NULL,
38  `theory_subject2_name` text NOT NULL,
39  `theory_subject3_code` text NOT NULL,
40  `theory_subject3_name` text NOT NULL,
41  `theory_subject4_code` text NOT NULL,
42  `theory_subject4_name` text NOT NULL,
43  `theory_subject5_code` text NOT NULL,
44  `theory_subject5_name` text NOT NULL,
45  `theory_subject6_code` text NOT NULL,
46  `theory_subject6_name` text NOT NULL,
47  `theory_subject7_code` text NOT NULL,
48  `theory_subject7_name` text NOT NULL,
49  `theory_subject8_code` text NOT NULL,
50  `theory_subject8_name` text NOT NULL,
51  `lab_subject1_code` text NOT NULL,
52  `lab_subject1_name` text NOT NULL,
53  `lab_subject2_code` text NOT NULL,
54  `lab_subject2_name` text NOT NULL,
55  `lab_subject3_code` text NOT NULL,
56  `lab_subject3_name` text NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
59
60--
61-- Dumping data for table `subject_specifics`
62--
63
64INSERT INTO `subject_specifics` (`id`, `department`, `regulation`, `year`, `semester`, `theory_subject1_code`, `theory_subject1_name`, `theory_subject2_code`, `theory_subject2_name`, `theory_subject3_code`, `theory_subject3_name`, `theory_subject4_code`, `theory_subject4_name`, `theory_subject5_code`, `theory_subject5_name`, `theory_subject6_code`, `theory_subject6_name`, `theory_subject7_code`, `theory_subject7_name`, `theory_subject8_code`, `theory_subject8_name`, `lab_subject1_code`, `lab_subject1_name`, `lab_subject2_code`, `lab_subject2_name`, `lab_subject3_code`, `lab_subject3_name`) VALUES
65(1, 'MCA', '2013', 'II', '3', 'mc7001', 'wad', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'mc6511', '0', 'wad lab', '', '', '');
66
67/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
68/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
69/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;