2 # Module for SQLite DXSql variants
4 # Stuff like table creates and (later) alters
8 # Copyright (c) 2005 Dirk Koopman G1TLH
20 my $s = q(show tables);
21 my $sth = $self->prepare($s);
24 push @out, $sth->fetchrow_array;
32 my $s = q{create table spot (
33 rowid integer auto_increment primary key ,
35 spotcall varchar(14) not null,
38 spotter varchar(14) not null,
55 $self->do('create index spot_ix1 on spot(time desc)');
56 dbg('adding spot index ix1');
57 $self->do('create index spot_ix2 on spot(spotcall asc)');
58 dbg('adding spot index ix2');