Drill 5: Summarise — Setup and tools

CREATE DATABASE edubyte CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
USE edubyte;

CREATE TABLE lessons (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  course_slug VARCHAR(80) NOT NULL,
  title VARCHAR(160) NOT NULL,
  minutes SMALLINT UNSIGNED NOT NULL DEFAULT 10,
  INDEX lessons_course_idx (course_slug)
);

INSERT INTO lessons (course_slug, title, minutes) VALUES ('css', 'Grid', 18);