dbicdh/SQLite/deploy/1/001-auto-__VERSION.sql
author Vincent Tondellier <tonton+hg@team1664.org>
Sat, 12 Sep 2015 00:00:43 +0200
changeset 72 ec517ae81b39
parent 59 4f4f8a52a874
permissions -rw-r--r--
Fix path of prettify.js (may need change on != debian)
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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;