[aur-dev] [PATCH] Remove explicit utf8 declarations in table creation

Dan McGee dan at archlinux.org
Thu Oct 20 10:30:51 EDT 2011


On Mon, Aug 22, 2011 at 3:45 PM, Dan McGee <dan at archlinux.org> wrote:
> The create database statement sets the default character set of the
> database to UTF-8, so no need to do it down below.
>
> Signed-off-by: Dan McGee <dan at archlinux.org>
> ---
Ping?

>  support/schema/aur-schema.sql |    4 ++--
>  1 files changed, 2 insertions(+), 2 deletions(-)
>
> diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
> index 88d074e..544ed94 100644
> --- a/support/schema/aur-schema.sql
> +++ b/support/schema/aur-schema.sql
> @@ -190,8 +190,8 @@ CREATE TABLE PackageBlacklist (
>  --
>  CREATE TABLE IF NOT EXISTS TU_VoteInfo (
>   ID int(10) unsigned NOT NULL auto_increment,
> -  Agenda text COLLATE utf8_general_ci NOT NULL,
> -  User VARCHAR(32) COLLATE utf8_general_ci NOT NULL,
> +  Agenda text NOT NULL,
> +  User VARCHAR(32) NOT NULL,
>   Submitted bigint(20) unsigned NOT NULL,
>   End bigint(20) unsigned NOT NULL,
>   SubmitterID int(10) unsigned NOT NULL,
> --
> 1.7.6
>
>


More information about the aur-dev mailing list