Difference found between database and vardef

[shamimwilson]

Hi all
I have installed sugarcrm community addition version 5.2.0c.
After installing I went to admin and repair.
Then I found a difference between vardef and database.


Plz help me regarding this issue...


example::::


/* Table : relationships */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'varchar' [len] => '36' */
/* VARDEF - id - ROW[name] => 'id' [vname] => 'LBL_ID' [type] => 'char' [required] => 'true' [dbType] => 'id' [len] => '36' */
/* INDEXES */
ALTER TABLE relationships modify column id char(36) NOT NULL ;
/* Table : acl_roles */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'varchar' [len] => '36' */
/* VARDEF - id - ROW[name] => 'id' [vname] => 'LBL_ID' [required] => 'true' [type] => 'char' [reportable] => '' [comment] => 'Unique identifier' [dbType] => 'id' [len] => '36' */
/*MISMATCH WITH DATABASE - date_entered - ROW [name] => 'date_entered' [type] => 'datetime' [default] => '0000-00-00 00:00:00' */
/* VARDEF - date_entered - ROW[name] => 'date_entered' [vname] => 'LBL_DATE_ENTERED' [type] => 'datetime' [required] => 'true' [comment] => 'Date record created' [dbType] => 'datetime' [len] => '' */
/*MISMATCH WITH DATABASE - date_modified - ROW [name] => 'date_modified' [type] => 'datetime' [default] => '0000-00-00 00:00:00' */
/* VARDEF - date_modified - ROW[name] => 'date_modified' [vname] => 'LBL_DATE_MODIFIED' [type] => 'datetime' [required] => 'true' [comment] => 'Date record last modified' [dbType] => 'datetime' [len] => '' */
/*MISMATCH WITH DATABASE - modified_user_id - ROW [name] => 'modified_user_id' [type] => 'varchar' [len] => '36' */
/* VARDEF - modified_user_id - ROW[name] => 'modified_user_id' [rname] => 'user_name' [id_name] => 'modified_user_id' [vname] => 'LBL_MODIFIED' [type] => 'char' [table] => 'modified_user_id_users' [isnull] => 'false' [dbType] => 'id' [required] => 'true' [len] => '36' [reportable] => '1' [comment] => 'User who last modified record' */
/*MISMATCH WITH DATABASE - created_by - ROW [name] => 'created_by' [type] => 'varchar' [len] => '36' */
/* VARDEF - created_by - ROW[name] => 'created_by' [rname] => 'user_name' [id_name] => 'created_by' [vname] => 'LBL_CREATED' [type] => 'char' [table] => 'created_by_users' [isnull] => 'false' [dbType] => 'id' [len] => '36' [comment] => 'User who created record' */
/* INDEXES */
ALTER TABLE acl_roles modify column id char(36) NOT NULL , modify column date_entered datetime NOT NULL , modify column date_modified datetime NOT NULL , modify column modified_user_id char(36) NOT NULL , modify column created_by char(36) NULL ;
/* Table : acl_actions */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'varchar' [len] => '36' */
/* VARDEF - id - ROW[name] => 'id' [vname] => 'LBL_ID' [required] => 'true' [type] => 'char' [reportable] => '' [comment] => 'Unique identifier' [dbType] => 'id' [len] => '36' */
/*MISMATCH WITH DATABASE - date_entered - ROW [name] => 'date_entered' [type] => 'datetime' [default] => '0000-00-00 00:00:00' */
/* VARDEF - date_entered - ROW[name] => 'date_entered' [vname] => 'LBL_DATE_ENTERED' [type] => 'datetime' [required] => 'true' [comment] => 'Date record created' [dbType] => 'datetime' [len] => '' */
/*MISMATCH WITH DATABASE - date_modified - ROW [name] => 'date_modified' [type] => 'datetime' [default] => '0000-00-00 00:00:00' */
/* VARDEF - date_modified - ROW[name] => 'date_modified' [vname] => 'LBL_DATE_MODIFIED' [type] => 'datetime' [required] => 'true' [comment] => 'Date record last modified' [dbType] => 'datetime' [len] => '' */
/*MISMATCH WITH DATABASE - modified_user_id - ROW [name] => 'modified_user_id' [type] => 'varchar' [len] => '36' */
/* VARDEF - modified_user_id - ROW[name] => 'modified_user_id' [rname] => 'user_name' [id_name] => 'modified_user_id' [vname] => 'LBL_MODIFIED' [type] => 'char' [table] => 'modified_user_id_users' [isnull] => 'false' [dbType] => 'id' [required] => 'true' [len] => '36' [reportable] => '1' [comment] => 'User who last modified record' */
/*MISMATCH WITH DATABASE - created_by - ROW [name] => 'created_by' [type] => 'varchar' [len] => '36' */
/* VARDEF - created_by - ROW[name] => 'created_by' [rname] => 'user_name' [id_name] => 'created_by' [vname] => 'LBL_CREATED' [type] => 'char' [table] => 'created_by_users' [isnull] => 'false' [dbType] => 'id' [len] => '36' [comment] => 'User ID who created record' */
/* INDEXES */

[crmsiva]

In the whole text, the following are the alterations to DB

ALTER TABLE relationships modify column id char(36) NOT NULL ;
ALTER TABLE acl_roles modify column id char(36) NOT NULL , modify column date_entered datetime NOT NULL , modify column date_modified datetime NOT NULL , modify column modified_user_id char(36) NOT NULL , modify column created_by char(36) NULL ;

You can execute this alter query?