-- Create Database
CREATE DATABASE music_video_player;
USE music_video_player;

-- Videos Table
CREATE TABLE videos (
    video_id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    artist VARCHAR(255) NOT NULL,
    album VARCHAR(255),
    genre VARCHAR(100),
    video_url VARCHAR(500) NOT NULL,
    thumbnail_url VARCHAR(500),
    duration_seconds INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert Sample Data
INSERT INTO videos (title, artist, album, genre, video_url, thumbnail_url, duration_seconds) 
VALUES 
('Blinding Lights', 'The Weeknd', 'After Hours', 'Synthwave', 'https://commondatastorage.googleapis.com/gtv-videos-bucket/sample/BigBuckBunny.mp4', 'https://via.placeholder.com/150', 200),
('Levitating', 'Dua Lipa', 'Future Nostalgia', 'Pop', 'https://commondatastorage.googleapis.com/gtv-videos-bucket/sample/ElephantsDream.mp4', 'https://via.placeholder.com/150', 203),
('Starboy', 'The Weeknd', 'Starboy', 'R&B', 'https://commondatastorage.googleapis.com/gtv-videos-bucket/sample/ForBiggerBlazes.mp4', 'https://via.placeholder.com/150', 230);