If i compare a database using ibexpert or clever components dbcomparer,
with a master sql schema, it shows they are identical.

If i do a backup and restore and then compare them i get a ton of the
following

/* Alter Field (Null / Not Null)... */
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
RDB$FIELD_NAME='ALTMENUITEMID' AND RDB$RELATION_NAME='ALTMENUITEM';

/* Alter Field (Null / Not Null)... */
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
RDB$FIELD_NAME='NAME' AND RDB$RELATION_NAME='ALTMENUITEM';

/* Alter Field (Null / Not Null)... */
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
RDB$FIELD_NAME='DESCRIPTION' AND RDB$RELATION_NAME='BILLCAT';

/* Alter Field (Null / Not Null)... */
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
RDB$FIELD_NAME='BILLCATNUM' AND RDB$RELATION_NAME='BILLCAT';

/* Alter Field (Null / Not Null)... */
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
RDB$FIELD_NAME='CREATED' AND RDB$RELATION_NAME='BILLCAT';

/* Alter Field (Null / Not Null)... */
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
RDB$FIELD_NAME='CALENDARNOTEID' AND RDB$RELATION_NAME='CALENDARNOTE';

/* Alter Field (Null / Not Null)... */
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
RDB$FIELD_NAME='CALENDARDATE' AND RDB$RELATION_NAME='CALENDARNOTE';


is the restore not restoring it identically? i'm using FIBPlus 6.25 to
do the restore, but i would imagine its just part of the firebird server
which is the latest 1.5.2.

any ideas?

thanks