CREATE DATABASE IF NOT EXISTS game_store;
USE game_store;

CREATE TABLE accounts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    game VARCHAR(100) NOT NULL,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    price DECIMAL(15,2) NOT NULL,
    image VARCHAR(255),
    status ENUM('tersedia', 'terjual') DEFAULT 'tersedia',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO accounts
(game, title, description, price, image, status)
VALUES
(
    'Mobile Legends',
    'Akun MLBB Mythic - Skin Lengkap',
    'Rank Mythic dengan berbagai skin dan hero.',
    750000,
    'ml.jpg',
    'tersedia'
),
(
    'Free Fire',
    'Akun FF Sultan',
    'Banyak bundle dan skin senjata.',
    500000,
    'ff.jpg',
    'tersedia'
),
(
    'PUBG Mobile',
    'Akun PUBG Premium',
    'Akun dengan skin dan item premium.',
    1000000,
    'pubg.jpg',
    'tersedia'
);