From 01e7bdce1d0a232610b531661f418b0606c0fa84 Mon Sep 17 00:00:00 2001
From: Jan-Philipp Litza <janphilipp@litza.de>
Date: Mon, 26 Dec 2011 16:56:54 +0100
Subject: update script for UserAngelTypes and fixes to install.sql

---
 db/install.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'db/install.sql')

diff --git a/db/install.sql b/db/install.sql
index 77c1c559..97103f51 100644
--- a/db/install.sql
+++ b/db/install.sql
@@ -1173,10 +1173,10 @@ CREATE TABLE IF NOT EXISTS `Wecken` (
 -- Tabellenstruktur für Tabelle `UserAngelTypes`
 --
 
-CREATE TABLE `engelsystem`.`UserAngelTypes` (
+CREATE TABLE IF NOT EXISTS `UserAngelTypes` (
 `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 `user_id` INT NOT NULL ,
 `angeltype_id` INT NOT NULL ,
 `confirm_user_id` INT NULL ,
 INDEX ( `user_id` , `angeltype_id` , `confirm_user_id` )
-) ENGINE = MYISAM ;
+) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- 
cgit v1.2.3-70-g09d2

