CREATE TABLE RecordingsDataType
(
    id BIGINT UNSIGNED DEFAULT NULL AUTO_INCREMENT,
   Node BIGINT UNSIGNED NOT NULL,
    RecordDate BIGINT UNSIGNED NOT NULL,
    EndRecording BIGINT UNSIGNED NOT NULL,
    CallerName VARCHAR(15) DEFAULT NULL,
    CallerNumber VARCHAR(30) DEFAULT NULL,
    RecordFile BLOB DEFAULT NULL,
    IsInbound TINYINT UNSIGNED DEFAULT 0,
    LastAccess BIGINT UNSIGNED NOT NULL,
    IsArchived TINYINT UNSIGNED DEFAULT 0,
    IsRequested TINYINT UNSIGNED DEFAULT 0,
    Length INT UNSIGNED NOT NULL,
    FromNode BIGINT UNSIGNED DEFAULT NULL,
    size BIGINT UNSIGNED DEFAULT NULL,
    Zone BIGINT UNSIGNED DEFAULT NULL,
    Extension VARCHAR(7) DEFAULT NULL,
    PRIMARY KEY ( id ) ,
    KEY Node ( Node,RecordDate )

) ENGINE=INNODB CHARSET=UTF8;
