dbicdh/PostgreSQL/deploy/1/001-auto-__VERSION.sql
author Vincent Tondellier <tonton+hg@team1664.org>
Mon, 09 Feb 2015 00:06:34 +0100
changeset 61 3a0ca02556da
parent 59 4f4f8a52a874
permissions -rw-r--r--
Add crash_data table to store the json Add searching on crashing backtrace function names Drop never used tables Bump DB schema version Requires PostgreSQL >= 9.4 for now (for jsonb)
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::PostgreSQL
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
-- Table: dbix_class_deploymenthandler_versions.
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
CREATE TABLE "dbix_class_deploymenthandler_versions" (
4f4f8a52a874 Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff changeset
    10
  "id" serial NOT NULL,
4f4f8a52a874 Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff changeset
    11
  "version" character varying(50) NOT NULL,
4f4f8a52a874 Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff changeset
    12
  "ddl" text,
4f4f8a52a874 Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff changeset
    13
  "upgrade_sql" text,
4f4f8a52a874 Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff changeset
    14
  PRIMARY KEY ("id"),
4f4f8a52a874 Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff changeset
    15
  CONSTRAINT "dbix_class_deploymenthandler_versions_version" UNIQUE ("version")
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
4f4f8a52a874 Add database v1 schema files
Vincent Tondellier <tonton+hg@team1664.org>
parents:
diff changeset
    18
;