В модуле есть стандартная функция добавления таблицы для нужд модуля где перечислены все поля с параметрами:
Код: Выделить всё
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data) {
/*
mpt -
*/
$data = <<<EOD
mpt: ID int(10) unsigned NOT NULL auto_increment
mpt: ID_TERMINAL varchar(255) NOT NULL DEFAULT ''
mpt: SETTINGS_ALARMKWACTIVATED BOOLEAN NOT NULL DEFAULT TRUE
mpt: SETTINGS_ALARMTTS BOOLEAN NOT NULL DEFAULT TRUE
mpt: SETTINGS_ALARMSTT BOOLEAN NOT NULL DEFAULT TRUE
mpt: SETTINGS_ASK_ME_AGAIN TINYINT NOT NULL DEFAULT 0
mpt: SETTINGS_QUIET BOOLEAN NOT NULL DEFAULT FALSE
mpt: SETTINGS_NO_HELLO BOOLEAN NOT NULL DEFAULT FALSE
mpt: SETTINGS_PHRASE_TIME_LIMIT TINYINT NOT NULL DEFAULT 15
mpt: SETTINGS_CHROME_MODE TINYINT NOT NULL DEFAULT 2
mpt: SETTINGS_CHROME_CHOKE BOOLEAN NOT NULL DEFAULT FALSE
mpt: SETTINGS_CHROME_ALARMSTT BOOLEAN NOT NULL DEFAULT FALSE
mpt: SNOWBOY_TOKEN varchar(100) NOT NULL DEFAULT 'd4977cf8ff6ede6efb8d2277c1608c7dbebf18a7'
mpt: SETTINGS_SENSITIVITY varchar(3) NOT NULL DEFAULT '0.7'
mpt: SETTINGS_PROVIDERTTS varchar(20) NOT NULL DEFAULT 'google'
mpt: SETTINGS_PROVIDERSTT varchar(20) NOT NULL DEFAULT 'google'
mpt: MAJORDOMO_HEARTBEAT_TIMEOUT INT(4) NOT NULL DEFAULT '0'
mpt: MPD_CONTROL BOOLEAN NOT NULL DEFAULT TRUE
mpt: MPD_IP varchar(15) NOT NULL DEFAULT '127.0.0.1'
mpt: MPD_PORT varchar(5) NOT NULL DEFAULT '6600'
mpt: MPD_PAUSE BOOLEAN NOT NULL DEFAULT TRUE
mpt: MPD_SMOOTHLY BOOLEAN NOT NULL DEFAULT FALSE
mpt: MPD_QUIETER TINYINT NOT NULL DEFAULT 0
mpt: MPD_WAIT_RESUME TINYINT NOT NULL DEFAULT 5
mpt: YANDEX_APIKEYTTS varchar(100) NOT NULL DEFAULT ''
mpt: YANDEX_APIKEYSTT varchar(100) NOT NULL DEFAULT ''
mpt: YANDEX_EMOTION varchar(15) NOT NULL DEFAULT 'good'
mpt: YANDEX_SPEAKER varchar(15) NOT NULL DEFAULT 'alyss'
mpt: AWS_SPEAKER varchar(15) NOT NULL DEFAULT 'Tatyana'
mpt: AWS_ACCESS_KEY_ID varchar(100) NOT NULL DEFAULT ''
mpt: AWS_SECRET_ACCESS_KEY varchar(100) NOT NULL DEFAULT ''
mpt: AWS_REGION varchar(15) NOT NULL DEFAULT 'eu-central-1'
mpt: AWS_BOTO3 BOOLEAN NOT NULL DEFAULT FALSE
mpt: RHVOICE-REST_SERVER varchar(100) NOT NULL DEFAULT 'http://127.0.0.1:8080'
mpt: RHVOICE-REST_SPEAKER varchar(15) NOT NULL DEFAULT 'anna'
mpt: RHVOICE-REST_RATE TINYINT NOT NULL DEFAULT 50
mpt: RHVOICE-REST_PITCH TINYINT NOT NULL DEFAULT 50
mpt: RHVOICE-REST_VOLUME TINYINT NOT NULL DEFAULT 50
mpt: RHVOICE_SPEAKER varchar(15) NOT NULL DEFAULT 'anna'
mpt: POCKETSPHINX-REST_SERVER varchar(100) NOT NULL DEFAULT 'http://127.0.0.1:8085'
mpt: CACHE_TTS_PRIORITY varchar(20) NOT NULL DEFAULT 'google'
mpt: PROXY_ENABLE BOOLEAN NOT NULL DEFAULT FALSE
mpt: PROXY_MONKEY_PATCHING BOOLEAN NOT NULL DEFAULT TRUE
mpt: PROXY_PROXY varchar(100) NOT NULL DEFAULT 'socks5h://127.0.0.1:9050'
mpt: UPDATE_INTERVAL TINYINT NOT NULL DEFAULT 0
mpt: UPDATE_TURNOFF TINYINT NOT NULL DEFAULT -1
mpt: UPDATE_FALLBACK BOOLEAN NOT NULL DEFAULT TRUE
mpt: VOLUME_LINE_OUT varchar(20) NOT NULL DEFAULT 'Line Out'
mpt: CACHE_TTS_SIZE INT(3) NOT NULL DEFAULT '100'
mpt: UPDATE_PIP BOOLEAN NOT NULL DEFAULT TRUE
mpt: UPDATE_APT BOOLEAN NOT NULL DEFAULT FALSE
mpt: MAJORDOMO_OBJECT_METHOD varchar(100) NOT NULL DEFAULT ''
EOD;
parent::dbInstall($data);
}
Код: Выделить всё
-- --------------------------------------------------------
--
-- Структура таблицы `mpt`
--
CREATE TABLE IF NOT EXISTS `mpt` (
`ID` int(10) unsigned NOT NULL,
`ID_TERMINAL` int(10) NOT NULL DEFAULT '1',
`SETTINGS_ALARMKWACTIVATED` tinyint(1) NOT NULL DEFAULT '1',
`SETTINGS_ALARMTTS` tinyint(1) NOT NULL DEFAULT '1',
`SETTINGS_ALARMSTT` tinyint(1) NOT NULL DEFAULT '1',
`SETTINGS_ASK_ME_AGAIN` tinyint(4) NOT NULL DEFAULT '0',
`SETTINGS_QUIET` tinyint(1) NOT NULL DEFAULT '0',
`SETTINGS_NO_HELLO` tinyint(1) NOT NULL DEFAULT '0',
`SETTINGS_PHRASE_TIME_LIMIT` tinyint(4) NOT NULL DEFAULT '15',
`SETTINGS_CHROME_MODE` tinyint(4) NOT NULL DEFAULT '2',
`SETTINGS_CHROME_CHOKE` tinyint(1) NOT NULL DEFAULT '0',
`SETTINGS_CHROME_ALARMSTT` tinyint(1) NOT NULL DEFAULT '0',
`SNOWBOY_TOKEN` varchar(100) NOT NULL DEFAULT 'd4977cf8ff6ede6efb8d2277c1608c7dbebf18a7',
`SETTINGS_SENSITIVITY` varchar(3) NOT NULL DEFAULT '0.7',
`SETTINGS_PROVIDERTTS` varchar(20) NOT NULL DEFAULT 'google',
`SETTINGS_PROVIDERSTT` varchar(20) NOT NULL DEFAULT 'google',
`MAJORDOMO_HEARTBEAT_TIMEOUT` int(4) NOT NULL DEFAULT '0',
`MPD_CONTROL` tinyint(1) NOT NULL DEFAULT '1',
`MPD_IP` varchar(15) NOT NULL DEFAULT '127.0.0.1',
`MPD_PORT` varchar(5) NOT NULL DEFAULT '6600',
`MPD_PAUSE` tinyint(1) NOT NULL DEFAULT '1',
`MPD_SMOOTHLY` tinyint(1) NOT NULL DEFAULT '0',
`MPD_QUIETER` tinyint(4) NOT NULL DEFAULT '0',
`MPD_WAIT_RESUME` tinyint(4) NOT NULL DEFAULT '5',
`YANDEX_APIKEYTTS` varchar(100) NOT NULL DEFAULT '',
`YANDEX_APIKEYSTT` varchar(100) NOT NULL DEFAULT '',
`YANDEX_EMOTION` varchar(15) NOT NULL DEFAULT 'good',
`YANDEX_SPEAKER` varchar(15) NOT NULL DEFAULT 'alyss',
`AWS_SPEAKER` varchar(15) NOT NULL DEFAULT 'Tatyana',
`AWS_ACCESS_KEY_ID` varchar(100) NOT NULL DEFAULT '',
`AWS_SECRET_ACCESS_KEY` varchar(100) NOT NULL DEFAULT '',
`AWS_REGION` varchar(15) NOT NULL DEFAULT 'eu-central-1',
`AWS_BOTO3` tinyint(1) NOT NULL DEFAULT '0',
`RHVOICE-REST_SPEAKER` varchar(15) NOT NULL DEFAULT 'anna',
`RHVOICE-REST_RATE` tinyint(4) NOT NULL DEFAULT '50',
`RHVOICE-REST_PITCH` tinyint(4) NOT NULL DEFAULT '50',
`RHVOICE-REST_VOLUME` tinyint(4) NOT NULL DEFAULT '50',
`RHVOICE_SPEAKER` varchar(15) NOT NULL DEFAULT 'anna',
`CACHE_TTS_PRIORITY` varchar(20) NOT NULL DEFAULT 'google',
`PROXY_ENABLE` tinyint(1) NOT NULL DEFAULT '0',
`PROXY_MONKEY_PATCHING` tinyint(1) NOT NULL DEFAULT '1',
`UPDATE_INTERVAL` tinyint(4) NOT NULL DEFAULT '0',
`UPDATE_TURNOFF` tinyint(4) NOT NULL DEFAULT '-1',
`UPDATE_FALLBACK` tinyint(1) NOT NULL DEFAULT '1',
`VOLUME_LINE_OUT` varchar(20) NOT NULL DEFAULT 'Line Out',
`CACHE_TTS_SIZE` int(3) NOT NULL DEFAULT '100',
`UPDATE_PIP` tinyint(1) NOT NULL DEFAULT '1',
`UPDATE_APT` tinyint(1) NOT NULL DEFAULT '0',
`MAJORDOMO_OBJECT_METHOD` varchar(100) NOT NULL DEFAULT ''
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;