/*=============================================================
SCRIPT HEADER

VERSION:   1.01.0001
DATE:      08-24-2007 15:12:07
SERVER:    212.227.60.167

	Tables:
		codefixerlp_tblPayment, codefixerlp_tblCategory, codefixerlp_tblConfig
		codefixerlp_tblEmailTemplate, codefixerlp_tblCategoryRoute, codefixerlp_tblLink
		codefixerlp_tblRating, codefixerlp_tblUser, codefixerlp_tblNews
		codefixerlp_tblReview, codefixerlp_tblEmail, codefixerlp_tblSchema
		codefixerlp_tblCustomPage


=============================================================*/

SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_WARNINGS ON
SET NOCOUNT ON
SET XACT_ABORT ON
GO

-- BEGINNING TRANSACTION STRUCTURE
PRINT 'Beginning transaction STRUCTURE'
BEGIN TRANSACTION _STRUCTURE_
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblReview
Print 'Create Table codefixerlp_tblReview'
GO
CREATE TABLE [codefixerlp_tblReview] (
		[fldID]              int NOT NULL IDENTITY(1, 1),
		[fldIDLink]          int NULL,
		[fldFirstName]       nvarchar(100) NULL,
		[fldLastName]        nvarchar(100) NULL,
		[fldBody]            ntext NULL,
		[fldIPAddress]       nvarchar(20) NULL,
		[fldActive]          bit NULL,
		[fldDateAdded]       datetime NULL,
		[fldIDType]          int NULL,
		[fldInfo]            nvarchar(255) NULL,
		[SSMA_TimeStamp]     timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblReview$PrimaryKey to codefixerlp_tblReview
Print 'Add Primary Key codefixerlp_tblReview$PrimaryKey to codefixerlp_tblReview'
GO
ALTER TABLE [codefixerlp_tblReview]
	ADD
	CONSTRAINT [codefixerlp_tblReview$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__22AA2996 to codefixerlp_tblReview
Print 'Add Default Constraint DF__codefixer__fldAc__22AA2996 to codefixerlp_tblReview'
GO
ALTER TABLE [codefixerlp_tblReview]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__22AA2996]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__239E4DCF to codefixerlp_tblReview
Print 'Add Default Constraint DF__codefixer__fldID__239E4DCF to codefixerlp_tblReview'
GO
ALTER TABLE [codefixerlp_tblReview]
	ADD
	CONSTRAINT [DF__codefixer__fldID__239E4DCF]
	DEFAULT ((0)) FOR [fldIDType]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldActive on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldActive on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldActive]
	ON [codefixerlp_tblReview] ([fldActive])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldDateAdded on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldDateAdded on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldDateAdded]
	ON [codefixerlp_tblReview] ([fldDateAdded])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldFirstName on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldFirstName on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldFirstName]
	ON [codefixerlp_tblReview] ([fldFirstName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldID on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldID on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldID]
	ON [codefixerlp_tblReview] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldIDLink on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldIDLink on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldIDLink]
	ON [codefixerlp_tblReview] ([fldIDLink])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldIPAddress on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldIPAddress on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldIPAddress]
	ON [codefixerlp_tblReview] ([fldIPAddress])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldLastName on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldLastName on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldLastName]
	ON [codefixerlp_tblReview] ([fldLastName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblReview$fldTypeID on codefixerlp_tblReview
Print 'Create Index codefixerlp_tblReview$fldTypeID on codefixerlp_tblReview'
GO
CREATE INDEX [codefixerlp_tblReview$fldTypeID]
	ON [codefixerlp_tblReview] ([fldIDType])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblNews
Print 'Create Table codefixerlp_tblNews'
GO
CREATE TABLE [codefixerlp_tblNews] (
		[fldID]                  int NOT NULL IDENTITY(1, 1),
		[fldTitle]               nvarchar(255) NULL,
		[fldBody]                ntext NULL,
		[fldRating]              float NULL,
		[fldNumberOfRatings]     int NULL,
		[fldActive]              bit NULL,
		[fldDateAdded]           datetime NULL,
		[SSMA_TimeStamp]         timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblNews$PrimaryKey to codefixerlp_tblNews
Print 'Add Primary Key codefixerlp_tblNews$PrimaryKey to codefixerlp_tblNews'
GO
ALTER TABLE [codefixerlp_tblNews]
	ADD
	CONSTRAINT [codefixerlp_tblNews$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__15502E78 to codefixerlp_tblNews
Print 'Add Default Constraint DF__codefixer__fldAc__15502E78 to codefixerlp_tblNews'
GO
ALTER TABLE [codefixerlp_tblNews]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__15502E78]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldNu__145C0A3F to codefixerlp_tblNews
Print 'Add Default Constraint DF__codefixer__fldNu__145C0A3F to codefixerlp_tblNews'
GO
ALTER TABLE [codefixerlp_tblNews]
	ADD
	CONSTRAINT [DF__codefixer__fldNu__145C0A3F]
	DEFAULT ((0)) FOR [fldNumberOfRatings]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldRa__1367E606 to codefixerlp_tblNews
Print 'Add Default Constraint DF__codefixer__fldRa__1367E606 to codefixerlp_tblNews'
GO
ALTER TABLE [codefixerlp_tblNews]
	ADD
	CONSTRAINT [DF__codefixer__fldRa__1367E606]
	DEFAULT ((0)) FOR [fldRating]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblNews$fldActive on codefixerlp_tblNews
Print 'Create Index codefixerlp_tblNews$fldActive on codefixerlp_tblNews'
GO
CREATE INDEX [codefixerlp_tblNews$fldActive]
	ON [codefixerlp_tblNews] ([fldActive])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblNews$fldDateAdded on codefixerlp_tblNews
Print 'Create Index codefixerlp_tblNews$fldDateAdded on codefixerlp_tblNews'
GO
CREATE INDEX [codefixerlp_tblNews$fldDateAdded]
	ON [codefixerlp_tblNews] ([fldDateAdded])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblNews$fldID on codefixerlp_tblNews
Print 'Create Index codefixerlp_tblNews$fldID on codefixerlp_tblNews'
GO
CREATE INDEX [codefixerlp_tblNews$fldID]
	ON [codefixerlp_tblNews] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblNews$fldNumberOfRatings on codefixerlp_tblNews
Print 'Create Index codefixerlp_tblNews$fldNumberOfRatings on codefixerlp_tblNews'
GO
CREATE INDEX [codefixerlp_tblNews$fldNumberOfRatings]
	ON [codefixerlp_tblNews] ([fldNumberOfRatings])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblNews$fldRating on codefixerlp_tblNews
Print 'Create Index codefixerlp_tblNews$fldRating on codefixerlp_tblNews'
GO
CREATE INDEX [codefixerlp_tblNews$fldRating]
	ON [codefixerlp_tblNews] ([fldRating])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblNews$fldTitle on codefixerlp_tblNews
Print 'Create Index codefixerlp_tblNews$fldTitle on codefixerlp_tblNews'
GO
CREATE INDEX [codefixerlp_tblNews$fldTitle]
	ON [codefixerlp_tblNews] ([fldTitle])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblUser
Print 'Create Table codefixerlp_tblUser'
GO
CREATE TABLE [codefixerlp_tblUser] (
		[fldID]              int NOT NULL IDENTITY(1, 1),
		[fldUsername]        nvarchar(50) NULL,
		[fldPassword]        nvarchar(50) NULL,
		[fldHandle]          nvarchar(50) NULL,
		[fldEmail]           nvarchar(255) NULL,
		[fldFirstName]       nvarchar(100) NULL,
		[fldLastName]        nvarchar(100) NULL,
		[fldWebSiteURL]      nvarchar(255) NULL,
		[fldWebSiteName]     nvarchar(255) NULL,
		[fldDateAdded]       datetime NULL,
		[fldActive]          bit NULL,
		[fldIDType]          int NULL,
		[SSMA_TimeStamp]     timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblUser$PrimaryKey to codefixerlp_tblUser
Print 'Add Primary Key codefixerlp_tblUser$PrimaryKey to codefixerlp_tblUser'
GO
ALTER TABLE [codefixerlp_tblUser]
	ADD
	CONSTRAINT [codefixerlp_tblUser$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__276EDEB3 to codefixerlp_tblUser
Print 'Add Default Constraint DF__codefixer__fldAc__276EDEB3 to codefixerlp_tblUser'
GO
ALTER TABLE [codefixerlp_tblUser]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__276EDEB3]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__286302EC to codefixerlp_tblUser
Print 'Add Default Constraint DF__codefixer__fldID__286302EC to codefixerlp_tblUser'
GO
ALTER TABLE [codefixerlp_tblUser]
	ADD
	CONSTRAINT [DF__codefixer__fldID__286302EC]
	DEFAULT ((0)) FOR [fldIDType]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblUser$fldID on codefixerlp_tblUser
Print 'Create Index codefixerlp_tblUser$fldID on codefixerlp_tblUser'
GO
CREATE INDEX [codefixerlp_tblUser$fldID]
	ON [codefixerlp_tblUser] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblCustomPage
Print 'Create Table codefixerlp_tblCustomPage'
GO
CREATE TABLE [codefixerlp_tblCustomPage] (
		[fldID]              int NOT NULL IDENTITY(1, 1),
		[fldMenuTitle]       nvarchar(20) NULL,
		[fldPageName]        nvarchar(255) NULL,
		[fldBody]            ntext NULL,
		[fldActive]          bit NULL,
		[fldPosition]        nvarchar(50) NULL,
		[SSMA_TimeStamp]     timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblCustomPage$PrimaryKey to codefixerlp_tblCustomPage
Print 'Add Primary Key codefixerlp_tblCustomPage$PrimaryKey to codefixerlp_tblCustomPage'
GO
ALTER TABLE [codefixerlp_tblCustomPage]
	ADD
	CONSTRAINT [codefixerlp_tblCustomPage$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__0519C6AF to codefixerlp_tblCustomPage
Print 'Add Default Constraint DF__codefixer__fldAc__0519C6AF to codefixerlp_tblCustomPage'
GO
ALTER TABLE [codefixerlp_tblCustomPage]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__0519C6AF]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCustomPage$fldActive on codefixerlp_tblCustomPage
Print 'Create Index codefixerlp_tblCustomPage$fldActive on codefixerlp_tblCustomPage'
GO
CREATE INDEX [codefixerlp_tblCustomPage$fldActive]
	ON [codefixerlp_tblCustomPage] ([fldActive])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCustomPage$fldID on codefixerlp_tblCustomPage
Print 'Create Index codefixerlp_tblCustomPage$fldID on codefixerlp_tblCustomPage'
GO
CREATE INDEX [codefixerlp_tblCustomPage$fldID]
	ON [codefixerlp_tblCustomPage] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCustomPage$fldMenuTitle on codefixerlp_tblCustomPage
Print 'Create Index codefixerlp_tblCustomPage$fldMenuTitle on codefixerlp_tblCustomPage'
GO
CREATE INDEX [codefixerlp_tblCustomPage$fldMenuTitle]
	ON [codefixerlp_tblCustomPage] ([fldMenuTitle])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCustomPage$fldPageName on codefixerlp_tblCustomPage
Print 'Create Index codefixerlp_tblCustomPage$fldPageName on codefixerlp_tblCustomPage'
GO
CREATE UNIQUE INDEX [codefixerlp_tblCustomPage$fldPageName]
	ON [codefixerlp_tblCustomPage] ([fldPageName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblSchema
Print 'Create Table codefixerlp_tblSchema'
GO
CREATE TABLE [codefixerlp_tblSchema] (
		[fldID]                 int NOT NULL IDENTITY(1, 1),
		[fldSchemaName]         nvarchar(50) NULL,
		[fldSchemaClass]        nvarchar(50) NULL,
		[fldSchemaView]         nvarchar(255) NULL,
		[fldResultsPerPage]     int NULL,
		[fldFieldsViewable]     nvarchar(50) NULL,
		[fldTitle]              nvarchar(50) NULL,
		[fldMessage]            nvarchar(50) NULL,
		[fldFormID]             nvarchar(50) NULL,
		[fldFormText]           nvarchar(50) NULL,
		[fldWidth]              nvarchar(50) NULL,
		[fldHeight]             nvarchar(50) NULL,
		[fldFieldID]            nvarchar(50) NULL,
		[fldFieldText]          nvarchar(50) NULL,
		[fldSchemaCategory]     nvarchar(50) NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblSchema$PrimaryKey to codefixerlp_tblSchema
Print 'Add Primary Key codefixerlp_tblSchema$PrimaryKey to codefixerlp_tblSchema'
GO
ALTER TABLE [codefixerlp_tblSchema]
	ADD
	CONSTRAINT [codefixerlp_tblSchema$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldRe__25869641 to codefixerlp_tblSchema
Print 'Add Default Constraint DF__codefixer__fldRe__25869641 to codefixerlp_tblSchema'
GO
ALTER TABLE [codefixerlp_tblSchema]
	ADD
	CONSTRAINT [DF__codefixer__fldRe__25869641]
	DEFAULT ((0)) FOR [fldResultsPerPage]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldFieldID on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldFieldID on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldFieldID]
	ON [codefixerlp_tblSchema] ([fldFieldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldFieldsViewable on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldFieldsViewable on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldFieldsViewable]
	ON [codefixerlp_tblSchema] ([fldFieldsViewable])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldFieldText on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldFieldText on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldFieldText]
	ON [codefixerlp_tblSchema] ([fldFieldText])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldFormID on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldFormID on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldFormID]
	ON [codefixerlp_tblSchema] ([fldFormID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldHeight on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldHeight on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldHeight]
	ON [codefixerlp_tblSchema] ([fldHeight])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldID on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldID on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldID]
	ON [codefixerlp_tblSchema] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldMessage on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldMessage on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldMessage]
	ON [codefixerlp_tblSchema] ([fldMessage])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldReturnFieldID on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldReturnFieldID on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldReturnFieldID]
	ON [codefixerlp_tblSchema] ([fldFormText])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldSchemaCategory on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldSchemaCategory on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldSchemaCategory]
	ON [codefixerlp_tblSchema] ([fldSchemaCategory])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldSchemaClass on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldSchemaClass on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldSchemaClass]
	ON [codefixerlp_tblSchema] ([fldSchemaClass])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldSchemaName on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldSchemaName on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldSchemaName]
	ON [codefixerlp_tblSchema] ([fldSchemaName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldSchemaView on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldSchemaView on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldSchemaView]
	ON [codefixerlp_tblSchema] ([fldSchemaView])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldTitle on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldTitle on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldTitle]
	ON [codefixerlp_tblSchema] ([fldTitle])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblSchema$fldWidth on codefixerlp_tblSchema
Print 'Create Index codefixerlp_tblSchema$fldWidth on codefixerlp_tblSchema'
GO
CREATE INDEX [codefixerlp_tblSchema$fldWidth]
	ON [codefixerlp_tblSchema] ([fldWidth])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblEmail
Print 'Create Table codefixerlp_tblEmail'
GO
CREATE TABLE [codefixerlp_tblEmail] (
		[fldID]                    int NOT NULL IDENTITY(1, 1),
		[fldEmailFrom]             nvarchar(255) NULL,
		[fldEmailTo]               nvarchar(255) NULL,
		[fldEmailCC]               ntext NULL,
		[fldEmailBCC]              ntext NULL,
		[fldEmailSubject]          nvarchar(255) NULL,
		[fldEmailBody]             ntext NULL,
		[fldEmailDateAdded]        datetime NULL,
		[fldEmailFormat]           nvarchar(50) NULL,
		[fldEmailIP]               nvarchar(50) NULL,
		[fldEmailSessionID]        nvarchar(50) NULL,
		[fldEmailTicket]           nvarchar(50) NULL,
		[fldEmailServerName]       nvarchar(255) NULL,
		[fldEmailComponent]        nvarchar(50) NULL,
		[fldEmailAuthUsername]     nvarchar(255) NULL,
		[fldEmailAuthPassword]     nvarchar(255) NULL,
		[SSMA_TimeStamp]           timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblEmail$PrimaryKey to codefixerlp_tblEmail
Print 'Add Primary Key codefixerlp_tblEmail$PrimaryKey to codefixerlp_tblEmail'
GO
ALTER TABLE [codefixerlp_tblEmail]
	ADD
	CONSTRAINT [codefixerlp_tblEmail$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmail$fldEmailSessionID on codefixerlp_tblEmail
Print 'Create Index codefixerlp_tblEmail$fldEmailSessionID on codefixerlp_tblEmail'
GO
CREATE INDEX [codefixerlp_tblEmail$fldEmailSessionID]
	ON [codefixerlp_tblEmail] ([fldEmailSessionID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmail$fldID on codefixerlp_tblEmail
Print 'Create Index codefixerlp_tblEmail$fldID on codefixerlp_tblEmail'
GO
CREATE INDEX [codefixerlp_tblEmail$fldID]
	ON [codefixerlp_tblEmail] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblRating
Print 'Create Table codefixerlp_tblRating'
GO
CREATE TABLE [codefixerlp_tblRating] (
		[fldID]              int NOT NULL IDENTITY(1, 1),
		[fldIDLink]          int NULL,
		[fldRating]          float NULL,
		[fldIPAddress]       nvarchar(20) NULL,
		[fldActive]          bit NULL,
		[fldDateAdded]       datetime NULL,
		[fldIDType]          int NULL,
		[SSMA_TimeStamp]     timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblRating$PrimaryKey to codefixerlp_tblRating
Print 'Add Primary Key codefixerlp_tblRating$PrimaryKey to codefixerlp_tblRating'
GO
ALTER TABLE [codefixerlp_tblRating]
	ADD
	CONSTRAINT [codefixerlp_tblRating$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__1FCDBCEB to codefixerlp_tblRating
Print 'Add Default Constraint DF__codefixer__fldAc__1FCDBCEB to codefixerlp_tblRating'
GO
ALTER TABLE [codefixerlp_tblRating]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__1FCDBCEB]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__20C1E124 to codefixerlp_tblRating
Print 'Add Default Constraint DF__codefixer__fldID__20C1E124 to codefixerlp_tblRating'
GO
ALTER TABLE [codefixerlp_tblRating]
	ADD
	CONSTRAINT [DF__codefixer__fldID__20C1E124]
	DEFAULT ((0)) FOR [fldIDType]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblRating$fldActive on codefixerlp_tblRating
Print 'Create Index codefixerlp_tblRating$fldActive on codefixerlp_tblRating'
GO
CREATE INDEX [codefixerlp_tblRating$fldActive]
	ON [codefixerlp_tblRating] ([fldActive])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblRating$fldDateAdded on codefixerlp_tblRating
Print 'Create Index codefixerlp_tblRating$fldDateAdded on codefixerlp_tblRating'
GO
CREATE INDEX [codefixerlp_tblRating$fldDateAdded]
	ON [codefixerlp_tblRating] ([fldDateAdded])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblRating$fldID on codefixerlp_tblRating
Print 'Create Index codefixerlp_tblRating$fldID on codefixerlp_tblRating'
GO
CREATE INDEX [codefixerlp_tblRating$fldID]
	ON [codefixerlp_tblRating] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblRating$fldIDLink on codefixerlp_tblRating
Print 'Create Index codefixerlp_tblRating$fldIDLink on codefixerlp_tblRating'
GO
CREATE INDEX [codefixerlp_tblRating$fldIDLink]
	ON [codefixerlp_tblRating] ([fldIDLink])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblRating$fldIPAddress on codefixerlp_tblRating
Print 'Create Index codefixerlp_tblRating$fldIPAddress on codefixerlp_tblRating'
GO
CREATE INDEX [codefixerlp_tblRating$fldIPAddress]
	ON [codefixerlp_tblRating] ([fldIPAddress])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblRating$fldRating on codefixerlp_tblRating
Print 'Create Index codefixerlp_tblRating$fldRating on codefixerlp_tblRating'
GO
CREATE INDEX [codefixerlp_tblRating$fldRating]
	ON [codefixerlp_tblRating] ([fldRating])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblRating$fldTypeID on codefixerlp_tblRating
Print 'Create Index codefixerlp_tblRating$fldTypeID on codefixerlp_tblRating'
GO
CREATE INDEX [codefixerlp_tblRating$fldTypeID]
	ON [codefixerlp_tblRating] ([fldIDType])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblConfig
Print 'Create Table codefixerlp_tblConfig'
GO
CREATE TABLE [codefixerlp_tblConfig] (
		[fldID]                     int NOT NULL IDENTITY(1, 1),
		[fldConfigName]             nvarchar(255) NULL,
		[fldConfigValue]            ntext NULL,
		[fldProtected]              bit NULL,
		[fldDataType]               nvarchar(50) NULL,
		[fldConfigDescription]      ntext NULL,
		[fldSystem]                 bit NULL,
		[fldRank]                   int NULL,
		[fldOption1Text]            ntext NULL,
		[fldOption1Value]           ntext NULL,
		[fldOption2Text]            ntext NULL,
		[fldOption2Value]           ntext NULL,
		[fldOption3Text]            ntext NULL,
		[fldOption3Value]           ntext NULL,
		[fldOption4Text]            ntext NULL,
		[fldOption4Value]           ntext NULL,
		[fldOption5Text]            ntext NULL,
		[fldOption5Value]           ntext NULL,
		[fldOption6Text]            ntext NULL,
		[fldOption6Value]           ntext NULL,
		[fldOption7Text]            ntext NULL,
		[fldOption7Value]           ntext NULL,
		[fldOption8Text]            ntext NULL,
		[fldOption8Value]           ntext NULL,
		[fldOption9Text]            ntext NULL,
		[fldOption9Value]           ntext NULL,
		[fldOption10Text]           ntext NULL,
		[fldOption10Value]          ntext NULL,
		[fldOtherAllowed]           bit NULL,
		[fldConfigFriendlyName]     nvarchar(255) NULL,
		[fldTextArea]               bit NULL,
		[fldIDType]                 int NULL,
		[SSMA_TimeStamp]            timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblConfig$PrimaryKey to codefixerlp_tblConfig
Print 'Add Primary Key codefixerlp_tblConfig$PrimaryKey to codefixerlp_tblConfig'
GO
ALTER TABLE [codefixerlp_tblConfig]
	ADD
	CONSTRAINT [codefixerlp_tblConfig$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__03317E3D to codefixerlp_tblConfig
Print 'Add Default Constraint DF__codefixer__fldID__03317E3D to codefixerlp_tblConfig'
GO
ALTER TABLE [codefixerlp_tblConfig]
	ADD
	CONSTRAINT [DF__codefixer__fldID__03317E3D]
	DEFAULT ((0)) FOR [fldIDType]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldOt__014935CB to codefixerlp_tblConfig
Print 'Add Default Constraint DF__codefixer__fldOt__014935CB to codefixerlp_tblConfig'
GO
ALTER TABLE [codefixerlp_tblConfig]
	ADD
	CONSTRAINT [DF__codefixer__fldOt__014935CB]
	DEFAULT ((0)) FOR [fldOtherAllowed]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldPr__7F60ED59 to codefixerlp_tblConfig
Print 'Add Default Constraint DF__codefixer__fldPr__7F60ED59 to codefixerlp_tblConfig'
GO
ALTER TABLE [codefixerlp_tblConfig]
	ADD
	CONSTRAINT [DF__codefixer__fldPr__7F60ED59]
	DEFAULT ((0)) FOR [fldProtected]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldSy__00551192 to codefixerlp_tblConfig
Print 'Add Default Constraint DF__codefixer__fldSy__00551192 to codefixerlp_tblConfig'
GO
ALTER TABLE [codefixerlp_tblConfig]
	ADD
	CONSTRAINT [DF__codefixer__fldSy__00551192]
	DEFAULT ((0)) FOR [fldSystem]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldTe__023D5A04 to codefixerlp_tblConfig
Print 'Add Default Constraint DF__codefixer__fldTe__023D5A04 to codefixerlp_tblConfig'
GO
ALTER TABLE [codefixerlp_tblConfig]
	ADD
	CONSTRAINT [DF__codefixer__fldTe__023D5A04]
	DEFAULT ((0)) FOR [fldTextArea]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldConfigFriendlyName on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldConfigFriendlyName on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldConfigFriendlyName]
	ON [codefixerlp_tblConfig] ([fldConfigFriendlyName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldConfigName on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldConfigName on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldConfigName]
	ON [codefixerlp_tblConfig] ([fldConfigName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldDataType on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldDataType on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldDataType]
	ON [codefixerlp_tblConfig] ([fldDataType])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldID on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldID on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldID]
	ON [codefixerlp_tblConfig] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldOtherAllowed on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldOtherAllowed on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldOtherAllowed]
	ON [codefixerlp_tblConfig] ([fldOtherAllowed])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldProtected on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldProtected on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldProtected]
	ON [codefixerlp_tblConfig] ([fldProtected])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldRank on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldRank on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldRank]
	ON [codefixerlp_tblConfig] ([fldRank])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldSystem on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldSystem on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldSystem]
	ON [codefixerlp_tblConfig] ([fldSystem])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblConfig$fldTextArea on codefixerlp_tblConfig
Print 'Create Index codefixerlp_tblConfig$fldTextArea on codefixerlp_tblConfig'
GO
CREATE INDEX [codefixerlp_tblConfig$fldTextArea]
	ON [codefixerlp_tblConfig] ([fldTextArea])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblCategory
Print 'Create Table codefixerlp_tblCategory'
GO
CREATE TABLE [codefixerlp_tblCategory] (
		[fldID]                      int NOT NULL IDENTITY(1, 1),
		[fldIDParent]                int NULL,
		[fldCategoryName]            nvarchar(50) NULL,
		[fldPageName]                nvarchar(255) NULL,
		[fldCategoryDescription]     ntext NULL,
		[fldDateAdded]               datetime NULL,
		[fldActive]                  bit NULL,
		[fldTitle]                   nvarchar(255) NULL,
		[fldKeywords]                nvarchar(255) NULL,
		[SSMA_TimeStamp]             timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblCategory$PrimaryKey to codefixerlp_tblCategory
Print 'Add Primary Key codefixerlp_tblCategory$PrimaryKey to codefixerlp_tblCategory'
GO
ALTER TABLE [codefixerlp_tblCategory]
	ADD
	CONSTRAINT [codefixerlp_tblCategory$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__7C8480AE to codefixerlp_tblCategory
Print 'Add Default Constraint DF__codefixer__fldAc__7C8480AE to codefixerlp_tblCategory'
GO
ALTER TABLE [codefixerlp_tblCategory]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__7C8480AE]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldActive on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldActive on codefixerlp_tblCategory'
GO
CREATE INDEX [codefixerlp_tblCategory$fldActive]
	ON [codefixerlp_tblCategory] ([fldActive])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldCategoryName on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldCategoryName on codefixerlp_tblCategory'
GO
CREATE INDEX [codefixerlp_tblCategory$fldCategoryName]
	ON [codefixerlp_tblCategory] ([fldCategoryName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldDateAdded on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldDateAdded on codefixerlp_tblCategory'
GO
CREATE INDEX [codefixerlp_tblCategory$fldDateAdded]
	ON [codefixerlp_tblCategory] ([fldDateAdded])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldID on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldID on codefixerlp_tblCategory'
GO
CREATE INDEX [codefixerlp_tblCategory$fldID]
	ON [codefixerlp_tblCategory] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldIDParent on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldIDParent on codefixerlp_tblCategory'
GO
CREATE INDEX [codefixerlp_tblCategory$fldIDParent]
	ON [codefixerlp_tblCategory] ([fldIDParent])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldKeywords on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldKeywords on codefixerlp_tblCategory'
GO
CREATE INDEX [codefixerlp_tblCategory$fldKeywords]
	ON [codefixerlp_tblCategory] ([fldKeywords])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldPageName on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldPageName on codefixerlp_tblCategory'
GO
CREATE UNIQUE INDEX [codefixerlp_tblCategory$fldPageName]
	ON [codefixerlp_tblCategory] ([fldPageName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategory$fldTitle on codefixerlp_tblCategory
Print 'Create Index codefixerlp_tblCategory$fldTitle on codefixerlp_tblCategory'
GO
CREATE INDEX [codefixerlp_tblCategory$fldTitle]
	ON [codefixerlp_tblCategory] ([fldTitle])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblPayment
Print 'Create Table codefixerlp_tblPayment'
GO
CREATE TABLE [codefixerlp_tblPayment] (
		[fldID]                           int NOT NULL IDENTITY(1, 1),
		[fldItemName]                     nvarchar(255) NULL,
		[fldItemNumber]                   nvarchar(50) NULL,
		[fldPaymentAmount]                float NULL,
		[fldPaymentCurrency]              nvarchar(50) NULL,
		[fldReceiverEmail]                nvarchar(50) NULL,
		[fldPayerEmail]                   nvarchar(50) NULL,
		[fldInvoice]                      nvarchar(255) NULL,
		[fldFirstName]                    nvarchar(50) NULL,
		[fldLastName]                     nvarchar(50) NULL,
		[fldAddress]                      nvarchar(50) NULL,
		[fldCity]                         nvarchar(50) NULL,
		[fldCounty]                       nvarchar(50) NULL,
		[fldPostCode]                     nvarchar(15) NULL,
		[fldCountry]                      nvarchar(50) NULL,
		[fldPhoneA]                       nvarchar(50) NULL,
		[fldPhoneB]                       nvarchar(50) NULL,
		[fldShipping]                     float NULL,
		[fldHandling]                     float NULL,
		[fldTax]                          float NULL,
		[fldPaymentStatus]                nvarchar(50) NULL,
		[fldTransactionID]                nvarchar(50) NULL,
		[fldTransactionDateTime]          datetime NULL,
		[fldSecurityKey]                  nvarchar(50) NULL,
		[fldGatewayStatus]                nvarchar(50) NULL,
		[fldIDType]                       int NULL,
		[fldIDOwner]                      int NULL,
		[fldIDTypeOwner]                  int NULL,
		[fldSessionID]                    nvarchar(50) NULL,
		[fldIP]                           nvarchar(50) NULL,
		[fldNotes]                        ntext NULL,
		[fldRecurringTimePeriod]          nvarchar(1) NULL,
		[fldRecurringTimePeriodUnit]      int NULL,
		[fldRecurringDateStart]           datetime NULL,
		[fldPaymentStatusDescription]     nvarchar(255) NULL,
		[fldRecurringDateEnd]             datetime NULL,
		[SSMA_TimeStamp]                  timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblPayment$PrimaryKey to codefixerlp_tblPayment
Print 'Add Primary Key codefixerlp_tblPayment$PrimaryKey to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [codefixerlp_tblPayment$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldHa__1920BF5C to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldHa__1920BF5C to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldHa__1920BF5C]
	DEFAULT ((0)) FOR [fldHandling]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__1B0907CE to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldID__1B0907CE to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldID__1B0907CE]
	DEFAULT ((0)) FOR [fldIDType]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__1BFD2C07 to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldID__1BFD2C07 to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldID__1BFD2C07]
	DEFAULT ((0)) FOR [fldIDOwner]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__1CF15040 to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldID__1CF15040 to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldID__1CF15040]
	DEFAULT ((0)) FOR [fldIDTypeOwner]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldPa__173876EA to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldPa__173876EA to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldPa__173876EA]
	DEFAULT ((0)) FOR [fldPaymentAmount]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldRe__1DE57479 to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldRe__1DE57479 to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldRe__1DE57479]
	DEFAULT ((0)) FOR [fldRecurringTimePeriodUnit]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldSh__182C9B23 to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldSh__182C9B23 to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldSh__182C9B23]
	DEFAULT ((0)) FOR [fldShipping]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldTa__1A14E395 to codefixerlp_tblPayment
Print 'Add Default Constraint DF__codefixer__fldTa__1A14E395 to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [DF__codefixer__fldTa__1A14E395]
	DEFAULT ((0)) FOR [fldTax]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldAddress on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldAddress on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldAddress]
	ON [codefixerlp_tblPayment] ([fldAddress])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldCity on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldCity on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldCity]
	ON [codefixerlp_tblPayment] ([fldCity])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldCountry on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldCountry on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldCountry]
	ON [codefixerlp_tblPayment] ([fldCountry])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldCounty on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldCounty on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldCounty]
	ON [codefixerlp_tblPayment] ([fldCounty])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldFirstName on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldFirstName on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldFirstName]
	ON [codefixerlp_tblPayment] ([fldFirstName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldGatewayStatus on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldGatewayStatus on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldGatewayStatus]
	ON [codefixerlp_tblPayment] ([fldGatewayStatus])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldID on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldID on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldID]
	ON [codefixerlp_tblPayment] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldIDOwner on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldIDOwner on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldIDOwner]
	ON [codefixerlp_tblPayment] ([fldIDOwner])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldIDType on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldIDType on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldIDType]
	ON [codefixerlp_tblPayment] ([fldIDType])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldIDTypeOwner on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldIDTypeOwner on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldIDTypeOwner]
	ON [codefixerlp_tblPayment] ([fldIDTypeOwner])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldInvoice on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldInvoice on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldInvoice]
	ON [codefixerlp_tblPayment] ([fldInvoice])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldItemName on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldItemName on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldItemName]
	ON [codefixerlp_tblPayment] ([fldItemName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldItemNumber on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldItemNumber on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldItemNumber]
	ON [codefixerlp_tblPayment] ([fldItemNumber])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldLastName on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldLastName on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldLastName]
	ON [codefixerlp_tblPayment] ([fldLastName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldPaymentAmount on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldPaymentAmount on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldPaymentAmount]
	ON [codefixerlp_tblPayment] ([fldPaymentAmount])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldPaymentCurrency on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldPaymentCurrency on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldPaymentCurrency]
	ON [codefixerlp_tblPayment] ([fldPaymentCurrency])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldPaymentStatus on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldPaymentStatus on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldPaymentStatus]
	ON [codefixerlp_tblPayment] ([fldPaymentStatus])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldPhoneA on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldPhoneA on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldPhoneA]
	ON [codefixerlp_tblPayment] ([fldPhoneA])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldPhoneB on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldPhoneB on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldPhoneB]
	ON [codefixerlp_tblPayment] ([fldPhoneB])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldPostCode on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldPostCode on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldPostCode]
	ON [codefixerlp_tblPayment] ([fldPostCode])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldReceiverEmail on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldReceiverEmail on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldReceiverEmail]
	ON [codefixerlp_tblPayment] ([fldReceiverEmail])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldSecurityKey on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldSecurityKey on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldSecurityKey]
	ON [codefixerlp_tblPayment] ([fldSecurityKey])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldSessionID on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldSessionID on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldSessionID]
	ON [codefixerlp_tblPayment] ([fldSessionID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldTransactionDateTime on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldTransactionDateTime on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldTransactionDateTime]
	ON [codefixerlp_tblPayment] ([fldTransactionDateTime])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldTransactionID on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldTransactionID on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldTransactionID]
	ON [codefixerlp_tblPayment] ([fldTransactionID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblPayment$fldTxnID on codefixerlp_tblPayment
Print 'Create Index codefixerlp_tblPayment$fldTxnID on codefixerlp_tblPayment'
GO
CREATE INDEX [codefixerlp_tblPayment$fldTxnID]
	ON [codefixerlp_tblPayment] ([fldPayerEmail])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblLink
Print 'Create Table codefixerlp_tblLink'
GO
CREATE TABLE [codefixerlp_tblLink] (
		[fldID]                  int NOT NULL IDENTITY(1, 1),
		[fldIDParent]            int NULL,
		[fldActive]              bit NULL,
		[fldFeatured]            bit NULL,
		[fldRating]              float NULL,
		[fldNumberOfRatings]     int NULL,
		[fldLinkName]            nvarchar(255) NULL,
		[fldURL]                 nvarchar(255) NULL,
		[fldReciprocalURL]       nvarchar(255) NULL,
		[fldLinkDescription]     ntext NULL,
		[fldContactName]         nvarchar(50) NULL,
		[fldContactEmail]        nvarchar(50) NULL,
		[fldLinkNotes]           ntext NULL,
		[fldDateAdded]           datetime NULL,
		[fldApproved]            bit NULL,
		[fldPageName]            nvarchar(255) NULL,
		[fldIDType]              int NULL,
		[fldPaymentItemName]     nvarchar(50) NULL,
		[fldImageURL]            nvarchar(255) NULL,
		[fldAddress]             nvarchar(50) NULL,
		[fldTown]                nvarchar(50) NULL,
		[fldCounty]              nvarchar(50) NULL,
		[fldPostCode]            nvarchar(15) NULL,
		[fldCountry]             nvarchar(50) NULL,
		[fldPhone]               nvarchar(50) NULL,
		[fldURLMap]              nvarchar(255) NULL,
		[fldCustomContent]       ntext NULL,
		[fldClickThrough]        int NULL,
		[fldImageURLb]           nvarchar(255) NULL,
		[fldImageURLc]           nvarchar(255) NULL,
		[fldHits]                int NULL,
		[fldIDUser]              int NULL,
		[fldKeywords]            nvarchar(50) NULL,
		[SSMA_TimeStamp]         timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblLink$PrimaryKey to codefixerlp_tblLink
Print 'Add Primary Key codefixerlp_tblLink$PrimaryKey to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [codefixerlp_tblLink$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__0BC6C43E to codefixerlp_tblLink
Print 'Add Default Constraint DF__codefixer__fldAc__0BC6C43E to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__0BC6C43E]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAp__0DAF0CB0 to codefixerlp_tblLink
Print 'Add Default Constraint DF__codefixer__fldAp__0DAF0CB0 to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [DF__codefixer__fldAp__0DAF0CB0]
	DEFAULT ((0)) FOR [fldApproved]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldCl__0F975522 to codefixerlp_tblLink
Print 'Add Default Constraint DF__codefixer__fldCl__0F975522 to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [DF__codefixer__fldCl__0F975522]
	DEFAULT ((0)) FOR [fldClickThrough]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldFe__0CBAE877 to codefixerlp_tblLink
Print 'Add Default Constraint DF__codefixer__fldFe__0CBAE877 to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [DF__codefixer__fldFe__0CBAE877]
	DEFAULT ((0)) FOR [fldFeatured]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldHi__108B795B to codefixerlp_tblLink
Print 'Add Default Constraint DF__codefixer__fldHi__108B795B to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [DF__codefixer__fldHi__108B795B]
	DEFAULT ((0)) FOR [fldHits]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__0EA330E9 to codefixerlp_tblLink
Print 'Add Default Constraint DF__codefixer__fldID__0EA330E9 to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [DF__codefixer__fldID__0EA330E9]
	DEFAULT ((0)) FOR [fldIDType]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldID__117F9D94 to codefixerlp_tblLink
Print 'Add Default Constraint DF__codefixer__fldID__117F9D94 to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [DF__codefixer__fldID__117F9D94]
	DEFAULT ((0)) FOR [fldIDUser]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldActive on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldActive on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldActive]
	ON [codefixerlp_tblLink] ([fldActive])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldAddress on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldAddress on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldAddress]
	ON [codefixerlp_tblLink] ([fldAddress])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldApproved on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldApproved on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldApproved]
	ON [codefixerlp_tblLink] ([fldApproved])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldContactEmail on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldContactEmail on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldContactEmail]
	ON [codefixerlp_tblLink] ([fldContactEmail])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldContactName on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldContactName on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldContactName]
	ON [codefixerlp_tblLink] ([fldContactName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldCountry on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldCountry on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldCountry]
	ON [codefixerlp_tblLink] ([fldCountry])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldCounty on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldCounty on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldCounty]
	ON [codefixerlp_tblLink] ([fldCounty])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldDateAdded on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldDateAdded on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldDateAdded]
	ON [codefixerlp_tblLink] ([fldDateAdded])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldFeatured on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldFeatured on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldFeatured]
	ON [codefixerlp_tblLink] ([fldFeatured])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldGraphicURL on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldGraphicURL on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldGraphicURL]
	ON [codefixerlp_tblLink] ([fldImageURL])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldID on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldID on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldID]
	ON [codefixerlp_tblLink] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldIDParent on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldIDParent on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldIDParent]
	ON [codefixerlp_tblLink] ([fldIDParent])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldIDType on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldIDType on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldIDType]
	ON [codefixerlp_tblLink] ([fldIDType])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldLinkName on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldLinkName on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldLinkName]
	ON [codefixerlp_tblLink] ([fldLinkName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldNumberOfRatings on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldNumberOfRatings on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldNumberOfRatings]
	ON [codefixerlp_tblLink] ([fldNumberOfRatings])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldPageName on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldPageName on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldPageName]
	ON [codefixerlp_tblLink] ([fldPageName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldPaymentItemName on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldPaymentItemName on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldPaymentItemName]
	ON [codefixerlp_tblLink] ([fldPaymentItemName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldPostCode on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldPostCode on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldPostCode]
	ON [codefixerlp_tblLink] ([fldPostCode])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldRating on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldRating on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldRating]
	ON [codefixerlp_tblLink] ([fldRating])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldReciprocalURL on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldReciprocalURL on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldReciprocalURL]
	ON [codefixerlp_tblLink] ([fldReciprocalURL])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldTown on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldTown on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldTown]
	ON [codefixerlp_tblLink] ([fldTown])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblLink$fldURL on codefixerlp_tblLink
