X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=5f17ebe55531f797ca7878907644f40800b76dae;hb=1d7e89b8623b1ae271aac80651d16dc7c655b15a;hp=2ce5dadf4b27cb5334bac513ade8041a384b60f3;hpb=78060df8cb43cafd81304f386d7111510a4b8f9d;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index 2ce5dad..5f17ebe 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -11,6 +11,7 @@ CREATE TABLE employee ( employee_id INTEGER PRIMARY KEY NOT NULL, position integer NOT NULL, group_id integer, + group_id_2 integer, name varchar(100) ); @@ -107,7 +108,8 @@ CREATE TABLE track ( trackid INTEGER PRIMARY KEY NOT NULL, cd integer NOT NULL, position integer NOT NULL, - title varchar(100) NOT NULL + title varchar(100) NOT NULL, + last_updated_on datetime NULL ); -- @@ -128,6 +130,14 @@ CREATE TABLE link ( ); -- +-- Table: file_columns +-- +CREATE TABLE file_columns ( + id INTEGER PRIMARY KEY NOT NULL, + file varchar(255) +); + +-- -- Table: tags -- CREATE TABLE tags (