From: Janis Streib <janis@dogcraft.de>
Date: Fri, 16 Jan 2015 13:12:31 +0000 (+0100)
Subject: ADD: AdminLog table
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=382afd1be086aa9f9a52e2be30164f7a4b3e8f40

ADD: AdminLog table
---

diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql
index 5c79a162..7ff5a615 100644
--- a/doc/tableStructure.sql
+++ b/doc/tableStructure.sql
@@ -321,3 +321,13 @@ CREATE TABLE IF NOT EXISTS `org_admin` (
   `deleted` timestamp NULL DEFAULT NULL,
   KEY (`orgid`, `memid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `adminLog`;
+CREATE TABLE `adminLog` (
+  `when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `uid` int(11) unsigned NOT NULL,
+  `admin` int(11) unsigned NOT NULL,
+  `type` varchar(100) NOT NULL DEFAULT '',
+  `information` varchar(50) NOT NULL DEFAULT '',
+  PRIMARY KEY (`when`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\ No newline at end of file