--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Thu Nov 18 08:18:15 2010
+-- Created on Fri Mar 2 18:22:33 2012
--
--
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)
);
name varchar(100) NOT NULL
);
+CREATE UNIQUE INDEX owners_name ON owners (name);
+
--
-- Table: producer
--