CREATE TABLE shared_cvs (uuid char(36) NOT NULL, user_uuid char(36) NOT NULL, cv_file varchar(255) NOT NULL, title varchar(255) DEFAULT NULL, description text DEFAULT NULL, is_public tinyint(1) DEFAULT 0, status enum('active','inactive') DEFAULT 'active', shared_at timestamp NOT NULL DEFAULT current_timestamp(), last_accessed timestamp NULL DEFAULT NULL, access_count int(11) DEFAULT 0, PRIMARY KEY (uuid), KEY idx_user_uuid (user_uuid), KEY idx_status (status), KEY idx_shared_at (shared_at), CONSTRAINT shared_cvs_ibfk_1 FOREIGN KEY (user_uuid) REFERENCES users (uuid) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 
