Login   Register  
PHP Classes
elePHPant
Icontem

MySQL Versioning: Update MySQL databases using SQL change set files

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 (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2009-03-29 (5 years ago) RSS 2.0 feedNot enough user ratingsTotal: 322 All time: 6,421 This week: 1,456Up
Version License PHP version Categories  
mysql-versioning 0.9GNU General Public Lice...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 is available for providing paid consulting. Contact solomongaby .
Classes: 10 packages by
Country: Romania Romania
Age: 30
All time rank: 1664 in Romania Romania
Week rank: 222 Down5 in Romania Romania Down
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:322All time:6,421
 This week:0This week:1,456Up