import { Knex } from 'knex' ; export async function up ( knex ) { await knex . schema . alterTable ( 'directus_fields' , ( table ) => { table . dropForeign ( [ 'collection' ] ) ; } ) ; await knex . schema . alterTable ( 'directus_activity' , ( table ) => { table . dropForeign ( [ 'collection' ] ) ; } ) ; await knex . schema . alterTable ( 'directus_permissions' , ( table ) => { table . dropForeign ( [ 'collection' ] ) ; } ) ; await knex . schema . alterTable ( 'directus_presets' , ( table ) => { table . dropForeign ( [ 'collection' ] ) ; } ) ; await knex . schema . alterTable ( 'directus_relations' , ( table ) => { table . dropForeign ( [ 'one_collection' ] ) ; table . dropForeign ( [ 'many_collection' ] ) ; } ) ; await knex . schema . alterTable ( 'directus_revisions' , ( table ) => { table . dropForeign ( [ 'collection' ] ) ; } ) ; } export async function down ( knex ) { await knex . schema . alterTable ( 'directus_fields' , ( table ) => { table . foreign ( 'collection' ) . references ( 'directus_collections.collection' ) ; } ) ; await knex . schema . alterTable ( 'directus_activity' , ( table ) => { table . foreign ( 'collection' ) . references ( 'directus_collections.collection' ) ; } ) ; await knex . schema . alterTable ( 'directus_permissions' , ( table ) => { table . foreign ( 'collection' ) . references ( 'directus_collections.collection' ) ; } ) ; await knex . schema . alterTable ( 'directus_presets' , ( table ) => { table . foreign ( 'collection' ) . references ( 'directus_collections.collection' ) ; } ) ; await knex . schema . alterTable ( 'directus_relations' , ( table ) => { table . foreign ( 'one_collection' ) . references ( 'directus_collections.collection' ) ; table . foreign ( 'many_collection' ) . references ( 'directus_collections.collection' ) ; } ) ; await knex . schema . alterTable ( 'directus_revisions' , ( table ) => { table . foreign ( 'collection' ) . references ( 'directus_collections.collection' ) ; } ) ; }