As part of the installation of WebCenter Content 11g (UCM or URM), one of the main functions is to run the Repository Creation Utility (RCU) to establish the database schema and tables. This is pretty helpful because it runs all the scripts you need to have without having to manually set anything up in the database.
In UCM 10g and earlier, the installation itself would establish the database tables if you wanted it to. Otherwise, the SQL scripts were available to be run independently ahead of time. For DBAs who wanted to understand what was being done to the database for the application, this was helpful for them. But in 11g, that is all masked now in RCU. You don't get to see the scripts at all as part of it's establishing the tables.
But if you comb through the directories for RCU, you can track them down. They are in the /rcuHome/rcu/integration/contentserver11/sql/ directories. And to understand the order in which they are run, you can open up the /rcuHome/rcu/integration/contentserver11/contentserver11.xml file and see how they are run there. The order in which they are run are:
contentserverrole.sql
contentserveruser.sql
intradoc.sql
workflow.sql
formats.sql
users.sql
default.sql
contentprocedures.sql
If you are installing WebCenter Records (URM), it will run some additional scripts between the formats.sql and users.sql :
MetadataSet.sql
UIEnhancements.sql
RecordsManagement.sql
RecordsManagement_default.sql
ClassifiedEnhancements.sql
ClassifiedEnhancements_default.sql
In addition to the scripts being available within the RCU install directories, they are also available from within the Content Server UI. If you go to Administration -> DataStoreDesign SQL Generation, this page can allow you to download these various SQL scripts.
From here, you can select your particular database type and which components to include. Several components make changes dynamically to the database when they are enabled, so these scripts give you a way to inspect what is being run during that startup time. Once selected, click Generate and you now can either view or download the scripts from the Actions menu.
DISCLAIMER: Installations are ONLY supported when done with the Repository Creation Utility. These scripts are for reference only and not supported to be run manually.