Print 'Create Index codefixerlp_tblLink$fldURL on codefixerlp_tblLink'
GO
CREATE INDEX [codefixerlp_tblLink$fldURL]
	ON [codefixerlp_tblLink] ([fldURL])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblCategoryRoute
Print 'Create Table codefixerlp_tblCategoryRoute'
GO
CREATE TABLE [codefixerlp_tblCategoryRoute] (
		[fldID]              int NOT NULL IDENTITY(1, 1),
		[fldIDCat]           int NULL,
		[fldIDCatParent]     int NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblCategoryRoute$PrimaryKey to codefixerlp_tblCategoryRoute
Print 'Add Primary Key codefixerlp_tblCategoryRoute$PrimaryKey to codefixerlp_tblCategoryRoute'
GO
ALTER TABLE [codefixerlp_tblCategoryRoute]
	ADD
	CONSTRAINT [codefixerlp_tblCategoryRoute$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategoryRoute$fldID on codefixerlp_tblCategoryRoute
Print 'Create Index codefixerlp_tblCategoryRoute$fldID on codefixerlp_tblCategoryRoute'
GO
CREATE INDEX [codefixerlp_tblCategoryRoute$fldID]
	ON [codefixerlp_tblCategoryRoute] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategoryRoute$fldIDCat on codefixerlp_tblCategoryRoute
Print 'Create Index codefixerlp_tblCategoryRoute$fldIDCat on codefixerlp_tblCategoryRoute'
GO
CREATE INDEX [codefixerlp_tblCategoryRoute$fldIDCat]
	ON [codefixerlp_tblCategoryRoute] ([fldIDCat])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblCategoryRoute$fldIDCatParent on codefixerlp_tblCategoryRoute
Print 'Create Index codefixerlp_tblCategoryRoute$fldIDCatParent on codefixerlp_tblCategoryRoute'
GO
CREATE INDEX [codefixerlp_tblCategoryRoute$fldIDCatParent]
	ON [codefixerlp_tblCategoryRoute] ([fldIDCatParent])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Table codefixerlp_tblEmailTemplate
Print 'Create Table codefixerlp_tblEmailTemplate'
GO
CREATE TABLE [codefixerlp_tblEmailTemplate] (
		[fldID]                    int NOT NULL IDENTITY(1, 1),
		[fldTemplateName]          nvarchar(255) NULL,
		[fldHeader]                ntext NULL,
		[fldContent]               ntext NULL,
		[fldFooter]                ntext NULL,
		[fldDateAdded]             datetime NULL,
		[fldTypeEmailTemplate]     nvarchar(50) NULL,
		[fldActive]                bit NULL,
		[fldSystem]                bit NULL,
		[fldProtected]             bit NULL,
		[fldSubject]               nvarchar(255) NULL,
		[SSMA_TimeStamp]           timestamp NOT NULL
)
ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Primary Key codefixerlp_tblEmailTemplate$PrimaryKey to codefixerlp_tblEmailTemplate
Print 'Add Primary Key codefixerlp_tblEmailTemplate$PrimaryKey to codefixerlp_tblEmailTemplate'
GO
ALTER TABLE [codefixerlp_tblEmailTemplate]
	ADD
	CONSTRAINT [codefixerlp_tblEmailTemplate$PrimaryKey]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldAc__07F6335A to codefixerlp_tblEmailTemplate
Print 'Add Default Constraint DF__codefixer__fldAc__07F6335A to codefixerlp_tblEmailTemplate'
GO
ALTER TABLE [codefixerlp_tblEmailTemplate]
	ADD
	CONSTRAINT [DF__codefixer__fldAc__07F6335A]
	DEFAULT ((0)) FOR [fldActive]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldPr__09DE7BCC to codefixerlp_tblEmailTemplate
Print 'Add Default Constraint DF__codefixer__fldPr__09DE7BCC to codefixerlp_tblEmailTemplate'
GO
ALTER TABLE [codefixerlp_tblEmailTemplate]
	ADD
	CONSTRAINT [DF__codefixer__fldPr__09DE7BCC]
	DEFAULT ((0)) FOR [fldProtected]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Add Default Constraint DF__codefixer__fldSy__08EA5793 to codefixerlp_tblEmailTemplate
Print 'Add Default Constraint DF__codefixer__fldSy__08EA5793 to codefixerlp_tblEmailTemplate'
GO
ALTER TABLE [codefixerlp_tblEmailTemplate]
	ADD
	CONSTRAINT [DF__codefixer__fldSy__08EA5793]
	DEFAULT ((0)) FOR [fldSystem]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldActive on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldActive on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldActive]
	ON [codefixerlp_tblEmailTemplate] ([fldActive])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldDateAdded on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldDateAdded on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldDateAdded]
	ON [codefixerlp_tblEmailTemplate] ([fldDateAdded])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldID on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldID on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldID]
	ON [codefixerlp_tblEmailTemplate] ([fldID])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldProtected on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldProtected on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldProtected]
	ON [codefixerlp_tblEmailTemplate] ([fldProtected])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldSubject on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldSubject on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldSubject]
	ON [codefixerlp_tblEmailTemplate] ([fldSubject])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldSystem on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldSystem on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldSystem]
	ON [codefixerlp_tblEmailTemplate] ([fldSystem])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldTemplateName on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldTemplateName on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldTemplateName]
	ON [codefixerlp_tblEmailTemplate] ([fldTemplateName])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
