From 15c80c2d88bfc7d2ae06d3c5c6a6a64a78eb476e Mon Sep 17 00:00:00 2001 From: Mark Hymers Date: Wed, 27 Jul 2011 20:10:55 +0100 Subject: [PATCH] Update schema to 63 Signed-off-by: Mark Hymers --- setup/current_schema.sql | 2 +- setup/{schema_62.sql => schema_63.sql} | 10 +++++++--- 2 files changed, 8 insertions(+), 4 deletions(-) rename setup/{schema_62.sql => schema_63.sql} (99%) diff --git a/setup/current_schema.sql b/setup/current_schema.sql index a52d8c02..72130c95 120000 --- a/setup/current_schema.sql +++ b/setup/current_schema.sql @@ -1 +1 @@ -schema_62.sql \ No newline at end of file +schema_63.sql \ No newline at end of file diff --git a/setup/schema_62.sql b/setup/schema_63.sql similarity index 99% rename from setup/schema_62.sql rename to setup/schema_63.sql index 4229a235..18f432ca 100644 --- a/setup/schema_62.sql +++ b/setup/schema_63.sql @@ -981,7 +981,8 @@ CREATE TABLE archive ( origin_server text, description text, created timestamp with time zone DEFAULT now() NOT NULL, - modified timestamp with time zone DEFAULT now() NOT NULL + modified timestamp with time zone DEFAULT now() NOT NULL, + primary_mirror text ); @@ -5585,6 +5586,9 @@ GRANT SELECT ON TABLE version_checks TO PUBLIC; -- PostgreSQL database dump complete -- --- Set schema version -INSERT INTO config (name, value) VALUES ('db_revision', 62); +-- +-- PostgreSQL database dump complete +-- +-- Set schema version +INSERT INTO config (name, value) VALUES ('db_revision', 63); -- 2.39.2