INSERT INTO [SampleProperty].[dbo].[Equipment]

([EquipmentNo]

,[Description]

,[EqType]

,[EquipTypeID]

,[ParentID])

VALUES

('E1'

,'TestE1'

,'Motor'

,1

,null)

GO

INSERT INTO [SampleProperty].[dbo].[Equipment]

([EquipmentNo]

,[Description]

,[EqType]

,[EquipTypeID]

,[ParentID])

VALUES

('E2'

,'TestE2'

,'Motor'

,1

,null)

GO

INSERT INTO [SampleProperty].[dbo].[Equipment]

([EquipmentNo]

,[Description]

,[EqType]

,[EquipTypeID]

,[ParentID])

VALUES

('E3'

,'testE3'

,'Heater'

,4

,null)

GO

INSERT INTO [SampleProperty].[dbo].[EquipmentTypes]

([EquipTypeID]

,[EquipmentType])

VALUES

(1

,'Motor1')

GO

INSERT INTO [SampleProperty].[dbo].[EquipmentTypes]

([EquipTypeID]

,[EquipmentType])

VALUES

(2

,'Busbar1')

GO

INSERT INTO [SampleProperty].[dbo].[EquipmentTypes]

([EquipTypeID]

,[EquipmentType])

VALUES

(3

,'Switchboard1')

GO

INSERT INTO [SampleProperty].[dbo].[EquipmentTypes]

([EquipTypeID]

,[EquipmentType])

VALUES

(4

,'Heater')

GO

INSERT INTO [SampleProperty].[dbo].[PropertyDef]

([PropName]

,[Caption]

,[ObjectTypeID])

VALUES

('Color'

,'Color'

,3)

GO

INSERT INTO [SampleProperty].[dbo].[PropertyDef]

([PropName]

,[Caption]

,[ObjectTypeID])

VALUES

('Height'

,'Height'

,3)

GO

INSERT INTO [SampleProperty].[dbo].[PropertyDef]

([PropName]

,[Caption]

,[ObjectTypeID])

VALUES

('Frequency'

,'Frequency'

,3)

GO

INSERT INTO [SampleProperty].[dbo].[EPropertyData]

([ObjectId]

,[PropertyDefID]

,[PropValue])

VALUES

(1

,1

,'Red')

GO

INSERT INTO [SampleProperty].[dbo].[EPropertyData]

([ObjectId]

,[PropertyDefID]

,[PropValue])

VALUES

(2

,1

,'Green')

Go

INSERT INTO [SampleProperty].[dbo].[EPropertyData]

([ObjectId]

,[PropertyDefID]

,[PropValue])

VALUES

(3

,3

,'12')