-- Create Index codefixerlp_tblEmailTemplate$fldTypeEmailTemplate on codefixerlp_tblEmailTemplate
Print 'Create Index codefixerlp_tblEmailTemplate$fldTypeEmailTemplate on codefixerlp_tblEmailTemplate'
GO
CREATE INDEX [codefixerlp_tblEmailTemplate$fldTypeEmailTemplate]
	ON [codefixerlp_tblEmailTemplate] ([fldTypeEmailTemplate])
	ON [PRIMARY]
GO

IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

-- COMMITTING TRANSACTION STRUCTURE
PRINT 'Committing transaction STRUCTURE'
IF @@TRANCOUNT>0
	COMMIT TRANSACTION _STRUCTURE_
GO

SET NOEXEC OFF
GO
-- BEGINNING TRANSACTION DATA
PRINT 'Beginning transaction DATA'
BEGIN TRANSACTION _DATA_
GO

SET NOCOUNT ON
GO

-- Deleting from table: codefixerlp_tblPayment
PRINT 'Deleting from table: codefixerlp_tblPayment'
DELETE FROM [codefixerlp_tblPayment]
-- Deleting from table: codefixerlp_tblCategory
PRINT 'Deleting from table: codefixerlp_tblCategory'
DELETE FROM [codefixerlp_tblCategory]
-- Deleting from table: codefixerlp_tblConfig
PRINT 'Deleting from table: codefixerlp_tblConfig'
DELETE FROM [codefixerlp_tblConfig]
-- Deleting from table: codefixerlp_tblEmailTemplate
PRINT 'Deleting from table: codefixerlp_tblEmailTemplate'
DELETE FROM [codefixerlp_tblEmailTemplate]
-- Deleting from table: codefixerlp_tblCategoryRoute
PRINT 'Deleting from table: codefixerlp_tblCategoryRoute'
DELETE FROM [codefixerlp_tblCategoryRoute]
-- Deleting from table: codefixerlp_tblRating
PRINT 'Deleting from table: codefixerlp_tblRating'
DELETE FROM [codefixerlp_tblRating]
-- Deleting from table: codefixerlp_tblUser
PRINT 'Deleting from table: codefixerlp_tblUser'
DELETE FROM [codefixerlp_tblUser]
-- Deleting from table: codefixerlp_tblNews
PRINT 'Deleting from table: codefixerlp_tblNews'
DELETE FROM [codefixerlp_tblNews]
-- Deleting from table: codefixerlp_tblLink
PRINT 'Deleting from table: codefixerlp_tblLink'
DELETE FROM [codefixerlp_tblLink]
-- Deleting from table: codefixerlp_tblReview
PRINT 'Deleting from table: codefixerlp_tblReview'
DELETE FROM [codefixerlp_tblReview]
-- Deleting from table: codefixerlp_tblSchema
PRINT 'Deleting from table: codefixerlp_tblSchema'
DELETE FROM [codefixerlp_tblSchema]
-- Deleting from table: codefixerlp_tblCustomPage
PRINT 'Deleting from table: codefixerlp_tblCustomPage'
DELETE FROM [codefixerlp_tblCustomPage]
-- Deleting from table: codefixerlp_tblEmail
PRINT 'Deleting from table: codefixerlp_tblEmail'
DELETE FROM [codefixerlp_tblEmail]

