I just noticed that too, while contemplating a switch from Oracle to PostgreSQL. The Oracle schema also still has the mets_bitstream_id column in the Bundle table, which is no longer used and has been dropped.
I'll start a JIRA issue to fix this. (OBTW, before you switch over to Oracle, you ought to be aware that many DSpace tables use CLOBs, and those can make life very difficult because most of Oracle's own tools (e.g. SQL*Plus) don't work with them.) thanks, -- Larry On Dec 15, 2009, at 5:02 AM, Bram Luyten wrote: > Hello Francis, > > these tables are indeed deprecated and not in use anymore. > > best regards, > > Bram > > @mire - http://www.atmire.com > > Technologielaan 9 - 3001 Heverlee - Belgium > 533 2nd Street - Encinitas, CA 92024 - USA > > http://www.togather.eu - Before getting together, get t...@ther > > > On Tue, Dec 15, 2009 at 10:50 AM, Brouns, Francis <[email protected] > > wrote: > Hi, > > We are in the process of upgrading from Dspace 1.4.2 to 1.5.2, at > the same time moving from Postgresql to Oracle. When I perform an > upgrade from 1.4 to 1.5.2 and run the database_schema_142-15.sql on > Postgresql the tables history and history_state are dropped. > However, when I do a clean install of an Oracle database from > database_schema.sql (1.5.2) the tables history and history_state are > created. In the Postgresql database_schema.sql (1.5.2) those tables > are not created. It is save to assume that both tables are no longer > required? > > Best wishes, > Francis Brouns > Open Universiteit Nederland > ------------------------------------------------------------------------------ > Return on Information: > Google Enterprise Search pays you back > Get the facts. > http://p.sf.net/sfu/google-dev2dev > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > > ------------------------------------------------------------------------------ > Return on Information: > Google Enterprise Search pays you back > Get the facts. > http://p.sf.net/sfu/google-dev2dev > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
