We have Enterprise 220.127.116.11 running on Microsoft Server on a SQL stack
IN a module we have a custom field that is of type checkbox
Everytime we run a Quick repair and rebuild on this field we get a "mismatch with Database" hit in the SQL for Differences between the Database and the vardefs..
/*MISMATCH WITH DATABASE - concluded - ROW [name] => 'concluded' [type] => 'bit' [len] => '1' [default] => '0' */
/* VARDEF - concluded - ROW[required] => '' [name] => 'concluded' [vname] => 'LBL_CONCLUDED' [type] => 'bit' [massupdate] => '' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'enabled' [duplicate_merge_dom_value] => '1' [audited] => '' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [calculated] => '' [len] => '255' [size] => '20' [dbType] => 'bool' */
ALTER TABLE sior_referrals DROP CONSTRAINT DF__sior_refe__concl__33FF9E21;
ALTER TABLE sior_referrals ALTER COLUMN concluded bit NULL;
ALTER TABLE sior_referrals ADD DEFAULT 0 FOR concluded;
Now we can execute this SQL all we want but it does not resolve the missmatch.
I know the DB is essentially valid, but I would rather clean this sort of thing up.
What can be done to resolve this?