2 # Module for SQLite DXSql variants
4 # Stuff like table creates and (later) alters
8 # Copyright (c) 2005 Dirk Koopman G1TLH
11 package DXSql::SQLite;
21 my $s = q(SELECT name FROM sqlite_master WHERE type='table' ORDER BY name);
22 my $sth = $self->prepare($s);
25 push @out, $sth->fetchrow_array;
33 my $s = q{create table spot (
34 rowid integer primary key,
36 spotcall text not null,
39 spotter text not null,
56 $self->do('create index spot_ix1 on spot(time desc)');
57 dbg('adding spot index ix1');
58 $self->do('create index spot_ix2 on spot(spotcall asc)');
59 dbg('adding spot index ix2');