-- http://www.phpmyadmin.net
--




--
-- Database: `cheese`
--

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` int(10) NOT NULL AUTO_INCREMENT,
  `request_id` int(10) NOT NULL,
  `user_id` int(9) NOT NULL,
  `comment_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `comment_title` varchar(150) DEFAULT NULL,
  `comment_points` int(5) NOT NULL DEFAULT '0' COMMENT 'although this seems to break third normal form, it seems that it is worth breaking for efficency',
  PRIMARY KEY (`comment_id`),
  FULLTEXT KEY `comment_text` (`comment_title`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`comment_id`, `request_id`, `user_id`, `comment_time`, `comment_title`, `comment_points`) VALUES
(1, 1, 18, '2014-08-26 12:02:13', 'SPAM IS GREAT', 2),
(2, 1, 18, '2014-08-26 12:02:13', 'SPAM IS GREAT', 1),
(3, 1, 18, '2014-08-26 12:02:13', 'SPAM IS GREAT', 0),
(4, 1, 18, '2014-08-26 12:02:13', 'SPAM IS GREAT', -1),
(5, 1, 18, '2014-08-26 12:02:13', 'SPAM IS GREAT', -1),
(6, 2, 17, '2014-10-01 22:23:07', 'This is very interesting! Not sure how to approach the problem though...', -1),
(7, 2, 17, '2014-10-01 22:23:17', 'This is very interesting! Not sure how to approach the problem though...', 1),
(8, 3, 17, '2014-10-01 22:39:30', 'You just did.', 1),
(9, 2, 17, '2014-10-01 23:13:37', 'I think its 43', -1),
(10, 2, 17, '2014-10-03 11:06:53', 'According to my calculator,the answer is  2', 0),
(11, 5, 17, '2014-10-03 13:26:52', '[i]This post has been flagged for deletion[/i]', 0),
(12, 5, 17, '2014-10-03 13:30:12', 'test', 0),
(13, 2, 17, '2014-10-11 12:52:12', 'I learnt this in class last week, its 2.', 0),
(14, 1, 17, '2015-01-01 14:49:48', 'World', 1),
(15, 6, 17, '2015-01-16 23:00:50', 'Richie sincerely hopes this works', 0),
(16, 6, 17, '2015-01-16 23:05:37', 'I solemnly swear that I am up to no good.', 0),
(17, 6, 17, '2015-01-16 23:20:46', '.good no to up am I that swear solemnly I', 0),
(18, 6, 17, '2015-01-16 23:24:49', '.works this hopes sincerely Richie', 0),
(19, 6, 17, '2015-01-16 23:25:45', 'eff', 0),
(20, 0, 17, '2015-01-16 23:29:29', 'duncare', 0),
(21, 6, 17, '2015-01-16 23:30:03', 'duncare', 0),
(22, 6, 17, '2015-01-16 23:30:33', 'duncare', 0),
(23, 6, 17, '2015-01-16 23:31:09', 'duncare', 0),
(24, 6, 17, '2015-01-16 23:31:10', 'duncare', 0),
(25, 6, 17, '2015-01-16 23:32:31', 'duncare', 0),
(26, 6, 17, '2015-01-16 23:32:40', 'duncare', 0),
(27, 6, 17, '2015-01-16 23:33:13', 'please tell them I said something', 0),
(28, 6, 17, '2015-01-16 23:33:17', 'duncare', 0),
(29, 6, 17, '2015-01-16 23:33:18', 'duncare', 0),
(30, 2, 17, '2015-01-16 23:37:27', 'please tell them I said something mklmlmk', 0),
(31, 3, 17, '2015-01-27 19:08:52', 'This is a notifs test!', 0),
(32, 8, 17, '2015-02-19 14:05:17', 'why you no comment grrrr', 0),
(33, 8, 17, '2015-02-19 14:06:18', 'BRUUHHH DAT IRONY THO', 0),
(34, 4, 17, '2015-02-20 10:49:10', 'test too', 1),
(35, 4, 17, '2015-02-20 10:52:00', 'look ma another test', -1),
(36, 4, 17, '2015-02-20 11:15:13', 'post test', 0),
(37, 4, 17, '2015-02-20 11:17:10', 'JUST WORK PLS', 0),
(38, 11, 17, '2015-02-22 15:15:02', 'LOL', 0),
(39, 12, 17, '2015-03-01 12:31:36', 'What a [b]stupid[/b] question', 1),
(40, 21, 20, '2015-04-04 02:33:22', 'Title should be removed', -2);

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

