
CREATE TABLE `ipf`.`contact_form` (`id` INT(5) NOT NULL AUTO_INCREMENT , `full_name` VARCHAR(255) NOT NULL , `email` VARCHAR(50) NOT NULL , `country_code` VARCHAR(5) NOT NULL , `area_code` INT(10) NOT NULL , `phone_number` VARCHAR(10) NOT NULL , `organization` VARCHAR(50) NOT NULL , `country` VARCHAR(15) NOT NULL , `txt_message` VARCHAR(255) NOT NULL , `refer` VARCHAR(155) NOT NULL , PRIMARY KEY (`id`)) ENGINE = MyISAM;

CREATE TABLE `ipf`.`country_membership` ( `org_name` VARCHAR(20) NOT NULL , `org_email` VARCHAR(50) NOT NULL , `org_contact_fname` VARCHAR(20) NOT NULL , `org_contact_lname` VARCHAR(20) NOT NULL , `org_address` VARCHAR(150) NOT NULL , `org_address2` VARCHAR(150) NOT NULL , `org_city` VARCHAR(15) NOT NULL , `org_state` VARCHAR(15) NOT NULL , `org_country` VARCHAR(15) NOT NULL , `org_postal_code` INT(10) NOT NULL , `org_country_code` INT(5) NOT NULL , `org_area_code` INT(10) NOT NULL , `org_phone_number` INT(10) NOT NULL , `org_website` VARCHAR(50) NOT NULL , `org_president` VARCHAR(20) NOT NULL , `org_president_email` VARCHAR(50) NOT NULL , `org_vice_president` VARCHAR(20) NOT NULL , `org_vice_president_email` VARCHAR(50) NOT NULL , `org_secretary` VARCHAR(20) NOT NULL , `org_secretary_email` VARCHAR(50) NOT NULL , `org_treasurer` VARCHAR(20) NOT NULL , `org_treasurer_email` VARCHAR(50) NOT NULL , `org_question1` CHAR(10) NOT NULL , `org_question2` CHAR(10) NOT NULL , `org_question3` CHAR(10) NOT NULL , `org_question4` CHAR(25) NOT NULL , `org_question5` CHAR(10) NOT NULL , `org_file` VARCHAR(155) NOT NULL , `org_social_link` VARCHAR(25) NOT NULL , `org_question8` CHAR(10) NOT NULL , `org_question9` CHAR(10) NOT NULL , `org_question10` CHAR(10) NOT NULL , `org_file2` VARCHAR(155) NOT NULL , `org_acknowledge` CHAR(10) NOT NULL , `declaration_fname` VARCHAR(10) NOT NULL , `declaration_lname` VARCHAR(10) NOT NULL ) ENGINE = MyISAM;

ALTER TABLE `country_membership` ADD `count_mem_id` INT(5) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`count_mem_id`);

CREATE TABLE `ipf`.`diplomat_application` ( `dip_app_id` INT(5) NOT NULL , `title` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `first_name` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `last_name` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `last_name_suffix` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `address` VARCHAR(155) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `address2` VARCHAR(155) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `city` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `email` VARCHAR(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country_code` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `area_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `phone_number` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `continent` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `timezone` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `text_message` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_first_name` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_last_name` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_title_org` VARCHAR(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_email` VARCHAR(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_country_code` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_area_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_phone_number` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_first_name2` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_last_name2` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_title_org2` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_email2` VARCHAR(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_country_code2` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_area_code2` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_phone_number2` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_first_name3` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_last_name3` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_title_org3` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_email3` VARCHAR(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_country_code3` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_area_code3` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_phone_number3` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `mem_ipf` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `org_name` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `endorsed_int_dip` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `zoom` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `broadband` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `speak_languages` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `multiple_language` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `profile_photo` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `create_date` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ) ENGINE = MyISAM;

ALTER TABLE `diplomat_application` ADD `dip_app_id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`dip_app_id`);

ALTER TABLE `diplomat_application` CHANGE `last_name_suffix` `last_name_suffix` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL;


CREATE TABLE `ipf`.`volunteer_application` ( `title` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `first_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `last_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `last_name_suffix` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `address` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `address2` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `city` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `state` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `postal_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `email` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country_code` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `area_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `phone_number` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `continent` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `timezone` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `text_message` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_first_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_last_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_title_org` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_email` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_country_code` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_area_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_phone_number` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_first_name2` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_last_name2` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_title_org2` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_email2` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_country_code2` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_area_code2` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_phone_number2` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_first_name3` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_last_name3` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_title_org3` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_email3` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_country_code3` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_area_code3` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ref_phone_number3` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `member_ipf` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `org_name` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ipf_positionhold` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `current_position` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `zoom` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `broadband` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `speak_language` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `multiple_language` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `profile_photo` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `create_date` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ) ENGINE = MyISAM;


ALTER TABLE `volunteer_application` ADD `volunteer_id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`volunteer_id`);

ALTER TABLE `volunteer_application` ADD `org_position` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `volunteer_id`;

ALTER TABLE `volunteer_application` CHANGE `last_name_suffix` `last_name_suffix` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL;

CREATE TABLE `ipf`.`logo_submission` ( `first_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `last_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `artist_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `city` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `state` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `email` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `instagram` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `twitter` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `website` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country_code` VARCHAR(5) NOT NULL , `area_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `phone_number` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `artist_bio` VARCHAR(450) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `contest` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `term_condition` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ) ENGINE = MyISAM;

ALTER TABLE `logo_submission` ADD `logo_sub_id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`logo_sub_id`);

ALTER TABLE `logo_submission` CHANGE `country_code` `country_code` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL;

ALTER TABLE `logo_submission` ADD `create_date` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `term_condition`;

ALTER TABLE `logo_submission` ADD `upload_image1` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `term_condition`, ADD `upload_image2` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `upload_image1`, ADD `upload_image3` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `upload_image2`, ADD `upload_image4` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `upload_image3`;

ALTER TABLE `logo_submission` CHANGE `website` `website` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL;
ALTER TABLE `logo_submission` CHANGE `term_condition` `term_condition` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL;

CREATE TABLE `ipf`.`document_video_request` ( `document_video` VARCHAR(155) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `title` VARCHAR(6) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `first_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `last_name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `last_name_suffix` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `address` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `address2` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `city` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `state` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `postal_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `email` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `country_code` VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `area_code` INT(10) NOT NULL , `phone_number` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `reason` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `org_name` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `ipf_positionhold` CHAR(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL , `current_position` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ) ENGINE = MyISAM;

ALTER TABLE `document_video_request` ADD `doc_vid_id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`doc_vid_id`);

ALTER TABLE `document_video_request` ADD `create_date` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `current_position`;

ALTER TABLE `document_video_request` CHANGE `create_date` `create_date` DATE NOT NULL;