remove sm materilized tables

diff --git a/views.sql b/views.sql
index 808f76e..0c63c8e 100644 (file)
--- a/views.sql
+++ b/views.sql
@@ -14,9 +14,6 @@ from eg5120
 where sensor_type = 1;
 ;
 grant select on s_1 to gread ;
-drop table sm_1;
-create table sm_1 as select * from s_1;
-grant select on sm_1 to gread ;
 
 -- 2 2 Channel Push Notification
 drop view s_2;
@@ -34,9 +31,6 @@ from eg5120
 where sensor_type = 2;
 ;
 grant select on s_2 to gread ;
-drop table sm_2;
-create table sm_2 as select * from s_2;
-grant select on sm_2 to gread ;
 
 -- 29 Linear Displacement
 drop view s_29;
@@ -54,9 +48,6 @@ from eg5120
 where sensor_type = 29;
 ;
 grant select on s_29 to gread ;
-drop table sm_29;
-create table sm_29 as select * from s_29;
-grant select on sm_29 to gread ;
 
 -- 30 Structural Monitoring
 drop view s_30;
@@ -74,9 +65,6 @@ from eg5120
 where sensor_type = 30;
 ;
 grant select on s_30 to gread ;
-drop table sm_30;
-create table sm_30 as select * from s_30;
-grant select on sm_30 to gread ;
 
 -- 47 Wireless Tilt Sensor
 drop view s_47;
@@ -94,9 +82,6 @@ from eg5120
 where sensor_type = 47;
 ;
 grant select on s_47 to gread ;
-drop table sm_47;
-create table sm_47 as select * from s_47;
-grant select on sm_47 to gread ;
 
 -- 81 Two Channel Vibration Plus
 drop view s_81;
@@ -157,7 +142,4 @@ where sensor_type = 81
 order by time
 ;
 grant select on s_81 to gread ;
-drop table sm_81;
-create table sm_81 as select * from s_81;
-grant select on sm_81 to gread ;