* Auto-generated Migration: Please modify to your needs!
12
*/
13
final class Version20190130163118 extends AbstractMigration
14
{
15
public function getDescription() : string
16
{
17
return '';
18
}
19
20
public function up(Schema $schema) : void
21
{
22
// this up() migration is auto-generated, please modify it to your needs
23
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
24
25
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, user_name VARCHAR(255) NOT NULL, image VARCHAR(255) DEFAULT NULL, verified TINYINT(1) DEFAULT \'0\' NOT NULL, verified_hash VARCHAR(255) NOT NULL, verified_date_time DATETIME NOT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), UNIQUE INDEX UNIQ_8D93D64924A232CF (user_name), UNIQUE INDEX UNIQ_8D93D649CEA1B245 (verified_hash), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
26
}
27
28
public function down(Schema $schema) : void
29
{
30
// this down() migration is auto-generated, please modify it to your needs
31
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
Starbugstone /
SnowTricks
