 -- Indexes for table `file_document`
 --
 ALTER TABLE `file_document`
-  ADD PRIMARY KEY (`file_docId`);
+ ADD PRIMARY KEY (`file_docId`);
 
 --
 -- Indexes for table `picture_profile`
 --
 ALTER TABLE `picture_profile`
-  ADD PRIMARY KEY (`picPro_id`);
+ ADD PRIMARY KEY (`picPro_id`);
 
 --
 -- Indexes for table `picture_slide`
 --
 ALTER TABLE `picture_slide`
-  ADD PRIMARY KEY (`picSlide_id`);
+ ADD PRIMARY KEY (`picSlide_id`);
 
 --
 -- Indexes for table `research`
 --
 ALTER TABLE `research`
-  ADD PRIMARY KEY (`res_id`);
+ ADD PRIMARY KEY (`res_id`);
+
+--
+-- Indexes for table `subjects`
+--
+ALTER TABLE `subjects`
+ ADD PRIMARY KEY (`subj_id`);
 
 --
 -- Indexes for table `table_teacher`
 --
 ALTER TABLE `table_teacher`
-  ADD PRIMARY KEY (`table_id`);
+ ADD PRIMARY KEY (`table_id`);
 
 --
 -- Indexes for table `university`
 --
 ALTER TABLE `university`
-  ADD PRIMARY KEY (`uni_id`);
+ ADD PRIMARY KEY (`uni_id`);
 
 --
 -- Indexes for table `username`
 --
 ALTER TABLE `username`
-  ADD PRIMARY KEY (`user_id`);
+ ADD PRIMARY KEY (`user_id`);
 
 --
 -- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `file_document`
--
ALTER TABLE `file_document`
  MODIFY `file_docId` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `picture_profile`
--
ALTER TABLE `picture_profile`
  MODIFY `picPro_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `picture_slide`
--
ALTER TABLE `picture_slide`
  MODIFY `picSlide_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `research`
--
ALTER TABLE `research`
  MODIFY `res_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `table_teacher`
--
ALTER TABLE `table_teacher`
  MODIFY `table_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `university`
--
ALTER TABLE `university`
  MODIFY `uni_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `username`
--
ALTER TABLE `username`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
/*!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 */;

--

CREATE TABLE IF NOT EXISTS `research` (
`res_id` int(11) NOT NULL,
  `res_name` text NOT NULL,
  `res_file` text NOT NULL,
  `res_pict` text NOT NULL,
