diff options
author | franck cuny <franck@lumberjaph.net> | 2011-01-24 21:32:25 +0100 |
---|---|---|
committer | franck cuny <franck@lumberjaph.net> | 2011-01-24 21:32:25 +0100 |
commit | 0e615cf95a4fe198eed9ce125804767d1f38d80f (patch) | |
tree | 76b999d3a2f25ec6c76e24a2f05aa42ac01ded60 /sql/SQLite/deploy/2/001-auto-__VERSION.sql | |
parent | don't ignore .sql files (diff) | |
download | jitterbug-0e615cf95a4fe198eed9ce125804767d1f38d80f.tar.gz |
add sql schema for various version
Diffstat (limited to '')
-rw-r--r-- | sql/SQLite/deploy/2/001-auto-__VERSION.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/SQLite/deploy/2/001-auto-__VERSION.sql b/sql/SQLite/deploy/2/001-auto-__VERSION.sql new file mode 100644 index 0000000..8b1bc1f --- /dev/null +++ b/sql/SQLite/deploy/2/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Mon Jan 24 21:26:41 2011 +-- + +; +BEGIN TRANSACTION; +-- +-- Table: dbix_class_deploymenthandler_versions +-- +CREATE TABLE dbix_class_deploymenthandler_versions ( + id INTEGER PRIMARY KEY NOT NULL, + version varchar(50) NOT NULL, + ddl text, + upgrade_sql text +); +CREATE UNIQUE INDEX dbix_class_deploymenthandler_versions_version ON dbix_class_deploymenthandler_versions (version); +COMMIT \ No newline at end of file |