org.mmbase.storage.implementation.database
Class Schemes

java.lang.Object
  org.mmbase.storage.implementation.database.Schemes

public final class Schemes
extends Object

This class defines the scheme names and defaults used by the default database storage manager classes. Specific storage managers may add their own schemes, or not use schemes at all.

Since:

MMBase-1.7

Version:

$Id: Schemes.java 45079 2011-02-01 10:46:11Z michiel $

Author:

Pierre van Rooden

Field Summary

static String	CHANGE_FIELD Name of the scheme for changing a field.
static String	CHANGE_FIELD_DEFAULT The default scheme for changing a field.
static String	CREATE_CONSTRAINT Name of the scheme for creating (adding) a constraint, such as a key or index.
static String	CREATE_CONSTRAINT_DEFAULT The default scheme for creating (adding) a constraint.
static String	CREATE_DELETE_TRIGGER Name of the scheme for creating an 'delete' trigger for a view.
static String	CREATE_DELETE_TRIGGER_DEFAULT
static String	CREATE_FIELD Name of the scheme for creating (adding) a field.
static String	CREATE_FIELD_DEFAULT The default scheme for creating (adding) a field.
static String	CREATE_FOREIGN_KEY Name of the partial scheme for creating a foreign (referential) key.
static String	CREATE_FOREIGN_KEY_DEFAULT The default scheme for selecting a node type.
static String	CREATE_INDEX Name of the scheme for creating an index for a field.
static String	CREATE_INDEX_DEFAULT The default scheme for creating an index
static String	CREATE_INSERT_TRIGGER Name of the scheme for creating an 'insert' trigger for a view.
static String	CREATE_INSERT_TRIGGER_DEFAULT
static String	CREATE_OBJECT_ROW_TYPE Name of the scheme for creating a row type.
static String	CREATE_OBJECT_TABLE Name of the scheme for creating a table.
static String	CREATE_OBJECT_TABLE_DEFAULT The default scheme for creating a table.
static String	CREATE_PRIMARY_KEY Name of the partial scheme for creating a primary key.
static String	CREATE_PRIMARY_KEY_DEFAULT The default scheme for creating a primary key.
static String	CREATE_ROW_TYPE Name of the scheme for creating a row type.
static String	CREATE_SEQUENCE Name of the scheme for creating a sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) field definition of the primary key field ('number') {2} the database name or catalog
static String	CREATE_SEQUENCE_DEFAULT The default scheme for creating a sequence table.
static String	CREATE_TABLE Name of the scheme for creating a table.
static String	CREATE_TABLE_DEFAULT The default scheme for creating a table.
static String	CREATE_UNIQUE_INDEX Name of the scheme for creating a unique (generally composite) index.
static String	CREATE_UNIQUE_INDEX_DEFAULT The default scheme for creating a composite key.
static String	CREATE_UNIQUE_KEY Name of the partial scheme for creating a unique key.
static String	CREATE_UNIQUE_KEY_DEFAULT The default scheme for selecting a node type.
static String	CREATE_UPDATE_TRIGGER Name of the scheme for creating an 'update' trigger for a view.
static String	CREATE_UPDATE_TRIGGER_DEFAULT
static String	CREATE_VIEW Name of the scheme for creating a view.
static String	CREATE_VIEW_DEFAULT
static String	DELETE_CONSTRAINT Name of the scheme for deleting a constraint, such as a key or index.
static String	DELETE_CONSTRAINT_DEFAULT The default scheme for deleting a constraint.
static String	DELETE_FIELD Name of the scheme for deleting a field.
static String	DELETE_FIELD_DEFAULT The default scheme for deleting a field.
static String	DELETE_INDEX Name of the scheme for deleting a index.
static String	DELETE_INDEX_DEFAULT The default scheme for deleting a constraint.
static String	DELETE_NODE Name of the scheme for selecting a node type.
static String	DELETE_NODE_DEFAULT The default scheme for selecting a node type.
static String	DELETE_UNIQUE_INDEX Name of the scheme for deleting a unique (generally composite) index.
static String	DELETE_UNIQUE_INDEX_DEFAULT The default scheme for deleting a constraint.
static String	DROP_ROW_TYPE Name of the scheme for dropping a row type.
static String	DROP_TABLE Name of the scheme for dropping a table.
static String	DROP_TABLE_DEFAULT The default scheme for reading a text field.
static String	GET_BINARY_DATA Name of the scheme for reading a binary field from a node.
static String	GET_BINARY_DATA_DEFAULT The default scheme for reading a binary field.
static String	GET_TABLE_SIZE Name of the scheme for obtaining the size of a (builder) table.
static String	GET_TABLE_SIZE_DEFAULT The default scheme for reading a text field.
static String	GET_TEXT_DATA Name of the scheme for reading a text field from a node.
static String	GET_TEXT_DATA_DEFAULT The default scheme for reading a text field.
static String	INIT_SEQUENCE Name of the scheme for initializing a sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) name of the primary key field ('number') {2} the value to init the sequence to {3} a default 'increment'
static String	INIT_SEQUENCE_DEFAULT The default scheme for initializing a sequence table.
static String	INSERT_NODE Name of the scheme for inserting a node.
static String	INSERT_NODE_DEFAULT The default scheme for inserting a node type.
static String	READ_SEQUENCE Name of the scheme for retrieving the key from sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) name of the primary key field ('number') {2} the sequence buffer size (nr of keys that MMBase caches in the storage layer).
static String	READ_SEQUENCE_DEFAULT The default scheme for retrieving the key from a sequence table.
static String	SELECT_NODE Name of the scheme for selecting a node.
static String	SELECT_NODE_DEFAULT The default scheme for selecting a node.
static String	SELECT_NODE_TYPE Name of the scheme for selecting a node type.
static String	SELECT_NODE_TYPE_DEFAULT The default scheme for selecting a node type.
static String	UPDATE_NODE Name of the scheme for updating a node type.
static String	UPDATE_NODE_DEFAULT The default scheme for updating a node type.
static String	UPDATE_SEQUENCE Name of the scheme for updating a sequence or number table The parameters accepted are: {0} the storage manager (StorageManager), or the basename for tables (String) {1} the (suggested) name of the primary key field ('number') {2} the sequence buffer size (nr of keys that MMBase caches in the storage layer).
static String	UPDATE_SEQUENCE_DEFAULT The default scheme for updating a sequence table.

