完全手册ASP.NETAjax实用开发详解(12-13)

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'BUILTIN\Administrators') CREATE USER [BUILTIN\Administrators] FOR LOGIN [BUILTIN\Administrators] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Address]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Address]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, [Address] [varchar](255) NULL, CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Mailbox]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Mailbox]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, CONSTRAINT [PK_Mailbox] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Mail]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Mail]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](200) NULL, [Body] [text] NULL, [FromAddress] [varchar](1000) NULL, [ToAddress] [varchar](1000) NULL, [CCAddress] [varchar](1000) NULL, [ISHtmlFormat] [bit] NULL, [CreateDate] [datetime] NULL, [Size] [int] NULL, [Status] [smallint] NULL, [MailboxID] [int] NULL, CONSTRAINT [PK_Mail] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Attachment]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Attachment]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](200) NULL, [Url] [varchar](255) NULL, [MailID] [int] NULL, CONSTRAINT [PK_Attachment] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Mail_Mailbox]') AND parent_object_id = OBJECT_ID(N'[dbo].[Mail]')) ALTER TABLE [dbo].[Mail] WITH CHECK ADD CONSTRAINT [FK_Mail_Mailbox] FOREIGN KEY([MailboxID]) REFERENCES [dbo].[Mailbox] ([ID]) GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Attachment_Mail]') AND parent_object_id = OBJECT_ID(N'[dbo].[Attachment]')) ALTER TABLE [dbo].[Attachment] WITH CHECK ADD CONSTRAINT [FK_Attachment_Mail] FOREIGN KEY([MailID]) REFERENCES [dbo].[Mail] ([ID])