/*
* Create Table News
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[News](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NOT NULL,
[date] [datetime] NOT NULL,
[content] [nvarchar](4000) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/*
* Create Table People
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[People]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[People](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[firstName] [nvarchar](64) NOT NULL,
[middleName] [nvarchar](64) NULL,
[lastName] [nvarchar](64) NOT NULL,
[title] [nvarchar](128) NULL,
[description] [nvarchar](2048) NULL,
[email] [nvarchar](256) NULL,
[phone] [nvarchar](64) NULL,
[fax] [nvarchar](64) NULL,
[streetAddress] [nvarchar](128) NULL,
[city] [nvarchar](128) NULL,
[state] [nvarchar](64) NULL,
[postalCode] [nvarchar](64) NULL,
[country] [nvarchar](64) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/*
* Create Table Category
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Category]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Category](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NULL,
[description] [nvarchar](2048) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[parentCategoryId] [nvarchar](32) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/*
* Create Table Item
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Item]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Item](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NOT NULL,
[description] [nvarchar](2048) NULL,
[price] [float] NULL,
[inStock] [bit] NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/*
* Create Table Testimonails
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Testimonials]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Testimonials](
[id] [nvarchar](32) NOT NULL,
[visible] [bit] NOT NULL,
[title] [nvarchar](256) NOT NULL,
[date] [datetime] NOT NULL,
[content] [nvarchar](1024) NULL,
[testifier] [nvarchar](256) NULL,
[testifierTitle] [nvarchar](256) NULL,
[testifierCompany] [nvarchar](256) NULL,
[imageUrl] [nvarchar](256) NULL,
[imageAltText] [nvarchar](256) NULL,
[displayOrder] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/*
* Create Table Categorization
* */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Categorization]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Categorization](
[itemId] [nvarchar](32) NOT NULL,
[parentCategoryId] [nvarchar](32) NOT NULL,
PRIMARY KEY CLUSTERED
(
[itemId] ASC,
[pare�
通用网站中小型企业网站 （143个子文件） 
Items.aspx 10KB About.aspx 9KB News.aspx 6KB ItemDetail.aspx 6KB Testimonials.aspx 5KB People.aspx 4KB Default.aspx 4KB Contact.aspx 4KB LegalNotice.aspx 4KB ClassDiagram.cd 406B web.config 2KB XmlCatalogProvider.cs 6KB SqlCatalogProvider.cs 6KB Person.cs 6KB Items.aspx.cs 4KB SqlNewsProvider.cs 4KB XmlPeopleProvider.cs 4KB SqlPeopleProvider.cs 3KB Testimonial.cs 3KB Messages.cs 3KB Util.cs 3KB Catalog.cs 2KB XmlNewsProvider.cs 2KB SmallBusinessDataProvidersSection.cs 2KB Item.cs 2KB SqlTestimonialProvider.cs 2KB NewsItem.cs 2KB XmlTestimonialProvider.cs 2KB Testimonials.cs 2KB Category.cs 2KB News.cs 2KB People.cs 1KB News.aspx.cs 1KB ProviderSettingsValidation.cs 1KB Testimonials.aspx.cs 894B People.aspx.cs 856B CatalogProvider.cs 484B MasterPage.master.cs 340B NewsProvider.cs 296B ItemDetail.aspx.cs 270B TestimonialProvider.cs 267B PeopleProvider.cs 245B LegalNotice.aspx.cs 153B Default.aspx.cs 66B Contact.aspx.cs 60B About.aspx.cs 59B css-content.css 12KB css-print.css 6KB
corp_blue_nav_bl.gif 416B corp_blue_nav_br.gif 405B corp_blue_nav_tl.gif 403B corp_blue_nav_tr.gif 396B corp_blue_nav_bg_l.gif 155B corp_blue_nav_bg_r.gif 155B t.gif 58B l.gif 58B corp_blue_arrow.gif 57B tplus.gif 55B lplus.gif 55B rplus.gif 55B plus.gif 55B rminus.gif 54B lminus.gif 54B tminus.gif 54B minus.gif 54B list-bullet-02.gif 54B list-bullet-01-link.gif 52B list-bullet-02-link.gif 52B list-bullet-01.gif 52B i.gif 51B arrow.gif 51B spacer.gif 43B Eula.htm 7KB
Welcome.html 112KB favicon.ico 1KB
item01.jpg 32KB item02.jpg 30KB news1.jpg 16KB news2.jpg 13KB photo-poster.jpg 12KB person-4.jpg 9KB home-photo-2.jpg 9KB person-5.jpg 8KB person-1.jpg 7KB person-2.jpg 7KB corp_blue_logo_home.jpg 7KB person-6.jpg 7KB news-2.jpg 7KB person-7.jpg 6KB person-3.jpg 6KB news.jpg 5KB cat03.jpg 5KB cat01.jpg 5KB home-photo-1.jpg 4KB home-photo-3.jpg 4KB cat07.jpg 4KB cat04.jpg 4KB cat05.jpg 4KB cat02.jpg 4KB cat08.jpg 4KB共 143 条
- 1
- 2
评论0