summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorLoui Chang <louipc.ist@gmail.com>2011-02-28 02:38:45 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-28 09:38:14 +0100
commitc638a89314422ab98e91c585e24267bf8a1f79c3 (patch)
treec0cf000e67055e2c618cd9aa70c096dc2890abdd /support/schema
parent24c628ad43ae8b8777afbcaa44f6721cf5d2a29f (diff)
downloadaur-c638a89314422ab98e91c585e24267bf8a1f79c3.tar.gz
aur-c638a89314422ab98e91c585e24267bf8a1f79c3.tar.xz
Specify utf8 in database schema.
Signed-off-by: Loui Chang <louipc.ist@gmail.com> Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql8
1 files changed, 4 insertions, 4 deletions
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,