From 5e5443fad6bcd49ee57fda70855dc1e63a52f255 Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Wed, 21 Dec 2011 22:20:06 +0100
Subject: #44 angeltypes recreated

---
 db/update.sql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'db/update.sql')

diff --git a/db/update.sql b/db/update.sql
index 994e285d..7da5f3e6 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -12,4 +12,10 @@ NULL , 'ical', 'iCal shift export'
 );
 
 /* DECT Nummern können für GSM auch 5-stellig sein. */
-ALTER TABLE `User` CHANGE `DECT` `DECT` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
\ No newline at end of file
+ALTER TABLE `User` CHANGE `DECT` `DECT` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
+
+/* Neues Engeltypen-System */
+ALTER TABLE `AngelTypes` DROP `Man`;
+ALTER TABLE `AngelTypes` CHANGE `TID` `id` INT( 11 ) NOT NULL AUTO_INCREMENT;
+ALTER TABLE `AngelTypes` CHANGE `Name` `name` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
+ALTER TABLE `AngelTypes` ADD `restricted` INT( 1 ) NOT NULL;
-- 
cgit v1.2.3-70-g09d2

