summaryrefslogtreecommitdiff
path: root/db/update.d/15_UserAngelTypes.php
diff options
context:
space:
mode:
Diffstat (limited to 'db/update.d/15_UserAngelTypes.php')
-rw-r--r--db/update.d/15_UserAngelTypes.php17
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;
-}