Index: openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql	13 Jan 2005 13:55:32 -0000	1.4
+++ openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql	22 Jan 2005 17:59:37 -0000	1.5
@@ -7,8 +7,15 @@
 -- @cvs-id $Id$
 --
 
+-- create table email_image_rel_ext (
+--	rel_id 		integer constraint email_image_rel_ext_fk references acs_rels(rel_id)
+--			constraint email_image_rel_ext primary key 
+-- );
+
+
 @@ attribute
 @@ portraits
+@@ email-image
 @@ application-groups-create
 @@ subsite-callbacks-create
 @@ host-node-map-create
@@ -30,3 +37,4 @@
      persons
 where p.party_id = groups.group_id(+)
   and p.party_id = persons.person_id(+);
+
Index: openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-drop.sql	13 Jan 2005 13:55:32 -0000	1.3
+++ openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-drop.sql	22 Jan 2005 17:59:37 -0000	1.4
@@ -10,5 +10,6 @@
 @@ user-profiles-drop
 @@ attributes-drop
 @@ portraits-drop
+@@ email-image-drop
 @@ host-node-map-drop
 @@ site-node-selection-drop
\ No newline at end of file
Index: openacs-4/packages/acs-subsite/sql/oracle/email-image-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/email-image-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/sql/oracle/email-image-drop.sql	22 Jan 2005 17:57:35 -0000	1.1
@@ -0,0 +1,14 @@
+--
+-- packages/acs-subsite/sql/portraits-drop.sql
+--
+-- author  Miguel Marin (miguelmarin@viaro.net) Viaro Networks (www.viaro.net)
+-- creation-date 2005-01-22
+--
+
+drop table email_images;
+
+begin
+  acs_rel_type.drop_type('email_image_rel');
+end;
+/
+show errors
Index: openacs-4/packages/acs-subsite/sql/oracle/email-image.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/email-image.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/sql/oracle/email-image.sql	22 Jan 2005 17:57:35 -0000	1.1
@@ -0,0 +1,35 @@
+-- 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		constraint email_image_fk
+			references users
+			constraint email_image_pk
+			primary key
+);
+
+begin
+  acs_rel_type.create_role('email_image', 'Email Image', 'Email Images');
+
+  acs_rel_type.create_type (
+    rel_type => 'email_image_rel',
+    pretty_name => 'Email Image',
+    pretty_plural => 'Email Images',
+    object_type_one => 'user',
+    role_one => 'user',
+    table_name => 'email_images',
+    id_column => 'user_id',
+    package_name => 'email_image_rel',
+    min_n_rels_one => 1,
+    max_n_rels_one => 1,
+    object_type_two => 'content_item',
+    min_n_rels_two => 0,
+    max_n_rels_two => 1
+  );
+
+  commit;
+end;
+/
+show errors