Hi all, We are in the process of upgrading our dspace from 1.5.2. to 1.8.2 and notice many differences between a newly created dspace 1.8 schema (Oracle) and when we upgrade an existing Oracle schema.
Most of the issues we can resolve. However, it is not clear to us whether there should be 3 or 4 constraints. ALTER TABLE COMMUNITY2COLLECTION DROP CONSTRAINT SYS_C0046271; ALTER TABLE COMMUNITY2COMMUNITY DROP CONSTRAINT SYS_C0046282; ALTER TABLE COMMUNITY2COMMUNITY DROP CONSTRAINT SYS_C0046281; ALTER TABLE COLLECTION2ITEM DROP CONSTRAINT SYS_C0046274; ALTER TABLE community2collection ADD CONSTRAINT comm2coll_collection_fk FOREIGN KEY (collection_id) REFERENCES collection DEFERRABLE; ALTER TABLE community2community ADD CONSTRAINT com2com_child_fk FOREIGN KEY (child_comm_id) REFERENCES community DEFERRABLE; ALTER TABLE collection2item ADD CONSTRAINT coll2item_item_fk FOREIGN KEY (item_id) REFERENCES item DEFERRABLE; ALTER TABLE DSPACE.COMMUNITY2COMMUNITY ADD FOREIGN KEY (PARENT_COMM_ID) REFERENCES DSPACE.COMMUNITY (COMMUNITY_ID); Do we need all 4? Best wishes, Francis Brouns Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Open Universiteit sluit iedere aansprakelijkheid uit die voortvloeit uit elektronische verzending. Aan de inhoud van deze e-mail en/of eventueel toegevoegde bijlagen kunnen geen rechten worden ontleend. This e-mail is intended exclusively for the addressee(s), and may not be passed on to, or made available for use by any person other than the addressee(s). Open Universiteit rules out any and every liability resulting from any electronic transmission. No rights may be derived from the contents of this message. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech