Tables [dbo].[ca_acme_checkpoint]
Properties
PropertyValue
Row Count57
Created11:07:04 AM Wednesday, March 07, 2007
Last Modified11:09:05 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKca_acme_checkpoint: message_type_uuid\message_version_numbermessage_type_uuidbinary(16)16
No
Cluster Primary Key XPKca_acme_checkpoint: message_type_uuid\message_version_numbermessage_version_numberint4
No
last_message_numberint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKca_acme_checkpoint: message_type_uuid\message_version_numberXPKca_acme_checkpointmessage_type_uuid, message_version_number
Yes
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantDeleteupmuser_group
GrantInsertupmuser_group
GrantDeleteswcmadmin
GrantInsertswcmadmin
GrantDeletecicuser
GrantInsertcicuser
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectregadmin
GrantSelectupmuser_group
GrantUpdateupmuser_group
GrantSelectca_itrm_group_ams
GrantSelectswcmadmin
GrantUpdateswcmadmin
GrantSelectcicuser
GrantUpdatecicuser
SQL Script
CREATE TABLE [dbo].[ca_acme_checkpoint]
(
[message_type_uuid] [binary] (16) NOT NULL,
[message_version_number] [int] NOT NULL,
[last_message_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_acme_checkpoint] ADD CONSTRAINT [XPKca_acme_checkpoint] PRIMARY KEY CLUSTERED ([message_type_uuid], [message_version_number]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ca_acme_checkpoint] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_acme_checkpoint] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_acme_checkpoint] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_acme_checkpoint] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_acme_checkpoint] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_acme_checkpoint] TO [cicuser]
GRANT INSERT ON  [dbo].[ca_acme_checkpoint] TO [cicuser]
GRANT DELETE ON  [dbo].[ca_acme_checkpoint] TO [cicuser]
GRANT UPDATE ON  [dbo].[ca_acme_checkpoint] TO [cicuser]
GRANT SELECT ON  [dbo].[ca_acme_checkpoint] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_acme_checkpoint] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_acme_checkpoint] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_acme_checkpoint] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_acme_checkpoint] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_acme_checkpoint] TO [upmuser_group]
GRANT INSERT ON  [dbo].[ca_acme_checkpoint] TO [upmuser_group]
GRANT DELETE ON  [dbo].[ca_acme_checkpoint] TO [upmuser_group]
GRANT UPDATE ON  [dbo].[ca_acme_checkpoint] TO [upmuser_group]
GO
Uses