root/freepbx/trunk/upgrades/2.2.0beta1/freepbx_log.sql

Revision 2657, 315 bytes (checked in by gregmac, 6 years ago)

Added EXISTS check for freepbx_log

Line 
1 CREATE TABLE IF NOT EXISTS `freepbx_log` (
2 `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
3 `time` DATETIME NOT NULL ,
4 `section` VARCHAR( 50 ) NULL ,
5 `level` ENUM( 'error', 'warning', 'debug', 'devel-debug' ) NOT NULL ,
6 `status` INT NOT NULL,
7 `message` TEXT NOT NULL ,
8 INDEX ( `time` , `level` )
9 ) ENGINE = MYISAM ;
Note: See TracBrowser for help on using the browser.