Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.50 -r1.51
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	13 Jan 2005 13:54:44 -0000	1.50
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	23 Jan 2005 23:16:19 -0000	1.51
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="5.2.0d11" url="http://openacs.org/repository/download/apm/acs-content-repository-5.2.0d11.apm">
+    <version name="5.2.0d12" url="http://openacs.org/repository/download/apm/acs-content-repository-5.2.0d12.apm">
         <owner url="http://openacs.org">OpenACS</owner>
 
         <summary>The canonical repository for OpenACS content.</summary>
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -r1.22 -r1.23
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	13 Jan 2005 13:55:07 -0000	1.22
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	23 Jan 2005 23:16:19 -0000	1.23
@@ -350,10 +350,13 @@
 create index cr_revisions_by_mime_type on cr_revisions(mime_type);
 create index cr_revisions_title_idx on cr_revisions(title);
 create index cr_revisions_item_id_idx ON cr_revisions(item_id);
+create index cr_revisions_publish_date_idx on cr_revisions(publish_date);
 
 -- create index cr_revisions_lower_title_idx on cr_revisions(lower(title));
 -- create index cr_revisions_title_ltr_idx on cr_revisions(substr(lower(title), 1, 1));
 
+
+
 comment on table cr_revisions is '
   Each content item may be associated with any number of revisions.
   The item_id is used to associate revisions with an item.
Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d11-5.2.0d12.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d11-5.2.0d12.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d11-5.2.0d12.sql	23 Jan 2005 23:16:19 -0000	1.1
@@ -0,0 +1 @@
+create index cr_revisions_publish_date_idx on cr_revisions(publish_date);
\ No newline at end of file
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.47 -r1.48
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	13 Jan 2005 13:55:09 -0000	1.47
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	23 Jan 2005 23:16:20 -0000	1.48
@@ -494,9 +494,12 @@
 
 create index cr_revisions_by_mime_type on cr_revisions(mime_type);
 create index cr_revisions_title_idx on cr_revisions(title);
+create index cr_revisions_publish_date_idx on cr_revisions(publish_date);
+
 -- create index cr_revisions_lower_title_idx on cr_revisions(lower(title));
 -- create index cr_revisions_title_ltr_idx on cr_revisions(substr(lower(title), 1, 1));
 
+
 comment on table cr_revisions is '
   Each content item may be associated with any number of revisions.
   The item_id is used to associate revisions with an item.
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d11-5.2.0d12.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d11-5.2.0d12.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d11-5.2.0d12.sql	23 Jan 2005 23:16:20 -0000	1.1
@@ -0,0 +1 @@
+create index cr_revisions_publish_date_idx on cr_revisions(publish_date);
\ No newline at end of file