From 502b1c454d1eb686c8b35c18ce07e11fd64f9b4e Mon Sep 17 00:00:00 2001 From: Joakim Erdfelt Date: Mon, 18 Jun 2007 00:52:26 +0000 Subject: [PATCH] Fixing collation to utf8_general_ci git-svn-id: https://svn.apache.org/repos/asf/maven/archiva/trunk@548150 13f79535-47bb-0310-9956-ffa450edef68 --- archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql | 2 +- .../archiva-webapp/src/sql/mysql/drop_archiva_tables.sql | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql b/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql index 1726deab3..9da244402 100644 --- a/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql +++ b/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql @@ -1,6 +1,6 @@ -- mysql mysql --user=root --password < dev_bootstrap.sql -create database archiva; +create database archiva character set utf8 collate utf8_general_ci; create database redback; use mysql; diff --git a/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql b/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql index f51ef2bc3..b30ab647e 100644 --- a/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql +++ b/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql @@ -30,3 +30,5 @@ DROP TABLE IF EXISTS `ARCHIVA_VERSIONED_REFERENCE` ; DROP TABLE IF EXISTS `ARCHIVA_CIMANAGEMENT` ; DROP TABLE IF EXISTS `ARCHIVA_SCM` ; DROP TABLE IF EXISTS `ARCHIVA_ORGANIZATION` ; +DROP TABLE IF EXISTS `ARCHIVA_REPOSITORY_PROBLEMS` ; + -- 2.39.5