execute($sql); $sql = "ALTER TABLE `person` ADD PRIMARY KEY (`id`),ADD UNIQUE KEY `url` (`alias`); ALTER TABLE `person` ADD FULLTEXT KEY `search` (`name`); COMMIT;"; $this->execute($sql); $sql = "ALTER TABLE `person` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0; COMMIT; COMMIT;"; $this->execute($sql); } /** * {@inheritdoc} */ public function safeDown() { echo "m230314_094410_person cannot be reverted.\n"; return false; } /* // Use up()/down() to run migration code without a transaction. public function up() { } public function down() { echo "m230314_094410_person cannot be reverted.\n"; return false; } */ }