mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
ad79ef48a2
* add tests * add bench
73 lines
1.5 KiB
Plaintext
73 lines
1.5 KiB
Plaintext
|
|
CREATE TABLE t3(id INTEGER PRIMARY KEY, b NOT NULL);
|
|
CREATE TABLE t4(c, d, e);
|
|
CREATE UNIQUE INDEX i3 ON t3(b);
|
|
CREATE UNIQUE INDEX i4 ON t4(c, d);
|
|
|
|
|
|
CREATE TABLE t1(a, b);
|
|
CREATE INDEX i1 ON t1(a);
|
|
|
|
|
|
CREATE TABLE t5(a INTEGER PRIMARY KEY,b,c,d,e,f,g);
|
|
CREATE INDEX t5b ON t5(b);
|
|
CREATE INDEX t5c ON t5(c);
|
|
CREATE INDEX t5d ON t5(d);
|
|
CREATE INDEX t5e ON t5(e);
|
|
CREATE INDEX t5f ON t5(f);
|
|
CREATE INDEX t5g ON t5(g);
|
|
|
|
|
|
CREATE TABLE t1(a, b);
|
|
CREATE INDEX i1 ON t1(a);
|
|
CREATE INDEX i2 ON t1(b);
|
|
|
|
|
|
CREATE TABLE t2(x, y);
|
|
CREATE INDEX t2i1 ON t2(x);
|
|
|
|
|
|
CREATE TABLE t3(a INTEGER PRIMARY KEY, b, c);
|
|
CREATE INDEX t3i1 ON t3(b);
|
|
CREATE INDEX t3i2 ON t3(c);
|
|
|
|
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY,b,c,d,e,f,g);
|
|
CREATE INDEX t1b ON t1(b);
|
|
CREATE INDEX t1c ON t1(c);
|
|
CREATE INDEX t1d ON t1(d);
|
|
CREATE INDEX t1e ON t1(e);
|
|
CREATE INDEX t1f ON t1(f);
|
|
CREATE INDEX t1g ON t1(g);
|
|
|
|
|
|
CREATE TABLE composer(
|
|
cid INTEGER PRIMARY KEY,
|
|
cname TEXT
|
|
);
|
|
CREATE TABLE album(
|
|
aid INTEGER PRIMARY KEY,
|
|
aname TEXT
|
|
);
|
|
CREATE TABLE track(
|
|
tid INTEGER PRIMARY KEY,
|
|
cid INTEGER REFERENCES composer,
|
|
aid INTEGER REFERENCES album,
|
|
title TEXT
|
|
);
|
|
CREATE INDEX track_i1 ON track(cid);
|
|
CREATE INDEX track_i2 ON track(aid);
|
|
|
|
|
|
CREATE TABLE t1(
|
|
a,b,c,d,e, f,g,h,i,j,
|
|
k,l,m,n,o, p,q,r,s,t
|
|
);
|
|
CREATE INDEX i1 ON t1(k,l,m,n,o,p,q,r,s,t);
|
|
|
|
|
|
CREATE TABLE t6(a, b, c);
|
|
CREATE INDEX t6i1 ON t6(a, b);
|
|
CREATE INDEX t6i2 ON t6(c);
|
|
|