22 lines
960 B
SQL
22 lines
960 B
SQL
-- KEI initial migration
|
|
-- Creates the table used by register.php and the admin review dashboard.
|
|
|
|
CREATE TABLE IF NOT EXISTS talent_applications (
|
|
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
full_name VARCHAR(190) NOT NULL,
|
|
email VARCHAR(190) NOT NULL,
|
|
whatsapp VARCHAR(50) NOT NULL,
|
|
category VARCHAR(50) NOT NULL,
|
|
photo_url VARCHAR(255) DEFAULT NULL,
|
|
video_url VARCHAR(255) DEFAULT NULL,
|
|
consent_accuracy TINYINT(1) NOT NULL DEFAULT 0,
|
|
consent_audition TINYINT(1) NOT NULL DEFAULT 0,
|
|
consent_contract TINYINT(1) NOT NULL DEFAULT 0,
|
|
consent_data TINYINT(1) NOT NULL DEFAULT 0,
|
|
status VARCHAR(20) NOT NULL DEFAULT 'review',
|
|
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
INDEX idx_talent_applications_status (status),
|
|
INDEX idx_talent_applications_created_at (created_at),
|
|
INDEX idx_talent_applications_email (email)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|