Modify the sum type of the active servers MV.
authorAnt Zucaro <azucaro@gmail.com>
Wed, 8 Nov 2017 02:19:04 +0000 (21:19 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Wed, 8 Nov 2017 02:19:04 +0000 (21:19 -0500)
tables/active_servers_mv.tab

index a6be890..3a5c594 100755 (executable)
@@ -2,7 +2,7 @@ create table active_servers_mv(
        sort_order integer,
        server_id bigint,
        server_name character varying(128),
-       games integer,
+       play_time interval,
        create_dt timestamp without time zone default (now() at time zone 'UTC'),
     CONSTRAINT active_servers_mv_pk PRIMARY KEY (sort_order)
 );