|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace Application\Migrations; |
|
4
|
|
|
|
|
5
|
|
|
use Doctrine\DBAL\Migrations\AbstractMigration, |
|
6
|
|
|
Doctrine\DBAL\Schema\Schema; |
|
7
|
|
|
|
|
8
|
|
|
/** |
|
9
|
|
|
* Auto-generated Migration: Please modify to your need! |
|
10
|
|
|
*/ |
|
11
|
|
|
class Version20111017011135 extends AbstractMigration |
|
12
|
|
|
{ |
|
13
|
|
|
public function up(Schema $schema) |
|
14
|
|
|
{ |
|
15
|
|
|
// this up() migration is autogenerated, please modify it to your needs |
|
16
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql"); |
|
17
|
|
|
|
|
18
|
|
|
$this->addSql("CREATE TABLE users (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(255) NOT NULL, username_canonical VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, email_canonical VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, algorithm VARCHAR(255) NOT NULL, salt VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, last_login DATETIME DEFAULT NULL, locked TINYINT(1) NOT NULL, expired TINYINT(1) NOT NULL, expires_at DATETIME DEFAULT NULL, confirmation_token VARCHAR(255) DEFAULT NULL, password_requested_at DATETIME DEFAULT NULL, roles LONGTEXT NOT NULL COMMENT '(DC2Type:array)', credentials_expired TINYINT(1) NOT NULL, credentials_expire_at DATETIME DEFAULT NULL, fullname VARCHAR(255) NOT NULL, company VARCHAR(255) DEFAULT NULL, post VARCHAR(255) DEFAULT NULL, subscribe TINYINT(1) NOT NULL, comment LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_1483A5E992FC23A8 (username_canonical), UNIQUE INDEX UNIQ_1483A5E9A0D96FBF (email_canonical), PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
19
|
|
|
$this->addSql("CREATE TABLE pages (id INT AUTO_INCREMENT NOT NULL, slug VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, text LONGTEXT NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
20
|
|
|
$this->addSql("CREATE TABLE news (id INT AUTO_INCREMENT NOT NULL, slug VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, preview LONGTEXT NOT NULL, text LONGTEXT NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
21
|
|
|
$this->addSql("CREATE TABLE event__pages (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, slug VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, text LONGTEXT NOT NULL, INDEX IDX_98D57EBB71F7E88B (event_id), PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
22
|
|
|
$this->addSql("CREATE TABLE event__speakers (id INT AUTO_INCREMENT NOT NULL, slug VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, company VARCHAR(255) NOT NULL, about LONGTEXT NOT NULL, photo VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
23
|
|
|
$this->addSql("CREATE TABLE event__events_speakers (speaker_id INT NOT NULL, event_id INT NOT NULL, INDEX IDX_873F8739D04A0F27 (speaker_id), INDEX IDX_873F873971F7E88B (event_id), PRIMARY KEY(speaker_id, event_id)) ENGINE = InnoDB"); |
|
24
|
|
|
$this->addSql("CREATE TABLE event__events (id INT AUTO_INCREMENT NOT NULL, slug VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT NOT NULL, about LONGTEXT NOT NULL, logo VARCHAR(255) NOT NULL, active TINYINT(1) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
25
|
|
|
$this->addSql("CREATE TABLE event__mails (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, text LONGTEXT NOT NULL, start TINYINT(1) DEFAULT NULL, complete TINYINT(1) DEFAULT NULL, PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
26
|
|
|
$this->addSql("CREATE TABLE event__events_mails (mail_id INT NOT NULL, event_id INT NOT NULL, INDEX IDX_ADE63A26C8776F01 (mail_id), INDEX IDX_ADE63A2671F7E88B (event_id), PRIMARY KEY(mail_id, event_id)) ENGINE = InnoDB"); |
|
27
|
|
|
$this->addSql("CREATE TABLE event__news (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, slug VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, preview LONGTEXT NOT NULL, text LONGTEXT NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_1ED586771F7E88B (event_id), PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
28
|
|
|
$this->addSql("CREATE TABLE event__tickets (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, payment_id INT DEFAULT NULL, user_id INT DEFAULT NULL, status VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
29
|
|
|
$this->addSql("CREATE TABLE event__reviews (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, slug VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, text LONGTEXT NOT NULL, INDEX IDX_5BD4E3A271F7E88B (event_id), PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
30
|
|
|
$this->addSql("CREATE TABLE event__speakers_reviews (review_id INT NOT NULL, speaker_id INT NOT NULL, INDEX IDX_C0C1D68A3E2E969B (review_id), INDEX IDX_C0C1D68AD04A0F27 (speaker_id), PRIMARY KEY(review_id, speaker_id)) ENGINE = InnoDB"); |
|
31
|
|
|
$this->addSql("CREATE TABLE payments (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, sum NUMERIC(10, 0) NOT NULL, status VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB"); |
|
32
|
|
|
$this->addSql("ALTER TABLE event__pages ADD CONSTRAINT FK_98D57EBB71F7E88B FOREIGN KEY (event_id) REFERENCES event__events(id)"); |
|
33
|
|
|
$this->addSql("ALTER TABLE event__events_speakers ADD CONSTRAINT FK_873F8739D04A0F27 FOREIGN KEY (speaker_id) REFERENCES event__speakers(id)"); |
|
34
|
|
|
$this->addSql("ALTER TABLE event__events_speakers ADD CONSTRAINT FK_873F873971F7E88B FOREIGN KEY (event_id) REFERENCES event__events(id)"); |
|
35
|
|
|
$this->addSql("ALTER TABLE event__events_mails ADD CONSTRAINT FK_ADE63A26C8776F01 FOREIGN KEY (mail_id) REFERENCES event__mails(id)"); |
|
36
|
|
|
$this->addSql("ALTER TABLE event__events_mails ADD CONSTRAINT FK_ADE63A2671F7E88B FOREIGN KEY (event_id) REFERENCES event__events(id)"); |
|
37
|
|
|
$this->addSql("ALTER TABLE event__news ADD CONSTRAINT FK_1ED586771F7E88B FOREIGN KEY (event_id) REFERENCES event__events(id)"); |
|
38
|
|
|
$this->addSql("ALTER TABLE event__tickets ADD CONSTRAINT FK_66E2955971F7E88B FOREIGN KEY (event_id) REFERENCES event__events(id)"); |
|
39
|
|
|
$this->addSql("ALTER TABLE event__tickets ADD CONSTRAINT FK_66E295594C3A3BB FOREIGN KEY (payment_id) REFERENCES payments(id)"); |
|
40
|
|
|
$this->addSql("ALTER TABLE event__tickets ADD CONSTRAINT FK_66E29559A76ED395 FOREIGN KEY (user_id) REFERENCES users(id)"); |
|
41
|
|
|
$this->addSql("ALTER TABLE event__reviews ADD CONSTRAINT FK_5BD4E3A271F7E88B FOREIGN KEY (event_id) REFERENCES event__events(id)"); |
|
42
|
|
|
$this->addSql("ALTER TABLE event__speakers_reviews ADD CONSTRAINT FK_C0C1D68A3E2E969B FOREIGN KEY (review_id) REFERENCES event__reviews(id)"); |
|
43
|
|
|
$this->addSql("ALTER TABLE event__speakers_reviews ADD CONSTRAINT FK_C0C1D68AD04A0F27 FOREIGN KEY (speaker_id) REFERENCES event__speakers(id)"); |
|
44
|
|
|
} |
|
45
|
|
|
|
|
46
|
|
|
public function down(Schema $schema) |
|
47
|
|
|
{ |
|
48
|
|
|
// this down() migration is autogenerated, please modify it to your needs |
|
49
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql"); |
|
50
|
|
|
|
|
51
|
|
|
$this->addSql("ALTER TABLE event__tickets DROP FOREIGN KEY FK_66E29559A76ED395"); |
|
52
|
|
|
$this->addSql("ALTER TABLE event__events_speakers DROP FOREIGN KEY FK_873F8739D04A0F27"); |
|
53
|
|
|
$this->addSql("ALTER TABLE event__speakers_reviews DROP FOREIGN KEY FK_C0C1D68AD04A0F27"); |
|
54
|
|
|
$this->addSql("ALTER TABLE event__pages DROP FOREIGN KEY FK_98D57EBB71F7E88B"); |
|
55
|
|
|
$this->addSql("ALTER TABLE event__events_speakers DROP FOREIGN KEY FK_873F873971F7E88B"); |
|
56
|
|
|
$this->addSql("ALTER TABLE event__events_mails DROP FOREIGN KEY FK_ADE63A2671F7E88B"); |
|
57
|
|
|
$this->addSql("ALTER TABLE event__news DROP FOREIGN KEY FK_1ED586771F7E88B"); |
|
58
|
|
|
$this->addSql("ALTER TABLE event__tickets DROP FOREIGN KEY FK_66E2955971F7E88B"); |
|
59
|
|
|
$this->addSql("ALTER TABLE event__reviews DROP FOREIGN KEY FK_5BD4E3A271F7E88B"); |
|
60
|
|
|
$this->addSql("ALTER TABLE event__events_mails DROP FOREIGN KEY FK_ADE63A26C8776F01"); |
|
61
|
|
|
$this->addSql("ALTER TABLE event__speakers_reviews DROP FOREIGN KEY FK_C0C1D68A3E2E969B"); |
|
62
|
|
|
$this->addSql("ALTER TABLE event__tickets DROP FOREIGN KEY FK_66E295594C3A3BB"); |
|
63
|
|
|
$this->addSql("DROP TABLE users"); |
|
64
|
|
|
$this->addSql("DROP TABLE pages"); |
|
65
|
|
|
$this->addSql("DROP TABLE news"); |
|
66
|
|
|
$this->addSql("DROP TABLE event__pages"); |
|
67
|
|
|
$this->addSql("DROP TABLE event__speakers"); |
|
68
|
|
|
$this->addSql("DROP TABLE event__events_speakers"); |
|
69
|
|
|
$this->addSql("DROP TABLE event__events"); |
|
70
|
|
|
$this->addSql("DROP TABLE event__mails"); |
|
71
|
|
|
$this->addSql("DROP TABLE event__events_mails"); |
|
72
|
|
|
$this->addSql("DROP TABLE event__news"); |
|
73
|
|
|
$this->addSql("DROP TABLE event__tickets"); |
|
74
|
|
|
$this->addSql("DROP TABLE event__reviews"); |
|
75
|
|
|
$this->addSql("DROP TABLE event__speakers_reviews"); |
|
76
|
|
|
$this->addSql("DROP TABLE payments"); |
|
77
|
|
|
} |
|
78
|
|
|
} |
|
79
|
|
|
|
stfalcon /
fwdays
