 INSERT INTO sys_group_to_data_classification VALUES ( 8, 7,"cru-");
 INSERT INTO sys_group_to_data_classification VALUES ( 8, 8,"cru-");
 
--- INSERT DEFAULT LC_FIELDS
-INSERT INTO lc_fields (tablename,fieldname) VALUES ("field_options","option_description");
-INSERT INTO lc_fields (tablename,fieldname) VALUES ("ct_unit","name");
-INSERT INTO lc_fields (tablename,fieldname) VALUES ("ct_unit_type","name");
-INSERT INTO lc_fields (tablename,fieldname) VALUES ("ct_unit_type","description");
-
 -- INSERT DEFAULT TABLE FIELD TO DATA CLASSIFICATION MAPPINGS
-
--- TABLE NAMES ARE SORTED IN ALPHEBATICAL ORDER
+-- TABLE NAMES ARE SORTED IN ALPHABETICAL ORDER
 
 -- adodb_logsql
 

INSERT INTO gis_feature_class_to_layer VALUES ('def_people', 'ppl_grp_inj');
INSERT INTO gis_feature_class_to_layer VALUES ('def_people', 'ppl_grp_dead');
INSERT INTO gis_feature_class_to_layer VALUES ('def_people', 'ppl_grp_grave');

-- gis_wiki

-- gps

-- group_details
INSERT INTO sys_tablefields_to_data_classification VALUES ( "group_details", 1);

-- hr_assign_contractor_to_site_table

-- hr_assign_site_to_contractor_table

-- hr_contractor_table

-- hr_damaged_house_basic_details_table

-- hr_damaged_house_location_details_table

-- hr_family_head_details_table

-- hr_site_allocated_organization_table

-- hr_site_house_details_table

-- hr_site_infrastructure_details_table

-- hr_site_location_details_table

-- hr_site_main_coordinator_details_table

-- hr_site_name_and_uid_table

-- identity_to_person
INSERT INTO sys_tablefields_to_data_classification VALUES ( "identity_to_person", 1);

-- image
INSERT INTO sys_tablefields_to_data_classification VALUES ( "image", 6);

-- ims_alternate
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_alternate", 6);

-- ims_inventory_records
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_inventory_records", 6);

-- ims_item_records
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_item_records", 6);

-- ims_optimization
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_optimization", 7);

-- ims_relation
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_relation", 6);

-- ims_reorder_level
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_reorder_level", 6);

-- ims_transfer_item
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_transfer_item", 6);

-- incident
INSERT INTO sys_tablefields_to_data_classification VALUES ( "incident", 6);

-- landmark_location

-- lc_fields
INSERT INTO sys_tablefields_to_data_classification VALUES ( "lc_fields", 6);

-- lc_tmp_po
INSERT INTO sys_tablefields_to_data_classification VALUES ( "lc_tmp_po", 6);

-- location
INSERT INTO sys_tablefields_to_data_classification VALUES ( "location", 6);

-- location_details
INSERT INTO sys_tablefields_to_data_classification VALUES ( "location_details", 5);

-- messaging_group

-- old_passwords

-- org_main
INSERT INTO sys_tablefields_to_data_classification VALUES ( "org_main", 2);

-- password_event_log

-- person

-- person_deceased
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_deceased", 1);

-- person_details
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_details", 1);

-- person_missing
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_missing", 1);

-- person_physical
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_physical", 1);

-- person_status
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_status", 1);

-- person_to_pgroup
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_to_pgroup", 1);

-- person_to_report
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_to_report", 1);

-- person_uuid
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_uuid", 1);

-- pgroup
INSERT INTO sys_tablefields_to_data_classification VALUES ( "pgroup", 1);

-- phonetic_word

-- report_files

-- report_keywords

-- resource_to_incident
INSERT INTO sys_tablefields_to_data_classification VALUES ( "resource_to_incident", 6);

-- rms_fulfil
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_fulfil", 6);
-- rms_pledge
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_pledge", 6);
-- rms_plg_item
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_plg_item", 6);
-- rms_priority
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_priority", 6);
-- rms_req_item
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_req_item", 6);
-- rms_request
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_request", 6);
-- rms_status
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_status", 6);
-- rms_tmp_sch
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_tmp_sch", 8);
-- sector
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sector", 2);

-- sessions
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sessions", 6);

-- sync_instance
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sync_instance", 6);

-- sys_data_classifications
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_data_classifications", 6);

-- sys_group_to_data_classification
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_group_to_data_classification", 6);

-- sys_group_to_module

-- sys_tablefields_to_data_classification
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_tablefields_to_data_classification", 6);

-- sys_user_groups
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_user_groups", 6);

-- sys_user_to_group
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_user_to_group", 6);

-- unit

-- unit_type

-- user_preference

-- users
INSERT INTO sys_tablefields_to_data_classification VALUES ( "users", 6);

-- vm_access_classification_to_request

-- vm_access_constraint

-- vm_access_constraint_to_request

-- vm_access_request

