diff options
author | Norbert Preining <norbert@preining.info> | 2019-09-02 13:46:59 +0900 |
---|---|---|
committer | Norbert Preining <norbert@preining.info> | 2019-09-02 13:46:59 +0900 |
commit | e0c6872cf40896c7be36b11dcc744620f10adf1d (patch) | |
tree | 60335e10d2f4354b0674ec22d7b53f0f8abee672 /support/pdbf-toolkit/somedb.sql |
Initial commit
Diffstat (limited to 'support/pdbf-toolkit/somedb.sql')
-rw-r--r-- | support/pdbf-toolkit/somedb.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/support/pdbf-toolkit/somedb.sql b/support/pdbf-toolkit/somedb.sql new file mode 100644 index 0000000000..a9ee0c7469 --- /dev/null +++ b/support/pdbf-toolkit/somedb.sql @@ -0,0 +1,6 @@ +CREATE TABLE data1 (date DATE, money INTEGER); +INSERT INTO data1 VALUES ('2008/05/07', 75), ('2008/05/08', 70), ('2008/05/09', 80), ('2008/05/10', 100), ('2008/05/11', 200), ('2008/05/12', 100), ('2008/05/13', 50), ('2008/05/14', 200), ('2008/05/15', 2000); +CREATE TABLE data2 (date DATE, runtimeA REAL, runtimeB REAL); +INSERT INTO data2 VALUES ('2008/05/07', 75.32, 72.58), ('2008/05/08', 74.16, 71.36), ('2008/05/09', 76.58, 70.24), ('2008/05/10', 70.46, 69.56), ('2008/05/11', 69.27, 69.18), ('2008/05/12', 66.91, 68.45), ('2008/05/13', 60.94, 67.34), ('2008/05/14', 62.16, 66.93), ('2008/05/15', 59.47, 66.34); +CREATE TABLE test (col1 INTEGER, col2 REAL); +INSERT INTO test VALUES (1,111.1), (2,222.1);
\ No newline at end of file |