 -- AUTO_INCREMENT for table `RSOs`
 --
 ALTER TABLE `RSOs`
-  MODIFY `rso_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
+  MODIFY `rso_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `universities`
 --
 ALTER TABLE `universities`
-  MODIFY `uni_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;COMMIT;
+  MODIFY `uni_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
+--
+-- Constraints for dumped tables
+--
+
+--
+-- Constraints for table `comments`
+--
+ALTER TABLE `comments`
+  ADD CONSTRAINT `event_id` FOREIGN KEY (`event_id`) REFERENCES `events` (`event_id`),
+  ADD CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`);
+
+--
+-- Constraints for table `events`
+--
+ALTER TABLE `events`
+  ADD CONSTRAINT `rso_id` FOREIGN KEY (`rso_id`) REFERENCES `RSOs` (`rso_id`);
+
+--
+-- Constraints for table `RSOs`
+--
+ALTER TABLE `RSOs`
+  ADD CONSTRAINT `rso_admin_id` FOREIGN KEY (`rso_admin_id`) REFERENCES `users` (`user_id`),
+  ADD CONSTRAINT `uni_id` FOREIGN KEY (`uni_id`) REFERENCES `universities` (`uni_id`);
+
+--
+-- Constraints for table `users`
+--
+ALTER TABLE `users`
+  ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`uni_id`) REFERENCES `universities` (`uni_id`);
+COMMIT;
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 29, 2017 at 10:05 PM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 5.6.30


-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `uni_id` (`uni_id`),
  ADD KEY `rso_id` (`rso_id`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