Constructor Summary

Schemes()

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CREATE_ROW_TYPE

public static final String CREATE_ROW_TYPE

Name of the scheme for creating a row type. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the row type for

{2} the field definitions (excluding index definitions)

{3} the builder that this rowtype extends from

This attribute is optional, and there is no default for this scheme. An example (for Informix):

CREATE ROW TYPE {1}_t ({2}) EXTENDS {3}_t

See Also:

Constant Field Values

CREATE_TABLE

public static final String CREATE_TABLE

Name of the scheme for creating a table. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the table name of the builder to create the table for

{2} the field definitions (excluding simple index definitions)

{3} the simple index definitions. A comma-seperated list, which is preceded by a comma UNLESS there is a rowtype scheme defined

{4} the field definitions, including simple index definitions

{5} constraint definitions A comma-seperated list, which is preceded by a comma UNLESS there is a rowtype scheme defined, and no other field definitions.

{6} the table name of the builder that this table extends from

{7} the database name or catalog

You can set up your scheme to create extended tables (i.e. in Postgresql). You also can define indexes or fields seperate (i.e. in HSQL or in a create table after a create row type in Informix) or in one go (as you might do with MySQL).

See Also:

Constant Field Values

CREATE_TABLE_DEFAULT

public static final String CREATE_TABLE_DEFAULT

The default scheme for creating a table.

See Also:

Constant Field Values

CREATE_OBJECT_ROW_TYPE

public static final String CREATE_OBJECT_ROW_TYPE

Name of the scheme for creating a row type. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the row type for

{2} the field definitions (excluding index definitions)

This attribute is optional, and there is no default for this scheme. An example (for Informix):

CREATE ROW TYPE {1}_t ({2})

See Also:

Constant Field Values

CREATE_OBJECT_TABLE

public static final String CREATE_OBJECT_TABLE

Name of the scheme for creating a table. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the table for

{2} the field definitions (excluding simple index definitions) A comma-seperated list, which is preceded by a comma UNLESS there is a rowtype scheme defined

{3} the simple index definitions

{4} the field definitions, including simple index definitions A comma-seperated list, which is preceded by a comma UNLESS there is a rowtype scheme defined, and no other field definitions.

{5} the constraint definitions

You can set up your scheme to create extended tables (i.e. in Postgresql). You also can define indexes or fields seperate (i.e. in HSQL or in a create table after a create row type in Informix) or in one go (as you might do with MySQL).

See Also:

Constant Field Values

CREATE_OBJECT_TABLE_DEFAULT

public static final String CREATE_OBJECT_TABLE_DEFAULT

The default scheme for creating a table.

See Also:

Constant Field Values

CREATE_PRIMARY_KEY

public static final String CREATE_PRIMARY_KEY

