wMDh50Ne

1"CREATE TABLE IF NOT EXISTS records (id VARCHAR(20) PRIMARY KEY, number INT NOT NULL, timestamp INT NOT NULL, name VARCHAR(20), views BIGINT NOT NULL,  data BINARY(128) NOT NULL, previousRecord VARCHAR(20) NOT NULL, , FOREIGN KEY ( previousRecord ) REFERENCES records ( id ) ON DELETE SET NULL)",
2	
3"CREATE UNIQUE INDEX IF NOT EXISTS records_number ON records(number)",
4
5"CREATE INDEX IF NOT EXISTS records_name ON records(name)"
6	
7SELECT r.id, r.number, r.name, r.views, lower(hex(r.data)),
8 r.previousRecord, it.id, it.type, it.recordId, lower(hex(it.data)) 
9FROM 
10  (select * from records limit 100 offset 100) as r  
11   left outer join items as it on it.recordId=r.id
12	
13SELECT  r.id, 
14        r.number, 
15        r.name, 
16        r.views, 
17        lower(hex(r.data)),
18        r.previousRecord, 
19        it.id, 
20        it.type, 
21        it.recordId, 
22        lower(hex(it.data)) 
23FROM 
24    records r
25    left outer join items as it on it.recordId = r.id
26    order by r.id 
27    limit 100 offset 100