Pimcore\Model\Object\Fieldcollection\Definition\Dao::createUpdateTable PHP Метод

createUpdateTable() публичный Метод

public createUpdateTable ( ClassDefinition $class )
$class Pimcore\Model\Object\ClassDefinition
    public function createUpdateTable(Object\ClassDefinition $class)
    {
        $table = $this->getTableName($class);
        $this->db->query("CREATE TABLE IF NOT EXISTS `" . $table . "` (\n\t\t  `o_id` int(11) NOT NULL default '0',\n\t\t  `index` int(11) default '0',\n          `fieldname` varchar(190) default '',\n          PRIMARY KEY (`o_id`,`index`,`fieldname`(190)),\n          INDEX `o_id` (`o_id`),\n          INDEX `index` (`index`),\n          INDEX `fieldname` (`fieldname`)\n\t\t) DEFAULT CHARSET=utf8mb4;");
        $existingColumns = $this->getValidTableColumns($table, false);
        // no caching of table definition
        $columnsToRemove = $existingColumns;
        $protectedColums = ["o_id", "index", "fieldname"];
        Object\ClassDefinition\Service::updateTableDefinitions($this->tableDefinitions, [$table]);
        foreach ($this->model->getFieldDefinitions() as $value) {
            $key = $value->getName();
            if (is_array($value->getColumnType())) {
                // if a datafield requires more than one field
                foreach ($value->getColumnType() as $fkey => $fvalue) {
                    $this->addModifyColumn($table, $key . "__" . $fkey, $fvalue, "", "NULL");
                    $protectedColums[] = $key . "__" . $fkey;
                }
            } else {
                if ($value->getColumnType()) {
                    $this->addModifyColumn($table, $key, $value->getColumnType(), "", "NULL");
                    $protectedColums[] = $key;
                }
            }
            $this->addIndexToField($value, $table);
            if ($value instanceof Object\ClassDefinition\Data\Localizedfields) {
                $value->classSaved($class, ["context" => ["containerType" => "fieldcollection", "containerKey" => $this->model->getKey()]]);
            }
        }
        $this->removeUnusedColumns($table, $columnsToRemove, $protectedColums);
        $this->tableDefinitions = null;
    }