--- a/roundup/backends/tsearch2_setup.py	Thu Jan 06 22:07:35 2005 +0000
+++ b/roundup/backends/tsearch2_setup.py	Sat Jan 08 11:25:23 2005 +0000
@@ -1,5 +1,34 @@
-tsearch_sql = """
--- Adjust this setting to control where the objects get CREATEd.
+#$Id: tsearch2_setup.py,v 1.2 2005-01-08 11:25:23 jlgijsbers Exp $
+
+# All the SQL in this module is taken from the tsearch2 module in the contrib
+# tree of PostgreSQL 7.4.6. PostgreSQL, and this code, has the following
+# license:
+#
+# PostgreSQL Data Base Management System
+# (formerly known as Postgres, then as Postgres95).
+#
+# Portions Copyright (c) 1996-2003, The PostgreSQL Global Development Group
+#
+# Portions Copyright (c) 1994, The Regents of the University of California
+#
+# Permission to use, copy, modify, and distribute this software and its
+# documentation for any purpose, without fee, and without a written agreement
+# is hereby granted, provided that the above copyright notice and this
+# paragraph and the following two paragraphs appear in all copies.
+#
+# IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR
+# DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
+# LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
+# DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE
+# POSSIBILITY OF SUCH DAMAGE.
+#
+# THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
+# INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
+# AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER IS
+# ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO
+# PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
+
+tsearch_sql = """ -- Adjust this setting to control where the objects get CREATEd.
 SET search_path = public;
 
 --dict conf