CREATE TABLE IF NOT EXISTS `sys_weblog` (
`Guid` CHAR(255) NOT NULL DEFAULT '',
`Package` VARCHAR(255) DEFAULT '',
`Module` VARCHAR(255) DEFAULT 'ObjWeblog',
`Page` CHAR(255) NOT NULL DEFAULT '',
`Site` CHAR(255) NOT NULL DEFAULT '',
`User` CHAR(255) DEFAULT NULL,
`Parameters` CHAR(255) DEFAULT NULL,
`Start` TIMESTAMP(6) NOT NULL
DEFAULT CURRENT_TIMESTAMP(6),
`End` TIMESTAMP(6) NOT NULL
DEFAULT CURRENT_TIMESTAMP(6),
`Time` DATETIME(2) DEFAULT NULL
ON UPDATE CURRENT_TIMESTAMP(2),
`Hits` INT DEFAULT 1,
`Level` INT DEFAULT 0,
`RemoteIp` CHAR(50) DEFAULT NULL,
`UserAgent` CHAR(255) DEFAULT '',
`Browser` CHAR(255) DEFAULT '',
`Platform` CHAR(255) DEFAULT '',
`Referer` CHAR(255) DEFAULT '',
`Isp` CHAR(255) DEFAULT NULL,
`Lookup` CHAR(1) DEFAULT 'N',
`Payload` MEDIUMTEXT DEFAULT NULL,
PRIMARY KEY (`Guid`),
KEY `idx_user` (`User`),
KEY `idx_page` (`Page`),
KEY `idx_time` (`Time`),
KEY `idx_params` (`Parameters`),
KEY `idx_start` (`Start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE={collation}
CREATE TABLE IF NOT EXISTS `sys_weblog_daily` (
`Page` CHAR(255) NOT NULL DEFAULT '',
`Package` VARCHAR(255) DEFAULT '',
`Module` VARCHAR(255) DEFAULT 'ObjWeblog',
`Site` CHAR(255) NOT NULL DEFAULT '',
`Day` DATE NOT NULL,
`Parameters` CHAR(255) DEFAULT NULL,
`Hits` INT DEFAULT 0,
`RemoteIp` CHAR(50) DEFAULT NULL,
`UserAgent` CHAR(255) DEFAULT '',
PRIMARY KEY (`Page`, `Site`, `Day`),
KEY `idx_day` (`Day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE={collation}