From f06a8d55b49864c77d31633092fe1b21156bbf47 Mon Sep 17 00:00:00 2001
From: Greg Sabino Mullane <greg@endpoint.com>
Date: Fri, 4 Oct 2013 21:19:03 -0400
Subject: [PATCH] Add some text fields to the dbgroup and herd tables for
 future use in "cloning"

---
 bucardo.schema | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/bucardo.schema b/bucardo.schema
index c8ad47674..59d224c43 100644
--- a/bucardo.schema
+++ b/bucardo.schema
@@ -208,6 +208,7 @@ ALTER TABLE bucardo.db ADD CONSTRAINT db_status CHECK (status IN ('active','inac
 CREATE TABLE bucardo.dbgroup (
   name      TEXT        NOT NULL,
               CONSTRAINT dbgroup_name_pk PRIMARY KEY (name),
+  about     TEXT            NULL,
   cdate     TIMESTAMPTZ NOT NULL DEFAULT now()
 );
 COMMENT ON TABLE bucardo.dbgroup IS $$Named groups of databases: used as 'targetgroup' for syncs$$;
@@ -311,6 +312,7 @@ CREATE UNIQUE INDEX bucardo_custom_trigger_goat_type_unique ON bucardo.bucardo_c
 CREATE TABLE bucardo.herd (
   name       TEXT        NOT NULL,
                CONSTRAINT herd_name_pk PRIMARY KEY (name),
+  about      TEXT            NULL,
   cdate      TIMESTAMPTZ NOT NULL DEFAULT now()
 );
 COMMENT ON TABLE bucardo.herd IS $$Named group of tables or sequences from the goat table: used as the 'source' for syncs$$;
-- 
2.39.5