CREATE TABLE [dbo].[pd_machine_ext]
(
[machine_id] [int] NOT NULL,
[primary_pde_name] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__prima__2F25DA6B] DEFAULT (' '),
[backup_pde_name] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__backu__3019FEA4] DEFAULT (' '),
[primary_pdg_name] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__prima__310E22DD] DEFAULT (' '),
[pd_static_name] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__pd_st__32024716] DEFAULT (' '),
[last_dns_name] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__last___32F66B4F] DEFAULT (' '),
[last_dns_name_1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__last___33EA8F88] DEFAULT (' '),
[last_dns_name_2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__last___34DEB3C1] DEFAULT (' '),
[last_dns_name_3] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__last___35D2D7FA] DEFAULT (' '),
[last_dns_name_4] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__last___36C6FC33] DEFAULT (' '),
[last_dns_name_5] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__last___37BB206C] DEFAULT (' '),
[profile_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__profi__38AF44A5] DEFAULT (' '),
[config_server] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__confi__39A368DE] DEFAULT (' '),
[mac_address] [nvarchar] (18) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__mac_a__3A978D17] DEFAULT (' '),
[agent_version] [int] NOT NULL CONSTRAINT [DF__pd_machin__agent__3B8BB150] DEFAULT ('0'),
[neugent_version] [int] NOT NULL CONSTRAINT [DF__pd_machin__neuge__3C7FD589] DEFAULT ('0'),
[pp_version] [int] NOT NULL CONSTRAINT [DF__pd_machin__pp_ve__3D73F9C2] DEFAULT ('0'),
[pd_protocol] [int] NOT NULL CONSTRAINT [DF__pd_machin__pd_pr__3E681DFB] DEFAULT ('0'),
[pd_date] [nvarchar] (26) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__pd_da__3F5C4234] DEFAULT (' '),
[pd_address] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_machin__pd_ad__4050666D] DEFAULT (' '),
[object_id_high] [int] NOT NULL CONSTRAINT [DF__pd_machin__objec__41448AA6] DEFAULT ('0'),
[object_id_low] [int] NOT NULL CONSTRAINT [DF__pd_machin__objec__4238AEDF] DEFAULT ('0')
) ON [PRIMARY]

GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_pd_machine_ext] ON [dbo].[pd_machine_ext] ([machine_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[pd_machine_ext] TO [pdadmin]
GRANT INSERT ON  [dbo].[pd_machine_ext] TO [pdadmin]
GRANT DELETE ON  [dbo].[pd_machine_ext] TO [pdadmin]
GRANT UPDATE ON  [dbo].[pd_machine_ext] TO [pdadmin]
GRANT SELECT ON  [dbo].[pd_machine_ext] TO [pduser]
GRANT SELECT ON  [dbo].[pd_machine_ext] TO [uniadmin]
GRANT INSERT ON  [dbo].[pd_machine_ext] TO [uniadmin]
GRANT DELETE ON  [dbo].[pd_machine_ext] TO [uniadmin]
GRANT UPDATE ON  [dbo].[pd_machine_ext] TO [uniadmin]
GO