PRINT ' '
PRINT '-- IFC Model Server Project'
PRINT '-- EXC::MMC::IMS Database SQL DDL (EXPRESS to XML Schema Converter::Meta Model Conversion module for IMS DB)'
PRINT '-- 08 Dec. 2001 IMS Project 2001, VTT and SECOM Co., Ltd.'
PRINT '-- yoshinobu.adachi@vtt.fi'

	
SET NOCOUNT ON;
GO
USE ims_db;
GO
PRINT ''
PRINT '----------------------------------------------------------------------'
PRINT '-- START --'
	

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: Ifc2DCompositeCurve'
-- ENTITY Table Definition
CREATE TABLE Ifc2DCompositeCurve (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE Ifc2DCompositeCurve_Segments (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE Ifc2DCompositeCurve_Segments ADD CONSTRAINT
	PK_Ifc2DCompositeCurve_Segments FOREIGN KEY (pid)
	REFERENCES Ifc2DCompositeCurve (oid) ON DELETE CASCADE;

ALTER TABLE Ifc2DCompositeCurve ADD [SelfIntersect]  tinyint;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcActionTimeControl'
-- ENTITY Table Definition
CREATE TABLE IfcActionTimeControl (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcActionTimeControl ADD [ConstraintType]  ntext;										
				
ALTER TABLE IfcActionTimeControl ADD [ContraintTime]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcActor'
-- ENTITY Table Definition
CREATE TABLE IfcActor (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcActor ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcActor ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcActor ADD [Name]  ntext;										
				
ALTER TABLE IfcActor ADD [Description]  ntext;										
				
ALTER TABLE IfcActor ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcActor ADD [TheActor]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcActorRole'
-- ENTITY Table Definition
CREATE TABLE IfcActorRole (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcActorRole ADD [Role] VARCHAR(50);
				
ALTER TABLE IfcActorRole ADD [UserDefinedRole]  ntext;										
				
ALTER TABLE IfcActorRole ADD [Description]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcActuator'
-- ENTITY Table Definition
CREATE TABLE IfcActuator (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcActuator ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcActuator ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcActuator ADD [Name]  ntext;										
				
ALTER TABLE IfcActuator ADD [Description]  ntext;										
				
ALTER TABLE IfcActuator ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcActuator ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcActuator ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcActuator ADD [Tag]  ntext;										
				
ALTER TABLE IfcActuator ADD [ControlElementId]  ntext;										
				
ALTER TABLE IfcActuator ADD [PredefinedType] VARCHAR(50);
				
ALTER TABLE IfcActuator ADD [FailPosition] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAirFilter'
-- ENTITY Table Definition
CREATE TABLE IfcAirFilter (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAirFilter ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcAirFilter ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcAirFilter ADD [Name]  ntext;										
				
ALTER TABLE IfcAirFilter ADD [Description]  ntext;										
				
ALTER TABLE IfcAirFilter ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcAirFilter ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcAirFilter ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcAirFilter ADD [Tag]  ntext;										
				
ALTER TABLE IfcAirFilter ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcAirFilter ADD [DirtyPressureDrop]  float;										
				
ALTER TABLE IfcAirFilter ADD [CleanPressureDrop]  float;										
				
ALTER TABLE IfcAirFilter ADD [Efficiency]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAirTerminal'
-- ENTITY Table Definition
CREATE TABLE IfcAirTerminal (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAirTerminal ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcAirTerminal ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [Name]  ntext;										
				
ALTER TABLE IfcAirTerminal ADD [Description]  ntext;										
				
ALTER TABLE IfcAirTerminal ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcAirTerminal ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [Tag]  ntext;										
				
ALTER TABLE IfcAirTerminal ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [AirFlowType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [Throw]  float;										
				
ALTER TABLE IfcAirTerminal ADD [AirDiffusionPerformanceIndex]  float;										
				
ALTER TABLE IfcAirTerminal ADD [FinishType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [FinishColor]  ntext;										
				
ALTER TABLE IfcAirTerminal ADD [MountingType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [FaceType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [CoreType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminal ADD [CoreSetVertical]  float;										
				
ALTER TABLE IfcAirTerminal ADD [CoreSetHorizontal]  float;										
				
ALTER TABLE IfcAirTerminal ADD [IntegralControl]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAirTerminalBox'
-- ENTITY Table Definition
CREATE TABLE IfcAirTerminalBox (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAirTerminalBox ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcAirTerminalBox ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcAirTerminalBox ADD [Name]  ntext;										
				
ALTER TABLE IfcAirTerminalBox ADD [Description]  ntext;										
				
ALTER TABLE IfcAirTerminalBox ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcAirTerminalBox ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcAirTerminalBox ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcAirTerminalBox ADD [Tag]  ntext;										
				
ALTER TABLE IfcAirTerminalBox ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminalBox ADD [TerminalBoxType] VARCHAR(50);
				
ALTER TABLE IfcAirTerminalBox ADD [SoundLevel] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcApplication'
-- ENTITY Table Definition
CREATE TABLE IfcApplication (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcApplication ADD [ApplicationDeveloper] VARCHAR(50);
				
ALTER TABLE IfcApplication ADD [Version]  ntext;										
				
ALTER TABLE IfcApplication ADD [ApplicationFullName]  ntext;										
				
ALTER TABLE IfcApplication ADD [ApplicationIdentifier]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcApproval'
-- ENTITY Table Definition
CREATE TABLE IfcApproval (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcApproval ADD [Description]  ntext;										
				
ALTER TABLE IfcApproval ADD [AuthorizingAgent]  VARCHAR(50);
				
ALTER TABLE IfcApproval ADD [RequestFrom]  VARCHAR(50);
				
ALTER TABLE IfcApproval ADD [RequestTo]  VARCHAR(50);
				
ALTER TABLE IfcApproval ADD [RequestingDate]  VARCHAR(50);
				
ALTER TABLE IfcApproval ADD [RequestedDate]  VARCHAR(50);
				
ALTER TABLE IfcApproval ADD [ApprovalDate]  VARCHAR(50);
				
ALTER TABLE IfcApproval ADD [ApprovalStatus] VARCHAR(50);
				
ALTER TABLE IfcApproval ADD [ApprovalConstraint]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcApprovalUsage'
-- ENTITY Table Definition
CREATE TABLE IfcApprovalUsage (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcApprovalUsage ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcApprovalUsage ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcApprovalUsage ADD [Name]  ntext;										
				
ALTER TABLE IfcApprovalUsage ADD [Description]  ntext;										
				
ALTER TABLE IfcApprovalUsage ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcApprovalUsage ADD [Approval] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcArbitraryClosedProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcArbitraryClosedProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcArbitraryClosedProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcArbitraryClosedProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcArbitraryClosedProfileDef ADD [OuterCurve] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcArbitraryOpenProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcArbitraryOpenProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcArbitraryOpenProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcArbitraryOpenProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcArbitraryOpenProfileDef ADD [Curve] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcArbitraryProfileDefWithVoids'
-- ENTITY Table Definition
CREATE TABLE IfcArbitraryProfileDefWithVoids (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcArbitraryProfileDefWithVoids ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcArbitraryProfileDefWithVoids ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcArbitraryProfileDefWithVoids ADD [OuterCurve] VARCHAR(50);
					
CREATE TABLE IfcArbitraryProfileDefWithVoids_InnerCurves (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcArbitraryProfileDefWithVoids_InnerCurves ADD CONSTRAINT
	PK_IfcArbitraryProfileDefWithVoids_InnerCurves FOREIGN KEY (pid)
	REFERENCES IfcArbitraryProfileDefWithVoids (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAssessory'
-- ENTITY Table Definition
CREATE TABLE IfcAssessory (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAssessory ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcAssessory ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcAssessory ADD [Name]  ntext;										
				
ALTER TABLE IfcAssessory ADD [Description]  ntext;										
				
ALTER TABLE IfcAssessory ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcAssessory ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcAssessory ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcAssessory ADD [Tag]  ntext;										
				
ALTER TABLE IfcAssessory ADD [MountingType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAsset'
-- ENTITY Table Definition
CREATE TABLE IfcAsset (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAsset ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcAsset ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [Name]  ntext;										
				
ALTER TABLE IfcAsset ADD [Description]  ntext;										
				
ALTER TABLE IfcAsset ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcAsset ADD [AssetLocation] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [AssetIdentifier]  ntext;										
				
CREATE TABLE IfcAsset_AssetRisks (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcAsset_AssetRisks ADD CONSTRAINT
	PK_IfcAsset_AssetRisks FOREIGN KEY (pid)
	REFERENCES IfcAsset (oid) ON DELETE CASCADE;

ALTER TABLE IfcAsset ADD [OriginalValue] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [CurrentValue] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [TotalReplacementCost] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [Owner]  VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [User]  VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [LeasedFrom]  VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [LeasedTo]  VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [ResponsiblePerson] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [IncorporationDate] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [CommissioningDate] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [WarrantyDuration]  float;										
				
ALTER TABLE IfcAsset ADD [ExpectedLife]  float;										
				
ALTER TABLE IfcAsset ADD [OperatingFunction] VARCHAR(50);
				
ALTER TABLE IfcAsset ADD [DepreciatedValue] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAxis1Placement'
-- ENTITY Table Definition
CREATE TABLE IfcAxis1Placement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAxis1Placement ADD [Location] VARCHAR(50);
				
ALTER TABLE IfcAxis1Placement ADD [Axis] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAxis2Placement2D'
-- ENTITY Table Definition
CREATE TABLE IfcAxis2Placement2D (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAxis2Placement2D ADD [Location] VARCHAR(50);
				
ALTER TABLE IfcAxis2Placement2D ADD [RefDirection] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcAxis2Placement3D'
-- ENTITY Table Definition
CREATE TABLE IfcAxis2Placement3D (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcAxis2Placement3D ADD [Location] VARCHAR(50);
				
ALTER TABLE IfcAxis2Placement3D ADD [Axis] VARCHAR(50);
				
ALTER TABLE IfcAxis2Placement3D ADD [RefDirection] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBeam'
-- ENTITY Table Definition
CREATE TABLE IfcBeam (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBeam ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcBeam ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcBeam ADD [Name]  ntext;										
				
ALTER TABLE IfcBeam ADD [Description]  ntext;										
				
ALTER TABLE IfcBeam ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcBeam ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcBeam ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcBeam ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBoiler'
-- ENTITY Table Definition
CREATE TABLE IfcBoiler (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBoiler ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcBoiler ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcBoiler ADD [Name]  ntext;										
				
ALTER TABLE IfcBoiler ADD [Description]  ntext;										
				
ALTER TABLE IfcBoiler ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcBoiler ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcBoiler ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcBoiler ADD [Tag]  ntext;										
				
ALTER TABLE IfcBoiler ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcBoiler ADD [HeatTransferRate]  float;										
				
ALTER TABLE IfcBoiler ADD [ThermalEfficiency]  float;										
				
ALTER TABLE IfcBoiler ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcBoiler ADD [BoilerType] VARCHAR(50);
				
ALTER TABLE IfcBoiler ADD [HeatOutput]  float;										
				
ALTER TABLE IfcBoiler ADD [PressureRating]  float;										
				
ALTER TABLE IfcBoiler ADD [EnergyInputRate]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBooleanClippingResult'
-- ENTITY Table Definition
CREATE TABLE IfcBooleanClippingResult (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBooleanClippingResult ADD [Operator] VARCHAR(50);
				
ALTER TABLE IfcBooleanClippingResult ADD [FirstOperand]  VARCHAR(50);
				
ALTER TABLE IfcBooleanClippingResult ADD [SecondOperand]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBooleanResult'
-- ENTITY Table Definition
CREATE TABLE IfcBooleanResult (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBooleanResult ADD [Operator] VARCHAR(50);
				
ALTER TABLE IfcBooleanResult ADD [FirstOperand]  VARCHAR(50);
				
ALTER TABLE IfcBooleanResult ADD [SecondOperand]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBoundedSurface'
-- ENTITY Table Definition
CREATE TABLE IfcBoundedSurface (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBoundingBox'
-- ENTITY Table Definition
CREATE TABLE IfcBoundingBox (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBoundingBox ADD [Corner] VARCHAR(50);
				
ALTER TABLE IfcBoundingBox ADD [XDim]  float;										
				
ALTER TABLE IfcBoundingBox ADD [YDim]  float;										
				
ALTER TABLE IfcBoundingBox ADD [ZDim]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBoxedHalfSpace'
-- ENTITY Table Definition
CREATE TABLE IfcBoxedHalfSpace (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBoxedHalfSpace ADD [BaseSurface] VARCHAR(50);
				
ALTER TABLE IfcBoxedHalfSpace ADD [AgreementFlag]  BIT;										
				
ALTER TABLE IfcBoxedHalfSpace ADD [Enclosure] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBudget'
-- ENTITY Table Definition
CREATE TABLE IfcBudget (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBudget ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcBudget ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcBudget ADD [Name]  ntext;										
				
ALTER TABLE IfcBudget ADD [Description]  ntext;										
				
ALTER TABLE IfcBudget ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcBudget ADD [Title]  ntext;										
				
ALTER TABLE IfcBudget ADD [SubmittedBy]  VARCHAR(50);
					
CREATE TABLE IfcBudget_ApprovedBy (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcBudget_ApprovedBy ADD CONSTRAINT
	PK_IfcBudget_ApprovedBy FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid) ON DELETE CASCADE;

ALTER TABLE IfcBudget ADD [PreparedBy] VARCHAR(50);
				
ALTER TABLE IfcBudget ADD [SubmittedOn] VARCHAR(50);
				
ALTER TABLE IfcBudget ADD [TotalCost] VARCHAR(50);
					
CREATE TABLE IfcBudget_CostElements (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcBudget_CostElements ADD CONSTRAINT
	PK_IfcBudget_CostElements FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid) ON DELETE CASCADE;

ALTER TABLE IfcBudget ADD [Status]  ntext;										
				
ALTER TABLE IfcBudget ADD [IntendedUse]  ntext;										
				
CREATE TABLE IfcBudget_Comments (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcBudget_Comments ADD CONSTRAINT
	PK_IfcBudget_Comments FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcBudget_TargetUsers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcBudget_TargetUsers ADD CONSTRAINT
	PK_IfcBudget_TargetUsers FOREIGN KEY (pid)
	REFERENCES IfcBudget (oid) ON DELETE CASCADE;

ALTER TABLE IfcBudget ADD [ValidFromDate] VARCHAR(50);
				
ALTER TABLE IfcBudget ADD [ValidToDate] VARCHAR(50);
				
ALTER TABLE IfcBudget ADD [UpdateDate] VARCHAR(50);
				
ALTER TABLE IfcBudget ADD [ScheduleNumber]  ntext;										
				
ALTER TABLE IfcBudget ADD [BudgetSource]  ntext;										
				
ALTER TABLE IfcBudget ADD [Balance] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBuilding'
-- ENTITY Table Definition
CREATE TABLE IfcBuilding (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBuilding ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcBuilding ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcBuilding ADD [Name]  ntext;										
				
ALTER TABLE IfcBuilding ADD [Description]  ntext;										
				
ALTER TABLE IfcBuilding ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcBuilding ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcBuilding ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcBuilding ADD [LongName]  ntext;										
				
ALTER TABLE IfcBuilding ADD [CompositionType] VARCHAR(50);
				
ALTER TABLE IfcBuilding ADD [ElevationOfRefHeight]  float;										
				
ALTER TABLE IfcBuilding ADD [ElevationOfTerrain]  float;										
				
ALTER TABLE IfcBuilding ADD [BuildingAddress] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBuildingElementProxy'
-- ENTITY Table Definition
CREATE TABLE IfcBuildingElementProxy (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBuildingElementProxy ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcBuildingElementProxy ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcBuildingElementProxy ADD [Name]  ntext;										
				
ALTER TABLE IfcBuildingElementProxy ADD [Description]  ntext;										
				
ALTER TABLE IfcBuildingElementProxy ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcBuildingElementProxy ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcBuildingElementProxy ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcBuildingElementProxy ADD [Tag]  ntext;										
				
ALTER TABLE IfcBuildingElementProxy ADD [CompositionType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBuildingStorey'
-- ENTITY Table Definition
CREATE TABLE IfcBuildingStorey (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBuildingStorey ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcBuildingStorey ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcBuildingStorey ADD [Name]  ntext;										
				
ALTER TABLE IfcBuildingStorey ADD [Description]  ntext;										
				
ALTER TABLE IfcBuildingStorey ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcBuildingStorey ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcBuildingStorey ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcBuildingStorey ADD [LongName]  ntext;										
				
ALTER TABLE IfcBuildingStorey ADD [CompositionType] VARCHAR(50);
				
ALTER TABLE IfcBuildingStorey ADD [Elevation]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcBuiltIn'
-- ENTITY Table Definition
CREATE TABLE IfcBuiltIn (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcBuiltIn ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcBuiltIn ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcBuiltIn ADD [Name]  ntext;										
				
ALTER TABLE IfcBuiltIn ADD [Description]  ntext;										
				
ALTER TABLE IfcBuiltIn ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcBuiltIn ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcBuiltIn ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcBuiltIn ADD [Tag]  ntext;										
				
ALTER TABLE IfcBuiltIn ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCalendarDate'
-- ENTITY Table Definition
CREATE TABLE IfcCalendarDate (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCalendarDate ADD [DayComponent]  int;										
				
ALTER TABLE IfcCalendarDate ADD [MonthComponent]  int;										
				
ALTER TABLE IfcCalendarDate ADD [YearComponent]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCartesianPoint'
-- ENTITY Table Definition
CREATE TABLE IfcCartesianPoint (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
CREATE TABLE IfcCartesianPoint_Coordinates (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcCartesianPoint_Coordinates ADD CONSTRAINT
	PK_IfcCartesianPoint_Coordinates FOREIGN KEY (pid)
	REFERENCES IfcCartesianPoint (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCartesianTransformationOperator2D'
-- ENTITY Table Definition
CREATE TABLE IfcCartesianTransformationOperator2D (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCartesianTransformationOperator2D ADD [Axis1] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator2D ADD [Axis2] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator2D ADD [LocalOrigin] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator2D ADD [Scale]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCartesianTransformationOperator2DnonUniform'
-- ENTITY Table Definition
CREATE TABLE IfcCartesianTransformationOperator2DnonUniform (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD [Axis1] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD [Axis2] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD [LocalOrigin] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD [Scale]  float;										
				
ALTER TABLE IfcCartesianTransformationOperator2DnonUniform ADD [Scale2]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCartesianTransformationOperator3D'
-- ENTITY Table Definition
CREATE TABLE IfcCartesianTransformationOperator3D (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCartesianTransformationOperator3D ADD [Axis1] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD [Axis2] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD [LocalOrigin] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD [Scale]  float;										
				
ALTER TABLE IfcCartesianTransformationOperator3D ADD [Axis3] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCartesianTransformationOperator3DnonUniform'
-- ENTITY Table Definition
CREATE TABLE IfcCartesianTransformationOperator3DnonUniform (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD [Axis1] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD [Axis2] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD [LocalOrigin] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD [Scale]  float;										
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD [Axis3] VARCHAR(50);
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD [Scale2]  float;										
				
ALTER TABLE IfcCartesianTransformationOperator3DnonUniform ADD [Scale3]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcChangeOrder'
-- ENTITY Table Definition
CREATE TABLE IfcChangeOrder (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcChangeOrder ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [Name]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [Description]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [OrderNumber]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [TransactionCode]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [IssuingDate] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [IssuedBy]  VARCHAR(50);
					
CREATE TABLE IfcChangeOrder_IssuedTo (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcChangeOrder_IssuedTo ADD CONSTRAINT
	PK_IfcChangeOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcChangeOrder_AdditionalContacts (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcChangeOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcChangeOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid) ON DELETE CASCADE;

CREATE TABLE IfcChangeOrder_Remarks (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcChangeOrder_Remarks ADD CONSTRAINT
	PK_IfcChangeOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcChangeOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcChangeOrder ADD [Signoff] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [BudgetSource] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [ChangeDescription]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [ReasonForChange]  ntext;										
				
ALTER TABLE IfcChangeOrder ADD [RequestedStartTime] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [RequestedFinishTime] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [CostEstimate] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [WorkPlan] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [Status] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [ActualStartTime] VARCHAR(50);
				
ALTER TABLE IfcChangeOrder ADD [ActualFinishTime] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcChiller'
-- ENTITY Table Definition
CREATE TABLE IfcChiller (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcChiller ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcChiller ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcChiller ADD [Name]  ntext;										
				
ALTER TABLE IfcChiller ADD [Description]  ntext;										
				
ALTER TABLE IfcChiller ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcChiller ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcChiller ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcChiller ADD [Tag]  ntext;										
				
ALTER TABLE IfcChiller ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcChiller ADD [HeatTransferRate]  float;										
				
ALTER TABLE IfcChiller ADD [ThermalEfficiency]  float;										
				
ALTER TABLE IfcChiller ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcChiller ADD [ChillerType] VARCHAR(50);
				
ALTER TABLE IfcChiller ADD [NominalCoolingCapacity_]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCircle'
-- ENTITY Table Definition
CREATE TABLE IfcCircle (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCircle ADD [Position]  VARCHAR(50);
				
ALTER TABLE IfcCircle ADD [Radius]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCircleProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcCircleProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCircleProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcCircleProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcCircleProfileDef ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcCircleProfileDef ADD [Radius]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcClassification'
-- ENTITY Table Definition
CREATE TABLE IfcClassification (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcClassification ADD [Source]  ntext;										
				
ALTER TABLE IfcClassification ADD [Edition]  ntext;										
				
ALTER TABLE IfcClassification ADD [EditionDate] VARCHAR(50);
				
ALTER TABLE IfcClassification ADD [Name]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcClassificationItem'
-- ENTITY Table Definition
CREATE TABLE IfcClassificationItem (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcClassificationItem ADD [Notation] VARCHAR(50);
				
ALTER TABLE IfcClassificationItem ADD [ItemOf] VARCHAR(50);
				
ALTER TABLE IfcClassificationItem ADD [Title]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcClassificationItemRelationship'
-- ENTITY Table Definition
CREATE TABLE IfcClassificationItemRelationship (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcClassificationItemRelationship ADD [RelatingItem] VARCHAR(50);
					
CREATE TABLE IfcClassificationItemRelationship_RelatedItems (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcClassificationItemRelationship_RelatedItems ADD CONSTRAINT
	PK_IfcClassificationItemRelationship_RelatedItems FOREIGN KEY (pid)
	REFERENCES IfcClassificationItemRelationship (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcClassificationNotation'
-- ENTITY Table Definition
CREATE TABLE IfcClassificationNotation (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcClassificationNotation_NotationFacets (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcClassificationNotation_NotationFacets ADD CONSTRAINT
	PK_IfcClassificationNotation_NotationFacets FOREIGN KEY (pid)
	REFERENCES IfcClassificationNotation (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcClassificationNotationFacet'
-- ENTITY Table Definition
CREATE TABLE IfcClassificationNotationFacet (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcClassificationNotationFacet ADD [NotationValue]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcClassificationReference'
-- ENTITY Table Definition
CREATE TABLE IfcClassificationReference (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcClassificationReference ADD [Location]  ntext;										
				
ALTER TABLE IfcClassificationReference ADD [ItemReference]  ntext;										
				
ALTER TABLE IfcClassificationReference ADD [Name]  ntext;										
				
ALTER TABLE IfcClassificationReference ADD [ReferencedSource] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcClosedShell'
-- ENTITY Table Definition
CREATE TABLE IfcClosedShell (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcClosedShell_CfsFaces (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcClosedShell_CfsFaces ADD CONSTRAINT
	PK_IfcClosedShell_CfsFaces FOREIGN KEY (pid)
	REFERENCES IfcClosedShell (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCMDocPackage'
-- ENTITY Table Definition
CREATE TABLE IfcCMDocPackage (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCMDocPackage ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCMDocPackage ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCMDocPackage ADD [Name]  ntext;										
				
ALTER TABLE IfcCMDocPackage ADD [Description]  ntext;										
				
ALTER TABLE IfcCMDocPackage ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCMDocPackage ADD [DocPackageID]  ntext;										
				
ALTER TABLE IfcCMDocPackage ADD [DocPackageName]  ntext;										
				
ALTER TABLE IfcCMDocPackage ADD [CreationDate]  VARCHAR(50);
					
CREATE TABLE IfcCMDocPackage_Authors (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCMDocPackage_Authors ADD CONSTRAINT
	PK_IfcCMDocPackage_Authors FOREIGN KEY (pid)
	REFERENCES IfcCMDocPackage (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCoil'
-- ENTITY Table Definition
CREATE TABLE IfcCoil (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCoil ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCoil ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCoil ADD [Name]  ntext;										
				
ALTER TABLE IfcCoil ADD [Description]  ntext;										
				
ALTER TABLE IfcCoil ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCoil ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcCoil ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcCoil ADD [Tag]  ntext;										
				
ALTER TABLE IfcCoil ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcCoil ADD [CoilType] VARCHAR(50);
				
ALTER TABLE IfcCoil ADD [BypassFactor]  float;										
				
ALTER TABLE IfcCoil ADD [FaceVelocity]  float;										
				
ALTER TABLE IfcCoil ADD [FlowArrangement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcColumn'
-- ENTITY Table Definition
CREATE TABLE IfcColumn (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcColumn ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcColumn ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcColumn ADD [Name]  ntext;										
				
ALTER TABLE IfcColumn ADD [Description]  ntext;										
				
ALTER TABLE IfcColumn ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcColumn ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcColumn ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcColumn ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCompartment'
-- ENTITY Table Definition
CREATE TABLE IfcCompartment (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCompartment ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCompartment ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCompartment ADD [Name]  ntext;										
				
ALTER TABLE IfcCompartment ADD [Description]  ntext;										
				
ALTER TABLE IfcCompartment ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCompartment ADD [HasNaturalVentilation]  tinyint;										
				
ALTER TABLE IfcCompartment ADD [HasSprinklerProtection]  tinyint;										
				
ALTER TABLE IfcCompartment ADD [FireRiskFactor]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcComplexProperty'
-- ENTITY Table Definition
CREATE TABLE IfcComplexProperty (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcComplexProperty ADD [Name]  ntext;										
				
ALTER TABLE IfcComplexProperty ADD [Description]  ntext;										
				
ALTER TABLE IfcComplexProperty ADD [UsageName]  ntext;										
					
CREATE TABLE IfcComplexProperty_HasProperties (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcComplexProperty_HasProperties ADD CONSTRAINT
	PK_IfcComplexProperty_HasProperties FOREIGN KEY (pid)
	REFERENCES IfcComplexProperty (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCompositeCurve'
-- ENTITY Table Definition
CREATE TABLE IfcCompositeCurve (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcCompositeCurve_Segments (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCompositeCurve_Segments ADD CONSTRAINT
	PK_IfcCompositeCurve_Segments FOREIGN KEY (pid)
	REFERENCES IfcCompositeCurve (oid) ON DELETE CASCADE;

ALTER TABLE IfcCompositeCurve ADD [SelfIntersect]  tinyint;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCompositeCurveSegment'
-- ENTITY Table Definition
CREATE TABLE IfcCompositeCurveSegment (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCompositeCurveSegment ADD [Transition] VARCHAR(50);
				
ALTER TABLE IfcCompositeCurveSegment ADD [SameSense]  BIT;										
				
ALTER TABLE IfcCompositeCurveSegment ADD [ParentCurve] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCompositeProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcCompositeProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCompositeProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcCompositeProfileDef ADD [ProfileName]  ntext;										
					
CREATE TABLE IfcCompositeProfileDef_Profiles (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCompositeProfileDef_Profiles ADD CONSTRAINT
	PK_IfcCompositeProfileDef_Profiles FOREIGN KEY (pid)
	REFERENCES IfcCompositeProfileDef (oid) ON DELETE CASCADE;

ALTER TABLE IfcCompositeProfileDef ADD [Label]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCompressor'
-- ENTITY Table Definition
CREATE TABLE IfcCompressor (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCompressor ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCompressor ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCompressor ADD [Name]  ntext;										
				
ALTER TABLE IfcCompressor ADD [Description]  ntext;										
				
ALTER TABLE IfcCompressor ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCompressor ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcCompressor ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcCompressor ADD [Tag]  ntext;										
				
ALTER TABLE IfcCompressor ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcCompressor ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcCompressor ADD [ImpellerDiameter]  float;										
				
ALTER TABLE IfcCompressor ADD [CompressorType] VARCHAR(50);
				
ALTER TABLE IfcCompressor ADD [HotGasBypass]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConnectedFaceSet'
-- ENTITY Table Definition
CREATE TABLE IfcConnectedFaceSet (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcConnectedFaceSet_CfsFaces (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcConnectedFaceSet_CfsFaces ADD CONSTRAINT
	PK_IfcConnectedFaceSet_CfsFaces FOREIGN KEY (pid)
	REFERENCES IfcConnectedFaceSet (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConnectionConstraint'
-- ENTITY Table Definition
CREATE TABLE IfcConnectionConstraint (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConnectionConstraint ADD [WaterproofingRequired]  tinyint;										
				
ALTER TABLE IfcConnectionConstraint ADD [VentilationRequired]  tinyint;										
				
ALTER TABLE IfcConnectionConstraint ADD [JoinType] VARCHAR(50);
				
ALTER TABLE IfcConnectionConstraint ADD [RangeOfMovement]  float;										
				
ALTER TABLE IfcConnectionConstraint ADD [FireRating]  float;										
				
ALTER TABLE IfcConnectionConstraint ADD [ConstraintOf] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConnectionCurveGeometry'
-- ENTITY Table Definition
CREATE TABLE IfcConnectionCurveGeometry (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConnectionCurveGeometry ADD [CurveOnRelatingElement] VARCHAR(50);
				
ALTER TABLE IfcConnectionCurveGeometry ADD [CurveOnRelatedElement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConnectionPointGeometry'
-- ENTITY Table Definition
CREATE TABLE IfcConnectionPointGeometry (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConnectionPointGeometry ADD [PointOnRelatingElement] VARCHAR(50);
				
ALTER TABLE IfcConnectionPointGeometry ADD [PointOnRelatedElement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConnectionPortGeometry'
-- ENTITY Table Definition
CREATE TABLE IfcConnectionPortGeometry (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConnectionPortGeometry ADD [LocationAtRelatingElement]  VARCHAR(50);
				
ALTER TABLE IfcConnectionPortGeometry ADD [LocationAtRelatedElement]  VARCHAR(50);
				
ALTER TABLE IfcConnectionPortGeometry ADD [ProfileOfPort] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConnectionSurfaceGeometry'
-- ENTITY Table Definition
CREATE TABLE IfcConnectionSurfaceGeometry (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConnectionSurfaceGeometry ADD [SurfaceOnRelatingElement] VARCHAR(50);
				
ALTER TABLE IfcConnectionSurfaceGeometry ADD [SurfaceOnRelatedElement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConstraint'
-- ENTITY Table Definition
CREATE TABLE IfcConstraint (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConstraint ADD [ConstraintGrade] VARCHAR(50);
				
ALTER TABLE IfcConstraint ADD [Description]  ntext;										
				
ALTER TABLE IfcConstraint ADD [ConstraintSource]  ntext;										
				
ALTER TABLE IfcConstraint ADD [Name]  ntext;										
				
ALTER TABLE IfcConstraint ADD [CreatingActor]  VARCHAR(50);
				
ALTER TABLE IfcConstraint ADD [CreationTime]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConstraintAggregationRelationship'
-- ENTITY Table Definition
CREATE TABLE IfcConstraintAggregationRelationship (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConstraintAggregationRelationship ADD [LogicalAggregator] VARCHAR(50);
				
ALTER TABLE IfcConstraintAggregationRelationship ADD [RelatingConstraint] VARCHAR(50);
					
CREATE TABLE IfcConstraintAggregationRelationship_RelatedConstraints (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcConstraintAggregationRelationship_RelatedConstraints ADD CONSTRAINT
	PK_IfcConstraintAggregationRelationship_RelatedConstraints FOREIGN KEY (pid)
	REFERENCES IfcConstraintAggregationRelationship (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConstraintUsage'
-- ENTITY Table Definition
CREATE TABLE IfcConstraintUsage (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConstraintUsage ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcConstraintUsage ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcConstraintUsage ADD [Name]  ntext;										
				
ALTER TABLE IfcConstraintUsage ADD [Description]  ntext;										
				
ALTER TABLE IfcConstraintUsage ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcConstraintUsage ADD [Intent] VARCHAR(50);
				
ALTER TABLE IfcConstraintUsage ADD [Constraint] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConstructionEquipmentResource'
-- ENTITY Table Definition
CREATE TABLE IfcConstructionEquipmentResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConstructionEquipmentResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD [Name]  ntext;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD [Description]  ntext;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcConstructionEquipmentResource ADD [ResourceConsumption] VARCHAR(50);
				
ALTER TABLE IfcConstructionEquipmentResource ADD [BaseUnit] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConstructionMaterialResource'
-- ENTITY Table Definition
CREATE TABLE IfcConstructionMaterialResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConstructionMaterialResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcConstructionMaterialResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcConstructionMaterialResource ADD [Name]  ntext;										
				
ALTER TABLE IfcConstructionMaterialResource ADD [Description]  ntext;										
				
ALTER TABLE IfcConstructionMaterialResource ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcConstructionMaterialResource ADD [ResourceConsumption] VARCHAR(50);
				
ALTER TABLE IfcConstructionMaterialResource ADD [BaseUnit] VARCHAR(50);
					
CREATE TABLE IfcConstructionMaterialResource_Suppliers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcConstructionMaterialResource_Suppliers ADD CONSTRAINT
	PK_IfcConstructionMaterialResource_Suppliers FOREIGN KEY (pid)
	REFERENCES IfcConstructionMaterialResource (oid) ON DELETE CASCADE;

ALTER TABLE IfcConstructionMaterialResource ADD [OrderQuantity] VARCHAR(50);
					
CREATE TABLE IfcConstructionMaterialResource_DesignMaterial (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcConstructionMaterialResource_DesignMaterial ADD CONSTRAINT
	PK_IfcConstructionMaterialResource_DesignMaterial FOREIGN KEY (pid)
	REFERENCES IfcConstructionMaterialResource (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConstructionProductResource'
-- ENTITY Table Definition
CREATE TABLE IfcConstructionProductResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConstructionProductResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcConstructionProductResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcConstructionProductResource ADD [Name]  ntext;										
				
ALTER TABLE IfcConstructionProductResource ADD [Description]  ntext;										
				
ALTER TABLE IfcConstructionProductResource ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcConstructionProductResource ADD [ResourceConsumption] VARCHAR(50);
				
ALTER TABLE IfcConstructionProductResource ADD [BaseUnit] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcContextDependentUnit'
-- ENTITY Table Definition
CREATE TABLE IfcContextDependentUnit (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcContextDependentUnit ADD [Dimensions] VARCHAR(50);
				
ALTER TABLE IfcContextDependentUnit ADD [UnitType] VARCHAR(50);
				
ALTER TABLE IfcContextDependentUnit ADD [Name]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcControlElement'
-- ENTITY Table Definition
CREATE TABLE IfcControlElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcControlElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcControlElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcControlElement ADD [Name]  ntext;										
				
ALTER TABLE IfcControlElement ADD [Description]  ntext;										
				
ALTER TABLE IfcControlElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcControlElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcControlElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcControlElement ADD [Tag]  ntext;										
				
ALTER TABLE IfcControlElement ADD [ControlElementId]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcController'
-- ENTITY Table Definition
CREATE TABLE IfcController (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcController ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcController ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcController ADD [Name]  ntext;										
				
ALTER TABLE IfcController ADD [Description]  ntext;										
				
ALTER TABLE IfcController ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcController ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcController ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcController ADD [Tag]  ntext;										
				
ALTER TABLE IfcController ADD [ControlElementId]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcConversionBasedUnit'
-- ENTITY Table Definition
CREATE TABLE IfcConversionBasedUnit (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcConversionBasedUnit ADD [Dimensions] VARCHAR(50);
				
ALTER TABLE IfcConversionBasedUnit ADD [UnitType] VARCHAR(50);
				
ALTER TABLE IfcConversionBasedUnit ADD [Name]  ntext;										
				
ALTER TABLE IfcConversionBasedUnit ADD [ConversionFactor] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCoolingTower'
-- ENTITY Table Definition
CREATE TABLE IfcCoolingTower (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCoolingTower ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCoolingTower ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCoolingTower ADD [Name]  ntext;										
				
ALTER TABLE IfcCoolingTower ADD [Description]  ntext;										
				
ALTER TABLE IfcCoolingTower ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCoolingTower ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcCoolingTower ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcCoolingTower ADD [Tag]  ntext;										
				
ALTER TABLE IfcCoolingTower ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcCoolingTower ADD [HeatTransferRate]  float;										
				
ALTER TABLE IfcCoolingTower ADD [ThermalEfficiency]  float;										
				
ALTER TABLE IfcCoolingTower ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcCoolingTower ADD [CoolingTowerType] VARCHAR(50);
				
CREATE TABLE IfcCoolingTower_AmbientDesignTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcCoolingTower_AmbientDesignTemperature ADD CONSTRAINT
	PK_IfcCoolingTower_AmbientDesignTemperature FOREIGN KEY (pid)
	REFERENCES IfcCoolingTower (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCoordinatedUniversalTimeOffset'
-- ENTITY Table Definition
CREATE TABLE IfcCoordinatedUniversalTimeOffset (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCoordinatedUniversalTimeOffset ADD [HourOffset]  int;										
				
ALTER TABLE IfcCoordinatedUniversalTimeOffset ADD [MinuteOffset]  int;										
				
ALTER TABLE IfcCoordinatedUniversalTimeOffset ADD [Sense] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCost'
-- ENTITY Table Definition
CREATE TABLE IfcCost (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCost ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCost ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCost ADD [Name]  ntext;										
				
ALTER TABLE IfcCost ADD [Description]  ntext;										
				
ALTER TABLE IfcCost ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCost ADD [ContextDescription]  ntext;										
				
ALTER TABLE IfcCost ADD [ElementCost] VARCHAR(50);
				
ALTER TABLE IfcCost ADD [ExtensionCost] VARCHAR(50);
				
ALTER TABLE IfcCost ADD [CostUse] VARCHAR(50);
				
ALTER TABLE IfcCost ADD [PreparedOn] VARCHAR(50);
					
CREATE TABLE IfcCost_Quantities (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCost_Quantities ADD CONSTRAINT
	PK_IfcCost_Quantities FOREIGN KEY (pid)
	REFERENCES IfcCost (oid) ON DELETE CASCADE;

ALTER TABLE IfcCost ADD [CostType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCostModifier'
-- ENTITY Table Definition
CREATE TABLE IfcCostModifier (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCostModifier ADD [Purpose]  ntext;										
					
CREATE TABLE IfcCostModifier_ModifierValue (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcCostModifier_ModifierValue ADD CONSTRAINT
	PK_IfcCostModifier_ModifierValue FOREIGN KEY (pid)
	REFERENCES IfcCostModifier (oid) ON DELETE CASCADE;

ALTER TABLE IfcCostModifier ADD [ModifierDate] VARCHAR(50);
				
ALTER TABLE IfcCostModifier ADD [CostOperator] VARCHAR(50);
				
ALTER TABLE IfcCostModifier ADD [ModifierBasis] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCostModifierValue'
-- ENTITY Table Definition
CREATE TABLE IfcCostModifierValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCostModifierValue ADD [ModifierAmount]  float;										
				
ALTER TABLE IfcCostModifierValue ADD [Currency] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCostQuantity'
-- ENTITY Table Definition
CREATE TABLE IfcCostQuantity (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCostQuantity ADD [BaseQuantity] VARCHAR(50);
				
ALTER TABLE IfcCostQuantity ADD [FinalQuantity] VARCHAR(50);
				
ALTER TABLE IfcCostQuantity ADD [WasteFactor]  float;										
				
ALTER TABLE IfcCostQuantity ADD [RoundOffIncrement]  float;										
				
ALTER TABLE IfcCostQuantity ADD [RoundOffBasis] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCostSchedule'
-- ENTITY Table Definition
CREATE TABLE IfcCostSchedule (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCostSchedule ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCostSchedule ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCostSchedule ADD [Name]  ntext;										
				
ALTER TABLE IfcCostSchedule ADD [Description]  ntext;										
				
ALTER TABLE IfcCostSchedule ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCostSchedule ADD [Title]  ntext;										
				
ALTER TABLE IfcCostSchedule ADD [SubmittedBy]  VARCHAR(50);
					
CREATE TABLE IfcCostSchedule_ApprovedBy (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCostSchedule_ApprovedBy ADD CONSTRAINT
	PK_IfcCostSchedule_ApprovedBy FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid) ON DELETE CASCADE;

ALTER TABLE IfcCostSchedule ADD [PreparedBy] VARCHAR(50);
				
ALTER TABLE IfcCostSchedule ADD [SubmittedOn] VARCHAR(50);
				
ALTER TABLE IfcCostSchedule ADD [TotalCost] VARCHAR(50);
					
CREATE TABLE IfcCostSchedule_CostElements (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCostSchedule_CostElements ADD CONSTRAINT
	PK_IfcCostSchedule_CostElements FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid) ON DELETE CASCADE;

ALTER TABLE IfcCostSchedule ADD [Status]  ntext;										
				
ALTER TABLE IfcCostSchedule ADD [IntendedUse]  ntext;										
				
CREATE TABLE IfcCostSchedule_Comments (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcCostSchedule_Comments ADD CONSTRAINT
	PK_IfcCostSchedule_Comments FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcCostSchedule_TargetUsers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCostSchedule_TargetUsers ADD CONSTRAINT
	PK_IfcCostSchedule_TargetUsers FOREIGN KEY (pid)
	REFERENCES IfcCostSchedule (oid) ON DELETE CASCADE;

ALTER TABLE IfcCostSchedule ADD [ValidFromDate] VARCHAR(50);
				
ALTER TABLE IfcCostSchedule ADD [ValidToDate] VARCHAR(50);
				
ALTER TABLE IfcCostSchedule ADD [UpdateDate] VARCHAR(50);
				
ALTER TABLE IfcCostSchedule ADD [ScheduleNumber]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCostValue'
-- ENTITY Table Definition
CREATE TABLE IfcCostValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCostValue ADD [BaseCostValue]  float;										
				
ALTER TABLE IfcCostValue ADD [FinalCostValue]  float;										
				
ALTER TABLE IfcCostValue ADD [Currency] VARCHAR(50);
				
ALTER TABLE IfcCostValue ADD [UnitCostBasis] VARCHAR(50);
				
ALTER TABLE IfcCostValue ADD [CostType]  ntext;										
				
ALTER TABLE IfcCostValue ADD [CostDate] VARCHAR(50);
					
CREATE TABLE IfcCostValue_CostModifiers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCostValue_CostModifiers ADD CONSTRAINT
	PK_IfcCostValue_CostModifiers FOREIGN KEY (pid)
	REFERENCES IfcCostValue (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCostValueRelationship'
-- ENTITY Table Definition
CREATE TABLE IfcCostValueRelationship (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCostValueRelationship ADD [ComponentOf] VARCHAR(50);
					
CREATE TABLE IfcCostValueRelationship_CostComponents (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCostValueRelationship_CostComponents ADD CONSTRAINT
	PK_IfcCostValueRelationship_CostComponents FOREIGN KEY (pid)
	REFERENCES IfcCostValueRelationship (oid) ON DELETE CASCADE;

ALTER TABLE IfcCostValueRelationship ADD [Description]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCovering'
-- ENTITY Table Definition
CREATE TABLE IfcCovering (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCovering ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCovering ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCovering ADD [Name]  ntext;										
				
ALTER TABLE IfcCovering ADD [Description]  ntext;										
				
ALTER TABLE IfcCovering ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCovering ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcCovering ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcCovering ADD [Tag]  ntext;										
				
ALTER TABLE IfcCovering ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCrewResource'
-- ENTITY Table Definition
CREATE TABLE IfcCrewResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCrewResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCrewResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCrewResource ADD [Name]  ntext;										
				
ALTER TABLE IfcCrewResource ADD [Description]  ntext;										
				
ALTER TABLE IfcCrewResource ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCrewResource ADD [ResourceConsumption] VARCHAR(50);
				
ALTER TABLE IfcCrewResource ADD [BaseUnit] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCsgSolid'
-- ENTITY Table Definition
CREATE TABLE IfcCsgSolid (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCsgSolid ADD [TreeRootExpression]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCurtainWall'
-- ENTITY Table Definition
CREATE TABLE IfcCurtainWall (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCurtainWall ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcCurtainWall ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcCurtainWall ADD [Name]  ntext;										
				
ALTER TABLE IfcCurtainWall ADD [Description]  ntext;										
				
ALTER TABLE IfcCurtainWall ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcCurtainWall ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcCurtainWall ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcCurtainWall ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcCurveBoundedPlane'
-- ENTITY Table Definition
CREATE TABLE IfcCurveBoundedPlane (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcCurveBoundedPlane ADD [BasisSurface] VARCHAR(50);
				
ALTER TABLE IfcCurveBoundedPlane ADD [OuterBoundary] VARCHAR(50);
					
CREATE TABLE IfcCurveBoundedPlane_InnerBoundaries (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcCurveBoundedPlane_InnerBoundaries ADD CONSTRAINT
	PK_IfcCurveBoundedPlane_InnerBoundaries FOREIGN KEY (pid)
	REFERENCES IfcCurveBoundedPlane (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDamper'
-- ENTITY Table Definition
CREATE TABLE IfcDamper (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDamper ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDamper ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDamper ADD [Name]  ntext;										
				
ALTER TABLE IfcDamper ADD [Description]  ntext;										
				
ALTER TABLE IfcDamper ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcDamper ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcDamper ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcDamper ADD [Tag]  ntext;										
				
ALTER TABLE IfcDamper ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcDamper ADD [PredefinedType] VARCHAR(50);
				
ALTER TABLE IfcDamper ADD [FrameDepth]  float;										
				
ALTER TABLE IfcDamper ADD [SizingMethod] VARCHAR(50);
				
ALTER TABLE IfcDamper ADD [CloseOffRating]  float;										
				
ALTER TABLE IfcDamper ADD [LeakageAirFlowRate]  float;										
				
ALTER TABLE IfcDamper ADD [PercentOpen]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDateAndTime'
-- ENTITY Table Definition
CREATE TABLE IfcDateAndTime (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDateAndTime ADD [DateComponent] VARCHAR(50);
				
ALTER TABLE IfcDateAndTime ADD [TimeComponent] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDerivedProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcDerivedProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDerivedProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcDerivedProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcDerivedProfileDef ADD [ParentProfile] VARCHAR(50);
				
ALTER TABLE IfcDerivedProfileDef ADD [Operator] VARCHAR(50);
				
ALTER TABLE IfcDerivedProfileDef ADD [Label]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDerivedUnit'
-- ENTITY Table Definition
CREATE TABLE IfcDerivedUnit (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcDerivedUnit_Elements (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcDerivedUnit_Elements ADD CONSTRAINT
	PK_IfcDerivedUnit_Elements FOREIGN KEY (pid)
	REFERENCES IfcDerivedUnit (oid) ON DELETE CASCADE;

ALTER TABLE IfcDerivedUnit ADD [UnitType] VARCHAR(50);
				
ALTER TABLE IfcDerivedUnit ADD [UserDefinedType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDerivedUnitElement'
-- ENTITY Table Definition
CREATE TABLE IfcDerivedUnitElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDerivedUnitElement ADD [Unit] VARCHAR(50);
				
ALTER TABLE IfcDerivedUnitElement ADD [Exponent]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDimensionalExponents'
-- ENTITY Table Definition
CREATE TABLE IfcDimensionalExponents (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDimensionalExponents ADD [LengthExponent]  int;										
				
ALTER TABLE IfcDimensionalExponents ADD [MassExponent]  int;										
				
ALTER TABLE IfcDimensionalExponents ADD [TimeExponent]  int;										
				
ALTER TABLE IfcDimensionalExponents ADD [ElectricCurrentExponent]  int;										
				
ALTER TABLE IfcDimensionalExponents ADD [ThermodynamicTemperatureExponent]  int;										
				
ALTER TABLE IfcDimensionalExponents ADD [AmountOfSubstanceExponent]  int;										
				
ALTER TABLE IfcDimensionalExponents ADD [LuminousIntensityExponent]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDirection'
-- ENTITY Table Definition
CREATE TABLE IfcDirection (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
CREATE TABLE IfcDirection_DirectionRatios (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcDirection_DirectionRatios ADD CONSTRAINT
	PK_IfcDirection_DirectionRatios FOREIGN KEY (pid)
	REFERENCES IfcDirection (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDirectionalLightSource'
-- ENTITY Table Definition
CREATE TABLE IfcDirectionalLightSource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
CREATE TABLE IfcDirectionalLightSource_Color (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcDirectionalLightSource_Color ADD CONSTRAINT
	PK_IfcDirectionalLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcDirectionalLightSource (oid) ON DELETE CASCADE;

ALTER TABLE IfcDirectionalLightSource ADD [AmbientIntensity]  float;										
				
ALTER TABLE IfcDirectionalLightSource ADD [Intensity]  float;										
				
ALTER TABLE IfcDirectionalLightSource ADD [InContext] VARCHAR(50);
				
ALTER TABLE IfcDirectionalLightSource ADD [Name]  ntext;										
				
ALTER TABLE IfcDirectionalLightSource ADD [Description]  ntext;										
				
ALTER TABLE IfcDirectionalLightSource ADD [Direction] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDiscreteElement'
-- ENTITY Table Definition
CREATE TABLE IfcDiscreteElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDiscreteElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDiscreteElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDiscreteElement ADD [Name]  ntext;										
				
ALTER TABLE IfcDiscreteElement ADD [Description]  ntext;										
				
ALTER TABLE IfcDiscreteElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcDiscreteElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcDiscreteElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcDiscreteElement ADD [Tag]  ntext;										
				
ALTER TABLE IfcDiscreteElement ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDistributionElement'
-- ENTITY Table Definition
CREATE TABLE IfcDistributionElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDistributionElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDistributionElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDistributionElement ADD [Name]  ntext;										
				
ALTER TABLE IfcDistributionElement ADD [Description]  ntext;										
				
ALTER TABLE IfcDistributionElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcDistributionElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcDistributionElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcDistributionElement ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDistributionFlowElement'
-- ENTITY Table Definition
CREATE TABLE IfcDistributionFlowElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDistributionFlowElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDistributionFlowElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDistributionFlowElement ADD [Name]  ntext;										
				
ALTER TABLE IfcDistributionFlowElement ADD [Description]  ntext;										
				
ALTER TABLE IfcDistributionFlowElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcDistributionFlowElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcDistributionFlowElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcDistributionFlowElement ADD [Tag]  ntext;										
				
ALTER TABLE IfcDistributionFlowElement ADD [FlowElementType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDocumentElectronicFormat'
-- ENTITY Table Definition
CREATE TABLE IfcDocumentElectronicFormat (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDocumentElectronicFormat ADD [FileExtension]  ntext;										
				
ALTER TABLE IfcDocumentElectronicFormat ADD [MimeContentType]  ntext;										
				
ALTER TABLE IfcDocumentElectronicFormat ADD [MimeSubtype]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDocumentInformation'
-- ENTITY Table Definition
CREATE TABLE IfcDocumentInformation (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDocumentInformation ADD [DocumentId]  ntext;										
				
ALTER TABLE IfcDocumentInformation ADD [Name]  ntext;										
				
ALTER TABLE IfcDocumentInformation ADD [Description]  ntext;										
					
CREATE TABLE IfcDocumentInformation_DocumentReferences (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcDocumentInformation_DocumentReferences ADD CONSTRAINT
	PK_IfcDocumentInformation_DocumentReferences FOREIGN KEY (pid)
	REFERENCES IfcDocumentInformation (oid) ON DELETE CASCADE;

ALTER TABLE IfcDocumentInformation ADD [Purpose]  ntext;										
				
ALTER TABLE IfcDocumentInformation ADD [IntendedUse]  ntext;										
				
ALTER TABLE IfcDocumentInformation ADD [Scope]  ntext;										
				
ALTER TABLE IfcDocumentInformation ADD [Revision]  ntext;										
				
ALTER TABLE IfcDocumentInformation ADD [DocumentOwner]  VARCHAR(50);
					
CREATE TABLE IfcDocumentInformation_Editors (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcDocumentInformation_Editors ADD CONSTRAINT
	PK_IfcDocumentInformation_Editors FOREIGN KEY (pid)
	REFERENCES IfcDocumentInformation (oid) ON DELETE CASCADE;

ALTER TABLE IfcDocumentInformation ADD [CreationTime] VARCHAR(50);
				
ALTER TABLE IfcDocumentInformation ADD [LastRevisionTime] VARCHAR(50);
				
ALTER TABLE IfcDocumentInformation ADD [ElectronicFormat] VARCHAR(50);
				
ALTER TABLE IfcDocumentInformation ADD [ValidFrom] VARCHAR(50);
				
ALTER TABLE IfcDocumentInformation ADD [ValidUntil] VARCHAR(50);
				
ALTER TABLE IfcDocumentInformation ADD [Confidentiality] VARCHAR(50);
				
ALTER TABLE IfcDocumentInformation ADD [Status] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDocumentInformationRelationship'
-- ENTITY Table Definition
CREATE TABLE IfcDocumentInformationRelationship (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDocumentInformationRelationship ADD [RelatingDocument] VARCHAR(50);
					
CREATE TABLE IfcDocumentInformationRelationship_RelatedDocuments (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcDocumentInformationRelationship_RelatedDocuments ADD CONSTRAINT
	PK_IfcDocumentInformationRelationship_RelatedDocuments FOREIGN KEY (pid)
	REFERENCES IfcDocumentInformationRelationship (oid) ON DELETE CASCADE;

ALTER TABLE IfcDocumentInformationRelationship ADD [RelationshipType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDocumentReference'
-- ENTITY Table Definition
CREATE TABLE IfcDocumentReference (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDocumentReference ADD [Location]  ntext;										
				
ALTER TABLE IfcDocumentReference ADD [ItemReference]  ntext;										
				
ALTER TABLE IfcDocumentReference ADD [Name]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDoor'
-- ENTITY Table Definition
CREATE TABLE IfcDoor (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDoor ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDoor ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDoor ADD [Name]  ntext;										
				
ALTER TABLE IfcDoor ADD [Description]  ntext;										
				
ALTER TABLE IfcDoor ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcDoor ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcDoor ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcDoor ADD [Tag]  ntext;										
				
ALTER TABLE IfcDoor ADD [OverallHeight]  float;										
				
ALTER TABLE IfcDoor ADD [OverallWidth]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDoorLiningProperties'
-- ENTITY Table Definition
CREATE TABLE IfcDoorLiningProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDoorLiningProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDoorLiningProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDoorLiningProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcDoorLiningProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcDoorLiningProperties ADD [LiningDepth]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [LiningThickness]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [ThresholdDepth]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [ThresholdThickness]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [TransomThickness]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [TransomOffset]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [LiningOffset]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [ThresholdOffset]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [CasingThickness]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [CasingDepth]  float;										
				
ALTER TABLE IfcDoorLiningProperties ADD [ShapeAspectStyle] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDoorPanelProperties'
-- ENTITY Table Definition
CREATE TABLE IfcDoorPanelProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDoorPanelProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDoorPanelProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDoorPanelProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcDoorPanelProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcDoorPanelProperties ADD [PanelDepth]  float;										
				
ALTER TABLE IfcDoorPanelProperties ADD [PanelOperation] VARCHAR(50);
				
ALTER TABLE IfcDoorPanelProperties ADD [PanelWidth]  float;										
				
ALTER TABLE IfcDoorPanelProperties ADD [PanelPosition] VARCHAR(50);
				
ALTER TABLE IfcDoorPanelProperties ADD [ShapeAspectStyle] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcDoorStyle'
-- ENTITY Table Definition
CREATE TABLE IfcDoorStyle (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcDoorStyle ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcDoorStyle ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcDoorStyle ADD [Name]  ntext;										
				
ALTER TABLE IfcDoorStyle ADD [Description]  ntext;										
				
ALTER TABLE IfcDoorStyle ADD [ApplicableOccurrence]  ntext;										
					
CREATE TABLE IfcDoorStyle_HasPropertySets (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcDoorStyle_HasPropertySets ADD CONSTRAINT
	PK_IfcDoorStyle_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcDoorStyle (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcDoorStyle_RepresentationMaps (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcDoorStyle_RepresentationMaps ADD CONSTRAINT
	PK_IfcDoorStyle_RepresentationMaps FOREIGN KEY (pid)
	REFERENCES IfcDoorStyle (oid) ON DELETE CASCADE;

ALTER TABLE IfcDoorStyle ADD [Tag]  ntext;										
				
ALTER TABLE IfcDoorStyle ADD [OperationType] VARCHAR(50);
				
ALTER TABLE IfcDoorStyle ADD [ConstructionType] VARCHAR(50);
				
ALTER TABLE IfcDoorStyle ADD [ParameterTakesPrecedence]  BIT;										
				
ALTER TABLE IfcDoorStyle ADD [Sizeable]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcEdge'
-- ENTITY Table Definition
CREATE TABLE IfcEdge (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcEdge ADD [EdgeStart] VARCHAR(50);
				
ALTER TABLE IfcEdge ADD [EdgeEnd] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcEdgeCurve'
-- ENTITY Table Definition
CREATE TABLE IfcEdgeCurve (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcEdgeCurve ADD [EdgeStart] VARCHAR(50);
				
ALTER TABLE IfcEdgeCurve ADD [EdgeEnd] VARCHAR(50);
				
ALTER TABLE IfcEdgeCurve ADD [EdgeGeometry] VARCHAR(50);
				
ALTER TABLE IfcEdgeCurve ADD [SameSense]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcElectricalAppliance'
-- ENTITY Table Definition
CREATE TABLE IfcElectricalAppliance (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcElectricalAppliance ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcElectricalAppliance ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcElectricalAppliance ADD [Name]  ntext;										
				
ALTER TABLE IfcElectricalAppliance ADD [Description]  ntext;										
				
ALTER TABLE IfcElectricalAppliance ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcElectricalAppliance ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcElectricalAppliance ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcElectricalAppliance ADD [Tag]  ntext;										
				
ALTER TABLE IfcElectricalAppliance ADD [ApplianceType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcElectricalBaseProperties'
-- ENTITY Table Definition
CREATE TABLE IfcElectricalBaseProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcElectricalBaseProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcElectricalBaseProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [ElectricCurrentType] VARCHAR(50);
				
ALTER TABLE IfcElectricalBaseProperties ADD [InputVoltage]  float;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [InputFrequency]  float;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [FullLoadCurrent]  float;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [MinimumCircuitCurrent]  float;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [MaximumPowerInput]  float;										
				
ALTER TABLE IfcElectricalBaseProperties ADD [RatedPowerInput]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcElectricalElement'
-- ENTITY Table Definition
CREATE TABLE IfcElectricalElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcElectricalElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcElectricalElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcElectricalElement ADD [Name]  ntext;										
				
ALTER TABLE IfcElectricalElement ADD [Description]  ntext;										
				
ALTER TABLE IfcElectricalElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcElectricalElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcElectricalElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcElectricalElement ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcElectricalExtendedProperties'
-- ENTITY Table Definition
CREATE TABLE IfcElectricalExtendedProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcElectricalExtendedProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcElectricalExtendedProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [ElectricCurrentType] VARCHAR(50);
				
ALTER TABLE IfcElectricalExtendedProperties ADD [InputVoltage]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [InputFrequency]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [FullLoadCurrent]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [MinimumCircuitCurrent]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [MaximumPowerInput]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [RatedPowerInput]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [InputPhase]  int;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [InrushCurrent]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [LockedRotorCurrent]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [CircuitSizePowerInput]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [FuseSize]  float;										
				
ALTER TABLE IfcElectricalExtendedProperties ADD [Grounded]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcElectricMotor'
-- ENTITY Table Definition
CREATE TABLE IfcElectricMotor (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcElectricMotor ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcElectricMotor ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcElectricMotor ADD [Name]  ntext;										
				
ALTER TABLE IfcElectricMotor ADD [Description]  ntext;										
				
ALTER TABLE IfcElectricMotor ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcElectricMotor ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcElectricMotor ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcElectricMotor ADD [Tag]  ntext;										
				
ALTER TABLE IfcElectricMotor ADD [MotorWindingType] VARCHAR(50);
				
ALTER TABLE IfcElectricMotor ADD [Efficiency]  float;										
				
ALTER TABLE IfcElectricMotor ADD [PowerOutput]  float;										
				
ALTER TABLE IfcElectricMotor ADD [FrameConfiguration]  ntext;										
				
ALTER TABLE IfcElectricMotor ADD [InsulationRating_]  ntext;										
				
ALTER TABLE IfcElectricMotor ADD [MotorHousing] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcElementQuantity'
-- ENTITY Table Definition
CREATE TABLE IfcElementQuantity (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcElementQuantity ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcElementQuantity ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcElementQuantity ADD [Name]  ntext;										
				
ALTER TABLE IfcElementQuantity ADD [Description]  ntext;										
				
ALTER TABLE IfcElementQuantity ADD [MethodOfMeasurement]  ntext;										
					
CREATE TABLE IfcElementQuantity_Quantities (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcElementQuantity_Quantities ADD CONSTRAINT
	PK_IfcElementQuantity_Quantities FOREIGN KEY (pid)
	REFERENCES IfcElementQuantity (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcEllipse'
-- ENTITY Table Definition
CREATE TABLE IfcEllipse (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcEllipse ADD [Position]  VARCHAR(50);
				
ALTER TABLE IfcEllipse ADD [SemiAxis1]  float;										
				
ALTER TABLE IfcEllipse ADD [SemiAxis2]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcEllipseProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcEllipseProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcEllipseProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcEllipseProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcEllipseProfileDef ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcEllipseProfileDef ADD [SemiAxis1]  float;										
				
ALTER TABLE IfcEllipseProfileDef ADD [SemiAxis2]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcEquipmentElement'
-- ENTITY Table Definition
CREATE TABLE IfcEquipmentElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcEquipmentElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcEquipmentElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcEquipmentElement ADD [Name]  ntext;										
				
ALTER TABLE IfcEquipmentElement ADD [Description]  ntext;										
				
ALTER TABLE IfcEquipmentElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcEquipmentElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcEquipmentElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcEquipmentElement ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcEquipmentStandard'
-- ENTITY Table Definition
CREATE TABLE IfcEquipmentStandard (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcEquipmentStandard ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcEquipmentStandard ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcEquipmentStandard ADD [Name]  ntext;										
				
ALTER TABLE IfcEquipmentStandard ADD [Description]  ntext;										
				
ALTER TABLE IfcEquipmentStandard ADD [ObjectType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcExtendedMaterialProperties'
-- ENTITY Table Definition
CREATE TABLE IfcExtendedMaterialProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcExtendedMaterialProperties ADD [Material] VARCHAR(50);
					
CREATE TABLE IfcExtendedMaterialProperties_ExtendedProperties (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcExtendedMaterialProperties_ExtendedProperties ADD CONSTRAINT
	PK_IfcExtendedMaterialProperties_ExtendedProperties FOREIGN KEY (pid)
	REFERENCES IfcExtendedMaterialProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcExtendedMaterialProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcExtendedMaterialProperties ADD [Name]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcExtrudedAreaSolid'
-- ENTITY Table Definition
CREATE TABLE IfcExtrudedAreaSolid (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcExtrudedAreaSolid ADD [SweptArea] VARCHAR(50);
				
ALTER TABLE IfcExtrudedAreaSolid ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcExtrudedAreaSolid ADD [ExtrudedDirection] VARCHAR(50);
				
ALTER TABLE IfcExtrudedAreaSolid ADD [Depth]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFace'
-- ENTITY Table Definition
CREATE TABLE IfcFace (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcFace_Bounds (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcFace_Bounds ADD CONSTRAINT
	PK_IfcFace_Bounds FOREIGN KEY (pid)
	REFERENCES IfcFace (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFaceBasedSurfaceModel'
-- ENTITY Table Definition
CREATE TABLE IfcFaceBasedSurfaceModel (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcFaceBasedSurfaceModel_FbsmFaces (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcFaceBasedSurfaceModel_FbsmFaces ADD CONSTRAINT
	PK_IfcFaceBasedSurfaceModel_FbsmFaces FOREIGN KEY (pid)
	REFERENCES IfcFaceBasedSurfaceModel (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFaceBound'
-- ENTITY Table Definition
CREATE TABLE IfcFaceBound (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFaceBound ADD [Bound] VARCHAR(50);
				
ALTER TABLE IfcFaceBound ADD [Orientation]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFaceOuterBound'
-- ENTITY Table Definition
CREATE TABLE IfcFaceOuterBound (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFaceOuterBound ADD [Bound] VARCHAR(50);
				
ALTER TABLE IfcFaceOuterBound ADD [Orientation]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFaceSurface'
-- ENTITY Table Definition
CREATE TABLE IfcFaceSurface (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcFaceSurface_Bounds (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcFaceSurface_Bounds ADD CONSTRAINT
	PK_IfcFaceSurface_Bounds FOREIGN KEY (pid)
	REFERENCES IfcFaceSurface (oid) ON DELETE CASCADE;

ALTER TABLE IfcFaceSurface ADD [FaceSurface] VARCHAR(50);
				
ALTER TABLE IfcFaceSurface ADD [SameSense]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFacetedBrep'
-- ENTITY Table Definition
CREATE TABLE IfcFacetedBrep (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFacetedBrep ADD [Outer] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFacetedBrepWithVoids'
-- ENTITY Table Definition
CREATE TABLE IfcFacetedBrepWithVoids (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFacetedBrepWithVoids ADD [Outer] VARCHAR(50);
					
CREATE TABLE IfcFacetedBrepWithVoids_Voids (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcFacetedBrepWithVoids_Voids ADD CONSTRAINT
	PK_IfcFacetedBrepWithVoids_Voids FOREIGN KEY (pid)
	REFERENCES IfcFacetedBrepWithVoids (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFan'
-- ENTITY Table Definition
CREATE TABLE IfcFan (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFan ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFan ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [Name]  ntext;										
				
ALTER TABLE IfcFan ADD [Description]  ntext;										
				
ALTER TABLE IfcFan ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFan ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [Tag]  ntext;										
				
ALTER TABLE IfcFan ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [ImpellerDiameter]  float;										
				
ALTER TABLE IfcFan ADD [AirFlowType] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [StaticPressure]  float;										
				
ALTER TABLE IfcFan ADD [FanPressureClass] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [FanWheelType] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [WheelMaterial]  VARCHAR(50);
				
ALTER TABLE IfcFan ADD [WheelTipSpeed]  float;										
				
ALTER TABLE IfcFan ADD [DischargeVelocity]  float;										
				
ALTER TABLE IfcFan ADD [HousingMaterial]  VARCHAR(50);
				
ALTER TABLE IfcFan ADD [DischargePressureLoss]  float;										
				
ALTER TABLE IfcFan ADD [FanDischargeType] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [FanArrangement] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [FanRotation] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [FanDriveArrangement] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [DrivePowerLoss_]  float;										
				
ALTER TABLE IfcFan ADD [MotorDriveType] VARCHAR(50);
				
ALTER TABLE IfcFan ADD [MotorInAirstream_]  BIT;										
				
ALTER TABLE IfcFan ADD [FanMountingType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFlowController'
-- ENTITY Table Definition
CREATE TABLE IfcFlowController (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFlowController ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFlowController ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFlowController ADD [Name]  ntext;										
				
ALTER TABLE IfcFlowController ADD [Description]  ntext;										
				
ALTER TABLE IfcFlowController ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFlowController ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFlowController ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFlowController ADD [Tag]  ntext;										
				
ALTER TABLE IfcFlowController ADD [FlowElementType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFlowFitting'
-- ENTITY Table Definition
CREATE TABLE IfcFlowFitting (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFlowFitting ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFlowFitting ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFlowFitting ADD [Name]  ntext;										
				
ALTER TABLE IfcFlowFitting ADD [Description]  ntext;										
				
ALTER TABLE IfcFlowFitting ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFlowFitting ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFlowFitting ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFlowFitting ADD [Tag]  ntext;										
				
ALTER TABLE IfcFlowFitting ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcFlowFitting ADD [PredefinedType] VARCHAR(50);
				
ALTER TABLE IfcFlowFitting ADD [PrimaryFittingType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFlowSegment'
-- ENTITY Table Definition
CREATE TABLE IfcFlowSegment (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFlowSegment ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFlowSegment ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFlowSegment ADD [Name]  ntext;										
				
ALTER TABLE IfcFlowSegment ADD [Description]  ntext;										
				
ALTER TABLE IfcFlowSegment ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFlowSegment ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFlowSegment ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFlowSegment ADD [Tag]  ntext;										
				
ALTER TABLE IfcFlowSegment ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcFlowSegment ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFlowTerminal'
-- ENTITY Table Definition
CREATE TABLE IfcFlowTerminal (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFlowTerminal ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFlowTerminal ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFlowTerminal ADD [Name]  ntext;										
				
ALTER TABLE IfcFlowTerminal ADD [Description]  ntext;										
				
ALTER TABLE IfcFlowTerminal ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFlowTerminal ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFlowTerminal ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFlowTerminal ADD [Tag]  ntext;										
				
ALTER TABLE IfcFlowTerminal ADD [FlowElementType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFluidFlowProperties'
-- ENTITY Table Definition
CREATE TABLE IfcFluidFlowProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFluidFlowProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFluidFlowProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFluidFlowProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcFluidFlowProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcFluidFlowProperties ADD [MaximumFlowRate]  float;										
				
ALTER TABLE IfcFluidFlowProperties ADD [DesignFlowrate]  float;										
				
ALTER TABLE IfcFluidFlowProperties ADD [MinimumFlowrate]  float;										
				
ALTER TABLE IfcFluidFlowProperties ADD [PressureLoss]  float;										
				
ALTER TABLE IfcFluidFlowProperties ADD [WorkingPressure]  float;										
				
ALTER TABLE IfcFluidFlowProperties ADD [PressureRating]  float;										
				
ALTER TABLE IfcFluidFlowProperties ADD [Fluid] VARCHAR(50);
				
ALTER TABLE IfcFluidFlowProperties ADD [DesignVelocity]  float;										
				
CREATE TABLE IfcFluidFlowProperties_DesignTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcFluidFlowProperties_DesignTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_DesignTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid) ON DELETE CASCADE;

CREATE TABLE IfcFluidFlowProperties_MaximumTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcFluidFlowProperties_MaximumTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_MaximumTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid) ON DELETE CASCADE;

CREATE TABLE IfcFluidFlowProperties_MinimumTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcFluidFlowProperties_MinimumTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_MinimumTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid) ON DELETE CASCADE;

CREATE TABLE IfcFluidFlowProperties_WorkingTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcFluidFlowProperties_WorkingTemperature ADD CONSTRAINT
	PK_IfcFluidFlowProperties_WorkingTemperature FOREIGN KEY (pid)
	REFERENCES IfcFluidFlowProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcFluidFlowProperties ADD [WorkingQuality]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFluidMovingDevice'
-- ENTITY Table Definition
CREATE TABLE IfcFluidMovingDevice (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFluidMovingDevice ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFluidMovingDevice ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFluidMovingDevice ADD [Name]  ntext;										
				
ALTER TABLE IfcFluidMovingDevice ADD [Description]  ntext;										
				
ALTER TABLE IfcFluidMovingDevice ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFluidMovingDevice ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFluidMovingDevice ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFluidMovingDevice ADD [Tag]  ntext;										
				
ALTER TABLE IfcFluidMovingDevice ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcFluidMovingDevice ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcFluidMovingDevice ADD [ImpellerDiameter]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFurnishingElement'
-- ENTITY Table Definition
CREATE TABLE IfcFurnishingElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFurnishingElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFurnishingElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFurnishingElement ADD [Name]  ntext;										
				
ALTER TABLE IfcFurnishingElement ADD [Description]  ntext;										
				
ALTER TABLE IfcFurnishingElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFurnishingElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFurnishingElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFurnishingElement ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFurniture'
-- ENTITY Table Definition
CREATE TABLE IfcFurniture (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFurniture ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFurniture ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFurniture ADD [Name]  ntext;										
				
ALTER TABLE IfcFurniture ADD [Description]  ntext;										
				
ALTER TABLE IfcFurniture ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcFurniture ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcFurniture ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcFurniture ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcFurnitureStandard'
-- ENTITY Table Definition
CREATE TABLE IfcFurnitureStandard (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcFurnitureStandard ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcFurnitureStandard ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcFurnitureStandard ADD [Name]  ntext;										
				
ALTER TABLE IfcFurnitureStandard ADD [Description]  ntext;										
				
ALTER TABLE IfcFurnitureStandard ADD [ObjectType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcGeneralMaterialProperties'
-- ENTITY Table Definition
CREATE TABLE IfcGeneralMaterialProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcGeneralMaterialProperties ADD [Material] VARCHAR(50);
				
ALTER TABLE IfcGeneralMaterialProperties ADD [MolecularWeight]  float;										
				
ALTER TABLE IfcGeneralMaterialProperties ADD [Porosity]  float;										
				
ALTER TABLE IfcGeneralMaterialProperties ADD [MassDensity]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcGeometricRepresentationContext'
-- ENTITY Table Definition
CREATE TABLE IfcGeometricRepresentationContext (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcGeometricRepresentationContext ADD [ContextIdentifier]  ntext;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD [ContextType]  ntext;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD [CoordinateSpaceDimension]  int;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD [Precision]  float;										
				
ALTER TABLE IfcGeometricRepresentationContext ADD [WorldCoordinateSystem]  VARCHAR(50);
				
ALTER TABLE IfcGeometricRepresentationContext ADD [TrueNorth] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcGeometricSet'
-- ENTITY Table Definition
CREATE TABLE IfcGeometricSet (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcGeometricSet_Elements (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcGeometricSet_Elements ADD CONSTRAINT
	PK_IfcGeometricSet_Elements FOREIGN KEY (pid)
	REFERENCES IfcGeometricSet (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcGrid'
-- ENTITY Table Definition
CREATE TABLE IfcGrid (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcGrid ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcGrid ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcGrid ADD [Name]  ntext;										
				
ALTER TABLE IfcGrid ADD [Description]  ntext;										
				
ALTER TABLE IfcGrid ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcGrid ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcGrid ADD [Representation] VARCHAR(50);
					
CREATE TABLE IfcGrid_UAxes (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcGrid_UAxes ADD CONSTRAINT
	PK_IfcGrid_UAxes FOREIGN KEY (pid)
	REFERENCES IfcGrid (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcGrid_VAxes (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcGrid_VAxes ADD CONSTRAINT
	PK_IfcGrid_VAxes FOREIGN KEY (pid)
	REFERENCES IfcGrid (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcGrid_WAxes (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcGrid_WAxes ADD CONSTRAINT
	PK_IfcGrid_WAxes FOREIGN KEY (pid)
	REFERENCES IfcGrid (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcGridAxis'
-- ENTITY Table Definition
CREATE TABLE IfcGridAxis (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcGridAxis ADD [AxisTag]  ntext;										
				
ALTER TABLE IfcGridAxis ADD [AxisCurve] VARCHAR(50);
				
ALTER TABLE IfcGridAxis ADD [SameSense]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcGridPlacement'
-- ENTITY Table Definition
CREATE TABLE IfcGridPlacement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcGridPlacement ADD [PlacementLocation] VARCHAR(50);
				
ALTER TABLE IfcGridPlacement ADD [PlacementRefDirection] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcGroup'
-- ENTITY Table Definition
CREATE TABLE IfcGroup (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcGroup ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcGroup ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcGroup ADD [Name]  ntext;										
				
ALTER TABLE IfcGroup ADD [Description]  ntext;										
				
ALTER TABLE IfcGroup ADD [ObjectType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcHalfSpaceSolid'
-- ENTITY Table Definition
CREATE TABLE IfcHalfSpaceSolid (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcHalfSpaceSolid ADD [BaseSurface] VARCHAR(50);
				
ALTER TABLE IfcHalfSpaceSolid ADD [AgreementFlag]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcHeatExchanger'
-- ENTITY Table Definition
CREATE TABLE IfcHeatExchanger (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcHeatExchanger ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcHeatExchanger ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcHeatExchanger ADD [Name]  ntext;										
				
ALTER TABLE IfcHeatExchanger ADD [Description]  ntext;										
				
ALTER TABLE IfcHeatExchanger ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcHeatExchanger ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcHeatExchanger ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcHeatExchanger ADD [Tag]  ntext;										
				
ALTER TABLE IfcHeatExchanger ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcHeatExchanger ADD [HeatTransferRate]  float;										
				
ALTER TABLE IfcHeatExchanger ADD [ThermalEfficiency]  float;										
				
ALTER TABLE IfcHeatExchanger ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcHeatExchanger ADD [HeatExchangerType] VARCHAR(50);
				
ALTER TABLE IfcHeatExchanger ADD [HeatExchangerArrangement] VARCHAR(50);
				
ALTER TABLE IfcHeatExchanger ADD [NumberOfPlates]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcHeatTransferDevice'
-- ENTITY Table Definition
CREATE TABLE IfcHeatTransferDevice (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcHeatTransferDevice ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcHeatTransferDevice ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcHeatTransferDevice ADD [Name]  ntext;										
				
ALTER TABLE IfcHeatTransferDevice ADD [Description]  ntext;										
				
ALTER TABLE IfcHeatTransferDevice ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcHeatTransferDevice ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcHeatTransferDevice ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcHeatTransferDevice ADD [Tag]  ntext;										
				
ALTER TABLE IfcHeatTransferDevice ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcHeatTransferDevice ADD [HeatTransferRate]  float;										
				
ALTER TABLE IfcHeatTransferDevice ADD [ThermalEfficiency]  float;										
				
ALTER TABLE IfcHeatTransferDevice ADD [PrimaryEnergySource] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcHydronicHeater'
-- ENTITY Table Definition
CREATE TABLE IfcHydronicHeater (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcHydronicHeater ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcHydronicHeater ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcHydronicHeater ADD [Name]  ntext;										
				
ALTER TABLE IfcHydronicHeater ADD [Description]  ntext;										
				
ALTER TABLE IfcHydronicHeater ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcHydronicHeater ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcHydronicHeater ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcHydronicHeater ADD [Tag]  ntext;										
				
ALTER TABLE IfcHydronicHeater ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcHydronicHeater ADD [HydronicHeaterType] VARCHAR(50);
				
ALTER TABLE IfcHydronicHeater ADD [HeatOutput]  float;										
				
ALTER TABLE IfcHydronicHeater ADD [Enclosure]  ntext;										
				
ALTER TABLE IfcHydronicHeater ADD [BodyMass]  float;										
				
ALTER TABLE IfcHydronicHeater ADD [NumberOfPanels]  int;										
				
ALTER TABLE IfcHydronicHeater ADD [NumberOfSections]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcHygroscopicMaterialProperties'
-- ENTITY Table Definition
CREATE TABLE IfcHygroscopicMaterialProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcHygroscopicMaterialProperties ADD [Material] VARCHAR(50);
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD [UpperVaporResistanceFactor]  float;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD [LowerVaporResistanceFactor]  float;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD [IsothermalMoistureCapacity]  float;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD [VaporPermeability]  float;										
				
ALTER TABLE IfcHygroscopicMaterialProperties ADD [MoistureDiffusivity]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcInventory'
-- ENTITY Table Definition
CREATE TABLE IfcInventory (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcInventory ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcInventory ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcInventory ADD [Name]  ntext;										
				
ALTER TABLE IfcInventory ADD [Description]  ntext;										
				
ALTER TABLE IfcInventory ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcInventory ADD [DefinedType] VARCHAR(50);
				
ALTER TABLE IfcInventory ADD [Jurisdiction]  VARCHAR(50);
					
CREATE TABLE IfcInventory_ResponsiblePersons (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcInventory_ResponsiblePersons ADD CONSTRAINT
	PK_IfcInventory_ResponsiblePersons FOREIGN KEY (pid)
	REFERENCES IfcInventory (oid) ON DELETE CASCADE;

ALTER TABLE IfcInventory ADD [LastUpdateDate] VARCHAR(50);
				
ALTER TABLE IfcInventory ADD [CurrentValue] VARCHAR(50);
				
ALTER TABLE IfcInventory ADD [OriginalValue] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcIshapeProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcIshapeProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcIshapeProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcIshapeProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcIshapeProfileDef ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcIshapeProfileDef ADD [OverallWidth]  float;										
				
ALTER TABLE IfcIshapeProfileDef ADD [OverallDepth]  float;										
				
ALTER TABLE IfcIshapeProfileDef ADD [WebThickness]  float;										
				
ALTER TABLE IfcIshapeProfileDef ADD [FlangeThickness]  float;										
				
ALTER TABLE IfcIshapeProfileDef ADD [FilletRadius]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLaborResource'
-- ENTITY Table Definition
CREATE TABLE IfcLaborResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcLaborResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcLaborResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcLaborResource ADD [Name]  ntext;										
				
ALTER TABLE IfcLaborResource ADD [Description]  ntext;										
				
ALTER TABLE IfcLaborResource ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcLaborResource ADD [ResourceConsumption] VARCHAR(50);
				
ALTER TABLE IfcLaborResource ADD [BaseUnit] VARCHAR(50);
				
ALTER TABLE IfcLaborResource ADD [Title]  ntext;										
				
CREATE TABLE IfcLaborResource_SkillSet (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcLaborResource_SkillSet ADD CONSTRAINT
	PK_IfcLaborResource_SkillSet FOREIGN KEY (pid)
	REFERENCES IfcLaborResource (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLibraryInformation'
-- ENTITY Table Definition
CREATE TABLE IfcLibraryInformation (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcLibraryInformation ADD [Name]  ntext;										
				
ALTER TABLE IfcLibraryInformation ADD [Version]  ntext;										
				
ALTER TABLE IfcLibraryInformation ADD [Publisher] VARCHAR(50);
				
ALTER TABLE IfcLibraryInformation ADD [VersionDate] VARCHAR(50);
					
CREATE TABLE IfcLibraryInformation_LibraryReference (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcLibraryInformation_LibraryReference ADD CONSTRAINT
	PK_IfcLibraryInformation_LibraryReference FOREIGN KEY (pid)
	REFERENCES IfcLibraryInformation (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLibraryReference'
-- ENTITY Table Definition
CREATE TABLE IfcLibraryReference (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcLibraryReference ADD [Location]  ntext;										
				
ALTER TABLE IfcLibraryReference ADD [ItemReference]  ntext;										
				
ALTER TABLE IfcLibraryReference ADD [Name]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLightFixture'
-- ENTITY Table Definition
CREATE TABLE IfcLightFixture (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcLightFixture ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcLightFixture ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcLightFixture ADD [Name]  ntext;										
				
ALTER TABLE IfcLightFixture ADD [Description]  ntext;										
				
ALTER TABLE IfcLightFixture ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcLightFixture ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcLightFixture ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcLightFixture ADD [Tag]  ntext;										
				
ALTER TABLE IfcLightFixture ADD [MaximumSpaceSensibleLoad]  float;										
				
ALTER TABLE IfcLightFixture ADD [MaximumPlenumSensibleLoad_]  float;										
				
ALTER TABLE IfcLightFixture ADD [SensibleLoadToRadiant]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLine'
-- ENTITY Table Definition
CREATE TABLE IfcLine (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcLine ADD [Pnt] VARCHAR(50);
				
ALTER TABLE IfcLine ADD [Dir] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLocalPlacement'
-- ENTITY Table Definition
CREATE TABLE IfcLocalPlacement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcLocalPlacement ADD [PlacementRelTo] VARCHAR(50);
				
ALTER TABLE IfcLocalPlacement ADD [RelativePlacement]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLocalTime'
-- ENTITY Table Definition
CREATE TABLE IfcLocalTime (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcLocalTime ADD [HourComponent]  int;										
				
ALTER TABLE IfcLocalTime ADD [MinuteComponent]  int;										
				
ALTER TABLE IfcLocalTime ADD [SecondComponent]  float;										
				
ALTER TABLE IfcLocalTime ADD [Zone] VARCHAR(50);
				
ALTER TABLE IfcLocalTime ADD [DaylightSavingOffset]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcLoop'
-- ENTITY Table Definition
CREATE TABLE IfcLoop (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaintenanceRecord'
-- ENTITY Table Definition
CREATE TABLE IfcMaintenanceRecord (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMaintenanceRecord ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcMaintenanceRecord ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceRecord ADD [Name]  ntext;										
				
ALTER TABLE IfcMaintenanceRecord ADD [Description]  ntext;										
				
ALTER TABLE IfcMaintenanceRecord ADD [ObjectType]  ntext;										
					
CREATE TABLE IfcMaintenanceRecord_Records (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMaintenanceRecord_Records ADD CONSTRAINT
	PK_IfcMaintenanceRecord_Records FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceRecord (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaintenanceWorkOrder'
-- ENTITY Table Definition
CREATE TABLE IfcMaintenanceWorkOrder (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMaintenanceWorkOrder ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [Name]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [Description]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [OrderNumber]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [TransactionCode]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [IssuingDate] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [IssuedBy]  VARCHAR(50);
					
CREATE TABLE IfcMaintenanceWorkOrder_IssuedTo (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMaintenanceWorkOrder_IssuedTo ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcMaintenanceWorkOrder_AdditionalContacts (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMaintenanceWorkOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid) ON DELETE CASCADE;

CREATE TABLE IfcMaintenanceWorkOrder_Remarks (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMaintenanceWorkOrder_Remarks ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcMaintenanceWorkOrder ADD [Signoff] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [BudgetSource] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [ProductDescription]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [ShortJobDescription]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [LongJobDescription]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [WorkTypeRequested]  ntext;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [ContractualType]  ntext;										
				
CREATE TABLE IfcMaintenanceWorkOrder_IfNotAccomplished (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMaintenanceWorkOrder_IfNotAccomplished ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_IfNotAccomplished FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcMaintenanceWorkOrder ADD [RequestedStartTime] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [RequestedFinishTime] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [ActualStartTime] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [ActualFinishTime] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [CostEstimate] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [WorkPlan] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [Status] VARCHAR(50);
				
CREATE TABLE IfcMaintenanceWorkOrder_WorkOrderRiskType (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMaintenanceWorkOrder_WorkOrderRiskType ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_WorkOrderRiskType FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcMaintenanceWorkOrder_PerformedBy (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMaintenanceWorkOrder_PerformedBy ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_PerformedBy FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcMaintenanceWorkOrder ADD [ActualCost] VARCHAR(50);
				
CREATE TABLE IfcMaintenanceWorkOrder_SparesToolsEquipmentConsumables (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMaintenanceWorkOrder_SparesToolsEquipmentConsumables ADD CONSTRAINT
	PK_IfcMaintenanceWorkOrder_SparesToolsEquipmentConsumables FOREIGN KEY (pid)
	REFERENCES IfcMaintenanceWorkOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcMaintenanceWorkOrder ADD [MaintenanceType] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [FaultPriority] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [LocationPriority] VARCHAR(50);
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [AssetDowntime]  float;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [ScheduledFrequency]  float;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [RequiredResponseTime]  float;										
				
ALTER TABLE IfcMaintenanceWorkOrder ADD [LeadCraft]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcManufacturerInformation'
-- ENTITY Table Definition
CREATE TABLE IfcManufacturerInformation (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcManufacturerInformation ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcManufacturerInformation ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcManufacturerInformation ADD [Name]  ntext;										
				
ALTER TABLE IfcManufacturerInformation ADD [Description]  ntext;										
				
ALTER TABLE IfcManufacturerInformation ADD [ModelLabel]  ntext;										
				
ALTER TABLE IfcManufacturerInformation ADD [ModelReference]  ntext;										
				
ALTER TABLE IfcManufacturerInformation ADD [Manufacturer] VARCHAR(50);
					
CREATE TABLE IfcManufacturerInformation_QuantityInformation (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcManufacturerInformation_QuantityInformation ADD CONSTRAINT
	PK_IfcManufacturerInformation_QuantityInformation FOREIGN KEY (pid)
	REFERENCES IfcManufacturerInformation (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMappedItem'
-- ENTITY Table Definition
CREATE TABLE IfcMappedItem (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMappedItem ADD [MappingSource] VARCHAR(50);
				
ALTER TABLE IfcMappedItem ADD [MappingTarget] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaterial'
-- ENTITY Table Definition
CREATE TABLE IfcMaterial (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMaterial ADD [Name]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaterialClassificationRelationship'
-- ENTITY Table Definition
CREATE TABLE IfcMaterialClassificationRelationship (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcMaterialClassificationRelationship_MaterialClassifications (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMaterialClassificationRelationship_MaterialClassifications ADD CONSTRAINT
	PK_IfcMaterialClassificationRelationship_MaterialClassifications FOREIGN KEY (pid)
	REFERENCES IfcMaterialClassificationRelationship (oid) ON DELETE CASCADE;

ALTER TABLE IfcMaterialClassificationRelationship ADD [ClassifiedMaterial] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaterialLayer'
-- ENTITY Table Definition
CREATE TABLE IfcMaterialLayer (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMaterialLayer ADD [Material] VARCHAR(50);
				
ALTER TABLE IfcMaterialLayer ADD [LayerThickness]  float;										
				
ALTER TABLE IfcMaterialLayer ADD [IsVentilated]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaterialLayerSet'
-- ENTITY Table Definition
CREATE TABLE IfcMaterialLayerSet (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcMaterialLayerSet_MaterialLayers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMaterialLayerSet_MaterialLayers ADD CONSTRAINT
	PK_IfcMaterialLayerSet_MaterialLayers FOREIGN KEY (pid)
	REFERENCES IfcMaterialLayerSet (oid) ON DELETE CASCADE;

ALTER TABLE IfcMaterialLayerSet ADD [LayerSetName]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaterialLayerSetUsage'
-- ENTITY Table Definition
CREATE TABLE IfcMaterialLayerSetUsage (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMaterialLayerSetUsage ADD [ForLayerSet] VARCHAR(50);
				
ALTER TABLE IfcMaterialLayerSetUsage ADD [LayerSetDirection] VARCHAR(50);
				
ALTER TABLE IfcMaterialLayerSetUsage ADD [DirectionSense] VARCHAR(50);
				
ALTER TABLE IfcMaterialLayerSetUsage ADD [OffsetFromReferenceLine]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMaterialList'
-- ENTITY Table Definition
CREATE TABLE IfcMaterialList (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcMaterialList_Materials (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMaterialList_Materials ADD CONSTRAINT
	PK_IfcMaterialList_Materials FOREIGN KEY (pid)
	REFERENCES IfcMaterialList (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMeasureWithUnit'
-- ENTITY Table Definition
CREATE TABLE IfcMeasureWithUnit (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcMeasureWithUnit_ValueComponent (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcMeasureWithUnit_ValueComponent ADD CONSTRAINT
	PK_IfcMeasureWithUnit_ValueComponent FOREIGN KEY (pid)
	REFERENCES IfcMeasureWithUnit (oid) ON DELETE CASCADE;

ALTER TABLE IfcMeasureWithUnit ADD [UnitComponent]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMechanicalMaterialProperties'
-- ENTITY Table Definition
CREATE TABLE IfcMechanicalMaterialProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMechanicalMaterialProperties ADD [Material] VARCHAR(50);
				
ALTER TABLE IfcMechanicalMaterialProperties ADD [DynamicViscosity]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMetric'
-- ENTITY Table Definition
CREATE TABLE IfcMetric (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMetric ADD [ConstraintGrade] VARCHAR(50);
				
ALTER TABLE IfcMetric ADD [Description]  ntext;										
				
ALTER TABLE IfcMetric ADD [ConstraintSource]  ntext;										
				
ALTER TABLE IfcMetric ADD [Name]  ntext;										
				
ALTER TABLE IfcMetric ADD [CreatingActor]  VARCHAR(50);
				
ALTER TABLE IfcMetric ADD [CreationTime]  VARCHAR(50);
					
CREATE TABLE IfcMetric_Values (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMetric_Values ADD CONSTRAINT
	PK_IfcMetric_Values FOREIGN KEY (pid)
	REFERENCES IfcMetric (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMetricBenchmark'
-- ENTITY Table Definition
CREATE TABLE IfcMetricBenchmark (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMetricBenchmark ADD [ConstraintGrade] VARCHAR(50);
				
ALTER TABLE IfcMetricBenchmark ADD [Description]  ntext;										
				
ALTER TABLE IfcMetricBenchmark ADD [ConstraintSource]  ntext;										
				
ALTER TABLE IfcMetricBenchmark ADD [Name]  ntext;										
				
ALTER TABLE IfcMetricBenchmark ADD [CreatingActor]  VARCHAR(50);
				
ALTER TABLE IfcMetricBenchmark ADD [CreationTime]  VARCHAR(50);
					
CREATE TABLE IfcMetricBenchmark_Values (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMetricBenchmark_Values ADD CONSTRAINT
	PK_IfcMetricBenchmark_Values FOREIGN KEY (pid)
	REFERENCES IfcMetricBenchmark (oid) ON DELETE CASCADE;

ALTER TABLE IfcMetricBenchmark ADD [Benchmark] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMetricValue'
-- ENTITY Table Definition
CREATE TABLE IfcMetricValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMetricValue ADD [DataType] VARCHAR(50);
				
ALTER TABLE IfcMetricValue ADD [DataValue]  VARCHAR(50);
				
ALTER TABLE IfcMetricValue ADD [ValueSource]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMonetaryUnit'
-- ENTITY Table Definition
CREATE TABLE IfcMonetaryUnit (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMonetaryUnit ADD [Currency] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcMove'
-- ENTITY Table Definition
CREATE TABLE IfcMove (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcMove ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcMove ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcMove ADD [Name]  ntext;										
				
ALTER TABLE IfcMove ADD [Description]  ntext;										
				
ALTER TABLE IfcMove ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcMove ADD [Productivity] VARCHAR(50);
				
ALTER TABLE IfcMove ADD [TaskId]  ntext;										
				
CREATE TABLE IfcMove_WBSCode (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMove_WBSCode ADD CONSTRAINT
	PK_IfcMove_WBSCode FOREIGN KEY (pid)
	REFERENCES IfcMove (oid) ON DELETE CASCADE;

CREATE TABLE IfcMove_WBSSource (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMove_WBSSource ADD CONSTRAINT
	PK_IfcMove_WBSSource FOREIGN KEY (pid)
	REFERENCES IfcMove (oid) ON DELETE CASCADE;

ALTER TABLE IfcMove ADD [Status] VARCHAR(50);
				
CREATE TABLE IfcMove_Milestones (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMove_Milestones ADD CONSTRAINT
	PK_IfcMove_Milestones FOREIGN KEY (pid)
	REFERENCES IfcMove (oid) ON DELETE CASCADE;

ALTER TABLE IfcMove ADD [WorkMethod]  ntext;										
				
ALTER TABLE IfcMove ADD [InPlaceQuantity] VARCHAR(50);
				
ALTER TABLE IfcMove ADD [EstimatedQuantity] VARCHAR(50);
				
ALTER TABLE IfcMove ADD [BudgetQuantity] VARCHAR(50);
				
ALTER TABLE IfcMove ADD [IsRootTask]  BIT;										
				
ALTER TABLE IfcMove ADD [MoveFrom] VARCHAR(50);
				
ALTER TABLE IfcMove ADD [MoveTo] VARCHAR(50);
					
CREATE TABLE IfcMove_MoveConstraints (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcMove_MoveConstraints ADD CONSTRAINT
	PK_IfcMove_MoveConstraints FOREIGN KEY (pid)
	REFERENCES IfcMove (oid) ON DELETE CASCADE;

CREATE TABLE IfcMove_PunchList (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcMove_PunchList ADD CONSTRAINT
	PK_IfcMove_PunchList FOREIGN KEY (pid)
	REFERENCES IfcMove (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcObjective'
-- ENTITY Table Definition
CREATE TABLE IfcObjective (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcObjective ADD [ConstraintGrade] VARCHAR(50);
				
ALTER TABLE IfcObjective ADD [Description]  ntext;										
				
ALTER TABLE IfcObjective ADD [ConstraintSource]  ntext;										
				
ALTER TABLE IfcObjective ADD [Name]  ntext;										
				
ALTER TABLE IfcObjective ADD [CreatingActor]  VARCHAR(50);
				
ALTER TABLE IfcObjective ADD [CreationTime]  VARCHAR(50);
				
ALTER TABLE IfcObjective ADD [ObjectiveQualifier] VARCHAR(50);
					
CREATE TABLE IfcObjective_BenchmarkValues (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcObjective_BenchmarkValues ADD CONSTRAINT
	PK_IfcObjective_BenchmarkValues FOREIGN KEY (pid)
	REFERENCES IfcObjective (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcObjective_ResultValues (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcObjective_ResultValues ADD CONSTRAINT
	PK_IfcObjective_ResultValues FOREIGN KEY (pid)
	REFERENCES IfcObjective (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOccupant'
-- ENTITY Table Definition
CREATE TABLE IfcOccupant (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOccupant ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcOccupant ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcOccupant ADD [Name]  ntext;										
				
ALTER TABLE IfcOccupant ADD [Description]  ntext;										
				
ALTER TABLE IfcOccupant ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcOccupant ADD [TheActor]  VARCHAR(50);
				
ALTER TABLE IfcOccupant ADD [LeeseOrRentalDate] VARCHAR(50);
				
ALTER TABLE IfcOccupant ADD [LeeseOrRentalPeriod]  float;										
				
ALTER TABLE IfcOccupant ADD [OccupationType] VARCHAR(50);
				
ALTER TABLE IfcOccupant ADD [UnlimitedPeriod]  tinyint;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOffsetCurve2D'
-- ENTITY Table Definition
CREATE TABLE IfcOffsetCurve2D (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOffsetCurve2D ADD [BasisCurve] VARCHAR(50);
				
ALTER TABLE IfcOffsetCurve2D ADD [Distance]  float;										
				
ALTER TABLE IfcOffsetCurve2D ADD [SelfIntersect]  tinyint;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOffsetCurve3D'
-- ENTITY Table Definition
CREATE TABLE IfcOffsetCurve3D (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOffsetCurve3D ADD [BasisCurve] VARCHAR(50);
				
ALTER TABLE IfcOffsetCurve3D ADD [Distance]  float;										
				
ALTER TABLE IfcOffsetCurve3D ADD [SelfIntersect]  tinyint;										
				
ALTER TABLE IfcOffsetCurve3D ADD [RefDirection] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOpeningElement'
-- ENTITY Table Definition
CREATE TABLE IfcOpeningElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOpeningElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcOpeningElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcOpeningElement ADD [Name]  ntext;										
				
ALTER TABLE IfcOpeningElement ADD [Description]  ntext;										
				
ALTER TABLE IfcOpeningElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcOpeningElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcOpeningElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcOpeningElement ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOpenShell'
-- ENTITY Table Definition
CREATE TABLE IfcOpenShell (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcOpenShell_CfsFaces (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcOpenShell_CfsFaces ADD CONSTRAINT
	PK_IfcOpenShell_CfsFaces FOREIGN KEY (pid)
	REFERENCES IfcOpenShell (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOpticalMaterialProperties'
-- ENTITY Table Definition
CREATE TABLE IfcOpticalMaterialProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOpticalMaterialProperties ADD [Material] VARCHAR(50);
				
ALTER TABLE IfcOpticalMaterialProperties ADD [VisibleTransmittance]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [SolarTransmittance]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [ThermalIrTransmittance]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [ThermalIrEmissivityBack]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [ThermalIrEmissivityFront]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [VisibleReflectanceBack]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [VisibleReflectanceFront]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [SolarReflectanceFront]  float;										
				
ALTER TABLE IfcOpticalMaterialProperties ADD [SolarReflectanceBack]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOrganization'
-- ENTITY Table Definition
CREATE TABLE IfcOrganization (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOrganization ADD [Id]  ntext;										
				
ALTER TABLE IfcOrganization ADD [Name]  ntext;										
				
ALTER TABLE IfcOrganization ADD [Description]  ntext;										
					
CREATE TABLE IfcOrganization_Roles (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcOrganization_Roles ADD CONSTRAINT
	PK_IfcOrganization_Roles FOREIGN KEY (pid)
	REFERENCES IfcOrganization (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcOrganization_Addresses (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcOrganization_Addresses ADD CONSTRAINT
	PK_IfcOrganization_Addresses FOREIGN KEY (pid)
	REFERENCES IfcOrganization (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOrganizationRelationship'
-- ENTITY Table Definition
CREATE TABLE IfcOrganizationRelationship (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOrganizationRelationship ADD [Name]  ntext;										
				
ALTER TABLE IfcOrganizationRelationship ADD [Description]  ntext;										
				
ALTER TABLE IfcOrganizationRelationship ADD [RelatingOrganization] VARCHAR(50);
					
CREATE TABLE IfcOrganizationRelationship_RelatedOrganizations (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcOrganizationRelationship_RelatedOrganizations ADD CONSTRAINT
	PK_IfcOrganizationRelationship_RelatedOrganizations FOREIGN KEY (pid)
	REFERENCES IfcOrganizationRelationship (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOrientedEdge'
-- ENTITY Table Definition
CREATE TABLE IfcOrientedEdge (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOrientedEdge ADD [EdgeStart] VARCHAR(50);
				
ALTER TABLE IfcOrientedEdge ADD [EdgeEnd] VARCHAR(50);
				
ALTER TABLE IfcOrientedEdge ADD [EdgeElement] VARCHAR(50);
				
ALTER TABLE IfcOrientedEdge ADD [Orientation]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOutlet'
-- ENTITY Table Definition
CREATE TABLE IfcOutlet (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOutlet ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcOutlet ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcOutlet ADD [Name]  ntext;										
				
ALTER TABLE IfcOutlet ADD [Description]  ntext;										
				
ALTER TABLE IfcOutlet ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcOutlet ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcOutlet ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcOutlet ADD [Tag]  ntext;										
				
ALTER TABLE IfcOutlet ADD [OutletType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcOwnerHistory'
-- ENTITY Table Definition
CREATE TABLE IfcOwnerHistory (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcOwnerHistory ADD [OwningUser] VARCHAR(50);
				
ALTER TABLE IfcOwnerHistory ADD [OwningApplication] VARCHAR(50);
				
ALTER TABLE IfcOwnerHistory ADD [State] VARCHAR(50);
				
ALTER TABLE IfcOwnerHistory ADD [ChangeAction] VARCHAR(50);
				
ALTER TABLE IfcOwnerHistory ADD [LastModifiedDate]  int;										
				
ALTER TABLE IfcOwnerHistory ADD [LastModifyingUser] VARCHAR(50);
				
ALTER TABLE IfcOwnerHistory ADD [LastModifyingApplication] VARCHAR(50);
				
ALTER TABLE IfcOwnerHistory ADD [CreationDate]  int;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPath'
-- ENTITY Table Definition
CREATE TABLE IfcPath (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcPath_EdgeList (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPath_EdgeList ADD CONSTRAINT
	PK_IfcPath_EdgeList FOREIGN KEY (pid)
	REFERENCES IfcPath (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPermeableCoveringProperties'
-- ENTITY Table Definition
CREATE TABLE IfcPermeableCoveringProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPermeableCoveringProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcPermeableCoveringProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD [OperationType] VARCHAR(50);
				
ALTER TABLE IfcPermeableCoveringProperties ADD [PanelPosition] VARCHAR(50);
				
ALTER TABLE IfcPermeableCoveringProperties ADD [FrameDepth]  float;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD [FrameThickness]  float;										
				
ALTER TABLE IfcPermeableCoveringProperties ADD [ShapeAspectStyle] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPerson'
-- ENTITY Table Definition
CREATE TABLE IfcPerson (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPerson ADD [Id]  ntext;										
				
ALTER TABLE IfcPerson ADD [FamilyName]  ntext;										
				
ALTER TABLE IfcPerson ADD [GivenName]  ntext;										
				
CREATE TABLE IfcPerson_MiddleNames (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcPerson_MiddleNames ADD CONSTRAINT
	PK_IfcPerson_MiddleNames FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid) ON DELETE CASCADE;

CREATE TABLE IfcPerson_PrefixTitles (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcPerson_PrefixTitles ADD CONSTRAINT
	PK_IfcPerson_PrefixTitles FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid) ON DELETE CASCADE;

CREATE TABLE IfcPerson_SuffixTitles (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcPerson_SuffixTitles ADD CONSTRAINT
	PK_IfcPerson_SuffixTitles FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcPerson_Roles (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPerson_Roles ADD CONSTRAINT
	PK_IfcPerson_Roles FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcPerson_Addresses (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPerson_Addresses ADD CONSTRAINT
	PK_IfcPerson_Addresses FOREIGN KEY (pid)
	REFERENCES IfcPerson (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPersonAndOrganization'
-- ENTITY Table Definition
CREATE TABLE IfcPersonAndOrganization (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPersonAndOrganization ADD [ThePerson] VARCHAR(50);
				
ALTER TABLE IfcPersonAndOrganization ADD [TheOrganization] VARCHAR(50);
					
CREATE TABLE IfcPersonAndOrganization_Roles (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPersonAndOrganization_Roles ADD CONSTRAINT
	PK_IfcPersonAndOrganization_Roles FOREIGN KEY (pid)
	REFERENCES IfcPersonAndOrganization (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPlane'
-- ENTITY Table Definition
CREATE TABLE IfcPlane (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPlane ADD [Position] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPointLightSource'
-- ENTITY Table Definition
CREATE TABLE IfcPointLightSource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
CREATE TABLE IfcPointLightSource_Color (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcPointLightSource_Color ADD CONSTRAINT
	PK_IfcPointLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcPointLightSource (oid) ON DELETE CASCADE;

ALTER TABLE IfcPointLightSource ADD [AmbientIntensity]  float;										
				
ALTER TABLE IfcPointLightSource ADD [Intensity]  float;										
				
ALTER TABLE IfcPointLightSource ADD [InContext] VARCHAR(50);
				
ALTER TABLE IfcPointLightSource ADD [Name]  ntext;										
				
ALTER TABLE IfcPointLightSource ADD [Description]  ntext;										
				
ALTER TABLE IfcPointLightSource ADD [Location] VARCHAR(50);
				
CREATE TABLE IfcPointLightSource_Attenuation (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcPointLightSource_Attenuation ADD CONSTRAINT
	PK_IfcPointLightSource_Attenuation FOREIGN KEY (pid)
	REFERENCES IfcPointLightSource (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPolygonalBoundedHalfSpace'
-- ENTITY Table Definition
CREATE TABLE IfcPolygonalBoundedHalfSpace (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD [BaseSurface] VARCHAR(50);
				
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD [AgreementFlag]  BIT;										
				
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcPolygonalBoundedHalfSpace ADD [PolygonalBoundary] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPolyline'
-- ENTITY Table Definition
CREATE TABLE IfcPolyline (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcPolyline_Points (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPolyline_Points ADD CONSTRAINT
	PK_IfcPolyline_Points FOREIGN KEY (pid)
	REFERENCES IfcPolyline (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPolyLoop'
-- ENTITY Table Definition
CREATE TABLE IfcPolyLoop (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcPolyLoop_Polygon (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPolyLoop_Polygon ADD CONSTRAINT
	PK_IfcPolyLoop_Polygon FOREIGN KEY (pid)
	REFERENCES IfcPolyLoop (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPostalAddress'
-- ENTITY Table Definition
CREATE TABLE IfcPostalAddress (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPostalAddress ADD [Purpose] VARCHAR(50);
				
ALTER TABLE IfcPostalAddress ADD [Description]  ntext;										
				
ALTER TABLE IfcPostalAddress ADD [UserDefinedPurpose]  ntext;										
				
ALTER TABLE IfcPostalAddress ADD [InternalLocation]  ntext;										
				
CREATE TABLE IfcPostalAddress_AddressLines (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcPostalAddress_AddressLines ADD CONSTRAINT
	PK_IfcPostalAddress_AddressLines FOREIGN KEY (pid)
	REFERENCES IfcPostalAddress (oid) ON DELETE CASCADE;

ALTER TABLE IfcPostalAddress ADD [PostalBox]  ntext;										
				
ALTER TABLE IfcPostalAddress ADD [Town]  ntext;										
				
ALTER TABLE IfcPostalAddress ADD [Region]  ntext;										
				
ALTER TABLE IfcPostalAddress ADD [PostalCode]  ntext;										
				
ALTER TABLE IfcPostalAddress ADD [Country]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPresentationLightSource'
-- ENTITY Table Definition
CREATE TABLE IfcPresentationLightSource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
CREATE TABLE IfcPresentationLightSource_Color (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcPresentationLightSource_Color ADD CONSTRAINT
	PK_IfcPresentationLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcPresentationLightSource (oid) ON DELETE CASCADE;

ALTER TABLE IfcPresentationLightSource ADD [AmbientIntensity]  float;										
				
ALTER TABLE IfcPresentationLightSource ADD [Intensity]  float;										
				
ALTER TABLE IfcPresentationLightSource ADD [InContext] VARCHAR(50);
				
ALTER TABLE IfcPresentationLightSource ADD [Name]  ntext;										
				
ALTER TABLE IfcPresentationLightSource ADD [Description]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcProductDefinitionShape'
-- ENTITY Table Definition
CREATE TABLE IfcProductDefinitionShape (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcProductDefinitionShape ADD [Name]  ntext;										
				
ALTER TABLE IfcProductDefinitionShape ADD [Description]  ntext;										
					
CREATE TABLE IfcProductDefinitionShape_Representations (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcProductDefinitionShape_Representations ADD CONSTRAINT
	PK_IfcProductDefinitionShape_Representations FOREIGN KEY (pid)
	REFERENCES IfcProductDefinitionShape (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcProductRepresentation'
-- ENTITY Table Definition
CREATE TABLE IfcProductRepresentation (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcProductRepresentation ADD [Name]  ntext;										
				
ALTER TABLE IfcProductRepresentation ADD [Description]  ntext;										
					
CREATE TABLE IfcProductRepresentation_Representations (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcProductRepresentation_Representations ADD CONSTRAINT
	PK_IfcProductRepresentation_Representations FOREIGN KEY (pid)
	REFERENCES IfcProductRepresentation (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcProject'
-- ENTITY Table Definition
CREATE TABLE IfcProject (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcProject ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcProject ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcProject ADD [Name]  ntext;										
				
ALTER TABLE IfcProject ADD [Description]  ntext;										
				
ALTER TABLE IfcProject ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcProject ADD [LongName]  ntext;										
				
ALTER TABLE IfcProject ADD [Phase]  ntext;										
					
CREATE TABLE IfcProject_RepresentationContexts (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcProject_RepresentationContexts ADD CONSTRAINT
	PK_IfcProject_RepresentationContexts FOREIGN KEY (pid)
	REFERENCES IfcProject (oid) ON DELETE CASCADE;

ALTER TABLE IfcProject ADD [UnitsInContext] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPropertyBoundedValue'
-- ENTITY Table Definition
CREATE TABLE IfcPropertyBoundedValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPropertyBoundedValue ADD [Name]  ntext;										
				
ALTER TABLE IfcPropertyBoundedValue ADD [Description]  ntext;										
					
CREATE TABLE IfcPropertyBoundedValue_UpperBoundValue (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcPropertyBoundedValue_UpperBoundValue ADD CONSTRAINT
	PK_IfcPropertyBoundedValue_UpperBoundValue FOREIGN KEY (pid)
	REFERENCES IfcPropertyBoundedValue (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcPropertyBoundedValue_LowerBoundValue (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcPropertyBoundedValue_LowerBoundValue ADD CONSTRAINT
	PK_IfcPropertyBoundedValue_LowerBoundValue FOREIGN KEY (pid)
	REFERENCES IfcPropertyBoundedValue (oid) ON DELETE CASCADE;

ALTER TABLE IfcPropertyBoundedValue ADD [Unit]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPropertyEnumeratedValue'
-- ENTITY Table Definition
CREATE TABLE IfcPropertyEnumeratedValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPropertyEnumeratedValue ADD [Name]  ntext;										
				
ALTER TABLE IfcPropertyEnumeratedValue ADD [Description]  ntext;										
					
CREATE TABLE IfcPropertyEnumeratedValue_EnumerationValues (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcPropertyEnumeratedValue_EnumerationValues ADD CONSTRAINT
	PK_IfcPropertyEnumeratedValue_EnumerationValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyEnumeratedValue (oid) ON DELETE CASCADE;

ALTER TABLE IfcPropertyEnumeratedValue ADD [EnumerationReference] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPropertyEnumeration'
-- ENTITY Table Definition
CREATE TABLE IfcPropertyEnumeration (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPropertyEnumeration ADD [Name]  ntext;										
					
CREATE TABLE IfcPropertyEnumeration_EnumerationValues (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcPropertyEnumeration_EnumerationValues ADD CONSTRAINT
	PK_IfcPropertyEnumeration_EnumerationValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyEnumeration (oid) ON DELETE CASCADE;

ALTER TABLE IfcPropertyEnumeration ADD [Unit]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPropertyReferenceValue'
-- ENTITY Table Definition
CREATE TABLE IfcPropertyReferenceValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPropertyReferenceValue ADD [Name]  ntext;										
				
ALTER TABLE IfcPropertyReferenceValue ADD [Description]  ntext;										
				
ALTER TABLE IfcPropertyReferenceValue ADD [UsageName]  ntext;										
				
ALTER TABLE IfcPropertyReferenceValue ADD [PropertyReference]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPropertySet'
-- ENTITY Table Definition
CREATE TABLE IfcPropertySet (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPropertySet ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcPropertySet ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcPropertySet ADD [Name]  ntext;										
				
ALTER TABLE IfcPropertySet ADD [Description]  ntext;										
					
CREATE TABLE IfcPropertySet_HasProperties (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPropertySet_HasProperties ADD CONSTRAINT
	PK_IfcPropertySet_HasProperties FOREIGN KEY (pid)
	REFERENCES IfcPropertySet (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPropertySingleValue'
-- ENTITY Table Definition
CREATE TABLE IfcPropertySingleValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPropertySingleValue ADD [Name]  ntext;										
				
ALTER TABLE IfcPropertySingleValue ADD [Description]  ntext;										
					
CREATE TABLE IfcPropertySingleValue_NominalValue (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcPropertySingleValue_NominalValue ADD CONSTRAINT
	PK_IfcPropertySingleValue_NominalValue FOREIGN KEY (pid)
	REFERENCES IfcPropertySingleValue (oid) ON DELETE CASCADE;

ALTER TABLE IfcPropertySingleValue ADD [Unit]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPropertyTableValue'
-- ENTITY Table Definition
CREATE TABLE IfcPropertyTableValue (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPropertyTableValue ADD [Name]  ntext;										
				
ALTER TABLE IfcPropertyTableValue ADD [Description]  ntext;										
					
CREATE TABLE IfcPropertyTableValue_DefiningValues (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcPropertyTableValue_DefiningValues ADD CONSTRAINT
	PK_IfcPropertyTableValue_DefiningValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyTableValue (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcPropertyTableValue_DefinedValues (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcPropertyTableValue_DefinedValues ADD CONSTRAINT
	PK_IfcPropertyTableValue_DefinedValues FOREIGN KEY (pid)
	REFERENCES IfcPropertyTableValue (oid) ON DELETE CASCADE;

ALTER TABLE IfcPropertyTableValue ADD [Expression]  ntext;										
				
ALTER TABLE IfcPropertyTableValue ADD [DefiningUnit]  VARCHAR(50);
				
ALTER TABLE IfcPropertyTableValue ADD [DefinedUnit]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcProxy'
-- ENTITY Table Definition
CREATE TABLE IfcProxy (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcProxy ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcProxy ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcProxy ADD [Name]  ntext;										
				
ALTER TABLE IfcProxy ADD [Description]  ntext;										
				
ALTER TABLE IfcProxy ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcProxy ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcProxy ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcProxy ADD [ProxyType] VARCHAR(50);
				
ALTER TABLE IfcProxy ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPump'
-- ENTITY Table Definition
CREATE TABLE IfcPump (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPump ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcPump ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcPump ADD [Name]  ntext;										
				
ALTER TABLE IfcPump ADD [Description]  ntext;										
				
ALTER TABLE IfcPump ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcPump ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcPump ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcPump ADD [Tag]  ntext;										
				
ALTER TABLE IfcPump ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcPump ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcPump ADD [ImpellerDiameter]  float;										
				
ALTER TABLE IfcPump ADD [PumpType] VARCHAR(50);
				
ALTER TABLE IfcPump ADD [NetPositiveSuctionHead]  float;										
				
ALTER TABLE IfcPump ADD [ImpellerSealMaterial]  VARCHAR(50);
				
ALTER TABLE IfcPump ADD [PumpBaseType] VARCHAR(50);
				
ALTER TABLE IfcPump ADD [MotorDriveType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcPurchaseOrder'
-- ENTITY Table Definition
CREATE TABLE IfcPurchaseOrder (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcPurchaseOrder ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcPurchaseOrder ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [Name]  ntext;										
				
ALTER TABLE IfcPurchaseOrder ADD [Description]  ntext;										
				
ALTER TABLE IfcPurchaseOrder ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcPurchaseOrder ADD [OrderNumber]  ntext;										
				
ALTER TABLE IfcPurchaseOrder ADD [TransactionCode]  ntext;										
				
ALTER TABLE IfcPurchaseOrder ADD [IssuingDate] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [IssuedBy]  VARCHAR(50);
					
CREATE TABLE IfcPurchaseOrder_IssuedTo (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPurchaseOrder_IssuedTo ADD CONSTRAINT
	PK_IfcPurchaseOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcPurchaseOrder (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcPurchaseOrder_AdditionalContacts (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcPurchaseOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcPurchaseOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcPurchaseOrder (oid) ON DELETE CASCADE;

CREATE TABLE IfcPurchaseOrder_Remarks (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcPurchaseOrder_Remarks ADD CONSTRAINT
	PK_IfcPurchaseOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcPurchaseOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcPurchaseOrder ADD [Signoff] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [BudgetSource] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [RequiredDate] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [ScheduledDate] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [ActualDate] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [IsFOB]  BIT;										
				
ALTER TABLE IfcPurchaseOrder ADD [ShipMethod]  ntext;										
				
ALTER TABLE IfcPurchaseOrder ADD [PurchaseItems] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [TotalCost] VARCHAR(50);
				
ALTER TABLE IfcPurchaseOrder ADD [Status] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcQuantityArea'
-- ENTITY Table Definition
CREATE TABLE IfcQuantityArea (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcQuantityArea ADD [Name]  ntext;										
				
ALTER TABLE IfcQuantityArea ADD [Description]  ntext;										
				
ALTER TABLE IfcQuantityArea ADD [Unit] VARCHAR(50);
				
ALTER TABLE IfcQuantityArea ADD [AreaValue]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcQuantityCount'
-- ENTITY Table Definition
CREATE TABLE IfcQuantityCount (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcQuantityCount ADD [Name]  ntext;										
				
ALTER TABLE IfcQuantityCount ADD [Description]  ntext;										
				
ALTER TABLE IfcQuantityCount ADD [Unit] VARCHAR(50);
				
ALTER TABLE IfcQuantityCount ADD [CountValue]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcQuantityLength'
-- ENTITY Table Definition
CREATE TABLE IfcQuantityLength (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcQuantityLength ADD [Name]  ntext;										
				
ALTER TABLE IfcQuantityLength ADD [Description]  ntext;										
				
ALTER TABLE IfcQuantityLength ADD [Unit] VARCHAR(50);
				
ALTER TABLE IfcQuantityLength ADD [LengthValue]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcQuantityVolume'
-- ENTITY Table Definition
CREATE TABLE IfcQuantityVolume (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcQuantityVolume ADD [Name]  ntext;										
				
ALTER TABLE IfcQuantityVolume ADD [Description]  ntext;										
				
ALTER TABLE IfcQuantityVolume ADD [Unit] VARCHAR(50);
				
ALTER TABLE IfcQuantityVolume ADD [VolumeValue]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcQuantityWeight'
-- ENTITY Table Definition
CREATE TABLE IfcQuantityWeight (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcQuantityWeight ADD [Name]  ntext;										
				
ALTER TABLE IfcQuantityWeight ADD [Description]  ntext;										
				
ALTER TABLE IfcQuantityWeight ADD [Unit] VARCHAR(50);
				
ALTER TABLE IfcQuantityWeight ADD [WeightValue]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRailing'
-- ENTITY Table Definition
CREATE TABLE IfcRailing (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRailing ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRailing ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRailing ADD [Name]  ntext;										
				
ALTER TABLE IfcRailing ADD [Description]  ntext;										
				
ALTER TABLE IfcRailing ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcRailing ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcRailing ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcRailing ADD [Tag]  ntext;										
				
ALTER TABLE IfcRailing ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRamp'
-- ENTITY Table Definition
CREATE TABLE IfcRamp (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRamp ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRamp ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRamp ADD [Name]  ntext;										
				
ALTER TABLE IfcRamp ADD [Description]  ntext;										
				
ALTER TABLE IfcRamp ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcRamp ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcRamp ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcRamp ADD [Tag]  ntext;										
				
ALTER TABLE IfcRamp ADD [ShapeType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRampFlight'
-- ENTITY Table Definition
CREATE TABLE IfcRampFlight (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRampFlight ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRampFlight ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRampFlight ADD [Name]  ntext;										
				
ALTER TABLE IfcRampFlight ADD [Description]  ntext;										
				
ALTER TABLE IfcRampFlight ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcRampFlight ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcRampFlight ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcRampFlight ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRectangleProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcRectangleProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRectangleProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcRectangleProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcRectangleProfileDef ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcRectangleProfileDef ADD [XDim]  float;										
				
ALTER TABLE IfcRectangleProfileDef ADD [YDim]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRectangularTrimmedSurface'
-- ENTITY Table Definition
CREATE TABLE IfcRectangularTrimmedSurface (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRectangularTrimmedSurface ADD [BasisSurface] VARCHAR(50);
				
ALTER TABLE IfcRectangularTrimmedSurface ADD [U1]  float;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD [V1]  float;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD [U2]  float;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD [V2]  float;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD [Usense]  BIT;										
				
ALTER TABLE IfcRectangularTrimmedSurface ADD [Vsense]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcReferenceEdge'
-- ENTITY Table Definition
CREATE TABLE IfcReferenceEdge (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcReferenceEdge ADD [Placement]  VARCHAR(50);
				
ALTER TABLE IfcReferenceEdge ADD [Edge] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcReferenceFace'
-- ENTITY Table Definition
CREATE TABLE IfcReferenceFace (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcReferenceFace ADD [Placement]  VARCHAR(50);
				
ALTER TABLE IfcReferenceFace ADD [Face] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcReferencesCostDocument'
-- ENTITY Table Definition
CREATE TABLE IfcReferencesCostDocument (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcReferencesCostDocument ADD [ReferencedDocument]  VARCHAR(50);
					
CREATE TABLE IfcReferencesCostDocument_ReferencingCosts (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcReferencesCostDocument_ReferencingCosts ADD CONSTRAINT
	PK_IfcReferencesCostDocument_ReferencingCosts FOREIGN KEY (pid)
	REFERENCES IfcReferencesCostDocument (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcReferencesCostDocument_ReferencingModifiers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcReferencesCostDocument_ReferencingModifiers ADD CONSTRAINT
	PK_IfcReferencesCostDocument_ReferencingModifiers FOREIGN KEY (pid)
	REFERENCES IfcReferencesCostDocument (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcReferenceVertex'
-- ENTITY Table Definition
CREATE TABLE IfcReferenceVertex (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcReferenceVertex ADD [Placement]  VARCHAR(50);
				
ALTER TABLE IfcReferenceVertex ADD [Vertex] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAggregates'
-- ENTITY Table Definition
CREATE TABLE IfcRelAggregates (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAggregates ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAggregates ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAggregates ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAggregates ADD [Description]  ntext;										
				
ALTER TABLE IfcRelAggregates ADD [RelatingObject] VARCHAR(50);
					
CREATE TABLE IfcRelAggregates_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAggregates_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAggregates_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAggregates (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAggregatesResources'
-- ENTITY Table Definition
CREATE TABLE IfcRelAggregatesResources (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAggregatesResources ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAggregatesResources ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAggregatesResources ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAggregatesResources ADD [Description]  ntext;										
				
ALTER TABLE IfcRelAggregatesResources ADD [RelatingObject] VARCHAR(50);
					
CREATE TABLE IfcRelAggregatesResources_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAggregatesResources_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAggregatesResources_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAggregatesResources (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAggregatesResources ADD [RequiredQuantity] VARCHAR(50);
				
ALTER TABLE IfcRelAggregatesResources ADD [ConversionRate] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsFMStandard'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsFMStandard (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsFMStandard ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsFMStandard ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD [Description]  ntext;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD [JobFunction]  ntext;										
				
ALTER TABLE IfcRelAssignsFMStandard ADD [RelatingStandard]  VARCHAR(50);
					
CREATE TABLE IfcRelAssignsFMStandard_RelatedPersons (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsFMStandard_RelatedPersons ADD CONSTRAINT
	PK_IfcRelAssignsFMStandard_RelatedPersons FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsFMStandard (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsTasks'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsTasks (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsTasks ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsTasks ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsTasks ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsTasks ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssignsTasks_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsTasks_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsTasks_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsTasks (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssignsTasks ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsTasks ADD [RelatingControl] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsTasks ADD [TimeForTask] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsTasks ADD [Milestone] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsToActor'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsToActor (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsToActor ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsToActor ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToActor ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsToActor ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssignsToActor_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsToActor_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToActor_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToActor (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssignsToActor ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToActor ADD [RelatingActor] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToActor ADD [ActingRole] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsToControl'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsToControl (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsToControl ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsToControl ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToControl ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsToControl ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssignsToControl_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsToControl_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToControl_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToControl (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssignsToControl ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToControl ADD [RelatingControl] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsToGroup'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsToGroup (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsToGroup ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsToGroup ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToGroup ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsToGroup ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssignsToGroup_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsToGroup_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToGroup_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToGroup (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssignsToGroup ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToGroup ADD [RelatingGroup] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsToProcess'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsToProcess (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsToProcess ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsToProcess ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToProcess ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsToProcess ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssignsToProcess_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsToProcess_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToProcess_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToProcess (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssignsToProcess ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToProcess ADD [RelatingProcess] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToProcess ADD [QuantityInProcess] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsToProduct'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsToProduct (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsToProduct ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsToProduct ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToProduct ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsToProduct ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssignsToProduct_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsToProduct_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToProduct_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToProduct (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssignsToProduct ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToProduct ADD [RelatingProduct] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssignsToResource'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssignsToResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssignsToResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssignsToResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToResource ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssignsToResource ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssignsToResource_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssignsToResource_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssignsToResource_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssignsToResource (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssignsToResource ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelAssignsToResource ADD [RelatingResource] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssociates'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssociates (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssociates ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssociates ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssociates ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssociates ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssociates_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssociates_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociates_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociates (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssociatesClassification'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssociatesClassification (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssociatesClassification ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssociatesClassification ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssociatesClassification ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssociatesClassification ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssociatesClassification_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssociatesClassification_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesClassification_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesClassification (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssociatesClassification ADD [RelatingClassification]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssociatesDocument'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssociatesDocument (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssociatesDocument ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssociatesDocument ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssociatesDocument ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssociatesDocument ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssociatesDocument_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssociatesDocument_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesDocument_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesDocument (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssociatesDocument ADD [RelatingDocument]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssociatesLibrary'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssociatesLibrary (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssociatesLibrary ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssociatesLibrary ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssociatesLibrary ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssociatesLibrary ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssociatesLibrary_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssociatesLibrary_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesLibrary_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesLibrary (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssociatesLibrary ADD [RelatingLibrary]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelAssociatesMaterial'
-- ENTITY Table Definition
CREATE TABLE IfcRelAssociatesMaterial (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelAssociatesMaterial ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelAssociatesMaterial ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelAssociatesMaterial ADD [Name]  ntext;										
				
ALTER TABLE IfcRelAssociatesMaterial ADD [Description]  ntext;										
					
CREATE TABLE IfcRelAssociatesMaterial_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelAssociatesMaterial_RelatedObjects ADD CONSTRAINT
	PK_IfcRelAssociatesMaterial_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelAssociatesMaterial (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelAssociatesMaterial ADD [RelatingMaterial]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelConnectsElements'
-- ENTITY Table Definition
CREATE TABLE IfcRelConnectsElements (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelConnectsElements ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelConnectsElements ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsElements ADD [Name]  ntext;										
				
ALTER TABLE IfcRelConnectsElements ADD [Description]  ntext;										
				
ALTER TABLE IfcRelConnectsElements ADD [ConnectionGeometry] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsElements ADD [RelatingElement] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsElements ADD [RelatedElement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelConnectsPathElements'
-- ENTITY Table Definition
CREATE TABLE IfcRelConnectsPathElements (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelConnectsPathElements ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelConnectsPathElements ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD [Name]  ntext;										
				
ALTER TABLE IfcRelConnectsPathElements ADD [Description]  ntext;										
				
ALTER TABLE IfcRelConnectsPathElements ADD [ConnectionGeometry] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD [RelatingElement] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD [RelatedElement] VARCHAR(50);
				
CREATE TABLE IfcRelConnectsPathElements_RelatingPriorities (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	IntegerValue int
);
ALTER TABLE IfcRelConnectsPathElements_RelatingPriorities ADD CONSTRAINT
	PK_IfcRelConnectsPathElements_RelatingPriorities FOREIGN KEY (pid)
	REFERENCES IfcRelConnectsPathElements (oid) ON DELETE CASCADE;

CREATE TABLE IfcRelConnectsPathElements_RelatedPriorities (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	IntegerValue int
);
ALTER TABLE IfcRelConnectsPathElements_RelatedPriorities ADD CONSTRAINT
	PK_IfcRelConnectsPathElements_RelatedPriorities FOREIGN KEY (pid)
	REFERENCES IfcRelConnectsPathElements (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelConnectsPathElements ADD [RelatedConnectionType] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPathElements ADD [RelatingConnectionType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelConnectsPorts'
-- ENTITY Table Definition
CREATE TABLE IfcRelConnectsPorts (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelConnectsPorts ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelConnectsPorts ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPorts ADD [Name]  ntext;										
				
ALTER TABLE IfcRelConnectsPorts ADD [Description]  ntext;										
				
ALTER TABLE IfcRelConnectsPorts ADD [ConnectionGeometry] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPorts ADD [RelatingElement] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPorts ADD [RelatedElement] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPorts ADD [FlowDirection] VARCHAR(50);
				
ALTER TABLE IfcRelConnectsPorts ADD [PortConnectionType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelContainedInSpatialStructure'
-- ENTITY Table Definition
CREATE TABLE IfcRelContainedInSpatialStructure (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelContainedInSpatialStructure ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelContainedInSpatialStructure ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelContainedInSpatialStructure ADD [Name]  ntext;										
				
ALTER TABLE IfcRelContainedInSpatialStructure ADD [Description]  ntext;										
					
CREATE TABLE IfcRelContainedInSpatialStructure_RelatedElements (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelContainedInSpatialStructure_RelatedElements ADD CONSTRAINT
	PK_IfcRelContainedInSpatialStructure_RelatedElements FOREIGN KEY (pid)
	REFERENCES IfcRelContainedInSpatialStructure (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelContainedInSpatialStructure ADD [RelatingStructure] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelCostsObjects'
-- ENTITY Table Definition
CREATE TABLE IfcRelCostsObjects (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelCostsObjects ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelCostsObjects ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelCostsObjects ADD [Name]  ntext;										
				
ALTER TABLE IfcRelCostsObjects ADD [Description]  ntext;										
					
CREATE TABLE IfcRelCostsObjects_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelCostsObjects_RelatedObjects ADD CONSTRAINT
	PK_IfcRelCostsObjects_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelCostsObjects (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelCostsObjects ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelCostsObjects ADD [RelatingControl] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelCoversBldgElements'
-- ENTITY Table Definition
CREATE TABLE IfcRelCoversBldgElements (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelCoversBldgElements ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelCoversBldgElements ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelCoversBldgElements ADD [Name]  ntext;										
				
ALTER TABLE IfcRelCoversBldgElements ADD [Description]  ntext;										
				
ALTER TABLE IfcRelCoversBldgElements ADD [RelatingBuildingElement] VARCHAR(50);
					
CREATE TABLE IfcRelCoversBldgElements_RelatedCoverings (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelCoversBldgElements_RelatedCoverings ADD CONSTRAINT
	PK_IfcRelCoversBldgElements_RelatedCoverings FOREIGN KEY (pid)
	REFERENCES IfcRelCoversBldgElements (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelDefinesByProperties'
-- ENTITY Table Definition
CREATE TABLE IfcRelDefinesByProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelDefinesByProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelDefinesByProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelDefinesByProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcRelDefinesByProperties ADD [Description]  ntext;										
					
CREATE TABLE IfcRelDefinesByProperties_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelDefinesByProperties_RelatedObjects ADD CONSTRAINT
	PK_IfcRelDefinesByProperties_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelDefinesByProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelDefinesByProperties ADD [RelatingPropertyDefinition] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelDefinesByType'
-- ENTITY Table Definition
CREATE TABLE IfcRelDefinesByType (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelDefinesByType ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelDefinesByType ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelDefinesByType ADD [Name]  ntext;										
				
ALTER TABLE IfcRelDefinesByType ADD [Description]  ntext;										
					
CREATE TABLE IfcRelDefinesByType_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelDefinesByType_RelatedObjects ADD CONSTRAINT
	PK_IfcRelDefinesByType_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelDefinesByType (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelDefinesByType ADD [RelatingType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelFillsElement'
-- ENTITY Table Definition
CREATE TABLE IfcRelFillsElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelFillsElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelFillsElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelFillsElement ADD [Name]  ntext;										
				
ALTER TABLE IfcRelFillsElement ADD [Description]  ntext;										
				
ALTER TABLE IfcRelFillsElement ADD [RelatingOpeningElement] VARCHAR(50);
				
ALTER TABLE IfcRelFillsElement ADD [RelatedBuildingElement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelFlowControlElements'
-- ENTITY Table Definition
CREATE TABLE IfcRelFlowControlElements (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelFlowControlElements ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelFlowControlElements ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelFlowControlElements ADD [Name]  ntext;										
				
ALTER TABLE IfcRelFlowControlElements ADD [Description]  ntext;										
					
CREATE TABLE IfcRelFlowControlElements_RelatedControlElements (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelFlowControlElements_RelatedControlElements ADD CONSTRAINT
	PK_IfcRelFlowControlElements_RelatedControlElements FOREIGN KEY (pid)
	REFERENCES IfcRelFlowControlElements (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelFlowControlElements ADD [RelatingFlowElement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelInteractionRequirements'
-- ENTITY Table Definition
CREATE TABLE IfcRelInteractionRequirements (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelInteractionRequirements ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelInteractionRequirements ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD [Name]  ntext;										
				
ALTER TABLE IfcRelInteractionRequirements ADD [Description]  ntext;										
				
ALTER TABLE IfcRelInteractionRequirements ADD [DailyInteraction]  float;										
				
ALTER TABLE IfcRelInteractionRequirements ADD [ImportanceRating]  float;										
				
ALTER TABLE IfcRelInteractionRequirements ADD [LocationOfInteraction] VARCHAR(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD [RelatingActor] VARCHAR(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD [RelatedActor] VARCHAR(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD [RelatedSpaceProgram] VARCHAR(50);
				
ALTER TABLE IfcRelInteractionRequirements ADD [RelatingSpaceProgram] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelMaintenanceEvent'
-- ENTITY Table Definition
CREATE TABLE IfcRelMaintenanceEvent (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelMaintenanceEvent ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelMaintenanceEvent ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelMaintenanceEvent ADD [Name]  ntext;										
				
ALTER TABLE IfcRelMaintenanceEvent ADD [Description]  ntext;										
					
CREATE TABLE IfcRelMaintenanceEvent_RelatedAssets (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelMaintenanceEvent_RelatedAssets ADD CONSTRAINT
	PK_IfcRelMaintenanceEvent_RelatedAssets FOREIGN KEY (pid)
	REFERENCES IfcRelMaintenanceEvent (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelMaintenanceEvent ADD [RelatingWorkOrder] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelNests'
-- ENTITY Table Definition
CREATE TABLE IfcRelNests (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelNests ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelNests ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelNests ADD [Name]  ntext;										
				
ALTER TABLE IfcRelNests ADD [Description]  ntext;										
				
ALTER TABLE IfcRelNests ADD [RelatingObject] VARCHAR(50);
					
CREATE TABLE IfcRelNests_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelNests_RelatedObjects ADD CONSTRAINT
	PK_IfcRelNests_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelNests (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelOccupiesSpaces'
-- ENTITY Table Definition
CREATE TABLE IfcRelOccupiesSpaces (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelOccupiesSpaces ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelOccupiesSpaces ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelOccupiesSpaces ADD [Name]  ntext;										
				
ALTER TABLE IfcRelOccupiesSpaces ADD [Description]  ntext;										
					
CREATE TABLE IfcRelOccupiesSpaces_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelOccupiesSpaces_RelatedObjects ADD CONSTRAINT
	PK_IfcRelOccupiesSpaces_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelOccupiesSpaces (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelOccupiesSpaces ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelOccupiesSpaces ADD [RelatingActor] VARCHAR(50);
				
ALTER TABLE IfcRelOccupiesSpaces ADD [ActingRole] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelOverridesProperties'
-- ENTITY Table Definition
CREATE TABLE IfcRelOverridesProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelOverridesProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelOverridesProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelOverridesProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcRelOverridesProperties ADD [Description]  ntext;										
					
CREATE TABLE IfcRelOverridesProperties_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelOverridesProperties_RelatedObjects ADD CONSTRAINT
	PK_IfcRelOverridesProperties_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelOverridesProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelOverridesProperties ADD [RelatingPropertyDefinition] VARCHAR(50);
					
CREATE TABLE IfcRelOverridesProperties_OverridingProperties (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelOverridesProperties_OverridingProperties ADD CONSTRAINT
	PK_IfcRelOverridesProperties_OverridingProperties FOREIGN KEY (pid)
	REFERENCES IfcRelOverridesProperties (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelSequence'
-- ENTITY Table Definition
CREATE TABLE IfcRelSequence (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelSequence ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelSequence ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelSequence ADD [Name]  ntext;										
				
ALTER TABLE IfcRelSequence ADD [Description]  ntext;										
				
ALTER TABLE IfcRelSequence ADD [RelatingProcess] VARCHAR(50);
				
ALTER TABLE IfcRelSequence ADD [RelatedProcess] VARCHAR(50);
				
ALTER TABLE IfcRelSequence ADD [TimeLag]  float;										
				
ALTER TABLE IfcRelSequence ADD [SequenceType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelServicesBuildings'
-- ENTITY Table Definition
CREATE TABLE IfcRelServicesBuildings (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelServicesBuildings ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelServicesBuildings ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelServicesBuildings ADD [Name]  ntext;										
				
ALTER TABLE IfcRelServicesBuildings ADD [Description]  ntext;										
				
ALTER TABLE IfcRelServicesBuildings ADD [RelatingSystem] VARCHAR(50);
					
CREATE TABLE IfcRelServicesBuildings_RelatedBuildings (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelServicesBuildings_RelatedBuildings ADD CONSTRAINT
	PK_IfcRelServicesBuildings_RelatedBuildings FOREIGN KEY (pid)
	REFERENCES IfcRelServicesBuildings (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelSpaceBoundary'
-- ENTITY Table Definition
CREATE TABLE IfcRelSpaceBoundary (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelSpaceBoundary ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelSpaceBoundary ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD [Name]  ntext;										
				
ALTER TABLE IfcRelSpaceBoundary ADD [Description]  ntext;										
				
ALTER TABLE IfcRelSpaceBoundary ADD [RelatingSpace] VARCHAR(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD [RelatedBuildingElement] VARCHAR(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD [ConnectionGeometry] VARCHAR(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD [PhysicalOrVirtualBoundary] VARCHAR(50);
				
ALTER TABLE IfcRelSpaceBoundary ADD [InternalOrExternalBoundary] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelUsesResource'
-- ENTITY Table Definition
CREATE TABLE IfcRelUsesResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelUsesResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelUsesResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelUsesResource ADD [Name]  ntext;										
				
ALTER TABLE IfcRelUsesResource ADD [Description]  ntext;										
					
CREATE TABLE IfcRelUsesResource_RelatedObjects (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelUsesResource_RelatedObjects ADD CONSTRAINT
	PK_IfcRelUsesResource_RelatedObjects FOREIGN KEY (pid)
	REFERENCES IfcRelUsesResource (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelUsesResource ADD [RelatedObjectsType] VARCHAR(50);
				
ALTER TABLE IfcRelUsesResource ADD [RelatingResource] VARCHAR(50);
				
ALTER TABLE IfcRelUsesResource ADD [Duration]  float;										
				
ALTER TABLE IfcRelUsesResource ADD [Quantity] VARCHAR(50);
				
ALTER TABLE IfcRelUsesResource ADD [ProductivityConversionRate] VARCHAR(50);
				
ALTER TABLE IfcRelUsesResource ADD [ConverterMultiplierOrDivider] VARCHAR(50);
					
CREATE TABLE IfcRelUsesResource_ResourceUseCosts (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRelUsesResource_ResourceUseCosts ADD CONSTRAINT
	PK_IfcRelUsesResource_ResourceUseCosts FOREIGN KEY (pid)
	REFERENCES IfcRelUsesResource (oid) ON DELETE CASCADE;

ALTER TABLE IfcRelUsesResource ADD [WasteFactor]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRelVoidsElement'
-- ENTITY Table Definition
CREATE TABLE IfcRelVoidsElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRelVoidsElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRelVoidsElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRelVoidsElement ADD [Name]  ntext;										
				
ALTER TABLE IfcRelVoidsElement ADD [Description]  ntext;										
				
ALTER TABLE IfcRelVoidsElement ADD [RelatingBuildingElement] VARCHAR(50);
				
ALTER TABLE IfcRelVoidsElement ADD [RelatedOpeningElement] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRepresentation'
-- ENTITY Table Definition
CREATE TABLE IfcRepresentation (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRepresentation ADD [ContextOfItems] VARCHAR(50);
				
ALTER TABLE IfcRepresentation ADD [RepresentationIdentifier]  ntext;										
				
ALTER TABLE IfcRepresentation ADD [RepresentationType]  ntext;										
					
CREATE TABLE IfcRepresentation_Items (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcRepresentation_Items ADD CONSTRAINT
	PK_IfcRepresentation_Items FOREIGN KEY (pid)
	REFERENCES IfcRepresentation (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRepresentationContext'
-- ENTITY Table Definition
CREATE TABLE IfcRepresentationContext (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRepresentationContext ADD [ContextIdentifier]  ntext;										
				
ALTER TABLE IfcRepresentationContext ADD [ContextType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRepresentationMap'
-- ENTITY Table Definition
CREATE TABLE IfcRepresentationMap (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRepresentationMap ADD [MappingOrigin]  VARCHAR(50);
				
ALTER TABLE IfcRepresentationMap ADD [MappedRepresentation] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRevolvedAreaSolid'
-- ENTITY Table Definition
CREATE TABLE IfcRevolvedAreaSolid (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRevolvedAreaSolid ADD [SweptArea] VARCHAR(50);
				
ALTER TABLE IfcRevolvedAreaSolid ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcRevolvedAreaSolid ADD [Axis] VARCHAR(50);
				
ALTER TABLE IfcRevolvedAreaSolid ADD [Angle]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRoof'
-- ENTITY Table Definition
CREATE TABLE IfcRoof (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRoof ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcRoof ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcRoof ADD [Name]  ntext;										
				
ALTER TABLE IfcRoof ADD [Description]  ntext;										
				
ALTER TABLE IfcRoof ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcRoof ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcRoof ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcRoof ADD [Tag]  ntext;										
				
ALTER TABLE IfcRoof ADD [ShapeType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcRoundedRectangleProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcRoundedRectangleProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcRoundedRectangleProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD [XDim]  float;										
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD [YDim]  float;										
				
ALTER TABLE IfcRoundedRectangleProfileDef ADD [RoundingRadius]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSanitaryTerminal'
-- ENTITY Table Definition
CREATE TABLE IfcSanitaryTerminal (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSanitaryTerminal ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSanitaryTerminal ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSanitaryTerminal ADD [Name]  ntext;										
				
ALTER TABLE IfcSanitaryTerminal ADD [Description]  ntext;										
				
ALTER TABLE IfcSanitaryTerminal ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSanitaryTerminal ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcSanitaryTerminal ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcSanitaryTerminal ADD [Tag]  ntext;										
				
ALTER TABLE IfcSanitaryTerminal ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcSanitaryTerminal ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcScheduleTimeControl'
-- ENTITY Table Definition
CREATE TABLE IfcScheduleTimeControl (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcScheduleTimeControl ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcScheduleTimeControl ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [Name]  ntext;										
				
ALTER TABLE IfcScheduleTimeControl ADD [Description]  ntext;										
				
ALTER TABLE IfcScheduleTimeControl ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcScheduleTimeControl ADD [ActualStart] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [EarlyStart] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [LateStart] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [ScheduleStart] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [ActualFinish] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [EarlyFinish] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [LateFinish] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [ScheduleFinish] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [ScheduleDuration]  float;										
				
ALTER TABLE IfcScheduleTimeControl ADD [ActualDuration]  float;										
				
ALTER TABLE IfcScheduleTimeControl ADD [RemainingTime]  float;										
				
ALTER TABLE IfcScheduleTimeControl ADD [FreeFloat]  float;										
				
ALTER TABLE IfcScheduleTimeControl ADD [TotalFloat]  float;										
				
ALTER TABLE IfcScheduleTimeControl ADD [IsCritical]  BIT;										
				
ALTER TABLE IfcScheduleTimeControl ADD [StatusTime] VARCHAR(50);
				
ALTER TABLE IfcScheduleTimeControl ADD [StartFloat]  float;										
				
ALTER TABLE IfcScheduleTimeControl ADD [FinishFloat]  float;										
				
ALTER TABLE IfcScheduleTimeControl ADD [Completion]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSectionedSpine'
-- ENTITY Table Definition
CREATE TABLE IfcSectionedSpine (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSectionedSpine ADD [SpineCurve] VARCHAR(50);
					
CREATE TABLE IfcSectionedSpine_CrossSections (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcSectionedSpine_CrossSections ADD CONSTRAINT
	PK_IfcSectionedSpine_CrossSections FOREIGN KEY (pid)
	REFERENCES IfcSectionedSpine (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcSectionedSpine_CrossSectionPositions (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcSectionedSpine_CrossSectionPositions ADD CONSTRAINT
	PK_IfcSectionedSpine_CrossSectionPositions FOREIGN KEY (pid)
	REFERENCES IfcSectionedSpine (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSensor'
-- ENTITY Table Definition
CREATE TABLE IfcSensor (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSensor ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSensor ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSensor ADD [Name]  ntext;										
				
ALTER TABLE IfcSensor ADD [Description]  ntext;										
				
ALTER TABLE IfcSensor ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSensor ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcSensor ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcSensor ADD [Tag]  ntext;										
				
ALTER TABLE IfcSensor ADD [ControlElementId]  ntext;										
				
ALTER TABLE IfcSensor ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcShapeAspect'
-- ENTITY Table Definition
CREATE TABLE IfcShapeAspect (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcShapeAspect_ShapeRepresentations (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcShapeAspect_ShapeRepresentations ADD CONSTRAINT
	PK_IfcShapeAspect_ShapeRepresentations FOREIGN KEY (pid)
	REFERENCES IfcShapeAspect (oid) ON DELETE CASCADE;

ALTER TABLE IfcShapeAspect ADD [Name]  ntext;										
				
ALTER TABLE IfcShapeAspect ADD [Description]  ntext;										
				
ALTER TABLE IfcShapeAspect ADD [ProductDefinitional]  tinyint;										
				
ALTER TABLE IfcShapeAspect ADD [PartOfProductDefinitionShape] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcShapeRepresentation'
-- ENTITY Table Definition
CREATE TABLE IfcShapeRepresentation (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcShapeRepresentation ADD [ContextOfItems] VARCHAR(50);
				
ALTER TABLE IfcShapeRepresentation ADD [RepresentationIdentifier]  ntext;										
				
ALTER TABLE IfcShapeRepresentation ADD [RepresentationType]  ntext;										
					
CREATE TABLE IfcShapeRepresentation_Items (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcShapeRepresentation_Items ADD CONSTRAINT
	PK_IfcShapeRepresentation_Items FOREIGN KEY (pid)
	REFERENCES IfcShapeRepresentation (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcShellBasedSurfaceModel'
-- ENTITY Table Definition
CREATE TABLE IfcShellBasedSurfaceModel (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcShellBasedSurfaceModel_SbsmBoundary (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcShellBasedSurfaceModel_SbsmBoundary ADD CONSTRAINT
	PK_IfcShellBasedSurfaceModel_SbsmBoundary FOREIGN KEY (pid)
	REFERENCES IfcShellBasedSurfaceModel (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSite'
-- ENTITY Table Definition
CREATE TABLE IfcSite (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSite ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSite ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSite ADD [Name]  ntext;										
				
ALTER TABLE IfcSite ADD [Description]  ntext;										
				
ALTER TABLE IfcSite ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSite ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcSite ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcSite ADD [LongName]  ntext;										
				
ALTER TABLE IfcSite ADD [CompositionType] VARCHAR(50);
				
CREATE TABLE IfcSite_RefLatitude (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	IntegerValue int
);
ALTER TABLE IfcSite_RefLatitude ADD CONSTRAINT
	PK_IfcSite_RefLatitude FOREIGN KEY (pid)
	REFERENCES IfcSite (oid) ON DELETE CASCADE;

CREATE TABLE IfcSite_RefLongitude (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	IntegerValue int
);
ALTER TABLE IfcSite_RefLongitude ADD CONSTRAINT
	PK_IfcSite_RefLongitude FOREIGN KEY (pid)
	REFERENCES IfcSite (oid) ON DELETE CASCADE;

ALTER TABLE IfcSite ADD [RefElevation]  float;										
				
ALTER TABLE IfcSite ADD [LandTitleNumber]  ntext;										
				
ALTER TABLE IfcSite ADD [SiteAddress] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSIUnit'
-- ENTITY Table Definition
CREATE TABLE IfcSIUnit (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSIUnit ADD [Dimensions] VARCHAR(50);
				
ALTER TABLE IfcSIUnit ADD [UnitType] VARCHAR(50);
				
ALTER TABLE IfcSIUnit ADD [Prefix] VARCHAR(50);
				
ALTER TABLE IfcSIUnit ADD [Name] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSlab'
-- ENTITY Table Definition
CREATE TABLE IfcSlab (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSlab ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSlab ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSlab ADD [Name]  ntext;										
				
ALTER TABLE IfcSlab ADD [Description]  ntext;										
				
ALTER TABLE IfcSlab ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSlab ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcSlab ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcSlab ADD [Tag]  ntext;										
				
ALTER TABLE IfcSlab ADD [PredefinedType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSpace'
-- ENTITY Table Definition
CREATE TABLE IfcSpace (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSpace ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSpace ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSpace ADD [Name]  ntext;										
				
ALTER TABLE IfcSpace ADD [Description]  ntext;										
				
ALTER TABLE IfcSpace ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSpace ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcSpace ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcSpace ADD [LongName]  ntext;										
				
ALTER TABLE IfcSpace ADD [CompositionType] VARCHAR(50);
				
ALTER TABLE IfcSpace ADD [InteriorOrExteriorSpace] VARCHAR(50);
				
ALTER TABLE IfcSpace ADD [ElevationWithFlooring]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSpaceProgram'
-- ENTITY Table Definition
CREATE TABLE IfcSpaceProgram (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSpaceProgram ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSpaceProgram ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSpaceProgram ADD [Name]  ntext;										
				
ALTER TABLE IfcSpaceProgram ADD [Description]  ntext;										
				
ALTER TABLE IfcSpaceProgram ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSpaceProgram ADD [SpaceProgramIdentifier]  ntext;										
				
ALTER TABLE IfcSpaceProgram ADD [MaxRequiredArea]  float;										
				
ALTER TABLE IfcSpaceProgram ADD [MinRequiredArea]  float;										
				
ALTER TABLE IfcSpaceProgram ADD [RequestedLocation] VARCHAR(50);
				
ALTER TABLE IfcSpaceProgram ADD [MinEstimatedCost] VARCHAR(50);
				
ALTER TABLE IfcSpaceProgram ADD [MaxEstimatedCost] VARCHAR(50);
				
ALTER TABLE IfcSpaceProgram ADD [StandardRequiredArea]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSpaceProgramGroup'
-- ENTITY Table Definition
CREATE TABLE IfcSpaceProgramGroup (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSpaceProgramGroup ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSpaceProgramGroup ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSpaceProgramGroup ADD [Name]  ntext;										
				
ALTER TABLE IfcSpaceProgramGroup ADD [Description]  ntext;										
				
ALTER TABLE IfcSpaceProgramGroup ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSpaceProgramGroup ADD [RequiredGroupArea]  float;										
				
ALTER TABLE IfcSpaceProgramGroup ADD [GroupRole]  ntext;										
				
ALTER TABLE IfcSpaceProgramGroup ADD [GroupAssignment]  VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSpaceThermalLoad'
-- ENTITY Table Definition
CREATE TABLE IfcSpaceThermalLoad (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSpaceThermalLoad ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSpaceThermalLoad ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD [Name]  ntext;										
				
ALTER TABLE IfcSpaceThermalLoad ADD [Description]  ntext;										
				
ALTER TABLE IfcSpaceThermalLoad ADD [ApplicableValueRatio]  float;										
				
ALTER TABLE IfcSpaceThermalLoad ADD [ThermalLoadSource] VARCHAR(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD [RequirementOrCriteria] VARCHAR(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD [ConstantLoad]  BIT;										
				
ALTER TABLE IfcSpaceThermalLoad ADD [LossOrGain] VARCHAR(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD [SourceDescription]  ntext;										
				
ALTER TABLE IfcSpaceThermalLoad ADD [MaximumValue] VARCHAR(50);
				
ALTER TABLE IfcSpaceThermalLoad ADD [MinimumValue] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSpotLightSource'
-- ENTITY Table Definition
CREATE TABLE IfcSpotLightSource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
CREATE TABLE IfcSpotLightSource_Color (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcSpotLightSource_Color ADD CONSTRAINT
	PK_IfcSpotLightSource_Color FOREIGN KEY (pid)
	REFERENCES IfcSpotLightSource (oid) ON DELETE CASCADE;

ALTER TABLE IfcSpotLightSource ADD [AmbientIntensity]  float;										
				
ALTER TABLE IfcSpotLightSource ADD [Intensity]  float;										
				
ALTER TABLE IfcSpotLightSource ADD [InContext] VARCHAR(50);
				
ALTER TABLE IfcSpotLightSource ADD [Name]  ntext;										
				
ALTER TABLE IfcSpotLightSource ADD [Description]  ntext;										
				
ALTER TABLE IfcSpotLightSource ADD [Location] VARCHAR(50);
				
CREATE TABLE IfcSpotLightSource_Attenuation (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcSpotLightSource_Attenuation ADD CONSTRAINT
	PK_IfcSpotLightSource_Attenuation FOREIGN KEY (pid)
	REFERENCES IfcSpotLightSource (oid) ON DELETE CASCADE;

ALTER TABLE IfcSpotLightSource ADD [SpreadAngle]  float;										
				
ALTER TABLE IfcSpotLightSource ADD [CutOffAngle]  float;										
				
ALTER TABLE IfcSpotLightSource ADD [Radius]  float;										
				
ALTER TABLE IfcSpotLightSource ADD [Direction] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcStair'
-- ENTITY Table Definition
CREATE TABLE IfcStair (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcStair ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcStair ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcStair ADD [Name]  ntext;										
				
ALTER TABLE IfcStair ADD [Description]  ntext;										
				
ALTER TABLE IfcStair ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcStair ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcStair ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcStair ADD [Tag]  ntext;										
				
ALTER TABLE IfcStair ADD [ShapeType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcStairFlight'
-- ENTITY Table Definition
CREATE TABLE IfcStairFlight (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcStairFlight ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcStairFlight ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcStairFlight ADD [Name]  ntext;										
				
ALTER TABLE IfcStairFlight ADD [Description]  ntext;										
				
ALTER TABLE IfcStairFlight ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcStairFlight ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcStairFlight ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcStairFlight ADD [Tag]  ntext;										
				
ALTER TABLE IfcStairFlight ADD [NumberOfRiser]  int;										
				
ALTER TABLE IfcStairFlight ADD [NumberOfTreads]  int;										
				
ALTER TABLE IfcStairFlight ADD [RiserHeight]  float;										
				
ALTER TABLE IfcStairFlight ADD [TreadLength]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcStorageDevice'
-- ENTITY Table Definition
CREATE TABLE IfcStorageDevice (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcStorageDevice ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcStorageDevice ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcStorageDevice ADD [Name]  ntext;										
				
ALTER TABLE IfcStorageDevice ADD [Description]  ntext;										
				
ALTER TABLE IfcStorageDevice ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcStorageDevice ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcStorageDevice ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcStorageDevice ADD [Tag]  ntext;										
				
ALTER TABLE IfcStorageDevice ADD [FlowElementType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSubContractResource'
-- ENTITY Table Definition
CREATE TABLE IfcSubContractResource (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSubContractResource ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSubContractResource ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSubContractResource ADD [Name]  ntext;										
				
ALTER TABLE IfcSubContractResource ADD [Description]  ntext;										
				
ALTER TABLE IfcSubContractResource ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSubContractResource ADD [ResourceConsumption] VARCHAR(50);
				
ALTER TABLE IfcSubContractResource ADD [BaseUnit] VARCHAR(50);
				
ALTER TABLE IfcSubContractResource ADD [SubContractResourceID]  ntext;										
				
ALTER TABLE IfcSubContractResource ADD [SubContractor]  VARCHAR(50);
				
ALTER TABLE IfcSubContractResource ADD [JobDescription]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSurfaceExtendedProperties'
-- ENTITY Table Definition
CREATE TABLE IfcSurfaceExtendedProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSurfaceExtendedProperties ADD [UsageIdentifier]  ntext;										
					
CREATE TABLE IfcSurfaceExtendedProperties_ExtendedProperties (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcSurfaceExtendedProperties_ExtendedProperties ADD CONSTRAINT
	PK_IfcSurfaceExtendedProperties_ExtendedProperties FOREIGN KEY (pid)
	REFERENCES IfcSurfaceExtendedProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcSurfaceExtendedProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcSurfaceExtendedProperties ADD [Name]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSurfaceOfLinearExtrusion'
-- ENTITY Table Definition
CREATE TABLE IfcSurfaceOfLinearExtrusion (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD [SweptCurve] VARCHAR(50);
				
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD [ExtrudedDirection] VARCHAR(50);
				
ALTER TABLE IfcSurfaceOfLinearExtrusion ADD [Depth]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSurfaceOfRevolution'
-- ENTITY Table Definition
CREATE TABLE IfcSurfaceOfRevolution (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSurfaceOfRevolution ADD [SweptCurve] VARCHAR(50);
				
ALTER TABLE IfcSurfaceOfRevolution ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcSurfaceOfRevolution ADD [AxisPosition] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSurfaceRenderingProperties'
-- ENTITY Table Definition
CREATE TABLE IfcSurfaceRenderingProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSurfaceRenderingProperties ADD [UsageIdentifier]  ntext;										
				
CREATE TABLE IfcSurfaceRenderingProperties_AmbientColor (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcSurfaceRenderingProperties_AmbientColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_AmbientColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcSurfaceRenderingProperties ADD [AmbientIntensity]  float;										
				
CREATE TABLE IfcSurfaceRenderingProperties_DiffuseColor (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcSurfaceRenderingProperties_DiffuseColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_DiffuseColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcSurfaceRenderingProperties ADD [Transparency]  float;										
				
CREATE TABLE IfcSurfaceRenderingProperties_EmmisiveColor (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcSurfaceRenderingProperties_EmmisiveColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_EmmisiveColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid) ON DELETE CASCADE;

ALTER TABLE IfcSurfaceRenderingProperties ADD [SpecularIntensity]  float;										
				
CREATE TABLE IfcSurfaceRenderingProperties_SpecularColor (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcSurfaceRenderingProperties_SpecularColor ADD CONSTRAINT
	PK_IfcSurfaceRenderingProperties_SpecularColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceRenderingProperties (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSurfaceShadingProperties'
-- ENTITY Table Definition
CREATE TABLE IfcSurfaceShadingProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSurfaceShadingProperties ADD [UsageIdentifier]  ntext;										
				
CREATE TABLE IfcSurfaceShadingProperties_AmbientColor (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcSurfaceShadingProperties_AmbientColor ADD CONSTRAINT
	PK_IfcSurfaceShadingProperties_AmbientColor FOREIGN KEY (pid)
	REFERENCES IfcSurfaceShadingProperties (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSurfaceStyle'
-- ENTITY Table Definition
CREATE TABLE IfcSurfaceStyle (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSurfaceStyle ADD [Name]  ntext;										
					
CREATE TABLE IfcSurfaceStyle_Properties (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcSurfaceStyle_Properties ADD CONSTRAINT
	PK_IfcSurfaceStyle_Properties FOREIGN KEY (pid)
	REFERENCES IfcSurfaceStyle (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSurfaceStyleUsage'
-- ENTITY Table Definition
CREATE TABLE IfcSurfaceStyleUsage (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcSurfaceStyleUsage_AppliedTo (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcSurfaceStyleUsage_AppliedTo ADD CONSTRAINT
	PK_IfcSurfaceStyleUsage_AppliedTo FOREIGN KEY (pid)
	REFERENCES IfcSurfaceStyleUsage (oid) ON DELETE CASCADE;

ALTER TABLE IfcSurfaceStyleUsage ADD [Style] VARCHAR(50);
				
ALTER TABLE IfcSurfaceStyleUsage ADD [Side] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSystem'
-- ENTITY Table Definition
CREATE TABLE IfcSystem (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSystem ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSystem ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSystem ADD [Name]  ntext;										
				
ALTER TABLE IfcSystem ADD [Description]  ntext;										
				
ALTER TABLE IfcSystem ADD [ObjectType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcSystemFurnitureElement'
-- ENTITY Table Definition
CREATE TABLE IfcSystemFurnitureElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcSystemFurnitureElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcSystemFurnitureElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD [Name]  ntext;										
				
ALTER TABLE IfcSystemFurnitureElement ADD [Description]  ntext;										
				
ALTER TABLE IfcSystemFurnitureElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcSystemFurnitureElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcSystemFurnitureElement ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTable'
-- ENTITY Table Definition
CREATE TABLE IfcTable (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTable ADD [Name]  ntext;										
					
CREATE TABLE IfcTable_Rows (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcTable_Rows ADD CONSTRAINT
	PK_IfcTable_Rows FOREIGN KEY (pid)
	REFERENCES IfcTable (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTableRow'
-- ENTITY Table Definition
CREATE TABLE IfcTableRow (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcTableRow_RowCells (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcTableRow_RowCells ADD CONSTRAINT
	PK_IfcTableRow_RowCells FOREIGN KEY (pid)
	REFERENCES IfcTableRow (oid) ON DELETE CASCADE;

ALTER TABLE IfcTableRow ADD [IsHeading]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTank'
-- ENTITY Table Definition
CREATE TABLE IfcTank (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTank ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcTank ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcTank ADD [Name]  ntext;										
				
ALTER TABLE IfcTank ADD [Description]  ntext;										
				
ALTER TABLE IfcTank ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcTank ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcTank ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcTank ADD [Tag]  ntext;										
				
ALTER TABLE IfcTank ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcTank ADD [Volume]  float;										
				
ALTER TABLE IfcTank ADD [ReliefValveSetting]  float;										
				
ALTER TABLE IfcTank ADD [ChargePressure]  float;										
				
ALTER TABLE IfcTank ADD [PressureRegulatorSetting]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTask'
-- ENTITY Table Definition
CREATE TABLE IfcTask (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTask ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcTask ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcTask ADD [Name]  ntext;										
				
ALTER TABLE IfcTask ADD [Description]  ntext;										
				
ALTER TABLE IfcTask ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcTask ADD [Productivity] VARCHAR(50);
				
ALTER TABLE IfcTask ADD [TaskId]  ntext;										
				
CREATE TABLE IfcTask_WBSCode (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcTask_WBSCode ADD CONSTRAINT
	PK_IfcTask_WBSCode FOREIGN KEY (pid)
	REFERENCES IfcTask (oid) ON DELETE CASCADE;

CREATE TABLE IfcTask_WBSSource (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcTask_WBSSource ADD CONSTRAINT
	PK_IfcTask_WBSSource FOREIGN KEY (pid)
	REFERENCES IfcTask (oid) ON DELETE CASCADE;

ALTER TABLE IfcTask ADD [Status] VARCHAR(50);
				
CREATE TABLE IfcTask_Milestones (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcTask_Milestones ADD CONSTRAINT
	PK_IfcTask_Milestones FOREIGN KEY (pid)
	REFERENCES IfcTask (oid) ON DELETE CASCADE;

ALTER TABLE IfcTask ADD [WorkMethod]  ntext;										
				
ALTER TABLE IfcTask ADD [InPlaceQuantity] VARCHAR(50);
				
ALTER TABLE IfcTask ADD [EstimatedQuantity] VARCHAR(50);
				
ALTER TABLE IfcTask ADD [BudgetQuantity] VARCHAR(50);
				
ALTER TABLE IfcTask ADD [IsRootTask]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTelecomAddress'
-- ENTITY Table Definition
CREATE TABLE IfcTelecomAddress (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTelecomAddress ADD [Purpose] VARCHAR(50);
				
ALTER TABLE IfcTelecomAddress ADD [Description]  ntext;										
				
ALTER TABLE IfcTelecomAddress ADD [UserDefinedPurpose]  ntext;										
				
CREATE TABLE IfcTelecomAddress_TelephoneNumbers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcTelecomAddress_TelephoneNumbers ADD CONSTRAINT
	PK_IfcTelecomAddress_TelephoneNumbers FOREIGN KEY (pid)
	REFERENCES IfcTelecomAddress (oid) ON DELETE CASCADE;

CREATE TABLE IfcTelecomAddress_FacsimileNumbers (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcTelecomAddress_FacsimileNumbers ADD CONSTRAINT
	PK_IfcTelecomAddress_FacsimileNumbers FOREIGN KEY (pid)
	REFERENCES IfcTelecomAddress (oid) ON DELETE CASCADE;

ALTER TABLE IfcTelecomAddress ADD [PagerNumber]  ntext;										
				
CREATE TABLE IfcTelecomAddress_ElectronicMailAddresses (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcTelecomAddress_ElectronicMailAddresses ADD CONSTRAINT
	PK_IfcTelecomAddress_ElectronicMailAddresses FOREIGN KEY (pid)
	REFERENCES IfcTelecomAddress (oid) ON DELETE CASCADE;

ALTER TABLE IfcTelecomAddress ADD [WWWHomePageURL]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcThermalMaterialProperties'
-- ENTITY Table Definition
CREATE TABLE IfcThermalMaterialProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcThermalMaterialProperties ADD [Material] VARCHAR(50);
				
ALTER TABLE IfcThermalMaterialProperties ADD [SpecificHeatCapacity]  float;										
				
ALTER TABLE IfcThermalMaterialProperties ADD [BoilingPoint]  float;										
				
ALTER TABLE IfcThermalMaterialProperties ADD [FreezingPoint]  float;										
				
ALTER TABLE IfcThermalMaterialProperties ADD [ThermalConductivity]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTransportElement'
-- ENTITY Table Definition
CREATE TABLE IfcTransportElement (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTransportElement ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcTransportElement ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcTransportElement ADD [Name]  ntext;										
				
ALTER TABLE IfcTransportElement ADD [Description]  ntext;										
				
ALTER TABLE IfcTransportElement ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcTransportElement ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcTransportElement ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcTransportElement ADD [Tag]  ntext;										
				
ALTER TABLE IfcTransportElement ADD [OperationType] VARCHAR(50);
				
ALTER TABLE IfcTransportElement ADD [CapacityByWeight]  float;										
				
ALTER TABLE IfcTransportElement ADD [CapacityByNumber]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTrapeziumProfileDef'
-- ENTITY Table Definition
CREATE TABLE IfcTrapeziumProfileDef (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTrapeziumProfileDef ADD [ProfileType] VARCHAR(50);
				
ALTER TABLE IfcTrapeziumProfileDef ADD [ProfileName]  ntext;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD [Position] VARCHAR(50);
				
ALTER TABLE IfcTrapeziumProfileDef ADD [BottomXDim]  float;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD [TopXDim]  float;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD [YDim]  float;										
				
ALTER TABLE IfcTrapeziumProfileDef ADD [TopXOffset]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTreatmentDevice'
-- ENTITY Table Definition
CREATE TABLE IfcTreatmentDevice (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTreatmentDevice ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcTreatmentDevice ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcTreatmentDevice ADD [Name]  ntext;										
				
ALTER TABLE IfcTreatmentDevice ADD [Description]  ntext;										
				
ALTER TABLE IfcTreatmentDevice ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcTreatmentDevice ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcTreatmentDevice ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcTreatmentDevice ADD [Tag]  ntext;										
				
ALTER TABLE IfcTreatmentDevice ADD [FlowElementType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTrimmedCurve'
-- ENTITY Table Definition
CREATE TABLE IfcTrimmedCurve (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTrimmedCurve ADD [BasisCurve] VARCHAR(50);
					
CREATE TABLE IfcTrimmedCurve_Trim1 (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcTrimmedCurve_Trim1 ADD CONSTRAINT
	PK_IfcTrimmedCurve_Trim1 FOREIGN KEY (pid)
	REFERENCES IfcTrimmedCurve (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcTrimmedCurve_Trim2 (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	select_type VARCHAR(255),
	data_type tinyint,
	RealValue float,
	IntegerValue int,
	BooleanValue bit,
	LogicalValue tinyint,
	EntityRef VARCHAR(50),
	StringValue ntext
);
ALTER TABLE IfcTrimmedCurve_Trim2 ADD CONSTRAINT
	PK_IfcTrimmedCurve_Trim2 FOREIGN KEY (pid)
	REFERENCES IfcTrimmedCurve (oid) ON DELETE CASCADE;

ALTER TABLE IfcTrimmedCurve ADD [SenseAgreement]  BIT;										
				
ALTER TABLE IfcTrimmedCurve ADD [MasterRepresentation] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTubeBundle'
-- ENTITY Table Definition
CREATE TABLE IfcTubeBundle (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTubeBundle ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcTubeBundle ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [Name]  ntext;										
				
ALTER TABLE IfcTubeBundle ADD [Description]  ntext;										
				
ALTER TABLE IfcTubeBundle ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcTubeBundle ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [Tag]  ntext;										
				
ALTER TABLE IfcTubeBundle ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [HeatTransferRate]  float;										
				
ALTER TABLE IfcTubeBundle ADD [ThermalEfficiency]  float;										
				
ALTER TABLE IfcTubeBundle ADD [PrimaryEnergySource] VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [TubeSize]  float;										
				
ALTER TABLE IfcTubeBundle ADD [TubeMaterial]  VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [TubeLength]  float;										
				
ALTER TABLE IfcTubeBundle ADD [TubeSpacing]  float;										
				
CREATE TABLE IfcTubeBundle_TubeFluidEnteringTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcTubeBundle_TubeFluidEnteringTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_TubeFluidEnteringTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid) ON DELETE CASCADE;

CREATE TABLE IfcTubeBundle_TubeFluidLeavingTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcTubeBundle_TubeFluidLeavingTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_TubeFluidLeavingTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid) ON DELETE CASCADE;

ALTER TABLE IfcTubeBundle ADD [FinMaterial]  VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [ShellMaterial]  VARCHAR(50);
				
ALTER TABLE IfcTubeBundle ADD [FinSpacing]  float;										
				
ALTER TABLE IfcTubeBundle ADD [TubeFoulingFactor]  float;										
				
ALTER TABLE IfcTubeBundle ADD [NumberOfTubeCircuits]  int;										
				
ALTER TABLE IfcTubeBundle ADD [NumberOfTubeRows]  int;										
				
CREATE TABLE IfcTubeBundle_ShellFluidLeavingTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcTubeBundle_ShellFluidLeavingTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_ShellFluidLeavingTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid) ON DELETE CASCADE;

CREATE TABLE IfcTubeBundle_ShellFluidEnteringTemperature (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcTubeBundle_ShellFluidEnteringTemperature ADD CONSTRAINT
	PK_IfcTubeBundle_ShellFluidEnteringTemperature FOREIGN KEY (pid)
	REFERENCES IfcTubeBundle (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTypeObject'
-- ENTITY Table Definition
CREATE TABLE IfcTypeObject (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTypeObject ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcTypeObject ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcTypeObject ADD [Name]  ntext;										
				
ALTER TABLE IfcTypeObject ADD [Description]  ntext;										
				
ALTER TABLE IfcTypeObject ADD [ApplicableOccurrence]  ntext;										
					
CREATE TABLE IfcTypeObject_HasPropertySets (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcTypeObject_HasPropertySets ADD CONSTRAINT
	PK_IfcTypeObject_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcTypeObject (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcTypeProduct'
-- ENTITY Table Definition
CREATE TABLE IfcTypeProduct (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcTypeProduct ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcTypeProduct ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcTypeProduct ADD [Name]  ntext;										
				
ALTER TABLE IfcTypeProduct ADD [Description]  ntext;										
				
ALTER TABLE IfcTypeProduct ADD [ApplicableOccurrence]  ntext;										
					
CREATE TABLE IfcTypeProduct_HasPropertySets (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcTypeProduct_HasPropertySets ADD CONSTRAINT
	PK_IfcTypeProduct_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcTypeProduct (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcTypeProduct_RepresentationMaps (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcTypeProduct_RepresentationMaps ADD CONSTRAINT
	PK_IfcTypeProduct_RepresentationMaps FOREIGN KEY (pid)
	REFERENCES IfcTypeProduct (oid) ON DELETE CASCADE;

ALTER TABLE IfcTypeProduct ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcUnitAssignment'
-- ENTITY Table Definition
CREATE TABLE IfcUnitAssignment (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcUnitAssignment_Units (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcUnitAssignment_Units ADD CONSTRAINT
	PK_IfcUnitAssignment_Units FOREIGN KEY (pid)
	REFERENCES IfcUnitAssignment (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcUnitHeater'
-- ENTITY Table Definition
CREATE TABLE IfcUnitHeater (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcUnitHeater ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcUnitHeater ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcUnitHeater ADD [Name]  ntext;										
				
ALTER TABLE IfcUnitHeater ADD [Description]  ntext;										
				
ALTER TABLE IfcUnitHeater ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcUnitHeater ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcUnitHeater ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcUnitHeater ADD [Tag]  ntext;										
				
ALTER TABLE IfcUnitHeater ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcUnitHeater ADD [HeatTransferRate]  float;										
				
ALTER TABLE IfcUnitHeater ADD [ThermalEfficiency]  float;										
				
ALTER TABLE IfcUnitHeater ADD [PrimaryEnergySource] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcValve'
-- ENTITY Table Definition
CREATE TABLE IfcValve (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcValve ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcValve ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcValve ADD [Name]  ntext;										
				
ALTER TABLE IfcValve ADD [Description]  ntext;										
				
ALTER TABLE IfcValve ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcValve ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcValve ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcValve ADD [Tag]  ntext;										
				
ALTER TABLE IfcValve ADD [FlowElementType] VARCHAR(50);
				
ALTER TABLE IfcValve ADD [CloseOffRating]  float;										
				
ALTER TABLE IfcValve ADD [ValveFlowCoefficient] VARCHAR(50);
				
ALTER TABLE IfcValve ADD [ValveType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcVector'
-- ENTITY Table Definition
CREATE TABLE IfcVector (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcVector ADD [Orientation] VARCHAR(50);
				
ALTER TABLE IfcVector ADD [Magnitude]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcVertex'
-- ENTITY Table Definition
CREATE TABLE IfcVertex (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcVertexPoint'
-- ENTITY Table Definition
CREATE TABLE IfcVertexPoint (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcVertexPoint ADD [VertexGeometry] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcVirtualGridIntersection'
-- ENTITY Table Definition
CREATE TABLE IfcVirtualGridIntersection (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
				
CREATE TABLE IfcVirtualGridIntersection_IntersectingAxes (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcVirtualGridIntersection_IntersectingAxes ADD CONSTRAINT
	PK_IfcVirtualGridIntersection_IntersectingAxes FOREIGN KEY (pid)
	REFERENCES IfcVirtualGridIntersection (oid) ON DELETE CASCADE;

CREATE TABLE IfcVirtualGridIntersection_OffsetDistances (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	RealValue float
);
ALTER TABLE IfcVirtualGridIntersection_OffsetDistances ADD CONSTRAINT
	PK_IfcVirtualGridIntersection_OffsetDistances FOREIGN KEY (pid)
	REFERENCES IfcVirtualGridIntersection (oid) ON DELETE CASCADE;

PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWall'
-- ENTITY Table Definition
CREATE TABLE IfcWall (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWall ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWall ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWall ADD [Name]  ntext;										
				
ALTER TABLE IfcWall ADD [Description]  ntext;										
				
ALTER TABLE IfcWall ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcWall ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcWall ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcWall ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWallStandardCase'
-- ENTITY Table Definition
CREATE TABLE IfcWallStandardCase (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWallStandardCase ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWallStandardCase ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWallStandardCase ADD [Name]  ntext;										
				
ALTER TABLE IfcWallStandardCase ADD [Description]  ntext;										
				
ALTER TABLE IfcWallStandardCase ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcWallStandardCase ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcWallStandardCase ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcWallStandardCase ADD [Tag]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWindow'
-- ENTITY Table Definition
CREATE TABLE IfcWindow (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWindow ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWindow ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWindow ADD [Name]  ntext;										
				
ALTER TABLE IfcWindow ADD [Description]  ntext;										
				
ALTER TABLE IfcWindow ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcWindow ADD [ObjectPlacement] VARCHAR(50);
				
ALTER TABLE IfcWindow ADD [Representation] VARCHAR(50);
				
ALTER TABLE IfcWindow ADD [Tag]  ntext;										
				
ALTER TABLE IfcWindow ADD [OverallHeight]  float;										
				
ALTER TABLE IfcWindow ADD [OverallWidth]  float;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWindowLiningProperties'
-- ENTITY Table Definition
CREATE TABLE IfcWindowLiningProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWindowLiningProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWindowLiningProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWindowLiningProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcWindowLiningProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcWindowLiningProperties ADD [LiningDepth]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [LiningThickness]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [TransomThickness]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [MullionThickness]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [FirstTransomOffset]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [SecondTransomOffset]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [FirstMullionOffset]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [SecondMullionOffset]  float;										
				
ALTER TABLE IfcWindowLiningProperties ADD [ShapeAspectStyle] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWindowPanelProperties'
-- ENTITY Table Definition
CREATE TABLE IfcWindowPanelProperties (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWindowPanelProperties ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWindowPanelProperties ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWindowPanelProperties ADD [Name]  ntext;										
				
ALTER TABLE IfcWindowPanelProperties ADD [Description]  ntext;										
				
ALTER TABLE IfcWindowPanelProperties ADD [OperationType] VARCHAR(50);
				
ALTER TABLE IfcWindowPanelProperties ADD [PanelPosition] VARCHAR(50);
				
ALTER TABLE IfcWindowPanelProperties ADD [FrameDepth]  float;										
				
ALTER TABLE IfcWindowPanelProperties ADD [FrameThickness]  float;										
				
ALTER TABLE IfcWindowPanelProperties ADD [ShapeAspectStyle] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWindowStyle'
-- ENTITY Table Definition
CREATE TABLE IfcWindowStyle (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWindowStyle ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWindowStyle ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWindowStyle ADD [Name]  ntext;										
				
ALTER TABLE IfcWindowStyle ADD [Description]  ntext;										
				
ALTER TABLE IfcWindowStyle ADD [ApplicableOccurrence]  ntext;										
					
CREATE TABLE IfcWindowStyle_HasPropertySets (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcWindowStyle_HasPropertySets ADD CONSTRAINT
	PK_IfcWindowStyle_HasPropertySets FOREIGN KEY (pid)
	REFERENCES IfcWindowStyle (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcWindowStyle_RepresentationMaps (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcWindowStyle_RepresentationMaps ADD CONSTRAINT
	PK_IfcWindowStyle_RepresentationMaps FOREIGN KEY (pid)
	REFERENCES IfcWindowStyle (oid) ON DELETE CASCADE;

ALTER TABLE IfcWindowStyle ADD [Tag]  ntext;										
				
ALTER TABLE IfcWindowStyle ADD [ConstructionType] VARCHAR(50);
				
ALTER TABLE IfcWindowStyle ADD [OperationType] VARCHAR(50);
				
ALTER TABLE IfcWindowStyle ADD [ParameterTakesPrecedence]  BIT;										
				
ALTER TABLE IfcWindowStyle ADD [Sizeable]  BIT;										
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWorkOrder'
-- ENTITY Table Definition
CREATE TABLE IfcWorkOrder (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWorkOrder ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [Name]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [Description]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [OrderNumber]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [TransactionCode]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [IssuingDate] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [IssuedBy]  VARCHAR(50);
					
CREATE TABLE IfcWorkOrder_IssuedTo (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcWorkOrder_IssuedTo ADD CONSTRAINT
	PK_IfcWorkOrder_IssuedTo FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcWorkOrder_AdditionalContacts (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcWorkOrder_AdditionalContacts ADD CONSTRAINT
	PK_IfcWorkOrder_AdditionalContacts FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid) ON DELETE CASCADE;

CREATE TABLE IfcWorkOrder_Remarks (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcWorkOrder_Remarks ADD CONSTRAINT
	PK_IfcWorkOrder_Remarks FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcWorkOrder ADD [Signoff] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [BudgetSource] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [ProductDescription]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [ShortJobDescription]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [LongJobDescription]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [WorkTypeRequested]  ntext;										
				
ALTER TABLE IfcWorkOrder ADD [ContractualType]  ntext;										
				
CREATE TABLE IfcWorkOrder_IfNotAccomplished (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcWorkOrder_IfNotAccomplished ADD CONSTRAINT
	PK_IfcWorkOrder_IfNotAccomplished FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcWorkOrder ADD [RequestedStartTime] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [RequestedFinishTime] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [ActualStartTime] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [ActualFinishTime] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [CostEstimate] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [WorkPlan] VARCHAR(50);
				
ALTER TABLE IfcWorkOrder ADD [Status] VARCHAR(50);
				
CREATE TABLE IfcWorkOrder_WorkOrderRiskType (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	StringValue ntext
);
ALTER TABLE IfcWorkOrder_WorkOrderRiskType ADD CONSTRAINT
	PK_IfcWorkOrder_WorkOrderRiskType FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid) ON DELETE CASCADE;
	
CREATE TABLE IfcWorkOrder_PerformedBy (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcWorkOrder_PerformedBy ADD CONSTRAINT
	PK_IfcWorkOrder_PerformedBy FOREIGN KEY (pid)
	REFERENCES IfcWorkOrder (oid) ON DELETE CASCADE;

ALTER TABLE IfcWorkOrder ADD [ActualCost] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWorkPlan'
-- ENTITY Table Definition
CREATE TABLE IfcWorkPlan (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWorkPlan ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWorkPlan ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWorkPlan ADD [Name]  ntext;										
				
ALTER TABLE IfcWorkPlan ADD [Description]  ntext;										
				
ALTER TABLE IfcWorkPlan ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcWorkPlan ADD [Identifier]  ntext;										
				
ALTER TABLE IfcWorkPlan ADD [CreationDate] VARCHAR(50);
					
CREATE TABLE IfcWorkPlan_Creators (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcWorkPlan_Creators ADD CONSTRAINT
	PK_IfcWorkPlan_Creators FOREIGN KEY (pid)
	REFERENCES IfcWorkPlan (oid) ON DELETE CASCADE;

ALTER TABLE IfcWorkPlan ADD [Purpose]  ntext;										
				
ALTER TABLE IfcWorkPlan ADD [Duration]  float;										
				
ALTER TABLE IfcWorkPlan ADD [TotalFloat]  float;										
				
ALTER TABLE IfcWorkPlan ADD [StartTime] VARCHAR(50);
				
ALTER TABLE IfcWorkPlan ADD [FinishTime] VARCHAR(50);
				
ALTER TABLE IfcWorkPlan ADD [WorkControlType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcWorkSchedule'
-- ENTITY Table Definition
CREATE TABLE IfcWorkSchedule (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcWorkSchedule ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcWorkSchedule ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcWorkSchedule ADD [Name]  ntext;										
				
ALTER TABLE IfcWorkSchedule ADD [Description]  ntext;										
				
ALTER TABLE IfcWorkSchedule ADD [ObjectType]  ntext;										
				
ALTER TABLE IfcWorkSchedule ADD [Identifier]  ntext;										
				
ALTER TABLE IfcWorkSchedule ADD [CreationDate] VARCHAR(50);
					
CREATE TABLE IfcWorkSchedule_Creators (
	uid int IDENTITY(1,1) NOT NULL PRIMARY KEY,
	pid VARCHAR (50),
	EntityRef VARCHAR (50)
);
ALTER TABLE IfcWorkSchedule_Creators ADD CONSTRAINT
	PK_IfcWorkSchedule_Creators FOREIGN KEY (pid)
	REFERENCES IfcWorkSchedule (oid) ON DELETE CASCADE;

ALTER TABLE IfcWorkSchedule ADD [Purpose]  ntext;										
				
ALTER TABLE IfcWorkSchedule ADD [Duration]  float;										
				
ALTER TABLE IfcWorkSchedule ADD [TotalFloat]  float;										
				
ALTER TABLE IfcWorkSchedule ADD [StartTime] VARCHAR(50);
				
ALTER TABLE IfcWorkSchedule ADD [FinishTime] VARCHAR(50);
				
ALTER TABLE IfcWorkSchedule ADD [WorkControlType] VARCHAR(50);
				
PRINT '--'
PRINT 'Created!'
GO
		

PRINT ' '
PRINT '----------------------------------------------------------------------'
PRINT 'Table: IfcZone'
-- ENTITY Table Definition
CREATE TABLE IfcZone (
			
	oid VARCHAR(50) NOT NULL PRIMARY KEY
);
GO
			
ALTER TABLE IfcZone ADD [GlobalId]  ntext;										
				
ALTER TABLE IfcZone ADD [OwnerHistory] VARCHAR(50);
				
ALTER TABLE IfcZone ADD [Name]  ntext;										
				
ALTER TABLE IfcZone ADD [Description]  ntext;										
				
ALTER TABLE IfcZone ADD [ObjectType]  ntext;										
				
PRINT '--'
PRINT 'Created!'
GO
		
PRINT ''
PRINT '-- END --'
PRINT '----------------------------------------------------------------------'
GO