Skip to content

Instantly share code, notes, and snippets.

@mhayes

mhayes/migration.cfm

Created July 16, 2010 17:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mhayes/478650 to your computer and use it in GitHub Desktop.
Save mhayes/478650 to your computer and use it in GitHub Desktop.
Download ZIP
ColdFusion migrations idea
Raw
migration.cfm
<!---
Database Migration Script:
Instructions here
--->
<cfsavecontent variable="up">
<!--- The contents in this section will be used to apply your update --->
CREATE VIEW [ats].[VW_R_T1]
AS
SELECT TOP 3 * FROM ats.vw_r
</cfsavecontent>
<cfsavecontent variable="down">
<!--- The contents in this section will be used to undo your update --->
DROP VIEW ats.vw_r_t1
</cfsavecontent>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment