CREATE TABLE IF NOT EXISTS `#__rsfirewall_exceptions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(4) NOT NULL, `regex` tinyint(1) NOT NULL, `match` text NOT NULL, `php` tinyint(1) NOT NULL, `sql` tinyint(1) NOT NULL, `js` tinyint(1) NOT NULL, `uploads` tinyint(1) NOT NULL, `reason` text NULL, `date` datetime NOT NULL, `published` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8;