--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Tue Mar 16 16:49:23 2010
+-- Created on Thu Nov 18 08:18:15 2010
--
--
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
--
);
--
+-- Table: timestamp_primary_key_test
+--
+CREATE TABLE timestamp_primary_key_test (
+ id timestamp NOT NULL DEFAULT current_timestamp,
+ PRIMARY KEY (id)
+);
+
+--
-- Table: treelike
--
CREATE TABLE treelike (
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
--