public override void Up()
{
logger.Info("Start initial migration");
if (!Schema.AppSchemaExists())
{
Create.AppSchema();
}
if (!Schema.AppSchema().AppTableExists(TableNames.Cache))
{
Create.AppTable(TableNames.Cache)
.WithColumn("Id").AsString(449).NotNullable().PrimaryKey()
.WithColumn("Value").AsMaxVarBinary().NotNullable()
.WithColumn("ExpiresAtTime").AsDateTimeOffset(7).NotNullable()
.WithColumn("SlidingExpirationInSeconds").AsInt64().Nullable()
.WithColumn("AbsoluteExpiration").AsDateTimeOffset(7).Nullable();
}
if (!Schema.AppSchema().AppTableExists(TableNames.Logs))
{
Create.AppTable(TableNames.Logs)
.WithIdentityColumn()
.WithColumn("Severity").AsString()
.WithColumn("Message").AsMaxString()
.WithColumn("Timestamp").AsDateTime().Indexed()
.WithColumn("Logger").AsString()
.WithColumn("ExceptionType").AsString().Nullable()
.WithColumn("ExceptionMessage").AsMaxString().Nullable()
.WithColumn("UserLogin").AsString().Nullable()
.WithColumn("SourceName").AsString();
}
if (!Schema.AppSchema().AppTableExists(TableNames.Users))
{
Create.AppTable(TableNames.Users)
.WithIdentityColumn()
.WithColumn("UserId").AsInt64().Indexed()
.WithColumn("Roles").AsMaxString().WithDefaultValue("")
.WithPeriodColumns()
.WithActiveColumn()
.WithAuditColumns();
}
if (!Schema.AppSchema().AppTableExists(TableNames.UsersSession))
{
Create.AppTable(TableNames.UsersSession)
.WithColumn("SessionKey").AsString(449).NotNullable().PrimaryKey()
.WithColumn("SessionId").AsString().NotNullable()
.WithColumn("Login").AsString().NotNullable()
.WithColumn("UserId").AsInt64().NotNullable().Indexed()
.WithColumn("TimeStamp").AsDateTimeOffset(7).NotNullable().WithDefaultValue(DateTimeOffset.UtcNow);
}
Execute.AppScript("./Scripts/Example.sql");
logger.Info("Initial migration completed");
}