addForeignKey function
Add a foreign key to a table.
Implementation
Future<void> addForeignKey({
required String databaseName,
required String foreignKeyName,
required String table,
required String column,
required String foreignTable,
required String foreignColumn,
}) async {
/// restore the member constrant.
await Transaction.current.db.query('''
ALTER TABLE `$databaseName`.`$table`
ADD CONSTRAINT `$foreignKeyName`
FOREIGN KEY (`$column`)
REFERENCES `$databaseName`.`$foreignTable` (`$foreignColumn`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
''');
}