This page last changed on Sep 21, 2008 by jseverino.

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.

RELATED TOPICS

Database Configuration


confluence_27_db.script (application/octet-stream)
Document generated by Confluence on Dec 03, 2008 15:13