Download the PHP package eliasfarah/db-struct-sync without Composer
On this page you can find all versions of the php package eliasfarah/db-struct-sync. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download eliasfarah/db-struct-sync
More information about eliasfarah/db-struct-sync
Files in eliasfarah/db-struct-sync
Package db-struct-sync
Short Description mysql structure syncronisation tool
License
Homepage https://github.com/gerkirill/dbStructSync
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package db-struct-sync
Original Owner of this project is https://github.com/gerkirill/dbStructSync
The class provides ability to compare 2 database structure dumps and compile a set of sql statements to update one database to make it structure identical to another.
The input for the script could be taken from the phpMyAdmin structure dump, or provided by some custom code that uses 'SHOW CREATE TABLE' query to get database structure table by table. The output is either array of sql statements suitable for executions right from php or a string where the statements are placed each at new line and delimited with ';' - suitable for execution from phpMyAdmin SQL page. The resulting sql may contain queries that aim to: Create missing table (CREATE TABLE query) Delete table which should not longer exist (DROP TABLE query) Update, drop or add table field or index definition (ALTER TABLE query)
Some features:
- AUTO_INCREMENT value is ommited during the comparison and in resulting CREATE TABLE sql
- fields with definitions like "(var)char (255) NOT NULL default ''" and "(var)char (255) NOT NULL" are treated as equal, the same for (big|tiny)int NOT NULL default 0;
- IF NOT EXISTS is automatically added to the resulting sql CREATE TABLE statement
- fields updating queries always come before key modification ones for each table Not implemented:
-
The class even does not try to insert or re-order fields in the same order as in the original table. Does order matter? IMPORTANT!!! Class will not handle a case when the field was renamed. It will generate 2 queries - one to drop the column with the old name and one to create column with the new name, so if there is a data in the dropped column, it will be lost. Usage example: $updater = new dbStructUpdater(); $res = $updater->getUpdates($struct1, $struct2);
$res == array ( [0]=>"ALTER TABLE
bMODIFYnamevarchar(255) NOT NULL", ... )
