@@ -5,8 +5,8 @@ discard block |
||
5 | 5 | |
6 | 6 | class m161123_191412_firefly_files_table extends Migration |
7 | 7 | { |
8 | - public function safeUp() |
|
9 | - { |
|
8 | + public function safeUp() |
|
9 | + { |
|
10 | 10 | $this->createTable(DbFile::tableName(), [ |
11 | 11 | // limit the path size on the db file storage driver. |
12 | 12 | // otherwise the key gets too big. |
@@ -35,11 +35,11 @@ discard block |
||
35 | 35 | 'created_at' => $this->datetime()->comment('When the file was first created'), |
36 | 36 | 'PRIMARY KEY (`path`(150))' |
37 | 37 | ]); |
38 | - } |
|
38 | + } |
|
39 | 39 | |
40 | - public function safeDown() |
|
41 | - { |
|
40 | + public function safeDown() |
|
41 | + { |
|
42 | 42 | $this->dropTable(DbFile::tableName()); |
43 | - } |
|
43 | + } |
|
44 | 44 | |
45 | 45 | } |
@@ -4,15 +4,15 @@ |
||
4 | 4 | |
5 | 5 | class m170312_165920_firefly_firefly_fix_uuid_collation extends Migration |
6 | 6 | { |
7 | - public function safeUp() |
|
8 | - { |
|
7 | + public function safeUp() |
|
8 | + { |
|
9 | 9 | $query = "ALTER TABLE `firefly_file_manager` CHANGE `uuid` `uuid` CHAR(22) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL COMMENT 'The unique identifier for this file'"; |
10 | 10 | $this->execute($query); |
11 | - } |
|
11 | + } |
|
12 | 12 | |
13 | - public function safeDown() |
|
14 | - { |
|
13 | + public function safeDown() |
|
14 | + { |
|
15 | 15 | $query = "ALTER TABLE `firefly_file_manager` CHANGE `uuid` `uuid` CHAR(22) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'The unique identifier for this file'"; |
16 | 16 | $this->execute($query); |
17 | - } |
|
17 | + } |
|
18 | 18 | } |
@@ -6,8 +6,8 @@ discard block |
||
6 | 6 | class m161126_123100_firefly_file_manager extends Migration |
7 | 7 | { |
8 | 8 | |
9 | - public function safeUp() |
|
10 | - { |
|
9 | + public function safeUp() |
|
10 | + { |
|
11 | 11 | $this->createTable(FileManager::tableName(), [ |
12 | 12 | |
13 | 13 | 'uuid' => $this->char(36)->notNull()->comment('The uuid for this file'), |
@@ -35,11 +35,11 @@ discard block |
||
35 | 35 | 'PRIMARY KEY (uuid)' |
36 | 36 | |
37 | 37 | ]); |
38 | - } |
|
38 | + } |
|
39 | 39 | |
40 | - public function safeDown() |
|
41 | - { |
|
40 | + public function safeDown() |
|
41 | + { |
|
42 | 42 | $this->dropTable(FileManager::tableName()); |
43 | - } |
|
43 | + } |
|
44 | 44 | |
45 | 45 | } |
@@ -4,13 +4,13 @@ |
||
4 | 4 | |
5 | 5 | class m161130_132459_firefly_uuid_change_to_22_chars extends Migration |
6 | 6 | { |
7 | - public function safeUp() |
|
8 | - { |
|
7 | + public function safeUp() |
|
8 | + { |
|
9 | 9 | $this->alterColumn('firefly_file_manager', 'uuid', "CHAR(22) NOT NULL COMMENT 'The unique identifier for this file'"); |
10 | - } |
|
10 | + } |
|
11 | 11 | |
12 | - public function safeDown() |
|
13 | - { |
|
12 | + public function safeDown() |
|
13 | + { |
|
14 | 14 | $this->alterColumn('firefly_file_manager', 'uuid', "CHAR(36) NOT NULL COMMENT 'The uuid for this file'"); |
15 | - } |
|
15 | + } |
|
16 | 16 | } |
@@ -7,12 +7,12 @@ discard block |
||
7 | 7 | |
8 | 8 | class m170112_211700_change_dds_page_ids_to_uuid64 extends Migration |
9 | 9 | { |
10 | - public function safeUp() |
|
11 | - { |
|
12 | - $cms_page = CmsPage::tableName(); |
|
13 | - // Step 1 |
|
10 | + public function safeUp() |
|
11 | + { |
|
12 | + $cms_page = CmsPage::tableName(); |
|
13 | + // Step 1 |
|
14 | 14 | // ------ |
15 | - // loop through all members in the DDS and find all members with a definition using |
|
15 | + // loop through all members in the DDS and find all members with a definition using |
|
16 | 16 | // {class: neon\\cms\\form\\fields\\PageSelector} |
17 | 17 | // or where the definition uses a `dataMapKey` of `pages` and a `dataMapProvider` of `cms` |
18 | 18 | $members = neon()->db->query()->select('*')->from('dds_member')->where('definition LIKE \'{"class":"neon__cms__form__fields__PageSelector%\'')->all(); |
@@ -47,10 +47,10 @@ discard block |
||
47 | 47 | } |
48 | 48 | } |
49 | 49 | $this->dropColumn($cms_page, 'old_id'); |
50 | - } |
|
50 | + } |
|
51 | 51 | |
52 | - public function safeDown() |
|
53 | - { |
|
54 | - echo "There is no coming back from this!\n"; |
|
55 | - } |
|
52 | + public function safeDown() |
|
53 | + { |
|
54 | + echo "There is no coming back from this!\n"; |
|
55 | + } |
|
56 | 56 | } |
57 | 57 | \ No newline at end of file |
@@ -7,23 +7,23 @@ |
||
7 | 7 | |
8 | 8 | class m170112_201653_cms_static_content_page_ids_to_uuid64 extends Migration |
9 | 9 | { |
10 | - public function safeUp() |
|
11 | - { |
|
12 | - $cms_static_content = CmsStaticContent::tableName(); |
|
10 | + public function safeUp() |
|
11 | + { |
|
12 | + $cms_static_content = CmsStaticContent::tableName(); |
|
13 | 13 | $cms_page = CmsPage::tableName(); |
14 | 14 | |
15 | 15 | // use a nice id |
16 | - $this->alterColumn($cms_static_content, 'page_id', $this->char(22)->null()->comment('A uuid using base 64')); |
|
16 | + $this->alterColumn($cms_static_content, 'page_id', $this->char(22)->null()->comment('A uuid using base 64')); |
|
17 | 17 | // update with nice_id's |
18 | 18 | $this->execute("UPDATE $cms_static_content JOIN $cms_page ON $cms_page.old_id = $cms_static_content.page_id SET $cms_static_content.page_id = $cms_page.id"); |
19 | - } |
|
19 | + } |
|
20 | 20 | |
21 | - public function safeDown() |
|
22 | - { |
|
21 | + public function safeDown() |
|
22 | + { |
|
23 | 23 | $cms_static_content = CmsStaticContent::tableName(); |
24 | 24 | $cms_page = CmsPage::tableName(); |
25 | 25 | |
26 | 26 | $this->execute("UPDATE $cms_static_content JOIN $cms_page ON $cms_page.id = $cms_static_content.page_id SET $cms_static_content.page_id = $cms_page.old_id"); |
27 | 27 | $this->alterColumn($cms_static_content, 'page_id', $this->integer(11)->null()); |
28 | - } |
|
28 | + } |
|
29 | 29 | } |
30 | 30 | \ No newline at end of file |
@@ -5,20 +5,20 @@ |
||
5 | 5 | class m161130_180814_cms_additional_page_fields extends Migration |
6 | 6 | { |
7 | 7 | |
8 | - public function safeUp() |
|
9 | - { |
|
8 | + public function safeUp() |
|
9 | + { |
|
10 | 10 | $this->addColumn('cms_page', 'keywords', "VARCHAR(1000) NULL COMMENT 'Keywords for this page'"); |
11 | 11 | $this->addColumn('cms_page', 'description', "VARCHAR(1000) NULL COMMENT 'Description of this page'"); |
12 | 12 | $this->addColumn('cms_page', 'languages', "VARCHAR(1000) NULL COMMENT 'Supported languages on this page'"); |
13 | 13 | $this->addColumn('cms_page', 'page_params', "VARCHAR(10000) NULL COMMENT 'Additional parameters for this page which are interpreted directly within the templates'"); |
14 | - } |
|
14 | + } |
|
15 | 15 | |
16 | - public function safeDown() |
|
17 | - { |
|
16 | + public function safeDown() |
|
17 | + { |
|
18 | 18 | $this->dropColumn('cms_page', 'keywords'); |
19 | 19 | $this->dropColumn('cms_page', 'description'); |
20 | 20 | $this->dropColumn('cms_page', 'languages'); |
21 | 21 | $this->dropColumn('cms_page', 'page_params'); |
22 | - } |
|
22 | + } |
|
23 | 23 | |
24 | 24 | } |
@@ -4,8 +4,8 @@ discard block |
||
4 | 4 | |
5 | 5 | class m170107_201653_cms_create_cms_static_content_table_again extends Migration |
6 | 6 | { |
7 | - public function safeUp() |
|
8 | - { |
|
7 | + public function safeUp() |
|
8 | + { |
|
9 | 9 | $cms_static = 'cms_static_content'; |
10 | 10 | |
11 | 11 | // recreate the table with the new structure |
@@ -46,10 +46,10 @@ discard block |
||
46 | 46 | // } |
47 | 47 | // } |
48 | 48 | // } while ($count < $total); |
49 | - } |
|
49 | + } |
|
50 | 50 | |
51 | - public function safeDown() |
|
52 | - { |
|
51 | + public function safeDown() |
|
52 | + { |
|
53 | 53 | $this->dropTable('cms_static_content'); |
54 | - } |
|
54 | + } |
|
55 | 55 | } |
@@ -7,11 +7,11 @@ |
||
7 | 7 | */ |
8 | 8 | class m171011_143735_forms_phoebe extends Migration |
9 | 9 | { |
10 | - public function safeUp() |
|
11 | - { |
|
12 | - } |
|
10 | + public function safeUp() |
|
11 | + { |
|
12 | + } |
|
13 | 13 | |
14 | - public function safeDown() |
|
15 | - { |
|
16 | - } |
|
14 | + public function safeDown() |
|
15 | + { |
|
16 | + } |
|
17 | 17 | } |