@@ -24,12 +24,12 @@ |
||
24 | 24 | |
25 | 25 | $this->createTable('{{%taxonomy}}', [ |
26 | 26 | 'id' => Schema::TYPE_PK, |
27 | - 'name' => Schema::TYPE_STRING . '(200) NOT NULL', |
|
28 | - 'slug' => Schema::TYPE_STRING . '(200) NOT NULL', |
|
29 | - 'hierarchical' => Schema::TYPE_SMALLINT . '(1) NOT NULL DEFAULT 0', |
|
30 | - 'singular_name' => Schema::TYPE_STRING . '(255) NOT NULL', |
|
31 | - 'plural_name' => Schema::TYPE_STRING . '(255) NOT NULL', |
|
32 | - 'menu_builder' => Schema::TYPE_SMALLINT . '(1) NOT NULL DEFAULT 0', |
|
27 | + 'name' => Schema::TYPE_STRING.'(200) NOT NULL', |
|
28 | + 'slug' => Schema::TYPE_STRING.'(200) NOT NULL', |
|
29 | + 'hierarchical' => Schema::TYPE_SMALLINT.'(1) NOT NULL DEFAULT 0', |
|
30 | + 'singular_name' => Schema::TYPE_STRING.'(255) NOT NULL', |
|
31 | + 'plural_name' => Schema::TYPE_STRING.'(255) NOT NULL', |
|
32 | + 'menu_builder' => Schema::TYPE_SMALLINT.'(1) NOT NULL DEFAULT 0', |
|
33 | 33 | ], $tableOptions); |
34 | 34 | |
35 | 35 | /** |
@@ -24,17 +24,17 @@ |
||
24 | 24 | |
25 | 25 | $this->createTable('{{%post_comment}}', [ |
26 | 26 | 'id' => Schema::TYPE_PK, |
27 | - 'post_id' => Schema::TYPE_INTEGER . '(11) NOT NULL', |
|
27 | + 'post_id' => Schema::TYPE_INTEGER.'(11) NOT NULL', |
|
28 | 28 | 'author' => Schema::TYPE_TEXT, |
29 | - 'email' => Schema::TYPE_STRING . '(100)', |
|
30 | - 'url' => Schema::TYPE_STRING . '(255)', |
|
31 | - 'ip' => Schema::TYPE_STRING . '(100) NOT NULL', |
|
32 | - 'date' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
33 | - 'content' => Schema::TYPE_TEXT . ' NOT NULL', |
|
34 | - 'status' => Schema::TYPE_STRING . '(20) NOT NULL', |
|
35 | - 'agent' => Schema::TYPE_STRING . '(255) NOT NULL', |
|
36 | - 'parent' => Schema::TYPE_INTEGER . '(11) DEFAULT 0', |
|
37 | - 'user_id' => Schema::TYPE_INTEGER . '(11)', |
|
29 | + 'email' => Schema::TYPE_STRING.'(100)', |
|
30 | + 'url' => Schema::TYPE_STRING.'(255)', |
|
31 | + 'ip' => Schema::TYPE_STRING.'(100) NOT NULL', |
|
32 | + 'date' => Schema::TYPE_DATETIME.' NOT NULL', |
|
33 | + 'content' => Schema::TYPE_TEXT.' NOT NULL', |
|
34 | + 'status' => Schema::TYPE_STRING.'(20) NOT NULL', |
|
35 | + 'agent' => Schema::TYPE_STRING.'(255) NOT NULL', |
|
36 | + 'parent' => Schema::TYPE_INTEGER.'(11) DEFAULT 0', |
|
37 | + 'user_id' => Schema::TYPE_INTEGER.'(11)', |
|
38 | 38 | 'FOREIGN KEY ([[post_id]]) REFERENCES {{%post}} ([[id]]) ON DELETE CASCADE ON UPDATE CASCADE', |
39 | 39 | ], $tableOptions); |
40 | 40 |
@@ -23,18 +23,18 @@ |
||
23 | 23 | |
24 | 24 | $this->createTable('{{%media}}', [ |
25 | 25 | 'id' => Schema::TYPE_PK, |
26 | - 'author' => Schema::TYPE_INTEGER . '(11) NOT NULL', |
|
27 | - 'post_id' => Schema::TYPE_INTEGER . '(11)', |
|
28 | - 'title' => Schema::TYPE_TEXT . ' NOT NULL', |
|
26 | + 'author' => Schema::TYPE_INTEGER.'(11) NOT NULL', |
|
27 | + 'post_id' => Schema::TYPE_INTEGER.'(11)', |
|
28 | + 'title' => Schema::TYPE_TEXT.' NOT NULL', |
|
29 | 29 | 'excerpt' => Schema::TYPE_TEXT, |
30 | 30 | 'content' => Schema::TYPE_TEXT, |
31 | - 'password' => Schema::TYPE_STRING . '(255)', |
|
32 | - 'date' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
33 | - 'modified' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
34 | - 'slug' => Schema::TYPE_STRING . '(255) NOT NULL', |
|
35 | - 'mime_type' => Schema::TYPE_STRING . '(100) NOT NULL', |
|
36 | - 'comment_status' => Schema::TYPE_STRING . "(20) NOT NULL DEFAULT 'open'", |
|
37 | - 'comment_count' => Schema::TYPE_INTEGER . '(11) NOT NULL DEFAULT 0', |
|
31 | + 'password' => Schema::TYPE_STRING.'(255)', |
|
32 | + 'date' => Schema::TYPE_DATETIME.' NOT NULL', |
|
33 | + 'modified' => Schema::TYPE_DATETIME.' NOT NULL', |
|
34 | + 'slug' => Schema::TYPE_STRING.'(255) NOT NULL', |
|
35 | + 'mime_type' => Schema::TYPE_STRING.'(100) NOT NULL', |
|
36 | + 'comment_status' => Schema::TYPE_STRING."(20) NOT NULL DEFAULT 'open'", |
|
37 | + 'comment_count' => Schema::TYPE_INTEGER.'(11) NOT NULL DEFAULT 0', |
|
38 | 38 | 'FOREIGN KEY ([[post_id]]) REFERENCES {{%post}} ([[id]]) ON DELETE SET NULL ON UPDATE CASCADE', |
39 | 39 | 'FOREIGN KEY ([[author]]) REFERENCES {{%user}} ([[id]]) ON DELETE CASCADE ON UPDATE CASCADE', |
40 | 40 | ], $tableOptions); |
@@ -23,10 +23,10 @@ |
||
23 | 23 | } |
24 | 24 | |
25 | 25 | $this->createTable('{{%auth_rule}}', [ |
26 | - 'name' => Schema::TYPE_STRING . '(64) NOT NULL', |
|
26 | + 'name' => Schema::TYPE_STRING.'(64) NOT NULL', |
|
27 | 27 | 'data' => Schema::TYPE_TEXT, |
28 | - 'created_at' => Schema::TYPE_INTEGER . '(11)', |
|
29 | - 'updated_at' => Schema::TYPE_INTEGER . '(11)', |
|
28 | + 'created_at' => Schema::TYPE_INTEGER.'(11)', |
|
29 | + 'updated_at' => Schema::TYPE_INTEGER.'(11)', |
|
30 | 30 | 'PRIMARY KEY ([[name]])', |
31 | 31 | ], $tableOptions); |
32 | 32 | } |
@@ -23,12 +23,12 @@ |
||
23 | 23 | |
24 | 24 | $this->createTable('{{%term}}', [ |
25 | 25 | 'id' => Schema::TYPE_PK, |
26 | - 'taxonomy_id' => Schema::TYPE_INTEGER . '(11) NOT NULL', |
|
27 | - 'name' => Schema::TYPE_STRING . '(200) NOT NULL', |
|
28 | - 'slug' => Schema::TYPE_STRING . '(200) NOT NULL', |
|
26 | + 'taxonomy_id' => Schema::TYPE_INTEGER.'(11) NOT NULL', |
|
27 | + 'name' => Schema::TYPE_STRING.'(200) NOT NULL', |
|
28 | + 'slug' => Schema::TYPE_STRING.'(200) NOT NULL', |
|
29 | 29 | 'description' => Schema::TYPE_TEXT, |
30 | - 'parent' => Schema::TYPE_INTEGER . '(11) DEFAULT 0', |
|
31 | - 'count' => Schema::TYPE_INTEGER . '(11) DEFAULT 0', |
|
30 | + 'parent' => Schema::TYPE_INTEGER.'(11) DEFAULT 0', |
|
31 | + 'count' => Schema::TYPE_INTEGER.'(11) DEFAULT 0', |
|
32 | 32 | 'FOREIGN KEY ([[taxonomy_id]]) REFERENCES {{%taxonomy}} ([[id]]) ON DELETE CASCADE ON UPDATE CASCADE', |
33 | 33 | ], $tableOptions); |
34 | 34 |
@@ -23,8 +23,8 @@ |
||
23 | 23 | } |
24 | 24 | |
25 | 25 | $this->createTable('{{%auth_item_child}}', [ |
26 | - 'parent' => Schema::TYPE_STRING . '(64) NOT NULL', |
|
27 | - 'child' => Schema::TYPE_STRING . '(64) NOT NULL', |
|
26 | + 'parent' => Schema::TYPE_STRING.'(64) NOT NULL', |
|
27 | + 'child' => Schema::TYPE_STRING.'(64) NOT NULL', |
|
28 | 28 | 'PRIMARY KEY ([[parent]], [[child]])', |
29 | 29 | 'FOREIGN KEY ([[parent]]) REFERENCES {{%auth_item}} ([[name]]) ON DELETE CASCADE ON UPDATE CASCADE', |
30 | 30 | 'FOREIGN KEY ([[child]]) REFERENCES {{%auth_item}} ([[name]]) ON DELETE CASCADE ON UPDATE CASCADE', |
@@ -23,10 +23,10 @@ |
||
23 | 23 | |
24 | 24 | $this->createTable('{{%option}}', [ |
25 | 25 | 'id' => Schema::TYPE_PK, |
26 | - 'name' => Schema::TYPE_STRING . '(64) NOT NULL', |
|
27 | - 'value' => Schema::TYPE_TEXT . ' NOT NULL', |
|
28 | - 'label' => Schema::TYPE_STRING . '(64)', |
|
29 | - 'group' => Schema::TYPE_STRING . '(64)', |
|
26 | + 'name' => Schema::TYPE_STRING.'(64) NOT NULL', |
|
27 | + 'value' => Schema::TYPE_TEXT.' NOT NULL', |
|
28 | + 'label' => Schema::TYPE_STRING.'(64)', |
|
29 | + 'group' => Schema::TYPE_STRING.'(64)', |
|
30 | 30 | ], $tableOptions); |
31 | 31 | |
32 | 32 | $this->batchInsert('{{%option}}', ['name', 'value', 'label', 'group'], [ |
@@ -23,9 +23,9 @@ |
||
23 | 23 | } |
24 | 24 | |
25 | 25 | $this->createTable('{{%auth_assignment}}', [ |
26 | - 'item_name' => Schema::TYPE_STRING . '(64) NOT NULL', |
|
27 | - 'user_id' => Schema::TYPE_INTEGER . '(11) NOT NULL', |
|
28 | - 'created_at' => Schema::TYPE_INTEGER . '(11)', |
|
26 | + 'item_name' => Schema::TYPE_STRING.'(64) NOT NULL', |
|
27 | + 'user_id' => Schema::TYPE_INTEGER.'(11) NOT NULL', |
|
28 | + 'created_at' => Schema::TYPE_INTEGER.'(11)', |
|
29 | 29 | 'PRIMARY KEY ([[item_name]], [[user_id]])', |
30 | 30 | 'FOREIGN KEY ([[user_id]]) REFERENCES {{%user}} ([[id]]) ON DELETE CASCADE ON UPDATE CASCADE', |
31 | 31 | 'FOREIGN KEY ([[item_name]]) REFERENCES {{%auth_item}} ([[name]]) ON DELETE CASCADE ON UPDATE CASCADE', |
@@ -23,9 +23,9 @@ |
||
23 | 23 | |
24 | 24 | $this->createTable('{{%media_meta}}', [ |
25 | 25 | 'id' => Schema::TYPE_PK, |
26 | - 'media_id' => Schema::TYPE_INTEGER . '(11) NOT NULL', |
|
27 | - 'name' => Schema::TYPE_STRING . '(255) NOT NULL', |
|
28 | - 'value' => Schema::TYPE_TEXT . ' NOT NULL', |
|
26 | + 'media_id' => Schema::TYPE_INTEGER.'(11) NOT NULL', |
|
27 | + 'name' => Schema::TYPE_STRING.'(255) NOT NULL', |
|
28 | + 'value' => Schema::TYPE_TEXT.' NOT NULL', |
|
29 | 29 | 'FOREIGN KEY ([[media_id]]) REFERENCES {{%media}} ([[id]]) ON DELETE CASCADE ON UPDATE CASCADE', |
30 | 30 | ], $tableOptions); |
31 | 31 | } |