X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-online.php;h=b08ea40e9469bf5979cf174b9dc1c5dc1e12cdbb;hp=bb240f2a0e1fbf16ced3dc301044efcc14c18113;hb=82d53dfb7f59fa1e37bd500e3db3d10a9d4a78da;hpb=2ed1fa148954934a37ce31342c90cb2d90b80ecd diff --git a/inc/extensions/ext-online.php b/inc/extensions/ext-online.php index bb240f2a0e..b08ea40e94 100644 --- a/inc/extensions/ext-online.php +++ b/inc/extensions/ext-online.php @@ -53,11 +53,11 @@ case "register": // Do stuff when installtion is running (modules.php?module=adm // SQL commands to run $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_online"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_online ( -id BIGINT(20) NOT NULL AUTO_INCREMENT, +id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, sid VARCHAR(32) NOT NULL DEFAULT '', ip VARCHAR(15) NOT NULL DEFAULT '', -userid BIGINT(20) NOT NULL DEFAULT '0', -refid BIGINT(20) NOT NULL DEFAULT '0', +userid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +refid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', module VARCHAR(255) NOT NULL DEFAULT '', action VARCHAR(255) NOT NULL DEFAULT '', what VARCHAR(255) NOT NULL DEFAULT '',