-- vm_courier

-- vm_hours

-- vm_image

-- vm_mailbox

-- vm_message

-- vm_position

-- vm_position_active

-- vm_position_full

-- vm_positiontype

-- vm_projects

-- vm_projects_active

-- vm_vol_active

-- vm_vol_details

-- vm_vol_position

-- vm_vol_skills

-- ws_keys



-- gis_feature

-- gis_feature_class

-- gis_location

-- gis_layers

-- gis_wiki

-- gps

-- group_details
INSERT INTO sys_tablefields_to_data_classification VALUES ( "group_details", 1);

-- hr_assign_contractor_to_site_table

-- hr_assign_site_to_contractor_table

-- hr_contractor_table

-- hr_damaged_house_basic_details_table

-- hr_damaged_house_location_details_table

-- hr_family_head_details_table

-- hr_site_allocated_organization_table

-- hr_site_house_details_table

-- hr_site_infrastructure_details_table

-- hr_site_location_details_table

-- hr_site_main_coordinator_details_table

-- hr_site_name_and_uid_table

-- identity_to_person
INSERT INTO sys_tablefields_to_data_classification VALUES ( "identity_to_person", 1);

-- image
INSERT INTO sys_tablefields_to_data_classification VALUES ( "image", 6);

-- ims_alternate
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_alternate", 6);

-- ims_inventory_records
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_inventory_records", 6);

-- ims_item_records
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_item_records", 6);

-- ims_optimization
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_optimization", 7);

-- ims_relation
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_relation", 6);

-- ims_reorder_level
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_reorder_level", 6);

-- ims_transfer_item
INSERT INTO sys_tablefields_to_data_classification VALUES ( "ims_transfer_item", 6);

-- incident
INSERT INTO sys_tablefields_to_data_classification VALUES ( "incident", 6);

-- landmark_location

-- lc_fields
INSERT INTO sys_tablefields_to_data_classification VALUES ( "lc_fields", 6);

-- lc_tmp_po
INSERT INTO sys_tablefields_to_data_classification VALUES ( "lc_tmp_po", 6);

-- location
INSERT INTO sys_tablefields_to_data_classification VALUES ( "location", 6);

-- location_details
INSERT INTO sys_tablefields_to_data_classification VALUES ( "location_details", 5);

-- messaging_group

-- old_passwords

-- org_main
INSERT INTO sys_tablefields_to_data_classification VALUES ( "org_main", 2);

-- password_event_log

-- person

-- person_deceased
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_deceased", 1);

-- person_details
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_details", 1);

-- person_missing
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_missing", 1);

-- person_physical
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_physical", 1);

-- person_status
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_status", 1);

-- person_to_pgroup
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_to_pgroup", 1);

-- person_to_report
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_to_report", 1);

-- person_uuid
INSERT INTO sys_tablefields_to_data_classification VALUES ( "person_uuid", 1);

-- pgroup
INSERT INTO sys_tablefields_to_data_classification VALUES ( "pgroup", 1);

-- phonetic_word

-- report_files

-- report_keywords

-- resource_to_incident
INSERT INTO sys_tablefields_to_data_classification VALUES ( "resource_to_incident", 6);

-- rms_fulfil
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_fulfil", 6);
-- rms_pledge
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_pledge", 6);
-- rms_plg_item
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_plg_item", 6);
-- rms_priority
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_priority", 6);
-- rms_req_item
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_req_item", 6);
-- rms_request
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_request", 6);
-- rms_status
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_status", 6);
-- rms_tmp_sch
INSERT INTO sys_tablefields_to_data_classification VALUES ( "rms_tmp_sch", 8);
-- sector
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sector", 2);

-- sessions
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sessions", 6);

-- sync_instance
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sync_instance", 6);

-- sys_data_classifications
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_data_classifications", 6);

-- sys_group_to_data_classification
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_group_to_data_classification", 6);

-- sys_group_to_module

-- sys_tablefields_to_data_classification
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_tablefields_to_data_classification", 6);

-- sys_user_groups
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_user_groups", 6);

-- sys_user_to_group
INSERT INTO sys_tablefields_to_data_classification VALUES ( "sys_user_to_group", 6);

-- unit

-- unit_type

-- user_preference

-- users
INSERT INTO sys_tablefields_to_data_classification VALUES ( "users", 6);

-- vm_access_classification_to_request

-- vm_access_constraint

-- vm_access_constraint_to_request

-- vm_access_request

-- vm_courier

-- vm_hours

-- vm_image

-- vm_mailbox

-- vm_message

-- vm_position

-- vm_position_active

-- vm_position_full

-- vm_positiontype

-- vm_projects

-- vm_projects_active

-- vm_vol_active

-- vm_vol_details

-- vm_vol_position

-- vm_vol_skills

-- ws_keys


-- INSERT DEFAULT GIS CLASSIFICATIONS

-- gis_layers
INSERT INTO gis_layers VALUES ('def_disaster_areas', 'Disaster Areas', '');
