To update existing database schema for 4.1.0

As explained below, apply the appropriate version(s) of update.sql, and then update the user-salts.

Update.sql

If you are currently using demo data that you set up under Scheduler v3.1.1, and you want to continue using your current data, apply the following list of update.sql files:

1. update.sql (3.2.0)

2. update.sql (3.3.0)

3. update.sql (3.5.0)

4. update.sql (3.6.0)

5. update.sql (3.7.2)

6. update.sql (4.1.0)

To apply each update.sql, install all the distributed update.sql files to the folder /var/tmp/. Then run the following command for each update.sql in the order provided:

...

If you are updating from Scheduler v3.7.3 then apply only the latest (4.1.0) update.sql from the above list.

User salts

Configure and run the  standalone, updateUserSalt, to convert DB user salt fields to new MIME flavored salts

...

• Install the distributed demo-structure.sql file to /var/tmp/demo-structure.sql

demo-seed.sql

This file contains all the static data required by the application (e.g dropdown options, list of users, states, countries, etc). 

...

root@shell> mysql scheduler < /var/tmp/demo-data.sql
root@shell> mysql scheduler < /var/tmp/demo-seed.sql

demo-data.sql

This file contains a set of data for demonstration purposes. This includes demo templates, scheduled appointments, and more.  Upon running this script (along with the populate-fake-subjects executable, and update.sql that follow) you should have all the data that you need to evaluate the application.

...

root@shell> mysql scheduler < /var/tmp/demo-data.sql

populate-fake-subjects

This program creates demo subjects data. README.txt in the program is out of date, please refer to the instructions below on how to run the program.

...