Difference between revisions of "SAM V2:customization"

From AMACWiki
Jump to: navigation, search
(How to Add a Field to a Table and Form)
(How to Add a Field to a Table and Form)
Line 69: Line 69:
  
 
===Step 1===
 
===Step 1===
# 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:
+
 
 +
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:
  
 
<pre>alter table disabilities add column evaluator_name varchar(50) … </pre>
 
<pre>alter table disabilities add column evaluator_name varchar(50) … </pre>
  
 
Or you could use the MySQL workbench to alter the table using the GUI tools.
 
Or you could use the MySQL workbench to alter the table using the GUI tools.

Revision as of 12:51, 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

Step 1

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.