-- Impor SATU KALI ke database baru khusus VitLashes. Tidak menghapus tabel yang ada.
CREATE TABLE vl_users (
 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 email VARCHAR(190) NOT NULL UNIQUE,
 password_hash VARCHAR(255) NOT NULL,
 name VARCHAR(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE vl_lock (
 id TINYINT UNSIGNED NOT NULL PRIMARY KEY,
 attempts INT UNSIGNED NOT NULL DEFAULT 0,
 window_start BIGINT UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO vl_lock (id) VALUES (1);
CREATE TABLE vl_bookings (
 id CHAR(32) NOT NULL PRIMARY KEY,
 name VARCHAR(100) NOT NULL,
 phone VARCHAR(30) NOT NULL,
 service VARCHAR(100) NOT NULL,
 date DATE NOT NULL,
 start SMALLINT UNSIGNED NOT NULL,
 duration SMALLINT UNSIGNED NOT NULL,
 price INT UNSIGNED NOT NULL,
 paid INT UNSIGNED NOT NULL,
 status VARCHAR(20) NOT NULL,
 note TEXT NOT NULL,
 created DATETIME NOT NULL,
 updated DATETIME NOT NULL,
 INDEX booking_date (date, status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;