final class Version20240802113703_EntityLock extends AbstractMigration
11
{
12
public function getDescription(): string
13
{
14
return 'Introduce new entity EntityLock';
15
}
16
17
public function up(Schema $schema): void
18
{
19
$this->addSql('CREATE TABLE stu_entity_lock (entity_id INT NOT NULL, type VARCHAR(20) NOT NULL, request_id VARCHAR(50) DEFAULT NULL, created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, user_id INT DEFAULT NULL, PRIMARY KEY(entity_id, type))');
20
$this->addSql('CREATE INDEX IDX_7EC1164FA76ED395 ON stu_entity_lock (user_id)');
21
$this->addSql('ALTER TABLE stu_entity_lock ADD CONSTRAINT FK_7EC1164FA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
22
}
23
24
public function down(Schema $schema): void
25
{
26
$this->addSql('ALTER TABLE stu_entity_lock DROP CONSTRAINT FK_7EC1164FA76ED395');
st-universe /
core
