Self-Service

Self-Service check list

---

1. Registry

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\SelfService]

"SSDbDatabaseDriver"="MSSQL"

"SSDbEntDatabaseDriver"="MSSQL"

"SSDbDatabaseServer"="servername\\crmsqlexpress"

"SSDbUserName"="sa"

"SSDbEntDatabaseServer"="servername\\crmsqlexpress"

"SSDbEntUser"="sa"

"SSDbDatabaseName"="CRMSelfService"

"SSDbEntDatabaseName"="CRM"

"SSDbPassword"="password"

"SSDbEntPassword"="password"

2. Database

--SQL to create the database

USE [master] GO

CREATE DATABASE [CRMSelfService] ON PRIMARY ( NAME = N'CRMSelfService', FILENAME = N'CRMSelfService.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

LOG ON 

( NAME = N'CRMSelfService_log', FILENAME = N'CRMSelfService_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO

ALTER DATABASE [CRMSelfService] SET COMPATIBILITY_LEVEL = 100 GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [CRMSelfService].[dbo].[sp_fulltext_database] @action = 'enable' end GO

ALTER DATABASE [CRMSelfService] SET ANSI_NULL_DEFAULT OFF GO

ALTER DATABASE [CRMSelfService] SET ANSI_NULLS OFF GO

ALTER DATABASE [CRMSelfService] SET ANSI_PADDING OFF GO

ALTER DATABASE [CRMSelfService] SET ANSI_WARNINGS OFF GO

SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO

CREATE TABLE [dbo].[Visitor]( [Visi_VisitorId] [int] IDENTITY(1,1) NOT NULL, [Visi_VisitorKey] [nvarchar](50) NULL, [Visi_LogonId] [nvarchar](30) NULL, [Visi_Password] [nvarchar](12) NULL, [Visi_PersonId] [int] NULL, [Visi_CompanyId] [int] NULL, [Visi_IpAddress] [nvarchar](15) NULL, [Visi_Salutation] [nvarchar](10) NULL, [Visi_FirstName] [nvarchar](30) NULL, [Visi_LastName] [nvarchar](40) NULL, [Visi_MiddleName] [nvarchar](30) NULL, [Visi_Suffix] [nvarchar](20) NULL, [Visi_Gender] [nvarchar](6) NULL, [Visi_Title] [nvarchar](30) NULL, [Visi_TitleCode] [nvarchar](15) NULL, [Visi_CompanyName] [nvarchar](60) NULL, [Visi_PhoneCountryCode] [nvarchar](5) NULL, [Visi_PhoneAreaCode] [nvarchar](20) NULL, [Visi_PhoneNumber] [nvarchar](20) NULL, [Visi_FaxCountryCode] [nvarchar](5) NULL, [Visi_FaxAreaCode] [nvarchar](20) NULL, [Visi_FaxNumber] [nvarchar](20) NULL, [Visi_EmailAddress] [nvarchar](50) NULL, [Visi_Address1] [nvarchar](40) NULL, [Visi_Address2] [nvarchar](40) NULL, [Visi_Address3] [nvarchar](40) NULL, [Visi_Address4] [nvarchar](40) NULL, [Visi_Address5] [nvarchar](40) NULL, [Visi_City] [nvarchar](30) NULL, [Visi_State] [nvarchar](30) NULL, [Visi_Country] [nvarchar](30) NULL, [Visi_PostCode] [nvarchar](10) NULL, [Visi_Language] [nvarchar](5) NULL, [Visi_CreatedDate] [datetime] NULL, [Visi_UpdatedDate] [datetime] NULL, [visi_userid] [int] NULL ) ON [PRIMARY] GO

CREATE TABLE [dbo].[VisitorProfile]( [Prof_ProfileId] [int] IDENTITY(1,1) NOT NULL, [Prof_VisitorID] [int] NULL, [Prof_ProfileType] [nvarchar](30) NULL, [Prof_Details] [nvarchar](120) NULL, [Prof_CreatedDate] [datetime] NULL, [Prof_UpdatedDate] [datetime] NULL ) ON [PRIMARY]

GO