D.1 Types and storage destinations of SQL script files

You can create an SQL script file using the sample file stored in the following directory:

<Service platform installation directory>\CSC\sql

This directory contains the following files and, the files to be used differ depending on the type of database and usage.

Table D‒1: Types of SQL script files
Database type	Classification	File name	Description
HiRDB	For creating a table	CreateTables_HiRDB.sql	Used to set up a stand-alone HCSC server or the first HCSC server in a cluster configuration.
		CreateTables_HiRDB_for_Matrix.sql	Used to set up a stand-alone HCSC server or the first HCSC server in a cluster configuration, when HiRDB matrix splitting is used.
		CreateTables_HiRDB_for_Range.sql	Used to set up a stand-alone HCSC server or the first HCSC server in a cluster configuration when HiRDB range splitting is used.
		CreateCSCIndividualTables_HiRDB.sql	Used to set up the second HCSC server in a cluster configuration.
	For deleting a table	DeleteTables_HiRDB.sql	Used to cancel the setup of a stand-alone HCSC server or the first HCSC server in a cluster configuration.
	For deleting a table	DeleteCSCIndividualTables_HiRDB.sql	Used to cancel setup of the second HCSC server in a cluster configuration.
Oracle	For creating a table	CreateTables_Oracle.sql	Used to set up a stand-alone HCSC server or the first HCSC server in a cluster configuration.
	For creating a table	CreateCSCIndividualTables_Oracle.sql	Used to set up the second HCSC server in a cluster configuration.
	For deleting a table	DeleteTables_Oracle.sql	Used to cancel setup of a stand-alone HCSC server or the first HCSC server in a cluster configuration.
	For deleting a table	DeleteCSCIndividualTables_Oracle.sql	Used to cancel setup of the second HCSC server in a cluster configuration.