Changeset 6515
- Timestamp:
- 2004-01-15T16:59:24+13:00 (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/gsdl3/src/java/org/greenstone/gsdl3/util/GSSQL.java
r6356 r6515 4 4 5 5 // table names 6 public static String DOCUMENT_TABLE = "document";7 public static String STRUCTURE_TABLE = "structure";8 public static String DIVISION_TABLE = "divisions";9 public static String DIVISION_FILE_TABLE = "divisionfilerefs";10 public static String DIVISION_METADATA_TABLE = "divisionmetarefs";11 public static String FILE_SECTION_TABLE = "filesection";12 public static String FILE_GROUP_TABLE = "filegroups";13 public static String FILE_TABLE = "files";14 public static String METADATA_TABLE = "metadata";15 public static String NAMESPACE_TABLE = "namespaces";16 public static String METADATA_VALUE_TABLE = "mdvalues";17 public static String CLASSIFIER_TABLE = "classifiers";18 public static String CLASS_DATA_TABLE = "classdata";19 public static String CLASS_DOCUMENT_TABLE = "classdocuments";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 20 21 21 // unique key names - references to the tables 22 public static String METADATA_REF = "MetadataRef";23 public static String NAMESPACE_REF = "NamespaceRef";24 public static String STRUCTURE_REF = "StructureRef";25 public static String DIVISION_REF = "DivisionRef";26 public static String FILE_SECTION_REF = "FileSectionRef";27 public static String FILE_GROUP_REF = "FileGroupRef";28 public static String CLASSIFIER_REF = "ClassifyRef";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 29 30 30 // combined refs 31 public static String PARENT_REF = "ParentRef";32 public static String PARENT_TYPE = "ParentType";31 public static final String PARENT_REF = "ParentRef"; 32 public static final String PARENT_TYPE = "ParentType"; 33 33 34 // otherfields - these are unique ids per document - ie combined with docid35 public static String DOCUMENT_ID = "DocID";36 public static String METADATA_ID = "MetaID";37 public static String FILE_ID = "FileID";38 public static String STRUCTURE_ID = "StructureID";39 public static String SECTION_ID = "SectionID";40 public static String FILE_GROUP_ID = "FileID";41 public static String FILE_SECTION_ID = "FileID";42 public static String CLASSIFIER_ID = "ClassifyID";43 public static String PARENT_ID = "ParentID";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 44 45 45 // type fields 46 public static String DOC_TYPE = "DocType";47 public static String NAMESPACE_TYPE = "NamespaceType";48 public static String STRUCTURE_TYPE = "StructureType";49 public static String DIVISION_TYPE = "DivisionType";50 public static String FILE_LOCATION_TYPE = "FileLocType";51 public static String MIME_TYPE = "MIMEType";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 52 53 53 // other stuff 54 public static String LABEL = "Label"; 55 public static String VALUE = "Value"; 56 public static String LABEL_ORDER = "LabelOrder"; 57 public static String SHORT_LABEL = "ShortLabel"; 58 public static String USER_LABEL = "UserLabel"; 59 public static String NAME = "Name"; 60 public static String DESCRIPTION = "Description"; 61 public static String FILE_LOCATION = "FileLocation"; 62 public static String CREATOR = "Creator"; 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"; 63 79 64 public static String MG_NUM = "mgseqno";65 66 public static String COMMA = ",";67 public static String EQUALS = "=";68 public static String QUOTE = "'";69 public static String EQUALS_QUOTE = "='";70 public static String DOT = ".";71 public static String END = ";";72 80 }
Note:
See TracChangeset
for help on using the changeset viewer.