--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Mon Feb 21 12:10:04 2011
+-- Created on Fri Mar 2 18:22:33 2012
--
--
);
--
--- 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
--