 -- Indexes for table `boards`
 --
 ALTER TABLE `boards`
- ADD PRIMARY KEY (`name`,`uid`) USING BTREE, ADD KEY `uid` (`uid`);
+  ADD PRIMARY KEY (`name`,`uid`) USING BTREE,
+  ADD KEY `uid` (`uid`);
 
 --
 -- Indexes for table `friends`
 --
 ALTER TABLE `friends`
- ADD PRIMARY KEY (`fid`);
+  ADD PRIMARY KEY (`fid`);
 
 --
 -- Indexes for table `likes`
 --
 ALTER TABLE `likes`
- ADD PRIMARY KEY (`uid`,`post_id`), ADD KEY `post_id` (`post_id`);
+  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;
+  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`);
+  ADD PRIMARY KEY (`pid`);
 
 --
 -- Indexes for table `users`
 --
 ALTER TABLE `users`
- ADD PRIMARY KEY (`uid`);
+  ADD PRIMARY KEY (`uid`);
 
 --
 -- AUTO_INCREMENT for dumped tables

-- phpMyAdmin SQL Dump
-- version 4.2.7
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Dec 04, 2015 at 06:03 PM
-- Server version: 5.5.41-log
-- PHP Version: 5.6.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `ucrinterest`
--

-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `nid` int(11) NOT NULL,
  `from` int(11) NOT NULL,
  `to` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
