/*
* 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�
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
C#个人网站模板+sql数据库 (143个子文件)
Items.aspx 9KB
About.aspx 9KB
News.aspx 6KB
ItemDetail.aspx 6KB
Testimonials.aspx 5KB
People.aspx 4KB
Default.aspx 4KB
Contact.aspx 4KB
LegalNotice.aspx 4KB
web.config 2KB
XmlCatalogProvider.cs 6KB
SqlCatalogProvider.cs 6KB
Person.cs 6KB
Items.aspx.cs 5KB
SqlNewsProvider.cs 4KB
SqlPeopleProvider.cs 3KB
Testimonial.cs 3KB
Messages.cs 3KB
XmlPeopleProvider.cs 3KB
Util.cs 2KB
XmlNewsProvider.cs 2KB
Catalog.cs 2KB
SqlTestimonialProvider.cs 2KB
SmallBusinessDataProvidersSection.cs 2KB
NewsItem.cs 2KB
XmlTestimonialProvider.cs 2KB
Item.cs 2KB
Testimonials.cs 2KB
Category.cs 2KB
News.aspx.cs 2KB
News.cs 2KB
People.cs 1KB
ProviderSettingsValidation.cs 1KB
Testimonials.aspx.cs 1KB
People.aspx.cs 996B
CatalogProvider.cs 405B
NewsProvider.cs 307B
TestimonialProvider.cs 277B
PeopleProvider.cs 252B
MasterPage.master.cs 68B
LegalNotice.aspx.cs 63B
Default.aspx.cs 63B
ItemDetail.aspx.cs 62B
Contact.aspx.cs 60B
About.aspx.cs 57B
css-content.css 12KB
css-print.css 6KB
Thumbs.db 147KB
Thumbs.db 14KB
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
r.gif 58B
l.gif 58B
corp_blue_arrow.gif 57B
plus.gif 55B
rplus.gif 55B
tplus.gif 55B
lplus.gif 55B
list-bullet-02.gif 54B
minus.gif 54B
rminus.gif 54B
tminus.gif 54B
lminus.gif 54B
list-bullet-01-link.gif 52B
list-bullet-01.gif 52B
list-bullet-02-link.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
共 143 条
- 1
- 2
xie447824191
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
前往页