summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/install.sql18
-rw-r--r--db/update.sql3
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` );