PHPackages                             danielgp/fk-scale-mysql - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. danielgp/fk-scale-mysql

ActiveLibrary

danielgp/fk-scale-mysql
=======================

Scaling up the column type for fields used in foreign keys in MySQL can be a daunting activity, now this will be no more!

1.4.2(9y ago)041MITPHPPHP >=5.5

Since Nov 18Pushed 3mo ago1 watchersCompare

[ Source](https://github.com/danielgp/fk-scale-mysql)[ Packagist](https://packagist.org/packages/danielgp/fk-scale-mysql)[ RSS](/packages/danielgp-fk-scale-mysql/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (3)Versions (32)Used By (0)

fk-scale-mysql
==============

[](#fk-scale-mysql)

Scaling up the column type for fields used in foreign keys in MySQL can be a daunting activity, now this will be no more!

Packagist statistics by poser.pugx.org [![Latest Stable Version](https://camo.githubusercontent.com/42a59eb137108a6a0c61af24996bdc0d6d61e4d14b9a6797ac4184cd0aa768a4/68747470733a2f2f706f7365722e707567782e6f72672f64616e69656c67702f666b2d7363616c652d6d7973716c2f762f737461626c65)](https://packagist.org/packages/danielgp/fk-scale-mysql)[![Total Downloads](https://camo.githubusercontent.com/4b0eea5c2f528796aafa8508330e1024bc5bd6b1bca9c5dcb7175c78f6264dd3/68747470733a2f2f706f7365722e707567782e6f72672f64616e69656c67702f666b2d7363616c652d6d7973716c2f646f776e6c6f616473)](https://packagist.org/packages/danielgp/fk-scale-mysql)[![License](https://camo.githubusercontent.com/1f071b45a9b94e3df44a7f87c605fb8329306d07d20c6fd10673199c656c1aac/68747470733a2f2f706f7365722e707567782e6f72672f64616e69656c67702f666b2d7363616c652d6d7973716c2f6c6963656e7365)](https://packagist.org/packages/danielgp/fk-scale-mysql)[![Monthly Downloads](https://camo.githubusercontent.com/f85ece6e07fa1dafa43f76abe6cc509ab273e19a1e7a23ea010e8e1d26526627/68747470733a2f2f706f7365722e707567782e6f72672f64616e69656c67702f666b2d7363616c652d6d7973716c2f642f6d6f6e74686c79)](https://packagist.org/packages/danielgp/fk-scale-mysql)[![Daily Downloads](https://camo.githubusercontent.com/3c7edd2456b279e8d160fc20dad9131c5d61448b4325b0525a09f9b11820ddac/68747470733a2f2f706f7365722e707567782e6f72672f64616e69656c67702f666b2d7363616c652d6d7973716c2f642f6461696c79)](https://packagist.org/packages/danielgp/fk-scale-mysql)[![FOSSA Status](https://camo.githubusercontent.com/16dba3ec90553e3e3b58823860fcf2614a8ef78982c3bf984d4179e5a2e0b971/68747470733a2f2f6170702e666f7373612e636f6d2f6170692f70726f6a656374732f6769742532426769746875622e636f6d25324664616e69656c6770253246666b2d7363616c652d6d7973716c2e7376673f747970653d736869656c64)](https://app.fossa.com/projects/git%2Bgithub.com%2Fdanielgp%2Ffk-scale-mysql?ref=badge_shield)

Code quality analysis [![SensioLabsInsight](https://camo.githubusercontent.com/d29ca186dcdba0796ddef53ed050faf9ad2d1390d63d7e61afef7f55e46c4512/68747470733a2f2f696e73696768742e73656e73696f6c6162732e636f6d2f70726f6a656374732f63333932646465322d376638312d343133632d396338302d6461343861336134623839632f6269672e706e67)](https://insight.sensiolabs.com/projects/c392dde2-7f81-413c-9c80-da48a3a4b89c)[![Codacy Badge](https://camo.githubusercontent.com/cbdfaf1fe3052b7682737a41b82d268ef58a607a7f05d75bfee0816bf80fe0a6/68747470733a2f2f6170692e636f646163792e636f6d2f70726f6a6563742f62616467652f67726164652f3833653130383766626666393434373962333333666464333262373462636338)](https://www.codacy.com/app/danielpopiniuc/fk-scale-mysql)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/ec3adff747f12694695b7f055f2813d32bc89ece7060c92e07d43c8f291027f3/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f64616e69656c67702f666b2d7363616c652d6d7973716c2f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/danielgp/fk-scale-mysql/?branch=master)[![Build Status](https://camo.githubusercontent.com/237174cb8922d49dbe1a7a301a15af89f0a5f6542990de76f6fd1ccecd0c2408/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f64616e69656c67702f666b2d7363616c652d6d7973716c2f6261646765732f6275696c642e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/danielgp/fk-scale-mysql/build-status/master)

In order to use this package following steps have to be followed:

- Make sure you have installed Composer () as the used libraries are not distributed by default in the package on GitHub;
- Run "composer update" command from the root folder of this package (same place where "composer.json" is placed;
- Either have access to MySQL to add a new user (default one stored in the configuration (GRANT SELECT ON *.* TO "web\_fk\_scale"@"127.0.0.1" IDENTIFIED BY PASSWORD "\*929090A686FB866B5F4B8A89D53E78FAE36D9FDD"; FLUSH PRIVILEGES;) or amend the configuration file (ConfigurationMySQL.php) to match a user that has at least SELECT access to target database and all its dependences (if not all dependencies are known, just allow the user to have read-only access to everything);
- Should you choose to give it a try on an already tested database, you can download "world" database from MySQL official site:

Final remark: This packages only analyze (not a single modification is performed) and only provides sequence of query to make necessary scaling (up or down) of Foreign Keys in MySQL databases starting from a combination of a Database/Table/Column!

()

License
-------

[](#license)

[![FOSSA Status](https://camo.githubusercontent.com/c4acaec2f722e1576c5bda2b4f65fd3955eb666d1d578ae7c6663fe26430848d/68747470733a2f2f6170702e666f7373612e636f6d2f6170692f70726f6a656374732f6769742532426769746875622e636f6d25324664616e69656c6770253246666b2d7363616c652d6d7973716c2e7376673f747970653d6c61726765)](https://app.fossa.com/projects/git%2Bgithub.com%2Fdanielgp%2Ffk-scale-mysql?ref=badge_large)

###  Health Score

37

—

LowBetter than 83% of packages

Maintenance54

Moderate activity, may be stable

Popularity4

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity69

Established project with proven stability

 Bus Factor1

Top contributor holds 98% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~12 days

Recently: every ~79 days

Total

31

Last Release

3455d ago

Major Versions

0.9.2 → 1.0.02015-11-24

### Community

Maintainers

![](https://www.gravatar.com/avatar/a1422c4aeb4f66f40a873b82f072fbf171ba1ef71b914ab724d0e2a1f092cad3?d=identicon)[danielgp](/maintainers/danielgp)

---

Top Contributors

[![danielgp](https://avatars.githubusercontent.com/u/4377685?v=4)](https://github.com/danielgp "danielgp (49 commits)")[![fossabot](https://avatars.githubusercontent.com/u/29791463?v=4)](https://github.com/fossabot "fossabot (1 commits)")

### Embed Badge

![Health badge](/badges/danielgp-fk-scale-mysql/health.svg)

```
[![Health](https://phpackages.com/badges/danielgp-fk-scale-mysql/health.svg)](https://phpackages.com/packages/danielgp-fk-scale-mysql)
```

###  Alternatives

[symfony/security-bundle

Provides a tight integration of the Security component into the Symfony full-stack framework

2.5k172.9M1.8k](/packages/symfony-security-bundle)[statamic/cms

The Statamic CMS Core Package

4.8k3.2M720](/packages/statamic-cms)[laravel/reverb

Laravel Reverb provides a real-time WebSocket communication backend for Laravel applications.

1.5k9.4M48](/packages/laravel-reverb)[elgg/elgg

Elgg is an award-winning social networking engine, delivering the building blocks that enable businesses, schools, universities and associations to create their own fully-featured social networks and applications.

1.7k15.7k4](/packages/elgg-elgg)[api-platform/http-cache

API Platform HttpCache component

223.2M7](/packages/api-platform-http-cache)[mapado/rest-client-sdk

Rest Client SDK for hydra API

1125.9k2](/packages/mapado-rest-client-sdk)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)