From f358feda0b0294e403dafd118714ab24b7a8afde Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton@traccar.org>
Date: Wed, 28 Sep 2022 06:57:11 -0700
Subject: Add table for command queue

---
 schema/changelog-5.4.xml | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)

(limited to 'schema')

diff --git a/schema/changelog-5.4.xml b/schema/changelog-5.4.xml
index f3a13ef59..e69bc5fab 100644
--- a/schema/changelog-5.4.xml
+++ b/schema/changelog-5.4.xml
@@ -17,6 +17,39 @@
       <column name="overspeedgeofenceid" type="INT" defaultValueNumeric="0" />
     </addColumn>
 
+    <createTable tableName="tc_commands_queue">
+      <column autoIncrement="true" name="id" type="INT">
+        <constraints primaryKey="true" />
+      </column>
+      <column name="deviceid" type="INT">
+        <constraints nullable="false" />
+      </column>
+      <column name="description" type="VARCHAR(4000)">
+        <constraints nullable="false" />
+      </column>
+      <column name="type" type="VARCHAR(128)">
+        <constraints nullable="false" />
+      </column>
+      <column name="textchannel" type="BOOLEAN" defaultValueBoolean="false">
+        <constraints nullable="false" />
+      </column>
+      <column name="attributes" type="VARCHAR(4000)">
+        <constraints nullable="false" />
+      </column>
+    </createTable>
+
+    <addForeignKeyConstraint
+            baseTableName="tc_commands_queue"
+            baseColumnNames="deviceid"
+            constraintName="fk_commands_queue_deviceid"
+            onDelete="CASCADE"
+            referencedColumnNames="id"
+            referencedTableName="tc_devices" />
+
+    <createIndex tableName="tc_commands_queue" indexName="idx_commands_queue_deviceid">
+      <column name="deviceid" />
+    </createIndex>
+
   </changeSet>
 
 </databaseChangeLog>
-- 
cgit v1.2.3