S1ghzCFH

1DROP TABLE IF EXISTS `forum`;
2CREATE TABLE IF NOT EXISTS `forum` (
3  `id` int(5) NOT NULL AUTO_INCREMENT,
4  `formName` varchar(255) NOT NULL,
5  `forumDescription` varchar(255) NOT NULL,
6  `forumCreator` varchar(255) NOT NULL,
7  `forumCreationTime` varchar(255) NOT NULL,
8  `forumLink` varchar(255) NOT NULL,
9  PRIMARY KEY (`id`)
10) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
11
12INSERT INTO `forum` (`id`, `formName`, `forumDescription`, `forumCreator`, `forumCreationTime`, `forumLink`) VALUES
13(1, 'Lobby', 'You can chill here', 'ItsPeav', '14 June 2018, 16:27', 'lobby.php');
14
15DROP TABLE IF EXISTS `replies`;
16CREATE TABLE IF NOT EXISTS `replies` (
17  `id` int(5) NOT NULL AUTO_INCREMENT,
18  `replyOnThread` varchar(255) NOT NULL,
19  `replyCreationDate` varchar(255) NOT NULL,
20  `replyContent` varchar(255) NOT NULL,
21  `replyer` varchar(255) NOT NULL,
22  PRIMARY KEY (`id`)
23) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
24
25INSERT INTO `replies` (`id`, `replyOnThread`, `replyCreationDate`, `replyContent`, `replyer`) VALUES
26(6, 'I am hungry', '14 June 2018, 22:40', 'Yeah me2 man', 'deathcoderz');
27
28DROP TABLE IF EXISTS `threads`;
29CREATE TABLE IF NOT EXISTS `threads` (
30  `id` int(5) NOT NULL AUTO_INCREMENT,
31  `forum` varchar(255) NOT NULL,
32  `threadTitle` varchar(255) NOT NULL,
33  `threadCreator` varchar(255) NOT NULL,
34  `threadDescription` varchar(255) NOT NULL,
35  `threadReplys` varchar(255) NOT NULL,
36  `threadCreationDate` varchar(255) NOT NULL,
37  PRIMARY KEY (`id`)
38) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
39
40INSERT INTO `threads` (`id`, `forum`, `threadTitle`, `threadCreator`, `threadDescription`, `threadReplys`, `threadCreationDate`) VALUES
41(1, 'Lobby', 'I am hungry', 'ItsPeav', 'How do you feel about this?', '1', '14 June 2018, 22:39');
42
43DROP TABLE IF EXISTS `users`;
44CREATE TABLE IF NOT EXISTS `users` (
45  `id` int(11) NOT NULL AUTO_INCREMENT,
46  `username` varchar(100) NOT NULL,
47  `email` varchar(100) NOT NULL,
48  `password` varchar(100) NOT NULL,
49  PRIMARY KEY (`id`)
50) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
51
52
53INSERT INTO `users` (`id`, `username`, `email`, `password`) VALUES
54(1, 'deathcoderz', 'deathcoderz1337@gmail.com', '4489563c83d5a0bade4a89b4a4f2484d');
55COMMIT;