PHP Classes

MySQL Structure Magic: Synchronize MySQL database schemata

Recommend this page to a friend!
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 62%Total: 1,512 This week: 2All time: 2,594 This week: 94Up
Version License PHP version Categories
mysqlstructmagic 0.8GNU General Publi...5.0PHP 5, Databases, Systems administration
Description 

Author

This class can be used to synchronize MySQL database schemata.

It can analyze the schema of a MySQL database and export it as a PHP array definition or in a XML format.

The class can also import previously exported schema definitions.

With an initial and final schema definitions the class can compare them and determine the necessary SQL statements to alter the initial schema to make it become the final schema.

Picture of Alen Pokos
Name: Alen Pokos <contact>
Classes: 1 package by
Country: Croatia Croatia
Age: 38
All time rank: 18354 in Croatia Croatia
Week rank: 109 Up1 in Croatia Croatia Up

Details

// * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * // // * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * // // All Rights Reserved, Alen Pokos, http://ghosap.com // // Contact : ghosap@ghosap.com, http://ghosap.com // // Copying, editing, or deleting of any portion of this script is forbbiden. // // Distibution is allowed as it is in complete, with all attributions and comments. // // This software is free for both commercial and private use, donations are welcome. // // This software comes without any warranty. // // For any questions or permisions contact author. // // * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * // // * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * // // * * * * * * * * * * * * * * MySql StructMagic * * * * * * * * * * * * * * * * * * // // MySql StructMagic v0.8, build 01082008 // // If u are interested to contribute to this program or send feedback contact me. // // Contact : Alen Pokos, ghosap@ghosap.com, http://ghosap.com // // * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * // // * * * * * * * * * * * * * R E A D M E * * * * * * * * * * * * * * * * * * * * * * // /* Requirements : - tested to work with MySQL 5 - tested to work on PHP 5 Known bugs : - multi field indexes, shows only the last component - buggy key and index support ToDo list : - better key and index support - some semantic updates - input data validator - support for triggers and procedures - anything else feedback shows it is required ... */

  Files folder image Files  
File Role Description
Plain text file class_MySqlStructMagic.php Class Main class file
Accessible without login Plain text file demo.php Example Demo file, to show usage of class
Accessible without login Plain text file readme.txt Doc. Readme

 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,512
This week:2
All time:2,594
This week:94Up
 User Ratings  
 
 All time
Utility:87%StarStarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:50%StarStarStar
Examples:56%StarStarStar
Tests:-
Videos:-
Overall:62%StarStarStarStar
Rank:913