 --
 
 CREATE TABLE IF NOT EXISTS `file_document` (
-  `file_docId` int(11) NOT NULL,
+`file_docId` int(11) NOT NULL,
   `file_subName` text NOT NULL,
   `file_docPath` text NOT NULL,
-  `file_docDetail` text NOT NULL
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+  `file_docDetail` text NOT NULL,
+  `subj_id` int(11) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `file_document`
+--
+
+INSERT INTO `file_document` (`file_docId`, `file_subName`, `file_docPath`, `file_docDetail`, `subj_id`) VALUES
+(4, '', '16_09_15_07_25_341625580105.PDF', 'test', 1);
 
 -- --------------------------------------------------------
 

-- Indexes for table `file_document`
--
ALTER TABLE `file_document`
  ADD PRIMARY KEY (`file_docId`);

--
-- Indexes for table `picture_profile`
--
ALTER TABLE `picture_profile`
  ADD PRIMARY KEY (`picPro_id`);

--
-- Indexes for table `picture_slide`
--
ALTER TABLE `picture_slide`
  ADD PRIMARY KEY (`picSlide_id`);

--
-- Indexes for table `research`
--
ALTER TABLE `research`
  ADD PRIMARY KEY (`res_id`);

--
-- Indexes for table `table_teacher`
--
ALTER TABLE `table_teacher`
  ADD PRIMARY KEY (`table_id`);

--
-- Indexes for table `university`
--
ALTER TABLE `university`
  ADD PRIMARY KEY (`uni_id`);

--
-- Indexes for table `username`
--
ALTER TABLE `username`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables

--

CREATE TABLE IF NOT EXISTS `university` (
`uni_id` int(11) NOT NULL,
  `uni_data` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

