CREATE TABLE [dbo].[ucm_simple_triggers]
(
[trigger_uuid] [binary] (16) NOT NULL,
[repeat_count] [int] NULL,
[repeat_interval] [int] NULL,
[repeat_unit] [tinyint] NULL,
[times_triggered] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ucm_simple_triggers] ADD CONSTRAINT [XPKucm_simple_triggers] PRIMARY KEY CLUSTERED ([trigger_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ucm_simple_triggers] TO [ucmadmin]
GRANT INSERT ON  [dbo].[ucm_simple_triggers] TO [ucmadmin]
GRANT DELETE ON  [dbo].[ucm_simple_triggers] TO [ucmadmin]
GRANT UPDATE ON  [dbo].[ucm_simple_triggers] TO [ucmadmin]
GRANT SELECT ON  [dbo].[ucm_simple_triggers] TO [ucmuser]
GRANT SELECT ON  [dbo].[ucm_simple_triggers] TO [uniadmin]
GRANT INSERT ON  [dbo].[ucm_simple_triggers] TO [uniadmin]
GRANT DELETE ON  [dbo].[ucm_simple_triggers] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ucm_simple_triggers] TO [uniadmin]
GRANT SELECT ON  [dbo].[ucm_simple_triggers] TO [uniuser]
GO