Small updates to the SQL exporter:
- SQL Keywords are now uppercased
- Line breaks now occur at more sensible points so that the output is more readable
Before:
create table "participations" ( "user_id" bigint not null, "project_id" bigint not null, "start_date" datetime not null, "team_id" bigint not null, "department" varchar(255) not null, "employee_id" bigint not null ); alter table `participations` add primary key `participations_project_id_user_id_primary`(`project_id`, `user_id`); alter table `participations` add unique `participations_team_id_user_id_unique`(`team_id`, `user_id`); alter table `participations` add index `participations_department_employee_id_index`(`department`, `employee_id`)
Now:
CREATE TABLE `participations`(
`user_id` BIGINT NOT NULL,
`project_id` BIGINT NOT NULL,
`start_date` DATETIME NOT NULL,
`team_id` BIGINT NOT NULL,
`department` VARCHAR(255) NOT NULL,
`employee_id` BIGINT NOT NULL
);
ALTER TABLE
`participations` ADD PRIMARY KEY `participations_project_id_user_id_primary`(`project_id`, `user_id`);
ALTER TABLE
`participations` ADD UNIQUE `participations_team_id_user_id_unique`(`team_id`, `user_id`);
ALTER TABLE
`participations` ADD INDEX `participations_department_employee_id_index`(`department`, `employee_id`);