|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
declare(strict_types=1); |
|
4
|
|
|
|
|
5
|
|
|
namespace DoctrineMigrations; |
|
6
|
|
|
|
|
7
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
8
|
|
|
use Doctrine\Migrations\AbstractMigration; |
|
9
|
|
|
|
|
10
|
|
|
/** |
|
11
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
12
|
|
|
*/ |
|
13
|
|
|
final class Version20200704213812 extends AbstractMigration |
|
14
|
|
|
{ |
|
15
|
|
|
public function getDescription() : string |
|
16
|
|
|
{ |
|
17
|
|
|
return ''; |
|
18
|
|
|
} |
|
19
|
|
|
|
|
20
|
|
|
public function up(Schema $schema) : void |
|
21
|
|
|
{ |
|
22
|
|
|
// this up() migration is auto-generated, please modify it to your needs |
|
23
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
|
|
|
|
|
24
|
|
|
|
|
25
|
|
|
$this->addSql('CREATE TABLE user (id INT UNSIGNED AUTO_INCREMENT NOT NULL, teacher_id INT UNSIGNED DEFAULT NULL, idp_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', username VARCHAR(255) NOT NULL, firstname VARCHAR(255) DEFAULT NULL, lastname VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', user_type VARCHAR(255) NOT NULL COMMENT \'(DC2Type:user_type)\', is_substitution_notifications_enabled TINYINT(1) NOT NULL, is_exam_notifications_enabled TINYINT(1) NOT NULL, is_message_notifications_enabled TINYINT(1) NOT NULL, is_email_notifications_enabled TINYINT(1) NOT NULL, data LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), INDEX IDX_8D93D64941807E1D (teacher_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
26
|
|
|
$this->addSql('CREATE TABLE user_students (user_id INT UNSIGNED NOT NULL, student_id INT UNSIGNED NOT NULL, INDEX IDX_44E469B2A76ED395 (user_id), INDEX IDX_44E469B2CB944F1A (student_id), PRIMARY KEY(user_id, student_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
27
|
|
|
$this->addSql('CREATE TABLE user_dismissed_messages (user_id INT UNSIGNED NOT NULL, message_id INT UNSIGNED NOT NULL, INDEX IDX_E1D43738A76ED395 (user_id), INDEX IDX_E1D43738537A1329 (message_id), PRIMARY KEY(user_id, message_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
28
|
|
|
$this->addSql('CREATE TABLE absence (id INT UNSIGNED AUTO_INCREMENT NOT NULL, teacher_id INT UNSIGNED DEFAULT NULL, study_group_id INT UNSIGNED DEFAULT NULL, room_id INT UNSIGNED DEFAULT NULL, date DATE NOT NULL, lesson_start INT DEFAULT NULL, lesson_end INT DEFAULT NULL, INDEX IDX_765AE0C941807E1D (teacher_id), INDEX IDX_765AE0C95DDDCCCE (study_group_id), INDEX IDX_765AE0C954177093 (room_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
29
|
|
|
$this->addSql('CREATE TABLE appointment (id INT UNSIGNED AUTO_INCREMENT NOT NULL, category_id INT UNSIGNED DEFAULT NULL, external_id VARCHAR(255) DEFAULT NULL, title VARCHAR(255) NOT NULL, content LONGTEXT DEFAULT NULL, start DATETIME NOT NULL, end DATETIME DEFAULT NULL, location VARCHAR(255) DEFAULT NULL, all_day TINYINT(1) NOT NULL, mark_students_absent TINYINT(1) NOT NULL, external_organizers VARCHAR(255) DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_FE38F8449F75D7B0 (external_id), INDEX IDX_FE38F84412469DE2 (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
30
|
|
|
$this->addSql('CREATE TABLE appointment_studygroups (appointment_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_5EE7E790E5B533F9 (appointment_id), INDEX IDX_5EE7E7905DDDCCCE (study_group_id), PRIMARY KEY(appointment_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
31
|
|
|
$this->addSql('CREATE TABLE appointment_organizers (appointment_id INT UNSIGNED NOT NULL, teacher_id INT UNSIGNED NOT NULL, INDEX IDX_ABD20936E5B533F9 (appointment_id), INDEX IDX_ABD2093641807E1D (teacher_id), PRIMARY KEY(appointment_id, teacher_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
32
|
|
|
$this->addSql('CREATE TABLE appointment_visibilities (appointment_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_9A6E5842E5B533F9 (appointment_id), INDEX IDX_9A6E58425E66E314 (user_type_entity_id), PRIMARY KEY(appointment_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
33
|
|
|
$this->addSql('CREATE TABLE appointment_category (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) DEFAULT NULL, name VARCHAR(255) NOT NULL, color VARCHAR(255) DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_336892099F75D7B0 (external_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
34
|
|
|
$this->addSql('CREATE TABLE document (id INT UNSIGNED AUTO_INCREMENT NOT NULL, category_id INT UNSIGNED DEFAULT NULL, title VARCHAR(255) NOT NULL, content LONGTEXT NOT NULL, updated_at DATETIME NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_D8698A7612469DE2 (category_id), FULLTEXT INDEX IDX_D8698A762B36786B (title), FULLTEXT INDEX IDX_D8698A76FEC530A9 (content), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
35
|
|
|
$this->addSql('CREATE TABLE document_studygroups (document_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_A786B266C33F7837 (document_id), INDEX IDX_A786B2665DDDCCCE (study_group_id), PRIMARY KEY(document_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
36
|
|
|
$this->addSql('CREATE TABLE document_visibilities (document_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_CE496E3EC33F7837 (document_id), INDEX IDX_CE496E3E5E66E314 (user_type_entity_id), PRIMARY KEY(document_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
37
|
|
|
$this->addSql('CREATE TABLE document_authors (document_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, INDEX IDX_2A638C8DC33F7837 (document_id), INDEX IDX_2A638C8DA76ED395 (user_id), PRIMARY KEY(document_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
38
|
|
|
$this->addSql('CREATE TABLE document_attachment (id INT UNSIGNED AUTO_INCREMENT NOT NULL, document_id INT UNSIGNED DEFAULT NULL, filename LONGTEXT NOT NULL, path VARCHAR(255) NOT NULL, size INT NOT NULL, updated_at DATETIME NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_D89C72EDC33F7837 (document_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
39
|
|
|
$this->addSql('CREATE TABLE document_category (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
40
|
|
|
$this->addSql('CREATE TABLE exam (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) DEFAULT NULL, date DATE DEFAULT NULL, lesson_start INT NOT NULL, lesson_end INT NOT NULL, description VARCHAR(255) DEFAULT NULL, rooms LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_38BBA6C69F75D7B0 (external_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
41
|
|
|
$this->addSql('CREATE TABLE exam_tuitions (exam_id INT UNSIGNED NOT NULL, tuition_id INT UNSIGNED NOT NULL, INDEX IDX_A472BA1A578D5E91 (exam_id), INDEX IDX_A472BA1A7FFA6BA (tuition_id), PRIMARY KEY(exam_id, tuition_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
42
|
|
|
$this->addSql('CREATE TABLE exam_students (exam_id INT UNSIGNED NOT NULL, student_id INT UNSIGNED NOT NULL, INDEX IDX_E70DC281578D5E91 (exam_id), INDEX IDX_E70DC281CB944F1A (student_id), PRIMARY KEY(exam_id, student_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
43
|
|
|
$this->addSql('CREATE TABLE exam_supervision (id INT UNSIGNED AUTO_INCREMENT NOT NULL, exam_id INT UNSIGNED DEFAULT NULL, teacher_id INT UNSIGNED DEFAULT NULL, lesson INT NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_2BD1F5C1578D5E91 (exam_id), INDEX IDX_2BD1F5C141807E1D (teacher_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
44
|
|
|
$this->addSql('CREATE TABLE timetable_lesson (id INT UNSIGNED AUTO_INCREMENT NOT NULL, period_id INT UNSIGNED DEFAULT NULL, week_id INT UNSIGNED DEFAULT NULL, tuition_id INT UNSIGNED DEFAULT NULL, room_id INT UNSIGNED DEFAULT NULL, external_id VARCHAR(255) NOT NULL, day INT NOT NULL, lesson INT NOT NULL, is_double_lesson TINYINT(1) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', `type` VARCHAR(255) NOT NULL, subject VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_2628C7279F75D7B0 (external_id), INDEX IDX_2628C727EC8B7ADE (period_id), INDEX IDX_2628C727C86F3B2F (week_id), INDEX IDX_2628C7277FFA6BA (tuition_id), INDEX IDX_2628C72754177093 (room_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
45
|
|
|
$this->addSql('CREATE TABLE timetable_lesson_teachers (timetable_lesson_id INT UNSIGNED NOT NULL, teacher_id INT UNSIGNED NOT NULL, INDEX IDX_78936A02EA4D7C00 (timetable_lesson_id), INDEX IDX_78936A0241807E1D (teacher_id), PRIMARY KEY(timetable_lesson_id, teacher_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
46
|
|
|
$this->addSql('CREATE TABLE grade (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) DEFAULT NULL, name VARCHAR(255) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_595AAE349F75D7B0 (external_id), UNIQUE INDEX UNIQ_595AAE345E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
47
|
|
|
$this->addSql('CREATE TABLE grade_teacher (teacher_id INT UNSIGNED NOT NULL, grade_id INT UNSIGNED NOT NULL, type VARCHAR(255) NOT NULL COMMENT \'(DC2Type:grade_teacher_type)\', INDEX IDX_4ABB343741807E1D (teacher_id), INDEX IDX_4ABB3437FE19A1A8 (grade_id), PRIMARY KEY(teacher_id, grade_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
48
|
|
|
$this->addSql('CREATE TABLE ics_access_token (id INT UNSIGNED AUTO_INCREMENT NOT NULL, user_id INT UNSIGNED DEFAULT NULL, token VARCHAR(128) NOT NULL, type VARCHAR(255) NOT NULL COMMENT \'(DC2Type:ics_access_token_type)\', name VARCHAR(255) NOT NULL, registered DATETIME NOT NULL, last_active DATETIME DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_2E41884B5F37A13B (token), INDEX IDX_2E41884BA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
49
|
|
|
$this->addSql('CREATE TABLE import_date_time (id INT UNSIGNED AUTO_INCREMENT NOT NULL, entity_class VARCHAR(255) NOT NULL, updated_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_128BA50D41BF2C66 (entity_class), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
50
|
|
|
$this->addSql('CREATE TABLE infotext (id INT UNSIGNED AUTO_INCREMENT NOT NULL, date DATE NOT NULL, content LONGTEXT NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
51
|
|
|
$this->addSql('CREATE TABLE message (id INT UNSIGNED AUTO_INCREMENT NOT NULL, created_by_id INT UNSIGNED DEFAULT NULL, updated_by_id INT UNSIGNED DEFAULT NULL, title VARCHAR(255) NOT NULL, content LONGTEXT NOT NULL, start_date DATETIME NOT NULL, expire_date DATETIME NOT NULL, scope VARCHAR(255) NOT NULL COMMENT \'(DC2Type:message_scope)\', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, is_downloads_enabled TINYINT(1) NOT NULL, is_uploads_enabled TINYINT(1) NOT NULL, upload_description LONGTEXT DEFAULT NULL, is_email_notification_sent TINYINT(1) NOT NULL, is_push_notification_sent TINYINT(1) NOT NULL, must_confirm TINYINT(1) NOT NULL, priority VARCHAR(255) NOT NULL COMMENT \'(DC2Type:message_priority)\', uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_B6BD307FB03A8386 (created_by_id), INDEX IDX_B6BD307F896DBBDE (updated_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
52
|
|
|
$this->addSql('CREATE TABLE message_studygroups (message_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_4550DBF5537A1329 (message_id), INDEX IDX_4550DBF55DDDCCCE (study_group_id), PRIMARY KEY(message_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
53
|
|
|
$this->addSql('CREATE TABLE message_visibilities (message_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_A7AD7AA9537A1329 (message_id), INDEX IDX_A7AD7AA95E66E314 (user_type_entity_id), PRIMARY KEY(message_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
54
|
|
|
$this->addSql('CREATE TABLE message_download_usertypes (message_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_38D89C91537A1329 (message_id), INDEX IDX_38D89C915E66E314 (user_type_entity_id), PRIMARY KEY(message_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
55
|
|
|
$this->addSql('CREATE TABLE message_download_studygroups (message_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_638F7119537A1329 (message_id), INDEX IDX_638F71195DDDCCCE (study_group_id), PRIMARY KEY(message_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
56
|
|
|
$this->addSql('CREATE TABLE message_upload_usertypes (message_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_17AD59BA537A1329 (message_id), INDEX IDX_17AD59BA5E66E314 (user_type_entity_id), PRIMARY KEY(message_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
57
|
|
|
$this->addSql('CREATE TABLE message_upload_studygroups (message_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_FEF1953A537A1329 (message_id), INDEX IDX_FEF1953A5DDDCCCE (study_group_id), PRIMARY KEY(message_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
58
|
|
|
$this->addSql('CREATE TABLE message_confirmation_usertypes (message_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_7F22A1537A1329 (message_id), INDEX IDX_7F22A15E66E314 (user_type_entity_id), PRIMARY KEY(message_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
59
|
|
|
$this->addSql('CREATE TABLE message_confirmation_studygroups (message_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_9010E1C6537A1329 (message_id), INDEX IDX_9010E1C65DDDCCCE (study_group_id), PRIMARY KEY(message_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
60
|
|
|
$this->addSql('CREATE TABLE message_attachment (id INT UNSIGNED AUTO_INCREMENT NOT NULL, message_id INT UNSIGNED DEFAULT NULL, filename VARCHAR(255) NOT NULL, path VARCHAR(255) NOT NULL, size INT NOT NULL, updated_at DATETIME NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_B68FF524537A1329 (message_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
61
|
|
|
$this->addSql('CREATE TABLE message_confirmation (message_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_8C3C27DA537A1329 (message_id), INDEX IDX_8C3C27DAA76ED395 (user_id), PRIMARY KEY(message_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
62
|
|
|
$this->addSql('CREATE TABLE message_file (id INT UNSIGNED AUTO_INCREMENT NOT NULL, message_id INT UNSIGNED DEFAULT NULL, label VARCHAR(255) NOT NULL, extension VARCHAR(255) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_250AADC9537A1329 (message_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
63
|
|
|
$this->addSql('CREATE TABLE message_file_upload (message_file_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, filename VARCHAR(255) DEFAULT NULL, path VARCHAR(255) DEFAULT NULL, size INT DEFAULT NULL, updated_at DATETIME NOT NULL, INDEX IDX_CFD59E593434360 (message_file_id), INDEX IDX_CFD59E59A76ED395 (user_id), PRIMARY KEY(message_file_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
64
|
|
|
$this->addSql('CREATE TABLE oauth_client_info (id INT UNSIGNED AUTO_INCREMENT NOT NULL, client_id VARCHAR(32) DEFAULT NULL, name VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_46345E9E19EB6921 (client_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
65
|
|
|
$this->addSql('CREATE TABLE privacy_category (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) DEFAULT NULL, label VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_1B8576429F75D7B0 (external_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
66
|
|
|
$this->addSql('CREATE TABLE room (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) DEFAULT NULL, name VARCHAR(16) NOT NULL, `description` LONGTEXT DEFAULT NULL, capacity INT DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_729F519B9F75D7B0 (external_id), UNIQUE INDEX UNIQ_729F519B5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
67
|
|
|
$this->addSql('CREATE TABLE room_reservation (id INT UNSIGNED AUTO_INCREMENT NOT NULL, room_id INT UNSIGNED DEFAULT NULL, teacher_id INT UNSIGNED DEFAULT NULL, date DATE NOT NULL, lesson_start INT NOT NULL, lesson_end INT NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_56FDE76A54177093 (room_id), INDEX IDX_56FDE76A41807E1D (teacher_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
68
|
|
|
$this->addSql('CREATE TABLE room_tag (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, description LONGTEXT DEFAULT NULL, has_value TINYINT(1) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
69
|
|
|
$this->addSql('CREATE TABLE room_roomtags (room_id INT UNSIGNED NOT NULL, tag_id INT UNSIGNED NOT NULL, value INT DEFAULT NULL, INDEX IDX_80B7F00554177093 (room_id), INDEX IDX_80B7F005BAD26311 (tag_id), PRIMARY KEY(room_id, tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
70
|
|
|
$this->addSql('CREATE TABLE setting (`key` VARCHAR(255) NOT NULL, value LONGTEXT NOT NULL COMMENT \'(DC2Type:object)\', PRIMARY KEY(`key`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
71
|
|
|
$this->addSql('CREATE TABLE student (id INT UNSIGNED AUTO_INCREMENT NOT NULL, grade_id INT UNSIGNED DEFAULT NULL, external_id VARCHAR(255) NOT NULL, firstname VARCHAR(255) NOT NULL, lastname VARCHAR(255) NOT NULL, gender VARCHAR(255) NOT NULL COMMENT \'(DC2Type:gender)\', email VARCHAR(255) DEFAULT NULL, status VARCHAR(255) DEFAULT NULL, is_full_aged TINYINT(1) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_B723AF339F75D7B0 (external_id), INDEX IDX_B723AF33FE19A1A8 (grade_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
72
|
|
|
$this->addSql('CREATE TABLE student_approved_privacy_categories (student_id INT UNSIGNED NOT NULL, privacy_category_id INT UNSIGNED NOT NULL, INDEX IDX_42D136F6CB944F1A (student_id), INDEX IDX_42D136F6F1E8355A (privacy_category_id), PRIMARY KEY(student_id, privacy_category_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
73
|
|
|
$this->addSql('CREATE TABLE study_group (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL COMMENT \'(DC2Type:study_group_type)\', uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_32BA14259F75D7B0 (external_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
74
|
|
|
$this->addSql('CREATE TABLE study_group_grades (study_group_id INT UNSIGNED NOT NULL, grade_id INT UNSIGNED NOT NULL, INDEX IDX_C647F0BA5DDDCCCE (study_group_id), INDEX IDX_C647F0BAFE19A1A8 (grade_id), PRIMARY KEY(study_group_id, grade_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
75
|
|
|
$this->addSql('CREATE TABLE study_group_membership (study_group_id INT UNSIGNED NOT NULL, student_id INT UNSIGNED NOT NULL, type VARCHAR(255) DEFAULT NULL, INDEX IDX_26983EF95DDDCCCE (study_group_id), INDEX IDX_26983EF9CB944F1A (student_id), PRIMARY KEY(study_group_id, student_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
76
|
|
|
$this->addSql('CREATE TABLE subject (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) DEFAULT NULL, abbreviation VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, replace_subject_abbreviation TINYINT(1) NOT NULL, is_visible_grades TINYINT(1) NOT NULL, is_visible_students TINYINT(1) NOT NULL, is_visible_teachers TINYINT(1) NOT NULL, is_visible_rooms TINYINT(1) NOT NULL, is_visible_subjects TINYINT(1) NOT NULL, is_visible_lists TINYINT(1) NOT NULL, color VARCHAR(255) DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_FBCE3E7A9F75D7B0 (external_id), UNIQUE INDEX UNIQ_FBCE3E7ABCF3411D (abbreviation), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
77
|
|
|
$this->addSql('CREATE TABLE substitution (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) NOT NULL, date DATE NOT NULL, lesson_start INT NOT NULL, lesson_end INT NOT NULL, starts_before TINYINT(1) NOT NULL, type VARCHAR(255) DEFAULT NULL, subject VARCHAR(255) DEFAULT NULL, replacement_subject VARCHAR(255) DEFAULT NULL, room VARCHAR(255) DEFAULT NULL, replacement_room VARCHAR(255) DEFAULT NULL, remark VARCHAR(255) DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_C7C90AE09F75D7B0 (external_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
78
|
|
|
$this->addSql('CREATE TABLE substitution_teachers (substitution_id INT UNSIGNED NOT NULL, teacher_id INT UNSIGNED NOT NULL, INDEX IDX_3D5933E1D7F487C9 (substitution_id), INDEX IDX_3D5933E141807E1D (teacher_id), PRIMARY KEY(substitution_id, teacher_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
79
|
|
|
$this->addSql('CREATE TABLE substitution_replacement_teachers (substitution_id INT UNSIGNED NOT NULL, teacher_id INT UNSIGNED NOT NULL, INDEX IDX_DA62411DD7F487C9 (substitution_id), INDEX IDX_DA62411D41807E1D (teacher_id), PRIMARY KEY(substitution_id, teacher_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
80
|
|
|
$this->addSql('CREATE TABLE substitution_studygroups (substitution_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_89A42774D7F487C9 (substitution_id), INDEX IDX_89A427745DDDCCCE (study_group_id), PRIMARY KEY(substitution_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
81
|
|
|
$this->addSql('CREATE TABLE substitution_replacement_studygroups (substitution_id INT UNSIGNED NOT NULL, study_group_id INT UNSIGNED NOT NULL, INDEX IDX_99785F77D7F487C9 (substitution_id), INDEX IDX_99785F775DDDCCCE (study_group_id), PRIMARY KEY(substitution_id, study_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
82
|
|
|
$this->addSql('CREATE TABLE teacher (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) NOT NULL, acronym VARCHAR(255) NOT NULL, title VARCHAR(255) DEFAULT NULL, firstname VARCHAR(255) NOT NULL, lastname VARCHAR(255) NOT NULL, gender VARCHAR(255) NOT NULL COMMENT \'(DC2Type:gender)\', email VARCHAR(255) DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_B0F6A6D59F75D7B0 (external_id), UNIQUE INDEX UNIQ_B0F6A6D5512D8851 (acronym), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
83
|
|
|
$this->addSql('CREATE TABLE teacher_subjects (teacher_id INT UNSIGNED NOT NULL, subject_id INT UNSIGNED NOT NULL, INDEX IDX_AA332A9C41807E1D (teacher_id), INDEX IDX_AA332A9C23EDC87 (subject_id), PRIMARY KEY(teacher_id, subject_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
84
|
|
|
$this->addSql('CREATE TABLE teacher_tags (teacher_id INT UNSIGNED NOT NULL, teacher_tag_id INT UNSIGNED NOT NULL, INDEX IDX_4E00F31741807E1D (teacher_id), INDEX IDX_4E00F317AF59B1E4 (teacher_tag_id), PRIMARY KEY(teacher_id, teacher_tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
85
|
|
|
$this->addSql('CREATE TABLE teacher_tag (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(32) NOT NULL, name VARCHAR(255) NOT NULL, color VARCHAR(7) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_B1A33B79F75D7B0 (external_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
86
|
|
|
$this->addSql('CREATE TABLE timetable_period (id INT UNSIGNED AUTO_INCREMENT NOT NULL, external_id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, start DATETIME NOT NULL, end DATETIME NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_1BE4AD1A9F75D7B0 (external_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
87
|
|
|
$this->addSql('CREATE TABLE timetable_period_visibilities (timetable_period_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_1954F2D6CB3E0748 (timetable_period_id), INDEX IDX_1954F2D65E66E314 (user_type_entity_id), PRIMARY KEY(timetable_period_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
88
|
|
|
$this->addSql('CREATE TABLE timetable_supervision (id INT UNSIGNED AUTO_INCREMENT NOT NULL, period_id INT UNSIGNED DEFAULT NULL, week_id INT UNSIGNED DEFAULT NULL, teacher_id INT UNSIGNED DEFAULT NULL, external_id VARCHAR(255) NOT NULL, day INT NOT NULL, lesson INT NOT NULL, is_before TINYINT(1) NOT NULL, location VARCHAR(255) NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_396D5F689F75D7B0 (external_id), INDEX IDX_396D5F68EC8B7ADE (period_id), INDEX IDX_396D5F68C86F3B2F (week_id), INDEX IDX_396D5F6841807E1D (teacher_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
89
|
|
|
$this->addSql('CREATE TABLE timetable_week (id INT UNSIGNED AUTO_INCREMENT NOT NULL, `key` VARCHAR(255) NOT NULL, display_name VARCHAR(255) NOT NULL, week_mod INT NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_CE6683CE4E645A7E (`key`), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
90
|
|
|
$this->addSql('CREATE TABLE tuition (id INT UNSIGNED AUTO_INCREMENT NOT NULL, subject_id INT UNSIGNED DEFAULT NULL, teacher_id INT UNSIGNED DEFAULT NULL, study_group_id INT UNSIGNED DEFAULT NULL, external_id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, display_name VARCHAR(255) DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', UNIQUE INDEX UNIQ_A1B25E5B9F75D7B0 (external_id), INDEX IDX_A1B25E5B23EDC87 (subject_id), INDEX IDX_A1B25E5B41807E1D (teacher_id), INDEX IDX_A1B25E5B5DDDCCCE (study_group_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
91
|
|
|
$this->addSql('CREATE TABLE tuition_additional_teachers (tuition_id INT UNSIGNED NOT NULL, teacher_id INT UNSIGNED NOT NULL, INDEX IDX_CD0280547FFA6BA (tuition_id), INDEX IDX_CD02805441807E1D (teacher_id), PRIMARY KEY(tuition_id, teacher_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
92
|
|
|
$this->addSql('CREATE TABLE user_type_entity (id INT UNSIGNED AUTO_INCREMENT NOT NULL, user_type VARCHAR(255) NOT NULL COMMENT \'(DC2Type:user_type)\', UNIQUE INDEX UNIQ_84E4E6C5F65F1BE0 (user_type), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
93
|
|
|
$this->addSql('CREATE TABLE user_web_push_subscription (id INT UNSIGNED AUTO_INCREMENT NOT NULL, user_id INT UNSIGNED DEFAULT NULL, subscription_hash VARCHAR(255) NOT NULL, subscription LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', INDEX IDX_260A81F9A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
94
|
|
|
$this->addSql('CREATE TABLE wiki (id INT UNSIGNED AUTO_INCREMENT NOT NULL, root_id INT UNSIGNED DEFAULT NULL, title VARCHAR(255) NOT NULL, is_online TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, content LONGTEXT NOT NULL, `left` INT NOT NULL, level INT NOT NULL, `right` INT NOT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', `parent` INT UNSIGNED DEFAULT NULL, INDEX IDX_22CDDC0679066886 (root_id), INDEX IDX_22CDDC06514BFC18 (`parent`), FULLTEXT INDEX IDX_22CDDC062B36786B (title), FULLTEXT INDEX IDX_22CDDC06FEC530A9 (content), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
95
|
|
|
$this->addSql('CREATE TABLE wiki_article_visibilities (wiki_article_id INT UNSIGNED NOT NULL, user_type_entity_id INT UNSIGNED NOT NULL, INDEX IDX_2E45B22D4E9C5254 (wiki_article_id), INDEX IDX_2E45B22D5E66E314 (user_type_entity_id), PRIMARY KEY(wiki_article_id, user_type_entity_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
96
|
|
|
$this->addSql('CREATE TABLE ext_log_entries (id INT AUTO_INCREMENT NOT NULL, action VARCHAR(8) NOT NULL, logged_at DATETIME NOT NULL, object_id VARCHAR(64) DEFAULT NULL, object_class VARCHAR(255) NOT NULL, version INT NOT NULL, data LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', username VARCHAR(255) DEFAULT NULL, INDEX log_class_lookup_idx (object_class), INDEX log_date_lookup_idx (logged_at), INDEX log_user_lookup_idx (username), INDEX log_version_lookup_idx (object_id, object_class, version), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC'); |
|
97
|
|
|
$this->addSql('CREATE TABLE id_entity (entity_id VARCHAR(255) NOT NULL, id VARCHAR(255) NOT NULL, expiry DATETIME NOT NULL, PRIMARY KEY(entity_id, id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
98
|
|
|
$this->addSql('CREATE TABLE log (id INT AUTO_INCREMENT NOT NULL, channel VARCHAR(255) NOT NULL, level INT NOT NULL, message LONGTEXT NOT NULL, time DATETIME NOT NULL, details LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
99
|
|
|
$this->addSql('CREATE TABLE cron_job (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, command VARCHAR(255) NOT NULL, arguments VARCHAR(255) DEFAULT NULL, description VARCHAR(255) DEFAULT NULL, running_instances INT UNSIGNED DEFAULT 0 NOT NULL, max_instances INT UNSIGNED DEFAULT 1 NOT NULL, number INT UNSIGNED DEFAULT 1 NOT NULL, period VARCHAR(255) NOT NULL, last_use DATETIME DEFAULT NULL, next_run DATETIME NOT NULL, enable TINYINT(1) DEFAULT \'1\' NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
100
|
|
|
$this->addSql('CREATE TABLE cron_job_result (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, cron_job_id BIGINT UNSIGNED NOT NULL, run_at DATETIME NOT NULL, run_time DOUBLE PRECISION NOT NULL, status_code INT NOT NULL, output LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_2CD346EE79099ED8 (cron_job_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
101
|
|
|
$this->addSql('CREATE TABLE oauth2_access_token (identifier CHAR(80) NOT NULL, client VARCHAR(32) NOT NULL, expiry DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', user_identifier VARCHAR(128) DEFAULT NULL, scopes TEXT DEFAULT NULL COMMENT \'(DC2Type:oauth2_scope)\', revoked TINYINT(1) NOT NULL, INDEX IDX_454D9673C7440455 (client), PRIMARY KEY(identifier)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
102
|
|
|
$this->addSql('CREATE TABLE oauth2_authorization_code (identifier CHAR(80) NOT NULL, client VARCHAR(32) NOT NULL, expiry DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', user_identifier VARCHAR(128) DEFAULT NULL, scopes TEXT DEFAULT NULL COMMENT \'(DC2Type:oauth2_scope)\', revoked TINYINT(1) NOT NULL, INDEX IDX_509FEF5FC7440455 (client), PRIMARY KEY(identifier)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
103
|
|
|
$this->addSql('CREATE TABLE oauth2_client (identifier VARCHAR(32) NOT NULL, secret VARCHAR(128) DEFAULT NULL, redirect_uris TEXT DEFAULT NULL COMMENT \'(DC2Type:oauth2_redirect_uri)\', grants TEXT DEFAULT NULL COMMENT \'(DC2Type:oauth2_grant)\', scopes TEXT DEFAULT NULL COMMENT \'(DC2Type:oauth2_scope)\', active TINYINT(1) NOT NULL, allow_plain_text_pkce TINYINT(1) DEFAULT \'0\' NOT NULL, PRIMARY KEY(identifier)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
104
|
|
|
$this->addSql('CREATE TABLE oauth2_refresh_token (identifier CHAR(80) NOT NULL, access_token CHAR(80) DEFAULT NULL, expiry DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', revoked TINYINT(1) NOT NULL, INDEX IDX_4DD90732B6A2DD68 (access_token), PRIMARY KEY(identifier)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'); |
|
105
|
|
|
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D64941807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE SET NULL'); |
|
106
|
|
|
$this->addSql('ALTER TABLE user_students ADD CONSTRAINT FK_44E469B2A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
107
|
|
|
$this->addSql('ALTER TABLE user_students ADD CONSTRAINT FK_44E469B2CB944F1A FOREIGN KEY (student_id) REFERENCES student (id) ON DELETE CASCADE'); |
|
108
|
|
|
$this->addSql('ALTER TABLE user_dismissed_messages ADD CONSTRAINT FK_E1D43738A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
109
|
|
|
$this->addSql('ALTER TABLE user_dismissed_messages ADD CONSTRAINT FK_E1D43738537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
110
|
|
|
$this->addSql('ALTER TABLE absence ADD CONSTRAINT FK_765AE0C941807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
111
|
|
|
$this->addSql('ALTER TABLE absence ADD CONSTRAINT FK_765AE0C95DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
112
|
|
|
$this->addSql('ALTER TABLE absence ADD CONSTRAINT FK_765AE0C954177093 FOREIGN KEY (room_id) REFERENCES room (id) ON DELETE CASCADE'); |
|
113
|
|
|
$this->addSql('ALTER TABLE appointment ADD CONSTRAINT FK_FE38F84412469DE2 FOREIGN KEY (category_id) REFERENCES appointment_category (id) ON DELETE CASCADE'); |
|
114
|
|
|
$this->addSql('ALTER TABLE appointment_studygroups ADD CONSTRAINT FK_5EE7E790E5B533F9 FOREIGN KEY (appointment_id) REFERENCES appointment (id) ON DELETE CASCADE'); |
|
115
|
|
|
$this->addSql('ALTER TABLE appointment_studygroups ADD CONSTRAINT FK_5EE7E7905DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
116
|
|
|
$this->addSql('ALTER TABLE appointment_organizers ADD CONSTRAINT FK_ABD20936E5B533F9 FOREIGN KEY (appointment_id) REFERENCES appointment (id) ON DELETE CASCADE'); |
|
117
|
|
|
$this->addSql('ALTER TABLE appointment_organizers ADD CONSTRAINT FK_ABD2093641807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
118
|
|
|
$this->addSql('ALTER TABLE appointment_visibilities ADD CONSTRAINT FK_9A6E5842E5B533F9 FOREIGN KEY (appointment_id) REFERENCES appointment (id) ON DELETE CASCADE'); |
|
119
|
|
|
$this->addSql('ALTER TABLE appointment_visibilities ADD CONSTRAINT FK_9A6E58425E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
120
|
|
|
$this->addSql('ALTER TABLE document ADD CONSTRAINT FK_D8698A7612469DE2 FOREIGN KEY (category_id) REFERENCES document_category (id) ON DELETE CASCADE'); |
|
121
|
|
|
$this->addSql('ALTER TABLE document_studygroups ADD CONSTRAINT FK_A786B266C33F7837 FOREIGN KEY (document_id) REFERENCES document (id) ON DELETE CASCADE'); |
|
122
|
|
|
$this->addSql('ALTER TABLE document_studygroups ADD CONSTRAINT FK_A786B2665DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
123
|
|
|
$this->addSql('ALTER TABLE document_visibilities ADD CONSTRAINT FK_CE496E3EC33F7837 FOREIGN KEY (document_id) REFERENCES document (id) ON DELETE CASCADE'); |
|
124
|
|
|
$this->addSql('ALTER TABLE document_visibilities ADD CONSTRAINT FK_CE496E3E5E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
125
|
|
|
$this->addSql('ALTER TABLE document_authors ADD CONSTRAINT FK_2A638C8DC33F7837 FOREIGN KEY (document_id) REFERENCES document (id) ON DELETE CASCADE'); |
|
126
|
|
|
$this->addSql('ALTER TABLE document_authors ADD CONSTRAINT FK_2A638C8DA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
127
|
|
|
$this->addSql('ALTER TABLE document_attachment ADD CONSTRAINT FK_D89C72EDC33F7837 FOREIGN KEY (document_id) REFERENCES document (id) ON DELETE CASCADE'); |
|
128
|
|
|
$this->addSql('ALTER TABLE exam_tuitions ADD CONSTRAINT FK_A472BA1A578D5E91 FOREIGN KEY (exam_id) REFERENCES exam (id) ON DELETE CASCADE'); |
|
129
|
|
|
$this->addSql('ALTER TABLE exam_tuitions ADD CONSTRAINT FK_A472BA1A7FFA6BA FOREIGN KEY (tuition_id) REFERENCES tuition (id) ON DELETE CASCADE'); |
|
130
|
|
|
$this->addSql('ALTER TABLE exam_students ADD CONSTRAINT FK_E70DC281578D5E91 FOREIGN KEY (exam_id) REFERENCES exam (id) ON DELETE CASCADE'); |
|
131
|
|
|
$this->addSql('ALTER TABLE exam_students ADD CONSTRAINT FK_E70DC281CB944F1A FOREIGN KEY (student_id) REFERENCES student (id) ON DELETE CASCADE'); |
|
132
|
|
|
$this->addSql('ALTER TABLE exam_supervision ADD CONSTRAINT FK_2BD1F5C1578D5E91 FOREIGN KEY (exam_id) REFERENCES exam (id) ON DELETE CASCADE'); |
|
133
|
|
|
$this->addSql('ALTER TABLE exam_supervision ADD CONSTRAINT FK_2BD1F5C141807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
134
|
|
|
$this->addSql('ALTER TABLE timetable_lesson ADD CONSTRAINT FK_2628C727EC8B7ADE FOREIGN KEY (period_id) REFERENCES timetable_period (id) ON DELETE CASCADE'); |
|
135
|
|
|
$this->addSql('ALTER TABLE timetable_lesson ADD CONSTRAINT FK_2628C727C86F3B2F FOREIGN KEY (week_id) REFERENCES timetable_week (id) ON DELETE CASCADE'); |
|
136
|
|
|
$this->addSql('ALTER TABLE timetable_lesson ADD CONSTRAINT FK_2628C7277FFA6BA FOREIGN KEY (tuition_id) REFERENCES tuition (id) ON DELETE CASCADE'); |
|
137
|
|
|
$this->addSql('ALTER TABLE timetable_lesson ADD CONSTRAINT FK_2628C72754177093 FOREIGN KEY (room_id) REFERENCES room (id) ON DELETE SET NULL'); |
|
138
|
|
|
$this->addSql('ALTER TABLE timetable_lesson_teachers ADD CONSTRAINT FK_78936A02EA4D7C00 FOREIGN KEY (timetable_lesson_id) REFERENCES timetable_lesson (id) ON DELETE CASCADE'); |
|
139
|
|
|
$this->addSql('ALTER TABLE timetable_lesson_teachers ADD CONSTRAINT FK_78936A0241807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
140
|
|
|
$this->addSql('ALTER TABLE grade_teacher ADD CONSTRAINT FK_4ABB343741807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
141
|
|
|
$this->addSql('ALTER TABLE grade_teacher ADD CONSTRAINT FK_4ABB3437FE19A1A8 FOREIGN KEY (grade_id) REFERENCES grade (id) ON DELETE CASCADE'); |
|
142
|
|
|
$this->addSql('ALTER TABLE ics_access_token ADD CONSTRAINT FK_2E41884BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
143
|
|
|
$this->addSql('ALTER TABLE message ADD CONSTRAINT FK_B6BD307FB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id) ON DELETE SET NULL'); |
|
144
|
|
|
$this->addSql('ALTER TABLE message ADD CONSTRAINT FK_B6BD307F896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id) ON DELETE SET NULL'); |
|
145
|
|
|
$this->addSql('ALTER TABLE message_studygroups ADD CONSTRAINT FK_4550DBF5537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
146
|
|
|
$this->addSql('ALTER TABLE message_studygroups ADD CONSTRAINT FK_4550DBF55DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
147
|
|
|
$this->addSql('ALTER TABLE message_visibilities ADD CONSTRAINT FK_A7AD7AA9537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
148
|
|
|
$this->addSql('ALTER TABLE message_visibilities ADD CONSTRAINT FK_A7AD7AA95E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
149
|
|
|
$this->addSql('ALTER TABLE message_download_usertypes ADD CONSTRAINT FK_38D89C91537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
150
|
|
|
$this->addSql('ALTER TABLE message_download_usertypes ADD CONSTRAINT FK_38D89C915E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
151
|
|
|
$this->addSql('ALTER TABLE message_download_studygroups ADD CONSTRAINT FK_638F7119537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
152
|
|
|
$this->addSql('ALTER TABLE message_download_studygroups ADD CONSTRAINT FK_638F71195DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
153
|
|
|
$this->addSql('ALTER TABLE message_upload_usertypes ADD CONSTRAINT FK_17AD59BA537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
154
|
|
|
$this->addSql('ALTER TABLE message_upload_usertypes ADD CONSTRAINT FK_17AD59BA5E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
155
|
|
|
$this->addSql('ALTER TABLE message_upload_studygroups ADD CONSTRAINT FK_FEF1953A537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
156
|
|
|
$this->addSql('ALTER TABLE message_upload_studygroups ADD CONSTRAINT FK_FEF1953A5DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
157
|
|
|
$this->addSql('ALTER TABLE message_confirmation_usertypes ADD CONSTRAINT FK_7F22A1537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
158
|
|
|
$this->addSql('ALTER TABLE message_confirmation_usertypes ADD CONSTRAINT FK_7F22A15E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
159
|
|
|
$this->addSql('ALTER TABLE message_confirmation_studygroups ADD CONSTRAINT FK_9010E1C6537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
160
|
|
|
$this->addSql('ALTER TABLE message_confirmation_studygroups ADD CONSTRAINT FK_9010E1C65DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
161
|
|
|
$this->addSql('ALTER TABLE message_attachment ADD CONSTRAINT FK_B68FF524537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
162
|
|
|
$this->addSql('ALTER TABLE message_confirmation ADD CONSTRAINT FK_8C3C27DA537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
163
|
|
|
$this->addSql('ALTER TABLE message_confirmation ADD CONSTRAINT FK_8C3C27DAA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
164
|
|
|
$this->addSql('ALTER TABLE message_file ADD CONSTRAINT FK_250AADC9537A1329 FOREIGN KEY (message_id) REFERENCES message (id) ON DELETE CASCADE'); |
|
165
|
|
|
$this->addSql('ALTER TABLE message_file_upload ADD CONSTRAINT FK_CFD59E593434360 FOREIGN KEY (message_file_id) REFERENCES message_file (id) ON DELETE CASCADE'); |
|
166
|
|
|
$this->addSql('ALTER TABLE message_file_upload ADD CONSTRAINT FK_CFD59E59A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
167
|
|
|
$this->addSql('ALTER TABLE oauth_client_info ADD CONSTRAINT FK_46345E9E19EB6921 FOREIGN KEY (client_id) REFERENCES oauth2_client (identifier) ON DELETE CASCADE'); |
|
168
|
|
|
$this->addSql('ALTER TABLE room_reservation ADD CONSTRAINT FK_56FDE76A54177093 FOREIGN KEY (room_id) REFERENCES room (id) ON DELETE CASCADE'); |
|
169
|
|
|
$this->addSql('ALTER TABLE room_reservation ADD CONSTRAINT FK_56FDE76A41807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
170
|
|
|
$this->addSql('ALTER TABLE room_roomtags ADD CONSTRAINT FK_80B7F00554177093 FOREIGN KEY (room_id) REFERENCES room (id) ON DELETE CASCADE'); |
|
171
|
|
|
$this->addSql('ALTER TABLE room_roomtags ADD CONSTRAINT FK_80B7F005BAD26311 FOREIGN KEY (tag_id) REFERENCES room_tag (id) ON DELETE CASCADE'); |
|
172
|
|
|
$this->addSql('ALTER TABLE student ADD CONSTRAINT FK_B723AF33FE19A1A8 FOREIGN KEY (grade_id) REFERENCES grade (id) ON DELETE SET NULL'); |
|
173
|
|
|
$this->addSql('ALTER TABLE student_approved_privacy_categories ADD CONSTRAINT FK_42D136F6CB944F1A FOREIGN KEY (student_id) REFERENCES student (id) ON DELETE CASCADE'); |
|
174
|
|
|
$this->addSql('ALTER TABLE student_approved_privacy_categories ADD CONSTRAINT FK_42D136F6F1E8355A FOREIGN KEY (privacy_category_id) REFERENCES privacy_category (id) ON DELETE CASCADE'); |
|
175
|
|
|
$this->addSql('ALTER TABLE study_group_grades ADD CONSTRAINT FK_C647F0BA5DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
176
|
|
|
$this->addSql('ALTER TABLE study_group_grades ADD CONSTRAINT FK_C647F0BAFE19A1A8 FOREIGN KEY (grade_id) REFERENCES grade (id) ON DELETE CASCADE'); |
|
177
|
|
|
$this->addSql('ALTER TABLE study_group_membership ADD CONSTRAINT FK_26983EF95DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
178
|
|
|
$this->addSql('ALTER TABLE study_group_membership ADD CONSTRAINT FK_26983EF9CB944F1A FOREIGN KEY (student_id) REFERENCES student (id) ON DELETE CASCADE'); |
|
179
|
|
|
$this->addSql('ALTER TABLE substitution_teachers ADD CONSTRAINT FK_3D5933E1D7F487C9 FOREIGN KEY (substitution_id) REFERENCES substitution (id) ON DELETE CASCADE'); |
|
180
|
|
|
$this->addSql('ALTER TABLE substitution_teachers ADD CONSTRAINT FK_3D5933E141807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
181
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_teachers ADD CONSTRAINT FK_DA62411DD7F487C9 FOREIGN KEY (substitution_id) REFERENCES substitution (id) ON DELETE CASCADE'); |
|
182
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_teachers ADD CONSTRAINT FK_DA62411D41807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
183
|
|
|
$this->addSql('ALTER TABLE substitution_studygroups ADD CONSTRAINT FK_89A42774D7F487C9 FOREIGN KEY (substitution_id) REFERENCES substitution (id) ON DELETE CASCADE'); |
|
184
|
|
|
$this->addSql('ALTER TABLE substitution_studygroups ADD CONSTRAINT FK_89A427745DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
185
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_studygroups ADD CONSTRAINT FK_99785F77D7F487C9 FOREIGN KEY (substitution_id) REFERENCES substitution (id) ON DELETE CASCADE'); |
|
186
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_studygroups ADD CONSTRAINT FK_99785F775DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
187
|
|
|
$this->addSql('ALTER TABLE teacher_subjects ADD CONSTRAINT FK_AA332A9C41807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
188
|
|
|
$this->addSql('ALTER TABLE teacher_subjects ADD CONSTRAINT FK_AA332A9C23EDC87 FOREIGN KEY (subject_id) REFERENCES subject (id) ON DELETE CASCADE'); |
|
189
|
|
|
$this->addSql('ALTER TABLE teacher_tags ADD CONSTRAINT FK_4E00F31741807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
190
|
|
|
$this->addSql('ALTER TABLE teacher_tags ADD CONSTRAINT FK_4E00F317AF59B1E4 FOREIGN KEY (teacher_tag_id) REFERENCES teacher_tag (id) ON DELETE CASCADE'); |
|
191
|
|
|
$this->addSql('ALTER TABLE timetable_period_visibilities ADD CONSTRAINT FK_1954F2D6CB3E0748 FOREIGN KEY (timetable_period_id) REFERENCES timetable_period (id) ON DELETE CASCADE'); |
|
192
|
|
|
$this->addSql('ALTER TABLE timetable_period_visibilities ADD CONSTRAINT FK_1954F2D65E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
193
|
|
|
$this->addSql('ALTER TABLE timetable_supervision ADD CONSTRAINT FK_396D5F68EC8B7ADE FOREIGN KEY (period_id) REFERENCES timetable_period (id) ON DELETE CASCADE'); |
|
194
|
|
|
$this->addSql('ALTER TABLE timetable_supervision ADD CONSTRAINT FK_396D5F68C86F3B2F FOREIGN KEY (week_id) REFERENCES timetable_week (id) ON DELETE CASCADE'); |
|
195
|
|
|
$this->addSql('ALTER TABLE timetable_supervision ADD CONSTRAINT FK_396D5F6841807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
196
|
|
|
$this->addSql('ALTER TABLE tuition ADD CONSTRAINT FK_A1B25E5B23EDC87 FOREIGN KEY (subject_id) REFERENCES subject (id) ON DELETE CASCADE'); |
|
197
|
|
|
$this->addSql('ALTER TABLE tuition ADD CONSTRAINT FK_A1B25E5B41807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
198
|
|
|
$this->addSql('ALTER TABLE tuition ADD CONSTRAINT FK_A1B25E5B5DDDCCCE FOREIGN KEY (study_group_id) REFERENCES study_group (id) ON DELETE CASCADE'); |
|
199
|
|
|
$this->addSql('ALTER TABLE tuition_additional_teachers ADD CONSTRAINT FK_CD0280547FFA6BA FOREIGN KEY (tuition_id) REFERENCES tuition (id) ON DELETE CASCADE'); |
|
200
|
|
|
$this->addSql('ALTER TABLE tuition_additional_teachers ADD CONSTRAINT FK_CD02805441807E1D FOREIGN KEY (teacher_id) REFERENCES teacher (id) ON DELETE CASCADE'); |
|
201
|
|
|
$this->addSql('ALTER TABLE user_web_push_subscription ADD CONSTRAINT FK_260A81F9A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)'); |
|
202
|
|
|
$this->addSql('ALTER TABLE wiki ADD CONSTRAINT FK_22CDDC0679066886 FOREIGN KEY (root_id) REFERENCES wiki (id) ON DELETE CASCADE'); |
|
203
|
|
|
$this->addSql('ALTER TABLE wiki ADD CONSTRAINT FK_22CDDC06514BFC18 FOREIGN KEY (`parent`) REFERENCES wiki (`id`) ON DELETE CASCADE'); |
|
204
|
|
|
$this->addSql('ALTER TABLE wiki_article_visibilities ADD CONSTRAINT FK_2E45B22D4E9C5254 FOREIGN KEY (wiki_article_id) REFERENCES wiki (id) ON DELETE CASCADE'); |
|
205
|
|
|
$this->addSql('ALTER TABLE wiki_article_visibilities ADD CONSTRAINT FK_2E45B22D5E66E314 FOREIGN KEY (user_type_entity_id) REFERENCES user_type_entity (id) ON DELETE CASCADE'); |
|
206
|
|
|
$this->addSql('ALTER TABLE cron_job_result ADD CONSTRAINT FK_2CD346EE79099ED8 FOREIGN KEY (cron_job_id) REFERENCES cron_job (id)'); |
|
207
|
|
|
$this->addSql('ALTER TABLE oauth2_access_token ADD CONSTRAINT FK_454D9673C7440455 FOREIGN KEY (client) REFERENCES oauth2_client (identifier) ON DELETE CASCADE'); |
|
208
|
|
|
$this->addSql('ALTER TABLE oauth2_authorization_code ADD CONSTRAINT FK_509FEF5FC7440455 FOREIGN KEY (client) REFERENCES oauth2_client (identifier)'); |
|
209
|
|
|
$this->addSql('ALTER TABLE oauth2_refresh_token ADD CONSTRAINT FK_4DD90732B6A2DD68 FOREIGN KEY (access_token) REFERENCES oauth2_access_token (identifier) ON DELETE SET NULL'); |
|
210
|
|
|
} |
|
211
|
|
|
|
|
212
|
|
|
public function down(Schema $schema) : void |
|
213
|
|
|
{ |
|
214
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
215
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
|
|
|
|
|
216
|
|
|
|
|
217
|
|
|
$this->addSql('ALTER TABLE user_students DROP FOREIGN KEY FK_44E469B2A76ED395'); |
|
218
|
|
|
$this->addSql('ALTER TABLE user_dismissed_messages DROP FOREIGN KEY FK_E1D43738A76ED395'); |
|
219
|
|
|
$this->addSql('ALTER TABLE document_authors DROP FOREIGN KEY FK_2A638C8DA76ED395'); |
|
220
|
|
|
$this->addSql('ALTER TABLE ics_access_token DROP FOREIGN KEY FK_2E41884BA76ED395'); |
|
221
|
|
|
$this->addSql('ALTER TABLE message DROP FOREIGN KEY FK_B6BD307FB03A8386'); |
|
222
|
|
|
$this->addSql('ALTER TABLE message DROP FOREIGN KEY FK_B6BD307F896DBBDE'); |
|
223
|
|
|
$this->addSql('ALTER TABLE message_confirmation DROP FOREIGN KEY FK_8C3C27DAA76ED395'); |
|
224
|
|
|
$this->addSql('ALTER TABLE message_file_upload DROP FOREIGN KEY FK_CFD59E59A76ED395'); |
|
225
|
|
|
$this->addSql('ALTER TABLE user_web_push_subscription DROP FOREIGN KEY FK_260A81F9A76ED395'); |
|
226
|
|
|
$this->addSql('ALTER TABLE appointment_studygroups DROP FOREIGN KEY FK_5EE7E790E5B533F9'); |
|
227
|
|
|
$this->addSql('ALTER TABLE appointment_organizers DROP FOREIGN KEY FK_ABD20936E5B533F9'); |
|
228
|
|
|
$this->addSql('ALTER TABLE appointment_visibilities DROP FOREIGN KEY FK_9A6E5842E5B533F9'); |
|
229
|
|
|
$this->addSql('ALTER TABLE appointment DROP FOREIGN KEY FK_FE38F84412469DE2'); |
|
230
|
|
|
$this->addSql('ALTER TABLE document_studygroups DROP FOREIGN KEY FK_A786B266C33F7837'); |
|
231
|
|
|
$this->addSql('ALTER TABLE document_visibilities DROP FOREIGN KEY FK_CE496E3EC33F7837'); |
|
232
|
|
|
$this->addSql('ALTER TABLE document_authors DROP FOREIGN KEY FK_2A638C8DC33F7837'); |
|
233
|
|
|
$this->addSql('ALTER TABLE document_attachment DROP FOREIGN KEY FK_D89C72EDC33F7837'); |
|
234
|
|
|
$this->addSql('ALTER TABLE document DROP FOREIGN KEY FK_D8698A7612469DE2'); |
|
235
|
|
|
$this->addSql('ALTER TABLE exam_tuitions DROP FOREIGN KEY FK_A472BA1A578D5E91'); |
|
236
|
|
|
$this->addSql('ALTER TABLE exam_students DROP FOREIGN KEY FK_E70DC281578D5E91'); |
|
237
|
|
|
$this->addSql('ALTER TABLE exam_supervision DROP FOREIGN KEY FK_2BD1F5C1578D5E91'); |
|
238
|
|
|
$this->addSql('ALTER TABLE timetable_lesson_teachers DROP FOREIGN KEY FK_78936A02EA4D7C00'); |
|
239
|
|
|
$this->addSql('ALTER TABLE grade_teacher DROP FOREIGN KEY FK_4ABB3437FE19A1A8'); |
|
240
|
|
|
$this->addSql('ALTER TABLE student DROP FOREIGN KEY FK_B723AF33FE19A1A8'); |
|
241
|
|
|
$this->addSql('ALTER TABLE study_group_grades DROP FOREIGN KEY FK_C647F0BAFE19A1A8'); |
|
242
|
|
|
$this->addSql('ALTER TABLE user_dismissed_messages DROP FOREIGN KEY FK_E1D43738537A1329'); |
|
243
|
|
|
$this->addSql('ALTER TABLE message_studygroups DROP FOREIGN KEY FK_4550DBF5537A1329'); |
|
244
|
|
|
$this->addSql('ALTER TABLE message_visibilities DROP FOREIGN KEY FK_A7AD7AA9537A1329'); |
|
245
|
|
|
$this->addSql('ALTER TABLE message_download_usertypes DROP FOREIGN KEY FK_38D89C91537A1329'); |
|
246
|
|
|
$this->addSql('ALTER TABLE message_download_studygroups DROP FOREIGN KEY FK_638F7119537A1329'); |
|
247
|
|
|
$this->addSql('ALTER TABLE message_upload_usertypes DROP FOREIGN KEY FK_17AD59BA537A1329'); |
|
248
|
|
|
$this->addSql('ALTER TABLE message_upload_studygroups DROP FOREIGN KEY FK_FEF1953A537A1329'); |
|
249
|
|
|
$this->addSql('ALTER TABLE message_confirmation_usertypes DROP FOREIGN KEY FK_7F22A1537A1329'); |
|
250
|
|
|
$this->addSql('ALTER TABLE message_confirmation_studygroups DROP FOREIGN KEY FK_9010E1C6537A1329'); |
|
251
|
|
|
$this->addSql('ALTER TABLE message_attachment DROP FOREIGN KEY FK_B68FF524537A1329'); |
|
252
|
|
|
$this->addSql('ALTER TABLE message_confirmation DROP FOREIGN KEY FK_8C3C27DA537A1329'); |
|
253
|
|
|
$this->addSql('ALTER TABLE message_file DROP FOREIGN KEY FK_250AADC9537A1329'); |
|
254
|
|
|
$this->addSql('ALTER TABLE message_file_upload DROP FOREIGN KEY FK_CFD59E593434360'); |
|
255
|
|
|
$this->addSql('ALTER TABLE student_approved_privacy_categories DROP FOREIGN KEY FK_42D136F6F1E8355A'); |
|
256
|
|
|
$this->addSql('ALTER TABLE absence DROP FOREIGN KEY FK_765AE0C954177093'); |
|
257
|
|
|
$this->addSql('ALTER TABLE timetable_lesson DROP FOREIGN KEY FK_2628C72754177093'); |
|
258
|
|
|
$this->addSql('ALTER TABLE room_reservation DROP FOREIGN KEY FK_56FDE76A54177093'); |
|
259
|
|
|
$this->addSql('ALTER TABLE room_roomtags DROP FOREIGN KEY FK_80B7F00554177093'); |
|
260
|
|
|
$this->addSql('ALTER TABLE room_roomtags DROP FOREIGN KEY FK_80B7F005BAD26311'); |
|
261
|
|
|
$this->addSql('ALTER TABLE user_students DROP FOREIGN KEY FK_44E469B2CB944F1A'); |
|
262
|
|
|
$this->addSql('ALTER TABLE exam_students DROP FOREIGN KEY FK_E70DC281CB944F1A'); |
|
263
|
|
|
$this->addSql('ALTER TABLE student_approved_privacy_categories DROP FOREIGN KEY FK_42D136F6CB944F1A'); |
|
264
|
|
|
$this->addSql('ALTER TABLE study_group_membership DROP FOREIGN KEY FK_26983EF9CB944F1A'); |
|
265
|
|
|
$this->addSql('ALTER TABLE absence DROP FOREIGN KEY FK_765AE0C95DDDCCCE'); |
|
266
|
|
|
$this->addSql('ALTER TABLE appointment_studygroups DROP FOREIGN KEY FK_5EE7E7905DDDCCCE'); |
|
267
|
|
|
$this->addSql('ALTER TABLE document_studygroups DROP FOREIGN KEY FK_A786B2665DDDCCCE'); |
|
268
|
|
|
$this->addSql('ALTER TABLE message_studygroups DROP FOREIGN KEY FK_4550DBF55DDDCCCE'); |
|
269
|
|
|
$this->addSql('ALTER TABLE message_download_studygroups DROP FOREIGN KEY FK_638F71195DDDCCCE'); |
|
270
|
|
|
$this->addSql('ALTER TABLE message_upload_studygroups DROP FOREIGN KEY FK_FEF1953A5DDDCCCE'); |
|
271
|
|
|
$this->addSql('ALTER TABLE message_confirmation_studygroups DROP FOREIGN KEY FK_9010E1C65DDDCCCE'); |
|
272
|
|
|
$this->addSql('ALTER TABLE study_group_grades DROP FOREIGN KEY FK_C647F0BA5DDDCCCE'); |
|
273
|
|
|
$this->addSql('ALTER TABLE study_group_membership DROP FOREIGN KEY FK_26983EF95DDDCCCE'); |
|
274
|
|
|
$this->addSql('ALTER TABLE substitution_studygroups DROP FOREIGN KEY FK_89A427745DDDCCCE'); |
|
275
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_studygroups DROP FOREIGN KEY FK_99785F775DDDCCCE'); |
|
276
|
|
|
$this->addSql('ALTER TABLE tuition DROP FOREIGN KEY FK_A1B25E5B5DDDCCCE'); |
|
277
|
|
|
$this->addSql('ALTER TABLE teacher_subjects DROP FOREIGN KEY FK_AA332A9C23EDC87'); |
|
278
|
|
|
$this->addSql('ALTER TABLE tuition DROP FOREIGN KEY FK_A1B25E5B23EDC87'); |
|
279
|
|
|
$this->addSql('ALTER TABLE substitution_teachers DROP FOREIGN KEY FK_3D5933E1D7F487C9'); |
|
280
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_teachers DROP FOREIGN KEY FK_DA62411DD7F487C9'); |
|
281
|
|
|
$this->addSql('ALTER TABLE substitution_studygroups DROP FOREIGN KEY FK_89A42774D7F487C9'); |
|
282
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_studygroups DROP FOREIGN KEY FK_99785F77D7F487C9'); |
|
283
|
|
|
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D64941807E1D'); |
|
284
|
|
|
$this->addSql('ALTER TABLE absence DROP FOREIGN KEY FK_765AE0C941807E1D'); |
|
285
|
|
|
$this->addSql('ALTER TABLE appointment_organizers DROP FOREIGN KEY FK_ABD2093641807E1D'); |
|
286
|
|
|
$this->addSql('ALTER TABLE exam_supervision DROP FOREIGN KEY FK_2BD1F5C141807E1D'); |
|
287
|
|
|
$this->addSql('ALTER TABLE timetable_lesson_teachers DROP FOREIGN KEY FK_78936A0241807E1D'); |
|
288
|
|
|
$this->addSql('ALTER TABLE grade_teacher DROP FOREIGN KEY FK_4ABB343741807E1D'); |
|
289
|
|
|
$this->addSql('ALTER TABLE room_reservation DROP FOREIGN KEY FK_56FDE76A41807E1D'); |
|
290
|
|
|
$this->addSql('ALTER TABLE substitution_teachers DROP FOREIGN KEY FK_3D5933E141807E1D'); |
|
291
|
|
|
$this->addSql('ALTER TABLE substitution_replacement_teachers DROP FOREIGN KEY FK_DA62411D41807E1D'); |
|
292
|
|
|
$this->addSql('ALTER TABLE teacher_subjects DROP FOREIGN KEY FK_AA332A9C41807E1D'); |
|
293
|
|
|
$this->addSql('ALTER TABLE teacher_tags DROP FOREIGN KEY FK_4E00F31741807E1D'); |
|
294
|
|
|
$this->addSql('ALTER TABLE timetable_supervision DROP FOREIGN KEY FK_396D5F6841807E1D'); |
|
295
|
|
|
$this->addSql('ALTER TABLE tuition DROP FOREIGN KEY FK_A1B25E5B41807E1D'); |
|
296
|
|
|
$this->addSql('ALTER TABLE tuition_additional_teachers DROP FOREIGN KEY FK_CD02805441807E1D'); |
|
297
|
|
|
$this->addSql('ALTER TABLE teacher_tags DROP FOREIGN KEY FK_4E00F317AF59B1E4'); |
|
298
|
|
|
$this->addSql('ALTER TABLE timetable_lesson DROP FOREIGN KEY FK_2628C727EC8B7ADE'); |
|
299
|
|
|
$this->addSql('ALTER TABLE timetable_period_visibilities DROP FOREIGN KEY FK_1954F2D6CB3E0748'); |
|
300
|
|
|
$this->addSql('ALTER TABLE timetable_supervision DROP FOREIGN KEY FK_396D5F68EC8B7ADE'); |
|
301
|
|
|
$this->addSql('ALTER TABLE timetable_lesson DROP FOREIGN KEY FK_2628C727C86F3B2F'); |
|
302
|
|
|
$this->addSql('ALTER TABLE timetable_supervision DROP FOREIGN KEY FK_396D5F68C86F3B2F'); |
|
303
|
|
|
$this->addSql('ALTER TABLE exam_tuitions DROP FOREIGN KEY FK_A472BA1A7FFA6BA'); |
|
304
|
|
|
$this->addSql('ALTER TABLE timetable_lesson DROP FOREIGN KEY FK_2628C7277FFA6BA'); |
|
305
|
|
|
$this->addSql('ALTER TABLE tuition_additional_teachers DROP FOREIGN KEY FK_CD0280547FFA6BA'); |
|
306
|
|
|
$this->addSql('ALTER TABLE appointment_visibilities DROP FOREIGN KEY FK_9A6E58425E66E314'); |
|
307
|
|
|
$this->addSql('ALTER TABLE document_visibilities DROP FOREIGN KEY FK_CE496E3E5E66E314'); |
|
308
|
|
|
$this->addSql('ALTER TABLE message_visibilities DROP FOREIGN KEY FK_A7AD7AA95E66E314'); |
|
309
|
|
|
$this->addSql('ALTER TABLE message_download_usertypes DROP FOREIGN KEY FK_38D89C915E66E314'); |
|
310
|
|
|
$this->addSql('ALTER TABLE message_upload_usertypes DROP FOREIGN KEY FK_17AD59BA5E66E314'); |
|
311
|
|
|
$this->addSql('ALTER TABLE message_confirmation_usertypes DROP FOREIGN KEY FK_7F22A15E66E314'); |
|
312
|
|
|
$this->addSql('ALTER TABLE timetable_period_visibilities DROP FOREIGN KEY FK_1954F2D65E66E314'); |
|
313
|
|
|
$this->addSql('ALTER TABLE wiki_article_visibilities DROP FOREIGN KEY FK_2E45B22D5E66E314'); |
|
314
|
|
|
$this->addSql('ALTER TABLE wiki DROP FOREIGN KEY FK_22CDDC0679066886'); |
|
315
|
|
|
$this->addSql('ALTER TABLE wiki DROP FOREIGN KEY FK_22CDDC06514BFC18'); |
|
316
|
|
|
$this->addSql('ALTER TABLE wiki_article_visibilities DROP FOREIGN KEY FK_2E45B22D4E9C5254'); |
|
317
|
|
|
$this->addSql('ALTER TABLE cron_job_result DROP FOREIGN KEY FK_2CD346EE79099ED8'); |
|
318
|
|
|
$this->addSql('ALTER TABLE oauth2_refresh_token DROP FOREIGN KEY FK_4DD90732B6A2DD68'); |
|
319
|
|
|
$this->addSql('ALTER TABLE oauth_client_info DROP FOREIGN KEY FK_46345E9E19EB6921'); |
|
320
|
|
|
$this->addSql('ALTER TABLE oauth2_access_token DROP FOREIGN KEY FK_454D9673C7440455'); |
|
321
|
|
|
$this->addSql('ALTER TABLE oauth2_authorization_code DROP FOREIGN KEY FK_509FEF5FC7440455'); |
|
322
|
|
|
$this->addSql('DROP TABLE user'); |
|
323
|
|
|
$this->addSql('DROP TABLE user_students'); |
|
324
|
|
|
$this->addSql('DROP TABLE user_dismissed_messages'); |
|
325
|
|
|
$this->addSql('DROP TABLE absence'); |
|
326
|
|
|
$this->addSql('DROP TABLE appointment'); |
|
327
|
|
|
$this->addSql('DROP TABLE appointment_studygroups'); |
|
328
|
|
|
$this->addSql('DROP TABLE appointment_organizers'); |
|
329
|
|
|
$this->addSql('DROP TABLE appointment_visibilities'); |
|
330
|
|
|
$this->addSql('DROP TABLE appointment_category'); |
|
331
|
|
|
$this->addSql('DROP TABLE document'); |
|
332
|
|
|
$this->addSql('DROP TABLE document_studygroups'); |
|
333
|
|
|
$this->addSql('DROP TABLE document_visibilities'); |
|
334
|
|
|
$this->addSql('DROP TABLE document_authors'); |
|
335
|
|
|
$this->addSql('DROP TABLE document_attachment'); |
|
336
|
|
|
$this->addSql('DROP TABLE document_category'); |
|
337
|
|
|
$this->addSql('DROP TABLE exam'); |
|
338
|
|
|
$this->addSql('DROP TABLE exam_tuitions'); |
|
339
|
|
|
$this->addSql('DROP TABLE exam_students'); |
|
340
|
|
|
$this->addSql('DROP TABLE exam_supervision'); |
|
341
|
|
|
$this->addSql('DROP TABLE timetable_lesson'); |
|
342
|
|
|
$this->addSql('DROP TABLE timetable_lesson_teachers'); |
|
343
|
|
|
$this->addSql('DROP TABLE grade'); |
|
344
|
|
|
$this->addSql('DROP TABLE grade_teacher'); |
|
345
|
|
|
$this->addSql('DROP TABLE ics_access_token'); |
|
346
|
|
|
$this->addSql('DROP TABLE import_date_time'); |
|
347
|
|
|
$this->addSql('DROP TABLE infotext'); |
|
348
|
|
|
$this->addSql('DROP TABLE message'); |
|
349
|
|
|
$this->addSql('DROP TABLE message_studygroups'); |
|
350
|
|
|
$this->addSql('DROP TABLE message_visibilities'); |
|
351
|
|
|
$this->addSql('DROP TABLE message_download_usertypes'); |
|
352
|
|
|
$this->addSql('DROP TABLE message_download_studygroups'); |
|
353
|
|
|
$this->addSql('DROP TABLE message_upload_usertypes'); |
|
354
|
|
|
$this->addSql('DROP TABLE message_upload_studygroups'); |
|
355
|
|
|
$this->addSql('DROP TABLE message_confirmation_usertypes'); |
|
356
|
|
|
$this->addSql('DROP TABLE message_confirmation_studygroups'); |
|
357
|
|
|
$this->addSql('DROP TABLE message_attachment'); |
|
358
|
|
|
$this->addSql('DROP TABLE message_confirmation'); |
|
359
|
|
|
$this->addSql('DROP TABLE message_file'); |
|
360
|
|
|
$this->addSql('DROP TABLE message_file_upload'); |
|
361
|
|
|
$this->addSql('DROP TABLE oauth_client_info'); |
|
362
|
|
|
$this->addSql('DROP TABLE privacy_category'); |
|
363
|
|
|
$this->addSql('DROP TABLE room'); |
|
364
|
|
|
$this->addSql('DROP TABLE room_reservation'); |
|
365
|
|
|
$this->addSql('DROP TABLE room_tag'); |
|
366
|
|
|
$this->addSql('DROP TABLE room_roomtags'); |
|
367
|
|
|
$this->addSql('DROP TABLE setting'); |
|
368
|
|
|
$this->addSql('DROP TABLE student'); |
|
369
|
|
|
$this->addSql('DROP TABLE student_approved_privacy_categories'); |
|
370
|
|
|
$this->addSql('DROP TABLE study_group'); |
|
371
|
|
|
$this->addSql('DROP TABLE study_group_grades'); |
|
372
|
|
|
$this->addSql('DROP TABLE study_group_membership'); |
|
373
|
|
|
$this->addSql('DROP TABLE subject'); |
|
374
|
|
|
$this->addSql('DROP TABLE substitution'); |
|
375
|
|
|
$this->addSql('DROP TABLE substitution_teachers'); |
|
376
|
|
|
$this->addSql('DROP TABLE substitution_replacement_teachers'); |
|
377
|
|
|
$this->addSql('DROP TABLE substitution_studygroups'); |
|
378
|
|
|
$this->addSql('DROP TABLE substitution_replacement_studygroups'); |
|
379
|
|
|
$this->addSql('DROP TABLE teacher'); |
|
380
|
|
|
$this->addSql('DROP TABLE teacher_subjects'); |
|
381
|
|
|
$this->addSql('DROP TABLE teacher_tags'); |
|
382
|
|
|
$this->addSql('DROP TABLE teacher_tag'); |
|
383
|
|
|
$this->addSql('DROP TABLE timetable_period'); |
|
384
|
|
|
$this->addSql('DROP TABLE timetable_period_visibilities'); |
|
385
|
|
|
$this->addSql('DROP TABLE timetable_supervision'); |
|
386
|
|
|
$this->addSql('DROP TABLE timetable_week'); |
|
387
|
|
|
$this->addSql('DROP TABLE tuition'); |
|
388
|
|
|
$this->addSql('DROP TABLE tuition_additional_teachers'); |
|
389
|
|
|
$this->addSql('DROP TABLE user_type_entity'); |
|
390
|
|
|
$this->addSql('DROP TABLE user_web_push_subscription'); |
|
391
|
|
|
$this->addSql('DROP TABLE wiki'); |
|
392
|
|
|
$this->addSql('DROP TABLE wiki_article_visibilities'); |
|
393
|
|
|
$this->addSql('DROP TABLE ext_log_entries'); |
|
394
|
|
|
$this->addSql('DROP TABLE id_entity'); |
|
395
|
|
|
$this->addSql('DROP TABLE log'); |
|
396
|
|
|
$this->addSql('DROP TABLE cron_job'); |
|
397
|
|
|
$this->addSql('DROP TABLE cron_job_result'); |
|
398
|
|
|
$this->addSql('DROP TABLE oauth2_access_token'); |
|
399
|
|
|
$this->addSql('DROP TABLE oauth2_authorization_code'); |
|
400
|
|
|
$this->addSql('DROP TABLE oauth2_client'); |
|
401
|
|
|
$this->addSql('DROP TABLE oauth2_refresh_token'); |
|
402
|
|
|
} |
|
403
|
|
|
} |
|
404
|
|
|
|
SchulIT /
icc
Loading history...
This function has been deprecated. The supplier of the function has supplied an explanatory message.
The explanatory message should give you some clue as to whether and when the function will be removed and what other function to use instead.