diff options
author | Philip Häusler <msquare@notrademark.de> | 2011-12-21 22:20:06 +0100 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2011-12-21 22:20:06 +0100 |
commit | 5e5443fad6bcd49ee57fda70855dc1e63a52f255 (patch) | |
tree | c1b7475495ca7775dd2f975ff010b67255e34076 /db/update.sql | |
parent | 23d82fecb4d1e40f2ef8fe1ebc16455fa7221f0f (diff) |
#44 angeltypes recreated
Diffstat (limited to 'db/update.sql')
-rw-r--r-- | db/update.sql | 8 |
1 files changed, 7 insertions, 1 deletions
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; |