--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Sat Jun 27 14:02:39 2009
+-- Created on Sat Mar 6 12:26:40 2010
--
-
-
-BEGIN TRANSACTION;
+;
--
-- Table: artist
charfield char(10)
);
+CREATE INDEX artist_name_hookidx ON artist (name);
+
--
-- Table: bindtype_test
--
created_on timestamp NOT NULL,
varchar_date varchar(20),
varchar_datetime varchar(20),
- skip_inflation datetime
-);
-
---
--- Table: file_columns
---
-CREATE TABLE file_columns (
- id INTEGER PRIMARY KEY NOT NULL,
- file varchar(255) NOT NULL
+ skip_inflation datetime,
+ ts_without_tz datetime
);
--
);
--
+-- Table: money_test
+--
+CREATE TABLE money_test (
+ id INTEGER PRIMARY KEY NOT NULL,
+ amount money
+);
+
+--
-- Table: noprimarykey
--
CREATE TABLE noprimarykey (
--
CREATE TABLE bookmark (
id INTEGER PRIMARY KEY NOT NULL,
- link integer NOT NULL
+ link integer
);
CREATE INDEX bookmark_idx_link ON bookmark (link);
cd integer NOT NULL
);
-CREATE INDEX forceforeign_idx_artist ON forceforeign (artist);
-
--
-- Table: self_ref_alias
--
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
+ last_updated_at datetime,
+ small_dt smalldatetime
);
CREATE INDEX track_idx_cd ON track (cd);
cd_id INTEGER PRIMARY KEY NOT NULL
);
-CREATE INDEX cd_artwork_idx_cd_id ON cd_artwork (cd_id);
-
--
-- Table: liner_notes
--
notes varchar(100) NOT NULL
);
-CREATE INDEX liner_notes_idx_liner_id ON liner_notes (liner_id);
-
--
-- Table: lyric_versions
--
-- View: year2000cds
--
CREATE VIEW year2000cds AS
- SELECT cdid, artist, title FROM cd WHERE year ='2000';
-
-COMMIT;
+ SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000"
\ No newline at end of file