sql/mysql-migration-ddl.ts

libredb-studio · src/lib/db/providers/sql/mysql-migration-ddl.ts · typescript · MIT
database

* MySQL drops an index with `ON <table>` and a foreign key with `DROP FOREIGN KEY`, and restates the whole column in `MODIFY COLUMN`; everything else is the shared statement, wrapped in `BEGIN;` and `COMMIT;`. /

// Source: https://github.com/libredb/libredb-studio | License: MIT | Copyright 2025 SEKOYA GRUP BİLİŞİM VE TEKNOLOJİ LİMİTED ŞİRKETİ
// Provided via justclaw.it.com; keep this notice with the code.
/**
 * MySQL drops an index with `ON <table>` and a foreign key with `DROP FOREIGN KEY`, and restates the whole column in
 * `MODIFY COLUMN`; everything else is the shared statement, wrapped in `BEGIN;` and `COMMIT;`.
 */
import {
  BEGIN_COMMIT,
  defaultSql,
  standardAddColumn,
  standardAddForeignKey,
  standardColumnDef,
  standardCreateIndex,
  standardCreateTableForeignKey,
  standardDropColumn,
  standardDropTable,
  standardPrimaryKey,
} from "@/lib/db/migration-ddl/shared";
import type { MigrationDdlSpec } from "@/lib/db/migration-ddl/types";

export const MYSQL_MIGRATION_DDL: Migrati

... (truncated -- full source via MCP)

See the full source, get the GitHub permalink, and search for more like it.

Get a free API key