安装和配置Citrix 店面 1.2

采用 [ 主人]

创建数据库[ 思杰 -StoreFront]主
（NAME = N’MyApps’, FILENAME = N’C：\ Program Files \ 微软 SQL Server \ MSSQL10_50.SQL2008 \ MSSQL \ DATA \ 思杰 -StoreFront.mdf‘ , SIZE = 10240KB ,
MAXSIZE = UNLIMITED，FILEGROWTH = 10％）
登入
（NAME = N’MyApps_log’, FILENAME = N’C：\ Program Files \ 微软 SQL Server \ MSSQL10_50.SQL2008 \ MSSQL \ DATA \ 思杰 -StoreFront.ldf‘ , SIZE = 10240KB ,
最大大小= 2048GB，文件增长= 10％）
收集latin1_general_CI_AS_KS

如果（1 = FULLTEXTSERVICEPROPERTY（‘IsFullTextInstalled’))
开始
执行[ 思杰 -StoreFront]。[dbo]。[sp_fulltext_database] @action =‘enable’
结束

ALTER DATABASE [ 思杰 -StoreFront] SET ANSI_NULL_DEFAULT OFF
ALTER DATABASE [ 思杰 -StoreFront] SET ANSI_NULLS OFF
ALTER DATABASE [ 思杰 -StoreFront] SET ANSI_PADDING OFF
ALTER DATABASE [ 思杰 -StoreFront]设置ANSI_WARNINGS OFF
ALTER DATABASE [ 思杰 -StoreFront]关闭ARITHABORT
ALTER DATABASE [ 思杰 -StoreFront] SET AUTO_CLOSE OFF
ALTER DATABASE [ 思杰 -StoreFront] SET AUTO_CREATE_STATISTICS ON
ALTER DATABASE [ 思杰 -StoreFront] SET AUTO_SHRINK OFF
ALTER DATABASE [ 思杰 -StoreFront] SET AUTO_UPDATE_STATISTICS ON
ALTER DATABASE [ 思杰 -StoreFront] SET CURSOR_CLOSE_ON_COMMIT OFF
ALTER DATABASE [ 思杰 -StoreFront] SET CURSOR_DEFAULT
ALTER DATABASE [ 思杰 -StoreFront] SET CONCAT_NULL_YIELDS_NULL OFF
ALTER DATABASE [ 思杰 -StoreFront] SET NUMERIC_ROUNDABORT OFF
ALTER DATABASE [ 思杰 -StoreFront] SET QUOTED_IDENTIFIER OFF
ALTER DATABASE [ 思杰 -StoreFront] SET RECURSIVE_TRIGGERS OFF
ALTER DATABASE [ 思杰 -StoreFront] SET DISABLE_BROKER
ALTER DATABASE [ 思杰 -StoreFront] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
ALTER DATABASE [ 思杰 -StoreFront] SET DATE_CORRELATION_OPTIMIZATION OFF
ALTER DATABASE [ 思杰 -StoreFront]设置信任度关闭
ALTER DATABASE [ 思杰 -StoreFront] SET ALLOW_SNAPSHOT_ISOLATION OFF
ALTER DATABASE [ 思杰 -StoreFront]设置参数简单
ALTER DATABASE [ 思杰 -StoreFront] SET READ_COMMITTED_SNAPSHOT OFF
ALTER DATABASE [ 思杰 -StoreFront] SET HONOR_BROKER_PRIORITY OFF
ALTER DATABASE [ 思杰 -StoreFront] SET READ_WRITE
ALTER DATABASE [ 思杰 -StoreFront]完全恢复设置
ALTER DATABASE [ 思杰 -StoreFront] SET MULTI_USER
ALTER DATABASE [ 思杰 -StoreFront] SET PAGE_VERIFY NONE
ALTER DATABASE [ 思杰 -StoreFront] SET DB_CHAINING OFF

采用 [ 思杰 -StoreFront]

/ ******对象：表[dbo]。[用户] ****** /
设置ANSI_NULLS ON

