diff options
| -rw-r--r-- | schema/changelog-5.6.xml | 5 | ||||
| -rw-r--r-- | src/main/java/org/traccar/model/Report.java | 2 |
2 files changed, 6 insertions, 1 deletions
diff --git a/schema/changelog-5.6.xml b/schema/changelog-5.6.xml index d7768f8e2..38b206902 100644 --- a/schema/changelog-5.6.xml +++ b/schema/changelog-5.6.xml @@ -22,6 +22,9 @@ <column name="description" type="VARCHAR(128)"> <constraints nullable="false" /> </column> + <column name="calendarid" type="INT"> + <constraints nullable="false" /> + </column> <column name="from" type="TIMESTAMP"> <constraints nullable="false" /> </column> @@ -33,6 +36,8 @@ </column> </createTable> + <addForeignKeyConstraint baseTableName="tc_reports" baseColumnNames="calendarid" constraintName="fk_reports_calendarid" referencedTableName="tc_calendars" referencedColumnNames="id" onDelete="CASCADE" /> + <createTable tableName="tc_user_report"> <column name="userid" type="INT"> <constraints nullable="false" /> diff --git a/src/main/java/org/traccar/model/Report.java b/src/main/java/org/traccar/model/Report.java index 393f6fef7..83bb2e920 100644 --- a/src/main/java/org/traccar/model/Report.java +++ b/src/main/java/org/traccar/model/Report.java @@ -20,7 +20,7 @@ import org.traccar.storage.StorageName; import java.util.Date; @StorageName("tc_reports") -public class Report extends ExtendedModel { +public class Report extends ScheduledModel { private String type; |