summaryrefslogtreecommitdiff
path: root/db/update.d
diff options
context:
space:
mode:
authorJan-Philipp Litza <janphilipp@litza.de>2011-12-26 16:37:08 +0100
committerJan-Philipp Litza <janphilipp@litza.de>2011-12-26 16:37:08 +0100
commit36354d307eb7edca75b4dddec91e547b4d3ede46 (patch)
treee461d03c61658958e5893abf369953b8a234f7e8 /db/update.d
parent0d37e85f347a59e51a94c0bc7443c0377f6efba6 (diff)
updated table AngelTypes in update script
Diffstat (limited to 'db/update.d')
-rw-r--r--db/update.d/02_AngelTypes.php8
1 files changed, 7 insertions, 1 deletions
diff --git a/db/update.d/02_AngelTypes.php b/db/update.d/02_AngelTypes.php
index 8ac50948..b5561402 100644
--- a/db/update.d/02_AngelTypes.php
+++ b/db/update.d/02_AngelTypes.php
@@ -1,3 +1,9 @@
<?php
-_rename_table("EngelType", "AngelTypes");
+if(_rename_table("EngelType", "AngelTypes"))
+ sql_query("ALTER TABLE `AngelTypes`
+ CHANGE `TID` `id` INT NOT NULL AUTO_INCREMENT,
+ CHANGE `Name` `name` VARCHAR(25) NOT NULL DEFAULT '',
+ DROP `Man`,
+ ADD `restricted` INT(1) NOT NULL
+ ");
?>