设置QUOTED_IDENTIFIER ONCREATE TABLE [dbo]。[User]（
[id] [int] IDENTITY（1,1）NOT NULL，
[用户名] [nvarchar]（100）收集latin1_general_CS_AS_KS NOT NULL，
约束[PK_users]主键
(
[id] ASC
）（PAD_INDEX = OFF，STATISTICS_NORECOMPUTE = OFF，
IGNORE_DUP_KEY = OFF，ALLOW_ROW_LOCKS = ON，ALLOW_PAGE_LOCKS = OFF）
开启[PRIMARY] ) 开启[PRIMARY]

在[dbo]上创建唯一的非索引索引[username_idx]。[用户] (
[用户名] ASC
）（PAD_INDEX = OFF，STATISTICS_NORECOMPUTE = OFF，
SORT_IN_TEMPDB = OFF，IGNORE_DUP_KEY = OFF，DROP_EXISTING = OFF，
在线=关闭，ALLOW_ROW_LOCKS =打开，ALLOW_PAGE_LOCKS =关闭）
开启[PRIMARY]

/ ******对象：表[dbo]。[订阅] ****** /
设置ANSI_NULLS ON

将QUOTED_IDENTIFIER设置为ON

创建表[dbo]。[订阅]（
[id] [int] IDENTITY（1,1）NOT NULL，
[subscription_ref] [varchar]（32）收集latin1_general_CS_AS_KS NOT NULL，
[resource_id] [nvarchar]（400）收集latin1_general_CS_AS_KS NOT NULL，
[user_id] [int] NOT NULL，
[状态] [int]非空，
[元数据] [nvarchar]（max）NULL，
[secure_metadata] [nvarchar]（max）NULL，
约束[PK_subscriptions]主键
(
[id] ASC
）（PAD_INDEX = OFF，STATISTICS_NORECOMPUTE = OFF，
IGNORE_DUP_KEY = OFF，ALLOW_ROW_LOCKS = ON，ALLOW_PAGE_LOCKS = OFF）
开启[PRIMARY] ) 开启[PRIMARY]

创建唯一的非索引索引[subscription_ref_idx]
[dbo]。[订阅] (
[subscription_ref] ASC
）（PAD_INDEX = OFF，STATISTICS_NORECOMPUTE = OFF，
SORT_IN_TEMPDB = OFF，IGNORE_DUP_KEY = OFF，DROP_EXISTING = OFF，
在线=关闭，ALLOW_ROW_LOCKS =打开，ALLOW_PAGE_LOCKS =关闭）
开启[PRIMARY]

在[dbo]上创建NONCLUSTERED索引[user_resource_idx]。[订阅] (
[user_id] ASC，
[resource_id] ASC
）（PAD_INDEX = OFF，STATISTICS_NORECOMPUTE = OFF，
SORT_IN_TEMPDB = OFF，IGNORE_DUP_KEY = OFF，DROP_EXISTING = OFF，
在线=关闭，ALLOW_ROW_LOCKS =打开，ALLOW_PAGE_LOCKS =关闭）
开启[PRIMARY]

/ ******对象：默认[DF_subscriptions_status] ****** /
ALTER TABLE [dbo]。[订阅] 添加CONSTRAINT [DF_subscriptions_status] 默认（（0））为[状态]

/ ******对象：ForeignKey [FK_subscriptions_user_id] ****** /
ALTER TABLE [dbo]。[订阅] 带检查添加约束[FK_subscriptions_user_id] 外键（[user_id]）
参考[dbo]。[用户]（[id]）

ALTER TABLE [dbo]。[订阅] 检查约束[FK_subscriptions_user_id]

创建表[dbo]。[SchemaDetails]（
[major_version] [int] NOT NULL，
[minor_version] [int] NOT NULL，
[详细信息] [nvarchar]（最大）NULL
）在[PRIMARY]上

插入[dbo]。[SchemaDetails]（[major_version]，[minor_version]）
值（1、0）

采用 [ 主人] CREATE LOGIN [hobo \ RES-CitrixStoreFrontServers]来自WINDOWS；
更改登录[hobo \ RES-CitrixStoreFrontServers] WITH DEFAULT_DATABASE = [ 思杰 -StoreFront ];

采用 [ 思杰 -StoreFront] 创建用户[CitrixSubscriptionDBUsers]进行登录[hobo \ RES-CitrixStoreFrontServers ]; EXEC sp_addrolemember N’db_datawriter’, N’CitrixSubscriptionDBUsers’;
EXEC sp_addrolemember N’db_datareader’, N’CitrixSubscriptionDBUsers’;