Name of the partial scheme for creating a primary key. This a partial scheme that is typically included in an CREATE TABLE or ALTER TABLE scheme. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the key for

{2} the field to create the key for

See Also:

Constant Field Values

CREATE_PRIMARY_KEY_DEFAULT

public static final String CREATE_PRIMARY_KEY_DEFAULT

The default scheme for creating a primary key.

See Also:

Constant Field Values

CREATE_UNIQUE_KEY

public static final String CREATE_UNIQUE_KEY

Name of the partial scheme for creating a unique key. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the key for

{2} the field to create the key for

See Also:

Constant Field Values

CREATE_UNIQUE_KEY_DEFAULT

public static final String CREATE_UNIQUE_KEY_DEFAULT

The default scheme for selecting a node type.

See Also:

Constant Field Values

CREATE_FOREIGN_KEY

public static final String CREATE_FOREIGN_KEY

Name of the partial scheme for creating a foreign (referential) key. This a partial scheme that is typically included in an CREATE TABLE or ALTER TABLE scheme. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the key for

{2} the field to create the key for

{3} the basic storage element referenced (name of the object table)

{4} the name of the number field

{5} the name of the foreign key (may be unspecified)

See Also:

Constant Field Values

CREATE_FOREIGN_KEY_DEFAULT

public static final String CREATE_FOREIGN_KEY_DEFAULT

The default scheme for selecting a node type.

See Also:

Constant Field Values

CREATE_UNIQUE_INDEX

public static final String CREATE_UNIQUE_INDEX

Name of the scheme for creating a unique (generally composite) index. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the key for

{2} the fieldlist to create the key for

{3} the index name

See Also:

Constant Field Values

CREATE_UNIQUE_INDEX_DEFAULT

public static final String CREATE_UNIQUE_INDEX_DEFAULT

The default scheme for creating a composite key.

See Also:

Constant Field Values

DELETE_UNIQUE_INDEX

public static final String DELETE_UNIQUE_INDEX

Name of the scheme for deleting a unique (generally composite) index. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder of the field

{2} the index name

See Also:

Constant Field Values

DELETE_UNIQUE_INDEX_DEFAULT

public static final String DELETE_UNIQUE_INDEX_DEFAULT

The default scheme for deleting a constraint.

See Also:

Constant Field Values

CREATE_INDEX

public static final String CREATE_INDEX

Name of the scheme for creating an index for a field. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to create the key for

{2} the field (or fieldlist) to create the key for

{3} the index name

See Also:

Constant Field Values

CREATE_INDEX_DEFAULT

public static final String CREATE_INDEX_DEFAULT

The default scheme for creating an index

DELETE_INDEX

public static final String DELETE_INDEX

Name of the scheme for deleting a index. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder of the field

{2} the index name

See Also:

Constant Field Values

DELETE_INDEX_DEFAULT

public static final String DELETE_INDEX_DEFAULT

The default scheme for deleting a constraint.

DELETE_NODE

public static final String DELETE_NODE

Name of the scheme for selecting a node type. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to delete the node from (MMObjectBuilder), or the builder table name (String)

{2} the 'number' field (CoreField), or the database field name (String)

{3} the number of the object to update (Integer)

See Also:

Constant Field Values

DELETE_NODE_DEFAULT

public static final String DELETE_NODE_DEFAULT

The default scheme for selecting a node type.

See Also:

Constant Field Values

DROP_ROW_TYPE

public static final String DROP_ROW_TYPE

Name of the scheme for dropping a row type. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to drop teh rowtype of (MMObjectBuilder), or the builder table name (String)

See Also:

Constant Field Values

DROP_TABLE

public static final String DROP_TABLE

Name of the scheme for dropping a table. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to drop (MMObjectBuilder), or the builder table name (String)

See Also:

Constant Field Values

DROP_TABLE_DEFAULT

public static final String DROP_TABLE_DEFAULT

The default scheme for reading a text field.

See Also:

Constant Field Values

GET_BINARY_DATA

public static final String GET_BINARY_DATA

Name of the scheme for reading a binary field from a node. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to delete the node from (MMObjectBuilder), or the builder table name (String)

{2} the binary field (CoreField), or the binary field name (String)

{3} the 'number' field (CoreField), or the database field name (String)

{4} the number of the object to update (Integer)

See Also:

Constant Field Values

GET_BINARY_DATA_DEFAULT

public static final String GET_BINARY_DATA_DEFAULT

The default scheme for reading a binary field.

See Also:

Constant Field Values

GET_TABLE_SIZE

public static final String GET_TABLE_SIZE

