From c638a89314422ab98e91c585e24267bf8a1f79c3 Mon Sep 17 00:00:00 2001 From: Loui Chang Date: Sun, 27 Feb 2011 20:38:45 -0500 Subject: Specify utf8 in database schema. Signed-off-by: Loui Chang Signed-off-by: Lukas Fleischer --- support/schema/aur-schema.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'support') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index b713fc8e..1649055e 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.2.3-24-g4f1b