summaryrefslogtreecommitdiff
path: root/support/pdbf-toolkit/somedb.sql
blob: a9ee0c746964fa0840fbf403e778ce8b07dc51b8 (plain)
1
2
3
4
5
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);