diff options
author | msquare <msquare@notrademark.de> | 2016-08-22 19:32:54 +0200 |
---|---|---|
committer | msquare <msquare@notrademark.de> | 2016-08-22 19:32:54 +0200 |
commit | 3f4be08865296431d070e4386a252dac84d528ec (patch) | |
tree | 08ab8c245137dff544c7c928b4a924e604b41ece /db/update.d/15_UserAngelTypes.php | |
parent | 14d20933f7dcbf6d4aab3ee2c6444a19c7afdfd6 (diff) |
remove old update script
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; -} |