Index: openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.1.4a1-2.2.0a3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/upgrade/Attic/upgrade-2.1.4a1-2.2.0a3.sql,v
diff -u -N
--- openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.1.4a1-2.2.0a3.sql	14 Mar 2006 03:04:43 -0000	1.1.2.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,149 +0,0 @@
--- 
--- 
--- 
--- @author Victor Guerra (guerra@galileo.edu)
--- @creation-date 2005-10-26
--- @arch-tag: 8c6601f5-4351-4295-8d55-bb9f711e23f0
--- @cvs-id $Id: upgrade-2.1.4a1-2.2.0a3.sql,v 1.1.2.1 2006/03/14 03:04:43 donb Exp $
---
-
--- Creating table for site templates                                                                                                           
-create table dotlrn_site_templates (
-        site_template_id        integer
-                                constraint dotlrn_site_templates_st_id_pk primary key,
-        pretty_name             varchar(100),
-        site_master             varchar(1000) not null,
-        portal_theme_id         integer
-                                constraint dotlrn_ste_templates_p_theme_id_fk
-                                references portal_element_themes(theme_id)
-);
-
-
--- Altering dotlrn communities table in order to have which
--- site template is going to be using the community
-
-alter table dotlrn_communities_all add column site_template_id integer;
-alter table dotlrn_communities_all add constraint dotlrn_c_site_template_id_fk foreign key (site_template_id) references dotlrn_site_templates(site_template_id);
-
-
--- Altering Users Profile table and dotlrn users view in order to have
--- which site teemplate is going to be using the user
-
-alter table dotlrn_user_profile_rels add column site_template_id integer;
-alter table dotlrn_user_profile_rels add constraint dotlrn_user_p_rels_site_template_id_fk foreign key (site_template_id) references dotlrn_site_templates(site_template_id);
-
-drop view dotlrn_users;
-
-create view dotlrn_users
-as
-    select acs_rels.rel_id,
-           dotlrn_user_profile_rels.portal_id,
-           dotlrn_user_profile_rels.theme_id,
-           dotlrn_user_profile_rels.id,
-           dotlrn_user_profile_rels.site_template_id,
-           users.user_id,
-           persons.first_names,
-           persons.last_name,
-           parties.email,
-           dotlrn_user_types.type,
-           dotlrn_user_types.pretty_name as pretty_type,
-           dotlrn_user_types.rel_type,
-           dotlrn_user_types.group_id,
-           dotlrn_user_types.segment_id
-    from dotlrn_user_profile_rels,
-         dotlrn_user_types,
-         acs_rels,
-         parties,
-         users,
-         persons
-    where dotlrn_user_profile_rels.rel_id = acs_rels.rel_id
-    and acs_rels.object_id_one = dotlrn_user_types.group_id
-    and acs_rels.object_id_two = parties.party_id
-    and parties.party_id = users.user_id
-    and users.user_id = persons.person_id;
-
-
---Creating default site tempaltes 
-
-create function inline_0()
-returns integer as '
-declare 
-	v_site_template_id	dotlrn_site_templates.site_template_id%TYPE;
-	v_theme_id		portal_element_themes.theme_id%TYPE;
-begin
-	select theme_id into v_theme_id 
-        from portal_element_themes 
-	where name = ''#new-portal.kelp_theme_name#''; 
-	
-	select acs_object_id_seq.nextval 
-        into v_site_template_id 
-        from dual;
-
-	insert into dotlrn_site_templates
-	(site_template_id, pretty_name, site_master, portal_theme_id ) 
-	values 
-	(v_site_template_id, ''#new-portal.kelp_theme_name#'',''/packages/dotlrn/www/dotlrn-master-kelp'', v_theme_id);
-
-
-	select theme_id into v_theme_id 
-        from portal_element_themes 
-	where name = ''#new-portal.sloan_theme_name#''; 
-	
-	select acs_object_id_seq.nextval 
-        into   v_site_template_id 
-        from   dual;
-
-	insert into dotlrn_site_templates
-	(site_template_id, pretty_name, site_master, portal_theme_id ) 
-	values 
-	(v_site_template_id, ''#new-portal.sloan_theme_name#'',''/packages/dotlrn/www/dotlrn-master'', v_theme_id);
-	
-
-	update dotlrn_communities_all set site_template_id = v_site_template_id;
-	update dotlrn_user_profile_rels set site_template_id = v_site_template_id;
-
-	update apm_parameter_values 
-        set attr_value = v_site_template_id
-	where parameter_id in ( select parameter_id 
-				from apm_parameters 
-				where parameter_name = ''CommDefaultSiteTemplate_p'' or parameter_name = ''UserDefaultSiteTemplate_p'');
-
-	
-
-	return v_site_template_id;
-
-end;' language 'plpgsql';
-
-select inline_0();
-
-drop function inline_0();
-
--- Create auxiliary tables
-
-create table apm_parameter_values_copy (
-	value_id	        integer,	
-	package_id		integer, 
-	parameter_id		integer, 
-	attr_value		text
-);
-
-insert into apm_parameter_values_copy (
-	value_id,	
-	package_id, 
-	parameter_id, 
-	attr_value 
-) select * from apm_parameter_values;
-
--- Store emails to be sent when user joins a community
-create table dotlrn_member_emails (
-        email_id	serial primary key,
-        community_id    integer references dotlrn_communities_all
-                        on delete cascade,
--- Might be useful
-        type            text default 'on join',
-        from_addr       text,
-        subject         text,
-        email           text,
-        enabled_p       boolean default 'f',
-	                constraint dotlrn_member_emails_un unique(community_id, type)
-);