Files
edu/bbs/_tmp/_migrate_learning_pk_content.php

10 lines
231 B
PHP

<?php
declare(strict_types=1);
require __DIR__ . '/../db_conn.php';
$pdo = db_conn();
$pdo->exec('ALTER TABLE edu_learning_histories DROP PRIMARY KEY, ADD PRIMARY KEY (member_id, sys_comp_code, content_id)');
echo "ALTER_OK\n";