Index: openacs-4/packages/contacts/contacts.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/contacts.info,v
diff -u -N -r1.78 -r1.79
--- openacs-4/packages/contacts/contacts.info	26 Jun 2006 06:36:50 -0000	1.78
+++ openacs-4/packages/contacts/contacts.info	1 Nov 2006 11:25:39 -0000	1.79
@@ -7,14 +7,14 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="1.2b16" url="http://openacs.org/repository/download/apm/contacts-1.2b16.apm">
+    <version name="1.2b19" url="http://openacs.org/repository/download/apm/contacts-1.2b19.apm">
         <owner url="mailto:openacs@geddert.com">Matthew Geddert</owner>
         <summary>This application lets you collaboratively view, edit and categorize contacts.</summary>
         <release-date>2006-06-25</release-date>
         <description format="text/plain">Contacts is an application for managing all those people and or organization you need to keep track of. It has a complete UI for storing and categorizing contacts. Each contact can have an arbitrary number of custom attributes associated with it, including other contacts (i.e. a certain contact &quot;belongs&quot; to a certain organization). It also functions as a service contract provider for attributes related to users in your system</description>
         <maturity>0</maturity>
 
-        <provides url="contacts" version="1.2b16"/>
+        <provides url="contacts" version="1.2b19"/>
         <requires url="acs-datetime" version="4.1"/>
         <requires url="acs-events" version="0.5d3"/>
         <requires url="acs-tcl" version="5.2.0b3"/>
Index: openacs-4/packages/contacts/sql/postgresql/contacts-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-create.sql,v
diff -u -N -r1.14 -r1.15
--- openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	26 Jun 2006 06:36:51 -0000	1.14
+++ openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	1 Nov 2006 11:25:44 -0000	1.15
@@ -7,15 +7,17 @@
 --
 
 
--- all contacts are parties. we are making parties content repository items,
--- so we need party revisions
-
 create table contact_party_revisions (
         party_revision_id       integer
                                 constraint contact_party_revisions_id_fk references cr_revisions(revision_id)
                                 constraint contact_party_revisions_id_pk primary key
 );
 
+comment on table contact_party_revisions is '
+all contacts are parties. we are making parties content repository items,
+so we need party revisions
+';
+
 -- create the content type
 select content_type__create_type (
    'contact_party_revision',      -- content_type
@@ -61,12 +63,34 @@
                                 constraint contact_groups_id_nn not null,
         default_p               boolean default 'f'
                                 constraint contact_groups_default_p_nn not null,
+        user_change_p           boolean default 'f'
+                                constraint contact_groups_user_change_p_nn not null,
         package_id              integer
                                 constraint contact_groups_package_id_fk references apm_packages(package_id)
                                 constraint contact_groups_package_id_nn not null,
         unique(group_id,package_id)
 );
 
+comment on table contact_groups is '
+this mapping table notes what groups (this is acs groups) are can be used in a specific contacts package and therefore have special attributes.
+';
+
+comment on table contact_groups.group_id is '
+ACS Group ID which is linked to the contacts instance
+';
+
+comment on table contact_groups.package_id is '
+Package ID of the contacts instance the group is linked to
+';
+
+comment on table contact_groups.default_p is '
+Is this group a default group? This means that all contacts entered through this contacts instance are automatically added to this group
+';
+
+comment on table contact_groups.user_change_p is '
+Can a user change this his own attributes in this group?
+';
+
 create table contact_groups_allowed_rels (
         group_id                integer
                                 constraint contact_groups_id_fk references groups(group_id)
@@ -95,6 +119,31 @@
         unique(party_id,title,signature)
 );
 
+
+comment on table contact_signatures is '
+Contacts supports signatures for each party_id. This is where they are stored. THe signature is attached to each mailing the party sends out, if selected. A party can have multiple signatures, in this situation a select box is shown. The default signature is selected by default (if there is any).
+';
+
+comment on table contact_signatures.signature_id is '
+Primary key for identifying a signature
+';
+
+comment on table contact_signatures.title is '
+Title of the signature for nice display of the it.
+';
+
+comment on table contact_signatures.signature is '
+The signature itself. This will be attached to the mailing (if selected).
+';
+
+comment on table contact_signatures.default_p is '
+Is the signature the default signature.
+';
+
+comment on table contact_signatures.party_id is '
+Party_id of the user who is creating the mailing. This is not the signature for the recipient, but the sender of the mailing.
+';
+
 -- this view greatly simplifies getting available roles for various contact types
 create view contact_rel_types as 
 (    select rel_type,
Index: openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql	18 May 2006 18:02:59 -0000	1.7
+++ openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql	1 Nov 2006 11:25:44 -0000	1.8
@@ -56,6 +56,7 @@
         return v_party_revision_id;
 end;' language 'plpgsql';
 
+
 create or replace function contact_party_revision__item_id (
         integer,                -- party_id
         timestamptz,            -- creation_date
Index: openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b18-b19.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/upgrade/Attic/upgrade-1.2b18-b19.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b18-b19.sql	1 Nov 2006 11:25:44 -0000	1.1
@@ -0,0 +1 @@
+ alter table contact_groups add column user_change_p boolean default 'f';
\ No newline at end of file