--
-- Created by SQL::Translator::Producer::SQLite
-- Created on Tue Jun 30 22:26:36 2009
--
BEGIN TRANSACTION;
--
-- Table: test
--
CREATE TABLE test (
pk1 INTEGER PRIMARY KEY NOT NULL,
display_name varchar(128) NOT NULL,
t_created datetime NOT NULL,
t_updated datetime NOT NULL
);
--
-- Table: test_date
--
CREATE TABLE test_date (
pk1 INTEGER PRIMARY KEY NOT NULL,
display_name varchar(128) NOT NULL,
t_created date NOT NULL,
t_updated date NOT NULL
);
--
-- Table: test_datetime
--
CREATE TABLE test_datetime (
pk1 INTEGER PRIMARY KEY NOT NULL,
display_name varchar(128) NOT NULL,
t_created datetime NOT NULL,
t_updated datetime NOT NULL
);
--
-- Table: test_time
--
CREATE TABLE test_time (
pk1 INTEGER PRIMARY KEY NOT NULL,
display_name varchar(128) NOT NULL,
t_created timestamp NOT NULL,
t_updated timestamp NOT NULL
);
COMMIT;