 --
 
 CREATE TABLE IF NOT EXISTS `picture_profile` (
-  `picPro_id` int(11) NOT NULL,
+`picPro_id` int(11) NOT NULL,
   `picPro_name` text NOT NULL
-) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `picture_profile`
+--
+
+INSERT INTO `picture_profile` (`picPro_id`, `picPro_name`) VALUES
+(18, '16_09_15_03_52_57_.jpg');
 
 -- --------------------------------------------------------
 

-- 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 `username` (
`user_id` int(11) NOT NULL,
  `user_fb` char(20) NOT NULL,
  `user_fbName` text NOT NULL,
  `user_email` text NOT NULL,
  `user_status` enum('public','admin') NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `username`
--

INSERT INTO `username` (`user_id`, `user_fb`, `user_fbName`, `user_email`, `user_status`) VALUES
(2, '1041856095832668', 'เต้ ไชยวัฒน์', 'mynameistecs51@gmail.com', 'admin');

--
-- Indexes for dumped tables
