 -- Indexes for table `comments`
 --
 ALTER TABLE `comments`
-  ADD PRIMARY KEY (`comment_id`);
+  ADD PRIMARY KEY (`comment_id`),
+  ADD KEY `event_id` (`event_id`),
+  ADD KEY `user_id` (`user_id`);
 
 --
 -- Indexes for table `events`
 --
 ALTER TABLE `events`
-  ADD PRIMARY KEY (`event_id`);
+  ADD PRIMARY KEY (`event_id`),
+  ADD KEY `rso_id` (`rso_id`);
 
 --
 -- Indexes for table `RSOs`
 --
 ALTER TABLE `RSOs`
-  ADD PRIMARY KEY (`rso_id`);
+  ADD PRIMARY KEY (`rso_id`),
+  ADD KEY `rso_admin_id` (`rso_admin_id`),
+  ADD KEY `uni_id` (`uni_id`);
 
 --
 -- Indexes for table `universities`

--

CREATE TABLE `comments` (
  `user_name` varchar(30) NOT NULL,
  `comment` varchar(140) NOT NULL,
  `event` int(11) NOT NULL,
  `comment_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `RSOs` (
  `rso_name` varchar(30) NOT NULL,
  `rso_admin_id` int(11) UNSIGNED NOT NULL,
  `member_count` int(10) UNSIGNED NOT NULL,
  `rso_id` int(11) UNSIGNED NOT NULL,
  `uni_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------
