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 -N -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 @@ t t - + OpenACS The canonical repository for OpenACS content. 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 -N -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 -N --- /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 -N -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 -N --- /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