rafaelurben
/ generator.sql
Last active
December 10, 2025 01:27
MariaDB char(32) to native uuid migration generator
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- ============================================================================ | |
| -- UUID migration SQL GENERATOR for MariaDB 10.11.14 | |
| -- Produces statements to migrate non-native UUID-like CHAR(32) columns to native UUID. | |
| -- Usage: run this script in the target database. It will OUTPUT SQL statements | |
| -- which you should REVIEW and run in the order indicated below. | |
| -- | |
| -- Created by rafaelurben and ChatGPT | |
| -- ============================================================================ | |
| -- 0) Parameters: change if you need a different database than DATABASE() |