Create Tables

Top  Previous  Next

The Create table window allows the database administrator to create the tables and indexes required by Crash Magic.

cmMaintCreateTables

 

Grant access to - Specify the database user that Crash Magic will use to access the system tables. This user will be granted Select, Insert, Update and Delete to the system table records.
Tables namespace - This allows oracle users to specify a name space for the tables. This field should be left blank if no namespace is required or specified.
Index namespace -  This allows oracle users to specify a name space for the indexes. This field should be left blank if no namespace is required or specified.
Display SQL - This button will generate the SQL statements to create the Crash Magic system tables and indexes. These statements will be shown in the text box below. Database administrators can choose to copy the SQL and run the statements from their own database  interface. Crash Magic does not allow changes to the table, and index structures, but storage clause information can be added.
Login - This is the database login of the user that will create the tables and indexes for Crash Magic. This user must be able to create tables in the schema specified from the previous window.
Password - This is the password for the login above
Role - This allows the user to specify a role required by the login above to create the Crash Magic system table and indexes. This should be left blank if no role is required.
Password - This is the role password. This should be left blank if no role or password is required.
Execute SQL - This will execute the SQL show in the bottom text box. Connection information from the configuration wizard tab will be used to execute the SQL displayed.
Done - This button will close the Create tables window.