|
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 Version20170126101230 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 ext_log_entries_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
22
|
|
|
$this->addSql('CREATE SEQUENCE request_metrics_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
23
|
|
|
$this->addSql('CREATE SEQUENCE swp_item_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
24
|
|
|
$this->addSql('CREATE SEQUENCE swp_package_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
25
|
|
|
$this->addSql('CREATE SEQUENCE swp_api_key_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
26
|
|
|
$this->addSql('CREATE SEQUENCE swp_content_list_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
27
|
|
|
$this->addSql('CREATE SEQUENCE swp_content_list_item_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
28
|
|
|
$this->addSql('CREATE SEQUENCE swp_fbia_application_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
29
|
|
|
$this->addSql('CREATE SEQUENCE swp_fbia_article_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
30
|
|
|
$this->addSql('CREATE SEQUENCE swp_fbia_feed_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
31
|
|
|
$this->addSql('CREATE SEQUENCE swp_fbia_page_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
32
|
|
|
$this->addSql('CREATE SEQUENCE swp_menu_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
33
|
|
|
$this->addSql('CREATE SEQUENCE swp_organization_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
34
|
|
|
$this->addSql('CREATE SEQUENCE swp_rule_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
35
|
|
|
$this->addSql('CREATE SEQUENCE swp_tenant_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
36
|
|
|
$this->addSql('CREATE SEQUENCE swp_user_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); |
|
37
|
|
|
$this->addSql('CREATE TABLE ext_log_entries (id INT NOT NULL, action VARCHAR(8) NOT NULL, logged_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, object_id VARCHAR(64) DEFAULT NULL, object_class VARCHAR(255) NOT NULL, version INT NOT NULL, data TEXT DEFAULT NULL, username VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))'); |
|
38
|
|
|
$this->addSql('CREATE INDEX log_class_lookup_idx ON ext_log_entries (object_class)'); |
|
39
|
|
|
$this->addSql('CREATE INDEX log_date_lookup_idx ON ext_log_entries (logged_at)'); |
|
40
|
|
|
$this->addSql('CREATE INDEX log_user_lookup_idx ON ext_log_entries (username)'); |
|
41
|
|
|
$this->addSql('CREATE INDEX log_version_lookup_idx ON ext_log_entries (object_id, object_class, version)'); |
|
42
|
|
|
$this->addSql('COMMENT ON COLUMN ext_log_entries.data IS \'(DC2Type:array)\''); |
|
43
|
|
|
$this->addSql('CREATE TABLE request_metrics (id INT NOT NULL, uri TEXT NOT NULL, route VARCHAR(255) NOT NULL, duration INT NOT NULL, created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))'); |
|
44
|
|
|
$this->addSql('CREATE TABLE swp_container_data (id SERIAL NOT NULL, container_id INT DEFAULT NULL, key VARCHAR(255) NOT NULL, value VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
45
|
|
|
$this->addSql('CREATE INDEX IDX_F117CAC2BC21F742 ON swp_container_data (container_id)'); |
|
46
|
|
|
$this->addSql('CREATE TABLE swp_container_widgets (id SERIAL NOT NULL, widget_id INT DEFAULT NULL, container_id INT DEFAULT NULL, position INT NOT NULL, PRIMARY KEY(id))'); |
|
47
|
|
|
$this->addSql('CREATE INDEX IDX_EC017811FBE885E2 ON swp_container_widgets (widget_id)'); |
|
48
|
|
|
$this->addSql('CREATE INDEX IDX_EC017811BC21F742 ON swp_container_widgets (container_id)'); |
|
49
|
|
|
$this->addSql('CREATE TABLE swp_item (id INT NOT NULL, package_id INT DEFAULT NULL, headline VARCHAR(255) NOT NULL, slugline VARCHAR(255) DEFAULT NULL, guid VARCHAR(255) NOT NULL, byline VARCHAR(255) NOT NULL, language VARCHAR(255) NOT NULL, description TEXT DEFAULT NULL, subjects TEXT NOT NULL, services TEXT DEFAULT NULL, keywords TEXT NOT NULL, places TEXT NOT NULL, type VARCHAR(255) NOT NULL, located VARCHAR(255) DEFAULT NULL, urgency INT NOT NULL, priority INT NOT NULL, version INT NOT NULL, body TEXT DEFAULT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
50
|
|
|
$this->addSql('CREATE INDEX IDX_E10C0866F44CABFF ON swp_item (package_id)'); |
|
51
|
|
|
$this->addSql('COMMENT ON COLUMN swp_item.subjects IS \'(DC2Type:array)\''); |
|
52
|
|
|
$this->addSql('COMMENT ON COLUMN swp_item.services IS \'(DC2Type:array)\''); |
|
53
|
|
|
$this->addSql('COMMENT ON COLUMN swp_item.keywords IS \'(DC2Type:array)\''); |
|
54
|
|
|
$this->addSql('COMMENT ON COLUMN swp_item.places IS \'(DC2Type:array)\''); |
|
55
|
|
|
$this->addSql('CREATE TABLE swp_package (id INT NOT NULL, headline VARCHAR(255) NOT NULL, slugline VARCHAR(255) NOT NULL, guid VARCHAR(255) NOT NULL, byline VARCHAR(255) NOT NULL, language VARCHAR(255) NOT NULL, description TEXT DEFAULT NULL, subjects TEXT NOT NULL, services TEXT DEFAULT NULL, keywords TEXT NOT NULL, places TEXT NOT NULL, type VARCHAR(255) NOT NULL, located VARCHAR(255) DEFAULT NULL, urgency INT NOT NULL, priority INT NOT NULL, version INT NOT NULL, enabled BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
56
|
|
|
$this->addSql('COMMENT ON COLUMN swp_package.subjects IS \'(DC2Type:array)\''); |
|
57
|
|
|
$this->addSql('COMMENT ON COLUMN swp_package.services IS \'(DC2Type:array)\''); |
|
58
|
|
|
$this->addSql('COMMENT ON COLUMN swp_package.keywords IS \'(DC2Type:array)\''); |
|
59
|
|
|
$this->addSql('COMMENT ON COLUMN swp_package.places IS \'(DC2Type:array)\''); |
|
60
|
|
|
$this->addSql('CREATE TABLE swp_file (id SERIAL NOT NULL, asset_id VARCHAR(255) NOT NULL, file_extension VARCHAR(255) NOT NULL, created_at DATE NOT NULL, updated_at DATE DEFAULT NULL, PRIMARY KEY(id))'); |
|
61
|
|
|
$this->addSql('CREATE TABLE swp_image_rendition (id SERIAL NOT NULL, image_id INT DEFAULT NULL, media_id INT DEFAULT NULL, width INT NOT NULL, height INT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
62
|
|
|
$this->addSql('CREATE INDEX IDX_932D0BFB3DA5256D ON swp_image_rendition (image_id)'); |
|
63
|
|
|
$this->addSql('CREATE INDEX IDX_932D0BFBEA9FDD75 ON swp_image_rendition (media_id)'); |
|
64
|
|
|
$this->addSql('CREATE TABLE swp_api_key (id INT NOT NULL, user_id INT DEFAULT NULL, api_key VARCHAR(255) NOT NULL, valid_to TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
65
|
|
|
$this->addSql('CREATE INDEX IDX_30090BA3A76ED395 ON swp_api_key (user_id)'); |
|
66
|
|
|
$this->addSql('CREATE TABLE swp_article (id SERIAL NOT NULL, route_id INT DEFAULT NULL, slug VARCHAR(255) NOT NULL, body TEXT NOT NULL, title VARCHAR(255) NOT NULL, keywords TEXT NOT NULL, lead TEXT DEFAULT NULL, template_name VARCHAR(255) DEFAULT NULL, locale VARCHAR(255) NOT NULL, status VARCHAR(255) NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, publish_start_date DATE DEFAULT NULL, publish_end_date DATE DEFAULT NULL, published_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, is_publishable BOOLEAN NOT NULL, metadata TEXT DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
67
|
|
|
$this->addSql('CREATE INDEX IDX_FB21E85834ECB4E6 ON swp_article (route_id)'); |
|
68
|
|
|
$this->addSql('CREATE UNIQUE INDEX swp_article_slug_idx ON swp_article (slug, tenant_code)'); |
|
69
|
|
|
$this->addSql('COMMENT ON COLUMN swp_article.keywords IS \'(DC2Type:array)\''); |
|
70
|
|
|
$this->addSql('CREATE TABLE swp_article_media (id SERIAL NOT NULL, article_id INT DEFAULT NULL, file_id INT DEFAULT NULL, image_id INT DEFAULT NULL, key VARCHAR(255) NOT NULL, body TEXT DEFAULT NULL, description TEXT DEFAULT NULL, located VARCHAR(255) DEFAULT NULL, by_line VARCHAR(255) DEFAULT NULL, mimetype VARCHAR(255) NOT NULL, usage_terms VARCHAR(255) DEFAULT NULL, created_at DATE NOT NULL, updated_at DATE DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
71
|
|
|
$this->addSql('CREATE INDEX IDX_B9721F7E7294869C ON swp_article_media (article_id)'); |
|
72
|
|
|
$this->addSql('CREATE INDEX IDX_B9721F7E93CB796C ON swp_article_media (file_id)'); |
|
73
|
|
|
$this->addSql('CREATE INDEX IDX_B9721F7E3DA5256D ON swp_article_media (image_id)'); |
|
74
|
|
|
$this->addSql('CREATE TABLE swp_container (id SERIAL NOT NULL, name VARCHAR(255) NOT NULL, type INT NOT NULL, width INT DEFAULT NULL, height INT DEFAULT NULL, styles TEXT DEFAULT NULL, css_class VARCHAR(255) DEFAULT NULL, visible BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT \'now\' NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
75
|
|
|
$this->addSql('CREATE UNIQUE INDEX swp_name_idx ON swp_container (name, tenant_code)'); |
|
76
|
|
|
$this->addSql('CREATE TABLE swp_content_list (id INT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(255) DEFAULT NULL, type VARCHAR(255) NOT NULL, cache_life_time INT DEFAULT NULL, list_limit INT DEFAULT NULL, filters TEXT NOT NULL, enabled BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
77
|
|
|
$this->addSql('COMMENT ON COLUMN swp_content_list.filters IS \'(DC2Type:array)\''); |
|
78
|
|
|
$this->addSql('CREATE TABLE swp_content_list_item (id INT NOT NULL, content_id INT NOT NULL, content_list_id INT NOT NULL, position INT NOT NULL, enabled BOOLEAN NOT NULL, sticky BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
79
|
|
|
$this->addSql('CREATE INDEX IDX_8513AA6984A0A3ED ON swp_content_list_item (content_id)'); |
|
80
|
|
|
$this->addSql('CREATE INDEX IDX_8513AA69E2A6CF38 ON swp_content_list_item (content_list_id)'); |
|
81
|
|
|
$this->addSql('CREATE TABLE swp_fbia_application (id INT NOT NULL, app_id VARCHAR(255) NOT NULL, app_secret VARCHAR(255) NOT NULL, enabled BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
82
|
|
|
$this->addSql('CREATE TABLE swp_fbia_article (id INT NOT NULL, article_id INT NOT NULL, feed_id INT NOT NULL, tenant_code VARCHAR(255) NOT NULL, submission_id VARCHAR(255) NOT NULL, status VARCHAR(255) NOT NULL, errors TEXT DEFAULT \'{}\' NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
83
|
|
|
$this->addSql('CREATE INDEX IDX_F9B0A4377294869C ON swp_fbia_article (article_id)'); |
|
84
|
|
|
$this->addSql('CREATE INDEX IDX_F9B0A43751A5BC03 ON swp_fbia_article (feed_id)'); |
|
85
|
|
|
$this->addSql('CREATE UNIQUE INDEX swp_fbia_article_idx ON swp_fbia_article (submission_id, feed_id)'); |
|
86
|
|
|
$this->addSql('CREATE TABLE swp_fbia_feed (id INT NOT NULL, facebook_page_id INT NOT NULL, content_list_id INT NOT NULL, tenant_code VARCHAR(255) NOT NULL, mode INT DEFAULT 0 NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
87
|
|
|
$this->addSql('CREATE INDEX IDX_36D3F8097A7D7F9F ON swp_fbia_feed (facebook_page_id)'); |
|
88
|
|
|
$this->addSql('CREATE INDEX IDX_36D3F809E2A6CF38 ON swp_fbia_feed (content_list_id)'); |
|
89
|
|
|
$this->addSql('CREATE UNIQUE INDEX swp_fbia_feed_idx ON swp_fbia_feed (content_list_id, facebook_page_id)'); |
|
90
|
|
|
$this->addSql('CREATE TABLE swp_fbia_page (id INT NOT NULL, application_id INT DEFAULT NULL, page_id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, access_token VARCHAR(255) DEFAULT NULL, enabled BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
91
|
|
|
$this->addSql('CREATE INDEX IDX_1990A823E030ACD ON swp_fbia_page (application_id)'); |
|
92
|
|
|
$this->addSql('CREATE TABLE swp_image (id SERIAL NOT NULL, asset_id VARCHAR(255) NOT NULL, file_extension VARCHAR(255) NOT NULL, width INT DEFAULT NULL, height INT DEFAULT NULL, created_at DATE NOT NULL, updated_at DATE DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
93
|
|
|
$this->addSql('CREATE TABLE swp_menu (id INT NOT NULL, root_id INT DEFAULT NULL, parent_id INT DEFAULT NULL, route_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, label VARCHAR(255) DEFAULT NULL, link_attributes TEXT NOT NULL, children_attributes TEXT NOT NULL, label_attributes TEXT NOT NULL, uri VARCHAR(255) DEFAULT NULL, attributes TEXT NOT NULL, extras TEXT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL, level INT NOT NULL, position INT NOT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
94
|
|
|
$this->addSql('CREATE INDEX IDX_831217EB79066886 ON swp_menu (root_id)'); |
|
95
|
|
|
$this->addSql('CREATE INDEX IDX_831217EB727ACA70 ON swp_menu (parent_id)'); |
|
96
|
|
|
$this->addSql('CREATE INDEX IDX_831217EB34ECB4E6 ON swp_menu (route_id)'); |
|
97
|
|
|
$this->addSql('COMMENT ON COLUMN swp_menu.link_attributes IS \'(DC2Type:array)\''); |
|
98
|
|
|
$this->addSql('COMMENT ON COLUMN swp_menu.children_attributes IS \'(DC2Type:array)\''); |
|
99
|
|
|
$this->addSql('COMMENT ON COLUMN swp_menu.label_attributes IS \'(DC2Type:array)\''); |
|
100
|
|
|
$this->addSql('COMMENT ON COLUMN swp_menu.attributes IS \'(DC2Type:array)\''); |
|
101
|
|
|
$this->addSql('COMMENT ON COLUMN swp_menu.extras IS \'(DC2Type:array)\''); |
|
102
|
|
|
$this->addSql('CREATE TABLE swp_organization (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, enabled BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
103
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_F9E66D1A77153098 ON swp_organization (code)'); |
|
104
|
|
|
$this->addSql('CREATE TABLE swp_route (id SERIAL NOT NULL, root_id INT DEFAULT NULL, parent_id INT DEFAULT NULL, route_content_id INT DEFAULT NULL, host VARCHAR(255) NOT NULL, schemes TEXT NOT NULL, methods TEXT NOT NULL, defaults TEXT NOT NULL, requirements TEXT NOT NULL, options TEXT NOT NULL, condition_expr VARCHAR(255) DEFAULT NULL, variable_pattern VARCHAR(255) DEFAULT NULL, staticPrefix VARCHAR(255) DEFAULT NULL, template_name VARCHAR(255) DEFAULT NULL, articles_template_name VARCHAR(255) DEFAULT NULL, type VARCHAR(255) NOT NULL, cache_time_in_seconds INT NOT NULL, name VARCHAR(255) NOT NULL, position INT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL, level INT NOT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
105
|
|
|
$this->addSql('CREATE INDEX IDX_5CE4CE5A79066886 ON swp_route (root_id)'); |
|
106
|
|
|
$this->addSql('CREATE INDEX IDX_5CE4CE5A727ACA70 ON swp_route (parent_id)'); |
|
107
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_5CE4CE5A8AD7690A ON swp_route (route_content_id)'); |
|
108
|
|
|
$this->addSql('CREATE INDEX prefix_idx ON swp_route (staticPrefix)'); |
|
109
|
|
|
$this->addSql('CREATE UNIQUE INDEX swp_route_name_idx ON swp_route (name, tenant_code)'); |
|
110
|
|
|
$this->addSql('COMMENT ON COLUMN swp_route.schemes IS \'(DC2Type:array)\''); |
|
111
|
|
|
$this->addSql('COMMENT ON COLUMN swp_route.methods IS \'(DC2Type:array)\''); |
|
112
|
|
|
$this->addSql('COMMENT ON COLUMN swp_route.defaults IS \'(DC2Type:array)\''); |
|
113
|
|
|
$this->addSql('COMMENT ON COLUMN swp_route.requirements IS \'(DC2Type:array)\''); |
|
114
|
|
|
$this->addSql('COMMENT ON COLUMN swp_route.options IS \'(DC2Type:array)\''); |
|
115
|
|
|
$this->addSql('CREATE TABLE swp_rule (id INT NOT NULL, expression VARCHAR(255) NOT NULL, priority INT NOT NULL, configuration TEXT NOT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
116
|
|
|
$this->addSql('COMMENT ON COLUMN swp_rule.configuration IS \'(DC2Type:array)\''); |
|
117
|
|
|
$this->addSql('CREATE TABLE swp_tenant (id INT NOT NULL, organization_id INT DEFAULT NULL, tenant_route_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, subdomain VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, enabled BOOLEAN NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, theme_name VARCHAR(255) DEFAULT NULL, domain_name VARCHAR(255) DEFAULT NULL, amp_enabled BOOLEAN NOT NULL, PRIMARY KEY(id))'); |
|
118
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_EC6095FE5E237E06 ON swp_tenant (name)'); |
|
119
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_EC6095FEC1D5962E ON swp_tenant (subdomain)'); |
|
120
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_EC6095FE77153098 ON swp_tenant (code)'); |
|
121
|
|
|
$this->addSql('CREATE INDEX IDX_EC6095FE32C8A3DE ON swp_tenant (organization_id)'); |
|
122
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_EC6095FE154AD611 ON swp_tenant (tenant_route_id)'); |
|
123
|
|
|
$this->addSql('CREATE TABLE swp_user (id INT NOT NULL, username VARCHAR(180) NOT NULL, username_canonical VARCHAR(180) NOT NULL, email VARCHAR(180) NOT NULL, email_canonical VARCHAR(180) NOT NULL, enabled BOOLEAN NOT NULL, salt VARCHAR(255) DEFAULT NULL, password VARCHAR(255) NOT NULL, last_login TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, confirmation_token VARCHAR(180) DEFAULT NULL, password_requested_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, roles TEXT NOT NULL, tenant_code VARCHAR(255) NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))'); |
|
124
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_7384FB3192FC23A8 ON swp_user (username_canonical)'); |
|
125
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_7384FB31A0D96FBF ON swp_user (email_canonical)'); |
|
126
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_7384FB31C05FB297 ON swp_user (confirmation_token)'); |
|
127
|
|
|
$this->addSql('COMMENT ON COLUMN swp_user.roles IS \'(DC2Type:array)\''); |
|
128
|
|
|
$this->addSql('CREATE TABLE swp_widget (id SERIAL NOT NULL, name VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, visible BOOLEAN NOT NULL, parameters TEXT NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT \'now\' NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, tenant_code VARCHAR(255) NOT NULL, PRIMARY KEY(id))'); |
|
129
|
|
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_27C04F4C5E237E06 ON swp_widget (name)'); |
|
130
|
|
|
$this->addSql('COMMENT ON COLUMN swp_widget.parameters IS \'(DC2Type:json_array)\''); |
|
131
|
|
|
$this->addSql('ALTER TABLE swp_container_data ADD CONSTRAINT FK_F117CAC2BC21F742 FOREIGN KEY (container_id) REFERENCES swp_container (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
132
|
|
|
$this->addSql('ALTER TABLE swp_container_widgets ADD CONSTRAINT FK_EC017811FBE885E2 FOREIGN KEY (widget_id) REFERENCES swp_widget (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
133
|
|
|
$this->addSql('ALTER TABLE swp_container_widgets ADD CONSTRAINT FK_EC017811BC21F742 FOREIGN KEY (container_id) REFERENCES swp_container (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
134
|
|
|
$this->addSql('ALTER TABLE swp_item ADD CONSTRAINT FK_E10C0866F44CABFF FOREIGN KEY (package_id) REFERENCES swp_package (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
135
|
|
|
$this->addSql('ALTER TABLE swp_image_rendition ADD CONSTRAINT FK_932D0BFB3DA5256D FOREIGN KEY (image_id) REFERENCES swp_image (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
136
|
|
|
$this->addSql('ALTER TABLE swp_image_rendition ADD CONSTRAINT FK_932D0BFBEA9FDD75 FOREIGN KEY (media_id) REFERENCES swp_article_media (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
137
|
|
|
$this->addSql('ALTER TABLE swp_api_key ADD CONSTRAINT FK_30090BA3A76ED395 FOREIGN KEY (user_id) REFERENCES swp_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
138
|
|
|
$this->addSql('ALTER TABLE swp_article ADD CONSTRAINT FK_FB21E85834ECB4E6 FOREIGN KEY (route_id) REFERENCES swp_route (id) ON DELETE SET NULL NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
139
|
|
|
$this->addSql('ALTER TABLE swp_article_media ADD CONSTRAINT FK_B9721F7E7294869C FOREIGN KEY (article_id) REFERENCES swp_article (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
140
|
|
|
$this->addSql('ALTER TABLE swp_article_media ADD CONSTRAINT FK_B9721F7E93CB796C FOREIGN KEY (file_id) REFERENCES swp_file (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
141
|
|
|
$this->addSql('ALTER TABLE swp_article_media ADD CONSTRAINT FK_B9721F7E3DA5256D FOREIGN KEY (image_id) REFERENCES swp_image (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
142
|
|
|
$this->addSql('ALTER TABLE swp_content_list_item ADD CONSTRAINT FK_8513AA6984A0A3ED FOREIGN KEY (content_id) REFERENCES swp_article (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
143
|
|
|
$this->addSql('ALTER TABLE swp_content_list_item ADD CONSTRAINT FK_8513AA69E2A6CF38 FOREIGN KEY (content_list_id) REFERENCES swp_content_list (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
144
|
|
|
$this->addSql('ALTER TABLE swp_fbia_article ADD CONSTRAINT FK_F9B0A4377294869C FOREIGN KEY (article_id) REFERENCES swp_article (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
145
|
|
|
$this->addSql('ALTER TABLE swp_fbia_article ADD CONSTRAINT FK_F9B0A43751A5BC03 FOREIGN KEY (feed_id) REFERENCES swp_fbia_feed (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
146
|
|
|
$this->addSql('ALTER TABLE swp_fbia_feed ADD CONSTRAINT FK_36D3F8097A7D7F9F FOREIGN KEY (facebook_page_id) REFERENCES swp_fbia_page (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
147
|
|
|
$this->addSql('ALTER TABLE swp_fbia_feed ADD CONSTRAINT FK_36D3F809E2A6CF38 FOREIGN KEY (content_list_id) REFERENCES swp_content_list (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
148
|
|
|
$this->addSql('ALTER TABLE swp_fbia_page ADD CONSTRAINT FK_1990A823E030ACD FOREIGN KEY (application_id) REFERENCES swp_fbia_application (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
149
|
|
|
$this->addSql('ALTER TABLE swp_menu ADD CONSTRAINT FK_831217EB79066886 FOREIGN KEY (root_id) REFERENCES swp_menu (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
150
|
|
|
$this->addSql('ALTER TABLE swp_menu ADD CONSTRAINT FK_831217EB727ACA70 FOREIGN KEY (parent_id) REFERENCES swp_menu (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
151
|
|
|
$this->addSql('ALTER TABLE swp_menu ADD CONSTRAINT FK_831217EB34ECB4E6 FOREIGN KEY (route_id) REFERENCES swp_route (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
152
|
|
|
$this->addSql('ALTER TABLE swp_route ADD CONSTRAINT FK_5CE4CE5A79066886 FOREIGN KEY (root_id) REFERENCES swp_route (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
153
|
|
|
$this->addSql('ALTER TABLE swp_route ADD CONSTRAINT FK_5CE4CE5A727ACA70 FOREIGN KEY (parent_id) REFERENCES swp_route (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
154
|
|
|
$this->addSql('ALTER TABLE swp_route ADD CONSTRAINT FK_5CE4CE5A8AD7690A FOREIGN KEY (route_content_id) REFERENCES swp_article (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
155
|
|
|
$this->addSql('ALTER TABLE swp_tenant ADD CONSTRAINT FK_EC6095FE32C8A3DE FOREIGN KEY (organization_id) REFERENCES swp_organization (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
156
|
|
|
$this->addSql('ALTER TABLE swp_tenant ADD CONSTRAINT FK_EC6095FE154AD611 FOREIGN KEY (tenant_route_id) REFERENCES swp_route (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); |
|
157
|
|
|
} |
|
158
|
|
|
|
|
159
|
|
|
/** |
|
160
|
|
|
* @param Schema $schema |
|
161
|
|
|
*/ |
|
162
|
|
|
public function down(Schema $schema) |
|
163
|
|
|
{ |
|
164
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
165
|
|
|
$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.'); |
|
166
|
|
|
|
|
167
|
|
|
$this->addSql('CREATE SCHEMA public'); |
|
168
|
|
|
$this->addSql('ALTER TABLE swp_item DROP CONSTRAINT FK_E10C0866F44CABFF'); |
|
169
|
|
|
$this->addSql('ALTER TABLE swp_article_media DROP CONSTRAINT FK_B9721F7E93CB796C'); |
|
170
|
|
|
$this->addSql('ALTER TABLE swp_article_media DROP CONSTRAINT FK_B9721F7E7294869C'); |
|
171
|
|
|
$this->addSql('ALTER TABLE swp_content_list_item DROP CONSTRAINT FK_8513AA6984A0A3ED'); |
|
172
|
|
|
$this->addSql('ALTER TABLE swp_fbia_article DROP CONSTRAINT FK_F9B0A4377294869C'); |
|
173
|
|
|
$this->addSql('ALTER TABLE swp_route DROP CONSTRAINT FK_5CE4CE5A8AD7690A'); |
|
174
|
|
|
$this->addSql('ALTER TABLE swp_image_rendition DROP CONSTRAINT FK_932D0BFBEA9FDD75'); |
|
175
|
|
|
$this->addSql('ALTER TABLE swp_container_data DROP CONSTRAINT FK_F117CAC2BC21F742'); |
|
176
|
|
|
$this->addSql('ALTER TABLE swp_container_widgets DROP CONSTRAINT FK_EC017811BC21F742'); |
|
177
|
|
|
$this->addSql('ALTER TABLE swp_content_list_item DROP CONSTRAINT FK_8513AA69E2A6CF38'); |
|
178
|
|
|
$this->addSql('ALTER TABLE swp_fbia_feed DROP CONSTRAINT FK_36D3F809E2A6CF38'); |
|
179
|
|
|
$this->addSql('ALTER TABLE swp_fbia_page DROP CONSTRAINT FK_1990A823E030ACD'); |
|
180
|
|
|
$this->addSql('ALTER TABLE swp_fbia_article DROP CONSTRAINT FK_F9B0A43751A5BC03'); |
|
181
|
|
|
$this->addSql('ALTER TABLE swp_fbia_feed DROP CONSTRAINT FK_36D3F8097A7D7F9F'); |
|
182
|
|
|
$this->addSql('ALTER TABLE swp_image_rendition DROP CONSTRAINT FK_932D0BFB3DA5256D'); |
|
183
|
|
|
$this->addSql('ALTER TABLE swp_article_media DROP CONSTRAINT FK_B9721F7E3DA5256D'); |
|
184
|
|
|
$this->addSql('ALTER TABLE swp_menu DROP CONSTRAINT FK_831217EB79066886'); |
|
185
|
|
|
$this->addSql('ALTER TABLE swp_menu DROP CONSTRAINT FK_831217EB727ACA70'); |
|
186
|
|
|
$this->addSql('ALTER TABLE swp_tenant DROP CONSTRAINT FK_EC6095FE32C8A3DE'); |
|
187
|
|
|
$this->addSql('ALTER TABLE swp_article DROP CONSTRAINT FK_FB21E85834ECB4E6'); |
|
188
|
|
|
$this->addSql('ALTER TABLE swp_menu DROP CONSTRAINT FK_831217EB34ECB4E6'); |
|
189
|
|
|
$this->addSql('ALTER TABLE swp_route DROP CONSTRAINT FK_5CE4CE5A79066886'); |
|
190
|
|
|
$this->addSql('ALTER TABLE swp_route DROP CONSTRAINT FK_5CE4CE5A727ACA70'); |
|
191
|
|
|
$this->addSql('ALTER TABLE swp_tenant DROP CONSTRAINT FK_EC6095FE154AD611'); |
|
192
|
|
|
$this->addSql('ALTER TABLE swp_api_key DROP CONSTRAINT FK_30090BA3A76ED395'); |
|
193
|
|
|
$this->addSql('ALTER TABLE swp_container_widgets DROP CONSTRAINT FK_EC017811FBE885E2'); |
|
194
|
|
|
$this->addSql('DROP SEQUENCE ext_log_entries_id_seq CASCADE'); |
|
195
|
|
|
$this->addSql('DROP SEQUENCE request_metrics_id_seq CASCADE'); |
|
196
|
|
|
$this->addSql('DROP SEQUENCE swp_item_id_seq CASCADE'); |
|
197
|
|
|
$this->addSql('DROP SEQUENCE swp_package_id_seq CASCADE'); |
|
198
|
|
|
$this->addSql('DROP SEQUENCE swp_api_key_id_seq CASCADE'); |
|
199
|
|
|
$this->addSql('DROP SEQUENCE swp_content_list_id_seq CASCADE'); |
|
200
|
|
|
$this->addSql('DROP SEQUENCE swp_content_list_item_id_seq CASCADE'); |
|
201
|
|
|
$this->addSql('DROP SEQUENCE swp_fbia_application_id_seq CASCADE'); |
|
202
|
|
|
$this->addSql('DROP SEQUENCE swp_fbia_article_id_seq CASCADE'); |
|
203
|
|
|
$this->addSql('DROP SEQUENCE swp_fbia_feed_id_seq CASCADE'); |
|
204
|
|
|
$this->addSql('DROP SEQUENCE swp_fbia_page_id_seq CASCADE'); |
|
205
|
|
|
$this->addSql('DROP SEQUENCE swp_menu_id_seq CASCADE'); |
|
206
|
|
|
$this->addSql('DROP SEQUENCE swp_organization_id_seq CASCADE'); |
|
207
|
|
|
$this->addSql('DROP SEQUENCE swp_rule_id_seq CASCADE'); |
|
208
|
|
|
$this->addSql('DROP SEQUENCE swp_tenant_id_seq CASCADE'); |
|
209
|
|
|
$this->addSql('DROP SEQUENCE swp_user_id_seq CASCADE'); |
|
210
|
|
|
$this->addSql('DROP TABLE ext_log_entries'); |
|
211
|
|
|
$this->addSql('DROP TABLE request_metrics'); |
|
212
|
|
|
$this->addSql('DROP TABLE swp_container_data'); |
|
213
|
|
|
$this->addSql('DROP TABLE swp_container_widgets'); |
|
214
|
|
|
$this->addSql('DROP TABLE swp_item'); |
|
215
|
|
|
$this->addSql('DROP TABLE swp_package'); |
|
216
|
|
|
$this->addSql('DROP TABLE swp_file'); |
|
217
|
|
|
$this->addSql('DROP TABLE swp_image_rendition'); |
|
218
|
|
|
$this->addSql('DROP TABLE swp_api_key'); |
|
219
|
|
|
$this->addSql('DROP TABLE swp_article'); |
|
220
|
|
|
$this->addSql('DROP TABLE swp_article_media'); |
|
221
|
|
|
$this->addSql('DROP TABLE swp_container'); |
|
222
|
|
|
$this->addSql('DROP TABLE swp_content_list'); |
|
223
|
|
|
$this->addSql('DROP TABLE swp_content_list_item'); |
|
224
|
|
|
$this->addSql('DROP TABLE swp_fbia_application'); |
|
225
|
|
|
$this->addSql('DROP TABLE swp_fbia_article'); |
|
226
|
|
|
$this->addSql('DROP TABLE swp_fbia_feed'); |
|
227
|
|
|
$this->addSql('DROP TABLE swp_fbia_page'); |
|
228
|
|
|
$this->addSql('DROP TABLE swp_image'); |
|
229
|
|
|
$this->addSql('DROP TABLE swp_menu'); |
|
230
|
|
|
$this->addSql('DROP TABLE swp_organization'); |
|
231
|
|
|
$this->addSql('DROP TABLE swp_route'); |
|
232
|
|
|
$this->addSql('DROP TABLE swp_rule'); |
|
233
|
|
|
$this->addSql('DROP TABLE swp_tenant'); |
|
234
|
|
|
$this->addSql('DROP TABLE swp_user'); |
|
235
|
|
|
$this->addSql('DROP TABLE swp_widget'); |
|
236
|
|
|
} |
|
237
|
|
|
} |
|
238
|
|
|
|
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.