-- No rows are in codefixerlp_tblReview
PRINT 'No rows are in codefixerlp_tblReview'
-- No rows are in codefixerlp_tblLink
PRINT 'No rows are in codefixerlp_tblLink'
-- No rows are in codefixerlp_tblNews
PRINT 'No rows are in codefixerlp_tblNews'
-- No rows are in codefixerlp_tblEmail
PRINT 'No rows are in codefixerlp_tblEmail'
-- No rows are in codefixerlp_tblCustomPage
PRINT 'No rows are in codefixerlp_tblCustomPage'
-- Insert scripts for table: codefixerlp_tblSchema
PRINT 'Inserting rows into table: codefixerlp_tblSchema'
SET IDENTITY_INSERT [codefixerlp_tblSchema] ON

INSERT INTO [codefixerlp_tblSchema] ([fldID], [fldSchemaName], [fldSchemaClass], [fldSchemaView], [fldResultsPerPage], [fldFieldsViewable], [fldTitle], [fldMessage], [fldFormID], [fldFormText], [fldWidth], [fldHeight], [fldFieldID], [fldFieldText], [fldSchemaCategory]) VALUES (1, N'News', N'cNews', N'Default', 20, N'Title', N'News', N'News Title', N'crating_fldidlink', N'text_crating_fldidlink', N'400', N'500', N'ID', N'Title', N'Search')
INSERT INTO [codefixerlp_tblSchema] ([fldID], [fldSchemaName], [fldSchemaClass], [fldSchemaView], [fldResultsPerPage], [fldFieldsViewable], [fldTitle], [fldMessage], [fldFormID], [fldFormText], [fldWidth], [fldHeight], [fldFieldID], [fldFieldText], [fldSchemaCategory]) VALUES (2, N'Submission', N'cLink', N'Default', 20, N'LinkName', N'Links', N'Link Title &amp; Link Description', N'crating_fldidlink', N'text_crating_fldidlink', N'400', N'500', N'ID', N'LinkName', N'Search')

SET IDENTITY_INSERT [codefixerlp_tblSchema] OFF

-- No rows are in codefixerlp_tblUser
PRINT 'No rows are in codefixerlp_tblUser'
-- Insert scripts for table: codefixerlp_tblConfig
PRINT 'Inserting rows into table: codefixerlp_tblConfig'
SET IDENTITY_INSERT [codefixerlp_tblConfig] ON

