diff options
| author | Trygve Laugstøl <trygvis@inamo.no> | 2015-10-31 14:28:11 +0100 |
|---|---|---|
| committer | Trygve Laugstøl <trygvis@inamo.no> | 2015-10-31 14:28:11 +0100 |
| commit | 9d97d8f89bc570b1232c0dd8450f489b39023e18 (patch) | |
| tree | c0113f6ded70a2d0cbe39caea65c614016d3b323 /migrations/sqls | |
| parent | 803148d5a23afe207fb5de9ac73c986a324feb9c (diff) | |
| download | diller-server-9d97d8f89bc570b1232c0dd8450f489b39023e18.tar.gz diller-server-9d97d8f89bc570b1232c0dd8450f489b39023e18.tar.bz2 diller-server-9d97d8f89bc570b1232c0dd8450f489b39023e18.tar.xz diller-server-9d97d8f89bc570b1232c0dd8450f489b39023e18.zip | |
core/web:
o Adding last_timestamp
o Showing last_value and last_timestamp for each property.
Diffstat (limited to 'migrations/sqls')
| -rw-r--r-- | migrations/sqls/20151031131941-last-timestamp-down.sql | 1 | ||||
| -rw-r--r-- | migrations/sqls/20151031131941-last-timestamp-up.sql | 2 |
2 files changed, 3 insertions, 0 deletions
diff --git a/migrations/sqls/20151031131941-last-timestamp-down.sql b/migrations/sqls/20151031131941-last-timestamp-down.sql new file mode 100644 index 0000000..44f074e --- /dev/null +++ b/migrations/sqls/20151031131941-last-timestamp-down.sql @@ -0,0 +1 @@ +/* Replace with your SQL commands */
\ No newline at end of file diff --git a/migrations/sqls/20151031131941-last-timestamp-up.sql b/migrations/sqls/20151031131941-last-timestamp-up.sql new file mode 100644 index 0000000..0268983 --- /dev/null +++ b/migrations/sqls/20151031131941-last-timestamp-up.sql @@ -0,0 +1,2 @@ +ALTER TABLE device_property +ADD COLUMN last_timestamp TIMESTAMPTZ; |