/*
* 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�
没有合适的资源?快使用搜索试试~ 我知道了~
smallbusiness,微软推出的,基于.net平台的小型商业开源网站
共306个文件
jpg:84个
gif:48个
cs:41个
5星 · 超过95%的资源 需积分: 0 15 下载量 173 浏览量
2008-11-01
09:31:18
上传
评论
收藏 1.71MB RAR 举报
温馨提示
smallbusiness,微软推出的,基于.net平台的小型商业开源网站
资源推荐
资源详情
资源评论
收起资源包目录
smallbusiness,微软推出的,基于.net平台的小型商业开源网站 (306个子文件)
ReminderService.asmx 139B
Items.aspx 9KB
Items.aspx 9KB
About.aspx 9KB
About.aspx 9KB
News.aspx 6KB
News.aspx 6KB
ItemDetail.aspx 6KB
ItemDetail.aspx 6KB
Testimonials.aspx 5KB
Testimonials.aspx 5KB
People.aspx 4KB
People.aspx 4KB
Default.aspx 4KB
Default.aspx 4KB
Contact.aspx 4KB
Contact.aspx 4KB
LegalNotice.aspx 4KB
LegalNotice.aspx 4KB
CustomError.aspx 2KB
CustomError.aspx 1KB
web.config 8KB
Web.config 5KB
web.config 2KB
ReminderService.cs 13KB
ListReminderTypes.cs 8KB
XmlCatalogProvider.cs 6KB
SqlCatalogProvider.cs 6KB
ICustomizeReminderService.cs 6KB
Person.cs 6KB
Items.aspx.cs 4KB
SqlNewsProvider.cs 4KB
SqlPeopleProvider.cs 3KB
Testimonial.cs 3KB
Messages.cs 3KB
XmlPeopleProvider.cs 3KB
AssemblyInfo.cs 3KB
Util.cs 2KB
XmlNewsProvider.cs 2KB
Catalog.cs 2KB
CommonTypes.cs 2KB
SqlTestimonialProvider.cs 2KB
SmallBusinessDataProvidersSection.cs 2KB
NewsItem.cs 2KB
XmlTestimonialProvider.cs 2KB
Item.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
CustomError.aspx.cs 409B
CatalogProvider.cs 401B
MasterPage.master.cs 340B
NewsProvider.cs 307B
TestimonialProvider.cs 277B
ItemDetail.aspx.cs 270B
PeopleProvider.cs 252B
LegalNotice.aspx.cs 153B
Default.aspx.cs 66B
Contact.aspx.cs 60B
About.aspx.cs 59B
css-content.css 12KB
css-content.css 12KB
css-print.css 6KB
css-print.css 6KB
Thumbs.db 11KB
corp_blue_nav_bl.gif 416B
corp_blue_nav_bl.gif 416B
corp_blue_nav_br.gif 405B
corp_blue_nav_br.gif 405B
corp_blue_nav_tl.gif 403B
corp_blue_nav_tl.gif 403B
corp_blue_nav_tr.gif 396B
corp_blue_nav_tr.gif 396B
corp_blue_nav_bg_l.gif 155B
corp_blue_nav_bg_r.gif 155B
corp_blue_nav_bg_l.gif 155B
corp_blue_nav_bg_r.gif 155B
l.gif 58B
t.gif 58B
l.gif 58B
t.gif 58B
corp_blue_arrow.gif 57B
corp_blue_arrow.gif 57B
plus.gif 55B
tplus.gif 55B
lplus.gif 55B
rplus.gif 55B
plus.gif 55B
tplus.gif 55B
lplus.gif 55B
rplus.gif 55B
lminus.gif 54B
rminus.gif 54B
minus.gif 54B
tminus.gif 54B
共 306 条
- 1
- 2
- 3
- 4
资源评论
- xiazaiwansui2014-08-24这个是个好东西,比较适合用来学习
- Wdayear2012-11-19第二個文件cs中有所需內容
qgqchile
- 粉丝: 3
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Picasso_v3.1 2.ipa
- chromedriver-mac-arm64.zip
- 蓝zapro.apk
- chromedriver-linux64.zip
- UCAS研一深度学习实验-MNIST手写数字识别python源码+详细注释(高分项目)
- 基于Python和PyTorch框架完成的一个手写数字识别实验源码(带MINIST手写数字数据集)+详细注释(高分项目)
- 基于Matlab在MNIST数据集上利用CNN完成手写体数字识别任务,并实现单层CNN反向传播算法+源代码+文档说明(高分项目)
- NVIDIA驱动、CUDA和Pytorch及其依赖
- 基于SVM多特征融合的微表情识别python源码+项目说明+详细注释(高分课程设计)
- html动态爱心代码一(附源码)
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功