|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace SWP\Migrations; |
|
4
|
|
|
|
|
5
|
|
|
use Doctrine\DBAL\Migrations\AbstractMigration; |
|
6
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
7
|
|
|
|
|
8
|
|
|
/** |
|
9
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
10
|
|
|
*/ |
|
11
|
|
|
class Version20171215124825 extends AbstractMigration |
|
|
|
|
|
|
12
|
|
|
{ |
|
13
|
|
|
/** |
|
14
|
|
|
* @param Schema $schema |
|
15
|
|
|
*/ |
|
16
|
|
|
public function up(Schema $schema) |
|
17
|
|
|
{ |
|
18
|
|
|
// this up() migration is auto-generated, please modify it to your needs |
|
19
|
|
|
$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.'); |
|
20
|
|
|
|
|
21
|
|
|
$this->addSql('CREATE SEQUENCE swp_article_events_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
22
|
|
|
$this->addSql('CREATE SEQUENCE swp_article_statistics_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
23
|
|
|
$this->addSql('CREATE TABLE swp_article_events (id INT NOT NULL, article_statistics_id INT NOT NULL, action VARCHAR(255) DEFAULT NULL, value VARCHAR(255) DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
24
|
|
|
$this->addSql('CREATE INDEX IDX_ED5F19E41DFE7A17 ON swp_article_events (article_statistics_id)'); |
|
25
|
|
|
$this->addSql('CREATE TABLE swp_article_statistics (id INT NOT NULL, article_id INT NOT NULL, impressions_number INT DEFAULT NULL, page_views_number INT DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
26
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_505B94427294869C ON swp_article_statistics (article_id)'); |
|
27
|
|
|
$this->addSql('ALTER TABLE swp_article_events ADD CONSTRAINT FK_ED5F19E41DFE7A17 FOREIGN KEY (article_statistics_id) REFERENCES swp_article_statistics (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
28
|
|
|
$this->addSql('ALTER TABLE swp_article_statistics ADD CONSTRAINT FK_505B94427294869C FOREIGN KEY (article_id) REFERENCES swp_article (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
29
|
|
|
} |
|
30
|
|
|
|
|
31
|
|
|
/** |
|
32
|
|
|
* @param Schema $schema |
|
33
|
|
|
*/ |
|
34
|
|
|
public function down(Schema $schema) |
|
35
|
|
|
{ |
|
36
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
37
|
|
|
$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.'); |
|
38
|
|
|
|
|
39
|
|
|
$this->addSql('ALTER TABLE swp_article_events DROP CONSTRAINT FK_ED5F19E41DFE7A17'); |
|
40
|
|
|
$this->addSql('DROP SEQUENCE swp_article_events_id_seq CASCADE'); |
|
41
|
|
|
$this->addSql('DROP SEQUENCE swp_article_statistics_id_seq CASCADE'); |
|
42
|
|
|
$this->addSql('DROP TABLE swp_article_events'); |
|
43
|
|
|
$this->addSql('DROP TABLE swp_article_statistics'); |
|
44
|
|
|
} |
|
45
|
|
|
} |
|
46
|
|
|
|
ahilles107 /
web-publisher
This class, trait or interface has been deprecated. The supplier of the file has supplied an explanatory message.
The explanatory message should give you some clue as to whether and when the type will be removed from the class and what other constant to use instead.