Self-Service

Self-Service check list

---

1. Regsitry

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

3.