Technical Note: 20090113079

Database Maintenance

(Maitre'D 8.00.000.057 and later versions of Maitre'D)

ID Number

Individual records no longer have a preset ID number. When creating a new record, the next available number will be assigned by default, but the system will let you change it if the new number is not already assigned to another record in the same database table.

Note: There are some exceptions, such as the Reserved Media Types.

Every time a modified record is saved, by clicking on the OK or Apply button, what actually happens is a new record is created, to replace the former one, and that old one is made obsolete, but remains in the system, for a complete history. This allow for better tracking, as reports for the past will use the records that were active at the time of the transaction, rather then the current records.

Note: If an option is modified and immediately set back to the previous state, clicking on the OK button might actually create a new record in some more complex tables. Therefore, it is preferable to use the Cancel button when no change is required to avoid creating a twin record.

Delete Button

The Delete button has been moved from within the records to the table lists.

When replacing an existing record with another one, it is preferable to Delete the old record and Add the new one, because Modifying a record to use it for a different case could become confusing when printing legacy reports.

For example, if the Take Out task was edited, because that service is no longer offered, to make it a Valet task, at the end of the year, when printing the Valet salaries, they could include the former Take Out salaries as well.

Even if some tables still have a limited number of records, because of the Point Of Sales limitations, that number only applies to the current records, so that Take Out tasks will no longer count towards that limit anyway, even if it is still available for reports.