diff options
Diffstat (limited to 'db/update.d/15_UserAngelTypes.php')
-rw-r--r-- | db/update.d/15_UserAngelTypes.php | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/db/update.d/15_UserAngelTypes.php b/db/update.d/15_UserAngelTypes.php deleted file mode 100644 index 5609c06f..00000000 --- a/db/update.d/15_UserAngelTypes.php +++ /dev/null @@ -1,17 +0,0 @@ -<?php -if(sql_num_query("SHOW TABLES LIKE 'UserAngelTypes'") === 0) { - sql_query("CREATE TABLE `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` ) - )"); - sql_query("INSERT INTO `UserAngelTypes` (`user_id`, `angeltype_id`) - SELECT `User`.`UID`, `AngelTypes`.`id` - FROM `User` - INNER JOIN `AngelTypes` - ON TRIM(TRAILING 'Engel' FROM TRIM(TRAILING 'Angel' FROM `User`.`Art`)) = `AngelTypes`.`name`"); - - $applied = true; -} |