CREATE TABLE [dbo].[infohis]
(
[object_uuid] [binary] (16) NOT NULL,
[sw_domain_uuid] [binary] (16) NOT NULL,
[sw_def_uuid] [binary] (16) NOT NULL,
[sttotal] [int] NOT NULL,
[acid] [int] NULL,
[stdate] [int] NULL,
[sttime] [int] NULL,
[enddate] [int] NULL,
[endtime] [int] NULL,
[endtotal] [int] NULL,
[apflag] [int] NULL,
[domain_uuid] [binary] (16) NULL,
[object_type] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[infohis] ADD CONSTRAINT [XPKinfohis] PRIMARY KEY CLUSTERED ([object_uuid], [sw_def_uuid], [sttotal]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[infohis] TO [ams_group]
GRANT SELECT ON  [dbo].[infohis] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[infohis] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[infohis] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[infohis] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[infohis] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[infohis] TO [upmuser_group]
GO