--
-- Table structure for table `notifs`
--

CREATE TABLE IF NOT EXISTS `notifs` (
  `notif_id` int(20) NOT NULL AUTO_INCREMENT,
  `notif_user_id` int(9) NOT NULL,
  `notif_text` varchar(100) NOT NULL,
  `notif_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `notif_type` varchar(10) NOT NULL DEFAULT 'vote',
  `notif_vote_origin` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`notif_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1817 ;

--
-- Dumping data for table `notifs`
--

INSERT INTO `notifs` (`notif_id`, `notif_user_id`, `notif_text`, `notif_date`, `notif_type`, `notif_vote_origin`) VALUES
(69, 17, 'Richie left a comment on <b>How do I ask a favor on this site?</b>.', '2015-01-27 19:08:52', 'comment', ''),
(75, 17, 'Richie left a submission on <b>How do I ask a favor on this site?</b>.', '2015-01-27 19:10:12', 'submission', ''),
(189, 17, '[b]jlnmm[/b] now has 1 votes.', '2015-01-28 09:57:09', 'vote', 'request5'),
(190, 17, '[b][i]This post has been flagged for deletion[/i][/b] now has 0 votes.', '2015-01-28 09:57:09', 'vote', 'comment11'),
(191, 17, '[b]test[/b] now has 0 votes.', '2015-01-28 09:57:09', 'vote', 'comment12'),
(192, 17, '[b]This post is spam.[/b] now has 0 votes.', '2015-01-28 09:57:09', 'vote', 'submission5'),
(265, 17, '[b][/b] now has 0 votes.', '2015-02-01 14:48:56', 'vote', 'request7'),
(1587, 17, '[b]How do I ask a favor on this site?[/b] now has 1 votes.', '2015-02-16 23:17:30', 'vote', 'request3'),
(1588, 17, '[b]You just did.[/b] now has 1 votes.', '2015-02-16 23:17:30', 'vote', 'comment8'),
(1589, 17, '[b]This is a notifs test![/b] now has 0 votes.', '2015-02-16 23:17:30', 'vote', 'comment31'),
(1590, 17, '[b][/b] now has 0 votes.', '2015-02-16 23:17:30', 'vote', 'submission10'),
(1591, 17, '[b]Testing[/b] now has -1 votes.', '2015-02-16 23:17:30', 'vote', 'submission6'),
(1684, 17, '[b]What is 1+1?[/b] now has 1 votes.', '2015-02-17 18:15:16', 'vote', 'request2'),
(1685, 17, '[b]I learnt this in class last week, its 2.[/b] now has 0 votes.', '2015-02-17 18:15:16', 'vote', 'comment13'),
(1687, 17, '[b]This is very interesting! Not sure how to approach the problem though...[/b] now has 1 votes.', '2015-02-17 18:15:16', 'vote', 'comment7'),
(1688, 17, '[b]According to my calculator,the answer is  2[/b] now has 0 votes.', '2015-02-17 18:15:17', 'vote', 'comment10'),
(1689, 17, '[b]I think its 43[/b] now has -1 votes.', '2015-02-17 18:15:17', 'vote', 'comment9'),
(1690, 17, '[b]please tell them I said something mklmlmk[/b] now has 0 votes.', '2015-02-17 18:15:17', 'vote', 'comment30'),
(1692, 17, '[b]Its 2.[/b] now has 1 votes.', '2015-02-17 18:15:17', 'vote', 'submission4'),
(1693, 17, '[b][/b] now has -1 votes.', '2015-02-17 18:15:17', 'vote', 'submission9'),
(1717, 17, '[b]test[/b] now has 1 votes.', '2015-02-19 13:49:13', 'vote', 'request6'),
(1718, 17, '[b]Richie sincerely hopes this works[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment15'),
(1719, 17, '[b]I solemnly swear that I am up to no good.[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment16'),
(1720, 17, '[b].good no to up am I that swear solemnly I[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment17'),
(1721, 17, '[b].works this hopes sincerely Richie[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment18'),
(1722, 17, '[b]eff[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment19'),
(1723, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment21'),
(1724, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment22'),
(1725, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment23'),
(1726, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment24'),
(1727, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment26'),
(1728, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment25'),
(1729, 17, '[b]please tell them I said something[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment27'),
(1730, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment28'),
(1731, 17, '[b]duncare[/b] now has 0 votes.', '2015-02-19 13:49:14', 'vote', 'comment29'),
(1732, 17, '[b]Help me with this[/b] now has 1 votes.', '2015-02-19 13:53:09', 'vote', 'request1'),
(1733, 18, '[b]SPAM IS GREAT[/b] now has 2 votes.', '2015-02-19 13:53:10', 'vote', 'comment1'),
(1734, 18, '[b]SPAM IS GREAT[/b] now has 0 votes.', '2015-02-19 13:53:10', 'vote', 'comment3'),
(1735, 18, '[b]SPAM IS GREAT[/b] now has -1 votes.', '2015-02-19 13:53:10', 'vote', 'comment4'),
(1736, 18, '[b]SPAM IS GREAT[/b] now has 1 votes.', '2015-02-19 13:53:10', 'vote', 'comment2'),
(1737, 18, '[b]SPAM IS GREAT[/b] now has -1 votes.', '2015-02-19 13:53:10', 'vote', 'comment5'),
(1738, 17, '[b]World[/b] now has 1 votes.', '2015-02-19 13:53:10', 'vote', 'comment14'),
(1743, 17, 'Richie left a comment on [b]GET TEST[/b].', '2015-02-19 13:53:36', 'comment', ''),
(1746, 17, 'Richie left a submission on [b]GET TEST[/b].', '2015-02-19 13:55:35', 'submission', ''),
(1750, 17, '[b]GET TEST[/b] now has 1 votes.', '2015-02-19 13:56:29', 'vote', 'request8'),
(1753, 17, 'Richie left a submission on [b]GET TEST[/b].', '2015-02-19 13:57:46', 'submission', ''),
(1758, 17, '[b]Hi[/b] now has -1 votes.', '2015-02-19 14:03:05', 'vote', 'submission11'),
(1759, 17, '[b]Test 2[/b] now has 1 votes.', '2015-02-19 14:03:16', 'vote', 'submission12'),
(1760, 17, 'Richie left a comment on [b]GET TEST[/b].', '2015-02-19 14:05:17', 'comment', ''),
(1761, 17, '[b]why you no comment grrrr[/b] now has 0 votes.', '2015-02-19 14:05:22', 'vote', 'comment32'),
(1762, 17, 'Richie left a comment on [b]GET TEST[/b].', '2015-02-19 14:06:18', 'comment', ''),
(1767, 17, '[b]BRUUHHH DAT IRONY THO[/b] now has 1 votes.', '2015-02-19 14:11:49', 'vote', 'comment33'),
(1771, 17, '[b]test again[/b] now has 1 votes.', '2015-02-19 14:58:47', 'vote', 'request10'),
(1772, 17, 'Richie left a comment on [b]test[/b].', '2015-02-20 10:49:10', 'comment', ''),
(1773, 17, 'Richie left a comment on [b]test[/b].', '2015-02-20 10:52:00', 'comment', ''),
(1774, 17, 'Richie left a submission on [b]test[/b].', '2015-02-20 11:09:05', 'submission', ''),
(1775, 17, 'Richie left a comment on [b]test[/b].', '2015-02-20 11:15:13', 'comment', ''),
(1776, 17, 'Richie left a comment on [b]test[/b].', '2015-02-20 11:17:10', 'comment', ''),
(1777, 17, 'Richie left a submission on [b]test[/b].', '2015-02-20 15:39:28', 'submission', ''),
(1779, 17, '[b]Test POST`[/b] now has 1 votes.', '2015-02-20 16:16:46', 'vote', 'submission13'),
(1781, 17, '[b]test[/b] now has 1 votes.', '2015-02-20 16:42:39', 'vote', 'submission7'),
(1782, 17, '[b]look ma another test[/b] now has -1 votes.', '2015-02-20 16:42:48', 'vote', 'comment35'),
(1783, 17, '[b]test too[/b] now has 1 votes.', '2015-02-20 16:44:00', 'vote', 'comment34'),
(1787, 17, 'Richie left a submission on [b]Hello[/b].', '2015-02-22 15:14:38', 'submission', ''),
(1788, 17, '[b]Yes[/b] now has 1 votes.', '2015-02-22 15:14:49', 'vote', 'submission15'),
(1789, 17, '[b]Hello[/b] now has -1 votes.', '2015-02-22 15:14:51', 'vote', 'request11'),
(1790, 17, 'Richie left a comment on [b]Hello[/b].', '2015-02-22 15:15:02', 'comment', ''),
(1791, 17, 'Richie left a comment on [b]Why is the sky blue?[/b].', '2015-03-01 12:31:36', 'comment', ''),
(1792, 17, '[b]What a [b]stupid[/b] question[/b] now has 1 votes.', '2015-03-01 12:31:45', 'vote', 'comment39'),
(1793, 17, 'Richie left a submission on [b]Why is the sky blue?[/b].', '2015-03-01 12:32:38', 'submission', ''),
(1794, 17, '[b]Why is the sky blue?[/b] now has 1 votes.', '2015-03-06 22:21:56', 'vote', 'request12'),
(1795, 17, '[b]This is very interesting! Not sure how to approach the problem though...[/b] now has -1 votes.', '2015-03-22 16:08:49', 'vote', 'comment6'),
(1796, 17, '[b]The addition of two real integers using radicals[/b] now has 1 votes.', '2015-03-31 07:47:12', 'vote', 'submission3'),
(1798, 17, '[b]What.[/b] now has 1 votes.', '2015-04-03 14:42:23', 'vote', 'submission1'),
(1799, 17, '[b]43[/b] now has 1 votes.', '2015-04-03 14:42:25', 'vote', 'submission8'),
(1800, 18, '[b]Im a terrible human being[/b] now has 1 votes.', '2015-04-03 14:42:44', 'vote', 'submission2'),
(1801, 17, 'Richie left a submission on [b]FINAL (I hope)[/b].', '2015-04-03 15:47:21', 'submission', ''),
(1802, 17, 'Richie left a submission on [b]I hate this project[/b].', '2015-04-04 02:21:05', 'submission', ''),
(1803, 17, '[b]abc[/b] now has 1 votes.', '2015-04-04 02:21:12', 'vote', 'submission18'),
(1804, 17, 'max left a comment on [b]Test that favor[/b].', '2015-04-04 02:33:22', 'comment', ''),
(1805, 17, 'max left a submission on [b]Test that favor[/b].', '2015-04-04 02:33:41', 'submission', ''),
(1811, 20, '[b]submission 1[/b] now has 2 votes.', '2015-04-04 02:34:26', 'vote', 'submission19'),
(1812, 20, '[b]Title should be removed[/b] now has -2 votes.', '2015-04-04 02:34:28', 'vote', 'comment40'),
(1813, 17, '[b]Test that favor[/b] now has 1 votes.', '2015-04-04 02:34:30', 'vote', 'request21'),
(1816, 17, '[b]test[/b] now has 1 votes.', '2015-04-07 10:47:48', 'vote', 'request4');

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

--
-- Table structure for table `prelaunch`
--

CREATE TABLE IF NOT EXISTS `prelaunch` (
  `prelaunch_id` int(11) NOT NULL AUTO_INCREMENT,
  `prelaunch_email` varchar(75) NOT NULL,
  `prelaunch_profession` varchar(30) NOT NULL,
  `prelaunch_keys` varchar(300) DEFAULT NULL,
  `prelaunch_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`prelaunch_id`),
  UNIQUE KEY `prelaunch_email` (`prelaunch_email`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `prelaunch`
--

INSERT INTO `prelaunch` (`prelaunch_id`, `prelaunch_email`, `prelaunch_profession`, `prelaunch_keys`, `prelaunch_time`) VALUES
(1, 'testing', 'potato', 'keys', '2015-02-14 11:31:48'),
(2, '', '', '', '2015-02-14 11:35:29'),
(3, 'abc', '123', 'lolcakes', '2015-02-14 11:36:35'),
(5, 'officegunner@gmail.com', 'programmer', '111,102,102,105,99,101,103,117,110,110,101,114,34,103,109,97,105,108,46,99,111,109,13,64,13', '2015-02-14 11:39:55'),
(8, 'abc@123.com', 'programmer', '97,98,99,64,49,50,51,46,99,111,109,13', '2015-02-14 11:54:29'),
(9, 'maxlow21@gmail.com', 'musician', '111,102,102,105,99,101,103,109,97,120,108,111,119,50,49,64,103,109,97,105,108,46,99,111,109,13', '2015-02-14 12:40:02');

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

--
-- Table structure for table `requests`
--

CREATE TABLE IF NOT EXISTS `requests` (
  `request_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(9) NOT NULL,
  `request_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `request_duration` int(7) NOT NULL DEFAULT '3600',
  `request_title` varchar(50) NOT NULL,
  `request_text` text NOT NULL COMMENT 'how long the request lasts',
  `request_cheese` int(5) NOT NULL,
  `request_points` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `requests`
--

INSERT INTO `requests` (`request_id`, `user_id`, `request_start`, `request_duration`, `request_title`, `request_text`, `request_cheese`, `request_points`) VALUES
(1, 17, '2014-08-26 11:46:55', 86400, 'Help me with this', 'Hey guys whats the time complexity of tiling evenly-distributed one-sided polyminos [b]order 4[/b] in a [s]9-column grid[/s] augmented with a column vector comprising straight polyminos?\n[center][color=red]WOT.[/color][/center]\n[img]http://upload.wikimedia.org/wikipedia/en/5/5f/Original_Doge_meme.jpg[/img]\n[youtube]UvoK3sSr1w0[/youtube]', 42, 1),
(2, 17, '2014-10-01 20:07:15', 99999, 'What is 1+1?', 'Hi. I have been looking for a long time and I really have no idea what the answer to [b][i]1+1[/i][/b] is. I have a hunch that it is [color="#F00"][u]2[/u][/color]', 50, 1),
(3, 17, '2014-10-01 22:37:41', 60000, 'How do I ask a favor on this site?', 'Hi! I am bob and I am new to this site. I do not actually know how to post a request on to this site, so I am going to ask using this request box! Please dun hate, any feedback would be appreciated. Thanks!', 0, 1),
(4, 17, '2014-10-01 23:04:16', 3600, 'test', 'test', 100, 1),
(5, 17, '2014-10-03 13:26:03', 5845, 'jlnmm', 'fghncdfrtyujm', 0, 1),
(6, 17, '2015-01-14 21:00:49', 3600, 'test', 'this tis their test text there', 0, 1),
(7, 17, '2015-02-01 14:48:47', 3600, '', 'testing testing', 0, 0),
(8, 17, '2015-02-19 13:48:07', 3600, 'GET TEST', 'I REALLY HOPE THIS WORKS', 0, 1),
(9, 17, '2015-02-19 14:24:15', 3600, 'cheese   time test', 'cheese time test :o', 0, 0),
(10, 17, '2015-02-19 14:27:34', 3600, 'test again', '[b]dummy text[/b]', 80, 0),
(11, 17, '2015-02-22 15:13:59', 7139, 'Hello', 'Diapers are cool[b]:)[/b]', 0, -1),
(12, 17, '2015-03-01 12:31:09', 3600, 'Why is the sky blue?', 'I was walking outside today, and I noticed that the sky is blue. Can anyone tell me why the sky is blue?', 0, 1),
(13, 17, '2015-04-03 03:05:38', 3600, 'Transaction test', 'I hope the transaction works', 0, 0),
(14, 17, '2015-04-03 03:14:04', 3600, 'Transaction Test', 'This time I hope transactions work', 0, 0),
(15, 17, '2015-04-03 10:39:12', 3600, 'a', 'cheese test 1', 20, 0),
(16, 17, '2015-04-03 13:55:20', 3600, 'q', 'cheese test2 :/', 0, 0),
(17, 17, '2015-04-03 14:14:27', 3600, 'FINAL (I hope)', 'Hello this is a cheese test', 0, 0),
(18, 17, '2015-04-03 14:15:02', 3600, 'FINAL (I hope)', 'Hello this is a cheese test', 0, 0),
(19, 17, '2015-04-03 14:16:37', 3600, 'Does subtraction work?', '[i]Does subtraction work?[/i]', 50, 0),
(20, 17, '2015-04-04 02:17:56', 3600, 'I hate this project', 'Can you just work [b]please[/b]', 50, 0),
(21, 17, '2015-04-04 02:32:03', 3600, 'Test that favor', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 50, 1);

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

--
-- Table structure for table `submissions`
--

CREATE TABLE IF NOT EXISTS `submissions` (
  `submission_id` int(10) NOT NULL AUTO_INCREMENT,
  `request_id` int(10) NOT NULL,
  `user_id` int(9) NOT NULL,
  `submission_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `submission_title` varchar(50) NOT NULL,
  `submission_text` text NOT NULL,
  `submission_points` int(5) NOT NULL DEFAULT '0' COMMENT 'although this seems to break third normal form, it seems that it is worth breaking for efficentcy',
  PRIMARY KEY (`submission_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `submissions`
--

INSERT INTO `submissions` (`submission_id`, `request_id`, `user_id`, `submission_time`, `submission_title`, `submission_text`, `submission_points`) VALUES
(1, 1, 17, '2014-08-26 11:50:47', 'What.', 'What are you on about... this makes no sense. <!--intrusive html here-->', 0),
(2, 1, 18, '2014-08-26 11:50:47', 'Im a terrible human being', 'I THINK CATS ARE DOGS WITH AN ATTITUDE [i] SMUG FACE [/i]', 1),
(3, 2, 17, '2014-10-01 22:29:50', 'The addition of two real integers using radicals', 'In order to get the answer, you must first take the [i]first term[/i] and add it to the [i]second term[/i], using the additional table, where:  /0/1/2/3/4/5/6/7/8/9/0/0/0/0/0/0/0/0/0/0/0/1/0/1/2/3/4/5/6/7/8/92/0/2/4/6/8/10/12/14/16/18... which means [i][b]1+1=2[/b][/i]', 0),
(4, 2, 17, '2014-10-02 13:55:55', 'Its 2.', 'I am a professor and number theory, and I am 100% certain its 2', 1),
(5, 5, 17, '2014-10-03 13:29:21', 'This post is spam.', '[i] This Post has been Flagged for Deletion[/i]', 0),
(6, 3, 17, '2014-10-03 13:29:55', 'Testing', 'Testing', -1),
(7, 4, 17, '2014-10-03 13:32:07', 'test', 'test', 1),
(8, 1, 17, '2014-10-04 20:35:55', '43', '[i]The answer to the universe is 43.[/i]', 1),
(9, 2, 17, '2015-01-16 23:45:27', '', '1 1 = 69 durrr', -1),
(10, 3, 17, '2015-01-27 19:10:12', '', 'This is a notifs test!', 0),
(11, 8, 17, '2015-02-19 13:55:35', 'Hi', 'Does submissions work?', -1),
(12, 8, 17, '2015-02-19 13:57:46', 'Test 2', 'I hope submissions work', 1),
(13, 4, 17, '2015-02-20 11:09:05', 'Test POST`', 'come on POST', 1),
(14, 4, 17, '2015-02-20 15:39:28', 'POST TEST', 'POST TEST BRIUHHHHHHHH', 0),
(15, 11, 17, '2015-02-22 15:14:38', 'Yes', 'Diapers are the state of art technology for babycare :D', 1),
(16, 12, 17, '2015-03-01 12:32:38', '', 'The sky is blue, due to Rayleigh Scattering, with blue being a shorter wavelength than red light', 0),
(17, 17, 17, '2015-04-03 15:47:21', 'Submission 1', 'DUR IM NOT USING MY HEAD', 0),
(18, 20, 17, '2015-04-04 02:21:05', 'abc', '1   1 = 25', 1),
(19, 21, 20, '2015-04-04 02:33:41', 'submission 1', 'vote for me pls', 2);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE IF NOT EXISTS `transactions` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `request_id` int(11) NOT NULL,
  `due_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `request_id` (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `users_join`
--

CREATE TABLE IF NOT EXISTS `users_join` (
  `user_join_id` int(9) NOT NULL AUTO_INCREMENT,
  `cheese` float DEFAULT '0',
  `float_cheese` float DEFAULT '0',
  `reputation` int(4) DEFAULT '1729',
  `description` text,
  PRIMARY KEY (`user_join_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `users_join`
--

INSERT INTO `users_join` (`user_join_id`, `cheese`, `float_cheese`, `reputation`, `description`) VALUES
(1, 0, 0, 1729, NULL),
(2, 0, 0, 1729, NULL),
(3, 0, 0, 1729, NULL),
(4, 0, 0, 1729, NULL),
(5, 0, 0, 1729, NULL),
(6, 0, 0, 1729, NULL),
(7, 0, 0, 1729, NULL),
(8, 0, 0, 1729, NULL),
(9, 0, 0, 1729, NULL),
(10, 0, 0, 1729, NULL),
(11, 0, 0, 1729, NULL),
(12, 0, 0, 1729, NULL),
(13, 0, 0, 1729, NULL),
(14, 0, 0, 1729, NULL),
(15, 0, 0, 1729, NULL),
(16, 0, 0, 1729, NULL),
(17, 19880, 0, 1729, NULL),
(18, 0, 0, 1729, NULL),
(19, 0, 0, 1729, NULL),
(20, 50, 0, 1729, NULL),
(21, 0, 0, 1729, NULL);

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

--
-- Table structure for table `votes`
--

CREATE TABLE IF NOT EXISTS `votes` (
  `vote_id` int(11) NOT NULL AUTO_INCREMENT,
  `request_ide` int(10) NOT NULL DEFAULT '-1' COMMENT 'ide resolves dis-ambiguity bug',
  `submission_ide` int(10) NOT NULL DEFAULT '-1' COMMENT 'ide resolves dis-ambiguity bug',
  `comment_ide` int(10) NOT NULL DEFAULT '-1' COMMENT 'ide resolves dis-ambiguity bug',
  `user_id` int(9) NOT NULL,
  `choice` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`vote_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;

--
-- Dumping data for table `votes`
--

INSERT INTO `votes` (`vote_id`, `request_ide`, `submission_ide`, `comment_ide`, `user_id`, `choice`) VALUES
(5, 1, -1, -1, 17, 1),
(10, 1, -1, -1, 18, 1),
(11, -1, -1, 1, 18, 1),
(12, -1, -1, 1, 17, 1),
(13, -1, -1, 3, 17, 0),
(14, -1, -1, 4, 17, -1),
(15, -1, 2, -1, 17, 1),
(16, -1, 2, -1, 18, -1),
(18, -1, -1, 2, 17, 1),
(19, -1, -1, 5, 17, -1),
(20, -1, 1, -1, 17, -1),
(21, 2, -1, -1, 17, 1),
(22, -1, -1, 6, 17, -1),
(23, -1, -1, 7, 17, 1),
(24, -1, 3, -1, 17, 0),
(25, 3, -1, -1, 17, 1),
(26, -1, -1, 8, 17, 1),
(27, 4, -1, -1, 17, 1),
(28, -1, -1, 9, 17, -1),
(29, -1, 4, -1, 17, 1),
(30, -1, -1, 10, 17, 0),
(31, 5, -1, -1, 17, 1),
(32, -1, -1, 11, 17, 0),
(33, -1, 6, -1, 17, -1),
(34, -1, 7, -1, 17, 1),
(35, -1, 5, -1, 17, 0),
(36, -1, -1, 12, 17, 0),
(37, -1, 8, -1, 17, 1),
(38, -1, -1, 13, 17, 0),
(39, -1, -1, 14, 17, 1),
(40, 6, -1, -1, 17, 1),
(41, -1, -1, 15, 17, 0),
(42, -1, -1, 16, 17, 0),
(43, -1, -1, 17, 17, 0),
(44, -1, -1, 18, 17, 0),
(45, -1, -1, 19, 17, 0),
(46, -1, -1, 30, 17, 0),
(47, -1, 9, -1, 17, -1),
(48, -1, -1, 31, 17, 0),
(49, -1, 10, -1, 17, 0),
(50, 7, -1, -1, 17, 0),
(51, -1, -1, 21, 17, 0),
(52, -1, -1, 22, 17, 0),
(53, -1, -1, 23, 17, 0),
(54, -1, -1, 24, 17, 0),
(55, -1, -1, 26, 17, 0),
(56, -1, -1, 25, 17, 0),
(57, -1, -1, 27, 17, 0),
(58, -1, -1, 28, 17, 0),
(59, -1, -1, 29, 17, 0),
(60, 8, -1, -1, 17, 1),
(61, -1, 11, -1, 17, -1),
(62, -1, 12, -1, 17, 1),
(63, -1, -1, 32, 17, 0),
(64, -1, -1, 33, 17, 0),
(65, 9, -1, -1, 17, 0),
(66, 10, -1, -1, 17, 0),
(67, -1, -1, 34, 17, 1),
(68, -1, -1, 35, 17, -1),
(69, -1, 13, -1, 17, 1),
(70, -1, -1, 36, 17, 0),
(71, -1, -1, 37, 17, 0),
(72, -1, 14, -1, 17, 0),
(73, 11, -1, -1, 17, -1),
(74, -1, 15, -1, 17, 1),
(75, -1, -1, 38, 17, 0),
(76, 12, -1, -1, 17, 1),
(77, -1, -1, 39, 17, 1),
(78, -1, 16, -1, 17, 0),
(79, 14, -1, -1, 17, 0),
(80, 17, -1, -1, 17, 0),
(81, -1, 17, -1, 17, 0),
(82, 20, -1, -1, 17, 0),
(83, -1, 18, -1, 17, 1),
(84, 21, -1, -1, 20, 0),
(85, -1, -1, 40, 20, -1),
(86, -1, 19, -1, 20, 1),
(87, 21, -1, -1, 17, 1),
(88, -1, -1, 40, 17, -1),
(89, -1, 19, -1, 17, 1);

