Creating Database Schema Manually

Database Schema Creation

This document provides information on how to find the SQL for database table creation.

Often, DBAs will require that table creation be done manually. To find the required SQL statements, you can use the script generated from our evaluation version's HSQLDB database.

• Install Confluence with no external database.
• Shut down Confluence.
• Find the file located in <confluence-home>/database/confluencedb.script.

The confluence-home directory is not your installation directory, its the directory specified in confluence-init.properties. For more information, see Confluence Home Directory and Confluence Installation Directory.

To see some example SQL statements, click 'Tools' and select 'Attachments' on this wiki page.

To get Confluence to run against this established schema, configure the database with the normal procedure, then modify the hibernate.connection.url, username and password from confluence-home/confluence.cfg.xml or server.xml, depending on whether it's a direct jdbc or resoruce connection. This is described in Migrating Confluence Between Servers.

RELATED TOPICS

Database Configuration