liferay-database-utils
CommunitySafe Liferay DB migrations and upgrades
Software Engineering#database#migration#upgrade#schema-version#liferay#upgradeprocess#upgrade-step-registrator
AuthorJoaoPedroAmaral
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This guide helps developers manage and automate database schema upgrades for Liferay modules, avoiding broken deployments, data loss, and version mismatches during module or portal upgrades.
Core Features & Use Cases
- Safe Schema Modifications: Demonstrates using helpers like hasColumn, hasTable, and alter to add, rename, or change columns only when needed.
- Versioned Upgrade Management: Shows how to register ordered upgrade steps with UpgradeStepRegistrator to migrate between semantic versions.
- SQL Templates & Major Upgrades: Explains running update.sql templates and using the portal db upgrade client for large Liferay version migrations.
- Use Case: Add a new status column to a Service Builder table, migrate legacy values, and ensure Liferay-Require-SchemaVersion aligns with the registrator.
Quick Start
Create an UpgradeProcess that safely adds or alters columns and register it in an UpgradeStepRegistrator to migrate from 1.0.0 to 1.1.0.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: liferay-database-utils Download link: https://github.com/JoaoPedroAmaral/backBarbearia/archive/main.zip#liferay-database-utils Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.