CREATE TABLE [dbo].[ud_swcat_rule]
(
[scuuid] [uniqueidentifier] NOT NULL,
[scrule] [nvarchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ud_swcat___scrul__3F3DDD51] DEFAULT (' '),
[scnote] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ud_swcat___scnot__4032018A] DEFAULT (' '),
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ud_swcat___lacti__412625C3] DEFAULT (' '),
[lactdate] [datetime] NOT NULL CONSTRAINT [DF__ud_swcat___lactd__421A49FC] DEFAULT (' '),
[createdate] [datetime] NOT NULL CONSTRAINT [DF__ud_swcat___creat__430E6E35] DEFAULT (' '),
[createuser] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ud_swcat___creat__4402926E] DEFAULT (' ')
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ud_swcat_rule_ak1] ON [dbo].[ud_swcat_rule] ([scuuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ud_swcat_rule] TO [aiadmin]
GRANT INSERT ON  [dbo].[ud_swcat_rule] TO [aiadmin]
GRANT DELETE ON  [dbo].[ud_swcat_rule] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ud_swcat_rule] TO [aiadmin]
GRANT SELECT ON  [dbo].[ud_swcat_rule] TO [aipublic]
GO