UPDATE ddb_fields
  SET field_type_name='delimited_field', delimiter=';'
  WHERE field_name IN
    ('v_adm_req',
     'v_applicants_policies'
    );

UPDATE ddb_fields
  SET field_type_name='delimited_field', delimiter=';', col_delimiter=' - '
  WHERE field_name IN
    ('v_if_sat_req_recom'
    );

/* field group: GPA breakdown */
INSERT INTO ddb_fields (delimiter, col_delimiter, project_name, field_name, label, description, notes, suppress_if_null, decimal_places, footnote_applies_to, footnote_name, footnote_invert, field_type_name, create_index)
  VALUES(NULL,NULL,'best-colleges',
         'g_gpa_breakdown','GPA breakdown',
         NULL,'',0,NULL,NULL,NULL,0,'field_group',NULL);

INSERT INTO ddb_field_groups
  VALUES('best-colleges','g_gpa_breakdown','with_labels');

INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_lt_100',0,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_100_199',10,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_200_249',20,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_250_299',30,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_300_324',40,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_325_349',50,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_350_374',50,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_gpa_breakdown','pct_gpa_gt_375',50,NULL,'X');

INSERT INTO ddb_section_fields (project_name, section_name, field_name, field_order, omit_section_if_field_null)
  VALUES('best-colleges', 'HS_GPA', 'g_gpa_breakdown', 10, 0);


/* field group: Student body involved in Greek life */
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_student_body_in_greek_life','v_stu_frat_soro_pct',20,NULL,'X');

/* field group: Students required to live in school-owned, -operated, or -affiliated housing */
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_stu_req_hou','v_stu_req_liv_fre',0,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_stu_req_hou','v_stu_req_liv_sop',10,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_stu_req_hou','v_stu_req_liv_jun',20,NULL,'X');
INSERT INTO ddb_field_group_fields (project_name, field_group_name, sub_field_name, field_order, omit_field_group_if_field_null, display_label)
  VALUES('best-colleges','g_stu_req_hou','v_stu_req_liv_sen',30,NULL,'X');

UPDATE ddb_section_fields
  SET field_order=field_order+1
  WHERE section_name='General' AND field_order >=3;
INSERT INTO ddb_section_fields (project_name, section_name, field_name, field_order, omit_section_if_field_null)
  VALUES('best-colleges', 'General', 'g_stu_req_hou', 3, 0);