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 // )); }