dhis2-devs team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 1845
committer: Lars <larshelg@larshelg-laptop>
branch nick: trunk
timestamp: Wed 2010-05-12 18:27:25 +0200
message:
  Mysql fix
modified:
  dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableCreator.java


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription

=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableCreator.java'
--- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableCreator.java	2010-04-12 21:23:33 +0000
+++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableCreator.java	2010-05-12 16:27:25 +0000
@@ -137,10 +137,10 @@
                 "periodid INTEGER NOT NULL, " +
                 "sourceid INTEGER NOT NULL, " +
                 "categoryoptioncomboid INTEGER NOT NULL, " +
-                "\"value\" CHARACTER VARYING(255), " +
-                "storedby CHARACTER VARYING(31), " +
+                "value VARCHAR(255), " +
+                "storedby VARCHAR(31), " +
                 "lastupdated TIMESTAMP, " +
-                "\"comment\" CHARACTER VARYING(360), " +
+                "comment VARCHAR(360), " +
                 "followup BOOLEAN, " +
                 "CONSTRAINT datavaluearchive_pkey PRIMARY KEY (dataelementid, periodid, sourceid, categoryoptioncomboid), " +
                 "CONSTRAINT fk_datavaluearchive_categoryoptioncomboid FOREIGN KEY (categoryoptioncomboid) " +
@@ -151,14 +151,14 @@
                     "REFERENCES period (periodid), " +
                 "CONSTRAINT fk_datavaluearchive_sourceid FOREIGN KEY (sourceid) " +
                     "REFERENCES source (sourceid) );";
-                
+            
             jdbcTemplate.execute( sql );
             
-            log.info( "Created table aggregateddatasetcompleteness" );
+            log.info( "Created table datavaluearchive" );
         }
         catch ( Exception ex )
         {
-            log.info( "Table aggregateddatasetcompleteness exists" );
+            log.info( "Table datavaluearchive exists" );
         }
     }
 }