rewritten angeltypes and user angeltypes

2 files changed, 3 insertions, 18 deletions

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` );