/*
* Copyright (C) 2009 eXo Platform SAS.
*
* This is free software; you can redistribute it and/or modify it
* under the terms of the GNU Lesser General Public License as
* published by the Free Software Foundation; either version 2.1 of
* the License, or (at your option) any later version.
*
* This software is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this software; if not, write to the Free
* Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
* 02110-1301 USA, or see the FSF site: http://www.fsf.org.
*/
package org.exoplatform.services.jcr.impl.storage.jdbc;
import org.exoplatform.services.database.utils.DialectConstants;
/**
* Created by The eXo Platform SAS.
*
* @author Gennady Azarenkov
* @version $Id: DBConstants.java 34801 2009-07-31 15:44:50Z dkatayev $
*/
/**
* @author <a href="mailto:nzamosenchuk@exoplatform.com">Nikolay Zamosenchuk</a>
* @version $Id: DBConstants.java 34360 2009-07-22 23:58:59Z nzamosenchuk $
*
*/
/**
* @author <a href="mailto:nzamosenchuk@exoplatform.com">Nikolay Zamosenchuk</a>
* @version $Id: DBConstants.java 34360 2009-07-22 23:58:59Z nzamosenchuk $
*
*/
public class DBConstants extends DialectConstants
{
// ============================= Tables ============================
protected String JCR_ITEM;
protected String JCR_VALUE;
protected String JCR_REF;
// ======================== Error constants ========================
/**
* JCR_PK_ITEM.
*/
protected String JCR_PK_ITEM;
/**
* JCR_FK_ITEM_PARENT.
*/
protected String JCR_FK_ITEM_PARENT;
/**
* JCR_IDX_ITEM_PARENT.
*/
protected String JCR_IDX_ITEM_PARENT;
/**
* JCR_IDX_ITEM_PARENT.
*/
protected String JCR_IDX_ITEM_PARENT_NAME;
/**
* JCR_IDX_ITEM_PARENT_ID.
*/
protected String JCR_IDX_ITEM_PARENT_ID;
/**
* JCR_PK_VALUE.
*/
protected String JCR_PK_VALUE;
/**
* JCR_FK_VALUE_PROPERTY.
*/
protected String JCR_FK_VALUE_PROPERTY;
/**
* JCR_IDX_VALUE_PROPERTY.
*/
protected String JCR_IDX_VALUE_PROPERTY;
/**
* JCR_PK_REF.
*/
protected String JCR_PK_REF;
/**
* JCR_IDX_REF_PROPERTY.
*/
protected String JCR_IDX_REF_PROPERTY;
/**
* JCR_IDX_ITEM_N_ORDER_NUM
*/
protected String JCR_IDX_ITEM_N_ORDER_NUM;
/**
* JCR_ITEM_SEQ
*/
protected String JCR_ITEM_SEQ;
/**
* JCR_ITEM_NEXT_VAL
*/
protected String JCR_ITEM_NEXT_VAL;
/**
* JCR_IDX_ITEM_PARENT_FK
*/
protected String JCR_IDX_ITEM_PARENT_FK;
// ======================== SQL scripts ========================
/**
* FIND_ITEM_BY_ID.
*/
protected String FIND_ITEM_BY_ID;
/**
* FIND_ITEM_BY_PATH.
*/
protected String FIND_ITEM_BY_PATH;
/**
* FIND_ITEM_BY_NAME.
*/
protected String FIND_ITEM_BY_NAME;
/**
* FIND_CHILD_PROPERTY_BY_PATH.
*/
protected String FIND_CHILD_PROPERTY_BY_PATH;
/**
* FIND_PROPERTY_BY_NAME.
*/
protected String FIND_PROPERTY_BY_NAME;
/**
* FIND_REFERENCES.
*/
protected String FIND_REFERENCES;
/**
* FIND_VALUES_BY_PROPERTYID.
*/
protected String FIND_VALUES_BY_PROPERTYID;
/**
* FIND_NODES_BY_PARENTID.
*/
protected String FIND_NODES_BY_PARENTID;
/**
* FIND_LAST_ORDER_NUMBER_BY_PARENTID.
*/
protected String FIND_LAST_ORDER_NUMBER_BY_PARENTID;
/**
* FIND_NODES_COUNT_BY_PARENTID.
*/
protected String FIND_NODES_COUNT_BY_PARENTID;
/**
* FIND_PROPERTIES_BY_PARENTID.
*/
protected String FIND_PROPERTIES_BY_PARENTID;
/**
* FIND_MAX_PROPERTY_VERSIONS.
*/
protected String FIND_MAX_PROPERTY_VERSIONS;
/**
* INSERT_NODE.
*/
protected String INSERT_NODE;
/**
* INSERT_PROPERTY.
*/
protected String INSERT_PROPERTY;
/**
* INSERT_VALUE.
*/
protected String INSERT_VALUE;
/**
* INSERT_REF.
*/
protected String INSERT_REF;
/**
* RENAME_NODE.
*/
protected String RENAME_NODE;
/**
* UPDATE_NODE.
*/
protected String UPDATE_NODE;
/**
* UPDATE_PROPERTY.
*/
protected String UPDATE_PROPERTY;
/**
* DELETE_ITEM.
*/
protected String DELETE_ITEM;
/**
* DELETE_VALUE.
*/
protected String DELETE_VALUE;
/**
* DELETE_REF.
*/
protected String DELETE_REF;
/**
* FIND_NODES.
*/
protected String FIND_NODES_AND_PROPERTIES;
/**
* FIND_NODES_COUNT.
*/
protected String FIND_NODES_COUNT;
/**
* FIND_WORKSPACE_DATA_SIZE.
*/
protected String FIND_WORKSPACE_DATA_SIZE;
/**
* FIND_NODE_DATA_SIZE.
*/
protected String FIND_NODE_DATA_SIZE;
/**
* FIND_NODE_PROPERTIES_ON_VALUE_STORAGE.
*/
protected String FIND_NODE_PROPERTIES_ON_VALUE_STORAGE;
/**
* FIND_WORKSPACE_PROPERTIES_ON_VALUE_STORAGE.
*/
protected String FIND_WORKSPACE_PROPERTIES_ON_VALUE_STORAGE;
/**
* FIND_VALUE_STORAGE_DESC_AND_SIZE.
*/
protected String FIND_VALUE_STORAGE_DESC_AND_SIZE;
// ======================== ITEMS table ========================
/**
* COLUMN_ID.
*/
public static final String COLUMN_ID = "ID";
/**
* COLUMN_PARENTID.
*/
public static final String COLUMN_PARENTID = "PARENT_ID";
/**
* COLUMN_NAME.
*/
public static final String COLUMN_NAME = "NAME";
/**
* COLUMN_VERSION.
*/
public static final String COLUMN_VERSION = "VERSION";
/**
* CONTAINER_NAME. Exists only for single-db.
*/
public static final String CONTAINER_NAME = "CONTAINER_NAME";
/**
* COLUMN_CLASS.
*/
public static final String COLUMN_CLASS = "I_CLASS";
/**
* COLUMN_INDEX.
*/
public static final String COLUMN_INDEX = "I_INDEX";
/**
* COLUMN_NORDERNUM.
*/
public static final String COLUMN_NORDERNUM = "N_ORDER_NUM";
/**
* COLUMN_PTYPE.
*/
public static final String COLUMN_PTYPE = "P_TYPE";
/**
* COLUMN_PMULTIVALUED.
*/
public static final String COLUMN_PMULTIVALUED = "P_MULTIVALUED";
// VALUE table
/**
* PROPERTY_ID
*/
public static final String COLUMN_VPROPERTY_ID = "PROPERTY_ID";
/**
* COLUMN_VDATA.
*/
public static final String COLUMN_VDATA = "DATA";
/**
* COLUMN_VORDERNUM.
*/
public static final String COLUMN_VORDERNUM = "ORDER_NUM";
/**
* COLUMN_VSTORAGE_DESC.
*/
public static final String COLUMN_VSTORAGE_DESC = "STORAGE_DESC";
}