This server will be upgraded at 3pm Sydney time on December 3rd (December 2nd, 8pm PST) and will be down for up to 30 minutes.
This documentation relates to the latest version of Confluence.
If you are using an earlier version, please go to the documentation home page and select the relevant version.

Database Schema

Added by Jeremy Largman, last edited by Jim Severino [Atlassian] on Sep 21, 2008  (view change) show comment
All Versions
Click for all versions
Confluence 2.10 Documentation

Index

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
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Comments (3)

 

  1. Jan 28, 2008

    Jay Compton says:

    Hi, would it be helpful if I exported an empty install schema from DB2 to contri...

    Hi, would it be helpful if I exported an empty install schema from DB2 to contribute to this? I have one for Confluence 2.7.

    1. Jan 29, 2008

      Mei Yan Chan says:

      Hi Jay, Feel free to share with us if possible. Thanks. Regards, Mei

      Hi Jay,

      Feel free to share with us if possible. Thanks.

      Regards,
      Mei

  2. Feb 24, 2008

    James Fleming [Atlassian] says:

    Jeremy, This page may be a good complement.

    Jeremy,

    This page may be a good complement.

Add Comment