Self-Service: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Self-Service check list | Self-Service check list | ||
---- | ---- | ||
1. | 1. Registry | ||
2. Database | 2. Database | ||
3. | |||
---- | |||
--SQL to create the database | --SQL to create the database | ||
USE [master] | USE [master] | ||
GO | GO | ||
CREATE DATABASE [CRMSelfService] ON PRIMARY | CREATE DATABASE [CRMSelfService] ON PRIMARY | ||
( NAME = N'CRMSelfService', FILENAME = N'CRMSelfService.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) | ( NAME = N'CRMSelfService', FILENAME = N'CRMSelfService.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) | ||
| Line 16: | Line 23: | ||
( NAME = N'CRMSelfService_log', FILENAME = N'CRMSelfService_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) | ( NAME = N'CRMSelfService_log', FILENAME = N'CRMSelfService_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) | ||
GO | GO | ||
ALTER DATABASE [CRMSelfService] SET COMPATIBILITY_LEVEL = 100 | ALTER DATABASE [CRMSelfService] SET COMPATIBILITY_LEVEL = 100 | ||
GO | GO | ||
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) | IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) | ||
begin | begin | ||
| Line 23: | Line 32: | ||
end | end | ||
GO | GO | ||
ALTER DATABASE [CRMSelfService] SET ANSI_NULL_DEFAULT OFF | ALTER DATABASE [CRMSelfService] SET ANSI_NULL_DEFAULT OFF | ||
GO | GO | ||
ALTER DATABASE [CRMSelfService] SET ANSI_NULLS OFF | ALTER DATABASE [CRMSelfService] SET ANSI_NULLS OFF | ||
GO | GO | ||
ALTER DATABASE [CRMSelfService] SET ANSI_PADDING OFF | ALTER DATABASE [CRMSelfService] SET ANSI_PADDING OFF | ||
GO | GO | ||
ALTER DATABASE [CRMSelfService] SET ANSI_WARNINGS OFF | ALTER DATABASE [CRMSelfService] SET ANSI_WARNINGS OFF | ||
GO | GO | ||
SET ANSI_NULLS ON | SET ANSI_NULLS ON | ||
GO | GO | ||
SET QUOTED_IDENTIFIER ON | SET QUOTED_IDENTIFIER ON | ||
GO | GO | ||
CREATE TABLE [dbo].[Visitor]( | CREATE TABLE [dbo].[Visitor]( | ||
[Visi_VisitorId] [int] IDENTITY(1,1) NOT NULL, | [Visi_VisitorId] [int] IDENTITY(1,1) NOT NULL, | ||
| Line 74: | Line 90: | ||
) ON [PRIMARY] | ) ON [PRIMARY] | ||
GO | GO | ||
CREATE TABLE [dbo].[VisitorProfile]( | CREATE TABLE [dbo].[VisitorProfile]( | ||
[Prof_ProfileId] [int] IDENTITY(1,1) NOT NULL, | [Prof_ProfileId] [int] IDENTITY(1,1) NOT NULL, | ||
| Line 82: | Line 99: | ||
[Prof_UpdatedDate] [datetime] NULL | [Prof_UpdatedDate] [datetime] NULL | ||
) ON [PRIMARY] | ) ON [PRIMARY] | ||
GO | GO | ||
Revision as of 20:03, 11 December 2011
Self-Service check list
1. Registry
2. Database
3.
--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
