diff options
| author | Tharre <tharre3@gmail.com> | 2018-05-22 14:53:49 +0200 |
|---|---|---|
| committer | Tharre <tharre3@gmail.com> | 2018-05-22 14:56:40 +0200 |
| commit | 15eff625a55edccbc7fb7f8832a019348c4c9b7e (patch) | |
| tree | 87815d59558ea53fa0620072a6d70a1ef6408245 /src/main/resources/sql/database.sql | |
| parent | 5d079c1a30c3188bb514b251e8dc07c61596428f (diff) | |
| download | sepm-groupproject-15eff625a55edccbc7fb7f8832a019348c4c9b7e.tar.gz sepm-groupproject-15eff625a55edccbc7fb7f8832a019348c4c9b7e.tar.xz sepm-groupproject-15eff625a55edccbc7fb7f8832a019348c4c9b7e.zip | |
Fix regression caused by commit:3f84016
Enums have ordering is important, commit:3f84016 changed ordering of the
Vehicle.Status enum, but failed to also change that in the database
schema.
Diffstat (limited to 'src/main/resources/sql/database.sql')
| -rw-r--r-- | src/main/resources/sql/database.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/main/resources/sql/database.sql b/src/main/resources/sql/database.sql index ddedeac..463e8ac 100644 --- a/src/main/resources/sql/database.sql +++ b/src/main/resources/sql/database.sql @@ -9,8 +9,8 @@ CREATE TABLE IF NOT EXISTS VehicleVersion ( CREATE TABLE IF NOT EXISTS Vehicle ( id BIGINT AUTO_INCREMENT PRIMARY KEY, version BIGINT NOT NULL, - status ENUM('ABGEMELDET', 'FREI_WACHE', 'ZUM_BERUFUNGSORT', 'AM_BERUFUNGSORT', 'ZUM_ZIELORT', - 'AM_ZIELORT', 'FREI_FUNK', 'DELETED') NOT NULL, + status ENUM('ABGEMELDET', 'FREI_WACHE', 'FREI_FUNK', 'ZUM_BERUFUNGSORT', 'AM_BERUFUNGSORT', + 'ZUM_ZIELORT', 'AM_ZIELORT', 'DELETED') NOT NULL, FOREIGN KEY (version) REFERENCES VehicleVersion(id), ); |