This appendix contains the SQL scripts that are specific to a variety of different databases. In addition to adding enhancements that will improve performance on a specific database, these scripts omit any constructs that are not supported by a specific database (for example, the InstantDB script does not employ foreign keys, a feature still under development). If you are having trouble with the standard SQL scripts provided in Chapter 3 or Chapter 5, check to see if a script for your specific database is included here. All of the scripts shown here are available for download online by visiting http://www.newInstance.com.
Additionally, many of these scripts contain information that is not SQL, but instead is an instruction set for the database. For example, the Cloudscape database needs connection information specified at the head of any SQL script run against it, and InstantDB needs information about the JDBC driver to use. For each of the databases covered here, specific deployment details are covered in Appendix B. Any additional information specified in the examples in this appendix is also used in Appendix B as part of deployment.
Finally, the scripts used to create the accounts storage assume that
the scripts to create the user store have already been run. In other
words, if you are using Cloudscape, you must execute the script in
Example A-1 before executing the one in Example A-6. This is because the foreign key constraint on
USER_ID in the ...