From 382afd1be086aa9f9a52e2be30164f7a4b3e8f40 Mon Sep 17 00:00:00 2001 From: Janis Streib Date: Fri, 16 Jan 2015 14:12:31 +0100 Subject: [PATCH] ADD: AdminLog table --- doc/tableStructure.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) 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 -- 2.39.2