// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <DevicePinData> table = (TableSnapshot <DevicePinData>)store.Table("DevicePin");
table.CreateForeignKey("PK_DevicePin", store.Table("Circuit"), DevicePinData.PinIdField.Field, ForeignKeyAction.Cascade, false);
table.CreateForeignKey("FK_Circuit_DevicePin", store.Table("Circuit"), DevicePinData.CircuitIdField.Field, ForeignKeyAction.Restrict, false);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <CircuitSymbolData> table = (TableSnapshot <CircuitSymbolData>)store.Table("CircuitSymbol");
table.CreateForeignKey("FK_Circuit_CircuitSymbol", store.Table("Circuit"), CircuitSymbolData.CircuitIdField.Field, ForeignKeyAction.Cascade, false);
table.CreateForeignKey("FK_LogicalCircuit_CircuitSymbol", store.Table("LogicalCircuit"), CircuitSymbolData.LogicalCircuitIdField.Field, ForeignKeyAction.Restrict, false);
}
// Creates table.
public static TableSnapshot <SensorData> CreateTable(StoreSnapshot store)
{
TableSnapshot <SensorData> table = new TableSnapshot <SensorData>(store, "Sensor", SensorData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_Sensor", SensorData.SensorIdField.Field, true);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <CircuitButtonData> CreateTable(StoreSnapshot store)
{
TableSnapshot <CircuitButtonData> table = new TableSnapshot <CircuitButtonData>(store, "CircuitButton", CircuitButtonData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_CircuitButton", CircuitButtonData.CircuitButtonIdField.Field, true);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <ProjectData> CreateTable(StoreSnapshot store)
{
TableSnapshot <ProjectData> table = new TableSnapshot <ProjectData>(store, "Project", ProjectData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_Project", ProjectData.ProjectIdField.Field, true);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <GraphicsArrayData> CreateTable(StoreSnapshot store)
{
TableSnapshot <GraphicsArrayData> table = new TableSnapshot <GraphicsArrayData>(store, "GraphicsArray", GraphicsArrayData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_GraphicsArray", GraphicsArrayData.GraphicsArrayIdField.Field, true);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <CollapsedCategoryData> CreateTable(StoreSnapshot store)
{
TableSnapshot <CollapsedCategoryData> table = new TableSnapshot <CollapsedCategoryData>(store, "CollapsedCategory", CollapsedCategoryData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_CollapsedCategory", CollapsedCategoryData.NameField.Field, true);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <MemoryData> CreateTable(StoreSnapshot store)
{
TableSnapshot <MemoryData> table = new TableSnapshot <MemoryData>(store, "Memory", MemoryData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_Memory", MemoryData.MemoryIdField.Field, true);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <LedMatrixData> CreateTable(StoreSnapshot store)
{
TableSnapshot <LedMatrixData> table = new TableSnapshot <LedMatrixData>(store, "LedMatrix", LedMatrixData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_LedMatrix", LedMatrixData.LedMatrixIdField.Field, true);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <WireData> CreateTable(StoreSnapshot store)
{
TableSnapshot <WireData> table = new TableSnapshot <WireData>(store, "Wire", WireData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_Wire", WireData.WireIdField.Field, true);
table.CreateIndex("IX_LogicalCircuit_Wire", WireData.LogicalCircuitIdField.Field);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <CircuitProbeData> CreateTable(StoreSnapshot store)
{
TableSnapshot <CircuitProbeData> table = new TableSnapshot <CircuitProbeData>(store, "CircuitProbe", CircuitProbeData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_CircuitProbe", CircuitProbeData.CircuitProbeIdField.Field, true);
table.MakeUnique("AK_CircuitProbe_Name", CircuitProbeData.NameField.Field, false);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <LogicalCircuitData> CreateTable(StoreSnapshot store)
{
TableSnapshot <LogicalCircuitData> table = new TableSnapshot <LogicalCircuitData>(store, "LogicalCircuit", LogicalCircuitData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_LogicalCircuit", LogicalCircuitData.LogicalCircuitIdField.Field, true);
table.MakeUnique("AK_LogicalCircuit_Name", LogicalCircuitData.NameField.Field, false);
// Return created table
return(table);
}
// Creates table.
public static TableSnapshot <DevicePinData> CreateTable(StoreSnapshot store)
{
TableSnapshot <DevicePinData> table = new TableSnapshot <DevicePinData>(store, "DevicePin", DevicePinData.fields);
// Create all but foreign keys of the table
table.MakeUnique("PK_DevicePin", DevicePinData.PinIdField.Field, true);
table.MakeUnique("AK_DevicePinName", DevicePinData.CircuitIdField.Field, DevicePinData.NameField.Field);
table.CreateIndex("IX_Circuit_DevicePin", DevicePinData.CircuitIdField.Field);
// Return created table
return(table);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <WireData> table = (TableSnapshot <WireData>)store.Table("Wire");
table.CreateForeignKey("FK_LogicalCircuit_Wire", store.Table("LogicalCircuit"), WireData.LogicalCircuitIdField.Field, ForeignKeyAction.Cascade, false);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <CircuitProbeData> table = (TableSnapshot <CircuitProbeData>)store.Table("CircuitProbe");
table.CreateForeignKey("PK_CircuitProbe", store.Table("Circuit"), CircuitProbeData.CircuitProbeIdField.Field, ForeignKeyAction.Cascade, false);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <MemoryData> table = (TableSnapshot <MemoryData>)store.Table("Memory");
table.CreateForeignKey("PK_Memory", store.Table("Circuit"), MemoryData.MemoryIdField.Field, ForeignKeyAction.Cascade, false);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <ProjectData> table = (TableSnapshot <ProjectData>)store.Table("Project");
table.CreateForeignKey("FK_LogicalCircuit_Project", store.Table("LogicalCircuit"), ProjectData.LogicalCircuitIdField.Field, ForeignKeyAction.Restrict, false);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <GraphicsArrayData> table = (TableSnapshot <GraphicsArrayData>)store.Table("GraphicsArray");
table.CreateForeignKey("PK_GraphicsArray", store.Table("Circuit"), GraphicsArrayData.GraphicsArrayIdField.Field, ForeignKeyAction.Cascade, false);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <LedMatrixData> table = (TableSnapshot <LedMatrixData>)store.Table("LedMatrix");
table.CreateForeignKey("PK_LedMatrix", store.Table("Circuit"), LedMatrixData.LedMatrixIdField.Field, ForeignKeyAction.Cascade, false);
}
// Creates all foreign keys of the table
public static void CreateForeignKeys(StoreSnapshot store)
{
TableSnapshot <SensorData> table = (TableSnapshot <SensorData>)store.Table("Sensor");
table.CreateForeignKey("PK_Sensor", store.Table("Circuit"), SensorData.SensorIdField.Field, ForeignKeyAction.Cascade, false);
}
