Catnap.IntegrationTests.Migrations.CreateSchema_SqlServerCe.CreateSchema_SqlServerCe C# (CSharp) Method

CreateSchema_SqlServerCe Class Documentation Show file Open project: timscott/catnap

CreateSchema_SqlServerCe() public method

public CreateSchema_SqlServerCe ( ) : Catnap.Migration
return	Catnap.Migration

        public CreateSchema_SqlServerCe()
            : base(@"create table Forum (Id int primary key identity(1,1) not null, Name nvarchar(200), TimeOfDayLastUpdated bigint)",
			@"create table Post (Id int primary key identity(1,1) not null, Title nvarchar(200), Body nvarchar(200), DatePosted datetime, PosterId int, ForumId int not null)",
			@"create table Person (Id int primary key identity(1,1) not null, FirstName nvarchar(200), LastName nvarchar(200), Active int, MemberSince int)",
			@"create table ForumGuid (Id uniqueidentifier primary key not null, Name nvarchar(200), TimeOfDayLastUpdated bigint)",
            @"create table PostGuid (Id uniqueidentifier primary key not null, Title nvarchar(200), Body nvarchar(200), DatePosted datetime, PosterId uniqueidentifier, ForumId uniqueidentifier not null)",
            @"create table PersonGuid (Id uniqueidentifier primary key not null, FirstName nvarchar(200), LastName nvarchar(200), Active int, MemberSince int)")
        {
        }

CreateSchema_SqlServerCe