| @@ -30,78 +30,78 @@ | ||
| 30 | 30 |      { | 
| 31 | 31 | // this up() migration is auto-generated, please modify it to your needs | 
| 32 | 32 | $this->addSql( | 
| 33 | -            'CREATE TABLE company (' . | |
| 34 | - 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' . | |
| 35 | - 'company_name VARCHAR(255) NOT NULL, ' . | |
| 36 | - 'address VARCHAR(255) NOT NULL, ' . | |
| 37 | - 'zip_code VARCHAR(5) NOT NULL, ' . | |
| 38 | - 'town VARCHAR(255) NOT NULL, ' . | |
| 39 | - 'country VARCHAR(255) NOT NULL, ' . | |
| 40 | - 'phone VARCHAR(14) NOT NULL, ' . | |
| 41 | - 'facsimile VARCHAR(14) DEFAULT NULL, ' . | |
| 42 | - 'email VARCHAR(255) NOT NULL, ' . | |
| 43 | - 'contact_name VARCHAR(255) NOT NULL, ' . | |
| 44 | - 'cellphone VARCHAR(14) NOT NULL, ' . | |
| 45 | - 'slug VARCHAR(255) NOT NULL, ' . | |
| 46 | - 'UNIQUE INDEX UNIQ_4FBF094F1D4E64E8 (company_name), ' . | |
| 47 | - 'UNIQUE INDEX UNIQ_4FBF094F989D9B62 (slug), ' . | |
| 48 | - 'PRIMARY KEY(uuid)' . | |
| 33 | +            'CREATE TABLE company ('. | |
| 34 | + 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '. | |
| 35 | + 'company_name VARCHAR(255) NOT NULL, '. | |
| 36 | + 'address VARCHAR(255) NOT NULL, '. | |
| 37 | + 'zip_code VARCHAR(5) NOT NULL, '. | |
| 38 | + 'town VARCHAR(255) NOT NULL, '. | |
| 39 | + 'country VARCHAR(255) NOT NULL, '. | |
| 40 | + 'phone VARCHAR(14) NOT NULL, '. | |
| 41 | + 'facsimile VARCHAR(14) DEFAULT NULL, '. | |
| 42 | + 'email VARCHAR(255) NOT NULL, '. | |
| 43 | + 'contact_name VARCHAR(255) NOT NULL, '. | |
| 44 | + 'cellphone VARCHAR(14) NOT NULL, '. | |
| 45 | + 'slug VARCHAR(255) NOT NULL, '. | |
| 46 | + 'UNIQUE INDEX UNIQ_4FBF094F1D4E64E8 (company_name), '. | |
| 47 | + 'UNIQUE INDEX UNIQ_4FBF094F989D9B62 (slug), '. | |
| 48 | + 'PRIMARY KEY(uuid)'. | |
| 49 | 49 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' | 
| 50 | 50 | ); | 
| 51 | 51 | $this->addSql( | 
| 52 | -            'CREATE TABLE settings (' . | |
| 53 | - 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' . | |
| 54 | - 'locale VARCHAR(255) NOT NULL, ' . | |
| 55 | - 'currency VARCHAR(255) NOT NULL, ' . | |
| 56 | - 'PRIMARY KEY(uuid)' . | |
| 52 | +            'CREATE TABLE settings ('. | |
| 53 | + 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '. | |
| 54 | + 'locale VARCHAR(255) NOT NULL, '. | |
| 55 | + 'currency VARCHAR(255) NOT NULL, '. | |
| 56 | + 'PRIMARY KEY(uuid)'. | |
| 57 | 57 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' | 
| 58 | 58 | ); | 
| 59 | 59 | $this->addSql( | 
| 60 | -            'CREATE TABLE supplier (' . | |
| 61 | - 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' . | |
| 62 | - 'family_log VARCHAR(255) NOT NULL, ' . | |
| 63 | - 'delay_delivery INT NOT NULL, ' . | |
| 64 | - 'order_days LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' . | |
| 65 | - 'active TINYINT(1) NOT NULL, ' . | |
| 66 | - 'company_name VARCHAR(255) NOT NULL, ' . | |
| 67 | - 'address VARCHAR(255) NOT NULL, ' . | |
| 68 | - 'zip_code VARCHAR(5) NOT NULL, ' . | |
| 69 | - 'town VARCHAR(255) NOT NULL, ' . | |
| 70 | - 'country VARCHAR(255) NOT NULL, ' . | |
| 71 | - 'phone VARCHAR(14) NOT NULL, ' . | |
| 72 | - 'facsimile VARCHAR(14) DEFAULT NULL, ' . | |
| 73 | - 'email VARCHAR(255) NOT NULL, ' . | |
| 74 | - 'contact_name VARCHAR(255) NOT NULL, ' . | |
| 75 | - 'cellphone VARCHAR(14) NOT NULL, s' . | |
| 76 | - 'lug VARCHAR(255) NOT NULL, ' . | |
| 77 | - 'UNIQUE INDEX UNIQ_9B2A6C7E1D4E64E8 (company_name), ' . | |
| 78 | - 'UNIQUE INDEX UNIQ_9B2A6C7E989D9B62 (slug), ' . | |
| 79 | - 'PRIMARY KEY(uuid)' . | |
| 60 | +            'CREATE TABLE supplier ('. | |
| 61 | + 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '. | |
| 62 | + 'family_log VARCHAR(255) NOT NULL, '. | |
| 63 | + 'delay_delivery INT NOT NULL, '. | |
| 64 | + 'order_days LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', '. | |
| 65 | + 'active TINYINT(1) NOT NULL, '. | |
| 66 | + 'company_name VARCHAR(255) NOT NULL, '. | |
| 67 | + 'address VARCHAR(255) NOT NULL, '. | |
| 68 | + 'zip_code VARCHAR(5) NOT NULL, '. | |
| 69 | + 'town VARCHAR(255) NOT NULL, '. | |
| 70 | + 'country VARCHAR(255) NOT NULL, '. | |
| 71 | + 'phone VARCHAR(14) NOT NULL, '. | |
| 72 | + 'facsimile VARCHAR(14) DEFAULT NULL, '. | |
| 73 | + 'email VARCHAR(255) NOT NULL, '. | |
| 74 | + 'contact_name VARCHAR(255) NOT NULL, '. | |
| 75 | + 'cellphone VARCHAR(14) NOT NULL, s'. | |
| 76 | + 'lug VARCHAR(255) NOT NULL, '. | |
| 77 | + 'UNIQUE INDEX UNIQ_9B2A6C7E1D4E64E8 (company_name), '. | |
| 78 | + 'UNIQUE INDEX UNIQ_9B2A6C7E989D9B62 (slug), '. | |
| 79 | + 'PRIMARY KEY(uuid)'. | |
| 80 | 80 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' | 
| 81 | 81 | ); | 
| 82 | 82 | $this->addSql( | 
| 83 | -            'CREATE TABLE user (' . | |
| 84 | - 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' . | |
| 85 | - 'username VARCHAR(150) NOT NULL, ' . | |
| 86 | - 'email VARCHAR(255) NOT NULL, ' . | |
| 87 | - 'password VARCHAR(120) NOT NULL, ' . | |
| 88 | - 'roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' . | |
| 89 | - 'PRIMARY KEY(uuid)' . | |
| 83 | +            'CREATE TABLE user ('. | |
| 84 | + 'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', '. | |
| 85 | + 'username VARCHAR(150) NOT NULL, '. | |
| 86 | + 'email VARCHAR(255) NOT NULL, '. | |
| 87 | + 'password VARCHAR(120) NOT NULL, '. | |
| 88 | + 'roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', '. | |
| 89 | + 'PRIMARY KEY(uuid)'. | |
| 90 | 90 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' | 
| 91 | 91 | ); | 
| 92 | 92 | $this->addSql( | 
| 93 | -            'CREATE TABLE messenger_messages (' . | |
| 94 | - 'id BIGINT AUTO_INCREMENT NOT NULL, ' . | |
| 95 | - 'body LONGTEXT NOT NULL, ' . | |
| 96 | - 'headers LONGTEXT NOT NULL, ' . | |
| 97 | - 'queue_name VARCHAR(190) NOT NULL, ' . | |
| 98 | - 'created_at DATETIME NOT NULL, ' . | |
| 99 | - 'available_at DATETIME NOT NULL, ' . | |
| 100 | - 'delivered_at DATETIME DEFAULT NULL, ' . | |
| 101 | - 'INDEX IDX_75EA56E0FB7336F0 (queue_name), ' . | |
| 102 | - 'INDEX IDX_75EA56E0E3BD61CE (available_at), ' . | |
| 103 | - 'INDEX IDX_75EA56E016BA31DB (delivered_at), ' . | |
| 104 | - 'PRIMARY KEY(id)' . | |
| 93 | +            'CREATE TABLE messenger_messages ('. | |
| 94 | + 'id BIGINT AUTO_INCREMENT NOT NULL, '. | |
| 95 | + 'body LONGTEXT NOT NULL, '. | |
| 96 | + 'headers LONGTEXT NOT NULL, '. | |
| 97 | + 'queue_name VARCHAR(190) NOT NULL, '. | |
| 98 | + 'created_at DATETIME NOT NULL, '. | |
| 99 | + 'available_at DATETIME NOT NULL, '. | |
| 100 | + 'delivered_at DATETIME DEFAULT NULL, '. | |
| 101 | + 'INDEX IDX_75EA56E0FB7336F0 (queue_name), '. | |
| 102 | + 'INDEX IDX_75EA56E0E3BD61CE (available_at), '. | |
| 103 | + 'INDEX IDX_75EA56E016BA31DB (delivered_at), '. | |
| 104 | + 'PRIMARY KEY(id)'. | |
| 105 | 105 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' | 
| 106 | 106 | ); | 
| 107 | 107 | } |