wm_status.php

<?php

include("../../bin/do_not_change/standard_validation_regex.php");

unset($field);
unset($index);

$table = "${master}_status";

$thing_display = preg_replace("/_/", " ", $table);
$Thing_display = ucwords($thing_display);
$things_display = "${thing_display}s";
$Things_display = ucwords($things_display);

$indefinite_article = "a";

$default_sort_by = "sort_order";

$field[] = array("name"=>"id",
                 "type"=>"INT UNSIGNED",
                 "not_null" => TRUE,
                 "auto_increment" => TRUE,
                 "display_in_table_list_column" => TRUE,
                 "display_field_in_vertical_table" => TRUE,
                 "field_is_required_in_form" => TRUE,
                 "human_display" => "ID"
                );

$field[] = array("name"=>"name",
	         "type"=>"VARCHAR",
                 "size"=>150,
                 "not_null" => TRUE,
                 "display_in_table_list_column" => TRUE,
                 "display_field_in_vertical_table" => TRUE,
                 "field_is_required_in_form" => TRUE,
                 "filterable" => TRUE,
                 "filter_operator" => "LIKE",
                 "human_display" => "Name"
                );

$field[] = array("name"=>"sort_order",
                 "type"=>"INT UNSIGNED",
                 "display_in_table_list_column" => TRUE,
                 "display_field_in_vertical_table" => FALSE,
                 "field_is_required_in_form" => TRUE,
                 "human_display" => "Sort Order"
                );

include("../../bin/do_not_change/standard_config_files/STANDARD_TABLE_FIELDS");

$index[] = array("type"=>"PRIMARY KEY",
                 "name"=>array("id")
                );

$startup_sql[] = "INSERT IGNORE INTO thing (id, name, active, date_added) VALUES ('$table','$Thing_display','y',NOW())";

// give admin group read/write permissions 
$startup_sql[] = "INSERT IGNORE INTO jusergroup_thing (usergroup_id, thing_id, read_access, write_access, active, date_added) VALUES ('2','$table','all','all','y',NOW())";

$startup_sql[] = "INSERT IGNORE INTO $table (name,sort_order) VALUES ('In Development',10)";
$startup_sql[] = "INSERT IGNORE INTO $table (name,sort_order) VALUES ('To Be Tested',20)";
$startup_sql[] = "INSERT IGNORE INTO $table (name,sort_order) VALUES ('Pass',50)";
$startup_sql[] = "INSERT IGNORE INTO $table (name,sort_order) VALUES ('Fail',60)";

?>