From c638a89314422ab98e91c585e24267bf8a1f79c3 Mon Sep 17 00:00:00 2001
From: Loui Chang <louipc.ist@gmail.com>
Date: Sun, 27 Feb 2011 20:38:45 -0500
Subject: Specify utf8 in database schema.

Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
---
 support/schema/aur-schema.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'support/schema/aur-schema.sql')

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,
-- 
cgit v1.3.1

