CREATE TABLE [dbo].[ai_swcat_prop]
(
[scuuid] [uniqueidentifier] NOT NULL,
[scname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[scnote] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[lactdate] [datetime] NOT NULL,
[createdate] [datetime] NOT NULL,
[createuser] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swcat___creat__19183469] DEFAULT (' ')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_swcat_prop] ADD CONSTRAINT [ai_swcat_prop_pk] PRIMARY KEY CLUSTERED ([scuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swcat_prop_ak1] ON [dbo].[ai_swcat_prop] ([scname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swcat_prop_ak2] ON [dbo].[ai_swcat_prop] ([scnote]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_swcat_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_swcat_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_swcat_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_swcat_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_swcat_prop] TO [aipublic]
GO