2 # Module for SQLite DXSql variants
4 # Stuff like table creates and (later) alters
8 # Copyright (c) 2005 Dirk Koopman G1TLH
21 my $s = q(show tables);
22 my $sth = $self->prepare($s);
25 push @out, $sth->fetchrow_array;
33 my $s = q{create table spot (
34 rowid integer auto_increment primary key ,
36 spotcall varchar(14) not null,
39 spotter varchar(14) 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');