--- Created on Thu Jul 30 09:37:43 2009
+--
+-- Created by SQL::Translator::Producer::SQLite
+-- Created on Mon Sep 21 00:11:34 2009
--
charfield char(10)
);
+CREATE INDEX artist_name_hookidx ON artist (name);
+
--
-- Table: bindtype_test
--
CREATE TABLE track (
trackid INTEGER PRIMARY KEY NOT NULL,
cd integer NOT NULL,
- position integer NOT NULL,
+ position int NOT NULL,
title varchar(100) NOT NULL,
last_updated_on datetime,
last_updated_at datetime,
- small_dt smalldatetime,
- increment integer
+ small_dt smalldatetime
);
CREATE INDEX track_idx_cd ON track (cd);