Confluence Docs 3.0 : Creating Database Schema Manually This page last changed on Feb 09, 2009 by jlargman. ## 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 Attachments: confluence_27_db.script (application/octet-stream)

Document generated by Confluence on Nov 05, 2009 23:34