diff options
| author | Anton Tananaev <anton@traccar.org> | 2023-01-24 09:59:30 -0800 |
|---|---|---|
| committer | Anton Tananaev <anton@traccar.org> | 2023-01-24 09:59:30 -0800 |
| commit | 51c167fa8067ac81a47914211cc252f5dd3e40f1 (patch) | |
| tree | 563f33a3b9ceadbc8d3b6d9958dc68d7be4c9040 /schema | |
| parent | 8841cea8676057756f23e1f9a710a5a19ac5e63a (diff) | |
| download | trackermap-server-51c167fa8067ac81a47914211cc252f5dd3e40f1.tar.gz trackermap-server-51c167fa8067ac81a47914211cc252f5dd3e40f1.tar.bz2 trackermap-server-51c167fa8067ac81a47914211cc252f5dd3e40f1.zip | |
Add calendar to report
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/changelog-5.6.xml | 5 |
1 files changed, 5 insertions, 0 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" /> |