public WebAPI_Migrator_0()
{
Version = new Version(0, 0, 0);
MigrationName = "WebAPI";
schema = new List<SchemaDefinition>();
AddSchema("webapi_access_log", new ColumnDefinition[3]{
new ColumnDefinition{
Name = "user",
Type = new ColumnTypeDef{
Type = ColumnType.UUID
}
},
new ColumnDefinition{
Name = "method",
Type = new ColumnTypeDef{
Type = ColumnType.Char,
Size = 32
}
},
new ColumnDefinition{
Name = "loggedat",
Type = new ColumnTypeDef{
Type = ColumnType.Double
}
}
}, new IndexDefinition[1]{
new IndexDefinition{
Fields = new string[3]{ "user", "method", "loggedat" },
Type = IndexType.Primary
}
});
AddSchema("webapi_access", new ColumnDefinition[]{
new ColumnDefinition{
Name = "user",
Type = new ColumnTypeDef{
Type = ColumnType.UUID,
defaultValue = UUID.Zero.ToString()
}
},
new ColumnDefinition{
Name = "method",
Type = new ColumnTypeDef{
Type = ColumnType.Char,
Size = 32,
defaultValue = ""
}
},
new ColumnDefinition{
Name = "rate",
Type = new ColumnTypeDef{
Type = ColumnType.Integer,
Size = 11,
unsigned = true,
isNull = true,
defaultValue = null
}
}
}, new IndexDefinition[]{
new IndexDefinition{
Fields = new string[2]{ "user", "method" },
Type = IndexType.Primary
}
});
AddSchema("webapi_access_tokens", new ColumnDefinition[]{
new ColumnDefinition{
Name = "user",
Type = new ColumnTypeDef{
Type = ColumnType.UUID
}
},
new ColumnDefinition{
Name = "accessToken",
Type = new ColumnTypeDef{
Type = ColumnType.UUID
}
}
}, new IndexDefinition[]{
new IndexDefinition{
Fields = new string[1]{ "user" },
Type = IndexType.Primary
}
});
}