From 297e330ead69b92a4723369098e7c4dbf7aa5694 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Tue, 24 Aug 2021 23:14:30 -0700
Subject: Implement orders functionality

---
 schema/changelog-4.15.xml   | 66 +++++++++++++++++++++++++++++++++++++++++++++
 schema/changelog-master.xml |  1 +
 2 files changed, 67 insertions(+)
 create mode 100644 schema/changelog-4.15.xml

(limited to 'schema')

diff --git a/schema/changelog-4.15.xml b/schema/changelog-4.15.xml
new file mode 100644
index 000000000..e8dd15bb5
--- /dev/null
+++ b/schema/changelog-4.15.xml
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<databaseChangeLog
+  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
+                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd"
+  logicalFilePath="changelog-4.15">
+
+  <changeSet author="author" id="changelog-4.15">
+
+    <createTable tableName="tc_orders">
+      <column name="id" type="INT" autoIncrement="true">
+        <constraints primaryKey="true" />
+      </column>
+      <column name="uniqueid" type="VARCHAR(128)">
+        <constraints nullable="false" />
+      </column>
+      <column name="description" type="VARCHAR(512)" />
+      <column name="fromAddress" type="VARCHAR(512)" />
+      <column name="toAddress" type="VARCHAR(512)" />
+      <column name="attributes" type="VARCHAR(4000)">
+        <constraints nullable="false" />
+      </column>
+    </createTable>
+
+    <addUniqueConstraint tableName="tc_orders" columnNames="uniqueid" constraintName="uk_orders_uniqueid" />
+
+    <createTable tableName="tc_user_order">
+      <column name="userid" type="INT">
+        <constraints nullable="false" />
+      </column>
+      <column name="orderid" type="INT">
+        <constraints nullable="false" />
+      </column>
+    </createTable>
+
+    <addForeignKeyConstraint baseTableName="tc_user_order" baseColumnNames="userid" constraintName="fk_user_order_userid" referencedTableName="tc_users" referencedColumnNames="id" onDelete="CASCADE" />
+    <addForeignKeyConstraint baseTableName="tc_user_order" baseColumnNames="orderid" constraintName="fk_user_order_orderid" referencedTableName="tc_orders" referencedColumnNames="id" onDelete="CASCADE" />
+
+    <createTable tableName="tc_group_order">
+      <column name="groupid" type="INT">
+        <constraints nullable="false" />
+      </column>
+      <column name="orderid" type="INT">
+        <constraints nullable="false" />
+      </column>
+    </createTable>
+
+    <addForeignKeyConstraint baseTableName="tc_group_order" baseColumnNames="groupid" constraintName="fk_group_order_groupid" referencedTableName="tc_groups" referencedColumnNames="id" onDelete="CASCADE" />
+    <addForeignKeyConstraint baseTableName="tc_group_order" baseColumnNames="orderid" constraintName="fk_group_order_orderid" referencedTableName="tc_orders" referencedColumnNames="id" onDelete="CASCADE" />
+
+    <createTable tableName="tc_device_order">
+      <column name="deviceid" type="INT">
+        <constraints nullable="false" />
+      </column>
+      <column name="orderid" type="INT">
+        <constraints nullable="false" />
+      </column>
+    </createTable>
+
+    <addForeignKeyConstraint baseTableName="tc_device_order" baseColumnNames="deviceid" constraintName="fk_device_order_deviceid" referencedTableName="tc_devices" referencedColumnNames="id" onDelete="CASCADE" />
+    <addForeignKeyConstraint baseTableName="tc_device_order" baseColumnNames="orderid" constraintName="fk_device_order_orderid" referencedTableName="tc_orders" referencedColumnNames="id" onDelete="CASCADE" />
+
+  </changeSet>
+
+</databaseChangeLog>
diff --git a/schema/changelog-master.xml b/schema/changelog-master.xml
index df54737a2..245367de3 100644
--- a/schema/changelog-master.xml
+++ b/schema/changelog-master.xml
@@ -28,5 +28,6 @@
   <include file="changelog-4.10.xml" relativeToChangelogFile="true" />
   <include file="changelog-4.11.xml" relativeToChangelogFile="true" />
   <include file="changelog-4.13.xml" relativeToChangelogFile="true" />
+  <include file="changelog-4.15.xml" relativeToChangelogFile="true" />
 
 </databaseChangeLog>
-- 
cgit v1.2.3