diff options
| author | Simon Rettberg | 2021-12-01 17:23:18 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2022-03-09 15:06:54 +0100 |
| commit | bc4734d9be292070bb50bc89603ad479fb71bf59 (patch) | |
| tree | da5d25d9dbed7875179c57fff55bc4e18004f63d /modules-available/eventlog/install.inc.php | |
| parent | [locations] Modularize additional column handling (diff) | |
| download | slx-admin-bc4734d9be292070bb50bc89603ad479fb71bf59.tar.gz slx-admin-bc4734d9be292070bb50bc89603ad479fb71bf59.tar.xz slx-admin-bc4734d9be292070bb50bc89603ad479fb71bf59.zip | |
[eventlog] install: Fix SQL
Diffstat (limited to 'modules-available/eventlog/install.inc.php')
| -rw-r--r-- | modules-available/eventlog/install.inc.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/modules-available/eventlog/install.inc.php b/modules-available/eventlog/install.inc.php index 3d252138..f6057d23 100644 --- a/modules-available/eventlog/install.inc.php +++ b/modules-available/eventlog/install.inc.php @@ -17,7 +17,7 @@ $res[] = tableCreate('notification_rule', ' `ruleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `description` text, - `type` varchar(40) NOT NULL CHARACTER SET ascii, + `type` varchar(40) CHARACTER SET ascii NOT NULL, `datafilter` blob NOT NULL, `subject` varchar(200) NOT NULL, `message` text NOT NULL, @@ -44,7 +44,7 @@ $res[] = tableCreate('notification_rule_x_transport', ' $res[] = tableCreate('notification_sample', ' `type` varchar(40) CHARACTER SET ascii NOT NULL, `dateline` int(10) UNSIGNED NOT NULL, - `data` blob, + `data` mediumblob, KEY (`type`, `dateline`) '); |