Pimcore\Model\Object\Classificationstore\Dao::createUpdateTable PHP Method

createUpdateTable() public method

public createUpdateTable ( )
    public function createUpdateTable()
    {
        $groupsTable = $this->getGroupsTableName();
        $dataTable = $this->getDataTableName();
        $this->db->query("CREATE TABLE IF NOT EXISTS `" . $groupsTable . "` (\n            `o_id` BIGINT(20) NOT NULL,\n            `groupId` BIGINT(20) NOT NULL,\n            `fieldname` VARCHAR(70) NOT NULL,\n            PRIMARY KEY (`groupId`, `o_id`, `fieldname`),\n            INDEX `o_id` (`o_id`),\n            INDEX `fieldname` (`fieldname`)\n        ) DEFAULT CHARSET=utf8mb4;");
        $this->db->query("CREATE TABLE IF NOT EXISTS `" . $dataTable . "` (\n            `o_id` BIGINT(20) NOT NULL,\n            `collectionId` BIGINT(20) NULL,\n            `groupId` BIGINT(20) NOT NULL,\n            `keyId` BIGINT(20) NOT NULL,\n            `value` LONGTEXT NULL,\n\t        `value2` LONGTEXT NULL,\n            `fieldname` VARCHAR(70) NOT NULL,\n            `language` VARCHAR(10) NOT NULL,\n            `type` VARCHAR(50) NULL,\n            PRIMARY KEY (`groupId`, `keyId`, `o_id`, `fieldname`, `language`),\n            INDEX `o_id` (`o_id`),\n            INDEX `groupId` (`groupId`),\n            INDEX `keyId` (`keyId`),\n            INDEX `fieldname` (`fieldname`),\n            INDEX `language` (`language`)\n        ) DEFAULT CHARSET=utf8mb4;");
        $this->tableDefinitions = null;
    }