[GH-ISSUE #121] migrations is created even though the default value is the same #226

New issue

Open

opened 2026-03-07 20:42:13 +03:00 by kerem · 0 comments

kerem commented

2026-03-07 20:42:13 +03:00

Owner

Originally created by @avp90 on GitHub (May 23, 2021).
Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/121

Database

CREATE DATABASE IF NOT EXISTS test;
CREATE TABLE `contacts_cstm` (
  `id_c` char(36) NOT NULL,
  `gic_skype_call_c` varchar(255) DEFAULT 'skype:{gic_skype_name_c}?call',
  PRIMARY KEY (`id_c`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8

new migration

command params: --include=up --type=schema

ALTER TABLE `contacts_cstm` CHANGE `gic_skype_call_c` `gic_skype_call_c` varchar(255) DEFAULT 'skype:{gic_skype_name_c}?call';

Originally created by @avp90 on GitHub (May 23, 2021). Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/121 ## Database ```sql CREATE DATABASE IF NOT EXISTS test; CREATE TABLE `contacts_cstm` ( `id_c` char(36) NOT NULL, `gic_skype_call_c` varchar(255) DEFAULT 'skype:{gic_skype_name_c}?call', PRIMARY KEY (`id_c`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 ``` ## new migration command params: --include=up --type=schema ```sql ALTER TABLE `contacts_cstm` CHANGE `gic_skype_call_c` `gic_skype_call_c` varchar(255) DEFAULT 'skype:{gic_skype_name_c}?call'; ```