Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 7.69 KB | None | 0 0
  1. ALTER TABLE category_training CHANGE url_img url_img VARCHAR(255) DEFAULT NULL;
  2.      ALTER TABLE scene CHANGE training_id training_id INT DEFAULT NULL;
  3.      ALTER TABLE four_images CHANGE training_id training_id INT DEFAULT NULL;
  4.      ALTER TABLE USER CHANGE infos_user_id infos_user_id INT DEFAULT NULL, CHANGE badge_id badge_id INT DEFAULT NULL, CHANGE salt salt VARCHAR(255) DEFAULT NULL, CHANGE last_login last_login DATETIME DEFAULT NULL, CHANGE confirmation_token confirmation_token VARCHAR(180) DEFAULT NULL, CHANGE password_requested_at password_requested_at DATETIME DEFAULT NULL, CHANGE date_inscription date_inscription DATE DEFAULT NULL, CHANGE sessid sessid VARCHAR(255) DEFAULT NULL;
  5.      ALTER TABLE image_quizz CHANGE training_id training_id INT DEFAULT NULL;
  6.      ALTER TABLE qcm CHANGE teacher_id teacher_id INT DEFAULT NULL, CHANGE TYPE TYPE INT DEFAULT NULL;
  7.      ALTER TABLE crossword CHANGE training_id training_id INT DEFAULT NULL;
  8.      ALTER TABLE test CHANGE formation_id formation_id INT DEFAULT NULL, CHANGE lien_test_entree lien_test_entree VARCHAR(255) DEFAULT NULL, CHANGE envoi_test_entree envoi_test_entree DATETIME DEFAULT NULL, CHANGE passage_test_entree passage_test_entree DATETIME DEFAULT NULL, CHANGE resultat_test_entree resultat_test_entree VARCHAR(255) DEFAULT NULL, CHANGE lien_test_sortie lien_test_sortie VARCHAR(255) DEFAULT NULL, CHANGE envoi_test_sortie envoi_test_sortie DATETIME DEFAULT NULL, CHANGE passage_test_sortie passage_test_sortie DATETIME DEFAULT NULL, CHANGE resultat_test_sortie resultat_test_sortie VARCHAR(255) DEFAULT NULL;
  9.      ALTER TABLE qcmquest CHANGE anecdote_id anecdote_id INT DEFAULT NULL, CHANGE url_img url_img VARCHAR(255) DEFAULT NULL;
  10.      ALTER TABLE opca CHANGE taux_horaire taux_horaire INT DEFAULT NULL, CHANGE delay_jour_opca delay_jour_opca INT DEFAULT NULL, CHANGE heure_max heure_max INT DEFAULT NULL, CHANGE comment comment VARCHAR(255) DEFAULT NULL, CHANGE contact_nom contact_nom VARCHAR(255) DEFAULT NULL, CHANGE contact_prenom contact_prenom VARCHAR(255) DEFAULT NULL, CHANGE contact_poste contact_poste VARCHAR(255) DEFAULT NULL, CHANGE contact_tel contact_tel VARCHAR(255) DEFAULT NULL, CHANGE contact_email contact_email VARCHAR(255) DEFAULT NULL, CHANGE accept_email accept_email INT DEFAULT NULL;
  11.      ALTER TABLE RESULT CHANGE user_id user_id INT DEFAULT NULL;
  12.      ALTER TABLE office_qcm CHANGE software_id software_id INT DEFAULT NULL, CHANGE image image VARCHAR(255) DEFAULT NULL, CHANGE texte texte VARCHAR(255) DEFAULT NULL;
  13.      ALTER TABLE training_content CHANGE content content MEDIUMTEXT NOT NULL;
  14.      ALTER TABLE lesson CHANGE software_id software_id INT DEFAULT NULL;
  15.      ALTER TABLE user_documents CHANGE formation_id formation_id INT DEFAULT NULL, CHANGE url url VARCHAR(255) DEFAULT NULL, CHANGE description description VARCHAR(255) DEFAULT NULL, CHANGE created_at created_at DATETIME DEFAULT NULL, CHANGE updated_at updated_at DATETIME DEFAULT NULL, CHANGE show_plateforme show_plateforme INT DEFAULT NULL, CHANGE bound_dossier bound_dossier INT DEFAULT NULL;
  16.      ALTER TABLE office_question CHANGE software_id software_id INT DEFAULT NULL;
  17.      ALTER TABLE god_father CHANGE firstname firstname VARCHAR(255) DEFAULT NULL, CHANGE lastname lastname VARCHAR(255) DEFAULT NULL, CHANGE mail mail VARCHAR(255) DEFAULT NULL, CHANGE phone phone VARCHAR(255) DEFAULT NULL;
  18.      ALTER TABLE hangman CHANGE training_id training_id INT DEFAULT NULL;
  19.      ALTER TABLE exercice CHANGE software_id software_id INT DEFAULT NULL;
  20.      ALTER TABLE infos_user CHANGE god_father_id god_father_id INT DEFAULT NULL, CHANGE training_id training_id INT DEFAULT NULL, CHANGE teacher_id teacher_id INT DEFAULT NULL, CHANGE software_id software_id INT DEFAULT NULL, CHANGE user_id user_id INT DEFAULT NULL, CHANGE birthday birthday DATE DEFAULT NULL, CHANGE city_birthday city_birthday VARCHAR(255) DEFAULT NULL, CHANGE address address VARCHAR(255) DEFAULT NULL, CHANGE phone phone VARCHAR(20) DEFAULT NULL, CHANGE etat etat DOUBLE PRECISION DEFAULT NULL, CHANGE cgu cgu TINYINT(1) DEFAULT NULL, CHANGE num_secu num_secu VARCHAR(255) DEFAULT NULL, CHANGE employer employer VARCHAR(255) DEFAULT NULL, CHANGE job job VARCHAR(255) DEFAULT NULL, CHANGE city city VARCHAR(255) DEFAULT NULL, CHANGE postal_code postal_code VARCHAR(255) DEFAULT NULL, CHANGE study_level study_level VARCHAR(255) DEFAULT NULL, CHANGE work_hours work_hours VARCHAR(255) DEFAULT NULL, CHANGE cpf_hours cpf_hours INT DEFAULT NULL, CHANGE mobile_hours mobile_hours INT DEFAULT NULL, CHANGE diff_hours diff_hours INT DEFAULT NULL, CHANGE gender gender VARCHAR(10) DEFAULT NULL, CHANGE naf_ape naf_ape VARCHAR(255) DEFAULT NULL, CHANGE siret siret VARCHAR(255) DEFAULT NULL, CHANGE contract_type contract_type VARCHAR(255) DEFAULT NULL, CHANGE cate_socio_pro cate_socio_pro VARCHAR(255) DEFAULT NULL, CHANGE time_contract time_contract VARCHAR(255) DEFAULT NULL, CHANGE reg_exec reg_exec VARCHAR(255) DEFAULT NULL, CHANGE reg_postal_code reg_postal_code VARCHAR(255) DEFAULT NULL, CHANGE expectations expectations VARCHAR(255) DEFAULT NULL, CHANGE url_bil url_bil VARCHAR(255) DEFAULT NULL, CHANGE url_dif url_dif VARCHAR(255) DEFAULT NULL, CHANGE url_profile url_profile VARCHAR(255) DEFAULT NULL, CHANGE other_reg other_reg VARCHAR(255) DEFAULT NULL, CHANGE confirm_teacher confirm_teacher INT DEFAULT NULL, CHANGE popup_accept_teacher popup_accept_teacher TINYINT(1) DEFAULT NULL, CHANGE current_formation_id current_formation_id INT DEFAULT NULL, CHANGE relance_logging_7_sent_at relance_logging_7_sent_at DATETIME DEFAULT NULL, CHANGE relance_logging_10_sent_at relance_logging_10_sent_at DATETIME DEFAULT NULL, CHANGE relance_register_2_sent_at relance_register_2_sent_at DATETIME DEFAULT NULL;
  21.      ALTER TABLE teacher CHANGE user_id user_id INT DEFAULT NULL, CHANGE reference reference VARCHAR(255) DEFAULT NULL, CHANGE url_cv url_cv VARCHAR(255) DEFAULT NULL, CHANGE STATUS STATUS VARCHAR(255) DEFAULT NULL, CHANGE url_diplome url_diplome VARCHAR(255) DEFAULT NULL, CHANGE per_hour per_hour VARCHAR(255) DEFAULT NULL, CHANGE siret siret VARCHAR(255) DEFAULT NULL, CHANGE need_test need_test VARCHAR(255) DEFAULT NULL, CHANGE contrat_signed contrat_signed VARCHAR(255) DEFAULT NULL, CHANGE motif_status motif_status VARCHAR(255) DEFAULT NULL, CHANGE url_test url_test VARCHAR(255) DEFAULT NULL, CHANGE url_appear_in url_appear_in VARCHAR(255) DEFAULT NULL, CHANGE url_calendly url_calendly VARCHAR(255) DEFAULT NULL;
  22.      ALTER TABLE breakout CHANGE training_id training_id INT DEFAULT NULL;
  23.      ALTER TABLE training CHANGE program_is_available program_is_available TINYINT(1) DEFAULT NULL, CHANGE is_valid is_valid TINYINT(1) DEFAULT NULL, CHANGE url_img url_img VARCHAR(255) DEFAULT NULL, CHANGE url_logo url_logo VARCHAR(255) DEFAULT NULL, CHANGE url_pdf url_pdf VARCHAR(255) DEFAULT NULL, CHANGE url_action url_action VARCHAR(255) DEFAULT NULL;
  24.      ALTER TABLE log CHANGE user_id user_id INT DEFAULT NULL, CHANGE TIME TIME INT DEFAULT NULL, CHANGE created_at created_at DATETIME DEFAULT NULL;
  25.      ALTER TABLE user_formation CHANGE debut_formation debut_formation DATETIME DEFAULT NULL, CHANGE fin_formation fin_formation DATETIME DEFAULT NULL, CHANGE montant montant DOUBLE PRECISION DEFAULT NULL, CHANGE paiement_opca paiement_opca DOUBLE PRECISION DEFAULT NULL, CHANGE paiement_etat paiement_etat INT DEFAULT NULL, CHANGE travail_temps_mobile travail_temps_mobile INT DEFAULT NULL, CHANGE lieu_formation lieu_formation VARCHAR(255) DEFAULT NULL, CHANGE examen examen VARCHAR(255) DEFAULT NULL, CHANGE comment comment VARCHAR(255) DEFAULT NULL, CHANGE etat_dossier_updated_at etat_dossier_updated_at DATETIME DEFAULT NULL, CHANGE date_envoi_dossier_opca date_envoi_dossier_opca DATETIME DEFAULT NULL;
  26.      ALTER TABLE module CHANGE software_id software_id INT DEFAULT NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement