public static void ModifyTableDefinition(TableDefinition tableDefinition)
{
tableDefinition
.AddBigIntField(QueryDirectory.TableName.AsFk(), false, true)
.AddBigIntField(MetaResultTable.SessionIdFieldName, false, true)
.AddNVarCharField(RowHashFieldName, false, true)
.AddBigIntField(RowOrderFieldName, false, false)
.AddDateCreateField() // datetime the record is created
.AddDateUpdatedField() // datetime the record is updated
.SetCompoundPrimaryKey(new List <string>
{
QueryDirectory.TableName.AsFk(),
MetaResultTable.SessionIdFieldName,
RowHashFieldName
});
// _tableDefinition.Indexes.Add(new IndexDefinition(
// _tableDefinition,
// "idx_" + _tableDefinition.Name + "_Query_Session",
// false,
// QueryDirectory.TableName.AsFk(),
// MetaResultTable.SessionIdFieldName
// ));
}
