USE [WitteRFID]਀䜀伀 ਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  吀愀戀氀攀 嬀搀戀漀崀⸀嬀吀愀最䄀猀猀漀挀椀愀琀椀漀渀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 ㄀㄀⼀㄀㔀⼀㈀ ㄀㄀ ㄀㔀㨀㐀㄀㨀㄀㐀 ⨀⨀⨀⨀⨀⨀⼀ SET ANSI_NULLS ON਀䜀伀 SET QUOTED_IDENTIFIER ON਀䜀伀 CREATE TABLE [dbo].[TagAssociation](਀ऀ嬀吀愀最䤀䐀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㄀㘀⤀ 一伀吀 一唀䰀䰀Ⰰ [AccessionNumber] [nvarchar](50) NOT NULL,਀ऀ嬀䐀攀猀挀爀椀瀀琀椀漀渀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㄀  ⤀ 一伀吀 一唀䰀䰀Ⰰ [TimeStamp] [datetime] NOT NULL਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 GO਀ /****** Object: Table [dbo].[TagAlarms] Script Date: 11/15/2011 15:41:14 ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一 GO਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀吀愀最䄀氀愀爀洀猀崀⠀ [RecordID] [int] IDENTITY(1,1) NOT NULL,਀ऀ嬀吀愀最䤀䐀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㔀 ⤀ 一伀吀 一唀䰀䰀Ⰰ [TimeStamp] [datetime] NOT NULL,਀ऀ嬀䄀氀愀爀洀吀礀瀀攀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㔀 ⤀ 一伀吀 一唀䰀䰀Ⰰ [ReaderReporting] [nvarchar](50) NULL,਀ऀ嬀匀匀䤀崀 嬀椀渀琀崀 一唀䰀䰀 ) ON [PRIMARY]਀䜀伀 ਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  吀愀戀氀攀 嬀搀戀漀崀⸀嬀䌀甀爀爀攀渀琀䄀氀愀爀洀猀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 ㄀㄀⼀㄀㔀⼀㈀ ㄀㄀ ㄀㔀㨀㐀㄀㨀㄀㐀 ⨀⨀⨀⨀⨀⨀⼀ SET ANSI_NULLS ON਀䜀伀 SET QUOTED_IDENTIFIER ON਀䜀伀 CREATE TABLE [dbo].[CurrentAlarms](਀ऀ嬀吀愀最䤀䐀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㔀 ⤀ 一伀吀 一唀䰀䰀Ⰰ [TimeStamp] [datetime] NOT NULL,਀ऀ嬀䄀氀愀爀洀吀礀瀀攀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㔀 ⤀ 一伀吀 一唀䰀䰀Ⰰ [ReaderReporting] [nvarchar](50) NULL਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 GO਀ /****** Object: Table [dbo].[NotificationRecipients] Script Date: 05/10/2012 21:55:22 ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一 GO਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀一漀琀椀昀椀挀愀琀椀漀渀刀攀挀椀瀀椀攀渀琀猀崀⠀ [EmailAddress] [nvarchar](100) NOT NULL,਀ऀ嬀一愀洀攀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㔀 ⤀ 一唀䰀䰀Ⰰ [GetMissingTags] [tinyint] NULL,਀ऀ嬀䜀攀琀䴀漀琀椀漀渀吀愀最猀崀 嬀琀椀渀礀椀渀琀崀 一唀䰀䰀Ⰰ [GetSystemNotifications] [tinyint] NULL,਀ऀ嬀刀攀挀攀椀瘀攀圀愀椀琀䴀椀渀甀琀攀猀崀 嬀椀渀琀崀 一唀䰀䰀 ) ON [PRIMARY]਀䜀伀 ALTER TABLE [dbo].[NotificationRecipients] ADD CONSTRAINT [DF_NotificationRecipients_GetMissingTags] DEFAULT ((0)) FOR [GetMissingTags]਀䜀伀 ALTER TABLE [dbo].[NotificationRecipients] ADD CONSTRAINT [DF_NotificationRecipients_GetMotionTags] DEFAULT ((0)) FOR [GetMotionTags]਀䜀伀 ALTER TABLE [dbo].[NotificationRecipients] ADD CONSTRAINT [DF_NotificationRecipients_GetSystemNotifications] DEFAULT ((0)) FOR [GetSystemNotifications]਀䜀伀