---
+--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Sat Oct 16 16:17:01 2010
---
+-- Created on Sat Jun 11 00:39:51 2011
+--
--
-- Table: artist
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 (
hello integer NOT NULL,
goodbye integer NOT NULL,
sensors character(10) NOT NULL,
- read_count integer,
+ read_count int,
PRIMARY KEY (foo, bar, hello, goodbye)
);
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);