Jeden Skill in Manus ausführen
mit einem Klick

Jeden Skill in Manus mit einem Klick ausführen

Loslegen

mysql-lamp-legacy

Sterne2

Forks1

Aktualisiert23. Januar 2026 um 19:25

Managing legacy MySQL/MariaDB schemas in LAMP stacks.

Installation

Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.

In Manus ausführen

Quelle

sraloff

sraloff/gravityboots

GitHub-Repository öffnen Creator-Repositorys ansehen

Download

In Manus ausführen

Verwandte BerufeSOC

Basierend auf der SOC-Berufsklassifikation

DatenbankarchitektenInformatik- und Mathematikberufe·SOC 15-1243

SKILL.md

readonly

name	mysql-lamp-legacy
description	Managing legacy MySQL/MariaDB schemas in LAMP stacks.

MySQL / MariaDB (LAMP Legacy)

When to use this skill

Working on legacy LAMP (Linux, Apache, MySQL, PHP) projects.
Maintaining WordPress, Drupal, or older custom PHP apps.
Dealing with specific MySQL quirks (backticks, engine types).

1. Schema Management

Engine: Ensure InnoDB is used (not MyISAM).
Encoding: Convert/Ensure utf8mb4 (collation utf8mb4_unicode_ci or utf8mb4_0900_ai_ci).
Dates: Beware of 0000-00-00 dates; enable strict mode if possible (NO_ZERO_DATE).

2. Identifiers

Quoting: Use backticks ` ` for identifiers (tables, columns) if they conflict with keywords.
Case Sensitivity: Remember table names are case-sensitive on Linux but not Windows/macOS. Lowercase conventions prefered.

3. Optimization

Indexes: Max key length limits might apply on older versions with utf8mb4.
Query Cache: Deprecated/Removed in newer MySQL; do not rely on it.
Foreign Keys: Often missing in legacy apps; add them if InnoDB allows, otherwise enforce in app logic (but add a comment // Logic FK).

Mehr aus diesem Repository

gleiches Repository

project-initialization-bootstrap

sraloff/gravityboots

Bootstraps a new project with standard folder structure, git init, basic files, planning doc skeletons, and initial memory.json. Triggers on new project creation keywords. CRITICAL for first-time setup.

2026-01-232

apache-lamp-config

sraloff/gravityboots

Configuration for Virtual Hosts, .htaccess, and PHP-FPM in LAMP stacks.

2026-01-232

api-design-patterns

sraloff/gravityboots

Principles for REST, GraphQL, versioning, and API authentication.

2026-01-232

assets-icons-fonts

sraloff/gravityboots

Optimization and usage of SVGs, fonts, and static assets.

2026-01-232

bootstrap-legacy

sraloff/gravityboots

Patterns for maintaining or migrating Bootstrap 3/4/5 projects.

2026-01-232

caddy-modern-config

sraloff/gravityboots

Caddyfile configuration, auto-HTTPS, and FastCGI.

2026-01-232

name	mysql-lamp-legacy
description	Managing legacy MySQL/MariaDB schemas in LAMP stacks.

MySQL / MariaDB (LAMP Legacy)

When to use this skill

Working on legacy LAMP (Linux, Apache, MySQL, PHP) projects.
Maintaining WordPress, Drupal, or older custom PHP apps.
Dealing with specific MySQL quirks (backticks, engine types).

1. Schema Management

Engine: Ensure InnoDB is used (not MyISAM).
Encoding: Convert/Ensure utf8mb4 (collation utf8mb4_unicode_ci or utf8mb4_0900_ai_ci).
Dates: Beware of 0000-00-00 dates; enable strict mode if possible (NO_ZERO_DATE).

2. Identifiers

Quoting: Use backticks ` ` for identifiers (tables, columns) if they conflict with keywords.
Case Sensitivity: Remember table names are case-sensitive on Linux but not Windows/macOS. Lowercase conventions prefered.

3. Optimization

Indexes: Max key length limits might apply on older versions with utf8mb4.
Query Cache: Deprecated/Removed in newer MySQL; do not rely on it.
Foreign Keys: Often missing in legacy apps; add them if InnoDB allows, otherwise enforce in app logic (but add a comment // Logic FK).