1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
/***************************************************************************
* Copyright (c) 2004 - 2011 Eike Stepper (Berlin, Germany) and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
* Andre Dietisheim - initial API and implementation
* Eike Stepper - maintenance
**************************************************************************/
package org.eclipse.emf.cdo.common.internal.db.cache;
import org.eclipse.net4j.db.DBType;
import org.eclipse.net4j.db.ddl.IDBField;
import org.eclipse.net4j.db.ddl.IDBIndex;
import org.eclipse.net4j.db.ddl.IDBTable;
import org.eclipse.net4j.spi.db.DBSchema;
/**
* @author Andre Dietisheim
*/
public class DBRevisionCacheSchema extends DBSchema
{
public static final DBRevisionCacheSchema INSTANCE = new DBRevisionCacheSchema();
/**
* DBTable dbrevisioncache_revisions.
* <p>
* TODO Make name configurable!
*/
public static final IDBTable REVISIONS = INSTANCE.addTable("dbrevisioncache_revisions");
public static final IDBField REVISIONS_ID = //
REVISIONS.addField("id", DBType.VARCHAR, 254);
public static final IDBField REVISIONS_VERSION = //
REVISIONS.addField("version", DBType.INTEGER);
public static final IDBField REVISIONS_CREATED = //
REVISIONS.addField("created", DBType.BIGINT);
public static final IDBField REVISIONS_REVISED = //
REVISIONS.addField("revised", DBType.BIGINT);
public static final IDBField REVISIONS_CDOREVISION = //
REVISIONS.addField("revision", DBType.BLOB);
public static final IDBField REVISIONS_RESOURCENODE_NAME = //
REVISIONS.addField("resourcenode_name", DBType.VARCHAR, false);
public static final IDBField REVISIONS_CONTAINERID = //
REVISIONS.addField("container_id", DBType.BIGINT, false);
public static final IDBIndex INDEX_REVISIONS_RESOURCENODENAME = //
REVISIONS.addIndex(IDBIndex.Type.NON_UNIQUE, REVISIONS_RESOURCENODE_NAME);
public static final IDBIndex INDEX_REVISIONS_ID = //
REVISIONS.addIndex(IDBIndex.Type.NON_UNIQUE, REVISIONS_ID);
public static final IDBIndex INDEX_REVISIONS_VERSION = //
REVISIONS.addIndex(IDBIndex.Type.NON_UNIQUE, REVISIONS_VERSION);
public static final IDBIndex INDEX_REVISIONS_PK = //
REVISIONS.addIndex(IDBIndex.Type.PRIMARY_KEY, REVISIONS_ID, REVISIONS_VERSION);
public static final IDBIndex INDEX_REVISIONS_CONTAINERID = //
REVISIONS.addIndex(IDBIndex.Type.NON_UNIQUE, REVISIONS_CONTAINERID);
private DBRevisionCacheSchema()
{
super("DBRevisionCache");
}
static
{
INSTANCE.lock();
}
}
|