Example of creating a table for application versioning

If you need an example of creating a table for application versioning, maybe this script will help :

CREATE TABLE [dbo].[dnn_Version](
    [VersionId] [int] IDENTITY(1,1) NOT NULL,
    [Major] [int] NOT NULL,
    [Minor] [int] NOT NULL,
    [Build] [int] NOT NULL,
    [CreatedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_dnn_Version] PRIMARY KEY CLUSTERED
(
    [VersionId] ASC
) ON [PRIMARY],
 CONSTRAINT [IX_dnn_Version] UNIQUE NONCLUSTERED
(
    [Major] ASC,
    [Minor] ASC,
    [Build] ASC
) ON [PRIMARY]
) ON [PRIMARY]

Note : This script taken from dotnetnuke database