--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Mon Mar 22 11:08:33 2010
+-- Created on Tue Feb 22 18:42:16 2011
--
-;
--
-- Table: artist
CREATE TABLE artist (
artistid INTEGER PRIMARY KEY NOT NULL,
name varchar(100),
- rank integer NOT NULL DEFAULT '13',
+ rank integer NOT NULL DEFAULT 13,
charfield char(10)
);
CREATE INDEX artist_name_hookidx ON artist (name);
+CREATE UNIQUE INDEX artist_name ON artist (name);
+
+CREATE UNIQUE INDEX u_nullable ON artist (charfield, rank);
+
--
-- Table: bindtype_test
--
id INTEGER PRIMARY KEY NOT NULL,
bytea blob,
blob blob,
- clob clob
+ clob clob,
+ a_memo memo
);
--
);
--
--- Table: file_columns
---
-CREATE TABLE file_columns (
- id INTEGER PRIMARY KEY NOT NULL,
- file varchar(255) NOT NULL
-);
-
---
-- Table: fourkeys
--
CREATE TABLE fourkeys (
CREATE INDEX books_idx_owner ON books (owner);
+CREATE UNIQUE INDEX books_title ON books (title);
+
--
-- Table: employee
--
position int NOT NULL,
title varchar(100) NOT NULL,
last_updated_on datetime,
- last_updated_at datetime,
- small_dt smalldatetime
+ last_updated_at datetime
);
CREATE INDEX track_idx_cd ON track (cd);
CREATE INDEX tags_idx_cd ON tags (cd);
+CREATE UNIQUE INDEX tagid_cd ON tags (tagid, cd);
+
+CREATE UNIQUE INDEX tagid_cd_tag ON tags (tagid, cd, tag);
+
+CREATE UNIQUE INDEX tags_tagid_tag ON tags (tagid, tag);
+
+CREATE UNIQUE INDEX tags_tagid_tag_cd ON tags (tagid, tag, cd);
+
--
-- Table: cd_to_producer
--
-- View: year2000cds
--
CREATE VIEW year2000cds AS
- SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000"
\ No newline at end of file
+ SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000";