=== modified file 'dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/DefaultResourceTableService.java' --- dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/DefaultResourceTableService.java 2012-12-04 18:16:30 +0000 +++ dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/DefaultResourceTableService.java 2012-12-13 18:41:20 +0000 @@ -426,6 +426,7 @@ final PeriodType periodType = dataElement.getPeriodType(); values.add( String.valueOf( dataElement.getId() ) ); + values.add( dataElement.getUid() ); values.add( dataElement.getName() ); values.add( periodType != null ? String.valueOf( periodType.getId() ) : null ); values.add( periodType != null ? periodType.getName() : null ); === modified file 'dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/jdbc/JdbcResourceTableStore.java' --- dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/jdbc/JdbcResourceTableStore.java 2012-11-26 12:54:18 +0000 +++ dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/jdbc/JdbcResourceTableStore.java 2012-12-13 18:41:20 +0000 @@ -216,7 +216,7 @@ } final String sql = "CREATE TABLE " + TABLE_NAME_DATA_ELEMENT_STRUCTURE + - " ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementname VARCHAR(250), periodtypeid INTEGER, periodtypename VARCHAR(250) )"; + " ( dataelementid INTEGER NOT NULL PRIMARY KEY, uid CHARACTER(11), dataelementname VARCHAR(250), periodtypeid INTEGER, periodtypename VARCHAR(250) )"; log.info( "Create data element structure SQL: " + sql );