From f7a00616b14821203f89e63d9c887b3e98b9826e Mon Sep 17 00:00:00 2001
From: Abyss777 <abyss@fox5.ru>
Date: Thu, 20 Oct 2016 15:32:56 +0500
Subject: Extend device model with management info

---
 schema/changelog-3.8.xml | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'schema')

diff --git a/schema/changelog-3.8.xml b/schema/changelog-3.8.xml
index 7a2b1e4e0..dbf04df79 100644
--- a/schema/changelog-3.8.xml
+++ b/schema/changelog-3.8.xml
@@ -94,5 +94,18 @@
     <modifyDataType tableName="groups" columnName="attributes" newDataType="VARCHAR(4000)" />
     <modifyDataType tableName="server" columnName="attributes" newDataType="VARCHAR(4000)" />
 
+    <addColumn tableName="devices">
+      <column name="phone" type="VARCHAR(128)" />
+    </addColumn>
+    <addColumn tableName="devices">
+      <column name="model" type="VARCHAR(128)" />
+    </addColumn>
+    <addColumn tableName="devices">
+      <column name="contact" type="VARCHAR(512)" />
+    </addColumn>
+    <addColumn tableName="devices">
+      <column name="type" type="VARCHAR(128)" />
+    </addColumn>
+
   </changeSet>
 </databaseChangeLog>
-- 
cgit v1.2.3