Using SQL Scripts

  • Article

The following table lists and describes the SQL scripts available in CCF:

File Name (w/relative path)

Description

CreateCcfReportsJob.sql

Uses transaction data to create the report job that populates the CcfAuditReports database.

CreateInfrastructureAndReportsDb.sql

Creates the CcfInfrastructure and CcfAuditReports database.

CcfInfrastructure\ClearInfrastructureData.sql

Removes all table data from a subset of the tables.

CcfInfrastructure\CreateAuditReportsDbObjects.sql

Creates the tables and constraints for the CcfAuditReports database.

CcfInfrastructure\CreateInfraStructureDbObjects.sql

Creates the tables and constraints for the CcfInfrastructure database

CcfInfrastructure\CreateInfrastructureSprocs.sql

Creates the stored procedures for the CcfInfrastructure database.

CcfInfrastructure\InfrastructureSecurity.sql

Sets the security access rights for the CcfInfrastructure database

CcfQuickStarts\ClearDatabases.sql

Removes all table data from all tables.

CcfQuickStarts\ClearDbInstallOptions.sql

Removes all data from the CcfConfigValues table, found in the tempdb.

CcfQuickStarts\CreateQuickStartDbObjects.sql

Creates the CCFQuickStarts tables.

CcfQuickStarts\CreateQuickStartSprocs.sql

Creates the CCFQuickStarts stored procedures.

CcfQuickStarts\QuickStartSecurity.sql

Sets the security access rights to the CCFQuickStarts database.

CcfQuickStarts\ReplaceMacrosWithInstallOptions.sql

See the “Configuration Options” section earlier in this document.

Upgrade2.6To3.0.sql

Copies the data from a CCF v2.6 database into a v3.0 database.