ObjectSchema.java

package com.idega.slide.schema;

import com.idega.util.dbschema.IndexImpl;

/**
 * 
 * 
 *  Last modified: $Date: 2007/02/04 20:42:22 $ by $Author: valdas $
 * 
 * @author <a href="mailto:aron@idega.com">aron</a>
 * @version $Revision: 1.3 $
 */
public class ObjectSchema extends SlideSchema {
	
	/*
	 CREATE TABLE "OBJECT" (
	"URI_ID" NUMBER(10),
    	"CLASS_NAME" VARCHAR2(255) NOT NULL,
	PRIMARY KEY("URI_ID"),
    	FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID")
    	) CACHE NOLOGGING; 
	 
	 */

	public ObjectSchema(){
		super();
		SlideSchemaColumn uriID = new SlideSchemaColumn(this);
		uriID.setDataTypeClass(Integer.class);
		uriID.setMaxLength(10);
		uriID.setPartOfPrimaryKey(true);
		uriID.setNullAllowed(false);
		uriID.setSQLFieldName("URI_ID");
		uriID.setOneToManyEntity(new UriSchema());
		
		
		SlideSchemaColumn className = new SlideSchemaColumn(this);
		className.setDataTypeClass(String.class);
		className.setNullAllowed(false);
		className.setSQLFieldName("CLASS_NAME");
		
		
		addColumn(uriID,true);
		addColumn(className);
		
		//CREATE INDEX object_idx1 ON object(class_name,uri_id);
		IndexImpl index1 = new IndexImpl("object_idx1",getSQLName());
		index1.addField("CLASS_NAME");
		index1.addField("URI_ID");
		addIndex(index1);
		
	
	}
	
	/* (non-Javadoc)
	 * @see com.idega.slide.entity.SlideEntity#getSQLTableName()
	 */
	public String getSQLName() {
		return "OBJECT";
	}
}