tekst

CREATE TABLE IF NOT EXISTS `channels` (
  `channel_id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR (128) NOT NULL,
  `description` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`channel_id`))
ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `messages` (
  `message_id` INT NOT NULL AUTO_INCREMENT,
  `messages_text` VARCHAR(255) NOT NULL,
  `sender_username` VARCHAR(45) NOT NULL,
  `sender_email` VARCHAR(45) NOT NULL,
  `channel` INT NOT NULL,
  `time_sent` DATETIME NOT NULL,
  `is_read` TINYINT(1) NULL DEFAULT 0,
  PRIMARY KEY (`message_id`),
  CONSTRAINT `channel`
    FOREIGN KEY (`channel`)
    REFERENCES `channels` (`channel_id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('1', 'Test', 'test 1');
INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('2', 'Test 2', 'Test 2');
INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('3', 'Test 3', 'Test 3');
INSERT INTO `implementacijasistemi`.`channels` (`channel_id`, `name`, `description`) VALUES ('4', 'Test 4', 'Test 4');

INSERT 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');
INSERT 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');
INSERT 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');
INSERT 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');