Changeset 6016
- Timestamp:
- 2003-11-27T12:32:39+13:00 (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/util/GS3SQLConnection.java
r6014 r6016 190 190 // as such for efficiency reasons 191 191 structureMap.addProperty("StructureID", 64); // this identifier 192 structureMap.addProperty(" Type", 64); // the type of the structure192 structureMap.addProperty("StructureType", 64); // the type of the structure 193 193 structureMap.addProperty("Label", 128); // the label of the structure 194 194 statement.execute(structureMap.toString()); … … 196 196 // create section table 197 197 GS3SQLCreateTable sectionMap = new GS3SQLCreateTable("divisions"); 198 sectionMap.addAutoPrimaryKey(" divisionRef");198 sectionMap.addAutoPrimaryKey("DivisionRef"); 199 199 sectionMap.addProperty("StructureRef", GS3SQLField.INTEGER_TYPE); 200 200 sectionMap.addProperty("DocID", 64); // a 'foreign key' in effect - but not treated … … 203 203 sectionMap.addProperty("ParentRef", 64); // the parent sql reference identifier 204 204 sectionMap.addProperty("SectionID", 64); // this identifier 205 sectionMap.addProperty(" Type", 64); // the type of the section205 sectionMap.addProperty("DivisionType", 64); // the type of the section 206 206 sectionMap.addProperty("LabelOrder", 64); // the order of the section 207 207 sectionMap.addProperty("ShortLabel", 128); // the short label of the section … … 213 213 GS3SQLCreateTable metaRefs = new GS3SQLCreateTable("divisionmetarefs"); 214 214 metaRefs.addProperty("DocID", 64); 215 metaRefs.addProperty(" divisionRef", GS3SQLField.INTEGER_TYPE);216 metaRefs.addProperty(" Type", 16); // whether a namespace or meta ref215 metaRefs.addProperty("DivisionRef", GS3SQLField.INTEGER_TYPE); 216 metaRefs.addProperty("DivisionType", 16); // whether a namespace or meta ref 217 217 metaRefs.addProperty("MetaID", 64); // the metadata reference itself, as a string 218 218 statement.execute(metaRefs.toString()); … … 221 221 GS3SQLCreateTable fileRefs = new GS3SQLCreateTable("divisionfilerefs"); 222 222 fileRefs.addProperty("DocID", 64); 223 fileRefs.addProperty(" divisionRef", GS3SQLField.INTEGER_TYPE);224 fileRefs.addProperty(" Type", 16); // whether section, group or file223 fileRefs.addProperty("DivisionRef", GS3SQLField.INTEGER_TYPE); 224 fileRefs.addProperty("DivisionType", 16); // whether section, group or file 225 225 fileRefs.addProperty("FileID", 32); 226 226 statement.execute(fileRefs.toString());
Note:
See TracChangeset
for help on using the changeset viewer.