Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -r1.27 -r1.28
--- openacs-4/packages/acs-kernel/acs-kernel.info	16 Jul 2003 00:15:31 -0000	1.27
+++ openacs-4/packages/acs-kernel/acs-kernel.info	15 Aug 2003 14:35:49 -0000	1.28
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="5.0d" url="http://openacs.org/repository/download/apm/acs-kernel-5.0d.apm">
+    <version name="5.0d2" url="http://openacs.org/repository/download/apm/acs-kernel-5.0d2.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -17,7 +17,7 @@
         <release-date>2003-02-18</release-date>
         <vendor url="http://openacs.org/">OpenACS</vendor>
 
-        <provides url="acs-kernel" version="5.0d"/>
+        <provides url="acs-kernel" version="5.0d2"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v
diff -u -r1.20 -r1.21
--- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql	17 Jul 2003 01:10:39 -0000	1.20
+++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql	15 Aug 2003 14:35:50 -0000	1.21
@@ -160,7 +160,9 @@
 			        constraint apm_packages_inst_name_nn not null,
     enabled_p			char(1) default 'f' 
 			        constraint apm_packages_enabled_p_ck
-				check (enabled_p in ('t', 'f'))
+				check (enabled_p in ('t', 'f')),
+    -- default system locale for this package
+    default_locale              varchar2(30)
 );
 
 -- create bitmap index apm_packages_package_key_idx on apm_packages (package_key);
Index: openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql	29 Mar 2002 17:10:44 -0000	1.4
+++ openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql	15 Aug 2003 14:35:50 -0000	1.5
@@ -548,7 +548,9 @@
 	dont_spam_me_p		char(1) default 'f'
 				constraint user_prefs_dont_spam_me_p_ck
 				check (dont_spam_me_p in ('t','f')),
-	email_type		varchar2(64)
+	email_type		varchar2(64),
+        locale                  varchar2(30),
+        timezone                varchar2(100)
 );
 
 begin
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7.2d-5.0d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7.2d-5.0d.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7.2d-5.0d.sql	17 Jul 2003 01:10:39 -0000	1.3
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7.2d-5.0d.sql	15 Aug 2003 14:35:50 -0000	1.4
@@ -1,2 +1,25 @@
+-- 
+-- Upgrade script from 4.7.2d2 to 5.0d
+--
+-- @author Don Baccus (dhogaza@pacifier.net)
+-- @author Lars Pind (lars@collaboraid.biz)
+--
+-- @cvs-id $Id$
+--
+
+
+-- Add support for fast import of data files
+
 insert into apm_package_file_types(file_type_key, pretty_name) values('sql_data', 'SQL Data');
 insert into apm_package_file_types(file_type_key, pretty_name) values('ctl_file', 'SQL data loader control');
+
+
+
+-- Add locale preference to user_preferences table
+alter table user_preferences add locale varchar2(30);
+
+
+
+-- Add locale preference to apm_packages
+alter table apm_packages add default_locale varchar2(30);
+
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d-5.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d-5.0d2.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d-5.0d2.sql	15 Aug 2003 14:35:50 -0000	1.1
@@ -0,0 +1,11 @@
+-- 
+-- Upgrade script from 5.0d to 5.0d2
+--
+-- @author Simon Carstensen (simon@collaboraid.biz)
+--
+-- @cvs-id $Id: upgrade-5.0d-5.0d2.sql,v 1.1 2003/08/15 14:35:50 peterm Exp $
+--
+
+-- Adds column timezone to table user_preferences
+
+alter table user_preferences add timezone varchar2(100);
Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v
diff -u -r1.40 -r1.41
--- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	17 Jul 2003 01:10:40 -0000	1.40
+++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	15 Aug 2003 14:35:50 -0000	1.41
@@ -221,7 +221,9 @@
 				references apm_package_types(package_key),
     instance_name		varchar(300)
 			        constraint apm_packages_inst_name_nn not null,
-    enabled_p			boolean default 'f'
+    enabled_p			boolean default 'f',
+    -- default system locale for this package
+    default_locale              varchar(30)
 );
 
 create index apm_packages_package_key_idx on apm_packages (package_key);
Index: openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	17 May 2003 01:47:10 -0000	1.11
+++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	15 Aug 2003 14:35:50 -0000	1.12
@@ -520,7 +520,9 @@
 	-- an ISO 639 language code (in lowercase)
 	language_preference	char(2) default 'en',
 	dont_spam_me_p		boolean default 'f',
-	email_type		varchar(64)
+	email_type		varchar(64),
+        locale                  varchar(30),
+        timezone                varchar(100)
 );
 
 create function inline_1 ()
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7.2d-5.0d.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7.2d-5.0d.sql	17 Jul 2003 01:10:40 -0000	1.4
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7.2d-5.0d.sql	15 Aug 2003 14:35:51 -0000	1.5
@@ -1,2 +1,25 @@
+-- 
+-- Upgrade script from 4.7.2d2 to 5.0d
+--
+-- @author Don Baccus (dhogaza@pacifier.net)
+-- @author Lars Pind (lars@collaboraid.biz)
+--
+-- @cvs-id $Id$
+--
+
+
+-- Add support for fast import of data files
+
 insert into apm_package_file_types(file_type_key, pretty_name) values('sql_data', 'SQL Data');
 insert into apm_package_file_types(file_type_key, pretty_name) values('ctl_file', 'SQL data loader control');
+
+
+
+-- Add locale preference to user_preferences table
+alter table user_preferences add locale varchar(30);
+
+
+
+-- Add locale preference to apm_packages
+alter table apm_packages add default_locale varchar(30);
+
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d-5.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d-5.0d2.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d-5.0d2.sql	15 Aug 2003 14:35:51 -0000	1.1
@@ -0,0 +1,11 @@
+-- 
+-- Upgrade script from 5.0d to 5.0d2
+--
+-- @author Simon Carstensen (simon@collaboraid.biz)
+--
+-- @cvs-id $Id: upgrade-5.0d-5.0d2.sql,v 1.1 2003/08/15 14:35:51 peterm Exp $
+--
+
+-- Adds column timezone to table user_preferences
+
+alter table user_preferences add column timezone varchar(100);