CREATE TABLE Ifc2DCompositeCurve (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE Ifc2DCompositeCurve_Segments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE Ifc2DCompositeCurve_Segments ADD CONSTRAINT
	PK_Ifc2DCompositeCurve_Segments FOREIGN KEY (pid)
	REFERENCES Ifc2DCompositeCurve (oid);

ALTER TABLE Ifc2DCompositeCurve ADD COLUMN [SelfIntersect]  BYTE;										
				
CREATE TABLE IfcActionTimeControl (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcActionTimeControl ADD COLUMN [ConstraintType]  MEMO;										
				
ALTER TABLE IfcActionTimeControl ADD COLUMN [ContraintTime]  TEXT(50);
				
CREATE TABLE IfcActor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcActor ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcActor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcActor ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcActor ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcActor ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcActor ADD COLUMN [TheActor]  TEXT(50);
				
CREATE TABLE IfcActorRole (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcActorRole ADD COLUMN [Role] TEXT(50);
				
ALTER TABLE IfcActorRole ADD COLUMN [UserDefinedRole]  MEMO;										
				
ALTER TABLE IfcActorRole ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcActuator (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcActuator ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcActuator ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcActuator ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcActuator ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcActuator ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcActuator ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcActuator ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcActuator ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcActuator ADD COLUMN [ControlElementId]  MEMO;										
				
ALTER TABLE IfcActuator ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcActuator ADD COLUMN [FailPosition] TEXT(50);
				
CREATE TABLE IfcAirFilter (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAirFilter ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcAirFilter ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcAirFilter ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcAirFilter ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcAirFilter ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcAirFilter ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcAirFilter ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcAirFilter ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcAirFilter ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcAirFilter ADD COLUMN [DirtyPressureDrop]  DOUBLE;										
				
ALTER TABLE IfcAirFilter ADD COLUMN [CleanPressureDrop]  DOUBLE;										
				
ALTER TABLE IfcAirFilter ADD COLUMN [Efficiency]  DOUBLE;										
				
CREATE TABLE IfcAirTerminal (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAirTerminal ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [AirFlowType] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [Throw]  DOUBLE;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [AirDiffusionPerformanceIndex]  DOUBLE;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [FinishType] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [FinishColor]  MEMO;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [MountingType] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [FaceType] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [CoreType] TEXT(50);
				
ALTER TABLE IfcAirTerminal ADD COLUMN [CoreSetVertical]  DOUBLE;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [CoreSetHorizontal]  DOUBLE;										
				
ALTER TABLE IfcAirTerminal ADD COLUMN [IntegralControl]  BIT;										
				
CREATE TABLE IfcAirTerminalBox (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAirTerminalBox ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [TerminalBoxType] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [SoundLevel] TEXT(50);
				
CREATE TABLE IfcApplication (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcApplication ADD COLUMN [ApplicationDeveloper] TEXT(50);
				
ALTER TABLE IfcApplication ADD COLUMN [Version]  MEMO;										
				
ALTER TABLE IfcApplication ADD COLUMN [ApplicationFullName]  MEMO;										
				
ALTER TABLE IfcApplication ADD COLUMN [ApplicationIdentifier]  MEMO;										
				
CREATE TABLE IfcApproval (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcApproval ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcApproval ADD COLUMN [AuthorizingAgent]  TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [RequestFrom]  TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [RequestTo]  TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [RequestingDate]  TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [RequestedDate]  TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [ApprovalDate]  TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [ApprovalStatus] TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [ApprovalConstraint]  MEMO;										
				
CREATE TABLE IfcApprovalUsage (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcApprovalUsage ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcApprovalUsage ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcApprovalUsage ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcApprovalUsage ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcApprovalUsage ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcApprovalUsage ADD COLUMN [Approval] TEXT(50);
				
CREATE TABLE IfcArbitraryClosedProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcArbitraryClosedProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcArbitraryClosedProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcArbitraryClosedProfileDef ADD COLUMN [OuterCurve] TEXT(50);
				
CREATE TABLE IfcArbitraryOpenProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcArbitraryOpenProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcArbitraryOpenProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcArbitraryOpenProfileDef ADD COLUMN [Curve] TEXT(50);
				
CREATE TABLE IfcArbitraryProfileDefWithVoids (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcArbitraryProfileDefWithVoids ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcArbitraryProfileDefWithVoids ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcArbitraryProfileDefWithVoids ADD COLUMN [OuterCurve] TEXT(50);
					
CREATE TABLE IfcArbitraryProfileDefWithVoids_InnerCurves (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcArbitraryProfileDefWithVoids_InnerCurves ADD CONSTRAINT
	PK_IfcArbitraryProfileDefWithVoids_InnerCurves FOREIGN KEY (pid)
	REFERENCES IfcArbitraryProfileDefWithVoids (oid);

CREATE TABLE IfcAssessory (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAssessory ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcAssessory ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcAssessory ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcAssessory ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcAssessory ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcAssessory ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcAssessory ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcAssessory ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcAssessory ADD COLUMN [MountingType]  MEMO;										
				
CREATE TABLE IfcAsset (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAsset ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcAsset ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcAsset ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcAsset ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcAsset ADD COLUMN [AssetLocation] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [AssetIdentifier]  MEMO;										
				
CREATE TABLE IfcAsset_AssetRisks (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcAsset_AssetRisks ADD CONSTRAINT
	PK_IfcAsset_AssetRisks FOREIGN KEY (pid)
	REFERENCES IfcAsset (oid);

ALTER TABLE IfcAsset ADD COLUMN [OriginalValue] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [CurrentValue] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [TotalReplacementCost] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [Owner]  TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [User]  TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [LeasedFrom]  TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [LeasedTo]  TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [ResponsiblePerson] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [IncorporationDate] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [CommissioningDate] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [WarrantyDuration]  DOUBLE;										
				
ALTER TABLE IfcAsset ADD COLUMN [ExpectedLife]  DOUBLE;										
				
ALTER TABLE IfcAsset ADD COLUMN [OperatingFunction] TEXT(50);
				
ALTER TABLE IfcAsset ADD COLUMN [DepreciatedValue] TEXT(50);
				
CREATE TABLE IfcAxis1Placement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAxis1Placement ADD COLUMN [Location] TEXT(50);
				
ALTER TABLE IfcAxis1Placement ADD COLUMN [Axis] TEXT(50);
				
CREATE TABLE IfcAxis2Placement2D (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAxis2Placement2D ADD COLUMN [Location] TEXT(50);
				
ALTER TABLE IfcAxis2Placement2D ADD COLUMN [RefDirection] TEXT(50);
				
CREATE TABLE IfcAxis2Placement3D (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAxis2Placement3D ADD COLUMN [Location] TEXT(50);
				
ALTER TABLE IfcAxis2Placement3D ADD COLUMN [Axis] TEXT(50);
				
ALTER TABLE IfcAxis2Placement3D ADD COLUMN [RefDirection] TEXT(50);
				
CREATE TABLE IfcBeam (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBeam ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcBeam ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBeam ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcBeam ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBeam ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcBeam ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcBeam ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcBeam ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcBoiler (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBoiler ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcBoiler ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBoiler ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcBoiler ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBoiler ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcBoiler ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcBoiler ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcBoiler ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcBoiler ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcBoiler ADD COLUMN [HeatTransferRate]  DOUBLE;										
				
ALTER TABLE IfcBoiler ADD COLUMN [ThermalEfficiency]  DOUBLE;										
				
ALTER TABLE IfcBoiler ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcBoiler ADD COLUMN [BoilerType] TEXT(50);
				
ALTER TABLE IfcBoiler ADD COLUMN [HeatOutput]  DOUBLE;										
				
ALTER TABLE IfcBoiler ADD COLUMN [PressureRating]  DOUBLE;										
				
ALTER TABLE IfcBoiler ADD COLUMN [EnergyInputRate]  DOUBLE;										
				
CREATE TABLE IfcBooleanClippingResult (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBooleanClippingResult ADD COLUMN [Operator] TEXT(50);
				
ALTER TABLE IfcBooleanClippingResult ADD COLUMN [FirstOperand]  TEXT(50);
				
ALTER TABLE IfcBooleanClippingResult ADD COLUMN [SecondOperand]  TEXT(50);
				
CREATE TABLE IfcBooleanResult (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBooleanResult ADD COLUMN [Operator] TEXT(50);
				
ALTER TABLE IfcBooleanResult ADD COLUMN [FirstOperand]  TEXT(50);
				
ALTER TABLE IfcBooleanResult ADD COLUMN [SecondOperand]  TEXT(50);
				
CREATE TABLE IfcBoundedSurface (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcBoundingBox (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBoundingBox ADD COLUMN [Corner] TEXT(50);
				
ALTER TABLE IfcBoundingBox ADD COLUMN [XDim]  DOUBLE;										
				
ALTER TABLE IfcBoundingBox ADD COLUMN [YDim]  DOUBLE;										
				
ALTER TABLE IfcBoundingBox ADD COLUMN [ZDim]  DOUBLE;										
				
CREATE TABLE IfcBoxedHalfSpace (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBoxedHalfSpace ADD COLUMN [BaseSurface] TEXT(50);
				
ALTER TABLE IfcBoxedHalfSpace ADD COLUMN [AgreementFlag]  BIT;										
				
ALTER TABLE IfcBoxedHalfSpace ADD COLUMN [Enclosure] TEXT(50);
				
CREATE TABLE IfcBudget (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBudget ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [Title]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [SubmittedBy]  TEXT(50);
					
CREATE TABLE IfcBudget_ApprovedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBudget_ApprovedBy ADD CONSTRAINT
	PK_IfcBudget_ApprovedBy FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid);

ALTER TABLE IfcBudget ADD COLUMN [PreparedBy] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [SubmittedOn] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [TotalCost] TEXT(50);
					
CREATE TABLE IfcBudget_CostElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBudget_CostElements ADD CONSTRAINT
	PK_IfcBudget_CostElements FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid);

ALTER TABLE IfcBudget ADD COLUMN [Status]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [IntendedUse]  MEMO;										
				
CREATE TABLE IfcBudget_Comments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcBudget_Comments ADD CONSTRAINT
	PK_IfcBudget_Comments FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid);
	
CREATE TABLE IfcBudget_TargetUsers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBudget_TargetUsers ADD CONSTRAINT
	PK_IfcBudget_TargetUsers FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid);

ALTER TABLE IfcBudget ADD COLUMN [ValidFromDate] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [ValidToDate] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [UpdateDate] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [ScheduleNumber]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [BudgetSource]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [Balance] TEXT(50);
				
CREATE TABLE IfcBuilding (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuilding ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuilding ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcBuilding ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcBuilding ADD COLUMN [LongName]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [CompositionType] TEXT(50);
				
ALTER TABLE IfcBuilding ADD COLUMN [ElevationOfRefHeight]  DOUBLE;										
				
ALTER TABLE IfcBuilding ADD COLUMN [ElevationOfTerrain]  DOUBLE;										
				
ALTER TABLE IfcBuilding ADD COLUMN [BuildingAddress] TEXT(50);
				
CREATE TABLE IfcBuildingElementProxy (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcBuildingElementProxy ADD COLUMN [CompositionType] TEXT(50);
				
CREATE TABLE IfcBuildingStorey (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuildingStorey ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [LongName]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [CompositionType] TEXT(50);
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [Elevation]  DOUBLE;										
				
CREATE TABLE IfcBuiltIn (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuiltIn ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcBuiltIn ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuiltIn ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcBuiltIn ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBuiltIn ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcBuiltIn ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcBuiltIn ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcBuiltIn ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcBuiltIn ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcCalendarDate (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCalendarDate ADD COLUMN [DayComponent]  LONG;										
				
ALTER TABLE IfcCalendarDate ADD COLUMN [MonthComponent]  LONG;										
				
ALTER TABLE IfcCalendarDate ADD COLUMN [YearComponent]  LONG;										
				
CREATE TABLE IfcCartesianPoint (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcCartesianPoint_Coordinates (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcCartesianPoint_Coordinates ADD CONSTRAINT
	PK_IfcCartesianPoint_Coordinates FOREIGN KEY (pid)
	REFERENCES IfcCartesianPoint (oid);

CREATE TABLE IfcCartesianTransformationOperator2D (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCartesianTransformationOperator2D ADD COLUMN [Axis1] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator2D ADD COLUMN [Axis2] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator2D ADD COLUMN [LocalOrigin] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator2D ADD COLUMN [Scale]  DOUBLE;										
				
CREATE TABLE IfcCartesianTransformationOperator2DnonUniform (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD COLUMN [Axis1] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD COLUMN [Axis2] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD COLUMN [LocalOrigin] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD COLUMN [Scale]  DOUBLE;										
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD COLUMN [Scale2]  DOUBLE;										
				
CREATE TABLE IfcCartesianTransformationOperator3D (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCartesianTransformationOperator3D ADD COLUMN [Axis1] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD COLUMN [Axis2] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD COLUMN [LocalOrigin] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD COLUMN [Scale]  DOUBLE;										
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD COLUMN [Axis3] TEXT(50);
				
CREATE TABLE IfcCartesianTransformationOperator3DnonUniform (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD COLUMN [Axis1] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD COLUMN [Axis2] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD COLUMN [LocalOrigin] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD COLUMN [Scale]  DOUBLE;										
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD COLUMN [Axis3] TEXT(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD COLUMN [Scale2]  DOUBLE;										
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD COLUMN [Scale3]  DOUBLE;										
				
CREATE TABLE IfcChangeOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcChangeOrder ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [OrderNumber]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [IssuingDate] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [IssuedBy]  TEXT(50);
					
CREATE TABLE IfcChangeOrder_IssuedTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcChangeOrder_IssuedTo ADD CONSTRAINT
	PK_IfcChangeOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid);
	
CREATE TABLE IfcChangeOrder_AdditionalContacts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcChangeOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcChangeOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid);

CREATE TABLE IfcChangeOrder_Remarks (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcChangeOrder_Remarks ADD CONSTRAINT
	PK_IfcChangeOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid);

ALTER TABLE IfcChangeOrder ADD COLUMN [Signoff] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [BudgetSource] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [ChangeDescription]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [ReasonForChange]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [RequestedStartTime] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [RequestedFinishTime] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [CostEstimate] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [WorkPlan] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [Status] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [ActualStartTime] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [ActualFinishTime] TEXT(50);
				
CREATE TABLE IfcChiller (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcChiller ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcChiller ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcChiller ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcChiller ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcChiller ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcChiller ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcChiller ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcChiller ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcChiller ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcChiller ADD COLUMN [HeatTransferRate]  DOUBLE;										
				
ALTER TABLE IfcChiller ADD COLUMN [ThermalEfficiency]  DOUBLE;										
				
ALTER TABLE IfcChiller ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcChiller ADD COLUMN [ChillerType] TEXT(50);
				
ALTER TABLE IfcChiller ADD COLUMN [NominalCoolingCapacity_]  DOUBLE;										
				
CREATE TABLE IfcCircle (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCircle ADD COLUMN [Position]  TEXT(50);
				
ALTER TABLE IfcCircle ADD COLUMN [Radius]  DOUBLE;										
				
CREATE TABLE IfcCircleProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCircleProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcCircleProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcCircleProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcCircleProfileDef ADD COLUMN [Radius]  DOUBLE;										
				
CREATE TABLE IfcClassification (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcClassification ADD COLUMN [Source]  MEMO;										
				
ALTER TABLE IfcClassification ADD COLUMN [Edition]  MEMO;										
				
ALTER TABLE IfcClassification ADD COLUMN [EditionDate] TEXT(50);
				
ALTER TABLE IfcClassification ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcClassificationItem (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcClassificationItem ADD COLUMN [Notation] TEXT(50);
				
ALTER TABLE IfcClassificationItem ADD COLUMN [ItemOf] TEXT(50);
				
ALTER TABLE IfcClassificationItem ADD COLUMN [Title]  MEMO;										
				
CREATE TABLE IfcClassificationItemRelationship (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcClassificationItemRelationship ADD COLUMN [RelatingItem] TEXT(50);
					
CREATE TABLE IfcClassificationItemRelationship_RelatedItems (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcClassificationItemRelationship_RelatedItems ADD CONSTRAINT
	PK_IfcClassificationItemRelationship_RelatedItems FOREIGN KEY (pid)
	REFERENCES IfcClassificationItemRelationship (oid);

CREATE TABLE IfcClassificationNotation (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcClassificationNotation_NotationFacets (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcClassificationNotation_NotationFacets ADD CONSTRAINT
	PK_IfcClassificationNotation_NotationFacets FOREIGN KEY (pid)
	REFERENCES IfcClassificationNotation (oid);

CREATE TABLE IfcClassificationNotationFacet (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcClassificationNotationFacet ADD COLUMN [NotationValue]  MEMO;										
				
CREATE TABLE IfcClassificationReference (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcClassificationReference ADD COLUMN [Location]  MEMO;										
				
ALTER TABLE IfcClassificationReference ADD COLUMN [ItemReference]  MEMO;										
				
ALTER TABLE IfcClassificationReference ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcClassificationReference ADD COLUMN [ReferencedSource] TEXT(50);
				
CREATE TABLE IfcClosedShell (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcClosedShell_CfsFaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcClosedShell_CfsFaces ADD CONSTRAINT
	PK_IfcClosedShell_CfsFaces FOREIGN KEY (pid)
	REFERENCES IfcClosedShell (oid);

CREATE TABLE IfcCMDocPackage (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCMDocPackage ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [DocPackageID]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [DocPackageName]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [CreationDate]  TEXT(50);
					
CREATE TABLE IfcCMDocPackage_Authors (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_Authors ADD CONSTRAINT
	PK_IfcCMDocPackage_Authors FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);

CREATE TABLE IfcCoil (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCoil ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCoil ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCoil ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCoil ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCoil ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCoil ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcCoil ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcCoil ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcCoil ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcCoil ADD COLUMN [CoilType] TEXT(50);
				
ALTER TABLE IfcCoil ADD COLUMN [BypassFactor]  DOUBLE;										
				
ALTER TABLE IfcCoil ADD COLUMN [FaceVelocity]  DOUBLE;										
				
ALTER TABLE IfcCoil ADD COLUMN [FlowArrangement] TEXT(50);
				
CREATE TABLE IfcColumn (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcColumn ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcColumn ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcColumn ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcColumn ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcColumn ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcColumn ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcColumn ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcColumn ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcCompartment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCompartment ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCompartment ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCompartment ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCompartment ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCompartment ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCompartment ADD COLUMN [HasNaturalVentilation]  BYTE;										
				
ALTER TABLE IfcCompartment ADD COLUMN [HasSprinklerProtection]  BYTE;										
				
ALTER TABLE IfcCompartment ADD COLUMN [FireRiskFactor]  LONG;										
				
CREATE TABLE IfcComplexProperty (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcComplexProperty ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcComplexProperty ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcComplexProperty ADD COLUMN [UsageName]  MEMO;										
					
CREATE TABLE IfcComplexProperty_HasProperties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcComplexProperty_HasProperties ADD CONSTRAINT
	PK_IfcComplexProperty_HasProperties FOREIGN KEY (pid)
	REFERENCES IfcComplexProperty (oid);

CREATE TABLE IfcCompositeCurve (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcCompositeCurve_Segments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCompositeCurve_Segments ADD CONSTRAINT
	PK_IfcCompositeCurve_Segments FOREIGN KEY (pid)
	REFERENCES IfcCompositeCurve (oid);

ALTER TABLE IfcCompositeCurve ADD COLUMN [SelfIntersect]  BYTE;										
				
CREATE TABLE IfcCompositeCurveSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCompositeCurveSegment ADD COLUMN [Transition] TEXT(50);
				
ALTER TABLE IfcCompositeCurveSegment ADD COLUMN [SameSense]  BIT;										
				
ALTER TABLE IfcCompositeCurveSegment ADD COLUMN [ParentCurve] TEXT(50);
				
CREATE TABLE IfcCompositeProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCompositeProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcCompositeProfileDef ADD COLUMN [ProfileName]  MEMO;										
					
CREATE TABLE IfcCompositeProfileDef_Profiles (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCompositeProfileDef_Profiles ADD CONSTRAINT
	PK_IfcCompositeProfileDef_Profiles FOREIGN KEY (pid)
	REFERENCES IfcCompositeProfileDef (oid);

ALTER TABLE IfcCompositeProfileDef ADD COLUMN [Label]  MEMO;										
				
CREATE TABLE IfcCompressor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCompressor ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCompressor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCompressor ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCompressor ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCompressor ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCompressor ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcCompressor ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcCompressor ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcCompressor ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcCompressor ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcCompressor ADD COLUMN [ImpellerDiameter]  DOUBLE;										
				
ALTER TABLE IfcCompressor ADD COLUMN [CompressorType] TEXT(50);
				
ALTER TABLE IfcCompressor ADD COLUMN [HotGasBypass]  BIT;										
				
CREATE TABLE IfcConnectedFaceSet (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcConnectedFaceSet_CfsFaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConnectedFaceSet_CfsFaces ADD CONSTRAINT
	PK_IfcConnectedFaceSet_CfsFaces FOREIGN KEY (pid)
	REFERENCES IfcConnectedFaceSet (oid);

CREATE TABLE IfcConnectionConstraint (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConnectionConstraint ADD COLUMN [WaterproofingRequired]  BYTE;										
				
ALTER TABLE IfcConnectionConstraint ADD COLUMN [VentilationRequired]  BYTE;										
				
ALTER TABLE IfcConnectionConstraint ADD COLUMN [JoinType] TEXT(50);
				
ALTER TABLE IfcConnectionConstraint ADD COLUMN [RangeOfMovement]  DOUBLE;										
				
ALTER TABLE IfcConnectionConstraint ADD COLUMN [FireRating]  DOUBLE;										
				
ALTER TABLE IfcConnectionConstraint ADD COLUMN [ConstraintOf] TEXT(50);
				
CREATE TABLE IfcConnectionCurveGeometry (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConnectionCurveGeometry ADD COLUMN [CurveOnRelatingElement] TEXT(50);
				
ALTER TABLE IfcConnectionCurveGeometry ADD COLUMN [CurveOnRelatedElement] TEXT(50);
				
CREATE TABLE IfcConnectionPointGeometry (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConnectionPointGeometry ADD COLUMN [PointOnRelatingElement] TEXT(50);
				
ALTER TABLE IfcConnectionPointGeometry ADD COLUMN [PointOnRelatedElement] TEXT(50);
				
CREATE TABLE IfcConnectionPortGeometry (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConnectionPortGeometry ADD COLUMN [LocationAtRelatingElement]  TEXT(50);
				
ALTER TABLE IfcConnectionPortGeometry ADD COLUMN [LocationAtRelatedElement]  TEXT(50);
				
ALTER TABLE IfcConnectionPortGeometry ADD COLUMN [ProfileOfPort] TEXT(50);
				
CREATE TABLE IfcConnectionSurfaceGeometry (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConnectionSurfaceGeometry ADD COLUMN [SurfaceOnRelatingElement] TEXT(50);
				
ALTER TABLE IfcConnectionSurfaceGeometry ADD COLUMN [SurfaceOnRelatedElement] TEXT(50);
				
CREATE TABLE IfcConstraint (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstraint ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcConstraint ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstraint ADD COLUMN [ConstraintSource]  MEMO;										
				
ALTER TABLE IfcConstraint ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcConstraint ADD COLUMN [CreatingActor]  TEXT(50);
				
ALTER TABLE IfcConstraint ADD COLUMN [CreationTime]  TEXT(50);
				
CREATE TABLE IfcConstraintAggregationRelationship (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstraintAggregationRelationship ADD COLUMN [LogicalAggregator] TEXT(50);
				
ALTER TABLE IfcConstraintAggregationRelationship ADD COLUMN [RelatingConstraint] TEXT(50);
					
CREATE TABLE IfcConstraintAggregationRelationship_RelatedConstraints (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstraintAggregationRelationship_RelatedConstraints ADD CONSTRAINT
	PK_IfcConstraintAggregationRelationship_RelatedConstraints FOREIGN KEY (pid)
	REFERENCES IfcConstraintAggregationRelationship (oid);

CREATE TABLE IfcConstraintUsage (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstraintUsage ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcConstraintUsage ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstraintUsage ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcConstraintUsage ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstraintUsage ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcConstraintUsage ADD COLUMN [Intent] TEXT(50);
				
ALTER TABLE IfcConstraintUsage ADD COLUMN [Constraint] TEXT(50);
				
CREATE TABLE IfcConstructionEquipmentResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [BaseUnit] TEXT(50);
				
CREATE TABLE IfcConstructionMaterialResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [BaseUnit] TEXT(50);
					
CREATE TABLE IfcConstructionMaterialResource_Suppliers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionMaterialResource_Suppliers ADD CONSTRAINT
	PK_IfcConstructionMaterialResource_Suppliers FOREIGN KEY (pid)
	REFERENCES IfcConstructionMaterialResource (oid);

ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [OrderQuantity] TEXT(50);
					
CREATE TABLE IfcConstructionMaterialResource_DesignMaterial (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionMaterialResource_DesignMaterial ADD CONSTRAINT
	PK_IfcConstructionMaterialResource_DesignMaterial FOREIGN KEY (pid)
	REFERENCES IfcConstructionMaterialResource (oid);

CREATE TABLE IfcConstructionProductResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstructionProductResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcConstructionProductResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstructionProductResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcConstructionProductResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstructionProductResource ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcConstructionProductResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcConstructionProductResource ADD COLUMN [BaseUnit] TEXT(50);
				
CREATE TABLE IfcContextDependentUnit (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcContextDependentUnit ADD COLUMN [Dimensions] TEXT(50);
				
ALTER TABLE IfcContextDependentUnit ADD COLUMN [UnitType] TEXT(50);
				
ALTER TABLE IfcContextDependentUnit ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcControlElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcControlElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcControlElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcControlElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcControlElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcControlElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcControlElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcControlElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcControlElement ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcControlElement ADD COLUMN [ControlElementId]  MEMO;										
				
CREATE TABLE IfcController (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcController ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcController ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcController ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcController ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcController ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcController ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcController ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcController ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcController ADD COLUMN [ControlElementId]  MEMO;										
				
CREATE TABLE IfcConversionBasedUnit (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConversionBasedUnit ADD COLUMN [Dimensions] TEXT(50);
				
ALTER TABLE IfcConversionBasedUnit ADD COLUMN [UnitType] TEXT(50);
				
ALTER TABLE IfcConversionBasedUnit ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcConversionBasedUnit ADD COLUMN [ConversionFactor] TEXT(50);
				
CREATE TABLE IfcCoolingTower (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCoolingTower ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCoolingTower ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCoolingTower ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCoolingTower ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCoolingTower ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCoolingTower ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcCoolingTower ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcCoolingTower ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcCoolingTower ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcCoolingTower ADD COLUMN [HeatTransferRate]  DOUBLE;										
				
ALTER TABLE IfcCoolingTower ADD COLUMN [ThermalEfficiency]  DOUBLE;										
				
ALTER TABLE IfcCoolingTower ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcCoolingTower ADD COLUMN [CoolingTowerType] TEXT(50);
				
CREATE TABLE IfcCoolingTower_AmbientDesignTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcCoolingTower_AmbientDesignTemperature ADD CONSTRAINT
	PK_IfcCoolingTower_AmbientDesignTemperature FOREIGN KEY (pid)
	REFERENCES IfcCoolingTower (oid);

CREATE TABLE IfcCoordinatedUniversalTimeOffset (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCoordinatedUniversalTimeOffset ADD COLUMN [HourOffset]  LONG;										
				
ALTER TABLE IfcCoordinatedUniversalTimeOffset ADD COLUMN [MinuteOffset]  LONG;										
				
ALTER TABLE IfcCoordinatedUniversalTimeOffset ADD COLUMN [Sense] TEXT(50);
				
CREATE TABLE IfcCost (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCost ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCost ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCost ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCost ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCost ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCost ADD COLUMN [ContextDescription]  MEMO;										
				
ALTER TABLE IfcCost ADD COLUMN [ElementCost] TEXT(50);
				
ALTER TABLE IfcCost ADD COLUMN [ExtensionCost] TEXT(50);
				
ALTER TABLE IfcCost ADD COLUMN [CostUse] TEXT(50);
				
ALTER TABLE IfcCost ADD COLUMN [PreparedOn] TEXT(50);
					
CREATE TABLE IfcCost_Quantities (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCost_Quantities ADD CONSTRAINT
	PK_IfcCost_Quantities FOREIGN KEY (pid)
	REFERENCES IfcCost (oid);

ALTER TABLE IfcCost ADD COLUMN [CostType]  MEMO;										
				
CREATE TABLE IfcCostModifier (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostModifier ADD COLUMN [Purpose]  MEMO;										
					
CREATE TABLE IfcCostModifier_ModifierValue (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcCostModifier_ModifierValue ADD CONSTRAINT
	PK_IfcCostModifier_ModifierValue FOREIGN KEY (pid)
	REFERENCES IfcCostModifier (oid);

ALTER TABLE IfcCostModifier ADD COLUMN [ModifierDate] TEXT(50);
				
ALTER TABLE IfcCostModifier ADD COLUMN [CostOperator] TEXT(50);
				
ALTER TABLE IfcCostModifier ADD COLUMN [ModifierBasis] TEXT(50);
				
CREATE TABLE IfcCostModifierValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostModifierValue ADD COLUMN [ModifierAmount]  DOUBLE;										
				
ALTER TABLE IfcCostModifierValue ADD COLUMN [Currency] TEXT(50);
				
CREATE TABLE IfcCostQuantity (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostQuantity ADD COLUMN [BaseQuantity] TEXT(50);
				
ALTER TABLE IfcCostQuantity ADD COLUMN [FinalQuantity] TEXT(50);
				
ALTER TABLE IfcCostQuantity ADD COLUMN [WasteFactor]  DOUBLE;										
				
ALTER TABLE IfcCostQuantity ADD COLUMN [RoundOffIncrement]  DOUBLE;										
				
ALTER TABLE IfcCostQuantity ADD COLUMN [RoundOffBasis] TEXT(50);
				
CREATE TABLE IfcCostSchedule (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostSchedule ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCostSchedule ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [Title]  MEMO;										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [SubmittedBy]  TEXT(50);
					
CREATE TABLE IfcCostSchedule_ApprovedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCostSchedule_ApprovedBy ADD CONSTRAINT
	PK_IfcCostSchedule_ApprovedBy FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid);

ALTER TABLE IfcCostSchedule ADD COLUMN [PreparedBy] TEXT(50);
				
ALTER TABLE IfcCostSchedule ADD COLUMN [SubmittedOn] TEXT(50);
				
ALTER TABLE IfcCostSchedule ADD COLUMN [TotalCost] TEXT(50);
					
CREATE TABLE IfcCostSchedule_CostElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCostSchedule_CostElements ADD CONSTRAINT
	PK_IfcCostSchedule_CostElements FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid);

ALTER TABLE IfcCostSchedule ADD COLUMN [Status]  MEMO;										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [IntendedUse]  MEMO;										
				
CREATE TABLE IfcCostSchedule_Comments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcCostSchedule_Comments ADD CONSTRAINT
	PK_IfcCostSchedule_Comments FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid);
	
CREATE TABLE IfcCostSchedule_TargetUsers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCostSchedule_TargetUsers ADD CONSTRAINT
	PK_IfcCostSchedule_TargetUsers FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid);

ALTER TABLE IfcCostSchedule ADD COLUMN [ValidFromDate] TEXT(50);
				
ALTER TABLE IfcCostSchedule ADD COLUMN [ValidToDate] TEXT(50);
				
ALTER TABLE IfcCostSchedule ADD COLUMN [UpdateDate] TEXT(50);
				
ALTER TABLE IfcCostSchedule ADD COLUMN [ScheduleNumber]  MEMO;										
				
CREATE TABLE IfcCostValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostValue ADD COLUMN [BaseCostValue]  DOUBLE;										
				
ALTER TABLE IfcCostValue ADD COLUMN [FinalCostValue]  DOUBLE;										
				
ALTER TABLE IfcCostValue ADD COLUMN [Currency] TEXT(50);
				
ALTER TABLE IfcCostValue ADD COLUMN [UnitCostBasis] TEXT(50);
				
ALTER TABLE IfcCostValue ADD COLUMN [CostType]  MEMO;										
				
ALTER TABLE IfcCostValue ADD COLUMN [CostDate] TEXT(50);
					
CREATE TABLE IfcCostValue_CostModifiers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCostValue_CostModifiers ADD CONSTRAINT
	PK_IfcCostValue_CostModifiers FOREIGN KEY (pid)
	REFERENCES IfcCostValue (oid);

CREATE TABLE IfcCostValueRelationship (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostValueRelationship ADD COLUMN [ComponentOf] TEXT(50);
					
CREATE TABLE IfcCostValueRelationship_CostComponents (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCostValueRelationship_CostComponents ADD CONSTRAINT
	PK_IfcCostValueRelationship_CostComponents FOREIGN KEY (pid)
	REFERENCES IfcCostValueRelationship (oid);

ALTER TABLE IfcCostValueRelationship ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcCovering (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCovering ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCovering ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCovering ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCovering ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCovering ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcCovering ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcCrewResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCrewResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCrewResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcCrewResource ADD COLUMN [BaseUnit] TEXT(50);
				
CREATE TABLE IfcCsgSolid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCsgSolid ADD COLUMN [TreeRootExpression]  TEXT(50);
				
CREATE TABLE IfcCurtainWall (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCurtainWall ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcCurtainWall ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCurtainWall ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcCurtainWall ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCurtainWall ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcCurtainWall ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcCurtainWall ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcCurtainWall ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcCurveBoundedPlane (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCurveBoundedPlane ADD COLUMN [BasisSurface] TEXT(50);
				
ALTER TABLE IfcCurveBoundedPlane ADD COLUMN [OuterBoundary] TEXT(50);
					
CREATE TABLE IfcCurveBoundedPlane_InnerBoundaries (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCurveBoundedPlane_InnerBoundaries ADD CONSTRAINT
	PK_IfcCurveBoundedPlane_InnerBoundaries FOREIGN KEY (pid)
	REFERENCES IfcCurveBoundedPlane (oid);

CREATE TABLE IfcDamper (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDamper ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDamper ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDamper ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDamper ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcDamper ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcDamper ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [FrameDepth]  DOUBLE;										
				
ALTER TABLE IfcDamper ADD COLUMN [SizingMethod] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [CloseOffRating]  DOUBLE;										
				
ALTER TABLE IfcDamper ADD COLUMN [LeakageAirFlowRate]  DOUBLE;										
				
ALTER TABLE IfcDamper ADD COLUMN [PercentOpen]  DOUBLE;										
				
CREATE TABLE IfcDateAndTime (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDateAndTime ADD COLUMN [DateComponent] TEXT(50);
				
ALTER TABLE IfcDateAndTime ADD COLUMN [TimeComponent] TEXT(50);
				
CREATE TABLE IfcDerivedProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDerivedProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcDerivedProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcDerivedProfileDef ADD COLUMN [ParentProfile] TEXT(50);
				
ALTER TABLE IfcDerivedProfileDef ADD COLUMN [Operator] TEXT(50);
				
ALTER TABLE IfcDerivedProfileDef ADD COLUMN [Label]  MEMO;										
				
CREATE TABLE IfcDerivedUnit (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcDerivedUnit_Elements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDerivedUnit_Elements ADD CONSTRAINT
	PK_IfcDerivedUnit_Elements FOREIGN KEY (pid)
	REFERENCES IfcDerivedUnit (oid);

ALTER TABLE IfcDerivedUnit ADD COLUMN [UnitType] TEXT(50);
				
ALTER TABLE IfcDerivedUnit ADD COLUMN [UserDefinedType]  MEMO;										
				
CREATE TABLE IfcDerivedUnitElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDerivedUnitElement ADD COLUMN [Unit] TEXT(50);
				
ALTER TABLE IfcDerivedUnitElement ADD COLUMN [Exponent]  LONG;										
				
CREATE TABLE IfcDimensionalExponents (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDimensionalExponents ADD COLUMN [LengthExponent]  LONG;										
				
ALTER TABLE IfcDimensionalExponents ADD COLUMN [MassExponent]  LONG;										
				
ALTER TABLE IfcDimensionalExponents ADD COLUMN [TimeExponent]  LONG;										
				
ALTER TABLE IfcDimensionalExponents ADD COLUMN [ElectricCurrentExponent]  LONG;										
				
ALTER TABLE IfcDimensionalExponents ADD COLUMN [ThermodynamicTemperatureExponent]  LONG;										
				
ALTER TABLE IfcDimensionalExponents ADD COLUMN [AmountOfSubstanceExponent]  LONG;										
				
ALTER TABLE IfcDimensionalExponents ADD COLUMN [LuminousIntensityExponent]  LONG;										
				
CREATE TABLE IfcDirection (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcDirection_DirectionRatios (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcDirection_DirectionRatios ADD CONSTRAINT
	PK_IfcDirection_DirectionRatios FOREIGN KEY (pid)
	REFERENCES IfcDirection (oid);

CREATE TABLE IfcDirectionalLightSource (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcDirectionalLightSource_Color (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcDirectionalLightSource_Color ADD CONSTRAINT
	PK_IfcDirectionalLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcDirectionalLightSource (oid);

ALTER TABLE IfcDirectionalLightSource ADD COLUMN [AmbientIntensity]  DOUBLE;										
				
ALTER TABLE IfcDirectionalLightSource ADD COLUMN [Intensity]  DOUBLE;										
				
ALTER TABLE IfcDirectionalLightSource ADD COLUMN [InContext] TEXT(50);
				
ALTER TABLE IfcDirectionalLightSource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDirectionalLightSource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDirectionalLightSource ADD COLUMN [Direction] TEXT(50);
				
CREATE TABLE IfcDiscreteElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDiscreteElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcDistributionElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDistributionElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDistributionElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDistributionElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDistributionElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDistributionElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcDistributionElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcDistributionElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcDistributionElement ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcDistributionFlowElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [FlowElementType] TEXT(50);
				
CREATE TABLE IfcDocumentElectronicFormat (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDocumentElectronicFormat ADD COLUMN [FileExtension]  MEMO;										
				
ALTER TABLE IfcDocumentElectronicFormat ADD COLUMN [MimeContentType]  MEMO;										
				
ALTER TABLE IfcDocumentElectronicFormat ADD COLUMN [MimeSubtype]  MEMO;										
				
CREATE TABLE IfcDocumentInformation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDocumentInformation ADD COLUMN [DocumentId]  MEMO;										
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcDocumentInformation_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDocumentInformation_DocumentReferences ADD CONSTRAINT
	PK_IfcDocumentInformation_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDocumentInformation (oid);

ALTER TABLE IfcDocumentInformation ADD COLUMN [Purpose]  MEMO;										
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [IntendedUse]  MEMO;										
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [Scope]  MEMO;										
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [Revision]  MEMO;										
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [DocumentOwner]  TEXT(50);
					
CREATE TABLE IfcDocumentInformation_Editors (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDocumentInformation_Editors ADD CONSTRAINT
	PK_IfcDocumentInformation_Editors FOREIGN KEY (pid)
	REFERENCES IfcDocumentInformation (oid);

ALTER TABLE IfcDocumentInformation ADD COLUMN [CreationTime] TEXT(50);
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [LastRevisionTime] TEXT(50);
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [ElectronicFormat] TEXT(50);
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [ValidFrom] TEXT(50);
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [ValidUntil] TEXT(50);
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [Confidentiality] TEXT(50);
				
ALTER TABLE IfcDocumentInformation ADD COLUMN [Status] TEXT(50);
				
CREATE TABLE IfcDocumentInformationRelationship (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDocumentInformationRelationship ADD COLUMN [RelatingDocument] TEXT(50);
					
CREATE TABLE IfcDocumentInformationRelationship_RelatedDocuments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDocumentInformationRelationship_RelatedDocuments ADD CONSTRAINT
	PK_IfcDocumentInformationRelationship_RelatedDocuments FOREIGN KEY (pid)
	REFERENCES IfcDocumentInformationRelationship (oid);

ALTER TABLE IfcDocumentInformationRelationship ADD COLUMN [RelationshipType]  MEMO;										
				
CREATE TABLE IfcDocumentReference (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDocumentReference ADD COLUMN [Location]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [ItemReference]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcDoor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDoor ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDoor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDoor ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDoor ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDoor ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcDoor ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcDoor ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcDoor ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcDoor ADD COLUMN [OverallHeight]  DOUBLE;										
				
ALTER TABLE IfcDoor ADD COLUMN [OverallWidth]  DOUBLE;										
				
CREATE TABLE IfcDoorLiningProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [LiningDepth]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [LiningThickness]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [ThresholdDepth]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [ThresholdThickness]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [TransomThickness]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [TransomOffset]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [LiningOffset]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [ThresholdOffset]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [CasingThickness]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [CasingDepth]  DOUBLE;										
				
ALTER TABLE IfcDoorLiningProperties ADD COLUMN [ShapeAspectStyle] TEXT(50);
				
CREATE TABLE IfcDoorPanelProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [PanelDepth]  DOUBLE;										
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [PanelOperation] TEXT(50);
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [PanelWidth]  DOUBLE;										
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [PanelPosition] TEXT(50);
				
ALTER TABLE IfcDoorPanelProperties ADD COLUMN [ShapeAspectStyle] TEXT(50);
				
CREATE TABLE IfcDoorStyle (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDoorStyle ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcDoorStyle ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDoorStyle ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcDoorStyle ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcDoorStyle ADD COLUMN [ApplicableOccurrence]  MEMO;										
					
CREATE TABLE IfcDoorStyle_HasPropertySets (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoorStyle_HasPropertySets ADD CONSTRAINT
	PK_IfcDoorStyle_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcDoorStyle (oid);
	
CREATE TABLE IfcDoorStyle_RepresentationMaps (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoorStyle_RepresentationMaps ADD CONSTRAINT
	PK_IfcDoorStyle_RepresentationMaps FOREIGN KEY (pid)
	REFERENCES IfcDoorStyle (oid);

ALTER TABLE IfcDoorStyle ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcDoorStyle ADD COLUMN [OperationType] TEXT(50);
				
ALTER TABLE IfcDoorStyle ADD COLUMN [ConstructionType] TEXT(50);
				
ALTER TABLE IfcDoorStyle ADD COLUMN [ParameterTakesPrecedence]  BIT;										
				
ALTER TABLE IfcDoorStyle ADD COLUMN [Sizeable]  BIT;										
				
CREATE TABLE IfcEdge (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEdge ADD COLUMN [EdgeStart] TEXT(50);
				
ALTER TABLE IfcEdge ADD COLUMN [EdgeEnd] TEXT(50);
				
CREATE TABLE IfcEdgeCurve (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEdgeCurve ADD COLUMN [EdgeStart] TEXT(50);
				
ALTER TABLE IfcEdgeCurve ADD COLUMN [EdgeEnd] TEXT(50);
				
ALTER TABLE IfcEdgeCurve ADD COLUMN [EdgeGeometry] TEXT(50);
				
ALTER TABLE IfcEdgeCurve ADD COLUMN [SameSense]  BIT;										
				
CREATE TABLE IfcElectricalAppliance (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricalAppliance ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [ApplianceType] TEXT(50);
				
CREATE TABLE IfcElectricalBaseProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [ElectricCurrentType] TEXT(50);
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [InputVoltage]  DOUBLE;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [InputFrequency]  DOUBLE;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [FullLoadCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [MinimumCircuitCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [MaximumPowerInput]  DOUBLE;										
				
ALTER TABLE IfcElectricalBaseProperties ADD COLUMN [RatedPowerInput]  DOUBLE;										
				
CREATE TABLE IfcElectricalElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricalElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcElectricalElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricalElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcElectricalElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcElectricalElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcElectricalElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcElectricalElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcElectricalElement ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcElectricalExtendedProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [ElectricCurrentType] TEXT(50);
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [InputVoltage]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [InputFrequency]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [FullLoadCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [MinimumCircuitCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [MaximumPowerInput]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [RatedPowerInput]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [InputPhase]  LONG;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [InrushCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [LockedRotorCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [CircuitSizePowerInput]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [FuseSize]  DOUBLE;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD COLUMN [Grounded]  BIT;										
				
CREATE TABLE IfcElectricMotor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricMotor ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricMotor ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcElectricMotor ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcElectricMotor ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [MotorWindingType] TEXT(50);
				
ALTER TABLE IfcElectricMotor ADD COLUMN [Efficiency]  DOUBLE;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [PowerOutput]  DOUBLE;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [FrameConfiguration]  MEMO;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [InsulationRating_]  MEMO;										
				
ALTER TABLE IfcElectricMotor ADD COLUMN [MotorHousing] TEXT(50);
				
CREATE TABLE IfcElementQuantity (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElementQuantity ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcElementQuantity ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElementQuantity ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcElementQuantity ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcElementQuantity ADD COLUMN [MethodOfMeasurement]  MEMO;										
					
CREATE TABLE IfcElementQuantity_Quantities (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcElementQuantity_Quantities ADD CONSTRAINT
	PK_IfcElementQuantity_Quantities FOREIGN KEY (pid)
	REFERENCES IfcElementQuantity (oid);

CREATE TABLE IfcEllipse (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEllipse ADD COLUMN [Position]  TEXT(50);
				
ALTER TABLE IfcEllipse ADD COLUMN [SemiAxis1]  DOUBLE;										
				
ALTER TABLE IfcEllipse ADD COLUMN [SemiAxis2]  DOUBLE;										
				
CREATE TABLE IfcEllipseProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEllipseProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcEllipseProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcEllipseProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcEllipseProfileDef ADD COLUMN [SemiAxis1]  DOUBLE;										
				
ALTER TABLE IfcEllipseProfileDef ADD COLUMN [SemiAxis2]  DOUBLE;										
				
CREATE TABLE IfcEquipmentElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEquipmentElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcEquipmentElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcEquipmentElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcEquipmentElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcEquipmentElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcEquipmentElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcEquipmentElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcEquipmentElement ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcEquipmentStandard (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEquipmentStandard ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcEquipmentStandard ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcEquipmentStandard ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcEquipmentStandard ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcEquipmentStandard ADD COLUMN [ObjectType]  MEMO;										
				
CREATE TABLE IfcExtendedMaterialProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcExtendedMaterialProperties ADD COLUMN [Material] TEXT(50);
					
CREATE TABLE IfcExtendedMaterialProperties_ExtendedProperties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcExtendedMaterialProperties_ExtendedProperties ADD CONSTRAINT
	PK_IfcExtendedMaterialProperties_ExtendedProperties FOREIGN KEY (pid)
	REFERENCES IfcExtendedMaterialProperties (oid);

ALTER TABLE IfcExtendedMaterialProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcExtendedMaterialProperties ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcExtrudedAreaSolid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcExtrudedAreaSolid ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcExtrudedAreaSolid ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcExtrudedAreaSolid ADD COLUMN [ExtrudedDirection] TEXT(50);
				
ALTER TABLE IfcExtrudedAreaSolid ADD COLUMN [Depth]  DOUBLE;										
				
CREATE TABLE IfcFace (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcFace_Bounds (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFace_Bounds ADD CONSTRAINT
	PK_IfcFace_Bounds FOREIGN KEY (pid)
	REFERENCES IfcFace (oid);

CREATE TABLE IfcFaceBasedSurfaceModel (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcFaceBasedSurfaceModel_FbsmFaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFaceBasedSurfaceModel_FbsmFaces ADD CONSTRAINT
	PK_IfcFaceBasedSurfaceModel_FbsmFaces FOREIGN KEY (pid)
	REFERENCES IfcFaceBasedSurfaceModel (oid);

CREATE TABLE IfcFaceBound (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFaceBound ADD COLUMN [Bound] TEXT(50);
				
ALTER TABLE IfcFaceBound ADD COLUMN [Orientation]  BIT;										
				
CREATE TABLE IfcFaceOuterBound (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFaceOuterBound ADD COLUMN [Bound] TEXT(50);
				
ALTER TABLE IfcFaceOuterBound ADD COLUMN [Orientation]  BIT;										
				
CREATE TABLE IfcFaceSurface (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcFaceSurface_Bounds (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFaceSurface_Bounds ADD CONSTRAINT
	PK_IfcFaceSurface_Bounds FOREIGN KEY (pid)
	REFERENCES IfcFaceSurface (oid);

ALTER TABLE IfcFaceSurface ADD COLUMN [FaceSurface] TEXT(50);
				
ALTER TABLE IfcFaceSurface ADD COLUMN [SameSense]  BIT;										
				
CREATE TABLE IfcFacetedBrep (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFacetedBrep ADD COLUMN [Outer] TEXT(50);
				
CREATE TABLE IfcFacetedBrepWithVoids (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFacetedBrepWithVoids ADD COLUMN [Outer] TEXT(50);
					
CREATE TABLE IfcFacetedBrepWithVoids_Voids (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFacetedBrepWithVoids_Voids ADD CONSTRAINT
	PK_IfcFacetedBrepWithVoids_Voids FOREIGN KEY (pid)
	REFERENCES IfcFacetedBrepWithVoids (oid);

CREATE TABLE IfcFan (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFan ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFan ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFan ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFan ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFan ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcFan ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [ImpellerDiameter]  DOUBLE;										
				
ALTER TABLE IfcFan ADD COLUMN [AirFlowType] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [StaticPressure]  DOUBLE;										
				
ALTER TABLE IfcFan ADD COLUMN [FanPressureClass] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [FanWheelType] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [WheelMaterial]  TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [WheelTipSpeed]  DOUBLE;										
				
ALTER TABLE IfcFan ADD COLUMN [DischargeVelocity]  DOUBLE;										
				
ALTER TABLE IfcFan ADD COLUMN [HousingMaterial]  TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [DischargePressureLoss]  DOUBLE;										
				
ALTER TABLE IfcFan ADD COLUMN [FanDischargeType] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [FanArrangement] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [FanRotation] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [FanDriveArrangement] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [DrivePowerLoss_]  DOUBLE;										
				
ALTER TABLE IfcFan ADD COLUMN [MotorDriveType] TEXT(50);
				
ALTER TABLE IfcFan ADD COLUMN [MotorInAirstream_]  BIT;										
				
ALTER TABLE IfcFan ADD COLUMN [FanMountingType] TEXT(50);
				
CREATE TABLE IfcFlowController (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowController ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFlowController ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowController ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFlowController ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFlowController ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFlowController ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFlowController ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFlowController ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcFlowController ADD COLUMN [FlowElementType] TEXT(50);
				
CREATE TABLE IfcFlowFitting (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowFitting ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFlowFitting ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFlowFitting ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFlowFitting ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFlowFitting ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcFlowFitting ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [PrimaryFittingType] TEXT(50);
				
CREATE TABLE IfcFlowSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowSegment ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFlowSegment ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowSegment ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFlowSegment ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFlowSegment ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFlowSegment ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFlowSegment ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFlowSegment ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcFlowSegment ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcFlowSegment ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcFlowTerminal (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowTerminal ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [FlowElementType] TEXT(50);
				
CREATE TABLE IfcFluidFlowProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [MaximumFlowRate]  DOUBLE;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [DesignFlowrate]  DOUBLE;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [MinimumFlowrate]  DOUBLE;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [PressureLoss]  DOUBLE;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [WorkingPressure]  DOUBLE;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [PressureRating]  DOUBLE;										
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [Fluid] TEXT(50);
				
ALTER TABLE IfcFluidFlowProperties ADD COLUMN [DesignVelocity]  DOUBLE;										
				
CREATE TABLE IfcFluidFlowProperties_DesignTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcFluidFlowProperties_DesignTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_DesignTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid);

CREATE TABLE IfcFluidFlowProperties_MaximumTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcFluidFlowProperties_MaximumTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_MaximumTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid);

CREATE TABLE IfcFluidFlowProperties_MinimumTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcFluidFlowProperties_MinimumTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_MinimumTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid);

CREATE TABLE IfcFluidFlowProperties_WorkingTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcFluidFlowProperties_WorkingTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_WorkingTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid);

ALTER TABLE IfcFluidFlowProperties ADD COLUMN [WorkingQuality]  DOUBLE;										
				
CREATE TABLE IfcFluidMovingDevice (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcFluidMovingDevice ADD COLUMN [ImpellerDiameter]  DOUBLE;										
				
CREATE TABLE IfcFurnishingElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFurnishingElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFurnishingElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFurnishingElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFurnishingElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFurnishingElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFurnishingElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFurnishingElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFurnishingElement ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcFurniture (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFurniture ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFurniture ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFurniture ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFurniture ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFurniture ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcFurniture ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcFurniture ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcFurniture ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcFurnitureStandard (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFurnitureStandard ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcFurnitureStandard ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFurnitureStandard ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcFurnitureStandard ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcFurnitureStandard ADD COLUMN [ObjectType]  MEMO;										
				
CREATE TABLE IfcGeneralMaterialProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGeneralMaterialProperties ADD COLUMN [Material] TEXT(50);
				
ALTER TABLE IfcGeneralMaterialProperties ADD COLUMN [MolecularWeight]  DOUBLE;										
				
ALTER TABLE IfcGeneralMaterialProperties ADD COLUMN [Porosity]  DOUBLE;										
				
ALTER TABLE IfcGeneralMaterialProperties ADD COLUMN [MassDensity]  DOUBLE;										
				
CREATE TABLE IfcGeometricRepresentationContext (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGeometricRepresentationContext ADD COLUMN [ContextIdentifier]  MEMO;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD COLUMN [ContextType]  MEMO;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD COLUMN [CoordinateSpaceDimension]  LONG;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD COLUMN [Precision]  DOUBLE;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD COLUMN [WorldCoordinateSystem]  TEXT(50);
				
ALTER TABLE IfcGeometricRepresentationContext ADD COLUMN [TrueNorth] TEXT(50);
				
CREATE TABLE IfcGeometricSet (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcGeometricSet_Elements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcGeometricSet_Elements ADD CONSTRAINT
	PK_IfcGeometricSet_Elements FOREIGN KEY (pid)
	REFERENCES IfcGeometricSet (oid);

CREATE TABLE IfcGrid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGrid ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcGrid ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcGrid ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcGrid ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcGrid ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcGrid ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcGrid ADD COLUMN [Representation] TEXT(50);
					
CREATE TABLE IfcGrid_UAxes (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcGrid_UAxes ADD CONSTRAINT
	PK_IfcGrid_UAxes FOREIGN KEY (pid)
	REFERENCES IfcGrid (oid);
	
CREATE TABLE IfcGrid_VAxes (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcGrid_VAxes ADD CONSTRAINT
	PK_IfcGrid_VAxes FOREIGN KEY (pid)
	REFERENCES IfcGrid (oid);
	
CREATE TABLE IfcGrid_WAxes (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcGrid_WAxes ADD CONSTRAINT
	PK_IfcGrid_WAxes FOREIGN KEY (pid)
	REFERENCES IfcGrid (oid);

CREATE TABLE IfcGridAxis (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGridAxis ADD COLUMN [AxisTag]  MEMO;										
				
ALTER TABLE IfcGridAxis ADD COLUMN [AxisCurve] TEXT(50);
				
ALTER TABLE IfcGridAxis ADD COLUMN [SameSense]  BIT;										
				
CREATE TABLE IfcGridPlacement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGridPlacement ADD COLUMN [PlacementLocation] TEXT(50);
				
ALTER TABLE IfcGridPlacement ADD COLUMN [PlacementRefDirection] TEXT(50);
				
CREATE TABLE IfcGroup (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGroup ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcGroup ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcGroup ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcGroup ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcGroup ADD COLUMN [ObjectType]  MEMO;										
				
CREATE TABLE IfcHalfSpaceSolid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcHalfSpaceSolid ADD COLUMN [BaseSurface] TEXT(50);
				
ALTER TABLE IfcHalfSpaceSolid ADD COLUMN [AgreementFlag]  BIT;										
				
CREATE TABLE IfcHeatExchanger (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcHeatExchanger ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [HeatTransferRate]  DOUBLE;										
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [ThermalEfficiency]  DOUBLE;										
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [HeatExchangerType] TEXT(50);
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [HeatExchangerArrangement] TEXT(50);
				
ALTER TABLE IfcHeatExchanger ADD COLUMN [NumberOfPlates]  LONG;										
				
CREATE TABLE IfcHeatTransferDevice (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [HeatTransferRate]  DOUBLE;										
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [ThermalEfficiency]  DOUBLE;										
				
ALTER TABLE IfcHeatTransferDevice ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
CREATE TABLE IfcHydronicHeater (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcHydronicHeater ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [HydronicHeaterType] TEXT(50);
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [HeatOutput]  DOUBLE;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [Enclosure]  MEMO;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [BodyMass]  DOUBLE;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [NumberOfPanels]  LONG;										
				
ALTER TABLE IfcHydronicHeater ADD COLUMN [NumberOfSections]  LONG;										
				
CREATE TABLE IfcHygroscopicMaterialProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcHygroscopicMaterialProperties ADD COLUMN [Material] TEXT(50);
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD COLUMN [UpperVaporResistanceFactor]  DOUBLE;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD COLUMN [LowerVaporResistanceFactor]  DOUBLE;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD COLUMN [IsothermalMoistureCapacity]  DOUBLE;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD COLUMN [VaporPermeability]  DOUBLE;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD COLUMN [MoistureDiffusivity]  DOUBLE;										
				
CREATE TABLE IfcInventory (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcInventory ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcInventory ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcInventory ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcInventory ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcInventory ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcInventory ADD COLUMN [DefinedType] TEXT(50);
				
ALTER TABLE IfcInventory ADD COLUMN [Jurisdiction]  TEXT(50);
					
CREATE TABLE IfcInventory_ResponsiblePersons (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcInventory_ResponsiblePersons ADD CONSTRAINT
	PK_IfcInventory_ResponsiblePersons FOREIGN KEY (pid)
	REFERENCES IfcInventory (oid);

ALTER TABLE IfcInventory ADD COLUMN [LastUpdateDate] TEXT(50);
				
ALTER TABLE IfcInventory ADD COLUMN [CurrentValue] TEXT(50);
				
ALTER TABLE IfcInventory ADD COLUMN [OriginalValue] TEXT(50);
				
CREATE TABLE IfcIshapeProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [OverallWidth]  DOUBLE;										
				
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [OverallDepth]  DOUBLE;										
				
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [WebThickness]  DOUBLE;										
				
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [FlangeThickness]  DOUBLE;										
				
ALTER TABLE IfcIshapeProfileDef ADD COLUMN [FilletRadius]  DOUBLE;										
				
CREATE TABLE IfcLaborResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLaborResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLaborResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcLaborResource ADD COLUMN [BaseUnit] TEXT(50);
				
ALTER TABLE IfcLaborResource ADD COLUMN [Title]  MEMO;										
				
CREATE TABLE IfcLaborResource_SkillSet (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcLaborResource_SkillSet ADD CONSTRAINT
	PK_IfcLaborResource_SkillSet FOREIGN KEY (pid)
	REFERENCES IfcLaborResource (oid);

CREATE TABLE IfcLibraryInformation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLibraryInformation ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcLibraryInformation ADD COLUMN [Version]  MEMO;										
				
ALTER TABLE IfcLibraryInformation ADD COLUMN [Publisher] TEXT(50);
				
ALTER TABLE IfcLibraryInformation ADD COLUMN [VersionDate] TEXT(50);
					
CREATE TABLE IfcLibraryInformation_LibraryReference (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLibraryInformation_LibraryReference ADD CONSTRAINT
	PK_IfcLibraryInformation_LibraryReference FOREIGN KEY (pid)
	REFERENCES IfcLibraryInformation (oid);

CREATE TABLE IfcLibraryReference (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLibraryReference ADD COLUMN [Location]  MEMO;										
				
ALTER TABLE IfcLibraryReference ADD COLUMN [ItemReference]  MEMO;										
				
ALTER TABLE IfcLibraryReference ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcLightFixture (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLightFixture ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLightFixture ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcLightFixture ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcLightFixture ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [MaximumSpaceSensibleLoad]  DOUBLE;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [MaximumPlenumSensibleLoad_]  DOUBLE;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [SensibleLoadToRadiant]  DOUBLE;										
				
CREATE TABLE IfcLine (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLine ADD COLUMN [Pnt] TEXT(50);
				
ALTER TABLE IfcLine ADD COLUMN [Dir] TEXT(50);
				
CREATE TABLE IfcLocalPlacement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLocalPlacement ADD COLUMN [PlacementRelTo] TEXT(50);
				
ALTER TABLE IfcLocalPlacement ADD COLUMN [RelativePlacement]  TEXT(50);
				
CREATE TABLE IfcLocalTime (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLocalTime ADD COLUMN [HourComponent]  LONG;										
				
ALTER TABLE IfcLocalTime ADD COLUMN [MinuteComponent]  LONG;										
				
ALTER TABLE IfcLocalTime ADD COLUMN [SecondComponent]  DOUBLE;										
				
ALTER TABLE IfcLocalTime ADD COLUMN [Zone] TEXT(50);
				
ALTER TABLE IfcLocalTime ADD COLUMN [DaylightSavingOffset]  LONG;										
				
CREATE TABLE IfcLoop (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcMaintenanceRecord (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [ObjectType]  MEMO;										
					
CREATE TABLE IfcMaintenanceRecord_Records (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaintenanceRecord_Records ADD CONSTRAINT
	PK_IfcMaintenanceRecord_Records FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceRecord (oid);

CREATE TABLE IfcMaintenanceWorkOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [OrderNumber]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [IssuingDate] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [IssuedBy]  TEXT(50);
					
CREATE TABLE IfcMaintenanceWorkOrder_IssuedTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaintenanceWorkOrder_IssuedTo ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid);
	
CREATE TABLE IfcMaintenanceWorkOrder_AdditionalContacts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaintenanceWorkOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid);

CREATE TABLE IfcMaintenanceWorkOrder_Remarks (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMaintenanceWorkOrder_Remarks ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid);

ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [Signoff] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [BudgetSource] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ProductDescription]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ShortJobDescription]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [LongJobDescription]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [WorkTypeRequested]  MEMO;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ContractualType]  MEMO;										
				
CREATE TABLE IfcMaintenanceWorkOrder_IfNotAccomplished (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMaintenanceWorkOrder_IfNotAccomplished ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_IfNotAccomplished FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid);

ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [RequestedStartTime] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [RequestedFinishTime] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ActualStartTime] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ActualFinishTime] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [CostEstimate] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [WorkPlan] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [Status] TEXT(50);
				
CREATE TABLE IfcMaintenanceWorkOrder_WorkOrderRiskType (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMaintenanceWorkOrder_WorkOrderRiskType ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_WorkOrderRiskType FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid);
	
CREATE TABLE IfcMaintenanceWorkOrder_PerformedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaintenanceWorkOrder_PerformedBy ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_PerformedBy FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid);

ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ActualCost] TEXT(50);
				
CREATE TABLE IfcMaintenanceWorkOrder_SparesToolsEquipmentConsumables (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMaintenanceWorkOrder_SparesToolsEquipmentConsumables ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_SparesToolsEquipmentConsumables FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid);

ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [MaintenanceType] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [FaultPriority] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [LocationPriority] TEXT(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [AssetDowntime]  DOUBLE;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [ScheduledFrequency]  DOUBLE;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [RequiredResponseTime]  DOUBLE;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD COLUMN [LeadCraft]  MEMO;										
				
CREATE TABLE IfcManufacturerInformation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcManufacturerInformation ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcManufacturerInformation ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcManufacturerInformation ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcManufacturerInformation ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcManufacturerInformation ADD COLUMN [ModelLabel]  MEMO;										
				
ALTER TABLE IfcManufacturerInformation ADD COLUMN [ModelReference]  MEMO;										
				
ALTER TABLE IfcManufacturerInformation ADD COLUMN [Manufacturer] TEXT(50);
					
CREATE TABLE IfcManufacturerInformation_QuantityInformation (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcManufacturerInformation_QuantityInformation ADD CONSTRAINT
	PK_IfcManufacturerInformation_QuantityInformation FOREIGN KEY (pid)
	REFERENCES IfcManufacturerInformation (oid);

CREATE TABLE IfcMappedItem (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMappedItem ADD COLUMN [MappingSource] TEXT(50);
				
ALTER TABLE IfcMappedItem ADD COLUMN [MappingTarget] TEXT(50);
				
CREATE TABLE IfcMaterial (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaterial ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcMaterialClassificationRelationship (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcMaterialClassificationRelationship_MaterialClassifications (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaterialClassificationRelationship_MaterialClassifications ADD CONSTRAINT
	PK_IfcMaterialClassificationRelationship_MaterialClassifications FOREIGN KEY (pid)
	REFERENCES IfcMaterialClassificationRelationship (oid);

ALTER TABLE IfcMaterialClassificationRelationship ADD COLUMN [ClassifiedMaterial] TEXT(50);
				
CREATE TABLE IfcMaterialLayer (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaterialLayer ADD COLUMN [Material] TEXT(50);
				
ALTER TABLE IfcMaterialLayer ADD COLUMN [LayerThickness]  DOUBLE;										
				
ALTER TABLE IfcMaterialLayer ADD COLUMN [IsVentilated]  BIT;										
				
CREATE TABLE IfcMaterialLayerSet (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcMaterialLayerSet_MaterialLayers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaterialLayerSet_MaterialLayers ADD CONSTRAINT
	PK_IfcMaterialLayerSet_MaterialLayers FOREIGN KEY (pid)
	REFERENCES IfcMaterialLayerSet (oid);

ALTER TABLE IfcMaterialLayerSet ADD COLUMN [LayerSetName]  MEMO;										
				
CREATE TABLE IfcMaterialLayerSetUsage (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaterialLayerSetUsage ADD COLUMN [ForLayerSet] TEXT(50);
				
ALTER TABLE IfcMaterialLayerSetUsage ADD COLUMN [LayerSetDirection] TEXT(50);
				
ALTER TABLE IfcMaterialLayerSetUsage ADD COLUMN [DirectionSense] TEXT(50);
				
ALTER TABLE IfcMaterialLayerSetUsage ADD COLUMN [OffsetFromReferenceLine]  DOUBLE;										
				
CREATE TABLE IfcMaterialList (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcMaterialList_Materials (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaterialList_Materials ADD CONSTRAINT
	PK_IfcMaterialList_Materials FOREIGN KEY (pid)
	REFERENCES IfcMaterialList (oid);

CREATE TABLE IfcMeasureWithUnit (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcMeasureWithUnit_ValueComponent (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMeasureWithUnit_ValueComponent ADD CONSTRAINT
	PK_IfcMeasureWithUnit_ValueComponent FOREIGN KEY (pid)
	REFERENCES IfcMeasureWithUnit (oid);

ALTER TABLE IfcMeasureWithUnit ADD COLUMN [UnitComponent]  TEXT(50);
				
CREATE TABLE IfcMechanicalMaterialProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMechanicalMaterialProperties ADD COLUMN [Material] TEXT(50);
				
ALTER TABLE IfcMechanicalMaterialProperties ADD COLUMN [DynamicViscosity]  DOUBLE;										
				
CREATE TABLE IfcMetric (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMetric ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcMetric ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcMetric ADD COLUMN [ConstraintSource]  MEMO;										
				
ALTER TABLE IfcMetric ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcMetric ADD COLUMN [CreatingActor]  TEXT(50);
				
ALTER TABLE IfcMetric ADD COLUMN [CreationTime]  TEXT(50);
					
CREATE TABLE IfcMetric_Values (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMetric_Values ADD CONSTRAINT
	PK_IfcMetric_Values FOREIGN KEY (pid)
	REFERENCES IfcMetric (oid);

CREATE TABLE IfcMetricBenchmark (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMetricBenchmark ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [ConstraintSource]  MEMO;										
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [CreatingActor]  TEXT(50);
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [CreationTime]  TEXT(50);
					
CREATE TABLE IfcMetricBenchmark_Values (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMetricBenchmark_Values ADD CONSTRAINT
	PK_IfcMetricBenchmark_Values FOREIGN KEY (pid)
	REFERENCES IfcMetricBenchmark (oid);

ALTER TABLE IfcMetricBenchmark ADD COLUMN [Benchmark] TEXT(50);
				
CREATE TABLE IfcMetricValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMetricValue ADD COLUMN [DataType] TEXT(50);
				
ALTER TABLE IfcMetricValue ADD COLUMN [DataValue]  TEXT(50);
				
ALTER TABLE IfcMetricValue ADD COLUMN [ValueSource]  MEMO;										
				
CREATE TABLE IfcMonetaryUnit (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMonetaryUnit ADD COLUMN [Currency] TEXT(50);
				
CREATE TABLE IfcMove (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMove ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcMove ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMove ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcMove ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcMove ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcMove ADD COLUMN [Productivity] TEXT(50);
				
ALTER TABLE IfcMove ADD COLUMN [TaskId]  MEMO;										
				
CREATE TABLE IfcMove_WBSCode (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMove_WBSCode ADD CONSTRAINT
	PK_IfcMove_WBSCode FOREIGN KEY (pid)
	REFERENCES IfcMove (oid);

CREATE TABLE IfcMove_WBSSource (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMove_WBSSource ADD CONSTRAINT
	PK_IfcMove_WBSSource FOREIGN KEY (pid)
	REFERENCES IfcMove (oid);

ALTER TABLE IfcMove ADD COLUMN [Status] TEXT(50);
				
CREATE TABLE IfcMove_Milestones (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMove_Milestones ADD CONSTRAINT
	PK_IfcMove_Milestones FOREIGN KEY (pid)
	REFERENCES IfcMove (oid);

ALTER TABLE IfcMove ADD COLUMN [WorkMethod]  MEMO;										
				
ALTER TABLE IfcMove ADD COLUMN [InPlaceQuantity] TEXT(50);
				
ALTER TABLE IfcMove ADD COLUMN [EstimatedQuantity] TEXT(50);
				
ALTER TABLE IfcMove ADD COLUMN [BudgetQuantity] TEXT(50);
				
ALTER TABLE IfcMove ADD COLUMN [IsRootTask]  BIT;										
				
ALTER TABLE IfcMove ADD COLUMN [MoveFrom] TEXT(50);
				
ALTER TABLE IfcMove ADD COLUMN [MoveTo] TEXT(50);
					
CREATE TABLE IfcMove_MoveConstraints (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMove_MoveConstraints ADD CONSTRAINT
	PK_IfcMove_MoveConstraints FOREIGN KEY (pid)
	REFERENCES IfcMove (oid);

CREATE TABLE IfcMove_PunchList (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcMove_PunchList ADD CONSTRAINT
	PK_IfcMove_PunchList FOREIGN KEY (pid)
	REFERENCES IfcMove (oid);

CREATE TABLE IfcObjective (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcObjective ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcObjective ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcObjective ADD COLUMN [ConstraintSource]  MEMO;										
				
ALTER TABLE IfcObjective ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcObjective ADD COLUMN [CreatingActor]  TEXT(50);
				
ALTER TABLE IfcObjective ADD COLUMN [CreationTime]  TEXT(50);
				
ALTER TABLE IfcObjective ADD COLUMN [ObjectiveQualifier] TEXT(50);
					
CREATE TABLE IfcObjective_BenchmarkValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcObjective_BenchmarkValues ADD CONSTRAINT
	PK_IfcObjective_BenchmarkValues FOREIGN KEY (pid)
	REFERENCES IfcObjective (oid);
	
CREATE TABLE IfcObjective_ResultValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcObjective_ResultValues ADD CONSTRAINT
	PK_IfcObjective_ResultValues FOREIGN KEY (pid)
	REFERENCES IfcObjective (oid);

CREATE TABLE IfcOccupant (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOccupant ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcOccupant ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOccupant ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcOccupant ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcOccupant ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcOccupant ADD COLUMN [TheActor]  TEXT(50);
				
ALTER TABLE IfcOccupant ADD COLUMN [LeeseOrRentalDate] TEXT(50);
				
ALTER TABLE IfcOccupant ADD COLUMN [LeeseOrRentalPeriod]  DOUBLE;										
				
ALTER TABLE IfcOccupant ADD COLUMN [OccupationType] TEXT(50);
				
ALTER TABLE IfcOccupant ADD COLUMN [UnlimitedPeriod]  BYTE;										
				
CREATE TABLE IfcOffsetCurve2D (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOffsetCurve2D ADD COLUMN [BasisCurve] TEXT(50);
				
ALTER TABLE IfcOffsetCurve2D ADD COLUMN [Distance]  DOUBLE;										
				
ALTER TABLE IfcOffsetCurve2D ADD COLUMN [SelfIntersect]  BYTE;										
				
CREATE TABLE IfcOffsetCurve3D (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOffsetCurve3D ADD COLUMN [BasisCurve] TEXT(50);
				
ALTER TABLE IfcOffsetCurve3D ADD COLUMN [Distance]  DOUBLE;										
				
ALTER TABLE IfcOffsetCurve3D ADD COLUMN [SelfIntersect]  BYTE;										
				
ALTER TABLE IfcOffsetCurve3D ADD COLUMN [RefDirection] TEXT(50);
				
CREATE TABLE IfcOpeningElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOpeningElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcOpeningElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOpeningElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcOpeningElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcOpeningElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcOpeningElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcOpeningElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcOpeningElement ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcOpenShell (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcOpenShell_CfsFaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOpenShell_CfsFaces ADD CONSTRAINT
	PK_IfcOpenShell_CfsFaces FOREIGN KEY (pid)
	REFERENCES IfcOpenShell (oid);

CREATE TABLE IfcOpticalMaterialProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [Material] TEXT(50);
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [VisibleTransmittance]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [SolarTransmittance]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [ThermalIrTransmittance]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [ThermalIrEmissivityBack]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [ThermalIrEmissivityFront]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [VisibleReflectanceBack]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [VisibleReflectanceFront]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [SolarReflectanceFront]  DOUBLE;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD COLUMN [SolarReflectanceBack]  DOUBLE;										
				
CREATE TABLE IfcOrganization (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOrganization ADD COLUMN [Id]  MEMO;										
				
ALTER TABLE IfcOrganization ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcOrganization ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcOrganization_Roles (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOrganization_Roles ADD CONSTRAINT
	PK_IfcOrganization_Roles FOREIGN KEY (pid)
	REFERENCES IfcOrganization (oid);
	
CREATE TABLE IfcOrganization_Addresses (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOrganization_Addresses ADD CONSTRAINT
	PK_IfcOrganization_Addresses FOREIGN KEY (pid)
	REFERENCES IfcOrganization (oid);

CREATE TABLE IfcOrganizationRelationship (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOrganizationRelationship ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcOrganizationRelationship ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcOrganizationRelationship ADD COLUMN [RelatingOrganization] TEXT(50);
					
CREATE TABLE IfcOrganizationRelationship_RelatedOrganizations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOrganizationRelationship_RelatedOrganizations ADD CONSTRAINT
	PK_IfcOrganizationRelationship_RelatedOrganizations FOREIGN KEY (pid)
	REFERENCES IfcOrganizationRelationship (oid);

CREATE TABLE IfcOrientedEdge (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOrientedEdge ADD COLUMN [EdgeStart] TEXT(50);
				
ALTER TABLE IfcOrientedEdge ADD COLUMN [EdgeEnd] TEXT(50);
				
ALTER TABLE IfcOrientedEdge ADD COLUMN [EdgeElement] TEXT(50);
				
ALTER TABLE IfcOrientedEdge ADD COLUMN [Orientation]  BIT;										
				
CREATE TABLE IfcOutlet (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOutlet ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcOutlet ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOutlet ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcOutlet ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcOutlet ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcOutlet ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcOutlet ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcOutlet ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcOutlet ADD COLUMN [OutletType] TEXT(50);
				
CREATE TABLE IfcOwnerHistory (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOwnerHistory ADD COLUMN [OwningUser] TEXT(50);
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [OwningApplication] TEXT(50);
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [State] TEXT(50);
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [ChangeAction] TEXT(50);
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [LastModifiedDate]  LONG;										
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [LastModifyingUser] TEXT(50);
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [LastModifyingApplication] TEXT(50);
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [CreationDate]  LONG;										
				
CREATE TABLE IfcPath (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcPath_EdgeList (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPath_EdgeList ADD CONSTRAINT
	PK_IfcPath_EdgeList FOREIGN KEY (pid)
	REFERENCES IfcPath (oid);

CREATE TABLE IfcPermeableCoveringProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [OperationType] TEXT(50);
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [PanelPosition] TEXT(50);
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [FrameDepth]  DOUBLE;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [FrameThickness]  DOUBLE;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD COLUMN [ShapeAspectStyle] TEXT(50);
				
CREATE TABLE IfcPerson (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPerson ADD COLUMN [Id]  MEMO;										
				
ALTER TABLE IfcPerson ADD COLUMN [FamilyName]  MEMO;										
				
ALTER TABLE IfcPerson ADD COLUMN [GivenName]  MEMO;										
				
CREATE TABLE IfcPerson_MiddleNames (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPerson_MiddleNames ADD CONSTRAINT
	PK_IfcPerson_MiddleNames FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid);

CREATE TABLE IfcPerson_PrefixTitles (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPerson_PrefixTitles ADD CONSTRAINT
	PK_IfcPerson_PrefixTitles FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid);

CREATE TABLE IfcPerson_SuffixTitles (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPerson_SuffixTitles ADD CONSTRAINT
	PK_IfcPerson_SuffixTitles FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid);
	
CREATE TABLE IfcPerson_Roles (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPerson_Roles ADD CONSTRAINT
	PK_IfcPerson_Roles FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid);
	
CREATE TABLE IfcPerson_Addresses (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPerson_Addresses ADD CONSTRAINT
	PK_IfcPerson_Addresses FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid);

CREATE TABLE IfcPersonAndOrganization (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPersonAndOrganization ADD COLUMN [ThePerson] TEXT(50);
				
ALTER TABLE IfcPersonAndOrganization ADD COLUMN [TheOrganization] TEXT(50);
					
CREATE TABLE IfcPersonAndOrganization_Roles (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPersonAndOrganization_Roles ADD CONSTRAINT
	PK_IfcPersonAndOrganization_Roles FOREIGN KEY (pid)
	REFERENCES IfcPersonAndOrganization (oid);

CREATE TABLE IfcPlane (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPlane ADD COLUMN [Position] TEXT(50);
				
CREATE TABLE IfcPointLightSource (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcPointLightSource_Color (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcPointLightSource_Color ADD CONSTRAINT
	PK_IfcPointLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcPointLightSource (oid);

ALTER TABLE IfcPointLightSource ADD COLUMN [AmbientIntensity]  DOUBLE;										
				
ALTER TABLE IfcPointLightSource ADD COLUMN [Intensity]  DOUBLE;										
				
ALTER TABLE IfcPointLightSource ADD COLUMN [InContext] TEXT(50);
				
ALTER TABLE IfcPointLightSource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPointLightSource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcPointLightSource ADD COLUMN [Location] TEXT(50);
				
CREATE TABLE IfcPointLightSource_Attenuation (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcPointLightSource_Attenuation ADD CONSTRAINT
	PK_IfcPointLightSource_Attenuation FOREIGN KEY (pid)
	REFERENCES IfcPointLightSource (oid);

CREATE TABLE IfcPolygonalBoundedHalfSpace (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD COLUMN [BaseSurface] TEXT(50);
				
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD COLUMN [AgreementFlag]  BIT;										
				
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD COLUMN [PolygonalBoundary] TEXT(50);
				
CREATE TABLE IfcPolyline (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcPolyline_Points (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPolyline_Points ADD CONSTRAINT
	PK_IfcPolyline_Points FOREIGN KEY (pid)
	REFERENCES IfcPolyline (oid);

CREATE TABLE IfcPolyLoop (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcPolyLoop_Polygon (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPolyLoop_Polygon ADD CONSTRAINT
	PK_IfcPolyLoop_Polygon FOREIGN KEY (pid)
	REFERENCES IfcPolyLoop (oid);

CREATE TABLE IfcPostalAddress (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPostalAddress ADD COLUMN [Purpose] TEXT(50);
				
ALTER TABLE IfcPostalAddress ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcPostalAddress ADD COLUMN [UserDefinedPurpose]  MEMO;										
				
ALTER TABLE IfcPostalAddress ADD COLUMN [InternalLocation]  MEMO;										
				
CREATE TABLE IfcPostalAddress_AddressLines (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPostalAddress_AddressLines ADD CONSTRAINT
	PK_IfcPostalAddress_AddressLines FOREIGN KEY (pid)
	REFERENCES IfcPostalAddress (oid);

ALTER TABLE IfcPostalAddress ADD COLUMN [PostalBox]  MEMO;										
				
ALTER TABLE IfcPostalAddress ADD COLUMN [Town]  MEMO;										
				
ALTER TABLE IfcPostalAddress ADD COLUMN [Region]  MEMO;										
				
ALTER TABLE IfcPostalAddress ADD COLUMN [PostalCode]  MEMO;										
				
ALTER TABLE IfcPostalAddress ADD COLUMN [Country]  MEMO;										
				
CREATE TABLE IfcPresentationLightSource (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcPresentationLightSource_Color (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcPresentationLightSource_Color ADD CONSTRAINT
	PK_IfcPresentationLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcPresentationLightSource (oid);

ALTER TABLE IfcPresentationLightSource ADD COLUMN [AmbientIntensity]  DOUBLE;										
				
ALTER TABLE IfcPresentationLightSource ADD COLUMN [Intensity]  DOUBLE;										
				
ALTER TABLE IfcPresentationLightSource ADD COLUMN [InContext] TEXT(50);
				
ALTER TABLE IfcPresentationLightSource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPresentationLightSource ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcProductDefinitionShape (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProductDefinitionShape ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcProductDefinitionShape ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcProductDefinitionShape_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProductDefinitionShape_Representations ADD CONSTRAINT
	PK_IfcProductDefinitionShape_Representations FOREIGN KEY (pid)
	REFERENCES IfcProductDefinitionShape (oid);

CREATE TABLE IfcProductRepresentation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProductRepresentation ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcProductRepresentation ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcProductRepresentation_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProductRepresentation_Representations ADD CONSTRAINT
	PK_IfcProductRepresentation_Representations FOREIGN KEY (pid)
	REFERENCES IfcProductRepresentation (oid);

CREATE TABLE IfcProject (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProject ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProject ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [LongName]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [Phase]  MEMO;										
					
CREATE TABLE IfcProject_RepresentationContexts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProject_RepresentationContexts ADD CONSTRAINT
	PK_IfcProject_RepresentationContexts FOREIGN KEY (pid)
	REFERENCES IfcProject (oid);

ALTER TABLE IfcProject ADD COLUMN [UnitsInContext] TEXT(50);
				
CREATE TABLE IfcPropertyBoundedValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertyBoundedValue ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPropertyBoundedValue ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcPropertyBoundedValue_UpperBoundValue (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPropertyBoundedValue_UpperBoundValue ADD CONSTRAINT
	PK_IfcPropertyBoundedValue_UpperBoundValue FOREIGN KEY (pid)
	REFERENCES IfcPropertyBoundedValue (oid);
	
CREATE TABLE IfcPropertyBoundedValue_LowerBoundValue (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPropertyBoundedValue_LowerBoundValue ADD CONSTRAINT
	PK_IfcPropertyBoundedValue_LowerBoundValue FOREIGN KEY (pid)
	REFERENCES IfcPropertyBoundedValue (oid);

ALTER TABLE IfcPropertyBoundedValue ADD COLUMN [Unit]  TEXT(50);
				
CREATE TABLE IfcPropertyEnumeratedValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertyEnumeratedValue ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPropertyEnumeratedValue ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcPropertyEnumeratedValue_EnumerationValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPropertyEnumeratedValue_EnumerationValues ADD CONSTRAINT
	PK_IfcPropertyEnumeratedValue_EnumerationValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyEnumeratedValue (oid);

ALTER TABLE IfcPropertyEnumeratedValue ADD COLUMN [EnumerationReference] TEXT(50);
				
CREATE TABLE IfcPropertyEnumeration (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertyEnumeration ADD COLUMN [Name]  MEMO;										
					
CREATE TABLE IfcPropertyEnumeration_EnumerationValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPropertyEnumeration_EnumerationValues ADD CONSTRAINT
	PK_IfcPropertyEnumeration_EnumerationValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyEnumeration (oid);

ALTER TABLE IfcPropertyEnumeration ADD COLUMN [Unit]  TEXT(50);
				
CREATE TABLE IfcPropertyReferenceValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertyReferenceValue ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPropertyReferenceValue ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcPropertyReferenceValue ADD COLUMN [UsageName]  MEMO;										
				
ALTER TABLE IfcPropertyReferenceValue ADD COLUMN [PropertyReference]  TEXT(50);
				
CREATE TABLE IfcPropertySet (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertySet ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcPropertySet ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPropertySet ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPropertySet ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcPropertySet_HasProperties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPropertySet_HasProperties ADD CONSTRAINT
	PK_IfcPropertySet_HasProperties FOREIGN KEY (pid)
	REFERENCES IfcPropertySet (oid);

CREATE TABLE IfcPropertySingleValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertySingleValue ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPropertySingleValue ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcPropertySingleValue_NominalValue (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPropertySingleValue_NominalValue ADD CONSTRAINT
	PK_IfcPropertySingleValue_NominalValue FOREIGN KEY (pid)
	REFERENCES IfcPropertySingleValue (oid);

ALTER TABLE IfcPropertySingleValue ADD COLUMN [Unit]  TEXT(50);
				
CREATE TABLE IfcPropertyTableValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertyTableValue ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPropertyTableValue ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcPropertyTableValue_DefiningValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPropertyTableValue_DefiningValues ADD CONSTRAINT
	PK_IfcPropertyTableValue_DefiningValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyTableValue (oid);
	
CREATE TABLE IfcPropertyTableValue_DefinedValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPropertyTableValue_DefinedValues ADD CONSTRAINT
	PK_IfcPropertyTableValue_DefinedValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyTableValue (oid);

ALTER TABLE IfcPropertyTableValue ADD COLUMN [Expression]  MEMO;										
				
ALTER TABLE IfcPropertyTableValue ADD COLUMN [DefiningUnit]  TEXT(50);
				
ALTER TABLE IfcPropertyTableValue ADD COLUMN [DefinedUnit]  TEXT(50);
				
CREATE TABLE IfcProxy (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProxy ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcProxy ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProxy ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcProxy ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcProxy ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcProxy ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcProxy ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcProxy ADD COLUMN [ProxyType] TEXT(50);
				
ALTER TABLE IfcProxy ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcPump (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPump ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcPump ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPump ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcPump ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcPump ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcPump ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [ImpellerDiameter]  DOUBLE;										
				
ALTER TABLE IfcPump ADD COLUMN [PumpType] TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [NetPositiveSuctionHead]  DOUBLE;										
				
ALTER TABLE IfcPump ADD COLUMN [ImpellerSealMaterial]  TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [PumpBaseType] TEXT(50);
				
ALTER TABLE IfcPump ADD COLUMN [MotorDriveType] TEXT(50);
				
CREATE TABLE IfcPurchaseOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPurchaseOrder ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [OrderNumber]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [IssuingDate] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [IssuedBy]  TEXT(50);
					
CREATE TABLE IfcPurchaseOrder_IssuedTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPurchaseOrder_IssuedTo ADD CONSTRAINT
	PK_IfcPurchaseOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcPurchaseOrder (oid);
	
CREATE TABLE IfcPurchaseOrder_AdditionalContacts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPurchaseOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcPurchaseOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcPurchaseOrder (oid);

CREATE TABLE IfcPurchaseOrder_Remarks (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcPurchaseOrder_Remarks ADD CONSTRAINT
	PK_IfcPurchaseOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcPurchaseOrder (oid);

ALTER TABLE IfcPurchaseOrder ADD COLUMN [Signoff] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [BudgetSource] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [RequiredDate] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [ScheduledDate] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [ActualDate] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [IsFOB]  BIT;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [ShipMethod]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [PurchaseItems] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [TotalCost] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [Status] TEXT(50);
				
CREATE TABLE IfcQuantityArea (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcQuantityArea ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcQuantityArea ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcQuantityArea ADD COLUMN [Unit] TEXT(50);
				
ALTER TABLE IfcQuantityArea ADD COLUMN [AreaValue]  DOUBLE;										
				
CREATE TABLE IfcQuantityCount (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcQuantityCount ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcQuantityCount ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcQuantityCount ADD COLUMN [Unit] TEXT(50);
				
ALTER TABLE IfcQuantityCount ADD COLUMN [CountValue]  DOUBLE;										
				
CREATE TABLE IfcQuantityLength (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcQuantityLength ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcQuantityLength ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcQuantityLength ADD COLUMN [Unit] TEXT(50);
				
ALTER TABLE IfcQuantityLength ADD COLUMN [LengthValue]  DOUBLE;										
				
CREATE TABLE IfcQuantityVolume (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcQuantityVolume ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcQuantityVolume ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcQuantityVolume ADD COLUMN [Unit] TEXT(50);
				
ALTER TABLE IfcQuantityVolume ADD COLUMN [VolumeValue]  DOUBLE;										
				
CREATE TABLE IfcQuantityWeight (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcQuantityWeight ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcQuantityWeight ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcQuantityWeight ADD COLUMN [Unit] TEXT(50);
				
ALTER TABLE IfcQuantityWeight ADD COLUMN [WeightValue]  DOUBLE;										
				
CREATE TABLE IfcRailing (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRailing ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRailing ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRailing ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRailing ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRailing ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcRailing ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcRailing ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcRailing ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcRailing ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcRamp (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRamp ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRamp ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRamp ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRamp ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRamp ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcRamp ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcRamp ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcRamp ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcRamp ADD COLUMN [ShapeType] TEXT(50);
				
CREATE TABLE IfcRampFlight (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRampFlight ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRampFlight ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcRampFlight ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcRampFlight ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcRectangleProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [XDim]  DOUBLE;										
				
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [YDim]  DOUBLE;										
				
CREATE TABLE IfcRectangularTrimmedSurface (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRectangularTrimmedSurface ADD COLUMN [BasisSurface] TEXT(50);
				
ALTER TABLE IfcRectangularTrimmedSurface ADD COLUMN [U1]  DOUBLE;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD COLUMN [V1]  DOUBLE;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD COLUMN [U2]  DOUBLE;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD COLUMN [V2]  DOUBLE;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD COLUMN [Usense]  BIT;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD COLUMN [Vsense]  BIT;										
				
CREATE TABLE IfcReferenceEdge (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcReferenceEdge ADD COLUMN [Placement]  TEXT(50);
				
ALTER TABLE IfcReferenceEdge ADD COLUMN [Edge] TEXT(50);
				
CREATE TABLE IfcReferenceFace (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcReferenceFace ADD COLUMN [Placement]  TEXT(50);
				
ALTER TABLE IfcReferenceFace ADD COLUMN [Face] TEXT(50);
				
CREATE TABLE IfcReferencesCostDocument (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcReferencesCostDocument ADD COLUMN [ReferencedDocument]  TEXT(50);
					
CREATE TABLE IfcReferencesCostDocument_ReferencingCosts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcReferencesCostDocument_ReferencingCosts ADD CONSTRAINT
	PK_IfcReferencesCostDocument_ReferencingCosts FOREIGN KEY (pid)
	REFERENCES IfcReferencesCostDocument (oid);
	
CREATE TABLE IfcReferencesCostDocument_ReferencingModifiers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcReferencesCostDocument_ReferencingModifiers ADD CONSTRAINT
	PK_IfcReferencesCostDocument_ReferencingModifiers FOREIGN KEY (pid)
	REFERENCES IfcReferencesCostDocument (oid);

CREATE TABLE IfcReferenceVertex (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcReferenceVertex ADD COLUMN [Placement]  TEXT(50);
				
ALTER TABLE IfcReferenceVertex ADD COLUMN [Vertex] TEXT(50);
				
CREATE TABLE IfcRelAggregates (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAggregates ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAggregates ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAggregates ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAggregates ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelAggregates ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelAggregates_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAggregates_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAggregates_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAggregates (oid);

CREATE TABLE IfcRelAggregatesResources (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAggregatesResources ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAggregatesResources ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAggregatesResources ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAggregatesResources ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelAggregatesResources ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelAggregatesResources_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAggregatesResources_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAggregatesResources_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAggregatesResources (oid);

ALTER TABLE IfcRelAggregatesResources ADD COLUMN [RequiredQuantity] TEXT(50);
				
ALTER TABLE IfcRelAggregatesResources ADD COLUMN [ConversionRate] TEXT(50);
				
CREATE TABLE IfcRelAssignsFMStandard (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsFMStandard ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsFMStandard ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD COLUMN [JobFunction]  MEMO;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD COLUMN [RelatingStandard]  TEXT(50);
					
CREATE TABLE IfcRelAssignsFMStandard_RelatedPersons (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsFMStandard_RelatedPersons ADD CONSTRAINT
	PK_IfcRelAssignsFMStandard_RelatedPersons FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsFMStandard (oid);

CREATE TABLE IfcRelAssignsTasks (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsTasks ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsTasks ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsTasks ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsTasks ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssignsTasks_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsTasks_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsTasks_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsTasks (oid);

ALTER TABLE IfcRelAssignsTasks ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelAssignsTasks ADD COLUMN [RelatingControl] TEXT(50);
				
ALTER TABLE IfcRelAssignsTasks ADD COLUMN [TimeForTask] TEXT(50);
				
ALTER TABLE IfcRelAssignsTasks ADD COLUMN [Milestone] TEXT(50);
				
CREATE TABLE IfcRelAssignsToActor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsToActor ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsToActor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsToActor ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsToActor ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssignsToActor_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsToActor_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToActor_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToActor (oid);

ALTER TABLE IfcRelAssignsToActor ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelAssignsToActor ADD COLUMN [RelatingActor] TEXT(50);
				
ALTER TABLE IfcRelAssignsToActor ADD COLUMN [ActingRole] TEXT(50);
				
CREATE TABLE IfcRelAssignsToControl (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsToControl ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsToControl ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsToControl ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsToControl ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssignsToControl_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsToControl_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToControl_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToControl (oid);

ALTER TABLE IfcRelAssignsToControl ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelAssignsToControl ADD COLUMN [RelatingControl] TEXT(50);
				
CREATE TABLE IfcRelAssignsToGroup (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsToGroup ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsToGroup ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsToGroup ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsToGroup ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssignsToGroup_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsToGroup_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToGroup_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToGroup (oid);

ALTER TABLE IfcRelAssignsToGroup ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelAssignsToGroup ADD COLUMN [RelatingGroup] TEXT(50);
				
CREATE TABLE IfcRelAssignsToProcess (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsToProcess ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsToProcess ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsToProcess ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsToProcess ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssignsToProcess_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsToProcess_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToProcess_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToProcess (oid);

ALTER TABLE IfcRelAssignsToProcess ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelAssignsToProcess ADD COLUMN [RelatingProcess] TEXT(50);
				
ALTER TABLE IfcRelAssignsToProcess ADD COLUMN [QuantityInProcess] TEXT(50);
				
CREATE TABLE IfcRelAssignsToProduct (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsToProduct ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsToProduct ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsToProduct ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsToProduct ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssignsToProduct_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsToProduct_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToProduct_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToProduct (oid);

ALTER TABLE IfcRelAssignsToProduct ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelAssignsToProduct ADD COLUMN [RelatingProduct] TEXT(50);
				
CREATE TABLE IfcRelAssignsToResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsToResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssignsToResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsToResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsToResource ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssignsToResource_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsToResource_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToResource_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToResource (oid);

ALTER TABLE IfcRelAssignsToResource ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelAssignsToResource ADD COLUMN [RelatingResource] TEXT(50);
				
CREATE TABLE IfcRelAssociates (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssociates ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssociates ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssociates ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssociates ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssociates_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssociates_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociates_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociates (oid);

CREATE TABLE IfcRelAssociatesClassification (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssociatesClassification ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssociatesClassification ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssociatesClassification ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssociatesClassification ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssociatesClassification_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssociatesClassification_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesClassification_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesClassification (oid);

ALTER TABLE IfcRelAssociatesClassification ADD COLUMN [RelatingClassification]  TEXT(50);
				
CREATE TABLE IfcRelAssociatesDocument (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssociatesDocument ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssociatesDocument ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssociatesDocument ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssociatesDocument ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssociatesDocument_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssociatesDocument_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesDocument_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesDocument (oid);

ALTER TABLE IfcRelAssociatesDocument ADD COLUMN [RelatingDocument]  TEXT(50);
				
CREATE TABLE IfcRelAssociatesLibrary (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssociatesLibrary ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssociatesLibrary ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssociatesLibrary ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssociatesLibrary ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssociatesLibrary_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssociatesLibrary_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesLibrary_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesLibrary (oid);

ALTER TABLE IfcRelAssociatesLibrary ADD COLUMN [RelatingLibrary]  TEXT(50);
				
CREATE TABLE IfcRelAssociatesMaterial (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssociatesMaterial ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelAssociatesMaterial ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssociatesMaterial ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssociatesMaterial ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelAssociatesMaterial_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssociatesMaterial_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesMaterial_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesMaterial (oid);

ALTER TABLE IfcRelAssociatesMaterial ADD COLUMN [RelatingMaterial]  TEXT(50);
				
CREATE TABLE IfcRelConnectsElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelConnectsElements ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [ConnectionGeometry] TEXT(50);
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [RelatingElement] TEXT(50);
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [RelatedElement] TEXT(50);
				
CREATE TABLE IfcRelConnectsPathElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [ConnectionGeometry] TEXT(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [RelatingElement] TEXT(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [RelatedElement] TEXT(50);
				
CREATE TABLE IfcRelConnectsPathElements_RelatingPriorities (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	IntegerValue LONG
);
ALTER TABLE IfcRelConnectsPathElements_RelatingPriorities ADD CONSTRAINT
	PK_IfcRelConnectsPathElements_RelatingPriorities FOREIGN KEY (pid)
	REFERENCES IfcRelConnectsPathElements (oid);

CREATE TABLE IfcRelConnectsPathElements_RelatedPriorities (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	IntegerValue LONG
);
ALTER TABLE IfcRelConnectsPathElements_RelatedPriorities ADD CONSTRAINT
	PK_IfcRelConnectsPathElements_RelatedPriorities FOREIGN KEY (pid)
	REFERENCES IfcRelConnectsPathElements (oid);

ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [RelatedConnectionType] TEXT(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [RelatingConnectionType] TEXT(50);
				
CREATE TABLE IfcRelConnectsPorts (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [ConnectionGeometry] TEXT(50);
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [RelatingElement] TEXT(50);
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [RelatedElement] TEXT(50);
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [FlowDirection] TEXT(50);
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [PortConnectionType] TEXT(50);
				
CREATE TABLE IfcRelContainedInSpatialStructure (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelContainedInSpatialStructure ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelContainedInSpatialStructure ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelContainedInSpatialStructure ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelContainedInSpatialStructure ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelContainedInSpatialStructure_RelatedElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelContainedInSpatialStructure_RelatedElements ADD CONSTRAINT
	PK_IfcRelContainedInSpatialStructure_RelatedElements FOREIGN KEY (pid)
	REFERENCES IfcRelContainedInSpatialStructure (oid);

ALTER TABLE IfcRelContainedInSpatialStructure ADD COLUMN [RelatingStructure] TEXT(50);
				
CREATE TABLE IfcRelCostsObjects (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelCostsObjects ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelCostsObjects_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelCostsObjects_RelatedObjects ADD CONSTRAINT
	PK_IfcRelCostsObjects_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelCostsObjects (oid);

ALTER TABLE IfcRelCostsObjects ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [RelatingControl] TEXT(50);
				
CREATE TABLE IfcRelCoversBldgElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [RelatingBuildingElement] TEXT(50);
					
CREATE TABLE IfcRelCoversBldgElements_RelatedCoverings (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelCoversBldgElements_RelatedCoverings ADD CONSTRAINT
	PK_IfcRelCoversBldgElements_RelatedCoverings FOREIGN KEY (pid)
	REFERENCES IfcRelCoversBldgElements (oid);

CREATE TABLE IfcRelDefinesByProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelDefinesByProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelDefinesByProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelDefinesByProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelDefinesByProperties ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelDefinesByProperties_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelDefinesByProperties_RelatedObjects ADD CONSTRAINT
	PK_IfcRelDefinesByProperties_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelDefinesByProperties (oid);

ALTER TABLE IfcRelDefinesByProperties ADD COLUMN [RelatingPropertyDefinition] TEXT(50);
				
CREATE TABLE IfcRelDefinesByType (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelDefinesByType ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelDefinesByType ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelDefinesByType ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelDefinesByType ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelDefinesByType_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelDefinesByType_RelatedObjects ADD CONSTRAINT
	PK_IfcRelDefinesByType_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelDefinesByType (oid);

ALTER TABLE IfcRelDefinesByType ADD COLUMN [RelatingType] TEXT(50);
				
CREATE TABLE IfcRelFillsElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelFillsElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [RelatingOpeningElement] TEXT(50);
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [RelatedBuildingElement] TEXT(50);
				
CREATE TABLE IfcRelFlowControlElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelFlowControlElements ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelFlowControlElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelFlowControlElements ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelFlowControlElements ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelFlowControlElements_RelatedControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelFlowControlElements_RelatedControlElements ADD CONSTRAINT
	PK_IfcRelFlowControlElements_RelatedControlElements FOREIGN KEY (pid)
	REFERENCES IfcRelFlowControlElements (oid);

ALTER TABLE IfcRelFlowControlElements ADD COLUMN [RelatingFlowElement] TEXT(50);
				
CREATE TABLE IfcRelInteractionRequirements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [DailyInteraction]  DOUBLE;										
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [ImportanceRating]  DOUBLE;										
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [LocationOfInteraction] TEXT(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [RelatingActor] TEXT(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [RelatedActor] TEXT(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [RelatedSpaceProgram] TEXT(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD COLUMN [RelatingSpaceProgram] TEXT(50);
				
CREATE TABLE IfcRelMaintenanceEvent (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelMaintenanceEvent ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelMaintenanceEvent ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelMaintenanceEvent ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelMaintenanceEvent ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelMaintenanceEvent_RelatedAssets (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelMaintenanceEvent_RelatedAssets ADD CONSTRAINT
	PK_IfcRelMaintenanceEvent_RelatedAssets FOREIGN KEY (pid)
	REFERENCES IfcRelMaintenanceEvent (oid);

ALTER TABLE IfcRelMaintenanceEvent ADD COLUMN [RelatingWorkOrder] TEXT(50);
				
CREATE TABLE IfcRelNests (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNests ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelNests ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNests ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelNests ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelNests ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNests_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNests_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNests_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNests (oid);

CREATE TABLE IfcRelOccupiesSpaces (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelOccupiesSpaces_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelOccupiesSpaces_RelatedObjects ADD CONSTRAINT
	PK_IfcRelOccupiesSpaces_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelOccupiesSpaces (oid);

ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [RelatingActor] TEXT(50);
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [ActingRole] TEXT(50);
				
CREATE TABLE IfcRelOverridesProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelOverridesProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelOverridesProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelOverridesProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelOverridesProperties ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelOverridesProperties_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelOverridesProperties_RelatedObjects ADD CONSTRAINT
	PK_IfcRelOverridesProperties_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelOverridesProperties (oid);

ALTER TABLE IfcRelOverridesProperties ADD COLUMN [RelatingPropertyDefinition] TEXT(50);
					
CREATE TABLE IfcRelOverridesProperties_OverridingProperties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelOverridesProperties_OverridingProperties ADD CONSTRAINT
	PK_IfcRelOverridesProperties_OverridingProperties FOREIGN KEY (pid)
	REFERENCES IfcRelOverridesProperties (oid);

CREATE TABLE IfcRelSequence (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelSequence ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelSequence ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelSequence ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelSequence ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelSequence ADD COLUMN [RelatingProcess] TEXT(50);
				
ALTER TABLE IfcRelSequence ADD COLUMN [RelatedProcess] TEXT(50);
				
ALTER TABLE IfcRelSequence ADD COLUMN [TimeLag]  DOUBLE;										
				
ALTER TABLE IfcRelSequence ADD COLUMN [SequenceType] TEXT(50);
				
CREATE TABLE IfcRelServicesBuildings (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [RelatingSystem] TEXT(50);
					
CREATE TABLE IfcRelServicesBuildings_RelatedBuildings (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelServicesBuildings_RelatedBuildings ADD CONSTRAINT
	PK_IfcRelServicesBuildings_RelatedBuildings FOREIGN KEY (pid)
	REFERENCES IfcRelServicesBuildings (oid);

CREATE TABLE IfcRelSpaceBoundary (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [RelatingSpace] TEXT(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [RelatedBuildingElement] TEXT(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [ConnectionGeometry] TEXT(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [PhysicalOrVirtualBoundary] TEXT(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD COLUMN [InternalOrExternalBoundary] TEXT(50);
				
CREATE TABLE IfcRelUsesResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelUsesResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcRelUsesResource_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelUsesResource_RelatedObjects ADD CONSTRAINT
	PK_IfcRelUsesResource_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelUsesResource (oid);

ALTER TABLE IfcRelUsesResource ADD COLUMN [RelatedObjectsType] TEXT(50);
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [RelatingResource] TEXT(50);
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [Duration]  DOUBLE;										
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [Quantity] TEXT(50);
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [ProductivityConversionRate] TEXT(50);
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [ConverterMultiplierOrDivider] TEXT(50);
					
CREATE TABLE IfcRelUsesResource_ResourceUseCosts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelUsesResource_ResourceUseCosts ADD CONSTRAINT
	PK_IfcRelUsesResource_ResourceUseCosts FOREIGN KEY (pid)
	REFERENCES IfcRelUsesResource (oid);

ALTER TABLE IfcRelUsesResource ADD COLUMN [WasteFactor]  DOUBLE;										
				
CREATE TABLE IfcRelVoidsElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelVoidsElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [RelatingBuildingElement] TEXT(50);
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [RelatedOpeningElement] TEXT(50);
				
CREATE TABLE IfcRepresentation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRepresentation ADD COLUMN [ContextOfItems] TEXT(50);
				
ALTER TABLE IfcRepresentation ADD COLUMN [RepresentationIdentifier]  MEMO;										
				
ALTER TABLE IfcRepresentation ADD COLUMN [RepresentationType]  MEMO;										
					
CREATE TABLE IfcRepresentation_Items (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRepresentation_Items ADD CONSTRAINT
	PK_IfcRepresentation_Items FOREIGN KEY (pid)
	REFERENCES IfcRepresentation (oid);

CREATE TABLE IfcRepresentationContext (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRepresentationContext ADD COLUMN [ContextIdentifier]  MEMO;										
				
ALTER TABLE IfcRepresentationContext ADD COLUMN [ContextType]  MEMO;										
				
CREATE TABLE IfcRepresentationMap (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRepresentationMap ADD COLUMN [MappingOrigin]  TEXT(50);
				
ALTER TABLE IfcRepresentationMap ADD COLUMN [MappedRepresentation] TEXT(50);
				
CREATE TABLE IfcRevolvedAreaSolid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRevolvedAreaSolid ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcRevolvedAreaSolid ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcRevolvedAreaSolid ADD COLUMN [Axis] TEXT(50);
				
ALTER TABLE IfcRevolvedAreaSolid ADD COLUMN [Angle]  DOUBLE;										
				
CREATE TABLE IfcRoof (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRoof ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcRoof ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRoof ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRoof ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRoof ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcRoof ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcRoof ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcRoof ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcRoof ADD COLUMN [ShapeType] TEXT(50);
				
CREATE TABLE IfcRoundedRectangleProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRoundedRectangleProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD COLUMN [XDim]  DOUBLE;										
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD COLUMN [YDim]  DOUBLE;										
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD COLUMN [RoundingRadius]  DOUBLE;										
				
CREATE TABLE IfcSanitaryTerminal (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcSanitaryTerminal ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcScheduleTimeControl (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [ActualStart] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [EarlyStart] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [LateStart] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [ScheduleStart] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [ActualFinish] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [EarlyFinish] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [LateFinish] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [ScheduleFinish] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [ScheduleDuration]  DOUBLE;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [ActualDuration]  DOUBLE;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [RemainingTime]  DOUBLE;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [FreeFloat]  DOUBLE;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [TotalFloat]  DOUBLE;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [IsCritical]  BIT;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [StatusTime] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [StartFloat]  DOUBLE;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [FinishFloat]  DOUBLE;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [Completion]  DOUBLE;										
				
CREATE TABLE IfcSectionedSpine (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSectionedSpine ADD COLUMN [SpineCurve] TEXT(50);
					
CREATE TABLE IfcSectionedSpine_CrossSections (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSectionedSpine_CrossSections ADD CONSTRAINT
	PK_IfcSectionedSpine_CrossSections FOREIGN KEY (pid)
	REFERENCES IfcSectionedSpine (oid);
	
CREATE TABLE IfcSectionedSpine_CrossSectionPositions (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSectionedSpine_CrossSectionPositions ADD CONSTRAINT
	PK_IfcSectionedSpine_CrossSectionPositions FOREIGN KEY (pid)
	REFERENCES IfcSectionedSpine (oid);

CREATE TABLE IfcSensor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSensor ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSensor ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcSensor ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcSensor ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [ControlElementId]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcShapeAspect (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcShapeAspect_ShapeRepresentations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcShapeAspect_ShapeRepresentations ADD CONSTRAINT
	PK_IfcShapeAspect_ShapeRepresentations FOREIGN KEY (pid)
	REFERENCES IfcShapeAspect (oid);

ALTER TABLE IfcShapeAspect ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcShapeAspect ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcShapeAspect ADD COLUMN [ProductDefinitional]  BYTE;										
				
ALTER TABLE IfcShapeAspect ADD COLUMN [PartOfProductDefinitionShape] TEXT(50);
				
CREATE TABLE IfcShapeRepresentation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcShapeRepresentation ADD COLUMN [ContextOfItems] TEXT(50);
				
ALTER TABLE IfcShapeRepresentation ADD COLUMN [RepresentationIdentifier]  MEMO;										
				
ALTER TABLE IfcShapeRepresentation ADD COLUMN [RepresentationType]  MEMO;										
					
CREATE TABLE IfcShapeRepresentation_Items (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcShapeRepresentation_Items ADD CONSTRAINT
	PK_IfcShapeRepresentation_Items FOREIGN KEY (pid)
	REFERENCES IfcShapeRepresentation (oid);

CREATE TABLE IfcShellBasedSurfaceModel (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcShellBasedSurfaceModel_SbsmBoundary (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcShellBasedSurfaceModel_SbsmBoundary ADD CONSTRAINT
	PK_IfcShellBasedSurfaceModel_SbsmBoundary FOREIGN KEY (pid)
	REFERENCES IfcShellBasedSurfaceModel (oid);

CREATE TABLE IfcSite (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSite ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSite ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSite ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSite ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSite ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSite ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcSite ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcSite ADD COLUMN [LongName]  MEMO;										
				
ALTER TABLE IfcSite ADD COLUMN [CompositionType] TEXT(50);
				
CREATE TABLE IfcSite_RefLatitude (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	IntegerValue LONG
);
ALTER TABLE IfcSite_RefLatitude ADD CONSTRAINT
	PK_IfcSite_RefLatitude FOREIGN KEY (pid)
	REFERENCES IfcSite (oid);

CREATE TABLE IfcSite_RefLongitude (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	IntegerValue LONG
);
ALTER TABLE IfcSite_RefLongitude ADD CONSTRAINT
	PK_IfcSite_RefLongitude FOREIGN KEY (pid)
	REFERENCES IfcSite (oid);

ALTER TABLE IfcSite ADD COLUMN [RefElevation]  DOUBLE;										
				
ALTER TABLE IfcSite ADD COLUMN [LandTitleNumber]  MEMO;										
				
ALTER TABLE IfcSite ADD COLUMN [SiteAddress] TEXT(50);
				
CREATE TABLE IfcSIUnit (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSIUnit ADD COLUMN [Dimensions] TEXT(50);
				
ALTER TABLE IfcSIUnit ADD COLUMN [UnitType] TEXT(50);
				
ALTER TABLE IfcSIUnit ADD COLUMN [Prefix] TEXT(50);
				
ALTER TABLE IfcSIUnit ADD COLUMN [Name] TEXT(50);
				
CREATE TABLE IfcSlab (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSlab ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSlab ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSlab ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSlab ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSlab ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcSlab ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcSpace (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpace ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpace ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcSpace ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcSpace ADD COLUMN [LongName]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [CompositionType] TEXT(50);
				
ALTER TABLE IfcSpace ADD COLUMN [InteriorOrExteriorSpace] TEXT(50);
				
ALTER TABLE IfcSpace ADD COLUMN [ElevationWithFlooring]  DOUBLE;										
				
CREATE TABLE IfcSpaceProgram (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpaceProgram ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [SpaceProgramIdentifier]  MEMO;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [MaxRequiredArea]  DOUBLE;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [MinRequiredArea]  DOUBLE;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [RequestedLocation] TEXT(50);
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [MinEstimatedCost] TEXT(50);
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [MaxEstimatedCost] TEXT(50);
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [StandardRequiredArea]  DOUBLE;										
				
CREATE TABLE IfcSpaceProgramGroup (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [RequiredGroupArea]  DOUBLE;										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [GroupRole]  MEMO;										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [GroupAssignment]  TEXT(50);
				
CREATE TABLE IfcSpaceThermalLoad (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [ApplicableValueRatio]  DOUBLE;										
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [ThermalLoadSource] TEXT(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [RequirementOrCriteria] TEXT(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [ConstantLoad]  BIT;										
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [LossOrGain] TEXT(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [SourceDescription]  MEMO;										
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [MaximumValue] TEXT(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD COLUMN [MinimumValue] TEXT(50);
				
CREATE TABLE IfcSpotLightSource (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcSpotLightSource_Color (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcSpotLightSource_Color ADD CONSTRAINT
	PK_IfcSpotLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcSpotLightSource (oid);

ALTER TABLE IfcSpotLightSource ADD COLUMN [AmbientIntensity]  DOUBLE;										
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [Intensity]  DOUBLE;										
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [InContext] TEXT(50);
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [Location] TEXT(50);
				
CREATE TABLE IfcSpotLightSource_Attenuation (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcSpotLightSource_Attenuation ADD CONSTRAINT
	PK_IfcSpotLightSource_Attenuation FOREIGN KEY (pid)
	REFERENCES IfcSpotLightSource (oid);

ALTER TABLE IfcSpotLightSource ADD COLUMN [SpreadAngle]  DOUBLE;										
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [CutOffAngle]  DOUBLE;										
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [Radius]  DOUBLE;										
				
ALTER TABLE IfcSpotLightSource ADD COLUMN [Direction] TEXT(50);
				
CREATE TABLE IfcStair (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcStair ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcStair ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcStair ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcStair ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcStair ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcStair ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcStair ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcStair ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcStair ADD COLUMN [ShapeType] TEXT(50);
				
CREATE TABLE IfcStairFlight (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcStairFlight ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcStairFlight ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcStairFlight ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcStairFlight ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [NumberOfRiser]  LONG;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [NumberOfTreads]  LONG;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [RiserHeight]  DOUBLE;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [TreadLength]  DOUBLE;										
				
CREATE TABLE IfcStorageDevice (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcStorageDevice ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcStorageDevice ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcStorageDevice ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcStorageDevice ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcStorageDevice ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcStorageDevice ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcStorageDevice ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcStorageDevice ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcStorageDevice ADD COLUMN [FlowElementType] TEXT(50);
				
CREATE TABLE IfcSubContractResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSubContractResource ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSubContractResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSubContractResource ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSubContractResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSubContractResource ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSubContractResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcSubContractResource ADD COLUMN [BaseUnit] TEXT(50);
				
ALTER TABLE IfcSubContractResource ADD COLUMN [SubContractResourceID]  MEMO;										
				
ALTER TABLE IfcSubContractResource ADD COLUMN [SubContractor]  TEXT(50);
				
ALTER TABLE IfcSubContractResource ADD COLUMN [JobDescription]  MEMO;										
				
CREATE TABLE IfcSurfaceExtendedProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSurfaceExtendedProperties ADD COLUMN [UsageIdentifier]  MEMO;										
					
CREATE TABLE IfcSurfaceExtendedProperties_ExtendedProperties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSurfaceExtendedProperties_ExtendedProperties ADD CONSTRAINT
	PK_IfcSurfaceExtendedProperties_ExtendedProperties FOREIGN KEY (pid)
	REFERENCES IfcSurfaceExtendedProperties (oid);

ALTER TABLE IfcSurfaceExtendedProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSurfaceExtendedProperties ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcSurfaceOfLinearExtrusion (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD COLUMN [SweptCurve] TEXT(50);
				
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD COLUMN [ExtrudedDirection] TEXT(50);
				
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD COLUMN [Depth]  DOUBLE;										
				
CREATE TABLE IfcSurfaceOfRevolution (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSurfaceOfRevolution ADD COLUMN [SweptCurve] TEXT(50);
				
ALTER TABLE IfcSurfaceOfRevolution ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcSurfaceOfRevolution ADD COLUMN [AxisPosition] TEXT(50);
				
CREATE TABLE IfcSurfaceRenderingProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSurfaceRenderingProperties ADD COLUMN [UsageIdentifier]  MEMO;										
				
CREATE TABLE IfcSurfaceRenderingProperties_AmbientColor (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcSurfaceRenderingProperties_AmbientColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_AmbientColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid);

ALTER TABLE IfcSurfaceRenderingProperties ADD COLUMN [AmbientIntensity]  DOUBLE;										
				
CREATE TABLE IfcSurfaceRenderingProperties_DiffuseColor (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcSurfaceRenderingProperties_DiffuseColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_DiffuseColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid);

ALTER TABLE IfcSurfaceRenderingProperties ADD COLUMN [Transparency]  DOUBLE;										
				
CREATE TABLE IfcSurfaceRenderingProperties_EmmisiveColor (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcSurfaceRenderingProperties_EmmisiveColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_EmmisiveColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid);

ALTER TABLE IfcSurfaceRenderingProperties ADD COLUMN [SpecularIntensity]  DOUBLE;										
				
CREATE TABLE IfcSurfaceRenderingProperties_SpecularColor (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcSurfaceRenderingProperties_SpecularColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_SpecularColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid);

CREATE TABLE IfcSurfaceShadingProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSurfaceShadingProperties ADD COLUMN [UsageIdentifier]  MEMO;										
				
CREATE TABLE IfcSurfaceShadingProperties_AmbientColor (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcSurfaceShadingProperties_AmbientColor ADD CONSTRAINT
	PK_IfcSurfaceShadingProperties_AmbientColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceShadingProperties (oid);

CREATE TABLE IfcSurfaceStyle (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSurfaceStyle ADD COLUMN [Name]  MEMO;										
					
CREATE TABLE IfcSurfaceStyle_Properties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSurfaceStyle_Properties ADD CONSTRAINT
	PK_IfcSurfaceStyle_Properties FOREIGN KEY (pid)
	REFERENCES IfcSurfaceStyle (oid);

CREATE TABLE IfcSurfaceStyleUsage (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcSurfaceStyleUsage_AppliedTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSurfaceStyleUsage_AppliedTo ADD CONSTRAINT
	PK_IfcSurfaceStyleUsage_AppliedTo FOREIGN KEY (pid)
	REFERENCES IfcSurfaceStyleUsage (oid);

ALTER TABLE IfcSurfaceStyleUsage ADD COLUMN [Style] TEXT(50);
				
ALTER TABLE IfcSurfaceStyleUsage ADD COLUMN [Side] TEXT(50);
				
CREATE TABLE IfcSystem (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSystem ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSystem ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSystem ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSystem ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSystem ADD COLUMN [ObjectType]  MEMO;										
				
CREATE TABLE IfcSystemFurnitureElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcTable (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTable ADD COLUMN [Name]  MEMO;										
					
CREATE TABLE IfcTable_Rows (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcTable_Rows ADD CONSTRAINT
	PK_IfcTable_Rows FOREIGN KEY (pid)
	REFERENCES IfcTable (oid);

CREATE TABLE IfcTableRow (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcTableRow_RowCells (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTableRow_RowCells ADD CONSTRAINT
	PK_IfcTableRow_RowCells FOREIGN KEY (pid)
	REFERENCES IfcTableRow (oid);

ALTER TABLE IfcTableRow ADD COLUMN [IsHeading]  BIT;										
				
CREATE TABLE IfcTank (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTank ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcTank ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcTank ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcTank ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTank ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcTank ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcTank ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcTank ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcTank ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcTank ADD COLUMN [Volume]  DOUBLE;										
				
ALTER TABLE IfcTank ADD COLUMN [ReliefValveSetting]  DOUBLE;										
				
ALTER TABLE IfcTank ADD COLUMN [ChargePressure]  DOUBLE;										
				
ALTER TABLE IfcTank ADD COLUMN [PressureRegulatorSetting]  DOUBLE;										
				
CREATE TABLE IfcTask (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTask ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcTask ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcTask ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcTask ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTask ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcTask ADD COLUMN [Productivity] TEXT(50);
				
ALTER TABLE IfcTask ADD COLUMN [TaskId]  MEMO;										
				
CREATE TABLE IfcTask_WBSCode (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTask_WBSCode ADD CONSTRAINT
	PK_IfcTask_WBSCode FOREIGN KEY (pid)
	REFERENCES IfcTask (oid);

CREATE TABLE IfcTask_WBSSource (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTask_WBSSource ADD CONSTRAINT
	PK_IfcTask_WBSSource FOREIGN KEY (pid)
	REFERENCES IfcTask (oid);

ALTER TABLE IfcTask ADD COLUMN [Status] TEXT(50);
				
CREATE TABLE IfcTask_Milestones (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTask_Milestones ADD CONSTRAINT
	PK_IfcTask_Milestones FOREIGN KEY (pid)
	REFERENCES IfcTask (oid);

ALTER TABLE IfcTask ADD COLUMN [WorkMethod]  MEMO;										
				
ALTER TABLE IfcTask ADD COLUMN [InPlaceQuantity] TEXT(50);
				
ALTER TABLE IfcTask ADD COLUMN [EstimatedQuantity] TEXT(50);
				
ALTER TABLE IfcTask ADD COLUMN [BudgetQuantity] TEXT(50);
				
ALTER TABLE IfcTask ADD COLUMN [IsRootTask]  BIT;										
				
CREATE TABLE IfcTelecomAddress (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTelecomAddress ADD COLUMN [Purpose] TEXT(50);
				
ALTER TABLE IfcTelecomAddress ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTelecomAddress ADD COLUMN [UserDefinedPurpose]  MEMO;										
				
CREATE TABLE IfcTelecomAddress_TelephoneNumbers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTelecomAddress_TelephoneNumbers ADD CONSTRAINT
	PK_IfcTelecomAddress_TelephoneNumbers FOREIGN KEY (pid)
	REFERENCES IfcTelecomAddress (oid);

CREATE TABLE IfcTelecomAddress_FacsimileNumbers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTelecomAddress_FacsimileNumbers ADD CONSTRAINT
	PK_IfcTelecomAddress_FacsimileNumbers FOREIGN KEY (pid)
	REFERENCES IfcTelecomAddress (oid);

ALTER TABLE IfcTelecomAddress ADD COLUMN [PagerNumber]  MEMO;										
				
CREATE TABLE IfcTelecomAddress_ElectronicMailAddresses (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTelecomAddress_ElectronicMailAddresses ADD CONSTRAINT
	PK_IfcTelecomAddress_ElectronicMailAddresses FOREIGN KEY (pid)
	REFERENCES IfcTelecomAddress (oid);

ALTER TABLE IfcTelecomAddress ADD COLUMN [WWWHomePageURL]  MEMO;										
				
CREATE TABLE IfcThermalMaterialProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcThermalMaterialProperties ADD COLUMN [Material] TEXT(50);
				
ALTER TABLE IfcThermalMaterialProperties ADD COLUMN [SpecificHeatCapacity]  DOUBLE;										
				
ALTER TABLE IfcThermalMaterialProperties ADD COLUMN [BoilingPoint]  DOUBLE;										
				
ALTER TABLE IfcThermalMaterialProperties ADD COLUMN [FreezingPoint]  DOUBLE;										
				
ALTER TABLE IfcThermalMaterialProperties ADD COLUMN [ThermalConductivity]  DOUBLE;										
				
CREATE TABLE IfcTransportElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTransportElement ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcTransportElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcTransportElement ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcTransportElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTransportElement ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcTransportElement ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcTransportElement ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcTransportElement ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcTransportElement ADD COLUMN [OperationType] TEXT(50);
				
ALTER TABLE IfcTransportElement ADD COLUMN [CapacityByWeight]  DOUBLE;										
				
ALTER TABLE IfcTransportElement ADD COLUMN [CapacityByNumber]  DOUBLE;										
				
CREATE TABLE IfcTrapeziumProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [ProfileName]  MEMO;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [BottomXDim]  DOUBLE;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [TopXDim]  DOUBLE;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [YDim]  DOUBLE;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [TopXOffset]  DOUBLE;										
				
CREATE TABLE IfcTreatmentDevice (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTreatmentDevice ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcTreatmentDevice ADD COLUMN [FlowElementType] TEXT(50);
				
CREATE TABLE IfcTrimmedCurve (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTrimmedCurve ADD COLUMN [BasisCurve] TEXT(50);
					
CREATE TABLE IfcTrimmedCurve_Trim1 (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTrimmedCurve_Trim1 ADD CONSTRAINT
	PK_IfcTrimmedCurve_Trim1 FOREIGN KEY (pid)
	REFERENCES IfcTrimmedCurve (oid);
	
CREATE TABLE IfcTrimmedCurve_Trim2 (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	select_type TEXT(255),
	data_type BYTE,
	RealValue DOUBLE,
	IntegerValue LONG,
	BooleanValue BIT,
	LogicalValue BYTE,
	EntityRef TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcTrimmedCurve_Trim2 ADD CONSTRAINT
	PK_IfcTrimmedCurve_Trim2 FOREIGN KEY (pid)
	REFERENCES IfcTrimmedCurve (oid);

ALTER TABLE IfcTrimmedCurve ADD COLUMN [SenseAgreement]  BIT;										
				
ALTER TABLE IfcTrimmedCurve ADD COLUMN [MasterRepresentation] TEXT(50);
				
CREATE TABLE IfcTubeBundle (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTubeBundle ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [HeatTransferRate]  DOUBLE;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [ThermalEfficiency]  DOUBLE;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [TubeSize]  DOUBLE;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [TubeMaterial]  TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [TubeLength]  DOUBLE;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [TubeSpacing]  DOUBLE;										
				
CREATE TABLE IfcTubeBundle_TubeFluidEnteringTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcTubeBundle_TubeFluidEnteringTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_TubeFluidEnteringTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid);

CREATE TABLE IfcTubeBundle_TubeFluidLeavingTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcTubeBundle_TubeFluidLeavingTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_TubeFluidLeavingTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid);

ALTER TABLE IfcTubeBundle ADD COLUMN [FinMaterial]  TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [ShellMaterial]  TEXT(50);
				
ALTER TABLE IfcTubeBundle ADD COLUMN [FinSpacing]  DOUBLE;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [TubeFoulingFactor]  DOUBLE;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [NumberOfTubeCircuits]  LONG;										
				
ALTER TABLE IfcTubeBundle ADD COLUMN [NumberOfTubeRows]  LONG;										
				
CREATE TABLE IfcTubeBundle_ShellFluidLeavingTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcTubeBundle_ShellFluidLeavingTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_ShellFluidLeavingTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid);

CREATE TABLE IfcTubeBundle_ShellFluidEnteringTemperature (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcTubeBundle_ShellFluidEnteringTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_ShellFluidEnteringTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid);

CREATE TABLE IfcTypeObject (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTypeObject ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcTypeObject ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcTypeObject ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcTypeObject ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTypeObject ADD COLUMN [ApplicableOccurrence]  MEMO;										
					
CREATE TABLE IfcTypeObject_HasPropertySets (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcTypeObject_HasPropertySets ADD CONSTRAINT
	PK_IfcTypeObject_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcTypeObject (oid);

CREATE TABLE IfcTypeProduct (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTypeProduct ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcTypeProduct ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcTypeProduct ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcTypeProduct ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcTypeProduct ADD COLUMN [ApplicableOccurrence]  MEMO;										
					
CREATE TABLE IfcTypeProduct_HasPropertySets (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcTypeProduct_HasPropertySets ADD CONSTRAINT
	PK_IfcTypeProduct_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcTypeProduct (oid);
	
CREATE TABLE IfcTypeProduct_RepresentationMaps (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcTypeProduct_RepresentationMaps ADD CONSTRAINT
	PK_IfcTypeProduct_RepresentationMaps FOREIGN KEY (pid)
	REFERENCES IfcTypeProduct (oid);

ALTER TABLE IfcTypeProduct ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcUnitAssignment (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcUnitAssignment_Units (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcUnitAssignment_Units ADD CONSTRAINT
	PK_IfcUnitAssignment_Units FOREIGN KEY (pid)
	REFERENCES IfcUnitAssignment (oid);

CREATE TABLE IfcUnitHeater (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcUnitHeater ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcUnitHeater ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcUnitHeater ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcUnitHeater ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcUnitHeater ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcUnitHeater ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcUnitHeater ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcUnitHeater ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcUnitHeater ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcUnitHeater ADD COLUMN [HeatTransferRate]  DOUBLE;										
				
ALTER TABLE IfcUnitHeater ADD COLUMN [ThermalEfficiency]  DOUBLE;										
				
ALTER TABLE IfcUnitHeater ADD COLUMN [PrimaryEnergySource] TEXT(50);
				
CREATE TABLE IfcValve (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcValve ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcValve ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcValve ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcValve ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcValve ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcValve ADD COLUMN [FlowElementType] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [CloseOffRating]  DOUBLE;										
				
ALTER TABLE IfcValve ADD COLUMN [ValveFlowCoefficient] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [ValveType] TEXT(50);
				
CREATE TABLE IfcVector (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcVector ADD COLUMN [Orientation] TEXT(50);
				
ALTER TABLE IfcVector ADD COLUMN [Magnitude]  DOUBLE;										
				
CREATE TABLE IfcVertex (
			
	oid TEXT(50) PRIMARY KEY
);
			
CREATE TABLE IfcVertexPoint (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcVertexPoint ADD COLUMN [VertexGeometry] TEXT(50);
				
CREATE TABLE IfcVirtualGridIntersection (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcVirtualGridIntersection_IntersectingAxes (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcVirtualGridIntersection_IntersectingAxes ADD CONSTRAINT
	PK_IfcVirtualGridIntersection_IntersectingAxes FOREIGN KEY (pid)
	REFERENCES IfcVirtualGridIntersection (oid);

CREATE TABLE IfcVirtualGridIntersection_OffsetDistances (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcVirtualGridIntersection_OffsetDistances ADD CONSTRAINT
	PK_IfcVirtualGridIntersection_OffsetDistances FOREIGN KEY (pid)
	REFERENCES IfcVirtualGridIntersection (oid);

CREATE TABLE IfcWall (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWall ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWall ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWall ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWall ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWall ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcWall ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcWall ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcWall ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcWallStandardCase (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWallStandardCase ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWallStandardCase ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWallStandardCase ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWallStandardCase ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWallStandardCase ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcWallStandardCase ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcWallStandardCase ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcWallStandardCase ADD COLUMN [Tag]  MEMO;										
				
CREATE TABLE IfcWindow (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWindow ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWindow ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWindow ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWindow ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWindow ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcWindow ADD COLUMN [ObjectPlacement] TEXT(50);
				
ALTER TABLE IfcWindow ADD COLUMN [Representation] TEXT(50);
				
ALTER TABLE IfcWindow ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcWindow ADD COLUMN [OverallHeight]  DOUBLE;										
				
ALTER TABLE IfcWindow ADD COLUMN [OverallWidth]  DOUBLE;										
				
CREATE TABLE IfcWindowLiningProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [LiningDepth]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [LiningThickness]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [TransomThickness]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [MullionThickness]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [FirstTransomOffset]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [SecondTransomOffset]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [FirstMullionOffset]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [SecondMullionOffset]  DOUBLE;										
				
ALTER TABLE IfcWindowLiningProperties ADD COLUMN [ShapeAspectStyle] TEXT(50);
				
CREATE TABLE IfcWindowPanelProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [OperationType] TEXT(50);
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [PanelPosition] TEXT(50);
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [FrameDepth]  DOUBLE;										
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [FrameThickness]  DOUBLE;										
				
ALTER TABLE IfcWindowPanelProperties ADD COLUMN [ShapeAspectStyle] TEXT(50);
				
CREATE TABLE IfcWindowStyle (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWindowStyle ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWindowStyle ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWindowStyle ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWindowStyle ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWindowStyle ADD COLUMN [ApplicableOccurrence]  MEMO;										
					
CREATE TABLE IfcWindowStyle_HasPropertySets (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindowStyle_HasPropertySets ADD CONSTRAINT
	PK_IfcWindowStyle_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcWindowStyle (oid);
	
CREATE TABLE IfcWindowStyle_RepresentationMaps (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindowStyle_RepresentationMaps ADD CONSTRAINT
	PK_IfcWindowStyle_RepresentationMaps FOREIGN KEY (pid)
	REFERENCES IfcWindowStyle (oid);

ALTER TABLE IfcWindowStyle ADD COLUMN [Tag]  MEMO;										
				
ALTER TABLE IfcWindowStyle ADD COLUMN [ConstructionType] TEXT(50);
				
ALTER TABLE IfcWindowStyle ADD COLUMN [OperationType] TEXT(50);
				
ALTER TABLE IfcWindowStyle ADD COLUMN [ParameterTakesPrecedence]  BIT;										
				
ALTER TABLE IfcWindowStyle ADD COLUMN [Sizeable]  BIT;										
				
CREATE TABLE IfcWorkOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkOrder ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [OrderNumber]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [IssuingDate] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [IssuedBy]  TEXT(50);
					
CREATE TABLE IfcWorkOrder_IssuedTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkOrder_IssuedTo ADD CONSTRAINT
	PK_IfcWorkOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid);
	
CREATE TABLE IfcWorkOrder_AdditionalContacts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcWorkOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid);

CREATE TABLE IfcWorkOrder_Remarks (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcWorkOrder_Remarks ADD CONSTRAINT
	PK_IfcWorkOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid);

ALTER TABLE IfcWorkOrder ADD COLUMN [Signoff] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [BudgetSource] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [ProductDescription]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [ShortJobDescription]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [LongJobDescription]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [WorkTypeRequested]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [ContractualType]  MEMO;										
				
CREATE TABLE IfcWorkOrder_IfNotAccomplished (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcWorkOrder_IfNotAccomplished ADD CONSTRAINT
	PK_IfcWorkOrder_IfNotAccomplished FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid);

ALTER TABLE IfcWorkOrder ADD COLUMN [RequestedStartTime] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [RequestedFinishTime] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [ActualStartTime] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [ActualFinishTime] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [CostEstimate] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [WorkPlan] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [Status] TEXT(50);
				
CREATE TABLE IfcWorkOrder_WorkOrderRiskType (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcWorkOrder_WorkOrderRiskType ADD CONSTRAINT
	PK_IfcWorkOrder_WorkOrderRiskType FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid);
	
CREATE TABLE IfcWorkOrder_PerformedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkOrder_PerformedBy ADD CONSTRAINT
	PK_IfcWorkOrder_PerformedBy FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid);

ALTER TABLE IfcWorkOrder ADD COLUMN [ActualCost] TEXT(50);
				
CREATE TABLE IfcWorkPlan (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkPlan ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkPlan ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [Identifier]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [CreationDate] TEXT(50);
					
CREATE TABLE IfcWorkPlan_Creators (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkPlan_Creators ADD CONSTRAINT
	PK_IfcWorkPlan_Creators FOREIGN KEY (pid)
	REFERENCES IfcWorkPlan (oid);

ALTER TABLE IfcWorkPlan ADD COLUMN [Purpose]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [Duration]  DOUBLE;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [TotalFloat]  DOUBLE;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [StartTime] TEXT(50);
				
ALTER TABLE IfcWorkPlan ADD COLUMN [FinishTime] TEXT(50);
				
ALTER TABLE IfcWorkPlan ADD COLUMN [WorkControlType] TEXT(50);
				
CREATE TABLE IfcWorkSchedule (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkSchedule ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [ObjectType]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [Identifier]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [CreationDate] TEXT(50);
					
CREATE TABLE IfcWorkSchedule_Creators (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkSchedule_Creators ADD CONSTRAINT
	PK_IfcWorkSchedule_Creators FOREIGN KEY (pid)
	REFERENCES IfcWorkSchedule (oid);

ALTER TABLE IfcWorkSchedule ADD COLUMN [Purpose]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [Duration]  DOUBLE;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [TotalFloat]  DOUBLE;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [StartTime] TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [FinishTime] TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [WorkControlType] TEXT(50);
				
CREATE TABLE IfcZone (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcZone ADD COLUMN [GlobalId]  MEMO;										
				
ALTER TABLE IfcZone ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcZone ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcZone ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcZone ADD COLUMN [ObjectType]  MEMO;