Source: config/migrations/20260802-project-object-types.js

export const id = '20260802-project-object-types';
export const name = 'Add project, repositoryShare and directoryShare to ObjectBase.Type enum';

/**
 * Project objects are the Members source of truth for project-wide metadata.
 * Repository- and directory-shares are share objects belonging to exactly one
 * project. None of these target types gets its own visible-* filter type —
 * shares derive all rights from their project (see workspace plan 025).
 */
export const migrate = async ({ query }) => {
    await query('SET @@system_versioning_alter_history = 1', []);
    await query(`
        ALTER TABLE ObjectBase
        MODIFY COLUMN \`Type\` enum('user','person','guest','extern','group','ggroup','family','historic','list','dlist','email','entry','visible','changeable','include','exclude','intersect','job','function','achievement','achievementT','action','actionT','event','eventT','eventFunctionT','eventJob','eventJobT','location','locationT','locationC','gentry','account','fiscalyear','costcenter','document','accountingVisible','accountingChangeable','project','repositoryShare','directoryShare') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
    `, []);
    await query('SET @@system_versioning_alter_history = 0', []);
};