| 1 | package org.greenstone.gsdl3.util;
|
|---|
| 2 |
|
|---|
| 3 | public class GSSQL {
|
|---|
| 4 |
|
|---|
| 5 | // table names
|
|---|
| 6 | public static final String DOCUMENT_TABLE = "document";
|
|---|
| 7 | public static final String STRUCTURE_TABLE = "structure";
|
|---|
| 8 | public static final String DIVISION_TABLE = "divisions";
|
|---|
| 9 | public static final String DIVISION_FILE_TABLE = "divisionfilerefs";
|
|---|
| 10 | public static final String DIVISION_METADATA_TABLE = "divisionmetarefs";
|
|---|
| 11 | public static final String FILE_SECTION_TABLE = "filesection";
|
|---|
| 12 | public static final String FILE_GROUP_TABLE = "filegroups";
|
|---|
| 13 | public static final String FILE_TABLE = "files";
|
|---|
| 14 | public static final String METADATA_TABLE = "metadata";
|
|---|
| 15 | public static final String NAMESPACE_TABLE = "namespaces";
|
|---|
| 16 | public static final String METADATA_VALUE_TABLE = "mdvalues";
|
|---|
| 17 | public static final String CLASSIFIER_TABLE = "classifiers";
|
|---|
| 18 | public static final String CLASS_DATA_TABLE = "classdata";
|
|---|
| 19 | public static final String CLASS_DOCUMENT_TABLE = "classdocuments";
|
|---|
| 20 |
|
|---|
| 21 | // unique key names - references to the tables
|
|---|
| 22 | public static final String METADATA_REF = "MetadataRef";
|
|---|
| 23 | public static final String NAMESPACE_REF = "NamespaceRef";
|
|---|
| 24 | public static final String STRUCTURE_REF = "StructureRef";
|
|---|
| 25 | public static final String DIVISION_REF = "DivisionRef";
|
|---|
| 26 | public static final String FILE_SECTION_REF = "FileSectionRef";
|
|---|
| 27 | public static final String FILE_GROUP_REF = "FileGroupRef";
|
|---|
| 28 | public static final String CLASSIFIER_REF = "ClassifyRef";
|
|---|
| 29 |
|
|---|
| 30 | // combined refs
|
|---|
| 31 | public static final String PARENT_REF = "ParentRef";
|
|---|
| 32 | public static final String PARENT_TYPE = "ParentType";
|
|---|
| 33 |
|
|---|
| 34 | // id fields - these are unique ids per document - ie combined with docid
|
|---|
| 35 | public static final String DOCUMENT_ID = "DocID";
|
|---|
| 36 | public static final String METADATA_ID = "MetaID";
|
|---|
| 37 | public static final String FILE_ID = "FileID";
|
|---|
| 38 | public static final String STRUCTURE_ID = "StructureID";
|
|---|
| 39 | public static final String SECTION_ID = "SectionID";
|
|---|
| 40 | public static final String FILE_GROUP_ID = "FileID";
|
|---|
| 41 | public static final String FILE_SECTION_ID = "FileID";
|
|---|
| 42 | public static final String CLASSIFIER_ID = "ClassifyID";
|
|---|
| 43 | public static final String PARENT_ID = "ParentID";
|
|---|
| 44 |
|
|---|
| 45 | // type fields
|
|---|
| 46 | public static final String DOC_TYPE = "DocType";
|
|---|
| 47 | public static final String NAMESPACE_TYPE = "NamespaceType";
|
|---|
| 48 | public static final String STRUCTURE_TYPE = "StructureType";
|
|---|
| 49 | public static final String DIVISION_TYPE = "DivisionType";
|
|---|
| 50 | public static final String FILE_LOCATION_TYPE = "FileLocType";
|
|---|
| 51 | public static final String MIME_TYPE = "MIMEType";
|
|---|
| 52 |
|
|---|
| 53 | // other stuff
|
|---|
| 54 | public static final String LABEL = "Label";
|
|---|
| 55 | public static final String VALUE = "Value";
|
|---|
| 56 | public static final String LABEL_ORDER = "LabelOrder";
|
|---|
| 57 | public static final String SHORT_LABEL = "ShortLabel";
|
|---|
| 58 | public static final String USER_LABEL = "UserLabel";
|
|---|
| 59 | public static final String NAME = "Name";
|
|---|
| 60 | public static final String DESCRIPTION = "Description";
|
|---|
| 61 | public static final String FILE_LOCATION = "FileLocation";
|
|---|
| 62 | public static final String CREATOR = "Creator";
|
|---|
| 63 | public static final String DOCUMENT_ORDER = "DocOrder";
|
|---|
| 64 | public static final String NUM_LEAF_DOCUMENTS = "NumLeafDocs";
|
|---|
| 65 |
|
|---|
| 66 | public static final String COMMA = ",";
|
|---|
| 67 | public static final String EQUALS = "=";
|
|---|
| 68 | public static final String QUOTE = "'";
|
|---|
| 69 | public static final String EQUALS_QUOTE = "='";
|
|---|
| 70 | public static final String DOT = ".";
|
|---|
| 71 | public static final String END = ";";
|
|---|
| 72 | public static final String NOT="!";
|
|---|
| 73 |
|
|---|
| 74 | // some values in the fields
|
|---|
| 75 | public static final String STRUCTURE = "Structure";
|
|---|
| 76 | public static final String DIVISION = "Division";
|
|---|
| 77 | public static final String ALL = "All";
|
|---|
| 78 | public static final String MG_NUM = "mgseqno";
|
|---|
| 79 |
|
|---|
| 80 | }
|
|---|
