From 5e8453992810181facf168d6aaede9d2dcd61dba Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Sun, 5 Jan 2014 19:30:06 +0100
Subject: rewritten angeltypes and user angeltypes

---
 db/install.sql | 18 ------------------
 db/update.sql  |  3 +++
 2 files changed, 3 insertions(+), 18 deletions(-)

(limited to 'db')

diff --git a/db/install.sql b/db/install.sql
index 7eb404a9..896093e4 100644
--- a/db/install.sql
+++ b/db/install.sql
@@ -41,24 +41,6 @@ CREATE TABLE IF NOT EXISTS `AngelTypes` (
 
 -- --------------------------------------------------------
 
---
--- Tabellenstruktur für Tabelle `ChangeLog`
---
-
-DROP TABLE IF EXISTS `ChangeLog`;
-CREATE TABLE IF NOT EXISTS `ChangeLog` (
-  `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `UID` int(11) NOT NULL DEFAULT '0',
-  `Commend` text NOT NULL,
-  `SQLCommad` text NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
--- Daten für Tabelle `ChangeLog`
---
-
-
--- --------------------------------------------------------
 
 --
 -- Tabellenstruktur für Tabelle `Counter`
diff --git a/db/update.sql b/db/update.sql
index 407a8539..29b4a7dc 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -1,3 +1,6 @@
+/* angeltype view */
+INSERT INTO `engelsystem`.`Privileges` (`id`, `name`, `desc`) VALUES (NULL , 'angeltypes', 'View angeltypes');
+
 /* force active */
 ALTER TABLE `User` ADD `force_active` BOOLEAN NOT NULL AFTER `Aktiv`, ADD INDEX ( `force_active` );
 
-- 
cgit v1.2.3-70-g09d2