PHP Classes
elePHPant
Icontem

MySQL Structure Magic: Synchronize MySQL database schemata

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (6 years ago) RSS 2.0 feedStarStarStarStar 69%Total: 1,441 All time: 2,558 This week: 1,093Up
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: 29
All time rank: 17584 in Croatia Croatia
Week rank: 1504 Up2 in Croatia Croatia Up

Details provided by the author  
// * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * //
// * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * //
//             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,441All time:2,558
 This week:0This week:1,093Up
 User Ratings  
 
 All time
Utility:100%StarStarStarStarStarStar
Consistency:91%StarStarStarStarStar
Documentation:50%StarStarStar
Examples:58%StarStarStar
Tests:-
Videos:-
Overall:69%StarStarStarStar
Rank:223