Updating database with relations; Adding new SQL query config files
authorrtrimana <rtrimana@uci.edu>
Thu, 22 Dec 2016 22:07:20 +0000 (14:07 -0800)
committerrtrimana <rtrimana@uci.edu>
Thu, 22 Dec 2016 22:07:20 +0000 (14:07 -0800)
localconfig/mysql/alarmSet.config [new file with mode: 0644]
localconfig/mysql/camSet.config [new file with mode: 0644]
localconfig/mysql/roomCameraRelation.config [new file with mode: 0644]
localconfig/mysql/roomSensorRelation.config [new file with mode: 0644]
localconfig/mysql/roomSet.config [new file with mode: 0644]
localconfig/mysql/smartSensorsSet.config [new file with mode: 0644]
others/Mysql/IoTMain.gz

diff --git a/localconfig/mysql/alarmSet.config b/localconfig/mysql/alarmSet.config
new file mode 100644 (file)
index 0000000..a321ced
--- /dev/null
@@ -0,0 +1,3 @@
+SELECT * FROM
+Alarm
+;
diff --git a/localconfig/mysql/camSet.config b/localconfig/mysql/camSet.config
new file mode 100644 (file)
index 0000000..939eb25
--- /dev/null
@@ -0,0 +1,3 @@
+SELECT * FROM
+Camera
+;
diff --git a/localconfig/mysql/roomCameraRelation.config b/localconfig/mysql/roomCameraRelation.config
new file mode 100644 (file)
index 0000000..3297815
--- /dev/null
@@ -0,0 +1,6 @@
+SELECT RELATION FROM
+FIRST
+Room
+OTHER
+Camera
+;
diff --git a/localconfig/mysql/roomSensorRelation.config b/localconfig/mysql/roomSensorRelation.config
new file mode 100644 (file)
index 0000000..52a7dce
--- /dev/null
@@ -0,0 +1,6 @@
+SELECT RELATION FROM
+FIRST
+Room
+OTHER
+SmartthingsSensor
+;
diff --git a/localconfig/mysql/roomSet.config b/localconfig/mysql/roomSet.config
new file mode 100644 (file)
index 0000000..a085212
--- /dev/null
@@ -0,0 +1,5 @@
+SELECT * FROM
+Room
+WHERE
+TYPE='LabRoom'
+;
diff --git a/localconfig/mysql/smartSensorsSet.config b/localconfig/mysql/smartSensorsSet.config
new file mode 100644 (file)
index 0000000..be13609
--- /dev/null
@@ -0,0 +1,3 @@
+SELECT * FROM
+SmartthingsSensor
+;
index 3a61a3f..a7449b7 100644 (file)
Binary files a/others/Mysql/IoTMain.gz and b/others/Mysql/IoTMain.gz differ