Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.2.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:

...

Run the following SQL scripts:

demo-structure.sql

This file contains the basic database schema and table structure for the Scheduler application.  There is no data in this file and it must be used in conjunction with seed data in order to have a running application. The structure is based on Scheduler v4.1.0.

  • 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). 

...

Code Block
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.

...

Code Block
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.

...

b. Windows
fakeSubjects.cmd <max-subject-id>

update.sql

Finally, apply update.sql, and you will be all set.

...