final class Version20241205211145_Userreferer extends AbstractMigration
11
{
12
public function getDescription(): string
13
{
14
return 'Add User Referer';
15
}
16
17
public function up(Schema $schema): void
18
{
19
$this->addSql('CREATE TABLE stu_user_referer (id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, referer TEXT NOT NULL, user_id INT NOT NULL, PRIMARY KEY(id))');
20
$this->addSql('CREATE UNIQUE INDEX UNIQ_A00722FDA76ED395 ON stu_user_referer (user_id)');
21
$this->addSql('ALTER TABLE stu_user_referer ADD CONSTRAINT FK_A00722FDA76ED395 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_user_referer DROP CONSTRAINT FK_A00722FDA76ED395');
st-universe /
core
