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

-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`comment_id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`event_id`);

--
-- Indexes for table `RSOs`
--
ALTER TABLE `RSOs`
  ADD PRIMARY KEY (`rso_id`);

--
-- Indexes for table `universities`

  `event_zip` int(5) NOT NULL,
  `event_duration` time NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `state` char(2) NOT NULL,
  `uni_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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