mysql.patch

diff --git a/core/pom.xml b/core/pom.xml
index 34c283f..2e7a645 100644
--- a/core/pom.xml
+++ b/core/pom.xml
@@ -145,9 +145,6 @@
     <profiles>
         <profile>
             <id>hsqldb</id>
-            <activation>
-                <activeByDefault>true</activeByDefault>
-            </activation>
             <dependencies>
                 <dependency>
                     <groupId>com.broadleafcommerce</groupId>
@@ -157,6 +154,9 @@
         </profile>
         <profile>
             <id>mysql</id>
+            <activation>
+                <activeByDefault>true</activeByDefault>
+            </activation>
             <dependencies>
                 <dependency>
                     <groupId>com.broadleafcommerce</groupId>
diff --git a/core/src/main/resources/runtime-properties/common-shared.properties b/core/src/main/resources/runtime-properties/common-shared.properties
index 6ebd89c..e118218 100644
--- a/core/src/main/resources/runtime-properties/common-shared.properties
+++ b/core/src/main/resources/runtime-properties/common-shared.properties
@@ -97,37 +97,37 @@ store.front.webapp.prefix=http://localhost:8080/

 # Settings for the default persistence unit
 blPU.hibernate.hbm2ddl.auto=none
-blPU.hibernate.dialect=org.broadleafcommerce.common.dialect.DemoHSQLDialect
+blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
 blPU.hibernate.show_sql=false
 blPU.hibernate.cache.use_second_level_cache=true
 blPU.hibernate.cache.use_query_cache=true
 blPU.hibernate.hbm2ddl.import_files=null
 # Settings for the CMS storage persistence unit
 blCMSStorage.hibernate.hbm2ddl.auto=none
-blCMSStorage.hibernate.dialect=org.broadleafcommerce.common.dialect.DemoHSQLDialect
+blCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
 blCMSStorage.hibernate.show_sql=false
 blCMSStorage.hibernate.cache.use_second_level_cache=true
 blCMSStorage.hibernate.cache.use_query_cache=true
 blCMSStorage.hibernate.hbm2ddl.import_files=null
 # Settings for the secure persistence unit
 blSecurePU.hibernate.hbm2ddl.auto=none
-blSecurePU.hibernate.dialect=org.broadleafcommerce.common.dialect.DemoHSQLDialect
+blSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
 blSecurePU.hibernate.show_sql=false
 blSecurePU.hibernate.cache.use_second_level_cache=false
 blSecurePU.hibernate.cache.use_query_cache=false
 blSecurePU.hibernate.hbm2ddl.import_files=null
 # Settings for the event persistence unit
 blEventPU.hibernate.hbm2ddl.auto=none
-blEventPU.hibernate.dialect=org.broadleafcommerce.common.dialect.DemoHSQLDialect
+blEventPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
 blEventPU.hibernate.show_sql=false
 blEventPU.hibernate.cache.use_second_level_cache=false
 blEventPU.hibernate.cache.use_query_cache=false
 blEventPU.hibernate.hbm2ddl.import_files=null

-blPU.hibernate.hbm2ddl.import_files_sql_extractor=org.broadleafcommerce.common.util.sql.importsql.DemoHsqlSingleLineSqlCommandExtractor
-blSecurePU.hibernate.hbm2ddl.import_files_sql_extractor=org.broadleafcommerce.common.util.sql.importsql.DemoHsqlSingleLineSqlCommandExtractor
-blCMSStorage.hibernate.hbm2ddl.import_files_sql_extractor=org.broadleafcommerce.common.util.sql.importsql.DemoHsqlSingleLineSqlCommandExtractor
-blEventPU.hibernate.hbm2ddl.import_files_sql_extractor=org.broadleafcommerce.common.util.sql.importsql.DemoHsqlSingleLineSqlCommandExtractor
+blPU.hibernate.hbm2ddl.import_files_sql_extractor=
+blSecurePU.hibernate.hbm2ddl.import_files_sql_extractor=
+blCMSStorage.hibernate.hbm2ddl.import_files_sql_extractor=
+blEventPU.hibernate.hbm2ddl.import_files_sql_extractor=

 auto.correct.sequence.generator.inconsistencies=true

@@ -203,4 +203,13 @@ searchRedirect.is.null.activeStartDate.active=false

 exception.handler.enabled=true

-logging.config=classpath:logging/logback.xml
\ No newline at end of file
+logging.config=classpath:logging/logback.xml
+
+
+# your local database username, just a user that has readwrite permissions
+database.user=root
+# local database password
+database.password=
+database.driver=com.mysql.jdbc.Driver
+# this connection URL assumes that it is connecting to a schema called broadleaf
+database.url=jdbc:mysql://localhost:3306/broadleaf?useUnicode=true&amp;characterEncoding=utf8