[aur-dev] [PATCH] Specify utf8 in database schema.
Lukas Fleischer
archlinux at cryptocrack.de
Mon Feb 28 04:26:23 EST 2011
On Sun, Feb 27, 2011 at 08:38:45PM -0500, Loui Chang wrote:
> Signed-off-by: Loui Chang <louipc.ist at gmail.com>
> ---
> support/schema/aur-schema.sql | 8 ++++----
> 1 files changed, 4 insertions(+), 4 deletions(-)
>
> diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
> index b713fc8..1649055 100644
> --- a/support/schema/aur-schema.sql
> +++ b/support/schema/aur-schema.sql
> @@ -2,7 +2,7 @@
> -- is also included such as AccountTypes, etc.
> --
> DROP DATABASE AUR;
> -CREATE DATABASE AUR;
> +CREATE DATABASE AUR DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
> USE AUR;
>
> -- Define the Account Types for the AUR.
> @@ -159,7 +159,7 @@ CREATE TABLE PackageComments (
> ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
> PackageID INTEGER UNSIGNED NOT NULL,
> UsersID INTEGER UNSIGNED NOT NULL,
> - Comments TEXT NOT NULl DEFAULT '',
> + Comments TEXT NOT NULL DEFAULT '',
> CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
> DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL,
> PRIMARY KEY (ID),
> @@ -193,8 +193,8 @@ CREATE TABLE PackageBlacklist (
> --
> CREATE TABLE IF NOT EXISTS TU_VoteInfo (
> ID int(10) unsigned NOT NULL auto_increment,
> - Agenda text collate latin1_general_ci NOT NULL,
> - User VARCHAR(32) collate latin1_general_ci NOT NULL,
> + Agenda text COLLATE utf8_general_ci NOT NULL,
> + User VARCHAR(32) COLLATE utf8_general_ci NOT NULL,
> Submitted bigint(20) unsigned NOT NULL,
> End bigint(20) unsigned NOT NULL,
> SubmitterID int(10) unsigned NOT NULL,
> --
> 1.7.4.1
Thanks. Pushed that.
More information about the aur-dev
mailing list