Skip to content

Instantly share code, notes, and snippets.

@debojitkakoti
Created June 30, 2015 06:45
Show Gist options
  • Save debojitkakoti/91eea7177d16a73b5111 to your computer and use it in GitHub Desktop.
Save debojitkakoti/91eea7177d16a73b5111 to your computer and use it in GitHub Desktop.
asterisk meetme table for real time conference setup
CREATE TABLE `meetmes` (
`bookid` INT(11) NOT NULL AUTO_INCREMENT,
`created` DATETIME NOT NULL,
`confno` INT(10) NULL DEFAULT NULL,
`pin` INT(10) NULL DEFAULT NULL,
`adminpin` CHAR(20) NULL DEFAULT NULL,
`opts` CHAR(20) NULL DEFAULT NULL,
`adminopts` CHAR(20) NULL DEFAULT NULL,
`maxusers` INT(11) NOT NULL DEFAULT '10',
`members` INT(11) NULL DEFAULT NULL,
`status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0=free,1=alloted',
`account_type` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1=temporary2=Permanent account',
PRIMARY KEY (`bookid`),
UNIQUE INDEX `confno` (`confno`),
UNIQUE INDEX `pin` (`pin`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
AUTO_INCREMENT=73;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment