[aur-dev] [PATCH] Specify utf8 in database schema.
Loui Chang
louipc.ist at gmail.com
Sun Feb 27 20:38:45 EST 2011
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
More information about the aur-dev
mailing list