/* ********************************************************************* MySQL - 5.1.41-community-log : Database - pbxconfig ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `conferences` */ DROP TABLE IF EXISTS `conferences`; CREATE TABLE `conferences` ( `confno` char(80) NOT NULL DEFAULT '0', `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `endtime` datetime NOT NULL DEFAULT '2099-12-31 23:59:59', `pin` char(20) DEFAULT NULL, `opts` char(100) DEFAULT NULL, `adminpin` char(20) DEFAULT NULL, `adminopts` char(100) DEFAULT NULL, `members` int(11) NOT NULL DEFAULT '0', `maxusers` int(11) NOT NULL DEFAULT '0', `conferencename` varchar(50) DEFAULT NULL, PRIMARY KEY (`confno`,`starttime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;