added new option to enforce Date or DateTime inflation, no matter what type the colum...

[dbsrgits/DBIx-Class.git] / t / lib / sqlite.sql

diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql
index e09d0ea..8de5cb5 100644 (file)
--- a/t/lib/sqlite.sql
+++ b/t/lib/sqlite.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::SQLite
--- Created on Thu Oct  9 13:12:46 2008
+-- Created on Fri Oct 24 21:02:41 2008
 -- 
 BEGIN TRANSACTION;
 
@@ -10,7 +10,8 @@ BEGIN TRANSACTION;
 --
 CREATE TABLE artist (
   artistid INTEGER PRIMARY KEY NOT NULL,
-  name varchar(100)
+  name varchar(100),
+  rank integer NOT NULL DEFAULT '13'
 );
 
 
@@ -113,7 +114,9 @@ CREATE TABLE employee (
 CREATE TABLE event (
   id INTEGER PRIMARY KEY NOT NULL,
   starts_at datetime NOT NULL,
-  created_on timestamp NOT NULL
+  created_on timestamp NOT NULL,
+  varchar_date varchar(20),
+  varchar_datetime varchar(20)
 );
 
 
@@ -170,11 +173,11 @@ CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_tw
 -- Table: genre
 --
 CREATE TABLE genre (
-  genreid  NOT NULL,
-  name  NOT NULL,
-  PRIMARY KEY (genreid)
+  genreid INTEGER PRIMARY KEY NOT NULL,
+  name varchar(100) NOT NULL
 );
 
+CREATE UNIQUE INDEX genre_name_genre ON genre (name);
 
 --
 -- Table: liner_notes