View source for SAM V2:customization

Since SAM V2 is open-source software, it is easily customized with a working knowledge of HTML, PHP, MySQL, and the SAM source code/database structure.

==Tables Names and Directory Structure==

<table border="1">
<tr>
<th>&nbsp;</th>
<th>Table Name</th>
<th>Subdirectory Name</th>
</tr>
<tr>
<td>Student</td>
<td>students</td>
<td>student</td>
</tr>
<tr>
<td>Disabilities</td>
<td>disabilities</td>
<td>disability</td>
</tr>
<tr>
<td>Accommodations</td>
<td>accommodations</td>
<td>accommodation</td>
</tr>
<tr>
<td>Consents</td>
<td>consent_types</td>
<td>consent</td>
</tr>
<tr>
<td>Referrals</td>
<td>referrals</td>
<td>referral</td>
</tr>
<tr>
<td>Case Notes</td>
<td>case_notes</td>
<td>case</td>
</tr>
<tr>
<td>Tasks</td>
<td>tasks</td>
<td>task</td>
</tr>
<tr>
<td>Documentation</td>
<td>documentation</td>
<td>doc</td>
</tr>
<tr>
<td>Tests</td>
<td>tests</td>
<td>test</td>
</tr>
<tr>
<td>Class Schedules</td>
<td>class_schedules</td>
<td>schedule</td>
</tr>
<tr>
<td>Orders</td>
<td>orders</td>
<td>order</td>
</tr>
</table>

==How to Add a Field to a Table and Form==

# Add the field to the underlying table in MySQL.  For example, to add a field called Evaluator Name to the disabilities table, you would execute a SQL statement similar to:

<code>alter table disabilities add column evaluator_name varchar(50) … </code>

Or you could use the MySQL workbench to alter the table using the GUI tools.