1
edit
Changes
→Database Step Up
# Once you are authenticated, select ''File -> Open'' and navigate to the location where the script, ''otts_schema.sql'' is located.
# Validate the script by pressing ''CTRL + F5''
# Once the validation is complete, run the script by pressing ''F5''. The query should read ''1 row(s) affected.'' The database is now setup. <br/>[[Image:execute_sql_script.JPG|center|450px550px|Figure 1.2 - Executing SQL Script]]
<br />
'''Note:''' By default after the script has been executed, there will be a master administrator login in the database. It is recommended to use this login in order to create the initial administrator login before using the system. It is also '''''highly''''' recommended that the master administrator login be deleted upon initial login. Since the master administrator login does not have a valid email, simply changing the password is not recommended.<br/><br />