EFrame_Sequence.sql
|
EFrame_<Pool_Id>_<Tab
leType>_Sequence.sql
|
Contains all the additional sequences that need to be created. |
EFrame_TableChanges.s
ql
|
EFrame_<Pool_Id>_<Tab
leType>_TableChanges.
sql
|
Contains all the table column differences that need to be applied
on the database shard. Modify this file to reference your tablespaces. |
EFrame_Drops.lst
|
EFrame_<Pool_Id>_<Tab
leType>_Drops.lst
|
This file contains sample and/or informational changes that
are not applied to the database by the entity deployer because they
could cause data loss. Review the file thoroughly and take action
on the entries as necessary for your environment. Note: Sterling Order Management Commerce Call Center Sterling Configure, Price, Quote does not provide a .sql file for removing tables
from the database but does provide the drop statements in the .lst
file. If you want to drop these tables, you must do it manually. Review
the entries in the file carefully before taking action.
|
EFrame_IndexAdds.sql
|
EFrame_<Pool_Id>_<Tab
leType>_IndexAdds.sql
|
Adds all of the indexes that need to be created in the database.
Modify this file to reference your tablespaces. |
EFrame_IndexDrops.sql
|
EFrame_<Pool_Id>_<Tab
leType>_IndexDrops.sq
l
|
Removes any extra indexes in the database. |
EFrame_TextIndexAdds.
sql
|
EFrame_<Pool_Id>_<Tab
leType>_TextIndexAdds
.sql
|
Adds new text search indexes that need to be created in the
database. |
EFrame_TextIndexDrops
.sql
|
EFrame_<Pool_Id>_<Tab
leType>_TextIndexDrop
s.sql
|
Removes text search indexes from the database. |
EFrame_TextIndexModif
y.sql
|
EFrame_<Pool_Id>_<Tab
leType>_TextIndexModi
fy.sql
|
Updates the text search indexes in the database. |
EFrame_TextIndexUpdat
es.sql
|
EFrame_<Pool_Id>_<Tab
leType>_TextIndexUpda
tes.sql
|
When executed, updates the content of the text indexes. |
EFrame_UpdateQueries.
sql
|
EFrame_<Pool_Id>_<Tab
leType>_UpdateQueries
.sql
|
For upgrades, updates the table column values in order to apply
other changes made to the columns. For example, if a table column
is changed from nullable to not nullable in the installation of a
previous release, the column values must be updated before the column
can be made not null in the current release because the column default
values for the current release may contain null values. |