-- Warning - TIMESTAMP datatype not supported for Insert scripts
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (39, N'URL_Categories', N'', 1, N'string', N'Fully qualified url to the categories directory of the links pro application.
This is often the root url of your site + linkspro subdirectory + ''/categories''

Or more simply it is the value you have just placed in URL_SiteRoot + ''/categories''

e.g. http://www.mysite.com/linkspro/categories

Do NOT add a / to the end', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Category URL Directory', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (40, N'FOLDER_Install', N'', 1, N'string', N'This is the directory of your site in which links pro application is installed. Usually a subdirectory of the root of the site.

e.g. linkspro

Do NOT add a /  to the beginning or end', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Install Folder', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (41, N'PATH_Site', N'', 1, N'string', N'The full hard drive path to the linkspro directory on your web server.

e.g. c:\inetpub\wwwroot\mysite\linkspro

Do NOT add a \ to the end', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Path to Site Root', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (42, N'PATH_Categories', N'', 1, N'string', N'Full hard drive path to the links pro categories directory.
This is often the root path of your site + linkspro subdirectory + ''\categories''. 

Or more simply it is the value you have just placed in PATH_SiteRoot + ''\categories''

e.g. c:\inetpub\wwwroot\linkspro\categories

Do NOT add a \ to the end', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Path to Categories', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (43, N'DescriptionLength', N'', 1, N'long', N'Maximum characters allowed to describe a link or category.', 0, 17, N'250', N'250', N'500', N'500', N'750', N'750', N'1000', N'1000', N'1500', N'1500', N'2000', N'2000', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Description Length', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (44, N'PageSuffix', N'', 1, N'string', N'Page Suffix', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Page Suffix', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (45, N'BannerImage', N'', 1, N'string', N'Filename of the main site banner image, found at the top of all pages. 

If you wish to use a custom image/header, place this file in the ''images'' subdirectory of your linkspro site and reference the filename here (without directory/path information).

Example banners are included via the dr0p down, to allow you to easily get going with some popular uses for this web application.

Please contact sales@codefixer.com for a custom banner or total reskin of your site. We will happilly quote you at our reduced development rate for modifications on the linkspro product.', 0, 15, N'LinksPro Ultimate', N'Header-LinksProUltimate.jpg', N'DVD Link Directory', N'Header-DVDLinks.jpg', N'Hosting Business Directory', N'Header-HostingDirectory.jpg', N'Recipe Link Directory', N'Header-RecipeLinks.jpg', N'LinksPro Basic', N'linksPro_468x60.gif', N'Car Sales Directory', N'Header-CarDirectory.jpg', N'Tourism Directory', N'Header-TourismDirectory.jpg', N'', N'', N'', N'', N'', N'', 1, N'Banner Image', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (46, N'BannerAltTag', N'', 1, N'string', N'Text description/title of the main site image. This will be visible if there is a problem loading the image, and also when your mouse hovers over it.', 0, 15, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Banner Alt Tag', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (50, N'AutomaticApproval', N'', 1, N'boolean', N'Do you want to authorize new links on your site prior to them being available to the public?

If you do set to False, to keep the system fully automated with no need for yourself to be bothered, set to True.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Automatic Approve Links', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (51, N'NotifyAdministrator', N'', 1, N'boolean', N'Do you want to be notified of new links, ratings and reviews, or happy to let the system govern itself?

Set to False if you don''t want notifications by email.', 1, 9, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Email Notify Administrator', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (52, N'META_SiteTitle', N'', 1, N'string', N'Title of this site, that appears in the browsers top bar and also SEO / META Keywords.', 0, 12, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Site Title', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (53, N'EmailServerName', N'', 1, N'string', N'The SMTP server name of your mail server allowing sending of mails from the system. This is usually from your ISP, a se1ection of common isp settings are available above, you can also enter in a custom one if different.', 0, 4, N'BT Internet', N'mail.btinternet.com', N'Demon', N'post.demon.co.uk', N'Hotmail', N'mail.hotmail.com', N'Yahoo', N'smtp.mail.yahoo.com', N'Gmail', N'smtp.gmail.com', N'AOL', N'smtp.aol.com', N'AT&T broadband USA', N'mail.attbi.com', N'Comcast USA', N'smtp.comcast.net', N'Gateway.net USA', N'smtp.Gateway.net', N'Netcom USA', N'smtp.ix.netcom.com', 1, N'Email Server SMTP', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (54, N'EmailComponent', N'', 1, N'string', N'Three different email components exist to enable the sending of mail. These are based on your host/servers particular settings

CDOSYS - Modern Standard, Windows 2003+
CDONTS - Windows 2000 and below
ASPMAIL - 3rd party mail component used by many ISP''s (do not confuse with Persists ASPEmail component) 

We recommended CDOSYS, but please do experiment if you have problems.', 0, 5, N'CDOSYS', N'CDOSYS', N'CDONTS', N'CDONTS', N'ASPMAIL', N'ASPMAIL', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Email Component', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (55, N'DaysForNewListing', N'', 1, N'long', N'Activates the "NEW" graphic next to categories and links, if a link is added within the amount of days specified above.

If value is set to 14 for instance, then the new flag will be next to a particular link for upto 14 days from when first added.', 0, 17, N'1', N'1', N'2', N'2', N'7', N'7', N'14', N'14', N'21', N'21', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Days For New Listing', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (56, N'ResultsMaxLatestLinks', N'', 1, N'long', N'Total amount of latest links you wish to show, usually kept small as latest links are shown on the homepage.', 0, 16, N'3', N'3', N'5', N'5', N'10', N'10', N'20', N'20', N'50', N'50', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Latest Links Results Top', 0, 7)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (57, N'CSS_TableBackgroundColor', N'', 1, N'string', N'Background color of tables/main body of site.

You can use named colours like blue or red or a hex value, please do put the # in if using the latter

e.g. #EFEFEF', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Content Background', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (58, N'CSS_TableEdgeColor', N'', 1, N'string', N'Color of the outlines around tables and site sections.

You can use named colors like blue or red or a hex value, please do put the # in if using the latter

e.g. #333333', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Content Border', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (59, N'CSS_BackgroundColor', N'', 1, N'string', N'Background color of site, that highlights the central body/content.

You can use named colors like blue or red or a hex value, please do put the # in if using the latter

e.g. #EFEFEF', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Site Background', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (60, N'LOGIN_AdminUsername', N'', 1, N'string', N'Username used to access the admin/back-end', 0, 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Admin Username', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (61, N'LOGIN_AdminPassword', N'', 1, N'string', N'Password used to access the admin/back-end', 0, 2, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Admin Password', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (62, N'URL_SiteRoot', N'', 1, N'string', N'Fully qualified url to the root of the links pro application.
This is often the root url of your site + linkspro subdirectory

e.g. http://www.mysite.com/linkspro

Do NOT add a / to the end', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Site URL', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (63, N'CSS_TableWidth', N'', 1, N'long', N'Width of main body of site in pixels. Numeric values only please do not put px suffix.', 0, 11, N'775', N'775', N'1014', N'1014', N'1270', N'1270', N'1590', N'1590', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Content Width', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (64, N'META_SiteDescription', N'', 1, N'string', N'Full Default Description of the this site, used for SEO / META Tags.', 0, 13, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Site Description', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (65, N'META_SiteKeywords', N'', 1, N'string', N'Default Keywords describing this site, used for SEO / META Tags.', 0, 14, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Site Keywords', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (66, N'ResultsPerPage', N'', 1, N'long', N'How many links/items will be displayed per page.', 0, 16, N'5', N'5', N'10', N'10', N'25', N'25', N'50', N'50', N'100', N'100', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Results Per Page', 0, 7)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (67, N'URL_Css', N'', 1, N'string', N'Fully qualified url to the CSS filename of the links pro application.
This is should be the root url of your site + linkspro subdirectory + ''/includes/css.asp''

Or more simply it is the value you have just placed in URL_SiteRoot +  ''/includes/css.asp''

e.g. http://www.mysite.com/linkspro/includes/css.asp', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Style Sheet URL', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (68, N'URL_JavascriptFunctions', N'', 1, N'string', N'Fully qualified url to the JavaScript Functions filename of the links pro application.
This is should be the root url of your site + linkspro subdirectory + ''/includes/functions.js''

Or more simply it is the value you have just placed in URL_SiteRoot +  ''/includes/functions.js''

e.g. http://www.mysite.com/linkspro/includes/functions.js', 1, 254, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Javascript Function URL', 0, 13)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (69, N'DATABASE_Type', N'', 1, N'string', N'Select between MS Access and MS SQL Server - depending on which database server you wish to use to run the application.', 1, 254, N'MS Access', N'dbaccess', N'MS SQL Server (7,2000,2005)', N'dbsqlserver', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Database Type', 0, 12)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (70, N'DATABASE_DefaultConnection', N'', 1, N'string', N'MS Access and MS SQL Connect Strings.
Choose based on which database type you are using.  

The example settings above need to be altered to suit your particular settings, please change the following:

MS SQL Server
DatabaseName - With the name of your database
UID - Username of a permitted user of the database
Password - Password of the user
Server=(local) - If using an off site server, Server=IP Address

MS Access
AbsolutePathToSiteRoot - With hard drive path to the root of the links pro directory e.g. c:\inetpub\wwwroot\linkspro\db.database

OLEDB Connect Strings are favoured/fastest, but in some circumstances you might wish to use the none OLEDB type, experiment to find which is best for you.', 1, 254, N'MS SQL Server (7,2000)  OLEDB', N'Provider=SQLOLEDB;Driver={SQL Server};Server=(local);Database=DatabaseName;Uid=Username;Pwd=Password;', N'MS SQL Server (7,2000) ODBC', N'Driver=SQL Server;Server=(local);Database=DatabaseName;UID=Username;PWD=Password', N'Access OLEDB', N'PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AbsolutePathToSiteRoot\links.mdb', N'Access', N'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\AbsolutePathToSiteRoot\links.mdb', N'MS SQL Server (2005,2005 Express) OLEDB', N'Provider=SQLNCLI;Data Source=localhost\sqlexpress;Initial Catalog=DatabaseName;UID=Username;PWD=Password;', N'MS SQL Server (2005,2005 Express) ODBC', N'Driver={SQL Native Client};Server=ServerName;Database=DatabaseName;UID=Username;PWD=Password;', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Database Connect String', 0, 12)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (71, N'AdministratorsEmail', N'', 1, N'string', N'Email address to which to receieve notifications and all correspondence from the site, this address will also be used in the FROM column, when sending emails to users of the system.', 0, 3, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Email Address', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (72, N'EmailFormat', N'', 1, N'string', N'Format in which to send emails out in, HTML or Text. HTML is recommended.', 0, 6, N'HTML', N'HTML', N'Text', N'Text', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Email Format', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (73, N'ShowDescriptions', N'', 1, N'boolean', N'In the category listings, do you want to show full descriptions under the main category title? 

Note, that turning this on will swap the standard subdirectories of categories that you usually see. 

Experiment to find what is best for you.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Descriptions', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (74, N'ResultsMaxTopRated', N'', 1, N'long', N'Top Rated section, how many links will be shown there and classified as top rated.', 0, 16, N'5', N'5', N'10', N'10', N'25', N'25', N'50', N'50', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Results Per Page Top Rated', 0, 7)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (75, N'DuplicateSites', N'', 1, N'boolean', N'Allow people to submit duplicate sites to the directory or not.', 1, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Duplicate Sites', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (76, N'ShowImages', N'', 1, N'boolean', N'Show images in the standard listing of links.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Images', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (77, N'TableNamePrefix', N'', 1, N'string', N'If installing in MS SQL Master database especially, you may wish to have a table prefix applied to the standard names to easily differentiate against others. If not leave blank. You will need to change your db tables to represent any changes made here, or the site will not work.', 1, 254, N'codefixer_', N'codefixer_', N'codefixerlp_', N'codefixerlp_', N'linkspro_', N'linkspro_', N'codefixerlpr_', N'codefixerlpr_', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Database Table Name Prefix', 0, 12)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (78, N'ResultsPerPageAdmin', N'', 1, N'long', N'The amount of links and other items to show per page in admin, this is different value to the resultsperpage for the front of the application.', 0, 16, N'5', N'5', N'10', N'10', N'25', N'25', N'50', N'50', N'100', N'100', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Results Per Page Admin', 0, 7)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (79, N'AllowTopCategoryLinks', N'', 1, N'boolean', N'Do you want to show links at the top of the directory, links without a category of high priority/visible importance?', 1, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Top Links', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (80, N'EmailIntervalSeconds', N'', 1, N'long', N'The interval in seconds a user with the same ip address or session id has to wait before sending another email using the on-site contact forms. This is to prevent your site being used for spam purposes.', 0, 7, N'15', N'15', N'30', N'30', N'60', N'60', N'120', N'120', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Email Send Interval', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (81, N'CSS_Color', N'', 1, N'string', N'Text Color. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Text', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (82, N'CSS_ColorLink', N'', 1, N'string', N'Link Color. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Link', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (83, N'CSS_ColorLinkHover', N'', 1, N'string', N'Link Hover Color. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Link Hover', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (84, N'CSS_FontFamily', N'', 1, N'string', N'List of fonts to be used for all text e.g. Verdana, Arial, Helvetica, sans-serif', 0, 11, N'Verdana, Arial, Helvetica, sans-serif', N'Verdana, Arial, Helvetica, sans-serif', N'Georgia, Times New Roman, Times, serif', N'Georgia, Times New Roman, Times, serif', N'Geneva, Arial, Helvetica, sans-serif', N'Geneva, Arial, Helvetica, sans-serif', N'Arial, Helvetica, sans-serif', N'Arial, Helvetica, sans-serif', N'Times New Roman, Times, serif', N'Times New Roman, Times, serif', N'Courier New, Courier, monospace', N'Courier New, Courier, monospace', N'Georgia, Times New Roman, Times, serif', N'Georgia, Times New Roman, Times, serif', N'', N'', N'', N'', N'', N'', 1, N'Font Family', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (85, N'CSS_FontSize', N'', 1, N'long', N'Font size in pixels, numerics only e.g. 10 or 12 or 14 (please don''t add px suffix)', 0, 11, N'9', N'9', N'10', N'10', N'11', N'11', N'12', N'12', N'13', N'13', N'14', N'14', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Font Size', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (86, N'CSS_InputEdgeColor', N'', 1, N'string', N'Color of the borders around form elements like text boxes or dr0p downs. Full color code listing can be viewed via the following

http://www.w3schools.com/html/html_colornames.asp', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Text Box Border', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (87, N'CSS_CellBackgroundColor1', N'', 1, N'string', N'Background color of cell/header/site sections (not implemented). Full color code listing can be viewed via the following

http://www.w3schools.com/html/html_colornames.asp', 1, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Cell Background', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (88, N'CSS_CellEdgeColor1', N'', 1, N'string', N'Color of the outline around main cell/header/site sections. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Cell Border', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (89, N'CSS_CellBackgroundColor2', N'', 1, N'string', N'Background color of admin menu/navigation bar. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Admin Nav Background', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (90, N'CSS_CellEdgeColor2', N'', 1, N'string', N'Color of the outline around admin menu/navigation bar. Full color code listing can be viewed via the following

http://www.w3schools.com/html/html_colornames.asp', 0, 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Color Admin Nav Border', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (91, N'AD_Google', N'', 1, N'boolean', N'Do you want to turn Google AdSense Advertising On or Off - Top of Page

Google AdSense is an easy way for website publishers to display relevant adverts on their website''s and earn money. The adverts are related to the existing content on your site or matched to the interests of the visitors your website attracts. You are payed per click, everytime a user simply clicks on an advert on your site, you earn money to varying degrees.

To apply for a google adsense account please visit the following URL
https://www.google.com/adsense/', 0, 19, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Google Adverts Top', 0, 11)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (92, N'AD_GoogleCode', N'', 1, N'string', N'Google AdSense Code

Can be found at the following URL (once logged in), next to the label ''AdSense for Content''
https://www.google.com/adsense/account-settings

Example of what you should enter here:
pub-2473673338532556

Google AdSense is an easy way for website publishers to display relevant adverts on their website''s and earn money. The adverts are related to the existing content on your site or matched to the interests of the visitors your website attracts. You are payed per click, everytime a user simply clicks on an advert on your site, you earn money to varying degrees.

To apply for a google adsense account, and so obtain your Google AdSense Code please visit the following URL
https://www.google.com/adsense/', 0, 19, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Google Adverts Code', 0, 11)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (94, N'AutomaticApprovalReviews', N'', 1, N'boolean', N'Automatically approve all reviews submitted to the site.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Automatic Approve Reviews', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (95, N'AutomaticApprovalRatings', N'', 1, N'boolean', N'Automatically approve all ratings submitted to the site.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Automatic Approve Ratings', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (96, N'ActivateNews', N'', 1, N'boolean', N'Do you want the news page turned on with the link on the navigation bar?', 0, 10, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'News Page', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (97, N'ShowNews', N'', 1, N'boolean', N'Show recent news on the home page of the site, not effected by News Page Menu Item.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'News Show Top', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (98, N'ResultsMaxNews', N'', 1, N'long', N'How many recent news items to show on the homepage.', 0, 16, N'5', N'5', N'10', N'10', N'25', N'25', N'50', N'50', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'News Results Top', 0, 7)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (99, N'ModeSite', N'', 1, N'string', N'1. Free - Allows links to be submitted to the site free of charge
2. Reciprocal - Submitter sites must have a link back to this site / your directory, for mutual search engine optimisation.
3. Pay - Members pay a free to submit to your directory. You can specify premium and standard rates depending on if the submitter wishes a link at the top of the directory, by altering the Premium Top Category and Fee Premium Settings. You can use recurring or 1 off billing.', 0, 10, N'Free', N'Free', N'Reciprocal', N'Reciprocal', N'Pay', N'Pay', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Site Mode', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (100, N'AllowTopCategorySubmit', N'', 1, N'boolean', N'Allow users to submit their links to the top of the directory, setting false will force them to submit to a category within the site.

IMPORTANT (Please Read)
Set "Show Top Links" to True also, so you/users can see the links submitted to the top of the directory. This is located within "Display Rules".', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Top Category Submission', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (101, N'PremiumTopCategory', N'', 1, N'boolean', N'Do you wish to offer a premium rate charge, for people to submit links to the top of your directory.

IMPORTANT (Please Read)
1. Set "Top Category Submission" to True also, so that users are allowed to submit to the top categories, Premium Submission will NOT work without this being turned on.
2. Set "Show Top Links" to True also, so you/users can see the links submitted to the top of the directory.', 0, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Config Premium Submission', 0, 8)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (102, N'FeePremium', N'', 1, N'double', N'Premium one off fee the site will charge submitters.', 0, 22, N'5.00', N'5.00', N'10.00', N'10.00', N'20.00', N'20.00', N'30.00', N'30.00', N'40.00', N'50.00', N'50.00', N'100.00', N'100.00', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Config Fee Premium', 0, 8)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (103, N'FeeStandard', N'', 1, N'double', N'Standard one off fee the site will charge submitters.', 0, 22, N'5.00', N'5.00', N'10.00', N'10.00', N'20.00', N'20.00', N'30.00', N'30.00', N'40.00', N'50.00', N'50.00', N'100.00', N'100.00', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Config Fee Standard', 0, 8)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (104, N'FeeCurrency', N'', 1, N'string', N'The currency your site will charge users in.', 0, 22, N'GBP', N'GBP', N'USD', N'USD', N'EUR', N'EUR', N'AUD', N'AUD', N'CAD', N'CAD', N'YEN', N'YEN', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Config Fee Currency', 0, 8)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (105, N'PAYPAL_Receiver_Email', N'', 1, N'string', N'Paypal Email address for you to receive site payments in. To sign up for a paypal business account please visit www.paypal.com. The email you specify there should be the same for this setting.', 0, 22, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: PayPal Email', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (106, N'PAYPAL_URL', N'', 1, N'string', N'URL of the PayPal payment gateway. If you experience problems in the future it is possible PayPal may have changed the this URL.', 0, 22, N'Live: https://www.paypal.com/cgi-bin/webscr', N'https://www.paypal.com/cgi-bin/webscr', N'Test: https://www.sandbox.paypal.com/cgi-bin/webscr', N'https://www.sandbox.paypal.com/cgi-bin/webscr', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: PayPal URL', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (107, N'ShowCustomMenu', N'', 1, N'boolean', N'Would you like to show a custom menu, above the main site menu. This will list any pages created by the custom site manager.', 0, 10, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Custom Pages', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (109, N'ReciprocalWebSiteTitle', N'', 1, N'string', N'Short Name/Description used in the reciprocal link on users sites.', 0, 23, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Reciprocal Web Site Title', 0, 10)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (110, N'ReciprocalWebSiteDescription', N'', 1, N'string', N'The description that will be used on users reciprocal links within their sites.', 0, 23, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Reciprocal Web Site Description', 0, 10)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (111, N'URL_ReciprocalLinkBack', N'', 1, N'string', N'The base fully qualified site url of which you wish users to have on there sites, for reciprocal status to be valid.

The system will look for this link on reciprocal sites.', 0, 23, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Reciprocal Link Back URL', 0, 10)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (112, N'PAYMENT_PayPal', N'', 1, N'boolean', N'Allow users to pay with PayPal.', 0, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Single PayPal', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (113, N'PAYMENT_NoChex', N'', 1, N'boolean', N'Allow users to pay with NoChex. This gateway only accepts GBP - if your ''Fee Currency'' setting isn''t in pounds sterling this option won''t be available to your customers, regardless of this setting.', 0, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Single Nochex', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (114, N'ShowLinkCount', N'', 1, N'boolean', N'Show the link count next to each category. This will total up all active links below that category and sub-categories.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Category Show Link Count', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (115, N'NOCHEX_Receiver_Email', N'', 1, N'string', N'NoChex Email address for you to receive site payments in. To sign up for a NoChex seller account please visit www.nochex.com. The email you specify there should be the same for this setting.', 0, 22, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Nochex Email', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (116, N'NOCHEX_URL', N'', 1, N'string', N'URL of the NoChex payment gateway. If you experience problems in the future it is possible NoChex may have changed the this URL.', 0, 22, N'https://secure.nochex.com/', N'https://secure.nochex.com/', N'https://www.nochex.com/nochex.dll/checkout', N'https://www.nochex.com/nochex.dll/checkout', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Nochex URL', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (117, N'PAYPAL_Recurring', N'', 1, N'boolean', N'Turn on Recurring Billing for PayPal, allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', 0, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Recurring PayPal', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (118, N'PAYMENT_Recurring_TimePeriod', N'', 1, N'string', N'The period you wish to charge recurring billing in, Days, Weeks, Months or Years', 0, 22, N'Day', N'D', N'Week', N'W', N'Month', N'M', N'Year', N'Y', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Config Recurring Cycle', 0, 8)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (119, N'PAYMENT_Recurring_TimePeriodUnit', N'', 1, N'long', N'How many units of whatever time period you se1ected, between each recurring charge. If you chose Weeks above, and you want to bill your customers every 4 weeks, then this value should be four. If you chose Years, and you want to bill them annually, then this unit should be 1.', 0, 22, N'1', N'1', N'2', N'2', N'3', N'3', N'4', N'4', N'5', N'5', N'7', N'7', N'12', N'12', N'14', N'14', N'21', N'21', N'30', N'30', 1, N'Pay: Config Recurring Cycle Unit', 0, 8)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (120, N'ANALYTICS_GoogleCode', N'', 1, N'string', N'Do you use Google Analytics? Enter your analytics code here, and all of the pages on this site will be tracked. 

You can find this code by pressing "Edit Analytics Account" on the main page within Google Analytics.

Example of what you should enter here:
UA-429234

For further information on Google Analytics hit/traffic statistics service please visit http://www.google.com/analytics', 0, 19, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Google Analytics Code', 0, 11)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (121, N'SiteWord', N'', 1, N'string', N'The type of item your site mainly uses. This will fill in text labels next to forms and other site titles to accurately let the users know what type of information to enter.', 0, 20, N'Link', N'Link', N'Company', N'Company', N'Business', N'Business', N'Restaurant', N'Restaurant', N'Inn', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Site Type', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (122, N'SiteWordPlural', N'', 1, N'string', N'The type of item your site mainly uses, but using a plural spelling to allow lists to accurately be labelled.', 0, 20, N'Links', N'Links', N'Companies', N'Companies', N'Businesses', N'Businesses', N'Restaurants', N'Restaurants', N'Inns', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Site Type Plural', 0, 1)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (123, N'ActivateAddressing', N'', 1, N'boolean', N'Do you want to obtain peoples addressing details and show them on the site. This also turns on a google map which is created from these details.', 0, 10, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Business/Address Mode', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (124, N'ActivateUpload', N'', 1, N'boolean', N'Allow users to upload their own images / logos on the submit screen.', 0, 10, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Upload Allowed', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (125, N'PAYMENT_Mode', N'', 1, N'string', N'1. Single: Customer pays a one time fee, and it is up to the site owner to organise any other payments if needed
2. Recurring: The customer pays a recurring charge, the frequency of which is specified in the paypal recurring settings. The price of recurring billing is set via the ''Fee Standard'' and ''Fee Premium'' settings.
These are functional when the ''Site Mode'' is set to ''Pay'' only.', 0, 22, N'Single', N'Single', N'Recurring', N'Recurring', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Config Mode', 0, 8)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (126, N'PAYMENT_Cheque', N'', 1, N'boolean', N'Allow users to pay with Cheque by post/external means.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Single Cheque', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (127, N'PAYMENT_Cash', N'', 1, N'boolean', N'Allow users to pay with Cash by post/external means.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Single Cash', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (128, N'PAYMENT_BankTransfer', N'', 1, N'boolean', N'Allow users to pay with Bank Transfer/Wire.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Single Bank Transfer', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (129, N'PAYMENT_CreditCard', N'', 1, N'boolean', N'Allow users to pay with your own credit card processing facilities, you will take there details and process the transaction manually.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Single Manual Card', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (130, N'CHEQUE_Recurring', N'', 1, N'boolean', N'Turn on Recurring Billing for Cheques (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Recurring Cheque', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (131, N'CASH_Recurring', N'', 1, N'boolean', N'Turn on Recurring Billing for Cash (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Recurring Cash', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (132, N'BANKTRANSFER_Recurring', N'', 1, N'boolean', N'Turn on Recurring Billing for Bank Transfer/Wire (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Recurring Bank Transfer', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (133, N'CREDITCARD_Recurring', N'', 1, N'boolean', N'Turn on Recurring Billing for Manual Credit/Debit Card processing (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', 1, 22, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Pay: Recurring Manual Card', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (134, N'PAYMENT_Address', N'', 1, N'string', N'Address of where you wish manual/postal payments to be sent to, your correspondence address.', 1, 22, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Address', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (135, N'CHEQUE_Receiver_Name', N'', 1, N'string', N'The name of the person or company people should make cheques payble to.', 1, 22, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Cheque Name', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (136, N'BANKTRANSFER_IBAN', N'', 1, N'string', N'Your bank payment details, recommended that you use either one of the Two main standards
1. ABA Routing Code - USA
2. IBAN (International Bank Account Number) - Europe and rest of world

You can of course use this field to specify any bank account details, if not using one of the above standards

Examples
1. IBAN: GB54BARC20992012345678
2. ABA: 231382241
3. NAME:Bob Acc Num:66299822 SORT:80-20-90 IBAN:GB5? SWIFT:HJD...

Always add in the IBAN, ABA or other words before any account details (as seen above) so that users will know what the details represent.', 1, 22, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Bank Transfer Details', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (137, N'CREDITCARD_Instructions', N'', 1, N'string', N'The instructions on how users will pay for there site submission if you''re manually processing their credit/debit cards.', 1, 22, N'Contact Shortly', N'We will contact you shortly to arrange payment via your credit/debit card.', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Pay: Manual Card Details', 0, 9)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (138, N'Force_Linkname', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Title''', 1, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Title', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (139, N'Force_URL', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Web Site Address''', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Web Address', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (140, N'Force_Description', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Description''', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Description', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (141, N'Force_Address', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Address''', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Address', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (142, N'Force_Town', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Town/City''', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Town/City', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (143, N'Force_County', N'', 1, N'boolean', N'Force people submitting to the site to give a ''County/State''', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force County/State', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (144, N'Force_PostCode', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Post Code/Zip''', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Post Code/Zip', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (145, N'Force_Country', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Country''', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Country', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (146, N'Force_Phone', N'', 1, N'boolean', N'Force people submitting to the site to give a ''Phone'' number', 0, 21, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Force Phone', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (147, N'EmailAuthUsername', N'', 1, N'string', N'If your mail server required authentication please put in the username associated with your email address you specified.', 0, 8, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Email Account Username', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (148, N'EmailAuthPassword', N'', 1, N'string', N'If your mail server required authentication please put in the password associated with your email address you specified.', 0, 9, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Email Account Password', 0, 2)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (149, N'ResultsPerPageTop', N'', 1, N'long', N'How many links/items will be displayed per page for premium links, if you have any links/items at the top of the directory.', 1, 16, N'5', N'5', N'10', N'10', N'25', N'25', N'50', N'50', N'100', N'100', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Results Per Page Top/Premium', 0, 7)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (150, N'AD_Google2', N'', 1, N'boolean', N'Do you want to turn Google AdSense Advertising On or Off - Bottom of Page', 0, 19, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Google Adverts Bottom', 0, 11)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (151, N'ShowLatestLinksTop', N'', 1, N'boolean', N'Show latest links on the top/home page of your site? See also "Latest Links Results Top" to specify how many links to show.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Latest Links Top', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (152, N'ShowEmail', N'', 1, N'boolean', N'Show email address of submitters to the public in the Details page?', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Submitters Email', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (153, N'ImageAmount', N'', 1, N'long', N'How many images are users allowed to upload. If you are wishing to offer custom content pages, you may wish to allow 2 or 3 images to be submitted so you can design small websites/content for your customers. Multiple images can also be displayed automatically in the details section by changing the Show Image Amount setting.', 1, 17, N'1', N'1', N'2', N'2', N'3', N'3', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Image Amount', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (154, N'ActivateReviews', N'', 1, N'boolean', N'Allow (or not) reviews to be viewed/submitted.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Activate Reviews', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (155, N'ReviewInfoLabel', N'', 1, N'string', N'Additional information field to associate with a review. This can be used to validate that the user has some understanding of what they''re reviewing and not just putting down unfounded review comments. An example would be to use this field to say "Date visited" to confirm a reviewer has visited a lodging/eatery establishment.', 1, 18, N'Date Visited', N'Date Visited', N'Meal Had', N'Meal Had', N'Package Bought', N'Package Bought', N'Room Number', N'Room Number', N'Booking Number', N'Booking Number', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Review Info', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (156, N'ShowClickThroughs', N'', 1, N'boolean', N'Show the current click-through count for a link/business.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Click-Throughs', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (157, N'ShowHits', N'', 1, N'boolean', N'Show the current hit count for a link/business.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Hits', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (158, N'ShowImageAmount', N'', 1, N'long', N'How many images are to automatically displayed when viewing the details page of link/company. If Show Images setting is set to off, no images will be displayed regardless of this setting.', 1, 17, N'1', N'1', N'2', N'2', N'3', N'3', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Image Amount', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (159, N'ShowLocationBar', N'', 1, N'boolean', N'Show the location bar/category bar at the top of the pages.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Location Bar', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (162, N'Layout', N'', 1, N'string', N'The layout of the site. Navigation to the left, right or top.', 0, 17, N'Left', N'Left', N'Top', N'Top', N'Right', N'Right', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Layout', 0, 3)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (163, N'CategoryDivisions', N'', 1, N'long', N'How many categories can be stacked horizontally e.g. leave at 1 to stack categories vertically, recommended you leave at 3 for most purposes.', 0, 17, N'1', N'1', N'2', N'2', N'3', N'3', N'4', N'4', N'5', N'5', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 1, N'Category Divisions', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (164, N'ActivateUser', N'', 1, N'boolean', N'Activate the user system, allowing people to signup and register their details with you.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Activate User System', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (165, N'UserSubmitOnly', N'', 1, N'boolean', N'Do users have to be logged in to submit a link to the site?

NOTE: Only applies if "User System" is Activated.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'User Submit Only', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (167, N'UserEditDetails', N'', 1, N'boolean', N'Are users allowed to edit their link details after submission?

NOTE: Only applies if "User System" is Activated.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'User Edit Details', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (168, N'UserReviewOnly', N'', 1, N'boolean', N'Do users have to be logged in to submit a review?

NOTE: Only applies if "User System" is Activated.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'User Review Only', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (169, N'UserRateOnly', N'', 1, N'boolean', N'Do users have to be logged in to submit a rating?

NOTE: Only applies if "User System" is Activated.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'User Rate Only', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (170, N'ActivateKeywords', N'', 1, N'boolean', N'Allow tags/keywords to be attached to listings, and submitted by users. Tags/keywords can be clicked and are included when searching.', 0, 18, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Activate Tags', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (171, N'ShowSubCategories', N'', 1, N'boolean', N'Show 3 subcategories under category listings.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Sub-Categories', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (172, N'PopupRating', N'', 1, N'boolean', N'Do you want ratings to be entered via a popup window or a standard full page', 1, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Popup Ratings', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (173, N'PopupReview', N'', 1, N'boolean', N'Do you want reviews to be entered via a popup window or a standard full page', 1, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Popup Reviews', 0, 5)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (174, N'ShowNewGraphic', N'', 1, N'boolean', N'Show the graphic next to categories to indicate it has new content inside it', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show New Graphic', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (175, N'ShowContact', N'', 1, N'boolean', N'Show Contact/Submitter name?', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Show Contact', 0, 6)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (176, N'ActivateContactUs', N'', 1, N'boolean', N'Show Contact Us page and menu link, allowing people to contact you on various matters. You must have inputted a value for ''Administrators Email Address'' and also setup your other email settings for this to function properly.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Activate Contact Us', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (177, N'ActivateCAPTCHA', N'', 1, N'boolean', N'Activate CAPTCHA Protection on Contact Us, Tell a Friend, Broken Link Reporting and Reviews. This forces the user to enter a randomly displayed set of letters or numbers, to authenticate that it is a user operating those pages and not an automated process/bot/tool who might cause Spam on your site.', 0, 17, N'True', N'True', N'False', N'False', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Activate CAPTCHA Protection', 0, 4)
INSERT INTO [codefixerlp_tblConfig] ([fldID], [fldConfigName], [fldConfigValue], [fldProtected], [fldDataType], [fldConfigDescription], [fldSystem], [fldRank], [fldOption1Text], [fldOption1Value], [fldOption2Text], [fldOption2Value], [fldOption3Text], [fldOption3Value], [fldOption4Text], [fldOption4Value], [fldOption5Text], [fldOption5Value], [fldOption6Text], [fldOption6Value], [fldOption7Text], [fldOption7Value], [fldOption8Text], [fldOption8Value], [fldOption9Text], [fldOption9Value], [fldOption10Text], [fldOption10Value], [fldOtherAllowed], [fldConfigFriendlyName], [fldTextArea], [fldIDType]) VALUES (178, N'EmailPickup', N'', 1, N'long', N'Applies ONLY when using CDOSYS as your Email Component.
Email pickup method that your email provider uses. If you have problems sending emails through Links Pro please change this setting an experiment or ask your ISP/Email provider which setting is correct and apply here.', 0, 9, N'SMTP Local', N'1', N'SMTP Remote', N'2', N'Exchange Server', N'3', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'Email Method (CDOSYS only)', 0, 2)

SET IDENTITY_INSERT [codefixerlp_tblConfig] OFF

-- No rows are in codefixerlp_tblCategory
PRINT 'No rows are in codefixerlp_tblCategory'
-- No rows are in codefixerlp_tblPayment
PRINT 'No rows are in codefixerlp_tblPayment'
-- No rows are in codefixerlp_tblRating
PRINT 'No rows are in codefixerlp_tblRating'
-- No rows are in codefixerlp_tblCategoryRoute
PRINT 'No rows are in codefixerlp_tblCategoryRoute'
-- Insert scripts for table: codefixerlp_tblEmailTemplate
PRINT 'Inserting rows into table: codefixerlp_tblEmailTemplate'
SET IDENTITY_INSERT [codefixerlp_tblEmailTemplate] ON

-- Warning - TIMESTAMP datatype not supported for Insert scripts
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (3, N'Link Approved', NULL, N'Congratulations, your submission has been <b>Approved</b>', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'Approved your Submission:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (4, N'Link Rejected', NULL, N'We''re sorry, your submission has been <b>Rejected</b>', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'Rejected your Submission:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (5, N'Broken Link', N'', N'', N'', '20060703 17:54:09', N'Protected', 1, 0, 1, N'Broken Link')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (6, N'Tell Friend', NULL, NULL, NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'I thought you might be interested in this website')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (7, N'New Link Added And Approved', NULL, N'A new submission has been added and approved', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received a new submission:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (8, N'New Link Added And Needs Approval', NULL, N'A new submission has been added and needs approval', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received a new submission that needs your approval:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (9, N'New Rating Added And Approved', NULL, N'A new rating has been added and approved', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received a new rating for:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (10, N'New Rating Added And Needs Approval', NULL, N'A new rating has been added and needs approval', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received a new rating that needs your approval for:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (11, N'New Review Added And Approved', NULL, N'A new review has been added and approved.', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received a new review for:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (12, N'New Review Added And Needs Approval', NULL, N'A new review has been added and needs approval.', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received a new review that needs your approval for:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (13, N'New Link Added And Approved User', NULL, N'Your new submission has been added and approved.', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received and approved your new submission:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (14, N'New Link Added And Needs Approval User', NULL, N'Your new submission has been added and is undergoing approval.', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'received your new submission and is currently undergoing approval:')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (15, N'Example Template 1', N'<style>
body,table,tr,td
{
font-family:arial;
font-size:12px;
color:#333333;
}

a,a:link,a:visited
{
font-family:arial;
font-size:12px;
color:blue;
}

a:hover
{
color:green;
}

</style>
<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<img src="http://www.codefixer.com/images/CodefixerLogo.gif" border="0" />
</td>
</tr>
</table>', N'<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td style="padding:5px;">
Welcome and thank you for signing up to the codefixer web site. we hope you enjoy your stay, and find our site useful.
</td></tr>
<tr><td>
<p>Codefixer offers <strong>ASP 
                        tutorials, articles and resources</strong> aimed at the 
                        beginner to intermediate ASP developer though there are 
                        many ASP tutorials, articles and resources for the more 
                        advanced. Delve deep and enjoy.<br /><br />Codefixer now has a <a href="http://www.codefixer.com/forum/default.asp">DISCUSSION 
                      FORUM</a> for all your ASP questions and comments. Be the 
                      first to post!<br /> <br /> <a href="http://www.codefixer.com/app_mpV4_PayPal/default.asp">MEMBERSPRO 
                      PAYPAL</a> now supports 3 levels of membership and recurring 
                      payments as well as one-off ''lifetime'' subscriptions.</p>

                     
              <p>We have a new series of <a href="http://www.codefixer.com/asp_net/index.asp">ASP.NET 
                tutorials</a> and articles on the way.</p></td>

<td></tr>
</table>', N'<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<div style="text-align:center;">
<a href="http://www.xlinesoft.com/asprunnerpro/codefixer468x60.aspx" alt="ASP Runner Professional"><img src="http://www.codefixer.com/images/banners/xlinesoft468x68.gif"  border="0" /></a>
</div>
<br /><br />
<div style="text-align:center;"><a href="http://www.codefixer.com/tutorials/about_company.asp">About</a> 
  | <a href="mailto:contact@codefixer.com?subject=contact">Contact</a> | <a href="http://www.codefixer.com/advertise/advertise.asp">Advertise</a> 
  | <a href="http://www.codefixer.com/tutorials/feedback.asp">Feedback</a> | <a href="http://www.codefixer.com/tutorials/service.asp">Hire Us</a> | <a href="http://www.codefixer.com/link/linktous.asp">Link</a> </div>

<p style="text-align:center;">Site developed by Michael Wall.<br />
  Copyright &copy; 2000-2006. All rights reserved.</p>
</td></tr>
</table>', '20060703 17:54:09', N'General', 1, 0, 0, N'Welcome To Codefixer')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (16, N'Example Template 2 (reusing Example 1 Header & Footer)', N'<style>
body,table,tr,td
{
font-family:arial;
font-size:12px;
color:#333333;
}

a,a:link,a:visited
{
font-family:arial;
font-size:12px;
color:blue;
}

a:hover
{
color:green;
}

</style>
<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<img src="http://www.codefixer.com/images/CodefixerLogo.gif" border="0" />
</td>
</tr>
</table>', N'<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td style="padding:5px;">
 <table width="100%" style="border:1px solid #CCCCCC;" cellpadding="2" cellspacing="0">
        <tr> 
          <td align="left" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td valign="top"><h1>MembersPro PayPal</h1>
                    MembersPro PayPal now lets you charge members recurring subscriptions 
                    or a one-off ''lifetime'' joining fee. <br />

                    With 3 levels of membership available you can set different 
                    subscription fees and provide different content for each. 
                    <br />
                    <br />
                    Easy to install professional 100% secure membership management 
                    system.<br />
                    Customers can signup and automatically be approved once their 
                    payment has been verified by PayPal. PayPal takes care of 
                    all the back end payments with their <a href="http://www.codefixer.com/app_mpV4_Paypal/paypal_ipn.asp">IPN 
                    interface</a> while you can concentrate on running a successful 
                    site and attracting more members. <br />
                    <br />
                    MembersPro PayPal can be quickly and easily integrated into
                    your existing site. Simply upload the files onto your server
                   and have it  running on your website in minutes.<br />                    
                   <br />

                    To use MembersPro PayPal you will need a <a href="https://www.paypal.com/cgi-bin/webscr?cmd=_registration-run" target="_blank">business
                    or premier PayPal account</a>  with Instant Payment
                    Notification  (IPN) enabled in your PayPal control panel. <br />
                    <br />
                    Our <a href="http://www.codefixer.com/app_mpV4_Paypal/subscription_payment_chart.asp">subscription 
                    payment chart</a> shows you how much potential revenue your 
                    site could generate.<br />
                    <br />
                    Here''s <a href="http://www.codefixer.com/app_mpV4_Paypal/10_reasons.asp">10 reasons</a> why you should buy our software.
                </p></td>

                <td width="23%" valign="top"> <div align="center"><a href="https://www.paypal.com/xclick/business=michael%40codefixer.com&item_name=MembersPro+PayPal&item_number=12&amount=199.00&no_note=1&currency_code=USD&return=http%3A//www.codefixer.com/applications/thankyou.asp&cancel_return=http%3A//www.codefixer.com/applications/cancel.asp">
				<strong>PURCHASE TODAY!</strong></a><br />
                    <br />
                    <img src="http://www.codefixer.com/images/productshotboxes/membersPro_paypal.gif" alt="MembersPro PayPal - ASP Membership software" width="125" height="125" border="0"> 
                    <br />
                    <br />
                  </div>
                  <div align="center"><a href="http://www.codefixer.com/members/login.asp" target="_blank"><img src="/images/mpPayPalpromotion.gif" width="222" height="121"  border="0" ></a> 
                    <table width="80%"  border="0" cellspacing="0" cellpadding="2">

                      <tr>
                        <td>All front end files 
can be easily integrated
into existing site templates.</td>
                      </tr>
                    </table>
                  </div></td>
              </tr>
            </table>
            <div align="center"><a href="http://www.codefixer.com/members/join/view_membershiptypes.asp" target="_blank"><br />

              <img src="http://www.codefixer.com/images/userdemo.gif" width="100" height="25" border="0"></a> 
              <a href="http://www.codefixer.com/members/login.asp" target="_blank"><img src="http://www.codefixer.com/images/admindemo.gif" width="100" height="25" border="0"></a> 
              <a href="http://www.codefixer.com/app_mpv4_paypal/support.asp"><img src="http://www.codefixer.com/images/nsupport.gif" width="90" height="25" border="0"></a> 
              <a href="http://www.codefixer.com/app_mpv4_paypal/faqs.asp"><img src="http://www.codefixer.com/images/nFAQS.gif" height="25" border="0"></a><br />
              <br />
            </div>
            <table width="100%" style="border:solid 1px #cccccc;" cellspacing="1" cellpadding="3">
              <tr > 
                <td width="9%" >Version</td>
                <td width="59%">Product Description</td>

                <td colspan="2"> <div align="center"><strong>Price $199 </strong></div></td>
              </tr>
              <tr style="border:solid 1px #cccccc;"> 
                <td width="9%" rowspan="2" valign="top" nowrap ><strong>4.1 </strong></td>
                <td rowspan="2" valign="top" ><strong>Single Site License<br />
                  </strong> Full source code included<br />

                  2 Hours technical support including free installation if needed<br />
                  Free Updates (2 years)<br />
                  Free Add-ons (2 years) </td>
                <td width="14%" rowspan="2" valign="top" ><form method="post" action="https://www.2checkout.com/cgi-bin/sbuyers/purchase.2c">
                    <div align="center"> 
                      <input type="hidden" name="sid" value="131678">
                      <input type="hidden" name="product_id" value="5">
                      <input type="hidden" name="quantity" value="1">

                      <input name="submit" value="Click to pay thru 2CheckOut" type="image" src="/images/2co.jpg" width="70" height="39">
                    </div>
                  </form></td>
                <td width="18%" valign="top"> <form action="https://www.paypal.com/cgi-bin/webscr" method="post">
                    <div align="center"> 
                      <input type="hidden" name="cmd" value="_xclick">
                      <input type="hidden" name="business" value="michael@codefixer.com">
                      <input type="hidden" name="return" value="http://www.codefixer.com/applications/thankyou.asp">
                      <input type="hidden" name="cancel_return" value="http://www.codefixer.com/applications/cancel.asp">

                      <input type="hidden" name="notify_url" value="http://www.codefixer.com/applications/ipn.asp">
                      <input type="hidden" name="item_name" value="MembersPro PayPal">
                      <input type="hidden" name="item_number" value="12">
                      <input type="hidden" name="amount" value="199">
                      <input type="hidden" name="no_note" value="1">
                      <input type="hidden" name="currency_code" value="USD">
					  
                      <input name="submit" type="image" src="/images/paypalbutton.jpg" alt="Make payments with PayPal - it''s fast, free and secure!" border="0" width="70" height="39">
                    </div>
                  </form></td>

              </tr>
              <tr> 
                <td></td>
              </tr>
              <tr style="border:solid 1px #cccccc;"> 
                <td rowspan="2" valign="top"><strong>4.1</strong></td>
                <td rowspan="2" valign="top" ><strong>Unlimited Sites License</strong> 
                  <br />
                  Full source code included<br />

                  3 Hours technical support including free installation if needed<br />
                  Free Updates (2 years)<br />
                  Free Add-ons (2 years) </td>
                <td colspan="2" valign="top"><div align="center"><strong>Price 
                    $499 </strong></div></td>
              </tr>
              <tr style="border:solid 1px #cccccc;"> 
                <td valign="top"><form method="post" action="https://www.2checkout.com/cgi-bin/sbuyers/purchase.2c">

                    <div align="center"> 
                      <input type="hidden" name="sid" value="131678">
                      <input type="hidden" name="product_id" value="6">
                      <input type="hidden" name="quantity" value="1">
                      <input name="submit" value="Click to pay thru 2CheckOut" type="image" src="/images/2co.jpg" width="70" height="39">
                    </div>
                  </form></td>
                <td valign="top"> <form action="https://www.paypal.com/cgi-bin/webscr" method="post">
                    <div align="center"> 
                      <input type="hidden" name="cmd" value="_xclick">

                      <input type="hidden" name="business" value="michael@codefixer.com">
                      <input type="hidden" name="return" value="http://www.codefixer.com/applications/thankyou.asp">
                      <input type="hidden" name="cancel_return" value="http://www.codefixer.com/applications/cancel.asp">
                      <input type="hidden" name="notify_url" value="http://www.codefixer.com/applications/ipn.asp">
                      <input type="hidden" name="item_name" value="MembersPro PayPal">
                      <input type="hidden" name="item_number" value="12">
                      <input type="hidden" name="amount" value="499">
                      <input type="hidden" name="no_note" value="1">
                      <input type="hidden" name="currency_code" value="USD">

					  
                      <input name="submit" type="image" src="http://www.codefixer.com/images/paypalbutton.jpg" alt="Make payments with PayPal - it''s fast, free and secure!" border="0" width="70" height="39">
                    </div>
                  </form></td>
              </tr>
            </table>
            <br /> <table style="border:solid 1px #cccccc;" width="100%">
              <tr> 
                <td align="left" valign="top"> <strong>Product Features</strong><br /><br />

                  &#8226; Easy to set up and admin, with no Dll''s or components 
                  to install.<br />
                   &#8226; Pure ASP code, 
                  and easily integrated into an existing site.<br />
                  &#8226; Supports multiple membership levels. <br />
                  &#8226; Joining form look is completely customizable. <br /> &#8226; Select the fields and 
                  details for joining form that you need. <br /> &#8226; Javascript 
                  enabled validation on joinup form.<br /> &#8226; Password protect 
                  all your pages with one line of code.<br /> &#8226; Change username 
                  and password.<br /> &#8226; Forgotten password reminder.<br /> &#8226; 
                  Configure site details and settings.<br /> &#8226; Secure administration 
                  area. <br /> &#8226; Web based administration area with easy navigation.<br />

                  &#8226; Administer MembersPro from any internet connected computer 
                  in the world.<br /> <font color="#000000">&#8226; 
                  Search facility for current members with sorting features.</font><font color="#FF0000"><br />
                  <font color="#000000">&#8226; Delete members details or view 
                  details.</font><br />
                  <font color="#000000">&#8226; Automatic approval of members.</font> 
                  <br />
                  <font color="#000000">&#8226;</font> <font color="#000000">Send 
                  mass email to all members.</font><br />

                  <font color="#000000">&#8226;</font> <font color="#000000">Easily 
                  change text of emails sent out.</font><br />
                  </font> &#8226; Uses an Access 2000 relational database.<br />
                  <font color="#FF0000"><font color="#000000">&#8226;</font></font> 
                  Secure against SQL injection.<br />
                  <font color="#FF0000"><font color="#000000">&#8226;</font></font> 
                  Password and username are not sent out in the same email for 
                  security.<br />

                   &#8226; Members 
                  can edit and update their own details.<br />
                  &#8226; Page tracking.<br />
                  &#8226; Login tracking.                  <br /> &#8226; and much 
                  much more...<br /> <font color="#FF0000"><br />
                  <br />

                  <font color="#000000">MembersPro Paypal is an excellent application. 
                  Robust and powerful, It''ll save you time, it''s taken us over 
                  3 years plus worth of work! </font></font> </td>
              </tr>
            </table>
            <br /> <table width="100%" style="border:solid 1px #cccccc;">
              <tr> 
                <td><strong>What is PayPal?</strong><br />
                  <br />

                  </strong>You can find out more about PayPal on the <a href="http://www.paypal.com" target="_blank">PayPal
                  website</a>.<br />
                   <br /><strong>What Could I use this  for?</strong><br />
                  <br />
                  </strong>Obviously a membership site, a subscription site,
                  a supporters site, a fan club or an organization. <br />
                  Sell your intellectual property, newsletters, articles, images, 
                  software, music or downloads.<br />
                  <br />

				  <strong>How it works? </strong><br />
                  <br />
                  </strong>A customer selects a membership option that they would 
                  like to subscribe to and then fills out the sign up form. The 
                  customer then clicks on the payment button and then goes through 
                  with their PayPal payment. The IPN process and post back as 
                  outlined above occur and provided the payment is verified and 
                  successful then the new member will be redirected back to the 
                  site&#8217;s login page and is instantly sent out an autogenerated 
                  password via email.<br />
                  The new member can then login to their account as an active 
                  member. Depending on the membership option that the new member 
                  has paid for they will be taken to the members home page for 
                  that subscription option.<br />
                Find out more about <a href="http://www.codefixer.com/app_mpV4_Paypal/paypal_ipn.asp">PayPal IPN.</a></td>
              </tr>

            </table>
            <br /> <table width="100%" style="border:solid 1px #cccccc;">
              <tr> 
                <td><strong>Server Requirements</strong><br /> 
                  <br />
                  Written in ASP, VBScript. No components to be installed. <br />
                  All the ASP pages must be run through an ASP enabled web server 
                  - Microsoft IIS 4 or above.<br />
                  If you are unsure whether your webserver supports ASP then send 
                  your webhosting company an email asking them.<br />

                  MembersPro Paypal will not work on other platforms. <br />
                  Email components - CDONTS, CDOSYS, JMail, ASPMail (Can be modified 
                  to support other components upon request) <br>
                  <p><strong>Database Requirements</strong><br />
                    <br />
                    This script uses a Microsoft Access 2000 database.<br />
                    The Access database is provided.<br />

                    This script will work for IE and Netscape 4 browsers and above.<br />
                  </p></td>
              </tr>
            </table>
                     </td>
        </tr>
      </table>
</td></tr>
</table>', N'<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<div style="text-align:center;">
<a href="http://www.xlinesoft.com/asprunnerpro/codefixer468x60.aspx" alt="ASP Runner Professional"><img src="http://www.codefixer.com/images/banners/xlinesoft468x68.gif"  border="0" /></a>
</div>
<br /><br />
<div style="text-align:center;"><a href="http://www.codefixer.com/tutorials/about_company.asp">About</a> 
  | <a href="mailto:contact@codefixer.com?subject=contact">Contact</a> | <a href="http://www.codefixer.com/advertise/advertise.asp">Advertise</a> 
  | <a href="http://www.codefixer.com/tutorials/feedback.asp">Feedback</a> | <a href="http://www.codefixer.com/tutorials/service.asp">Hire Us</a> | <a href="http://www.codefixer.com/link/linktous.asp">Link</a> </div>

<p style="text-align:center;">Site developed by Michael Wall.<br />
  Copyright &copy; 2000-2006. All rights reserved.</p>
</td></tr>
</table>', '20060703 17:54:09', N'General', 1, 0, 0, N'MembersPro Web Application Special Offer')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (17, N'Payment Follow Up', NULL, NULL, NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'Payment Follow up')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (18, N'Subscription Cancellation', NULL, NULL, NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'Subscription Cancellation')
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldID], [fldTemplateName], [fldHeader], [fldContent], [fldFooter], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem], [fldProtected], [fldSubject]) VALUES (19, N'Site Statistics', NULL, N'Hello,<br />Please find below the current Click-Throughs your site has received via our site.', NULL, '20060703 17:54:09', N'Protected', 1, 0, 1, N'Site Statistics')

SET IDENTITY_INSERT [codefixerlp_tblEmailTemplate] OFF


-- COMMITTING TRANSACTION DATA
PRINT 'Committing transaction DATA'
IF @@TRANCOUNT>0
	COMMIT TRANSACTION _DATA_
GO

SET NOEXEC OFF
GO