Difference between revisions of "SAM V2:customization"
Jump to navigation
Jump to search
(Created page with "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. ==Naming Conventions and ...") |
|||
Line 1: | Line 1: | ||
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. | 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> | <table border="1"> | ||
<tr> | <tr> | ||
<th> </th> | <th> </th> | ||
Line 65: | Line 65: | ||
</tr> | </tr> | ||
</table> | </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. |
Revision as of 13:50, 17 May 2011
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 Name | Subdirectory Name | |
---|---|---|
Student | students | student |
Disabilities | disabilities | disability |
Accommodations | accommodations | accommodation |
Consents | consent_types | consent |
Referrals | referrals | referral |
Case Notes | case_notes | case |
Tasks | tasks | task |
Documentation | documentation | doc |
Tests | tests | test |
Class Schedules | class_schedules | schedule |
Orders | orders | order |
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:
alter table disabilities add column evaluator_name varchar(50) …
Or you could use the MySQL workbench to alter the table using the GUI tools.