ADD: AdminLog table

diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql
index 5c79a162f7c7fe993f2a391e7acc656e6fa04ca0..7ff5a6159f1c3a1b39987a351bba87857a593552 100644 (file)
--- 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