CREATE TABLE `%%%TABLE_NAME%%%` (
  `rule_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `block` varchar(8) NOT NULL DEFAULT 'block',
  `target` text,
  `action` text,
  `ip` text,
  `id` text,
  `user_id` text COMMENT 'number',
  `target_id` text COMMENT 'number',
  `target_key` text,
  `detail` text,
  `rule_start` datetime DEFAULT NULL,
  `rule_end` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`rule_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8