API tools faq
paste
Advertisement
Guest User

uodate 14h57

a guest
Dec 10th, 2018
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.01 KB | None | 0 0
raw download clone embed print report
  1. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E0372A1A3550 FOREIGN KEY (oblige_id) REFERENCES oblige (id);
  2. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E0377E0B0CDD FOREIGN KEY (invoicing_history_id) REFERENCES invoicing_history (id);
  3. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E037FEC09103 FOREIGN KEY (simulation_id) REFERENCES simulation (id);
  4. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E0378E5A180C FOREIGN KEY (offre_duo_id) REFERENCES offre_duo (id);
  5. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E037DD3F3B08 FOREIGN KEY (old_dossier_id) REFERENCES dossier (id);
  6. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E0379393F8FE FOREIGN KEY (partner_id) REFERENCES partner (id);
  7. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E0376885AC1B FOREIGN KEY (gestionnaire_id) REFERENCES user (id);
  8. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E0378510D4DE FOREIGN KEY (depot_id) REFERENCES depot (id);
  9. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E03761F7E04C FOREIGN KEY (ash_answer_id) REFERENCES ash_answer (id);
  10. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E0375ED3C7B7 FOREIGN KEY (artisan_id) REFERENCES artisan (id);
  11. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E037E7A1254A FOREIGN KEY (contact_id) REFERENCES user (id);
  12. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E03761220EA6 FOREIGN KEY (creator_id) REFERENCES user (id);
  13. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E037CCF9E01E FOREIGN KEY (departement_id) REFERENCES departement (id);
  14. ALTER TABLE dossier ADD CONSTRAINT FK_3D48E03720024E64 FOREIGN KEY (admin_simulation_id) REFERENCES simulation (id);
  15. CREATE UNIQUE INDEX UNIQ_3D48E03761F7E04C ON dossier (ash_answer_id);
  16. CREATE INDEX user_corporate_name ON dossier (user_corporate_name);
  17. CREATE INDEX status ON dossier (status);
  18. CREATE INDEX is_prime_sent ON dossier (is_prime_sent);
  19. CREATE INDEX preca_level ON dossier (preca_level);
  20. CREATE INDEX dossier_pay_partner_directly_idx ON dossier (pay_partner_directly);
  21. CREATE INDEX dossier_voucher_code_idx ON dossier (voucher_code);
  22. CREATE UNIQUE INDEX reference_index ON dossier (reference);
  23. DROP INDEX fk_3d48e037e7a1254a ON dossier;
  24. CREATE INDEX dossier_contact_id_idx ON dossier (contact_id);
  25. DROP INDEX fk_3d48e037fec09103 ON dossier;
  26. CREATE INDEX dossier_simulation_id_idx ON dossier (simulation_id);
  27. DROP INDEX fk_3d48e03720024e64 ON dossier;
  28. CREATE INDEX dossier_admin_simulation_id_idx ON dossier (admin_simulation_id);
  29. DROP INDEX fk_3d48e0379393f8fe ON dossier;
  30. CREATE INDEX dossier_partner_id_idx ON dossier (partner_id);
  31. DROP INDEX fk_3d48e037ccf9e01e ON dossier;
  32. CREATE INDEX dossier_departement_id_idx ON dossier (departement_id);
  33. DROP INDEX fk_3d48e0376885ac1b ON dossier;
  34. CREATE INDEX dossier_gestionnaire_id_idx ON dossier (gestionnaire_id);
  35. DROP INDEX fk_3d48e0375ed3c7b7 ON dossier;
  36. CREATE INDEX dossier_artisan_id_idx ON dossier (artisan_id);
  37. DROP INDEX fk_3d48e0372a1a3550 ON dossier;
  38. CREATE INDEX dossier_oblige_id_idx ON dossier (oblige_id);
  39. DROP INDEX fk_3d48e03761f7e04c ON dossier;
  40. CREATE INDEX dossier_ash_answer_id_idx ON dossier (ash_answer_id);
  41. DROP INDEX fk_3d48e037dd3f3b08 ON dossier;
  42. CREATE INDEX dossier_old_dossier_id_idx ON dossier (old_dossier_id);
  43. DROP INDEX fk_3d48e03761220ea6 ON dossier;
  44. CREATE INDEX dossier_creator_id_idx ON dossier (creator_id);
  45. DROP INDEX fk_3d48e0378e5a180c ON dossier;
  46. CREATE INDEX dossier_offre_duo_id_idx ON dossier (offre_duo_id);
  47. DROP INDEX fk_3d48e0378510d4de ON dossier;
  48. CREATE INDEX dossier_depot_id_idx ON dossier (depot_id);
  49. DROP INDEX fk_3d48e0377e0b0cdd ON dossier;
  50. CREATE INDEX invoicing_history_id ON dossier (invoicing_history_id);
  51. ALTER TABLE ash_resolved_problem CHANGE dossier_id dossier_id BIGINT NOT NULL, CHANGE controle_id controle_id BIGINT NOT NULL, ADD PRIMARY KEY (dossier_id, controle_id);
  52. ALTER TABLE ash_resolved_problem ADD CONSTRAINT FK_BFD07ED7611C0C56 FOREIGN KEY (dossier_id) REFERENCES dossier (id) ON DELETE CASCADE;
  53. ALTER TABLE ash_resolved_problem ADD CONSTRAINT FK_BFD07ED7758926A6 FOREIGN KEY (controle_id) REFERENCES controle (id) ON DELETE CASCADE;
  54. CREATE INDEX IDX_BFD07ED7611C0C56 ON ash_resolved_problem (dossier_id);
  55. CREATE INDEX IDX_BFD07ED7758926A6 ON ash_resolved_problem (controle_id);
  56. ALTER TABLE critere2 CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  57. ALTER TABLE critere2 ADD CONSTRAINT FK_E8C8D4C397F608B6 FOREIGN KEY (critere1_id) REFERENCES critere1 (id);
  58. CREATE INDEX critere2_critere1_id_idx ON critere2 (critere1_id);
  59. ALTER TABLE artisan_coverage CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  60. ALTER TABLE artisan_coverage ADD CONSTRAINT FK_3FD25C0C3919D70D FOREIGN KEY (eligible_id) REFERENCES eligible_work (id);
  61. ALTER TABLE artisan_coverage ADD CONSTRAINT FK_3FD25C0C3E23E247 FOREIGN KEY (dept_id) REFERENCES departement (id);
  62. CREATE INDEX artisan_coverage_dept_id_idx ON artisan_coverage (dept_id);
  63. CREATE INDEX artisan_coverage_eligible_id_idx ON artisan_coverage (eligible_id);
  64. ALTER TABLE work_ash_field CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  65. ALTER TABLE work_ash_field ADD CONSTRAINT FK_3590B58AD823E37A FOREIGN KEY (section_id) REFERENCES ash_section (id);
  66. ALTER TABLE work_ash_field ADD CONSTRAINT FK_3590B58AE12CC000 FOREIGN KEY (ash_field_id) REFERENCES ash_field (id);
  67. CREATE INDEX IDX_3590B58AD823E37A ON work_ash_field (section_id);
  68. CREATE UNIQUE INDEX UNIQ_3590B58AE12CC000 ON work_ash_field (ash_field_id);
  69. ALTER TABLE payment_details CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  70. ALTER TABLE payment_details ADD CONSTRAINT FK_6B6F0560611C0C56 FOREIGN KEY (dossier_id) REFERENCES dossier (id);
  71. ALTER TABLE payment_details ADD CONSTRAINT FK_6B6F05604C3A3BB FOREIGN KEY (payment_id) REFERENCES payment (id);
  72. CREATE INDEX payment_details_dossier_id_idx ON payment_details (dossier_id);
  73. CREATE INDEX payment_details_payment_id_idx ON payment_details (payment_id);
  74. CREATE UNIQUE INDEX payment_id_check_number_idx ON payment_details (payment_id, check_number);
  75. ALTER TABLE depot CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  76. ALTER TABLE depot ADD CONSTRAINT FK_47948BBC2A1A3550 FOREIGN KEY (oblige_id) REFERENCES oblige (id);
  77. ALTER TABLE depot ADD CONSTRAINT FK_47948BBC783E3463 FOREIGN KEY (manager_id) REFERENCES user (id);
  78. CREATE INDEX IDX_47948BBC783E3463 ON depot (manager_id);
  79. CREATE INDEX depot_oblige_id_idx ON depot (oblige_id);
  80. ALTER TABLE notification_campaign CHANGE id id INT AUTO_INCREMENT NOT NULL;
  81. ALTER TABLE emmy_code_travaux CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  82. ALTER TABLE emmy_travaux_columns ADD CONSTRAINT FK_E8FB24656BC56924 FOREIGN KEY (emmy_code_travaux_id) REFERENCES emmy_code_travaux (id) ON DELETE CASCADE;
  83. ALTER TABLE emmy_travaux_columns ADD CONSTRAINT FK_E8FB2465EA0C3A06 FOREIGN KEY (emmy_export_label_id) REFERENCES emmy_export_label (id) ON DELETE CASCADE;
  84. CREATE INDEX IDX_E8FB24656BC56924 ON emmy_travaux_columns (emmy_code_travaux_id);
  85. CREATE INDEX IDX_E8FB2465EA0C3A06 ON emmy_travaux_columns (emmy_export_label_id);
  86. ALTER TABLE video CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  87. ALTER TABLE ash_answer CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  88. ALTER TABLE ash_answer ADD CONSTRAINT FK_A90D31FEC1E2EFDD FOREIGN KEY (last_user_id) REFERENCES user (id);
  89. CREATE INDEX ash_answer_last_user_id_idx ON ash_answer (last_user_id);
  90. ALTER TABLE history CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  91. ALTER TABLE history ADD CONSTRAINT FK_27BA704BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id);
  92. ALTER TABLE history ADD CONSTRAINT FK_27BA704B611C0C56 FOREIGN KEY (dossier_id) REFERENCES dossier (id);
  93. CREATE INDEX history_dossier_id_idx ON history (dossier_id);
  94. CREATE INDEX history_user_id_idx ON history (user_id);
  95. CREATE INDEX history_action_idx ON history (action);
  96. ALTER TABLE value_assoc DROP FOREIGN KEY value_assoc_inputval_id_input_val_id;
  97. ALTER TABLE value_assoc DROP FOREIGN KEY value_assoc_resultval_id_result_val_id;
  98. DROP INDEX value_assoc_resultval_id_idx ON value_assoc;
  99. ALTER TABLE value_assoc CHANGE resultval_id resultval_id BIGINT NOT NULL, CHANGE inputval_id inputval_id BIGINT NOT NULL;
  100. ALTER TABLE value_assoc ADD CONSTRAINT FK_8435B23A3BD7FE0B FOREIGN KEY (resultval_id) REFERENCES result_val (id);
  101. ALTER TABLE value_assoc ADD CONSTRAINT FK_8435B23A12DD6133 FOREIGN KEY (inputval_id) REFERENCES input_val (id);
  102. ALTER TABLE email_log CHANGE id id BIGINT AUTO_INCREMENT NOT NULL;
  103. ALTER TABLE contact_history ADD CONSTRAINT FK_BD9551CAF624B39D FOREIGN KEY (sender_id) REFERENCES user (id);
  104. ALTER TABLE contact_history ADD CONSTRAINT FK_BD9551CAE92F8F78 FOREIGN KEY (recipient_id) REFERENCES user (id);
  105. ALTER TABLE contact_history ADD CONSTRAINT FK_BD9551CA611C0C56 FOREIGN KEY (dossier_id) REFERENCES dossier (id);
  106. ALTER TABLE contact_history ADD CONSTRAINT FK_BD9551CA2598C3C9 FOREIGN KEY (artisan_sender_id) REFERENCES artisan (id);
  107. ALTER TABLE contact_history ADD CONSTRAINT FK_BD9551CA6F728F96 FOREIGN KEY (artisan_recipient_id) REFERENCES artisan (id);
  108. CREATE INDEX contact_history_dossier_id_idx ON contact_history (dossier_id);
  109. CREATE INDEX contact_history_recipient_id_idx ON contact_history (recipient_id);
  110. CREATE INDEX contact_history_artisan_recipient_id_idx ON contact_history (artisan_recipient_id);
  111. CREATE INDEX contact_history_artisan_sender_id_idx ON contact_history (artisan_sender_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!