1QpLFQn8

1CREATE TABLE IF NOT EXISTS `channels` (
2  `channel_id` INT NOT NULL AUTO_INCREMENT,
3  `name` VARCHAR (128) NOT NULL,
4  `description` VARCHAR(255) NOT NULL,
5  PRIMARY KEY (`channel_id`))
6ENGINE = InnoDB;
7
8CREATE TABLE IF NOT EXISTS `messages` (
9  `message_id` INT NOT NULL AUTO_INCREMENT,
10  `messages_text` VARCHAR(255) NOT NULL,
11  `sender_username` VARCHAR(45) NOT NULL,
12  `sender_email` VARCHAR(45) NOT NULL,
13  `channel` INT NOT NULL,
14  `time_sent` DATETIME NOT NULL,
15  `is_read` TINYINT(1) NULL DEFAULT 0,
16  PRIMARY KEY (`message_id`),
17  CONSTRAINT `channel`
18    FOREIGN KEY (`channel`)
19    REFERENCES `channels` (`channel_id`)
20    ON DELETE CASCADE
21    ON UPDATE CASCADE)
22ENGINE = InnoDB;
23
24
25INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('1', 'Test', 'test 1');
26INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('2', 'Test 2', 'Test 2');
27INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('3', 'Test 3', 'Test 3');
28INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('4', 'Test 4', 'Test 4');
29
30INSERT INTO `implementacijasistemi`.`messages` (`message_id`, `messages_text`, `sender_username`, `sender_email`, `channel`, `time_sent`) VALUES ('1', 'tekst teskt', 'Tom', 'tom_email@gmail.com', '1', '2000-03-15');
31INSERT INTO `implementacijasistemi`.`messages` (`message_id`, `messages_text`, `sender_username`, `sender_email`, `channel`, `time_sent`, `is_read`) VALUES ('2', 'bla bla bla', 'Kici', 'kici@email.com', '1', '2010-05-05', '1');
32INSERT INTO `implementacijasistemi`.`messages` (`message_id`, `messages_text`, `sender_username`, `sender_email`, `channel`, `time_sent`) VALUES ('3', 'finki finki', 'Martin', 'martin@hotmail.com', '2', '2018-01-01');
33INSERT INTO `implementacijasistemi`.`messages` (`message_id`, `messages_text`, `sender_username`, `sender_email`, `channel`, `time_sent`) VALUES ('4', 'shlak shlak', 'Bobo', 'bobo@gmail.com', '3', '2015-05-15');