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

  Author Author  
Picture of solomongaby
Name: solomongaby is available for providing paid consulting. Contact solomongaby .
Classes: 10 packages by
Country: Romania Romania
Age: 29
All time rank: 1654 in Romania Romania
Week rank: 301 Down6 in Romania Romania Down
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download Download .zip .tar.gz  
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.

  Classes of solomongaby  >  MySQL Versioning  >  Download Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL Versioning
Base name: mysql-versioning
Description: Update MySQL databases using SQL change set files
Version: 0.9
PHP version: 5.0
License: GNU General Public License (GPL)
All time users: 320 users
All time rank: 6399
Week users: 0 users
Week rank: 1774 Equal
 
  Groups   Rate classes User ratings   Dependencies  
  Trackback   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Systems administration System configuration and management View top rated classes


  User ratings  
Not enough user ratings

  Packages needed by this class  
Class DownloadWhy it is needed Dependency
MySQL-class Download .zip .tar.gz run queries using this wrapper class Required

  Pages that reference this package  
MySQL Database versioning strategy
MySQL Database versioning strategy by Gabi Solomon IF you just got into versioning your code then you are probably really happy with your acomplishment...

Latest pages that reference packages Latest pages that reference packages


  Applications that use this package  
No pages of applications that use this class were specified.
Add link image If you know an application of this package, send a message to the author to add a link here.
  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.

Download Download all files: mysql-versioning.tar.gz mysql-versioning.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.