-- Rename OPC table to hems_opcs.

SET @has_opcs := (
  SELECT COUNT(*)
  FROM information_schema.tables
  WHERE table_schema = DATABASE()
    AND table_name = 'opcs'
);

SET @has_hems_opcs := (
  SELECT COUNT(*)
  FROM information_schema.tables
  WHERE table_schema = DATABASE()
    AND table_name = 'hems_opcs'
);

SET @rename_sql := IF(
  @has_opcs > 0 AND @has_hems_opcs = 0,
  'RENAME TABLE opcs TO hems_opcs',
  'SELECT 1'
);

PREPARE stmt FROM @rename_sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;