summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2011-10-21 23:03:38 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2011-10-24 17:57:52 +0200
commit10355ec9591dcc5314a77c553b5c2a13ef551fbe (patch)
tree141636f3eaef6eda6d8d359347be4d210d7ed58a /support/schema
parent99a2bb81cf4fe3c1b16451628d15450b76d1eafe (diff)
downloadaur-10355ec9591dcc5314a77c553b5c2a13ef551fbe.tar.gz
aur-10355ec9591dcc5314a77c553b5c2a13ef551fbe.tar.xz
Remove explicit utf8 declarations in table creation
The create database statement sets the default character set of the database to UTF-8, so no need to do it down below. Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 88d074e3..544ed941 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -190,8 +190,8 @@ CREATE TABLE PackageBlacklist (
--
CREATE TABLE IF NOT EXISTS TU_VoteInfo (
ID int(10) unsigned NOT NULL auto_increment,
- Agenda text COLLATE utf8_general_ci NOT NULL,
- User VARCHAR(32) COLLATE utf8_general_ci NOT NULL,
+ Agenda text NOT NULL,
+ User VARCHAR(32) NOT NULL,
Submitted bigint(20) unsigned NOT NULL,
End bigint(20) unsigned NOT NULL,
SubmitterID int(10) unsigned NOT NULL,