Index: trunk/grails-app/conf/DataSource.groovy
===================================================================
--- trunk/grails-app/conf/DataSource.groovy	(revision 147)
+++ trunk/grails-app/conf/DataSource.groovy	(revision 148)
@@ -1,7 +1,12 @@
 dataSource {
-	pooled = true
-	driverClassName = "org.hsqldb.jdbcDriver"
-	username = "sa"
-	password = ""
+    pooled = true
+    /** HSQLDB  */
+    driverClassName = "org.hsqldb.jdbcDriver"
+    username = "sa"
+    password = ""
+    /** MySQL */
+//     driverClassName = "com.mysql.jdbc.Driver"
+//     username = "gnumimsadmin"
+//     password = "gnumimsadmin"
 }
 hibernate {
@@ -11,28 +16,42 @@
 }
 
-//environment specific settings
-//create-drop:  drop tables and data between sessions, then insert from Bootstrap.
-//create:       drop data between sessions, can't explain the rest.
-//update:       keep data, update tables as required, keeps inserting from BootStrap.
+// Environment specific settings.
+// create-drop:  drop tables and data between sessions, then call Bootstrap.
+// create:        drop data between sessions, can't explain the rest of the behaviour.
+// update:       keep data, update tables as required, then call BootStrap.
 environments {
-	development {
-		dataSource {
-			dbCreate = "create-drop" // one of 'create', 'create-drop','update'
-			url = "jdbc:hsqldb:mem:devDB"
-		}
-	}
-	test {
-		dataSource {
-			dbCreate = "update"
-			url = "jdbc:hsqldb:mem:testDb"
-		}
-	}
-	production {
-		dataSource {
-			//Delete dbCreate line after setup!
+    development {
+        dataSource {
+            /** HSQLDB - In memory */
             dbCreate = "create-drop"
-			//url = "jdbc:hsqldb:file:prodDb;shutdown=true"
             url = "jdbc:hsqldb:mem:devDB"
-		}
-	}
+            /** MySQL */
+//             dbCreate = "create-drop"
+//             url = "jdbc:mysql://host:3306/gnumims_dev"
+        }
+    }
+    test {
+        dataSource {
+            /** HSQLDB - In memory */
+            dbCreate = "update"
+            url = "jdbc:hsqldb:mem:devDb"
+            /** MySQL */
+//             dbCreate = "update"
+//             url = "jdbc:mysql://host:3306/gnumims_test"
+        }
+    }
+    production {
+        dataSource {
+            /** HSQLDB - In memory */
+            //Delete dbCreate line after setup!
+            dbCreate = "create-drop"
+            url = "jdbc:hsqldb:mem:devDB"
+            /** HSQLDB - In file */
+//             dbCreate = "update"
+//             url = "jdbc:hsqldb:file:prodDb;shutdown=true"
+            /** MySQL */
+//             dbCreate = "update"
+//             url = "jdbc:mysql://host:3306/gnumims_prod"
+        }
+    }
 }