Skip to content

Instantly share code, notes, and snippets.

@mneedham

mneedham/gist:383323

Created April 29, 2010 08:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mneedham/383323 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mneedham/383323 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CREATE TABLE dbo.changelog (
change_number INTEGER NOT NULL,
delta_set VARCHAR(10) NOT NULL,
start_dt DATETIME NOT NULL,
complete_dt DATETIME NULL,
applied_by VARCHAR(100) NOT NULL,
description VARCHAR(500) NOT NULL
)
GO
ALTER TABLE dbo.changelog ADD CONSTRAINT Pkchangelog PRIMARY KEY (change_number, delta_set)
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment