Resolve "Fixes for standalone development"

Related to #38 (closed)

docker/db/02-smartdata_v1.sql

@@ -34,6 +34,11 @@ CREATE TABLE `series` (
   `workflow`   int unsigned NOT NULL DEFAULT '0',
   `domain`     varchar(48) NOT NULL DEFAULT 'public',
   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  `type` char(3) DEFAULT 'OLD',
+  `period` bigint(20) DEFAULT 0,
+  `event` varchar(300) DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `uncertainty` int(11) DEFAULT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `uk_series` (`version`,`unit`,`x`,`y`,`z`,`r`,`dev`,`t0`,`t1`,`workflow`,`domain`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -77,6 +82,10 @@ CREATE TABLE `trackers` (
   `domain`     varchar(48) NOT NULL DEFAULT 'public',
   `row_id`     bigint unsigned NOT NULL,
   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  `type` char(3) DEFAULT 'OLD',
+  `period` bigint(20) DEFAULT 0,
+  `event` varchar(300) DEFAULT NULL,
+  `uncertainty` int(11) DEFAULT 0,
   PRIMARY KEY (`id`),
   UNIQUE KEY `uk_trackers` (`version`,`unit`,`signature`,`t0`,`t1`,`dev`,`workflow`,`domain`,`row_id`)