private function InstapageCmsPluginDBModel::initDebugTable in Instapage plugin 7.3
Same name and namespace in other branches
- 8.3 core/models/InstapageCmsPluginDBModel.php \InstapageCmsPluginDBModel::initDebugTable()
Initiates Instapage plugin's DB structure for debug table.
1 call to InstapageCmsPluginDBModel::initDebugTable()
- InstapageCmsPluginDBModel::initPluginTables in core/
models/ InstapageCmsPluginDBModel.php - Initiates Instapage plugin's DB structure.
File
- core/
models/ InstapageCmsPluginDBModel.php, line 183
Class
- InstapageCmsPluginDBModel
- Class responsible for communication with DB.
Code
private function initDebugTable() {
$sql = sprintf('SHOW TABLES LIKE \'%s\'', $this->debugTable);
$result = $this
->getRow($sql);
if ($result) {
return true;
}
$sql = sprintf('CREATE TABLE IF NOT EXISTS %s(' . 'id MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, ' . 'time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ' . 'text TEXT NULL, ' . 'caller VARCHAR(255) DEFAULT \'\' NOT NULL, ' . 'name VARCHAR(255) DEFAULT \'\' NOT NULL, ' . 'UNIQUE KEY id (id)) %s', $this->debugTable, $this->charsetCollate);
$this
->query($sql);
}