Name of the scheme for obtaining the size of a (builder) table. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to count the node of (MMObjectBuilder), or the builder table name (String)

See Also:

Constant Field Values

GET_TABLE_SIZE_DEFAULT

public static final String GET_TABLE_SIZE_DEFAULT

The default scheme for reading a text field.

See Also:

Constant Field Values

GET_TEXT_DATA

public static final String GET_TEXT_DATA

Name of the scheme for reading a text field from a node. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to delete the node from (MMObjectBuilder), or the builder table name (String)

{2} the text field (CoreField), or the text field name (String)

{3} the 'number' field (CoreField), or the database field name (String)

{4} the number of the object to update (Integer)

See Also:

Constant Field Values

GET_TEXT_DATA_DEFAULT

public static final String GET_TEXT_DATA_DEFAULT

The default scheme for reading a text field.

See Also:

Constant Field Values

INSERT_NODE

public static final String INSERT_NODE

Name of the scheme for inserting a node. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to update (MMObjectBuilder), or the builder table name (String)

{2} A comma-separated list of fieldnames to update'

{3} A comma-separated list of value-placeholders to update (a value placehodler takes the format '?')

See Also:

Constant Field Values

INSERT_NODE_DEFAULT

public static final String INSERT_NODE_DEFAULT

The default scheme for inserting a node type.

See Also:

Constant Field Values

SELECT_NODE

public static final String SELECT_NODE

Name of the scheme for selecting a node. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to query (MMObjectBuilder), or the builder table name (String)

{2} the 'number' field (CoreField), or the database field name (String)

{3} the number to locate (Integer)

See Also:

Constant Field Values

SELECT_NODE_DEFAULT

public static final String SELECT_NODE_DEFAULT

The default scheme for selecting a node.

See Also:

Constant Field Values

SELECT_NODE_TYPE

public static final String SELECT_NODE_TYPE

Name of the scheme for selecting a node type. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the MMBase module (MMBase), or the object table name (String)

{2} the 'number' field (CoreField), or the database field name (String)

{3} the number to locate (Integer)

See Also:

Constant Field Values

SELECT_NODE_TYPE_DEFAULT

public static final String SELECT_NODE_TYPE_DEFAULT

The default scheme for selecting a node type.

See Also:

Constant Field Values

UPDATE_NODE

public static final String UPDATE_NODE

Name of the scheme for updating a node type. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder to update (MMObjectBuilder), or the builder table name (String)

{2} A comma-separated list of fields to update, in the format 'fieldname = ?'

{3} the 'number' field (CoreField), or the database field name (String)

{4} the number of the object to update (Integer)

See Also:

Constant Field Values

UPDATE_NODE_DEFAULT

public static final String UPDATE_NODE_DEFAULT

The default scheme for updating a node type.

See Also:

Constant Field Values

CREATE_SEQUENCE

public static final String CREATE_SEQUENCE

Name of the scheme for creating a sequence or number table The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the (suggested) field definition of the primary key field ('number')

{2} the database name or catalog

See Also:

Constant Field Values

CREATE_SEQUENCE_DEFAULT

public static final String CREATE_SEQUENCE_DEFAULT

The default scheme for creating a sequence table.

See Also:

Constant Field Values

INIT_SEQUENCE

public static final String INIT_SEQUENCE

Name of the scheme for initializing a sequence or number table The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the (suggested) name of the primary key field ('number')

{2} the value to init the sequence to

{3} a default 'increment'

See Also:

Constant Field Values

INIT_SEQUENCE_DEFAULT

public static final String INIT_SEQUENCE_DEFAULT

The default scheme for initializing a sequence table.

See Also:

Constant Field Values

UPDATE_SEQUENCE

public static final String UPDATE_SEQUENCE

Name of the scheme for updating a sequence or number table The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the (suggested) name of the primary key field ('number')

{2} the sequence buffer size (nr of keys that MMBase caches in the storage layer).

See Also:

Constant Field Values

UPDATE_SEQUENCE_DEFAULT

public static final String UPDATE_SEQUENCE_DEFAULT

The default scheme for updating a sequence table.

See Also:

Constant Field Values

READ_SEQUENCE

public static final String READ_SEQUENCE

Name of the scheme for retrieving the key from sequence or number table The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the (suggested) name of the primary key field ('number')

{2} the sequence buffer size (nr of keys that MMBase caches in the storage layer).

See Also:

Constant Field Values

READ_SEQUENCE_DEFAULT

public static final String READ_SEQUENCE_DEFAULT

The default scheme for retrieving the key from a sequence table.

See Also:

Constant Field Values

CREATE_FIELD

