diff options
| author | Loui Chang <louipc.ist@gmail.com> | 2011-02-27 20:38:45 -0500 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-02-28 09:38:14 +0100 |
| commit | c638a89314422ab98e91c585e24267bf8a1f79c3 (patch) | |
| tree | c0cf000e67055e2c618cd9aa70c096dc2890abdd /support/schema | |
| parent | 24c628ad43ae8b8777afbcaa44f6721cf5d2a29f (diff) | |
| download | aurweb-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.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, |