Piwik\Updates\Updates_2_9_0_b7::addArchivingIdMigrationQueries PHP Method

addArchivingIdMigrationQueries() private method

    private function addArchivingIdMigrationQueries($sql)
    {
        $tables = ArchiveTableCreator::getTablesArchivesInstalled();
        foreach ($tables as $table) {
            $type = ArchiveTableCreator::getTypeFromTableName($table);
            if ($type === ArchiveTableCreator::NUMERIC_TABLE) {
                $maxId = Db::fetchOne('SELECT MAX(idarchive) FROM ' . $table);
                if (!empty($maxId)) {
                    $maxId = (int) $maxId + 500;
                } else {
                    $maxId = 1;
                }
                $sql[] = $this->migration->db->insert($this->sequenceTable, array('name' => $table, 'value' => $maxId));
            }
        }
        return $sql;
    }