-- 52_time_punches_rep_p_mark_id.sql — vinculo opcional; NAO remove colunas
SET NAMES utf8mb4;

SET @col := (
  SELECT COUNT(*) FROM information_schema.COLUMNS
  WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'time_punches' AND COLUMN_NAME = 'rep_p_mark_id'
);
SET @q := IF(@col = 0,
  'ALTER TABLE `time_punches` ADD COLUMN `rep_p_mark_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `id`, ADD KEY `idx_time_punches_rep_p_mark` (`rep_p_mark_id`)',
  'SELECT 1');
PREPARE stmt FROM @q;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;