Vehicle stuff

gistfile1.sql

CREATE TABLE VehicleConfig (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	AAIAVehicleConfigID int NOT NULL
)
GO

CREATE TABLE vcdb_VehiclePart (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	BaseVehicleID int NOT NULL FOREIGN KEY REFERENCES BaseVehicle (ID),
	SubmodelID int NOT NULL FOREIGN KEY REFERENCES Submodel (ID),
	PartNumber int NOT NULL
	VehicleConfigID int NULL FOREIGN KEY REFERENCES VehicleConfig (ID)
)
GO

CREATE TABLE VehiclePartDiff (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	VehiclePartID int NOT NULL FOREIGN KEY REFERENCES vcdb_VehiclePart (ID),
	diffID int NOT NULL,
	diffTable varchar(150) NULL,
	diffName varchar(500) NULL,
)