This section includes detailed information about DBPrism CMS SQL scripts.
Files located into the db/ directory
| Name
|
SQL Scripts called
|
Arguments
|
Run as
|
Comments
|
| create-schemas.sql
|
drop-context.sql
|
log_file
cms_repository
cms_user_sec
cms_user_sec_pwd
cms_owner
cms_owner_pwd
cachehost
|
SYS
|
Create database schemas, roles and grants permitions.
|
| install-sec.sql
|
none
|
log_file
cms_repository
cms_user_sec
cms_user_sec_pwd
cms_owner
cms_owner_pwd
cachehost
|
CMS_USER_SEC
|
Create tables, packages and virtual private database filters. It Also
grants permisitions to CMS_OWNER and creates default CMS users and groups.
|
| install.sql
|
cms_tab.sql
cache_spc.sql
cache_bdy.sql
cms_faq.sql
faqtest.sql
cms_news.sql
cms_rss.sql
search.sql
|
log_file
cms_user_sec
cms_owner
|
CMS_OWNER
|
SQL script to create DBPrism CMS primary tables, and CMS Extensions
such as FAQ report, MoreOver News and SourceForge RSS tables and the
Oracle Text search index.
|
| CallSpecs.sql
|
none
|
log_file
cms_repository
cms_user_sec
cms_user_sec_pwd
cms_owner
cms_owner_pwd
cachehost
|
CMS_OWNER
|
Create Call Spec for Java Stored Procedures, and utility procedures such as
UploadNews and UploadRss
grants permisitions to CMS_OWNER and creates default CMS users and groups.
|
