summaryrefslogtreecommitdiff
path: root/support/pdbf-toolkit/somedb.sql
diff options
context:
space:
mode:
authorNorbert Preining <norbert@preining.info>2019-09-02 13:46:59 +0900
committerNorbert Preining <norbert@preining.info>2019-09-02 13:46:59 +0900
commite0c6872cf40896c7be36b11dcc744620f10adf1d (patch)
tree60335e10d2f4354b0674ec22d7b53f0f8abee672 /support/pdbf-toolkit/somedb.sql
Initial commit
Diffstat (limited to 'support/pdbf-toolkit/somedb.sql')
-rw-r--r--support/pdbf-toolkit/somedb.sql6
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