From 01e7bdce1d0a232610b531661f418b0606c0fa84 Mon Sep 17 00:00:00 2001
From: Jan-Philipp Litza <janphilipp@litza.de>
Date: Mon, 26 Dec 2011 16:56:54 +0100
Subject: update script for UserAngelTypes and fixes to install.sql

---
 db/update.d/15_UserAngelTypes.php | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 db/update.d/15_UserAngelTypes.php

(limited to 'db/update.d')

diff --git a/db/update.d/15_UserAngelTypes.php b/db/update.d/15_UserAngelTypes.php
new file mode 100644
index 00000000..81a13f4e
--- /dev/null
+++ b/db/update.d/15_UserAngelTypes.php
@@ -0,0 +1,17 @@
+<?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 'Angel' FROM `User`.`Art`) = `AngelTypes`.`name`");
+
+    $applied = true;
+}
-- 
cgit v1.2.3-54-g00ecf