addForeignKey function

Future<void> addForeignKey({
  1. required String databaseName,
  2. required String foreignKeyName,
  3. required String table,
  4. required String column,
  5. required String foreignTable,
  6. required String foreignColumn,
})

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;

''');
}