CREATE TABLE `postulation_guardian` (
   `serial_psg` int(11) NOT NULL AUTO_INCREMENT,
   `id_psg` varchar(45) DEFAULT NULL,
   `first_name_psg` varchar(45) DEFAULT NULL,
   `last_name_psg` varchar(45) DEFAULT NULL,
   `birthdate_grd` datetime DEFAULT NULL,
   `address_psg` varchar(200) DEFAULT NULL,
   `email_psg` varchar(200) DEFAULT NULL,
   `id_shipping_address_psg` varchar(100) DEFAULT NULL,
   `id_emai_altiora_psg` varchar(100) DEFAULT NULL,
   `created_psg` datetime DEFAULT NULL,
   `updated_psg` datetime DEFAULT NULL,
   `status_psg` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
   `id_altiora_psg` varchar(100) DEFAULT NULL,
   PRIMARY KEY (`serial_psg`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2185 DEFAULT CHARSET=latin1;
 
 
  CREATE TABLE postulation_guardian_student (
   `serial_pgs` int(11) NOT NULL AUTO_INCREMENT,
   `serial_psg` int(11) NOT NULL,
   `serial_pst` int(11) NOT NULL,
   `status_pgs` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
   `created_pgs` datetime DEFAULT NULL,
   `updated_pgs` datetime DEFAULT NULL,   
   PRIMARY KEY (`serial_pgs`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2185 DEFAULT CHARSET=latin1;
 
 alter table postulation_question add column type_user enum('STUDENT','GUARDIAN') NULL default 'STUDENT' after type_ppq;  
 alter table postulation_question add column order_question int(11) NULL after type_user; 
 alter table postulation_form add column type_pfr enum('ONLY_STUDENT','WITH_GUARDIAN') DEFAULT 'ONLY_STUDENT' NOT NULL after automatic_billing_pfr;
 alter table postulation_student_form add column serial_psg int(11) NULL after serial_pfr;
 
 
 alter table postulation_student_form add column identification_document varchar(350) NULL after serial_psg;

 INSERT INTO `postulation_question` (`serial_ppq`,`name_ppq`,`type_ppq`,`type_user`,`order_question`,`status_ppq`,`created_at`,`updated_at`) VALUES (18,'Tipo de documento de identificación','SELECT','GUARDIAN',1,'ACTIVE',NULL,NULL);
INSERT INTO `postulation_question` (`serial_ppq`,`name_ppq`,`type_ppq`,`type_user`,`order_question`,`status_ppq`,`created_at`,`updated_at`) VALUES (19,'Nombres (dos nombres)','DIRECTRESPONSE','GUARDIAN',3,'ACTIVE',NULL,NULL);
INSERT INTO `postulation_question` (`serial_ppq`,`name_ppq`,`type_ppq`,`type_user`,`order_question`,`status_ppq`,`created_at`,`updated_at`) VALUES (20,'Apellidos (dos apellidos)','DIRECTRESPONSE','GUARDIAN',4,'ACTIVE',NULL,NULL);
INSERT INTO `postulation_question` (`serial_ppq`,`name_ppq`,`type_ppq`,`type_user`,`order_question`,`status_ppq`,`created_at`,`updated_at`) VALUES (21,'Fecha de nacimiento','DATE','GUARDIAN',5,'ACTIVE',NULL,NULL);
INSERT INTO `postulation_question` (`serial_ppq`,`name_ppq`,`type_ppq`,`type_user`,`order_question`,`status_ppq`,`created_at`,`updated_at`) VALUES (22,'Número de cédula o pasaporte','DIRECTRESPONSE','GUARDIAN',2,'ACTIVE',NULL,NULL);
INSERT INTO `postulation_question` (`serial_ppq`,`name_ppq`,`type_ppq`,`type_user`,`order_question`,`status_ppq`,`created_at`,`updated_at`) VALUES (23,'Correo electrónico (De preferecia Gmail)','EMAIL','GUARDIAN',6,'ACTIVE',NULL,NULL);

alter table postulation_question modify column type_ppq enum('MULTIPLECHOISE','DIRECTRESPONSE','BOTH','SELECT','RADIO','CHECKBOX','DATE','EMAIL','FILE');
INSERT INTO `postulation_question` (`name_ppq`, `type_ppq`, `type_user`, `status_ppq`) VALUES ('Copia documento de identificación', 'FILE', 'STUDENT', 'ACTIVE');


UPDATE `postulation_question` SET `order_question`='1' WHERE `serial_ppq`='1';
UPDATE `postulation_question` SET `order_question`='2' WHERE `serial_ppq`='2';
UPDATE `postulation_question` SET `order_question`='3' WHERE `serial_ppq`='3';
UPDATE `postulation_question` SET `order_question`='4' WHERE `serial_ppq`='4';
UPDATE `postulation_question` SET `order_question`='5' WHERE `serial_ppq`='5';
UPDATE `postulation_question` SET `order_question`='6' WHERE `serial_ppq`='6';
UPDATE `postulation_question` SET `order_question`='7' WHERE `serial_ppq`='7';
UPDATE `postulation_question` SET `order_question`='8' WHERE `serial_ppq`='24';
UPDATE `postulation_question` SET `order_question`='9' WHERE `serial_ppq`='8';
UPDATE `postulation_question` SET `order_question`='10' WHERE `serial_ppq`='9';
UPDATE `postulation_question` SET `order_question`='11' WHERE `serial_ppq`='10';
UPDATE `postulation_question` SET `order_question`='12' WHERE `serial_ppq`='11';
UPDATE `postulation_question` SET `order_question`='13' WHERE `serial_ppq`='12';
UPDATE `postulation_question` SET `order_question`='14' WHERE `serial_ppq`='13';
UPDATE `postulation_question` SET `order_question`='15' WHERE `serial_ppq`='14';
UPDATE `postulation_question` SET `order_question`='16' WHERE `serial_ppq`='15';
