My favorites | Sign in
Project Home Downloads Wiki Issues Source
Search
for
FaZend_Deployer  
Automatic Db schema deployer
Phase-Design
Updated Nov 23, 2009 by yegor...@gmail.com

Usage sample

You create a file application/deploy/database/1 user.sql:

--
-- This is a simple table for the list of users
--
CREATE TABLE IF NOT EXISTS `user` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT "Unique ID of the user",
  `email` VARBINARY(200) NOT NULL COMMENT "Unique user email",
  `password` VARBINARY(50) NOT NULL COMMENT "User password",
  PRIMARY KEY USING BTREE (`id`),
  UNIQUE (`email`)
  ) AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ENGINE=InnoDB;

That's it. The database will be deployed automatically during the next continuous integration lifecycle.

Files shall be named as <number> <space> <table name> ".sql", where <number> is an ordering number, to let Deployer know which table shall be created first, which second, and so forth.


Sign in to add a comment
Powered by Google Project Hosting