 -- Table structure for table `users`
 --
 
-CREATE TABLE IF NOT EXISTS `users` (
-`uid` int(11) NOT NULL,
+CREATE TABLE `users` (
+  `uid` int(11) NOT NULL,
   `email` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
   `password` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
   `username` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,

-- Table structure for table `interests`
--

CREATE TABLE IF NOT EXISTS `interests` (
  `uid` int(11) NOT NULL,
  `label` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Indexes for table `boards`
--
ALTER TABLE `boards`
  ADD PRIMARY KEY (`name`,`uid`) USING BTREE,
  ADD KEY `uid` (`uid`);

--
-- Indexes for table `friends`
--
ALTER TABLE `friends`
  ADD PRIMARY KEY (`fid`);

--
-- Indexes for table `likes`
--
ALTER TABLE `likes`
  ADD PRIMARY KEY (`uid`,`post_id`),
  ADD KEY `post_id` (`post_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`nid`);

--
-- Indexes for table `pins`
--
ALTER TABLE `pins`
  ADD PRIMARY KEY (`b_name`),
  ADD UNIQUE KEY `pin_id` (`pin_id`) USING BTREE;

--
-- Indexes for table `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`pid`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`uid`);

--
-- AUTO_INCREMENT for dumped tables
