 -- Dumping data for table `topic`
 --
 
-INSERT INTO `topic` (`name`, `description`, `subscribers`, `header_image`, `created`) VALUES
-('NEWS', 'News of all kind', 1, NULL, '2017-01-12 21:22:52'),
-('WORLDNEWS', 'World wide news like serious shit', 1, NULL, '2017-01-12 21:33:56'),
-('SCIENCE', 'Nerds, this is your topic come over here!', 0, NULL, '2017-01-12 21:34:31'),
-('MOVIES', 'All kinds of movies', 0, NULL, '2017-01-13 15:05:23'),
-('TELEVISION', 'Your favorite TV Shows', 0, NULL, '2017-01-13 15:06:20'),
-('PICS', 'Your nudes are leaking', 0, NULL, '2017-01-13 15:06:56'),
-('MUSIC', 'No Justin Bieber allowed', 0, NULL, '2017-01-13 15:07:28'),
-('FUNNY', '9GAG but different', 0, NULL, '2017-01-13 15:07:58'),
-('CODING', 'Your programming base', 0, NULL, '2017-01-13 15:08:34'),
-('GAMING', 'PC Master Race vs Console Peasents', 0, NULL, '2017-01-13 15:08:54'),
-('VIDEOS', '+98 Videos', 0, NULL, '2017-01-13 15:09:13'),
-('TRAVEL', 'From Prague to Beijing', 0, NULL, '2017-01-13 15:09:53'),
-('ARCHEOLOGY', NULL, 0, NULL, '2017-01-13 15:48:14');
+INSERT INTO `topic` (`name`, `description`, `subscribers`, `header_image`, `reported`, `created`) VALUES
+('NEWS', 'News of all kind', 1, NULL, 0, '2017-01-12 21:22:52'),
+('WORLDNEWS', 'World wide news like serious shit', 1, NULL, 0, '2017-01-12 21:33:56'),
+('SCIENCE', 'Nerds, this is your topic come over here!', 0, NULL, 0, '2017-01-12 21:34:31'),
+('MOVIES', 'All kinds of movies', 0, NULL, 0, '2017-01-13 15:05:23'),
+('TELEVISION', 'Your favorite TV Shows', 0, NULL, 0, '2017-01-13 15:06:20'),
+('PICS', 'Your nudes are leaking', 0, NULL, 0, '2017-01-13 15:06:56'),
+('MUSIC', 'No Justin Bieber allowed', 0, NULL, 0, '2017-01-13 15:07:28'),
+('FUNNY', '9GAG but different', 0, NULL, 0, '2017-01-13 15:07:58'),
+('CODING', 'Your programming base', 0, NULL, 0, '2017-01-13 15:08:34'),
+('GAMING', 'PC Master Race vs Console Peasents', 0, NULL, 0, '2017-01-13 15:08:54'),
+('VIDEOS', '+98 Videos', 0, NULL, 0, '2017-01-13 15:09:13'),
+('TRAVEL', 'From Prague to Beijing', 0, NULL, 0, '2017-01-13 15:09:53'),
+('ARCHEOLOGY', NULL, 0, NULL, 0, '2017-01-13 15:48:14');
 
 -- --------------------------------------------------------
 

  `uid` int(11) NOT NULL,
  `topic` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `subscription`

--
ALTER TABLE `link`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `link` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `link` ADD FULLTEXT KEY `text` (`text`);
ALTER TABLE `link` ADD FULLTEXT KEY `domain` (`domain`);
ALTER TABLE `link` ADD FULLTEXT KEY `url` (`url`);
ALTER TABLE `link` ADD FULLTEXT KEY `topic` (`topic`);

--
-- Indexes for table `reply`
--
ALTER TABLE `reply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `report_link`
--
ALTER TABLE `report_link`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `report_reply`
--
ALTER TABLE `report_reply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `report_topic`
--
ALTER TABLE `report_topic`
  ADD PRIMARY KEY (`id`);

--
