Skip to content

Instantly share code, notes, and snippets.

@ca4ti

ca4ti/cel.sql

Forked from wanghy6503/cel.sql
Created July 30, 2023 10:10
Show Gist options
  • Save ca4ti/b8d144d63379435250bac085d74e55b9 to your computer and use it in GitHub Desktop.
Save ca4ti/b8d144d63379435250bac085d74e55b9 to your computer and use it in GitHub Desktop.
Download ZIP
asterisk cel logging schema
Raw
cel.sql
CREATE TABLE `cel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`eventtype` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
`eventtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`userdeftype` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
`cid_name` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`cid_num` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`cid_ani` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`cid_rdnis` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`cid_dnid` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`exten` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`context` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`channame` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`appname` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`appdata` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
`amaflags` INT(11) NOT NULL,
`accountcode` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`peeraccount` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
`uniqueid` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
`linkedid` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
`userfield` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
`peer` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=INNODB;
@ca4ti
Copy link
Author

ca4ti commented Jul 30, 2023

CREATE TABLE cel (
id int(11) NOT NULL AUTO_INCREMENT,
eventtype varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
eventtime datetime NOT NULL,
cid_name varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
cid_num varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
cid_ani varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
cid_rdnis varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
cid_dnid varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
exten varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
context varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
channame varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
appname varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
appdata varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
amaflags int(11) NOT NULL,
accountcode varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
uniqueid varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
linkedid varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
peer varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
userdeftype varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
extra varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id),
KEY uniqueid_index (uniqueid),
KEY linkedid_index (linkedid),
KEY context_index (context)
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment