PHP Classes
elePHPant
Icontem

MySQL Versioning: Update MySQL databases using SQL change set files

Recommend this page to a friend!
  Info   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2009-03-29 (7 years ago) RSS 2.0 feedNot enough user ratingsTotal: 329 All time: 6,775 This week: 894Up
Version License PHP version Categories
mysql-versioning 0.9GNU General Publi...5.0Databases, Systems administration
Description Author

This class can be used to update MySQL databases using SQL change set files.

It can scan directories with files that contain SQL statements that define change sets for creating tables, altering tables, or changing the table data.

The class can execute the SQL statements to update the database schema and alter the requested table data.

Every time it is run the class only execute the newly added change set files.

Picture of solomongaby
Name: solomongaby <contact>
Classes: 10 packages by
Country: Romania Romania
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Files folder image__DB (2 files, 4 directories)
Accessible without login Plain text file config.php Conf. applications config file

  Files folder image Files  /  __DB  
File Role Description
Files folder imagechangesets (1 directory)
Files folder imagedata (1 file)
Files folder imageenviroment (2 files)
Files folder imagetables (1 file)
  Accessible without login Plain text file index.php Example applications run file
  Accessible without login Plain text file init.php Conf. config file for updater

  Files folder image Files  /  __DB  /  changesets  
File Role Description
Files folder image001 (1 file)

  Files folder image Files  /  __DB  /  changesets  /  001  
File Role Description
  Accessible without login Plain text file 01_changeset1.sql Data example of changeset

  Files folder image Files  /  __DB  /  data  
File Role Description
  Accessible without login Plain text file locations.sql Data data file for table locations

  Files folder image Files  /  __DB  /  enviroment  
File Role Description
  Plain text file Mysql.php Class mysql wrapper
  Plain text file MysqlUpdater.php Class main updater class

  Files folder image Files  /  __DB  /  tables  
File Role Description
  Accessible without login Plain text file locations.sql Data initial create for table locations.

Downloadmysql-versioning-2009-03-29.zip 7KB
Downloadmysql-versioning-2009-03-29.tar.gz 6KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
MySQL-class Download .zip .tar.gz run queries using this wrapper class Required
 Version Control Unique User Downloads Download Rankings  
 0%
Total:329
This week:0
All time:6,775
This week:894Up