CREATE TABLE CITATION_COLLECTION_ORDER (COLLECTION_ID VARCHAR2 (36) NOT NULL, CITATION_ID VARCHAR2 (36) NOT NULL, POSITION NUMBER(10,0) NOT NULL);
create index CITATION_COLL_ORDER_INDEX on CITATION_COLLECTION_ORDER (COLLECTION_ID,CITATION_ID);

UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='longtext' where SCHEMA_ID='unknown' and FIELD_ID='note' and PROPERTY_NAME='sakai:valueType';

UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='longtext' where SCHEMA_ID='article' and FIELD_ID='note' and PROPERTY_NAME='sakai:valueType';
UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='longtext' where SCHEMA_ID='book' and FIELD_ID='note' and PROPERTY_NAME='sakai:valueType';
UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='longtext' where SCHEMA_ID='chapter' and FIELD_ID='note' and PROPERTY_NAME='sakai:valueType';
UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='longtext' where SCHEMA_ID='report' and FIELD_ID='note' and PROPERTY_NAME='sakai:valueType';
UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='longtext' where SCHEMA_ID='proceed' and FIELD_ID='note' and PROPERTY_NAME='sakai:valueType';
UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='longtext' where SCHEMA_ID='thesis' and FIELD_ID='note' and PROPERTY_NAME='sakai:valueType';

UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='JF,JO,JA,J1,J2,BT,T2' where SCHEMA_ID='article' and FIELD_ID='sourceTitle' and PROPERTY_NAME='sakai:ris_identifier';
UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='BT,T2' where SCHEMA_ID='chapter' and FIELD_ID='sourceTitle' and PROPERTY_NAME='sakai:ris_identifier';
UPDATE CITATION_SCHEMA_FIELD set PROPERTY_VALUE='BT,T2' where SCHEMA_ID='proceed' and FIELD_ID='sourceTitle' and PROPERTY_NAME='sakai:ris_identifier';