CREATE TABLE [dbo].[usm_system_install]
(
[system_install_id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[comment] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[domain_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[host_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[logon_reqd] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timeout] [int] NULL,
[use_cache] [int] NULL CONSTRAINT [DF__usm_syste__use_c__2997E99E] DEFAULT ((0)),
[web_root] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[document_root] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[port_no] [int] NULL,
[log_messages] [int] NULL CONSTRAINT [DF__usm_syste__log_m__2A8C0DD7] DEFAULT ((0)),
[servlet_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[news_to_domains] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[client_side_processing] [int] NULL CONSTRAINT [DF__usm_syste__clien__2B803210] DEFAULT ((0)),
[concurrent_logon] [int] NULL CONSTRAINT [DF__usm_syste__concu__2C745649] DEFAULT ((0)),
[super_tenant_enabled] [int] NULL CONSTRAINT [DF__usm_syste__super__2D687A82] DEFAULT ((0)),
[login_property] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[super_tenant_levels] [int] NULL,
[secret_question] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwd_policy_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[comments] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_system_install] ADD CONSTRAINT [XPKusm_system_install] PRIMARY KEY CLUSTERED ([system_install_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_system_install] ADD CONSTRAINT [$usm_s_r00002c6b00000000] FOREIGN KEY ([pwd_policy_id]) REFERENCES [dbo].[usm_pwd_policy] ([pwd_policy_id])
GO
GRANT SELECT ON  [dbo].[usm_system_install] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_system_install] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_system_install] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_system_install] TO [usmgroup]
GO