PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2008-08-01 (8 years ago) RSS 2.0 feedStarStarStarStar 69%Total: 1,478 All time: 2,560 This week: 1,090Up
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

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,478
This week:0
All time:2,560
This week:1,090Up
 User Ratings  
 
 All time
Utility:100%StarStarStarStarStarStar
Consistency:91%StarStarStarStarStar
Documentation:50%StarStarStar
Examples:58%StarStarStar
Tests:-
Videos:-
Overall:69%StarStarStarStar
Rank:341