CREATE TABLE [dbo].[d_painter]
(
[id] [int] NOT NULL,
[formid] [int] NULL,
[formname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[formgroup] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[seclevel] [int] NULL,
[entityid] [int] NULL,
[cntltype] [int] NULL,
[cntlid] [int] NULL,
[parentid] [int] NULL,
[ddid] [int] NULL,
[mapback] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tstamp] [float] NULL,
[proplist] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[formtype] [int] NULL,
[predefined] [int] NULL,
[extra_s1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[extra_s2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[extra_s3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[extra_l1] [int] NULL,
[extra_l2] [int] NULL,
[extra_l3] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[d_painter] ADD CONSTRAINT [XPKd_painter] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [d_painter_x1] ON [dbo].[d_painter] ([formgroup]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [d_painter_x0] ON [dbo].[d_painter] ([formname], [cntlid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[d_painter] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[d_painter] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[d_painter] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[d_painter] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[d_painter] TO [service_desk_d_painter_group]
GRANT INSERT ON  [dbo].[d_painter] TO [service_desk_d_painter_group]
GRANT DELETE ON  [dbo].[d_painter] TO [service_desk_d_painter_group]
GRANT UPDATE ON  [dbo].[d_painter] TO [service_desk_d_painter_group]
GO