summaryrefslogtreecommitdiff
path: root/db/update.d/15_UserAngelTypes.php
diff options
context:
space:
mode:
authormsquare <msquare@notrademark.de>2016-08-22 19:32:54 +0200
committermsquare <msquare@notrademark.de>2016-08-22 19:32:54 +0200
commit3f4be08865296431d070e4386a252dac84d528ec (patch)
tree08ab8c245137dff544c7c928b4a924e604b41ece /db/update.d/15_UserAngelTypes.php
parent14d20933f7dcbf6d4aab3ee2c6444a19c7afdfd6 (diff)
remove old update script
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;
-}