Connect Daily uses a SQL database to hold the calendar data. This section covers how to create the database to hold the calendar data. Generally, these instructions are for your database administrator to follow.
Schema creation files are located in the cdaily-4.0.6/WEB-INF/sql directory. Use the calschema.sql file for your database engine.
The basic steps for all databases are:
Note The schema create script contains all commands necessary to drop existing tables and reload the schema. It is normal for error messages to appear at the beginning of the script stating that tables or views were not found to drop.
The schema script contains commands to drop all tables and re-create them. If you run this script on a production system, you will lose all data.
If you will be creating multiple installations, it is possible to create one physical database and partition it into multiple logical databases. For example, you plan to implement the calendar software for 12 distinct sites. Since each site has unique facilities and needs, you would like the data to be logically separated. If your database engine supports per user table spaces, you can create one physical database and then create 12 users, one for each logical calendar. You would then login to the physical database as each distinct User and create the table structures. Finally, for each logical calendar you would specify the unique login for that site in the configuration.properties file.
For information on whether your database engine supports per-user table spaces, contact your SQL database vendor.