Index: openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql	13 Jan 2005 13:55:32 -0000	1.6
+++ openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql	22 Jan 2005 18:02:00 -0000	1.7
@@ -9,6 +9,7 @@
 
 \i attribute.sql
 \i portraits.sql
+\i email-image.sql
 \i application-groups-create.sql
 \i subsite-callbacks-create.sql
 \i host-node-map-create.sql
Index: openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-drop.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-drop.sql	13 Jan 2005 13:55:32 -0000	1.4
+++ openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-drop.sql	22 Jan 2005 18:03:52 -0000	1.5
@@ -9,6 +9,7 @@
 \i user-profiles-drop.sql
 \i application-groups-drop.sql
 \i portraits-drop.sql
+\i email-image-drop.sql
 \i attributes-drop.sql
 \i host-node-map-drop.sql
 \i site-node-selection-dro.sql
Index: openacs-4/packages/acs-subsite/sql/postgresql/email-image-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/email-image-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/sql/postgresql/email-image-drop.sql	22 Jan 2005 18:02:00 -0000	1.1
@@ -0,0 +1,11 @@
+--
+-- packages/acs-subsite/sql/email-image-drop.sql
+--
+-- author Miguel Marin (miguelmarin@viaro.net) Viaro Networks (www.viaro.net)
+-- creation-date 2005-01-22
+--
+
+select acs_rel_type__drop_type('email_image_rel', 'f');
+select acs_rel_type__drop_role('email_image');
+
+drop table email_images;
Index: openacs-4/packages/acs-subsite/sql/postgresql/email-image.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/email-image.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/sql/postgresql/email-image.sql	22 Jan 2005 18:02:00 -0000	1.1
@@ -0,0 +1,41 @@
+-- Email Image Data Model
+-- author Miguel Marin (miguelmarin@viaro.net) Viaro Networks (www.viaro.net)
+-- creation-date 2005-01-22
+
+
+create table email_images (
+	user_id		integer constraint email_images_fk
+			references users
+			constraint email_images_pk
+			primary key
+);
+
+create function inline_0 ()
+returns integer as '
+begin
+  PERFORM acs_rel_type__create_role(''email_image'', ''Email Image'', ''Email Images'');
+
+  PERFORM acs_rel_type__create_type (
+      ''email_image_rel'',
+      ''Email Image'',
+      ''Email Images'',
+      ''relationship'',
+      ''email_images'',
+      ''user_id'',
+      ''email_image_rel'',
+      ''user'',
+      ''user'',
+      1,
+      1,
+      ''content_item'',
+      null,
+      0,
+      1
+  );
+
+  return 0;
+end;' language 'plpgsql';
+
+select inline_0 ();
+
+drop function inline_0 ();