| author | Vincent Tondellier <tonton+hg@team1664.org> |
| Sun, 08 Feb 2015 22:36:04 +0100 | |
| changeset 59 | 4f4f8a52a874 |
| permissions | -rw-r--r-- |
|
59
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
1 |
-- |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
2 |
-- Created by SQL::Translator::Producer::SQLite |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
3 |
-- Created on Sun Feb 1 19:58:35 2015 |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
4 |
-- |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
5 |
|
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
6 |
; |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
7 |
BEGIN TRANSACTION; |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
8 |
-- |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
9 |
-- Table: dbix_class_deploymenthandler_versions |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
10 |
-- |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
11 |
CREATE TABLE dbix_class_deploymenthandler_versions ( |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
12 |
id INTEGER PRIMARY KEY NOT NULL, |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
13 |
version varchar(50) NOT NULL, |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
14 |
ddl text, |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
15 |
upgrade_sql text |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
16 |
); |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
17 |
CREATE UNIQUE INDEX dbix_class_deploymenthandler_versions_version ON dbix_class_deploymenthandler_versions (version); |
|
4f4f8a52a874
Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff
changeset
|
18 |
COMMIT; |