# script para criar o banco e tabelas necessarias

CREATE DATABASE kxmidia;

CREATE USER 'midiatvz_kxmidia'@'localhost' IDENTIFIED BY '4Tm7k[b7[';

GRANT ALL PRIVILEGES ON kxmidia.* TO 'midiatvz_kxmidia'@'localhost';

FLUSH PRIVILEGES;

CREATE TABLE `playlists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `folder_slug` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `access_code` char(6) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `access_code` (`access_code`),
  KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;