CREATE TABLE IF NOT EXISTS `#__mmap` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

`category` INT(11)  NOT NULL ,
`title` VARCHAR(255)  NOT NULL ,
`visit` VARCHAR(255)  NOT NULL ,
`select` TEXT NOT NULL ,
`from` TEXT NOT NULL ,
`where` TEXT NOT NULL ,
`group` TEXT NOT NULL ,
`ordering` INT(11)  NOT NULL ,
`state` TINYINT(1)  NOT NULL ,
`checked_out` INT(11)  NOT NULL ,
`checked_out_time` DATETIME NOT NULL ,
`created_by` INT(11)  NOT NULL ,
`modified_by` INT(11)  NOT NULL ,
PRIMARY KEY (`id`)
) DEFAULT COLLATE=utf8mb4_unicode_ci;

