-- version 0

CREATE CACHED TABLE series (
       series_id INTEGER IDENTITY,
       series_name VARCHAR(128) NOT NULL
);

CREATE CACHED TABLE sample (
       series_id INTEGER NOT NULL REFERENCES series(series_id),       
       t TIMESTAMP NOT NULL,
       val DOUBLE NOT NULL
);

CREATE INDEX idx_sample_t ON sample(t);

CREATE CACHED TABLE dual (
       x INTEGER
);

INSERT INTO dual(x) values(1);

-- version 1

CREATE CACHED TABLE dashboard (
       name VARCHAR(64) NOT NULL,
       definition VARCHAR(4096) NOT NULL
);


Add a complete v1 schema file to work around a bug in sql-file.
Add a complete v1 schema file to work around a bug in sql-file.
