DDL SQL and Install script
The Alinous-Core supports Data Definition Language(DDL).
If you create install script under the ALINOUS_HOME, the content assist for the database table and column become available.
The Install Script is to make tables and indexes when newly install web application. By preparing this, you can install your web application soon, so it support your software testing process.
Create a new table. If the table exists, exception is thrown. You can check if the table exists or not bySql.TableExists() function.
Drop the table.
Create an index. This sentence also should be written in the install script.
Drop an index.
Alter the table. This is not used in the normal install script. Use this when the application upgrade.