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 IfcActor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcActor ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcActor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcActor ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcActor ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcActor_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcActor_DocumentReferences ADD CONSTRAINT
	PK_IfcActor_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcActor (oid);

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 [Description]  MEMO;										
				
CREATE TABLE IfcActuator (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcActuator ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcActuator ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcActuator ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcActuator ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcActuator_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcActuator_DocumentReferences ADD CONSTRAINT
	PK_IfcActuator_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcActuator (oid);

ALTER TABLE IfcActuator ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcActuator_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcActuator_Representations ADD CONSTRAINT
	PK_IfcActuator_Representations FOREIGN KEY (pid)
	REFERENCES IfcActuator (oid);

ALTER TABLE IfcActuator ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcActuator ADD COLUMN [HasMaterial]  TEXT(50);
				
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 IfcAddress (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAddress ADD COLUMN [InternalLocation]  MEMO;										
				
CREATE TABLE IfcAddress_AddressLines (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcAddress_AddressLines ADD CONSTRAINT
	PK_IfcAddress_AddressLines FOREIGN KEY (pid)
	REFERENCES IfcAddress (oid);

ALTER TABLE IfcAddress ADD COLUMN [Town]  MEMO;										
				
ALTER TABLE IfcAddress ADD COLUMN [Region]  MEMO;										
				
ALTER TABLE IfcAddress ADD COLUMN [PostalCode]  MEMO;										
				
ALTER TABLE IfcAddress ADD COLUMN [Country]  MEMO;										
				
CREATE TABLE IfcAddress_FacsimileNumbers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcAddress_FacsimileNumbers ADD CONSTRAINT
	PK_IfcAddress_FacsimileNumbers FOREIGN KEY (pid)
	REFERENCES IfcAddress (oid);

CREATE TABLE IfcAddress_TelephoneNumbers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcAddress_TelephoneNumbers ADD CONSTRAINT
	PK_IfcAddress_TelephoneNumbers FOREIGN KEY (pid)
	REFERENCES IfcAddress (oid);

CREATE TABLE IfcAddress_ElectronicMailAddresses (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcAddress_ElectronicMailAddresses ADD CONSTRAINT
	PK_IfcAddress_ElectronicMailAddresses FOREIGN KEY (pid)
	REFERENCES IfcAddress (oid);

ALTER TABLE IfcAddress ADD COLUMN [TelexNumber]  MEMO;										
				
ALTER TABLE IfcAddress ADD COLUMN [WWWHomePageURL]  MEMO;										
				
ALTER TABLE IfcAddress ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcAddress ADD COLUMN [PostalBox]  MEMO;										
				
CREATE TABLE IfcAirTerminalBox (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAirTerminalBox ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcAirTerminalBox_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAirTerminalBox_DocumentReferences ADD CONSTRAINT
	PK_IfcAirTerminalBox_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcAirTerminalBox (oid);

ALTER TABLE IfcAirTerminalBox ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcAirTerminalBox_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAirTerminalBox_Representations ADD CONSTRAINT
	PK_IfcAirTerminalBox_Representations FOREIGN KEY (pid)
	REFERENCES IfcAirTerminalBox (oid);

ALTER TABLE IfcAirTerminalBox ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcAirTerminalBox_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAirTerminalBox_ControlElements ADD CONSTRAINT
	PK_IfcAirTerminalBox_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcAirTerminalBox (oid);

ALTER TABLE IfcAirTerminalBox ADD COLUMN [TerminalBoxType] TEXT(50);
				
ALTER TABLE IfcAirTerminalBox ADD COLUMN [SoundLevel]  MEMO;										
				
CREATE TABLE IfcApplication (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcApplication ADD COLUMN [ApplicationIdentifier]  MEMO;										
				
ALTER TABLE IfcApplication ADD COLUMN [ApplicationFullName]  MEMO;										
				
ALTER TABLE IfcApplication ADD COLUMN [Version]  MEMO;										
				
ALTER TABLE IfcApplication ADD COLUMN [ApplicationDeveloper] TEXT(50);
				
CREATE TABLE IfcApproval (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcApproval ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcApproval ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcApproval ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcApproval ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcApproval_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcApproval_DocumentReferences ADD CONSTRAINT
	PK_IfcApproval_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcApproval (oid);

ALTER TABLE IfcApproval ADD COLUMN [Classification] TEXT(50);
				
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 IfcArbitraryProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcArbitraryProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcArbitraryProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcArbitraryProfileDef ADD COLUMN [CurveForSurface] TEXT(50);
				
CREATE TABLE IfcAttDrivenClippedExtrudedSolid (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcAttDrivenClippedExtrudedSolid_Segments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAttDrivenClippedExtrudedSolid_Segments ADD CONSTRAINT
	PK_IfcAttDrivenClippedExtrudedSolid_Segments FOREIGN KEY (pid)
	REFERENCES IfcAttDrivenClippedExtrudedSolid (oid);
	
CREATE TABLE IfcAttDrivenClippedExtrudedSolid_ClippingHalfSpaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAttDrivenClippedExtrudedSolid_ClippingHalfSpaces ADD CONSTRAINT
	PK_IfcAttDrivenClippedExtrudedSolid_ClippingHalfSpaces FOREIGN KEY (pid)
	REFERENCES IfcAttDrivenClippedExtrudedSolid (oid);

CREATE TABLE IfcAttDrivenClippedRevolvedSolid (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcAttDrivenClippedRevolvedSolid_Segments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAttDrivenClippedRevolvedSolid_Segments ADD CONSTRAINT
	PK_IfcAttDrivenClippedRevolvedSolid_Segments FOREIGN KEY (pid)
	REFERENCES IfcAttDrivenClippedRevolvedSolid (oid);
	
CREATE TABLE IfcAttDrivenClippedRevolvedSolid_ClippingHalfSpaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAttDrivenClippedRevolvedSolid_ClippingHalfSpaces ADD CONSTRAINT
	PK_IfcAttDrivenClippedRevolvedSolid_ClippingHalfSpaces FOREIGN KEY (pid)
	REFERENCES IfcAttDrivenClippedRevolvedSolid (oid);

CREATE TABLE IfcAttDrivenExtrudedSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAttDrivenExtrudedSegment ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcAttDrivenExtrudedSegment ADD COLUMN [ExtrudedDirection] TEXT(50);
				
ALTER TABLE IfcAttDrivenExtrudedSegment ADD COLUMN [Depth]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenExtrudedSegment ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcAttDrivenExtrudedSegment ADD COLUMN [ProfileDef] TEXT(50);
				
CREATE TABLE IfcAttDrivenExtrudedSolid (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcAttDrivenExtrudedSolid_Segments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAttDrivenExtrudedSolid_Segments ADD CONSTRAINT
	PK_IfcAttDrivenExtrudedSolid_Segments FOREIGN KEY (pid)
	REFERENCES IfcAttDrivenExtrudedSolid (oid);

CREATE TABLE IfcAttDrivenMorphedExtrudedSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAttDrivenMorphedExtrudedSegment ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedExtrudedSegment ADD COLUMN [ExtrudedDirection] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedExtrudedSegment ADD COLUMN [Depth]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenMorphedExtrudedSegment ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedExtrudedSegment ADD COLUMN [ProfileDef] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedExtrudedSegment ADD COLUMN [EndProfileDef] TEXT(50);
				
CREATE TABLE IfcAttDrivenMorphedRevolvedSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAttDrivenMorphedRevolvedSegment ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedRevolvedSegment ADD COLUMN [Axis] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedRevolvedSegment ADD COLUMN [Angle]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenMorphedRevolvedSegment ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedRevolvedSegment ADD COLUMN [StartAngle]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenMorphedRevolvedSegment ADD COLUMN [ProfileDef] TEXT(50);
				
ALTER TABLE IfcAttDrivenMorphedRevolvedSegment ADD COLUMN [EndProfileDef] TEXT(50);
				
CREATE TABLE IfcAttDrivenRevolvedSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAttDrivenRevolvedSegment ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcAttDrivenRevolvedSegment ADD COLUMN [Axis] TEXT(50);
				
ALTER TABLE IfcAttDrivenRevolvedSegment ADD COLUMN [Angle]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenRevolvedSegment ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcAttDrivenRevolvedSegment ADD COLUMN [StartAngle]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenRevolvedSegment ADD COLUMN [ProfileDef] TEXT(50);
				
CREATE TABLE IfcAttDrivenRevolvedSolid (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcAttDrivenRevolvedSolid_Segments (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAttDrivenRevolvedSolid_Segments ADD CONSTRAINT
	PK_IfcAttDrivenRevolvedSolid_Segments FOREIGN KEY (pid)
	REFERENCES IfcAttDrivenRevolvedSolid (oid);

CREATE TABLE IfcAttDrivenTaperedExtrudedSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAttDrivenTaperedExtrudedSegment ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedExtrudedSegment ADD COLUMN [ExtrudedDirection] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedExtrudedSegment ADD COLUMN [Depth]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenTaperedExtrudedSegment ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedExtrudedSegment ADD COLUMN [ProfileDef] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedExtrudedSegment ADD COLUMN [TaperingFactor]  DOUBLE;										
				
CREATE TABLE IfcAttDrivenTaperedRevolvedSegment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAttDrivenTaperedRevolvedSegment ADD COLUMN [SweptArea] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedRevolvedSegment ADD COLUMN [Axis] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedRevolvedSegment ADD COLUMN [Angle]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenTaperedRevolvedSegment ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedRevolvedSegment ADD COLUMN [StartAngle]  DOUBLE;										
				
ALTER TABLE IfcAttDrivenTaperedRevolvedSegment ADD COLUMN [ProfileDef] TEXT(50);
				
ALTER TABLE IfcAttDrivenTaperedRevolvedSegment ADD COLUMN [TaperingFactor]  DOUBLE;										
				
CREATE TABLE IfcAuditTrail (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcAuditTrail ADD COLUMN [CreationDate]  LONG;										
				
ALTER TABLE IfcAuditTrail ADD COLUMN [DeletionDate]  LONG;										
				
ALTER TABLE IfcAuditTrail ADD COLUMN [CreatingUser] TEXT(50);
				
ALTER TABLE IfcAuditTrail ADD COLUMN [DeletingUser] TEXT(50);
				
ALTER TABLE IfcAuditTrail ADD COLUMN [CreatingApplication] TEXT(50);
				
ALTER TABLE IfcAuditTrail ADD COLUMN [DeletingApplication] TEXT(50);
					
CREATE TABLE IfcAuditTrail_Transactions (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcAuditTrail_Transactions ADD CONSTRAINT
	PK_IfcAuditTrail_Transactions FOREIGN KEY (pid)
	REFERENCES IfcAuditTrail (oid);

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]  TEXT (20);										
				
ALTER TABLE IfcBeam ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBeam ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcBeam ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcBeam_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBeam_DocumentReferences ADD CONSTRAINT
	PK_IfcBeam_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcBeam (oid);

ALTER TABLE IfcBeam ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcBeam_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBeam_Representations ADD CONSTRAINT
	PK_IfcBeam_Representations FOREIGN KEY (pid)
	REFERENCES IfcBeam (oid);

ALTER TABLE IfcBeam ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcBeam ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcBeam ADD COLUMN [calcBeamSectionArea]  DOUBLE;										
				
ALTER TABLE IfcBeam ADD COLUMN [calcBeamVolume]  DOUBLE;										
				
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 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]  TEXT (20);										
				
ALTER TABLE IfcBudget ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcBudget_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBudget_DocumentReferences ADD CONSTRAINT
	PK_IfcBudget_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid);

ALTER TABLE IfcBudget ADD COLUMN [Classification] TEXT(50);
				
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 [BudgetNumber]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [BudgetSource]  MEMO;										
				
ALTER TABLE IfcBudget ADD COLUMN [Balance] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [AvailableDate]  TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [AvailableDuration]  DOUBLE;										
				
ALTER TABLE IfcBudget ADD COLUMN [BaseBudget] TEXT(50);
				
ALTER TABLE IfcBudget ADD COLUMN [UpdateDate]  TEXT(50);
				
CREATE TABLE IfcBuilding (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuilding ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcBuilding ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuilding ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcBuilding_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuilding_DocumentReferences ADD CONSTRAINT
	PK_IfcBuilding_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcBuilding (oid);

ALTER TABLE IfcBuilding ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcBuilding_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuilding_Representations ADD CONSTRAINT
	PK_IfcBuilding_Representations FOREIGN KEY (pid)
	REFERENCES IfcBuilding (oid);

ALTER TABLE IfcBuilding ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcBuilding ADD COLUMN [BuildingReference]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [BuildingName]  MEMO;										
				
ALTER TABLE IfcBuilding ADD COLUMN [calcTotalHeight]  DOUBLE;										
				
ALTER TABLE IfcBuilding ADD COLUMN [calcSiteCoverage]  DOUBLE;										
				
ALTER TABLE IfcBuilding ADD COLUMN [calcTotalVolume]  DOUBLE;										
				
ALTER TABLE IfcBuilding ADD COLUMN [ElevationOfRefHeight]  DOUBLE;										
				
ALTER TABLE IfcBuilding ADD COLUMN [ElevationOfTerrain]  DOUBLE;										
				
CREATE TABLE IfcBuildingElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuildingElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcBuildingElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuildingElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcBuildingElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcBuildingElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuildingElement_DocumentReferences ADD CONSTRAINT
	PK_IfcBuildingElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcBuildingElement (oid);

ALTER TABLE IfcBuildingElement ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcBuildingElement_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuildingElement_Representations ADD CONSTRAINT
	PK_IfcBuildingElement_Representations FOREIGN KEY (pid)
	REFERENCES IfcBuildingElement (oid);

ALTER TABLE IfcBuildingElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcBuildingElement ADD COLUMN [HasMaterial]  TEXT(50);
				
CREATE TABLE IfcBuildingStorey (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuildingStorey ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcBuildingStorey_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuildingStorey_DocumentReferences ADD CONSTRAINT
	PK_IfcBuildingStorey_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcBuildingStorey (oid);

ALTER TABLE IfcBuildingStorey ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcBuildingStorey_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuildingStorey_Representations ADD CONSTRAINT
	PK_IfcBuildingStorey_Representations FOREIGN KEY (pid)
	REFERENCES IfcBuildingStorey (oid);

ALTER TABLE IfcBuildingStorey ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [BuildingStoreyReference]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [BuildingStoreyName]  MEMO;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [Elevation]  DOUBLE;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [calcTotalHeight]  DOUBLE;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [calcTotalArea]  DOUBLE;										
				
ALTER TABLE IfcBuildingStorey ADD COLUMN [calcTotalVolume]  DOUBLE;										
				
CREATE TABLE IfcBuiltIn (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuiltIn ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcBuiltIn ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuiltIn ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcBuiltIn ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcBuiltIn_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuiltIn_DocumentReferences ADD CONSTRAINT
	PK_IfcBuiltIn_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcBuiltIn (oid);

ALTER TABLE IfcBuiltIn ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcBuiltIn_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuiltIn_Representations ADD CONSTRAINT
	PK_IfcBuiltIn_Representations FOREIGN KEY (pid)
	REFERENCES IfcBuiltIn (oid);

ALTER TABLE IfcBuiltIn ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcBuiltIn ADD COLUMN [HasMaterial]  TEXT(50);
				
CREATE TABLE IfcBuiltInAccessory (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcBuiltInAccessory_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuiltInAccessory_DocumentReferences ADD CONSTRAINT
	PK_IfcBuiltInAccessory_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcBuiltInAccessory (oid);

ALTER TABLE IfcBuiltInAccessory ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcBuiltInAccessory_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcBuiltInAccessory_Representations ADD CONSTRAINT
	PK_IfcBuiltInAccessory_Representations FOREIGN KEY (pid)
	REFERENCES IfcBuiltInAccessory (oid);

ALTER TABLE IfcBuiltInAccessory ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [calcMountingHeight]  DOUBLE;										
				
ALTER TABLE IfcBuiltInAccessory ADD COLUMN [MountingType]  MEMO;										
				
CREATE TABLE IfcCabinet (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCabinet ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcCabinet ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCabinet ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCabinet ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCabinet_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCabinet_DocumentReferences ADD CONSTRAINT
	PK_IfcCabinet_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCabinet (oid);

ALTER TABLE IfcCabinet ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcCabinet_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCabinet_Representations ADD CONSTRAINT
	PK_IfcCabinet_Representations FOREIGN KEY (pid)
	REFERENCES IfcCabinet (oid);

ALTER TABLE IfcCabinet ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcCabinet ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcCabinet ADD COLUMN [PredefinedType] TEXT(50);
					
CREATE TABLE IfcCabinet_CabinetHardware (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCabinet_CabinetHardware ADD CONSTRAINT
	PK_IfcCabinet_CabinetHardware FOREIGN KEY (pid)
	REFERENCES IfcCabinet (oid);

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 IfcChangeOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcChangeOrder ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcChangeOrder_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcChangeOrder_DocumentReferences ADD CONSTRAINT
	PK_IfcChangeOrder_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid);

ALTER TABLE IfcChangeOrder ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [OrderNo]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcChangeOrder ADD COLUMN [IssuingDate]  TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [IssuingCompany] 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);

ALTER TABLE IfcChangeOrder ADD COLUMN [Remark]  MEMO;										
				
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);
					
CREATE TABLE IfcChangeOrder_DocumentsForChange (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcChangeOrder_DocumentsForChange ADD CONSTRAINT
	PK_IfcChangeOrder_DocumentsForChange FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid);

ALTER TABLE IfcChangeOrder ADD COLUMN [CostEstimate] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [WorkPlan] TEXT(50);
				
ALTER TABLE IfcChangeOrder ADD COLUMN [Status] TEXT(50);
				
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 [Position] TEXT(50);
				
ALTER TABLE IfcCircleProfileDef ADD COLUMN [ProfileType] 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 [Table]  MEMO;										
				
ALTER TABLE IfcClassification ADD COLUMN [Notation] TEXT(50);
				
ALTER TABLE IfcClassification ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcClassification ADD COLUMN [Edition]  MEMO;										
				
CREATE TABLE IfcClassificationList (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcClassificationList_Classifications (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcClassificationList_Classifications ADD CONSTRAINT
	PK_IfcClassificationList_Classifications FOREIGN KEY (pid)
	REFERENCES IfcClassificationList (oid);

ALTER TABLE IfcClassificationList ADD COLUMN [Priority]  LONG;										
				
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 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]  TEXT (20);										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCMDocPackage_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_DocumentReferences ADD CONSTRAINT
	PK_IfcCMDocPackage_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);

ALTER TABLE IfcCMDocPackage ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [DocPackageID]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [DocPackageName]  MEMO;										
				
ALTER TABLE IfcCMDocPackage ADD COLUMN [Description]  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 IfcCMDocPackage_Approvals (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_Approvals ADD CONSTRAINT
	PK_IfcCMDocPackage_Approvals FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);
	
CREATE TABLE IfcCMDocPackage_WorkPlans (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_WorkPlans ADD CONSTRAINT
	PK_IfcCMDocPackage_WorkPlans FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);
	
CREATE TABLE IfcCMDocPackage_CostEstimates (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_CostEstimates ADD CONSTRAINT
	PK_IfcCMDocPackage_CostEstimates FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);
	
CREATE TABLE IfcCMDocPackage_WorkOrders (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_WorkOrders ADD CONSTRAINT
	PK_IfcCMDocPackage_WorkOrders FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);
	
CREATE TABLE IfcCMDocPackage_PurchaseOrders (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_PurchaseOrders ADD CONSTRAINT
	PK_IfcCMDocPackage_PurchaseOrders FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);
	
CREATE TABLE IfcCMDocPackage_ChangeOrders (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_ChangeOrders ADD CONSTRAINT
	PK_IfcCMDocPackage_ChangeOrders FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);
	
CREATE TABLE IfcCMDocPackage_Documents (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_Documents ADD CONSTRAINT
	PK_IfcCMDocPackage_Documents FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);
	
CREATE TABLE IfcCMDocPackage_BudgetSources (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCMDocPackage_BudgetSources ADD CONSTRAINT
	PK_IfcCMDocPackage_BudgetSources FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid);

CREATE TABLE IfcColumn (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcColumn ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcColumn ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcColumn ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcColumn ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcColumn_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcColumn_DocumentReferences ADD CONSTRAINT
	PK_IfcColumn_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcColumn (oid);

ALTER TABLE IfcColumn ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcColumn_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcColumn_Representations ADD CONSTRAINT
	PK_IfcColumn_Representations FOREIGN KEY (pid)
	REFERENCES IfcColumn (oid);

ALTER TABLE IfcColumn ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcColumn ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcColumn ADD COLUMN [calcColumnSectionArea]  DOUBLE;										
				
ALTER TABLE IfcColumn ADD COLUMN [calcColumnVolume]  DOUBLE;										
				
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 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 IfcConstrainedPlacement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstrainedPlacement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcConstrainedPlacement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstrainedPlacement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcConstrainedPlacement ADD COLUMN [PlacementRelTo]  TEXT(50);
				
ALTER TABLE IfcConstrainedPlacement ADD COLUMN [RelativePlacement]  TEXT(50);
					
CREATE TABLE IfcConstrainedPlacement_PathEndPointsConstraint (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstrainedPlacement_PathEndPointsConstraint ADD CONSTRAINT
	PK_IfcConstrainedPlacement_PathEndPointsConstraint FOREIGN KEY (pid)
	REFERENCES IfcConstrainedPlacement (oid);

CREATE TABLE IfcConstraint (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstraint ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcConstraint ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstraint ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcConstraint ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcConstraint_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstraint_DocumentReferences ADD CONSTRAINT
	PK_IfcConstraint_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcConstraint (oid);

ALTER TABLE IfcConstraint ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcConstraint ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcConstraint ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstraint ADD COLUMN [Source]  MEMO;										
				
CREATE TABLE IfcConstraintRelIntersection (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstraintRelIntersection ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcConstraintRelIntersection ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstraintRelIntersection ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcConstraintRelIntersection ADD COLUMN [RefPointAt]  TEXT(50);
					
CREATE TABLE IfcConstraintRelIntersection_OffsetFromCurves (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstraintRelIntersection_OffsetFromCurves ADD CONSTRAINT
	PK_IfcConstraintRelIntersection_OffsetFromCurves FOREIGN KEY (pid)
	REFERENCES IfcConstraintRelIntersection (oid);

CREATE TABLE IfcConstraintRelIntersection_OffsetDistances (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	RealValue DOUBLE
);
ALTER TABLE IfcConstraintRelIntersection_OffsetDistances ADD CONSTRAINT
	PK_IfcConstraintRelIntersection_OffsetDistances FOREIGN KEY (pid)
	REFERENCES IfcConstraintRelIntersection (oid);

CREATE TABLE IfcConstructionEquipmentResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcConstructionEquipmentResource_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionEquipmentResource_DocumentReferences ADD CONSTRAINT
	PK_IfcConstructionEquipmentResource_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcConstructionEquipmentResource (oid);

ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [TypeReference]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [TypeName]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [BaseUnit] TEXT(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [EquipmentModel]  MEMO;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD COLUMN [Manufacturer] TEXT(50);
				
CREATE TABLE IfcConstructionMaterialResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcConstructionMaterialResource_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionMaterialResource_DocumentReferences ADD CONSTRAINT
	PK_IfcConstructionMaterialResource_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcConstructionMaterialResource (oid);

ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [TypeReference]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [TypeName]  MEMO;										
				
ALTER TABLE IfcConstructionMaterialResource ADD COLUMN [Classification] TEXT(50);
				
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_MaterialProducts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionMaterialResource_MaterialProducts ADD CONSTRAINT
	PK_IfcConstructionMaterialResource_MaterialProducts FOREIGN KEY (pid)
	REFERENCES IfcConstructionMaterialResource (oid);
	
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 IfcConstructionZoneAggregationProduct (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcConstructionZoneAggregationProduct_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionZoneAggregationProduct_DocumentReferences ADD CONSTRAINT
	PK_IfcConstructionZoneAggregationProduct_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcConstructionZoneAggregationProduct (oid);

ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcConstructionZoneAggregationProduct_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionZoneAggregationProduct_Representations ADD CONSTRAINT
	PK_IfcConstructionZoneAggregationProduct_Representations FOREIGN KEY (pid)
	REFERENCES IfcConstructionZoneAggregationProduct (oid);

ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [ID]  MEMO;										
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [ZoneNotAggregation]  BIT;										
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [SelectionCriteria]  MEMO;										
				
ALTER TABLE IfcConstructionZoneAggregationProduct ADD COLUMN [PartOfProduct] TEXT(50);
					
CREATE TABLE IfcConstructionZoneAggregationProduct_CoveredProducts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcConstructionZoneAggregationProduct_CoveredProducts ADD CONSTRAINT
	PK_IfcConstructionZoneAggregationProduct_CoveredProducts FOREIGN KEY (pid)
	REFERENCES IfcConstructionZoneAggregationProduct (oid);

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 IfcController (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcController ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcController ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcController ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcController ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcController_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcController_DocumentReferences ADD CONSTRAINT
	PK_IfcController_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcController (oid);

ALTER TABLE IfcController ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcController_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcController_Representations ADD CONSTRAINT
	PK_IfcController_Representations FOREIGN KEY (pid)
	REFERENCES IfcController (oid);

ALTER TABLE IfcController ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcController ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcController ADD COLUMN [ControlElementID]  MEMO;										
				
ALTER TABLE IfcController ADD COLUMN [PredefinedType] TEXT(50);
				
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 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 [CostType] TEXT(50);
				
ALTER TABLE IfcCost ADD COLUMN [BaseCostValue]  DOUBLE;										
				
ALTER TABLE IfcCost ADD COLUMN [FinalCostValue]  DOUBLE;										
				
ALTER TABLE IfcCost ADD COLUMN [Currency] TEXT(50);
				
ALTER TABLE IfcCost ADD COLUMN [ModifierBasis] TEXT(50);
					
CREATE TABLE IfcCost_ModifierValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCost_ModifierValues ADD CONSTRAINT
	PK_IfcCost_ModifierValues FOREIGN KEY (pid)
	REFERENCES IfcCost (oid);

ALTER TABLE IfcCost ADD COLUMN [UnitCostBasis] TEXT(50);
				
ALTER TABLE IfcCost ADD COLUMN [CostDate]  TEXT(50);
					
CREATE TABLE IfcCost_CostComponents (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCost_CostComponents ADD CONSTRAINT
	PK_IfcCost_CostComponents FOREIGN KEY (pid)
	REFERENCES IfcCost (oid);

CREATE TABLE IfcCostElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcCostElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCostElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCostElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCostElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCostElement_DocumentReferences ADD CONSTRAINT
	PK_IfcCostElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCostElement (oid);

ALTER TABLE IfcCostElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcCostElement ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCostElement ADD COLUMN [ContextDescription]  MEMO;										
				
ALTER TABLE IfcCostElement ADD COLUMN [ElementCost] TEXT(50);
				
ALTER TABLE IfcCostElement ADD COLUMN [ExtensionCost] TEXT(50);
				
ALTER TABLE IfcCostElement ADD COLUMN [CostUse] TEXT(50);
				
ALTER TABLE IfcCostElement ADD COLUMN [PreparedOn]  TEXT(50);
				
ALTER TABLE IfcCostElement ADD COLUMN [Quantity] TEXT(50);
				
CREATE TABLE IfcCostModifier (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostModifier ADD COLUMN [Purpose]  MEMO;										
				
ALTER TABLE IfcCostModifier ADD COLUMN [CostValue]  DOUBLE;										
				
ALTER TABLE IfcCostModifier ADD COLUMN [CostOperator] TEXT(50);
				
CREATE TABLE IfcCostSchedule (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCostSchedule ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCostSchedule ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCostSchedule ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCostSchedule_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCostSchedule_DocumentReferences ADD CONSTRAINT
	PK_IfcCostSchedule_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid);

ALTER TABLE IfcCostSchedule ADD COLUMN [Classification] TEXT(50);
				
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);

CREATE TABLE IfcCounterOrShelf (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCounterOrShelf ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcCounterOrShelf ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCounterOrShelf ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCounterOrShelf ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCounterOrShelf_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCounterOrShelf_DocumentReferences ADD CONSTRAINT
	PK_IfcCounterOrShelf_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCounterOrShelf (oid);

ALTER TABLE IfcCounterOrShelf ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcCounterOrShelf_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCounterOrShelf_Representations ADD CONSTRAINT
	PK_IfcCounterOrShelf_Representations FOREIGN KEY (pid)
	REFERENCES IfcCounterOrShelf (oid);

ALTER TABLE IfcCounterOrShelf ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcCounterOrShelf ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcCounterOrShelf ADD COLUMN [PredefinedType] TEXT(50);
					
CREATE TABLE IfcCounterOrShelf_CounterOrShelfHardware (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCounterOrShelf_CounterOrShelfHardware ADD CONSTRAINT
	PK_IfcCounterOrShelf_CounterOrShelfHardware FOREIGN KEY (pid)
	REFERENCES IfcCounterOrShelf (oid);

CREATE TABLE IfcCovering (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCovering ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcCovering ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCovering ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCovering_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCovering_DocumentReferences ADD CONSTRAINT
	PK_IfcCovering_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCovering (oid);

ALTER TABLE IfcCovering ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcCovering_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCovering_Representations ADD CONSTRAINT
	PK_IfcCovering_Representations FOREIGN KEY (pid)
	REFERENCES IfcCovering (oid);

ALTER TABLE IfcCovering ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [LayerInformation] TEXT(50);
				
ALTER TABLE IfcCovering ADD COLUMN [calcCoveringArea]  DOUBLE;										
				
CREATE TABLE IfcCrewResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcCrewResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcCrewResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCrewResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCrewResource_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCrewResource_DocumentReferences ADD CONSTRAINT
	PK_IfcCrewResource_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCrewResource (oid);

ALTER TABLE IfcCrewResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [TypeReference]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [TypeName]  MEMO;										
				
ALTER TABLE IfcCrewResource ADD COLUMN [Classification] TEXT(50);
				
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]  TEXT (20);										
				
ALTER TABLE IfcCurtainWall ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcCurtainWall ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcCurtainWall ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcCurtainWall_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCurtainWall_DocumentReferences ADD CONSTRAINT
	PK_IfcCurtainWall_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcCurtainWall (oid);

ALTER TABLE IfcCurtainWall ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcCurtainWall_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcCurtainWall_Representations ADD CONSTRAINT
	PK_IfcCurtainWall_Representations FOREIGN KEY (pid)
	REFERENCES IfcCurtainWall (oid);

ALTER TABLE IfcCurtainWall ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcCurtainWall ADD COLUMN [HasMaterial]  TEXT(50);
				
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]  TEXT (20);										
				
ALTER TABLE IfcDamper ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDamper ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDamper_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDamper_DocumentReferences ADD CONSTRAINT
	PK_IfcDamper_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDamper (oid);

ALTER TABLE IfcDamper ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDamper_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDamper_Representations ADD CONSTRAINT
	PK_IfcDamper_Representations FOREIGN KEY (pid)
	REFERENCES IfcDamper (oid);

ALTER TABLE IfcDamper ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcDamper_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDamper_ControlElements ADD CONSTRAINT
	PK_IfcDamper_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcDamper (oid);

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] TEXT(50);
				
ALTER TABLE IfcDamper ADD COLUMN [LeakageAirFlowrate] TEXT(50);
				
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 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);
				
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 IfcDesignGrid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDesignGrid ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDesignGrid ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDesignGrid ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDesignGrid ADD COLUMN [GridPurpose]  MEMO;										
				
ALTER TABLE IfcDesignGrid ADD COLUMN [LocalPlacement] TEXT(50);
				
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 IfcDiscreteElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDiscreteElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDiscreteElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDiscreteElement_DocumentReferences ADD CONSTRAINT
	PK_IfcDiscreteElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDiscreteElement (oid);

ALTER TABLE IfcDiscreteElement ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDiscreteElement_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDiscreteElement_Representations ADD CONSTRAINT
	PK_IfcDiscreteElement_Representations FOREIGN KEY (pid)
	REFERENCES IfcDiscreteElement (oid);

ALTER TABLE IfcDiscreteElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcDiscreteElement ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcDistributionControlElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDistributionControlElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDistributionControlElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDistributionControlElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDistributionControlElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDistributionControlElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionControlElement_DocumentReferences ADD CONSTRAINT
	PK_IfcDistributionControlElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDistributionControlElement (oid);

ALTER TABLE IfcDistributionControlElement ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDistributionControlElement_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionControlElement_Representations ADD CONSTRAINT
	PK_IfcDistributionControlElement_Representations FOREIGN KEY (pid)
	REFERENCES IfcDistributionControlElement (oid);

ALTER TABLE IfcDistributionControlElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDistributionControlElement ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcDistributionControlElement ADD COLUMN [ControlElementID]  MEMO;										
				
CREATE TABLE IfcDistributionElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDistributionElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDistributionElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDistributionElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDistributionElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDistributionElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionElement_DocumentReferences ADD CONSTRAINT
	PK_IfcDistributionElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDistributionElement (oid);

ALTER TABLE IfcDistributionElement ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDistributionElement_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionElement_Representations ADD CONSTRAINT
	PK_IfcDistributionElement_Representations FOREIGN KEY (pid)
	REFERENCES IfcDistributionElement (oid);

ALTER TABLE IfcDistributionElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDistributionElement ADD COLUMN [HasMaterial]  TEXT(50);
				
CREATE TABLE IfcDistributionFlowElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDistributionFlowElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionFlowElement_DocumentReferences ADD CONSTRAINT
	PK_IfcDistributionFlowElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDistributionFlowElement (oid);

ALTER TABLE IfcDistributionFlowElement ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDistributionFlowElement_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionFlowElement_Representations ADD CONSTRAINT
	PK_IfcDistributionFlowElement_Representations FOREIGN KEY (pid)
	REFERENCES IfcDistributionFlowElement (oid);

ALTER TABLE IfcDistributionFlowElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcDistributionFlowElement ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcDistributionFlowElement_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionFlowElement_ControlElements ADD CONSTRAINT
	PK_IfcDistributionFlowElement_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcDistributionFlowElement (oid);

CREATE TABLE IfcDistributionPortGeometry (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDistributionPortGeometry_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDistributionPortGeometry_DocumentReferences ADD CONSTRAINT
	PK_IfcDistributionPortGeometry_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDistributionPortGeometry (oid);

ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [PortLocation] TEXT(50);
				
ALTER TABLE IfcDistributionPortGeometry ADD COLUMN [PortShape] TEXT(50);
				
CREATE TABLE IfcDocumentReference (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDocumentReference ADD COLUMN [DocumentType] TEXT(50);
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DocumentName]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DocumentDescription]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [Location]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DocumentOwner]  TEXT(50);
					
CREATE TABLE IfcDocumentReference_PreparedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDocumentReference_PreparedBy ADD CONSTRAINT
	PK_IfcDocumentReference_PreparedBy FOREIGN KEY (pid)
	REFERENCES IfcDocumentReference (oid);

ALTER TABLE IfcDocumentReference ADD COLUMN [CreationDate] TEXT(50);
					
CREATE TABLE IfcDocumentReference_Editors (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDocumentReference_Editors ADD CONSTRAINT
	PK_IfcDocumentReference_Editors FOREIGN KEY (pid)
	REFERENCES IfcDocumentReference (oid);

ALTER TABLE IfcDocumentReference ADD COLUMN [Revision]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DateOfRevision] TEXT(50);
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DocSectionReference]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DocumentScope]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DocumentPurpose]  MEMO;										
				
ALTER TABLE IfcDocumentReference ADD COLUMN [DocumentIntendedUse]  MEMO;										
				
CREATE TABLE IfcDocumentType (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDocumentType ADD COLUMN [FileExtension]  MEMO;										
				
ALTER TABLE IfcDocumentType ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcDocumentType_EditingApplications (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDocumentType_EditingApplications ADD CONSTRAINT
	PK_IfcDocumentType_EditingApplications FOREIGN KEY (pid)
	REFERENCES IfcDocumentType (oid);

CREATE TABLE IfcDoor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDoor ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDoor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDoor ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDoor ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDoor_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoor_DocumentReferences ADD CONSTRAINT
	PK_IfcDoor_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDoor (oid);

ALTER TABLE IfcDoor ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDoor_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoor_Representations ADD CONSTRAINT
	PK_IfcDoor_Representations FOREIGN KEY (pid)
	REFERENCES IfcDoor (oid);

ALTER TABLE IfcDoor ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDoor ADD COLUMN [HasMaterial]  TEXT(50);
				
CREATE TABLE IfcDoorLining (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDoorLining ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDoorLining ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDoorLining ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDoorLining ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDoorLining_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoorLining_DocumentReferences ADD CONSTRAINT
	PK_IfcDoorLining_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDoorLining (oid);

ALTER TABLE IfcDoorLining ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDoorLining_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoorLining_Representations ADD CONSTRAINT
	PK_IfcDoorLining_Representations FOREIGN KEY (pid)
	REFERENCES IfcDoorLining (oid);

ALTER TABLE IfcDoorLining ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDoorLining ADD COLUMN [HasMaterial]  TEXT(50);
				
CREATE TABLE IfcDoorPanel (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcDoorPanel ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcDoorPanel ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcDoorPanel ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcDoorPanel ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcDoorPanel_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoorPanel_DocumentReferences ADD CONSTRAINT
	PK_IfcDoorPanel_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDoorPanel (oid);

ALTER TABLE IfcDoorPanel ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcDoorPanel_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcDoorPanel_Representations ADD CONSTRAINT
	PK_IfcDoorPanel_Representations FOREIGN KEY (pid)
	REFERENCES IfcDoorPanel (oid);

ALTER TABLE IfcDoorPanel ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcDoorPanel ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcDoorPanel ADD COLUMN [PredefinedType] TEXT(50);
				
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 IfcElectricalAppliance (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricalAppliance ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcElectricalAppliance_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcElectricalAppliance_DocumentReferences ADD CONSTRAINT
	PK_IfcElectricalAppliance_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcElectricalAppliance (oid);

ALTER TABLE IfcElectricalAppliance ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcElectricalAppliance_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcElectricalAppliance_Representations ADD CONSTRAINT
	PK_IfcElectricalAppliance_Representations FOREIGN KEY (pid)
	REFERENCES IfcElectricalAppliance (oid);

ALTER TABLE IfcElectricalAppliance ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcElectricalAppliance ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcElectricalCharacteristics (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [ElectricCurrentType] TEXT(50);
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [InputVoltage]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [InputPhase]  LONG;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [InputFrequency]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [FullLoadCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [LockedRotorCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [InrushCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [MinimumCircuitCurrent]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [RatedPowerInput]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [MaximumPowerInput]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [CircuitSizePowerInput]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [FuseSize]  DOUBLE;										
				
ALTER TABLE IfcElectricalCharacteristics ADD COLUMN [Grounded]  BIT;										
				
CREATE TABLE IfcElectricalFixture (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcElectricalFixture ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcElectricalFixture ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcElectricalFixture ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcElectricalFixture ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcElectricalFixture_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcElectricalFixture_DocumentReferences ADD CONSTRAINT
	PK_IfcElectricalFixture_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcElectricalFixture (oid);

ALTER TABLE IfcElectricalFixture ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcElectricalFixture_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcElectricalFixture_Representations ADD CONSTRAINT
	PK_IfcElectricalFixture_Representations FOREIGN KEY (pid)
	REFERENCES IfcElectricalFixture (oid);

ALTER TABLE IfcElectricalFixture ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcElectricalFixture ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcElectricalFixture ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcElectricalFixture_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcElectricalFixture_ControlElements ADD CONSTRAINT
	PK_IfcElectricalFixture_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcElectricalFixture (oid);

ALTER TABLE IfcElectricalFixture ADD COLUMN [PredefinedType] TEXT(50);
				
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 IfcEnumeratedProperty (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEnumeratedProperty ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcEnumeratedProperty ADD COLUMN [EnumerationIndex]  LONG;										
				
ALTER TABLE IfcEnumeratedProperty ADD COLUMN [EnumerationReference] TEXT(50);
				
CREATE TABLE IfcEnumeration (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEnumeration ADD COLUMN [Name]  MEMO;										
				
CREATE TABLE IfcEnumeration_EnumerationValues (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcEnumeration_EnumerationValues ADD CONSTRAINT
	PK_IfcEnumeration_EnumerationValues FOREIGN KEY (pid)
	REFERENCES IfcEnumeration (oid);

CREATE TABLE IfcEquipment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcEquipment ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcEquipment ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcEquipment ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcEquipment ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcEquipment_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcEquipment_DocumentReferences ADD CONSTRAINT
	PK_IfcEquipment_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcEquipment (oid);

ALTER TABLE IfcEquipment ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcEquipment_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcEquipment_Representations ADD CONSTRAINT
	PK_IfcEquipment_Representations FOREIGN KEY (pid)
	REFERENCES IfcEquipment (oid);

ALTER TABLE IfcEquipment ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcEquipment ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcEquipment ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcExtensionPropertySet (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcExtensionPropertySet ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcExtensionPropertySet ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcExtensionPropertySet ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcExtensionPropertySet ADD COLUMN [Name]  MEMO;										
					
CREATE TABLE IfcExtensionPropertySet_HasProperties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcExtensionPropertySet_HasProperties ADD CONSTRAINT
	PK_IfcExtensionPropertySet_HasProperties FOREIGN KEY (pid)
	REFERENCES IfcExtensionPropertySet (oid);

ALTER TABLE IfcExtensionPropertySet ADD COLUMN [DefinitionSource]  MEMO;										
				
CREATE TABLE IfcExtrudedAreaSolid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcExtrudedAreaSolid ADD COLUMN [SweptArea] 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 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 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 IfcFireCompartment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFireCompartment ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFireCompartment ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFireCompartment_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFireCompartment_DocumentReferences ADD CONSTRAINT
	PK_IfcFireCompartment_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFireCompartment (oid);

ALTER TABLE IfcFireCompartment ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcFireCompartment_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFireCompartment_Representations ADD CONSTRAINT
	PK_IfcFireCompartment_Representations FOREIGN KEY (pid)
	REFERENCES IfcFireCompartment (oid);

ALTER TABLE IfcFireCompartment ADD COLUMN [Classification] TEXT(50);
					
CREATE TABLE IfcFireCompartment_BoundedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFireCompartment_BoundedBy ADD CONSTRAINT
	PK_IfcFireCompartment_BoundedBy FOREIGN KEY (pid)
	REFERENCES IfcFireCompartment (oid);

ALTER TABLE IfcFireCompartment ADD COLUMN [InteriorOrExteriorSpace] TEXT(50);
				
ALTER TABLE IfcFireCompartment ADD COLUMN [SpaceReference]  MEMO;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [SpaceName]  MEMO;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcTotalPerimeter]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcTotalArea]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcTotalVolume]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcAverageHeight]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcAverageGrossHeight]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcAverageClearHeight]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcElevationWithFlooring]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [calcHeightAboveGrade]  DOUBLE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [MainFireUse] TEXT(50);
				
ALTER TABLE IfcFireCompartment ADD COLUMN [AncillaryFireUse] TEXT(50);
				
ALTER TABLE IfcFireCompartment ADD COLUMN [FireRiskFactor]  LONG;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [HasNaturalVentilation]  BYTE;										
				
ALTER TABLE IfcFireCompartment ADD COLUMN [HasSprinklerProtection]  BYTE;										
				
CREATE TABLE IfcFlowController (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowController ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcFlowController ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowController ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFlowController ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFlowController_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowController_DocumentReferences ADD CONSTRAINT
	PK_IfcFlowController_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFlowController (oid);

ALTER TABLE IfcFlowController ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcFlowController_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowController_Representations ADD CONSTRAINT
	PK_IfcFlowController_Representations FOREIGN KEY (pid)
	REFERENCES IfcFlowController (oid);

ALTER TABLE IfcFlowController ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcFlowController ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcFlowController ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcFlowController_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowController_ControlElements ADD CONSTRAINT
	PK_IfcFlowController_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcFlowController (oid);

CREATE TABLE IfcFlowEquipment (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowEquipment ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcFlowEquipment ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowEquipment ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFlowEquipment ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFlowEquipment_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowEquipment_DocumentReferences ADD CONSTRAINT
	PK_IfcFlowEquipment_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFlowEquipment (oid);

ALTER TABLE IfcFlowEquipment ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcFlowEquipment_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowEquipment_Representations ADD CONSTRAINT
	PK_IfcFlowEquipment_Representations FOREIGN KEY (pid)
	REFERENCES IfcFlowEquipment (oid);

ALTER TABLE IfcFlowEquipment ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcFlowEquipment ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcFlowEquipment ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcFlowEquipment_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowEquipment_ControlElements ADD CONSTRAINT
	PK_IfcFlowEquipment_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcFlowEquipment (oid);

ALTER TABLE IfcFlowEquipment ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcFlowFitting (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowFitting ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcFlowFitting ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFlowFitting ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFlowFitting_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowFitting_DocumentReferences ADD CONSTRAINT
	PK_IfcFlowFitting_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFlowFitting (oid);

ALTER TABLE IfcFlowFitting ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcFlowFitting_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowFitting_Representations ADD CONSTRAINT
	PK_IfcFlowFitting_Representations FOREIGN KEY (pid)
	REFERENCES IfcFlowFitting (oid);

ALTER TABLE IfcFlowFitting ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcFlowFitting ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcFlowFitting_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowFitting_ControlElements ADD CONSTRAINT
	PK_IfcFlowFitting_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcFlowFitting (oid);

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]  TEXT (20);										
				
ALTER TABLE IfcFlowSegment ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowSegment ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFlowSegment ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFlowSegment_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowSegment_DocumentReferences ADD CONSTRAINT
	PK_IfcFlowSegment_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFlowSegment (oid);

ALTER TABLE IfcFlowSegment ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcFlowSegment_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowSegment_Representations ADD CONSTRAINT
	PK_IfcFlowSegment_Representations FOREIGN KEY (pid)
	REFERENCES IfcFlowSegment (oid);

ALTER TABLE IfcFlowSegment ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcFlowSegment ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcFlowSegment ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcFlowSegment_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowSegment_ControlElements ADD CONSTRAINT
	PK_IfcFlowSegment_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcFlowSegment (oid);

ALTER TABLE IfcFlowSegment ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcFlowTerminal (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFlowTerminal ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFlowTerminal_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowTerminal_DocumentReferences ADD CONSTRAINT
	PK_IfcFlowTerminal_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFlowTerminal (oid);

ALTER TABLE IfcFlowTerminal ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcFlowTerminal_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowTerminal_Representations ADD CONSTRAINT
	PK_IfcFlowTerminal_Representations FOREIGN KEY (pid)
	REFERENCES IfcFlowTerminal (oid);

ALTER TABLE IfcFlowTerminal ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcFlowTerminal ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcFlowTerminal_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFlowTerminal_ControlElements ADD CONSTRAINT
	PK_IfcFlowTerminal_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcFlowTerminal (oid);

ALTER TABLE IfcFlowTerminal ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcFurniture (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFurniture ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcFurniture ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFurniture ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFurniture ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFurniture_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFurniture_DocumentReferences ADD CONSTRAINT
	PK_IfcFurniture_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFurniture (oid);

ALTER TABLE IfcFurniture ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcFurniture_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFurniture_Representations ADD CONSTRAINT
	PK_IfcFurniture_Representations FOREIGN KEY (pid)
	REFERENCES IfcFurniture (oid);

ALTER TABLE IfcFurniture ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcFurniture ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcFurniture ADD COLUMN [PredefinedType] TEXT(50);
					
CREATE TABLE IfcFurniture_AssignedTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFurniture_AssignedTo ADD CONSTRAINT
	PK_IfcFurniture_AssignedTo FOREIGN KEY (pid)
	REFERENCES IfcFurniture (oid);

ALTER TABLE IfcFurniture ADD COLUMN [FurnitureModel] TEXT(50);
				
CREATE TABLE IfcFurnitureModel (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcFurnitureModel ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcFurnitureModel_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcFurnitureModel_DocumentReferences ADD CONSTRAINT
	PK_IfcFurnitureModel_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcFurnitureModel (oid);

ALTER TABLE IfcFurnitureModel ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [ModelID]  MEMO;										
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [ModelName]  MEMO;										
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [Manufacturer] TEXT(50);
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [CatalogName]  MEMO;										
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [BasicDescription]  MEMO;										
				
CREATE TABLE IfcFurnitureModel_BasicFeatures (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcFurnitureModel_BasicFeatures ADD CONSTRAINT
	PK_IfcFurnitureModel_BasicFeatures FOREIGN KEY (pid)
	REFERENCES IfcFurnitureModel (oid);

CREATE TABLE IfcFurnitureModel_AdjustableFeatures (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcFurnitureModel_AdjustableFeatures ADD CONSTRAINT
	PK_IfcFurnitureModel_AdjustableFeatures FOREIGN KEY (pid)
	REFERENCES IfcFurnitureModel (oid);

CREATE TABLE IfcFurnitureModel_Options (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcFurnitureModel_Options ADD CONSTRAINT
	PK_IfcFurnitureModel_Options FOREIGN KEY (pid)
	REFERENCES IfcFurnitureModel (oid);

ALTER TABLE IfcFurnitureModel ADD COLUMN [MaintenanceManual]  MEMO;										
				
ALTER TABLE IfcFurnitureModel ADD COLUMN [WarrantyDetails]  MEMO;										
				
CREATE TABLE IfcGeometricRepresentationContext (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGeometricRepresentationContext ADD COLUMN [GlobalId]  TEXT (20);										
				
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;										
				
CREATE TABLE IfcGridAxis (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGridAxis ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcGridAxis ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcGridAxis ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcGridAxis ADD COLUMN [PartOfGridLevel] TEXT(50);
				
ALTER TABLE IfcGridAxis ADD COLUMN [AxisTag]  MEMO;										
				
ALTER TABLE IfcGridAxis ADD COLUMN [AxisCurve] TEXT(50);
				
ALTER TABLE IfcGridAxis ADD COLUMN [SameSenseAsBaseCurve]  BIT;										
				
CREATE TABLE IfcGridIntersection (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGridIntersection ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcGridIntersection ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcGridIntersection ADD COLUMN [Label]  MEMO;										
					
CREATE TABLE IfcGridIntersection_AlignedWithAxes (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcGridIntersection_AlignedWithAxes ADD CONSTRAINT
	PK_IfcGridIntersection_AlignedWithAxes FOREIGN KEY (pid)
	REFERENCES IfcGridIntersection (oid);

ALTER TABLE IfcGridIntersection ADD COLUMN [IntersectionPoint] TEXT(50);
				
CREATE TABLE IfcGridLevel (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGridLevel ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcGridLevel ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcGridLevel ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcGridLevel ADD COLUMN [PartOfDesignGrid] TEXT(50);
				
ALTER TABLE IfcGridLevel ADD COLUMN [GridLevelHeight]  DOUBLE;										
				
ALTER TABLE IfcGridLevel ADD COLUMN [GridLevelName]  MEMO;										
				
CREATE TABLE IfcGroup (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcGroup ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcGroup ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcGroup ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcGroup ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcGroup_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcGroup_DocumentReferences ADD CONSTRAINT
	PK_IfcGroup_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcGroup (oid);

ALTER TABLE IfcGroup ADD COLUMN [GroupPurpose]  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 IfcInventory (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcInventory ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcInventory ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcInventory ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcInventory ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcInventory_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcInventory_DocumentReferences ADD CONSTRAINT
	PK_IfcInventory_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcInventory (oid);

ALTER TABLE IfcInventory ADD COLUMN [GroupPurpose]  MEMO;										
				
ALTER TABLE IfcInventory ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcInventory ADD COLUMN [Jurisdiction] TEXT(50);
					
CREATE TABLE IfcInventory_Responsible (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcInventory_Responsible ADD CONSTRAINT
	PK_IfcInventory_Responsible FOREIGN KEY (pid)
	REFERENCES IfcInventory (oid);

ALTER TABLE IfcInventory ADD COLUMN [LastUpdateDate]  TEXT(50);
					
CREATE TABLE IfcInventory_CurrentValue (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcInventory_CurrentValue ADD CONSTRAINT
	PK_IfcInventory_CurrentValue FOREIGN KEY (pid)
	REFERENCES IfcInventory (oid);
	
CREATE TABLE IfcInventory_OriginalValue (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcInventory_OriginalValue ADD CONSTRAINT
	PK_IfcInventory_OriginalValue FOREIGN KEY (pid)
	REFERENCES IfcInventory (oid);

CREATE TABLE IfcLaborResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLaborResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcLaborResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLaborResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcLaborResource_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLaborResource_DocumentReferences ADD CONSTRAINT
	PK_IfcLaborResource_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcLaborResource (oid);

ALTER TABLE IfcLaborResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [TypeReference]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [TypeName]  MEMO;										
				
ALTER TABLE IfcLaborResource ADD COLUMN [Classification] TEXT(50);
				
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 IfcLanding (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLanding ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcLanding ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLanding ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcLanding ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcLanding_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLanding_DocumentReferences ADD CONSTRAINT
	PK_IfcLanding_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcLanding (oid);

ALTER TABLE IfcLanding ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcLanding_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLanding_Representations ADD CONSTRAINT
	PK_IfcLanding_Representations FOREIGN KEY (pid)
	REFERENCES IfcLanding (oid);

ALTER TABLE IfcLanding ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcLanding ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcLanding ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcLanding ADD COLUMN [LayerInformation] TEXT(50);
				
ALTER TABLE IfcLanding ADD COLUMN [calcSlabArea]  DOUBLE;										
				
ALTER TABLE IfcLanding ADD COLUMN [calcSlabVolume]  DOUBLE;										
				
ALTER TABLE IfcLanding ADD COLUMN [calcHeadRoom]  DOUBLE;										
				
ALTER TABLE IfcLanding ADD COLUMN [calcWidth]  DOUBLE;										
				
ALTER TABLE IfcLanding ADD COLUMN [calcLength]  DOUBLE;										
				
CREATE TABLE IfcLibrary (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLibrary ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcLibrary ADD COLUMN [Version]  MEMO;										
				
ALTER TABLE IfcLibrary ADD COLUMN [Location]  MEMO;										
				
ALTER TABLE IfcLibrary ADD COLUMN [Publisher] TEXT(50);
				
ALTER TABLE IfcLibrary ADD COLUMN [VersionDate] TEXT(50);
				
CREATE TABLE IfcLibraryReference (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLibraryReference ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcLibraryReference ADD COLUMN [ReferencedLibrary] TEXT(50);
				
ALTER TABLE IfcLibraryReference ADD COLUMN [ReferencedItem]  MEMO;										
				
CREATE TABLE IfcLightFixture (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLightFixture ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcLightFixture ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLightFixture ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcLightFixture ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcLightFixture_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLightFixture_DocumentReferences ADD CONSTRAINT
	PK_IfcLightFixture_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcLightFixture (oid);

ALTER TABLE IfcLightFixture ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcLightFixture_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLightFixture_Representations ADD CONSTRAINT
	PK_IfcLightFixture_Representations FOREIGN KEY (pid)
	REFERENCES IfcLightFixture (oid);

ALTER TABLE IfcLightFixture ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcLightFixture ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcLightFixture ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcLightFixture_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLightFixture_ControlElements ADD CONSTRAINT
	PK_IfcLightFixture_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcLightFixture (oid);

ALTER TABLE IfcLightFixture ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcLightFixture ADD COLUMN [LuminousProperties] TEXT(50);
				
CREATE TABLE IfcLightSource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLightSource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcLightSource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLightSource ADD COLUMN [Label]  MEMO;										
					
CREATE TABLE IfcLightSource_SpectralPowerDistribution (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLightSource_SpectralPowerDistribution ADD CONSTRAINT
	PK_IfcLightSource_SpectralPowerDistribution FOREIGN KEY (pid)
	REFERENCES IfcLightSource (oid);
	
CREATE TABLE IfcLightSource_PhotometricOutputDistribution (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLightSource_PhotometricOutputDistribution ADD CONSTRAINT
	PK_IfcLightSource_PhotometricOutputDistribution FOREIGN KEY (pid)
	REFERENCES IfcLightSource (oid);

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 IfcLineConnectionGeometry (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLineConnectionGeometry ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcLineConnectionGeometry ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLineConnectionGeometry ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcLineConnectionGeometry ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcLineConnectionGeometry_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcLineConnectionGeometry_DocumentReferences ADD CONSTRAINT
	PK_IfcLineConnectionGeometry_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcLineConnectionGeometry (oid);

ALTER TABLE IfcLineConnectionGeometry ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcLineConnectionGeometry ADD COLUMN [LineOnRelatingElement] TEXT(50);
				
ALTER TABLE IfcLineConnectionGeometry ADD COLUMN [LineOnRelatedElement] TEXT(50);
				
CREATE TABLE IfcLocalPlacement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcLocalPlacement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcLocalPlacement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcLocalPlacement ADD COLUMN [Label]  MEMO;										
				
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 IfcMaintenanceRecord (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcMaintenanceRecord_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaintenanceRecord_DocumentReferences ADD CONSTRAINT
	PK_IfcMaintenanceRecord_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceRecord (oid);

ALTER TABLE IfcMaintenanceRecord ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [MaintenanceDate]  TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [MaintenanceType] TEXT(50);
					
CREATE TABLE IfcMaintenanceRecord_StandardMaintenanceTypes (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaintenanceRecord_StandardMaintenanceTypes ADD CONSTRAINT
	PK_IfcMaintenanceRecord_StandardMaintenanceTypes FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceRecord (oid);

ALTER TABLE IfcMaintenanceRecord ADD COLUMN [LastRecord] TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [MaintenanceActor]  TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [MaintenanceDuration]  DOUBLE;										
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [MaintenanceCost] TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [CurrentCondition] TEXT(50);
				
ALTER TABLE IfcMaintenanceRecord ADD COLUMN [Remark]  MEMO;										
				
CREATE TABLE IfcMaintenanceType (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaintenanceType ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcMaintenanceType_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaintenanceType_DocumentReferences ADD CONSTRAINT
	PK_IfcMaintenanceType_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceType (oid);

ALTER TABLE IfcMaintenanceType ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [MaintenanceTypeID]  MEMO;										
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [MaintenanceTypeName]  MEMO;										
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [MaintenanceObjectType]  MEMO;										
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [MaintenanceDescription]  MEMO;										
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [Manufacturer] TEXT(50);
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [MaintenancePeriod]  DOUBLE;										
				
ALTER TABLE IfcMaintenanceType ADD COLUMN [MaintenanceDuration]  DOUBLE;										
				
CREATE TABLE IfcManufactureInformation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcManufactureInformation ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [ModelLabel]  MEMO;										
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [ModelReference]  MEMO;										
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [Manufacturer] TEXT(50);
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [ShippingWeight]  DOUBLE;										
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [OperatingWeight]  DOUBLE;										
				
ALTER TABLE IfcManufactureInformation ADD COLUMN [WarrantyDuration]  DOUBLE;										
				
CREATE TABLE IfcManufactureInformation_WarrantyTerms (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcManufactureInformation_WarrantyTerms ADD CONSTRAINT
	PK_IfcManufactureInformation_WarrantyTerms FOREIGN KEY (pid)
	REFERENCES IfcManufactureInformation (oid);

CREATE TABLE IfcMaterial (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaterial ADD COLUMN [MaterialName]  MEMO;										
				
ALTER TABLE IfcMaterial ADD COLUMN [MaterialClassification] TEXT(50);
					
CREATE TABLE IfcMaterial_MaterialFinishes (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaterial_MaterialFinishes ADD CONSTRAINT
	PK_IfcMaterial_MaterialFinishes FOREIGN KEY (pid)
	REFERENCES IfcMaterial (oid);
	
CREATE TABLE IfcMaterial_Properties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaterial_Properties ADD CONSTRAINT
	PK_IfcMaterial_Properties FOREIGN KEY (pid)
	REFERENCES IfcMaterial (oid);

CREATE TABLE IfcMaterialFinish (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaterialFinish ADD COLUMN [FinishName]  MEMO;										
					
CREATE TABLE IfcMaterialFinish_Properties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaterialFinish_Properties ADD CONSTRAINT
	PK_IfcMaterialFinish_Properties FOREIGN KEY (pid)
	REFERENCES IfcMaterialFinish (oid);

CREATE TABLE IfcMaterialLayer (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaterialLayer ADD COLUMN [Material] TEXT(50);
				
ALTER TABLE IfcMaterialLayer ADD COLUMN [OffsetFromMLSBase]  DOUBLE;										
				
ALTER TABLE IfcMaterialLayer ADD COLUMN [LayerThickness]  DOUBLE;										
				
CREATE TABLE IfcMaterialLayerSet (
			
	oid TEXT(50) PRIMARY KEY
);
				
CREATE TABLE IfcMaterialLayerSet_HasMaterialLayers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMaterialLayerSet_HasMaterialLayers ADD CONSTRAINT
	PK_IfcMaterialLayerSet_HasMaterialLayers FOREIGN KEY (pid)
	REFERENCES IfcMaterialLayerSet (oid);

ALTER TABLE IfcMaterialLayerSet ADD COLUMN [IsVentilated]  BIT;										
				
CREATE TABLE IfcMaterialLayerSetUsage (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMaterialLayerSetUsage ADD COLUMN [ForLayerSet] TEXT(50);
				
ALTER TABLE IfcMaterialLayerSetUsage ADD COLUMN [MlsOffsetFromBaseline]  DOUBLE;										
				
ALTER TABLE IfcMaterialLayerSetUsage ADD COLUMN [MlsSenseLtoR]  BIT;										
				
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 IfcMetric (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMetric ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcMetric ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMetric ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcMetric ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcMetric_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMetric_DocumentReferences ADD CONSTRAINT
	PK_IfcMetric_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcMetric (oid);

ALTER TABLE IfcMetric ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcMetric ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcMetric ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcMetric ADD COLUMN [Source]  MEMO;										
				
CREATE TABLE IfcMetricBenchmark (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMetricBenchmark ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcMetricBenchmark_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcMetricBenchmark_DocumentReferences ADD CONSTRAINT
	PK_IfcMetricBenchmark_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcMetricBenchmark (oid);

ALTER TABLE IfcMetricBenchmark ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [Source]  MEMO;										
				
ALTER TABLE IfcMetricBenchmark ADD COLUMN [Benchmark] TEXT(50);
				
CREATE TABLE IfcMetricValue (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcMetricValue ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcMetricValue ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcMetricValue ADD COLUMN [Label]  MEMO;										
				
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 IfcNotationFacet (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcNotationFacet ADD COLUMN [NotationValue]  MEMO;										
				
ALTER TABLE IfcNotationFacet ADD COLUMN [Purpose]  MEMO;										
				
CREATE TABLE IfcObjective (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcObjective ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcObjective ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcObjective ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcObjective ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcObjective_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcObjective_DocumentReferences ADD CONSTRAINT
	PK_IfcObjective_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcObjective (oid);

ALTER TABLE IfcObjective ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcObjective ADD COLUMN [ConstraintGrade] TEXT(50);
				
ALTER TABLE IfcObjective ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcObjective ADD COLUMN [Source]  MEMO;										
				
ALTER TABLE IfcObjective ADD COLUMN [Objective] 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 IfcObjectReference (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcObjectReference ADD COLUMN [Name]  MEMO;										
					
CREATE TABLE IfcObjectReference_ObjectReference (
	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 IfcObjectReference_ObjectReference ADD CONSTRAINT
	PK_IfcObjectReference_ObjectReference FOREIGN KEY (pid)
	REFERENCES IfcObjectReference (oid);

CREATE TABLE IfcOccupancyNumber (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOccupancyNumber ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [ActualOccupancyNumber]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [DesignIntentOccupancyNumber]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [ActualCumulativeOccupancyNumber]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [DesignIntentCumulativeOccupancyNumber]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [OccupancyRate] TEXT(50);
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [ActualNumberOfResidents]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [DesignIntentNumberOfResidents]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [ResidentsOccupancyType] TEXT(50);
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [ActualNumberOfVisitors]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [DesignIntentNumberOfVisitors]  LONG;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [VisitorsOccupancyType] TEXT(50);
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [ActualPercentageRequiringAssistance]  DOUBLE;										
				
ALTER TABLE IfcOccupancyNumber ADD COLUMN [DesignIntentPercentageRequiringAssistance]  DOUBLE;										
				
CREATE TABLE IfcOccupancySchedule (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOccupancySchedule ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcOccupancySchedule ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOccupancySchedule ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcOccupancySchedule ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcOccupancySchedule_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancySchedule_DocumentReferences ADD CONSTRAINT
	PK_IfcOccupancySchedule_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcOccupancySchedule (oid);

ALTER TABLE IfcOccupancySchedule ADD COLUMN [Classification] TEXT(50);
					
CREATE TABLE IfcOccupancySchedule_SpaceProgramsToMove (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancySchedule_SpaceProgramsToMove ADD CONSTRAINT
	PK_IfcOccupancySchedule_SpaceProgramsToMove FOREIGN KEY (pid)
	REFERENCES IfcOccupancySchedule (oid);
	
CREATE TABLE IfcOccupancySchedule_NewlyOccupiedSpaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancySchedule_NewlyOccupiedSpaces ADD CONSTRAINT
	PK_IfcOccupancySchedule_NewlyOccupiedSpaces FOREIGN KEY (pid)
	REFERENCES IfcOccupancySchedule (oid);
	
CREATE TABLE IfcOccupancySchedule_NewlyEmptiedSpaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancySchedule_NewlyEmptiedSpaces ADD CONSTRAINT
	PK_IfcOccupancySchedule_NewlyEmptiedSpaces FOREIGN KEY (pid)
	REFERENCES IfcOccupancySchedule (oid);
	
CREATE TABLE IfcOccupancySchedule_ReoccupiedSpaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancySchedule_ReoccupiedSpaces ADD CONSTRAINT
	PK_IfcOccupancySchedule_ReoccupiedSpaces FOREIGN KEY (pid)
	REFERENCES IfcOccupancySchedule (oid);
	
CREATE TABLE IfcOccupancySchedule_OccupantsToMove (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancySchedule_OccupantsToMove ADD CONSTRAINT
	PK_IfcOccupancySchedule_OccupantsToMove FOREIGN KEY (pid)
	REFERENCES IfcOccupancySchedule (oid);
	
CREATE TABLE IfcOccupancySchedule_ScheduleElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancySchedule_ScheduleElements ADD CONSTRAINT
	PK_IfcOccupancySchedule_ScheduleElements FOREIGN KEY (pid)
	REFERENCES IfcOccupancySchedule (oid);

CREATE TABLE IfcOccupancyScheduleElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOccupancyScheduleElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcOccupancyScheduleElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOccupancyScheduleElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcOccupancyScheduleElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcOccupancyScheduleElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancyScheduleElement_DocumentReferences ADD CONSTRAINT
	PK_IfcOccupancyScheduleElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcOccupancyScheduleElement (oid);

ALTER TABLE IfcOccupancyScheduleElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcOccupancyScheduleElement ADD COLUMN [OccupancyTask] TEXT(50);
				
ALTER TABLE IfcOccupancyScheduleElement ADD COLUMN [TimeForSchedule] TEXT(50);
				
CREATE TABLE IfcOccupancyTask (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOccupancyTask ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcOccupancyTask ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOccupancyTask ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcOccupancyTask ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcOccupancyTask_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancyTask_DocumentReferences ADD CONSTRAINT
	PK_IfcOccupancyTask_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcOccupancyTask (oid);

ALTER TABLE IfcOccupancyTask ADD COLUMN [Productivity] TEXT(50);
				
ALTER TABLE IfcOccupancyTask ADD COLUMN [Classification] TEXT(50);
					
CREATE TABLE IfcOccupancyTask_OccupantsToMove (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancyTask_OccupantsToMove ADD CONSTRAINT
	PK_IfcOccupancyTask_OccupantsToMove FOREIGN KEY (pid)
	REFERENCES IfcOccupancyTask (oid);
	
CREATE TABLE IfcOccupancyTask_FFEtoMove (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancyTask_FFEtoMove ADD CONSTRAINT
	PK_IfcOccupancyTask_FFEtoMove FOREIGN KEY (pid)
	REFERENCES IfcOccupancyTask (oid);

ALTER TABLE IfcOccupancyTask ADD COLUMN [MoveType] TEXT(50);
					
CREATE TABLE IfcOccupancyTask_MoveFrom (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancyTask_MoveFrom ADD CONSTRAINT
	PK_IfcOccupancyTask_MoveFrom FOREIGN KEY (pid)
	REFERENCES IfcOccupancyTask (oid);
	
CREATE TABLE IfcOccupancyTask_MoveTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupancyTask_MoveTo ADD CONSTRAINT
	PK_IfcOccupancyTask_MoveTo FOREIGN KEY (pid)
	REFERENCES IfcOccupancyTask (oid);

ALTER TABLE IfcOccupancyTask ADD COLUMN [ConstraintType]  MEMO;										
				
ALTER TABLE IfcOccupancyTask ADD COLUMN [ConstraintTime]  TEXT(50);
				
CREATE TABLE IfcOccupant (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOccupant ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcOccupant ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOccupant ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcOccupant ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcOccupant_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOccupant_DocumentReferences ADD CONSTRAINT
	PK_IfcOccupant_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcOccupant (oid);

ALTER TABLE IfcOccupant ADD COLUMN [TheActor]  TEXT(50);
				
ALTER TABLE IfcOccupant ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcOpeningElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOpeningElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcOpeningElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcOpeningElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcOpeningElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcOpeningElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOpeningElement_DocumentReferences ADD CONSTRAINT
	PK_IfcOpeningElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcOpeningElement (oid);

ALTER TABLE IfcOpeningElement ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcOpeningElement_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcOpeningElement_Representations ADD CONSTRAINT
	PK_IfcOpeningElement_Representations FOREIGN KEY (pid)
	REFERENCES IfcOpeningElement (oid);

ALTER TABLE IfcOpeningElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcOpeningElement ADD COLUMN [calcOpeningArea]  DOUBLE;										
				
CREATE TABLE IfcOrganization (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcOrganization ADD COLUMN [Name]  MEMO;										
					
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 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);

ALTER TABLE IfcOrganization ADD COLUMN [Description]  MEMO;										
				
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 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 [ModifiedFlag]  TEXT(20);										
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [ApplicationId]  MEMO;										
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [OwnerDescriptor]  MEMO;										
				
ALTER TABLE IfcOwnerHistory ADD COLUMN [AuditTrail] TEXT(50);
				
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 IfcPermeableCovering (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPermeableCovering ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcPermeableCovering ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPermeableCovering ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcPermeableCovering ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcPermeableCovering_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPermeableCovering_DocumentReferences ADD CONSTRAINT
	PK_IfcPermeableCovering_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcPermeableCovering (oid);

ALTER TABLE IfcPermeableCovering ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcPermeableCovering_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPermeableCovering_Representations ADD CONSTRAINT
	PK_IfcPermeableCovering_Representations FOREIGN KEY (pid)
	REFERENCES IfcPermeableCovering (oid);

ALTER TABLE IfcPermeableCovering ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcPermeableCovering ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcPermeableCovering ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcPerson (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPerson ADD COLUMN [FamilyName]  MEMO;										
				
ALTER TABLE IfcPerson ADD COLUMN [GivenName]  MEMO;										
				
ALTER TABLE IfcPerson ADD COLUMN [MiddleNames]  MEMO;										
				
ALTER TABLE IfcPerson ADD COLUMN [PrefixTitles]  MEMO;										
				
ALTER TABLE IfcPerson ADD COLUMN [SuffixTitles]  MEMO;										
					
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 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 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 IfcPhotometricOutputSpace (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPhotometricOutputSpace ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcPhotometricOutputSpace ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPhotometricOutputSpace ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcPhotometricOutputSpace ADD COLUMN [OutputSpace] TEXT(50);
				
ALTER TABLE IfcPhotometricOutputSpace ADD COLUMN [OutputIntensity]  DOUBLE;										
				
CREATE TABLE IfcPlane (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPlane ADD COLUMN [Position] TEXT(50);
				
CREATE TABLE IfcPlumbingFixture (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPlumbingFixture ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcPlumbingFixture ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPlumbingFixture ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcPlumbingFixture ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcPlumbingFixture_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPlumbingFixture_DocumentReferences ADD CONSTRAINT
	PK_IfcPlumbingFixture_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcPlumbingFixture (oid);

ALTER TABLE IfcPlumbingFixture ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcPlumbingFixture_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPlumbingFixture_Representations ADD CONSTRAINT
	PK_IfcPlumbingFixture_Representations FOREIGN KEY (pid)
	REFERENCES IfcPlumbingFixture (oid);

ALTER TABLE IfcPlumbingFixture ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcPlumbingFixture ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcPlumbingFixture ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcPlumbingFixture_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPlumbingFixture_ControlElements ADD CONSTRAINT
	PK_IfcPlumbingFixture_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcPlumbingFixture (oid);

ALTER TABLE IfcPlumbingFixture ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcPointConnectionGeometry (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPointConnectionGeometry ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcPointConnectionGeometry ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPointConnectionGeometry ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcPointConnectionGeometry ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcPointConnectionGeometry_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPointConnectionGeometry_DocumentReferences ADD CONSTRAINT
	PK_IfcPointConnectionGeometry_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcPointConnectionGeometry (oid);

ALTER TABLE IfcPointConnectionGeometry ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcPointConnectionGeometry ADD COLUMN [PointOnRelatingElement] TEXT(50);
				
ALTER TABLE IfcPointConnectionGeometry ADD COLUMN [PointOnRelatedElement] 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 IfcProductDefinitionShape (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProductDefinitionShape ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcProductDefinitionShape ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProductDefinitionShape ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcProductDefinitionShape ADD COLUMN [Description]  MEMO;										
					
CREATE TABLE IfcProductDefinitionShape_ShapeRepresentations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProductDefinitionShape_ShapeRepresentations ADD CONSTRAINT
	PK_IfcProductDefinitionShape_ShapeRepresentations FOREIGN KEY (pid)
	REFERENCES IfcProductDefinitionShape (oid);

CREATE TABLE IfcProductDefinitionTopology (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProductDefinitionTopology ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcProductDefinitionTopology ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProductDefinitionTopology ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcProductDefinitionTopology ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcProductDefinitionTopology ADD COLUMN [TopologyRepresentation] TEXT(50);
				
CREATE TABLE IfcProductResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProductResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcProductResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProductResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcProductResource ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcProductResource_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProductResource_DocumentReferences ADD CONSTRAINT
	PK_IfcProductResource_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcProductResource (oid);

ALTER TABLE IfcProductResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcProductResource ADD COLUMN [TypeReference]  MEMO;										
				
ALTER TABLE IfcProductResource ADD COLUMN [TypeName]  MEMO;										
				
ALTER TABLE IfcProductResource ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcProductResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcProductResource ADD COLUMN [BaseUnit] TEXT(50);
				
ALTER TABLE IfcProductResource ADD COLUMN [ResourceProduct] TEXT(50);
				
CREATE TABLE IfcProject (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProject ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcProject ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProject ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcProject_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProject_DocumentReferences ADD CONSTRAINT
	PK_IfcProject_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcProject (oid);

ALTER TABLE IfcProject ADD COLUMN [ReferenceName]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [Phase]  MEMO;										
				
ALTER TABLE IfcProject ADD COLUMN [UnitsInContext] TEXT(50);
				
ALTER TABLE IfcProject ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcProject ADD COLUMN [AbsolutePlacement]  TEXT(50);
				
CREATE TABLE IfcProjectOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProjectOrder ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcProjectOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProjectOrder ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcProjectOrder ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcProjectOrder_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProjectOrder_DocumentReferences ADD CONSTRAINT
	PK_IfcProjectOrder_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcProjectOrder (oid);

ALTER TABLE IfcProjectOrder ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcProjectOrder ADD COLUMN [OrderNo]  MEMO;										
				
ALTER TABLE IfcProjectOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcProjectOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcProjectOrder ADD COLUMN [IssuingDate]  TEXT(50);
				
ALTER TABLE IfcProjectOrder ADD COLUMN [IssuingCompany] TEXT(50);
				
ALTER TABLE IfcProjectOrder ADD COLUMN [IssuedBy]  TEXT(50);
					
CREATE TABLE IfcProjectOrder_IssuedTo (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProjectOrder_IssuedTo ADD CONSTRAINT
	PK_IfcProjectOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcProjectOrder (oid);
	
CREATE TABLE IfcProjectOrder_AdditionalContacts (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProjectOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcProjectOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcProjectOrder (oid);

ALTER TABLE IfcProjectOrder ADD COLUMN [Remark]  MEMO;										
				
CREATE TABLE IfcPropertyList (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertyList ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcPropertyList ADD COLUMN [UserMin]  LONG;										
				
ALTER TABLE IfcPropertyList ADD COLUMN [Max]  LONG;										
					
CREATE TABLE IfcPropertyList_HasProperties (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPropertyList_HasProperties ADD CONSTRAINT
	PK_IfcPropertyList_HasProperties FOREIGN KEY (pid)
	REFERENCES IfcPropertyList (oid);

CREATE TABLE IfcPropertySet (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPropertySet ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcPropertySet ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPropertySet ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcPropertySet ADD COLUMN [Name]  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 IfcProxy (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcProxy ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcProxy ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcProxy ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcProxy ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcProxy_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProxy_DocumentReferences ADD CONSTRAINT
	PK_IfcProxy_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcProxy (oid);

ALTER TABLE IfcProxy ADD COLUMN [ProxyType] TEXT(50);
				
ALTER TABLE IfcProxy ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcProxy_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcProxy_Representations ADD CONSTRAINT
	PK_IfcProxy_Representations FOREIGN KEY (pid)
	REFERENCES IfcProxy (oid);

CREATE TABLE IfcPurchaseOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcPurchaseOrder ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcPurchaseOrder_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcPurchaseOrder_DocumentReferences ADD CONSTRAINT
	PK_IfcPurchaseOrder_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcPurchaseOrder (oid);

ALTER TABLE IfcPurchaseOrder ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [OrderNo]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [IssuingDate]  TEXT(50);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [IssuingCompany] 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);

ALTER TABLE IfcPurchaseOrder ADD COLUMN [Remark]  MEMO;										
				
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);
				
ALTER TABLE IfcPurchaseOrder ADD COLUMN [BudgetSource] TEXT(50);
				
CREATE TABLE IfcRailing (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRailing ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRailing ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRailing ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRailing ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcRailing_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRailing_DocumentReferences ADD CONSTRAINT
	PK_IfcRailing_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcRailing (oid);

ALTER TABLE IfcRailing ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcRailing_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRailing_Representations ADD CONSTRAINT
	PK_IfcRailing_Representations FOREIGN KEY (pid)
	REFERENCES IfcRailing (oid);

ALTER TABLE IfcRailing ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcRailing ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcRailing ADD COLUMN [PredefinedType] TEXT(50);
					
CREATE TABLE IfcRailing_RailingHardware (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRailing_RailingHardware ADD CONSTRAINT
	PK_IfcRailing_RailingHardware FOREIGN KEY (pid)
	REFERENCES IfcRailing (oid);

CREATE TABLE IfcRamp (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRamp ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRamp ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRamp ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRamp ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcRamp_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRamp_DocumentReferences ADD CONSTRAINT
	PK_IfcRamp_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcRamp (oid);

ALTER TABLE IfcRamp ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcRamp_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRamp_Representations ADD CONSTRAINT
	PK_IfcRamp_Representations FOREIGN KEY (pid)
	REFERENCES IfcRamp (oid);

ALTER TABLE IfcRamp ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcRamp ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcRamp ADD COLUMN [PredefinedType] TEXT(50);
					
CREATE TABLE IfcRamp_VerticallyConnects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRamp_VerticallyConnects ADD CONSTRAINT
	PK_IfcRamp_VerticallyConnects FOREIGN KEY (pid)
	REFERENCES IfcRamp (oid);

CREATE TABLE IfcRampFlight (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRampFlight ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRampFlight ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRampFlight ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcRampFlight_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRampFlight_DocumentReferences ADD CONSTRAINT
	PK_IfcRampFlight_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcRampFlight (oid);

ALTER TABLE IfcRampFlight ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcRampFlight_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRampFlight_Representations ADD CONSTRAINT
	PK_IfcRampFlight_Representations FOREIGN KEY (pid)
	REFERENCES IfcRampFlight (oid);

ALTER TABLE IfcRampFlight ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcRampFlight ADD COLUMN [HasMaterial]  TEXT(50);
					
CREATE TABLE IfcRampFlight_VerticallyConnects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRampFlight_VerticallyConnects ADD CONSTRAINT
	PK_IfcRampFlight_VerticallyConnects FOREIGN KEY (pid)
	REFERENCES IfcRampFlight (oid);

ALTER TABLE IfcRampFlight ADD COLUMN [calcLength]  DOUBLE;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [calcWidth]  DOUBLE;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [calcRise]  DOUBLE;										
				
ALTER TABLE IfcRampFlight ADD COLUMN [calcSlope]  DOUBLE;										
				
CREATE TABLE IfcRectangleProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [ProfileType] TEXT(50);
				
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [XDim]  DOUBLE;										
				
ALTER TABLE IfcRectangleProfileDef ADD COLUMN [YDim]  DOUBLE;										
				
CREATE TABLE IfcReferenceCurve (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcReferenceCurve ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcReferenceCurve ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcReferenceCurve ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcReferenceCurve ADD COLUMN [LocalPlacement] TEXT(50);
				
ALTER TABLE IfcReferenceCurve ADD COLUMN [ReferenceCurve] TEXT(50);
				
CREATE TABLE IfcReferencePoint (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcReferencePoint ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcReferencePoint ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcReferencePoint ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcReferencePoint ADD COLUMN [LocalPlacement] TEXT(50);
				
ALTER TABLE IfcReferencePoint ADD COLUMN [ReferencePoint] TEXT(50);
				
CREATE TABLE IfcReferenceSurface (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcReferenceSurface ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcReferenceSurface ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcReferenceSurface ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcReferenceSurface ADD COLUMN [LocalPlacement] TEXT(50);
				
ALTER TABLE IfcReferenceSurface ADD COLUMN [ReferenceSurface] TEXT(50);
				
CREATE TABLE IfcRelActsUpon (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelActsUpon ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelActsUpon ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelActsUpon ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelActsUpon ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelActsUpon ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelActsUpon ADD COLUMN [RelatingActor] TEXT(50);
					
CREATE TABLE IfcRelActsUpon_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelActsUpon_RelatedObjects ADD CONSTRAINT
	PK_IfcRelActsUpon_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelActsUpon (oid);

ALTER TABLE IfcRelActsUpon ADD COLUMN [ActingRole] TEXT(50);
				
CREATE TABLE IfcRelAdjacencyReq (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [RelatingSpaceProgram] TEXT(50);
				
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [RelatedSpaceProgram] TEXT(50);
				
ALTER TABLE IfcRelAdjacencyReq ADD COLUMN [AdjacencyImportanceRating]  LONG;										
				
CREATE TABLE IfcRelAggregatesConstraints (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAggregatesConstraints ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAggregatesConstraints ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAggregatesConstraints ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAggregatesConstraints ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAggregatesConstraints ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAggregatesConstraints ADD COLUMN [LogicalAggregator] TEXT(50);
				
ALTER TABLE IfcRelAggregatesConstraints ADD COLUMN [RelatingConstraint] TEXT(50);
					
CREATE TABLE IfcRelAggregatesConstraints_RelatedConstraints (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAggregatesConstraints_RelatedConstraints ADD CONSTRAINT
	PK_IfcRelAggregatesConstraints_RelatedConstraints FOREIGN KEY (pid)
	REFERENCES IfcRelAggregatesConstraints (oid);

CREATE TABLE IfcRelAggregatesCrewResources (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [RelatingCrewResource] TEXT(50);
					
CREATE TABLE IfcRelAggregatesCrewResources_RelatedResources (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAggregatesCrewResources_RelatedResources ADD CONSTRAINT
	PK_IfcRelAggregatesCrewResources_RelatedResources FOREIGN KEY (pid)
	REFERENCES IfcRelAggregatesCrewResources (oid);

ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [RequiredQuantity]  DOUBLE;										
				
ALTER TABLE IfcRelAggregatesCrewResources ADD COLUMN [ConversionRate] TEXT(50);
				
CREATE TABLE IfcRelAssemblesElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssemblesElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAssemblesElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssemblesElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAssemblesElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssemblesElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssemblesElements ADD COLUMN [RelatingElement] TEXT(50);
					
CREATE TABLE IfcRelAssemblesElements_RelatedElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssemblesElements_RelatedElements ADD CONSTRAINT
	PK_IfcRelAssemblesElements_RelatedElements FOREIGN KEY (pid)
	REFERENCES IfcRelAssemblesElements (oid);

CREATE TABLE IfcRelAssemblesSpaces (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssemblesSpaces ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAssemblesSpaces ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssemblesSpaces ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAssemblesSpaces ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssemblesSpaces ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssemblesSpaces ADD COLUMN [RelatingSpace] TEXT(50);
					
CREATE TABLE IfcRelAssemblesSpaces_RelatedSpaces (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssemblesSpaces_RelatedSpaces ADD CONSTRAINT
	PK_IfcRelAssemblesSpaces_RelatedSpaces FOREIGN KEY (pid)
	REFERENCES IfcRelAssemblesSpaces (oid);

CREATE TABLE IfcRelAssignsApprovals (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsApprovals ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAssignsApprovals ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsApprovals ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAssignsApprovals ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssignsApprovals ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssignsApprovals ADD COLUMN [RelatingControl] TEXT(50);
					
CREATE TABLE IfcRelAssignsApprovals_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsApprovals_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsApprovals_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsApprovals (oid);

CREATE TABLE IfcRelAssignsProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsProperties ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAssignsProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsProperties ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAssignsProperties ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssignsProperties ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssignsProperties ADD COLUMN [RelatingPropertyDefinition] TEXT(50);
					
CREATE TABLE IfcRelAssignsProperties_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsProperties_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsProperties_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsProperties (oid);

ALTER TABLE IfcRelAssignsProperties ADD COLUMN [DomainView]  MEMO;										
				
CREATE TABLE IfcRelAssignsTypedProperties (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [RelatingPropertyDefinition] TEXT(50);
					
CREATE TABLE IfcRelAssignsTypedProperties_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAssignsTypedProperties_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsTypedProperties_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsTypedProperties (oid);

ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [DomainView]  MEMO;										
				
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcRelAssignsTypedProperties ADD COLUMN [TypedClass]  MEMO;										
				
CREATE TABLE IfcRelAttachesElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAttachesElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAttachesElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAttachesElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAttachesElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAttachesElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAttachesElements ADD COLUMN [RelatingDiscreteElement] TEXT(50);
					
CREATE TABLE IfcRelAttachesElements_RelatedDistributionElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAttachesElements_RelatedDistributionElements ADD CONSTRAINT
	PK_IfcRelAttachesElements_RelatedDistributionElements FOREIGN KEY (pid)
	REFERENCES IfcRelAttachesElements (oid);

ALTER TABLE IfcRelAttachesElements ADD COLUMN [AttachmentLocation] TEXT(50);
				
CREATE TABLE IfcRelAttachesToBoundaries (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelAttachesToBoundaries ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelAttachesToBoundaries ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelAttachesToBoundaries ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelAttachesToBoundaries ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelAttachesToBoundaries ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelAttachesToBoundaries ADD COLUMN [RelatingSpaceBoundary] TEXT(50);
					
CREATE TABLE IfcRelAttachesToBoundaries_RelatedCoverings (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelAttachesToBoundaries_RelatedCoverings ADD CONSTRAINT
	PK_IfcRelAttachesToBoundaries_RelatedCoverings FOREIGN KEY (pid)
	REFERENCES IfcRelAttachesToBoundaries (oid);

CREATE TABLE IfcRelConnectsElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelConnectsElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelConnectsElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
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]  TEXT (20);										
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
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 [RelatingConnectionType] TEXT(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD COLUMN [RelatedConnectionType] TEXT(50);
				
CREATE TABLE IfcRelConnectsPorts (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelConnectsPorts ADD COLUMN [RelatingIsDependent]  BIT;										
				
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 [ConnectionGeometry] TEXT(50);
				
CREATE TABLE IfcRelContains (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelContains ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelContains ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelContains ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelContains ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelContains ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelContains ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelContains_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelContains_RelatedObjects ADD CONSTRAINT
	PK_IfcRelContains_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelContains (oid);

ALTER TABLE IfcRelContains ADD COLUMN [RelationshipType] TEXT(50);
				
ALTER TABLE IfcRelContains ADD COLUMN [ContainedOrReferenced] TEXT(50);
				
CREATE TABLE IfcRelControls (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelControls ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelControls ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelControls ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelControls ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelControls ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelControls ADD COLUMN [RelatingControl] TEXT(50);
					
CREATE TABLE IfcRelControls_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelControls_RelatedObjects ADD CONSTRAINT
	PK_IfcRelControls_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelControls (oid);

CREATE TABLE IfcRelControlsMaintenance (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelControlsMaintenance ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelControlsMaintenance ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelControlsMaintenance ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelControlsMaintenance ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelControlsMaintenance ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelControlsMaintenance ADD COLUMN [RelatingControl] TEXT(50);
					
CREATE TABLE IfcRelControlsMaintenance_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelControlsMaintenance_RelatedObjects ADD CONSTRAINT
	PK_IfcRelControlsMaintenance_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelControlsMaintenance (oid);

CREATE TABLE IfcRelCostsObjects (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelCostsObjects ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelCostsObjects ADD COLUMN [RelatingControl] TEXT(50);
					
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);

CREATE TABLE IfcRelCoversBldgElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelCoversBldgElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
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 IfcRelFillsElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelFillsElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [RelatingOpeningElement] TEXT(50);
				
ALTER TABLE IfcRelFillsElement ADD COLUMN [RelatedBuildingElement] TEXT(50);
				
CREATE TABLE IfcRelGroups (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelGroups ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelGroups ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelGroups ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelGroups ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelGroups ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelGroups ADD COLUMN [RelatingGroup] TEXT(50);
					
CREATE TABLE IfcRelGroups_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelGroups_RelatedObjects ADD CONSTRAINT
	PK_IfcRelGroups_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelGroups (oid);

CREATE TABLE IfcRelJoinsElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelJoinsElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [ConnectionGeometry] TEXT(50);
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [RelatingElement] TEXT(50);
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [RelatedElement] TEXT(50);
					
CREATE TABLE IfcRelJoinsElements_JointElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelJoinsElements_JointElements ADD CONSTRAINT
	PK_IfcRelJoinsElements_JointElements FOREIGN KEY (pid)
	REFERENCES IfcRelJoinsElements (oid);

ALTER TABLE IfcRelJoinsElements ADD COLUMN [JoinType] TEXT(50);
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [RangeOfMovement]  DOUBLE;										
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [FireRating]  DOUBLE;										
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [WaterProofingRequired]  BYTE;										
				
ALTER TABLE IfcRelJoinsElements ADD COLUMN [VentilationRequired]  BYTE;										
				
CREATE TABLE IfcRelNests (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNests ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNests ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNests ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNests ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNests ADD COLUMN [RelatingIsDependent]  BIT;										
				
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);

ALTER TABLE IfcRelNests ADD COLUMN [NestingPurpose]  MEMO;										
				
CREATE TABLE IfcRelNestsCostElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNestsCostElements_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNestsCostElements_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNestsCostElements_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNestsCostElements (oid);

ALTER TABLE IfcRelNestsCostElements ADD COLUMN [NestingPurpose]  MEMO;										
				
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelNestsCostElements ADD COLUMN [Criteria]  MEMO;										
				
CREATE TABLE IfcRelNestsCostSchedules (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNestsCostSchedules_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNestsCostSchedules_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNestsCostSchedules_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNestsCostSchedules (oid);

ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [NestingPurpose]  MEMO;										
				
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelNestsCostSchedules ADD COLUMN [Criteria]  MEMO;										
				
CREATE TABLE IfcRelNestsOccupancyScheduleElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNestsOccupancyScheduleElements_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNestsOccupancyScheduleElements_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNestsOccupancyScheduleElements_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNestsOccupancyScheduleElements (oid);

ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [NestingPurpose]  MEMO;										
				
ALTER TABLE IfcRelNestsOccupancyScheduleElements ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcRelNestsOccupancySchedules (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNestsOccupancySchedules_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNestsOccupancySchedules_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNestsOccupancySchedules_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNestsOccupancySchedules (oid);

ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [NestingPurpose]  MEMO;										
				
ALTER TABLE IfcRelNestsOccupancySchedules ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcRelNestsProcesses (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNestsProcesses ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNestsProcesses ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNestsProcesses ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNestsProcesses ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsProcesses ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsProcesses ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNestsProcesses_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNestsProcesses_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNestsProcesses_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNestsProcesses (oid);

ALTER TABLE IfcRelNestsProcesses ADD COLUMN [NestingPurpose]  MEMO;										
				
ALTER TABLE IfcRelNestsProcesses ADD COLUMN [Criteria]  MEMO;										
				
CREATE TABLE IfcRelNestsWorkScheduleElements (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNestsWorkScheduleElements_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNestsWorkScheduleElements_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNestsWorkScheduleElements_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNestsWorkScheduleElements (oid);

ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [NestingPurpose]  MEMO;										
				
ALTER TABLE IfcRelNestsWorkScheduleElements ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcRelNestsWorkSchedules (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [RelatingObject] TEXT(50);
					
CREATE TABLE IfcRelNestsWorkSchedules_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelNestsWorkSchedules_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNestsWorkSchedules_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNestsWorkSchedules (oid);

ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [NestingPurpose]  MEMO;										
				
ALTER TABLE IfcRelNestsWorkSchedules ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcRelOccupiesSpaces (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelOccupiesSpaces ADD COLUMN [RelatingActor] TEXT(50);
					
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 [ActingRole] TEXT(50);
				
CREATE TABLE IfcRelProcessOperatesOn (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [RelatingProcess] TEXT(50);
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [RelatedObject] TEXT(50);
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [OperationType]  MEMO;										
				
ALTER TABLE IfcRelProcessOperatesOn ADD COLUMN [OperationQuantity] TEXT(50);
				
CREATE TABLE IfcRelRelatesConstraints (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelRelatesConstraints ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelRelatesConstraints ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelRelatesConstraints ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelRelatesConstraints ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelRelatesConstraints ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelRelatesConstraints ADD COLUMN [RelatingControl] TEXT(50);
					
CREATE TABLE IfcRelRelatesConstraints_RelatedObjects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelRelatesConstraints_RelatedObjects ADD CONSTRAINT
	PK_IfcRelRelatesConstraints_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelRelatesConstraints (oid);

ALTER TABLE IfcRelRelatesConstraints ADD COLUMN [ConstraintRelationship] TEXT(50);
				
CREATE TABLE IfcRelSeparatesSpaces (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelSeparatesSpaces ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelSeparatesSpaces ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelSeparatesSpaces ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelSeparatesSpaces ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelSeparatesSpaces ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelSeparatesSpaces ADD COLUMN [RelatingBuildingElement] TEXT(50);
					
CREATE TABLE IfcRelSeparatesSpaces_RelatedSpaceBoundaries (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRelSeparatesSpaces_RelatedSpaceBoundaries ADD CONSTRAINT
	PK_IfcRelSeparatesSpaces_RelatedSpaceBoundaries FOREIGN KEY (pid)
	REFERENCES IfcRelSeparatesSpaces (oid);

CREATE TABLE IfcRelSequence (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelSequence ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelSequence ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelSequence ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelSequence ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelSequence ADD COLUMN [RelatingIsDependent]  BIT;										
				
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]  TEXT (20);										
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelServicesBuildings ADD COLUMN [RelatingIsDependent]  BIT;										
				
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 IfcRelUsesResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelUsesResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [RelatingProcess] TEXT(50);
				
ALTER TABLE IfcRelUsesResource ADD COLUMN [RelatedResource] 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]  TEXT (20);										
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [RelatingBuildingElement] TEXT(50);
				
ALTER TABLE IfcRelVoidsElement ADD COLUMN [RelatedOpeningElement] TEXT(50);
				
CREATE TABLE IfcRelWorkInteraction (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [RelatedIsDependent]  BIT;										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [RelatingIsDependent]  BIT;										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [RelatingActor] TEXT(50);
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [RelatedActor] TEXT(50);
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [RelatingSpaceProgram] TEXT(50);
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [RelatedSpaceProgram] TEXT(50);
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [DailyFrequency]  LONG;										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [ImportanceRating]  LONG;										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [AverageDuration]  DOUBLE;										
				
ALTER TABLE IfcRelWorkInteraction ADD COLUMN [Location] TEXT(50);
				
CREATE TABLE IfcRepresentationContext (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRepresentationContext ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcRepresentationContext ADD COLUMN [ContextIdentifier]  MEMO;										
				
ALTER TABLE IfcRepresentationContext ADD COLUMN [ContextType]  MEMO;										
				
CREATE TABLE IfcResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcResource ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcResource_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcResource_DocumentReferences ADD CONSTRAINT
	PK_IfcResource_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcResource (oid);

ALTER TABLE IfcResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcResource ADD COLUMN [TypeReference]  MEMO;										
				
ALTER TABLE IfcResource ADD COLUMN [TypeName]  MEMO;										
				
ALTER TABLE IfcResource ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcResource ADD COLUMN [ResourceConsumption] TEXT(50);
				
ALTER TABLE IfcResource ADD COLUMN [BaseUnit] TEXT(50);
				
CREATE TABLE IfcRevolvedAreaSolid (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcRevolvedAreaSolid ADD COLUMN [SweptArea] 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]  TEXT (20);										
				
ALTER TABLE IfcRoof ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcRoof ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcRoof ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcRoof_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRoof_DocumentReferences ADD CONSTRAINT
	PK_IfcRoof_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcRoof (oid);

ALTER TABLE IfcRoof ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcRoof_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcRoof_Representations ADD CONSTRAINT
	PK_IfcRoof_Representations FOREIGN KEY (pid)
	REFERENCES IfcRoof (oid);

ALTER TABLE IfcRoof ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcRoof ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcRoof ADD COLUMN [calcTotalRoofSurfaceArea]  DOUBLE;										
				
CREATE TABLE IfcScheduleTimeControl (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcScheduleTimeControl_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcScheduleTimeControl_DocumentReferences ADD CONSTRAINT
	PK_IfcScheduleTimeControl_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcScheduleTimeControl (oid);

ALTER TABLE IfcScheduleTimeControl ADD COLUMN [Classification] TEXT(50);
				
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 [TaskStatus] TEXT(50);
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [IsCritical]  BIT;										
				
ALTER TABLE IfcScheduleTimeControl ADD COLUMN [StatusTime]  TEXT(50);
				
CREATE TABLE IfcSensor (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSensor ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSensor ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSensor ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSensor_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSensor_DocumentReferences ADD CONSTRAINT
	PK_IfcSensor_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSensor (oid);

ALTER TABLE IfcSensor ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcSensor_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSensor_Representations ADD CONSTRAINT
	PK_IfcSensor_Representations FOREIGN KEY (pid)
	REFERENCES IfcSensor (oid);

ALTER TABLE IfcSensor ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcSensor ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcSensor ADD COLUMN [ControlElementID]  MEMO;										
				
ALTER TABLE IfcSensor ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcShapeAspect (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcShapeAspect ADD COLUMN [GlobalId]  TEXT (20);										
					
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 IfcSimpleProperty (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSimpleProperty ADD COLUMN [Name]  MEMO;										
					
CREATE TABLE IfcSimpleProperty_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 IfcSimpleProperty_ValueComponent ADD CONSTRAINT
	PK_IfcSimpleProperty_ValueComponent FOREIGN KEY (pid)
	REFERENCES IfcSimpleProperty (oid);

CREATE TABLE IfcSimplePropertyWithUnit (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSimplePropertyWithUnit ADD COLUMN [Name]  MEMO;										
				
ALTER TABLE IfcSimplePropertyWithUnit ADD COLUMN [ValueWithUnit] TEXT(50);
				
CREATE TABLE IfcSite (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSite ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSite ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSite ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSite ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSite_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSite_DocumentReferences ADD CONSTRAINT
	PK_IfcSite_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSite (oid);

ALTER TABLE IfcSite ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcSite_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSite_Representations ADD CONSTRAINT
	PK_IfcSite_Representations FOREIGN KEY (pid)
	REFERENCES IfcSite (oid);

ALTER TABLE IfcSite ADD COLUMN [Classification] 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 [TrueNorth] TEXT(50);
				
ALTER TABLE IfcSite ADD COLUMN [calcSitePerimeter]  DOUBLE;										
				
ALTER TABLE IfcSite ADD COLUMN [calcSiteArea]  DOUBLE;										
				
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]  TEXT (20);										
				
ALTER TABLE IfcSlab ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSlab ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSlab_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSlab_DocumentReferences ADD CONSTRAINT
	PK_IfcSlab_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSlab (oid);

ALTER TABLE IfcSlab ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcSlab_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSlab_Representations ADD CONSTRAINT
	PK_IfcSlab_Representations FOREIGN KEY (pid)
	REFERENCES IfcSlab (oid);

ALTER TABLE IfcSlab ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [LayerInformation] TEXT(50);
				
ALTER TABLE IfcSlab ADD COLUMN [calcSlabArea]  DOUBLE;										
				
ALTER TABLE IfcSlab ADD COLUMN [calcSlabVolume]  DOUBLE;										
				
CREATE TABLE IfcSpace (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpace ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSpace ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpace ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSpace_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSpace_DocumentReferences ADD CONSTRAINT
	PK_IfcSpace_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSpace (oid);

ALTER TABLE IfcSpace ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcSpace_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSpace_Representations ADD CONSTRAINT
	PK_IfcSpace_Representations FOREIGN KEY (pid)
	REFERENCES IfcSpace (oid);

ALTER TABLE IfcSpace ADD COLUMN [Classification] TEXT(50);
					
CREATE TABLE IfcSpace_BoundedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSpace_BoundedBy ADD CONSTRAINT
	PK_IfcSpace_BoundedBy FOREIGN KEY (pid)
	REFERENCES IfcSpace (oid);

ALTER TABLE IfcSpace ADD COLUMN [InteriorOrExteriorSpace] TEXT(50);
				
ALTER TABLE IfcSpace ADD COLUMN [SpaceReference]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [SpaceName]  MEMO;										
				
ALTER TABLE IfcSpace ADD COLUMN [calcTotalPerimeter]  DOUBLE;										
				
ALTER TABLE IfcSpace ADD COLUMN [calcTotalArea]  DOUBLE;										
				
ALTER TABLE IfcSpace ADD COLUMN [calcTotalVolume]  DOUBLE;										
				
ALTER TABLE IfcSpace ADD COLUMN [calcAverageHeight]  DOUBLE;										
				
ALTER TABLE IfcSpace ADD COLUMN [calcAverageGrossHeight]  DOUBLE;										
				
ALTER TABLE IfcSpace ADD COLUMN [calcAverageClearHeight]  DOUBLE;										
				
ALTER TABLE IfcSpace ADD COLUMN [calcElevationWithFlooring]  DOUBLE;										
				
CREATE TABLE IfcSpaceBoundary (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpaceBoundary ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSpaceBoundary ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpaceBoundary ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSpaceBoundary ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSpaceBoundary_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSpaceBoundary_DocumentReferences ADD CONSTRAINT
	PK_IfcSpaceBoundary_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSpaceBoundary (oid);

ALTER TABLE IfcSpaceBoundary ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcSpaceBoundary_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSpaceBoundary_Representations ADD CONSTRAINT
	PK_IfcSpaceBoundary_Representations FOREIGN KEY (pid)
	REFERENCES IfcSpaceBoundary (oid);

ALTER TABLE IfcSpaceBoundary ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcSpaceBoundary ADD COLUMN [PhysicalOrVirtualBoundary] TEXT(50);
				
ALTER TABLE IfcSpaceBoundary ADD COLUMN [InternalOrExternalBoundary] TEXT(50);
				
ALTER TABLE IfcSpaceBoundary ADD COLUMN [calcBoundarySurfaceArea]  DOUBLE;										
				
CREATE TABLE IfcSpaceProgram (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpaceProgram ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSpaceProgram_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSpaceProgram_DocumentReferences ADD CONSTRAINT
	PK_IfcSpaceProgram_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSpaceProgram (oid);

ALTER TABLE IfcSpaceProgram ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [SpaceProgramName]  MEMO;										
				
ALTER TABLE IfcSpaceProgram ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcSpaceProgramGroup (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSpaceProgramGroup_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSpaceProgramGroup_DocumentReferences ADD CONSTRAINT
	PK_IfcSpaceProgramGroup_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSpaceProgramGroup (oid);

ALTER TABLE IfcSpaceProgramGroup ADD COLUMN [GroupPurpose]  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 IfcSpaceUseCase (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSpaceUseCase ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [LossOrGain] TEXT(50);
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [RequirementOrCriteria] TEXT(50);
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [Source] TEXT(50);
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [SourceDescription]  MEMO;										
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [MaximumValue] TEXT(50);
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [ApplicableValueRatio]  DOUBLE;										
				
ALTER TABLE IfcSpaceUseCase ADD COLUMN [ConstantLoad]  BIT;										
				
CREATE TABLE IfcStair (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcStair ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcStair ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcStair ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcStair ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcStair_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcStair_DocumentReferences ADD CONSTRAINT
	PK_IfcStair_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcStair (oid);

ALTER TABLE IfcStair ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcStair_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcStair_Representations ADD CONSTRAINT
	PK_IfcStair_Representations FOREIGN KEY (pid)
	REFERENCES IfcStair (oid);

ALTER TABLE IfcStair ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcStair ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcStair ADD COLUMN [PredefinedType] TEXT(50);
					
CREATE TABLE IfcStair_VerticallyConnects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcStair_VerticallyConnects ADD CONSTRAINT
	PK_IfcStair_VerticallyConnects FOREIGN KEY (pid)
	REFERENCES IfcStair (oid);

CREATE TABLE IfcStairFlight (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcStairFlight ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcStairFlight ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcStairFlight ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcStairFlight_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcStairFlight_DocumentReferences ADD CONSTRAINT
	PK_IfcStairFlight_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcStairFlight (oid);

ALTER TABLE IfcStairFlight ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcStairFlight_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcStairFlight_Representations ADD CONSTRAINT
	PK_IfcStairFlight_Representations FOREIGN KEY (pid)
	REFERENCES IfcStairFlight (oid);

ALTER TABLE IfcStairFlight ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcStairFlight ADD COLUMN [HasMaterial]  TEXT(50);
					
CREATE TABLE IfcStairFlight_VerticallyConnects (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcStairFlight_VerticallyConnects ADD CONSTRAINT
	PK_IfcStairFlight_VerticallyConnects FOREIGN KEY (pid)
	REFERENCES IfcStairFlight (oid);

ALTER TABLE IfcStairFlight ADD COLUMN [StepTreadMaterial] TEXT(50);
				
ALTER TABLE IfcStairFlight ADD COLUMN [StepNosingMaterial] TEXT(50);
				
ALTER TABLE IfcStairFlight ADD COLUMN [calcStepRise]  DOUBLE;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [calcStepTread]  DOUBLE;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [calcFlightHeadRoom]  DOUBLE;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [calcTotalFlightRise]  DOUBLE;										
				
ALTER TABLE IfcStairFlight ADD COLUMN [calcTotalFlightRun]  DOUBLE;										
				
CREATE TABLE IfcSubcontractResource (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSubcontractResource ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSubcontractResource ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSubcontractResource ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSubcontractResource ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSubcontractResource_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSubcontractResource_DocumentReferences ADD CONSTRAINT
	PK_IfcSubcontractResource_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSubcontractResource (oid);

ALTER TABLE IfcSubcontractResource ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcSubcontractResource ADD COLUMN [TypeReference]  MEMO;										
				
ALTER TABLE IfcSubcontractResource ADD COLUMN [TypeName]  MEMO;										
				
ALTER TABLE IfcSubcontractResource ADD COLUMN [Classification] TEXT(50);
				
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 [Company] TEXT(50);
				
ALTER TABLE IfcSubcontractResource ADD COLUMN [JobDescription]  MEMO;										
				
CREATE TABLE IfcSystem (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSystem ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSystem ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSystem ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSystem ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSystem_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSystem_DocumentReferences ADD CONSTRAINT
	PK_IfcSystem_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSystem (oid);

ALTER TABLE IfcSystem ADD COLUMN [GroupPurpose]  MEMO;										
				
CREATE TABLE IfcSystemFurnitureElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcSystemFurnitureElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSystemFurnitureElement_DocumentReferences ADD CONSTRAINT
	PK_IfcSystemFurnitureElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcSystemFurnitureElement (oid);

ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcSystemFurnitureElement_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcSystemFurnitureElement_Representations ADD CONSTRAINT
	PK_IfcSystemFurnitureElement_Representations FOREIGN KEY (pid)
	REFERENCES IfcSystemFurnitureElement (oid);

ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcTable (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTable ADD COLUMN [GlobalId]  TEXT (20);										
				
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 IfcTopologyRepresentation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTopologyRepresentation ADD COLUMN [ContextOfItems] TEXT(50);
				
ALTER TABLE IfcTopologyRepresentation ADD COLUMN [RepresentationIdentifier]  MEMO;										
				
ALTER TABLE IfcTopologyRepresentation ADD COLUMN [RepresentationType]  MEMO;										
					
CREATE TABLE IfcTopologyRepresentation_Items (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcTopologyRepresentation_Items ADD CONSTRAINT
	PK_IfcTopologyRepresentation_Items FOREIGN KEY (pid)
	REFERENCES IfcTopologyRepresentation (oid);

CREATE TABLE IfcTransaction (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTransaction ADD COLUMN [TransactionDate]  LONG;										
				
ALTER TABLE IfcTransaction ADD COLUMN [TransactingUser] TEXT(50);
				
ALTER TABLE IfcTransaction ADD COLUMN [TransactingApplication] TEXT(50);
				
CREATE TABLE IfcTrapeziumProfileDef (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [Position] TEXT(50);
				
ALTER TABLE IfcTrapeziumProfileDef ADD COLUMN [ProfileType] 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 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 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 IfcValve (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcValve ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcValve ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcValve ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcValve_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcValve_DocumentReferences ADD CONSTRAINT
	PK_IfcValve_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcValve (oid);

ALTER TABLE IfcValve ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcValve_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcValve_Representations ADD CONSTRAINT
	PK_IfcValve_Representations FOREIGN KEY (pid)
	REFERENCES IfcValve (oid);

ALTER TABLE IfcValve ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [FlowElementType] TEXT(50);
					
CREATE TABLE IfcValve_ControlElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcValve_ControlElements ADD CONSTRAINT
	PK_IfcValve_ControlElements FOREIGN KEY (pid)
	REFERENCES IfcValve (oid);

ALTER TABLE IfcValve ADD COLUMN [CloseOffRating] TEXT(50);
				
ALTER TABLE IfcValve ADD COLUMN [ValveCv]  DOUBLE;										
				
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 IfcVisualScreen (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcVisualScreen ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcVisualScreen ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcVisualScreen ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcVisualScreen ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcVisualScreen_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcVisualScreen_DocumentReferences ADD CONSTRAINT
	PK_IfcVisualScreen_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcVisualScreen (oid);

ALTER TABLE IfcVisualScreen ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcVisualScreen_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcVisualScreen_Representations ADD CONSTRAINT
	PK_IfcVisualScreen_Representations FOREIGN KEY (pid)
	REFERENCES IfcVisualScreen (oid);

ALTER TABLE IfcVisualScreen ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcVisualScreen ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcVisualScreen ADD COLUMN [PredefinedType] TEXT(50);
				
CREATE TABLE IfcWall (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWall ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWall ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWall ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWall ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWall_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWall_DocumentReferences ADD CONSTRAINT
	PK_IfcWall_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWall (oid);

ALTER TABLE IfcWall ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcWall_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWall_Representations ADD CONSTRAINT
	PK_IfcWall_Representations FOREIGN KEY (pid)
	REFERENCES IfcWall (oid);

ALTER TABLE IfcWall ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWall ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcWall ADD COLUMN [LayerInformation] TEXT(50);
				
ALTER TABLE IfcWall ADD COLUMN [calcWallArea]  DOUBLE;										
				
ALTER TABLE IfcWall ADD COLUMN [calcWallVolume]  DOUBLE;										
				
CREATE TABLE IfcWindow (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWindow ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWindow ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWindow ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWindow ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWindow_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindow_DocumentReferences ADD CONSTRAINT
	PK_IfcWindow_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWindow (oid);

ALTER TABLE IfcWindow ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcWindow_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindow_Representations ADD CONSTRAINT
	PK_IfcWindow_Representations FOREIGN KEY (pid)
	REFERENCES IfcWindow (oid);

ALTER TABLE IfcWindow ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWindow ADD COLUMN [HasMaterial]  TEXT(50);
				
CREATE TABLE IfcWindowLining (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWindowLining ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWindowLining ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWindowLining ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWindowLining ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWindowLining_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindowLining_DocumentReferences ADD CONSTRAINT
	PK_IfcWindowLining_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWindowLining (oid);

ALTER TABLE IfcWindowLining ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcWindowLining_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindowLining_Representations ADD CONSTRAINT
	PK_IfcWindowLining_Representations FOREIGN KEY (pid)
	REFERENCES IfcWindowLining (oid);

ALTER TABLE IfcWindowLining ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWindowLining ADD COLUMN [HasMaterial]  TEXT(50);
				
CREATE TABLE IfcWindowPanel (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWindowPanel ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWindowPanel ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWindowPanel ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWindowPanel ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWindowPanel_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindowPanel_DocumentReferences ADD CONSTRAINT
	PK_IfcWindowPanel_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWindowPanel (oid);

ALTER TABLE IfcWindowPanel ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcWindowPanel_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWindowPanel_Representations ADD CONSTRAINT
	PK_IfcWindowPanel_Representations FOREIGN KEY (pid)
	REFERENCES IfcWindowPanel (oid);

ALTER TABLE IfcWindowPanel ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWindowPanel ADD COLUMN [HasMaterial]  TEXT(50);
				
ALTER TABLE IfcWindowPanel ADD COLUMN [PredefinedType] TEXT(50);
				
ALTER TABLE IfcWindowPanel ADD COLUMN [OperationType] TEXT(50);
				
CREATE TABLE IfcWorkOrder (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkOrder ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWorkOrder_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkOrder_DocumentReferences ADD CONSTRAINT
	PK_IfcWorkOrder_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid);

ALTER TABLE IfcWorkOrder ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [OrderNo]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [TransactionCode]  MEMO;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [IssuingDate]  TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [IssuingCompany] 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);

ALTER TABLE IfcWorkOrder ADD COLUMN [Remark]  MEMO;										
				
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;										
				
ALTER TABLE IfcWorkOrder ADD COLUMN [IfNotAccomplished]  MEMO;										
				
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 [BudgetSource] TEXT(50);
				
ALTER TABLE IfcWorkOrder ADD COLUMN [Status] TEXT(50);
				
CREATE TABLE IfcWorkPlan (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkPlan ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkPlan ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWorkPlan_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkPlan_DocumentReferences ADD CONSTRAINT
	PK_IfcWorkPlan_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWorkPlan (oid);

ALTER TABLE IfcWorkPlan ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWorkPlan ADD COLUMN [PlanID]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [PlanName]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWorkPlan ADD COLUMN [PlanPurpose] TEXT(50);
				
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);
	
CREATE TABLE IfcWorkPlan_Tasks (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkPlan_Tasks ADD CONSTRAINT
	PK_IfcWorkPlan_Tasks FOREIGN KEY (pid)
	REFERENCES IfcWorkPlan (oid);

ALTER TABLE IfcWorkPlan ADD COLUMN [RootTask] TEXT(50);
					
CREATE TABLE IfcWorkPlan_Schedules (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkPlan_Schedules ADD CONSTRAINT
	PK_IfcWorkPlan_Schedules FOREIGN KEY (pid)
	REFERENCES IfcWorkPlan (oid);
	
CREATE TABLE IfcWorkPlan_Resources (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkPlan_Resources ADD CONSTRAINT
	PK_IfcWorkPlan_Resources FOREIGN KEY (pid)
	REFERENCES IfcWorkPlan (oid);

CREATE TABLE IfcWorkSchedule (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkSchedule ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWorkSchedule_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkSchedule_DocumentReferences ADD CONSTRAINT
	PK_IfcWorkSchedule_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWorkSchedule (oid);

ALTER TABLE IfcWorkSchedule ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [WorkScheduleID]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [WorkScheduleName]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [Description]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [WorkSchedulePurpose]  MEMO;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [CreationDate]  TEXT(50);
					
CREATE TABLE IfcWorkSchedule_Schedulers (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkSchedule_Schedulers ADD CONSTRAINT
	PK_IfcWorkSchedule_Schedulers FOREIGN KEY (pid)
	REFERENCES IfcWorkSchedule (oid);
	
CREATE TABLE IfcWorkSchedule_ScheduleElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkSchedule_ScheduleElements ADD CONSTRAINT
	PK_IfcWorkSchedule_ScheduleElements FOREIGN KEY (pid)
	REFERENCES IfcWorkSchedule (oid);

ALTER TABLE IfcWorkSchedule ADD COLUMN [TotalElements]  LONG;										
					
CREATE TABLE IfcWorkSchedule_Resources (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkSchedule_Resources ADD CONSTRAINT
	PK_IfcWorkSchedule_Resources FOREIGN KEY (pid)
	REFERENCES IfcWorkSchedule (oid);

ALTER TABLE IfcWorkSchedule ADD COLUMN [BaseSchedule] TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [StartTime]  TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [FinishTime]  TEXT(50);
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [Duration]  DOUBLE;										
				
ALTER TABLE IfcWorkSchedule ADD COLUMN [TotalFloat]  DOUBLE;										
				
CREATE TABLE IfcWorkScheduleElement (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkScheduleElement ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWorkScheduleElement ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkScheduleElement ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWorkScheduleElement ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWorkScheduleElement_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkScheduleElement_DocumentReferences ADD CONSTRAINT
	PK_IfcWorkScheduleElement_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWorkScheduleElement (oid);

ALTER TABLE IfcWorkScheduleElement ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWorkScheduleElement ADD COLUMN [WorkTask] TEXT(50);
				
ALTER TABLE IfcWorkScheduleElement ADD COLUMN [TimeForSchedule] TEXT(50);
				
ALTER TABLE IfcWorkScheduleElement ADD COLUMN [Milestone] TEXT(50);
				
CREATE TABLE IfcWorkstation (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkstation ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWorkstation ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkstation ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWorkstation_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkstation_DocumentReferences ADD CONSTRAINT
	PK_IfcWorkstation_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWorkstation (oid);

ALTER TABLE IfcWorkstation ADD COLUMN [LocalPlacement] TEXT(50);
					
CREATE TABLE IfcWorkstation_Representations (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkstation_Representations ADD CONSTRAINT
	PK_IfcWorkstation_Representations FOREIGN KEY (pid)
	REFERENCES IfcWorkstation (oid);

ALTER TABLE IfcWorkstation ADD COLUMN [Classification] TEXT(50);
					
CREATE TABLE IfcWorkstation_BoundedBy (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkstation_BoundedBy ADD CONSTRAINT
	PK_IfcWorkstation_BoundedBy FOREIGN KEY (pid)
	REFERENCES IfcWorkstation (oid);

ALTER TABLE IfcWorkstation ADD COLUMN [InteriorOrExteriorSpace] TEXT(50);
				
ALTER TABLE IfcWorkstation ADD COLUMN [SpaceReference]  MEMO;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [SpaceName]  MEMO;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [calcTotalPerimeter]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [calcTotalArea]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [calcTotalVolume]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [calcAverageHeight]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [calcAverageGrossHeight]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [calcAverageClearHeight]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [calcElevationWithFlooring]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [WorkstationType] TEXT(50);
				
ALTER TABLE IfcWorkstation ADD COLUMN [FurntureModel] TEXT(50);
					
CREATE TABLE IfcWorkstation_ModuleElements (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkstation_ModuleElements ADD CONSTRAINT
	PK_IfcWorkstation_ModuleElements FOREIGN KEY (pid)
	REFERENCES IfcWorkstation (oid);

ALTER TABLE IfcWorkstation ADD COLUMN [TotalWorkTaskZone]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [TotalChairClearence]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [TotalCirculation]  DOUBLE;										
				
ALTER TABLE IfcWorkstation ADD COLUMN [TotalCubes]  LONG;										
				
CREATE TABLE IfcWorkTask (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcWorkTask ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcWorkTask ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcWorkTask ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcWorkTask ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcWorkTask_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcWorkTask_DocumentReferences ADD CONSTRAINT
	PK_IfcWorkTask_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcWorkTask (oid);

ALTER TABLE IfcWorkTask ADD COLUMN [Productivity] TEXT(50);
				
ALTER TABLE IfcWorkTask ADD COLUMN [Classification] TEXT(50);
				
ALTER TABLE IfcWorkTask ADD COLUMN [WorkTaskID]  MEMO;										
				
ALTER TABLE IfcWorkTask ADD COLUMN [WorkTaskName]  MEMO;										
				
ALTER TABLE IfcWorkTask ADD COLUMN [Description]  MEMO;										
				
CREATE TABLE IfcWorkTask_WBSCode (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcWorkTask_WBSCode ADD CONSTRAINT
	PK_IfcWorkTask_WBSCode FOREIGN KEY (pid)
	REFERENCES IfcWorkTask (oid);

CREATE TABLE IfcWorkTask_WBSSource (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	StringValue MEMO
);
ALTER TABLE IfcWorkTask_WBSSource ADD CONSTRAINT
	PK_IfcWorkTask_WBSSource FOREIGN KEY (pid)
	REFERENCES IfcWorkTask (oid);

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

ALTER TABLE IfcWorkTask ADD COLUMN [WorkMethod]  MEMO;										
				
ALTER TABLE IfcWorkTask ADD COLUMN [InPlaceQuantity] TEXT(50);
				
ALTER TABLE IfcWorkTask ADD COLUMN [EstimatedOuantity] TEXT(50);
				
ALTER TABLE IfcWorkTask ADD COLUMN [BudgetQuantity] TEXT(50);
				
CREATE TABLE IfcZone (
			
	oid TEXT(50) PRIMARY KEY
);
			
ALTER TABLE IfcZone ADD COLUMN [GlobalId]  TEXT (20);										
				
ALTER TABLE IfcZone ADD COLUMN [OwnerHistory] TEXT(50);
				
ALTER TABLE IfcZone ADD COLUMN [Label]  MEMO;										
				
ALTER TABLE IfcZone ADD COLUMN [UserDefinedType]  MEMO;										
					
CREATE TABLE IfcZone_DocumentReferences (
	uid COUNTER UNIQUE,
	pid TEXT(50),
	EntityRef TEXT (50)
);
ALTER TABLE IfcZone_DocumentReferences ADD CONSTRAINT
	PK_IfcZone_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcZone (oid);

ALTER TABLE IfcZone ADD COLUMN [GroupPurpose]  MEMO;