/*
|
Navicat SQLite Data Transfer
|
|
Source Server : count
|
Source Server Version : 30714
|
Source Host : :0
|
|
Target Server Type : SQLite
|
Target Server Version : 30714
|
File Encoding : 65001
|
|
Date: 2019-06-04 10:59:23
|
*/
|
|
PRAGMA foreign_keys = OFF;
|
|
-- ----------------------------
|
-- Table structure for RealTimeMetrics
|
-- ----------------------------
|
DROP TABLE IF EXISTS "main"."RealTimeMetrics";
|
CREATE TABLE "RealTimeMetrics" (
|
"TotalEnters" INTEGER,
|
"Date" INTEGER,
|
"TransmitTime" INTEGER,
|
"TotalExits" INTEGER,
|
"id" TEXT,
|
"CreateDate" INTEGER,
|
PRIMARY KEY ("id" ASC)
|
);
|
|
-- ----------------------------
|
-- Indexes structure for table RealTimeMetrics
|
-- ----------------------------
|
CREATE UNIQUE INDEX "main"."idx_RealTimeMetrics"
|
ON "RealTimeMetrics" ("id" ASC);
|
