====== LiquiBase Manual ======


===== Introduction =====
  * [[Overview]]


===== Building Change-Logs =====
  * <[[DatabaseChangeLog]]>
  * <[[ChangeSet]]>
  * <[[Include]]>
  * <[[Preconditions]]>
  * [[Contexts]]
  * [[ChangeLog Parameters]]
  * [[Hibernate|Hibernate Integration]]


===== LiquiBase Functionality =====
  * [[Update]]
  * [[Rollback]]
  * [[Diff]]
  * [[generating_changelogs|Generate Changelog]]
  * [[DBDoc]]
  * [[SQL Output]]

===== Running LiquiBase =====
  * [[Ant]]
  * [[Maven]]
  * [[Spring]]
  * [[Grails]]
  * [[Servlet Listener]]
  * [[Command Line]]

===== Available Database Refactorings =====
==== Structural Refactorings ====
  * [[Add Column]]
  * [[Rename Column]]
  * [[Modify Column]]
  * [[Drop Column]]
  * [[Alter Sequence]]
  * [[Create Table]]
  * [[Rename Table]]
  * [[Drop Table]]
  * [[Create View]]
  * [[Rename View]]
  * [[Drop View]]
  * [[Merge Columns]]
  * [[Create Stored Procedure]]
==== Data Quality Refactorings ====
  * [[Add Lookup Table]]
  * [[Add Not-Null Constraint]]
  * [[Remove Not-Null Constraint]]
  * [[Add Unique Constraint]]
  * [[Drop Unique Constraint]]
  * [[Create Sequence]]
  * [[Drop Sequence]]
  * [[Add Auto-Increment]]
  * [[Add Default Value]]
  * [[Drop Default Value]]
==== Referential Integrity Refactorings ====
  * [[Add Foreign Key Constraint]]
  * [[Drop Foreign Key Constraint]]
  * [[Add Primary Key Constraint]]
  * [[Drop Primary Key Constraint]]


==== Non-Refactoring Transformations ====
  * [[Insert Data]]
  * [[Load Data]]
  * [[Update Data]]
  * [[Delete Data]]
  * [[Tag Database]]

==== Architectural Refactorings ====
  * [[Create Index]]
  * [[Drop Index]]
==== Custom Refactorings ====
  * [[Custom SQL]]
  * [[Custom SQL File]]
  * [[Custom Refactoring Class]]
  * [[Execute Shell Command]]
===== Sample Change Logs =====
  * [[http://www.liquibase.org/samples/changelogs/mysql.changelog.xml|MySQL]]
  * [[http://www.liquibase.org/samples/changelogs/pgsql.changelog.xml|PostgreSQL]]
  * [[http://www.liquibase.org/samples/changelogs/oracle.changelog.xml|Oracle]]
  * [[http://www.liquibase.org/samples/changelogs/mssql.changelog.xml|MS SQL]]
  * [[http://www.liquibase.org/samples/changelogs/db2.changelog.xml|DB2]]
  * [[http://www.liquibase.org/samples/changelogs/derby.changelog.xml|Derby]]
  * [[http://www.liquibase.org/samples/changelogs/hsql.changelog.xml|HSQL]]
===== LiquiBase Development =====
  * [[Development Overview]]
  * [[Architecture]]
  * [[http://www.liquibase.org/api/index.html|API (Javadoc)]]
  * [[http://www.liquibase.org/doxygen/html/index.html|API (Doxygen)]]