public static final String CREATE_FIELD

Name of the scheme for creating (adding) a field. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder of the field

{2} the field name

{3} the field definition (excluding simple index definitions)

See Also:

Constant Field Values

CREATE_FIELD_DEFAULT

public static final String CREATE_FIELD_DEFAULT

The default scheme for creating (adding) a field.

See Also:

Constant Field Values

CHANGE_FIELD

public static final String CHANGE_FIELD

Name of the scheme for changing a field. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder of the field

{2} the field name

{3} the field definition (excluding simple index definitions)

See Also:

Constant Field Values

CHANGE_FIELD_DEFAULT

public static final String CHANGE_FIELD_DEFAULT

The default scheme for changing a field.

See Also:

Constant Field Values

DELETE_FIELD

public static final String DELETE_FIELD

Name of the scheme for deleting a field. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder of the field

{2} the field

See Also:

Constant Field Values

DELETE_FIELD_DEFAULT

public static final String DELETE_FIELD_DEFAULT

The default scheme for deleting a field.

See Also:

Constant Field Values

CREATE_CONSTRAINT

public static final String CREATE_CONSTRAINT

Name of the scheme for creating (adding) a constraint, such as a key or index. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder of the field

{2} the constraint definition

See Also:

Constant Field Values

CREATE_CONSTRAINT_DEFAULT

public static final String CREATE_CONSTRAINT_DEFAULT

The default scheme for creating (adding) a constraint.

See Also:

Constant Field Values

DELETE_CONSTRAINT

public static final String DELETE_CONSTRAINT

Name of the scheme for deleting a constraint, such as a key or index. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the builder of the field

{2} the constraint name

See Also:

Constant Field Values

DELETE_CONSTRAINT_DEFAULT

public static final String DELETE_CONSTRAINT_DEFAULT

The default scheme for deleting a constraint.

See Also:

Constant Field Values

CREATE_VIEW

public static final String CREATE_VIEW

Name of the scheme for creating a view. The parameters accepted are:

{0} the storage manager (StorageManager), or the basename for tables (String)

{1} the view name of the builder to create the view for

{2} the table name of the builder to create the view for

{3} the fields in view

{4} the fields from tables

{5} the number field

{6} the table name of the builder that this table extends from

{7} the database name or catalog

See Also:

Constant Field Values

CREATE_VIEW_DEFAULT

public static final String CREATE_VIEW_DEFAULT

See Also:

Constant Field Values

CREATE_INSERT_TRIGGER

public static final String CREATE_INSERT_TRIGGER

Name of the scheme for creating an 'insert' trigger for a view. The parameters accepted are:

• {0} the storage manager (StorageManager), or the basename for tables (String)
• {1} the name of the view to create the trigger on
• {2} the name of the table in which the fields for this view are stored
• {3} the name of the view/table that this builder extends from
• {4} the list of fields of the table {2}
• {5} the list of values of the table {2}
• {6} the list of fields of the view {3}
• {7} the list of values of the table {3}
• {8} the name of the trigger

See Also:

Constant Field Values

CREATE_INSERT_TRIGGER_DEFAULT

public static final String CREATE_INSERT_TRIGGER_DEFAULT

CREATE_DELETE_TRIGGER

public static final String CREATE_DELETE_TRIGGER

Name of the scheme for creating an 'delete' trigger for a view. The parameters accepted are:

• {0} the storage manager (StorageManager), or the basename for tables (String)
• {1} the name of the view to create the trigger on
• {2} the name of the table in which the fields for this view are stored
• {3} the name of the view/table that this builder exntends from
• {4} the name of the number field that joins the tables in the views
• {5} the name of the trigger

See Also:

Constant Field Values

CREATE_DELETE_TRIGGER_DEFAULT

public static final String CREATE_DELETE_TRIGGER_DEFAULT

CREATE_UPDATE_TRIGGER

public static final String CREATE_UPDATE_TRIGGER

Name of the scheme for creating an 'update' trigger for a view. The parameters accepted are:

• {0} the storage manager (StorageManager), or the basename for tables (String)
• {1} the name of the view to create the trigger on
• {2} the name of the table in which the fields for this view are stored
• {3} the name of the view/table that this builder extends from
• {4} the list 'SET' statements for table {2}
• {5} the list 'SET' statements for table {3}
• {6} the name of the number field that joins the tables in the views
• {7} the name of the trigger

See Also:

Constant Field Values

CREATE_UPDATE_TRIGGER_DEFAULT

public static final String CREATE_UPDATE_TRIGGER_DEFAULT

Constructor Detail

Schemes

public Schemes()